CREATE DATABASE northwind;
USE northwind;
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
`CustomerID` int(10) unsigned NOT NULL,
`CompanyName` varchar(45) NOT NULL default '',
`ContactName` varchar(45) NOT NULL default '',
`ContactTitle` varchar(45) NOT NULL default '',
`Address` varchar(45) NOT NULL default '',
`City` varchar(45) NOT NULL default '',
`Region` varchar(45) NOT NULL default '',
`PostalCode` varchar(45) NOT NULL default '',
`Country` varchar(45) NOT NULL default '',
`Phone` varchar(45) NOT NULL default '',
`Fax` varchar(45) NOT NULL default '',
PRIMARY KEY (`CustomerID`)
) TYPE=InnoDB;
;
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(1,'Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin','','12209','Germany','030-0074321','030-0076545'),
(2,'Ana Trujillo Emparedados y helados','Ana Trujillo','Owner','Avda. de la Constitución 2222','México D.F.','','05021','Mexico','(5) 555-4729','(5) 555-3745'),
(3,'Antonio Moreno Taquería','Antonio Moreno','Owner','Mataderos 2312','México D.F.','','05023','Mexico','(5) 555-3932',''),
(4,'Around the Horn','Thomas Hardy','Sales Representative','120 Hanover Sq.','London','','WA1 1DP','UK','(171) 555-7788','(171) 555-6750'),
(5,'Berglunds snabbköp','Christina Berglund','Order Administrator','Berguvsvägen 8','Luleå','','S-958 22','Sweden','0921-12 34 65','0921-12 34 67'),
(6,'Blauer See Delikatessen','Hanna Moos','Sales Representative','Forsterstr. 57','Mannheim','','68306','Germany','0621-08460','0621-08924'),
(7,'Blondel père et fils','Frédérique Citeaux','Marketing Manager','24, place Kléber','Strasbourg','','67000','France','88.60.15.31','88.60.15.32');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(8,'Bólido Comidas preparadas','Martín Sommer','Owner','C/ Araquil, 67','Madrid','','28023','Spain','(91) 555 22 82','(91) 555 91 99'),
(9,'Bon app\'','Laurence Lebihan','Owner','12, rue des Bouchers','Marseille','','13008','France','91.24.45.40','91.24.45.41'),
(10,'Bottom-Dollar Markets','Elizabeth Lincoln','Accounting Manager','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada','(604) 555-4729','(604) 555-3745'),
(11,'B\'s Beverages','Victoria Ashworth','Sales Representative','Fauntleroy Circus','London','','EC2 5NT','UK','(171) 555-1212',''),
(12,'Cactus Comidas para llevar','Patricio Simpson','Sales Agent','Cerrito 333','Buenos Aires','','1010','Argentina','(1) 135-5555','(1) 135-4892'),
(13,'Centro comercial Moctezuma','Francisco Chang','Marketing Manager','Sierras de Granada 9993','México D.F.','','05022','Mexico','(5) 555-3392','(5) 555-7293'),
(14,'Chop-suey Chinese','Yang Wang','Owner','Hauptstr. 29','Bern','','3012','Switzerland','0452-076545','');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(15,'Comércio Mineiro','Pedro Afonso','Sales Associate','Av. dos Lusíadas, 23','São Paulo','SP','05432-043','Brazil','(11) 555-7647',''),
(16,'Drachenblut Delikatessen','Sven Ottlieb','Order Administrator','Walserweg 21','Aachen','','52066','Germany','0241-039123','0241-059428'),
(17,'Du monde entier','Janine Labrune','Owner','67, rue des Cinquante Otages','Nantes','','44000','France','40.67.88.88','40.67.89.89'),
(18,'Eastern Connection','Ann Devon','Sales Agent','35 King George','London','','WX3 6FW','UK','(171) 555-0297','(171) 555-3373'),
(19,'Ernst Handel','Roland Mendel','Sales Manager','Kirchgasse 6','Graz','','8010','Austria','7675-3425','7675-3426'),
(20,'Familia Arquibaldo','Aria Cruz','Marketing Assistant','Rua Orós, 92','São Paulo','SP','05442-030','Brazil','(11) 555-9857',''),
(21,'FISSA Fabrica Inter. Salchichas S.A.','Diego Roel','Accounting Manager','C/ Moralzarzal, 86','Madrid','','28034','Spain','(91) 555 94 44','(91) 555 55 93'),
(22,'Folies gourmandes','Martine Rancé','Assistant Sales Agent','184, chaussée de Tournai','Lille','','59000','France','20.16.10.16','20.16.10.17');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(23,'Folk och fä HB','Maria Larsson','Owner','Åkergatan 24','Bräcke','','S-844 67','Sweden','0695-34 67 21',''),
(24,'Frankenversand','Peter Franken','Marketing Manager','Berliner Platz 43','München','','80805','Germany','089-0877310','089-0877451'),
(25,'France restauration','Carine Schmitt','Marketing Manager','54, rue Royale','Nantes','','44000','France','40.32.21.21','40.32.21.20'),
(26,'Franchi S.p.A.','Paolo Accorti','Sales Representative','Via Monte Bianco 34','Torino','','10100','Italy','011-4988260','011-4988261'),
(27,'Furia Bacalhau e Frutos do Mar','Lino Rodriguez ','Sales Manager','Jardim das rosas n. 32','Lisboa','','1675','Portugal','(1) 354-2534','(1) 354-2535'),
(28,'Galería del gastrónomo','Eduardo Saavedra','Marketing Manager','Rambla de Cataluña, 23','Barcelona','','08022','Spain','(93) 203 4560','(93) 203 4561'),
(29,'Godos Cocina Típica','José Pedro Freyre','Sales Manager','C/ Romero, 33','Sevilla','','41101','Spain','(95) 555 82 82','');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(30,'Gourmet Lanchonetes','André Fonseca','Sales Associate','Av. Brasil, 442','Campinas','SP','04876-786','Brazil','(11) 555-9482',''),
(31,'Great Lakes Food Market','Howard Snyder','Marketing Manager','2732 Baker Blvd.','Eugene','OR','97403','USA','(503) 555-7555',''),
(32,'GROSELLA-Restaurante','Manuel Pereira','Owner','5ª Ave. Los Palos Grandes','Caracas','DF','1081','Venezuela','(2) 283-2951','(2) 283-3397'),
(33,'Hanari Carnes','Mario Pontes','Accounting Manager','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil','(21) 555-0091','(21) 555-8765'),
(34,'HILARIÓN-Abastos','Carlos Hernández','Sales Representative','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela','(5) 555-1340','(5) 555-1948'),
(35,'Hungry Owl All-Night Grocers','Patricia McKenna','Sales Associate','8 Johnstown Road','Cork','Co. Cork','','Ireland','2967 542','2967 3333'),
(36,'Königlich Essen','Philip Cramer','Sales Associate','Maubelstr. 90','Brandenburg','','14776','Germany','0555-09876','');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(37,'La corne d\'abondance','Daniel Tonini','Sales Representative','67, avenue de l\'Europe','Versailles','','78000','France','30.59.84.10','30.59.85.11'),
(38,'La maison d\'Asie','Annette Roulet','Sales Manager','1 rue Alsace-Lorraine','Toulouse','','31000','France','61.77.61.10','61.77.61.11'),
(39,'Laughing Bacchus Wine Cellars','Yoshi Tannamuri','Marketing Assistant','1900 Oak St.','Vancouver','BC','V3F 2K1','Canada','(604) 555-3392','(604) 555-7293'),
(40,'Lazy K Kountry Store','John Steel','Marketing Manager','12 Orchestra Terrace','Walla Walla','WA','99362','USA','(509) 555-7969','(509) 555-6221'),
(41,'Lehmanns Marktstand','Renate Messner','Sales Representative','Magazinweg 7','Frankfurt a.M. ','','60528','Germany','069-0245984','069-0245874'),
(42,'LILA-Supermercado','Carlos González','Accounting Manager','Carrera 52 con Ave. Bolívar #65-98 Llano Larg','Barquisimeto','Lara','3508','Venezuela','(9) 331-6954','(9) 331-7256'),
(43,'LINO-Delicateses','Felipe Izquierdo','Owner','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela','(8) 34-56-12','(8) 34-93-93');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(44,'Lonesome Pine Restaurant','Fran Wilson','Sales Manager','89 Chiaroscuro Rd.','Portland','OR','97219','USA','(503) 555-9573','(503) 555-9646'),
(45,'Magazzini Alimentari Riuniti','Giovanni Rovelli','Marketing Manager','Via Ludovico il Moro 22','Bergamo','','24100','Italy','035-640230','035-640231'),
(46,'Maison Dewey','Catherine Dewey','Sales Agent','Rue Joseph-Bens 532','Bruxelles','','B-1180','Belgium','(02) 201 24 67','(02) 201 24 68'),
(47,'Mère Paillarde','Jean Fresnière','Marketing Assistant','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada','(514) 555-8054','(514) 555-8055'),
(48,'Morgenstern Gesundkost','Alexander Feuer','Marketing Assistant','Heerstr. 22','Leipzig','','04179','Germany','0342-023176',''),
(49,'Old World Delicatessen','Rene Phillips','Sales Representative','2743 Bering St.','Anchorage','AK','99508','USA','(907) 555-7584','(907) 555-2880'),
(50,'Ottilies Käseladen','Henriette Pfalzheim','Owner','Mehrheimerstr. 369','Köln','','50739','Germany','0221-0644327','0221-0765721');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(51,'Paris spécialités','Marie Bertrand','Owner','265, boulevard Charonne','Paris','','75012','France','(1) 42.34.22.66','(1) 42.34.22.77'),
(52,'Pericles Comidas clásicas','Guillermo Fernández','Sales Representative','Calle Dr. Jorge Cash 321','México D.F.','','05033','Mexico','(5) 552-3745','(5) 545-3745'),
(53,'Piccolo und mehr','Georg Pipps','Sales Manager','Geislweg 14','Salzburg','','5020','Austria','6562-9722','6562-9723'),
(54,'Princesa Isabel Vinhos','Isabel de Castro','Sales Representative','Estrada da saúde n. 58','Lisboa','','1756','Portugal','(1) 356-5634',''),
(55,'Que Delícia','Bernardo Batista','Accounting Manager','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil','(21) 555-4252','(21) 555-4545'),
(56,'Queen Cozinha','Lúcia Carvalho','Marketing Assistant','Alameda dos Canàrios, 891','São Paulo','SP','05487-020','Brazil','(11) 555-1189',''),
(57,'QUICK-Stop','Horst Kloss','Accounting Manager','Taucherstraße 10','Cunewalde','','01307','Germany','0372-035188','');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(58,'Rancho grande','Sergio Gutiérrez','Sales Representative','Av. del Libertador 900','Buenos Aires','','1010','Argentina','(1) 123-5555','(1) 123-5556'),
(59,'Rattlesnake Canyon Grocery','Paula Wilson','Assistant Sales Representative','2817 Milton Dr.','Albuquerque','NM','87110','USA','(505) 555-5939','(505) 555-3620'),
(60,'Reggiani Caseifici','Maurizio Moroni','Sales Associate','Strada Provinciale 124','Reggio Emilia','','42100','Italy','0522-556721','0522-556722'),
(61,'Ricardo Adocicados','Janete Limeira','Assistant Sales Agent','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil','(21) 555-3412',''),
(62,'Richter Supermarkt','Michael Holz','Sales Manager','Grenzacherweg 237','Genève','','1203','Switzerland','0897-034214',''),
(63,'Romero y tomillo','Alejandra Camino','Accounting Manager','Gran Vía, 1','Madrid','','28001','Spain','(91) 745 6200','(91) 745 6210'),
(64,'Santé Gourmet','Jonas Bergulfsen','Owner','Erling Skakkes gate 78','Stavern','','4110','Norway','07-98 92 35','07-98 92 47');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(65,'Save-a-lot Markets','Jose Pavarotti','Sales Representative','187 Suffolk Ln.','Boise','ID','83720','USA','(208) 555-8097',''),
(66,'Seven Seas Imports','Hari Kumar','Sales Manager','90 Wadhurst Rd.','London','','OX15 4NB','UK','(171) 555-1717','(171) 555-5646'),
(67,'Simons bistro','Jytte Petersen','Owner','Vinbæltet 34','København','','1734','Denmark','31 12 34 56','31 13 35 57'),
(68,'Spécialités du monde','Dominique Perrier','Marketing Manager','25, rue Lauriston','Paris','','75016','France','(1) 47.55.60.10','(1) 47.55.60.20'),
(69,'Split Rail Beer & Ale','Art Braunschweiger','Sales Manager','P.O. Box 555','Lander','WY','82520','USA','(307) 555-4680','(307) 555-6525'),
(70,'Suprêmes délices','Pascale Cartrain','Accounting Manager','Boulevard Tirou, 255','Charleroi','','B-6000','Belgium','(071) 23 67 22 20','(071) 23 67 22 21'),
(71,'The Cracker Box','Liu Wong','Marketing Assistant','55 Grizzly Peak Rd.','Butte','MT','59801','USA','(406) 555-5834','(406) 555-8083');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(72,'Toms Spezialitäten','Karin Josephs','Marketing Manager','Luisenstr. 48','Münster','','44087','Germany','0251-031259','0251-035695'),
(73,'Tortuga Restaurante','Miguel Angel Paolino','Owner','Avda. Azteca 123','México D.F.','','05033','Mexico','(5) 555-2933',''),
(74,'Tradição Hipermercados','Anabela Domingues','Sales Representative','Av. Inês de Castro, 414','São Paulo','SP','05634-030','Brazil','(11) 555-2167','(11) 555-2168'),
(75,'Trail\'s Head Gourmet Provisioners','Helvetius Nagy','Sales Associate','722 DaVinci Blvd.','Kirkland','WA','98034','USA','(206) 555-8257','(206) 555-2174'),
(76,'Vaffeljernet','Palle Ibsen','Sales Manager','Smagsløget 45','Århus','','8200','Denmark','86 21 32 43','86 22 33 44'),
(77,'Victuailles en stock','Mary Saveley','Sales Agent','2, rue du Commerce','Lyon','','69004','France','78.32.54.86','78.32.54.87'),
(78,'Vins et alcools Chevalier','Paul Henriot','Accounting Manager','59 rue de l\'Abbaye','Reims','','51100','France','26.47.15.10','26.47.15.11');
INSERT INTO `customers` (`CustomerID`,`CompanyName`,`ContactName`,`ContactTitle`,`Address`,`City`,`Region`,`PostalCode`,`Country`,`Phone`,`Fax`) VALUES
(79,'Die Wandernde Kuh','Rita Müller','Sales Representative','Adenauerallee 900','Stuttgart','','70563','Germany','0711-020361','0711-035428'),
(80,'Wartian Herkku','Pirkko Koskitalo','Accounting Manager','Torikatu 38','Oulu','','90110','Finland','981-443655','981-443655'),
(81,'Wellington Importadora','Paula Parente','Sales Manager','Rua do Mercado, 12','Resende','SP','08737-363','Brazil','(14) 555-8122',''),
(82,'Wilman Kala','Matti Karttunen','Owner/Marketing Assistant','Keskuskatu 45','Helsinki','','21240','Finland','90-224 8858','90-224 8858'),
(83,'Wolski Zajazd','Zbyszek Piestrzeniewicz','Owner','ul. Filtrowa 68','Warszawa','','01-012','Poland','(26) 642-7012','(26) 642-7012');
;
GRANT ALL PRIVILEGES ON *.* TO 'flexuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;