API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 17th, 2017
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.72 KB | None | 0 0
raw download clone embed print report
  1. DmUser:
  2. actAs: [Timestampable]
  3. columns:
  4. username:
  5. type: string(255)
  6. notnull: true
  7. unique: true
  8. email:
  9. type: string(255)
  10. notnull: true
  11. unique: true
  12. algorithm:
  13. type: string(128)
  14. default: sha1
  15. notnull: true
  16. salt: string(128)
  17. password: string(128)
  18. is_active:
  19. type: boolean
  20. default: true
  21. is_super_admin:
  22. type: boolean
  23. default: false
  24. last_login:
  25. type: timestamp
  26. forgot_password_code:
  27. type: string(12)
  28. unique: true
  29. indexes:
  30. is_active_idx:
  31. fields: [is_active]
  32. relations:
  33. Groups:
  34. class: DmGroup
  35. local: dm_user_id
  36. foreign: dm_group_id
  37. refClass: DmUserGroup
  38. foreignAlias: Users
  39. Permissions:
  40. class: DmPermission
  41. local: dm_user_id
  42. foreign: dm_permission_id
  43. refClass: DmUserPermission
  44. foreignAlias: Users
  45. Records:
  46. class: DmRecordPermission
  47. local: dm_user_id
  48. foreign: dm_record_permission_id
  49. refClass: DmRecordPermissionUser
  50. foreignAlias: Users
  51. RecordsPermissionsAssociations:
  52. class: DmRecordPermissionAssociation
  53. refClass: DmRecordPermissionAssociationUser
  54. local: dm_user_id
  55. foreign: dm_record_permission_association_id
  56. foreignAlias: Users
  57.  
  58. DmRecordPermissionUser:
  59. options:
  60. symfony:
  61. form: false
  62. filter: false
  63. columns:
  64. dm_user_id: {type: integer(11), notnull: true, primary: true}
  65. dm_record_permission_id: {type: integer(11), notnull: true, primary: true}
  66. relations:
  67. User:
  68. class: DmUser
  69. local: dm_user_id
  70. onDelete: CASCADE
  71. foreignAlias: Records
  72. Record:
  73. class: DmRecordPermission
  74. local: dm_record_permission_id
  75. onDelete: CASCADE
  76. foreignAlias: Users
  77.  
  78. DmGroup:
  79. actAs: [Timestampable]
  80. columns:
  81. name:
  82. type: string(255)
  83. unique: true
  84. description: string(1000)
  85. relations:
  86. Users:
  87. class: DmUser
  88. refClass: DmUserGroup
  89. local: dm_group_id
  90. foreign: dm_user_id
  91. foreignAlias: Groups
  92. Permissions:
  93. class: DmPermission
  94. local: dm_group_id
  95. foreign: dm_permission_id
  96. refClass: DmGroupPermission
  97. foreignAlias: Groups
  98. Records:
  99. class: DmRecordPermission
  100. local: dm_group_id
  101. foreign: dm_record_permission_id
  102. refClass: DmRecordPermissionGroup
  103. foreignAlias: Groups
  104. RecordsPermissionsAssociations:
  105. class: DmRecordPermissionAssociation
  106. refClass: DmRecordPermissionAssociationGroup
  107. local: dm_group_id
  108. foreign: dm_record_permission_association_id
  109. foreignAlias: Groups
  110.  
  111. DmRecordPermissionGroup:
  112. options:
  113. symfony:
  114. form: false
  115. filter: false
  116. columns:
  117. dm_group_id: {type: integer(11), notnull: true, primary: true}
  118. dm_record_permission_id: {type: integer(11), notnull: true, primary: true}
  119. relations:
  120. Group:
  121. class: DmGroup
  122. local: dm_group_id
  123. onDelete: CASCADE
  124. foreignAlias: Records
  125. Record:
  126. class: DmRecordPermission
  127. local: dm_record_permission_id
  128. onDelete: CASCADE
  129. foreignAlias: Groups
  130.  
  131. DmPermission:
  132. actAs: [Timestampable]
  133. columns:
  134. name:
  135. type: string(255)
  136. unique: true
  137. description: string(5000)
  138.  
  139. DmGroupPermission:
  140. options:
  141. symfony:
  142. form: false
  143. filter: false
  144. columns:
  145. dm_group_id:
  146. type: integer
  147. primary: true
  148. dm_permission_id:
  149. type: integer
  150. primary: true
  151. relations:
  152. Group:
  153. class: DmGroup
  154. local: dm_group_id
  155. onDelete: CASCADE
  156. foreignAlias: Permissions
  157. Permission:
  158. class: DmPermission
  159. local: dm_permission_id
  160. onDelete: CASCADE
  161. foreignAlias: Groups
  162.  
  163. DmUserPermission:
  164. options:
  165. symfony:
  166. form: false
  167. filter: false
  168. columns:
  169. dm_user_id:
  170. type: integer
  171. primary: true
  172. dm_permission_id:
  173. type: integer
  174. primary: true
  175. relations:
  176. User:
  177. class: DmUser
  178. local: dm_user_id
  179. onDelete: CASCADE
  180. foreignAlias: Permissions
  181. Permission:
  182. class: DmPermission
  183. local: dm_permission_id
  184. onDelete: CASCADE
  185. foreignAlias: Users
  186.  
  187. DmUserGroup:
  188. options:
  189. symfony:
  190. form: false
  191. filter: false
  192. columns:
  193. dm_user_id:
  194. type: integer
  195. primary: true
  196. dm_group_id:
  197. type: integer
  198. primary: true
  199. relations:
  200. User:
  201. class: DmUser
  202. local: dm_user_id
  203. onDelete: CASCADE
  204. foreignAlias: Groups
  205. Group:
  206. class: DmGroup
  207. local: dm_group_id
  208. onDelete: CASCADE
  209. foreignAlias: Users
  210.  
  211. DmRecordPermission:
  212. columns:
  213. secure_module: {type: string(255), notnull: true}
  214. secure_action: {type: string(255), notnull: true}
  215. secure_model: {type: string(255), notnull: true}
  216. secure_record: {type: integer(14), notnull: true}
  217. description: string(1000)
  218. relations:
  219. Users:
  220. class: DmUser
  221. local: dm_record_permission_id
  222. foreign: dm_user_id
  223. refClass: DmRecordPermissionUser
  224. foreignAlias: RecordsPermissions
  225. Groups:
  226. class: DmGroup
  227. local: dm_record_permission_id
  228. foreign: dm_group_id
  229. refClass: DmRecordPermissionGroup
  230. foreignAlias: RecordsPermissions
  231. indexes:
  232. #idx_secure_module_action_model:
  233.  
  234. ## Records Permissions Associations
  235.  
  236. DmRecordPermissionAssociation:
  237. columns:
  238. dm_secure_action:
  239. type: string(255)
  240. dm_secure_module:
  241. type: string(255)
  242. dm_secure_model:
  243. type: string(255)
  244. relations:
  245. Groups:
  246. class: DmGroup
  247. refClass: DmRecordPermissionAssociationGroup
  248. local: dm_record_permission_association_id
  249. foreign: dm_group_id
  250. foreignAlias: RecordsPermissionsAssociations
  251. Users:
  252. class: DmUser
  253. refClass: DmRecordPermissionAssociationUser
  254. local: dm_record_permission_association_id
  255. foreign: dm_user_id
  256. foreignAlias: RecordsPermissionsAssociations
  257.  
  258. DmRecordPermissionAssociationGroup:
  259. options:
  260. symfony:
  261. form: false
  262. filter: false
  263. columns:
  264. dm_group_id: { type: integer(11), notnull: true}
  265. dm_record_permission_association_id: {type: integer(11), notnull: true}
  266. relations:
  267. Association:
  268. class: DmRecordPermissionAssociation
  269. local: dm_record_permission_association_id
  270. onDelete: CASCADE
  271. foreignAlias: Groups
  272. Group:
  273. class: DmGroup
  274. local: dm_group_id
  275. onDelete: CASCADE
  276. foreignAlias: RecordsPermissionsAssociation
  277.  
  278. DmRecordPermissionAssociationUser:
  279. options:
  280. symfony:
  281. form: false
  282. filter: false
  283. columns:
  284. dm_user_id: {type: integer(11), notnull: true}
  285. dm_record_permission_association_id: {type: integer(11), notnull: true}
  286. relations:
  287. Association:
  288. class: DmRecordPermissionAssociation
  289. local: dm_record_permission_association_id
  290. onDelete: CASCADE
  291. foreignAlias: RecordsPermissionsAssociations
  292. User:
  293. class: DmUser
  294. local: dm_user_id
  295. onDelete: CASCADE
  296. foreignAlias: RecordsPermissionsAssociations
  297.  
  298. ## Records Permissions Associations
  299.  
  300.  
  301.  
  302. DmRememberKey:
  303. actAs:
  304. Timestampable:
  305. updated:
  306. disabled: true
  307. options:
  308. symfony:
  309. form: false
  310. filter: false
  311. columns:
  312. dm_user_id:
  313. type: integer
  314. remember_key: string(32)
  315. ip_address:
  316. type: string(50)
  317. primary: true
  318. relations:
  319. User:
  320. class: DmUser
  321. local: dm_user_id
  322. foreignAlias: RememberKeys
  323. foreignType: one
  324. onDelete: CASCADE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!