sfGuardGroup:
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    name:
      type: string(255)
      unique: true
    description: string(1000)
  relations:
    Users:
      class: sfGuardUser
      refClass: sfGuardUserGroup
      local: group_id
      foreign: user_id
      foreignAlias: Groups
    Permissions:
      class: sfGuardPermission
      local: group_id
      foreign: permission_id
      refClass: sfGuardGroupPermission
      foreignAlias: Groups

sfGuardPermission:
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    name:
      type: varchar(255)
      unique: true
    description: text

sfGuardGroupPermission:
  options:
    symfony:
      form:   false
      filter: false
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    group_id:
      type: integer(4)
      primary: true
    permission_id:
      type: integer(4)
      primary: true
  relations:
    Group:
      class: sfGuardGroup
      local: group_id
      onDelete: CASCADE
    Permission:
      class: sfGuardPermission
      local: permission_id
      onDelete: CASCADE

sfGuardUser:
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    first_name: string(255)
    last_name: string(255)
    email_address:
      type: string(255)
      notnull: true
      unique: true
    username:
      type: string(128)
      notnull: true
      unique: true
    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

sfGuardUserPermission:
  options:
    symfony:
      form:   false
      filter: false
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    user_id:
      type: integer(4)
      primary: true
    permission_id:
      type: integer(4)
      primary: true
  relations:
    User:
      class: sfGuardUser
      local: user_id
      onDelete: CASCADE
    Permission:
      class: sfGuardPermission
      local: permission_id
      onDelete: CASCADE

sfGuardUserGroup:
  options:
    symfony:
      form:   false
      filter: false
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    user_id:
      type: integer(4)
      primary: true
    group_id:
      type: integer(4)
      primary: true
  relations:
    User:
      class: sfGuardUser
      local: user_id
      onDelete: CASCADE
    Group:
      class: sfGuardGroup
      local: group_id
      onDelete: CASCADE

sfGuardRememberKey:
  options:
    symfony:
      form:   false
      filter: false
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    user_id: integer(4)
    remember_key: string(32)
    ip_address: string(50)
  relations:
    User:
      class: sfGuardUser
      local: user_id
      foreignAlias: RememberKeys
      foreignType: one
      onDelete: CASCADE

sfGuardForgotPassword:
  options:
    symfony:
      form:   false
      filter: false
  actAs: [Timestampable]
  columns:
    id: { type: integer(4), primary: true, autoincrement: true }
    user_id:
      type: integer(4)
      notnull: true
    unique_key: string(255)
    expires_at:
      type: timestamp
      notnull: true
  relations:
    User:
      class: sfGuardUser
      local: user_id
      type: one
      foreignType: one
      foreignAlias: ForgotPassword
      onDelete: CASCADE

sfGuardUserProfile:
  actAs:
    Timestampable: ~
    Sluggable:
      fields: [id,firstname,lastname]
  columns:
    user_id:
      type: integer(4)
      notnull: true
      unique: true
    id: { type: integer(4), primary: true, autoincrement: true }
    firstname: { type: varchar(200) }
    lastname: { type: varchar(200) }
    date_naissance: { type: date }
    sexe: { type: varchar(10) }
    statut_social: { type: varchar(20) }
    std_diplomes_niveaux_id: { type: integer(4) }
    adresse: { type: varchar(200) }
    adresse_complementaire: { type: varchar(200) }
    code_postal: { type: integer(4) }
    std_villes_id: { type: integer(4) }
    std_departements_id: { type: integer(4) }
    std_regions_id: { type: integer(4) }
    std_pays_id: { type: integer(4) }
    telephone_fixe: { type: varchar(20) }
    telephone_portable: { type: varchar(20) }
    fax: { type: varchar(20) }
    email_personnel: { type: varchar(200) }
    email_professionnel: { type: varchar(200) }
    email_secours: { type: varchar(200) }
    question_secrete: { type: text }
    response_question: { type: text }
    password: { type: varchar(200) }
    hash: { type: varchar(200) }
    activer: { type: boolean }
    langue: { type: varchar(5) }
    referrer: { type: varchar(255) }
    last_connexion: { type: datetime }
    last_ip: { type: varchar(50) }
    email_new: { type: varchar(200) }
    demande_password: { type: integer(4) }
    date_demande_password: { type: datetime }
    validate_at:
      type: timestamp
    validate:
      type: string(33)
  relations:
    User:
      class: sfGuardUser
      foreign: id
      local: user_id
      type: one
      onDelete: cascade
      foreignType: one
      foreignAlias: Profile
    DiplomeNiveau: { local: std_diplomes_niveaux_id, foreign: id }
    Ville: { local: std_villes_id, foreign: id }
    Region: { local: std_regions_id, foreign: id }
    Departement: { local: std_departements_id, foreign: id }
    Pays: { local: std_pays_id, foreign: id }
  indexes:
    validate:
      fields: [validate]