X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=propel%2Fschema.xml;h=e0c3aff1aa6d7cfc831bd89afe5978dbe82ba6b2;hb=0c4f17d96c338f9e3c13293c11b1be9765804804;hp=0c35e97b8c32307b189cbc10ad7d7c6907a1d5a1;hpb=5f50c624101d671ec4147b3ad974c15178c6ebe5;p=readifood.git

diff --git a/propel/schema.xml b/propel/schema.xml
index 0c35e97..e0c3aff 100644
--- a/propel/schema.xml
+++ b/propel/schema.xml
@@ -62,6 +62,7 @@
     <column name="telephone1" type="varchar" size="32" required="true"/>
     <column name="telephone2" type="varchar" size="32" required="true"/>
     <column name="email" type="varchar" size="64" required="true"/>
+    <column name="parcel" type="integer"/>
     <column name="notes" type="longvarchar" lazyLoad="true"/>
     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Contact">
       <reference local="address_id" foreign="id"/>
@@ -131,8 +132,8 @@
     <column name="requester_id" type="integer" required="true"/>
     <column name="beneficiary_id" type="integer" required="true"/>
     <column name="hub_id" type="integer" required="false"/>
-    <column name="quantity" type="integer" required="true"/>
     <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,15 @@
       <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>
 </database>