[Koha] SQL field lengths

Peter Huerter pete.huerter at gmail.com
Wed Dec 1 05:47:23 NZDT 2010


Perhaps this is a bug, or at least an inconsistency between the items, and
authorised_values SQL table schema.

Koha allows you to define an authorised value having length 80, but then you
can't use it.

Here is why:  

The SQL field items.ccode is a varchar(10).

The SQL field authorised_values.authorised_value is a varchar(80).

If this is a bug, how can I go about opening a defect?

Thanks,

Pete.
-- 
View this message in context: http://koha.1045719.n5.nabble.com/SQL-field-lengths-tp3285076p3286344.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.


More information about the Koha mailing list