SQL for US presidents

--
-- Table structure for table `us_presidents`
--

CREATE TABLE `us_presidents` (
  `president_id` int(3) NOT NULL,
  `president_name` varchar(255) NOT NULL,
  `more_info` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `us_presidents`
--

INSERT INTO `us_presidents` (`president_id`, `president_name`, `more_info`) VALUES
(1, 'John F. Kennedy', 'https://en.wikipedia.org/wiki/John_F._Kennedy'),
(2, 'Lyndon B. Johnson', 'https://en.wikipedia.org/wiki/Lyndon_B._Johnson'),
(3, 'Richard Nixon', 'https://en.wikipedia.org/wiki/Richard_Nixon'),
(4, 'Gerald Ford', 'https://en.wikipedia.org/wiki/Gerald_Ford'),
(7, 'Jimmy Carter', 'https://en.wikipedia.org/wiki/Jimmy_Carter'),
(8, 'Ronald Reagan', 'https://en.wikipedia.org/wiki/Ronald_Reagan'),
(9, 'George H. W. Bush', 'https://en.wikipedia.org/wiki/George_H._W._Bush'),
(10, 'Bill Clinton', 'https://en.wikipedia.org/wiki/Bill_Clinton'),
(11, 'George W. Bush', 'https://en.wikipedia.org/wiki/George_W._Bush'),
(12, 'Barack Obama', 'https://en.wikipedia.org/wiki/Barack_Obama'),
(13, 'Donald Trump', 'https://en.wikipedia.org/wiki/Donald_Trump');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `us_presidents`
--
ALTER TABLE `us_presidents`
  ADD PRIMARY KEY (`president_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `us_presidents`
--
ALTER TABLE `us_presidents`
  MODIFY `president_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;