Re: [Wonder-disc] migrations addForeignKey

[Lachlan D. <lac...@gm...>]

On 26/08/2008, at 9:52 PM, David Avendasora wrote:

> On Aug 26, 2008, at 7:30 AM, Lachlan Deck wrote:
>
>> On 26/08/2008, at 9:15 PM, David Avendasora wrote:
>>
>>> That or don't worry about FK constraints and assume WO will keep  
>>> your DB in order.
>>
>> Nah :-) Helps with indexes too... and for better or worse mysql is  
>> going to be a reality for our deployments. So I'll need support for  
>> it to be up to snuff (and I imagine others will too).
>
> Yeah, I hear you. I just wish I were a more skilled java coder as  
> I'm just not really comprehending the changes I need to make to the  
> MicrosoftPlugin to get it working with Migrations. I think others  
> will find it useful as well. Migrations are so cool that we need to  
> get it working consistently between all DBs. It would be nice to  
> make migrations as universal as WO's DB integration.
>
> Right now I'm on a self-imposed "cooling off period". Tomorrow when  
> I let myself look at the MicrosoftPlugin again what I need to do  
> will probably be so obvious.

:-)

It'll be useful to port Chuck's stuff for dealing with ordering  
operations for sql server to mysql as InnoDB also doesn't support  
deferred constraints :-/

with regards,
--

Lachlan Deck