From a40f0253af3605f490c4bc656e74f4b23bc42a9e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 17 Mar 2017 11:54:57 -0300 Subject: [PATCH] Bug 18231: Make sure we will not add the column twice Signed-off-by: Alex Buckley --- .../mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.perl | 11 +++++++++++ .../mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql | 3 --- 2 files changed, 11 insertions(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.perl delete mode 100644 installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql diff --git a/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.perl b/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.perl new file mode 100644 index 0000000..8974137 --- /dev/null +++ b/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.perl @@ -0,0 +1,11 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + unless ( column_exists( 'issuingrules', 'issuingrules_id' ) ) { + $dbh->do(q|ALTER TABLE `issuingrules` DROP PRIMARY KEY|); + $dbh->do(q|ALTER TABLE `issuingrules` ADD `issuingrules_id` INT( 11 ) NOT NULL auto_increment PRIMARY KEY FIRST|); + $dbh->do(q|ALTER TABLE `issuingrules` ADD CONSTRAINT UNIQUE `issuingrules_id` (`branchcode`,`categorycode`,`itemtype`)|); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 18231 - Add issuingrules.issuingrules_id)\n"; +} diff --git a/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql b/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql deleted file mode 100644 index a7cd8a7..0000000 --- a/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `issuingrules` DROP PRIMARY KEY; -ALTER TABLE `issuingrules` ADD `issuingrules_id` INT( 11 ) NOT NULL auto_increment PRIMARY KEY FIRST; -ALTER TABLE `issuingrules` ADD CONSTRAINT UNIQUE `issuingrules_id` (`branchcode`,`categorycode`,`itemtype`); -- 2.1.4