[Koha-bugs] [Bug 6331] Obsolete marc column in deleteditems

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Dec 5 15:40:19 CET 2013


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

--- Comment #15 from Fridolin SOMERS <fridolyn.somers at biblibre.com> ---
Created attachment 23320
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23320&action=edit
Bug 6331 - Update timestamp when deleting items

When item is transfered from items table to deleted items, all fields must be
copies but "timestamp".
This value must be updated to know when item has been deleted.

Test plan:
- Look a an item timestamp :
mysql> select timestamp from items where itemnumber = 2690;
+---------------------+
| timestamp           |
+---------------------+
| 2011-09-09 15:30:21 |
+---------------------+
1 row in set (0.00 sec)
- Delete this item in cataloguing module
- Check it is not in items table anymore :
mysql> select timestamp from items where itemnumber = 2690;
Empty set (0.00 sec)
- Look in deleteditems table :
mysql> select timestamp from deleteditems where itemnumber = 2690;
+---------------------+
| timestamp           |
+---------------------+
| 2013-12-05 15:33:20 |
+---------------------+
1 row in set (0.00 sec)
=> timestamp as been set to actual date/time

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list