[Koha-bugs] [Bug 6175] New: Mismatch between marc_subfield_structure and authorised_values tables

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6175

             Bug #: 6175
           Summary: Mismatch between marc_subfield_structure and
                    authorised_values tables
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: rel_3_6
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: Database
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: conan at lugmen.org.ar
         QAContact: koha-bugs at lists.koha-community.org


kohastructure.sql defines:

marc_subfield_structure.authorised_value varchar(20) default NULL

this column points to:

authorised_values.category varchar(10) NOT NULL default ''

Quick fix is straightforward: modify marc_subfield_structure to match
authorised_values definition.

However there's been a request to expand size for category column
(http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5458).

Also there is discussion to make all references to authorised_values.category
foreign key references on koha-dev list.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.