CREATE TABLE test(i INTEGER, j TIMESTAMP TIME INDEX);

Affected Rows: 0

INSERT INTO test VALUES (1, 1), (2, 2);

Affected Rows: 2

ALTER TABLE test ADD COLUMN k INTEGER DEFAULT 3;

Affected Rows: 0

SELECT * FROM test;

+---+-------------------------+---+
| i | j                       | k |
+---+-------------------------+---+
| 1 | 1970-01-01T00:00:00.001 | 3 |
| 2 | 1970-01-01T00:00:00.002 | 3 |
+---+-------------------------+---+

DROP TABLE test;

Affected Rows: 0