Hi,

On Tue, Aug 13, 2013 at 10:38 AM, Michael Hafen <michael.hafen@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@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