Changeset 7887
- Timestamp:
- 03/14/08 21:26:15 (2 years ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
plugins/sfGuardPlugin/branches/1.0/config/schema.yml
r7633 r7887 4 4 sf_guard_group: 5 5 _attributes: { phpName: sfGuardGroup } 6 id: 6 id: ~ 7 7 name: { type: varchar, size: 255, required: true, index: unique } 8 8 description: { type: longvarchar } … … 10 10 sf_guard_permission: 11 11 _attributes: { phpName: sfGuardPermission } 12 id: 12 id: ~ 13 13 name: { type: varchar, size: 255, required: true, index: unique } 14 14 description: { type: longvarchar } … … 21 21 sf_guard_user: 22 22 _attributes: { phpName: sfGuardUser } 23 id: 23 id: ~ 24 24 username: { type: varchar, size: 128, required: true, index: unique } 25 25 algorithm: { type: varchar, size: 128, required: true, default: sha1 } 26 26 salt: { type: varchar, size: 128, required: true } 27 27 password: { type: varchar, size: 128, required: true } 28 created_at: 28 created_at: ~ 29 29 last_login: { type: timestamp } 30 30 is_active: { type: boolean, required: true, default: 1 } … … 46 46 remember_key: { type: varchar, size: 32 } 47 47 ip_address: { type: varchar, size: 15, primaryKey: true } 48 created_at: 48 created_at: ~ plugins/sfGuardPlugin/branches/1.1/config/schema.yml
r7745 r7887 1 1 propel: 2 2 _attributes: { package: plugins.sfGuardPlugin.lib.model } 3 3 4 4 sf_guard_group: 5 5 _attributes: { phpName: sfGuardGroup } 6 id: 6 id: ~ 7 7 name: { type: varchar, size: 255, required: true, index: unique } 8 8 description: { type: longvarchar } 9 9 10 10 sf_guard_permission: 11 11 _attributes: { phpName: sfGuardPermission } 12 id: 12 id: ~ 13 13 name: { type: varchar, size: 255, required: true, index: unique } 14 14 description: { type: longvarchar } 15 15 16 16 sf_guard_group_permission: 17 17 _attributes: { phpName: sfGuardGroupPermission } 18 18 group_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_group, foreignReference: id, onDelete: cascade } 19 19 permission_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_permission, foreignReference: id, onDelete: cascade } 20 20 21 21 sf_guard_user: 22 22 _attributes: { phpName: sfGuardUser } 23 id: 23 id: ~ 24 24 username: { type: varchar, size: 128, required: true, index: unique } 25 25 algorithm: { type: varchar, size: 128, required: true, default: sha1 } 26 26 salt: { type: varchar, size: 128, required: true } 27 27 password: { type: varchar, size: 128, required: true } 28 created_at: 28 created_at: ~ 29 29 last_login: { type: timestamp } 30 30 is_active: { type: boolean, required: true, default: 1 } 31 31 is_super_admin: { type: boolean, required: true, default: 0 } 32 32 33 33 sf_guard_user_permission: 34 34 _attributes: { phpName: sfGuardUserPermission } 35 35 user_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade } 36 36 permission_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_permission, foreignReference: id, onDelete: cascade } 37 37 38 38 sf_guard_user_group: 39 39 _attributes: { phpName: sfGuardUserGroup } 40 40 user_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_user, foreignReference: id, onDelete: cascade } 41 41 group_id: { type: integer, primaryKey: true, required: true, foreignTable: sf_guard_group, foreignReference: id, onDelete: cascade } 42 42 43 43 sf_guard_remember_key: 44 44 _attributes: { phpName: sfGuardRememberKey } … … 46 46 remember_key: { type: varchar, size: 32 } 47 47 ip_address: { type: varchar, size: 15, primaryKey: true } 48 created_at: 48 created_at: ~
