aboutsummaryrefslogtreecommitdiff
path: root/src/db/migrations/03-sign-in-token.sql
diff options
context:
space:
mode:
authorJoris2025-02-07 14:54:22 +0100
committerJoris2025-02-07 14:54:22 +0100
commit2c3855e80df3f3ca7acaf0fc919bca66d495230c (patch)
treec6eadaef567236063f8af762afad51ef3911c21c /src/db/migrations/03-sign-in-token.sql
parentbfe4aa78d882b9d95bd1f954371136f3aa5c38c9 (diff)
Move migration to migrations folder
Diffstat (limited to 'src/db/migrations/03-sign-in-token.sql')
-rw-r--r--src/db/migrations/03-sign-in-token.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/src/db/migrations/03-sign-in-token.sql b/src/db/migrations/03-sign-in-token.sql
new file mode 100644
index 0000000..a3d8a13
--- /dev/null
+++ b/src/db/migrations/03-sign-in-token.sql
@@ -0,0 +1,5 @@
+DROP TABLE sign_in;
+
+ALTER TABLE user ADD COLUMN "password" TEXT NOT NULL DEFAULT "password";
+
+ALTER TABLE user ADD COLUMN "sign_in_token" TEXT NULL;