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