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 |
- |
|
|