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