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
+);