【SQL开源代码栏目提醒】:本文主要为网学会员提供initdata.sql,希望对需要initdata.sql网友有所帮助,学习一下!
--添加
系统配置信息数据
--添加地方信息表area_info_tab
insert into area_info_tab(area_id,area_name) values(1,'北京');
insert into area_info_tab(area_id,area_name) values(2,'上海');
insert into area_info_tab(area_id,area_name) values(3,'天津');
insert into area_info_tab(area_id,area_name) values(4,'重庆');
insert into area_info_tab(area_id,area_name) values(5,'广州');
insert into area_info_tab(area_id,area_name) values(6,'中山');
insert into area_info_tab(area_id,area_name) values(7,'东莞');
insert into area_info_tab(area_id,area_name) values(8,'佛山');
insert into area_info_tab(area_id,area_name) values(9,'珠海');
insert into area_info_tab(area_id,area_name) values(10,'深圳');
insert into area_info_tab(area_id,area_name) values(11,'海口');
insert into area_info_tab(area_id,area_name) values(12,'三亚');
insert into area_info_tab(area_id,area_name) values(13,'武汉');
insert into area_info_tab(area_id,area_name) values(14,'荆门');
insert into area_info_tab(area_id,area_name) values(15,'南京');
insert into area_info_tab(area_id,area_name) values(16,'常熟');
insert into area_info_tab(area_id,area_name) values(17,'常州');
insert into area_info_tab(area_id,area_name) values(18,'昆山');
insert into area_info_tab(area_id,area_name) values(19,'苏州');
insert into area_info_tab(area_id,area_name) values(20,'杭州');
insert into area_info_tab(area_id,area_name) values(21,'温州');
insert into area_info_tab(area_id,area_name) values(22,'合肥');
insert into area_info_tab(area_id,area_name) values(23,'安庆');
insert into area_info_tab(area_id,area_name) values(24,'福州');
insert into area_info_tab(area_id,area_name) values(25,'厦门');
insert into area_info_tab(area_id,area_name) values(26,'兰州');
insert into area_info_tab(area_id,area_name) values(27,'长沙');
insert into area_info_tab(area_id,area_name) values(28,'湘潭');
insert into area_info_tab(area_id,area_name) values(29,'南昌');
insert into area_info_tab(area_id,area_name) values(30,'九江');
--添加认识途径信息表approach_info_tab
insert into approach_info_tab(approach_id,approach_name) values(1,'同学');
insert into approach_info_tab(approach_id,approach_name) values(2,'同事');
insert into approach_info_tab(approach_id,approach_name) values(3,'展会');
insert into approach_info_tab(approach_id,approach_name) values(4,'订单');
--添加职位信息表profession_info_tab
insert into profession_info_tab(profession_id,profession_name) values(1,'董事长');
insert into profession_info_tab(profession_id,profession_name) values(2,'总经理');
insert into profession_info_tab(profession_id,profession_name) values(3,'市场经理');
insert into profession_info_tab(profession_id,profession_name) values(4,'销售经理');
insert into profession_info_tab(profession_id,profession_name) values(5,'研发经理');
insert into profession_info_tab(profession_id,profession_name) values(6,'
软件工程师');
insert into profession_info_tab(profession_id,profession_name) values(7,'硬件工程师');
insert into profession_info_tab(profession_id,profession_name) values(8,'
网络工程师');
insert into profession_info_tab(profession_id,profession_name) values(9,'技术总监');
insert into profession_info_tab(profession_id,profession_name) values(10,'项目经理');
insert into profession_info_tab(profession_id,profession_name) values(11,'测试工程师');
insert into profession_info_tab(profession_id,profession_name) values(12,'销售总监');
insert into profession_info_tab(profession_id,profession_name) values(13,'物流经理');
insert into profession_info_tab(profession_id,profession_name) values(14,'销售代表');
insert into profession_info_tab(profession_id,profession_name) values(15,'
医药代表');
insert into profession_info_tab(profession_id,profession_name) values(16,'经销商');
insert into profession_info_tab(profession_id,profession_name) values(17,'企业策划');
insert into profession_info_tab(profession_id,profession_name) values(18,'广告策划');
insert into profession_info_tab(profession_id,profession_name) values(19,'财务总监');
insert into profession_info_tab(pro