CREATE DATABASE `ftq`;

CREATE TABLE `quote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `saying` varchar(1000) DEFAULT NULL,
  `person` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 ;

INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (1,'Give me an army of West Point graduates and I''ll win a battle. Give me a handful of Texas Aggies, and I''ll win the war','George S. Patton');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (2,'Some folks look at me and see a certain swagger, which in Texas is called walking','George W. Bush');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (3,'Texas will again lift it''s head and stand among the nations. It ought to do so, for no country upon the globe can compare with it in natural advantages','Sam Houston ');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (4,'Texas is a state of mind. Texas is an obsession. Above all, Texas is a nation in every sense of the word','John Steinbeck');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (5,'If you''ve ever driven across Texas, you know how different one area of the state can be from another. Take El Paso. It looks as much like Dallas as I look like Jack Nicklaus','Lee Trevino');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (6,'Texas is the crossroads of the world. Everything here is big','Bobby Lee');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (7,'I must say as to what I have seen of Texas, it is the garden spot of the world, the best land and the best prospects for health I ever saw, and I do believe it is a fortune to any man to come here ','Davey Crockett');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (8,'I am forced to conclude that God made Texas on his day off, for pure entertainment, just to prove that all that diversity could be crammed into one section of earth by a really top hand','Mary Lasswell');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (9,'Texas is neither southern nor western. Texas is Texas','William Blakley');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (10,'I thought I knew Texas pretty well, but I had no notion of it''s size until I campaigned it','Ann Richards');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (11,'I done drew the line. Just like the Alamo. You''re either on one side of the line or the other. I don''t want to ever leave Texas again','Bum Phillips');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (12,'I think Texans have more fun than the rest of the world','Tommy Tune');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (13,'I love Texas because Texas is future-oriented, because Texans think anything is possible. Texans think big','Phil Gramm');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (14,'Houston is, without a doubt, the weirdest, most entertaining city in Texas, consisting as it does of subtropical forest, life in the fast lane, a layer of oil, cowboys and spacemen','Texas Tourism Guide ');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (15,'I feel safer on a racetrack than I do on Houston''s freeways','A.J. Foyt');
INSERT INTO `ftq`.`quote` (id,saying,person) VALUES (16,'My favorite Aggie joke? I''m sorry I don''t understand the question','Lyle Lovett');