[Koha-cvs] koha/updater updatedatabase

[Henri-Damien LAURENT]

CVSROOT:	/cvsroot/koha
Module name:	koha
Branch: 	
Changes by:	Henri-Damien LAURENT <hdl at savannah.gnu.org>	06/02/27 18:19:33

Modified files:
	updater        : updatedatabase 

Log message:
	New table used in overduerules.pl tools page.

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

Patches:
Index: koha/updater/updatedatabase
diff -u koha/updater/updatedatabase:1.128 koha/updater/updatedatabase:1.129
--- koha/updater/updatedatabase:1.128	Wed Jan 25 15:16:06 2006
+++ koha/updater/updatedatabase	Mon Feb 27 18:19:33 2006
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.128 2006/01/25 15:16:06 tipaul Exp $
+# $Id: updatedatabase,v 1.129 2006/02/27 18:19:33 hdl Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -93,7 +93,19 @@
 					KEY borrowernumber (borrowernumber),
 					KEY type (type,externalid)
 				)",
-
+	overduerules	=>"(`branchcode` varchar(255) NOT NULL default '',
+					`categorycode` char(2) NOT NULL default '',
+					`delay1` int(4) default '0',
+					`letter1` varchar(20) default NULL,
+					`debarred1` char(1) default '0',
+					`delay2` int(4) default '0',
+					`debarred2` char(1) default '0',
+					`letter2` varchar(20) default NULL,
+					`delay3` int(4) default '0',
+					`letter3` varchar(20) default NULL,
+					`debarred3` int(1) default '0',
+					PRIMARY KEY  (`branchcode`,`categorycode`)
+					)",
 );
 
 my %requirefields = (
@@ -1229,6 +1241,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.129  2006/02/27 18:19:33  hdl
+# New table used in overduerules.pl tools page.
+#
 # Revision 1.128  2006/01/25 15:16:06  tipaul
 # updating DB :
 # * removing useless tables