[Koha-devel] How to clean transaction table?
Galen Charlton
gmc at esilibrary.com
Tue Aug 13 19:58:32 CEST 2013
Hi,
On Tue, Aug 13, 2013 at 10:38 AM, Michael Hafen
<michael.hafen at washk12.org>wrote:
> with that said, the sequence database queries would be something like:
>
> Truncate Table branchtransfers;
> Truncate Table issues;
> Truncate Table old_issues;
> Truncate Table reserves;
> Truncate Table old_reserves;
> Truncate Table tmp_holdsqueue;
> Truncate Table accountoffsets;
> Truncate Table accountlines;
> Truncate Table statistics;
> Truncate Table action_logs;
>
To add on one more command:
UPDATE items SET onloan = NULL;
This avoids a problem where an item would appear in certain places to still
be on loan.
Regards,
Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email: gmc at esilibrary.com
direct: +1 770-709-5581
cell: +1 404-984-4366
skype: gmcharlt
web: http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130813/5c72e52f/attachment.html>
More information about the Koha-devel
mailing list