Alternc
latest
Alternc logiel libre pour l'hébergement
ssl.sql
Go to the documentation of this file.
1
2
CREATE
TABLE
`certificates` (
3
`id`
int
(
10
) unsigned
NOT
NULL
AUTO_INCREMENT,
4
`uid`
int
(
10
) unsigned
NOT
NULL
,
5
`status` tinyint(
3
) unsigned
NOT
NULL
,
6
`shared` tinyint(
3
) unsigned
NOT
NULL
,
7
`fqdn`
varchar
(
255
)
NOT
NULL
,
8
`altnames` text
NOT
NULL
,
9
`validstart` datetime
NOT
NULL
,
10
`validend` datetime
NOT
NULL
,
11
`sslcsr` text
NOT
NULL
,
12
`sslkey` text
NOT
NULL
,
13
`sslcrt` text
NOT
NULL
,
14
`sslchain` text
NOT
NULL
,
15
`ssl_action`
varchar
(
32
)
NOT
NULL
,
16
`ssl_result`
varchar
(
32
)
NOT
NULL
,
17
PRIMARY
KEY (`id`),
18
KEY `uid` (`uid`),
19
KEY `ssl_action` (`ssl_action`)
20
) ENGINE=InnoDB
DEFAULT
CHARSET=utf8;
21
22
CREATE
TABLE
IF
NOT
EXISTS
`certif_alias` (
23
`name`
varchar
(
255
)
NOT
NULL
,
24
`content` text
NOT
NULL
,
25
`uid`
int
(
10
) unsigned
NOT
NULL
,
26
`created`
timestamp
NOT
NULL
DEFAULT
CURRENT_TIMESTAMP
,
27
PRIMARY
KEY (`name`),
28
KEY `uid` (`uid`)
29
) ENGINE=InnoDB
DEFAULT
CHARSET=utf8 COMMENT=
'Global aliases defined for SSL certificates FILE validation processes'
;
30
31
CREATE
TABLE
IF
NOT
EXISTS
`certif_hosts` (
32
`certif`
int
(
10
) unsigned
NOT
NULL
,
33
`sub`
int
(
10
) unsigned
NOT
NULL
,
34
`uid`
int
(
10
) unsigned
NOT
NULL
,
35
PRIMARY
KEY (`certif`,`sub`),
36
KEY `uid` (`uid`)
37
) ENGINE=InnoDB
DEFAULT
CHARSET=utf8 COMMENT=
'VHosts of a user using defined or self-signed certificates'
;
38
39
INSERT
IGNORE
INTO
defquotas
VALUES
(
'ssl'
,
0
,
'default'
);
ssl
ssl.sql
Generated on Thu Jun 21 2018 12:00:09 for Alternc by
1.8.13