From d1dbc50a1c88282df24aafa7e82b334436b02ed8 Mon Sep 17 00:00:00 2001
From: ken restivo <ken@restivo.org>
Date: Sun, 8 Nov 2015 22:14:15 -0800
Subject: Manually document account_id link for schemaSpy.

---
 hubzilla_er/zot.xml | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'hubzilla_er')

diff --git a/hubzilla_er/zot.xml b/hubzilla_er/zot.xml
index f33e273eb..c1450b4fc 100644
--- a/hubzilla_er/zot.xml
+++ b/hubzilla_er/zot.xml
@@ -328,7 +328,9 @@
             <child column="channel_id" foreignKey="Implied Constraint" implied="true" onDeleteCascade="false" table="mail"/>
             <child column="channel_id" foreignKey="Implied Constraint" implied="true" onDeleteCascade="false" table="profext"/>
          </column>
-         <column autoUpdated="false" defaultValue="0" digits="0" id="1" name="channel_account_id" nullable="false" remarks="" size="10" type="INT UNSIGNED"/>
+         <column autoUpdated="false" defaultValue="0" digits="0" id="1" name="channel_account_id" nullable="false" remarks="" size="10" type="INT UNSIGNED">
+		       <foreignKey table="account" column="account_id"/>
+		 </column>
          <column autoUpdated="false" defaultValue="0" digits="0" id="2" name="channel_primary" nullable="false" remarks="" size="0" type="BIT"/>
          <column autoUpdated="false" defaultValue="" digits="0" id="3" name="channel_name" nullable="false" remarks="" size="255" type="CHAR"/>
          <column autoUpdated="false" defaultValue="" digits="0" id="4" name="channel_address" nullable="false" remarks="" size="255" type="CHAR"/>
-- 
cgit v1.2.3