diff options
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index 296356d..0c1a63a 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -378,6 +378,24 @@ CREATE TABLE IF NOT EXISTS `pbs_passwordrecovery` ( ALTER TABLE `pbs_passwordrecovery` ADD CONSTRAINT `pbs_passwordrecovery_ibfk_1` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE; + +CREATE TABLE IF NOT EXISTS `pbs_certificates` ( + `certificateID` int(11) NOT NULL AUTO_INCREMENT, + `personID` int(11), + `serial` varchar(32) COLLATE utf8_unicode_ci NOT NULL, + `issuedate` varchar(14) COLLATE utf8_unicode_ci NOT NULL, + `expiredate` varchar(14) COLLATE utf8_unicode_ci NOT NULL, + `issuerdn` varchar(1024) COLLATE utf8_unicode_ci NOT NULL, + `guestcert` tinyint(1) NOT NULL, + `revoked` tinyint(1) NOT NULL, + PRIMARY KEY (`certificateID`), + KEY `personID` (`personID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; + +ALTER TABLE `pbs_certificates` + ADD CONSTRAINT `pbs_certificates_ibfk_1` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`); + + -- Insert Filtertypes INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (1, 'IP'), |