[Koha-cvs] koha/updater updatedatabase

[Robert Lyon]

CVSROOT:	/sources/koha
Module name:	koha
Changes by:	Robert Lyon <bob_lyon>	06/07/20 04:36:01

Modified files:
	updater        : updatedatabase 

Log message:
	Merging back in some katipo changes to serials

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&r1=1.155&r2=1.156

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.155
retrieving revision 1.156
diff -u -b -r1.155 -r1.156
--- updatedatabase	17 Jul 2006 12:51:48 -0000	1.155
+++ updatedatabase	20 Jul 2006 04:36:01 -0000	1.156
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.155 2006/07/17 12:51:48 toins Exp $
+# $Id: updatedatabase,v 1.156 2006/07/20 04:36:01 bob_lyon Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -178,6 +178,14 @@
 	                        borrower1 integer,
 	                        borrower2 integer
 	                        )",
+       subscriptionroutinglist => "(
+	                        routingid int(11) NOT NULL auto_increment,
+	                        subscriptionid int(11) NOT NULL default '0',
+	                        borrowernumber int(11) NOT NULL default '0',
+	                        ranking int(11) NOT NULL default '0',
+	                        numberpattern varchar(100) NULL,
+	                        PRIMARY KEY  (routingid)
+	                        )",
 
 );
 
@@ -685,6 +693,21 @@
 'If set, a new item will be automatically added when receiving an issue',
             type => 'YesNo',
         },
+
+        {
+            uniquefieldrequired => 'variable',
+            variable            => 'RoutingSerials',
+            value               => '0',
+            forceupdate         => {
+                'explanation' => 1,
+                '
+                                        type' => 1
+            },
+            explanation =>
+'If set, will use alternate serials and routing lists functionality',
+            type => 'YesNo',
+        },
+           
         {
             uniquefieldrequired => 'variable',
             variable            => 'advancedMARCeditor',
@@ -837,7 +860,67 @@
             default => '',
             extra   => ''
         },
+	{
+	    field   => 'routingnotes',
+	    type    => 'TEXT',
+	    null    => 'NULL',
+	    key     => '',
+	    default => '',
+	    extra   => ''
+	},
+	{
+	    field   => 'claimdate',
+	    type    => 'DATE',
+	    null    => 'NULL',
+	    key     => '',
+	    default => '',
+	    extra   => ''
+	},	    
+    ],
+
+ subscription => [
+           {    
+	         field => 'firstacquidate',
+                 type    => 'DATE',
+                 null    => 'NULL',
+                 key     => '',
+                 default => '0000-00-00',
+ 	         extra   => ''		 
+           },
+           {     
+	         field => 'numberpattern',
+                 type    => 'int(4)',
+                 null    => 'NULL',
+                 key     => '',
+                 default => '0',
+ 	         extra   => ''		 		 
+           },
+           {     
+	         field => 'irregularity',
+                 type    => 'varchar(255)',
+                 null    => 'NULL',
+                 key     => '',
+                 default => '',
+ 	         extra   => ''		 		 
+           },
+           {     
+	         field => 'hemisphere',
+                 type    => 'int(1)',
+                 null    => '',
+                 key     => '',
+                 default => '1',
+ 	         extra   => ''		 		 
+           },
+           {     
+	         field => 'callnumber',
+                 type    => 'varchar(100)',
+                 null    => 'NULL',
+                 key     => '',
+                 default => '',
+ 	         extra   => ''		 		 
+           },     
     ],
+    
 	aqbasket =>  [
 		{
 			field	=> 'booksellerid',
@@ -2173,6 +2256,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.156  2006/07/20 04:36:01  bob_lyon
+# Merging back in some katipo changes to serials
+#
 # Revision 1.155  2006/07/17 12:51:48  toins
 # auto_increment id in aqbooksellers
 #