| Lines 4-14
          
      
      
        Link Here | 
        
          | 4 |  | 4 |  | 
        
          | 5 | CREATE TABLE IF NOT EXISTS `oai_harvester_biblios` ( | 5 | CREATE TABLE IF NOT EXISTS `oai_harvester_biblios` ( | 
        
          | 6 |   `import_oai_biblio_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 6 |   `import_oai_biblio_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 
          
            
              | 7 |   `oai_repository` varchar(255) NOT NULL, | 7 |   `oai_repository` varchar(191) NOT NULL, | 
            
              | 8 |   `oai_identifier` varchar(255) DEFAULT NULL, | 8 |   `oai_identifier` varchar(191) DEFAULT NULL, | 
        
          | 9 |   `biblionumber` int(11) NOT NULL, | 9 |   `biblionumber` int(11) NOT NULL, | 
        
          | 10 |   PRIMARY KEY (`import_oai_biblio_id`), | 10 |   PRIMARY KEY (`import_oai_biblio_id`), | 
          
            
              | 11 |   UNIQUE KEY `oai_record` (`oai_identifier`,`oai_repository`) USING BTREE, | 11 |   UNIQUE KEY `oai_record` (`oai_identifier`,`oai_repository` (191)) USING BTREE, | 
        
          | 12 |   KEY `FK_import_oai_biblio_1` (`biblionumber`), | 12 |   KEY `FK_import_oai_biblio_1` (`biblionumber`), | 
        
          | 13 |   CONSTRAINT `FK_import_oai_biblio_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE NO ACTION | 13 |   CONSTRAINT `FK_import_oai_biblio_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE NO ACTION | 
        
          | 14 | ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 14 | ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
  
    | Lines 39-47
          CREATE TABLE IF NOT EXISTS  `oai_harvester_history` (
      
      
        Link Here | 
        
          | 39 |  | 39 |  | 
        
          | 40 | CREATE TABLE IF NOT EXISTS `oai_harvester_import_queue` ( | 40 | CREATE TABLE IF NOT EXISTS `oai_harvester_import_queue` ( | 
        
          | 41 |   `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 41 |   `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 
          
            
              | 42 |   `uuid` varchar(45) CHARACTER SET utf8 NOT NULL, | 42 |   `uuid` varchar(45) NOT NULL, | 
            
              | 43 |   `status` varchar(45) CHARACTER SET utf8 NOT NULL DEFAULT 'new', | 43 |   `status` varchar(45) NOT NULL DEFAULT 'new', | 
            
              | 44 |   `result` text CHARACTER SET utf8 NOT NULL, | 44 |   `result` text NOT NULL, | 
        
          | 45 |   `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | 45 |   `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | 
        
          | 46 |   PRIMARY KEY (`id`) | 46 |   PRIMARY KEY (`id`) | 
        
          | 47 | ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 47 | ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |