[Bug 25878] New: Schema incorrectly describes course_items fields
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25878 Bug ID: 25878 Summary: Schema incorrectly describes course_items fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org On the schema page for the course_items table we include this comment on course_items.itype: "new itemtype for the item to have while on reserve (optional)" We have comparable notes for ccode, holdingbranch, and location. That comment is not strictly correct. While a course is active, these fields in course_items will hold the items original values. If the course is marked inactive and the item's original values are returned to the items table, then the fields in course_items will hold the values that this item had while on reserve. At this time I do not have alternate wording that explains this succinctly enough to put into the schema comment. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25878 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |minor CC| |jonathan.druart@bugs.koha-c | |ommunity.org -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25878 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I believe this might have changed recently, as we have 3 columns now for each of the values that can be changed. Andrew, can you confirm? `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional) `itype_enabled` tinyint(1) NOT NULL DEFAULT 0, -- indicates if itype should be changed while on course reserve `itype_storage` varchar(10) DEFAULT NULL, -- a place to store the itype when item is on course reserve -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org