sfGuardUser:
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer(4)
      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
  indexes:
    is_active_idx:
      fields: [is_active]

sfGuardUserProfile:
  columns:
    date_birth: {type: date }
    gender: { type:  string(12)}
    nif:  { type:  string(12), notnull:  true}
    address: { type:  string(150) }
    city: { type:  string(50), notnull:  true}
    province: { type:  string(50), notnull:  true}
    zip_code: { type:  string(8), notnull:  true}
    country: { type:  string(50)}
    telephone: { type:  string(15), notnull:  true }
    mobile: { type:  string(15)  }
    professional: { type:  boolean,default:false }
  relations:
    User:
      class: sfGuardUser
      foreign: id
      local: user_id
      type: one
      onDelete: cascade
      foreignType: one
      foreignAlias: Profile
    DcFenixNewsletterSubscriptor:
      local:        id
      foreign:      user_id
      foreignAlias: Profile

DcFenixNewsletterSubscriberList:
  tableName: fenix_newsletter_suscriber_list
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string(4000), notnull: true }
    description: { type: string(4000), notnull: true }
  relations:
    DcFenixNewsletterSubscriptor:
      local:        id
      foreign:      list_id
      foreignAlias: SubscriberList




DcFenixNewsletterSubscriptor:
  tableName: fenix_newsletter_subscriptor
  columns:
   user_id: {type: integer, notnull: true, primary: true}
   list_id: {type: integer, notnull: true, primary: true}