From 283951f36acf3480e0b2a236aeffc701b9baaa47 Mon Sep 17 00:00:00 2001 From: Sean Finney Date: Sat, 5 Jul 2008 21:23:47 +0200 Subject: 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... --- db.sql | 10 ---------- 1 file changed, 10 deletions(-) (limited to 'db.sql') 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; -- cgit v1.2.3