Hi, On Tue, Aug 13, 2013 at 10:38 AM, Michael Hafen <[email protected]>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: [email protected] 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
_______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
