|
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 |
- |
|
|