From c21e346659666a41242e6f7c34cea6bf2a82f12c Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.net>
Date: Tue, 15 Feb 2011 14:34:55 +0100
Subject: model update

---
 model.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/model.py b/model.py
index 9c04e83..e9ee2be 100644
--- a/model.py
+++ b/model.py
@@ -79,7 +79,7 @@ class ConstExpense (Expense):
     start   = ReqField(T.Date, index = True)
     end     = ReqField(T.Date, index = True)
 
-    prev = ManyToOne('ConstExpense')
+    prev = ManyToOne('ConstExpense', ondelete = "SET NULL")
     next = OneToOne('ConstExpense', inverse = 'prev')
     
     monthly = ColumnProperty(lambda c: sql.cast(c.expense / c.months, ExpNum))
@@ -135,6 +135,7 @@ session = elixir.session
 #
 
 Index('idx_single_date', SingleExpense.year, SingleExpense.month)
+Index('idx_start_end', ConstExpense.start, ConstExpense.end)
 
 if __name__ == "__main__":
     elixir.create_all()
-- 
cgit v1.2.3-54-g00ecf