Enha: users table

1 files changed, 1 insertions, 18 deletions

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;