[Koha-bugs] [Bug 13624] Remove columns branchcode, categorytype from table overduerules_transport_types

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13624

--- Comment #1 from Charles Farmer <charles.farmer at inlibro.com> ---
Created attachment 35561
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=35561&action=edit
Remove columns branchcode, categorytype from table overduerules_transport_types

Sponsored by Halland County Library

This patch is a _requirement_ to Bug #12771, and will be necessary once we
start managing more than 3 levels of overdue notice

In the database :
- A new column and primary key, 'overduerules_id', is added to the table
'overduerules'
- A new column referencing a foreign key, 'overduerules_id', is added to the
table 'overduerules_transport_types'
- The columns 'branchcode' and 'categorytype' are removed from the table
'overduerules_transport_types'

In C4/Overdues.pm :
- The SQL query of the function 'GetOverdueMessageTransportTypes' is changed to
take into account the new design of 'overduerules_transport_types'

In t/db_dependent/Overdues.t :
- The INSERT calls before the tests were changed to take into account the new
design of 'overduerules' and 'overduerules_transport_types'

TEST PLAN
---------
1) Apply the patch
2) Run the script
installer/data/mysql/atomicupdate/bug_13624_overduerules_transport_types.pl
   - It will create new tables and migrate the data
3) Run Overdues.t. Tests should be successful

-- 
You are receiving this mail because:
You are watching all bug changes.