X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=doc%2FtableStructure.sql;h=7ff0769c2e336a966b5769d6da5a8791f8e4d839;hb=346185795ad8dd3dbfeb417d2dccb69a39af64be;hp=7ff5a6159f1c3a1b39987a351bba87857a593552;hpb=382afd1be086aa9f9a52e2be30164f7a4b3e8f40;p=gigi.git

diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql
index 7ff5a615..7ff0769c 100644
--- a/doc/tableStructure.sql
+++ b/doc/tableStructure.sql
@@ -40,6 +40,7 @@ CREATE TABLE IF NOT EXISTS `organisations` (
   `state` varchar(2) NOT NULL,
   `province` varchar(100) NOT NULL,
   `city` varchar(100) NOT NULL,
+  `contactEmail` varchar(100) NOT NULL,
   `creator` int(11) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -143,6 +144,7 @@ CREATE TABLE `certs` (
   `codesign` tinyint(1) NOT NULL DEFAULT '0',
   `md` enum('md5','sha1','sha256','sha512') NOT NULL DEFAULT 'sha512',
   `profile` int(3) NOT NULL,
+  `caid` int(3) NULL DEFAULT NULL,
 
   `csr_name` varchar(255) NOT NULL DEFAULT '',
   `csr_type` enum('CSR', 'SPKAC') NOT NULL,
@@ -221,7 +223,16 @@ CREATE TABLE `subjectAlternativeNames` (
   `type` enum('email','DNS') NOT NULL
 ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
 
-
+DROP TABLE IF EXISTS `cacerts`;
+CREATE TABLE `cacerts` (
+  `id` int(3) NOT NULL AUTO_INCREMENT,
+  `keyname` varchar(60) NOT NULL,
+  `subroot` int(2) NOT NULL,
+  `validFrom` datetime NULL DEFAULT NULL,
+  `validTo` datetime NULL DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE (`keyname`)
+) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
 
 
 DROP TABLE IF EXISTS `jobs`;
@@ -330,4 +341,4 @@ CREATE TABLE `adminLog` (
   `type` varchar(100) NOT NULL DEFAULT '',
   `information` varchar(50) NOT NULL DEFAULT '',
   PRIMARY KEY (`when`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\ No newline at end of file
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;