diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/.gitignore | 0 | ||||
| -rw-r--r-- | migrations/20240831024047_login.sql | 22 |
2 files changed, 22 insertions, 0 deletions
diff --git a/migrations/.gitignore b/migrations/.gitignore deleted file mode 100644 index e69de29..0000000 --- a/migrations/.gitignore +++ /dev/null diff --git a/migrations/20240831024047_login.sql b/migrations/20240831024047_login.sql new file mode 100644 index 0000000..758e9c7 --- /dev/null +++ b/migrations/20240831024047_login.sql @@ -0,0 +1,22 @@ +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) +); |