propel:
  role:
    _attributes:   { phpName: Role }
    id:
    name:          varchar(255)
    credentials:   varchar(255)

  user:
    _attributes:    { phpName: User }
    id:
    parent_user_id: { type: integer, default: -1, foreignTable: user, foreignReference: id, onDelete: setnull }
    nickname:       varchar(50)
    first_name:     varchar(100)
    last_name:      varchar(100)
    email:          varchar(255)
    sha1_password:  varchar(40)
    salt:           varchar(32)
    role_id:
    last_login:      timestamp
    created_at:

  domain_permission:
    _attributes:       { phpName: DomainPermission }
    user_id:           { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
    domain_id:         { type: integer, foreignTable: domain, foreignReference: id, onDelete: cascade }

  domain:
    _attributes:       { phpName: Domain }
    id:
    name:              varchar(255)
    creator_id:        { type: integer, foreignTable: user, foreignReference: id, onDelete: setnull }
    mailbox_prefix:    varchar(255)
    max_mailbox_count: integer
    quota:             integer
    default_mailbox_quota: integer
    _uniques:
      i2:              [name]

  mailbox:
    _attributes:         { phpName: Mailbox }
    id:
    domain_id:           { type: integer, foreignTable: domain, foreignReference: id, onDelete: setnull }
    name:                varchar(30)
    password:            varchar(40)
    max_quota:           integer
    max_address_count:   integer
    last_login:          timestamp
    active:              { type: boolean, default: true }

  address:
    _attributes:         { phpName: Address }
    id:
    mailbox_id:          { type: integer, foreignTable: mailbox, foreignReference: id, onDelete: cascade }
    localpart:           varchar(255)
    domain_id:
    alias:               varchar(255)
    destination:         longvarchar
    active:              { type: boolean, default: true }
    save_in_mailbox:     { type: boolean, default: true }

  log:
    _attributes:   { phpName: LogEntry }
    id:
    user_id:       { type: integer, default: null, foreignTable: user, foreignReference: id, onDelete: setnull }
    created_at:
    message:       longvarchar
    host:          varchar(255)
    priority:      integer