[Koha-cvs] koha/updater updatedatabase

[LAURIN arnaud]

CVSROOT:	/sources/koha
Module name:	koha
Branch: 	
Changes by:	LAURIN arnaud <alaurin at savannah.gnu.org>	06/05/19 16:51:44

Modified files:
	updater        : updatedatabase 

Log message:
	update database for :
	- new feature ip and printer management
	adding two fields in branches table (branchip,branchprinter)
	
	- waiting date : adding one field in reserves table(waiting date) to calculate the Maximum delay to pick up a reserved document when it's available
	
	new system preference :
	- ReservesMaxPickUpDelay : Maximum delay to pick up a reserved document
	TransfersMaxDaysWarning : Max delay before considering the transfer as potentialy a problem

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/updater/updatedatabase.diff?tr1=1.137&tr2=1.138&r1=text&r2=text

Patches:
Index: koha/updater/updatedatabase
diff -u koha/updater/updatedatabase:1.137 koha/updater/updatedatabase:1.138
--- koha/updater/updatedatabase:1.137	Tue Apr 18 09:36:36 2006
+++ koha/updater/updatedatabase	Fri May 19 16:51:44 2006
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.137 2006/04/18 09:36:36 plg Exp $
+# $Id: updatedatabase,v 1.138 2006/05/19 16:51:44 alaurin Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -397,6 +397,24 @@
             explanation         => 'The relationships between a guarantor & a guarantee (separated by | or ,)',
             type                => 'free',
         },
+        {
+            uniquefieldrequired => 'variable',
+            variable            => 'ReservesMaxPickUpDelay',
+            value               => '10',
+            forceupdate         => { 'explanation' => 1,
+                                     'type' => 1},
+            explanation         => 'Maximum delay to pick up a reserved document',
+            type                => 'free',
+        },
+        {
+            uniquefieldrequired => 'variable',
+            variable            => 'TransfersMaxDaysWarning',
+            value               => '3',
+            forceupdate         => { 'explanation' => 1,
+                                     'type' => 1},
+            explanation         => 'Max delay before considering the transfer has potentialy a problem',
+            type                => 'free',
+        },
     ],
 
 );
@@ -527,6 +545,25 @@
 			after => 'contactfirstname',
 		},
 	],
+	
+	branches =>  [
+		{
+			field	=> 'branchip',
+			type	=> 'varchar(15)',
+			null	=> 'NULL',
+			key		=> '',
+			default	=> '',
+			extra	=> '',
+		},
+		{
+			field	=> 'branchprinter',
+			type	=> 'varchar(100)',
+			null	=> 'NULL',
+			key		=> '',
+			default	=> '',
+			extra	=> '',
+		},
+	],
 	categories =>  [
 		{
 			field	=> 'category_type',
@@ -537,7 +574,16 @@
 			extra	=> '',
 		},
 	],
-
+	reserves =>  [
+		{
+			field	=> 'waitingdate',
+			type	=> 'date',
+			null	=> 'NULL',
+			key		=> '',
+			default	=> '',
+			extra	=> '',
+		},
+	],
 );
 
 my %indexes = (
@@ -1528,6 +1574,17 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.138  2006/05/19 16:51:44  alaurin
+# update database for :
+# - new feature ip and printer management
+# adding two fields in branches table (branchip,branchprinter)
+#
+# - waiting date : adding one field in reserves table(waiting date) to calculate the Maximum delay to pick up a reserved document when it's available
+#
+# new system preference :
+# - ReservesMaxPickUpDelay : Maximum delay to pick up a reserved document
+# TransfersMaxDaysWarning : Max delay before considering the transfer as potentialy a problem
+#
 # Revision 1.137  2006/04/18 09:36:36  plg
 # bug fixed: typo fixed in labels and labels_conf tables creation query.
 #