[Koha-cvs] koha/updater updatedatabase [rel_2_2]

[Chris Cormack]

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
 #