gistfile1.txt

<!-- BEGIN: ROLE.orm.xml -->

<?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 repository-class="Dubture\PlansinnBundle\Entity\RoleRepository" name="Dubture\PlansinnBundle\Entity\Role" table="plansinn__role">
    <change-tracking-policy>DEFERRED_IMPLICIT</change-tracking-policy>
    <id name="id" type="integer" column="id">
      <generator strategy="AUTO"/>
    </id>
    <field name="name" type="string" column="name" length="255"/>
    
    <many-to-many field="users" target-entity="Application\Sonata\UserBundle\Entity\User" inversed-by="psroles">
        <join-table name="role__role_user">
                <join-columns>
                    <join-column name="user_id" referenced-column-name="id"/>
                </join-columns>
                <inverse-join-columns>
                    <join-column name="psrole_id" referenced-column-name="id"/>
                </inverse-join-columns>        
        </join-table>
    </many-to-many>
    
    <lifecycle-callbacks/>
  </entity>
</doctrine-mapping>

<!-- END: ROLE.orm.xml -->

<!-- BEGIN: USER.orm.xml -->

<?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="Application\Sonata\UserBundle\Entity\User" table="fos_user_user">

        <id name="id" column="id" type="integer">
            <generator strategy="AUTO" />
        </id>
        
        <field name="firstname" type="string" column="firstname" length="255" nullable="true"/>
        <field name="lastname" type="string" column="lastname" length="255" nullable="true"/>
        <field name="title" type="string" column="title" length="255" nullable="true"/>
        <field name="birthdate" type="integer" column="birthdate" nullable="true"/>
        <field name="birthplace" type="string" column="birthplace" length="255" nullable="true"/>
        <field name="description" type="text" column="description" nullable="true"/>
        <field name="phone" type="string" column="phone" length="255" nullable="true"/>
        
	    <one-to-many field="translations"
	        target-entity="Application\Sonata\UserBundle\Entity\UserTranslation"
	        mapped-by="translatable">
	        <cascade>
	            <cascade-persist />
	        </cascade>
	    </one-to-many>
        
        <many-to-many field="projects" mapped-by="users" target-entity="Dubture\PlansinnBundle\Entity\Project"/>
        <many-to-many field="psroles" mapped-by="users" target-entity="Dubture\PlansinnBundle\Entity\Role"/>
    </entity>

</doctrine-mapping>

<!-- END: USER.orm.xml -->