111.sql (790B)
1 -- +migrate Up 2 ALTER TABLE users ADD COLUMN general_messages_count INTEGER NOT NULL DEFAULT 0; 3 4 CREATE TABLE IF NOT EXISTS karma_history ( 5 id INTEGER NOT NULL PRIMARY KEY, 6 user_id INTEGER NOT NULL, 7 from_user_id INTEGER NULL, 8 karma INTEGER NOT NULL, 9 description VARCHAR(255) NOT NULL, 10 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 11 CONSTRAINT karma_history_user_id_fk 12 FOREIGN KEY (user_id) 13 REFERENCES users (id) 14 ON DELETE CASCADE 15 ON UPDATE CASCADE, 16 CONSTRAINT karma_history_from_user_id_fk 17 FOREIGN KEY (from_user_id) 18 REFERENCES users (id) 19 ON DELETE CASCADE 20 ON UPDATE CASCADE); 21 CREATE INDEX karma_history_user_id_idx ON karma_history (user_id); 22 23 -- +migrate Down