createglobaltoyzobjects.sql

程序源码~~关于SQL的源码

	cPhone		char(15)
)
go


/* pick of the month */
raiserror('Creating Table PickOfMonth....',0,1)
create table PickOfMonth
(
	cToyId 		char(6)REFERENCES Toys(cToyId), /* foreign key to toy table */
	siMonth		smallint,
	iYear		int,
	iTotalSold	int,
	constraint POM_PK primary key(cToyId,siMonth,iYear)
)
go


/*****************************************************/
-- Populating data into the tables
/********************/
insert into Category values('001','Activity','Activity toys encourage the childs social skills and interest in the world around them.')
insert into Category values('002','Dolls','A wide range of dolls from all the leading brands.')
insert into Category values('003','Arts And Crafts','Encourage children to create masterpieces with these incredible craft kits.')
insert into Category values('004','Games','A complete range of new and classic games.')
insert into Category values('005','Cars N Racing','Models of all current and vintage cars.')
insert into Category values('006','Pretend Play','These games can play an important part in the childs development.') /* Children can use these tools they need to play out their dreams.') */
insert into Category values('007','Model Kits','Models to build planes, cars, ships and much more.')
insert into Category values('008','Infant','Colorful, interactive toys for babies.')
insert into Category values('009','Stuffed Toys','Teddy bears, monkeys and many more soft toys.')
insert into Category values('010','Learning','Designed to make learning so much fun that children will forget they are learning at the same time')
insert into Category values('011','Science and Nature','Toys which encourage children to explore the world around them.')
insert into Category values('012','Musical toys','These toys generate music, sound and songs too.')
insert into Category values('013','Electronic','These are electronic toys, which run using batteries.')
insert into Category values('014','Puppets','These are puppet toys.')
insert into Category values('015','Trains','These trains will be the pride of any railway system.')
insert into Category values('016','Construction Toys','Bricks, building and other toys the will encourage children to build model houses and buildings.')
/* data for wrapper  */
insert into Wrapper values('001','Geckos',1,null,null)
insert into Wrapper values('002','Baby blocks',1.25,null,null)
insert into Wrapper values('003','Stars',1.50,null,null)
insert into Wrapper values('004','Bubbles',2,null,null)
insert into Wrapper values('005','Sesame street',1.5,null,null)
insert into Wrapper values('006','Moon',2.25,null,null)
insert into Wrapper values('007','Sea',1,null,null)
insert into Wrapper values('008','Sky',1,null,null)

/*        toy brand  */
INSERT INTO ToyBrand values('001','Bobby ')
INSERT INTO ToyBrand values('002','Frances-Price')
INSERT INTO ToyBrand values('003','The Bernie Kids')
INSERT INTO ToyBrand values('004','Largo')
INSERT INTO ToyBrand values('005','LAMOBIL')
INSERT INTO ToyBrand values('006','Crazy World')
INSERT INTO ToyBrand values('007','Brevet')
INSERT INTO ToyBrand values('008','Darden')

/* data for country  */
insert into Country values('001','United states of America')
insert into Country values('002','Albania')
insert into Country values('003','Andorra')
insert into Country values('004','Argentina')
insert into Country values('005','Austria')
insert into Country values('006','Bangladesh')
insert into Country values('007','Belgium')
insert into Country values('008','Bosnia & Herzegovina')
insert into Country values('009','Bulgaria')
insert into Country values('010','Czech Republic')
insert into Country values('011','Denmark')
insert into Country values('012','Yugoslavia ')
insert into Country values('013','France')
insert into Country values('014','Gibraltar')
insert into Country values('015','Greece')
insert into Country values('016','Georgia')
insert into Country values('017','Croatia')
insert into Country values('018','Estonia')
insert into Country values('019','Iceland')
insert into Country values('020','Italy')
insert into Country values('021','Israel')
insert into Country values('022','India')
insert into Country values('023','Cyprus')
insert into Country values('024','Russia')
insert into Country values('025','Liechtenstein')
insert into Country values('027','Lithuania')
insert into Country values('028','Luxembourg')
insert into Country values('030','Malta')
insert into Country values('031','Moldova')
insert into Country values('032','Monaco')
insert into Country values('033','Netherlands')
insert into Country values('034','Norway')
insert into Country values('035','Poland')
insert into Country values('036','Portugal')
insert into Country values('037','Romania')
insert into Country values('038','San Marino')
insert into Country values('039','Slovak Republic')
insert into Country values('040','Slovenia')
insert into Country values('041','Finland')
insert into Country values('042','Spain')
insert into Country values('043','Switzerland')
insert into Country values('044','Turkey')
insert into Country values('045','Ukraine')
insert into Country values('046','Hungary')
insert into Country values('047','Germany')
insert into Country values('048','Sweden')
insert into Country values('049','Latvia')
/* data into shippingmode  */
insert into ShippingMode values('01','Standard Shipping',4)
insert into ShippingMode values('02','World Mail',3)
insert into ShippingMode values('03','International Priority',1)
/* shipping rate  */
insert into ShippingRate values('001','01',2)
insert into ShippingRate values('001','02',4)
insert into ShippingRate values('001','03',10)
insert into ShippingRate values('002','01',03)
insert into ShippingRate values('002','02',06)
insert into ShippingRate values('002','03',10)
insert into ShippingRate values('003','01',04)
insert into ShippingRate values('003','02',06)
insert into ShippingRate values('003','03',12)
insert into ShippingRate values('004','01',04)
insert into ShippingRate values('004','02',08)
insert into ShippingRate values('004','03',12)
insert into ShippingRate values('005','01',04)
insert into ShippingRate values('005','02',08)
insert into ShippingRate values('005','03',12)
insert into ShippingRate values('006','01',04)
insert into ShippingRate values('006','02',08)
insert into ShippingRate values('006','03',12)
insert into ShippingRate values('007','01',04)
insert into ShippingRate values('007','02',06)
insert into ShippingRate values('007','03',10)
insert into ShippingRate values('008','01',04)
insert into ShippingRate values('008','02',05)
insert into ShippingRate values('008','03',08)
insert into ShippingRate values('009','01',10)
insert into ShippingRate values('009','02',12)
insert into ShippingRate values('009','03',15)
insert into ShippingRate values('010','01',10)
insert into ShippingRate values('010','02',12)
insert into ShippingRate values('010','03',15)

/*data into shopper  */
insert into shopper values('000001','angels','Angela','Smith','[e-mail]','16223 Radiance Court','Woodbridge','Virginia','001','22191','227-2344','6947343412896785','Master Card','08/09/2001')
insert into shopper values('000002','guide','Barbara','Johnson','[e-mail]','227 Beach Ave.','Sunnyvale','California','001','94087-1147','123-5673','5345146765854356','Master Card','04/10/2001')
insert into shopper values('000003','youbet','Betty','Williams','[e-mail]','1 Tread Road','Virginia Beach','Varginia','001','23455','458-3299','4747343412896785','Visa Card','12/12/2001')
insert into shopper values('000004','credit','Carol','Jones','[e-mail]','765 - Furling Road Apt 112  ','Boone','North Carolina','001','28607','678-4544','6344676854335436','Visa Card','10/12/2001')
insert into shopper values('000005','prepare','Catherine','Roberts','[e-mail]','5508 Aquiline Court','San Jose','California','001','95123','445-2256','3756784562869963','Master Card','09/10/2001')
insert into shopper values('000006','Char','Charles','Brown','[e-mail]','7822 S. Glitzy Avenue ','Maitland','Florida','001','32751','225-6678','3454678545443344','Visa Card','10/09/2001')
insert into shopper values('000007','chris','Christopher','Davis','[e-mail]','4896 11th ST  ','Hill Avenue','Utah','001','84056-5410','556-9087','7899887675443322','Visa Card','10/02/2001')
insert into shopper values('000008','mills','Cynthia','Miller','cynthiam@qmailcom','98066 Weary Storm Street','Moon Park ','California','001','93021-2930','422-5688','2345566576879900','Master Card','08/09/2001')
insert into shopper values('000009','gotcha','Daniel','Wilson','[e-mail]','4642 Peripheral Drive  ','Brecksville','Ohio','001','44141','454-2246','2345467890986745','Visa Card','11/02/2001')
insert into shopper values('000010','bingo','David','Moore','[e-mail]','8808 Joviality Drive   ','San Ramon','California','001','94583','982-5577','2343556678799674','Visa Card','11/12/2001')
insert into shopper values('000011','chubby','Deborah','Taylor','[e-mail]','2199- Fairfax Drive ','Libertyville','Illinois','001','60048','889-2235','2345468798078563','Master Card','11/23/2001')
insert into shopper values('000012','smile','Donna','Anderson','[e-mail] ','7930 Orange St. ','Las Vegas','Nevada','001','89117','845-2323','2314345676568766','Visa Card','11/24/2001')
insert into shopper values('000013','benhur','Dorothy','Thomas','[e-mail]','678 East 56th Street- #12','New York','New York','001','10009','696-2278','8765435456678754','Visa Card','12/03/2001')
insert into shopper values('000014','benjy','Elizabeth','Jackson','[e-mail]','598 Apex Avenue #2','Saint Paul ','Minnesota','001','55102','545-9078','4576544354567542','Visa Card','10/06/2001')
insert into shopper values('000015','sundance','Frances','Turner         ','[e-mail]','2562 Eastwood  ','Denton','Texas','001','76205-5922','878-6670','5676879007565452','Master Card','08/30/2001')
insert into shopper values('000016','bopeep','Helen','White','[e-mail]','Fleet Street','Point Pleasant','Pennsylvania','001','18950 ','585-7796','4564564564564565','Visa Card','10/10/2001')
insert into shopper values('000017','momma','James','Harris',' [e-mail]','3456 Mt. Regale Drive  ','1509 Alexandria','Virginia','001','22303-2541','335-6678','4657567545344544','Master Card','10/31/2001')
insert into shopper values('000018','grumpy','Jennifer','Martin','[e-mail]','9812  76th Street  ','Brooklyn','Maryland','001','21225','569-7789','9775445343233443','Visa Card','09/01/2001')
insert into shopper values('000019','patch','Jessica','Thompson','[e-mail]','565 Pebble St. ','Arlington','Texas','001','76014','445-6797','9766545343233455','Master Card','09/19/2001')
insert into shopper values('000020','sunshine','John','Garcia','[e-mail]','2234 B King Henry Drive ','Harrisburg','Pennsylvania','001','17109','521-9095','8764554334534567','Master Card','09/13/2001')
insert into shopper values('000021','good','Joseph','Martinez','[e-mail]','995 Rind Street ','Loma Linda','California','001','92354','456-9032','5687567567435344','Visa Card','05/31/2001')
insert into shopper values('000022','nestle','Joyce','Phillips','[e-mail]','535 Darwin Avenue ','Bridgeville','Pennsylvania','001','15017','789-6905','2345345345645656','Master Card','09/15/2001')
insert into shopper values('000023','hangon','Karen','Robinson','[e-mail]','2343-A Flowers Ferry Road    ','Marietta','Georgia','001','30067','334-5568','4546575675687689','Visa Card','02/26/2000')
insert into shopper values('000024','rumble','Kimberly','Clark','[e-mail]','79 Holler Valley Road ','Little Rock','Arkansas','001','72204','645-9023','2345653757898999','Master Card','05/31/2000')
insert into shopper values('000025','noddy','Laura','Rodriguez','[e-mail]','3242 Limestone','WayMarietta','Georgia','001','30062','567-3345','2345345676786543','Visa Card','03/03/2000')
insert into shopper values('000026','falcon','Linda','Lewis','[e-mail]','1524 Patagonia Lane ','Plano','Texas','001','75075','459-4563','8765434523543366','Visa Card','03/14/2000')
insert into shopper values('000027','lazer','Lisa','Lee','[e-mail]','18927 Sandstone Ave N ','Seattle','Washington','001','98133','897-3345','7653534745756567','Master Card','08/30/2001')
insert into shopper values('000028','spartan','Margaret','Walker','[e-mail]','405 SE Aden #101 ','Pullman','Washington','001','99163','567-9083','9867865434534467','Master Card','07/09/2001')
insert into shopper values('000029','zedi','Maria','Hall','[e-mail]','936 Midland Drive