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