#Schema.yml
#Schema representant la base de donnee
options:
  type: MYISAM

PokerGroup:
  columns:
    name: { type: string(32), notnull: true }

PokerUser:
  columns:
    name:          { type: string(32), notnull: true }
    first_name:    { type: string(32), notnull: true }
    email:         { type: string(255)}
    login:         { type: string(32), notnull: true, unique: true }
    password:      { type: string(32), notnull: true }
    level:         { type: integer(1), notnull: true, default: 1 }
    adress:        { type: string(32) }
    zip_code:      { type: integer(5) }
    city:          { type: string(32) }
    date_birth:    { type: string(16) }
    phone_number1: { type: string(10) }
    phone_number2: { type: string(10) }
    url_photo:     { type: string(255) }

PokerTournament:
  columns:
    name:                  { type: string(32), notnull: true }
    max_players_per_table: { type: integer(2), notnull: true }
    place:                 { type: string(32), notnull: true }
    type_reduction_tables: { type: boolean, notnull: true }
    status:                { type: integer(1) } # 0:Prévu / 1:En cours / 2:En pause / 3:Terminé
    group_id:              { type: integer(32), notnull: true }
    tournament_time:       { type: integer, notnull: true }
    description:           { type: string(4000) }
    max_players:           { type: integer(3) }
    initial_stack:         { type: integer(6) }
    url_image_sponsor:     { type: string(255) }
    text_sponsor:          { type: string(4000) }
  relations:
    PokerGroup:            { onDelete: CASCADE, local: group_id, foreign: id }

PokerRound:
  columns:
    rank:               { type: integer, primary: true }
    tournament_id:      { type: integer, primary: true }
    small_blind:        { type: integer, notnull: true }
    big_blind:          { type: integer, notnull: true }
    antes:              { type: integer, notnull: true, default: 0 }
    duration:           { type: integer, notnull: true }
  relations:
    PokerTournament:    { onDelete: CASCADE, local: tournament_id, foreign: id }

PokerBreak:
  columns:
    previous_round:     { type: integer, primary: true }
    tournament_id:      { type: integer, primary: true }
    duration:           { type: integer, notnull: true }
  relations:
    PokerTournament:    { onDelete: CASCADE, local: tournament_id, foreign: id }

PokerModerator:
  columns:
    user_id:         { type: integer, primary: true }
    tournament_id:   { type: integer, primary: true }
  relations:
    PokerUser:       { onDelete: CASCADE, local: user_id, foreign: id }
    PokerTournament: { onDelete: CASCADE, local: tournament_id, foreign: id }

PokerPlayer:
  columns:
    id:               { type: integer, autoincrement: true }
    user_id:          { type: integer, primary: true }
    tournament_id:    { type: integer, primary: true }
    position:         { type: integer }
    elimination_time: { type: integer, default: null }
    deplacement:      { type: integer, notnull: true, default: 0 }
  relations:
    PokerUser:        { onDelete: CASCADE, local: user_id, foreign: id }
    PokerTournament:  { onDelete: CASCADE, local: tournament_id, foreign: id }

PokerPlace:
  columns:
    player_id:        { type: integer, primary: true }
    user_id:          { type: integer, notnull: true }
    tournament_id:    { type: integer, notnull: true }
    table_number:     { type: integer }
    seat:             { type: integer }
  relations:
    PokerPlayer:      { onDelete: CASCADE, local: player_id, foreign: id }
    PokerUser:        { onDelete: CASCADE, local: user_id, foreign: id }
    PokerTournament:  { onDelete: CASCADE, local: tournament_id, foreign: id }

PokerMember:
  columns:
    user_id:    { type: integer(32), notnull: true, primary: true }
    group_id:   { type: integer(32), notnull: true, primary: true }
    level:      { type: boolean, notnull: true, default: 1 }
  relations:
    PokerGroup: { onDelete: CASCADE, local: group_id, foreign: id }
    PokerUser:  { onDelete: CASCADE, local: user_id, foreign: id }