|
Lines 353-386
CREATE TABLE collections_tracking (
Link Here
|
| 353 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
353 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 354 |
|
354 |
|
| 355 |
-- |
355 |
-- |
| 356 |
-- Table structure for table `default_branch_circ_rules` |
|
|
| 357 |
-- |
| 358 |
|
| 359 |
DROP TABLE IF EXISTS `default_branch_circ_rules`; |
| 360 |
CREATE TABLE `default_branch_circ_rules` ( |
| 361 |
`branchcode` VARCHAR(10) NOT NULL, |
| 362 |
`holdallowed` tinyint(1) default NULL, |
| 363 |
hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode |
| 364 |
`returnbranch` varchar(15) default NULL, |
| 365 |
PRIMARY KEY (`branchcode`), |
| 366 |
CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) |
| 367 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 368 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 369 |
|
| 370 |
-- |
| 371 |
-- Table structure for table `default_circ_rules` |
| 372 |
-- |
| 373 |
|
| 374 |
DROP TABLE IF EXISTS `default_circ_rules`; |
| 375 |
CREATE TABLE `default_circ_rules` ( |
| 376 |
`singleton` enum('singleton') NOT NULL default 'singleton', |
| 377 |
`holdallowed` int(1) default NULL, |
| 378 |
hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode |
| 379 |
`returnbranch` varchar(15) default NULL, |
| 380 |
PRIMARY KEY (`singleton`) |
| 381 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 382 |
|
| 383 |
-- |
| 384 |
-- Table structure for table `cities` |
356 |
-- Table structure for table `cities` |
| 385 |
-- |
357 |
-- |
| 386 |
|
358 |
|
|
Lines 968-988
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
| 968 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
940 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 969 |
|
941 |
|
| 970 |
-- |
942 |
-- |
| 971 |
-- Table structure for table `default_branch_item_rules` |
|
|
| 972 |
-- |
| 973 |
|
| 974 |
DROP TABLE IF EXISTS `default_branch_item_rules`; |
| 975 |
CREATE TABLE `default_branch_item_rules` ( |
| 976 |
`itemtype` varchar(10) NOT NULL, |
| 977 |
`holdallowed` tinyint(1) default NULL, |
| 978 |
hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode |
| 979 |
`returnbranch` varchar(15) default NULL, |
| 980 |
PRIMARY KEY (`itemtype`), |
| 981 |
CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 982 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 983 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 984 |
|
| 985 |
-- |
| 986 |
-- Table structure for table `branchtransfers` |
943 |
-- Table structure for table `branchtransfers` |
| 987 |
-- |
944 |
-- |
| 988 |
|
945 |
|
|
Lines 1005-1029
CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
Link Here
|
| 1005 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
962 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1006 |
|
963 |
|
| 1007 |
-- |
964 |
-- |
| 1008 |
-- Table structure for table `branch_item_rules` |
|
|
| 1009 |
-- |
| 1010 |
|
| 1011 |
DROP TABLE IF EXISTS `branch_item_rules`; |
| 1012 |
CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and fine rules under 'Holds policy by item type' |
| 1013 |
`branchcode` varchar(10) NOT NULL, -- the branch this rule is for (branches.branchcode) |
| 1014 |
`itemtype` varchar(10) NOT NULL, -- the item type this rule applies to (items.itype) |
| 1015 |
`holdallowed` tinyint(1) default NULL, -- the number of holds allowed |
| 1016 |
hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode |
| 1017 |
`returnbranch` varchar(15) default NULL, -- the branch the item returns to (homebranch, holdingbranch, noreturn) |
| 1018 |
PRIMARY KEY (`itemtype`,`branchcode`), |
| 1019 |
KEY `branch_item_rules_ibfk_2` (`branchcode`), |
| 1020 |
CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 1021 |
ON DELETE CASCADE ON UPDATE CASCADE, |
| 1022 |
CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) |
| 1023 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 1024 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1025 |
|
| 1026 |
-- |
| 1027 |
-- Table structure for table `creator_images` |
965 |
-- Table structure for table `creator_images` |
| 1028 |
-- |
966 |
-- |
| 1029 |
|
967 |
|
| 1030 |
- |
|
|