rendered paste body<?xml version="1.0" encoding="UTF-8"?>
<database name="propel" defaultIdMethod="native" noxsd="true">
<table name="warrior4peace" phpName="Warrior">
<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
<column name="title" type="varchar" size="100"/>
<column name="first_name" type="varchar" size="100" />
<column name="last_name" type="varchar" size="100" />
<column name="user_id" type="integer" />
<column name="created_at" type="timestamp" />
<column name="updated_at" type="timestamp" />
<column name="flagged" type="tinyint" />
</table>
<table name="warrior_stat" phpName="WarriorStat">
<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
<foreign-key foreignTable="warrior4peace">
<reference local="war_id" foreign="id" />
</foreign-key>
<column name="gender" type="varchar" size="2" />
<column name="nickname" type="varchar" size="50" />
<column name="bio" type="longvarchar" />
<column name="country" type="varchar" size="100" />
<column name="user_id" type="integer" />
<column name="created_at" type="timestamp" />
<column name="updated_at" type="timestamp" />
</table>
<table name="warrior_quote" phpName="WarriorQuote">
<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
<foreign-key foreignTable="warrior4peace">
<reference local="war_id" foreign="id" />
</foreign-key>
<column name="quote" type="longvarchar" size="1500" />
<column name="sig" type="varchar" size="100" />
<column name="category" type="varchar" size="100" />
<column name="orig_date" type="timestamp" />
<column name="user_id" type="integer" />
<column name="created_at" type="timestamp" />
<column name="updated_at" type="timestamp" />
</table>
<table name="warrior_image" phpName="WarriorImage">
<column name="img_id" type="integer" required="true" primaryKey="true"/>
<foreign-key foreignTable="warrior4peace">
<reference local="war_id" foreign="id" />
</foreign-key>
<column name="user_id" type="integer" />
<column name="created_at" type="timestamp" />
</table>
<table name="images" phpName="Images">
<column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true" />
<column name="img" type="blob" />
<column name="keywords" type="varchar" size="512" />
</table>
</database>