1CREATE TEMPORARY TABLE schemas_temp (
2    id TEXT,
3    tbl TEXT,
4    ts TEXT
5);
6
7INSERT INTO schemas_temp (id, tbl, ts) SELECT id, tbl, ts FROM schemas;
8
9DROP TABLE schemas;
10
11CREATE TABLE schemas (
12    id INTEGER PRIMARY KEY AUTOINCREMENT,
13    tbl,
14    ts,
15    user,
16    comment
17);
18
19INSERT INTO schemas (id, tbl, ts) SELECT id, tbl, ts FROM schemas_temp;
20
21DROP TABLE schemas_temp;
22