# 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')},
        ),
    ]

[((1327, 1375), 'django.db.migrations.DeleteModel', 'migrations.DeleteModel', ([], {'name': '"""AggregatedResults"""'}), "(name='AggregatedResults')\n", (1349, 1375), False, 'from django.db import migrations, models\n'), ((1408, 1451), 'django.db.migrations.DeleteModel', 'migrations.DeleteModel', ([], {'name': '"""ProductUsers"""'}), "(name='ProductUsers')\n", (1430, 1451), False, 'from django.db import migrations, models\n'), ((1484, 1597), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""productaggregations"""', 'old_name': '"""total_detractors"""', 'new_name': '"""detractors"""'}), "(model_name='productaggregations', old_name=\n    'total_detractors', new_name='detractors')\n", (1506, 1597), False, 'from django.db import migrations, models\n'), ((1649, 1756), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""productaggregations"""', 'old_name': '"""total_neutral"""', 'new_name': '"""neutral"""'}), "(model_name='productaggregations', old_name=\n    'total_neutral', new_name='neutral')\n", (1671, 1756), False, 'from django.db import migrations, models\n'), ((1808, 1938), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""productaggregations"""', 'old_name': '"""number_clients_negative"""', 'new_name': '"""num_clients_negative"""'}), "(model_name='productaggregations', old_name=\n    'number_clients_negative', new_name='num_clients_negative')\n", (1830, 1938), False, 'from django.db import migrations, models\n'), ((1990, 2120), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""productaggregations"""', 'old_name': '"""number_clients_positive"""', 'new_name': '"""num_clients_positive"""'}), "(model_name='productaggregations', old_name=\n    'number_clients_positive', new_name='num_clients_positive')\n", (2012, 2120), False, 'from django.db import migrations, models\n'), ((2172, 2283), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""productaggregations"""', 'old_name': '"""total_promoters"""', 'new_name': '"""promoters"""'}), "(model_name='productaggregations', old_name=\n    'total_promoters', new_name='promoters')\n", (2194, 2283), False, 'from django.db import migrations, models\n'), ((2335, 2447), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""surveyaggregations"""', 'old_name': '"""total_detractors"""', 'new_name': '"""detractors"""'}), "(model_name='surveyaggregations', old_name=\n    'total_detractors', new_name='detractors')\n", (2357, 2447), False, 'from django.db import migrations, models\n'), ((2499, 2605), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""surveyaggregations"""', 'old_name': '"""total_neutral"""', 'new_name': '"""neutral"""'}), "(model_name='surveyaggregations', old_name=\n    'total_neutral', new_name='neutral')\n", (2521, 2605), False, 'from django.db import migrations, models\n'), ((2657, 2786), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""surveyaggregations"""', 'old_name': '"""number_clients_negative"""', 'new_name': '"""num_clients_negative"""'}), "(model_name='surveyaggregations', old_name=\n    'number_clients_negative', new_name='num_clients_negative')\n", (2679, 2786), False, 'from django.db import migrations, models\n'), ((2838, 2967), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""surveyaggregations"""', 'old_name': '"""number_clients_positive"""', 'new_name': '"""num_clients_positive"""'}), "(model_name='surveyaggregations', old_name=\n    'number_clients_positive', new_name='num_clients_positive')\n", (2860, 2967), False, 'from django.db import migrations, models\n'), ((3019, 3129), 'django.db.migrations.RenameField', 'migrations.RenameField', ([], {'model_name': '"""surveyaggregations"""', 'old_name': '"""total_promoters"""', 'new_name': '"""promoters"""'}), "(model_name='surveyaggregations', old_name=\n    'total_promoters', new_name='promoters')\n", (3041, 3129), False, 'from django.db import migrations, models\n'), ((3181, 3273), 'django.db.migrations.RemoveField', 'migrations.RemoveField', ([], {'model_name': '"""productaggregations"""', 'name': '"""number_clients_neutral"""'}), "(model_name='productaggregations', name=\n    'number_clients_neutral')\n", (3203, 3273), False, 'from django.db import migrations, models\n'), ((3313, 3406), 'django.db.migrations.RemoveField', 'migrations.RemoveField', ([], {'model_name': '"""productaggregations"""', 'name': '"""percent_clients_neutral"""'}), "(model_name='productaggregations', name=\n    'percent_clients_neutral')\n", (3335, 3406), False, 'from django.db import migrations, models\n'), ((3446, 3537), 'django.db.migrations.RemoveField', 'migrations.RemoveField', ([], {'model_name': '"""surveyaggregations"""', 'name': '"""number_clients_neutral"""'}), "(model_name='surveyaggregations', name=\n    'number_clients_neutral')\n", (3468, 3537), False, 'from django.db import migrations, models\n'), ((3577, 3669), 'django.db.migrations.RemoveField', 'migrations.RemoveField', ([], {'model_name': '"""surveyaggregations"""', 'name': '"""percent_clients_neutral"""'}), "(model_name='surveyaggregations', name=\n    'percent_clients_neutral')\n", (3599, 3669), False, 'from django.db import migrations, models\n'), ((4116, 4231), 'django.db.migrations.AlterUniqueTogether', 'migrations.AlterUniqueTogether', ([], {'name': '"""clientaggregations"""', 'unique_together': "{('client', 'survey', 'user_type')}"}), "(name='clientaggregations', unique_together={\n    ('client', 'survey', 'user_type')})\n", (4146, 4231), False, 'from django.db import migrations, models\n'), ((3824, 3892), 'django.db.models.CharField', 'models.CharField', ([], {'blank': '(True)', 'default': 'None', 'max_length': '(30)', 'null': '(True)'}), '(blank=True, default=None, max_length=30, null=True)\n', (3840, 3892), False, 'from django.db import migrations, models\n'), ((4027, 4095), 'django.db.models.CharField', 'models.CharField', ([], {'blank': '(True)', 'default': 'None', 'max_length': '(30)', 'null': '(True)'}), '(blank=True, default=None, max_length=30, null=True)\n', (4043, 4095), False, 'from django.db import migrations, models\n'), ((338, 431), 'django.db.models.AutoField', 'models.AutoField', ([], {'auto_created': '(True)', 'primary_key': '(True)', 'serialize': '(False)', 'verbose_name': '"""ID"""'}), "(auto_created=True, primary_key=True, serialize=False,\n    verbose_name='ID')\n", (354, 431), False, 'from django.db import migrations, models\n'), ((457, 488), 'django.db.models.CharField', 'models.CharField', ([], {'max_length': '(30)'}), '(max_length=30)\n', (473, 488), False, 'from django.db import migrations, models\n'), ((518, 549), 'django.db.models.CharField', 'models.CharField', ([], {'max_length': '(30)'}), '(max_length=30)\n', (534, 549), False, 'from django.db import migrations, models\n'), ((582, 650), 'django.db.models.CharField', 'models.CharField', ([], {'blank': '(True)', 'default': 'None', 'max_length': '(30)', 'null': '(True)'}), '(blank=True, default=None, max_length=30, null=True)\n', (598, 650), False, 'from django.db import migrations, models\n'), ((683, 702), 'django.db.models.FloatField', 'models.FloatField', ([], {}), '()\n', (700, 702), False, 'from django.db import migrations, models\n'), ((741, 762), 'django.db.models.IntegerField', 'models.IntegerField', ([], {}), '()\n', (760, 762), False, 'from django.db import migrations, models\n'), ((795, 816), 'django.db.models.IntegerField', 'models.IntegerField', ([], {}), '()\n', (814, 816), False, 'from django.db import migrations, models\n'), ((850, 871), 'django.db.models.IntegerField', 'models.IntegerField', ([], {}), '()\n', (869, 871), False, 'from django.db import migrations, models\n'), ((902, 923), 'django.db.models.IntegerField', 'models.IntegerField', ([], {}), '()\n', (921, 923), False, 'from django.db import migrations, models\n'), ((965, 1019), 'django.db.models.FloatField', 'models.FloatField', ([], {'blank': '(True)', 'default': 'None', 'null': '(True)'}), '(blank=True, default=None, null=True)\n', (982, 1019), False, 'from django.db import migrations, models\n'), ((1060, 1114), 'django.db.models.FloatField', 'models.FloatField', ([], {'blank': '(True)', 'default': 'None', 'null': '(True)'}), '(blank=True, default=None, null=True)\n', (1077, 1114), False, 'from django.db import migrations, models\n'), ((1153, 1207), 'django.db.models.FloatField', 'models.FloatField', ([], {'blank': '(True)', 'default': 'None', 'null': '(True)'}), '(blank=True, default=None, null=True)\n', (1170, 1207), False, 'from django.db import migrations, models\n'), ((1256, 1290), 'django.db.models.BooleanField', 'models.BooleanField', ([], {'default': '(False)'}), '(default=False)\n', (1275, 1290), False, 'from django.db import migrations, models\n')]