internal/database/migrations/002_defaults.up.sql


1
2
3
4
5
6
7
8
9
10
11

BEGIN TRANSACTION;

CREATE TABLE IF NOT EXISTS defaults (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    key TEXT UNIQUE NOT NULL,
    value TEXT NOT NULL,
    description TEXT NOT NULL DEFAULT '',
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

COMMIT;