Revision 259459b0

b/snf-cyclades-app/synnefo/db/migrations/0069_auto__add_floatingip__add_field_virtualmachine_task__add_field_virtual.py
1
# encoding: 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
class Migration(SchemaMigration):
8

  
9
    def forwards(self, orm):
10
        
11
        # Adding model 'FloatingIP'
12
        db.create_table('db_floatingip', (
13
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
14
            ('userid', self.gf('django.db.models.fields.CharField')(max_length=128, db_index=True)),
15
            ('ipv4', self.gf('django.db.models.fields.IPAddressField')(unique=True, max_length=15, db_index=True)),
16
            ('network', self.gf('django.db.models.fields.related.ForeignKey')(related_name='floating_ips', to=orm['db.Network'])),
17
            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(related_name='floating_ips', null=True, to=orm['db.VirtualMachine'])),
18
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
19
            ('deleted', self.gf('django.db.models.fields.BooleanField')(default=False)),
20
            ('serial', self.gf('django.db.models.fields.related.ForeignKey')(related_name='floating_ips', null=True, to=orm['db.QuotaHolderSerial'])),
21
        ))
22
        db.send_create_signal('db', ['FloatingIP'])
23

  
24
        # Adding field 'VirtualMachine.task'
25
        db.add_column('db_virtualmachine', 'task', self.gf('django.db.models.fields.CharField')(max_length=64, null=True), keep_default=False)
26

  
27
        # Adding field 'VirtualMachine.task_job_id'
28
        db.add_column('db_virtualmachine', 'task_job_id', self.gf('django.db.models.fields.BigIntegerField')(max_length=64, null=True), keep_default=False)
29

  
30
        # Changing field 'VirtualMachine.operstate'
31
        db.alter_column('db_virtualmachine', 'operstate', self.gf('django.db.models.fields.CharField')(max_length=30))
32

  
33
        # Adding field 'Network.floating_ip_pool'
34
        db.add_column('db_network', 'floating_ip_pool', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False)
35

  
36

  
37
    def backwards(self, orm):
38
        
39
        # Deleting model 'FloatingIP'
40
        db.delete_table('db_floatingip')
41

  
42
        # Deleting field 'VirtualMachine.task'
43
        db.delete_column('db_virtualmachine', 'task')
44

  
45
        # Deleting field 'VirtualMachine.task_job_id'
46
        db.delete_column('db_virtualmachine', 'task_job_id')
47

  
48
        # Changing field 'VirtualMachine.operstate'
49
        db.alter_column('db_virtualmachine', 'operstate', self.gf('django.db.models.fields.CharField')(max_length=30, null=True))
50

  
51
        # Deleting field 'Network.floating_ip_pool'
52
        db.delete_column('db_network', 'floating_ip_pool')
53

  
54

  
55
    models = {
56
        'db.backend': {
57
            'Meta': {'ordering': "['clustername']", 'object_name': 'Backend'},
58
            'clustername': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}),
59
            'ctotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
60
            'dfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
61
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
62
            'dtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
63
            'hash': ('django.db.models.fields.CharField', [], {'max_length': '40'}),
64
            'hypervisor': ('django.db.models.fields.CharField', [], {'default': "'kvm'", 'max_length': '32'}),
65
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
66
            'index': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'unique': 'True'}),
67
            'mfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
68
            'mtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
69
            'offline': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
70
            'password_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
71
            'pinst_cnt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
72
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'default': '5080'}),
73
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
74
            'username': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'})
75
        },
76
        'db.backendnetwork': {
77
            'Meta': {'unique_together': "(('network', 'backend'),)", 'object_name': 'BackendNetwork'},
78
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'networks'", 'to': "orm['db.Backend']"}),
79
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
80
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
81
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
82
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
83
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
84
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
85
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
86
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
87
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
88
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'backend_networks'", 'to': "orm['db.Network']"}),
89
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '30'}),
90
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
91
        },
92
        'db.bridgepooltable': {
93
            'Meta': {'object_name': 'BridgePoolTable'},
94
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
95
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
96
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
97
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
98
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
99
            'size': ('django.db.models.fields.IntegerField', [], {})
100
        },
101
        'db.flavor': {
102
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk', 'disk_template'),)", 'object_name': 'Flavor'},
103
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
104
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
105
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
106
            'disk_template': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
107
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
108
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
109
        },
110
        'db.floatingip': {
111
            'Meta': {'object_name': 'FloatingIP'},
112
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
113
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
114
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
115
            'ipv4': ('django.db.models.fields.IPAddressField', [], {'unique': 'True', 'max_length': '15', 'db_index': 'True'}),
116
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'floating_ips'", 'null': 'True', 'to': "orm['db.VirtualMachine']"}),
117
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'floating_ips'", 'to': "orm['db.Network']"}),
118
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'floating_ips'", 'null': 'True', 'to': "orm['db.QuotaHolderSerial']"}),
119
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'db_index': 'True'})
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
        },
130
        'db.macprefixpooltable': {
131
            'Meta': {'object_name': 'MacPrefixPoolTable'},
132
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
133
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
134
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
135
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
136
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
137
            'size': ('django.db.models.fields.IntegerField', [], {})
138
        },
139
        'db.network': {
140
            'Meta': {'object_name': 'Network'},
141
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '32', 'null': 'True'}),
142
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
143
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
144
            'dhcp': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
145
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
146
            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
147
            'floating_ip_pool': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
148
            'gateway': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
149
            'gateway6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
150
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
151
            'link': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
152
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
153
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
154
            'mode': ('django.db.models.fields.CharField', [], {'max_length': '16', 'null': 'True'}),
155
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
156
            'pool': ('django.db.models.fields.related.OneToOneField', [], {'related_name': "'network'", 'unique': 'True', 'null': 'True', 'to': "orm['db.IPPoolTable']"}),
157
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
158
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'network'", 'null': 'True', 'to': "orm['db.QuotaHolderSerial']"}),
159
            'state': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '32'}),
160
            'subnet': ('django.db.models.fields.CharField', [], {'default': "'10.0.0.0/24'", 'max_length': '32'}),
161
            'subnet6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
162
            'tags': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
163
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
164
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'db_index': 'True'})
165
        },
166
        'db.networkinterface': {
167
            'Meta': {'object_name': 'NetworkInterface'},
168
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
169
            'dirty': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
170
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
171
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
172
            'index': ('django.db.models.fields.IntegerField', [], {}),
173
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
174
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
175
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '32', 'unique': 'True', 'null': 'True'}),
176
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
177
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
178
            'state': ('django.db.models.fields.CharField', [], {'default': "'ACTIVE'", 'max_length': '32'}),
179
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
180
        },
181
        'db.quotaholderserial': {
182
            'Meta': {'ordering': "['serial']", 'object_name': 'QuotaHolderSerial'},
183
            'accept': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
184
            'pending': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'db_index': 'True'}),
185
            'resolved': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
186
            'serial': ('django.db.models.fields.BigIntegerField', [], {'primary_key': 'True', 'db_index': 'True'})
187
        },
188
        'db.virtualmachine': {
189
            'Meta': {'object_name': 'VirtualMachine'},
190
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '30', 'null': 'True'}),
191
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machines'", 'null': 'True', 'to': "orm['db.Backend']"}),
192
            'backend_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
193
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
194
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
195
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
196
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
197
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
198
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
199
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
200
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
201
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
202
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
203
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
204
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
205
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
206
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'BUILD'", 'max_length': '30'}),
207
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machine'", 'null': 'True', 'to': "orm['db.QuotaHolderSerial']"}),
208
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
209
            'task': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
210
            'task_job_id': ('django.db.models.fields.BigIntegerField', [], {'max_length': '64', 'null': 'True'}),
211
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
212
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100', 'db_index': 'True'})
213
        },
214
        'db.virtualmachinediagnostic': {
215
            'Meta': {'ordering': "['-created']", 'object_name': 'VirtualMachineDiagnostic'},
216
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
217
            'details': ('django.db.models.fields.TextField', [], {'null': 'True'}),
218
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
219
            'level': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
220
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'diagnostics'", 'to': "orm['db.VirtualMachine']"}),
221
            'message': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
222
            'source': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
223
            'source_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True'})
224
        },
225
        'db.virtualmachinemetadata': {
226
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
227
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
228
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
229
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
230
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
231
        }
232
    }
233

  
234
    complete_apps = ['db']

Also available in: Unified diff