[Koha-bugs] [Bug 23352] Set serial issue default values when creating a subscription in serials/subscription-add.pl

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23352

--- Comment #1 from Alex Buckley <alexbuckley at catalyst.net.nz> ---
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.