1 files changed, 3 insertions, 3 deletions
diff --git a/internal/database/migrations/001_init.up.sql b/internal/database/migrations/001_init.up.sql
index 7edbd96..80ebcad 100644
--- a/internal/database/migrations/001_init.up.sql
+++ b/internal/database/migrations/001_init.up.sql
@@ -4,18 +4,18 @@ CREATE TABLE user_score (
     username TEXT UNIQUE NOT NULL,
     burn_time TIMESTAMP NOT NULL DEFAULT NOW() + interval '1 day',
     score SMALLINT NOT NULL,
-    created_at timestamp NOT NULL DEFAULT NOW()
+    created_at TIMESTAMP NOT NULL DEFAULT NOW()
 );
 
 CREATE TABLE action (
     id INT GENERATED BY DEFAULT AS IDENTITY,
     name TEXT NOT NULL,
-    magnitude SMALLSERIAL NOT NULL DEFAULT 1,
+    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 NOW(),
     UNIQUE(username, name),
     CONSTRAINT fk_user_score
       FOREIGN KEY(username)