Well, I have innodb support on my own box that I'm working on to start with, but I went and checked my web host and they don't support it.
However, I'm still looking for an answer, and it seems like maybe I don't really need "foreign keys and consistency"? I'm just trying to set up a database the "correct" way, which after much research on data modelling and 1NF, 2NF, 3NF and whatnot, I came up with tables called Item, Referrer, Vendor, Buyer, and Categories. But when I started to try to get these foreign keys and such set up I realized I was going to have an issue. Is this just something where I need to do more research on PHP/MySQL language so that my queries will take care of what the foreign keys, etc. would have done? Thanks! Levi On Wednesday 17 August 2005 11:49 am, Tracy R Reed wrote: > Levi Smith wrote: > > So, now I'm trying to develop this database for an antiques store where > > one item could be in multiple categories, and I think I've gathered > > enough (almost) to lay out the structure and was almost there. But now > > I've realized that the foreign keys seem to actually need to be defined > > in the database. I then found that apparently I need to use the InnoDB > > type to do that? Then I go to look at my webhost and I only have options > > for MyISAM, Heap, ISAM and Merge. > > Yes, if you really want foreign keys to work and enforce consistancy you > need to be using the innodb type. Do you have the option of upgrading > your mysql? If so I would recommend going with mysql 5. It is > technically still beta but it is late beta. I am using it and having > good success with it. It includes all of the features dba's have been > panning mysql over for years so mysql should now finally be counted as a > full fledged rdbms. > > -- > Tracy R Reed > http://ultraviolet.org -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
