Halfway done with email, not fully working yet.

2 files changed, 7 insertions, 0 deletions

diff --git a/server/migrations/2019-10-24-002614_create_password_reset_request/down.sql b/server/migrations/2019-10-24-002614_create_password_reset_request/down.sql
new file mode 100644
index 00000000..33500dfe
--- /dev/null
+++ b/server/migrations/2019-10-24-002614_create_password_reset_request/down.sql
@@ -0,0 +1 @@
+drop table password_reset_request;
diff --git a/server/migrations/2019-10-24-002614_create_password_reset_request/up.sql b/server/migrations/2019-10-24-002614_create_password_reset_request/up.sql
new file mode 100644
index 00000000..15cfaa59
--- /dev/null
+++ b/server/migrations/2019-10-24-002614_create_password_reset_request/up.sql
@@ -0,0 +1,6 @@
+create table password_reset_request (
+  id serial primary key,
+  user_id int references user_ on update cascade on delete cascade not null,
+  token_encrypted text not null,
+  published timestamp not null default now()
+);