Lines 4468-4473
DROP TABLE IF EXISTS `circulation_rules`;
Link Here
|
4468 |
CREATE TABLE `circulation_rules` ( |
4468 |
CREATE TABLE `circulation_rules` ( |
4469 |
`id` int(11) NOT NULL auto_increment, |
4469 |
`id` int(11) NOT NULL auto_increment, |
4470 |
`branchcode` varchar(10) NULL default NULL, |
4470 |
`branchcode` varchar(10) NULL default NULL, |
|
|
4471 |
`onsite_checkout` int(1) NULL default NULL, |
4471 |
`categorycode` varchar(10) NULL default NULL, |
4472 |
`categorycode` varchar(10) NULL default NULL, |
4472 |
`itemtype` varchar(10) NULL default NULL, |
4473 |
`itemtype` varchar(10) NULL default NULL, |
4473 |
`rule_name` varchar(32) NOT NULL, |
4474 |
`rule_name` varchar(32) NOT NULL, |
Lines 4477-4483
CREATE TABLE `circulation_rules` (
Link Here
|
4477 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4478 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4478 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4479 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4479 |
KEY `rule_name` (`rule_name`), |
4480 |
KEY `rule_name` (`rule_name`), |
4480 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
4481 |
UNIQUE (`branchcode`,`onsite_checkout`,`categorycode`,`itemtype`,`rule_name`) |
4481 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4482 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4482 |
|
4483 |
|
4483 |
-- |
4484 |
-- |
4484 |
- |
|
|