From d6e6803ebcd75763d243404af5d8c3dfcb2ba8a9 Mon Sep 17 00:00:00 2001 From: Aurélien Bompard Date: Fri, 24 May 2013 11:15:45 +0200 Subject: Add some database indices --- hyperkitty/models.py | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'hyperkitty/models.py') diff --git a/hyperkitty/models.py b/hyperkitty/models.py index 00882cc..317cb7a 100644 --- a/hyperkitty/models.py +++ b/hyperkitty/models.py @@ -27,10 +27,10 @@ from django.contrib import admin class Rating(models.Model): # @TODO: instead of list_address, user list model from kittystore? - list_address = models.CharField(max_length=255) + list_address = models.CharField(max_length=255, db_index=True) # @TODO: instead of messsageid, use message model from kittystore? - messageid = models.CharField(max_length=100) + messageid = models.CharField(max_length=100, db_index=True) user = models.ForeignKey(User) @@ -61,10 +61,10 @@ class UserProfile(models.Model): class Tag(models.Model): # @TODO: instead of list_address, user list model from kittystore? - list_address = models.CharField(max_length=255) + list_address = models.CharField(max_length=255, db_index=True) # @TODO: instead of threadid, use thread model from kittystore? - threadid = models.CharField(max_length=100) + threadid = models.CharField(max_length=100, db_index=True) tag = models.CharField(max_length=255) @@ -77,8 +77,8 @@ admin.site.register(Tag) class Favorite(models.Model): - list_address = models.CharField(max_length=255) - threadid = models.CharField(max_length=100) + list_address = models.CharField(max_length=255, db_index=True) + threadid = models.CharField(max_length=100, db_index=True) user = models.ForeignKey(User) def __unicode__(self): @@ -90,8 +90,8 @@ admin.site.register(Favorite) class LastView(models.Model): - list_address = models.CharField(max_length=255) - threadid = models.CharField(max_length=100) + list_address = models.CharField(max_length=255, db_index=True) + threadid = models.CharField(max_length=100, db_index=True) user = models.ForeignKey(User) view_date = models.DateTimeField(auto_now=True) -- cgit