Advertisement
Guest User

Untitled

a guest
Jun 11th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.45 KB | None | 0 0
  1. sfGuardUser:
  2. actAs:
  3. Timestampable: ~
  4. columns:
  5. id:
  6. type: integer(4)
  7. primary: true
  8. autoincrement: true
  9. username:
  10. type: string(128)
  11. notnull: true
  12. unique: true
  13. algorithm:
  14. type: string(128)
  15. default: sha1
  16. notnull: true
  17. salt:
  18. type: string(128)
  19. password:
  20. type: string(128)
  21. is_active:
  22. type: boolean
  23. default: 1
  24. is_super_admin:
  25. type: boolean
  26. default: false
  27. last_login:
  28. type: timestamp
  29. indexes:
  30. is_active_idx:
  31. fields: [is_active]
  32.  
  33. sfGuardUserProfile:
  34. inheritance:
  35. type: simple
  36. extends: sfGuardUserProfileBasis
  37. # Don't forget this!
  38. columns:
  39. date_birth: {type: date }
  40. gender: { type: string(12)}
  41. nif: { type: string(12), notnull: true}
  42. address: { type: string(150) }
  43. city: { type: string(50), notnull: true}
  44. province: { type: string(50), notnull: true}
  45. zip_code: { type: string(8), notnull: true}
  46. country: { type: string(50)}
  47. telephone: { type: string(15), notnull: true }
  48. mobile: { type: string(15) }
  49. professional: { type: boolean,default:false }
  50. relations:
  51. User:
  52. class: sfGuardUser
  53. foreign: id
  54. local: user_id
  55. type: one
  56. onDelete: cascade
  57. foreignType: one
  58. foreignAlias: Profile
  59. DcFenixNewsletterSubscriptor:
  60. local: id
  61. foreign: user_id
  62. foreignAlias: Profile
  63.  
  64. DcFenixNewsletterSubscriberList:
  65. tableName: fenix_newsletter_suscriber_list
  66. actAs: { Timestampable: ~ }
  67. columns:
  68. name: { type: string(4000), notnull: true }
  69. description: { type: string(4000), notnull: true }
  70. relations:
  71. DcFenixNewsletterSubscriptor:
  72. local: id
  73. foreign: list_id
  74. foreignAlias: SubscriberList
  75.  
  76.  
  77.  
  78.  
  79. DcFenixNewsletterSubscriptor:
  80. tableName: fenix_newsletter_subscriptor
  81. columns:
  82. user_id: {type: integer, notnull: true, primary: true}
  83. list_id: {type: integer, notnull: true, primary: true}
  84.  
  85.  
  86.  
  87.  
  88. DcFenixNewsletterActivitySubscriptor:
  89. tableName: fenix_newsletter_activity_subscriptor
  90. actAs: { Timestampable: created }
  91. columns:
  92. subscriptor_id: { type: integer}
  93. status: { type: boolean, notnull: true, default: 0 }
  94. relations:
  95. sfGuardUserProfile:
  96. local: id
  97. foreign: id
  98. type: many
  99. foreignType: one
  100. foreignAlias: SubscriberActivity
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement