propel:
  sf_guard_group:
    _attributes:    { phpName: sfGuardGroup }
    id:             ~
    name:           { type: varchar, size: 255, required: true, index: unique }
    description:    { type: longvarchar }

  sf_guard_group_permission:
    _attributes:    { phpName: sfGuardGroupPermission }
    group_id:       { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_group, foreignReference: id, onDelete: cascade }
    permission_id:  { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_permission, foreignReference: id, onDelete: cascade }

  sf_guard_permission:
    _attributes:    { phpName: sfGuardPermission }
    id:             ~
    name:           { type: varchar, size: 255, required: true }
    description:    { type: longvarchar }
    value: { type: VARCHAR, size: '10', required: true, defaultValue: '0' }

# Projektowy przodek (wymagana funkcjonalność)
# uprawnienie_tbl:
#    _attributes: { phpName: UprawnienieTbl }
#    uprawnienie_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
#    uprawnienie_prawo: { type: VARCHAR, size: '100', required: true, defaultValue: '' }
#    uprawnienie_modul_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: modul_tbl, foreignReference: modul_id, onDelete: CASCADE, onUpdate: RESTRICT }
#    uprawnienie_grupa_id: { type: INTEGER, size: '11', required: true, defaultValue: '0', foreignTable: grupa_tbl, foreignReference: grupa_id, onDelete: CASCADE, onUpdate: RESTRICT }
#    _indexes: { uprawnienie_modul_id: [uprawnienie_modul_id], uprawnienie_grupa_id: [uprawnienie_grupa_id] }

  sf_guard_remember_key:
    _attributes:    { phpName: sfGuardRememberKey }
    user_id:        { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade }
    remember_key:   { type: varchar, size: 32 }
    ip_address:     { type: varchar, size: 50, primaryKey: true }
    created_at:     ~

  sf_guard_user:
    _attributes:    { phpName: sfGuardUser }
    id:             ~
    username:       { type: varchar, size: 128, required: true, index: unique }
    algorithm:      { type: varchar, size: 128, required: true, default: sha1 }
    salt:           { type: varchar, size: 128, required: true }
    password:       { type: varchar, size: 128, required: true }
    created_at:     ~
    last_login:     { type: timestamp }
    is_active:      { type: boolean, required: true, default: 1 }
    is_super_admin: { type: boolean, required: true, default: 0 }
    czas_blokady: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
    nieudane_logowania: { type: SMALLINT, size: '6', required: true, defaultValue: '0' }
    czas_wygasniecia: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00' }
    edycja_hasla: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
    ip_addr:      { type: varchar, size: 256, required: false }

  sf_guard_user_group:
    _attributes:    { phpName: sfGuardUserGroup }
    user_id:        { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade }
    group_id:       { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_group, foreignReference: id, onDelete: cascade }

  sf_guard_user_permission:
    _attributes:    { phpName: sfGuardUserPermission }
    user_id:        { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade }
    permission_id:  { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_permission, foreignReference: id, onDelete: cascade }