 
 DROP VIEW `dbs_registry`.`relationships`;
 CREATE
-    ALGORITHM = UNDEFINED
-    DEFINER = `root`@`%`
-    SQL SECURITY DEFINER
 VIEW `dbs_registry`.`relationships` AS
     SELECT
         `ror`.`registry_object_id` AS `from_id`,

  WHERE
    ros.status = 'PUBLISHED' AND rot.status = 'PUBLISHED';

CREATE TABLE `dbs_registry`.`registry_object_implicit_relationships` (
  `from_id` MEDIUMINT(8) NOT NULL,
  `to_id` MEDIUMINT(8) NOT NULL,
  `relation_type` VARCHAR(512) NULL,
  `relation_origin` VARCHAR(32) NULL);

ALTER TABLE `dbs_registry`.`registry_object_implicit_relationships`
ADD INDEX `FROM_TO_RELATION` (`from_id` ASC, `to_id` ASC, `relation_type` ASC);

        LEFT JOIN `dbs_registry`.`registry_objects` `ros` ON ((`ror`.`registry_object_id` = `ros`.`registry_object_id`)))
        LEFT JOIN `dbs_registry`.`registry_objects` `rot` ON ((`ror`.`related_object_key` = `rot`.`key`)))
	WHERE
		`ros`.`status` = 'PUBLISHED' AND `rot`.`status` = 'PUBLISHED';

DROP VIEW `dbs_registry`.`identifier_relationships`;
CREATE
VIEW `dbs_registry`.`identifier_relationships` AS
    SELECT
        `roir`.`registry_object_id` AS `from_id`,
