--
-- Host: localhost    Database: sp6_taxontreetesting
-- ------------------------------------------------------


--
-- Table structure for table `taxontreedefitem`
--

CREATE TABLE `taxontreedefitem` (
  `TaxonTreeDefItemID` int(11) NOT NULL AUTO_INCREMENT,
  `TimestampCreated` datetime NOT NULL,
  `TimestampModified` datetime DEFAULT NULL,
  `Version` int(11) DEFAULT NULL,
  `FormatToken` varchar(32) DEFAULT NULL,
  `FullNameSeparator` varchar(32) DEFAULT NULL,
  `IsEnforced` bit(1) DEFAULT NULL,
  `IsInFullName` bit(1) DEFAULT NULL,
  `Name` varchar(64) NOT NULL,
  `RankID` int(11) NOT NULL,
  `Remarks` text,
  `TextAfter` varchar(64) DEFAULT NULL,
  `TextBefore` varchar(64) DEFAULT NULL,
  `ModifiedByAgentID` int(11) DEFAULT NULL,
  `ParentItemID` int(11) DEFAULT NULL,
  `TaxonTreeDefID` int(11) NOT NULL,
  `CreatedByAgentID` int(11) DEFAULT NULL,
  `Title` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`TaxonTreeDefItemID`),
  KEY `FKF29A82307699B003` (`CreatedByAgentID`),
  KEY `FKF29A82306A76BE4B` (`ParentItemID`),
  KEY `FKF29A8230EFA9D5F8` (`TaxonTreeDefID`),
  KEY `FKF29A82305327F942` (`ModifiedByAgentID`),
  CONSTRAINT `FKF29A82305327F942` FOREIGN KEY (`ModifiedByAgentID`) REFERENCES `agent` (`AgentID`),
  CONSTRAINT `FKF29A82306A76BE4B` FOREIGN KEY (`ParentItemID`) REFERENCES `taxontreedefitem` (`TaxonTreeDefItemID`),
  CONSTRAINT `FKF29A82307699B003` FOREIGN KEY (`CreatedByAgentID`) REFERENCES `agent` (`AgentID`),
  CONSTRAINT `FKF29A8230EFA9D5F8` FOREIGN KEY (`TaxonTreeDefID`) REFERENCES `taxontreedef` (`TaxonTreeDefID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `taxontreedefitem`
--

INSERT INTO `taxontreedefitem` VALUES (1,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','\0','Life',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL),(2,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','\0','Kingdom',10,NULL,NULL,NULL,NULL,1,1,NULL,NULL),(3,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subkingdom',20,NULL,NULL,NULL,NULL,2,1,NULL,NULL),(4,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','\0','Division',30,NULL,NULL,NULL,NULL,3,1,NULL,NULL),(5,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subdivision',40,NULL,NULL,NULL,NULL,4,1,NULL,NULL),(6,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','\0','Class',60,NULL,NULL,NULL,NULL,5,1,NULL,NULL),(7,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subclass',70,NULL,NULL,NULL,NULL,6,1,NULL,NULL),(8,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','\0','Order',100,NULL,NULL,NULL,NULL,7,1,NULL,NULL),(9,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Suborder',110,NULL,NULL,NULL,NULL,8,1,NULL,NULL),(10,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','\0','Family',140,NULL,NULL,NULL,NULL,9,1,NULL,NULL),(11,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subfamily',150,NULL,NULL,NULL,NULL,10,1,NULL,NULL),(12,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Tribe',160,NULL,NULL,NULL,NULL,11,1,NULL,NULL),(13,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subtribe',170,NULL,NULL,NULL,NULL,12,1,NULL,NULL),(14,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','','Genus',180,NULL,NULL,NULL,NULL,13,1,NULL,NULL),(15,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subgenus',190,NULL,NULL,NULL,NULL,14,1,NULL,NULL),(16,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Section',200,NULL,NULL,NULL,NULL,15,1,NULL,NULL),(17,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','\0','Subsection',210,NULL,NULL,NULL,NULL,16,1,NULL,NULL),(18,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','','','Species',220,NULL,NULL,NULL,NULL,17,1,NULL,NULL),(19,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','','Subspecies',230,NULL,NULL,'ssp. ',NULL,18,1,NULL,NULL),(20,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','','Variety',240,NULL,NULL,'var. ',NULL,19,1,NULL,NULL),(21,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','','Subvariety',250,NULL,NULL,'subvar. ',NULL,20,1,NULL,NULL),(22,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','','Forma',260,NULL,NULL,'f. ',NULL,21,1,NULL,NULL),(23,'2010-01-14 15:59:20','2010-01-14 15:59:20',1,NULL,' ','\0','','Subforma',270,NULL,NULL,'subf. ',NULL,22,1,NULL,NULL);


