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

--- Comment #2 from Martin Renvoize (ashimema) 
<[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to