View | Details | Raw Unified | Return to bug 17762
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx.perl (+3 lines)
Lines 10-15 if( CheckVersion( $DBversion ) ) { Link Here
10 
        $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN lang VARCHAR(25) NOT NULL DEFAULT 'default' AFTER lastseen" );
 10 
        $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN lang VARCHAR(25) NOT NULL DEFAULT 'default' AFTER lastseen" );
11 
    }
 11 
    }
12 

          12
          

        

            

              
              
              13
              
    # Add test on existene of this key

            

            

              14
              
    ALTER TABLE message_transports DROP FOREIGN KEY message_transports_ibfk_3;

            

            

              15
              

            

        

          13
          
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)

          16
          
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)

        

        

          14
          
        VALUES ('TranslateNotices',  '0',  NULL,  'Allow notices to be translated',  'YesNo') ");

          17
          
        VALUES ('TranslateNotices',  '0',  NULL,  'Allow notices to be translated',  'YesNo') ");

        

        

          15
          

          18
          

        



(-)a/installer/data/mysql/kohastructure.sql
      (-2 lines)




  

    
      
            Lines 2579-2585
          CREATE TABLE `message_transports` (
      
      
        Link Here
      
    
  

        

          2579
          
  KEY `letter_module` (`letter_module`,`letter_code`),

          2579
          
  KEY `letter_module` (`letter_module`,`letter_code`),

        

        

          2580
          
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,

          2580
          
  CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,

        

        

          2581
          
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,

          2581
          
  CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,

        

            

              2582
              
  CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`, `branchcode`) REFERENCES `letter` (`module`, `code`, `branchcode`) ON DELETE CASCADE ON UPDATE CASCADE

              
              
            

        

          2583
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

          2582
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

        

        

          2584
          

          2583
          

        

        

          2585
          
--

          2584
          
--

        

            

              2586
              
- 

              
              
            






  

  Return to bug 17762