You could say I bit off more than I could chew... However, what's done is done and I'm pulling the rest of my hair out and looking to the DaniWeb community for help...
I am building a site that people can log in to and select classes that are owned by different users...
I have 7 tables in my DB
# Class
# ClassDetails
# Owner
# OwnerDetails
# User
# UserClasses
# UserDetails
CREATE TABLE `Class` (
`CID` int(10) NOT NULL auto_increment,
`CDID` int(10) NOT NULL,
`OID` int(10) NOT NULL,
`CDName` varchar(255) NOT NULL,
PRIMARY KEY (`CID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
I have a ton of questions, but, I'll only ask a few... I'm sure I can figure it out with a little direction...
1. How do I apply Foreign keys to tables? If I do, can I update the ClassDetails table and auto populate the Class tables at the same time? When I try to add the Foreign Key now I get "No Index Defined!"...
2. Once the relationship is made using CASCADE can I update one to many rows?
Any help would be great!
Thanks,
Ted