added certificate DB

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'),