sfGuardGroup:
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    name:
      type: string(255)
      unique: true
    description:
      type: 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
      primary: true
      autoincrement: true
    name:
      type: string(255)
      unique: true
    description:
      type: string(1000)

sfGuardGroupPermission:
  options:
    symfony:
      form:   false
      filter: false
  actAs:
    Timestampable: ~
  columns:
    group_id:
      type: integer
      primary: true
    permission_id:
      type: integer
      primary: true
  relations:
    sfGuardGroup:
      local: group_id
      onDelete: CASCADE
    sfGuardPermission:
      local: permission_id
      onDelete: CASCADE

sfGuardUser:
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    username:
      type: string(128)
      notnull: true
      unique: true
    algorithm:
      type: string(128)
      default: sha1
      notnull: true
    salt:
      type: string(128)
    password:
      type: string(128)
    is_active:
      type: boolean
      default: 1
    is_super_admin:
      type: boolean
      default: false
    last_login:
      type: timestamp
    email:
      type: string(80)
      unique: true
      notnull: true
    fullname: string(255)
    image: string(255)
    specialization: clob
    registration_ip:
        type: string(15)
    validate:
      type: string(17)
    last_request: 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
    Directions:
      class: Direction
      local: user_id
      foreign: direction_id
      foreignAlias: Managers
      refClass: Manager__Direction
    Countries:
      class: Country
      local: user_id
      foreign: country_id
      foreignAlias: Managers
      refClass: Manager__Country

Manager__Country:
  options:
    symfony:
      filter: false
      form: false
  columns:
    user_id: { type: integer, primary: true }
    country_id: { type: integer, primary: true }
  relations:
    Manager:
      class: sfGuardUser
      onDelete: cascade
      local: user_id
      foreign: id
    Country:
      onDelete: cascade


Manager__Direction:
  options:
    symfony:
      filter: false
      form: false
  columns:
    user_id: { type: integer, primary: true }
    direction_id: { type: integer, primary: true }
  relations:
    Manager:
      class: sfGuardUser
      onDelete: cascade
      local: user_id
      foreign: id
    Direction:
      onDelete: cascade
      local: direction_id
      foreign: id



sfGuardUserPermission:
  options:
    symfony:
      form:   false
      filter: false
  actAs:
    Timestampable: ~
  columns:
    user_id:
      type: integer
      primary: true
    permission_id:
      type: integer
      primary: true
  relations:
    sfGuardUser:
      local: user_id
      onDelete: CASCADE
    sfGuardPermission:
      local: permission_id
      onDelete: CASCADE

sfGuardUserGroup:
  options:
    symfony:
      form:   false
      filter: false
  actAs:
    Timestampable: ~
  columns:
    user_id:
      type: integer
      primary: true
    group_id:
      type: integer
      primary: true
  relations:
    sfGuardUser:
      local: user_id
      onDelete: CASCADE
    sfGuardGroup:
      local: group_id
      onDelete: CASCADE

sfGuardRememberKey:
  options:
    symfony:
      form:   false
      filter: false
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    user_id:
      type: integer
    remember_key:
      type: string(32)
    ip_address:
      type: string(50)
      primary: true
  relations:
    sfGuardUser:
      local: user_id
      foreignAlias: RememberKeys
      foreignType: one
      onDelete: CASCADE