diff options
Diffstat (limited to 'app')
| -rw-r--r-- | app/model.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/app/model.py b/app/model.py index 28de237..414cfd0 100644 --- a/app/model.py +++ b/app/model.py @@ -60,7 +60,7 @@ class User (Model): class Category (Model): name = ReqColumn(db.Unicode(50), unique = True) - user_id = Column(db.Integer, db.ForeignKey(User.id)) + user_id = ReqColumn(db.Integer, db.ForeignKey(User.id)) parent_id = Column(db.Integer, db.ForeignKey('category.id')) children = db.relationship('Category', @@ -180,5 +180,5 @@ class MonthExpense (namedtuple('MonthExpense', 'date catexps')): # Extra indizes have to be here # -db.Index('idx_single_date', SingleExpense.year, SingleExpense.month) -db.Index('idx_start_end', ConstExpense.start, ConstExpense.end) +db.Index('idx_single_date', SingleExpense.user_id, SingleExpense.year, SingleExpense.month) +db.Index('idx_start_end', ConstExpense.user_id, ConstExpense.start, ConstExpense.end) |