[S1Pb]

Would be nice to use phpMyAdmin Designer to create relationships and if Gii could use those in code generation to create relations in code.

[bennouna]

You can add comments in your FK and Gii automatically creates relations in your models, like this

CREATE TABLE `Brand` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `Model` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `brandId` smallint(5) unsigned NOT NULL COMMENT 'CONSTRAINT FOREIGN KEY (brandId) REFERENCES Brand(id)',
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
);

[S1Pb]

The second quote doesn't look like it belong here...

[bennouna]

Here. It was part of my signature for half a day (no offense intended). It's gone.

Now the SQL above is what I use, and Gii makes good use of it. (I learned it from some Yii tutorial, maybe Larry Ullman or the blog tutorial)