Table: nornix_site.content

Structure
Name	Type	Null	Key	Default
DocumentNo	int(10) unsigned	NO	PRI	0
ContentTypeNo	int(10) unsigned	NO		0
Text	mediumtext	YES	MUL
Data	mediumblob	YES
TS	timestamp	NO		CURRENT_TIMESTAMP
Version	int(10) unsigned	NO	PRI	0
Block	varchar(16)	NO	PRI	content

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
1	Textsearch	1	Text					YES	FULLTEXT

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `content` (
  `DocumentNo` int(10) unsigned NOT NULL default '',
  `ContentTypeNo` int(10) unsigned NOT NULL default '',
  `Text` mediumtext,
  `Data` mediumblob,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Version` int(10) unsigned NOT NULL default '',
  `Block` varchar(16) NOT NULL default 'content',
  UNIQUE KEY `DocBlockVersion` (`DocumentNo`,`Version`,`Block`),
  KEY `DocVersion` (`DocumentNo`,`Version`),
  KEY `Block` (`Block`),
  FULLTEXT KEY `Textsearch` (`Text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8