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