[Koha-cvs] CVS: koha/updater updatedatabase,1.93,1.94

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28965/updater

Modified Files:
        updatedatabase 
Log Message:
adding a "location" field to the library.
This field is useful when the callnumber contains no information on the room 
where the item is stored.
With this field, we now have 3 levels of informations to find a book :
* the branch.
* the location.
* the callnumber.

This should be versatile enough to solve any storing method.
This hack is quite simple, due to the nice Biblio.pm API. The MARC => koha db 
link is automatically managed. Just add the link in the parameters section.

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.93
retrieving revision 1.94
diff -C2 -r1.93 -r1.94
*** updatedatabase      12 Aug 2004 14:50:50 -0000      1.93
--- updatedatabase      6 Sep 2004 10:00:29 -0000       1.94
***************
*** 289,309 ****
                                suggestionid int(8) NOT NULL auto_increment,
                                suggestedby int(11) NOT NULL default '0',
!                               managedby int(11) default NULL,
!                               status varchar(10) NOT NULL default '',
                                note text,
!                               author varchar(80) default NULL,
!                               title varchar(80) default NULL,
!                               copyrightdate smallint(6) default NULL,
!                               publishercode varchar(255) default NULL,
!                               date timestamp(8) NOT NULL,
!                               volumedesc char(255) default NULL,
!                               publicationyear smallint(6) default NULL,
!                               place char(255) default NULL,
!                               isbn char(10) default NULL,
!                               mailoverseeing smallint(1) default 0,
!                               biblionumber int(11) default NULL,
!                               PRIMARY KEY  (suggestionnumber),
!                               KEY suggestedby (suggestedby),
!                               KEY managedby (managedby)
                        )",
        aqbasket => "(basketno int(11) NOT NULL auto_increment,
--- 289,309 ----
                                suggestionid int(8) NOT NULL auto_increment,
                                suggestedby int(11) NOT NULL default '0',
!                               managedby int(11) default NULL ,
!                               STATUS varchar(10) NOT NULL default '',
                                note text,
!                               author varchar(80) default NULL ,
!                               title varchar(80) default NULL ,
!                               copyrightdate smallint(6) default NULL ,
!                               publishercode varchar(255) default NULL ,
!                               date timestamp(8) NOT NULL ,
!                               volumedesc varchar(255) default NULL ,
!                               publicationyear smallint(6) default '0',
!                               place varchar(255) default NULL ,
!                               isbn varchar(10) default NULL ,
!                               mailoverseeing smallint(1) default '0',
!                               biblionumber int(11) default NULL ,
!                               PRIMARY KEY (suggestionid) ,
!                               KEY suggestedby(suggestedby) ,
!                               KEY managedby(managedby)
                        )",
        aqbasket => "(basketno int(11) NOT NULL auto_increment,
***************
*** 405,409 ****
                                'sort2' => 'char(80)', },
      aqbudget => {'aqbudgetid' => 'tinyint(4) auto_increment primary key'},
!     items => {'paidfor' => 'text'},
  
      #added so that reference items are not available for reserves...
--- 405,409 ----
                                'sort2' => 'char(80)', },
      aqbudget => {'aqbudgetid' => 'tinyint(4) auto_increment primary key'},
!     items => {'paidfor' => 'text', 'location' => 'char(80)'},
  
      #added so that reference items are not available for reserves...
***************
*** 419,422 ****
--- 419,423 ----
                                                        'hidden' => 
'tinyint(1)',
                                                        'isurl' => 'tinyint(1)',
+                                                       'link' => 'char(80)',
                                                        },
      bookshelf => {'owner' => 'char(80)',
***************
*** 1369,1372 ****
--- 1370,1384 ----
  
  # $Log$
+ # Revision 1.94  2004/09/06 10:00:29  tipaul
+ # adding a "location" field to the library.
+ # This field is useful when the callnumber contains no information on the 
room where the item is stored.
+ # With this field, we now have 3 levels of informations to find a book :
+ # * the branch.
+ # * the location.
+ # * the callnumber.
+ #
+ # This should be versatile enough to solve any storing method.
+ # This hack is quite simple, due to the nice Biblio.pm API. The MARC => koha 
db link is automatically managed. Just add the link in the parameters section.
+ #
  # Revision 1.93  2004/08/12 14:50:50  tipaul
  # bugfixes