-- 向EmployeeInfo表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name='EmployeeInfo')
return


insert into EmployeeInfo values(22276128,'李洁飞','男',25,'441721199878548956','14562514455','广州','1990-12-24','会计')
insert into EmployeeInfo values(78549652,'李  洁','女',25,'441721199878548957','145625145','广州','1990-12-24','主管')
insert into EmployeeInfo values(78954655,'李洁飞','男',25,'441721199878548958','145625145','广州','1990-12-24','会计')
insert into EmployeeInfo values(54688786,'李  啊','女',35,'441721199878548959','145625145','广州','1990-12-24','打杂')
insert into EmployeeInfo values(75687537,'李  就','女',35,'441721199878548960','145625145','广州','1990-12-24','售货员')
insert into EmployeeInfo values(45757421,'李  看','女',24,'441721199878548961','145625145','广州','1990-12-24','管理员')
insert into EmployeeInfo values(45727645,'李  了','男',25,'441721199878548962','145625145','韶关','1990-12-24','经理')


-- 向User表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name = 'UserLogin')
return
insert into UserLogin values(38363660, 418218)
insert into UserLogin values(33027571, 19870530)

-- 向MemberInfo表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name='MemberInfo')
return

insert into Memberinfo values(33027572,'张  桑','男',25,'441721199811305545','145625145','广州','1990-12-24','45785678')
insert into Memberinfo values(33027573,'张  的','男',25,'441721199811305575','145625145','茂名','1990-12-24','45785679')


-- 向ProductInfo表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name='ProductInfo')
return
insert into ProductInfo values('ACC','空调泡沫清洁剂',75,64,'家居日用品')
insert into ProductInfo values('AF131','荟新芦荟滋养护色洗发露',38,32,'个人护理品')
insert into ProductInfo values('AF132','荟新去头屑洗发露',34,29,'个人护理品')
insert into ProductInfo values('AF231','荟新芦荟滋养护色润发乳',38,32,'个人护理品')
insert into ProductInfo values('AF232','荟新芦荟保湿修护润发乳',27,23,'个人护理品')
insert into ProductInfo values('AF301','荟新动感发胶',38,32,'个人护理品')
insert into ProductInfo values('AG','芦荟胶',38,32,'个人护理品')
insert into ProductInfo values('AG10','芦荟胶优惠套装（10支装）',330,281,'个人护理品')
insert into ProductInfo values('AG2','完美芦荟胶礼盒（2支装）',70,59,'个人护理品')
insert into ProductInfo values('AMP','完美芦荟矿物晶（瓶）',208,177,'健康食品')
insert into ProductInfo values('BC','丹参阿胶珍珠胶囊',285,242,'健康食品')
insert into ProductInfo values('CAC','空调汽车空调喷雾净',85,68,'家居日用品')
insert into ProductInfo values('CLD','芦荟超浓缩洗衣液',75,64,'家居日用品')
insert into ProductInfo values('CPT','玉米肽糙米胚芽片',380,323,'健康食品')
insert into ProductInfo values('CSO','压榨山茶籽油',298,180,'健康食品')
insert into ProductInfo values('DW','芦荟餐具洗洁精',45,38,'家居日用品')
insert into ProductInfo values('FAN01','清调补健康食品礼盒',823,700,'健康食品')
insert into ProductInfo values('FD30','完美高纤乐',170,145,'健康食品')
insert into ProductInfo values('FM30','完美高纤餐',135,115,'健康食品')
insert into ProductInfo values('FVR','芦荟蔬果洁净剂',26,22,'家居日用品')
insert into ProductInfo values('HT','低聚果糖沙棘茶（瓶）',220,187,'健康食品')
insert into ProductInfo values('HT30','低聚果糖沙棘茶（盒）',213,182,'健康食品')
insert into ProductInfo values('M5033','活肤眼霜',380,324,'玛丽艳特别护理')
insert into ProductInfo values('M6011','洁肤啫喱',203,173,'玛丽艳特别护理')
insert into ProductInfo values('M7033','护眼啫喱',280,239,'玛丽艳特别护理')
insert into ProductInfo values('M7034','紧肤精华露',480,410,'玛丽艳特别护理')
insert into ProductInfo values('M7035','活力精华露',480,410,'玛丽艳特别护理')
insert into ProductInfo values('M7037','美白精华露',560,478,'玛丽艳特别护理')
insert into ProductInfo values('M7041','黑泥面膜套装',528,451,'玛丽艳特别护理')
insert into ProductInfo values('M7043','脱角质霜',180,154,'玛丽艳特别护理')
insert into ProductInfo values('M8062','维E身体保湿乳',128,109,'玛丽艳特别护理')
insert into ProductInfo values('M8064','维E润手霜',63,54,'玛丽艳特别护理')
insert into ProductInfo values('M9031','按摩膏',318,271,'玛丽艳特别护理')
insert into ProductInfo values('MA110','润唇膏',76,64,'玛丽艳彩妆系')
insert into ProductInfo values('MA116','三色唇彩(炫彩亮)',120,84,'玛丽艳彩妆系')
insert into ProductInfo values('MA117','三色唇彩(魅力金)',120,84,'玛丽艳彩妆系')
insert into ProductInfo values('MA118','三色唇彩(粉蔷薇)',120,84,'玛丽艳彩妆系')
insert into ProductInfo values('MA119','唇彩（百合粉）',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA120','唇彩（淡彩粉）',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA121','唇膏(梅花粉)',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA122','唇膏(蜜桃红)',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA123','唇膏(牡丹红)',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA124','唇膏(玫瑰红)',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA125','唇膏(珠光紫)',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA126','唇彩（草紫红）',130,91,'玛丽艳彩妆系')
insert into ProductInfo values('MA3','敏感修护套装',488,417,'玛丽艳敏感品')
insert into ProductInfo values('MA3011','敏感洁肤霜',160,137,'玛丽艳敏感品')
insert into ProductInfo values('MA3021','敏感柔肤水',180,154,'玛丽艳敏感品')
insert into ProductInfo values('MA3032','敏感修护乳',228,195,'玛丽艳敏感品')
insert into ProductInfo values('MA3033','敏感修护晚霜',298,255,'玛丽艳敏感品')
insert into ProductInfo values('MA3041','敏感修护面膜',238,202,'玛丽艳敏感品')
insert into ProductInfo values('MA5','滋润套装',488,417,'玛丽艳滋润品')
insert into ProductInfo values('MA5011','柔和洁肤乳',168,144,'玛丽艳滋润品')
insert into ProductInfo values('MA5021','滋润爽肤水',168,144,'玛丽艳滋润品')
insert into ProductInfo values('MA5031','深层保湿日霜',298,255,'玛丽艳滋润品')
insert into ProductInfo values('MA5032','活细胞晚霜',348,297,'玛丽艳滋润品')
insert into ProductInfo values('MA5041','润肤面膜',238,203,'玛丽艳滋润品')
insert into ProductInfo values('MA6','清爽套装',488,417,'玛丽艳清爽系')
insert into ProductInfo values('MA6012','清爽洁面乳',180,154,'玛丽艳清爽系')
insert into ProductInfo values('MA6022','清爽紧肤水',180,154,'玛丽艳清爽系')
insert into ProductInfo values('MA6033','清爽凝胶',203,173,'玛丽艳清爽系')
insert into ProductInfo values('MA6034','平衡晚霜',280,239,'玛丽艳清爽系')
insert into ProductInfo values('MA6035','平衡修护液',145,124,'玛丽艳特别护')
insert into ProductInfo values('MA6042','深层洁肤面膜',248,211,'玛丽艳清爽系')
insert into ProductInfo values('MA7031','防晒美白润肤霜',226,193,'玛丽艳特别护')
insert into ProductInfo values('MA901','俏丽女士香水',490,319,'玛丽艳彩妆系')
insert into ProductInfo values('MA902','经典女士香水',590,384,'玛丽艳彩妆系')
insert into ProductInfo values('MA903','活力男士香水',490,319,'玛丽艳彩妆系')
insert into ProductInfo values('MA904','魅力男士香水',590,384,'玛丽艳彩妆系')
insert into ProductInfo values('MPC','芦荟多用途清洁剂 ',45,38,'家居日用品')
insert into ProductInfo values('NB','完美营养餐（罐）',173,147,'健康食品')
insert into ProductInfo values('NB30','完美营养餐（盒）',145,123,'健康食品')
insert into ProductInfo values('OLI','活立多健肠口服液',185,157,'健康食品')
insert into ProductInfo values('OLS','完美活立多牌一生糖',98,79,'健康食品')
insert into ProductInfo values('PM','芦荟喷雾口香剂',26,22,'个人护理品')
insert into ProductInfo values('PM15','口香剂优惠套装',330,281,'个人护理品')
insert into ProductInfo values('PSG','完美沙蒜软胶囊（瓶）',355,300,'健康食品')
insert into ProductInfo values('PSG2','完美沙蒜软胶囊（盒）',690,588,'健康食品')
insert into ProductInfo values('PSN','肽藻营养粉（罐）',485,412,'健康食品')
insert into ProductInfo values('PSN30','肽藻营养粉（盒）',485,412,'健康食品')
insert into ProductInfo values('RSG','荟新芦荟舒洁沐浴露（瓶）',60,51,'个人护理品')
insert into ProductInfo values('RW','完美法国兰红葡萄酒',188,150,'健康食品')
insert into ProductInfo values('SG20','芦荟沐浴露轻便装',20,17,'个人护理品')
insert into ProductInfo values('TPP','芦荟牙膏套装（早晚装）',57,48,'个人护理品')



-- 向ProductToInfo表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name='ProductToInfo')
return
insert into ProductToInfo values ('TPP',57,'2010-10-10','张德艺')
insert into ProductToInfo values ('MPC',12,'2011-11-10','张德艺')
insert into ProductToInfo values ('SG20',47,'2010-10-10','张秀虹')
insert into ProductToInfo values ('RW',7,'2001-10-10','张德艺')
insert into ProductToInfo values ('TPP',5,'2011-10-10','张德艺')
insert into ProductToInfo values ('TPP',7,'2010-08-10','张德艺')
insert into ProductToInfo values ('PSN30',57,'2012-10-10','张德艺')
insert into ProductToInfo values ('TPP',57,'2010-10-10','张秀红')
insert into ProductToInfo values ('TPP',12,'2013-06-10','张德艺')
insert into ProductToInfo values ('NB',57,'2012-10-10','张德艺')
insert into ProductToInfo values ('TPP',57,'2010-10-10','张小俊')
insert into ProductToInfo values ('TPP',45,'2010-10-10','张德艺')
insert into ProductToInfo values ('MA6034',57,'2011-10-10','张德艺')
insert into ProductToInfo values ('TPP',57,'2010-10-10','张德艺')
insert into ProductToInfo values ('TPP',7,'2013-06-10','徐荣获')
insert into ProductToInfo values ('OLI',10,'2012-10-10','张德艺')
insert into ProductToInfo values ('TPP',57,'2010-10-10','张德艺')
insert into ProductToInfo values ('MA5032',11,'2011-10-10','小  孟')



-- 向Stcok表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name='Stcok')
return

-- 数量初始化为0
insert into Stcok values('ACC',0)
insert into Stcok values('AF131',0)
insert into Stcok values('AF132',0)
insert into Stcok values('AF231',0)
insert into Stcok values('AF232',0)
insert into Stcok values('AF301',0)
insert into Stcok values('AG',0)
insert into Stcok values('AG10',0)
insert into Stcok values('AG2',0)
insert into Stcok values('AMP',0)
insert into Stcok values('BC',0)
insert into Stcok values('CAC',0)
insert into Stcok values('CLD',0)
insert into Stcok values('CPT',0)
insert into Stcok values('CSO',0)
insert into Stcok values('DW',0)
insert into Stcok values('FAN01',0)
insert into Stcok values('FD30',0)
insert into Stcok values('FM30',0)
insert into Stcok values('FVR',0)
insert into Stcok values('HT',0)
insert into Stcok values('HT30',0)
insert into Stcok values('M5033',0)
insert into Stcok values('M6011',0)
insert into Stcok values('M7033',0)
insert into Stcok values('M7034',0)
insert into Stcok values('M7035',0)
insert into Stcok values('M7037',0)
insert into Stcok values('M7041',0)
insert into Stcok values('M7043',0)
insert into Stcok values('M8062',0)
insert into Stcok values('M8064',0)
insert into Stcok values('M9031',0)
insert into Stcok values('MA110',0)
insert into Stcok values('MA116',0)
insert into Stcok values('MA117',0)
insert into Stcok values('MA118',0)
insert into Stcok values('MA119',0)
insert into Stcok values('MA120',0)
insert into Stcok values('MA121',0)
insert into Stcok values('MA122',0)
insert into Stcok values('MA123',0)
insert into Stcok values('MA124',0)
insert into Stcok values('MA125',0)
insert into Stcok values('MA126',0)
insert into Stcok values('MA3',0)
insert into Stcok values('MA3011',0)
insert into Stcok values('MA3021',0)
insert into Stcok values('MA3032',0)
insert into Stcok values('MA3033',0)
insert into Stcok values('MA3041',0)
insert into Stcok values('MA5',0)
insert into Stcok values('MA5011',0)
insert into Stcok values('MA5021',0)
insert into Stcok values('MA5031',0)
insert into Stcok values('MA5032',0)
insert into Stcok values('MA5041',0)
insert into Stcok values('MA6',0)
insert into Stcok values('MA6012',0)
insert into Stcok values('MA6022',0)
insert into Stcok values('MA6033',0)
insert into Stcok values('MA6034',0)
insert into Stcok values('MA6035',0)
insert into Stcok values('MA6042',0)
insert into Stcok values('MA7031',0)
insert into Stcok values('MA901',0)
insert into Stcok values('MA902',0)
insert into Stcok values('MA903',0)
insert into Stcok values('MA904',0)
insert into Stcok values('MPC',0)
insert into Stcok values('NB',0)
insert into Stcok values('NB30',0)
insert into Stcok values('OLI',0)
insert into Stcok values('OLS',0)
insert into Stcok values('PM',0)
insert into Stcok values('PM15',0)
insert into Stcok values('PSG',0)
insert into Stcok values('PSG2',0)
insert into Stcok values('PSN',0)
insert into Stcok values('PSN30',0)
insert into Stcok values('RSG',0)
insert into Stcok values('RW',0)
insert into Stcok values('SG20',0)
insert into Stcok values('TPP',0)


-- 向SellInfo(销售信息表)表中插入数据，先判断表是否存在，如果表不存在则跳出插入操作
if not exists(select * from sysobjects where name='SellInfo')
return

insert into SellInfo values('ACC',1, '2010-01-01 10:30:20')
insert into SellInfo values('AF131',3, '2010-02-11 14:30:20')
insert into SellInfo values('AF132',2, '2010-03-01 13:30:20')
insert into SellInfo values('AF231',2, '2010-04-21 10:30:20')
insert into SellInfo values('AF232',2, '2010-05-01 16:30:20')
insert into SellInfo values('AF301',2, '2010-06-15 10:30:20')
insert into SellInfo values('AG',4, '2011-01-07 10:30:20')
insert into SellInfo values('AG10',2, '2011-01-01 10:30:20')
insert into SellInfo values('AG2',2, '2011-02-01 10:30:20')
insert into SellInfo values('AMP',2, '2011-03-01 10:30:20')
insert into SellInfo values('BC',2, '2011-04-01 10:30:20')
insert into SellInfo values('CAC',6, '2011-05-01 10:30:20')
insert into SellInfo values('CLD',2, '2011-06-01 10:30:20')
insert into SellInfo values('CPT',2, '2011-07-01 10:30:20')
insert into SellInfo values('CSO',2, '2011-08-01 10:30:20')
insert into SellInfo values('DW',1, '2011-09-01 10:30:20')
insert into SellInfo values('FAN01',2, '2011-10-01 10:30:20')
insert into SellInfo values('FD30',2, '2011-11-01 10:30:20')
insert into SellInfo values('FM30',2, '2011-12-01 10:30:20')
insert into SellInfo values('FVR',2, '2012-01-01 10:30:20')
insert into SellInfo values('HT',2, '2012-02-01 10:30:20')
insert into SellInfo values('HT30',2, '2012-03-01 10:30:20')
insert into SellInfo values('M5033',2, '2012-04-01 10:30:20')
insert into SellInfo values('M6011',2, '2012-05-01 10:30:20')
insert into SellInfo values('M7033',3, '2012-06-01 10:30:20')
insert into SellInfo values('M7034',2, '2012-07-01 10:30:20')
insert into SellInfo values('M7035',2, '2012-08-01 10:30:20')
insert into SellInfo values('M7037',2, '2012-09-01 10:30:20')
insert into SellInfo values('M7041',2, '2012-10-01 10:30:20')
insert into SellInfo values('M7043',2, '2012-11-01 10:30:20')
insert into SellInfo values('M8062',2, '2012-12-01 10:30:20')
insert into SellInfo values('M8064',2, '2013-01-01 10:30:20')
insert into SellInfo values('M9031',4, '2013-02-01 10:30:20')
insert into SellInfo values('MA110',2, '2013-03-01 10:30:20')
insert into SellInfo values('MA116',2, '2013-04-01 10:30:20')
insert into SellInfo values('MA117',2, '2013-05-01 10:30:20')
insert into SellInfo values('MA118',2, '2013-06-01 10:30:20')
insert into SellInfo values('MA119',2, '2013-07-01 10:30:20')
insert into SellInfo values('MA120',2, '2013-08-01 10:30:20')
insert into SellInfo values('MA121',2, '2013-09-01 10:30:20')
insert into SellInfo values('MA122',6, '2013-10-01 10:30:20')
insert into SellInfo values('MA123',2, '2013-11-01 10:30:20')
insert into SellInfo values('MA124',2, '2013-12-01 10:30:20')
insert into SellInfo values('MA125',2, '2013-01-01 10:30:20')