[Web-erp-developers] Foreign Keys

[Phil D. <ph...@du...>]

I started to work through this making a script up then realised ...

Starting from version 3.23.50, InnoDB allows you to add a new foreign key 
constraint to a table. 

This is actually quite a recent version and many folks would not have this 
functionality on their ISP's servers - so I think I'll make the script up and 
keep it as an option for those that wish to have the xtra database 
integrity/security. I have converted all the tables to Innodb as discussed 
and included this in the update script.

I'm currently using mysql-max 3.23.49!! Probably due for an update anyway.

Phil