summaryrefslogtreecommitdiff
path: root/data/schema
diff options
context:
space:
mode:
Diffstat (limited to 'data/schema')
-rw-r--r--data/schema/6.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/data/schema/6.sql b/data/schema/6.sql
index 4ae7cb9..0c208ad 100644
--- a/data/schema/6.sql
+++ b/data/schema/6.sql
@@ -2,3 +2,14 @@ CREATE TABLE `sc_version` (
`schema_version` int(11) NOT NULL
) DEFAULT CHARSET=utf8;
INSERT INTO `sc_version` (`schema_version`) VALUES ('6');
+
+CREATE TABLE `sc_users_sslclientcerts` (
+ `id` INT NOT NULL AUTO_INCREMENT ,
+ `uId` INT NOT NULL ,
+ `sslSerial` VARCHAR( 32 ) NOT NULL ,
+ `sslClientIssuerDn` VARCHAR( 1024 ) NOT NULL ,
+ `sslName` VARCHAR( 64 ) NOT NULL ,
+ `sslEmail` VARCHAR( 64 ) NOT NULL ,
+ PRIMARY KEY ( `id` ) ,
+ UNIQUE (`id`)
+) CHARACTER SET utf8 COLLATE utf8_general_ci;