diff options
Diffstat (limited to 'data/schema/6.sql')
| -rw-r--r-- | data/schema/6.sql | 11 |
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; |