SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES'; -- ----------------------------------------------------- -- Table `nodeTypeT` -- ----------------------------------------------------- DROP TABLE IF EXISTS `nodeTypeT` ; CREATE TABLE IF NOT EXISTS `nodeTypeT` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `forceSingleNode` ENUM('y') NULL, `internalTypeId` VARCHAR(10) BINARY NOT NULL COMMENT 'refers to internalTypeT.id', `forceSingleType` ENUM('y') NULL COMMENT 'filled in automatically by trigger', `code` VARCHAR(30) BINARY NULL, `forceSinglePhoto` ENUM('y') NULL, `canEditType` ENUM('n','y') NOT NULL DEFAULT 'n', `canEditNode` ENUM('n','y') NOT NULL, `canHavePhoto` ENUM('n','y') NOT NULL DEFAULT 'n', `canLinkFrom` ENUM('n','y') NOT NULL DEFAULT 'n', `canLinkTo` ENUM('n','y') NOT NULL DEFAULT 'n', `canSearch` ENUM('n','y') NOT NULL DEFAULT 'n', `displayInObject` ENUM('n','y') NOT NULL DEFAULT 'n', `displayInObjectList` ENUM('n','y') NOT NULL DEFAULT 'n', `searchAnd` ENUM('n','y') NOT NULL DEFAULT 'n', `displayNode` ENUM('n','y') NOT NULL DEFAULT 'y', `requiredForObject` ENUM('n','y') NOT NULL DEFAULT 'n', `sorter` INT NOT NULL DEFAULT 0, `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `sorter_idx` (`sorter` ASC), INDEX `canedittype_idx` (`canEditType` ASC), INDEX `canlinkfrom_idx` (`canLinkFrom` ASC), INDEX `canlinkto_idx` (`canLinkTo` ASC), INDEX `cansearch_idx` (`canSearch` ASC), UNIQUE INDEX `internaltypeid_uq` (`internalTypeId` ASC, `forceSingleType` ASC), INDEX `caneditnode_idx` (`canEditNode` ASC), UNIQUE INDEX `code_UNIQUE` (`code` ASC), INDEX `forcesinglenode_idx` (`id` ASC, `forceSingleNode` ASC), INDEX `displaynode_idx` (`displayNode` ASC), INDEX `requiredforobject_idx` (`requiredForObject` ASC), CONSTRAINT `fk_nodeTypeT_internalTypeT1` FOREIGN KEY (`internalTypeId` , `forceSingleType`) REFERENCES `internalTypeT` (`id` , `forceSingleType`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; -- ----------------------------------------------------- -- Data for table `nodeTypeT` -- ----------------------------------------------------- START TRANSACTION; INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (1, NULL, 'user', 'y', 'user', 'y', 'n', 'y', 'y', 'y', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 1, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (2, NULL, 'object', 'y', 'object', NULL, 'n', 'y', 'y', 'n', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 2, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (3, 'y', 'tag', NULL, 'rootgeo', 'y', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'y', 'y', 3, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (4, 'y', 'tag', NULL, 'rootamenity', 'y', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 4, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (5, 'y', 'tag', NULL, 'rootsubmission', 'y', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 5, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (6, 'y', 'tag', NULL, 'rootuser', 'y', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 6, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (7, NULL, 'tag', NULL, 'locality', 'y', 'n', 'y', 'n', 'y', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 10, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (8, NULL, 'tag', NULL, 'neighborhood', 'y', 'n', 'y', 'n', 'y', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 30, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (9, NULL, 'tag', NULL, 'street', 'y', 'n', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 40, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (10, NULL, 'tag', NULL, 'amenity', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 80, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (11, NULL, 'tag', NULL, 'estatetype', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'n', 60, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (12, NULL, 'tag', NULL, 'submissiontype', 'y', 'y', 'y', 'n', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 20, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (13, NULL, 'tag', NULL, 'wallmaterial', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'n', 100, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (14, NULL, 'tag', NULL, 'roofmaterial', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'n', 110, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (15, NULL, 'tag', NULL, 'supply', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 120, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (16, NULL, 'tag', NULL, 'extamenity', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 90, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (17, NULL, 'attribute', NULL, 'geoattribute', 'y', 'n', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 50, NULL, NULL); INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (18, NULL, 'attribute', NULL, 'genericattribute', 'y', 'y', 'y', 'n', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'n', 70, NULL, NULL); COMMIT;