Z8veRUEz

1## resource model
2<?
3var $hasAndBelongsToMany = array( 'Tag' 		=> array( 'joinTable' => 'tags_resources', 'order' => 'Tag.label'),
4                                    	  'Attribute' 	=> array( 'joinTable' => 'resource_attributes')
5    );
6?>
7
8## attribute model
9<?
10 var $hasManyAndBelongsTo = array('Resource'=> array( 'joinTable' => 'resource_attributes') );
11?>
12
13## sql for join table 
14DROP TABLE IF EXISTS `creativevault`.`resource_attributes`;
15CREATE TABLE  `creativevault`.`resource_attributes` (
16  `id` int(11) NOT NULL auto_increment,
17  `value` varchar(255) NOT NULL,
18  `resource_id` int(11) NOT NULL,
19  `attribute_id` int(11) NOT NULL,
20  PRIMARY KEY  (`id`)
21) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;