mygpo/podcasts/migrations/0024_episodes_index.py

   1 # -*- coding: utf-8 -*-
   2 from __future__ import unicode_literals
   3
   4 from django.db import models, migrations
   5 import django.db.models.deletion
   6
   7
   8 class Migration(migrations.Migration):
   9
  10     dependencies = [
  11         ('podcasts', '0023_auto_20140729_1711'),
  12     ]
  13
  14     operations = [
  15         migrations.RunSQL(
  16             sql = 'CREATE INDEX episodes_podcast_hasreleased ON podcasts_episode (podcast_id, (released IS NOT NULL) DESC, released DESC);',
  17             reverse_sql = 'DROP INDEX IF EXISTS episodes_podcast_hasreleased;',
  18         )
  19     ]