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