|
Posted by Hilarion on 10/13/12 11:25
> Hilarion I am looking at your current suggestion. I am using phpMyAdmin
> to interface with my database currently, its a MySql engine.
On MySQL InnoDB tables (only!) you can use FOREIGN KEY with ON DELETE CASCADE
(from version 3.23.50). To create this constraint you are required to create
indexes on the referenced fields (separate index for "Parent" and separate
index for "SectionID"). In versions 4.1.2 (and newer) the index on referencing
column ("Parent") will be created automatically (if it does not exist).
Hilarion
Navigation:
[Reply to this message]
|