Closed sobrado closed 12 years ago
@nilay please give priority to this one. We will need to create a join table. Many to many trips can have many categoryes and categories can be assigned to many different trips
Following SQL need to be executed on database:
CREATE TABLE trip_tripcategories
(
trip_id
INT(11) NOT NULL,
category_id
INT(11) NOT NULL,
PRIMARY KEY (trip_id
,category_id
)
) ENGINE=INNODB DEFAULT CHARSET=latin1
@sobrado done please check it out
will do! please add gay-friendly , golf, sports fishing, scuba diving, and luxury
Added to database
On trips the "category" oprtion right now consists on a drop down menu so you can only choose one option. It has to be changed to a multiple option click box.