vod_category_config.sql

spring+webwork+iBatis做的VOD系统web端代码。值得学习MVC和持久层的人看。lib太大没上传。所以需要什么lib可要自己去下载。

insert into vod_category_config (id,parent_id,name) values (1,0,'');
insert into vod_category_config (id,parent_id,name) values (2,1,'电影');

insert into vod_category_config (id,parent_id,name) values (20,2,'动作');
insert into vod_category_config (id,parent_id,name) values (21,2,'情色');
insert into vod_category_config (id,parent_id,name) values (22,2,'剧情');
insert into vod_category_config (id,parent_id,name) values (23,2,'喜剧');
insert into vod_category_config (id,parent_id,name) values (24,2,'科幻');
insert into vod_category_config (id,parent_id,name) values (25,2,'武侠');
insert into vod_category_config (id,parent_id,name) values (26,2,'惊悚');
insert into vod_category_config (id,parent_id,name) values (27,2,'战争');
insert into vod_category_config (id,parent_id,name) values (28,2,'纪录');
insert into vod_category_config (id,parent_id,name) values (29,2,'爱情');
insert into vod_category_config (id,parent_id,name) values (30,2,'魔幻');
insert into vod_category_config (id,parent_id,name) values (31,2,'灾难');
insert into vod_category_config (id,parent_id,name) values (32,2,'恐怖');
insert into vod_category_config (id,parent_id,name) values (33,2,'儿童');
insert into vod_category_config (id,parent_id,name) values (34,2,'歌舞');
insert into vod_category_config (id,parent_id,name) values (35,2,'犯罪');
insert into vod_category_config (id,parent_id,name) values (36,2,'悬疑');
insert into vod_category_config (id,parent_id,name) values (37,2,'伦理');
insert into vod_category_config (id,parent_id,name) values (38,2,'文艺');
insert into vod_category_config (id,parent_id,name) values (39,2,'史诗');
insert into vod_category_config (id,parent_id,name) values (40,2,'激情');
insert into vod_category_config (id,parent_id,name) values (41,2,'高清');
insert into vod_category_config (id,parent_id,name) values (42,2,'推荐');
insert into vod_category_config (id,parent_id,name) values (43,2,'待审');
insert into vod_category_config (id,parent_id,name) values (44,2,'免费');
insert into vod_category_config (id,parent_id,name) values (45,2,'收费');
insert into vod_category_config (id,parent_id,name) values (135,2,'其他');
insert into vod_category_config (id,parent_id,name) values (141,2,'华语');
insert into vod_category_config (id,parent_id,name) values (142,2,'欧美');
insert into vod_category_config (id,parent_id,name) values (143,2,'日韩');
insert into vod_category_config (id,parent_id,name) values (144,2,'其他地区');


insert into vod_category_config (id,parent_id,name) values (3,1,'电视剧');

insert into vod_category_config (id,parent_id,name) values (46,3,'爱情');
insert into vod_category_config (id,parent_id,name) values (47,3,'现代');
insert into vod_category_config (id,parent_id,name) values (48,3,'偶像');
insert into vod_category_config (id,parent_id,name) values (49,3,'武侠');
insert into vod_category_config (id,parent_id,name) values (50,3,'刑侦');
insert into vod_category_config (id,parent_id,name) values (51,3,'古装');
insert into vod_category_config (id,parent_id,name) values (52,3,'言情');
insert into vod_category_config (id,parent_id,name) values (53,3,'历史');
insert into vod_category_config (id,parent_id,name) values (54,3,'轻喜');
insert into vod_category_config (id,parent_id,name) values (55,3,'神话');
insert into vod_category_config (id,parent_id,name) values (56,3,'军事');
insert into vod_category_config (id,parent_id,name) values (57,3,'剧情');
insert into vod_category_config (id,parent_id,name) values (58,3,'悬疑');
insert into vod_category_config (id,parent_id,name) values (59,3,'青春');
insert into vod_category_config (id,parent_id,name) values (60,3,'都市');
insert into vod_category_config (id,parent_id,name) values (61,3,'纪实');
insert into vod_category_config (id,parent_id,name) values (62,3,'动作');
insert into vod_category_config (id,parent_id,name) values (63,3,'犯罪');
insert into vod_category_config (id,parent_id,name) values (64,3,'情爱');
insert into vod_category_config (id,parent_id,name) values (65,3,'反腐');
insert into vod_category_config (id,parent_id,name) values (66,3,'推荐');
insert into vod_category_config (id,parent_id,name) values (67,3,'免费');
insert into vod_category_config (id,parent_id,name) values (68,3,'收费');
insert into vod_category_config (id,parent_id,name) values (69,3,'待审');
insert into vod_category_config (id,parent_id,name) values (70,3,'连载');
insert into vod_category_config (id,parent_id,name) values (71,3,'完整');
insert into vod_category_config (id,parent_id,name) values (136,3,'其他');
insert into vod_category_config (id,parent_id,name) values (145,3,'欧美');
insert into vod_category_config (id,parent_id,name) values (146,3,'日韩');
insert into vod_category_config (id,parent_id,name) values (147,3,'大陆');
insert into vod_category_config (id,parent_id,name) values (148,3,'港台');


insert into vod_category_config (id,parent_id,name) values (4,1,'动漫');

insert into vod_category_config (id,parent_id,name) values (72,4,'TV版');
insert into vod_category_config (id,parent_id,name) values (73,4,'OVA版');
insert into vod_category_config (id,parent_id,name) values (74,4,'剧场版');
insert into vod_category_config (id,parent_id,name) values (75,4,'科幻');
insert into vod_category_config (id,parent_id,name) values (76,4,'冒险');
insert into vod_category_config (id,parent_id,name) values (77,4,'奇幻');
insert into vod_category_config (id,parent_id,name) values (78,4,'恋爱');
insert into vod_category_config (id,parent_id,name) values (79,4,'搞笑');
insert into vod_category_config (id,parent_id,name) values (80,4,'战争');
insert into vod_category_config (id,parent_id,name) values (81,4,'体育');
insert into vod_category_config (id,parent_id,name) values (82,4,'动作');
insert into vod_category_config (id,parent_id,name) values (83,4,'推理');
insert into vod_category_config (id,parent_id,name) values (84,4,'推荐');
insert into vod_category_config (id,parent_id,name) values (85,4,'免费');
insert into vod_category_config (id,parent_id,name) values (86,4,'收费');
insert into vod_category_config (id,parent_id,name) values (87,4,'待审');
insert into vod_category_config (id,parent_id,name) values (88,4,'连载');
insert into vod_category_config (id,parent_id,name) values (89,4,'完整');
insert into vod_category_config (id,parent_id,name) values (137,4,'其他');
insert into vod_category_config (id,parent_id,name) values (149,4,'华语');
insert into vod_category_config (id,parent_id,name) values (150,4,'欧美');
insert into vod_category_config (id,parent_id,name) values (151,4,'日韩');
insert into vod_category_config (id,parent_id,name) values (152,4,'其他地区');


insert into vod_category_config (id,parent_id,name) values (5,1,'播客');

insert into vod_category_config (id,parent_id,name) values (90,5,'生活');
insert into vod_category_config (id,parent_id,name) values (91,5,'纪实');
insert into vod_category_config (id,parent_id,name) values (92,5,'故事');
insert into vod_category_config (id,parent_id,name) values (93,5,'DV');
insert into vod_category_config (id,parent_id,name) values (94,5,'推荐');
insert into vod_category_config (id,parent_id,name) values (95,5,'免费');
insert into vod_category_config (id,parent_id,name) values (96,5,'收费');
insert into vod_category_config (id,parent_id,name) values (97,5,'待审');
insert into vod_category_config (id,parent_id,name) values (138,5,'其他');


insert into vod_category_config (id,parent_id,name) values (6,1,'综艺');

insert into vod_category_config (id,parent_id,name) values (98,6,'搞笑');
insert into vod_category_config (id,parent_id,name) values (99,6,'访谈');
insert into vod_category_config (id,parent_id,name) values (100,6,'竞技');
insert into vod_category_config (id,parent_id,name) values (101,6,'答题');
insert into vod_category_config (id,parent_id,name) values (102,6,'抽奖');
insert into vod_category_config (id,parent_id,name) values (103,6,'整蛊');
insert into vod_category_config (id,parent_id,name) values (104,6,'搞怪');
insert into vod_category_config (id,parent_id,name) values (105,6,'饮食');
insert into vod_category_config (id,parent_id,name) values (106,6,'八卦');
insert into vod_category_config (id,parent_id,name) values (107,6,'桃色');
insert into vod_category_config (id,parent_id,name) values (108,6,'前沿');
insert into vod_category_config (id,parent_id,name) values (109,6,'演唱会');
insert into vod_category_config (id,parent_id,name) values (110,6,'晚会');
insert into vod_category_config (id,parent_id,name) values (111,6,'推荐');
insert into vod_category_config (id,parent_id,name) values (112,6,'免费');
insert into vod_category_config (id,parent_id,name) values (113,6,'收费');
insert into vod_category_config (id,parent_id,name) values (114,6,'待审');
insert into vod_category_config (id,parent_id,name) values (115,6,'连载');
insert into vod_category_config (id,parent_id,name) values (116,6,'完整');
insert into vod_category_config (id,parent_id,name) values (139,6,'其他');


insert into vod_category_config (id,parent_id,name) values (7,1,'音乐');

insert into vod_category_config (id,parent_id,name) values (117,7,'MTV');
insert into vod_category_config (id,parent_id,name) values (118,7,'单曲');
insert into vod_category_config (id,parent_id,name) values (119,7,'专辑');
insert into vod_category_config (id,parent_id,name) values (120,7,'男歌手');
insert into vod_category_config (id,parent_id,name) values (121,7,'女歌手');
insert into vod_category_config (id,parent_id,name) values (122,7,'组合');
insert into vod_category_config (id,parent_id,name) values (123,7,'最新');
insert into vod_category_config (id,parent_id,name) values (124,7,'热门');
insert into vod_category_config (id,parent_id,name) values (125,7,'流行');
insert into vod_category_config (id,parent_id,name) values (126,7,'情歌');
insert into vod_category_config (id,parent_id,name) values (127,7,'经典');
insert into vod_category_config (id,parent_id,name) values (128,7,'对唱');
insert into vod_category_config (id,parent_id,name) values (140,7,'其他');


insert into vod_category_config (id,parent_id,name) values (8,1,'推荐更新');
insert into vod_category_config (id,parent_id,name) values (9,1,'劲爆激情');
insert into vod_category_config (id,parent_id,name) values (10,1,'性福生活');
insert into vod_category_config (id,parent_id,name) values (11,1,'推荐影视');
insert into vod_category_config (id,parent_id,name) values (12,1,'推荐动漫');
insert into vod_category_config (id,parent_id,name) values (13,1,'推荐剧集');
insert into vod_category_config (id,parent_id,name) values (14,1,'推荐MV');
insert into vod_category_config (id,parent_id,name) values (15,1,'推荐音乐');
insert into vod_category_config (id,parent_id,name) values (16,1,'推荐播客');
insert into vod_category_config (id,parent_id,name) values (17,1,'推荐综艺');
insert into vod_category_config (id,parent_id,name) values (18,1,'推荐专题');
insert into vod_category_config (id,parent_id,name) values (19,1,'地区');

insert into vod_category_config (id,parent_id,name) values (129,19,'华语');
insert into vod_category_config (id,parent_id,name) values (130,19,'欧美');
insert into vod_category_config (id,parent_id,name) values (132,19,'大陆');
insert into vod_category_config (id,parent_id,name) values (131,19,'日韩');
insert into vod_category_config (id,parent_id,name) values (133,19,'港台');
insert into vod_category_config (id,parent_id,name) values (134,19,'其他地区');