https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43492 --- Comment #9 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 205370 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=205370&action=edit Bug 43492: Add library_opening_hours table and OPENING_HOURS_TYPE authorised value Adds the library_opening_hours table (surrogate PK, multiple rows per library/weekday allowed, an explicit closes_opening_id self-reference for slots that open on one day and don't close until a later day), seeds a new OPENING_HOURS_TYPE authorised value category with its reserved GENERAL value, and migrates library_hours data into the new table (complete open/close pairs only - a row with only one of the two set never had a usable meaning under the old model, and is not the same thing as a new-model open-ended slot), dropping library_hours once migrated. Test plan: 1. Apply this patch and run the atomicupdate: ktd --shell --run 'perl installer/data/mysql/updatedatabase.pl' Confirm the library_opening_hours table, the OPENING_HOURS_TYPE category and its GENERAL value are created, existing library_hours data is migrated across, and library_hours is dropped. 2. Confirm a fresh install (kohastructure.sql) produces the same result. -- You are receiving this mail because: You are watching all bug changes.