https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43492 --- Comment #2 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 205323 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=205323&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) alongside the existing library_hours table, and seeds a new OPENING_HOURS_TYPE authorised value category with its reserved GENERAL value. library_hours is intentionally left untouched here - C4::Circulation still reads it directly until Bug 43495 migrates that consumer and drops it, so the two tables coexist until then. 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, and library_hours is untouched. 2. Confirm a fresh install (kohastructure.sql) produces the same result. -- You are receiving this mail because: You are watching all bug changes.