DROP DATABASE IF EXISTS `ajaxtest`;
SHOW WARNINGS;
CREATE DATABASE IF NOT EXISTS `ajaxtest`;
SHOW WARNINGS;
USE `ajaxtest`;
SHOW WARNINGS;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `customer` (
  `id` int(4) NOT NULL PRIMARY KEY,
  `FirstName` varchar(15),
  `LastName` varchar(15),
  `Age` int(4),
  `Hometown` varchar(15),
  `Job` varchar(15),
  `Email` varchar(25)
);
SHOW WARNINGS;

INSERT INTO `ajaxtest`.`customer` (id, FirstName, LastName, Age, Hometown, Job, Email) VALUES
(3, 'Peter', 'Griffin', 41, 'Quahog', 'Brewery', 'peter.griffin@web.com'),
(6, 'Lois', 'Malcolm', 40, 'Newport', 'Piano Teacher', 'lois_malcolm@yahoo.org'),
(9, 'Joseph', 'Swanson', 39, 'Quahog', 'Police Officer', 'info@police.us'),
(12, 'Glenn', 'Quagmire', 41, 'Quahog', 'Pilot', 'office@iata.com')
;
SHOW WARNINGS;
