Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sfGuardGroup:
- actAs: [Timestampable]
- columns:
- id:
- type: integer(4)
- primary: true
- autoincrement: true
- name:
- type: string(255)
- unique: true
- description: string(1000)
- relations:
- users:
- class: sfGuardUser
- refClass: sfGuardUserGroup
- local: group_id
- foreign: user_id
- foreignAlias: Groups
- permissions:
- class: sfGuardPermission
- local: group_id
- foreign: permission_id
- refClass: sfGuardGroupPermission
- foreignAlias: Groups
- sfGuardPermission:
- actAs: [Timestampable]
- columns:
- id:
- type: integer(4)
- primary: true
- autoincrement: true
- name:
- type: string(255)
- unique: true
- description: string(1000)
- sfGuardGroupPermission:
- actAs: [Timestampable]
- columns:
- group_id:
- type: integer(4)
- primary: true
- permission_id:
- type: integer(4)
- primary: true
- relations:
- sfGuardGroup:
- local: group_id
- onDelete: CASCADE
- sfGuardPermission:
- local: permission_id
- onDelete: CASCADE
- 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: string(128)
- password: string(128)
- is_active:
- type: boolean
- default: 1
- is_super_admin:
- type: boolean
- default: 0
- last_login:
- type: timestamp
- indexes:
- is_active_idx:
- fields: [is_active]
- relations:
- groups:
- class: sfGuardGroup
- local: user_id
- foreign: group_id
- refClass: sfGuardUserGroup
- foreignAlias: Users
- permissions:
- class: sfGuardPermission
- local: user_id
- foreign: permission_id
- refClass: sfGuardUserPermission
- foreignAlias: Users
- sfGuardUserPermission:
- actAs: [Timestampable]
- columns:
- user_id:
- type: integer(4)
- primary: true
- permission_id:
- type: integer(4)
- primary: true
- relations:
- sfGuardUser:
- local: user_id
- onDelete: CASCADE
- sfGuardPermission:
- local: permission_id
- onDelete: CASCADE
- sfGuardUserGroup:
- actAs: [Timestampable]
- columns:
- user_id:
- type: integer(4)
- primary: true
- group_id:
- type: integer(4)
- primary: true
- relations:
- sfGuardUser:
- local: user_id
- onDelete: CASCADE
- sfGuardGroup:
- local: group_id
- onDelete: CASCADE
- sfGuardRememberKey:
- actAs: [Timestampable]
- columns:
- id:
- type: integer(4)
- primary: true
- autoincrement: true
- user_id:
- type: integer(4)
- remember_key: string(32)
- ip_address:
- type: string(50)
- primary: true
- relations:
- sfGuardUser:
- local: user_id
- foreignAlias: RememberKeys
- foreignType: one
- onDelete: CASCADE
- project:
- actAs:
- Timestampable: ~
- columns:
- name:
- type: string(255)
- notnull: true
- project_detail:
- type: string(4000)
- notnull: true
- options:
- collate: utf8_unicode_ci
- charset: utf8
- permission:
- actAs:
- Timestampable: ~
- columns:
- project_id:
- type: integer
- notnull: true
- programmer_id:
- type: integer
- notnull: true
- note:
- type: string(4000)
- notnull: true
- relations:
- project:
- local: project_id
- foreign: id
- foreignAlias: permission_project
- sfGuardUser:
- local: programmer_id
- foreign: id
- type: many
- foreignAlias: permission_username
- profile:
- columns:
- user_id:
- type: integer(4)
- first_name:
- type: string(255)
- notnull: true
- notblank: true
- nospace: true
- unique: true
- last_name:
- type: string(255)
- notnull: true
- notblank: true
- nospace: true
- email_address:
- type: string(255)
- email: true
- notnull: true
- notblank: true
- nospace: true
- relations:
- sfGuardUser:
- local: user_id
- foreign: id
- foreignAlias: profile_user
- story:
- actAs:
- Timestampable: ~
- columns:
- project_id:
- type: integer
- notnull: true
- user_id:
- type: integer
- notnull: true
- title:
- type: string(255)
- notnull: true
- description:
- type: string(4000)
- notnull: true
- relations:
- project:
- local: project_id
- foreign: id
- foreignAlias: story_project
- sfGuardUser:
- local: user_id
- foreign: id
- type: many
- foreignType: one
- foreignAlias: story_username
- FIXTURES :
- sfGuardUser:
- sgu_admin:
- username: admin
- password: admin
- is_super_admin: true
- sgu_sumon:
- username: sumon
- password: sumon
- is_super_admin: false
- sgu_muna:
- username: muna
- password: muna
- is_super_admin: false
- sfGuardPermission:
- sgp_admin:
- name: admin
- description: Administrator permission
- sfGuardGroup:
- sgg_admin:
- name: admin
- description: Administrator group
- sgg_programmer:
- name: programmer
- description: Programmer group
- sgg_client:
- name: client
- description: Client group
- sfGuardGroupPermission:
- sggp_admin:
- sfGuardGroup: sgg_admin
- sfGuardPermission: sgp_admin
- sfGuardUserGroup:
- sgug_admin:
- sfGuardGroup: sgg_admin
- sfGuardUser: sgu_admin
- sgug_programmer:
- sfGuardGroup: sgg_programmer
- sfGuardUser: sgu_sumon
- sgug_client:
- sfGuardGroup: sgg_client
- sfGuardUser: sgu_muna
- project:
- pro_agile:
- name: Agile Development
- project_detail: Agile Development is really important.
- pro_tour:
- name: Tourist Site
- project_detail: Should be nice looking and fantastic
- pro_tax_applicaton:
- name: Tax Client Manager
- project_detail: Tax calculation software with all kind of tracking.
- story:
- first_story:
- project: pro_tour
- title: Learning to be agile
- description: Agile development programmer description
- sfGuardUser: sgu_sumon
Add Comment
Please, Sign In to add comment