[Koha-bugs] [Bug 6175] 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

MJ Ray (software.coop) <mjr at software.coop> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Attachment #3911|0                           |1
        is obsolete|                            |

--- Comment #3 from MJ Ray (software.coop) <mjr at software.coop> ---
Created attachment 10086
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10086&action=edit
Bug 6175 Mismatch on tables definition

kohastructure.sql defines:
marc_subfield_structure.authorised_value varchar(20)
this column points to:
authorised_values.category varchar(10)

At first tought you would think about shortening in
marc_subfield_structure table, but install scripts had values longer
than 10 characters. Also there's been talk in the list about expanding
the column.

So:

- Expand on authorised_values.category.
- Add foreign keys constraints.
- Reshuffle sql scripts to allow insertions given the new constraints.
- Expand template input text field to match database column.

Signed-off-by: MJ Ray <mjr at phonecoop.coop>

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.