79.sql (634B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS user_forum_thread_subscriptions ( 3 user_id INTEGER NOT NULL, 4 thread_id INTEGER NOT NULL, 5 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 PRIMARY KEY (user_id, thread_id), 7 CONSTRAINT user_forum_thread_subscriptions_user_id_fk 8 FOREIGN KEY (user_id) 9 REFERENCES users (id) 10 ON DELETE CASCADE 11 ON UPDATE CASCADE, 12 CONSTRAINT uuser_forum_thread_subscriptions_thread_id_fk 13 FOREIGN KEY (thread_id) 14 REFERENCES forum_threads (id) 15 ON DELETE CASCADE 16 ON UPDATE CASCADE); 17 18 -- +migrate Down