[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/26 23:38:47

Modified files:
	updater        : updatedatabase 

Log message:
	Adding in new columns for serial and subscription tables so they update existing database tables

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

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.100.2.55
retrieving revision 1.100.2.56
diff -u -b -r1.100.2.55 -r1.100.2.56
--- updatedatabase	24 Nov 2006 00:23:22 -0000	1.100.2.55
+++ updatedatabase	26 Nov 2006 23:38:47 -0000	1.100.2.56
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.100.2.55 2006/11/24 00:23:22 bob_lyon Exp $
+# $Id: updatedatabase,v 1.100.2.56 2006/11/26 23:38:47 bob_lyon Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -1524,6 +1524,64 @@
             default => '',
             extra   => ''
         },
+        {
+            field   => 'routingnotes',
+            type    => 'text',
+            null    => 'NOT NULL',
+            key     => '',
+            default => '',
+            extra   => ''
+        },
+        {
+            field   => 'claimdate',
+            type    => 'date',
+            null    => 'NULL',
+            key     => '',
+            default => '',
+            extra   => ''
+        },	
+    ],
+    subscription => [
+        {
+            field   => 'firstacquidate',
+            type    => 'date',
+            null    => 'NOT NULL',
+            key     => '',
+            default => '0000-00-00',
+            extra   => ''
+        },	    
+        {
+            field   => 'numberpattern',
+            type    => 'int(4)',
+            null    => 'NOT NULL',
+            key     => '',
+            default => '0',
+            extra   => ''
+        },
+        {
+            field   => 'irregularity',
+            type    => 'varchar(255)',
+            null    => 'NULL',
+            key     => '',
+            default => '',
+            extra   => ''
+        },
+        {
+            field   => 'hemisphere',
+            type    => 'int(1)',
+            null    => 'NOT NULL',
+            key     => '',
+            default => '1',
+            extra   => ''
+        },
+        {
+            field   => 'callnumber',
+            type    => 'varchar(100)',
+            null    => 'NULL',
+            key     => '',
+            default => '',
+            extra   => ''
+        },
     ],
     biblioitems => [
         {
@@ -2220,6 +2278,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# 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
+#
 # Revision 1.100.2.55  2006/11/24 00:23:22  bob_lyon
 # Adding in the updated files for the routing serials
 #