View | Details | Raw Unified | Return to bug 14962
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +58 lines)
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
- 

Return to bug 14962