[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/updater updatedatabase [rel_2_2]
From: |
Chris Cormack |
Subject: |
[Koha-cvs] koha/updater updatedatabase [rel_2_2] |
Date: |
Mon, 12 Feb 2007 23:56:12 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: rel_2_2
Changes by: Chris Cormack <rangi> 07/02/12 23:56:11
Modified files:
updater : updatedatabase
Log message:
Adding in missing tables to make the Holiday code work
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_2_2&r1=1.100.2.59&r2=1.100.2.60
Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.100.2.59
retrieving revision 1.100.2.60
diff -u -b -r1.100.2.59 -r1.100.2.60
--- updatedatabase 8 Feb 2007 09:25:41 -0000 1.100.2.59
+++ updatedatabase 12 Feb 2007 23:56:11 -0000 1.100.2.60
@@ -1,6 +1,6 @@
#!/usr/bin/perl
-# $Id: updatedatabase,v 1.100.2.59 2007/02/08 09:25:41 tipaul Exp $
+# $Id: updatedatabase,v 1.100.2.60 2007/02/12 23:56:11 rangi Exp $
# Database Updater
# This script checks for required updates to the database.
@@ -405,6 +405,27 @@
guidebox tinyint(1) default NULL,
PRIMARY KEY (id)
)",
+ repeatable_holidays => "(id int(11) NOT NULL auto_increment,
+ branchcode varchar(4) NOT NULL default '',
+ weekday smallint(6) default NULL,
+ day smallint(6) default NULL,
+ month smallint(6) default NULL,
+ title varchar(50) NOT NULL default '',
+ description text NOT NULL,
+ PRIMARY KEY (id)
+ )",
+ special_holidays => "(
+ id int(11) NOT NULL auto_increment,
+ branchcode varchar(4) NOT NULL default '',
+ day smallint(6) NOT NULL default '0',
+ month smallint(6) NOT NULL default '0',
+ year smallint(6) NOT NULL default '0',
+ isexception smallint(1) NOT NULL default '1',
+ title varchar(50) NOT NULL default '',
+ description text NOT NULL,
+ PRIMARY KEY (id)
+ )",
+
);
my %requirefields = (
@@ -2303,6 +2324,9 @@
exit;
# $Log: updatedatabase,v $
+# Revision 1.100.2.60 2007/02/12 23:56:11 rangi
+# Adding in missing tables to make the Holiday code work
+#
# Revision 1.100.2.59 2007/02/08 09:25:41 tipaul
# changing tagorder to int(11) instead of tinyint
#