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);