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

--- Comment #22 from Martin Renvoize <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to