1CREATE TABLE maintainerTemp ( 2 id INTEGER PRIMARY KEY, 3 namespace TEXT NOT NULL, 4 approver TEXT NULL 5); 6 7INSERT INTO maintainerTemp(id,namespace,approver) SELECT id,namespace,maintainer FROM maintainer; 8DROP TABLE maintainer; 9ALTER TABLE maintainerTemp RENAME TO maintainer; 10 11CREATE TABLE pageTemp ( 12 page TEXT PRIMARY KEY, 13 approver TEXT NULL, 14 hidden BOOLEAN NOT NULL DEFAULT 0 15); 16 17INSERT INTO pageTemp(page,approver,hidden) SELECT page,maintainer,hidden FROM page; 18DROP TABLE page; 19ALTER TABLE pageTemp RENAME TO page; 20