diff options
| author | René 'Necoro' Neumann <necoro@necoro.net> | 2013-10-14 21:54:23 +0200 |
|---|---|---|
| committer | René 'Necoro' Neumann <necoro@necoro.net> | 2013-10-14 21:59:53 +0200 |
| commit | a628fd3084e94959dc29c86912f2a2e97038799c (patch) | |
| tree | 4c8ae571f6a06c9cfc232f25d0f6537450dcf4cd /app | |
| parent | 90e314801666de75335c5d6dd35a50571b765f61 (diff) | |
| download | kosten-a628fd3084e94959dc29c86912f2a2e97038799c.tar.gz kosten-a628fd3084e94959dc29c86912f2a2e97038799c.tar.bz2 kosten-a628fd3084e94959dc29c86912f2a2e97038799c.zip | |
More model tuning
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) |