SQLite 3 · Everyday SQL
Create a table
Create a table with an auto-assigned integer key and a default timestamp.
CREATE TABLE users (
id INTEGER PRIMARY KEY,
email TEXT NOT NULL UNIQUE,
created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
);
Official SQLite 3 documentation