summaryrefslogtreecommitdiff
path: root/migrations/20240929013644_token_id.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20240929013644_token_id.sql')
-rw-r--r--migrations/20240929013644_token_id.sql29
1 files changed, 0 insertions, 29 deletions
diff --git a/migrations/20240929013644_token_id.sql b/migrations/20240929013644_token_id.sql
deleted file mode 100644
index ad4d8b4..0000000
--- a/migrations/20240929013644_token_id.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-alter table token
-rename to old_token;
-
-create table token (
- id text
- not null
- primary key,
- secret text
- not null
- unique,
- login text
- not null,
- issued_at text
- not null,
- last_used_at text
- not null,
- foreign key (login)
- references login (id)
-);
-
-insert into token
-select
- 'T' || lower(hex(randomblob(8))) as id,
- *
-from old_token;
-
-drop table old_token;
-
-create index token_issued_at on token (issued_at);