[Koha-cvs] koha/misc holidays.sql [dev_week]

[Tumer Garip]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         dev_week
Changes by:     Tumer Garip <tgarip1957>        06/07/12 11:21:38

Added files:
        misc           : holidays.sql 

Log message:
        Database structure for holidays

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/holidays.sql?cvsroot=koha&only_with_tag=dev_week&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        12 Jul 2006 11:21:38 -0000      1.1.2.1
@@ -0,0 +1,28 @@
+--
+-- Table structure for table `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;
+-- Table structure for table `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;