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 | | | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
0 | NameMime | 2 | MimeTypeNo | A | 2 | | | | BTREE | |
InformationEngine | 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