From 5a2ec51e92657d162803e51957947e03a266c92e Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sat, 27 Aug 2011 01:08:25 -0400 Subject: [PATCH] Bug 6716 - Document holiday tables This patch documents the special_holidays and repeatable_holidays tables. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 34 +++++++++++++++++----------------- 1 file changed, 17 insertions(+), 17 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 078a6e4481..00f872f890 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1497,14 +1497,14 @@ CREATE TABLE `printers_profile` ( -- DROP TABLE IF EXISTS `repeatable_holidays`; -CREATE TABLE `repeatable_holidays` ( - `id` int(11) NOT NULL auto_increment, - `branchcode` varchar(10) 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, +CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed + `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha + `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for + `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on + `day` smallint(6) default NULL, -- day of the month this closing is on + `month` smallint(6) default NULL, -- month this closing is in + `title` varchar(50) NOT NULL default '', -- title of this closing + `description` text NOT NULL, -- description for this closing PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -1683,15 +1683,15 @@ CREATE TABLE sessions ( -- DROP TABLE IF EXISTS `special_holidays`; -CREATE TABLE `special_holidays` ( - `id` int(11) NOT NULL auto_increment, - `branchcode` varchar(10) 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, +CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings + `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha + `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for + `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on + `month` smallint(6) NOT NULL default 0, -- month this closing is in + `year` smallint(6) NOT NULL default 0, -- year this closing is in + `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) + `title` varchar(50) NOT NULL default '', -- title for this closing + `description` text NOT NULL, -- description of this closing PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.11.0