upd: rename package name and all references to it

[gigi.git] / src / org / cacert / gigi / database / upgrade / from_9.sql

diff --git a/src/org/cacert/gigi/database/upgrade/from_9.sql b/src/org/cacert/gigi/database/upgrade/from_9.sql
deleted file mode 100644 (file)
index ec2b0be..0000000
--- a/src/org/cacert/gigi/database/upgrade/from_9.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-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";