From da31c986df9f151417348432bb64ee62ad7fa403 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Mon, 16 Dec 2019 10:52:15 +0100 Subject: Gin index for data fields --- .../migrations/0115_auto_20191216_1013.py | 41 ++++++++++++++++++++++ .../migrations/0116_create_gist_extension.py | 17 +++++++++ .../migrations/0117_auto_20191216_1027.py | 28 +++++++++++++++ 3 files changed, 86 insertions(+) create mode 100644 ishtar_common/migrations/0115_auto_20191216_1013.py create mode 100644 ishtar_common/migrations/0116_create_gist_extension.py create mode 100644 ishtar_common/migrations/0117_auto_20191216_1027.py (limited to 'ishtar_common/migrations') diff --git a/ishtar_common/migrations/0115_auto_20191216_1013.py b/ishtar_common/migrations/0115_auto_20191216_1013.py new file mode 100644 index 000000000..1da9e4dbd --- /dev/null +++ b/ishtar_common/migrations/0115_auto_20191216_1013.py @@ -0,0 +1,41 @@ +# -*- coding: utf-8 -*- +# Generated by Django 1.11.18 on 2019-12-16 10:13 +from __future__ import unicode_literals + +import django.contrib.postgres.fields.jsonb +from django.db import migrations + + +class Migration(migrations.Migration): + + dependencies = [ + ('ishtar_common', '0114_auto_20191212_1726'), + ] + + operations = [ + migrations.AlterField( + model_name='document', + name='data', + field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}), + ), + migrations.AlterField( + model_name='historicalorganization', + name='data', + field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}), + ), + migrations.AlterField( + model_name='historicalperson', + name='data', + field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}), + ), + migrations.AlterField( + model_name='organization', + name='data', + field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}), + ), + migrations.AlterField( + model_name='person', + name='data', + field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}), + ), + ] diff --git a/ishtar_common/migrations/0116_create_gist_extension.py b/ishtar_common/migrations/0116_create_gist_extension.py new file mode 100644 index 000000000..cc22e3909 --- /dev/null +++ b/ishtar_common/migrations/0116_create_gist_extension.py @@ -0,0 +1,17 @@ +# -*- coding: utf-8 -*- +# Generated by Django 1.11.18 on 2019-12-16 10:18 +from __future__ import unicode_literals + +from django.db import migrations +from django.contrib.postgres.operations import BtreeGinExtension + + +class Migration(migrations.Migration): + + dependencies = [ + ('ishtar_common', '0115_auto_20191216_1013'), + ] + + operations = [ + BtreeGinExtension() + ] diff --git a/ishtar_common/migrations/0117_auto_20191216_1027.py b/ishtar_common/migrations/0117_auto_20191216_1027.py new file mode 100644 index 000000000..221f24e21 --- /dev/null +++ b/ishtar_common/migrations/0117_auto_20191216_1027.py @@ -0,0 +1,28 @@ +# -*- coding: utf-8 -*- +# Generated by Django 1.11.18 on 2019-12-16 10:27 +from __future__ import unicode_literals + +import django.contrib.postgres.indexes +from django.db import migrations + + +class Migration(migrations.Migration): + + dependencies = [ + ('ishtar_common', '0116_create_gist_extension'), + ] + + operations = [ + migrations.AddIndex( + model_name='person', + index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='ishtar_comm_data_a563fb_gin'), + ), + migrations.AddIndex( + model_name='document', + index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='ishtar_comm_data_c6da6f_gin'), + ), + migrations.AddIndex( + model_name='organization', + index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='ishtar_comm_data_36ecc0_gin'), + ), + ] -- cgit v1.2.3