Login | Register
My pages Projects Community openCollabNet

Discussions > users > Re: [propel] Using Creole to generate xml schema from db.

propel
Discussion topic

Back to topic list

Re: [propel] Using Creole to generate xml schema from db.

Reply

Author hlellelid
Full name Hans Lellelid
Date 2004-03-31 07:52:15 PST
Message Hi -

>> This does nothing when generating the mysql code when in fact it could
>> generate:
>> CONSTRAINT `fk_zone` FOREIGN KEY (`zone`) REFERENCES `soa` (`id`) ON
>> DELETE CASCADE ON UPDATE CASCADE,
>> CONSTRAINT `fk_aid` FOREIGN KEY (`aid`) REFERENCES `accounts` (`id`)
>> ON DELETE CASCADE ON UPDATE CASCADE
>
> I'm sorry to reply to myself:
>
> It adds:
> FOREIGN KEY (aid) REFERENCES accounts (id),
> FOREIGN KEY (zone) REFERENCES soa (id),
>
> but does not honor the onDelete attribute.

Yes, that's correct. I didn't know that MySQL InnoDB tables supported the
onDelete. This is a function of me porting the template from Torque
(which didn't add this for MySQL). If we can add this w/o creating errors
for the MyISAM tables (i.e. if they just ignore the extra stuff), then we
definitely should.

Currently, ON DELETE CASCADE is emulated for MySQL.

Hans

--------------------​--------------------​--------------------​---------
To unsubscribe, e-mail: users-unsubscribe@pr​opel.tigris.org
For additional commands, e-mail: users-help at propel dot tigris dot org

« Previous message in topic | 5 of 6 | Next message in topic »

Messages

Show all messages in topic

[propel] Using Creole to generate xml schema from db. davidu David A. Ulevitch 2004-03-31 06:02:42 PST
     Re: [propel] Using Creole to generate xml schema from db. hlellelid Hans Lellelid 2004-03-31 07:16:05 PST
         Re: [propel] Using Creole to generate xml schema from db. davidu David A. Ulevitch 2004-03-31 07:43:09 PST
             Re: [propel] Using Creole to generate xml schema from db. davidu David A. Ulevitch 2004-03-31 07:45:02 PST
                 Re: [propel] Using Creole to generate xml schema from db. hlellelid Hans Lellelid 2004-03-31 07:52:15 PST
             Re: [propel] Using Creole to generate xml schema from db. hlellelid Hans Lellelid 2004-03-31 07:50:26 PST
Messages per page: