X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;ds=sidebyside;f=propel%2Fschema.xml;h=2d6a609892a45fe1e769285021ad0a0b8c107b18;hb=HEAD;hp=7d7e6c08b268c8d9ec7da28710792961007b50ab;hpb=e7862268051db4ebdc89d4514b62910da133d19c;p=readifood.git

diff --git a/propel/schema.xml b/propel/schema.xml
index 7d7e6c0..2d6a609 100644
--- a/propel/schema.xml
+++ b/propel/schema.xml
@@ -133,6 +133,7 @@
     <column name="beneficiary_id" type="integer" required="true"/>
     <column name="hub_id" type="integer" required="false"/>
     <column name="parcel" type="integer" required="true"/>
+    <column name="notes" type="longvarchar" lazyLoad="true"/>
     <foreign-key foreignTable="Contact" phpName="Requester" refPhpName="Requester">
       <reference local="requester_id" foreign="id"/>
     </foreign-key>
@@ -166,4 +167,50 @@
       <reference local="driver_id" foreign="id"/>
     </foreign-key>
   </table>
+
+  <!-- Session state -->
+  <table name="Session" phpName="Session" baseClass="ReadifoodObject">
+    <vendor type="mysql">
+      <parameter name="Engine" value="InnoDB"/>
+      <parameter name="Charset" value="utf8"/>
+    </vendor>
+    <column name="id" type="varchar" primaryKey="true" required="true"/>
+    <column name="data" type="longvarchar" required="true"/>
+    <column name="timestamp" type="integer" required="true"/>
+  </table>
+
+  <!-- Offer -->
+  <table name="Offer" phpName="Offer" baseClass="ReadifoodObject">
+    <vendor type="mysql">
+      <parameter name="Engine" value="InnoDB"/>
+      <parameter name="Charset" value="utf8"/>
+    </vendor>
+    <column name="id" type="integer" primaryKey="true" required="true" autoIncrement="true"/>
+    <column name="description" type="varchar" size="256" required="true"/>
+    <column name="valid_from" type="date"/>
+    <column name="valid_to" type="date"/>
+  </table>
+
+  <!-- Offer state -->
+  <table name="OfferState" phpName="OfferState" baseClass="ReadifoodObject">
+    <vendor type="mysql">
+      <parameter name="Engine" value="InnoDB"/>
+      <parameter name="Charset" value="utf8"/>
+    </vendor>
+    <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
+    <column name="updated" type="timestamp" required="true"/>
+    <column name="offer_id" type="integer" required="true"/>
+    <column name="user_id" type="integer" required="true"/>
+    <column name="contact_id" type="integer" required="true"/>
+    <column name="state" type="integer" required="true"/>
+    <foreign-key foreignTable="Offer" phpName="Offer" refPhpName="OfferState">
+      <reference local="offer_id" foreign="id"/>
+    </foreign-key>
+    <foreign-key foreignTable="User" phpName="User" refPhpName="OfferState">
+      <reference local="user_id" foreign="contact_id"/>
+    </foreign-key>
+    <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="OfferState">
+      <reference local="contact_id" foreign="id"/>
+    </foreign-key>
+  </table>
 </database>