Re: customize unique book id

Wolfgang Pichler wrote:

> David Everly wrote:
>
> > Hi Wolfgang,
> >
> > I am glad to to help / submit patches to the best of my ability.
> > Mostly I would need a bit of education to get started:  You said
> > you may have a patch that allows some of this.  May I take a look
> > at it?
> >
> >  
> it is already incorporated in current cvs codebase.
>
> export CVS_RSH=ssh
> cvs -z3 
> -d:ext:<your-sourceforge-username>@cvs.sourceforge.net:/cvsroot/emilda 
> co src sql
> have a look on src/lib/mgmnt.inc
>
> - check/reedit all routines which handle valid book/user-id's and 
> change the code which handles the suffixes to some code which checks 
> number-ranges
> - change code which accesses the sql "control" table (row 
> last_control_number) to establish the "last" id
> TO BE DONE/TO BE VERIFIED (i will have time only in august :-(
>
> - book-ids are numerical in some tables and varchar in others -> why ?
> is this historical or is some calculation done ? is this related to 
> zebra control-number which has to be numeric ? how much effort to 
> clean this up ?
Book ids should be unsigned integers (10 digits) in all tables. The id 
in the reservations table should be of the same size, mediumint is a 
bug(?). However all control numbers are of type varchar in order to 
preserve the leading zeroes. This way the cn can be used directly for 
searching in Zebra.
> - dozen of others :-)))
>
> regards
> w.pichler
>
> _______________________________________________
> Emilda mailing list
> Emilda@xxxxxxxxxxxxxxxxxx
> http://lists.realnode.com/mailman/listinfo/emilda
Regards,

--
Erik Berglund
Oy Realnode Ab
Partner, Marketing
berglund [at] realnode.com
www.realnode.com