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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 2183-2189 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
2183
	total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency)
2183
	total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency)
2184
  PRIMARY KEY  (`suggestionid`),
2184
  PRIMARY KEY  (`suggestionid`),
2185
  KEY `suggestedby` (`suggestedby`),
2185
  KEY `suggestedby` (`suggestedby`),
2186
  KEY `managedby` (`managedby`)
2186
  KEY `managedby` (`managedby`),
2187
  CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE
2187
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2188
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2188
2189
2189
--
2190
--
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +20 lines)
Lines 8790-8795 if ( CheckVersion($DBversion) ) { Link Here
8790
    SetVersion($DBversion);
8790
    SetVersion($DBversion);
8791
}
8791
}
8792
8792
8793
$DBversion = "3.17.00.XXX";
8794
if ( CheckVersion($DBversion) ) {
8795
    $dbh->do(q|
8796
        UPDATE suggestions s SET s.budgetid = NULL
8797
        WHERE NOT EXISTS (
8798
            SELECT NULL
8799
            FROM aqbudgets b
8800
            WHERE b.budget_id = s.budgetid
8801
        );
8802
    |);
8803
8804
    $dbh->do(q|
8805
        ALTER TABLE suggestions
8806
        ADD CONSTRAINT suggestions_budget_id_fk FOREIGN KEY (budgetid) REFERENCES aqbudgets(budget_id) ON DELETE SET NULL ON UPDATE CASCADE
8807
    |);
8808
8809
    print "Upgrade to $DBversion done (Bug XXXXX - Add new foreign key suggestions.budgetid\n");
8810
    SetVersion($DBversion);
8811
}
8812
8793
=head1 FUNCTIONS
8813
=head1 FUNCTIONS
8794
8814
8795
=head2 TableExists($table)
8815
=head2 TableExists($table)
8796
- 

Return to bug 13007