Table: nornix_system.documenttype

Structure
Name	Type	Null	Key	Default	Extra
No	int(10) unsigned	NO	PRI		auto_increment
Name	varchar(18)	NO
MimeTypeNo	int(10) unsigned	NO	UNI	0
DescNo	int(10) unsigned	YES
Handler	varchar(64)	NO

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	UniqueMime	1	MimeTypeNo	A	3				BTREE

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

CREATE TABLE `documenttype` (
  `No` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(18) NOT NULL,
  `MimeTypeNo` int(10) unsigned NOT NULL default '',
  `DescNo` int(10) unsigned default NULL,
  `Handler` varchar(64) NOT NULL,
  PRIMARY KEY  (`No`),
  UNIQUE KEY `UniqueMime` (`MimeTypeNo`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED