All pastes #587870 Raw Edit

Anonymous

public text v1 · immutable
#587870 ·published 2007-06-25 04:37 UTC
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>