Table: nornix_site.block
Structure Comment test on tableName | Type | Null | Key | Default | Extra | Comment |
---|
No | smallint(6) | NO | PRI | | auto_increment | Comment test on field |
---|
Name | varchar(16) | NO | UNI | | | |
---|
ContentTypeNo | int(10) unsigned | NO | | 0 | | |
---|
Data | blob | NO | | | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
0 | Name | 1 | Name | A | 3 | | | | BTREE | |
InformationEngine | Row format | Table collation | Create options |
---|
MyISAM | Dynamic | utf8_general_ci | checksum=1 delay_key_write=1 row_format=FIXED |
CREATE TABLE `block` (
`No` smallint(6) NOT NULL auto_increment COMMENT 'Comment test on field',
`Name` varchar(16) NOT NULL,
`ContentTypeNo` int(10) unsigned NOT NULL default '',
`Data` blob NOT NULL,
PRIMARY KEY (`No`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED
COMMENT='Comment test on table'