64 lines
3.6 KiB
YAML
64 lines
3.6 KiB
YAML
propel:
|
|
_attributes: { package: plugins.sfGuardPlugin.lib.model }
|
|
|
|
sf_guard_group:
|
|
_attributes: { phpName: sfGuardGroup }
|
|
id: ~
|
|
name: { type: varchar, size: 48, required: true, index: unique }
|
|
description: { type: varchar, size: 48}
|
|
|
|
sf_guard_permission:
|
|
_attributes: { phpName: sfGuardPermission }
|
|
id: ~
|
|
name: { type: varchar, size: 48, required: true, index: unique }
|
|
description: { type: varchar, size: 48}
|
|
|
|
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_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, default: "" }
|
|
password: { type: varchar, size: 128, required: true, default: "" }
|
|
created_at: ~
|
|
last_login: { type: timestamp }
|
|
last_password_change: { type: timestamp }
|
|
is_active: { type: boolean, required: true, default: 1 }
|
|
is_super_admin: { type: boolean, required: true, default: 0 }
|
|
is_confirm: { type: boolean, required: false, default: 1 }
|
|
is_admin_confirm: { type: boolean, required: false, default: 0 }
|
|
hash_code: { type: varchar, size: 128, required: false }
|
|
language: { type: varchar, size: 10, required: false }
|
|
external_account: { type: varchar, size: 128, required: false}
|
|
|
|
|
|
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 }
|
|
|
|
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_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_module_permission:
|
|
_attributes: { phpName: sfGuardUserModulePermission }
|
|
id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade }
|
|
permissions: { type: LONGVARCHAR, phpType: array }
|
|
sf_guard_group_module_permission:
|
|
_attributes: { phpName: sfGuardGroupModulePermission }
|
|
id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_group, foreignReference: id, onDelete: cascade }
|
|
permissions: { type: LONGVARCHAR, phpType: array }
|