| Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|
| LayoutNo | smallint(6) | NO | PRI | |||
| BlockNo | smallint(6) | NO | PRI |
| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | PRIMARY | 2 | BlockNo | A | 4 | BTREE |
| Engine | Row format | Table collation | Create options |
|---|---|---|---|
| MyISAM | Fixed | utf8_general_ci |
CREATE TABLE `layoutblock` ( `LayoutNo` smallint(6) NOT NULL, `BlockNo` smallint(6) NOT NULL, PRIMARY KEY (`LayoutNo`,`BlockNo`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8