aboutsummaryrefslogtreecommitdiffstats
path: root/crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql
diff options
context:
space:
mode:
authorBenedikt Peetz <benedikt.peetz@b-peetz.de>2026-06-11 01:05:07 +0200
committerBenedikt Peetz <benedikt.peetz@b-peetz.de>2026-06-11 01:05:07 +0200
commit7a9e229d5f4913d1a48c92615bcb3234f5dcfd33 (patch)
tree21eacdafe35d4e36918dcac39688678f87ea4b0c /crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql
parentchore: Move everything into one big crate (diff)
downloadatuin-7a9e229d5f4913d1a48c92615bcb3234f5dcfd33.zip
chore: Restore db migrations
Diffstat (limited to 'crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql')
-rw-r--r--crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql b/crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql
new file mode 100644
index 00000000..6eba02ec
--- /dev/null
+++ b/crates/turtle/db/server-pg-migrations/20240621110731_user-verified.sql
@@ -0,0 +1,8 @@
+alter table users add verified_at timestamp with time zone default null;
+
+create table user_verification_token(
+ id bigserial primary key,
+ user_id bigint unique references users(id),
+ token text,
+ valid_until timestamp with time zone
+);