-- MySQL dump 8.22
--
-- Host: localhost    Database: us_presidents
---------------------------------------------------------
-- Server version	3.23.51

--
-- Table structure for table 'names'
--

DROP TABLE IF EXISTS name;
CREATE TABLE name (
  id int(11) NOT NULL auto_increment,
  last varchar(25) default NULL,
  first varchar(25) default NULL,
  middle varchar(25) default NULL,
  party varchar(25) default NULL,
  age int(3) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'name'
--


INSERT INTO name VALUES (1,'Washington','George',NULL,'Federalist',57);
INSERT INTO name VALUES (2,'Adams','John',NULL,'Federalist',61);
INSERT INTO name VALUES (3,'Jefferson','Thomas',NULL,'Democratic Republican',58);
INSERT INTO name VALUES (4,'Madison','James',NULL,'Democratic Republican',58);
INSERT INTO name VALUES (5,'Monroe','James',NULL,'Democratic Republican',59);
INSERT INTO name VALUES (6,'Adams','John','Quincy','Democratic Republican',58);
INSERT INTO name VALUES (7,'Jackson','Andrew',NULL,'Democratic',62);
INSERT INTO name VALUES (8,'Van Buren','Martin',NULL,'Democratic',54);
INSERT INTO name VALUES (9,'Harrison','William','Henry','Whig',68);
INSERT INTO name VALUES (10,'Tyler','John',NULL,'Whig',51);
INSERT INTO name VALUES (11,'Polk','James',NULL,'Democratic',49);
INSERT INTO name VALUES (12,'Taylor','Zachary',NULL,'Whig',64);
INSERT INTO name VALUES (13,'Fillmore','Millard',NULL,'Whig',50);
INSERT INTO name VALUES (14,'Pierce','Franklin',NULL,'Democratic',48);
INSERT INTO name VALUES (15,'Buchanan','James',NULL,'Democratic',66);
INSERT INTO name VALUES (16,'Lincoln','Abraham',NULL,'Republican',52);
INSERT INTO name VALUES (17,'Johnson','Andrew',NULL,'Democratic',56);
INSERT INTO name VALUES (18,'Grant','Ulysses','S','Republican',47);
INSERT INTO name VALUES (19,'Hayes','Rutherford','B','Republican',54);
INSERT INTO name VALUES (20,'Garfield','James',NULL,'Republican',49);

--
-- Table structure for table 'quote'
--

DROP TABLE IF EXISTS quote;
CREATE TABLE quote (
  id int(11) NOT NULL auto_increment,
  name_id int(11) default NULL,
  quote text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'quote'
--


INSERT INTO quote VALUES (1,1,'I cannot tell a lie.');
INSERT INTO quote VALUES (2,1,'To be prepared for war is one of the most effective means of preserving peace.');
INSERT INTO quote VALUES (3,2,'Liberty can not be preserved without general knowledge among people.');
INSERT INTO quote VALUES (4,2,'Facts are stubborn things; and whatever may be our wishes our inclinations, or the dictates of our passions, they cannot alter the state of facts and evidence.');
INSERT INTO quote VALUES (5,3,'Delay is preferable to error.');
INSERT INTO quote VALUES (6,3,'An injured friend is the bitterest of foes.');
INSERT INTO quote VALUES (7,3,'History, in general, only informs us what bad government is.');
INSERT INTO quote VALUES (8,3,'I can not live without books.');
INSERT INTO quote VALUES (9,4,'A public debt is a public curse.');
INSERT INTO quote VALUES (10,4,'All power in human hands is liable to be abused.');
INSERT INTO quote VALUES (11,5,'The right of self-defense never ceases.  It is among the most sacred, and alike necessary to nations and to individuals.');
INSERT INTO quote VALUES (12,7,'One man with courage makes a majority.');
INSERT INTO quote VALUES (13,9,'A decent and manly examination of the acts of government should not only be tolerated, but encouraged.');
INSERT INTO quote VALUES (14,10,'Wealth can only be accumulated by the earnings of industry and the savings of frugality.');
INSERT INTO quote VALUES (15,13,'An honorable defeat is better than a dishonorable victory.');
INSERT INTO quote VALUES (16,16,'You can fool all of the people some of the time, and some of the people all of the time, but you can not fool all of the people all of the time.');
INSERT INTO quote VALUES (17,16,'Fellow citizens, we cannot escape history.');
INSERT INTO quote VALUES (18,16,'Common-looking people are the best in the world:  that is the reason the Lord makes so many of them.');
INSERT INTO quote VALUES (19,16,'Truth is generally the best vindication against slander.');
INSERT INTO quote VALUES (20,16,'It is best not to swap horses while crossing the river.');
INSERT INTO quote VALUES (21,17,'Legislation can neither be wise nor just which seeks the welfare of a single interest at the expense and to the injury of many and varied interests.');
INSERT INTO quote VALUES (22,19,'Nothing brings out the lower traits of human nature like office seeking.');