SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES';


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

CREATE TABLE IF NOT EXISTS `nodeTypeT` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `forceSingleNode` ENUM('y') NULL,
  `internalTypeId` VARCHAR(10) BINARY NOT NULL COMMENT 'refers to internalTypeT.id',
  `forceSingleType` ENUM('y') NULL COMMENT 'filled in automatically by trigger',
  `code` VARCHAR(30) BINARY NULL,
  `canEditType` ENUM('n','y') NOT NULL DEFAULT 'n',
  `canEditNode` ENUM('n','y') NOT NULL,
  `canLinkFrom` ENUM('n','y') NOT NULL DEFAULT 'n',
  `canLinkTo` ENUM('n','y') NOT NULL DEFAULT 'n',
  `canSearch` ENUM('n','y') NOT NULL DEFAULT 'n',
  `searchAnd` ENUM('n','y') NOT NULL DEFAULT 'n',
  `displayNode` ENUM('n','y') NOT NULL DEFAULT 'y',
  `requiredForObject` ENUM('n','y') NOT NULL DEFAULT 'n',
  `sorter` INT NOT NULL DEFAULT 0,
  `added` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `sorter_idx` (`sorter` ASC),
  INDEX `canedittype_idx` (`canEditType` ASC),
  INDEX `canlinkfrom_idx` (`canLinkFrom` ASC),
  INDEX `canlinkto_idx` (`canLinkTo` ASC),
  INDEX `cansearch_idx` (`canSearch` ASC),
  UNIQUE INDEX `internaltypeid_uq` (`internalTypeId` ASC, `forceSingleType` ASC),
  INDEX `caneditnode_idx` (`canEditNode` ASC),
  UNIQUE INDEX `code_UNIQUE` (`code` ASC),
  INDEX `forcesinglenode_idx` (`id` ASC, `forceSingleNode` ASC),
  INDEX `displaynode_idx` (`displayNode` ASC),
  INDEX `requiredforobject_idx` (`requiredForObject` ASC),
  CONSTRAINT `fk_nodeTypeT_internalTypeT1`
    FOREIGN KEY (`internalTypeId` , `forceSingleType`)
    REFERENCES `internalTypeT` (`id` , `forceSingleType`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- 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;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

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

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);

COMMIT;