hooks/syncschema.py
changeset 10201 989bbadbcd8d
parent 10200 cceb2c7c02f4
child 10250 582301c2c8ca
--- a/hooks/syncschema.py	Thu Jan 15 16:44:36 2015 +0100
+++ b/hooks/syncschema.py	Thu Jan 15 16:49:32 2015 +0100
@@ -72,7 +72,7 @@
     table = SQL_PREFIX + etype
     column = SQL_PREFIX + rtype
     try:
-        cnx.system_sql(str('ALTER TABLE %s ADD %s integer' % (table, column)),
+        cnx.system_sql(str('ALTER TABLE %s ADD %s integer REFERENCES entities (eid)' % (table, column)),
                        rollback_on_failure=False)
         cnx.info('added column %s to table %s', column, table)
     except Exception: