Table: nornix_site.siteresource

Structure *Resources (images) for all pages.*
Name	Type	Null	Key	Default
Name	varchar(80)	NO	PRI
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(11) unsigned	NO		0
Height	int(11) unsigned	NO		0

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	PRIMARY	2	MimeTypeNo	A	8				BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `siteresource` (
  `Name` varchar(80) NOT NULL,
  `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(11) unsigned NOT NULL default '',
  `Height` int(11) unsigned NOT NULL default '',
  PRIMARY KEY  (`Name`,`MimeTypeNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Resources (images) for all pages.'