X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_5.sql;fp=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_5.sql;h=6f9d8f7b65116e3fad428953851ef9c6628cc0e5;hp=0000000000000000000000000000000000000000;hb=bccd4cc0dba0f89aa045b113bac46eb8cc1dab4e;hpb=c9ed09f0007fc2c813815be927a5a24b23dab83c

diff --git a/src/club/wpia/gigi/database/upgrade/from_5.sql b/src/club/wpia/gigi/database/upgrade/from_5.sql
new file mode 100644
index 00000000..6f9d8f7b
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_5.sql
@@ -0,0 +1,11 @@
+DROP TABLE IF EXISTS `passwordResetTickets`;
+CREATE TABLE `passwordResetTickets` (
+  `id` serial NOT NULL,
+  `memid` int NOT NULL,
+  `creator` int NOT NULL,
+  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `used` timestamp NULL DEFAULT NULL,
+  `token` varchar(32) NOT NULL,
+  `private_token` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+);