Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
editors
|
id
|
int(11) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
autocomplete
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
checkbox
|
tinyint(1) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
checkbox_group
|
set('One','Two','Three','Four','Five')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
color
|
varchar(7)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
combobox
|
enum('One','Two','Three','Four','Five')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
datetime
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
html
|
text
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
image
|
blob
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
masked
|
varchar(100)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
multi_level
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
multi_value
|
set('One','Two','Three','Four','Five')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
radio
|
enum('One','Two','Three','Four','Five')
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
range
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
spin
|
int(11)
|
|
|
|
|
NULL
|
NULL
|
|
editors
|
text
|
varchar(100)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
editors
|
time
|
time
|
|
|
|
|
NULL
|
NULL
|
|