Upgradeskript-Abhängigkeiten geändert

unit_foreign_key_for_line_items muss nach oe_do_delete_via_trigger ausgeführt
werden, sonst werden die Fremdschlüssel wieder gelöscht.

diff --git a/SL/DBUpgrade2.pm b/SL/DBUpgrade2.pm
index 650258378af4a44875d578568116bfaaddc0e147..0fd18b59c082c3621886a0936b3ef1345a501e31 100644 (file)
--- a/SL/DBUpgrade2.pm
+++ b/SL/DBUpgrade2.pm
@@ -185,6 +185,7 @@ sub process_query {
           # Query is complete. Send it.
 
           $sth = $dbh->prepare($query);
+          $::lxdebug->dump(0, "bb: query: ", $query);
           if (!$sth->execute()) {
             my $errstr = $dbh->errstr;
             return $errstr // '<unknown database error>' if $self->{return_on_error};

diff --git a/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql b/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql
index d99e1a7fa5b82fa210e26c83cf2fd67c66e7bdf8..ba547c824b55141ee1f29ef110f1c33f23a29b36 100644 (file)
--- a/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql
+++ b/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql
@@ -1,6 +1,6 @@
 -- @tag: unit_foreign_key_for_line_items
 -- @description: Fremdschlüssel auf »unit« für Beleg-Positionstabellen
--- @depends: release_3_0_0
+-- @depends: release_3_0_0 oe_do_delete_via_trigger
 ALTER TABLE orderitems           ADD FOREIGN KEY (unit) REFERENCES units (name);
 ALTER TABLE delivery_order_items ADD FOREIGN KEY (unit) REFERENCES units (name);
 ALTER TABLE invoice              ADD FOREIGN KEY (unit) REFERENCES units (name);