http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14246 Bug ID: 14246 Summary: Add borrowernumber to koha_news Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt@gmail.com Reporter: xarragon@gmail.com QA Contact: testopia@bugs.koha-community.org News items in Koha's OPAC and Staff client are anonymous. This is the first in a set of patches to add authorship tracking to the news items, with optional display preferences maintaining the current functionality. This first patch changes the database; it adds a column called 'borrowernumber' to the 'koha_news' table, adding a foreign key relationship to the 'borrowers' table. This is how tracking authorship is done. A LEFT JOIN statement is then used to get the title, firstname and surname columns available in the news data set. That is a separate patch. -- You are receiving this mail because: You are watching all bug changes.