XFB8MULp

1--
2-- Database: `testing`
3--
4
5-- --------------------------------------------------------
6
7--
8-- Table structure for table `tbl_customer`
9--
10
11CREATE TABLE IF NOT EXISTS `tbl_customer` (
12  `CustomerID` int(11) NOT NULL AUTO_INCREMENT,
13  `CustomerName` varchar(250) NOT NULL,
14  `Address` text NOT NULL,
15  `City` varchar(250) NOT NULL,
16  `PostalCode` varchar(30) NOT NULL,
17  `Country` varchar(100) NOT NULL,
18  PRIMARY KEY (`CustomerID`)
19) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
20
21--
22-- Dumping data for table `tbl_customer`
23--
24
25INSERT INTO `tbl_customer` (`CustomerID`, `CustomerName`, `Address`, `City`, `PostalCode`, `Country`) VALUES
26(1, 'Maria Anders', 'Obere Str. 57', 'Berlin', '12209', 'Germany'),
27(2, 'Ana Trujillo', 'Avda. de la Construction 2222', 'Mexico D.F.', '5021', 'Mexico'),
28(3, 'Antonio Moreno', 'Mataderos 2312', 'Mexico D.F.', '5023', 'Mexico'),
29(4, 'Thomas Hardy', '120 Hanover Sq.', 'London', 'WA1 1DP', 'UK'),
30(5, 'Paula Parente', 'Rua do Mercado, 12', 'Resende', '08737-363', 'Brazil'),
31(6, 'Wolski Zbyszek', 'ul. Filtrowa 68', 'Walla', '01-012', 'Poland'),
32(7, 'Matti Karttunen', 'Keskuskatu 45', 'Helsinki', '21240', 'Finland'),
33(8, 'Karl Jablonski', '305 - 14th Ave. S. Suite 3B', 'Seattle', '98128', 'USA'),
34(9, 'Paula Parente', 'Rua do Mercado, 12', 'Resende', '08737-363', 'Brazil'),
35(10, 'Pirkko Koskitalo', 'Torikatu 38', 'Oulu', '90110', 'Finland'),
36(11, 'Paul Henriot', '2, rue du Commerce', 'Reims', '51100', 'France'),
37(12, 'Helvetius Nagy', '722 DaVinci Blvd.', 'Kirkland', '98034', 'USA'),
38(13, 'Karin Josephs', 'Luisenstr. 48', 'Butte', '59801', 'USA');