| Lines 1349-1355
          CREATE TABLE `printers` (
      
      
        Link Here | 
        
          | 1349 |   `printername` varchar(40) NOT NULL default '', | 1349 |   `printername` varchar(40) NOT NULL default '', | 
        
          | 1350 |   `printqueue` varchar(20) default NULL, | 1350 |   `printqueue` varchar(20) default NULL, | 
        
          | 1351 |   `printtype` varchar(20) default NULL, | 1351 |   `printtype` varchar(20) default NULL, | 
          
            
              | 1352 |   PRIMARY KEY  (`printername`) | 1352 |   PRIMARY KEY (`printername`) | 
        
          | 1353 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1353 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1354 |  | 1354 |  | 
        
          | 1355 | -- | 1355 | -- | 
  
    | Lines 1441-1447
          CREATE TABLE saved_reports (
      
      
        Link Here | 
        
          | 1441 |    `report_id` int(11) default NULL, | 1441 |    `report_id` int(11) default NULL, | 
        
          | 1442 |    `report` longtext, | 1442 |    `report` longtext, | 
        
          | 1443 |    `date_run` datetime default NULL, | 1443 |    `date_run` datetime default NULL, | 
          
            
              | 1444 |    PRIMARY KEY  (`id`) | 1444 |    PRIMARY KEY (`id`) | 
        
          | 1445 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1445 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1446 |  | 1446 |  | 
        
          | 1447 | -- | 1447 | -- | 
  
    | Lines 1455-1461
          CREATE TABLE `search_field` (
      
      
        Link Here | 
        
          | 1455 |   `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', | 1455 |   `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', | 
        
          | 1456 |   `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', | 1456 |   `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', | 
        
          | 1457 |   PRIMARY KEY (`id`), | 1457 |   PRIMARY KEY (`id`), | 
          
            
              | 1458 |   UNIQUE KEY (`name` (191) ) | 1458 |   UNIQUE KEY (`name` (191)) | 
        
          | 1459 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1459 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1460 |  | 1460 |  | 
        
          | 1461 | -- | 1461 | -- | 
  
    | Lines 1474-1480
          CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
      
      
        Link Here | 
        
          | 1474 |   `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run | 1474 |   `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run | 
        
          | 1475 |   KEY `userid` (`userid`), | 1475 |   KEY `userid` (`userid`), | 
        
          | 1476 |   KEY `sessionid` (`sessionid`), | 1476 |   KEY `sessionid` (`sessionid`), | 
          
            
              | 1477 |   PRIMARY KEY  (`id`) | 1477 |   PRIMARY KEY (`id`) | 
        
          | 1478 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; | 1478 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results'; | 
        
          | 1479 |  | 1479 |  | 
        
          | 1480 | -- | 1480 | -- | 
  
    | Lines 1488-1494
          CREATE TABLE `search_marc_map` (
      
      
        Link Here | 
        
          | 1488 |   marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', | 1488 |   marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for', | 
        
          | 1489 |   marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', | 1489 |   marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field', | 
        
          | 1490 |   PRIMARY KEY(`id`), | 1490 |   PRIMARY KEY(`id`), | 
          
            
              | 1491 |   UNIQUE key(index_name, marc_field(191), marc_type), | 1491 |   UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`), | 
        
          | 1492 |   INDEX (`index_name`) | 1492 |   INDEX (`index_name`) | 
        
          | 1493 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1493 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1494 |  | 1494 |  | 
  
    | Lines 1529-1535
          CREATE TABLE `serial` ( -- issues related to subscriptions
      
      
        Link Here | 
        
          | 1529 |   `claimdate` date default NULL, -- date claimed | 1529 |   `claimdate` date default NULL, -- date claimed | 
        
          | 1530 |   claims_count int(11) default 0, -- number of claims made related to this issue | 1530 |   claims_count int(11) default 0, -- number of claims made related to this issue | 
        
          | 1531 |   `routingnotes` text, -- notes from the routing list | 1531 |   `routingnotes` text, -- notes from the routing list | 
          
            
              | 1532 |   PRIMARY KEY  (`serialid`) | 1532 |   PRIMARY KEY (`serialid`) | 
        
          | 1533 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 1533 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 1534 |  | 1534 |  | 
        
          | 1535 | -- | 1535 | -- | 
            
              | 1536 | -  |  |  |