[Koha-bugs] [Bug 16103] Remove FK constraint for sms_provider_id in deletedborrowers

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

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

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #49312|0                           |1
        is obsolete|                            |

--- Comment #3 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Created attachment 49742
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=49742&action=edit
Bug 16103: Remove FK sms_provider_id in deletedborrowers

This patch removes the FK constraint for sms_provider_id in table
deletedborrowers. (We do not need FKs in that table.)
It just corrects a newly added db revision in updatedatabase.
If this is pushed before releasing master, no need to do anything more.

Note that this key was not found in kohastructure and the DBIx schema.

Edit:

To test:
- With master DB run
  $ prove t/db_dependent/TestBuilder.t
=> SUCCESS: Tests pass
- Create a clean 3.22.00 DB
- Run the upgrade process
  $ perl installer/data/mysql/updatedatabase.pl
- Run
  $ prove t/db_dependent/TestBuilder.t
=> FAIL: Tests fail due to discrepancies in DB structure
- Re-create teh clean 3.22.00 DB
- Apply the patch
- Run the upgrade process
  $ perl installer/data/mysql/updatedatabase.pl
- Run
  $ prove t/db_dependent/TestBuilder.t
=> SUCCESS: Tests now pass

Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen at theke.io>

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