[Koha-cvs] CVS: koha/updater updatedatabase,1.74,1.75

[Paul POULAIN]

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

Modified Files:
	updatedatabase 
Log Message:
seealso field set to 255 chars

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.74
retrieving revision 1.75
diff -C2 -r1.74 -r1.75
*** updatedatabase	11 Mar 2004 16:10:16 -0000	1.74
--- updatedatabase	14 Apr 2004 19:49:00 -0000	1.75
***************
*** 249,253 ****
  			   'options' => 'text' },
      z3950servers      => { 'syntax'      => 'char(80)' },
!     marc_subfield_structure =>{'seealso'  => 'char(80)'},
      bookshelf => {'owner' => 'char(80)',
      					'category' => 'char(1)',
--- 249,253 ----
  			   'options' => 'text' },
      z3950servers      => { 'syntax'      => 'char(80)' },
!     marc_subfield_structure =>{'seealso'  => 'char(255)'},
      bookshelf => {'owner' => 'char(80)',
      					'category' => 'char(1)',
***************
*** 968,971 ****
--- 968,990 ----
  }
  
+ # changing the items table around...
+ my %items;
+ 
+ $sth = $dbh->prepare("show columns from items");
+ $sth->execute;
+ while ( my ( $column, $type, $null, $key, $default, $extra ) = $sth->fetchrow )
+ {
+     $items{$column} = $type;
+ }
+ 
+ if ($items{'bulk'} eq "varchar(30)") {
+     print "  Setting callnumber in items table\n";
+     my $sti =
+       $dbh->prepare("ALTER TABLE `items` CHANGE `bulk` `itemcallnumber` VARCHAR( 30 ) DEFAULT NULL");
+     $sti->execute;
+     $sti = $dbh->prepare("update marc_subfield_structure set kohafield=\"items.itemcallnumber\" where kohafield=\"items.bulk\"");
+     $sti->execute;
+ }
+ 
  # Populate tables with required data
  
***************
*** 1019,1022 ****
--- 1038,1044 ----
  
  # $Log$
+ # Revision 1.75  2004/04/14 19:49:00  tipaul
+ # seealso field set to 255 chars
+ #
  # Revision 1.74  2004/03/11 16:10:16  tipaul
  # *** empty log message ***