Bug 35190: Set default NULL for authorised_value_category in additional_fields table
authorEmily Lamancusa <emily.lamancusa@montgomerycountymd.gov>
Mon, 30 Oct 2023 15:31:31 +0000 (11:31 -0400)
committerTomas Cohen Arazi <tomascohen@theke.io>
Fri, 3 Nov 2023 17:22:46 +0000 (14:22 -0300)
commit40414f9c694f3d044f81662c6d9df9c6ca19e2fc
treef103290ebc363741f00922d6438361fd84b48da1
parent4310e13a6416d680e825621278859e3b91b1942a
Bug 35190: Set default NULL for authorised_value_category in additional_fields table

To test:
1. Start KTD without this patch
2. In the Administration module, create an Additional Field with
   Authorized Value set to None
3. Create another Additional Field with Authorized Value set to an
   existing authorized value
4. Apply patch and updatedatabase
5. Access the database in the command line with koha-mysql kohadev
6. Select all rows from additional_fields
7. Confirm that the two Additional Fields from earlier have values of
   NULL and the correct authorized value, respectively, in their
   authorised_value_category fields.
8. reset_all to test new install
9. Access the database in the command line
10. Show the table structure for additional_fields and confirm that
    default for authorised_value_category is NULL

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_35190.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql