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

[Ryan Higgins]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Ryan Higgins <rych>     07/07/13 17:56:17

Modified files:
        updater        : updatedatabase 

Log message:
        fix typos on labels update and add biblioitems.ccode

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_2_2&r1=1.100.2.64&r2=1.100.2.65

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.100.2.64
retrieving revision 1.100.2.65
diff -u -b -r1.100.2.64 -r1.100.2.65
--- updatedatabase      11 Jul 2007 13:15:48 -0000      1.100.2.64
+++ updatedatabase      13 Jul 2007 17:56:17 -0000      1.100.2.65
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.100.2.64 2007/07/11 13:15:48 sushi Exp $
+# $Id: updatedatabase,v 1.100.2.65 2007/07/13 17:56:17 rych Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -384,8 +384,8 @@
                                 PRIMARY KEY  (routingid)
                             )",
 
-   labels => "(`
-    labelid` int(11) NOT NULL auto_increment,
+   labels => "(
+   `labelid` int(11) NOT NULL auto_increment,
   batch_id varchar(10) NOT NULL default '1',
   itemnumber varchar(100) NOT NULL default '',
   timestamp timestamp(14) NOT NULL,
@@ -414,8 +414,7 @@
   PRIMARY KEY  (id)
 )",
 
-label_templates =>"(
- labels_templates (
+labels_templates =>"(
   tmpl_id int(4) NOT NULL auto_increment,
   tmpl_code char(100)   default '',
   tmpl_desc char(100)   default '',
@@ -466,12 +465,14 @@
     biblioitems => {
         'lccn' => 'char(25)',
         'url'  => 'varchar(255)',
-        'marc' => 'text'
+        'marc' => 'text',
+               'ccode' => 'varchar(32)',
     },
     deletedbiblioitems => {
         'lccn' => 'char(25)',
         'url'  => 'varchar(255)',
-        'marc' => 'text'
+        'marc' => 'text',
+               'ccode' => 'varchar(32)',
     },
     branchtransfers => { 'datearrived'    => 'datetime' },
     statistics      => { 'borrowernumber' => 'int(11)' },
@@ -1853,15 +1854,17 @@
                   $dbh->prepare(
 "alter table $table $action $field $type $null $key $extra default ?"
                   );
+            $sth->execute($default);
             }
             else {
                 $sth =
                   $dbh->prepare(
-"alter table $table drop primary key, $action $field $type $null $key $extra 
default ?"
+"alter table $table drop primary key, $action $field $type $null $key $extra "
                   );
+            $sth->execute();
             }
-            $sth->execute($default);
-            print "  Alter $field in $table\n" unless $silent;
+            print "  Altering:  $field in $table\n" unless $silent;
+            print $sth->{Statement} . "\n"  unless $silent;
         }
     }
 }
@@ -2354,6 +2357,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.100.2.65  2007/07/13 17:56:17  rych
+# fix typos on labels update and add biblioitems.ccode
+#
 # Revision 1.100.2.64  2007/07/11 13:15:48  sushi
 # oops, removing existing 'labels' table def.
 #