X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2FtableStructure.sql;fp=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2FtableStructure.sql;h=4b5194f77c1ac67d9f274dd324ee3531cf20fcf6;hp=57825338bdf2180fd67ec1d0a287f1c42b2e076f;hb=19dfeb8cc6ffa3f469e2b27fcedccc56b776c693;hpb=10e752c710c50035de036a79bc26fbedc7c8a460 diff --git a/src/club/wpia/gigi/database/tableStructure.sql b/src/club/wpia/gigi/database/tableStructure.sql index 57825338..4b5194f7 100644 --- a/src/club/wpia/gigi/database/tableStructure.sql +++ b/src/club/wpia/gigi/database/tableStructure.sql @@ -139,7 +139,7 @@ CREATE TABLE "user_agreements" ( DROP TABLE IF EXISTS "certs"; DROP TYPE IF EXISTS "mdType"; -CREATE TYPE "mdType" AS ENUM('md5','sha1','sha256','sha512'); +CREATE TYPE "mdType" AS ENUM('md5','sha1','sha256','sha384','sha512'); DROP TYPE IF EXISTS "csrType"; CREATE TYPE "csrType" AS ENUM ('CSR', 'SPKAC'); @@ -375,7 +375,7 @@ CREATE TABLE "schemeVersion" ( "version" smallint NOT NULL, PRIMARY KEY ("version") ); -INSERT INTO "schemeVersion" (version) VALUES(27); +INSERT INTO "schemeVersion" (version) VALUES(28); DROP TABLE IF EXISTS `passwordResetTickets`; CREATE TABLE `passwordResetTickets` (