-- ----------------------------------------------------------- --
-- APM should not use URT collected data to check auth objects
-- ----------------------------------------------------------- --
CREATE TABLE IF NOT EXISTS `apm_project_hidden_object` (
  `project` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `object` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`project`, `object`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
SELECT `project`, `object`
FROM `sod_auth_object` AS o
JOIN `apm_proj_obj_no_su53` AS h ON h.object_id = o.id
ORDER BY `project`;

DROP TABLE IF EXISTS `apm_proj_obj_no_su53`;