From 67bf0a128fc246ed622798b79ba9b7a0eb497485 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 2 May 2016 15:55:01 +0100 Subject: [PATCH] Bug 16414: Drop aqorders.budgetgroup_id This column has never been used and can be removed. Test plan: 1/ update the schema 2/ prove t/db_dependent/Acquisition.t should return green --- installer/data/mysql/atomicupdate/bug_16414.sql | 1 + t/db_dependent/Acquisition.t | 3 --- 2 files changed, 1 insertion(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_16414.sql diff --git a/installer/data/mysql/atomicupdate/bug_16414.sql b/installer/data/mysql/atomicupdate/bug_16414.sql new file mode 100644 index 0000000..975e02f --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_16414.sql @@ -0,0 +1 @@ +ALTER TABLE aqorders DROP COLUMN budgetgroup_id; diff --git a/t/db_dependent/Acquisition.t b/t/db_dependent/Acquisition.t index 16e0c86..7c80387 100755 --- a/t/db_dependent/Acquisition.t +++ b/t/db_dependent/Acquisition.t @@ -359,7 +359,6 @@ my @expectedfields = qw( gstrate discount budget_id - budgetgroup_id budgetdate sort1 sort2 @@ -487,7 +486,6 @@ my @base_expectedfields = qw( publicationyear collectiontitle invoiceid - budgetgroup_id place issn quantityreceived @@ -609,7 +607,6 @@ ok( title closedate basketname - budgetgroup_id invoiceid author parent_ordernumber -- 2.7.0