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

(-)a/installer/data/mysql/atomicupdate/bug_29605.pl (-1 / +10 lines)
Lines 32-39 return { Link Here
32
                ADD CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
32
                ADD CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
33
            });
33
            });
34
34
35
            say $out "Added missing foreign key on tmp_holdsqueue"
35
            say $out "Added missing foreign key on tmp_holdsqueue";
36
        }
36
        }
37
37
38
        $dbh->do(
39
            q{
40
                ALTER TABLE `account_offsets`
41
                MODIFY COLUMN `type` enum( 'CREATE', 'APPLY', 'VOID', 'OVERDUE_INCREASE', 'OVERDUE_DECREASE' ) NOT NULL
42
            }
43
        );
44
        say $out "Ensure NOT NULL on account_offsets.type";
45
38
    },
46
    },
47
39
}
48
}
(-)a/installer/data/mysql/db_revs/210600013.pl (-2 / +1 lines)
Lines 34-40 return { Link Here
34
                        'VOID',
34
                        'VOID',
35
                        'OVERDUE_INCREASE',
35
                        'OVERDUE_INCREASE',
36
                        'OVERDUE_DECREASE'
36
                        'OVERDUE_DECREASE'
37
                    )
37
                    ) NOT NULL
38
                AFTER `debit_id`
38
                AFTER `debit_id`
39
              }
39
              }
40
        );
40
        );
41
- 

Return to bug 29605