UPD: Removed primary key in adminLog table

[gigi.git] / src / org / cacert / gigi / database / tableStructure.sql

diff --git a/src/org/cacert/gigi/database/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql
index e72c2701734fbc6228b7599db7c62bc0bfc0a864..85f9d779218c7b8582072e259f257ebcff21c3a7 100644 (file)
--- 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);