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