-- 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