| Lines 2147-2154
          CREATE TABLE `subscriptionhistory` (
      
      
        Link Here | 
        
          | 2147 |   `histenddate` date default NULL, | 2147 |   `histenddate` date default NULL, | 
        
          | 2148 |   `missinglist` LONGTEXT NOT NULL, | 2148 |   `missinglist` LONGTEXT NOT NULL, | 
        
          | 2149 |   `recievedlist` LONGTEXT NOT NULL, | 2149 |   `recievedlist` LONGTEXT NOT NULL, | 
          
            
              | 2150 |   `opacnote` varchar(150) NOT NULL default '', | 2150 |   `opacnote` LONGTEXT NOT NULL default '', | 
            
              | 2151 |   `librariannote` varchar(150) NOT NULL default '', | 2151 |   `librariannote` LONGTEXT NOT NULL default '', | 
        
          | 2152 |   PRIMARY KEY  (`subscriptionid`), | 2152 |   PRIMARY KEY  (`subscriptionid`), | 
        
          | 2153 |   KEY `biblionumber` (`biblionumber`) | 2153 |   KEY `biblionumber` (`biblionumber`) | 
        
          | 2154 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 2154 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
            
              | 2155 | -  |  |  |