94.sql (537B)
1 -- +migrate Up 2 CREATE TABLE IF NOT EXISTS user_private_notes( 3 id INTEGER NOT NULL PRIMARY KEY, 4 user_id INTEGER NOT NULL, 5 notes BLOB NOT NULL, 6 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 7 updated_at DATETIME NULL DEFAULT CURRENT_TIMESTAMP, 8 CONSTRAINT user_private_notes_user_id_fk 9 FOREIGN KEY (user_id) 10 REFERENCES users (id) 11 ON DELETE CASCADE 12 ON UPDATE CASCADE); 13 14 CREATE INDEX user_private_notes_user_id_idx ON user_private_notes (user_id); 15 16 -- +migrate Down