On 20.01.2010, at 11:02, Marco Vannini wrote:
sorry, there right db schema is in http://doc.otrs.org/itsm/1.3/en/html/c427.html
On Wed, Jan 20, 2010 at 11:00 AM, Marco Vannini
<marco.vannini@gmail.com> wrote:
It is not so easy I think, depending if you have defined linkage between items too...
BTW, deleting all records in configitem* tables should be enough but then, as told before, there should be still records in links* tables.
(don't forget to do a backup before any activity ... )
i do not know if this would fit your needs, but if you delete the package "ITSMConfigurationManagement" all the tables for that package are deleted. After a nre installation of that single package you will have a clean CI DB.
Be careful because all you own class definitions are deleted as well, so you could copy and paste them from "ConfigItem" or just backup the related DB table and copy the content back after new installation of the CM package.
Nils Leideck
--
Nils Leideck
Senior Consultant