Bugzilla – Attachment 194297 Details for
Bug 14962
Temp Shelving Location / On Display Module
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14962: On Display changes for SQL
f2a6d95.patch (text/plain), 5.67 KB, created by
Martin Renvoize (ashimema)
on 2026-03-02 10:23:32 UTC
(
hide
)
Description:
Bug 14962: On Display changes for SQL
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2026-03-02 10:23:32 UTC
Size:
5.67 KB
patch
obsolete
>From f2a6d954b743dc8e41b23aa77b6cf1c6897af204 Mon Sep 17 00:00:00 2001 >From: Jake Deery <jake.deery@openfifth.co.uk> >Date: Mon, 1 Dec 2025 14:50:33 +0000 >Subject: [PATCH] Bug 14962: On Display changes for SQL > >This patch contains the required schema changes that will enable On >Display to function as a new module. >Please see the test files commit for instructions on how to test this >bundle of patches. > >Sponsored-by: ByWater Solutions >Signed-of-by: Martin Renvoize <martin.renvoize@openfifth.co.uk> >--- > installer/data/mysql/kohastructure.sql | 58 ++++++++++++++++++++++++++ > 1 file changed, 58 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a29c7e49292..5610d7fd865 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2886,6 +2886,63 @@ CREATE TABLE `discharges` ( > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >+-- >+-- Table structure for table `displays` >+-- >+ >+DROP TABLE IF EXISTS `displays`; >+/*!40101 SET @saved_cs_client = @@character_set_client */; >+/*!40101 SET character_set_client = utf8mb4 */; >+CREATE TABLE `displays` ( >+ `display_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique id for the display', >+ `display_name` varchar(255) DEFAULT NULL COMMENT 'the name of the display', >+ `start_date` date DEFAULT NULL COMMENT 'the start date of the display (optional)', >+ `end_date` date DEFAULT NULL COMMENT 'the end date of the display (optional)', >+ `enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'determines whether the display is active', >+ `display_location` varchar(80) DEFAULT NULL COMMENT 'the shelving location for the display (optional)', >+ `display_code` varchar(80) DEFAULT NULL COMMENT 'the collection code for the display (optional)', >+ `display_branch` varchar(10) DEFAULT NULL COMMENT 'a new home branch for the item to have while on display (optional)', >+ `display_holding_branch` varchar(10) DEFAULT NULL COMMENT 'a new holding branch for the item to have while on display (optional)', >+ `display_itype` varchar(10) DEFAULT NULL COMMENT 'a new itype for the item to have while on display (optional)', >+ `staff_note` mediumtext DEFAULT NULL COMMENT 'staff note for the display', >+ `public_note` mediumtext DEFAULT NULL COMMENT 'public note for the display', >+ `display_days` int(11) DEFAULT NULL COMMENT 'default number of days items will remain on display', >+ `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', >+ PRIMARY KEY (`display_id`), >+ KEY `display_branch` (`display_branch`), >+ KEY `display_holding_branch` (`display_holding_branch`), >+ KEY `display_itype` (`display_itype`), >+ CONSTRAINT `displays_ibfk_1` FOREIGN KEY (`display_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `displays_ibfk_2` FOREIGN KEY (`display_holding_branch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `displays_ibfk_3` FOREIGN KEY (`display_itype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+/*!40101 SET character_set_client = @saved_cs_client */; >+ >+-- >+-- Table structure for table `display_items` >+-- >+ >+DROP TABLE IF EXISTS `display_items`; >+/*!40101 SET @saved_cs_client = @@character_set_client */; >+/*!40101 SET character_set_client = utf8mb4 */; >+CREATE TABLE `display_items` ( >+ `display_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', >+ `display_id` int(11) NOT NULL COMMENT 'foreign key to link to displays.display_id', >+ `itemnumber` int(11) DEFAULT NULL COMMENT 'items.itemnumber for the item on display', >+ `biblionumber` int(11) DEFAULT NULL COMMENT 'biblio.biblionumber for the bibliographic record on display', >+ `date_added` date DEFAULT NULL COMMENT 'the date the item was added to the display', >+ `date_remove` date DEFAULT NULL COMMENT 'the date the item should be removed from the display', >+ PRIMARY KEY (`display_item_id`), >+ UNIQUE KEY `display_items_uniq` (`display_id`,`itemnumber`), >+ KEY `display_id` (`display_id`), >+ KEY `itemnumber` (`itemnumber`), >+ KEY `biblionumber` (`biblionumber`), >+ CONSTRAINT `display_items_ibfk_1` FOREIGN KEY (`display_id`) REFERENCES `displays` (`display_id`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `display_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `display_items_ibfk_3` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+/*!40101 SET character_set_client = @saved_cs_client */; >+ > -- > -- Table structure for table `edifact_ean` > -- >@@ -4496,6 +4553,7 @@ CREATE TABLE `library_groups` ( > `ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', > `ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', > `ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', >+ `ft_display_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries that can share display items', > `created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', > `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', > PRIMARY KEY (`id`), >-- >2.53.0 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14962
:
190216
|
190217
|
190218
|
190219
|
190220
|
190221
|
190222
|
190223
|
190224
|
190225
|
190226
|
190227
|
190228
|
190229
|
190230
|
190231
|
190232
|
190571
|
190572
|
193719
|
193720
|
193721
|
193722
|
193723
|
193724
|
193725
|
193726
|
193727
|
193728
|
193729
|
193730
|
193731
|
193732
|
193733
|
193734
|
193735
|
193736
|
193737
|
193738
|
193739
|
193740
|
193741
|
193742
|
193743
|
193744
|
193745
|
193746
|
193747
|
193748
|
193749
|
193750
|
193751
|
193752
|
193753
|
193754
|
193755
|
194285
|
194286
|
194287
|
194288
|
194289
|
194290
|
194291
|
194292
|
194293
|
194294
|
194295
|
194296
| 194297 |
194298
|
194299
|
194300
|
194301
|
194302
|
194303
|
194304
|
194305
|
194306
|
194307
|
194308
|
194309
|
194310
|
194311
|
194312
|
194313
|
194314
|
194315
|
194316
|
194317
|
194318
|
194320
|
194321
|
194322