X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_37.sql;fp=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_37.sql;h=1ac2a4e34fe126e08bd571eb0c505cece765d188;hp=0000000000000000000000000000000000000000;hb=46eea3386b6003bd243061cb215196f0f9240c90;hpb=ae39029198c046f75f6b0efea270970d6308fb5c

diff --git a/src/club/wpia/gigi/database/upgrade/from_37.sql b/src/club/wpia/gigi/database/upgrade/from_37.sql
new file mode 100644
index 00000000..1ac2a4e3
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_37.sql
@@ -0,0 +1,18 @@
+DROP TABLE IF EXISTS "user_contracts";
+DROP TYPE IF EXISTS "contractType";
+CREATE TYPE "contractType" AS ENUM ('RA Agent Contract', 'Org RA Agent Contract');
+
+CREATE TABLE "user_contracts" (
+  "id" serial NOT NULL,
+  "token" varchar(32) NOT NULL,
+  "memid" int NOT NULL,
+  "document" "contractType" NOT NULL,
+  "agentname" varchar(255) NOT NULL,
+  "datesigned" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  "daterevoked" timestamp DEFAULT NULL,
+  PRIMARY KEY ("id")
+);
+CREATE INDEX ON "user_contracts" ("memid");
+CREATE INDEX ON "user_contracts" ("document");
+CREATE INDEX ON "user_contracts" ("datesigned");
+CREATE INDEX ON "user_contracts" ("daterevoked");