sqlite create table with datetime

Jan 19, 20232 min read

	CREATE TABLE words(id INTEGER UNIQUE NOT NULL PRIMARY KEY, en TEXT, zh TEXT, mark INTEGER, deleted INTEGER, created_at  DEFAULT ( datetime( 'now', 'localtime' ) ) NOT NULL);