Hello Everyone.

I am writing a DVD rip library software in cake as one of my first
projects.  I'll give you the layout and the associations.

dvds
CREATE TABLE `dvds` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(55) default NULL,
  `body` text,
  `status_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

titles
CREATE TABLE `titles` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(155) default NULL,
  `body` text,
  `dvd_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

status
CREATE TABLE `status` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(55) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

DVD hasMany Title
Title belongsTo DVD

That association works perfect.  Now I want to associate the status
table with the dvds table, so that I can say whether or not the status
is closed or open for the DVD.

In cake what is the easiest way to quickly do this?  Right now I'm
running off just scaffolding because it really doesn't need another
interface and I'm wondering if I can continue to use the scaffolding,
so long as my assoications make sense?  Please help :)


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to