Cactiverecord Doesn't Work With Mysql Partitioned Table

Yii 1.1 General Discussion
1

hi,

I’m trying to build a new app with existing database.

some of the tables ih the db are partitioned by some fields.

which means that the primary key contains multiplefields.

because of MySQL’s requirement.

http://dev.mysql.com…nique-keys.html

in fact, each table has "id" column with uuid style.

I’d like to specify to use only that “id” as a “primaryKey” of each ActiveRecord model.

Is it impossible?

2

Overload the primaryKey() method to redefine which column(s) are the primary key.

I use it when creating models for views which doesn’t have PKs at all.

3

thanks.

can that work correctly with activerecord’s “relationship”?

4

CActiveRelation.foreignKey can take a set of fields, so yes.