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

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14246

--- Comment #5 from Martin Persson <xarragon at gmail.com> ---
Test plan:

* Check out clean master, reference sha-1 for this was:
f52084df0e395fdf89d80ca2fd77844273a8cf7c
* You need at least one news item, log in and add one from 'Administration' ->
'Tools' -> 'News'.
* Create a branch for the testing: git checkout -b test_news_author
* Apply the patch.
* Execute the database update:
  $ perl installer/data/mysql/atomicupdate/add_news_author.pl
* 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.

To remove all the changes (there are dependant patches that you can test before
you do this!):

* Execute the supplied SQL script: 
  $ mysql -u kohaadmin -p -D koha < remove_news_author.sql
* Drop the testing branch:
  $ git branch -d test_news_author

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