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