http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14246
M. Tompsett <mtomp...@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #43714|0 |1 is obsolete| | --- Comment #27 from M. Tompsett <mtomp...@hotmail.com> --- Created attachment 43719 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=43719&action=edit Bug 14246: Add borrowernumber to koha_news This patch adds a new column to koha_news that links a borrowernumber to each item. This allows Koha to display the author for each entry which makes it suitable as a simple CMS. Changes (from rejected patch): * Added missing kohastructure.sql changes. * Turned the atomic update file into a SQL file and changed name in accordance with wiki guidelines. * Changed SQL syntax and naming to be consistent with existing code. * Attached test plan to commit message. Test plan: * You need at least one news item, log in and add one from 'Administration' -> 'Tools' -> 'News'. * Apply the patch. * Apply database upgrade (directly or indirectly). * Go back to Staff interface and post a new news item. * Use the mysql command line client to connect to the Koha installation's database: mysql -u kohaadmin -p -D koha (change username and database to values appropiate for your system). * Execute the following query: SELECT title, borrowernumber FROM opac_news; * Inspect the results, the 'borrowernumber' column should be NULL for all news items created before the patch was applied, and non-NULL for the new item created AFTER the patch was applied. Optional: Remove database changes via: ALTER TABLE opac_news DROP FOREIGN KEY borrowernumber_fk; ALTER TABLE opac_news DROP COLUMN borrowernumber; Sponsored-By: Halland County Library Signed-off-by: Nick Clemens <n...@quecheelibrary.org> Signed-off-by: Mark Tompsett <mtomp...@hotmail.com> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://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/