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 | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 1 | PathPart | 1 | PathPart | A | | | | | BTREE | |
Information| Engine | 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