No subject

  dewey double (8,6) default NULL

I think this means that the dewey entry is restricted to being a numeric
data type (double precision - up to 8 digits displayed, with up to 6
digits following the decimal point)? As far as I know, the Dewey numbers
are "labels" - their value is not used for computation - so the dewey
number could be entered as a "text" data type?

I'd guess that simply changing the db entry to something like:
 
   dewey varchar (16) default NULL

might cover most of your needs?


I am just a newbie at this stuff and the above is all just guess-work -
so make modifications at your own risk ;^)

R.