1 DROP TABLE IF EXISTS `cacerts`;
2 CREATE TABLE `cacerts` (
3 `id` int(3) NOT NULL AUTO_INCREMENT,
4 `keyname` varchar(60) NOT NULL,
5 `link` varchar(160) NOT NULL,
6 `parentRoot` int(3) NOT NULL,
7 `validFrom` datetime NULL DEFAULT NULL,
8 `validTo` datetime NULL DEFAULT NULL,
11 ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;