From 283951f36acf3480e0b2a236aeffc701b9baaa47 Mon Sep 17 00:00:00 2001
From: Sean Finney <seanius@debian.org>
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

