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