|
Lines 5728-5733
CREATE TABLE `course_instructors` (
Link Here
|
| 5728 |
"); |
5728 |
"); |
| 5729 |
|
5729 |
|
| 5730 |
$dbh->do(" |
5730 |
$dbh->do(" |
|
|
5731 |
ALTER TABLE `course_instructors` |
| 5732 |
ADD CONSTRAINT `course_instructors_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), |
| 5733 |
ADD CONSTRAINT `course_instructors_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 5734 |
"); |
| 5735 |
|
| 5736 |
$dbh->do(" |
| 5731 |
CREATE TABLE `course_items` ( |
5737 |
CREATE TABLE `course_items` ( |
| 5732 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT, |
5738 |
`ci_id` int(11) NOT NULL AUTO_INCREMENT, |
| 5733 |
`itemnumber` int(11) NOT NULL, |
5739 |
`itemnumber` int(11) NOT NULL, |
|
Lines 5738-5748
CREATE TABLE `course_items` (
Link Here
|
| 5738 |
`enabled` enum('yes','no') NOT NULL DEFAULT 'no', |
5744 |
`enabled` enum('yes','no') NOT NULL DEFAULT 'no', |
| 5739 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
5745 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 5740 |
PRIMARY KEY (`ci_id`), |
5746 |
PRIMARY KEY (`ci_id`), |
| 5741 |
UNIQUE KEY `itemnumber` (`itemnumber`) |
5747 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
|
|
5748 |
KEY `holdingbranch` (`holdingbranch`) |
| 5742 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
5749 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 5743 |
"); |
5750 |
"); |
| 5744 |
|
5751 |
|
| 5745 |
$dbh->do(" |
5752 |
$dbh->do(" |
|
|
5753 |
ALTER TABLE `course_items` |
| 5754 |
ADD CONSTRAINT `course_items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 5755 |
ADD CONSTRAINT `course_items_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 5756 |
"); |
| 5757 |
|
| 5758 |
$dbh->do(" |
| 5746 |
CREATE TABLE `course_reserves` ( |
5759 |
CREATE TABLE `course_reserves` ( |
| 5747 |
`cr_id` int(11) NOT NULL AUTO_INCREMENT, |
5760 |
`cr_id` int(11) NOT NULL AUTO_INCREMENT, |
| 5748 |
`course_id` int(11) NOT NULL, |
5761 |
`course_id` int(11) NOT NULL, |
|
Lines 5751-5762
CREATE TABLE `course_reserves` (
Link Here
|
| 5751 |
`public_note` mediumtext, |
5764 |
`public_note` mediumtext, |
| 5752 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
5765 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 5753 |
PRIMARY KEY (`cr_id`), |
5766 |
PRIMARY KEY (`cr_id`), |
| 5754 |
UNIQUE KEY `psuedo_key` (`course_id`,`ci_id`), |
5767 |
UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), |
| 5755 |
KEY `course_id` (`course_id`) |
5768 |
KEY `course_id` (`course_id`) |
| 5756 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
5769 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 5757 |
"); |
5770 |
"); |
| 5758 |
|
5771 |
|
| 5759 |
$dbh->do(" |
5772 |
$dbh->do(" |
|
|
5773 |
ALTER TABLE `course_reserves` |
| 5774 |
ADD CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`); |
| 5775 |
"); |
| 5776 |
|
| 5777 |
$dbh->do(" |
| 5760 |
INSERT INTO permissions (module_bit, code, description) VALUES |
5778 |
INSERT INTO permissions (module_bit, code, description) VALUES |
| 5761 |
(18, 'manage_courses', 'Add, edit and delete courses'), |
5779 |
(18, 'manage_courses', 'Add, edit and delete courses'), |
| 5762 |
(18, 'add_reserves', 'Add course reserves'), |
5780 |
(18, 'add_reserves', 'Add course reserves'), |
|
Lines 5764-5769
INSERT INTO permissions (module_bit, code, description) VALUES
Link Here
|
| 5764 |
; |
5782 |
; |
| 5765 |
"); |
5783 |
"); |
| 5766 |
|
5784 |
|
|
|
5785 |
|
| 5767 |
print "Upgrade to $DBversion done (Add Course Reserves ( system preference UseCourseReserves ))\n"; |
5786 |
print "Upgrade to $DBversion done (Add Course Reserves ( system preference UseCourseReserves ))\n"; |
| 5768 |
SetVersion($DBversion); |
5787 |
SetVersion($DBversion); |
| 5769 |
} |
5788 |
} |
| 5770 |
- |
|
|