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