X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fdatabase%2FtableStructure.sql;fp=src%2Forg%2Fcacert%2Fgigi%2Fdatabase%2FtableStructure.sql;h=467160cd1bfbfff0e7c5d4c0da419c9c2e1c238a;hp=0764954c06358c3ad45d662dc0233849967dbc33;hb=85b9c7cfd0426eca278b609b96dd6b17b0a5144f;hpb=dbb3046c3a3b833305535937f1c7e2653f2ca247 diff --git a/src/org/cacert/gigi/database/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql index 0764954c..467160cd 100644 --- a/src/org/cacert/gigi/database/tableStructure.sql +++ b/src/org/cacert/gigi/database/tableStructure.sql @@ -330,7 +330,7 @@ CREATE TABLE IF NOT EXISTS "arbitrations" ( DROP TABLE IF EXISTS "user_groups"; DROP TYPE IF EXISTS "userGroup"; -CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert', 'nucleus-assurer'); +CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert', 'nucleus-assurer', 'locate-agent'); CREATE TABLE IF NOT EXISTS "user_groups" ( "id" serial NOT NULL, @@ -377,7 +377,7 @@ CREATE TABLE "schemeVersion" ( "version" smallint NOT NULL, PRIMARY KEY ("version") ); -INSERT INTO "schemeVersion" (version) VALUES(18); +INSERT INTO "schemeVersion" (version) VALUES(19); DROP TABLE IF EXISTS `passwordResetTickets`; CREATE TABLE `passwordResetTickets` (