Table: nornix_site.documentmeta

Structure
Name	Type	Null	Key	Default	Extra	Comment
MetadataNo	int(10) unsigned	NO	PRI		auto_increment
DocumentNo	int(10) unsigned	NO		0

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	MetaDocUnique	2	DocumentNo	A	6				BTREE

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

CREATE TABLE `documentmeta` (
  `MetadataNo` int(10) unsigned NOT NULL auto_increment,
  `DocumentNo` int(10) unsigned NOT NULL default '',
  PRIMARY KEY  (`MetadataNo`),
  UNIQUE KEY `MetaDocUnique` (`MetadataNo`,`DocumentNo`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED