Table: nornix_system.contenttype
Structure Name | Type | Null | Key | Default | Extra | Comment |
---|
No | int(10) unsigned | NO | PRI | | auto_increment | |
---|
Name | varchar(64) | NO | | | | |
---|
DescNo | int(10) unsigned | YES | | | | |
---|
Handler | varchar(64) | NO | | | | |
---|
Children | tinyint(1) unsigned | NO | | 0 | | |
---|
ParsesPath | tinyint(1) unsigned | NO | | 0 | | |
---|
NewData | mediumblob | YES | | | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
0 | PRIMARY | 1 | No | A | 19 | | | | BTREE | |
InformationEngine | Row format | Table collation | Create options |
---|
MyISAM | Dynamic | utf8_general_ci | pack_keys=0 row_format=FIXED |
CREATE TABLE `contenttype` (
`No` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(64) NOT NULL,
`DescNo` int(10) unsigned default NULL,
`Handler` varchar(64) NOT NULL,
`Children` tinyint(1) unsigned NOT NULL default '',
`ParsesPath` tinyint(1) unsigned NOT NULL default '',
`NewData` mediumblob,
PRIMARY KEY (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=FIXED