[Koha-cvs] koha/tools holidays.sql [rel_2_2]

[Mason James]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_2_2
Changes by:	Mason James <sushi>	07/01/16 02:50:07

Added files:
	tools          : holidays.sql 

Log message:
	sql to create holidays tables.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/tools/holidays.sql?cvsroot=koha&only_with_tag=rel_2_2&rev=1.1.2.1

Patches:
Index: holidays.sql
===================================================================
RCS file: holidays.sql
diff -N holidays.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ holidays.sql	16 Jan 2007 02:50:07 -0000	1.1.2.1
@@ -0,0 +1,30 @@
+  DROP TABLE IF EXISTS `special_holidays`;
+CREATE TABLE `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`)
+) TYPE=MyISAM;
+
+
+ DROP TABLE IF EXISTS `repeatable_holidays`;
+CREATE TABLE `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`)
+) TYPE=MyISAM;
+
+
+
+
+