From 2e9b18944eac3dcaf8a006594cb338d94c07a447 Mon Sep 17 00:00:00 2001 From: GrailFinder Date: Sat, 18 May 2024 13:27:28 +0300 Subject: Feat: auth; login; signup; migrate to sqlite --- internal/database/migrations/001_init.up.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'internal/database/migrations') diff --git a/internal/database/migrations/001_init.up.sql b/internal/database/migrations/001_init.up.sql index 80ebcad..f7e41c1 100644 --- a/internal/database/migrations/001_init.up.sql +++ b/internal/database/migrations/001_init.up.sql @@ -1,21 +1,22 @@ BEGIN; CREATE TABLE user_score ( - id INT GENERATED BY DEFAULT AS IDENTITY, + id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, - burn_time TIMESTAMP NOT NULL DEFAULT NOW() + interval '1 day', + password TEXT NOT NULL, + burn_time TIMESTAMP NOT NULL, score SMALLINT NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW() + created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE action ( - id INT GENERATED BY DEFAULT AS IDENTITY, + id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, magnitude SMALLINT NOT NULL DEFAULT 1, repeatable BOOLEAN NOT NULL DEFAULT FALSE, type TEXT NOT NULL, done BOOLEAN NOT NULL DEFAULT FALSE, username TEXT NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), + created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE(username, name), CONSTRAINT fk_user_score FOREIGN KEY(username) -- cgit v1.2.3