Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › database structures and foreign keys

database structures and foreign keys

Thread began 8/03/2009 8:17 am by jenkolaka19379118 | Last modified 8/07/2009 4:54 pm by jenkolaka19379118 | 4107 views | 7 replies

8/07/2009 2:35 amjenkolaka19379118

I have been resesarching this issue and realised that you cannot force referential integrity using a myisam database engine. Unfortunately I am using a myisam database engine. Did you use a innodb database engine to create the blue sky music database?. If not how did you (do you) force referential integrity using a myisam engine?

Secondly did you need to force referential integrity on any of the relationships in the blue sky music database?

Items.ItemcatID is a forign key relation to itemcategory.ItemcatID

orderdetails.DetailOrderID is a foreign key relation to orders.OrderID

orders.OrderStatus is a foreign key relation to orderstatustypes.StatusID

visitors.VisitorGroupID is a foreign key relation to groups.GroupID

If so could you please describe to me in detail how you do it? (sql statement)

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.