Lines 4430-4435
DROP TABLE IF EXISTS `circulation_rules`;
Link Here
|
4430 |
CREATE TABLE `circulation_rules` ( |
4430 |
CREATE TABLE `circulation_rules` ( |
4431 |
`id` int(11) NOT NULL auto_increment, |
4431 |
`id` int(11) NOT NULL auto_increment, |
4432 |
`branchcode` varchar(10) NULL default NULL, |
4432 |
`branchcode` varchar(10) NULL default NULL, |
|
|
4433 |
`onsite_checkout` int(1) NULL default NULL, |
4433 |
`categorycode` varchar(10) NULL default NULL, |
4434 |
`categorycode` varchar(10) NULL default NULL, |
4434 |
`itemtype` varchar(10) NULL default NULL, |
4435 |
`itemtype` varchar(10) NULL default NULL, |
4435 |
`rule_name` varchar(32) NOT NULL, |
4436 |
`rule_name` varchar(32) NOT NULL, |
Lines 4439-4445
CREATE TABLE `circulation_rules` (
Link Here
|
4439 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4440 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4440 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4441 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4441 |
KEY `rule_name` (`rule_name`), |
4442 |
KEY `rule_name` (`rule_name`), |
4442 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
4443 |
UNIQUE (`branchcode`,`onsite_checkout`,`categorycode`,`itemtype`,`rule_name`) |
4443 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4444 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4444 |
|
4445 |
|
4445 |
-- |
4446 |
-- |
4446 |
- |
|
|