X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=propel%2Fschema.xml;h=7c801b4d9f2e2942acdcbc85e5dc2b77c4205a3f;hb=d11f3b9f2da834281ab505d371d4b23bae80251a;hp=78516d8750d1ed801b2d4fdf67a1f0a9d7920a17;hpb=6fdbfe32798452ec1c0fdbda57edabb892518409;p=readifood.git

diff --git a/propel/schema.xml b/propel/schema.xml
index 78516d8..7c801b4 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"/>
@@ -61,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="notes" type="longvarchar" lazyLoad="true"/>
     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Contact">
       <reference local="address_id" foreign="id"/>
     </foreign-key>
@@ -93,6 +95,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="role" type="integer" required="true"/>
     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Hub">
       <reference local="address_id" foreign="id"/>
     </foreign-key>
@@ -156,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"/>