diff options
-rw-r--r-- | db.sql | 10 |
1 files changed, 0 insertions, 10 deletions
@@ -118,13 +118,3 @@ CREATE TRIGGER fkdc_packages_id_package_rel_map_package_id WHERE package_id = OLD.package_id AND rowid != OLD.rowid) IS NULL; END; - -CREATE TRIGGER fku_package_rel_map_prune_packages_package_id - BEFORE UPDATE ON [package_rel_map] - FOR EACH ROW BEGIN - DELETE FROM packages WHERE packages.id = OLD.package_id - AND (OLD.package_id != NEW.package_id) - AND (SELECT package_id FROM package_rel_map - WHERE package_id = OLD.package_id AND rowid != OLD.rowid) - IS NULL; - END; |