more filesHEADmaster

31 files changed, 963 insertions, 41 deletions

diff --git a/src/caas/migrations/0001_initial.py b/src/caas/migrations/0001_initial.py
index 409c48f..d524cf3 100644
--- a/src/caas/migrations/0001_initial.py
+++ b/src/caas/migrations/0001_initial.py
@@ -1,7 +1,6 @@
-# Generated by Django 3.0.5 on 2020-05-04 16:28
+# Generated by Django 3.0.8 on 2020-07-07 03:12
 
 from django.db import migrations, models
-import django.db.models.deletion
 
 
 class Migration(migrations.Migration):
@@ -13,62 +12,81 @@ class Migration(migrations.Migration):
 
     operations = [
         migrations.CreateModel(
-            name='VcpfeLocation',
+            name='FirmwareBatch',
             fields=[
                 ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
-                ('fuze_spm_site_id', models.CharField(max_length=16)),
-                ('fuze_spm_site_name', models.CharField(max_length=255)),
-                ('fuze_spm_market', models.CharField(max_length=255)),
-                ('fuze_spm_submarket', models.CharField(max_length=255)),
-                ('fuze_spm_site_type', models.CharField(choices=[('DRAN', 'DRAN'), ('CRAN', 'CRAN')], max_length=4)),
-                ('central_controller_sap_clli', models.CharField(max_length=255)),
-                ('vcu_sap_clli', models.CharField(max_length=255)),
-                ('csr_hostname', models.CharField(max_length=255)),
-                ('f1c_f1u_subnet', models.CharField(max_length=255)),
-                ('f1c_f1u_default_gateway', models.CharField(max_length=255)),
-                ('oam_subnet', models.CharField(max_length=255)),
-                ('oam_default_gateway', models.CharField(max_length=255)),
-                ('mgmt_subnet', models.CharField(max_length=255)),
-                ('mgmt_default_gateway', models.CharField(max_length=255)),
-                ('ilo_subnet', models.CharField(max_length=255)),
-                ('ilo_default_gateway', models.CharField(max_length=255)),
-                ('fhgw_subnet', models.CharField(max_length=255)),
-                ('fhgw_default_gateway', models.CharField(max_length=255)),
+                ('ilo_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_username', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password', models.CharField(blank=True, max_length=255, null=True)),
             ],
+            options={
+                'db_table': 'caas_firmwarebatch',
+                'managed': False,
+            },
         ),
         migrations.CreateModel(
-            name='Vlan',
+            name='IcingaBmc',
             fields=[
                 ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
-                ('host_vlan', models.PositiveSmallIntegerField()),
-                ('oam_vlan', models.PositiveSmallIntegerField()),
-                ('mgmt_vlan', models.PositiveSmallIntegerField()),
+                ('ilo_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('csr_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('latitude', models.CharField(blank=True, max_length=255, null=True)),
+                ('longitude', models.CharField(blank=True, max_length=255, null=True)),
+                ('serial_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('vendor_name', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password_admin_default', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password_admin', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_username', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password', models.CharField(blank=True, max_length=255, null=True)),
             ],
+            options={
+                'db_table': 'caas_icingabmc',
+                'managed': False,
+            },
         ),
         migrations.CreateModel(
-            name='VcpfeServer',
+            name='IcingaRouter',
             fields=[
                 ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
-                ('server_number', models.PositiveSmallIntegerField()),
-                ('server_hostname', models.CharField(max_length=255)),
-                ('cluster_name', models.CharField(max_length=255)),
-                ('f1u_address', models.CharField(max_length=255)),
-                ('f1c_address', models.CharField(max_length=255)),
-                ('oam_host_address', models.CharField(max_length=255)),
-                ('oam_vip_address', models.CharField(max_length=255)),
-                ('mgmt_address_range_start', models.CharField(max_length=255)),
-                ('mgmt_address_range_end', models.CharField(max_length=255)),
-                ('ilo_host_address', models.CharField(max_length=255)),
-                ('fhgw_host_address', models.CharField(max_length=255)),
-                ('vlan_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Vlan')),
+                ('csr_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
             ],
+            options={
+                'db_table': 'caas_icingarouter',
+                'managed': False,
+            },
         ),
         migrations.CreateModel(
-            name='Namespace',
+            name='WrBatch',
             fields=[
                 ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
-                ('namespace_name', models.CharField(max_length=255)),
-                ('server_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.VcpfeServer')),
+                ('cluster_id', models.IntegerField()),
+                ('parent_oam_vip_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('parent_oam_vip_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('pxe_mac_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_vip_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_address_range_start', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_address_range_end', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_subnet', models.CharField(blank=True, max_length=255, null=True)),
+                ('host_vlan', models.PositiveSmallIntegerField()),
+                ('oam_vlan', models.PositiveSmallIntegerField()),
+                ('mgmt_vlan', models.PositiveSmallIntegerField()),
+                ('cluster_name', models.CharField(blank=True, max_length=255, null=True)),
+                ('vendor_name', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_username', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password', models.CharField(blank=True, max_length=255, null=True)),
             ],
+            options={
+                'db_table': 'caas_wrbatch',
+                'managed': False,
+            },
         ),
     ]
diff --git a/src/caas/migrations/0002_auto_20200706_2113.py b/src/caas/migrations/0002_auto_20200706_2113.py
new file mode 100644
index 0000000..553a4e4
--- /dev/null
+++ b/src/caas/migrations/0002_auto_20200706_2113.py
@@ -0,0 +1,260 @@
+# Generated by Django 3.0.8 on 2020-07-07 03:13
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0001_initial'),
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='Blade',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('serial_number', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='CellSiteRouter',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('csr_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_subnet', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_subnet', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_subnet', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Chassis',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('serial_number', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Cluster',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('cluster_name', models.CharField(max_length=255)),
+                ('oam_vip_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_vip_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_address_range_start', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_address_range_end', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Credential',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('bmc_password_admin_default', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password_admin', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_username', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='FirmwareUpgradeSchedule',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('date_scheduled', models.DateTimeField(blank=True, null=True)),
+                ('date_completed', models.DateTimeField(blank=True, null=True)),
+                ('date_last_failed', models.DateTimeField(blank=True, null=True)),
+                ('kirke_ticket_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('kirke_ticket_status', models.CharField(blank=True, max_length=255, null=True)),
+                ('kirke_ticket_completed', models.DateTimeField(blank=True, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Location',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('fuze_spm_site_id', models.CharField(max_length=16)),
+                ('fuze_spm_site_name', models.CharField(max_length=255)),
+                ('fuze_spm_market', models.CharField(max_length=255)),
+                ('fuze_spm_submarket', models.CharField(max_length=255)),
+                ('fuze_spm_site_type', models.CharField(choices=[('DRAN', 'DRAN'), ('CRAN', 'CRAN')], max_length=4)),
+                ('latitude', models.DecimalField(blank=True, decimal_places=9, max_digits=12, null=True)),
+                ('longitude', models.DecimalField(blank=True, decimal_places=9, max_digits=12, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Namespace',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('namespace_name', models.CharField(max_length=255)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='SapClli',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('clli', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Server',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('server_number', models.PositiveSmallIntegerField(blank=True, null=True)),
+                ('oam_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_hostname', models.CharField(max_length=255)),
+                ('ilo_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('pxe_mac_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('csr_vdu_port_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('csr_oam_port_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('csr_mgmt_port_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('csr_nfs_port_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('intel_nic_firmware_version', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Vendor',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('vendor_name', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='Vlan',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('host_vlan', models.PositiveSmallIntegerField()),
+                ('oam_vlan', models.PositiveSmallIntegerField()),
+                ('mgmt_vlan', models.PositiveSmallIntegerField()),
+                ('nfs_vlan', models.PositiveSmallIntegerField(blank=True, null=True)),
+            ],
+        ),
+        migrations.CreateModel(
+            name='WrInstallSchedule',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('date_scheduled', models.DateTimeField(blank=True, null=True)),
+                ('date_completed', models.DateTimeField(blank=True, null=True)),
+                ('date_last_failed', models.DateTimeField(blank=True, null=True)),
+                ('kirke_ticket_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('kirke_ticket_status', models.CharField(blank=True, max_length=255, null=True)),
+                ('kirke_ticket_completed', models.DateTimeField(blank=True, null=True)),
+                ('cluster', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Cluster')),
+            ],
+        ),
+        migrations.AddConstraint(
+            model_name='vlan',
+            constraint=models.UniqueConstraint(fields=('host_vlan', 'oam_vlan', 'mgmt_vlan', 'nfs_vlan'), name='unique_vlan'),
+        ),
+        migrations.AddConstraint(
+            model_name='vendor',
+            constraint=models.UniqueConstraint(fields=('vendor_name',), name='unique_vendor'),
+        ),
+        migrations.AddField(
+            model_name='server',
+            name='blade',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Blade'),
+        ),
+        migrations.AddField(
+            model_name='server',
+            name='cluster',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Cluster'),
+        ),
+        migrations.AddConstraint(
+            model_name='sapclli',
+            constraint=models.UniqueConstraint(fields=('clli',), name='unique_sapclli'),
+        ),
+        migrations.AddConstraint(
+            model_name='namespace',
+            constraint=models.UniqueConstraint(fields=('namespace_name',), name='unique_namespace'),
+        ),
+        migrations.AddConstraint(
+            model_name='location',
+            constraint=models.UniqueConstraint(fields=('fuze_spm_site_id', 'fuze_spm_site_name', 'fuze_spm_market', 'fuze_spm_submarket', 'fuze_spm_site_type'), name='unique_location'),
+        ),
+        migrations.AddField(
+            model_name='firmwareupgradeschedule',
+            name='server',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Server'),
+        ),
+        migrations.AddConstraint(
+            model_name='credential',
+            constraint=models.UniqueConstraint(fields=('bmc_password_admin_default', 'bmc_password_admin', 'bmc_username', 'bmc_password'), name='unique_credential'),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='csr',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.CellSiteRouter'),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='location',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Location'),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='namespace',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Namespace'),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='parent_cluster',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Cluster'),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='sap_clli',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.SapClli'),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='vlan',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Vlan'),
+        ),
+        migrations.AddConstraint(
+            model_name='chassis',
+            constraint=models.UniqueConstraint(fields=('serial_number',), name='unique_chassis'),
+        ),
+        migrations.AddConstraint(
+            model_name='cellsiterouter',
+            constraint=models.UniqueConstraint(fields=('csr_hostname',), name='unique_cellsiterouter'),
+        ),
+        migrations.AddField(
+            model_name='blade',
+            name='chassis',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Chassis'),
+        ),
+        migrations.AddField(
+            model_name='blade',
+            name='credential',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Credential'),
+        ),
+        migrations.AddField(
+            model_name='blade',
+            name='vendor',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Vendor'),
+        ),
+        migrations.AddConstraint(
+            model_name='wrinstallschedule',
+            constraint=models.UniqueConstraint(fields=('cluster_id',), name='unique_wrinstallschedule'),
+        ),
+        migrations.AddConstraint(
+            model_name='server',
+            constraint=models.UniqueConstraint(fields=('ilo_host_address',), name='unique_server_byiloaddress'),
+        ),
+        migrations.AddConstraint(
+            model_name='firmwareupgradeschedule',
+            constraint=models.UniqueConstraint(fields=('server_id',), name='unique_firmwareupgradeschedule'),
+        ),
+        migrations.AddConstraint(
+            model_name='cluster',
+            constraint=models.UniqueConstraint(fields=('cluster_name',), name='unique_cluster'),
+        ),
+        migrations.AddConstraint(
+            model_name='blade',
+            constraint=models.UniqueConstraint(fields=('serial_number',), name='unique_blade'),
+        ),
+    ]
diff --git a/src/caas/migrations/0003_auto_20200706_2113.py b/src/caas/migrations/0003_auto_20200706_2113.py
new file mode 100644
index 0000000..fb3c69d
--- /dev/null
+++ b/src/caas/migrations/0003_auto_20200706_2113.py
@@ -0,0 +1,35 @@
+# Generated by Django 3.0.8 on 2020-07-07 03:13
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0002_auto_20200706_2113'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_icingabmc'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('', 'caas_icingabmc'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select location_id as id,\n  csr_hostname,\n  oam_default_gateway\nfrom caas_icingabmc\ngroup by location_id,\n  csr_hostname,\n  oam_default_gateway', 'caas_icingarouter'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('', 'caas_icingarouter'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_firmwarebatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('', 'caas_firmwarebatch'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration("select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null\n  and s.intel_nic_firmware_version = '1.2585.0'", 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0004_delete_wrbatch.py b/src/caas/migrations/0004_delete_wrbatch.py
new file mode 100644
index 0000000..a3e0e4d
--- /dev/null
+++ b/src/caas/migrations/0004_delete_wrbatch.py
@@ -0,0 +1,16 @@
+# Generated by Django 3.0.8 on 2020-07-11 04:34
+
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0003_auto_20200706_2113'),
+    ]
+
+    operations = [
+        migrations.DeleteModel(
+            name='WrBatch',
+        ),
+    ]
diff --git a/src/caas/migrations/0005_auto_20200710_2235.py b/src/caas/migrations/0005_auto_20200710_2235.py
new file mode 100644
index 0000000..8ca77db
--- /dev/null
+++ b/src/caas/migrations/0005_auto_20200710_2235.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-07-11 04:35
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0004_delete_wrbatch'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.intel_nic_firmware_version,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_firmwarebatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_firmwarebatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0006_wrbatch.py b/src/caas/migrations/0006_wrbatch.py
new file mode 100644
index 0000000..52cb599
--- /dev/null
+++ b/src/caas/migrations/0006_wrbatch.py
@@ -0,0 +1,43 @@
+# Generated by Django 3.0.8 on 2020-07-11 04:50
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0005_auto_20200710_2235'),
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='WrBatch',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('cluster_id', models.IntegerField()),
+                ('parent_oam_vip_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('parent_oam_vip_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('pxe_mac_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('ilo_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_hostname', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_host_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_vip_address', models.CharField(blank=True, max_length=255, null=True)),
+                ('oam_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_address_range_start', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_address_range_end', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_default_gateway', models.CharField(blank=True, max_length=255, null=True)),
+                ('mgmt_subnet', models.CharField(blank=True, max_length=255, null=True)),
+                ('host_vlan', models.PositiveSmallIntegerField()),
+                ('oam_vlan', models.PositiveSmallIntegerField()),
+                ('mgmt_vlan', models.PositiveSmallIntegerField()),
+                ('cluster_name', models.CharField(blank=True, max_length=255, null=True)),
+                ('vendor_name', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_username', models.CharField(blank=True, max_length=255, null=True)),
+                ('bmc_password', models.CharField(blank=True, max_length=255, null=True)),
+            ],
+            options={
+                'db_table': 'caas_wrbatch',
+                'managed': False,
+            },
+        ),
+    ]
diff --git a/src/caas/migrations/0007_auto_20200711_1126.py b/src/caas/migrations/0007_auto_20200711_1126.py
new file mode 100644
index 0000000..a8911d6
--- /dev/null
+++ b/src/caas/migrations/0007_auto_20200711_1126.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-07-11 17:26
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0006_wrbatch'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration("select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null\n  and s.intel_nic_firmware_version = '1.2585.0'", 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0008_auto_20200711_1127.py b/src/caas/migrations/0008_auto_20200711_1127.py
new file mode 100644
index 0000000..8808699
--- /dev/null
+++ b/src/caas/migrations/0008_auto_20200711_1127.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-07-11 17:27
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0007_auto_20200711_1126'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0009_auto_20200715_1630.py b/src/caas/migrations/0009_auto_20200715_1630.py
new file mode 100644
index 0000000..204b615
--- /dev/null
+++ b/src/caas/migrations/0009_auto_20200715_1630.py
@@ -0,0 +1,18 @@
+# Generated by Django 3.0.8 on 2020-07-15 22:30
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0008_auto_20200711_1127'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='location',
+            name='fuze_spm_site_type',
+            field=models.CharField(choices=[('SAP', 'SAP'), ('DRAN', 'DRAN'), ('CRAN', 'CRAN')], max_length=4),
+        ),
+    ]
diff --git a/src/caas/migrations/0010_auto_20200720_1413.py b/src/caas/migrations/0010_auto_20200720_1413.py
new file mode 100644
index 0000000..544b7f3
--- /dev/null
+++ b/src/caas/migrations/0010_auto_20200720_1413.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-07-20 20:13
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0009_auto_20200715_1630'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0011_auto_20200720_1525.py b/src/caas/migrations/0011_auto_20200720_1525.py
new file mode 100644
index 0000000..158bdb1
--- /dev/null
+++ b/src/caas/migrations/0011_auto_20200720_1525.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-07-20 21:25
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0010_auto_20200720_1413'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0012_auto_20200721_1540.py b/src/caas/migrations/0012_auto_20200721_1540.py
new file mode 100644
index 0000000..dc5169b
--- /dev/null
+++ b/src/caas/migrations/0012_auto_20200721_1540.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-07-21 21:40
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0011_auto_20200720_1525'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0013_auto_20200728_2359.py b/src/caas/migrations/0013_auto_20200728_2359.py
new file mode 100644
index 0000000..83e8998
--- /dev/null
+++ b/src/caas/migrations/0013_auto_20200728_2359.py
@@ -0,0 +1,31 @@
+# Generated by Django 3.0.8 on 2020-07-29 05:59
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0012_auto_20200721_1540'),
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='PatchSchedule',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('date_scheduled', models.DateTimeField(blank=True, null=True)),
+                ('date_completed', models.DateTimeField(blank=True, null=True)),
+                ('date_last_failed', models.DateTimeField(blank=True, null=True)),
+                ('kirke_ticket_number', models.CharField(blank=True, max_length=255, null=True)),
+                ('kirke_ticket_status', models.CharField(blank=True, max_length=255, null=True)),
+                ('kirke_ticket_completed', models.DateTimeField(blank=True, null=True)),
+                ('cluster', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='caas.Cluster')),
+            ],
+        ),
+        migrations.AddConstraint(
+            model_name='patchschedule',
+            constraint=models.UniqueConstraint(fields=('cluster_id',), name='unique_patchschedule'),
+        ),
+    ]
diff --git a/src/caas/migrations/0014_auto_20200803_1931.py b/src/caas/migrations/0014_auto_20200803_1931.py
new file mode 100644
index 0000000..793d1c3
--- /dev/null
+++ b/src/caas/migrations/0014_auto_20200803_1931.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.0.8 on 2020-08-04 01:31
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0013_auto_20200728_2359'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0015_auto_20200804_1404.py b/src/caas/migrations/0015_auto_20200804_1404.py
new file mode 100644
index 0000000..11c1150
--- /dev/null
+++ b/src/caas/migrations/0015_auto_20200804_1404.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1 on 2020-08-04 20:04
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0014_auto_20200803_1931'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0016_auto_20200804_1559.py b/src/caas/migrations/0016_auto_20200804_1559.py
new file mode 100644
index 0000000..64fd575
--- /dev/null
+++ b/src/caas/migrations/0016_auto_20200804_1559.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1 on 2020-08-04 21:59
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0015_auto_20200804_1404'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0017_cluster_is_central_controller.py b/src/caas/migrations/0017_cluster_is_central_controller.py
new file mode 100644
index 0000000..d2e500d
--- /dev/null
+++ b/src/caas/migrations/0017_cluster_is_central_controller.py
@@ -0,0 +1,18 @@
+# Generated by Django 3.0.8 on 2020-09-24 17:37
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0016_auto_20200804_1559'),
+    ]
+
+    operations = [
+        migrations.AddField(
+            model_name='cluster',
+            name='is_central_controller',
+            field=models.SmallIntegerField(blank=True, default=0, null=True),
+        ),
+    ]
diff --git a/src/caas/migrations/0018_auto_20200925_1855.py b/src/caas/migrations/0018_auto_20200925_1855.py
new file mode 100644
index 0000000..e8bc107
--- /dev/null
+++ b/src/caas/migrations/0018_auto_20200925_1855.py
@@ -0,0 +1,30 @@
+# Generated by Django 3.0.8 on 2020-09-25 18:55
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0017_cluster_is_central_controller'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select l.id as id,\n  csr.csr_hostname as csr_hostname,\n  csr.oam_default_gateway as oam_default_gateway\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.is_central_controller=0\ngroup by l.id,\n  csr.csr_hostname,\n  csr.oam_default_gateway', 'caas_icingarouter'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select location_id as id,\n  csr_hostname,\n  oam_default_gateway\nfrom caas_icingabmc\ngroup by location_id,\n  csr_hostname,\n  oam_default_gateway', 'caas_icingarouter'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.is_central_controller=0', 'caas_icingabmc'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_icingabmc'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.intel_nic_firmware_version,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.is_central_controller=0', 'caas_firmwarebatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.intel_nic_firmware_version,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_firmwarebatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0019_cluster_is_maint_window.py b/src/caas/migrations/0019_cluster_is_maint_window.py
new file mode 100644
index 0000000..cd297c5
--- /dev/null
+++ b/src/caas/migrations/0019_cluster_is_maint_window.py
@@ -0,0 +1,18 @@
+# Generated by Django 3.1.2 on 2020-10-01 17:42
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0018_auto_20200925_1855'),
+    ]
+
+    operations = [
+        migrations.AddField(
+            model_name='cluster',
+            name='is_maint_window',
+            field=models.SmallIntegerField(blank=True, default=0, null=True),
+        ),
+    ]
diff --git a/src/caas/migrations/0020_auto_20201001_1142.py b/src/caas/migrations/0020_auto_20201001_1142.py
new file mode 100644
index 0000000..3e238eb
--- /dev/null
+++ b/src/caas/migrations/0020_auto_20201001_1142.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.2 on 2020-10-01 17:42
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0019_cluster_is_maint_window'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  c.is_maint_window,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0021_auto_20201001_1232.py b/src/caas/migrations/0021_auto_20201001_1232.py
new file mode 100644
index 0000000..bb59147
--- /dev/null
+++ b/src/caas/migrations/0021_auto_20201001_1232.py
@@ -0,0 +1,22 @@
+# Generated by Django 3.1.2 on 2020-10-01 18:32
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0020_auto_20201001_1142'),
+    ]
+
+    operations = [
+        migrations.RemoveField(
+            model_name='cluster',
+            name='is_maint_window',
+        ),
+        migrations.AddField(
+            model_name='location',
+            name='maint_window_p',
+            field=models.BooleanField(blank=True, default=False, null=True),
+        ),
+    ]
diff --git a/src/caas/migrations/0022_auto_20201001_1232.py b/src/caas/migrations/0022_auto_20201001_1232.py
new file mode 100644
index 0000000..c18cf10
--- /dev/null
+++ b/src/caas/migrations/0022_auto_20201001_1232.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.2 on 2020-10-01 18:32
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0021_auto_20201001_1232'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  c.is_maint_window,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0023_auto_20201019_1631.py b/src/caas/migrations/0023_auto_20201019_1631.py
new file mode 100644
index 0000000..557884b
--- /dev/null
+++ b/src/caas/migrations/0023_auto_20201019_1631.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.2 on 2020-10-19 22:31
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0022_auto_20201001_1232'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password,\n  ws.date_completed\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nleft outer join caas_wrinstallschedule ws\n  on c.id = ws.cluster_id\nwhere c.is_central_controller = 0', 'caas_icingabmc'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.is_central_controller=0', 'caas_icingabmc'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0024_auto_20201023_1556.py b/src/caas/migrations/0024_auto_20201023_1556.py
new file mode 100644
index 0000000..e6cb4a9
--- /dev/null
+++ b/src/caas/migrations/0024_auto_20201023_1556.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.2 on 2020-10-23 21:56
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0023_auto_20201019_1631'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0025_auto_20201102_1545.py b/src/caas/migrations/0025_auto_20201102_1545.py
new file mode 100644
index 0000000..b37f422
--- /dev/null
+++ b/src/caas/migrations/0025_auto_20201102_1545.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.3 on 2020-11-02 22:45
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0024_auto_20201023_1556'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0026_auto_20201110_0932.py b/src/caas/migrations/0026_auto_20201110_0932.py
new file mode 100644
index 0000000..3956e28
--- /dev/null
+++ b/src/caas/migrations/0026_auto_20201110_0932.py
@@ -0,0 +1,29 @@
+# Generated by Django 3.1.3 on 2020-11-10 16:32
+
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0025_auto_20201102_1545'),
+    ]
+
+    operations = [
+        migrations.RemoveField(
+            model_name='server',
+            name='csr_mgmt_port_number',
+        ),
+        migrations.RemoveField(
+            model_name='server',
+            name='csr_nfs_port_number',
+        ),
+        migrations.RemoveField(
+            model_name='server',
+            name='csr_oam_port_number',
+        ),
+        migrations.RemoveField(
+            model_name='server',
+            name='csr_vdu_port_number',
+        ),
+    ]
diff --git a/src/caas/migrations/0027_auto_20201211_2103.py b/src/caas/migrations/0027_auto_20201211_2103.py
new file mode 100644
index 0000000..751411b
--- /dev/null
+++ b/src/caas/migrations/0027_auto_20201211_2103.py
@@ -0,0 +1,23 @@
+# Generated by Django 3.1.4 on 2020-12-12 04:03
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0026_auto_20201110_0932'),
+    ]
+
+    operations = [
+        migrations.AddField(
+            model_name='cluster',
+            name='mgmt_default_gateway',
+            field=models.CharField(blank=True, max_length=255, null=True),
+        ),
+        migrations.AddField(
+            model_name='cluster',
+            name='mgmt_subnet',
+            field=models.CharField(blank=True, max_length=255, null=True),
+        ),
+    ]
diff --git a/src/caas/migrations/0028_auto_20201212_1001.py b/src/caas/migrations/0028_auto_20201212_1001.py
new file mode 100644
index 0000000..cf6c1d0
--- /dev/null
+++ b/src/caas/migrations/0028_auto_20201212_1001.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.4 on 2020-12-12 17:01
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0027_auto_20201211_2103'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  c.mgmt_default_gateway,\n  c.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0029_auto_20201215_0832.py b/src/caas/migrations/0029_auto_20201215_0832.py
new file mode 100644
index 0000000..49adea4
--- /dev/null
+++ b/src/caas/migrations/0029_auto_20201215_0832.py
@@ -0,0 +1,21 @@
+# Generated by Django 3.1.4 on 2020-12-15 15:32
+
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0028_auto_20201212_1001'),
+    ]
+
+    operations = [
+        migrations.RemoveField(
+            model_name='cellsiterouter',
+            name='mgmt_default_gateway',
+        ),
+        migrations.RemoveField(
+            model_name='cellsiterouter',
+            name='mgmt_subnet',
+        ),
+    ]
diff --git a/src/caas/migrations/0030_auto_20201215_0835.py b/src/caas/migrations/0030_auto_20201215_0835.py
new file mode 100644
index 0000000..c8ee59d
--- /dev/null
+++ b/src/caas/migrations/0030_auto_20201215_0835.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.4 on 2020-12-15 15:35
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0029_auto_20201215_0832'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  c.mgmt_default_gateway as parent_mgmt_default_gateway,\n  c.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  c.mgmt_default_gateway,\n  c.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  csrp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  c.mgmt_default_gateway,\n  c.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]
diff --git a/src/caas/migrations/0031_auto_20201215_1430.py b/src/caas/migrations/0031_auto_20201215_1430.py
new file mode 100644
index 0000000..5f31f82
--- /dev/null
+++ b/src/caas/migrations/0031_auto_20201215_1430.py
@@ -0,0 +1,20 @@
+# Generated by Django 3.1.4 on 2020-12-15 21:30
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0030_auto_20201215_0835'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  cp.mgmt_default_gateway as parent_mgmt_default_gateway,\n  cp.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  c.mgmt_default_gateway,\n  c.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  l.fuze_spm_site_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n  cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n  c.mgmt_default_gateway as parent_mgmt_default_gateway,\n  c.mgmt_subnet as parent_mgmt_subnet,\n  s.pxe_mac_address,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  c.mgmt_default_gateway,\n  c.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  cp.cluster_name as parent_cluster_name,\n  v.vendor_name,\n  s.intel_nic_firmware_version,\n  l.maint_window_p,\n  n.id as namespace_id,\n  n.namespace_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_cellsiterouter csrp\n  on cp.csr_id = csrp.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\ninner join caas_namespace n\n  on c.namespace_id = n.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
+            atomic=False,
+        ),
+    ]