X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=propel%2Fschema.xml;h=1f423ddc6abe96871d1989a8ea02c65701cf981d;hb=1bfe6a5fb5a274f0d17845f0c6358f1980f89121;hp=b6a4804bdc5c18ccc7e3e0d92f214a77bb20c34e;hpb=a034b9e4d45513c3bd147e45fd969c14162fb13d;p=readifood.git

diff --git a/propel/schema.xml b/propel/schema.xml
index b6a4804..1f423dd 100644
--- a/propel/schema.xml
+++ b/propel/schema.xml
@@ -52,6 +52,7 @@
       <parameter name="Charset" value="utf8"/>
     </vendor>
     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
+    <column name="added" type="date" required="true"/>
     <column name="address_id" type="integer" required="true"/>
     <column name="forename" type="varchar" size="64" required="true"/>
     <column name="middle" type="varchar" size="128" required="true"/>
@@ -130,7 +131,7 @@
     <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"/>
     <foreign-key foreignTable="Contact" phpName="Requester" refPhpName="Requester">
       <reference local="requester_id" foreign="id"/>
     </foreign-key>
@@ -158,7 +159,7 @@
       <reference local="order_id" foreign="id"/>
     </foreign-key>
     <foreign-key foreignTable="User" phpName="User" refPhpName="OrderState">
-      <reference local="user_id" foreign="id"/>
+      <reference local="user_id" foreign="contact_id"/>
     </foreign-key>
     <foreign-key foreignTable="Contact" phpName="Driver" refPhpName="OrderState">
       <reference local="driver_id" foreign="id"/>