Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 2
Next »
CoreOne Application Services
Bug fixes
Database
SQL-Statement
-- Auto-generated SQL script #202411040936
INSERT IGNORE INTO servicedmcore_system_recurring_task_feature (id,name_key,taskscheduler_task_definition_id,order_id,feature_group_id)
VALUES (35,'Module.DM.MasterData.TargetSystem.Resource.DeactivateDeprovisionPreventionForProlongedRoleAssignments','8ee5929d98814d69aea5d9f72921c8ff',11,3);
INSERT INTO servicedmcore_system_type__system_recurring_task_feature (system_type_id, system_recurring_task_feature_id)
SELECT x.id, 35
FROM servicedmcore_system_type x
WHERE NOT EXISTS (
SELECT 1
FROM servicedmcore_system_type__system_recurring_task_feature y
WHERE y.system_recurring_task_feature_id = 35
AND y.system_type_id = x.id
);