 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2017-05-15 16:39:25
+-- Dump completed on 2017-05-16 18:22:56

CREATE DATABASE  IF NOT EXISTS `menagerie` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `menagerie`;
-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: menagerie

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `animals`
--

DROP TABLE IF EXISTS `animals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `animals` (
  `id` mediumint(8) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` char(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `animals`
--

LOCK TABLES `animals` WRITE;
/*!40000 ALTER TABLE `animals` DISABLE KEYS */;
INSERT INTO `animals` VALUES (00000001,'dog'),(00000002,'cat'),(00000003,'penguin'),(00000101,'people');
/*!40000 ALTER TABLE `animals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `animals_two`
--

DROP TABLE IF EXISTS `animals_two`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `animals_two` (
  `grp` enum('fish','mammal','bird') NOT NULL,
  `id` mediumint(8) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` char(30) NOT NULL,
  PRIMARY KEY (`grp`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `animals_two`
--

LOCK TABLES `animals_two` WRITE;
/*!40000 ALTER TABLE `animals_two` DISABLE KEYS */;
INSERT INTO `animals_two` VALUES ('mammal',00000001,'dog'),('mammal',00000002,'cat'),('bird',00000001,'penguin'),('fish',00000001,'lax'),('mammal',00000003,'whale'),('bird',00000002,'ostrich');
/*!40000 ALTER TABLE `animals_two` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `event`
--

