I would file a bug, but since I'm too new here I preferred to ask before.
Current marc_subfield_structure table definition looks like this:
CREATE TABLE `marc_subfield_structure` (
...
`authorised_value` varchar(20) default NULL,
...);
That column points to 'category' in authorised_values table, which is
defined like this:
CREATE TABLE `authorised_values` (
...
`category` varchar(10) NOT NULL default '',
...);
Two questions and a possible digression:
Q1. Shouldn't both be equal?
Q2. Shouldn't authorised_value in marc_subfield_structure be a foreign
key referencing category on authorised_values table?
The quick solution for this is to make authorised_value a varchar(10) in
marc_subfield_structure, since all other tables pointing to
authorised_values.category use that.
Making it also a foreign key would be desirable to add database consistency.
Should I file a bug or I'm seeing this in a wrong way?
Note: the digression grew too extensive, I'll hear answers to before
going with it.
--
Fernando Canizo (a.k.a. conan) - http://conan.muriandre.com/
GCS d? s:+ a C++ P--- L++++ E--- W+++ w--- M-- PE-- !tv b+++ h---- y+++
_______________________________________________
Koha-devel mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
