[Koha-cvs] koha/updater updatedatabase [rel_3_0]

[Antoine Farnault]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_3_0
Changes by:     Antoine Farnault <toins>        06/11/02 09:27:30

Modified files:
        updater        : updatedatabase 

Log message:
        issue.branchcode must be varchar(10).

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_3_0&r1=1.157.2.15&r2=1.157.2.16

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.157.2.15
retrieving revision 1.157.2.16
diff -u -b -r1.157.2.15 -r1.157.2.16
--- updatedatabase      31 Oct 2006 17:41:51 -0000      1.157.2.15
+++ updatedatabase      2 Nov 2006 09:27:30 -0000       1.157.2.16
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.157.2.15 2006/10/31 17:41:51 toins Exp $
+# $Id: updatedatabase,v 1.157.2.16 2006/11/02 09:27:30 toins Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -652,6 +652,14 @@
                        default => '',
                        extra   => '',
                },
+               {
+                   field   => 'branchcode',
+                   type    => 'varchar(10)',
+                   null    => 'NULL',
+                   key     => '',
+                   default => '',
+                   extra   => '',
+               },
        ],
        
     items => [
@@ -1620,8 +1628,8 @@
 while ( ( $column, $type, $null, $key, $default, $extra ) = $sth->fetchrow ){
        $marcdone=1 if ($type eq 'longtext' && $column eq 'marcxml') ;
 }
-unless ($marcdone) {
-#unless (1) { # to disable this block just to test.
+#unless ($marcdone) {
+unless (1) { # to disable this block just to test.
        print "moving MARC record to biblioitems table\n";
        # changing marc field type
        $dbh->do('ALTER TABLE `biblioitems` CHANGE `marc` `marc` BLOB NULL 
DEFAULT NULL ');
@@ -1867,6 +1875,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.157.2.16  2006/11/02 09:27:30  toins
+# issue.branchcode must be varchar(10).
+#
 # Revision 1.157.2.15  2006/10/31 17:41:51  toins
 # items.holdingbranch must be varchar(10)
 #