[Koha-cvs] koha/updater updatedatabase

[Henri-Damien LAURENT]

CVSROOT:        /cvsroot/koha
Module name:    koha
Branch:         
Changes by:     Henri-Damien LAURENT <address@hidden>   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