@@ -, +, @@ --- .../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 --- a/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.perl +++ a/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"; +} --- a/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql +++ a/installer/data/mysql/atomicupdate/Bug-18231-id_to_ussingrules_table.sql @@ -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`); --