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;

