View | Details | Raw Unified | Return to bug 17015
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-17 / +33 lines)
Lines 710-731 CREATE TABLE `deleteditems` ( Link Here
710
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
710
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
711
711
712
--
712
--
713
-- Table structure for table `discrete_calendar`
714
--
715
716
DROP TABLE IF EXISTS `discrete_calendar`;
717
CREATE TABLE `discrete_calendar` (
718
    `date` datetime NOT NULL,
719
    `branchcode` varchar(10) NOT NULL,
720
    `is_opened` tinyint(1) DEFAULT 1,
721
    `holiday_type` varchar(1) DEFAULT '',
722
    `note` varchar(30) DEFAULT '',
723
    `open_hour` time NOT NULL,
724
    `close_hour` time NOT NULL,
725
    PRIMARY KEY (`branchcode`,`date`)
726
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
727
728
--
729
-- Table structure for table `export_format`
713
-- Table structure for table `export_format`
730
--
714
--
731
715
Lines 1426-1431 CREATE TABLE `printers_profile` ( Link Here
1426
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1410
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1427
1411
1428
--
1412
--
1413
-- Table structure for table `repeatable_holidays`
1414
--
1415
1416
DROP TABLE IF EXISTS `repeatable_holidays`;
1417
CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed
1418
  `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha
1419
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for
1420
  `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on
1421
  `day` smallint(6) default NULL, -- day of the month this closing is on
1422
  `month` smallint(6) default NULL, -- month this closing is in
1423
  `title` varchar(50) NOT NULL default '', -- title of this closing
1424
  `description` MEDIUMTEXT NOT NULL, -- description for this closing
1425
  PRIMARY KEY  (`id`)
1426
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1427
1428
--
1429
-- Table structure for table `reports_dictionary`
1429
-- Table structure for table `reports_dictionary`
1430
--
1430
--
1431
1431
Lines 1986-1991 CREATE TABLE `reviews` ( -- patron opac comments Link Here
1986
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1986
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1987
1987
1988
--
1988
--
1989
-- Table structure for table `special_holidays`
1990
--
1991
1992
DROP TABLE IF EXISTS `special_holidays`;
1993
CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings
1994
  `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha
1995
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for
1996
  `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on
1997
  `month` smallint(6) NOT NULL default 0, -- month this closing is in
1998
  `year` smallint(6) NOT NULL default 0, -- year this closing is in
1999
  `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no)
2000
  `title` varchar(50) NOT NULL default '', -- title for this closing
2001
  `description` MEDIUMTEXT NOT NULL, -- description of this closing
2002
  PRIMARY KEY  (`id`)
2003
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2004
2005
--
1989
-- Table structure for table `statistics`
2006
-- Table structure for table `statistics`
1990
--
2007
--
1991
2008
1992
- 

Return to bug 17015