[Koha] [Koha-devel] How to clean transaction table?

[Galen Charlton]

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