SHARE
TWEET

Untitled

a guest Aug 18th, 2018 142 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. sfGuardUserProfile:
  2.   tableName: sf_guard_user_profile
  3.   columns:
  4.     id:
  5.       type: integer(4)
  6.       primary: true
  7.       autoincrement: true
  8.     user_id:
  9.       type: integer(4)
  10.       notnull: true
  11.     email:
  12.       type: string(80)
  13.     fullname:
  14.       type: string(80)
  15.     validate:
  16.       type: string(17)
  17.   # Don't forget this!
  18.   relations:
  19.     User:
  20.       class: sfGuardUser
  21.       foreign: id
  22.       local: user_id
  23.       type: one
  24.       onDelete: cascade
  25.       foreignType: one
  26.       foreignAlias: Profile
  27.  
  28. CoopProject:
  29.   actAs:
  30.     Timestampable: ~
  31.     Taggable:               ~
  32.   columns:
  33.     id:                     { type: integer(4), primary: true, notnull: true, autoincrement: true }
  34.     name:           { type: string(255), notnull: true }
  35.   indexes:
  36.     project_name:
  37.       fields: [name]
  38.       type: unique
  39.  
  40. CoopStore:
  41.   actAs:
  42.     Timestampable: ~
  43.     Taggable:               ~
  44.   columns:
  45.     id:                     { type: integer(4), primary: true, notnull: true, autoincrement: true }
  46.     project_id:     { type: integer(4), notnull: true}
  47.     name:           { type: string(255), notnull: true }
  48.     url:                    { type: string(255), notnull: true }
  49.     type:                   { type: string(255) }
  50.   relations:
  51.     CoopProject:    { onDelete: CASCADE, local: project_id, foreign: id, foreignAlias: Stores }
  52.  
  53. CoopStoreItem:
  54.   actAs:
  55.     Timestampable: ~
  56.     Taggable:               ~
  57.   columns:
  58.     id:                     { type: integer(4), primary: true, notnull: true, autoincrement: true}
  59.     store_id:       { type: integer(4), notnull: true }
  60.     parent_id:      { type: integer(4)}
  61.     name:                   { type: string(255), notnull: true }
  62.     type:               { type: string(255)}
  63.     last_rev:       { type: integer(64)}
  64.     modified_at:    { type: datetime()}
  65.   relations:
  66.     CoopStore:          { onDelete: CASCADE, local: store_id, foreign: id, foreignAlias: StoreItems }
  67.  
  68. CoopAccess:
  69.   actAs:
  70.     Timestampable: ~
  71.   columns:
  72.     project_id:     { type: integer(4), notnull: true }
  73.     user_id:        { type: integer(4), notnull: true }
  74.     status:       { type: integer(4)}
  75.   relations:
  76.     sfGuardUser:  { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: Access }
  77.     CoopProject:    { onDelete: CASCADE, local: project_id, foreign: id, foreignAlias: Access }
  78.   indexes:
  79.     user_project_index:
  80.       fields: [project_id,user_id]
  81.       type: unique
  82.  
  83. CoopCredential:
  84.   actAs:
  85.     Timestampable: ~
  86.   columns:
  87.     store_id:           { type: integer(4)}
  88.     user_id:                { type: integer(4)}
  89.     username:           { type: string(255)}
  90.     password:           { type: string(255)}
  91.     is_generic:     { type: bool()}
  92.     do_crawl:     { type: bool()}
  93.     is_public:    { type: bool()}
  94.   relations:
  95.     CoopStore:      { onDelete: CASCADE, local: store_id, foreign: id, foreignAlias: Credentials }
  96.     sfGuardUser:  { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: Access }
  97.     sfGuardUsers: { class: sfGuardUser, local: credential_id, foreign:user_id, refClass: CoopCredentialLink, foreignAlias: Credentials }
  98.    
  99. CoopCredentialLink:
  100.   actAs:
  101.     Timestampable: ~
  102.   columns:
  103.     id:                         { type: integer(4), primary: true, notnull: true, autoincrement: true }
  104.     user_id:                { type: integer(4)}
  105.     credential_id:  { type: integer()}
  106.   relations:
  107.     CoopCredential: { local: credential_id, foreignAlias: CredentialLinks }
  108.     sfGuardUser:    { local: user_id, foreignAlias: CredentialLinks }
  109.    
  110. CoopItemSeen:
  111.   actAs:
  112.     Timestampable: ~
  113.   columns:
  114.     store_item_id:  { type: integer(4), notnull: true }
  115.     user_id:            { type: integer(4), notnull: true }
  116.     rev:                { type: integer(4), notnull: true, default: 0}
  117.   relations:
  118.     sfGuardUser:    { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: ItemSeen }
  119.     CoopStoreItem:      { onDelete: CASCADE, local: store_item_id, foreign: id, foreignAlias: ItemSeen, foreignType: many}
  120.  
  121. CoopComment:
  122.   actAs:
  123.     Timestampable: ~
  124.   columns:
  125.     store_item_id:  { type: integer(4), notnull: true }
  126.     user_id:            { type: integer(4), notnull: true }
  127.     body:           { type: text }
  128.   relations:
  129.     sfGuardUser:    { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: UserComments }
  130.     CoopStoreItem:      { onDelete: CASCADE, local: store_item_id, foreign: id, foreignAlias: ItemComments }
  131.  
  132. CoopItemState:
  133.   actAs:
  134.     Timestampable: ~
  135.   columns:
  136.     store_item_id:  { type: integer(4), notnull: true }
  137.     user_id:            { type: integer(4), notnull: true }
  138.     state:          { type: integer(4)}
  139.   relations:
  140.     sfGuardUser:    { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: ItemState }
  141.     CoopStoreItem:      { onDelete: CASCADE, local: store_item_id, foreign: id, foreignAlias: ItemState }
RAW Paste Data
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
 
Top