1CREATE TEMPORARY TABLE schemas_temp ( 2 id INTEGER, 3 tbl, 4 ts, 5 islookup INTEGER, 6 user, 7 comment, 8 editors 9); 10 11INSERT INTO schemas_temp (id, tbl, ts, islookup, user, comment, editors) SELECT id, tbl, ts, islookup, user, comment, editors FROM schemas; 12 13DROP TABLE schemas; 14 15CREATE TABLE schemas ( 16 id INTEGER PRIMARY KEY AUTOINCREMENT, 17 tbl, 18 ts, 19 islookup INTEGER, 20 user, 21 comment, 22 config NOT NULL DEFAULT '{}' 23); 24 25INSERT INTO schemas (id, tbl, ts, islookup, user, comment, config) SELECT id, tbl, ts, islookup, user, comment, '{"allowed editors":"' || editors || '"}' FROM schemas_temp; 26 27DROP TABLE schemas_temp; 28