summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSean Finney <seanius@debian.org>2008-07-05 21:23:47 +0200
committerSean Finney <seanius@debian.org>2008-07-05 21:23:47 +0200
commit283951f36acf3480e0b2a236aeffc701b9baaa47 (patch)
tree30ef8a297019ce2ef79de639bf55fcbda019ac9e
parent9038baf1c9a73bf9f7afb175846f2cb3f43c31e1 (diff)
downloadpatch-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.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;