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@gmail.com ReportedBy: conan@lugmen.org.ar QAContact: koha-bugs@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.