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

(-)a/installer/data/mysql/kohastructure.sql (-17 / +33 lines)
Lines 683-704 CREATE TABLE `deleteditems` ( Link Here
683
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
683
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
684
684
685
--
685
--
686
-- Table structure for table `discrete_calendar`
687
--
688
689
DROP TABLE IF EXISTS `discrete_calendar`;
690
CREATE TABLE `discrete_calendar` (
691
    `date` datetime NOT NULL,
692
    `branchcode` varchar(10) NOT NULL,
693
    `is_opened` tinyint(1) DEFAULT 1,
694
    `holiday_type` varchar(1) DEFAULT '',
695
    `note` varchar(30) DEFAULT '',
696
    `open_hour` time NOT NULL,
697
    `close_hour` time NOT NULL,
698
    PRIMARY KEY (`branchcode`,`date`)
699
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
700
701
--
702
-- Table structure for table `export_format`
686
-- Table structure for table `export_format`
703
--
687
--
704
688
Lines 1398-1403 CREATE TABLE `printers_profile` ( Link Here
1398
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1382
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1399
1383
1400
--
1384
--
1385
-- Table structure for table `repeatable_holidays`
1386
--
1387
1388
DROP TABLE IF EXISTS `repeatable_holidays`;
1389
CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed
1390
  `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha
1391
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for
1392
  `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on
1393
  `day` smallint(6) default NULL, -- day of the month this closing is on
1394
  `month` smallint(6) default NULL, -- month this closing is in
1395
  `title` varchar(50) NOT NULL default '', -- title of this closing
1396
  `description` MEDIUMTEXT NOT NULL, -- description for this closing
1397
  PRIMARY KEY  (`id`)
1398
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1399
1400
--
1401
-- Table structure for table `reports_dictionary`
1401
-- Table structure for table `reports_dictionary`
1402
--
1402
--
1403
1403
Lines 1955-1960 CREATE TABLE `reviews` ( -- patron opac comments Link Here
1955
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1955
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1956
1956
1957
--
1957
--
1958
-- Table structure for table `special_holidays`
1959
--
1960
1961
DROP TABLE IF EXISTS `special_holidays`;
1962
CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings
1963
  `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha
1964
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for
1965
  `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on
1966
  `month` smallint(6) NOT NULL default 0, -- month this closing is in
1967
  `year` smallint(6) NOT NULL default 0, -- year this closing is in
1968
  `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no)
1969
  `title` varchar(50) NOT NULL default '', -- title for this closing
1970
  `description` MEDIUMTEXT NOT NULL, -- description of this closing
1971
  PRIMARY KEY  (`id`)
1972
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1973
1974
--
1958
-- Table structure for table `statistics`
1975
-- Table structure for table `statistics`
1959
--
1976
--
1960
1977
1961
- 

Return to bug 17015