-- -----------------------------------------------------
-- 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 (21, NULL, 'tag', NULL, 'oblast', 'y', 'n', 'y', 'n', 'n', 'y', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 25, 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 (22, NULL, 'tag', NULL, 'raion', 'y', 'n', 'y', 'n', 'n', 'y', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 26, NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `nodeTypeTL`
-- -----------------------------------------------------
START TRANSACTION;
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (21, 'ukr', 'Область');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (21, 'rus', 'Область');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (21, 'eng', 'Oblast');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (22, 'ukr', 'Район');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (22, 'rus', 'Район');
INSERT INTO `nodeTypeTL` (`id`, `languageId`, `name`) VALUES (22, 'eng', 'Raion');

COMMIT;


-- -----------------------------------------------------
-- Data for table `allowedNodeLinkT`
-- -----------------------------------------------------
START TRANSACTION;

INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 21, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (3, 22, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (21, 7, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (21, 8, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (21, 9, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (21, 17, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (21, 2, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (21, 22, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (22, 7, 'y', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (22, 8, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (22, 9, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (22, 17, 'n', 'y', NULL, NULL);
INSERT INTO `allowedNodeLinkT` (`srcNodeTypeId`, `dstNodeTypeId`, `essential`, `singleSrc`, `added`, `changed`) VALUES (22, 2, 'y', 'y', NULL, NULL);

COMMIT;


-- -----------------------------------------------------
-- Data for table `nodeAncestrySourceT`
-- -----------------------------------------------------
START TRANSACTION;
delete from nodeAncestrySourceT;

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, 10, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (2, 17, 30, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (2, 22, 50, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (2, 21, 60, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (7, 22, 10, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (7, 21, 20, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (8, 22, 30, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (8, 21, 40, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (9, 22, 30, NULL, NULL);
INSERT INTO `nodeAncestrySourceT` (`nodeTypeId`, `srcNodeTypeId`, `sorter`, `added`, `changed`) VALUES (9, 21, 40, NULL, NULL);

COMMIT;

-- update all caches
select __nodeAncestry_UpdateAll(1);
select __object_UpdateAllAddresses();