initdata.sql

数据库客户信息管理系统,C++,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(profession_id,profession_name) values(20,'会计');
insert into profession_info_tab(profession_id,profession_name) values(21,'证券经纪人');
insert into profession_info_tab(profession_id,profession_name) values(22,'注册分析师');
insert into profession_info_tab(profession_id,profession_name) values(23,'投资顾问');
insert into profession_info_tab(profession_id,profession_name) values(24,'质量工程师');
insert into profession_info_tab(profession_id,profession_name) values(25,'教授');
insert into profession_info_tab(profession_id,profession_name) values(26,'副教授');
insert into profession_info_tab(profession_id,profession_name) values(27,'讲师');
insert into profession_info_tab(profession_id,profession_name) values(28,'学生');
insert into profession_info_tab(profession_id,profession_name) values(29,'导演');
insert into profession_info_tab(profession_id,profession_name) values(30,'摄影师');

--添加行业信息表vocation_info_tab
insert into vocation_info_tab(vocation_id,vocation_name) values(1,'娱乐');
insert into vocation_info_tab(vocation_id,vocation_name) values(2,'体育');
insert into vocation_info_tab(vocation_id,vocation_name) values(3,'教育');
insert into vocation_info_tab(vocation_id,vocation_name) values(4,'卫生');
insert into vocation_info_tab(vocation_id,vocation_name) values(5,'交通');
insert into vocation_info_tab(vocation_id,vocation_name) values(6,'环保');
insert into vocation_info_tab(vocation_id,vocation_name) values(7,'保险');
insert into vocation_info_tab(vocation_id,vocation_name) values(8,'制造业');
insert into vocation_info_tab(vocation_id,vocation_name) values(9,'服务业');
insert into vocation_info_tab(vocation_id,vocation_name) values(10,'房地产');
insert into vocation_info_tab(vocation_id,vocation_name) values(11,'林业');
insert into vocation_info_tab(vocation_id,vocation_name) values(12,'渔业');
insert into vocation_info_tab(vocation_id,vocation_name) values(13,'政府');
insert into vocation_info_tab(vocation_id,vocation_name) values(14,'科研');
insert into vocation_info_tab(vocation_id,vocation_name) values(15,'艺术');

--提交
commit;