[Koha-cvs] koha/misc holidays.sql [dev_week]
Tumer Garip
tgarip at neu.edu.tr
Wed Jul 12 13:21:38 CEST 2006
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;
More information about the Koha-cvs
mailing list