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