MySQL Forums :: Ruby :: Ruby, Rails and MySQL gem ― through scaffolding, versioning, rake db:create, db:migrate ― HOW to implement and preserve your schema with SQL

Thank you very much for this informative article.

I have a question though:
what should I do if I don't want the primary key to be `id', but some other attribute?

Example:

CREATE TABLE products (
name varchar(100),
description text,
PRIMARY KEY (name)
) ENGINE=INNODB;

Thanks!