Lines 4415-4420
CREATE TABLE `circulation_rules` (
Link Here
|
4415 |
`branchcode` varchar(10) NULL default NULL, |
4415 |
`branchcode` varchar(10) NULL default NULL, |
4416 |
`categorycode` varchar(10) NULL default NULL, |
4416 |
`categorycode` varchar(10) NULL default NULL, |
4417 |
`itemtype` varchar(10) NULL default NULL, |
4417 |
`itemtype` varchar(10) NULL default NULL, |
|
|
4418 |
`checkout_type` ENUM('CHECKOUT', 'ONSITE') NULL default NULL, |
4418 |
`rule_name` varchar(32) NOT NULL, |
4419 |
`rule_name` varchar(32) NOT NULL, |
4419 |
`rule_value` varchar(32) NOT NULL, |
4420 |
`rule_value` varchar(32) NOT NULL, |
4420 |
PRIMARY KEY (`id`), |
4421 |
PRIMARY KEY (`id`), |
Lines 4422-4428
CREATE TABLE `circulation_rules` (
Link Here
|
4422 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4423 |
CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, |
4423 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4424 |
CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
4424 |
KEY `rule_name` (`rule_name`), |
4425 |
KEY `rule_name` (`rule_name`), |
4425 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
4426 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`checkout_type`,`rule_name`) |
4426 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4427 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4427 |
|
4428 |
|
4428 |
-- |
4429 |
-- |
4429 |
- |
|
|