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 -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson _______________________________________________ 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
