diff options
author | Sean Finney <seanius@debian.org> | 2008-07-05 21:23:47 +0200 |
---|---|---|
committer | Sean Finney <seanius@debian.org> | 2008-07-05 21:23:47 +0200 |
commit | 283951f36acf3480e0b2a236aeffc701b9baaa47 (patch) | |
tree | 30ef8a297019ce2ef79de639bf55fcbda019ac9e | |
parent | 9038baf1c9a73bf9f7afb175846f2cb3f43c31e1 (diff) | |
download | patch-tracker-283951f36acf3480e0b2a236aeffc701b9baaa47.tar.gz |
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...
-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; |