Lines 4219-4227
CREATE TABLE `circulation_rules` (
Link Here
|
4219 |
`rule_name` varchar(32) NOT NULL, |
4219 |
`rule_name` varchar(32) NOT NULL, |
4220 |
`rule_value` varchar(32) NOT NULL, |
4220 |
`rule_value` varchar(32) NOT NULL, |
4221 |
PRIMARY KEY (`id`), |
4221 |
PRIMARY KEY (`id`), |
4222 |
KEY `branchcode` (`branchcode`), |
4222 |
CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4223 |
KEY `categorycode` (`categorycode`), |
4223 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4224 |
KEY `itemtype` (`itemtype`), |
4224 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4225 |
KEY `rule_name` (`rule_name`), |
4225 |
KEY `rule_name` (`rule_name`), |
4226 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
4226 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
4227 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4227 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4228 |
- |
|
|