CREATE TABLE test(i INTEGER, j TIMESTAMP TIME INDEX); INSERT INTO test VALUES (1, 1), (2, 2); ALTER TABLE test ADD COLUMN k INTEGER DEFAULT 3; SELECT * FROM test; DROP TABLE test;