Attachment #128440 for bug #29605

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




                ADD CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
            });

            say $out "Added missing foreign key on tmp_holdsqueue";
        }

        $dbh->do(
            q{
                ALTER TABLE `account_offsets`
                MODIFY COLUMN `type` enum( 'CREATE', 'APPLY', 'VOID', 'OVERDUE_INCREASE', 'OVERDUE_DECREASE' ) NOT NULL
            }
        );
        say $out "Ensure NOT NULL on account_offsets.type";

    },

}

Lines 34-40 return { Link Here

(-)a/installer/data/mysql/db_revs/210600013.pl (-2 / +1 lines)
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

Lines 32-39 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29605.pl (-1 / +10 lines)
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	}