Table: nornix_system.mimeextension
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Extension | varchar(12) | NO | PRI | | | |
|---|
| MimeTypeNo | int(10) unsigned | NO | | 0 | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | PRIMARY | 1 | Extension | A | 32 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Fixed | utf8_general_ci | row_format=FIXED |
CREATE TABLE `mimeextension` (
`Extension` varchar(12) NOT NULL,
`MimeTypeNo` int(10) unsigned NOT NULL default '',
PRIMARY KEY (`Extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED