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

[Robert Lyon]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Robert Lyon <bob_lyon>  06/11/27 04:24:17

Modified files:
        updater        : updatedatabase 

Log message:
        Adding in column to track the last branch used for a serial to save 
librarian having to select each time

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

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.100.2.56
retrieving revision 1.100.2.57
diff -u -b -r1.100.2.56 -r1.100.2.57
--- updatedatabase      26 Nov 2006 23:38:47 -0000      1.100.2.56
+++ updatedatabase      27 Nov 2006 04:24:17 -0000      1.100.2.57
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.100.2.56 2006/11/26 23:38:47 bob_lyon Exp $
+# $Id: updatedatabase,v 1.100.2.57 2006/11/27 04:24:17 bob_lyon Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -372,6 +372,7 @@
                                                        recievedlist longtext 
NOT NULL,
                                                        opacnote varchar(150) 
NOT NULL default '',
                                                        librariannote 
varchar(150) NOT NULL default '',
+                                                       lastbranch varchar(15) 
default NULL,
                                                        PRIMARY KEY  
(subscriptionid),
                                                        KEY biblionumber 
(biblionumber)
                                )",
@@ -1593,6 +1594,16 @@
             extra   => ''
         },
     ],
+    subscriptionhistory => [
+        {
+            field   => 'lastbranch',
+            type    => 'varchar(15)',
+            null    => 'NULL',
+            key     => '',
+            default => '',
+            extra   => ''
+        },
+    ],    
     auth_header =>[
         {
             field => 'authtrees',
@@ -2278,6 +2289,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.100.2.57  2006/11/27 04:24:17  bob_lyon
+# Adding in column to track the last branch used for a serial to save 
librarian having to select each time
+#
 # Revision 1.100.2.56  2006/11/26 23:38:47  bob_lyon
 # Adding in new columns for serial and subscription tables so they update 
existing database tables
 #