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

(-)a/installer/data/mysql/db_revs/220600048.pl (-1 / +5 lines)
Lines 6-11 return { Link Here
6 
    up => sub {
 6 
    up => sub {
7 
        my ($args) = @_;
 7 
        my ($args) = @_;
8 
        my ($dbh, $out) = @$args{qw(dbh out)};
 8 
        my ($dbh, $out) = @$args{qw(dbh out)};
9 

            

            

              10
              
        # Delete 'empty' guarantors. No longer possible to add them via interface. Have no use.

            

            

              11
              
        $dbh->do(q{

            

            

              12
              
DELETE FROM borrower_relationships WHERE guarantor_id IS NULL

            

            

              13
              
        });

            

        

          9
          
        $dbh->do(q{

          14
          
        $dbh->do(q{

        

        

          10
          
ALTER TABLE borrower_relationships CHANGE COLUMN guarantor_id guarantor_id int(11) NOT NULL

          15
          
ALTER TABLE borrower_relationships CHANGE COLUMN guarantor_id guarantor_id int(11) NOT NULL

        

        

          11
          
        });

          16
          
        });

        

            

              12
              
- 

              
              
            






  

  Return to bug 33671