Table: nornix_root.rootsetting
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Class | varchar(32) | NO | PRI | | | |
|---|
| Attribute | varchar(48) | NO | PRI | | | |
|---|
| Value | varchar(255) | NO | | | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | ClassAttr | 2 | Attribute | A | 25 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Fixed | utf8_general_ci | row_format=FIXED |
CREATE TABLE `rootsetting` (
`Class` varchar(32) NOT NULL,
`Attribute` varchar(48) NOT NULL,
`Value` varchar(255) NOT NULL,
UNIQUE KEY `ClassAttr` (`Class`,`Attribute`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED