Table: nornix_system.docconttype

Structure
Name	Type	Null	Key	Default	Extra	Comment
DocumentTypeNo	int(10) unsigned	NO	PRI	0
ContentTypeNo	int(10) unsigned	NO	PRI	0

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	DocCont	2	ContentTypeNo	A	18				BTREE

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

CREATE TABLE `docconttype` (
  `DocumentTypeNo` int(10) unsigned NOT NULL default '',
  `ContentTypeNo` int(10) unsigned NOT NULL default '',
  UNIQUE KEY `DocCont` (`DocumentTypeNo`,`ContentTypeNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 ROW_FORMAT=FIXED