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