Lines 623-629
CREATE TABLE `course_reserves` (
Link Here
|
623 |
-- Constraints for table `course_reserves` |
623 |
-- Constraints for table `course_reserves` |
624 |
-- |
624 |
-- |
625 |
ALTER TABLE `course_reserves` |
625 |
ALTER TABLE `course_reserves` |
626 |
ADD CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`); |
626 |
ADD CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), |
|
|
627 |
ADD CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE; |
628 |
|
627 |
|
629 |
|
628 |
-- |
630 |
-- |
629 |
-- Table structure for table `branch_borrower_circ_rules` |
631 |
-- Table structure for table `branch_borrower_circ_rules` |
630 |
- |
|
|