It seems Im doing something incorrectly in my schema definition.
Considering the following snippets:
inventory_home:
id:
subdivision_id: {type: integer, foreignKey: true, foreignTable:
subdivision, foreignReference: id, onDelete: setnull}
subdivision:
id:
With this set up i cannot delete a Subdivision unless i first delete all
InventoryHomes linked to it. What i want to happen is for the
InventoryHome to get a null SubdivisionId when its linked Subdivision is
deleted.
What am I doing wrong?
Furthermore, if i want The InventoryHome to be deleted when its linked
Subdivision is deleted i would assume it would look something like this:
inventory_home:
id:
subdivision_id: {type: integer, primaryKey: true, foreignKey: true,
foreignTable: subdivision, foreignReference: id, onDelete: cascade}
subdivision:
id:
That doesnt seem to work either. I've looked at both the Propel and
Symfony documentation as well as this:
http://symforc.com/post/2008/07/10/Foreign-keys-onDelete-for-dummies but
they are all somewhat sparse on the subject. Could someone point out
what I'm doing wrong?
FYI Symfony 1.1, Propel 1.2.
Thanks!
--
Ant Cunningham
Graphic Designer | Web Developer
Vector Based Design
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
