gistfile1.yml

options:
  collate: utf8_unicode_ci
  charset: utf8
  type: InnoDB

Profile:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    user_id: { type: integer, notnull: true }
    age: { type: integer }
  relations:
    sfGuardUser: { onDelete: CASCADE, onUpdate: CASCADE, local: user_id, foreign: id, foreignAlias: Profile, foreignType: one}

Team:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string(255), unique: true }
    description: { type: string }
  relations:
    Users:
      class: sfGuardUser
      refClass: TeamUser
      local: team_id
      foreign: user_id
      foreignAlias: Team

TeamUser:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    user_id: { type: integer, primary: true }
    team_id: { type: integer, primary: true }
  relations:
    User: { class: sfGuardUser, local: user_id, onUpdate: CASCADE }
    Team: { local: group_id, onUpdate: CASCADE }

Lan:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    administrator_id: { type: integer }
    location: { type: string }
    start_date: { type: timestamp }
    end_date: { type: timestamp }
  relations:
    Administrator: { class: sfGuardUser, local: administrator_id, onUpdate: CASCADE }
    

Tournament:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    lan_id: { type: integer }
    game_id: { type: integer }
    game_mode_id: { type: integer }
    price: { type: decimal }
    places: { type: integer }
  relations:
    Lan: { local: lan_id, onUpdate: CASCADE }
    Game: { local: game_id, onUpdate: CASCADE }
    GameMode: { local: game_mode_id, onUpdate: CASCADE }

Game:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string }

GameMode:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string }

Payment:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    lan_id: { type: integer }
    user_id: { type: integer }
    date: { type: timestamp }
    montant: { type: decimal }

Sponsors:
  connection: doctrine
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string }
    logo: { type: string }
    url: { type: string }