DROP DATABASE IF EXISTS 'jasperarticle';
CREATE DATABASE `jasperarticle` /*!40100 DEFAULT CHARACTER SET utf8 */;

DROP TABLE IF EXISTS `jasperarticle`.`customer`;
CREATE TABLE `customer` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(45) NOT NULL default '',
  `Address` varchar(45) NOT NULL default '',
  `City` varchar(45) NOT NULL default '',
  `State` varchar(45) NOT NULL default '',
  `PostalCode` varchar(45) NOT NULL default '',
  `Website` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO customer (Name, Address, City, State, PostalCode, WebSite) VALUES (
	'XYZ,Inc.','123 Reporting Drive', 'Metro', 'TX', '99999', 'www.xyzinc.reports');


INSERT INTO customer (Name, Address, City, State, PostalCode, WebSite) VALUES (
	'ABC Corp.','456 Corporate Road', 'Big City', 'SD', '65432', 'www.abccorp.reports');