https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23352
--- Comment #1 from Alex Buckley <[email protected]> --- Created attachment 91678 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91678&action=edit Bug 23352: Database and DBIx changes This patch contains the following changes: * Atomicupdate (this change is idempotent using the column_exists subroutine) * kohastructure.sql changes adding the new column 'ccode' to subscription table. * Change to Koha/Schema/Result/Subscription.pm to reflect the change to subscription table Test plan: 1. Enter mysql terminal: sudo koha-mysql <instancename> 2. Run the query: describe subscription; 3. Notice there is no 'ccode' column after the 'mana_id' column 3. Exit mysql terminal and apply patch 4. Navigate to the installer/data/mysql directory 5. Enter koha-shell: sudo koha-shell <instancename> 6. Run: ./updatedatabase.pl 7. Notice atomicupdate runs without errors 8. Exit koha-shell and re-enter mysql terminal and confirm the 'ccode' column is in the subscription table now after mana_id column 9. Exit mysql terminal and view the installer/data/mysql/kohastructure.sql file and notice 'ccode' is added to subscription table under mana_id column 10. Exit the file and view the Koha/Schema/Result/Subscription.pm file. Notice it has been updated on 22 July 2019 and it now contains 'ccode' Sponsored-By: Brimbank Library, Australia -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
