Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
id | INT UNSIGNED | 10 | √ | null |
|
|
||
dom_id | INT UNSIGNED | 10 | null |
|
|
|||
name | VARCHAR | 255 | null |
|
|
|||
displayName | VARCHAR | 255 | null |
|
|
|||
www_root | TEXT | 65535 | null |
|
|
|||
sys_user_id | INT UNSIGNED | 10 | null |
|
|
|||
ssi | enum('false', 'true') | 6 | false |
|
|
|||
php | enum('false', 'true') | 6 | false |
|
|
|||
cgi | enum('false', 'true') | 6 | false |
|
|
|||
perl | enum('false', 'true') | 6 | false |
|
|
|||
python | enum('false', 'true') | 6 | false |
|
|
|||
fastcgi | enum('false', 'true') | 6 | false |
|
|
|||
miva | enum('false', 'true') | 6 | false |
|
|
|||
coldfusion | enum('false', 'true') | 6 | false |
|
|
|||
asp | enum('false', 'true') | 6 | false |
|
|
|||
asp_dot_net | enum('false', 'true') | 6 | false |
|
|
|||
ssl | enum('false', 'true') | 6 | false |
|
|
|||
same_ssl | enum('false', 'true') | 6 | true |
|
|
|||
php_handler_type | enum('cgi', 'fastcgi', 'module', 'isapi') | 7 | module |
|
|
|||
maintenance_mode | enum('false', 'true') | 6 | false |
|
|
|||
certificate_id | INT UNSIGNED | 10 | √ | 0 |
|
|
Table contained 0 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
dom_id | Must be unique | Asc/Asc | dom_id + name |
dom_id_displayName | Performance | Asc/Asc | dom_id + displayName |
sys_user_id | Performance | Asc | sys_user_id |