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