On Jan 25, 2008, at 3:11 PM, judouk wrote:
> > ///sorry, gmail let me post it first before I'd finished.... and now > that I've had the time to rethink what I was typing, I think I've > solved my own problem !//// > > <snip> > CREATE TABLE jobs ( > id int(10) not null auto_increment, > typeofjob varchar(20) not null, > primary key(id) > ) type = myisam; > > CREATE TABLE action ( > id int(10) not null auto_increment, > job_id int(10) not null, > action tinyint(1) null, > description varchar(255) null, > primary key(id) > ) type = myisam; > > > Surely I'd just use something like this and associate the two tables > with a $belongsToMany Looks like Job hasMany Action, and Action belongs Job to me. HABTM requires an additional table (actions_jobs, if that's what you're really after). -- John --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
