[Koha-bugs] [Bug 12029] Patrons should be able to delete their patron messages

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12029

--- Comment #22 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Comment on attachment 130516
  --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=130516
Bug 12029: Patrons should be able to delete their patron messages

Review of attachment 130516:
 --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=12029&attachment=130516)
-----------------------------------------------------------------

::: installer/data/mysql/kohastructure.sql
@@ +3739,4 @@
>    `message` mediumtext COLLATE utf8mb4_unicode_ci 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 'date and time the patron dismissed the message',

Final additional note from my own review:

Shouldn't this be a DATETIME rather than a TIMESTAMP field?

-- 
You are receiving this mail because:
You are watching all bug changes.