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 `internalTypeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `internalTypeT` ;

CREATE TABLE IF NOT EXISTS `internalTypeT` (
  `id` VARCHAR(10) BINARY NOT NULL,
  `forceSingleType` ENUM('y') NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `id_forcesingletype_id` (`id` ASC, `forceSingleType` ASC))
ENGINE = InnoDB
COMMENT = 'instead of enum for internal node type';


-- -----------------------------------------------------
-- 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',
  `canHaveRatingPoints` 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),
  INDEX `canhaveratingpoints_idx` (`canHaveRatingPoints` ASC),
  INDEX `canhavephoto_idx` (`canHavePhoto` ASC),
  CONSTRAINT `fk_nodeTypeT_internalTypeT1`
    FOREIGN KEY (`internalTypeId` , `forceSingleType`)
    REFERENCES `internalTypeT` (`id` , `forceSingleType`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `nodeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nodeT` ;

CREATE TABLE IF NOT EXISTS `nodeT` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `nodeTypeId` INT UNSIGNED NOT NULL,
  `forceSingleNode` ENUM('y') NULL,
  `forceSinglePhoto` ENUM('y') NULL,
  `name` VARCHAR(50) NOT NULL,
  `isRoot` ENUM('n','y') NOT NULL DEFAULT 'n',
  `displayNode` ENUM('n','y') NOT NULL DEFAULT 'y',
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `addedUserId` INT UNSIGNED NULL,
  `addedUserName` VARCHAR(255) NULL,
  `addedIp` VARCHAR(40) NULL,
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `changedUserId` INT UNSIGNED NULL,
  `changedUserName` VARCHAR(255) NULL,
  `changedIp` VARCHAR(40) NULL,
  PRIMARY KEY (`id`),
  INDEX `nodeT_id_nodeTypeId_idx` (`id` ASC, `nodeTypeId` ASC),
  UNIQUE INDEX `nodetypeid_forcesinglenode_uq` (`nodeTypeId` ASC, `forceSingleNode` ASC),
  INDEX `isroot_idx` (`isRoot` ASC),
  INDEX `id_forcesinglephoto_idx` (`id` ASC, `forceSinglePhoto` ASC),
  INDEX `displaynode_idx` (`displayNode` ASC),
  CONSTRAINT `fk_nodeT_nodeTypeT1`
    FOREIGN KEY (`nodeTypeId` , `forceSingleNode`)
    REFERENCES `nodeTypeT` (`id` , `forceSingleNode`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `nodeLinkTypeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nodeLinkTypeT` ;

CREATE TABLE IF NOT EXISTS `nodeLinkTypeT` (
  `id` INT UNSIGNED NOT NULL,
  `code` VARCHAR(30) BINARY NOT NULL,
  `forceSelfLink` ENUM('n','y') NOT NULL DEFAULT 'n',
  `isDefault` ENUM('y') NULL,
  `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`),
  UNIQUE INDEX `code_UNIQUE` (`code` ASC),
  INDEX `forceSelfLink_idx` (`forceSelfLink` ASC),
  UNIQUE INDEX `isDefault_UNIQUE` (`isDefault` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `nodeLinkT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nodeLinkT` ;

CREATE TABLE IF NOT EXISTS `nodeLinkT` (
  `nodeLinkTypeId` INT UNSIGNED NOT NULL,
  `srcNodeId` INT UNSIGNED NOT NULL,
  `dstNodeId` INT UNSIGNED NOT NULL,
  `metric` INT UNSIGNED NOT NULL DEFAULT 1,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `fk_nodeLinkT_nodeT2_idx` (`dstNodeId` ASC),
  UNIQUE INDEX `dstNodeId_srcNodeId_uq` (`nodeLinkTypeId` ASC, `dstNodeId` ASC, `srcNodeId` ASC),
  INDEX `metric_srcNodeId_idx` (`metric` ASC, `srcNodeId` ASC, `nodeLinkTypeId` ASC),
  INDEX `metric_dstNodeId_idx` (`metric` ASC, `dstNodeId` ASC, `nodeLinkTypeId` ASC),
  INDEX `fk_nodeLinkT_nodeLinkTypeT1_idx` (`nodeLinkTypeId` ASC),
  PRIMARY KEY (`nodeLinkTypeId`, `srcNodeId`, `dstNodeId`),
  INDEX `fk_nodeLinkT_nodeT1_idx` (`srcNodeId` ASC),
  CONSTRAINT `fk_nodeLinkT_nodeT2`
    FOREIGN KEY (`dstNodeId`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_nodeLinkT_nodeLinkTypeT1`
    FOREIGN KEY (`nodeLinkTypeId`)
    REFERENCES `nodeLinkTypeT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_nodeLinkT_nodeT1`
    FOREIGN KEY (`srcNodeId`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `languageT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `languageT` ;

CREATE TABLE IF NOT EXISTS `languageT` (
  `id` CHAR(3) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `sorter` INT NOT NULL,
  `isDefault` ENUM('y') NULL,
  `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`),
  UNIQUE INDEX `isDefault_UNIQUE` (`isDefault` ASC),
  INDEX `sorter_idx` (`sorter` ASC),
  INDEX `default_idx` (`isDefault` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `nodeTypeTL`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nodeTypeTL` ;

CREATE TABLE IF NOT EXISTS `nodeTypeTL` (
  `id` INT UNSIGNED NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`, `languageId`),
  INDEX `fk_nodeTypeTL_languageT1_idx` (`languageId` ASC),
  CONSTRAINT `fk_nodeTypeTL_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_nodeTypeTL_nodeTypeT1`
    FOREIGN KEY (`id`)
    REFERENCES `nodeTypeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `allowedNodeLinkT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `allowedNodeLinkT` ;

CREATE TABLE IF NOT EXISTS `allowedNodeLinkT` (
  `srcNodeTypeId` INT UNSIGNED NOT NULL,
  `dstNodeTypeId` INT UNSIGNED NOT NULL,
  `essential` ENUM('n','y') NOT NULL DEFAULT 'n',
  `singleSrc` ENUM('n','y') NOT NULL DEFAULT 'n',
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`srcNodeTypeId`, `dstNodeTypeId`),
  INDEX `fk_allowedNodeLinkT_nodeTypeT2_idx` (`dstNodeTypeId` ASC),
  INDEX `essential_idx` (`essential` ASC),
  INDEX `singlesrc_idx` (`singleSrc` ASC),
  CONSTRAINT `fk_allowedNodeLinkT_nodeTypeT1`
    FOREIGN KEY (`srcNodeTypeId`)
    REFERENCES `nodeTypeT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_allowedNodeLinkT_nodeTypeT2`
    FOREIGN KEY (`dstNodeTypeId`)
    REFERENCES `nodeTypeT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `userRoleT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `userRoleT` ;

CREATE TABLE IF NOT EXISTS `userRoleT` (
  `id` VARCHAR(30) BINARY NOT NULL,
  `isDefault` ENUM('y') NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `isDefault_UNIQUE` (`isDefault` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `userT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `userT` ;

CREATE TABLE IF NOT EXISTS `userT` (
  `id` INT UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(50) NULL,
  `email` VARCHAR(255) NULL,
  `login` VARCHAR(255) NOT NULL,
  `password` VARCHAR(100) NOT NULL,
  `roleId` VARCHAR(30) BINARY NOT NULL,
  `enabled` ENUM('n','y') NOT NULL DEFAULT 'y',
  `birthDate` DATE NULL,
  `preferredLanguage` CHAR(3) NULL,
  `token` VARCHAR(20) NULL,
  `phoneConfirmationCode` VARCHAR(255) NULL,
  `phoneConfirmationExpiry` DATETIME NULL,
  `emailConfirmationCode` VARCHAR(255) NULL,
  `emailConfirmationExpiry` DATETIME NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `login_UNIQUE` (`login` ASC),
  UNIQUE INDEX `phone_UNIQUE` (`phone` ASC),
  INDEX `fk_userT_languageT1_idx` (`preferredLanguage` ASC),
  INDEX `enabled_idx` (`enabled` ASC),
  INDEX `fk_userT_userRoleT1_idx` (`roleId` ASC),
  CONSTRAINT `fk_userT_nodeT1`
    FOREIGN KEY (`id`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_userT_languageT1`
    FOREIGN KEY (`preferredLanguage`)
    REFERENCES `languageT` (`id`)
    ON DELETE SET NULL
    ON UPDATE CASCADE,
  CONSTRAINT `fk_userT_userRoleT1`
    FOREIGN KEY (`roleId`)
    REFERENCES `userRoleT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `tagT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `tagT` ;

CREATE TABLE IF NOT EXISTS `tagT` (
  `id` INT UNSIGNED NOT NULL,
  `sorter` INT NOT NULL DEFAULT 0,
  `canSearch` ENUM('n','y') NOT NULL DEFAULT 'y',
  `canSearchRaw` ENUM('n','y') NULL,
  `displayInObject` ENUM('n','y') NOT NULL DEFAULT 'n',
  `displayInObjectRaw` ENUM('n','y') NULL,
  `displayInObjectList` ENUM('n','y') NOT NULL DEFAULT 'n',
  `displayInObjectListRaw` ENUM('n','y') NULL,
  `factor` DOUBLE NOT NULL DEFAULT 1.0 COMMENT 'relative measurement of tag importance - from 0.1 to 1;' /* comment truncated */ /*valid only for tag types with searchAnd = 'y'*/,
  `ratingPoints` INT UNSIGNED NOT NULL DEFAULT 0,
  `enabled` ENUM('n','y') NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`),
  INDEX `fk_searchLabelT_nodeT1_idx` (`id` ASC),
  INDEX `sorter_idx` (`sorter` ASC),
  INDEX `cansearch_idx` (`canSearch` ASC),
  INDEX `displayinobject_idx` (`displayInObject` ASC),
  INDEX `displayinobjectlist_idx` (`displayInObjectList` ASC),
  INDEX `ratingpoints_idx` (`ratingPoints` ASC),
  CONSTRAINT `fk_searchLabelT_nodeT1`
    FOREIGN KEY (`id`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `tagTL`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `tagTL` ;

CREATE TABLE IF NOT EXISTS `tagTL` (
  `id` INT UNSIGNED NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`, `languageId`),
  INDEX `fk_searchLabelTL_languageT1_idx` (`languageId` ASC),
  CONSTRAINT `fk_searchLabelTL_searchLabelT1`
    FOREIGN KEY (`id`)
    REFERENCES `tagT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_searchLabelTL_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `objectStatusT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `objectStatusT` ;

CREATE TABLE IF NOT EXISTS `objectStatusT` (
  `id` CHAR(10) BINARY NOT NULL,
  `public` ENUM('n','y') NOT NULL,
  `userEditable` ENUM('n','y') NOT NULL,
  `userDraftable` ENUM('n','y') NOT NULL,
  `isDefault` ENUM('y') NULL,
  `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`),
  UNIQUE INDEX `isDefault_UNIQUE` (`isDefault` ASC),
  INDEX `public_idx` (`public` ASC),
  INDEX `usereditable_idx` (`userEditable` ASC),
  INDEX `userdraftable_idx` (`userDraftable` ASC),
  INDEX `sorter_idx` (`sorter` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `objectT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `objectT` ;

CREATE TABLE IF NOT EXISTS `objectT` (
  `id` INT UNSIGNED NOT NULL,
  `address` TEXT NOT NULL,
  `description` TEXT NOT NULL,
  `statusId` CHAR(10) BINARY NOT NULL,
  `rating` DOUBLE NOT NULL DEFAULT 0.0,
  `noteForModerator` TEXT NULL,
  `noteForUser` TEXT NULL,
  `alias` TEXT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_objectT_objectStatusT1_idx` (`statusId` ASC),
  INDEX `rating_idx` (`rating` ASC),
  CONSTRAINT `fk_objectT_nodeT1`
    FOREIGN KEY (`id`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_objectT_objectStatusT1`
    FOREIGN KEY (`statusId`)
    REFERENCES `objectStatusT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `objectStatusTL`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `objectStatusTL` ;

CREATE TABLE IF NOT EXISTS `objectStatusTL` (
  `id` CHAR(10) BINARY NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`, `languageId`),
  INDEX `fk_objectStatusTL_languageT1_idx` (`languageId` ASC),
  CONSTRAINT `fk_objectStatusTL_objectStatusT1`
    FOREIGN KEY (`id`)
    REFERENCES `objectStatusT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_objectStatusTL_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `imageTypeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `imageTypeT` ;

CREATE TABLE IF NOT EXISTS `imageTypeT` (
  `id` CHAR(10) BINARY NOT NULL,
  `isDefault` ENUM('y') NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `isDefault_UNIQUE` (`isDefault` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `imageT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `imageT` ;

CREATE TABLE IF NOT EXISTS `imageT` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `nodeId` INT UNSIGNED NULL,
  `forceSinglePhoto` ENUM('y') NULL,
  `name` VARCHAR(255) NOT NULL,
  `filenameOriginal` VARCHAR(255) NOT NULL,
  `filenameFs` VARCHAR(255) NOT NULL,
  `display` ENUM('n','y') NOT NULL DEFAULT 'y',
  `sorter` INT NOT NULL,
  `imageTypeId` CHAR(10) BINARY NOT NULL,
  `videoType` VARCHAR(50) NOT NULL DEFAULT '',
  `url` VARCHAR(255) NOT NULL DEFAULT '',
  `extraId` VARCHAR(255) NOT NULL DEFAULT '',
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `addedUserId` INT UNSIGNED NULL,
  `addedUserName` VARCHAR(255) NULL,
  `addedIp` VARCHAR(40) NULL,
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `changedUserId` INT UNSIGNED NULL,
  `changedUserName` VARCHAR(255) NULL,
  `changedIp` VARCHAR(40) NULL,
  PRIMARY KEY (`id`),
  INDEX `objectIdSorter_idx` (`nodeId` ASC, `display` ASC, `sorter` ASC),
  UNIQUE INDEX `nodeid_forcesinglephoto_uq` (`nodeId` ASC, `forceSinglePhoto` ASC),
  INDEX `sorter_idx` (`nodeId` ASC, `sorter` ASC),
  INDEX `fk_imageT_imageTypeT1_idx` (`imageTypeId` ASC),
  CONSTRAINT `fk_imageT_nodeT1`
    FOREIGN KEY (`nodeId`)
    REFERENCES `nodeT` (`id`)
    ON DELETE SET NULL
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_imageT_imageTypeT1`
    FOREIGN KEY (`imageTypeId`)
    REFERENCES `imageTypeT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `internalDataTypeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `internalDataTypeT` ;

CREATE TABLE IF NOT EXISTS `internalDataTypeT` (
  `id` VARCHAR(10) BINARY NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
COMMENT = 'instead of enum for attribute data type';


-- -----------------------------------------------------
-- Table `attributeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeT` ;

CREATE TABLE IF NOT EXISTS `attributeT` (
  `id` INT UNSIGNED NOT NULL,
  `dataTypeId` VARCHAR(10) BINARY NOT NULL,
  `code` VARCHAR(30) BINARY NULL,
  `required` ENUM('n','y') NOT NULL DEFAULT 'n',
  `sortable` ENUM('n','y') NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`),
  INDEX `attributeT_idLabelId_idx` (`id` ASC),
  INDEX `datatype_idx` (`dataTypeId` ASC),
  INDEX `sortable_idx` (`sortable` ASC),
  UNIQUE INDEX `code_UNIQUE` (`code` ASC),
  CONSTRAINT `fk_attributeT_tagT1`
    FOREIGN KEY (`id`)
    REFERENCES `tagT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeT_internalDataTypeT1`
    FOREIGN KEY (`dataTypeId`)
    REFERENCES `internalDataTypeT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeTL`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeTL` ;

CREATE TABLE IF NOT EXISTS `attributeTL` (
  `id` INT UNSIGNED NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `uofmPre` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'unit of measure, localized',
  `uofmPost` VARCHAR(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`, `languageId`),
  INDEX `fk_attributeTL_languageT1_idx` (`languageId` ASC),
  CONSTRAINT `fk_attributeTL_attributeT1`
    FOREIGN KEY (`id`)
    REFERENCES `attributeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeTL_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeNumericT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeNumericT` ;

CREATE TABLE IF NOT EXISTS `attributeNumericT` (
  `id` INT UNSIGNED NOT NULL,
  `decimalMin` DECIMAL(22,6) NULL,
  `decimalMax` DECIMAL(22,6) NULL,
  `decimalRound` INT NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_attributeNumericT_attributeT1`
    FOREIGN KEY (`id`)
    REFERENCES `attributeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeValueNumericT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeValueNumericT` ;

CREATE TABLE IF NOT EXISTS `attributeValueNumericT` (
  `attributeId` INT UNSIGNED NOT NULL,
  `objectId` INT UNSIGNED NOT NULL,
  `value` DECIMAL(22,6) NOT NULL,
  `valueRaw` DECIMAL(22,6) NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `value_idx` (`value` ASC),
  PRIMARY KEY (`attributeId`, `objectId`),
  INDEX `fk_attributeValueNumericT_objectT1_idx` (`objectId` ASC),
  CONSTRAINT `fk_attributeValueNumericT_attributeNumericT1`
    FOREIGN KEY (`attributeId`)
    REFERENCES `attributeNumericT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeValueNumericT_objectT1`
    FOREIGN KEY (`objectId`)
    REFERENCES `objectT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeDatetimeFormatT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeDatetimeFormatT` ;

CREATE TABLE IF NOT EXISTS `attributeDatetimeFormatT` (
  `id` VARCHAR(10) BINARY NOT NULL,
  `storageFormat` VARCHAR(30) NOT NULL,
  `sorter` INT NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `sorter_idx` (`sorter` ASC),
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeDatetimeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeDatetimeT` ;

CREATE TABLE IF NOT EXISTS `attributeDatetimeT` (
  `id` INT UNSIGNED NOT NULL,
  `datetimeStorageId` VARCHAR(10) BINARY NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_attributeDatetimeT_attributeDatetimeFormatT1_idx` (`datetimeStorageId` ASC),
  CONSTRAINT `fk_attributeDatetimeT_attributeT1`
    FOREIGN KEY (`id`)
    REFERENCES `attributeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeDatetimeT_attributeDatetimeFormatT1`
    FOREIGN KEY (`datetimeStorageId`)
    REFERENCES `attributeDatetimeFormatT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeValueDatetimeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeValueDatetimeT` ;

CREATE TABLE IF NOT EXISTS `attributeValueDatetimeT` (
  `attributeId` INT UNSIGNED NOT NULL,
  `objectId` INT UNSIGNED NOT NULL,
  `value` DATETIME NOT NULL,
  `valueRaw` DATETIME NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `value_idx` (`value` ASC),
  PRIMARY KEY (`attributeId`, `objectId`),
  INDEX `fk_attributeValueDatetimeT_objectT1_idx` (`objectId` ASC),
  CONSTRAINT `fk_attributeValueDatetimeT_attributeDatetimeT1`
    FOREIGN KEY (`attributeId`)
    REFERENCES `attributeDatetimeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeValueDatetimeT_objectT1`
    FOREIGN KEY (`objectId`)
    REFERENCES `objectT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeDatetimeFormatTL`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeDatetimeFormatTL` ;

CREATE TABLE IF NOT EXISTS `attributeDatetimeFormatTL` (
  `id` VARCHAR(10) BINARY NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `outputFormat` VARCHAR(30) NOT NULL,
  `outputFormatJs` VARCHAR(30) NOT NULL,
  PRIMARY KEY (`languageId`, `id`),
  INDEX `fk_attributeDatetimeFormatTL_languageT1_idx` (`languageId` ASC),
  INDEX `fk_attributeDatetimeFormatTL_attributeDatetimeFormatT1_idx` (`id` ASC),
  CONSTRAINT `fk_attributeDatetimeFormatTL_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeDatetimeFormatTL_attributeDatetimeFormatT1`
    FOREIGN KEY (`id`)
    REFERENCES `attributeDatetimeFormatT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeTextT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeTextT` ;

CREATE TABLE IF NOT EXISTS `attributeTextT` (
  `id` INT UNSIGNED NOT NULL,
  `textIsLong` ENUM('n','y') NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_attributeText_attributeT1`
    FOREIGN KEY (`id`)
    REFERENCES `attributeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeValueTextT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeValueTextT` ;

CREATE TABLE IF NOT EXISTS `attributeValueTextT` (
  `attributeId` INT UNSIGNED NOT NULL,
  `objectId` INT UNSIGNED NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `value` TEXT NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`attributeId`, `objectId`, `languageId`),
  INDEX `fk_attributeValueTextT_languageT1_idx` (`languageId` ASC),
  INDEX `fk_attributeValueTextT_objectT1_idx` (`objectId` ASC),
  CONSTRAINT `fk_attributeValueTextT_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeValueTextT_attributeText1`
    FOREIGN KEY (`attributeId`)
    REFERENCES `attributeTextT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_attributeValueTextT_objectT1`
    FOREIGN KEY (`objectId`)
    REFERENCES `objectT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `templateT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `templateT` ;

CREATE TABLE IF NOT EXISTS `templateT` (
  `srcNodeTypeId` INT UNSIGNED NOT NULL,
  `dstNodeId` INT UNSIGNED NOT NULL,
  `dstNodeTypeId` INT UNSIGNED NOT NULL COMMENT 'filled in automatically by trigger',
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`srcNodeTypeId`, `dstNodeId`),
  INDEX `fk_templateT_nodeT1_idx` (`dstNodeId` ASC, `dstNodeTypeId` ASC),
  INDEX `fk_templateT_allowedNodeLinkT1_idx` (`srcNodeTypeId` ASC, `dstNodeTypeId` ASC),
  CONSTRAINT `fk_attributeTemplateT_nodeTypeT1`
    FOREIGN KEY (`srcNodeTypeId`)
    REFERENCES `nodeTypeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_templateT_nodeT1`
    FOREIGN KEY (`dstNodeId` , `dstNodeTypeId`)
    REFERENCES `nodeT` (`id` , `nodeTypeId`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_templateT_allowedNodeLinkT1`
    FOREIGN KEY (`srcNodeTypeId` , `dstNodeTypeId`)
    REFERENCES `allowedNodeLinkT` (`srcNodeTypeId` , `dstNodeTypeId`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `zzzNodeWorksetT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzNodeWorksetT` ;

CREATE TABLE IF NOT EXISTS `zzzNodeWorksetT` (
  `nodeId` INT UNSIGNED NOT NULL,
  `connId` BIGINT UNSIGNED NOT NULL,
  `isMain` INT NOT NULL DEFAULT 1,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`nodeId`, `connId`),
  INDEX `added_idx` (`added` ASC),
  INDEX `connid_nodeid_ismain_idx` (`connId` ASC, `nodeId` ASC, `isMain` ASC),
  INDEX `ismain_idx` (`isMain` ASC))
ENGINE = MEMORY;


-- -----------------------------------------------------
-- Table `oauthProviderT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `oauthProviderT` ;

CREATE TABLE IF NOT EXISTS `oauthProviderT` (
  `id` VARCHAR(30) BINARY NOT NULL,
  `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`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `userOauthT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `userOauthT` ;

CREATE TABLE IF NOT EXISTS `userOauthT` (
  `userId` INT UNSIGNED NOT NULL,
  `oauthProviderId` VARCHAR(30) BINARY NOT NULL,
  `identity` VARCHAR(255) NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userId`, `oauthProviderId`),
  INDEX `fk_userOauthT_oauthProviderT1_idx` (`oauthProviderId` ASC),
  INDEX `provideridentity_idx` (`oauthProviderId` ASC, `identity` ASC),
  CONSTRAINT `fk_userOauthT_userT1`
    FOREIGN KEY (`userId`)
    REFERENCES `userT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_userOauthT_oauthProviderT1`
    FOREIGN KEY (`oauthProviderId`)
    REFERENCES `oauthProviderT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `zzzDevNullT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `externalDataSourceT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `externalDataSourceT` ;

CREATE TABLE IF NOT EXISTS `externalDataSourceT` (
  `id` VARCHAR(30) BINARY NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `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`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `externalDataT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `externalDataT` ;

CREATE TABLE IF NOT EXISTS `externalDataT` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `externalDataSourceId` VARCHAR(30) BINARY NOT NULL,
  `parentNodeId` INT UNSIGNED NOT NULL,
  `externalKey` VARCHAR(255) BINARY NOT NULL,
  `tagId` INT UNSIGNED NULL,
  `typeCode` VARCHAR(30) BINARY NOT NULL,
  `enabled` ENUM('n','y') NOT NULL DEFAULT 'y',
  `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 `fk_externalDataT_externalDataSourceT1_idx` (`externalDataSourceId` ASC),
  INDEX `fk_externalDataT_tagT1_idx` (`tagId` ASC),
  UNIQUE INDEX `externaldatasourceid_externalkey_uq` (`externalDataSourceId` ASC, `parentNodeId` ASC, `typeCode` ASC, `externalKey` ASC),
  INDEX `enabled_idx` (`externalDataSourceId` ASC, `enabled` ASC),
  UNIQUE INDEX `externaldatasourceid_tagid_uq` (`externalDataSourceId` ASC, `tagId` ASC),
  INDEX `fk_externalDataT_tagT2_idx` (`parentNodeId` ASC),
  INDEX `externalkey_idx` (`externalKey` ASC),
  CONSTRAINT `fk_externalDataT_externalDataSourceT1`
    FOREIGN KEY (`externalDataSourceId`)
    REFERENCES `externalDataSourceT` (`id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_externalDataT_tagT1`
    FOREIGN KEY (`tagId`)
    REFERENCES `tagT` (`id`)
    ON DELETE SET NULL
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_externalDataT_tagT2`
    FOREIGN KEY (`parentNodeId`)
    REFERENCES `tagT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `externalDataTL`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `externalDataTL` ;

CREATE TABLE IF NOT EXISTS `externalDataTL` (
  `id` INT UNSIGNED NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`, `languageId`),
  INDEX `fk_externalDataTL_languageT1_idx` (`languageId` ASC),
  CONSTRAINT `fk_externalDataTL_externalDataT1`
    FOREIGN KEY (`id`)
    REFERENCES `externalDataT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_externalDataTL_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `externalDataSourceDatasetT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `externalDataSourceDatasetT` ;

CREATE TABLE IF NOT EXISTS `externalDataSourceDatasetT` (
  `externalDataSourceId` VARCHAR(30) BINARY NOT NULL,
  `code` VARCHAR(255) NOT NULL,
  `nodeId` INT UNSIGNED NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`externalDataSourceId`, `code`),
  CONSTRAINT `fk_externalDataSourceDatasetT_externalDataSourceT1`
    FOREIGN KEY (`externalDataSourceId`)
    REFERENCES `externalDataSourceT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `externalOsmDictionaryT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `externalOsmDictionaryT` ;

CREATE TABLE IF NOT EXISTS `externalOsmDictionaryT` (
  `externalDataSourceId` VARCHAR(30) BINARY NOT NULL,
  `code` VARCHAR(255) NOT NULL,
  `boundingWayIds` VARCHAR(255) NOT NULL COMMENT 'ways ids for administrative bounds; taken from OSM',
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`externalDataSourceId`, `code`),
  CONSTRAINT `fk_osmDictionaryT_externalDataSourceDatasetT1`
    FOREIGN KEY (`externalDataSourceId` , `code`)
    REFERENCES `externalDataSourceDatasetT` (`externalDataSourceId` , `code`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `zzzIntsT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzIntsT` ;

CREATE TABLE IF NOT EXISTS `zzzIntsT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `searchSessionT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `searchSessionT` ;

CREATE TABLE IF NOT EXISTS `searchSessionT` (
  `id` BIGINT UNSIGNED NOT NULL,
  `sid` VARCHAR(100) BINARY NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `sessionId_UNIQUE` (`sid` ASC),
  INDEX `added_idx` (`added` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `searchCriterionT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `searchCriterionT` ;

CREATE TABLE IF NOT EXISTS `searchCriterionT` (
  `sessionId` BIGINT UNSIGNED NOT NULL,
  `nodeId` INT UNSIGNED NOT NULL,
  `nodeTypeId` INT UNSIGNED NULL,
  `internalTypeId` VARCHAR(10) BINARY NOT NULL,
  PRIMARY KEY (`sessionId`, `nodeId`),
  INDEX `fk_searchCriterion_nodeT1_idx` (`nodeId` ASC, `nodeTypeId` ASC),
  INDEX `nodetypeid_node_id` (`sessionId` ASC, `nodeTypeId` ASC, `nodeId` ASC),
  INDEX `fk_searchCriterionT_internalTypeT1_idx` (`internalTypeId` ASC),
  CONSTRAINT `fk_searchCriterion_session1`
    FOREIGN KEY (`sessionId`)
    REFERENCES `searchSessionT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_searchCriterion_nodeT1`
    FOREIGN KEY (`nodeId` , `nodeTypeId`)
    REFERENCES `nodeT` (`id` , `nodeTypeId`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_searchCriterionT_internalTypeT1`
    FOREIGN KEY (`internalTypeId`)
    REFERENCES `internalTypeT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `searchCriterionNumericT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `searchCriterionNumericT` ;

CREATE TABLE IF NOT EXISTS `searchCriterionNumericT` (
  `sessionId` BIGINT UNSIGNED NOT NULL,
  `nodeId` INT UNSIGNED NOT NULL,
  `valueLow` DECIMAL(22,6) NULL,
  `valueHigh` DECIMAL(22,6) NULL,
  PRIMARY KEY (`sessionId`, `nodeId`),
  CONSTRAINT `fk_searchCriterionNumericT_searchCriterionT1`
    FOREIGN KEY (`sessionId` , `nodeId`)
    REFERENCES `searchCriterionT` (`sessionId` , `nodeId`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `searchCriterionDatetimeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `searchCriterionDatetimeT` ;

CREATE TABLE IF NOT EXISTS `searchCriterionDatetimeT` (
  `sessionId` BIGINT UNSIGNED NOT NULL,
  `nodeId` INT UNSIGNED NOT NULL,
  `valueLow` DATETIME NULL,
  `valueHigh` DATETIME NULL,
  PRIMARY KEY (`sessionId`, `nodeId`),
  CONSTRAINT `fk_searchCriterionDatetimeT_searchCriterionT1`
    FOREIGN KEY (`sessionId` , `nodeId`)
    REFERENCES `searchCriterionT` (`sessionId` , `nodeId`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `searchResultT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `searchResultT` ;

CREATE TABLE IF NOT EXISTS `searchResultT` (
  `sessionId` BIGINT UNSIGNED NOT NULL,
  `nodeId` INT UNSIGNED NOT NULL,
  `collapsed` ENUM('n','y') NOT NULL DEFAULT 'n',
  `extraObjects` INT UNSIGNED NOT NULL DEFAULT 0,
  `relevancy` DOUBLE NOT NULL DEFAULT 0.0,
  PRIMARY KEY (`sessionId`, `nodeId`),
  INDEX `fk_searchResultT_nodeT1_idx` (`nodeId` ASC),
  INDEX `collapsed_idx` (`sessionId` ASC, `collapsed` ASC),
  INDEX `relevancy_idx` (`sessionId` ASC, `relevancy` ASC),
  CONSTRAINT `fk_searchResultT_sessionT1`
    FOREIGN KEY (`sessionId`)
    REFERENCES `searchSessionT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_searchResultT_nodeT1`
    FOREIGN KEY (`nodeId`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `tmpOsmDataT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `tmpOsmDataT` ;

CREATE TABLE IF NOT EXISTS `tmpOsmDataT` (
  `id` VARCHAR(50) NOT NULL,
  `highway` VARCHAR(100) NULL,
  `name_ukr` VARCHAR(255) NULL,
  `name_rus` VARCHAR(255) NULL,
  `name_eng` VARCHAR(255) NULL COMMENT 'temp table to import OSM data, one dataset at once',
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `zzzDevNull2T`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNull2T` ;

CREATE TABLE IF NOT EXISTS `zzzDevNull2T` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE
COMMENT = 'used in calls where the function already executes inserts to' /* comment truncated */ /* zzzDevNullT*/;


-- -----------------------------------------------------
-- Table `nodeAncestryT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nodeAncestryT` ;

CREATE TABLE IF NOT EXISTS `nodeAncestryT` (
  `id` INT UNSIGNED NOT NULL,
  `languageId` CHAR(3) NOT NULL,
  `tagNames` TEXT NULL,
  PRIMARY KEY (`id`, `languageId`),
  INDEX `fk_nodeAncestryT_languageT1_idx` (`languageId` ASC),
  CONSTRAINT `fk_nodeAncestryT_nodeT1`
    FOREIGN KEY (`id`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_nodeAncestryT_languageT1`
    FOREIGN KEY (`languageId`)
    REFERENCES `languageT` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `nodeAncestrySourceT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nodeAncestrySourceT` ;

CREATE TABLE IF NOT EXISTS `nodeAncestrySourceT` (
  `nodeTypeId` INT UNSIGNED NOT NULL,
  `srcNodeTypeId` INT UNSIGNED NOT NULL,
  `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 (`nodeTypeId`, `srcNodeTypeId`),
  INDEX `fk_nodeAncestrySourceT_nodeTypeT2_idx` (`srcNodeTypeId` ASC),
  INDEX `sorter_idx` (`nodeTypeId` ASC, `srcNodeTypeId` ASC, `sorter` ASC),
  CONSTRAINT `fk_nodeAncestrySourceT_nodeTypeT1`
    FOREIGN KEY (`nodeTypeId`)
    REFERENCES `nodeTypeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_nodeAncestrySourceT_nodeTypeT2`
    FOREIGN KEY (`srcNodeTypeId`)
    REFERENCES `nodeTypeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `coordT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `coordT` ;

CREATE TABLE IF NOT EXISTS `coordT` (
  `nodeId` INT UNSIGNED NOT NULL,
  `latitude` DECIMAL(12,7) NOT NULL,
  `longitude` DECIMAL(12,7) NOT NULL,
  PRIMARY KEY (`nodeId`),
  CONSTRAINT `fk_coordT_nodeT1`
    FOREIGN KEY (`nodeId`)
    REFERENCES `nodeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `zzzDevNullLinkT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullLinkT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullLinkT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `zzzDevNullNodeT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullNodeT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullNodeT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `zzzDevNullObjectT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullObjectT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullObjectT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `zzzDevNullExternalDataT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullExternalDataT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullExternalDataT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `zzzDevNullTemplateT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullTemplateT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullTemplateT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `cacheObjectSortT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `cacheObjectSortT` ;

CREATE TABLE IF NOT EXISTS `cacheObjectSortT` (
  `objectId` INT UNSIGNED NOT NULL,
  `attributeId` INT UNSIGNED NOT NULL,
  `sorterAsc` DOUBLE NULL,
  `sorterDesc` DOUBLE NULL,
  PRIMARY KEY (`objectId`, `attributeId`),
  INDEX `sorterasc_idx` (`attributeId` ASC, `sorterAsc` DESC),
  INDEX `sorterdesc_idx` (`attributeId` ASC, `sorterDesc` DESC),
  CONSTRAINT `fk_cacheObjectSortT_objectT1`
    FOREIGN KEY (`objectId`)
    REFERENCES `objectT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_cacheObjectSortT_attributeT1`
    FOREIGN KEY (`attributeId`)
    REFERENCES `attributeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `zzzDevNullSearchT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzDevNullSearchT` ;

CREATE TABLE IF NOT EXISTS `zzzDevNullSearchT` (
  `n` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`n`))
ENGINE = BLACKHOLE;


-- -----------------------------------------------------
-- Table `zzzValidCharT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `zzzValidCharT` ;

CREATE TABLE IF NOT EXISTS `zzzValidCharT` (
  `id` VARCHAR(1) BINARY NOT NULL,
  `purpose` VARCHAR(10) NOT NULL,
  `replacement` VARCHAR(1) BINARY NULL,
  `forceSingle` ENUM('n','y') NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`, `purpose`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `tagCacheT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `tagCacheT` ;

CREATE TABLE IF NOT EXISTS `tagCacheT` (
  `id` INT UNSIGNED NOT NULL,
  `tagNames` TEXT NULL,
  `tagNamesSearch` TEXT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_tagCacheT_tagT1`
    FOREIGN KEY (`id`)
    REFERENCES `tagT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `attributeCacheT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `attributeCacheT` ;

CREATE TABLE IF NOT EXISTS `attributeCacheT` (
  `id` INT UNSIGNED NOT NULL,
  `attributeNames` TEXT NULL,
  `attributeNamesSearch` TEXT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_attributeCacheT_attributeT1`
    FOREIGN KEY (`id`)
    REFERENCES `attributeT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `searchResultSelectedT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `searchResultSelectedT` ;

CREATE TABLE IF NOT EXISTS `searchResultSelectedT` (
  `sessionId` BIGINT UNSIGNED NOT NULL,
  `objectId` INT UNSIGNED NOT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sessionId`, `objectId`),
  INDEX `fk_searchResultSelectedT_objectT1_idx` (`objectId` ASC),
  INDEX `added_idx` (`sessionId` ASC, `added` ASC),
  CONSTRAINT `fk_searchResultSelectedT_searchSessionT1`
    FOREIGN KEY (`sessionId`)
    REFERENCES `searchSessionT` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_searchResultSelectedT_objectT1`
    FOREIGN KEY (`objectId`)
    REFERENCES `objectT` (`id`)
    ON DELETE CASCADE
    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 `internalTypeT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `internalTypeT` (`id`, `forceSingleType`, `added`) VALUES ('user', 'y', NULL);
INSERT INTO `internalTypeT` (`id`, `forceSingleType`, `added`) VALUES ('object', 'y', NULL);
INSERT INTO `internalTypeT` (`id`, `forceSingleType`, `added`) VALUES ('tag', NULL, NULL);
INSERT INTO `internalTypeT` (`id`, `forceSingleType`, `added`) VALUES ('attribute', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `nodeTypeT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (1, NULL, 'user', 'y', 'user', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 1, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (2, NULL, 'object', 'y', 'object', NULL, 'n', 'y', 'y', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 2, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (3, 'y', 'tag', NULL, 'rootgeo', 'y', 'n', '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`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (4, 'y', 'tag', NULL, 'rootamenity', 'y', 'n', '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`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (5, 'y', 'tag', NULL, 'rootsubmission', 'y', 'n', '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`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (6, 'y', 'tag', NULL, 'rootuser', 'y', 'n', '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`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (7, NULL, 'tag', NULL, 'locality', 'y', 'n', 'y', 'n', 'n', 'y', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 30, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (8, NULL, 'tag', NULL, 'neighborhood', 'y', 'n', 'y', 'n', 'n', 'y', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 40, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (9, NULL, 'tag', NULL, 'street', 'y', 'n', 'y', 'n', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 50, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `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', 'y', 'n', 80, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (11, NULL, 'tag', NULL, 'estatetype', 'y', '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`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (12, NULL, 'tag', NULL, 'submissiontype', 'y', 'y', 'y', 'n', 'n', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 10, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (13, NULL, 'tag', NULL, 'wallmaterial', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'n', 100, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (14, NULL, 'tag', NULL, 'roofmaterial', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'n', 110, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (15, NULL, 'tag', NULL, 'supply', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 120, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `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', 'y', 'n', 90, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (17, NULL, 'attribute', NULL, 'geoattribute', 'y', 'n', 'y', 'n', 'n', 'y', 'y', 'n', 'n', 'n', 'y', 'y', 'n', 60, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (18, NULL, 'attribute', NULL, 'genericattribute', 'y', 'y', 'y', 'n', 'n', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 70, NULL, NULL);
INSERT INTO `nodeTypeT` (`id`, `forceSingleNode`, `internalTypeId`, `forceSingleType`, `code`, `forceSinglePhoto`, `canEditType`, `canEditNode`, `canHavePhoto`, `canHaveRatingPoints`, `canLinkFrom`, `canLinkTo`, `canSearch`, `displayInObject`, `displayInObjectList`, `searchAnd`, `displayNode`, `requiredForObject`, `sorter`, `added`, `changed`) VALUES (19, NULL, 'attribute', NULL, 'hiddenattribute', 'y', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 7, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `nodeLinkTypeT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `nodeLinkTypeT` (`id`, `code`, `forceSelfLink`, `isDefault`, `added`, `changed`) VALUES (1, 'owns', 'n', 'y', NULL, NULL);
INSERT INTO `nodeLinkTypeT` (`id`, `code`, `forceSelfLink`, `isDefault`, `added`, `changed`) VALUES (2, 'fav', 'n', NULL, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `languageT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `languageT` (`id`, `name`, `sorter`, `isDefault`, `added`, `changed`) VALUES ('ukr', 'Українська', 1, 'y', NULL, NULL);
INSERT INTO `languageT` (`id`, `name`, `sorter`, `isDefault`, `added`, `changed`) VALUES ('rus', 'Русский', 2, NULL, NULL, NULL);
INSERT INTO `languageT` (`id`, `name`, `sorter`, `isDefault`, `added`, `changed`) VALUES ('eng', 'English', 3, NULL, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `nodeTypeTL`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (1, 'ukr', 'користувач');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (1, 'rus', 'пользователь');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (1, 'eng', 'user');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (2, 'ukr', 'об\'єкт');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (2, 'rus', 'объект');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (2, 'eng', 'object');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (3, 'ukr', 'Розміщення');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (3, 'rus', 'Расположение');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (3, 'eng', 'Location');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (4, 'ukr', 'Різновиди та зручності');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (4, 'rus', 'Разновидности и удобства');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (4, 'eng', 'Types and Amenities');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (5, 'ukr', 'Мета');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (5, 'rus', 'Цель');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (5, 'eng', 'Purpose');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (6, 'ukr', 'всі користувачі');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (6, 'rus', 'все пользователи');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (6, 'eng', 'all users');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (7, 'ukr', 'Населений пункт');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (7, 'rus', 'Населенный пункт');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (7, 'eng', 'Locality');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (8, 'ukr', 'Масив/Район');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (8, 'rus', 'Массив/Район');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (8, 'eng', 'Neighbourhood');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (9, 'ukr', 'Вулиця');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (9, 'rus', 'Улица');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (9, 'eng', 'Street');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (10, 'ukr', 'Зручності');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (10, 'rus', 'Удобства');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (10, 'eng', 'Amenities');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (11, 'ukr', 'Вид');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (11, 'rus', 'Вид');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (11, 'eng', 'Type');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (12, 'ukr', 'Мета');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (12, 'rus', 'Цель');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (12, 'eng', 'Purpose');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (13, 'ukr', 'Матеріал стін');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (13, 'rus', 'Материал стен');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (13, 'eng', 'Wall Material');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (14, 'ukr', 'Матеріал покрівлі');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (14, 'rus', 'Материал накрытия');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (14, 'eng', 'Roofing Material');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (15, 'ukr', 'Комунікації');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (15, 'rus', 'Коммуникации');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (15, 'eng', 'Supplies');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (16, 'ukr', 'Зовнішні зручності');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (16, 'rus', 'Внешние удобства');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (16, 'eng', 'External Amenities');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (17, 'ukr', 'Географічний атрибут');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (17, 'rus', 'Географический аттрибут');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (17, 'eng', 'Location Attribute');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (18, 'ukr', 'Загальні параметри');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (18, 'rus', 'Общие параметры');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (18, 'eng', 'Basic Parameters');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (19, 'ukr', 'Скриті атрибути');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (19, 'rus', 'Скрытые атрибуты');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (19, 'eng', 'Hidden Attributes');

COMMIT;


-- -----------------------------------------------------
-- Data for table `allowedNodeLinkT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 7, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 8, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 9, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (7, 8, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (7, 9, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (8, 9, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (6, 1, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 2, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (7, 2, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (9, 2, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 11, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 10, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 10, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 12, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 2, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (10, 2, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 2, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 10, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 10, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 13, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 14, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 13, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 14, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 13, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 14, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 13, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 14, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (13, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (14, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 15, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 15, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 15, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 15, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (15, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 16, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 16, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 16, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 16, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (16, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (1, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 17, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (7, 17, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (9, 17, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (17, 2, 'y', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (4, 18, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 18, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (11, 18, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 18, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (18, 2, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (8, 2, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (12, 11, 'n', 'n', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (5, 11, 'n', 'n', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `userRoleT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `userRoleT` (`id`, `isDefault`, `added`) VALUES ('user', 'y', NULL);
INSERT INTO `userRoleT` (`id`, `isDefault`, `added`) VALUES ('manager', NULL, NULL);
INSERT INTO `userRoleT` (`id`, `isDefault`, `added`) VALUES ('admin', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `objectStatusT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `objectStatusT` (`id`, `public`, `userEditable`, `userDraftable`, `isDefault`, `sorter`, `added`, `changed`) VALUES ('draft', 'n', 'y', 'n', 'y', 1, NULL, NULL);
INSERT INTO `objectStatusT` (`id`, `public`, `userEditable`, `userDraftable`, `isDefault`, `sorter`, `added`, `changed`) VALUES ('review', 'y', 'n', 'y', NULL, 2, NULL, NULL);
INSERT INTO `objectStatusT` (`id`, `public`, `userEditable`, `userDraftable`, `isDefault`, `sorter`, `added`, `changed`) VALUES ('approved', 'y', 'n', 'y', NULL, 3, NULL, NULL);
INSERT INTO `objectStatusT` (`id`, `public`, `userEditable`, `userDraftable`, `isDefault`, `sorter`, `added`, `changed`) VALUES ('rejected', 'n', 'n', 'y', NULL, 4, NULL, NULL);
INSERT INTO `objectStatusT` (`id`, `public`, `userEditable`, `userDraftable`, `isDefault`, `sorter`, `added`, `changed`) VALUES ('blocked', 'n', 'n', 'n', NULL, 5, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `objectStatusTL`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('draft', 'ukr', 'Чорновик');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('draft', 'rus', 'Черновик');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('draft', 'eng', 'Draft');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('review', 'ukr', 'На розгляді');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('review', 'rus', 'На рассмотрении');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('review', 'eng', 'Reviewed');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('approved', 'ukr', 'Підтверджено');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('approved', 'rus', 'Подтверждено');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('approved', 'eng', 'Approved');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('rejected', 'ukr', 'Відхилено');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('rejected', 'rus', 'Отклонено');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('rejected', 'eng', 'Rejected');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('blocked', 'ukr', 'Заблоковано');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('blocked', 'rus', 'Заблокировано');
INSERT INTO `objectStatusTL` (`id`, `languageId`, `name`) VALUES ('blocked', 'eng', 'Blocked');

COMMIT;


-- -----------------------------------------------------
-- Data for table `imageTypeT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `imageTypeT` (`id`, `isDefault`, `added`) VALUES ('image', 'y', NULL);
INSERT INTO `imageTypeT` (`id`, `isDefault`, `added`) VALUES ('panorama', NULL, NULL);
INSERT INTO `imageTypeT` (`id`, `isDefault`, `added`) VALUES ('video', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `internalDataTypeT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `internalDataTypeT` (`id`, `added`) VALUES ('numeric', NULL);
INSERT INTO `internalDataTypeT` (`id`, `added`) VALUES ('datetime', NULL);
INSERT INTO `internalDataTypeT` (`id`, `added`) VALUES ('text', NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `attributeDatetimeFormatT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `attributeDatetimeFormatT` (`id`, `storageFormat`, `sorter`, `added`, `changed`) VALUES ('year', '%Y-01-01 00:00:00', 3, NULL, NULL);
INSERT INTO `attributeDatetimeFormatT` (`id`, `storageFormat`, `sorter`, `added`, `changed`) VALUES ('yearmonth', '%Y-%m-01 00:00:00', 2, NULL, NULL);
INSERT INTO `attributeDatetimeFormatT` (`id`, `storageFormat`, `sorter`, `added`, `changed`) VALUES ('date', '%Y-%m-%d 00:00:00', 1, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `attributeDatetimeFormatTL`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('year', 'ukr', 'рік', '%Y', 'yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('year', 'rus', 'год', '%Y', 'yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('year', 'eng', 'year only', '%Y', 'yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('yearmonth', 'ukr', 'рік і місяць', '%m.%Y', 'MM.yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('yearmonth', 'rus', 'год и месяц', '%m.%Y', 'MM.yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('yearmonth', 'eng', 'year and month', '%m/%Y', 'MM/yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('date', 'ukr', 'дата', '%d.%m.%Y', 'dd.MM.yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('date', 'rus', 'дата', '%d.%m.%Y', 'dd.MM.yyyy');
INSERT INTO `attributeDatetimeFormatTL` (`id`, `languageId`, `name`, `outputFormat`, `outputFormatJs`) VALUES ('date', 'eng', 'date', '%Y/%m/%d', 'yyyy/MM/dd');

COMMIT;


-- -----------------------------------------------------
-- Data for table `oauthProviderT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `oauthProviderT` (`id`, `added`, `changed`) VALUES ('google', NULL, NULL);
INSERT INTO `oauthProviderT` (`id`, `added`, `changed`) VALUES ('vkontakte', NULL, NULL);
INSERT INTO `oauthProviderT` (`id`, `added`, `changed`) VALUES ('facebook', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `externalDataSourceT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `externalDataSourceT` (`id`, `name`, `added`, `changed`) VALUES ('osm', 'OpenStreetMap', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `externalDataSourceDatasetT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `externalDataSourceDatasetT` (`externalDataSourceId`, `code`, `nodeId`, `added`, `changed`) VALUES ('osm', 'ternopil', 0, NULL, NULL);
INSERT INTO `externalDataSourceDatasetT` (`externalDataSourceId`, `code`, `nodeId`, `added`, `changed`) VALUES ('osm', 'kyiv', 0, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `externalOsmDictionaryT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `externalOsmDictionaryT` (`externalDataSourceId`, `code`, `boundingWayIds`, `added`, `changed`) VALUES ('osm', 'ternopil', '3058686', NULL, NULL);
INSERT INTO `externalOsmDictionaryT` (`externalDataSourceId`, `code`, `boundingWayIds`, `added`, `changed`) VALUES ('osm', 'kyiv', '421866', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `zzzIntsT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `zzzIntsT` (`n`) VALUES (0);
INSERT INTO `zzzIntsT` (`n`) VALUES (1);
INSERT INTO `zzzIntsT` (`n`) VALUES (2);
INSERT INTO `zzzIntsT` (`n`) VALUES (3);
INSERT INTO `zzzIntsT` (`n`) VALUES (4);
INSERT INTO `zzzIntsT` (`n`) VALUES (5);
INSERT INTO `zzzIntsT` (`n`) VALUES (6);
INSERT INTO `zzzIntsT` (`n`) VALUES (7);
INSERT INTO `zzzIntsT` (`n`) VALUES (8);
INSERT INTO `zzzIntsT` (`n`) VALUES (9);

COMMIT;


-- -----------------------------------------------------
-- Data for table `nodeAncestrySourceT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (2, 9, 20, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (2, 7, 40, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (8, 7, 20, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (9, 7, 20, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (9, 8, 40, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (2, 17, 30, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `zzzValidCharT`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('0', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('1', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('2', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('3', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('4', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('5', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('6', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('7', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('8', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('9', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES (' ', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('A', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('B', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('C', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('D', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('E', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('F', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('G', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('H', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('I', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('J', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('K', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('L', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('M', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('N', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('O', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('P', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Q', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('R', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('S', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('T', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('U', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('V', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('W', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('X', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Y', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Z', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('a', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('b', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('c', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('d', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('e', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('f', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('g', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('h', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('i', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('j', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('k', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('l', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('m', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('n', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('o', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('p', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('q', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('r', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('s', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('t', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('u', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('v', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('w', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('x', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('y', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('z', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('А', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Б', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('В', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Г', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ґ', 'norm', 'Г', 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Д', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Е', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Є', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ж', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('З', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('И', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('І', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ї', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Й', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('К', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Л', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('М', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Н', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('О', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('П', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Р', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('С', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Т', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('У', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ф', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Х', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ц', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ч', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ш', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Щ', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ь', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ю', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Я', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ё', 'norm', 'Е', 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Ы', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Э', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('а', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('б', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('в', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('г', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ґ', 'norm', 'г', 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('д', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('е', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('є', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ж', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('з', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('и', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('і', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ї', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('й', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('к', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('л', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('м', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('н', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('о', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('п', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('р', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('с', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('т', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('у', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ф', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('х', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ц', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ч', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ш', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('щ', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ь', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ю', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('я', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ё', 'norm', 'е', 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('ы', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('э', 'norm', NULL, 'y');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('0', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('1', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('2', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('3', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('4', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('5', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('6', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('7', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('8', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('9', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('A', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('B', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('C', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('D', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('E', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('F', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('G', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('H', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('I', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('J', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('K', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('L', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('M', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('N', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('O', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('P', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Q', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('R', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('S', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('T', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('U', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('V', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('W', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('X', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Y', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('Z', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('a', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('b', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('c', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('d', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('e', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('f', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('g', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('h', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('i', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('j', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('k', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('l', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('m', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('n', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('o', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('p', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('q', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('r', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('s', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('t', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('u', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('v', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('w', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('x', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('y', 'alias', NULL, 'n');
INSERT INTO `zzzValidCharT` (`id`, `purpose`, `replacement`, `forceSingle`) VALUES ('z', 'alias', NULL, 'n');

COMMIT;

