|
On Tue Mar 25 07:19:02 2003, Martin Edenhofer wrote: >Hi,
>On Mon, Mar 24, 2003 at 02:23:01PM -0500, Charles R. Rusty Thompson wrote: >> In time I could do this myself but I was wondering if anyone had written a >> cleanup script for the OTRS database. >> >> After the mail, users, etc are set up we have a testing cycle. After that >> testing it would be nice to be able to clear all the cases from the system, >> leaving the core user and setup data intact. If anyone has a scrub script or >> could give some guidelines on what can/should be deleted by force it would >> be great.
>delete from article; >delete from article_attachment; >delete from article_plain; >delete from ticket_history; >delete from ticket;
>Removes all existing ticket.
>> CT
> Martin
You should „delete from time_accounting;“ as well. Not having done this caused some „ghost-tickets“ which broke up the correct accounting of time. I’ll take a look at the other tables later today, to see if there are more „ghost-tickets“ left.
Marina __________ Netzlink Informationstechnik GmbH Heinrich-B�ssing-Ring 41 D-38102 Braunschweig Telefon: 0531-7073430 Telefax: 0531-7073459
|
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting f�r Ihr OTRS System? => http://www.otrs.de/
