Mine

<?xml version="1.0" encoding="UTF-8" ?>  <database name="propel" defaultIdMethod="native" noxsd="true" package="lib.model">    <table name="ask_question" phpName="Question">      <column name="id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/>      <column name="ask_user_id" type="INTEGER" required="true"/>      <column name="title" type="LONGVARCHAR" required="true"/>      <column name="body" type="LONGVARCHAR" required="true"/>      <column name="created_at" type="TIMESTAMP" required="true"/>      <column name="updated_at" type="TIMESTAMP" required="true"/>      <foreign-key foreignTable="ask_user" name="ask" onDelete="restrict">        <reference local="ask_user_id" foreign="id"/>      </foreign-key>    </table>    <table name="ask_user" phpName="User">      <column name="id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/>      <column name="nickname" type="VARCHAR" size="50" required="true"/>      <column name="first_name" type="VARCHAR" size="100" required="true"/>      <column name="last_name" type="VARCHAR" size="100" required="true"/>      <column name="created_at" type="TIMESTAMP" required="true"/>      <unique name="ask_user_nickname">        <unique-column name="nickname"/>      </unique>    </table>    <table name="ask_answer" phpName="Answer">      <column name="id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/>      <column name="ask_user_id" type="INTEGER" required="true"/>      <column name="ask_question_id" type="INTEGER" required="true"/>      <column name="body" type="LONGVARCHAR" required="true"/>      <column name="created_at" type="TIMESTAMP" required="true"/>      <foreign-key foreignTable="ask_user" name="provides" onDelete="restrict">        <reference local="ask_user_id" foreign="id"/>      </foreign-key>      <foreign-key foreignTable="ask_question" name="Rel_08" onDelete="restrict">        <reference local="ask_question_id" foreign="id"/>      </foreign-key>    </table>    <table name="ask_relevancy" phpName="Relevancy">      <column name="ask_user_id" type="INTEGER" required="true"/>      <column name="ask_answer_id" type="INTEGER" required="true"/>      <column name="score" type="INTEGER" required="true"/>      <column name="created_at" type="TIMESTAMP" required="true"/>      <foreign-key foreignTable="ask_user" name="determines" onDelete="restrict">        <reference local="ask_user_id" foreign="id"/>      </foreign-key>      <foreign-key foreignTable="ask_answer" name="Rel_04" onDelete="restrict">        <reference local="ask_answer_id" foreign="id"/>      </foreign-key>    </table>    <table name="ask_interest" phpName="Interest">      <column name="ask_user_id" type="INTEGER" required="true"/>      <column name="ask_question_id" type="INTEGER" required="true"/>      <column name="created_at" type="TIMESTAMP" required="true"/>      <foreign-key foreignTable="ask_question" name="generates" onDelete="restrict">        <reference local="ask_question_id" foreign="id"/>      </foreign-key>      <foreign-key foreignTable="ask_user" name="has" onDelete="restrict">        <reference local="ask_user_id" foreign="id"/>      </foreign-key>    </table></database>