Table: nornix_site.themeresource
Structure Name | Type | Null | Key | Default | Extra | Comment |
---|
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 | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
0 | PRIMARY | 3 | Name | A | 7 | | | | BTREE | |
InformationEngine | 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