remove update trigger for package_rel_maps

since now we "mark" new package relationss (which is necessary for removing
old relations), remove the update trigger, which would otherwise end up
deleting everything in the database...

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;