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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 16129-16135 if( CheckVersion( $DBversion ) ) { Link Here
16129
16129
16130
$DBversion = '18.06.00.005';
16130
$DBversion = '18.06.00.005';
16131
if( CheckVersion( $DBversion ) ) {
16131
if( CheckVersion( $DBversion ) ) {
16132
    unless ( column_exists('aqorders', 'created') ) {
16132
    unless ( column_exists('aqorders', 'created_by') ) {
16133
        $dbh->do( "ALTER TABLE aqorders ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived;" );
16133
        $dbh->do( "ALTER TABLE aqorders ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived;" );
16134
        unless ( foreign_key_exists('aqorders', 'aqorders_created_by') ) {
16134
        unless ( foreign_key_exists('aqorders', 'aqorders_created_by') ) {
16135
            $dbh->do( "ALTER TABLE aqorders ADD CONSTRAINT aqorders_created_by FOREIGN KEY (created_by) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE;" );
16135
            $dbh->do( "ALTER TABLE aqorders ADD CONSTRAINT aqorders_created_by FOREIGN KEY (created_by) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE;" );
16136
- 

Return to bug 21129