X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fdatabase%2FtableStructure.sql;h=9bd231e8c5f2efd7451beb730b85f9da5de8347c;hp=883adf769870fbf1d30085454c5b3ea25e0d3d02;hb=6fdaa05e2fc9f65211d3c8c5bda894b3c1906d2c;hpb=761d3fda9c34d37d302199bbe1b23c34739d555e diff --git a/src/org/cacert/gigi/database/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql index 883adf76..9bd231e8 100644 --- a/src/org/cacert/gigi/database/tableStructure.sql +++ b/src/org/cacert/gigi/database/tableStructure.sql @@ -261,17 +261,17 @@ CREATE TABLE "notary" ( "points" int NOT NULL DEFAULT '0', # awarded and the "experience points" are calculated virtually # Face to Face is default, TOPUP is for the remaining 30Points after two TTP -# TTP is default ttp assurance +# TTP is default ttp verification "method" "notaryType" NOT NULL DEFAULT 'Face to Face Meeting', "location" varchar(255) NOT NULL DEFAULT '', "date" varchar(255) NOT NULL DEFAULT '', -# date when assurance was entered +# date when verification was entered "when" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, #? "expire" timestamp NULL DEFAULT NULL, #????????????????? "sponsor" int NOT NULL DEFAULT '0', -# date when assurance was deleted (or 0) +# date when verification was deleted (or 0) "deleted" timestamp NULL DEFAULT NULL, PRIMARY KEY ("id") );