-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.22-community-nt

--
-- Create schema northwind
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ northwind;
USE northwind;

--
-- Table structure for table `northwind`.`customers`
--

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;

--
-- Dumping data for table `northwind`.`customers`
--

/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;


GRANT ALL PRIVILEGES ON *.* TO 'flexuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;