<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
  <entity name="Lyrics" table="lyrics">
    <indexes>
      <index name="user_id" columns="user_id"/>
      <index name="section_id" columns="section_id"/>
      <index name="type_article_id" columns="type_article_id"/>
      <index name="lyrics_ibfk_4" columns="artiste_id"/>
    </indexes>
    <id name="id" type="integer" column="id">
      <generator strategy="IDENTITY"/>
    </id>
    <field name="albumId" type="integer" column="album_id" nullable="true"/>
    <field name="titre" type="string" column="titre" length="255" nullable="false"/>
    <field name="artiste" type="string" column="artiste" length="255" nullable="false"/>
    <field name="son" type="string" column="son" length="255" nullable="false"/>
    <field name="featuring" type="string" column="featuring" length="255" nullable="true"/>
    <field name="media" type="string" column="media" length="255" nullable="true"/>
    <field name="texte" type="text" column="texte" nullable="false"/>
    <field name="vues" type="integer" column="vues" nullable="false"/>
    <field name="vuesDif" type="integer" column="vues_dif" nullable="false"/>
    <field name="date" type="datetime" column="date" nullable="false"/>
    <field name="image" type="string" column="image" length="255" nullable="false"/>
    <field name="duration" type="integer" column="duration" nullable="false"/>
    <field name="facebook" type="integer" column="facebook" nullable="false"/>
    <field name="twitter" type="integer" column="twitter" nullable="false"/>
    <field name="lastIp" type="string" column="last_ip" length="255" nullable="true"/>
    <field name="lastVisit" type="datetime" column="last_visit" nullable="true"/>
    <field name="likes" type="integer" column="likes" nullable="false"/>
    <field name="dislikes" type="integer" column="dislikes" nullable="false"/>
    <field name="score" type="float" column="score" precision="10" scale="0" nullable="false"/>
    <field name="ip" type="string" column="ip" length="255" nullable="true"/>
    <field name="slug" type="string" column="slug" length="255" nullable="false"/>
    <field name="vide" type="boolean" column="vide" nullable="false"/>
    <many-to-one field="typeArticle" target-entity="TypeArticle">
      <join-columns>
        <join-column name="type_article_id" referenced-column-name="id"/>
      </join-columns>
    </many-to-one>
    <many-to-one field="section" target-entity="Section">
      <join-columns>
        <join-column name="section_id" referenced-column-name="id"/>
      </join-columns>
    </many-to-one>
    <many-to-one field="user" target-entity="User">
      <join-columns>
        <join-column name="user_id" referenced-column-name="id"/>
      </join-columns>
    </many-to-one>
    <many-to-one field="artiste2" target-entity="Artiste">
      <join-columns>
        <join-column name="artiste_id" referenced-column-name="id"/>
      </join-columns>
    </many-to-one>
  </entity>
</doctrine-mapping>
