summaryrefslogtreecommitdiff
path: root/test/tables.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/tables.py')
-rw-r--r--test/tables.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/test/tables.py b/test/tables.py
index c0cdc4397..9bf1c8acb 100644
--- a/test/tables.py
+++ b/test/tables.py
@@ -30,14 +30,14 @@ addresses = Table('email_addresses', db,
orders = Table('orders', db,
Column('order_id', INT, primary_key = True),
- Column('user_id', INT),
+ Column('user_id', INT, foreign_key = ForeignKey(users.c.user_id)),
Column('description', VARCHAR(50)),
Column('isopen', INT)
)
orderitems = Table('items', db,
Column('item_id', INT, primary_key = True),
- Column('order_id', INT),
+ Column('order_id', INT, foreign_key = ForeignKey(orders.c.order_id)),
Column('item_name', VARCHAR(50))
)