X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=doc%2FtableStructure.sql;h=5c79a162f7c7fe993f2a391e7acc656e6fa04ca0;hb=42bbd6583455d10e2f500e5d6a8560a8a8e9152e;hp=55fdfdfc8cfd280803a549b7fe170cec27aad40a;hpb=fa1ae652fbff9c7caeded3fc89680703d1da381b;p=gigi.git diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql index 55fdfdfc..5c79a162 100644 --- a/doc/tableStructure.sql +++ b/doc/tableStructure.sql @@ -139,8 +139,6 @@ CREATE TABLE `certs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `memid` int(11) NOT NULL DEFAULT '0', `serial` varchar(50) NOT NULL DEFAULT '', - `CN` varchar(255) NOT NULL DEFAULT '', - `subject` varchar(1024) NOT NULL, `keytype` char(2) NOT NULL DEFAULT 'NS', `codesign` tinyint(1) NOT NULL DEFAULT '0', `md` enum('md5','sha1','sha256','sha512') NOT NULL DEFAULT 'sha512', @@ -168,6 +166,16 @@ CREATE TABLE `certs` ( KEY `emailcrt` (`crt_name`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; + +DROP TABLE IF EXISTS `certAvas`; +CREATE TABLE `certAvas` ( + `certid` int(11) NOT NULL, + `name` varchar(20) NOT NULL, + `value` varchar(255) NOT NULL, + + PRIMARY KEY (`certid`, `name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + DROP TABLE IF EXISTS `clientcerts`; CREATE TABLE `clientcerts` ( `id` int(11) NOT NULL, @@ -294,7 +302,7 @@ DROP TABLE IF EXISTS `user_groups`; CREATE TABLE IF NOT EXISTS `user_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL, - `permission` enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning') NOT NULL, + `permission` enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer') NOT NULL, `granted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleted` timestamp NULL DEFAULT NULL, `grantedby` int(11) NOT NULL, @@ -306,9 +314,10 @@ DROP TABLE IF EXISTS `org_admin`; CREATE TABLE IF NOT EXISTS `org_admin` ( `orgid` int(11) NOT NULL, `memid` int(11) NOT NULL, + `master` enum('y', 'n') NOT NULL, `creator` int(11) NOT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleter` int(11) NULL DEFAULT NULL, `deleted` timestamp NULL DEFAULT NULL, - PRIMARY KEY (`orgid`, `memid`) + KEY (`orgid`, `memid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;