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