|
Lines 2203-2208
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
| 2203 |
PRIMARY KEY (`suggestionid`), |
2203 |
PRIMARY KEY (`suggestionid`), |
| 2204 |
KEY `suggestedby` (`suggestedby`), |
2204 |
KEY `suggestedby` (`suggestedby`), |
| 2205 |
KEY `managedby` (`managedby`), |
2205 |
KEY `managedby` (`managedby`), |
|
|
2206 |
KEY `status` (`STATUS`), |
| 2207 |
KEY `biblionumber` (`biblionumber`), |
| 2208 |
KEY `branchcode` (`branchcode`), |
| 2206 |
CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE |
2209 |
CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE |
| 2207 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2210 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2208 |
|
2211 |
|
| 2209 |
- |
|
|