aboutsummaryrefslogtreecommitdiffstats
path: root/crates/server/db/server-pg-migrations/20240621110731_user-verified.sql
diff options
context:
space:
mode:
authorBenedikt Peetz <benedikt.peetz@b-peetz.de>2026-07-09 21:43:23 +0200
committerBenedikt Peetz <benedikt.peetz@b-peetz.de>2026-07-09 21:43:23 +0200
commit3223d93cb3c77ab02aa0a35f2a8314e447cee9a4 (patch)
tree3971a1f37f5fe3cadb747c5229a0d54e868e45e3 /crates/server/db/server-pg-migrations/20240621110731_user-verified.sql
parentfix(client/sync): Pass through precise error on `SyncError::WrongKey` (diff)
downloadatuin-3223d93cb3c77ab02aa0a35f2a8314e447cee9a4.zip
chore: Separate daemon, client, server, and lib into crates
Diffstat (limited to 'crates/server/db/server-pg-migrations/20240621110731_user-verified.sql')
-rw-r--r--crates/server/db/server-pg-migrations/20240621110731_user-verified.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/crates/server/db/server-pg-migrations/20240621110731_user-verified.sql b/crates/server/db/server-pg-migrations/20240621110731_user-verified.sql
new file mode 100644
index 00000000..6eba02ec
--- /dev/null
+++ b/crates/server/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
+);