ADD: scheme versioning, last time "Please execute database manager" ;-)

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

diff --git a/doc/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql
similarity index 98%
rename from doc/tableStructure.sql
rename to src/org/cacert/gigi/database/tableStructure.sql
index 867a1c63704dc3bd70582d3a397c1a8f9fbc2373..e72c2701734fbc6228b7599db7c62bc0bfc0a864 100644 (file)
--- a/doc/tableStructure.sql
+++ b/src/org/cacert/gigi/database/tableStructure.sql
@@ -341,3 +341,10 @@ CREATE TABLE `adminLog` (
   `information` varchar(50) NOT NULL DEFAULT '',
   PRIMARY KEY (`when`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `schemeVersion`;
+CREATE TABLE `schemeVersion` (
+  `version` int(5) NOT NULL,
+  PRIMARY KEY (`version`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+INSERT INTO schemeVersion(version)  VALUES(1);