Table: nornix_site.document
Structure Name | Type | Null | Key | Default | Extra | Comment |
---|
No | int(10) unsigned | NO | PRI | | auto_increment | |
---|
Level | int(10) unsigned | NO | | | | |
---|
SortOrder | int(10) unsigned | NO | | 0 | | |
---|
AuthLevel | int(10) unsigned | NO | | 0 | | |
---|
MenuName | varchar(80) | NO | | | | page name in menu |
---|
PageTitle | varchar(80) | NO | | | | page title in program titlebar |
---|
PathPart | varchar(45) | NO | MUL | | | |
---|
Lft | int(10) unsigned | NO | UNI | 0 | | |
---|
Rgt | int(10) unsigned | NO | UNI | 0 | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
1 | PathPart | 1 | PathPart | A | | | | | BTREE | |
InformationEngine | Row format | Table collation | Create options |
---|
MyISAM | Fixed | utf8_general_ci | row_format=FIXED |
CREATE TABLE `document` (
`No` int(10) unsigned NOT NULL auto_increment,
`Level` int(10) unsigned NOT NULL,
`SortOrder` int(10) unsigned NOT NULL default '',
`AuthLevel` int(10) unsigned NOT NULL default '',
`MenuName` varchar(80) NOT NULL default '' COMMENT 'page name in menu',
`PageTitle` varchar(80) NOT NULL default '' COMMENT 'page title in program titlebar',
`PathPart` varchar(45) NOT NULL default '',
`Lft` int(10) unsigned NOT NULL default '',
`Rgt` int(10) unsigned NOT NULL default '',
PRIMARY KEY (`No`),
UNIQUE KEY `Lft` (`Lft`),
UNIQUE KEY `Rgt` (`Rgt`),
KEY `PathPart` (`PathPart`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED