What driver are you using?
It seems to work for me using mysql.
---
User:
columns:
id:
primary: true
autoincrement: true
type: integer
length: 11
username:
type: string
size: 255
contact_id:
type: integer
size: 255
indexes:
name_contact_id_idx:
columns:
username: ~
contact_id: ~
type: unique
relations:
Contact: -
Produces....
CREATE TABLE user (id BIGINT AUTO_INCREMENT, username VARCHAR(255),
contact_id BIGINT, UNIQUE INDEX name_contact_id_idx_idx (username,
contact_id), INDEX contact_id_idx (contact_id), PRIMARY KEY(id)) ENGINE =
INNODB;
CREATE TABLE contact (id BIGINT AUTO_INCREMENT, name VARCHAR(255), PRIMARY
KEY(id)) ENGINE = INNODB;
ALTER TABLE user ADD FOREIGN KEY (contact_id) REFERENCES contact(id);
- Jon
On 10/28/07, Charley Tiggs <[EMAIL PROTECTED]> wrote:
>
>
>
> On Oct 28, 2007, at 4:45 AM, Ian P. Christian wrote:
>
> >
> > Charley Tiggs wrote:
> >> I'm using schema.yml to manage my models and to create the tables
> >> until the database structure settles down. I'm trying to create a
> >> multi-column index on a table and am not having any success. Here's
> >> the table:
> >>
> >
> > Please create a ticket for this in the symfony trac, mark for
> > attention
> > of jonwage.
>
> Thanks and done.
>
> Charley
>
>
> >
>
--
Jonathan Wage
http://www.jwage.com
http://www.centresource.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
