Table: nornix_system.class
Structure Name | Type | Null | Key | Default | Extra | Comment |
---|
No | int(10) unsigned | NO | PRI | | auto_increment | |
---|
Name | varchar(32) | NO | | | | |
---|
DescNo | int(10) unsigned | YES | | | | |
---|
LegendNo | int(10) unsigned | YES | | | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
0 | PRIMARY | 1 | No | A | 0 | | | | BTREE | |
InformationEngine | Row format | Table collation | Create options |
---|
MyISAM | Fixed | utf8_general_ci | row_format=FIXED |
CREATE TABLE `class` (
`No` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(32) NOT NULL,
`DescNo` int(10) unsigned default NULL,
`LegendNo` int(10) unsigned default NULL,
PRIMARY KEY (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED