insert into deepcate(id,pid,catename,cateorder,createtime) values
(1,0,'新闻',0,0),
(2,0,'图片',0,0),
(3,1,'国内新闻',0,0),
(4,1,'国际新闻',0,0),
(5,3,'北京新闻',0,0),
(6,4,'美国新闻',0,0),
(7,2,'美女图片',0,0),
(8,2,'风景图片',0,0),
(9,7,'日韩明星',0,0),
(10,9,'大陆明星',0,0);
(1,0,'新闻',0,0),
(2,0,'图片',0,0),
(3,1,'国内新闻',0,0),
(4,1,'国际新闻',0,0),
(5,3,'北京新闻',0,0),
(6,4,'美国新闻',0,0),
(7,2,'美女图片',0,0),
(8,2,'风景图片',0,0),
(9,7,'日韩明星',0,0),
(10,9,'大陆明星',0,0);
2016-05-30
CREATE TABLE `deepcate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL,
`catename` varchar(30) NOT NULL,
`cateorder` int(10) unsigned NOT NULL DEFAULT '0',
`createtime` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL,
`catename` varchar(30) NOT NULL,
`cateorder` int(10) unsigned NOT NULL DEFAULT '0',
`createtime` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2016-05-30
insert into likecate (id,path,catename,cateorder,createtime) values
(1,'','手机',0,0),
(2,'1','功能手机',0,0),
(3,'1,2','老人手机',0,0),
(4,'1,2','儿童手机',0,0),
(5,'1','智能手机',0,0),
(6,'1,5','android手机',0,0),
(7,'1,5','IOS手机',0,0),
(8,'1,5','WinPhote手机',0,0),
(9,'1,2,4','色盲手机',0,0),
(10,'1,2,3','大字手机',0,0)
;
(1,'','手机',0,0),
(2,'1','功能手机',0,0),
(3,'1,2','老人手机',0,0),
(4,'1,2','儿童手机',0,0),
(5,'1','智能手机',0,0),
(6,'1,5','android手机',0,0),
(7,'1,5','IOS手机',0,0),
(8,'1,5','WinPhote手机',0,0),
(9,'1,2,4','色盲手机',0,0),
(10,'1,2,3','大字手机',0,0)
;
2016-05-05