[Koha-bugs] [Bug 14246] New: Add borrowernumber to koha_news

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

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 at gmail.com
          Reporter: xarragon at gmail.com
        QA Contact: testopia at 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.