summaryrefslogtreecommitdiff
path: root/internal/server/api/migrations/20250109134844_users.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-01-09 19:14:05 +0200
committerKyren223 <Kyren223@proton.me>2025-01-09 19:14:05 +0200
commitb09a8fba647ff030b24d9ad12215ba330c13080c (patch)
treed2be54859c70a6760edb75e26ee44299b17f50dc /internal/server/api/migrations/20250109134844_users.sql
parent936d3cf690ace9adfdfe0fb44193c11a0cb26d95 (diff)
Fixed everything on the server-side
Diffstat (limited to 'internal/server/api/migrations/20250109134844_users.sql')
-rw-r--r--internal/server/api/migrations/20250109134844_users.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/server/api/migrations/20250109134844_users.sql b/internal/server/api/migrations/20250109134844_users.sql
index 8ebb9eb..c22cc19 100644
--- a/internal/server/api/migrations/20250109134844_users.sql
+++ b/internal/server/api/migrations/20250109134844_users.sql
@@ -8,5 +8,11 @@ CREATE TABLE IF NOT EXISTS users (
is_deleted BOOLEAN NOT NULL CHECK (is_deleted IN (false, true)) DEFAULT false
);
+CREATE TABLE IF NOT EXISTS user_data (
+ user_id INTEGER PRIMARY KEY REFERENCES users(id),
+ data TEXT NOT NULL
+);
+
-- +goose Down
DROP TABLE IF EXISTS users;
+DROP TABLE IF EXISTS user_data;