schema.yml

    sfGuardUser:
      actAs: [Timestampable]
      columns:
        email_address:
          type: string(255)
          notnull: true
          unique: true
        username:
          type: string(128)
          notnull: true
          unique: true
        first_name:
          type: varchar(255)
        last_name:
          type: varchar(255)
        algorithm:
          type: string(128)
          default: sha1
          notnull: true
        salt: string(128)
        password: string(128)
        is_active:
          type: boolean
          default: 1
        is_super_admin:
          type: boolean
          default: false
        last_login:
          type: timestamp
      indexes:
        is_active_idx:
          fields: [is_active]
      relations:
        Groups:
          class: sfGuardGroup
          local: user_id
          foreign: group_id
          refClass: sfGuardUserGroup
          foreignAlias: Users
        Permissions:
          class: sfGuardPermission
          local: user_id
          foreign: permission_id
          refClass: sfGuardUserPermission
          foreignAlias: Users

    sfGuardUserProfile:
      actAs:
        Timestampable: ~
      columns:
        user_id:
          type: integer(11)
          notnull: true
          default:
          unsigned: false
          primary: false
          unique: false
          autoincrement: false
        email_new:
          type: string(255)
          unique: true
        firstname:
          type: string(255)
        lastname:
          type: string(255)
        validate_at:
          type: timestamp
        validate:
          type: string(33)
     relations:
        User:         { onDelete: CASCADE, local: user_id, foreign: id, type: one, foreignType: one, foreignAlias: Profile, alias: User }