Guest User

Untitled

a guest
Jun 4th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.35 KB | None | 0 0
  1. sfGuardGroup:
  2. actAs: [Timestampable]
  3. columns:
  4. id:
  5. type: integer(4)
  6. primary: true
  7. autoincrement: true
  8. name:
  9. type: string(255)
  10. unique: true
  11. description: string(1000)
  12. relations:
  13. users:
  14. class: sfGuardUser
  15. refClass: sfGuardUserGroup
  16. local: group_id
  17. foreign: user_id
  18. foreignAlias: Groups
  19. permissions:
  20. class: sfGuardPermission
  21. local: group_id
  22. foreign: permission_id
  23. refClass: sfGuardGroupPermission
  24. foreignAlias: Groups
  25.  
  26. sfGuardPermission:
  27. actAs: [Timestampable]
  28. columns:
  29. id:
  30. type: integer(4)
  31. primary: true
  32. autoincrement: true
  33. name:
  34. type: string(255)
  35. unique: true
  36. description: string(1000)
  37.  
  38. sfGuardGroupPermission:
  39. actAs: [Timestampable]
  40. columns:
  41. group_id:
  42. type: integer(4)
  43. primary: true
  44. permission_id:
  45. type: integer(4)
  46. primary: true
  47. relations:
  48. sfGuardGroup:
  49. local: group_id
  50. onDelete: CASCADE
  51. sfGuardPermission:
  52. local: permission_id
  53. onDelete: CASCADE
  54.  
  55. sfGuardUser:
  56. actAs: [Timestampable]
  57. columns:
  58. id:
  59. type: integer(4)
  60. primary: true
  61. autoincrement: true
  62. username:
  63. type: string(128)
  64. notnull: true
  65. unique: true
  66. algorithm:
  67. type: string(128)
  68. default: sha1
  69. notnull: true
  70. salt: string(128)
  71. password: string(128)
  72. is_active:
  73. type: boolean
  74. default: 1
  75. is_super_admin:
  76. type: boolean
  77. default: 0
  78. last_login:
  79. type: timestamp
  80. indexes:
  81. is_active_idx:
  82. fields: [is_active]
  83. relations:
  84. groups:
  85. class: sfGuardGroup
  86. local: user_id
  87. foreign: group_id
  88. refClass: sfGuardUserGroup
  89. foreignAlias: Users
  90. permissions:
  91. class: sfGuardPermission
  92. local: user_id
  93. foreign: permission_id
  94. refClass: sfGuardUserPermission
  95. foreignAlias: Users
  96.  
  97. sfGuardUserPermission:
  98. actAs: [Timestampable]
  99. columns:
  100. user_id:
  101. type: integer(4)
  102. primary: true
  103. permission_id:
  104. type: integer(4)
  105. primary: true
  106. relations:
  107. sfGuardUser:
  108. local: user_id
  109. onDelete: CASCADE
  110. sfGuardPermission:
  111. local: permission_id
  112. onDelete: CASCADE
  113.  
  114. sfGuardUserGroup:
  115. actAs: [Timestampable]
  116. columns:
  117. user_id:
  118. type: integer(4)
  119. primary: true
  120. group_id:
  121. type: integer(4)
  122. primary: true
  123. relations:
  124. sfGuardUser:
  125. local: user_id
  126. onDelete: CASCADE
  127. sfGuardGroup:
  128. local: group_id
  129. onDelete: CASCADE
  130.  
  131. sfGuardRememberKey:
  132. actAs: [Timestampable]
  133. columns:
  134. id:
  135. type: integer(4)
  136. primary: true
  137. autoincrement: true
  138. user_id:
  139. type: integer(4)
  140. remember_key: string(32)
  141. ip_address:
  142. type: string(50)
  143. primary: true
  144. relations:
  145. sfGuardUser:
  146. local: user_id
  147. foreignAlias: RememberKeys
  148. foreignType: one
  149. onDelete: CASCADE
  150.  
  151. project:
  152. actAs:
  153. Timestampable: ~
  154. columns:
  155. name:
  156. type: string(255)
  157. notnull: true
  158. project_detail:
  159. type: string(4000)
  160. notnull: true
  161. options:
  162. collate: utf8_unicode_ci
  163. charset: utf8
  164.  
  165. permission:
  166. actAs:
  167. Timestampable: ~
  168. columns:
  169. project_id:
  170. type: integer
  171. notnull: true
  172. programmer_id:
  173. type: integer
  174. notnull: true
  175. note:
  176. type: string(4000)
  177. notnull: true
  178. relations:
  179. project:
  180. local: project_id
  181. foreign: id
  182. foreignAlias: permission_project
  183. sfGuardUser:
  184. local: programmer_id
  185. foreign: id
  186. type: many
  187. foreignAlias: permission_username
  188.  
  189. profile:
  190. columns:
  191. user_id:
  192. type: integer(4)
  193. first_name:
  194. type: string(255)
  195. notnull: true
  196. notblank: true
  197. nospace: true
  198. unique: true
  199. last_name:
  200. type: string(255)
  201. notnull: true
  202. notblank: true
  203. nospace: true
  204. email_address:
  205. type: string(255)
  206. email: true
  207. notnull: true
  208. notblank: true
  209. nospace: true
  210. relations:
  211. sfGuardUser:
  212. local: user_id
  213. foreign: id
  214. foreignAlias: profile_user
  215.  
  216. story:
  217. actAs:
  218. Timestampable: ~
  219. columns:
  220. project_id:
  221. type: integer
  222. notnull: true
  223. user_id:
  224. type: integer
  225. notnull: true
  226. title:
  227. type: string(255)
  228. notnull: true
  229. description:
  230. type: string(4000)
  231. notnull: true
  232. relations:
  233. project:
  234. local: project_id
  235. foreign: id
  236. foreignAlias: story_project
  237. sfGuardUser:
  238. local: user_id
  239. foreign: id
  240. type: many
  241. foreignType: one
  242. foreignAlias: story_username
  243.  
  244.  
  245.  
  246.  
  247. FIXTURES :
  248.  
  249. sfGuardUser:
  250. sgu_admin:
  251. username: admin
  252. password: admin
  253. is_super_admin: true
  254.  
  255. sgu_sumon:
  256. username: sumon
  257. password: sumon
  258. is_super_admin: false
  259.  
  260. sgu_muna:
  261. username: muna
  262. password: muna
  263. is_super_admin: false
  264.  
  265. sfGuardPermission:
  266. sgp_admin:
  267. name: admin
  268. description: Administrator permission
  269.  
  270. sfGuardGroup:
  271. sgg_admin:
  272. name: admin
  273. description: Administrator group
  274. sgg_programmer:
  275. name: programmer
  276. description: Programmer group
  277. sgg_client:
  278. name: client
  279. description: Client group
  280.  
  281. sfGuardGroupPermission:
  282. sggp_admin:
  283. sfGuardGroup: sgg_admin
  284. sfGuardPermission: sgp_admin
  285.  
  286. sfGuardUserGroup:
  287. sgug_admin:
  288. sfGuardGroup: sgg_admin
  289. sfGuardUser: sgu_admin
  290. sgug_programmer:
  291. sfGuardGroup: sgg_programmer
  292. sfGuardUser: sgu_sumon
  293. sgug_client:
  294. sfGuardGroup: sgg_client
  295. sfGuardUser: sgu_muna
  296.  
  297. project:
  298. pro_agile:
  299. name: Agile Development
  300. project_detail: Agile Development is really important.
  301.  
  302. pro_tour:
  303. name: Tourist Site
  304. project_detail: Should be nice looking and fantastic
  305.  
  306. pro_tax_applicaton:
  307. name: Tax Client Manager
  308. project_detail: Tax calculation software with all kind of tracking.
  309.  
  310. story:
  311. first_story:
  312. project: pro_tour
  313. title: Learning to be agile
  314. description: Agile development programmer description
  315. sfGuardUser: sgu_sumon
Add Comment
Please, Sign In to add comment