Name | Type | Null | Key | Default | Extra | Comment |
---|---|---|---|---|---|---|
Name | varchar(24) | NO | PRI | |||
Code | varchar(255) | NO |
Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|---|---|---|---|---|---|---|---|---|---|
0 | PRIMARY | 1 | Name | A | 4 | BTREE |
Engine | Row format | Table collation | Create options |
---|---|---|---|
MyISAM | Fixed | utf8_general_ci | row_format=FIXED |
CREATE TABLE `doctype` ( `Name` varchar(24) NOT NULL, `Code` varchar(255) NOT NULL, PRIMARY KEY (`Name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED