X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;ds=sidebyside;f=src%2Forg%2Fcacert%2Fgigi%2Fdatabase%2FtableStructure.sql;h=85f9d779218c7b8582072e259f257ebcff21c3a7;hb=b963961a09db63b2c0bf22ae3d44abd3911fd1f5;hp=e72c2701734fbc6228b7599db7c62bc0bfc0a864;hpb=53a66914a544d38be7e626aec2e74542745d4fda;p=gigi.git diff --git a/src/org/cacert/gigi/database/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql index e72c2701..85f9d779 100644 --- a/src/org/cacert/gigi/database/tableStructure.sql +++ b/src/org/cacert/gigi/database/tableStructure.sql @@ -339,7 +339,7 @@ CREATE TABLE `adminLog` ( `admin` int(11) unsigned NOT NULL, `type` varchar(100) NOT NULL DEFAULT '', `information` varchar(50) NOT NULL DEFAULT '', - PRIMARY KEY (`when`) + KEY (`when`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `schemeVersion`; @@ -347,4 +347,4 @@ CREATE TABLE `schemeVersion` ( `version` int(5) NOT NULL, PRIMARY KEY (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -INSERT INTO schemeVersion(version) VALUES(1); +INSERT INTO schemeVersion(version) VALUES(2);