Table: nornix_system.mimetype

Structure
Name	Type	Null	Key	Default	Extra
No	int(10) unsigned	NO	PRI		auto_increment
Name	varchar(48)	NO	UNI
Compressed	tinyint(1) unsigned	NO		0
DescNo	int(10) unsigned	YES
Charset	tinyint(1) unsigned	NO		0
Icon	varchar(48)	NO
Filter	int(10) unsigned	YES
ContentTypeNo	int(10) unsigned	YES

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	Name	1	Name	A	24				BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Fixed	utf8_general_ci	pack_keys=1 row_format=FIXED

CREATE TABLE `mimetype` (
  `No` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(48) NOT NULL,
  `Compressed` tinyint(1) unsigned NOT NULL default '',
  `DescNo` int(10) unsigned default NULL,
  `Charset` tinyint(1) unsigned NOT NULL default '',
  `Icon` varchar(48) NOT NULL,
  `Filter` int(10) unsigned default NULL,
  `ContentTypeNo` int(10) unsigned default NULL,
  PRIMARY KEY  (`No`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 PACK_KEYS=1 ROW_FORMAT=FIXED