petstore.sql

仿照著名的petstore写的网上书店

INSERT INTO Address VALUES('23', '25th St &  Dolores St', '', 'San Francisco','CA','94114',37.75013,-122.424782);
INSERT INTO Address VALUES('24', 'Ellis St & National Ave', '', 'Mountain view','CA','94043',37.40094,-122.052272);
INSERT INTO Address VALUES('25', '1st St & Market St ', '', 'San Francisco','CA','94105',37.791028,-122.399082);
INSERT INTO Address VALUES('26', 'San Antonio Rd & Middlefield Rd', '', 'Palo Alto','CA','94303',37.416239,-122.103474);
INSERT INTO Address VALUES('27', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('28', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('29', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('30', 'Leavesley Rd & Monterey Rd', '', 'Gilroy','CA','95020',37.019447,-121.574953);
INSERT INTO Address VALUES('31', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('32', 'Millbrae Ave &  Willow Ave', '', 'Millbrae ','CA','94030',37.596635,-122.391083);
INSERT INTO Address VALUES('33', 'Cesar Chavez St & Sanchez', '', 'San Francisco','CA','94131',37.74753,-122.428982);
INSERT INTO Address VALUES('34', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);
INSERT INTO Address VALUES('35', 'Bay Street and Columbus Ave ', '', 'San Francisco','CA','94133',37.805328,-122.416882);
INSERT INTO Address VALUES('36', 'Telegraph Ave & Bancroft Way', '', 'Berkeley','CA','94704',37.868825,-122.25978);
INSERT INTO Address VALUES('37', '1st St & Market St ', '', 'San Francisco','CA','94105',37.791028,-122.399082);
INSERT INTO Address VALUES('38', 'San Antonio Rd & Middlefield Rd', '', 'Palo Alto','CA','94303',37.416239,-122.103474);
INSERT INTO Address VALUES('39', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('40', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('41', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('42', '4th St & Howard St', '', 'San Francisco','CA','94103',37.783229,-122.402582);
INSERT INTO Address VALUES('43', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('44', 'Campbell St & Riverside Ave', '', 'Santa Cruz','CA','95060',36.96985,-122.019473);
INSERT INTO Address VALUES('45', 'Cesar Chavez St & Sanchez', '', 'San Francisco','CA','94131',37.74753,-122.428982);
INSERT INTO Address VALUES('46', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);
INSERT INTO Address VALUES('47', 'W el Camino Real & S Mary Ave', '', 'Sunnyvale','CA','94087',37.371641,-122.048772);
INSERT INTO Address VALUES('48', 'Telegraph Ave & Bancroft Way', '', 'Berkeley','CA','94704',37.868825,-122.25978);
INSERT INTO Address VALUES('49', '1st St & Market St ', '', 'San Francisco','CA','94105',37.791028,-122.399082);
INSERT INTO Address VALUES('50', 'San Antonio Rd & Middlefield Rd', '', 'Palo Alto','CA','94303',37.416239,-122.103474);
INSERT INTO Address VALUES('51', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('52', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('53', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('54', '4th St & Howard St', '', 'San Francisco','CA','94103',37.783229,-122.402582);
INSERT INTO Address VALUES('55', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('56', 'W el Camino Real & S Mary Ave', '', 'Sunnyvale','CA','94087',37.371641,-122.048772);
INSERT INTO Address VALUES('57', 'Campbell St & Riverside Ave', '', 'Santa Cruz','CA','95060',36.96985,-122.019473);
INSERT INTO Address VALUES('58', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);
INSERT INTO Address VALUES('59', 'Bay Street and Columbus Ave ', '', 'San Francisco','CA','94133',37.805328,-122.416882);
INSERT INTO Address VALUES('60', 'Telegraph Ave & Bancroft Way', '', 'Berkeley','CA','94704',37.868825,-122.25978);
INSERT INTO Address VALUES('61', 'San Antonio Rd & Middlefield Rd', '', 'Palo Alto','CA','94303',37.416239,-122.103474);
INSERT INTO Address VALUES('62', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('63', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('64', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('65', 'W el Camino Real & S Mary Ave', '', 'Sunnyvale','CA','94087',37.371641,-122.048772);
INSERT INTO Address VALUES('66', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('67', 'Millbrae Ave &  Willow Ave', '', 'Millbrae ','CA','94030',37.596635,-122.391083);
INSERT INTO Address VALUES('68', 'Cesar Chavez St & Sanchez', '', 'San Francisco','CA','94131',37.74753,-122.428982);
INSERT INTO Address VALUES('69', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);
INSERT INTO Address VALUES('70', 'Bay Street and Columbus Ave ', '', 'San Francisco','CA','94133',37.805328,-122.416882);
INSERT INTO Address VALUES('71', 'Leavesley Rd & Monterey Rd', '', 'Gilroy','CA','95020',37.019447,-121.574953);
INSERT INTO Address VALUES('72', 'Campbell St & Riverside Ave', '', 'Santa Cruz','CA','95060',36.96985,-122.019473);
INSERT INTO Address VALUES('73', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('74', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('75', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('76', '4th St & Howard St', '', 'San Francisco','CA','94103',37.783229,-122.402582);
INSERT INTO Address VALUES('77', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('78', 'Millbrae Ave &  Willow Ave', '', 'Millbrae ','CA','94030',37.596635,-122.391083);
INSERT INTO Address VALUES('79', 'Campbell St & Riverside Ave', '', 'Santa Cruz','CA','95060',36.96985,-122.019473);
INSERT INTO Address VALUES('80', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);
INSERT INTO Address VALUES('81', 'Grant Rd & South Dr ', '', 'Mountain view','CA','94040',37.366941,-122.078073);
INSERT INTO Address VALUES('82', 'Telegraph Ave & Bancroft Way', '', 'Berkeley','CA','94704',37.868825,-122.25978);
INSERT INTO Address VALUES('83', 'San Antonio Rd & Middlefield Rd', '', 'Palo Alto','CA','94303',37.416239,-122.103474);
INSERT INTO Address VALUES('84', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('85', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('86', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('87', '4th St & Howard St', '', 'San Francisco','CA','94103',37.783229,-122.402582);
INSERT INTO Address VALUES('88', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('89', 'Millbrae Ave &  Willow Ave', '', 'Millbrae ','CA','94030',37.596635,-122.391083);
INSERT INTO Address VALUES('90', 'Paseo Padre Pky & Fremont Blvd', '', 'Fremont','CA','94555',37.575035,-122.041273);
INSERT INTO Address VALUES('91', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);
INSERT INTO Address VALUES('92', 'El Camino Real & Scott Blvd', '', 'Santa Clara','CA','95050',37.352141 ,-121.959569);
INSERT INTO Address VALUES('93', 'Telegraph Ave & Bancroft Way', '', 'Berkeley','CA','94704',37.868825,-122.25978);
INSERT INTO Address VALUES('94', 'San Antonio Rd & Middlefield Rd', '', 'Palo Alto','CA','94303',37.416239,-122.103474);
INSERT INTO Address VALUES('95', '20th St &  Dolores St', '', 'San Francisco','CA','94114',37.75823,-122.425582);
INSERT INTO Address VALUES('96', 'River Oaks Pky & Village Center Dr', '', 'San Jose','CA','95134',37.398259,-121.922367);
INSERT INTO Address VALUES('97', 'Dolores St &  San Jose Ave', '', 'San Francisco','CA','94110',37.74023,-122.423782);
INSERT INTO Address VALUES('98', 'Campbell St & Riverside Ave', '', 'Santa Cruz','CA','95060',36.96985,-122.019473);
INSERT INTO Address VALUES('99', 'Palm Dr & Arboretum Rd', '', 'Stanford','CA','94305',37.437838,-122.166975);
INSERT INTO Address VALUES('100', 'Leavesley Rd & Monterey Rd', '', 'Gilroy','CA','95020',37.019447,-121.574953);
INSERT INTO Address VALUES('101', 'Cesar Chavez St & Sanchez', '', 'San Francisco','CA','94131',37.74753,-122.428982);
INSERT INTO Address VALUES('102', 'University Ave & Middlefield Rd', '', 'Palo Alto','CA','94301',37.450638,-122.156975);

INSERT INTO SellerContactInfo VALUES('1', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('2', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('3', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('4', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('5', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('6', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('7', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('8', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('9', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('10', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('11', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('12', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('13', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('14', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('15', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('16', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('17', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('18', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('19', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('20', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('21', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('22', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('23', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('24', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('25', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('26', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('27', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('28', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('29', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('30', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('31', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('32', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('33', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('34', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('35', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('36', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('37', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('38', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('39', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('40', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('41', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('42', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('43', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('44', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('45', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('46', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('47', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('48', 'Burns', 'Ed', '[e-mail]');