sfGuardUserProfile:
  tableName: sf_guard_user_profile
  columns:
    user_id: { type: integer(4), notnull: true }
    email: { type: string(255) }
    name: { type: string(255) }
  relations:
    User:
      class: sfGuardUser
      local: user_id
      foreign: id
      foreignAlias: Profile
      onDelete: CASCADE
    Bookclubs:
      class: Bookclub
      refClass: Membership
      foreignAlias: Users

#User:
#    tableName: users
#    columns:
#        email: { type: string(255), notnull: true, unique: true }
#        name: { type: string(255), notnull: true }
#        password: { type: string(255), notnull: true }
#    relations:
#        Bookclubs:
#            class: Bookclub
#            refClass: Membership
#            foreignAlias: Users

Bookclub:
    tableName: bookclubs
    columns:
        name: { type: string(255), notnull: true, unique: true }
    relations:
        Users:
            class: sfGuardUser
            refClass: Membership
            foreignAlias: Bookclubs

Membership:
    tableName: memberships
    columns:
        user_id: { type: integer, notnull: true }
        bookclub_id: { type: integer, notnull: true }
        is_admin: { type: boolean, notnull: true }
    relations:
        sfGuardUserProfile:
            foreignAlias: Memberships
        Bookclub:
            foreignAlias: Memberships

Wallpost:
    tableName: wallposts
    actAs: { Timestampable: ~ }
    columns:
        user_id: { type: integer, notnull: true }
        bookclub_id: { type: integer, notnull: true }
        message: { type: string(255), notnull: true }
    relations:
        sfGuardUserProfile:
            foreignAlias: Wallposts
        Bookclub:
            foreignAlias: Wallposts

Blogpost:
    tableName: blogposts
    actAs: { Timestampable: ~ }
    columns:
        user_id: { type: integer, notnull: true }
        post: { type: string(10000), notnull: true }
    relations:
        sfGuardUserProfile:
            foreignAlias: Blogposts

Newspost:
    tableName: newsposts
    actAs: { Timestampable: ~ }
    columns:
        user_id: { type: integer, notnull: true }
        post: { type: string(10000), notnull: true }
    relations:
        sfGuardUserProfile:
            foreignAlias: Newsposts

Article:
    tableName: articles
    actAs: { Timestampable: ~ }
    columns:
        author: { type: string(255), notnull: true }
        title: { type: string(255), notnull: true }
        article: { type: string(10000), notnull: true }