summaryrefslogtreecommitdiff
path: root/src/caas/migrations/0002_auto_20200706_2113.py
blob: 553a4e4a396d73f5145608f72ceea6ad7cff60bb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
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'),
        ),
    ]