From 55ed7d6bb605680a21e406a4084edb5df9f5eaec Mon Sep 17 00:00:00 2001 From: Grail Finder Date: Sat, 5 Apr 2025 12:40:13 +0300 Subject: Enha: users table --- internal/database/migrations/001_init.up.sql | 19 +------------------ 1 file changed, 1 insertion(+), 18 deletions(-) (limited to 'internal') diff --git a/internal/database/migrations/001_init.up.sql b/internal/database/migrations/001_init.up.sql index 141a045..e3b052d 100644 --- a/internal/database/migrations/001_init.up.sql +++ b/internal/database/migrations/001_init.up.sql @@ -1,25 +1,8 @@ BEGIN TRANSACTION; -CREATE TABLE IF NOT EXISTS user_score ( +CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, password TEXT NOT NULL, - burn_time TIMESTAMP NOT NULL, - score SMALLINT NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); - -CREATE TABLE IF NOT EXISTS action( - 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 CURRENT_TIMESTAMP, - UNIQUE(username, name), - CONSTRAINT fk_user_score - FOREIGN KEY(username) - REFERENCES user_score(username) -); COMMIT; -- cgit v1.2.3