-- MySQL dump 10.13  Distrib 5.6.11, for osx10.7 (x86_64)
--
-- Host: localhost    Database: birdclub
-- ------------------------------------------------------
-- Server version	5.6.11

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bird`
--

CREATE DATABASE birdclub DEFAULT CHARSET UTF8;
USE birdclub;

DROP TABLE IF EXISTS `bird`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bird` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `common` varchar(50) DEFAULT NULL,
  `scientific` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bird`
--

LOCK TABLES `bird` WRITE;
/*!40000 ALTER TABLE `bird` DISABLE KEYS */;
INSERT INTO `bird` VALUES (1,'Black-billed Magpie','Pica hudsonia'),(2,'American Crow','Corvus brachyrhynchos'),(3,'Common Raven','Corvus corax'),(4,'Bobolink','Dolichonyx oryzivorus'),(5,'Red-winged Blackbird','Agelaius phoeniceus'),(6,'Eastern Meadowlark','Sturnella magna'),(7,'Western Meadowlark','Sturnella neglecta'),(8,'Yellow-headed Blackbird','Xanthocephalus xanthocephalus'),(9,'Rusty Blackbird','Euphagus carolinus'),(10,'Brewer\'s Blackbird','Euphagus cyanocephalus'),(11,'Common Grackle','Quiscalus quiscula'),(12,'Brown-headed Cowbird','Molothrus ater'),(13,'Bullock\'s Oriole','Icterus bullockii'),(14,'Baltimore Oriole','Icterus galbula'),(15,'Scott\'s Oriole','Icterus parisorium'),(16,'Purple Finch','Carpodacus purpureus'),(17,'House Sparrow','Passer domesticus'),(18,'Brewer\'s Sparrow','Spizella breweri'),(19,'Field Sparrow','Spizella pusilla');
/*!40000 ALTER TABLE `bird` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `person`
--

DROP TABLE IF EXISTS `person`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `first` varchar(25) DEFAULT NULL,
  `last` varchar(25) DEFAULT NULL,
  `email` varchar(35) DEFAULT NULL,
  `phone` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `person`
--

LOCK TABLES `person` WRITE;
/*!40000 ALTER TABLE `person` DISABLE KEYS */;
INSERT INTO `person` VALUES (1,'Bob','Smith','bs@mynet.ca','555-1234'),(2,'Robert','Smith','robs@blah.ca','555-1224'),(3,'Sue','McKinney','suziemac@bogusisp.ca',NULL),(4,'Allyson','Zurita','a2z@shaw.ca','555-1873'),(5,'Kelly','Foard','theKelly@foard.com','555-1432'),(6,'Cody','Outland','outland@shaw.ca','432-2884'),(7,'Jamie','Ryckman','jr@telus.net','983-2842'),(8,'Javier','Maugeri','notjavierbardem@shaw.ca',NULL),(9,'Fernando','Kinzer',NULL,'499-0092'),(10,'Malinda','Soules','soufle@food.net','776-2284'),(11,'Allan','Moffet','moff@sportsnet.ca','887-8220'),(12,'Max','Keown','themax@blah.ca',NULL),(13,'Guy','Madril','madguy@movies.net','772-3375'),(14,'Ted','Hebel','th@hebel.web','887-2884'),(15,'Allan','Weigand','aweig@telus.net','332-7793'),(16,'Kurt','Matis',NULL,'887-0092'),(17,'Steve','Martin','crazyguy@aol.net',NULL);
/*!40000 ALTER TABLE `person` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sighting`
--

DROP TABLE IF EXISTS `sighting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sighting` (
  `person_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bird_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sighting`
--

LOCK TABLES `sighting` WRITE;
/*!40000 ALTER TABLE `sighting` DISABLE KEYS */;
INSERT INTO `sighting` VALUES (1,1,'2012-06-01'),(1,3,'2012-06-01'),(6,8,'2012-05-03'),(1,5,'2012-04-01'),(3,13,'2011-08-21'),(9,3,'2011-08-10'),(17,12,'2011-05-13'),(13,7,'2011-12-10'),(3,14,'2011-03-07'),(6,10,'2011-12-19'),(16,16,'2011-12-29'),(1,9,'2011-12-07'),(2,11,'2010-11-19'),(3,5,'2010-01-28'),(11,19,'2010-03-23'),(12,9,'2010-12-31'),(17,17,'2010-07-27'),(12,10,'2010-11-01'),(16,13,'2009-12-02'),(4,17,'2009-08-28'),(7,11,'2009-06-16'),(14,10,'2009-05-13'),(9,11,'2009-02-06'),(17,3,'2009-02-28'),(1,14,'2012-10-22'),(4,11,'2009-06-06'),(1,14,'2013-06-08');
/*!40000 ALTER TABLE `sighting` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2013-06-10 11:08:45
