-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 10, 2025 at 01:11 PM
-- Server version: 5.7.23-23
-- PHP Version: 8.1.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `sophief_class`
--

-- --------------------------------------------------------

--
-- Table structure for table `birth_place`
--

CREATE TABLE `birth_place` (
  `birth_place_id` int(11) NOT NULL,
  `president_name` varchar(200) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `city` varchar(19) DEFAULT NULL,
  `state_id` int(11) NOT NULL,
  `term_dates` varchar(38) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `birth_place`
--

INSERT INTO `birth_place` (`birth_place_id`, `president_name`, `birth_date`, `city`, `state_id`, `term_dates`) VALUES
(1, 'George Washington', '1732-02-22', 'Westmoreland County', 46, 'April 30, 1789 ? March 4, 1797'),
(2, 'John Adams', '1735-10-30', 'Braintree', 21, 'March 4, 1797 ? March 4, 1801'),
(3, 'Thomas Jefferson', '1743-04-13', 'Shadwell', 46, 'March 4, 1801 ? March 4, 1809'),
(4, 'James Madison', '1751-03-16', 'Port Conway', 46, 'March 4, 1809 ? March 4, 1817'),
(5, 'James Monroe', '1758-04-28', 'Monroe Hall', 46, 'March 4, 1817 ? March 4, 1825'),
(6, 'Andrew Jackson', '1767-03-15', 'Waxhaws Region', 40, 'March 4, 1829 ? March 4, 1837'),
(7, 'John Quincy Adams', '1767-07-11', 'Braintree', 21, 'March 4, 1825 ? March 4, 1829'),
(8, 'William Henry Harrison', '1773-02-09', 'Charles City County', 46, 'March 4, 1841 ? April 4, 1841'),
(9, 'Martin Van Buren', '1782-12-05', 'Kinderhook', 32, 'March 4, 1837 ? March 4, 1841'),
(10, 'Zachary Taylor', '1784-11-24', 'Barboursville', 46, 'March 4, 1849 ? July 9, 1850'),
(11, 'John Tyler', '1790-03-29', 'Charles City County', 46, 'April 4, 1841 ? March 4, 1845'),
(12, 'James Buchanan', '1791-07-23', 'Cove Gap', 38, 'March 4, 1857 ? March 4, 1861'),
(13, 'James K. Polk', '1795-02-11', 'Pineville', 33, 'March 4, 1845 ? March 4, 1849'),
(14, 'Millard Fillmore', '1800-01-07', 'Summerhill', 32, 'July 9, 1850 ? March 4, 1853'),
(15, 'Franklin Pierce', '1804-11-23', 'Hillsborough', 29, 'March 4, 1853 ? March 4, 1857'),
(16, 'Andrew Johnson', '1808-12-29', 'Raleigh', 33, 'April 15, 1865 ? March 4, 1869'),
(17, 'Abraham Lincoln', '1809-02-12', 'Sinking spring', 17, 'March 4, 1861 ? April 15, 1865'),
(18, 'Ulysses S. Grant', '1822-04-27', 'Point Pleasant', 35, 'March 4, 1869 ? March 4, 1877'),
(19, 'Rutherford B. Hayes', '1822-10-04', 'Delaware', 35, 'March 4, 1877 ? March 4, 1881'),
(20, 'Chester A. Arthur', '1829-10-05', 'Fairfield', 45, 'September 19, 1881 ? March 4, 1885'),
(21, 'James A. Garfield', '1831-11-19', 'Moreland Hills', 35, 'March 4, 1881 ? September 19, 1881'),
(22, 'Benjamin Harrison', '1933-08-20', 'North Bend', 35, 'March 4, 1889 ? March 4, 1893'),
(23, 'Grover Cleveland', '1837-03-18', 'Caldwell', 30, 'March 4, 1885 ? March 4, 1889'),
(24, 'William McKinley', '1834-01-29', 'Niles', 35, 'March 4, 1897 ? September 14, 1901'),
(25, 'Woodrow Wilson', '1856-12-28', 'Staunton', 46, 'March 4, 1913 ? March 4, 1921'),
(26, 'William Howard Taft', '1857-09-15', 'Cincinnati', 35, 'March 4, 1909 ? March 4, 1913'),
(27, 'Theodore Roosevelt', '1858-10-27', 'Manhattan', 32, 'September 14, 1901 ? March 4, 1909'),
(28, 'Warren G. Harding', '1865-11-02', 'Blooming Grove', 35, 'March 4, 1921 ? August 2, 1923'),
(29, 'Calvin Coolidge', '1873-04-04', 'Plymouth', 45, 'August 2, 1923 ? March 4, 1929'),
(30, 'Herbert Hoover', '1874-08-10', 'West Branch', 15, 'March 4, 1929 ? March 4, 1933'),
(31, 'Franklin D. Roosevelt', '1882-01-30', 'Hyde Park', 32, 'March 4, 1933 ? April 12, 1945'),
(32, 'Harry S. Truman', '1884-04-08', 'Lamar', 25, 'April 12, 1945 ? January 20, 1953'),
(33, 'Dwight D. Eisenhower', '1890-10-14', 'Denison', 43, 'January 20, 1953 ? January 20, 1961'),
(34, 'Lyndon B. Johnson', '1908-08-27', 'Stonewall', 43, 'November 22, 1963 ? January 20, 1969'),
(35, 'Ronald Reagan', '1911-02-06', 'Tampico', 13, 'January 20, 1981 ? January 20, 1989'),
(36, 'Richard M. Nixon', '1913-01-09', 'Yorba Linda', 5, 'January 20, 1969 ? August 9, 1974'),
(37, 'Gerald R. Ford', '1913-07-14', 'Omaha', 27, 'August 9, 1974 ? January 20, 1977'),
(38, 'John F. Kennedy', '1917-05-29', 'Brookline', 21, 'January 20, 1961 ? November 22, 1963'),
(39, 'George H. W. Bush', '1924-06-12', 'Milton', 21, 'January 20, 1989 ? January 20, 1993'),
(40, 'Jimmy Carter', '1924-10-01', 'Plains', 10, 'January 20, 1977 ? January 20, 1981'),
(41, 'Donald Trump', '1946-06-14', 'Queens', 32, 'January 20, 2017 ? January 19, 2021'),
(42, 'George W. Bush', '1946-07-06', 'New Haven', 7, 'January 20, 2001 ? January 20, 2009'),
(43, 'Bill Clinton', '1946-08-19', 'Hope', 4, 'January 20, 1993 ? January 20, 2001'),
(44, 'Barack Obama', '1961-08-04', 'Honolulu', 11, 'January 20, 2009 ? January 20, 2017'),
(45, 'Alexander Hamilton', '0000-00-00', 'Charlestown', 0, 'None but super important!'),
(46, 'Joe Biden', '1942-10-20', 'Scranton', 38, 'January 20, 2021 - Now!');

-- --------------------------------------------------------

--
-- Table structure for table `class`
--

CREATE TABLE `class` (
  `class_id` int(11) NOT NULL DEFAULT '0',
  `class_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `day_of_week` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `max_students` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`class_id`, `class_name`, `location`, `day_of_week`, `time`, `start_date`, `end_date`, `max_students`) VALUES
(0, ' class_name', ' location', ' day_of_week', ' time', '0000-00-00', '0000-00-00', 0);

-- --------------------------------------------------------

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `contact_id` int(11) NOT NULL,
  `phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`contact_id`, `phone`, `type`) VALUES
(1, '202-262-6907', 'mobile'),
(2, '202-462-2752', 'home'),
(3, '202-802-2323', 'mobile'),
(4, '202-710-1299', 'mobile'),
(5, '202-277-0150', 'mobile'),
(6, '202-227-7210', 'mobile');

-- --------------------------------------------------------

--
-- Table structure for table `cultural_region`
--

CREATE TABLE `cultural_region` (
  `cultural_id` int(11) NOT NULL,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cultural_region`
--

INSERT INTO `cultural_region` (`cultural_id`, `name`, `description`) VALUES
(1, 'Deep North', 'It\'s cold up there!  Hugging the Canadian border.  Brrr.'),
(2, 'Rocky Mountains', 'The Rocky Mountains dominate parts of these states.'),
(3, 'San Francisco', 'City is its own culture and odd blend of traditions.'),
(4, 'Cascadia', 'Coastal regions of Oregon and Washington - cooler and rainy!'),
(5, 'Socal', 'Southern Coast of California - beaches!'),
(6, 'Sun Belt', 'Sun-bleached and arid dessert - lots of cacti!'),
(7, 'Colorado', 'While still part of the Rocky Mountains (duh) and Sun Belt - Colorado is again its own weird culture.'),
(8, 'Midwest', 'The very flat but not super boring part of the middle of the country!'),
(9, 'Texas', 'Again - it\'s own entity though it has parts that are the Sun Belt, Midwest, Great Plains, Gulf Coast and the South.  Whew.'),
(10, 'Deep South', 'The true south when you think of the Civil War and other things.  Appalachia runs through the middle and certain states that are in the South geographically aren\'t really Southern. Florida we are talking to you.'),
(11, 'Appalachia', 'The Appalachian Mountains make a line up the eastern side of the country.  Folks who live up there were isolated and formed a very different culture.'),
(12, 'Mid-Atlantic', 'Or the \"boring\" part - basically the middle of the Atlantic Seaboard that is not New England or the Deep South!'),
(13, 'Rust Belt', 'Goes across Pennsylbannia, Oho, Indiana - this is where the steel mills and manufacturing used to reign. '),
(14, 'New England', 'Upper tip of the country that was first populated by a lot of uptight people.  Pilgrims landed here.  Good for leaf changing.  '),
(15, 'New York', 'Kind of like Texas/SF - the city of NY has it\'s own bizarre but amazing culture.  No place on earth like it!'),
(16, 'Florida', 'A weird mix of southerners up north, Cubans down south and a bunch of old people escaping New England winters.  '),
(17, 'Lousiana', 'Mix of Cajun, French and Southern.  Some seriously great food and music down here.  A must visit place!'),
(18, 'Great Lakes', 'States that border the Great Lakes - doh.  Also cold up there!'),
(19, 'Central Plains', 'Similar to the Midwest but only for the large flat plains that stretch - none of those hilly parts.  Think Kansas not Indiana.'),
(20, 'Alaska', 'The great state of Alaska so far away...obviously it\'s own entity.  Though maybe with a touch of Rocky Mountains.'),
(21, 'Hawaii', 'Not even really American?  :)  But, seriously...so far away.'),
(22, 'Gulf Coast', 'The region along the Gulf of Mexico...');

-- --------------------------------------------------------

--
-- Table structure for table `cultural_region_lookup`
--

CREATE TABLE `cultural_region_lookup` (
  `id` int(11) NOT NULL,
  `cultural_region_id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cultural_region_lookup`
--

INSERT INTO `cultural_region_lookup` (`id`, `cultural_region_id`, `state_id`) VALUES
(1, 10, 1),
(2, 20, 2),
(3, 6, 3),
(4, 10, 4),
(5, 5, 5),
(6, 3, 5),
(7, 7, 6),
(8, 2, 6),
(9, 6, 6),
(10, 14, 7),
(11, 12, 8),
(12, 16, 9),
(13, 10, 9),
(14, 10, 9),
(15, 11, 10),
(16, 21, 11),
(17, 2, 12),
(18, 8, 13),
(19, 18, 13),
(20, 8, 14),
(21, 18, 14),
(22, 13, 14),
(23, 8, 15),
(24, 1, 15),
(25, 8, 16),
(26, 19, 16),
(27, 10, 17),
(28, 11, 17),
(29, 10, 18),
(30, 17, 18),
(31, 14, 19),
(32, 12, 20),
(33, 11, 20),
(34, 14, 21),
(35, 18, 22),
(36, 13, 22),
(37, 1, 22),
(38, 1, 23),
(39, 18, 23),
(40, 10, 24),
(41, 8, 25),
(42, 10, 25),
(43, 1, 26),
(44, 2, 26),
(45, 8, 27),
(46, 19, 27),
(47, 14, 29),
(48, 12, 30),
(49, 13, 30),
(50, 15, 30),
(51, 6, 31),
(52, 15, 32),
(53, 13, 32),
(54, 14, 32),
(55, 10, 33),
(56, 11, 33),
(57, 1, 34),
(58, 18, 34),
(59, 8, 35),
(60, 13, 35),
(61, 11, 35),
(62, 19, 36),
(63, 8, 36),
(64, 10, 36),
(65, 4, 37),
(66, 2, 37),
(67, 13, 38),
(68, 11, 38),
(69, 12, 38),
(70, 14, 39),
(71, 10, 40),
(72, 11, 40),
(73, 1, 41),
(74, 8, 41),
(75, 19, 41),
(76, 11, 42),
(77, 10, 42),
(78, 9, 43),
(79, 2, 50),
(80, 8, 50),
(81, 6, 43),
(82, 8, 43),
(83, 2, 44),
(84, 6, 44),
(85, 14, 45),
(86, 11, 46),
(87, 12, 46),
(88, 10, 46),
(89, 4, 47),
(90, 2, 41),
(91, 11, 48),
(92, 1, 49),
(93, 8, 49),
(94, 18, 49),
(95, 22, 43),
(96, 22, 24),
(97, 22, 1),
(98, 22, 18),
(99, 22, 9),
(100, 6, 5);

-- --------------------------------------------------------

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `member_id` int(11) NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `age` int(25) NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `language` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `member`
--

INSERT INTO `member` (`member_id`, `first_name`, `last_name`, `age`, `email`, `language`, `description`) VALUES
(1, 'Sophie', 'Flaherty', 13, 'sophie@labcatscoding.com', 'Chinese', 'Tall,long hair, slightly feral.'),
(2, 'Alice', 'Patterson', 13, 'alice@labcatscode.com', 'Spanish', 'Long brown hair, average height, brown eyes'),
(3, 'Meredith', 'Page', 13, 'meredith@labcatscode.com', 'Chinese', 'Short, blond hair, blue eyes'),
(4, 'Eva', 'Flaherty', 16, 'eva@labcatscode.com', 'Chinese', 'Shoulder lenght brown hair, green eyes, tall'),
(5, 'Elizabeth', 'Mettler', 54, 'e@mettlersolutions.com', 'French', 'Grumpy and annoying');

-- --------------------------------------------------------

--
-- Table structure for table `member_class_lookup`
--

CREATE TABLE `member_class_lookup` (
  `id` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `member_contact_lookup`
--

CREATE TABLE `member_contact_lookup` (
  `id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `member_contact_lookup`
--

INSERT INTO `member_contact_lookup` (`id`, `member_id`, `contact_id`) VALUES
(1, 5, 1),
(2, 5, 2),
(3, 1, 2),
(4, 4, 1),
(5, 1, 3),
(6, 4, 4),
(7, 3, 5),
(8, 2, 6);

-- --------------------------------------------------------

--
-- Table structure for table `region`
--

CREATE TABLE `region` (
  `region_id` int(11) NOT NULL,
  `region_name` text COLLATE utf8_unicode_ci NOT NULL,
  `region_description` varchar(300) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `region`
--

INSERT INTO `region` (`region_id`, `region_name`, `region_description`) VALUES
(1, 'Northeast', 'Divided into two basic subregions - New England which is cold and where the settler first came.  The mid-atlantic region includes Delaware, Maryland, New Jersey, New York, Pennsylvanie and DC!  Industrial areas that gave rise to some of the East Coast biggest cities like NY, Philly and Bmore.'),
(2, 'Southeast', 'Includes the Deep South an area which struggled after the Civil War but is nice and warm.'),
(3, 'Southwest', 'Beautiful, stark landscape of praire and desert with some great marvles like the Grand Canyon and Carlsbad caverns.  Oh yeah - and cactus!'),
(4, 'West', 'Sprawling area from Hawaii to Alaska and the Rocky Mountains!'),
(5, 'Midwest', 'The breadbasket of America - this includes the the Great Plains as well as the more industrial ares of Indiana, Ohio and Michigan.');

-- --------------------------------------------------------

--
-- Table structure for table `snow`
--

CREATE TABLE `snow` (
  `snow_id` int(11) NOT NULL,
  `rank` int(4) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `days` decimal(3,1) DEFAULT NULL,
  `place` varchar(50) DEFAULT NULL,
  `inches` decimal(4,1) DEFAULT NULL,
  `cms` decimal(10,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `snow`
--

INSERT INTO `snow` (`snow_id`, `rank`, `state_id`, `days`, `place`, `inches`, `cms`) VALUES
(1, 1, 32, 66.4, 'Syracuse', 123.8, 314.00),
(2, 2, 50, 36.7, 'Lander', 91.4, 232.00),
(3, 3, 45, 54.4, 'Burlington', 81.2, 206.00),
(4, 4, 2, 48.0, 'Anchorage', 74.5, 189.00),
(5, 5, 48, 37.7, 'Beckley', 62.0, 157.00),
(6, 6, 19, 27.8, 'Portland', 61.8, 157.00),
(7, 7, 29, 29.8, 'Concord', 60.8, 154.00),
(8, 8, 44, 34.8, 'Salt Lake City', 56.2, 142.00),
(9, 9, 23, 37.3, 'Minneapolis', 54.0, 137.00),
(10, 10, 34, 45.2, 'Bismarck', 51.2, 130.00),
(11, 11, 22, 44.7, 'Lansing', 51.1, 129.00),
(12, 12, 49, 38.7, 'Madison', 50.9, 129.00),
(13, 13, 41, 30.1, 'Huron', 43.9, 111.00),
(14, 14, 21, 22.4, 'Boston', 43.8, 111.00),
(15, 15, 7, 20.1, 'Hartford', 40.5, 102.00),
(16, 16, 26, 32.9, 'Helena', 38.1, 96.80),
(17, 17, 15, 26.2, 'Des Moines', 34.9, 88.60),
(18, 18, 39, 18.7, 'Providence', 33.8, 85.90),
(19, 19, 38, 19.4, 'Harrisburg', 28.2, 71.60),
(20, 20, 35, 30.4, 'Columbus', 27.5, 69.90),
(21, 21, 14, 23.5, 'Indianapolis', 25.9, 65.80),
(22, 22, 27, 18.3, 'Lincoln', 25.9, 65.80),
(23, 23, 13, 19.9, 'Peoria', 24.6, 62.50),
(24, 24, 28, 16.3, 'Reno', 21.8, 55.40),
(25, 25, 8, 11.8, 'Wilmington', 20.2, 51.30),
(26, 26, 20, 9.6, 'Baltimore', 20.2, 51.30),
(27, 27, 12, 19.4, 'Boise', 19.2, 48.80),
(28, 28, 6, 19.1, 'Grand Junction', 19.1, 48.50),
(29, 29, 25, 11.5, 'Springfield', 17.0, 43.20),
(30, 30, 30, 8.7, 'Atlantic City', 16.5, 41.90),
(31, 31, 0, 8.1, 'Washington DC', 15.4, 0.00),
(32, 32, 16, 10.0, 'Wichita', 14.7, 37.30),
(33, 33, 17, 11.8, 'Louisville', 12.5, 31.80),
(34, 34, 46, 6.1, 'Richmond', 10.3, 26.20),
(35, 35, 31, 9.5, 'Albuquerque', 9.6, 24.40),
(36, 36, 36, 5.6, 'Oklahoma City', 7.8, 19.80),
(37, 37, 33, 3.9, 'Greensboro', 7.6, 19.30),
(38, 38, 42, 6.2, 'Nashville', 6.3, 16.00),
(39, 39, 4, 3.8, 'Fort Smith', 5.2, 13.20),
(40, 40, 47, 3.0, 'Seattle', 5.0, 12.70),
(41, 41, 37, 2.2, 'Portland', 3.0, 7.60),
(42, 42, 1, 0.8, 'Birmingham', 1.6, 4.10),
(43, 43, 43, 1.3, 'Dallas', 1.5, 3.80),
(44, 44, 24, 0.6, 'Jackson', 0.9, 2.30),
(45, 45, 10, 0.7, 'Macon', 0.7, 1.80),
(46, 46, 40, 0.3, 'Columbia', 0.5, 1.30),
(47, 47, 3, 0.3, 'Tucson', 0.3, 0.80),
(48, NULL, 90, NULL, NULL, 2.0, NULL),
(49, NULL, 95, NULL, NULL, 0.0, NULL),
(50, NULL, 96, NULL, NULL, 0.0, NULL),
(51, NULL, 97, NULL, NULL, 0.0, NULL),
(52, NULL, 102, NULL, NULL, 0.0, NULL),
(53, NULL, 103, NULL, NULL, 0.0, NULL),
(54, NULL, 108, NULL, NULL, 0.0, NULL),
(55, NULL, 117, NULL, NULL, 0.0, NULL),
(56, NULL, 118, NULL, NULL, 0.0, NULL),
(57, NULL, 123, NULL, NULL, 0.0, NULL),
(58, NULL, 128, NULL, NULL, 0.0, NULL),
(59, NULL, 129, NULL, NULL, 0.0, NULL),
(60, NULL, 134, NULL, NULL, 0.0, NULL),
(61, NULL, 139, NULL, NULL, 0.0, NULL),
(62, NULL, 144, NULL, NULL, 0.0, NULL),
(63, NULL, 149, NULL, NULL, 0.0, NULL),
(64, NULL, 150, NULL, NULL, 0.0, NULL),
(65, NULL, 155, NULL, NULL, 0.0, NULL),
(66, NULL, 160, NULL, NULL, 0.0, NULL),
(67, NULL, 165, NULL, NULL, 0.0, NULL),
(68, NULL, 170, NULL, NULL, 0.0, NULL),
(69, NULL, 175, NULL, NULL, 0.0, NULL),
(70, NULL, 180, NULL, NULL, 0.0, NULL),
(71, NULL, 185, NULL, NULL, 0.0, NULL),
(72, NULL, 186, NULL, NULL, 0.0, NULL),
(73, NULL, 187, NULL, NULL, 0.0, NULL),
(74, NULL, 196, NULL, NULL, 0.0, NULL),
(75, NULL, 201, NULL, NULL, 0.0, NULL),
(76, NULL, 206, NULL, NULL, 0.0, NULL),
(77, NULL, 211, NULL, NULL, 0.0, NULL),
(78, NULL, 216, NULL, NULL, 0.0, NULL),
(79, NULL, 221, NULL, NULL, 0.0, NULL),
(80, NULL, 222, NULL, NULL, 0.0, NULL),
(81, NULL, 231, NULL, NULL, 0.0, NULL),
(82, NULL, 236, NULL, NULL, 0.0, NULL),
(83, NULL, 237, NULL, NULL, 0.0, NULL),
(84, NULL, 242, NULL, NULL, 0.0, NULL),
(85, NULL, 243, NULL, NULL, 0.0, NULL),
(86, NULL, 244, NULL, NULL, 0.0, NULL),
(87, NULL, 245, NULL, NULL, 0.0, NULL),
(88, NULL, 246, NULL, NULL, 0.0, NULL),
(89, NULL, 251, NULL, NULL, 0.0, NULL),
(90, NULL, 252, NULL, NULL, 0.0, NULL),
(91, NULL, 253, NULL, NULL, 0.0, NULL),
(92, NULL, 258, NULL, NULL, 0.0, NULL),
(93, NULL, 263, NULL, NULL, 0.0, NULL),
(94, NULL, 264, NULL, NULL, 0.0, NULL),
(95, NULL, 269, NULL, NULL, 0.0, NULL),
(96, NULL, 278, NULL, NULL, 0.0, NULL),
(97, NULL, 283, NULL, NULL, 0.0, NULL),
(98, NULL, 284, NULL, NULL, 12.0, NULL),
(99, NULL, 285, NULL, NULL, 12.0, NULL),
(100, NULL, 290, NULL, NULL, 0.0, NULL),
(101, NULL, 295, NULL, NULL, 0.0, NULL),
(102, NULL, 297, NULL, NULL, 0.0, NULL),
(103, NULL, 302, NULL, NULL, 0.0, NULL),
(104, NULL, 307, NULL, NULL, 0.0, NULL),
(105, NULL, 312, NULL, NULL, 0.0, NULL),
(106, NULL, 317, NULL, NULL, 0.0, NULL),
(107, NULL, 326, NULL, NULL, 0.0, NULL),
(108, NULL, 331, NULL, NULL, 0.0, NULL),
(109, NULL, 336, NULL, NULL, 0.0, NULL),
(110, NULL, 341, NULL, NULL, 0.0, NULL),
(111, NULL, 342, NULL, NULL, 0.0, NULL),
(112, NULL, 343, NULL, NULL, 0.0, NULL),
(113, NULL, 352, NULL, NULL, 0.0, NULL),
(114, NULL, 353, NULL, NULL, 0.0, NULL),
(115, NULL, 354, NULL, NULL, 0.0, NULL),
(116, NULL, 359, NULL, NULL, 0.0, NULL),
(117, NULL, 360, NULL, NULL, 0.0, NULL),
(118, NULL, 365, NULL, NULL, 0.0, NULL),
(119, NULL, 366, NULL, NULL, 0.0, NULL),
(120, NULL, 367, NULL, NULL, 0.0, NULL),
(121, NULL, 368, NULL, NULL, 0.0, NULL),
(122, NULL, 373, NULL, NULL, 0.0, NULL),
(123, NULL, 378, NULL, NULL, 0.0, NULL),
(124, NULL, 379, NULL, NULL, 0.0, NULL),
(125, NULL, 380, NULL, NULL, 0.0, NULL),
(126, NULL, 381, NULL, NULL, 0.0, NULL),
(127, NULL, 382, NULL, NULL, 0.0, NULL),
(128, NULL, 387, NULL, NULL, 0.0, NULL),
(129, NULL, 396, NULL, NULL, 0.0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `state_id` int(11) NOT NULL,
  `state` varchar(14) DEFAULT NULL,
  `postal_code` varchar(2) DEFAULT NULL,
  `capitol` varchar(14) DEFAULT NULL,
  `largest_city` varchar(14) DEFAULT NULL,
  `statehood` date DEFAULT NULL,
  `land_area` int(6) DEFAULT NULL,
  `no_counties` int(3) DEFAULT NULL,
  `region` int(1) DEFAULT NULL,
  `2010_pop` int(8) DEFAULT NULL,
  `2000_pop` int(8) DEFAULT NULL,
  `electors` int(2) DEFAULT NULL,
  `house_seats` int(2) DEFAULT NULL,
  `color` varchar(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `birth_place`
--
ALTER TABLE `birth_place`
  ADD PRIMARY KEY (`birth_place_id`);

--
-- Indexes for table `class`
--
ALTER TABLE `class`
  ADD PRIMARY KEY (`class_id`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`contact_id`);

--
-- Indexes for table `cultural_region`
--
ALTER TABLE `cultural_region`
  ADD PRIMARY KEY (`cultural_id`);

--
-- Indexes for table `cultural_region_lookup`
--
ALTER TABLE `cultural_region_lookup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `member`
--
ALTER TABLE `member`
  ADD PRIMARY KEY (`member_id`);

--
-- Indexes for table `member_class_lookup`
--
ALTER TABLE `member_class_lookup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `member_contact_lookup`
--
ALTER TABLE `member_contact_lookup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `region`
--
ALTER TABLE `region`
  ADD PRIMARY KEY (`region_id`);

--
-- Indexes for table `snow`
--
ALTER TABLE `snow`
  ADD PRIMARY KEY (`snow_id`);

--
-- Indexes for table `state`
--
ALTER TABLE `state`
  ADD PRIMARY KEY (`state_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `birth_place`
--
ALTER TABLE `birth_place`
  MODIFY `birth_place_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cultural_region`
--
ALTER TABLE `cultural_region`
  MODIFY `cultural_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `cultural_region_lookup`
--
ALTER TABLE `cultural_region_lookup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT for table `member`
--
ALTER TABLE `member`
  MODIFY `member_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `member_contact_lookup`
--
ALTER TABLE `member_contact_lookup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `region`
--
ALTER TABLE `region`
  MODIFY `region_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `snow`
--
ALTER TABLE `snow`
  MODIFY `snow_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=130;

--
-- AUTO_INCREMENT for table `state`
--
ALTER TABLE `state`
  MODIFY `state_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
