1
2CREATE TABLE assignments_temp
3(
4    page     TEXT NOT NULL REFERENCES pages (page) ON DELETE CASCADE PRIMARY KEY,
5    pageassignees TEXT NOT NULL DEFAULT '',
6    autoassignees TEXT NOT NULL DEFAULT ''
7);
8
9INSERT INTO assignments_temp (page, pageassignees) SELECT page, assignee FROM assignments;
10
11DROP TABLE assignments;
12ALTER TABLE assignments_temp RENAME TO assignments;
13
14CREATE TABLE assignments_patterns (
15    pattern TEXT NOT NULL PRIMARY KEY ,
16    assignees TEXT NOT NULL
17);
18