Using postgres driver. Charley
On Oct 29, 2007, at 8:39 AM, Jonathan Wage wrote: > 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 -~----------~----~----~----~------~----~------~--~---
