crystal-gauntlet/db/migrations/13_quests.sql

8 lines
228 B
SQL

-- +migrate up
CREATE TABLE quest_timer (
account_id INTEGER NOT NULL references accounts(id),
next_at TEXT NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'now'))
);
-- +migrate down
DROP TABLE quest_timer;