-- MySQL dump 10.9 -- -- Host: localhost Database: GlassSlipper -- ------------------------------------------------------ -- Server version 5.0.21-standard /*!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 */; /*!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" */; -- -- Table structure for table `AvailableDogs` -- CREATE TABLE `AvailableDogs` ( `dogID` tinyint(3) NOT NULL, `vendorID` tinyint(3) default NULL, `vendorDogID` varchar(50) default NULL, `breedID1` varchar(50) default NULL, `breedID2` varchar(50) default NULL, `vendorComments` text, `witnessComments` text, `witnessName` varchar(50) default NULL, `vendorAgent` varchar(50) default NULL, `age` varchar(50) default NULL, `gender` varchar(50) default NULL, `height` varchar(50) default NULL, `weight` varchar(50) default NULL, `coat` varchar(50) default NULL, `color` varchar(50) default NULL, `askingPrice` varchar(50) default NULL, PRIMARY KEY (`dogID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `AvailableDogs` -- /*!40000 ALTER TABLE `AvailableDogs` DISABLE KEYS */; LOCK TABLES `AvailableDogs` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `AvailableDogs` ENABLE KEYS */; -- -- Table structure for table `Breeds` -- CREATE TABLE `Breeds` ( `BreedID` tinyint(3) unsigned zerofill NOT NULL default '001', `GroupID` tinyint(1) NOT NULL default '0', `BreedName` varchar(40) NOT NULL default '', `BreedDescription` text, `MinActivityIndoors` tinyint(1) unsigned default '0', `MaxActivityIndoors` tinyint(1) unsigned default '0', `MinActivityOutdoors` tinyint(1) unsigned default '0', `MaxActivityOutdoors` tinyint(1) unsigned default '0', `MinVigor` tinyint(1) unsigned default '0', `MaxVigor` tinyint(1) unsigned default '0', `MinFocus` tinyint(1) unsigned default '0', `MaxFocus` tinyint(1) unsigned default '0', `MinDominanceDogs` tinyint(1) unsigned default NULL, `MaxDominanceDogs` tinyint(1) unsigned default NULL, `MinDominancePeople` tinyint(1) unsigned default NULL, `MaxDominacePeople` tinyint(1) unsigned default NULL, `MinTerritoriality` tinyint(1) unsigned default NULL, `MaxTerritoriality` tinyint(1) unsigned default NULL, `MinStability` tinyint(1) unsigned default NULL, `MaxStability` tinyint(1) unsigned default NULL, `MinSociability` tinyint(1) unsigned default NULL, `MaxSociability` tinyint(1) unsigned default NULL, `MinSociabilityFamily` tinyint(1) unsigned default NULL, `MaxSociabilityFamily` tinyint(1) unsigned default NULL, `MinSociabilityChildren` tinyint(1) unsigned default NULL, `MaxSociablityChildren` tinyint(1) unsigned default NULL, `MinSociabilityStrangers` tinyint(1) unsigned default NULL, `MaxSociabilityStrangers` tinyint(1) unsigned default NULL, `MinLearningRate` tinyint(1) unsigned default NULL, `MaxLearningRate` tinyint(1) unsigned default NULL, `MinObedience` tinyint(1) unsigned default NULL, `MaxObedience` tinyint(1) unsigned default NULL, `MinProblemSolving` tinyint(1) unsigned default NULL, `MaxProblemSolving` tinyint(1) unsigned default NULL, `MinWatchdog` tinyint(1) unsigned default NULL, `MaxWatchdog` tinyint(1) unsigned default NULL, `MinGuarding` tinyint(1) unsigned default NULL, `MaxGuarding` tinyint(1) unsigned default NULL, `BulkRatioMale` decimal(3,2) default NULL, `BulkRatioFemale` decimal(3,2) default NULL, `MinHeighMale` tinyint(2) default NULL, `MaxHeightMale` tinyint(2) default NULL, `MinWeightMale` tinyint(3) unsigned default '0', `MaxWeightMale` tinyint(3) unsigned default '0', `MinHeightFemale` tinyint(2) default NULL, `MaxHeightFemale` tinyint(2) default NULL, `MinWeightFemale` tinyint(3) default NULL, `MaxWeightFemale` tinyint(3) default NULL, `Coat` varchar(50) default NULL, `Color` varchar(50) default NULL, `GroomingDays` tinyint(1) unsigned default '0', `GroomingTime` tinyint(2) unsigned default '0', `Trimming` varchar(50) default NULL, `Shedding` varchar(50) default NULL, `AKCFunction` varchar(50) default NULL, `AKCBehavior` varchar(255) default NULL, PRIMARY KEY (`BreedID`), KEY `newfk` (`GroupID`), CONSTRAINT `newfk` FOREIGN KEY (`GroupID`) REFERENCES `group` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Information from appendix A and B from the book by Tortora'; -- -- Dumping data for table `Breeds` -- /*!40000 ALTER TABLE `Breeds` DISABLE KEYS */; LOCK TABLES `Breeds` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `Breeds` ENABLE KEYS */; -- -- Table structure for table `Group` -- CREATE TABLE `Group` ( `GroupID` tinyint(1) NOT NULL default '0', `Name` varchar(15) NOT NULL default '', `ShortDescription` varchar(100) default NULL, `LongDescription` text, PRIMARY KEY (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 MIN_ROWS=6 MAX_ROWS=15 COMMENT='Universal Table of Dog Groups. Group Descriptions taken from'; -- -- Dumping data for table `Group` -- /*!40000 ALTER TABLE `Group` DISABLE KEYS */; LOCK TABLES `Group` WRITE; INSERT INTO `Group` VALUES (-3,'Debatable','Group membership of breed is debated.',NULL),(-2,'Unknown','Group membership of breed is unknown to data entry clerk.',NULL),(-1,'Not Entered','Data has not yet been entered.',NULL),(0,'Mutt','Mixed breed. No breed clearly dominates.',NULL),(1,'Sporting','Beeds bred for assisting hunters by retrieving, pointing, flushing or the like.',NULL),(2,'Hound','Breeds bred for hunting and tracking by sight or smell.',NULL),(3,'Working','Breeds bred for herding, guarding or pulling.',NULL),(4,'Terrier','Breeds bred for ratting, varmint hunting, baiting and fighting other dogs.','The AKC recongnizes 22 breeds of Terriers. In size and shape they show less variety than the Working Dogs, ranging from the miniature Norwich Terrier, which measures about 10 inches and 10 pounds, the the largest Terriers - the lean Airedale at about 23 inches and 55 pounds and the stocky, fighting American Staffordshire, about 18 inches and up to 70 pounds. Terriers have been used for a variety of purposes including guarding; pit fighting; hunting small but vicious predators such as foxes, badgers and other small prey animals like rabbits; and finally as ratters. All these activities involve tenacity and a well-developed rage and attack reaction to threat and punishment. Terriers were not supposed to back down no matter how painful their wounds. As far back as 1560, Dr. John Caius wrote that the Terriers were \"quarrelsome and snappy animals, and to be tolerated only in the stables.\" Terriers have been modified since that time, so they may not all show this tenacious streak. The Terrier group includes the Airedale, American Staffordshire, Australian, Bedlington, Border, Bull, Cairn, Dandie Dinmont, Fox, Irish, Kerry Blue, Lakeland, Manchester, Miniature Schnauzer, Norwich, Scottish, Sealyham, Skye, Staffordshire Bull, Welsh, West Highland White and Wheaten. '),(5,'Toy','Breeds bred for smallness. Typically under 15 pounds.',NULL),(6,'Miscellaneous','Alternately called \"non-sporting.\" Those breeds whose original functions are no longer applicable.',NULL),(7,'Primitive','\"Primitive,\" or wild breeds, such as the dingo.',NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `Group` ENABLE KEYS */; -- -- Table structure for table `Login` -- CREATE TABLE `Login` ( `LoginID` int(3) NOT NULL, `LoginString` varchar(20) NOT NULL, `LoginPassword` varchar(20) NOT NULL, PRIMARY KEY (`LoginID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `Login` -- /*!40000 ALTER TABLE `Login` DISABLE KEYS */; LOCK TABLES `Login` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `Login` ENABLE KEYS */; -- -- Table structure for table `Person` -- CREATE TABLE `Person` ( `PersonID` int(3) NOT NULL, `LoginID` int(3) default NULL, `Restlessness` tinyint(1) default NULL, `Activity` tinyint(1) default NULL, `OtherSurveyResults` varchar(50) default NULL, PRIMARY KEY (`PersonID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `Person` -- /*!40000 ALTER TABLE `Person` DISABLE KEYS */; LOCK TABLES `Person` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `Person` ENABLE KEYS */; -- -- Table structure for table `Vendor` -- CREATE TABLE `Vendor` ( `VendorID` tinyint(2) NOT NULL, `VendorName` varchar(50) NOT NULL, `VendorAddress` varchar(50) default NULL, `VendorCity` varchar(50) default NULL, `VendorState` varchar(50) default NULL, `VendorPhone` varchar(50) default NULL, `VenderDescription` text, PRIMARY KEY (`VendorID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `Vendor` -- /*!40000 ALTER TABLE `Vendor` DISABLE KEYS */; LOCK TABLES `Vendor` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `Vendor` ENABLE KEYS */; /*!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 */;