CREATE TABLE `cacerts` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`keyname` varchar(60) NOT NULL,
- `subroot` int(2) NOT NULL,
+ `parentRoot` int(3) NOT NULL,
`validFrom` datetime NULL DEFAULT NULL,
`validTo` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`),
`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`;
`version` int(5) NOT NULL,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-INSERT INTO schemeVersion(version) VALUES(1);
+INSERT INTO schemeVersion(version) VALUES(3);