| Lines 1320-1332
          CREATE TABLE `printers_profile` (
      
      
        Link Here | 
        
          | 1320 | DROP TABLE IF EXISTS `repeatable_holidays`; | 1320 | DROP TABLE IF EXISTS `repeatable_holidays`; | 
        
          | 1321 | CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed | 1321 | CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed | 
        
          | 1322 |   `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha | 1322 |   `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha | 
          
            
              | 1323 |   `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for | 1323 |   `branchcode` varchar(10) NOT NULL, -- foreign key from the branches table, defines which branch this closing is for | 
        
          | 1324 |   `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on | 1324 |   `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on | 
        
          | 1325 |   `day` smallint(6) default NULL, -- day of the month this closing is on | 1325 |   `day` smallint(6) default NULL, -- day of the month this closing is on | 
        
          | 1326 |   `month` smallint(6) default NULL, -- month this closing is in | 1326 |   `month` smallint(6) default NULL, -- month this closing is in | 
        
          | 1327 |   `title` varchar(50) NOT NULL default '', -- title of this closing | 1327 |   `title` varchar(50) NOT NULL default '', -- title of this closing | 
        
          | 1328 |   `description` MEDIUMTEXT NOT NULL, -- description for this closing | 1328 |   `description` MEDIUMTEXT NOT NULL, -- description for this closing | 
          
            
              | 1329 |   PRIMARY KEY  (`id`) | 1329 |   PRIMARY KEY  (`id`), | 
            
              |  |  | 1330 |   CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE | 
        
          | 1330 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1331 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1331 |  | 1332 |  | 
        
          | 1332 | -- | 1333 | -- | 
  
    | Lines 1902-1915
          CREATE TABLE `reviews` ( -- patron opac comments
      
      
        Link Here | 
        
          | 1902 | DROP TABLE IF EXISTS `special_holidays`; | 1903 | DROP TABLE IF EXISTS `special_holidays`; | 
        
          | 1903 | CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings | 1904 | CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings | 
        
          | 1904 |   `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha | 1905 |   `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha | 
          
            
              | 1905 |   `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for | 1906 |   `branchcode` varchar(10) NOT NULL, -- foreign key from the branches table, defines which branch this closing is for | 
        
          | 1906 |   `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on | 1907 |   `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on | 
        
          | 1907 |   `month` smallint(6) NOT NULL default 0, -- month this closing is in | 1908 |   `month` smallint(6) NOT NULL default 0, -- month this closing is in | 
        
          | 1908 |   `year` smallint(6) NOT NULL default 0, -- year this closing is in | 1909 |   `year` smallint(6) NOT NULL default 0, -- year this closing is in | 
        
          | 1909 |   `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) | 1910 |   `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) | 
        
          | 1910 |   `title` varchar(50) NOT NULL default '', -- title for this closing | 1911 |   `title` varchar(50) NOT NULL default '', -- title for this closing | 
        
          | 1911 |   `description` MEDIUMTEXT NOT NULL, -- description of this closing | 1912 |   `description` MEDIUMTEXT NOT NULL, -- description of this closing | 
          
            
              | 1912 |   PRIMARY KEY  (`id`) | 1913 |   PRIMARY KEY  (`id`), | 
            
              |  |  | 1914 |   CONSTRAINT `special_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE | 
        
          | 1913 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1915 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1914 |  | 1916 |  | 
        
          | 1915 | -- | 1917 | -- | 
            
              | 1916 | -  |  |  |