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 |
- |
|
|