You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
133 lines
8.6 KiB
Plaintext
133 lines
8.6 KiB
Plaintext
-- 执行删除.
|
|
DELETE FROM Port_Dept;
|
|
DELETE FROM Port_Station;
|
|
DELETE FROM Port_Emp;
|
|
DELETE FROM Port_DeptEmpStation;
|
|
DELETE FROM Port_DeptEmp;
|
|
DELETE FROM Port_StationType;
|
|
|
|
|
|
-- Port_Dept ;
|
|
DELETE FROM Port_Dept;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('100','集团总部','0') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1001','集团市场部','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1002','集团研发部','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1003','集团服务部','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1004','集团财务部','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1005','集团人力资源部','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1060','南方分公司','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1061', '市场部','1060') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1062', '财务部','1060') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1063', '销售部','1060') ;
|
|
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1070','北方分公司','100') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1071','市场部','1070') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1072','财务部','1070') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1073','销售部','1070') ;
|
|
INSERT INTO Port_Dept (No,Name,ParentNo) VALUES('1099','外来单位','100') ;
|
|
|
|
|
|
-- Port_StationType ;
|
|
DELETE FROM Port_StationType;
|
|
INSERT INTO Port_StationType (No,Name) VALUES('1','高层');
|
|
INSERT INTO Port_StationType (No,Name) VALUES('2','中层');
|
|
INSERT INTO Port_StationType (No,Name) VALUES('3','基层');
|
|
|
|
-- Port_Station ;
|
|
DELETE FROM Port_Station;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('01','总经理','1') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('02','市场部经理','2');
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('03','研发部经理','2') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('04','客服部经理','2') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('05','财务部经理','2') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('06','人力资源部经理','2') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('07','销售人员岗','3') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('08','程序员岗','3') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('09','技术服务岗','3') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('10','出纳岗','3') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('11','人力资源助理岗','3') ;
|
|
INSERT INTO Port_Station (No,Name,FK_StationType) VALUES('12','外来人员岗','3') ;
|
|
|
|
|
|
-- Port_Emp ;
|
|
-- 总经理部 ;
|
|
DELETE FROM Port_Emp;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('admin','admin','123','100','0531-82374939','yuwen@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('yuwen','钰雯','123','100','0531-82374939','yuwen@ccflow.org',0) ;
|
|
|
|
-- 市场部 ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('zhanghaicheng','张海成','123','1001','0531-82374939','zhanghaicheng@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('zhangyifan','张一帆','123','1001','0531-82374939','zhangyifan@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('zhoushengyu','周升雨','123','1001','0531-82374939','zhoushengyu@ccflow.org',0) ;
|
|
|
|
-- 研发部 ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('qifenglin','祁凤林','123','1002','0531-82374939','qifenglin@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('zhoutianjiao','周天娇','123','1002','0531-82374939','zhoutianjiao@ccflow.org',0) ;
|
|
|
|
-- 服务部经理 ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('guoxiangbin','郭祥斌','123','1003','0531-82374939','guoxiangbin@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('fuhui','福惠','123','1003','0531-82374939','fuhui@ccflow.org',0) ;
|
|
|
|
-- 财务部 ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('yangyilei','杨依雷','123','1004','0531-82374939','yangyilei@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('guobaogeng','郭宝庚','123','1004','0531-82374939','guobaogeng@ccflow.org',0) ;
|
|
|
|
-- 人力资源部 ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('liping','李萍','123','1005','0531-82374939','liping@ccflow.org',0) ;
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('liyan','李言','123','1005','0531-82374939','liyan@ccflow.org',0) ;
|
|
|
|
-- 外来单位人员
|
|
INSERT INTO Port_Emp (No,Name,Pass,FK_Dept,Tel,Email,EmpSta) VALUES('Guest','外来人员','123','1099','0531-82374939','Guest@ccflow.org',0) ;
|
|
|
|
|
|
-- Port_DeptEmp 人员与部门的对应 ;
|
|
DELETE FROM Port_DeptEmp;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('100_yuwen','yuwen','100','集团总部','01','总经理');
|
|
|
|
-- 市场部 ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1001_zhanghaicheng','zhanghaicheng','1001','集团市场部','02','市场部经理') ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1001_zhangyifan','zhangyifan','1001','集团市场部','07','销售人员岗') ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1001_zhoushengyu','zhoushengyu','1001','集团市场部','07','销售人员岗') ;
|
|
|
|
-- 研发部 ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1002_qifenglin','qifenglin','1002','集团研发部','03','研发部经理') ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1002_zhoutianjiao','zhoutianjiao','1002','集团研发部','08','程序员岗') ;
|
|
|
|
-- 服务部经理 ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1003_guoxiangbin','guoxiangbin','1003','客服部经理','04','客服部经理') ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1003_fuhui', 'fuhui','1003','客服部经理','09','技术服务岗') ;
|
|
|
|
-- 财务部 ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1004_yangyilei','yangyilei','1004','财务部','05','财务部经理') ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1004_guobaogeng','guobaogeng','1004','财务部','10','出纳岗') ;
|
|
|
|
-- 人力资源部 ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1005_liping','liping','1005','集团总部','06','人力资源部经理') ;
|
|
INSERT INTO Port_DeptEmp (MyPK,FK_Emp,FK_Dept,DeptName,StationNo,StationNoT) VALUES('1005_liyan','liyan','1005','集团总部','11','人力资源助理岗') ;
|
|
|
|
-- Port_DeptEmpStation 人员与岗位的对应 ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('100_yuwen_01','100','yuwen','01') ;
|
|
|
|
-- 市场部;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1001_zhanghaicheng_02','1001','zhanghaicheng','02') ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1001_zhangyifan_07','1001','zhangyifan','07') ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1001_zhoushengyu_07','1001','zhoushengyu','07') ;
|
|
|
|
-- 研发部 ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1002_qifenglin_03','1002','qifenglin','03') ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1002_zhoutianjiao_08','1002','zhoutianjiao','08') ;
|
|
|
|
-- 服务部;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1003_guoxiangbin_04','1003','guoxiangbin','04');
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1003_fuhui_09', '1003','fuhui','09') ;
|
|
|
|
-- 财务部;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1004_yangyilei_05','1004','yangyilei','05') ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1004_guobaogeng_10','1004','guobaogeng','10') ;
|
|
|
|
-- 人力资源部;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1005_liping_06','1005','liping','06') ;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1005_liyan_11','1005','liyan','11') ;
|
|
|
|
-- 外来单位人员;
|
|
INSERT INTO Port_DeptEmpStation (MyPK,FK_Dept,FK_Emp,FK_Station) VALUES('1099_Guest_12','1005','Guest','12') ; |