summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--db.sql10
1 files changed, 0 insertions, 10 deletions
diff --git a/db.sql b/db.sql
index 375c15a..20d8178 100644
--- a/db.sql
+++ b/db.sql
@@ -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;