Table: nornix_site.pageresource

Structure *Resources (images) for individual pages.*
Name	Type	Null	Key	Default
Name	varchar(80)	NO	PRI
DocumentNo	int(10) unsigned	NO	PRI	0
MimeTypeNo	int(10) unsigned	NO	PRI	0
Data	longblob	NO
TS	timestamp	NO		CURRENT_TIMESTAMP
Description	varchar(127)	NO
ContentTypeNo	int(10) unsigned	YES
Width	int(10) unsigned	NO		0
Height	int(11) unsigned	NO		0

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

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `pageresource` (
  `Name` varchar(80) NOT NULL default '',
  `DocumentNo` int(10) unsigned NOT NULL default '',
  `MimeTypeNo` int(10) unsigned NOT NULL default '',
  `Data` longblob NOT NULL,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Description` varchar(127) NOT NULL,
  `ContentTypeNo` int(10) unsigned default NULL,
  `Width` int(10) unsigned NOT NULL default '',
  `Height` int(11) unsigned NOT NULL default '',
  PRIMARY KEY  (`Name`,`DocumentNo`,`MimeTypeNo`),
  KEY `DocumentNo` (`DocumentNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Resources (images) for individual pages.'