sfGuardUserProfile:
  tableName: sf_guard_user_profile
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    user_id:
      type: integer(4)
      notnull: true
    email:
      type: string(80)
    fullname:
      type: string(80)
    validate:
      type: string(17)
  # Don't forget this!
  relations:
    User:
      class: sfGuardUser
      foreign: id
      local: user_id
      type: one
      onDelete: cascade
      foreignType: one
      foreignAlias: Profile

CoopProject:
  actAs:
    Timestampable: ~
    Taggable:		 		~
  columns:
    id:  					{ type: integer(4), primary: true, notnull: true, autoincrement: true }
    name:        	{ type: string(255), notnull: true }
  indexes:
    project_name:
      fields: [name]
      type: unique

CoopStore:
  actAs:
    Timestampable: ~
    Taggable:		 		~
  columns:
    id:  					{ type: integer(4), primary: true, notnull: true, autoincrement: true }
    project_id:		{ type: integer(4), notnull: true}
    name:        	{ type: string(255), notnull: true }
    url:					{ type: string(255), notnull: true }
    type:					{ type: string(255) }
  relations:
    CoopProject: 	{ onDelete: CASCADE, local: project_id, foreign: id, foreignAlias: Stores }

CoopStoreItem:
  actAs:
    Timestampable: ~
    Taggable:		 		~
  columns:
    id:  					{ type: integer(4), primary: true, notnull: true, autoincrement: true}
    store_id:  		{ type: integer(4), notnull: true }
    parent_id:		{ type: integer(4)}
    name:					{ type: string(255), notnull: true }
    type:  				{ type: string(255)}
    last_rev: 		{ type: integer(64)}
    modified_at:	{ type: datetime()}
  relations:
    CoopStore:   		{ onDelete: CASCADE, local: store_id, foreign: id, foreignAlias: StoreItems }

CoopAccess:
  actAs:
    Timestampable: ~
  columns:
    project_id: 	{ type: integer(4), notnull: true }
    user_id:  		{ type: integer(4), notnull: true }
    status:       { type: integer(4)}
  relations:
    sfGuardUser:  { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: Access }
    CoopProject: 	{ onDelete: CASCADE, local: project_id, foreign: id, foreignAlias: Access }
  indexes:
    user_project_index:
      fields: [project_id,user_id]
      type: unique

CoopCredential:
  actAs:
    Timestampable: ~
  columns:
    store_id:			{ type: integer(4)}
    user_id:				{ type: integer(4)}
    username:			{ type: string(255)}
    password:			{ type: string(255)}
    is_generic:  	{ type: bool()}
    do_crawl:  	  { type: bool()}
    is_public: 	  { type: bool()}
  relations:
    CoopStore:  	{ onDelete: CASCADE, local: store_id, foreign: id, foreignAlias: Credentials }
    sfGuardUser:  { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: Access }
    sfGuardUsers: { class: sfGuardUser, local: credential_id, foreign:user_id, refClass: CoopCredentialLink, foreignAlias: Credentials }

CoopCredentialLink:
  actAs:
    Timestampable: ~
  columns:
    id:  						{ type: integer(4), primary: true, notnull: true, autoincrement: true }
    user_id:				{ type: integer(4)}
    credential_id:  { type: integer()}
  relations:
    CoopCredential:	{ local: credential_id, foreignAlias: CredentialLinks }
    sfGuardUser:  	{ local: user_id, foreignAlias: CredentialLinks }

CoopItemSeen:
  actAs:
    Timestampable: ~
  columns:
    store_item_id:  { type: integer(4), notnull: true }
    user_id:  			{ type: integer(4), notnull: true }
    rev:       			{ type: integer(4), notnull: true, default: 0}
  relations:
    sfGuardUser:  	{ onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: ItemSeen }
    CoopStoreItem:  	{ onDelete: CASCADE, local: store_item_id, foreign: id, foreignAlias: ItemSeen, foreignType: many}

CoopComment:
  actAs:
    Timestampable: ~
  columns:
    store_item_id:  { type: integer(4), notnull: true }
    user_id:  			{ type: integer(4), notnull: true }
    body:         	{ type: text }
  relations:
    sfGuardUser:  	{ onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: UserComments }
    CoopStoreItem:  	{ onDelete: CASCADE, local: store_item_id, foreign: id, foreignAlias: ItemComments }

CoopItemState:
  actAs:
    Timestampable: ~
  columns:
    store_item_id:  { type: integer(4), notnull: true }
    user_id:  			{ type: integer(4), notnull: true }
    state:        	{ type: integer(4)}
  relations:
    sfGuardUser:  	{ onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: ItemState }
    CoopStoreItem:  	{ onDelete: CASCADE, local: store_item_id, foreign: id, foreignAlias: ItemState }