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

(-)a/installer/data/mysql/kohastructure.sql (-17 / +33 lines)
Lines 693-714 CREATE TABLE `deleteditems` ( Link Here
693
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
693
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
694
694
695
--
695
--
696
-- Table structure for table `discrete_calendar`
697
--
698
699
DROP TABLE IF EXISTS `discrete_calendar`;
700
CREATE TABLE `discrete_calendar` (
701
    `date` datetime NOT NULL,
702
    `branchcode` varchar(10) NOT NULL,
703
    `is_opened` tinyint(1) DEFAULT 1,
704
    `holiday_type` varchar(1) DEFAULT '',
705
    `note` varchar(30) DEFAULT '',
706
    `open_hour` time NOT NULL,
707
    `close_hour` time NOT NULL,
708
    PRIMARY KEY (`branchcode`,`date`)
709
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
710
711
--
712
-- Table structure for table `export_format`
696
-- Table structure for table `export_format`
713
--
697
--
714
698
Lines 1408-1413 CREATE TABLE `printers_profile` ( Link Here
1408
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1392
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1409
1393
1410
--
1394
--
1395
-- Table structure for table `repeatable_holidays`
1396
--
1397
1398
DROP TABLE IF EXISTS `repeatable_holidays`;
1399
CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed
1400
  `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha
1401
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for
1402
  `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on
1403
  `day` smallint(6) default NULL, -- day of the month this closing is on
1404
  `month` smallint(6) default NULL, -- month this closing is in
1405
  `title` varchar(50) NOT NULL default '', -- title of this closing
1406
  `description` MEDIUMTEXT NOT NULL, -- description for this closing
1407
  PRIMARY KEY  (`id`)
1408
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1409
1410
--
1411
-- Table structure for table `reports_dictionary`
1411
-- Table structure for table `reports_dictionary`
1412
--
1412
--
1413
1413
Lines 1965-1970 CREATE TABLE `reviews` ( -- patron opac comments Link Here
1965
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1965
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1966
1966
1967
--
1967
--
1968
-- Table structure for table `special_holidays`
1969
--
1970
1971
DROP TABLE IF EXISTS `special_holidays`;
1972
CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings
1973
  `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha
1974
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for
1975
  `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on
1976
  `month` smallint(6) NOT NULL default 0, -- month this closing is in
1977
  `year` smallint(6) NOT NULL default 0, -- year this closing is in
1978
  `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no)
1979
  `title` varchar(50) NOT NULL default '', -- title for this closing
1980
  `description` MEDIUMTEXT NOT NULL, -- description of this closing
1981
  PRIMARY KEY  (`id`)
1982
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1983
1984
--
1968
-- Table structure for table `statistics`
1985
-- Table structure for table `statistics`
1969
--
1986
--
1970
1987
1971
- 

Return to bug 17015