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

--- Comment #11 from Martin Renvoize (ashimema) 
<[email protected]> ---
Created attachment 192858
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=192858&action=edit
Bug 35972: Add course_type column for flexible course displays

This patch adds database infrastructure to support multiple course
display types (course reserves, research tables, on display, etc.)
instead of hardcoding "thesis tables" via department='TT'.

Database changes:
- Add course_type VARCHAR(80) column to courses table
- Migrate existing department='TT' records to course_type='RESEARCH_TABLE'
- Create CR_TYPE authorized value category with default values:
  * COURSE - Regular course reserves
  * RESEARCH_TABLE - Research/thesis tables
  * ON_DISPLAY - On display collections

Schema changes:
- Update kohastructure.sql with course_type column
- Add CR_TYPE authorized values to sample data
- Update Koha::Schema::Result::Course DBIx::Class schema

This flexible architecture allows libraries to:
- Customize terminology via authorized values (lib/lib_opac fields)
- Add new display types without code changes
- Support future features like Bug 12141 (On Display module)

The course_type column uses authorized values from CR_TYPE category,
with separate display text for staff interface (lib) and OPAC (lib_opac).

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to