Table: nornix_site.layout
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | smallint(6) | NO | PRI | | auto_increment | |
|---|
| Name | varchar(16) | NO | MUL | | | |
|---|
| Script | text | NO | | | | |
|---|
| MimeTypeNo | int(10) unsigned | NO | | 0 | | |
|---|
| Blocks | varchar(255) | NO | | | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | NameMime | 2 | MimeTypeNo | A | 2 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `layout` (
`No` smallint(6) NOT NULL auto_increment,
`Name` varchar(16) NOT NULL,
`Script` text NOT NULL,
`MimeTypeNo` int(10) unsigned NOT NULL default '',
`Blocks` varchar(255) NOT NULL default '',
PRIMARY KEY (`No`),
UNIQUE KEY `NameMime` (`Name`,`MimeTypeNo`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8