1CREATE TABLE assignments_patterns ( 2 id INTEGER PRIMARY KEY, 3 pattern NOT NULL, 4 page NOT NULL, 5 pos NOT NULL 6); 7 8CREATE TABLE assignments ( 9 pid NOT NULL, 10 pattern_id INTEGER NOT NULL, 11 assigned BOOLEAN NOT NULL DEFAULT 1, 12 PRIMARY KEY(pid, pattern_id) 13);