Attachment 148607 Details for Bug 12029 – Bug 12029: Adding messages.patron_read_date column

[patch] Bug 12029: Adding messages.patron_read_date column

Bug-12029-Adding-messagespatronreaddate-column.patch (text/plain), 2.30 KB, created by Jonathan Druart on 2023-03-23 13:01:53 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2023-03-23 13:01:53 UTC

Size: 2.30 KB

patch

obsolete

>From 1fe40ea0c12a0a486366a01ffee270eae798a658 Mon Sep 17 00:00:00 2001
>From: Aleisha Amohia <aleishaamohia@hotmail.com>
>Date: Wed, 15 Feb 2023 18:10:29 +1300
>Subject: [PATCH] Bug 12029: Adding messages.patron_read_date column
>
>Signed-off-by: Christopher Brannon <cbrannon@cdalibrary.org>
>
>JD Amended patch: Fix QA failure "File must have the exec flag"
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> ...9_-_add_messages.patron_read_date_column.pl | 18 ++++++++++++++++++
> installer/data/mysql/kohastructure.sql         |  1 +
> 2 files changed, 19 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_12029_-_add_messages.patron_read_date_column.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_12029_-_add_messages.patron_read_date_column.pl b/installer/data/mysql/atomicupdate/bug_12029_-_add_messages.patron_read_date_column.pl
>new file mode 100755
>index 00000000000..efbe1fccf0c
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_12029_-_add_messages.patron_read_date_column.pl
>@@ -0,0 +1,18 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "12029",
>+    description => "Enable users to dismiss their patron messages",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+
>+        if( !column_exists( 'messages', 'patron_read_date' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE messages ADD COLUMN `patron_read_date` timestamp NULL DEFAULT NULL AFTER `manager_id`
>+          });
>+
>+          say $out "Added column 'messages.patron_read_date'";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index a3faa37d794..8bbca95c069 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4293,6 +4293,7 @@ CREATE TABLE `messages` (
>   `message` mediumtext NOT NULL COMMENT 'the text of the message',
>   `message_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the message was written',
>   `manager_id` int(11) DEFAULT NULL COMMENT 'creator of message',
>+  `patron_read_date` timestamp NULL DEFAULT NULL COMMENT 'the date and time the patron dismissed the message',
>   PRIMARY KEY (`message_id`),
>   KEY `messages_ibfk_1` (`manager_id`),
>   KEY `messages_borrowernumber` (`borrowernumber`),
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 12029: 130514 | 130515 | 130516 | 132918 | 132949 | 137434 | 137435 | 137518 | 137519 | 137520 | 137521 | 137522 | 137523 | 137646 | 137647 | 137648 | 146706 | 146707 | 146708 | 146709 | 147521 | 147522 | 147523 | 147524 | 147525 | 148607 | 148608 | 148609 | 148610 | 148611