| Lines 10421-10433
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here | 
        
          | 10421 | $DBversion = "3.19.00.041"; | 10421 | $DBversion = "3.19.00.041"; | 
        
          | 10422 | if ( CheckVersion($DBversion) ) { | 10422 | if ( CheckVersion($DBversion) ) { | 
        
          | 10423 |     $dbh->do(q| | 10423 |     $dbh->do(q| | 
          
            
              | 10424 |         ALTER IGNORE TABLE suggestions ADD KEY status (STATUS) | 10424 |         ALTER TABLE suggestions ADD KEY status (STATUS) | 
        
          | 10425 |     |); | 10425 |     |); | 
        
          | 10426 |     $dbh->do(q| | 10426 |     $dbh->do(q| | 
          
            
              | 10427 |         ALTER IGNORE TABLE suggestions ADD KEY biblionumber (biblionumber) | 10427 |         ALTER TABLE suggestions ADD KEY biblionumber (biblionumber) | 
        
          | 10428 |     |); | 10428 |     |); | 
        
          | 10429 |     $dbh->do(q| | 10429 |     $dbh->do(q| | 
          
            
              | 10430 |         ALTER IGNORE TABLE suggestions ADD KEY branchcode (branchcode) | 10430 |         ALTER TABLE suggestions ADD KEY branchcode (branchcode) | 
        
          | 10431 |     |); | 10431 |     |); | 
        
          | 10432 |     print "Upgrade to $DBversion done (Bug 14132: suggestions table is missing indexes)\n"; | 10432 |     print "Upgrade to $DBversion done (Bug 14132: suggestions table is missing indexes)\n"; | 
        
          | 10433 |     SetVersion ($DBversion); | 10433 |     SetVersion ($DBversion); | 
  
    | Lines 10443-10449
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here | 
        
          | 10443 |     }); | 10443 |     }); | 
        
          | 10444 |  | 10444 |  | 
        
          | 10445 |     $dbh->do(q{ | 10445 |     $dbh->do(q{ | 
          
            
              | 10446 |         ALTER IGNORE TABLE auth_subfield_structure | 10446 |         ALTER TABLE auth_subfield_structure | 
        
          | 10447 |         ADD CONSTRAINT auth_subfield_structure_ibfk_1 | 10447 |         ADD CONSTRAINT auth_subfield_structure_ibfk_1 | 
        
          | 10448 |         FOREIGN KEY (authtypecode) REFERENCES auth_types(authtypecode) | 10448 |         FOREIGN KEY (authtypecode) REFERENCES auth_types(authtypecode) | 
        
          | 10449 |         ON DELETE CASCADE ON UPDATE CASCADE | 10449 |         ON DELETE CASCADE ON UPDATE CASCADE | 
  
    | Lines 10564-10578
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here | 
        
          | 10564 | $DBversion = "3.21.00.007"; | 10564 | $DBversion = "3.21.00.007"; | 
        
          | 10565 | if ( CheckVersion($DBversion) ) { | 10565 | if ( CheckVersion($DBversion) ) { | 
        
          | 10566 |     $dbh->do(q| | 10566 |     $dbh->do(q| | 
          
            
              | 10567 |         ALTER IGNORE TABLE aqbasket | 10567 |         ALTER TABLE aqbasket | 
        
          | 10568 |             ADD KEY authorisedby (authorisedby) | 10568 |             ADD KEY authorisedby (authorisedby) | 
        
          | 10569 |     |); | 10569 |     |); | 
        
          | 10570 |     $dbh->do(q| | 10570 |     $dbh->do(q| | 
          
            
              | 10571 |         ALTER IGNORE TABLE aqbooksellers | 10571 |         ALTER TABLE aqbooksellers | 
        
          | 10572 |             ADD KEY name (name(255)) | 10572 |             ADD KEY name (name(255)) | 
        
          | 10573 |     |); | 10573 |     |); | 
        
          | 10574 |     $dbh->do(q| | 10574 |     $dbh->do(q| | 
          
            
              | 10575 |         ALTER IGNORE TABLE aqbudgets | 10575 |         ALTER TABLE aqbudgets | 
        
          | 10576 |             ADD KEY budget_parent_id (budget_parent_id), | 10576 |             ADD KEY budget_parent_id (budget_parent_id), | 
        
          | 10577 |             ADD KEY budget_code (budget_code), | 10577 |             ADD KEY budget_code (budget_code), | 
        
          | 10578 |             ADD KEY budget_branchcode (budget_branchcode), | 10578 |             ADD KEY budget_branchcode (budget_branchcode), | 
  
    | Lines 10580-10590
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here | 
        
          | 10580 |             ADD KEY budget_owner_id (budget_owner_id) | 10580 |             ADD KEY budget_owner_id (budget_owner_id) | 
        
          | 10581 |     |); | 10581 |     |); | 
        
          | 10582 |     $dbh->do(q| | 10582 |     $dbh->do(q| | 
          
            
              | 10583 |         ALTER IGNORE TABLE aqbudgets_planning | 10583 |         ALTER TABLE aqbudgets_planning | 
        
          | 10584 |             ADD KEY budget_period_id (budget_period_id) | 10584 |             ADD KEY budget_period_id (budget_period_id) | 
        
          | 10585 |     |); | 10585 |     |); | 
        
          | 10586 |     $dbh->do(q| | 10586 |     $dbh->do(q| | 
          
            
              | 10587 |         ALTER IGNORE TABLE aqorders | 10587 |         ALTER TABLE aqorders | 
        
          | 10588 |             ADD KEY parent_ordernumber (parent_ordernumber), | 10588 |             ADD KEY parent_ordernumber (parent_ordernumber), | 
        
          | 10589 |             ADD KEY orderstatus (orderstatus) | 10589 |             ADD KEY orderstatus (orderstatus) | 
        
          | 10590 |     |); | 10590 |     |); | 
  
    | Lines 10821-10827
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here | 
        
          | 10821 |     $dbh->{PrintError} = $print_error; | 10821 |     $dbh->{PrintError} = $print_error; | 
        
          | 10822 |  | 10822 |  | 
        
          | 10823 |     $dbh->do(q{ | 10823 |     $dbh->do(q{ | 
          
            
              | 10824 |         ALTER IGNORE TABLE course_reserves | 10824 |         ALTER TABLE course_reserves | 
        
          | 10825 |             ADD CONSTRAINT course_reserves_ibfk_2 | 10825 |             ADD CONSTRAINT course_reserves_ibfk_2 | 
        
          | 10826 |                 FOREIGN KEY (ci_id) REFERENCES course_items (ci_id) | 10826 |                 FOREIGN KEY (ci_id) REFERENCES course_items (ci_id) | 
        
          | 10827 |                 ON DELETE CASCADE ON UPDATE CASCADE | 10827 |                 ON DELETE CASCADE ON UPDATE CASCADE | 
  
    | Lines 10934-10940
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here | 
        
          | 10934 | $DBversion = "3.21.00.029"; | 10934 | $DBversion = "3.21.00.029"; | 
        
          | 10935 | if ( CheckVersion($DBversion) ) { | 10935 | if ( CheckVersion($DBversion) ) { | 
        
          | 10936 |     $dbh->do(q{ | 10936 |     $dbh->do(q{ | 
          
            
              | 10937 |         ALTER IGNORE TABLE discharges | 10937 |         ALTER TABLE discharges | 
        
          | 10938 |             ADD COLUMN discharge_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST | 10938 |             ADD COLUMN discharge_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST | 
        
          | 10939 |     }); | 10939 |     }); | 
        
          | 10940 |     print "Upgrade to $DBversion done (Bug 14368: Add discharges history)\n"; | 10940 |     print "Upgrade to $DBversion done (Bug 14368: Add discharges history)\n"; | 
            
              | 10941 | -  |  |  |