# Generated by Django 2.0.3 on 2018-03-15 01:05

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('nps', '0012_auto_20180314_1600'),
    ]

    operations = [
        migrations.CreateModel(
            name='ClientAggregations',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('client', models.CharField(max_length=30)),
                ('survey', models.CharField(max_length=30)),
                ('user_type', models.CharField(blank=True, default=None, max_length=30, null=True)),
                ('nps_score', models.FloatField()),
                ('total_responses', models.IntegerField()),
                ('promoters', models.IntegerField()),
                ('detractors', models.IntegerField()),
                ('neutral', models.IntegerField()),
                ('percent_detractors', models.FloatField(blank=True, default=None, null=True)),
                ('percent_promoters', models.FloatField(blank=True, default=None, null=True)),
                ('percent_neutral', models.FloatField(blank=True, default=None, null=True)),
                ('statistically_significant', models.BooleanField(default=False)),
            ],
        ),
        migrations.DeleteModel(
            name='AggregatedResults',
        ),
        migrations.DeleteModel(
            name='ProductUsers',
        ),
        migrations.RenameField(
            model_name='productaggregations',
            old_name='total_detractors',
            new_name='detractors',
        ),
        migrations.RenameField(
            model_name='productaggregations',
            old_name='total_neutral',
            new_name='neutral',
        ),
        migrations.RenameField(
            model_name='productaggregations',
            old_name='number_clients_negative',
            new_name='num_clients_negative',
        ),
        migrations.RenameField(
            model_name='productaggregations',
            old_name='number_clients_positive',
            new_name='num_clients_positive',
        ),
        migrations.RenameField(
            model_name='productaggregations',
            old_name='total_promoters',
            new_name='promoters',
        ),
        migrations.RenameField(
            model_name='surveyaggregations',
            old_name='total_detractors',
            new_name='detractors',
        ),
        migrations.RenameField(
            model_name='surveyaggregations',
            old_name='total_neutral',
            new_name='neutral',
        ),
        migrations.RenameField(
            model_name='surveyaggregations',
            old_name='number_clients_negative',
            new_name='num_clients_negative',
        ),
        migrations.RenameField(
            model_name='surveyaggregations',
            old_name='number_clients_positive',
            new_name='num_clients_positive',
        ),
        migrations.RenameField(
            model_name='surveyaggregations',
            old_name='total_promoters',
            new_name='promoters',
        ),
        migrations.RemoveField(
            model_name='productaggregations',
            name='number_clients_neutral',
        ),
        migrations.RemoveField(
            model_name='productaggregations',
            name='percent_clients_neutral',
        ),
        migrations.RemoveField(
            model_name='surveyaggregations',
            name='number_clients_neutral',
        ),
        migrations.RemoveField(
            model_name='surveyaggregations',
            name='percent_clients_neutral',
        ),
        migrations.AddField(
            model_name='productaggregations',
            name='user_type',
            field=models.CharField(blank=True, default=None, max_length=30, null=True),
        ),
        migrations.AddField(
            model_name='surveyaggregations',
            name='user_type',
            field=models.CharField(blank=True, default=None, max_length=30, null=True),
        ),
        migrations.AlterUniqueTogether(
            name='clientaggregations',
            unique_together={('client', 'survey', 'user_type')},
        ),
    ]

[(31, 'django.db.migrations.DeleteModel', 'migrations.DeleteModel', False, 'from django.db import migrations, models\n'), (34, 'django.db.migrations.DeleteModel', 'migrations.DeleteModel', False, 'from django.db import migrations, models\n'), (37, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (42, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (47, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (52, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (57, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (62, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (67, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (72, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (77, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (82, 'django.db.migrations.RenameField', 'migrations.RenameField', False, 'from django.db import migrations, models\n'), (87, 'django.db.migrations.RemoveField', 'migrations.RemoveField', False, 'from django.db import migrations, models\n'), (91, 'django.db.migrations.RemoveField', 'migrations.RemoveField', False, 'from django.db import migrations, models\n'), (95, 'django.db.migrations.RemoveField', 'migrations.RemoveField', False, 'from django.db import migrations, models\n'), (99, 'django.db.migrations.RemoveField', 'migrations.RemoveField', False, 'from django.db import migrations, models\n'), (113, 'django.db.migrations.AlterUniqueTogether', 'migrations.AlterUniqueTogether', False, 'from django.db import migrations, models\n'), (106, 'django.db.models.CharField', 'models.CharField', False, 'from django.db import migrations, models\n'), (111, 'django.db.models.CharField', 'models.CharField', False, 'from django.db import migrations, models\n'), (16, 'django.db.models.AutoField', 'models.AutoField', False, 'from django.db import migrations, models\n'), (17, 'django.db.models.CharField', 'models.CharField', False, 'from django.db import migrations, models\n'), (18, 'django.db.models.CharField', 'models.CharField', False, 'from django.db import migrations, models\n'), (19, 'django.db.models.CharField', 'models.CharField', False, 'from django.db import migrations, models\n'), (20, 'django.db.models.FloatField', 'models.FloatField', False, 'from django.db import migrations, models\n'), (21, 'django.db.models.IntegerField', 'models.IntegerField', False, 'from django.db import migrations, models\n'), (22, 'django.db.models.IntegerField', 'models.IntegerField', False, 'from django.db import migrations, models\n'), (23, 'django.db.models.IntegerField', 'models.IntegerField', False, 'from django.db import migrations, models\n'), (24, 'django.db.models.IntegerField', 'models.IntegerField', False, 'from django.db import migrations, models\n'), (25, 'django.db.models.FloatField', 'models.FloatField', False, 'from django.db import migrations, models\n'), (26, 'django.db.models.FloatField', 'models.FloatField', False, 'from django.db import migrations, models\n'), (27, 'django.db.models.FloatField', 'models.FloatField', False, 'from django.db import migrations, models\n'), (28, 'django.db.models.BooleanField', 'models.BooleanField', False, 'from django.db import migrations, models\n')]