data.sql

老牌java开发的物流管理系统 详细的我也没有怎么看 好像是恒基的

--1、向商品分类表中插入测试数据
  insert into commcatetable(CommodityId,CommodityName)
  select '10001','日用类' union 
  select '10002','家电类' union 
  select '10003','办公类' union 
  select '10004','通信类' 
  
  
--2、向部门信息表中插入测试数据
  insert into departmentinfotable(DepartmentId,DepartmentName)
  select '1001','研发部' union
  select '1002','销售部' union 
  select '1003','采购部' union 
  select '1004','售后服务部' union 
  select '1005','维修部' union 
  select '1007','内勤部' union
  select '1008','运输部'

--3、DiplomaInfoTable(学历信息表)

insert into diplomainfotable values ('博士后')
insert into diplomainfotable values('博士')
insert into diplomainfotable values('硕士')
insert into diplomainfotable values('学士')
insert into diplomainfotable values('大专')
insert into diplomainfotable values('高中')
insert into diplomainfotable values('中专')
insert into diplomainfotable values('初中')
insert into diplomainfotable values('小学')



--4、JobsInfoTable(职务信息表)

insert into jobsinfotable values('1001','总经理','负责公司战略规划')

insert into jobsinfotable values('1002','副总经理','辅助总经历工作')

insert into jobsinfotable values('1003','工程师','技术研发和实施支持')

insert into jobsinfotable values('1004','技术员',NULL)

insert into jobsinfotable values('1005','销售员',NULL)

insert into jobsinfotable values('1006','采购员',NULL)

insert into jobsinfotable values('1007','库管员',NULL)

insert into jobsinfotable values('1008','储备干部',NULL)

insert into jobsinfotable values('1009','售后服务员',NULL)

insert into jobsinfotable values('1010','汽车司机',NULL)

insert into jobsinfotable values('1011','清洁工','打扫卫生')




--5、GoodsLocationTable(商品在库区域表)
insert into goodslocationtable values ('1001','东一区')
insert into goodslocationtable values ('1002','东二区')
insert into goodslocationtable values ('1003','西三区')
insert into goodslocationtable values ('1004','南四区')
insert into goodslocationtable values ('1005','北五区')

--6、GoodsRowsTable(商品摆放排号表)
insert into goodsrowstable values ('1001','一排')
insert into goodsrowstable values ('1002','二排')
insert into goodsrowstable values ('1003','三排')
insert into goodsrowstable values ('1004','四排')
insert into goodsrowstable values ('1005','五排')


--7、GoodsSeatsTable(商品摆放座号表)
insert into goodsseatstable values ('1001','一号')
insert into goodsseatstable values ('1002','二号')
insert into goodsseatstable values ('1003','三号')
insert into goodsseatstable values ('1004','四号')
insert into goodsseatstable values ('1005','五号')




--8、StockRegionInfoTable(商品在库位置表)
insert into stockregioninfotable 
select 'k102','1号仓' union all
select 't101','2号仓' union all
select 'v121','4号仓' 




 --9、SupplyTable(供应商信息表)
insert into supplytable
select 'ck450','联华公司','张飞','山西河北','0291-8231','13772956942','0215481','[e-mail]','www.lianhua.com' union all
select 'wk230','树人公司','赵云','河北保定','0281-4851','12345789212','1245732','[e-mail]','www.zy.com' union all
select 'op789','惠普公司','刘备','山西凤阳','0912-1234','13245754845','0215214','[e-mail]','www.lb.com'





--10、EmployeeInfoTable(职员信息表)(注：DepartmentId，JobsId为外键)


insert into employeeinfotable values ('10003','苏长城','男',23,'410108198309110515','1983-12-14','初中','2001-12-11','河南省周口市','037163982910','13837178301',1,2)
insert into employeeinfotable values('10005','陈凯','男',24,'410108198309110515','1983-09-11','小学','2002-09-12','河南省郑州市惠济区','037163982910','13837178301',3,4)
insert into employeeinfotable values('10006','张冠军','男',25,'410108198309110511','2007-04-27','高中','2007-04-14','河南省平顶山市','037163982910','13837178301',4,3)
insert into employeeinfotable values('10007','冯杰','女',30,'410108198309110515','1982-04-23','大专','2003-07-18','河南省信阳市','037163982910','13837178301',2,1)
insert into employeeinfotable values('10008','程传林','男',25,'410108198209120516','1982-03-22','学士','2002-06-11','河南省信阳市','037163982910','13837178301',1,2)
insert into employeeinfotable values('10009','肖雷','男',25,'410108198309110519','1981-09-15','博士','2001-12-11','河南省鹤壁市','037163982910','13837178301',3,4)



--11、向车队信息表中插入测试数据
  insert into carteaminfotable(CarTeamId,CarTeamName,ChargeId)
  select '10005','第一车队',1 union 
  select '10006','第二车队',2 union 
  select '10007','第三车队',3 union 
  select '10008','第四车队',4 union 
  select '10009','第五车队',5 
  

  
--12、向车辆管理表中插入测试数据
 insert into carmanagetable(CardId,CarDriverId,CarTeamId) 
 select '豫ACC277',1,1 union 
 select '豫ADC200',2,2 union
 select '豫A87627',3,3  union
 select '豫B23147',4,4



--13、LoginTable (登陆管理表)(注：EmployeeId为外键)
insert into logintable values ('10001','赵鹏','admin','admin',1)
insert into logintable values ('10002','冯波','admin','admin',2)
insert into logintable values ('10003','王建委','admin','admin',3)
insert into logintable values ('10004','袁新峰','admin','superadmin',4)
insert into logintable values ('10005','田晓顺','admin','superadmin',5)
insert into logintable values ('10006','admin','admin','superadmin',5)



--14、MessageInfoTable(公告信息表)
insert into messageinfotable
select '10001',1,'我昨天晚上到的家','2007-04-25 14:41:11','有什么事情给我打电话好了！' union all
select '10002',2,'我是老张，最近工作有点忙！','2007-04-25 14:50:06','天天维护服务器，过两天我回学校请大家吃饭！' union all
select '10003',3,'快五一了兄弟们准备去哪里玩呀？','2007-04-29 15:23:55','我现在一直在家呆着，看书做设计！'



--15、TypeTable(商品型号信息表)
insert into typetable
select 'tc101','贵重物品',1 union all
select 'kc200','易碎物品',2 union all
select 'wx300','危险物品',3
 


--16、WareHouseInfoTable（仓储信息表）
insert into warehouseinfotable 
select '1001','1号仓',1,'东区' union all
select '1002','2号仓',2,'西区' union all
select '1003','3号仓',3,'北区' 


--17、GoodsInfoTable(商品信息表)(注：GoodsCateId、GoodsSupplyId、GoodsStockId、StockRegionId、TypeId为外键)

insert into goodsinfotable values ('10001','长虹34寸液晶彩电',1,1,'A','四川省','成都市',1,10000,30,'2005-04-20','2007-04-18','台',2)
insert into goodsinfotable values('10002','长虹普通25寸彩电',2,2,'A','四川省','成都市',2,2500,30,'2004-04-07','2004-06-16','台',3)
insert into goodsinfotable values('10003','长虹29寸平板彩电',3,3,'B','四川省','成都市',3,3000,20,'2004-06-17','2004-09-10','台',1)

  



---18、StockInInfoTable(入库单信息表) 
insert into stockininfotable 
select '10003','2007-04-29 15:31:50',1,2,20,1,2,'构建组合' union all
select '10005','2007-04-29 15:50:53',2,1,10,2,1,'张冠军于2007年4月29日录入长虹34寸液晶彩电10台，型号：SDET－23－4'



--19、StockOutInfoTable(出库单信息表)
insert into stockoutinfotable 
select '10001','2007-04-29 20:26:36',1,2,5,'波波',1,2,'陈凯于2007年4月29日提长虹34寸液晶彩电5台，型号为SDET-23-4,出库负责人苏长城。' union all
select '10002','2007-04-29 20:28:30',2,1,5,'甜甜',1,2,'出库电视机'