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