跳至 [1] [全屏预览] 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),(11, 'php点点通-http://www.phpddt.com', 12, 13, 0, 1400044901);