gistfile1.txt

# All id type columns are set to integer with a length of 4 since this forces Doctrine to use integer type instead of bigint. This is especially important for working with sfGuardUserPlugin.
sfGuardUserProfile:
  actAs: { Timestampable: ~ }
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    user_id: integer(4)
    first_name: varchar(50)
    last_name: varchar(50)
    email: varchar(100)
    phone: varchar(25)
    address: varchar(255)
    city: varchar(255)
    state: varchar(50)
    zip: varchar(50)
  relations:
    sfGuardUser: { local: user_id, foreign: id, foreignAlias: profile, onDelete: cascade }