From 523e29fd1b8f8aab0ce4291a1dab317781780847 Mon Sep 17 00:00:00 2001
From: Michael Neves
Date: Mon, 27 Feb 2012 13:18:46 +0100
Subject: yend auth used for authentication after certificate check

---
 setup/pbs.sql  |  2 +-
 setup/pbs.sql~ | 18 ++++++++++++++++++
 2 files changed, 19 insertions(+), 1 deletion(-)

(limited to 'setup')

diff --git a/setup/pbs.sql b/setup/pbs.sql
index 0c1a63a..4c68ea6 100644
--- a/setup/pbs.sql
+++ b/setup/pbs.sql
@@ -379,7 +379,7 @@ 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` (
+CREATE TABLE IF NOT EXISTS `pbs_certificate` (
   `certificateID` int(11) NOT NULL AUTO_INCREMENT,
   `personID` int(11),
   `serial` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
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'),
-- 
cgit v1.2.3-55-g7522