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

diff --git a/src/club/wpia/gigi/database/upgrade/from_9.sql b/src/club/wpia/gigi/database/upgrade/from_9.sql
new file mode 100644
index 00000000..ec2b0be2
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_9.sql
@@ -0,0 +1,5 @@
+ALTER TABLE "emailPinglog" ADD COLUMN "challenge" varchar(255) NULL DEFAULT NULL;
+
+INSERT INTO "emailPinglog" SELECT CURRENT_TIMESTAMP AS "when", "memid" AS "uid", "email", 'active'::"emailPingType" AS "type", CASE WHEN "hash"='' THEN 'success'::"pingState" ELSE 'open'::"pingState" END AS state, '' AS result, "hash" AS "challenge" FROM "emails";
+ALTER TABLE "emails" DROP COLUMN "attempts";
+ALTER TABLE "emails" DROP COLUMN "hash";