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
表單數(shù)據(jù):
insert into fenlei(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);
insert into fenlei(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);
2016-04-14
創(chuàng)建表: create table fenlei(
id int unsigned not null auto_increment primary key,
pid int unsigned not null,
catename varchar(30) not null,
cateorder int unsigned not null,
createtime int(10) not null
);
id int unsigned not null auto_increment primary key,
pid int unsigned not null,
catename varchar(30) not null,
cateorder int unsigned not null,
createtime int(10) not null
);
2016-04-14