Table: nornix_site.block
Structure Comment test on table| Name | 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 | | | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | Name | 1 | Name | A | 3 | | | | BTREE | |
Information| Engine | 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'