Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0099_auto__add_field_ipaddress_project__add_field_virtualmachine_project__a.py @ b5780d85

History | View | Annotate | Download (20.2 kB)

1
# -*- coding: utf-8 -*-
2
import datetime
3
from south.db import db
4
from south.v2 import SchemaMigration
5
from django.db import models
6

    
7

    
8
class Migration(SchemaMigration):
9

    
10
    def forwards(self, orm):
11
        # Adding field 'IPAddress.project'
12
        db.add_column('db_ipaddress', 'project',
13
                      self.gf('django.db.models.fields.CharField')(max_length=255, null=True),
14
                      keep_default=False)
15

    
16
        # Adding field 'VirtualMachine.project'
17
        db.add_column('db_virtualmachine', 'project',
18
                      self.gf('django.db.models.fields.CharField')(max_length=255, null=True),
19
                      keep_default=False)
20

    
21
        # Adding field 'Network.project'
22
        db.add_column('db_network', 'project',
23
                      self.gf('django.db.models.fields.CharField')(max_length=255, null=True),
24
                      keep_default=False)
25

    
26

    
27
    def backwards(self, orm):
28
        # Deleting field 'IPAddress.project'
29
        db.delete_column('db_ipaddress', 'project')
30

    
31
        # Deleting field 'VirtualMachine.project'
32
        db.delete_column('db_virtualmachine', 'project')
33

    
34
        # Deleting field 'Network.project'
35
        db.delete_column('db_network', 'project')
36

    
37

    
38
    models = {
39
        'db.backend': {
40
            'Meta': {'ordering': "['clustername']", 'object_name': 'Backend'},
41
            'clustername': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}),
42
            'ctotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
43
            'dfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
44
            'disk_templates': ('synnefo.db.fields.SeparatedValuesField', [], {'null': 'True'}),
45
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
46
            'dtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
47
            'hash': ('django.db.models.fields.CharField', [], {'max_length': '40'}),
48
            'hypervisor': ('django.db.models.fields.CharField', [], {'default': "'kvm'", 'max_length': '32'}),
49
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
50
            'index': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'unique': 'True'}),
51
            'mfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
52
            'mtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
53
            'offline': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
54
            'password_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
55
            'pinst_cnt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
56
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'default': '5080'}),
57
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
58
            'username': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'})
59
        },
60
        'db.backendnetwork': {
61
            'Meta': {'unique_together': "(('network', 'backend'),)", 'object_name': 'BackendNetwork'},
62
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'networks'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Backend']"}),
63
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
64
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
65
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
66
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
67
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
68
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
69
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
70
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
71
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
72
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'backend_networks'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
73
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '30'}),
74
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
75
        },
76
        'db.bridgepooltable': {
77
            'Meta': {'object_name': 'BridgePoolTable'},
78
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
79
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
80
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
81
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
82
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
83
            'size': ('django.db.models.fields.IntegerField', [], {})
84
        },
85
        'db.flavor': {
86
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk', 'disk_template'),)", 'object_name': 'Flavor'},
87
            'allow_create': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
88
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
89
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
90
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
91
            'disk_template': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
92
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
93
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
94
        },
95
        'db.ipaddress': {
96
            'Meta': {'unique_together': "(('network', 'address', 'deleted'),)", 'object_name': 'IPAddress'},
97
            'address': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
98
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
99
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
100
            'floating_ip': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
101
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
102
            'ipversion': ('django.db.models.fields.IntegerField', [], {}),
103
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
104
            'nic': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.NetworkInterface']"}),
105
            'project': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
106
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.QuotaHolderSerial']"}),
107
            'subnet': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Subnet']"}),
108
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
109
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'db_index': 'True'})
110
        },
111
        'db.ipaddresslog': {
112
            'Meta': {'object_name': 'IPAddressLog'},
113
            'active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
114
            'address': ('django.db.models.fields.CharField', [], {'max_length': '64', 'db_index': 'True'}),
115
            'allocated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
116
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
117
            'network_id': ('django.db.models.fields.IntegerField', [], {}),
118
            'released_at': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
119
            'server_id': ('django.db.models.fields.IntegerField', [], {})
120
        },
121
        'db.ippooltable': {
122
            'Meta': {'object_name': 'IPPoolTable'},
123
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
124
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
125
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
126
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
127
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
128
            'size': ('django.db.models.fields.IntegerField', [], {}),
129
            'subnet': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ip_pools'", 'null': 'True', 'on_delete': 'models.PROTECT', 'to': "orm['db.Subnet']"})
130
        },
131
        'db.macprefixpooltable': {
132
            'Meta': {'object_name': 'MacPrefixPoolTable'},
133
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
134
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
135
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
136
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
137
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
138
            'size': ('django.db.models.fields.IntegerField', [], {})
139
        },
140
        'db.network': {
141
            'Meta': {'object_name': 'Network'},
142
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '32', 'null': 'True'}),
143
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
144
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
145
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
146
            'external_router': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
147
            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
148
            'floating_ip_pool': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
149
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
150
            'link': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
151
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
152
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
153
            'mode': ('django.db.models.fields.CharField', [], {'max_length': '16', 'null': 'True'}),
154
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
155
            'project': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
156
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
157
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'network'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.QuotaHolderSerial']"}),
158
            'state': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '32'}),
159
            'tags': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
160
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
161
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'db_index': 'True'})
162
        },
163
        'db.networkinterface': {
164
            'Meta': {'object_name': 'NetworkInterface'},
165
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
166
            'device_owner': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
167
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
168
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
169
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
170
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '32', 'unique': 'True', 'null': 'True'}),
171
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'null': 'True', 'on_delete': 'models.PROTECT', 'to': "orm['db.VirtualMachine']"}),
172
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '128', 'null': 'True'}),
173
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
174
            'security_groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.SecurityGroup']", 'null': 'True', 'symmetrical': 'False'}),
175
            'state': ('django.db.models.fields.CharField', [], {'default': "'ACTIVE'", 'max_length': '32'}),
176
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
177
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'db_index': 'True'})
178
        },
179
        'db.quotaholderserial': {
180
            'Meta': {'ordering': "['serial']", 'object_name': 'QuotaHolderSerial'},
181
            'accept': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
182
            'pending': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'db_index': 'True'}),
183
            'resolved': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
184
            'serial': ('django.db.models.fields.BigIntegerField', [], {'primary_key': 'True', 'db_index': 'True'})
185
        },
186
        'db.securitygroup': {
187
            'Meta': {'object_name': 'SecurityGroup'},
188
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
189
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'})
190
        },
191
        'db.subnet': {
192
            'Meta': {'object_name': 'Subnet'},
193
            'cidr': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
194
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
195
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
196
            'dhcp': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
197
            'dns_nameservers': ('synnefo.db.fields.SeparatedValuesField', [], {'null': 'True'}),
198
            'gateway': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
199
            'host_routes': ('synnefo.db.fields.SeparatedValuesField', [], {'null': 'True'}),
200
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
201
            'ipversion': ('django.db.models.fields.IntegerField', [], {'default': '4'}),
202
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '128', 'null': 'True'}),
203
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'subnets'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
204
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
205
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
206
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'db_index': 'True'})
207
        },
208
        'db.virtualmachine': {
209
            'Meta': {'object_name': 'VirtualMachine'},
210
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '30', 'null': 'True'}),
211
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machines'", 'null': 'True', 'on_delete': 'models.PROTECT', 'to': "orm['db.Backend']"}),
212
            'backend_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
213
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
214
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
215
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
216
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
217
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
218
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
219
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
220
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
221
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']", 'on_delete': 'models.PROTECT'}),
222
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
223
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
224
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
225
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
226
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'BUILD'", 'max_length': '30'}),
227
            'project': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
228
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machine'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.QuotaHolderSerial']"}),
229
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
230
            'task': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
231
            'task_job_id': ('django.db.models.fields.BigIntegerField', [], {'null': 'True'}),
232
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
233
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100', 'db_index': 'True'})
234
        },
235
        'db.virtualmachinediagnostic': {
236
            'Meta': {'ordering': "['-created']", 'object_name': 'VirtualMachineDiagnostic'},
237
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
238
            'details': ('django.db.models.fields.TextField', [], {'null': 'True'}),
239
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
240
            'level': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
241
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'diagnostics'", 'to': "orm['db.VirtualMachine']"}),
242
            'message': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
243
            'source': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
244
            'source_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True'})
245
        },
246
        'db.virtualmachinemetadata': {
247
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
248
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
249
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
250
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
251
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
252
        }
253
    }
254

    
255
    complete_apps = ['db']