1CREATE TABLE structpublish_assignments_patterns ( 2 pattern TEXT NOT NULL, 3 user TEXT NOT NULL, 4 status TEXT NOT NULL, 5 PRIMARY KEY (pattern, user, status) 6); 7 8CREATE TABLE structpublish_assignments ( 9 pid TEXT NOT NULL, 10 user TEXT NOT NULL, 11 status TEXT NOT NULL, 12 assigned INTEGER, 13 PRIMARY KEY(pid, user, status) 14); 15