From 7bb05e12bf767ff0e9894ac984bc36b244bcfcb9 Mon Sep 17 00:00:00 2001 From: emkael Date: Sat, 12 Mar 2016 12:07:11 +0100 Subject: * composite primary key for user preference table --- app/python/rcal/model.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/app/python/rcal/model.py b/app/python/rcal/model.py index 705fba2..3ecfceb 100644 --- a/app/python/rcal/model.py +++ b/app/python/rcal/model.py @@ -124,9 +124,11 @@ class Category(BASE): user_selections = Table( 'user_selections', BASE.metadata, Column('_user', Integer, - ForeignKey('users.id', onupdate='CASCADE', ondelete='CASCADE')), + ForeignKey('users.id', onupdate='CASCADE', ondelete='CASCADE'), + primary_key=True), Column('_calendar', String(255), - ForeignKey('calendars.uid', onupdate='CASCADE', ondelete='CASCADE')) + ForeignKey('calendars.uid', onupdate='CASCADE', ondelete='CASCADE'), + primary_key=True) ) -- cgit v1.2.3