[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 ***