alter database SOPM

All,

Is there a way to alter a database via the SOPM to change a FK relationship?

I found that I was unable to delete tickets in the system (we have a queue for deleting junky/spam tickets) when one of our custom integrations already had a db entry for it.

Here is the setup

Cost_estimate => FK relationship on ticket_id

So when I try to delete a ticket in the system, the system complains that it's violating the FK relationship on cost_estimate.

I need to update the SOPM to alter the key relationship so that deletes are okay (and will cascade/delete entries from the cost_estimates database).

Additionally I need to update the TableCreate statement to include a proper FK relationship.  How do I do this??

Best Regards,
Mike

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev