media xPDO schema

<?xml version="1.0" encoding="UTF-8"?>
<model package="media" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
    <object class="media" table="migx_media" extends="xPDOSimpleObject" >
    <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
    <field key="description" dbtype="text" phptype="string" index="fulltext" />
    <field key="file" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
    <field key="medialist_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
    <field key="pos" dbtype="int" precision="10" phptype="integer" null="false" default="0" />

    <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    <field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
    <field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
    <field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
    <field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
    <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    <field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
    <field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
    <field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
    <field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />

    <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
        <column key="id" collation="A" null="false" />
    </index>

        <aggregate alias="MedialistItem" class="mediaList" local="medialist_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
    </object>

</model>