| Lines 1434-1439
          CREATE TABLE saved_sql ( -- saved sql reports
      
      
        Link Here | 
        
          | 1434 |     report_area varchar(6) default NULL, | 1434 |     report_area varchar(6) default NULL, | 
        
          | 1435 |     report_group varchar(80) default NULL, | 1435 |     report_group varchar(80) default NULL, | 
        
          | 1436 |     report_subgroup varchar(80) default NULL, | 1436 |     report_subgroup varchar(80) default NULL, | 
            
              |  |  | 1437 |     `mana_id` int(11) NULL DEFAULT NULL, | 
        
          | 1437 |    PRIMARY KEY  (`id`), | 1438 |    PRIMARY KEY  (`id`), | 
        
          | 1438 |    KEY sql_area_group_idx (report_group, report_subgroup), | 1439 |    KEY sql_area_group_idx (report_group, report_subgroup), | 
        
          | 1439 |    KEY boridx (`borrowernumber`) | 1440 |    KEY boridx (`borrowernumber`) | 
  
    | Lines 2097-2102
          CREATE TABLE `subscription` ( -- information related to the subscription
      
      
        Link Here | 
        
          | 2097 |   `reneweddate` date default NULL, -- date of last renewal for the subscription | 2098 |   `reneweddate` date default NULL, -- date of last renewal for the subscription | 
        
          | 2098 |   `itemtype` VARCHAR( 10 ) NULL, | 2099 |   `itemtype` VARCHAR( 10 ) NULL, | 
        
          | 2099 |   `previousitemtype` VARCHAR( 10 ) NULL, | 2100 |   `previousitemtype` VARCHAR( 10 ) NULL, | 
            
              |  |  | 2101 |   `mana_id` int(11) NULL DEFAULT NULL, | 
        
          | 2100 |   PRIMARY KEY  (`subscriptionid`), | 2102 |   PRIMARY KEY  (`subscriptionid`), | 
        
          | 2101 |   KEY `by_biblionumber` (`biblionumber`), | 2103 |   KEY `by_biblionumber` (`biblionumber`), | 
        
          | 2102 |   CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, | 2104 |   CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, |