From 7396622f6bc05508b9e171ddbb861caaee0be0a5 Mon Sep 17 00:00:00 2001
From: Gael Le Mignot <gael@pilotsystems.net>
Date: Fri, 10 Dec 2021 11:22:01 +0100
Subject: [PATCH] Added index on webclasses

---
 ...05_webclass_teleforma_w_status_03cc4b_idx.py | 17 +++++++++++++++++
 teleforma/webclass/models.py                    |  3 +++
 2 files changed, 20 insertions(+)
 create mode 100644 teleforma/webclass/migrations/0005_webclass_teleforma_w_status_03cc4b_idx.py

diff --git a/teleforma/webclass/migrations/0005_webclass_teleforma_w_status_03cc4b_idx.py b/teleforma/webclass/migrations/0005_webclass_teleforma_w_status_03cc4b_idx.py
new file mode 100644
index 00000000..e330e55c
--- /dev/null
+++ b/teleforma/webclass/migrations/0005_webclass_teleforma_w_status_03cc4b_idx.py
@@ -0,0 +1,17 @@
+# Generated by Django 3.2.3 on 2021-12-10 11:20
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('webclass', '0004_auto_20210616_1654'),
+    ]
+
+    operations = [
+        migrations.AddIndex(
+            model_name='webclass',
+            index=models.Index(fields=['status', 'period', 'course'], name='teleforma_w_status_03cc4b_idx'),
+        ),
+    ]
diff --git a/teleforma/webclass/models.py b/teleforma/webclass/models.py
index a6567a27..56337de6 100644
--- a/teleforma/webclass/models.py
+++ b/teleforma/webclass/models.py
@@ -157,6 +157,9 @@ class Webclass(models.Model):
         db_table = app_label + '_' + 'webclass'
         verbose_name = _('webclass')
         verbose_name_plural = _('webclass')
+        indexes = [
+            models.Index(fields=['status', 'period', 'course', ]),
+         ]
 
     def __str__(self):
         return "Webclass %d : %s" % (self.id, self.course.title)
-- 
2.39.5