From b422be184e01b4cc35b9c9a6921379080c24edb3 Mon Sep 17 00:00:00 2001 From: Owen Jacobson Date: Fri, 4 Oct 2024 22:12:15 -0400 Subject: 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. --- migrations/20240831024047_login.sql | 22 ---------------------- 1 file changed, 22 deletions(-) delete mode 100644 migrations/20240831024047_login.sql (limited to 'migrations/20240831024047_login.sql') 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) -); -- cgit v1.2.3