X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;ds=sidebyside;f=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_2.sql;fp=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_2.sql;h=c36fbd496f956e8411323cfb0008c05e3191efe2;hb=bccd4cc0dba0f89aa045b113bac46eb8cc1dab4e;hp=0000000000000000000000000000000000000000;hpb=c9ed09f0007fc2c813815be927a5a24b23dab83c;p=gigi.git

diff --git a/src/club/wpia/gigi/database/upgrade/from_2.sql b/src/club/wpia/gigi/database/upgrade/from_2.sql
new file mode 100644
index 00000000..c36fbd49
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_2.sql
@@ -0,0 +1,11 @@
+DROP TABLE IF EXISTS `cacerts`;
+CREATE TABLE `cacerts` (
+  `id` int(3) NOT NULL AUTO_INCREMENT,
+  `keyname` varchar(60) NOT NULL,
+  `link` varchar(160) NOT NULL,
+  `parentRoot` int(3) NOT NULL,
+  `validFrom` datetime NULL DEFAULT NULL,
+  `validTo` datetime NULL DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE (`keyname`)
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;