|
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 949-969
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
| 949 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
921 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 950 |
|
922 |
|
| 951 |
-- |
923 |
-- |
| 952 |
-- Table structure for table `default_branch_item_rules` |
|
|
| 953 |
-- |
| 954 |
|
| 955 |
DROP TABLE IF EXISTS `default_branch_item_rules`; |
| 956 |
CREATE TABLE `default_branch_item_rules` ( |
| 957 |
`itemtype` varchar(10) NOT NULL, |
| 958 |
`holdallowed` tinyint(1) default NULL, |
| 959 |
hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode |
| 960 |
`returnbranch` varchar(15) default NULL, |
| 961 |
PRIMARY KEY (`itemtype`), |
| 962 |
CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 963 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 964 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 965 |
|
| 966 |
-- |
| 967 |
-- Table structure for table `branchtransfers` |
924 |
-- Table structure for table `branchtransfers` |
| 968 |
-- |
925 |
-- |
| 969 |
|
926 |
|
|
Lines 986-1010
CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
Link Here
|
| 986 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
943 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 987 |
|
944 |
|
| 988 |
-- |
945 |
-- |
| 989 |
-- Table structure for table `branch_item_rules` |
|
|
| 990 |
-- |
| 991 |
|
| 992 |
DROP TABLE IF EXISTS `branch_item_rules`; |
| 993 |
CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and fine rules under 'Holds policy by item type' |
| 994 |
`branchcode` varchar(10) NOT NULL, -- the branch this rule is for (branches.branchcode) |
| 995 |
`itemtype` varchar(10) NOT NULL, -- the item type this rule applies to (items.itype) |
| 996 |
`holdallowed` tinyint(1) default NULL, -- the number of holds allowed |
| 997 |
hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode |
| 998 |
`returnbranch` varchar(15) default NULL, -- the branch the item returns to (homebranch, holdingbranch, noreturn) |
| 999 |
PRIMARY KEY (`itemtype`,`branchcode`), |
| 1000 |
KEY `branch_item_rules_ibfk_2` (`branchcode`), |
| 1001 |
CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 1002 |
ON DELETE CASCADE ON UPDATE CASCADE, |
| 1003 |
CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) |
| 1004 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 1005 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1006 |
|
| 1007 |
-- |
| 1008 |
-- Table structure for table `creator_images` |
946 |
-- Table structure for table `creator_images` |
| 1009 |
-- |
947 |
-- |
| 1010 |
|
948 |
|
| 1011 |
- |
|
|