data.sql

超市的管理与及时的维护

insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('百事','add1','06124')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('长虹','add2','32564')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('青岛啤酒','add3','54876')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('蒙牛','add4','69875')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('徐福记','add5','23456')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('a','add1','06124')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('b','add2','32564')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('c','add3','54876')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('d牛','add4','69875')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('e','add5','23456')

insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('A1','address1','72531')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('A2','address2','75643')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('B1','address3','73689')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('B2','address4','78132')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('C1','address5','71359')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('D1','address55','725531')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('E2','address6','756343')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('F1','address7','731689')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('G2','address8','781632')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('H1','address9','713529')

insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch1',2,'1359','100',20,'1000001',1,'2005.3.10','2005.4.10','0','1','7','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch2',4,'280','40',20,'1000002',3,'2005.2.15','2005.3.15','0','1','8','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch3',150,'90','10',20,'1000003',105,'2005.5.10','2005.7.10','0','1','4','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch4',3500,'200','20',20,'1000004',2888,'2005.3.01','2005.5.31','0','1','8','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch6',12000,'80','10',20,'1000006',10000,'2005.7.01','2005.8.31','0','1','8','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch8',5,'2000','100',20,'1000008','0','1','7','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch9',50,'690','50',20,'1000009',38,'2005.3.10','2005.4.20','0','1','9','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch10',8,'2800','100',20,'1000010',6.5,'2005.5.10','2005.7.10','0','1','3','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch11',12,'15','50',20,'1000011','0','1','7','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch12',6,'1800','100',20,'1000012',4.5,'2005.5.10','2005.7.10','0','1','6','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch13',5,'2000','100',20,'1000013','0','0','9','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch15',8888,'300','50',20,'1000015',6999,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch16',60,'700','50',20,'1000016',55,'2005.6.01','2005.8.31','1','1','9','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch18',50,'900','100',20,'1000018',45,'2005.3.10','2005.5.30','1','1','7','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch19',8,'2000','150',20,'1000019','1','1','7','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch20',22,'500','100',20,'1000020',18,'2005.7.10','2005.8.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch21',2500,35,50,20,'1000021','1','1','8','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch22',55,'500','80',20,'1000022',50,'2005.6.10','2005.7.31','1','1','9','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch23',30,'1000','100',20,'1000023',26,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch24',9,'1500','100',20,'1000024',6,'2005.8.10','2005.9.30','1','1','8','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch25',6,'2000','150',20,'1000025',5,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch26',400,'500','50',20,'1000026','1','1','8','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch27',80,'300','50',20,'1000027',70,'2005.4.10','2005.5.15','1','1','7','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch28',280,'500','100',20,'1000028',260,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch29',48,'800','50',20,'1000029',40,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch30',6888,'300','50',20,'1000030',5999,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch31',68,'800','100',20,'1000031',59,'2005.7.10','2005.8.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch32',9,'1300','100',20,'1000032',7,'2005.4.10','2005.7.31','1','1','9','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch33',80,'900','50',20,'1000033',68,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch35',2888,'300','50',20,'1000035',2000,'2005.6.10','2005.7.31','1','1','8','5')

insert Member(MemberCard,TotalCost,RegDate) values('2003007',2000,'2003.5.30')
insert Member(MemberCard,TotalCost,RegDate) values('2004007',1000,'2004.6.01')
insert Member(MemberCard,TotalCost,RegDate) values('2005135',5000,'2005.2.15')
insert Member(MemberCard,TotalCost,RegDate) values('2005246',1500,'2005.3.10')
insert Member(MemberCard,TotalCost,RegDate) values('2005357',6888,'2005.6.20')

insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.3.20','200',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('6','2005.3.25','1',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('8','2005.3.26','280',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('9','2005.3.22','50',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.20','68',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('16','2005.4.25','20',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.28','55',1.5)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.30','35',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('27','2005.5.15','20',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.6.20','10',2)

insert [User] values('Admin','21232F297A57A5A743894A0E4A801FC3',4)
insert [User] values('赖秋林','9D607A663F3E9B0A90C3C8D4426640DC',2)
insert [User] values('阿年','894F782A148B33AF1E39A0EFED952D69',3)
insert [User] values('凌聪','8A8BB7CD343AA2AD99B7D762030857A2',1)
insert [User] values('翁炎泉','693A9FDD4C2FD0700968FBA0D07FF3C0',1)

insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(200,'2003-3-20','2003007','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(12000,'2003-3-25','','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(40,'2004-3-26','2005135','')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(150,'2004-3-22','','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(60,'2005-4-20','2005246','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(300,'2005-4-25','','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(200,'2005-4-28','2004007','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(90,'2005-8-15','2003007','')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(240,'2005-9-2','2005135','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(160,'2005-9-7','2003007','')