clients.sql

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `gender` enum('M','F') DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

INSERT INTO `clients` (`id`, `first_name`, `last_name`, `email`, `gender`, `created_at`, `updated_at`) VALUES
	(1, 'Samuel', 'Coleman', 'scoleman0@baidu.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(2, 'Adam', 'Riley', 'ariley1@irs.gov', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(3, 'Joan', 'Vasquez', 'jvasquez2@hibu.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(4, 'David', 'Nichols', 'dnichols3@skyrock.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(5, 'Ryan', 'Warren', 'rwarren4@youku.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(6, 'Maria', 'Anderson', 'manderson5@w3.org', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(7, 'Willie', 'Pierce', 'wpierce6@google.it', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(8, 'Harold', 'Garcia', 'hgarcia7@hhs.gov', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(9, 'Nicholas', 'Washington', 'nwashington8@google.com.hk', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(10, 'Laura', 'Jenkins', 'ljenkins9@alexa.com', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(11, 'Louis', 'Little', 'llittlea@accuweather.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(12, 'George', 'Bradley', 'gbradleyb@omniture.com', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(13, 'Roger', 'Thomas', 'rthomasc@furl.net', 'M', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(14, 'Marie', 'Woods', 'mwoodsd@boston.com', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21'),
	(15, 'Sharon', 'Gonzalez', 'sgonzaleze@mapquest.com', 'F', '2016-12-21 08:58:21', '2016-12-21 08:58:21');