|
Lines 2885-2890
CREATE TABLE `discharges` (
Link Here
|
| 2885 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2885 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2886 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2886 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2887 |
|
2887 |
|
|
|
2888 |
-- |
| 2889 |
-- Table structure for table `displays` |
| 2890 |
-- |
| 2891 |
|
| 2892 |
DROP TABLE IF EXISTS `displays`; |
| 2893 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 2894 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 2895 |
CREATE TABLE `displays` ( |
| 2896 |
`display_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the display', |
| 2897 |
`display_name` varchar(255) DEFAULT NULL COMMENT 'the name of the display', |
| 2898 |
`start_date` date DEFAULT NULL COMMENT 'the start date of the display (optional)', |
| 2899 |
`end_date` date DEFAULT NULL COMMENT 'the end date of the display (optional)', |
| 2900 |
`enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'determines whether the display is active', |
| 2901 |
`display_location` varchar(80) DEFAULT NULL COMMENT 'the shelving location for the display (optional)', |
| 2902 |
`display_code` varchar(80) DEFAULT NULL COMMENT 'the collection code for the display (optional)', |
| 2903 |
`display_branch` varchar(10) DEFAULT NULL COMMENT 'a new home branch for the item to have while on display (optional)', |
| 2904 |
`display_holding_branch` varchar(10) DEFAULT NULL COMMENT 'a new holding branch for the item to have while on display (optional)', |
| 2905 |
`display_itype` varchar(10) DEFAULT NULL COMMENT 'a new itype for the item to have while on display (optional)', |
| 2906 |
`staff_note` mediumtext DEFAULT NULL COMMENT 'staff note for the display', |
| 2907 |
`public_note` mediumtext DEFAULT NULL COMMENT 'public note for the display', |
| 2908 |
`display_days` int(11) DEFAULT NULL COMMENT 'default number of days items will remain on display', |
| 2909 |
`display_return_over` enum('yes - any library','yes - except at home library','no') NOT NULL DEFAULT 'no' COMMENT 'should the item be removed from the display when it is returned', |
| 2910 |
PRIMARY KEY (`display_id`), |
| 2911 |
KEY `display_branch` (`display_branch`), |
| 2912 |
KEY `display_holding_branch` (`display_holding_branch`), |
| 2913 |
KEY `display_itype` (`display_itype`), |
| 2914 |
CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2915 |
CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2916 |
CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2917 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2918 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2919 |
|
| 2920 |
-- |
| 2921 |
-- Table structure for table `display_items` |
| 2922 |
-- |
| 2923 |
|
| 2924 |
DROP TABLE IF EXISTS `display_items`; |
| 2925 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 2926 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 2927 |
CREATE TABLE `display_items` ( |
| 2928 |
`display_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
| 2929 |
`display_id` int(11) NOT NULL COMMENT 'foreign key to link to displays.display_id', |
| 2930 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'items.itemnumber for the item on display', |
| 2931 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'biblio.biblionumber for the bibliographic record on display', |
| 2932 |
`date_added` date DEFAULT NULL COMMENT 'the date the item was added to the display', |
| 2933 |
`date_remove` date DEFAULT NULL COMMENT 'the date the item should be removed from the display', |
| 2934 |
PRIMARY KEY (`display_item_id`), |
| 2935 |
UNIQUE KEY `display_items_uniq` (`display_id`,`itemnumber`), |
| 2936 |
KEY `display_id` (`display_id`), |
| 2937 |
KEY `itemnumber` (`itemnumber`), |
| 2938 |
KEY `biblionumber` (`biblionumber`), |
| 2939 |
CONSTRAINT `display_items_ibfk_1` FOREIGN KEY (`display_id`) REFERENCES `displays` (`display_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2940 |
CONSTRAINT `display_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2941 |
CONSTRAINT `display_items_ibfk_3` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2942 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2943 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2944 |
|
| 2888 |
-- |
2945 |
-- |
| 2889 |
-- Table structure for table `edifact_ean` |
2946 |
-- Table structure for table `edifact_ean` |
| 2890 |
-- |
2947 |
-- |
|
Lines 4479-4484
CREATE TABLE `library_groups` (
Link Here
|
| 4479 |
`ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', |
4536 |
`ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', |
| 4480 |
`ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', |
4537 |
`ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', |
| 4481 |
`ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', |
4538 |
`ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', |
|
|
4539 |
`ft_display_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries that can share display items', |
| 4482 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', |
4540 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', |
| 4483 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', |
4541 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', |
| 4484 |
PRIMARY KEY (`id`), |
4542 |
PRIMARY KEY (`id`), |
| 4485 |
- |
|
|