# config/doctrine/schema.yml
Reve:
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer(4)
      unsigned: true
      autoincrement: true
      primary: true
    reve:
      type: text
      notnull: true
    auteur:
      type: integer(4)
      notnull: true
    categorie:
      type: integer(4)
      unsigned: true
      notnull: true
    nbVotePlus:
      type: integer(4)
      notnull: true
      default: 0
    nbVoteMoins:
      type: integer(4)
      notnull: true
      default: 0
    ratio:
      type: double
      notnull: true
      default: 0
      comment: 'ratio de nbVotePlus/nbVoteMoins'
    etat:
      type: enum
      values: [0, 1, 2, 3]
      notnull: true
      default: 0
      comment: '0:creation ; 1: en moderation; 2 : accept� : 3 : supprimer'
  relations:
    Categorie:
      local: categorie
      foreign: id
      foreignAlias: Reves
  indexes:
    myindex:
      fields: [categorie]

RevesVote:
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer(4)
      unsigned: true
      primary: true
    id_reve:
      type: integer(4)
      unsigned: true
      unique: true
    vote_ip:
      type: string(40)
      notnull: true
      unique: true
    vote_user:
      type: integer(4)
      notnull: true
      default: 0
      unique: true
  relations:
    Reve:
      local: id_reve
      foreign: id
      foreignAlias: Votes
  indexes:
    myindex:
      fields: [id_reve]

Utilisateur:
  actAs:
    Timestampable: ~
  columns:
    id:
      type: integer(4)
      unsigned: true
      autoincrement: true
      primary: true
    username:
      type: string(18)
      notnull: true
    password:
      type: string(40)
      notnull: true
    email:
      type: string(255)
      notnull: true
    grade:
      type: enum
      values: [0, 1, 2, 9]
      notnull: true
      comment: '0 : Utilisateur, 1 : Membres, 2 : Moderateurs, 9 : Admin'
    lang:
      type: string(50)
      notnull: true
      default: 'francais'
    nbVotePlus:
      type: integer(11)
      notnull: true
      default: 0
    nbVoteMoins:
      type: integer(11)
      notnull: true
      default: 0

Categorie:
  actAs:
    Timestampable: ~
    Sluggable:
      fields: [name]
  columns:
    id:
      type: integer(4)
      unsigned: true
      autoincrement: true
      primary: true
    name:
      type: string(22)
      notnull: true
  relations:
    Reve:
      local: id
      foreign: categorie
      foreignAlias: Categories
  indexes:
    myindex:
      fields: [id]