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 |
- |
|
|