[Koha-bugs] [Bug 5423] Deleted Patrons are no longer saved in table deletedborrowers
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Dec 14 16:55:24 CET 2010
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5423
Nicole C. Engard <nengard at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |nengard at gmail.com
--- Comment #11 from Nicole C. Engard <nengard at gmail.com> 2010-12-14 15:55:22 UTC ---
I do have a privacy column in my deleted borrowers table (in HEAD) and I have
no errors in my log on deleting a patron.
Here's my table:
mysql> select * from deletedborrowers;
+----------------+----------------+---------+-----------+-------+------------+----------+--------------+------------+------------------+----------+-----------------+---------+---------+-------+----------------+--------+------+----------+----------+----------------+--------------+-----------+------------+--------+-----------+-----------+---------+---------+-------------+------------+--------------+--------------+------------+---------------+------+----------+-------------+------------------+--------------+-------------+---------------+--------------+-----------+----------+------+------------------+-------+----------------+----------+-------------+------------------+-------+---------------------+-------------------+--------------------+--------------------+--------------------+-------------------+-------------------+-----------------+----------------+---------+
| borrowernumber | cardnumber | surname | firstname | title | othernames |
initials | streetnumber | streettype | address | address2 | city
| zipcode | country | email | phone | mobile | fax | emailpro |
phonepro | B_streetnumber | B_streettype | B_address | B_address2 | B_city |
B_zipcode | B_country | B_email | B_phone | dateofbirth | branchcode |
categorycode | dateenrolled | dateexpiry | gonenoaddress | lost | debarred |
contactname | contactfirstname | contacttitle | guarantorid | borrowernotes |
relationship | ethnicity | ethnotes | sex | password | flags | userid
| opacnote | contactnote | sort1 | sort2 |
altcontactfirstname | altcontactsurname | altcontactaddress1 |
altcontactaddress2 | altcontactaddress3 | altcontactzipcode | altcontactcountry
| altcontactphone | smsalertnumber | privacy |
+----------------+----------------+---------+-----------+-------+------------+----------+--------------+------------+------------------+----------+-----------------+---------+---------+-------+----------------+--------+------+----------+----------+----------------+--------------+-----------+------------+--------+-----------+-----------+---------+---------+-------------+------------+--------------+--------------+------------+---------------+------+----------+-------------+------------------+--------------+-------------+---------------+--------------+-----------+----------+------+------------------+-------+----------------+----------+-------------+------------------+-------+---------------------+-------------------+--------------------+--------------------+--------------------+-------------------+-------------------+-----------------+----------------+---------+
| 37 | 23529000197047 | Charles | Lisa | | |
| NULL | NULL | 5129 Library Rd. | NULL |
Centerville, CA | 44262 | NULL | NULL | (212) 555-1212 | NULL | NULL |
NULL | NULL | NULL | NULL | | NULL |
| | NULL | | | 1982-10-14 | MPL |
K | 1988-11-14 | 2020-12-31 | 0 | 0 | 0 |
Alford | Jordan | NULL | 45 | |
father | NULL | NULL | M | 42b29d0771f3b7ef | NULL |
23529000197047 | | | 0.26352253767058 | Y |
| | | |
| | NULL | | NULL
| 1 |
1 row in set (0.00 sec)
--
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
More information about the Koha-bugs
mailing list