Table: nornix_site.themeresource

Structure
Name	Type	Null	Key	Default
ThemeNo	int(10) unsigned	NO	PRI	0
ContentTypeNo	int(10) unsigned	YES
Data	mediumblob	NO
TS	timestamp	NO		CURRENT_TIMESTAMP
Name	varchar(64)	NO	PRI
MimeTypeNo	int(10) unsigned	NO	PRI	0
Description	varchar(127)	NO
Width	int(10) unsigned	NO		0
Height	int(10) unsigned	NO		0

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	PRIMARY	3	Name	A	7				BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `themeresource` (
  `ThemeNo` int(10) unsigned NOT NULL default '',
  `ContentTypeNo` int(10) unsigned default NULL,
  `Data` mediumblob NOT NULL,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Name` varchar(64) NOT NULL default '',
  `MimeTypeNo` int(10) unsigned NOT NULL default '',
  `Description` varchar(127) NOT NULL,
  `Width` int(10) unsigned NOT NULL default '',
  `Height` int(10) unsigned NOT NULL default '',
  PRIMARY KEY  (`ThemeNo`,`MimeTypeNo`,`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8