Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
10 lines (8 sloc) 356 Bytes
CREATE TABLE test_file (
id INTEGER PRIMARY KEY AUTOINCREMENT,
project INTEGER NOT NULL,
label TEXT DEFAULT '',
mute_until INTEGER,
CONSTRAINT 'fk_test_file_project' FOREIGN KEY ('project') REFERENCES 'project' ('id') ON DELETE CASCADE
);
CREATE INDEX i_test_file_project ON test_file (project);