72.sql (637B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS pm_whitelisted_users ( 3 user_id INTEGER NOT NULL, 4 whitelisted_user_id INTEGER NOT NULL, 5 PRIMARY KEY (user_id, whitelisted_user_id) 6 CONSTRAINT pm_whitelisted_users_user_id_fk 7 FOREIGN KEY (user_id) 8 REFERENCES users (id) 9 ON DELETE CASCADE 10 ON UPDATE CASCADE, 11 CONSTRAINT pm_whitelisted_users_whitelisted_user_id_fk 12 FOREIGN KEY (whitelisted_user_id) 13 REFERENCES users (id) 14 ON DELETE CASCADE 15 ON UPDATE CASCADE); 16 17 ALTER TABLE users ADD COLUMN pm_mode INTEGER NOT NULL DEFAULT 0; 18 19 -- +migrate Down