From 4f565a9b78acfe1f7c1eafdb6672f709f938c395 Mon Sep 17 00:00:00 2001 From: hdl Date: Mon, 27 Feb 2006 18:19:33 +0000 Subject: [PATCH] New table used in overduerules.pl tools page. --- updater/updatedatabase | 17 ++++++++++++++++- 1 file changed, 16 insertions(+), 1 deletion(-) diff --git a/updater/updatedatabase b/updater/updatedatabase index 8b619e2926..7384058926 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -93,7 +93,19 @@ my %requiretables = ( 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 @@ sub MARCgetitem { exit; # $Log$ +# 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 -- 2.20.1