|
Lines 369-374
CREATE TABLE collections_tracking (
Link Here
|
| 369 |
PRIMARY KEY (collections_tracking_id) |
369 |
PRIMARY KEY (collections_tracking_id) |
| 370 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
370 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 371 |
|
371 |
|
|
|
372 |
ALTER TABLE `collections_tracking` |
| 373 |
ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 374 |
|
| 375 |
ALTER TABLE `collections_tracking` |
| 376 |
ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 377 |
|
| 372 |
-- |
378 |
-- |
| 373 |
-- Table structure for table `branch_borrower_circ_rules` |
379 |
-- Table structure for table `branch_borrower_circ_rules` |
| 374 |
-- |
380 |
-- |
| 375 |
- |
|
|