summaryrefslogtreecommitdiff
path: root/migrations/20240831024047_login.sql
diff options
context:
space:
mode:
authorOwen Jacobson <owen@grimoire.ca>2024-10-04 22:12:15 -0400
committerOwen Jacobson <owen@grimoire.ca>2024-10-04 22:38:25 -0400
commitb422be184e01b4cc35b9c9a6921379080c24edb3 (patch)
treeb35bec7a4025e9874ba2683e3b9b8da4447c2fb0 /migrations/20240831024047_login.sql
parent9bd6d9862b1c243def02200bca2cfbf578ad2a2f (diff)
Start fresh with database migrations.
The migration path from the original project inception to now was complicated and buggy, and stranded _both_ Kit and I with broken databases due to oversights and incomplete migrations. We've agreed to start fresh, once. If this is mistakenly started with an original-schema-flavour DB, startup will be aborted.
Diffstat (limited to 'migrations/20240831024047_login.sql')
-rw-r--r--migrations/20240831024047_login.sql22
1 files changed, 0 insertions, 22 deletions
diff --git a/migrations/20240831024047_login.sql b/migrations/20240831024047_login.sql
deleted file mode 100644
index 758e9c7..0000000
--- a/migrations/20240831024047_login.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-create table login (
- id text
- not null
- primary key,
- name text
- not null
- unique,
- password_hash text
- not null
-);
-
-create table token (
- secret text
- not null
- primary key,
- login text
- not null,
- issued_at text
- not null,
- foreign key (login)
- references login (id)
-);