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