Re: alter database SOPM

Awesome, thanks for the info - I am going to write a tickethook to take care of this!  Hopefully that does the trick :)

Best Regards,

Mike McMahon

From: [email protected] [mailto:[email protected]] On Behalf Of Martin Gruner
Sent: Tuesday, June 25, 2013 12:13 AM
To: Development community of OTRS
Subject: Re: [dev] alter database SOPM

Hi Mike,

Am 25.06.13 03:37, schrieb McMahon, Mike (HQP):

All,

Is there a way to alter a database via the SOPM to change a FK relationship?
In general, yes. You can use ForeignKeyCreate and -Drop tags for that.


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).
I don't think this will be possible. OTRS does not support specification of CASCADE at this point.


Additionally I need to update the TableCreate statement to include a proper FK relationship.  How do I do this??
Just in the same way as the tables are created in OTRS itself. See otrs-schema.xml.

To achieve what you need you probably have to patch Ticket::TicketDelete() to delete all referencing entities.

Regards, mg


--

Martin Gruner

Senior Developer R&D



OTRS AG

Europaring 4

94315 Straubing



T: +49 (0)6172 681988 0

F: +49 (0)9421 56818 18

I:  www.otrs.com/<http://www.otrs.com/>



Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065

Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn, Sabine Riedel



Mehr als ein Help Desk-System - Prozess- und Kundenmanagement mit OTRS 3.2 - Jetzt Frühbucherrabatt sichern:

http://www.otrs.com/de/loesungen/promotion/otrs-help-desk-32-special/

_______________________________________________
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