From d44fb0962ee78776e9b4173a0ef267be79898c8c Mon Sep 17 00:00:00 2001 From: Jan-Pascal van Best Date: Sat, 20 Feb 2016 21:36:38 +0100 Subject: [PATCH] Add index for created_at field --- tweet/migrations/0010_auto_20160220_2130.py | 21 +++++++++++++++++++++ tweet/models.py | 2 +- 2 files changed, 22 insertions(+), 1 deletion(-) create mode 100644 tweet/migrations/0010_auto_20160220_2130.py diff --git a/tweet/migrations/0010_auto_20160220_2130.py b/tweet/migrations/0010_auto_20160220_2130.py new file mode 100644 index 0000000..e8518e5 --- /dev/null +++ b/tweet/migrations/0010_auto_20160220_2130.py @@ -0,0 +1,21 @@ +# -*- coding: utf-8 -*- +# Generated by Django 1.9.2 on 2016-02-20 20:30 +from __future__ import unicode_literals + +from django.db import migrations, models +import django.utils.timezone + + +class Migration(migrations.Migration): + + dependencies = [ + ('tweet', '0009_tweet_address'), + ] + + operations = [ + migrations.AlterField( + model_name='tweet', + name='created_at', + field=models.DateTimeField(db_index=True, default=django.utils.timezone.now, verbose_name='date and time'), + ), + ] diff --git a/tweet/models.py b/tweet/models.py index 3133409..53df4e0 100644 --- a/tweet/models.py +++ b/tweet/models.py @@ -46,7 +46,7 @@ class Settings(models.Model): class Tweet(models.Model): id = models.BigIntegerField('id', primary_key=True) - created_at = models.DateTimeField('date and time', default=timezone.now) + created_at = models.DateTimeField('date and time', default=timezone.now, db_index=True) from_user = models.CharField('sender screen name', max_length=20) from_user_id = models.BigIntegerField('sender user id') in_reply_to = models.CharField('in reply to screen name', max_length=20, blank=True) -- 2.39.5