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 davidu
Full name David A. Ulevitch
Date 2004-03-31 07:45:02 PST
Message On Mar 31, 2004, at 9:43 AM, David A. Ulevitch wrote:
> <foreign-key foreignTable="accounts" onDelete="cascade">
> <reference local="aid" foreign="id"/>
> </foreign-key>
> <foreign-key foreignTable="soa" onDelete="cascade">
> <reference local="zone" foreign="id"/>
> </foreign-key>
>
> 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.

-davidu


--------------------​--------------------​--------------------​---------
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 | 4 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: