From a628fd3084e94959dc29c86912f2a2e97038799c Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Mon, 14 Oct 2013 21:54:23 +0200 Subject: More model tuning --- app/model.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'app') 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) -- cgit v1.2.3-54-g00ecf