初始化数据.sql

=== ==ASP销售管理系统

/**************************************/
/* 请建立数据库结构后导入以下初始数据 */
/**************************************/
/* 用户表 */
insert into Employee(LoginName,Password,Employee_Name) values('Admin','123','系统管理员')
/* 权限表 */
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000000,'客户管理',0)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000100,'客户查看',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000200,'客户添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000300,'客户修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000400,'客户删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000500,'采购记录添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000600,'采购记录修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000700,'采购记录删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000800,'跟进记录添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1000900,'跟进记录修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001000,'跟进记录删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001100,'回访记录添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001200,'回访记录修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001300,'回访记录删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001400,'需求表添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001500,'需求表修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001600,'需求表删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001700,'联系人添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001800,'联系人修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1001900,'联系人删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1002000,'客户文档添加',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1002100,'客户文档修改',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(1002200,'客户文档删除',1000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000000,'项目管理',0)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000100,'项目查看',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000200,'项目添加',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000300,'项目修改',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000305,'项目删除',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000400,'项目成员添加',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000500,'项目成员删除',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000600,'项目日志添加',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000700,'项目日志删除',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000800,'客户参与成员添加',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2000900,'客户参与成员删除',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2001000,'项目文档添加',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2001100,'项目文档修改',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(2001200,'项目文档删除',2000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000000,'合同管理',0)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000100,'合同查看',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000105,'财务统计',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000200,'新签合同',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000300,'合同修改',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000400,'收款记录添加',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000500,'收款记录删除',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000600,'外包记录添加',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000700,'外包记录删除',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000800,'基础业务记录添加',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3000900,'基础业务记录删除',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3001000,'合同变更记录添加',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(3001100,'合同变更记录删除',3000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(4000000,'文档管理',0)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(4000100,'文档查看',4000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(4000200,'文档添加',4000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(4000300,'文档修改',4000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(4000400,'文档删除',4000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(5000000,'人事管理',0)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(5000100,'员工查看',5000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(5000200,'员工添加',5000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(5000300,'员工资料修改',5000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(5000400,'员工删除',5000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(6000000,'系统管理',0)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(6000100,'权限分配',6000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(6000200,'工作移交',6000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(6000300,'分公司部门设置',6000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(6000400,'操作日志浏览',6000000)
insert into System_Application(Application_ID,Application_Name,Father_ID) values(6000500,'文档类型设置',6000000)