[Koha-bugs] [Bug 7671] add a real primary key "accountlinesid" in accountlines
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Aug 6 10:22:40 CEST 2012
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7671
Chris Cormack <chris at bigballofwax.co.nz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Needs Signoff |Signed Off
--- Comment #18 from Chris Cormack <chris at bigballofwax.co.nz> ---
Before
+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
| borrowernumber | accountno | itemnumber | date | amount | description
| dispute | accounttype | amountoutstanding | lastincrement | timestamp
| notify_id | notify_level | note | manager_id |
+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
| 1 | 1 | NULL | 2012-08-06 | 2.000000 | NULL
| NULL | Pay | NULL | NULL | 2012-08-06
20:15:58 | 0 | 0 | NULL | NULL |
+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
After patch
+----------------+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
| accountlinesid | borrowernumber | accountno | itemnumber | date |
amount | description | dispute | accounttype | amountoutstanding |
lastincrement | timestamp | notify_id | notify_level | note |
manager_id |
+----------------+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
| 1 | 1 | 1 | NULL | 2012-08-06 |
2.000000 | NULL | NULL | Pay | NULL |
NULL | 2012-08-06 20:15:58 | 0 | 0 | NULL | NULL |
+----------------+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
I then tested creating manual invoices, credits, reversing payments, paying,
and writing off.
The only thing I didnt test was overdue charges being added correctly. But as 2
others have already signed off on this. Marking signed off
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list