- CREATE TABLE IF NOT EXISTS `category` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(50) NOT NULL,
- `lft` int(11) NOT NULL,
- `rgt` int(11) NOT NULL,
- `order` int(11) NOT NULL COMMENT '排序',
- `create_time` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
- --
- -- 转存表中的数据 `category`
- --
- INSERT INTO `category` (`id`, `title`, `lft`, `rgt`, `order`, `create_time`) VALUES
- (1, '顶级栏目', 1, 20, 1, 1261964806),
- (2, '编辑后的分类', 16, 19, 50, 1264586212),
- (4, '公司产品', 10, 15, 50, 1264586249),
- (5, '荣誉资质', 8, 9, 50, 1264586270),
- (6, '资料下载', 6, 7, 50, 1264586295),
- (7, '人才招聘', 4, 5, 50, 1264586314),
- (8, '留言板', 2, 3, 50, 1264586884),
- (9, '总裁', 17, 18, 50, 1267771951),
- (10, '新的分类的子分类', 11, 14, 0, 1400044841),
- //该片段来自于http://www.codesnippet.cn/detail/2408201715264.html
来源: http://www.codesnippet.cn/detail/2408201715264.html