Statistics
| Branch: | Tag: | Revision:

root / snf-app / synnefo / db / migrations / 0006_auto__add_networkinterface.py @ 483c9197

History | View | Annotate | Download (13.3 kB)

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 'NetworkInterface'
12
        db.create_table('db_networkinterface', (
13
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
14
            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(related_name='nics', to=orm['db.VirtualMachine'])),
15
            ('network', self.gf('django.db.models.fields.related.ForeignKey')(related_name='nics', to=orm['db.Network'])),
16
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
17
            ('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
18
            ('index', self.gf('django.db.models.fields.IntegerField')(null=True)),
19
            ('mac', self.gf('django.db.models.fields.CharField')(max_length=17, null=True)),
20
            ('ipv4', self.gf('django.db.models.fields.IPAddressField')(max_length=15, null=True)),
21
            ('ipv6', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
22
            ('firewall_profile', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
23
        ))
24
        db.send_create_signal('db', ['NetworkInterface'])
25

    
26
        # Deleting field 'VirtualMachine.ipsix'
27
        db.delete_column('db_virtualmachine', 'ipsix')
28

    
29
        # Deleting field 'VirtualMachine.ipfour'
30
        db.delete_column('db_virtualmachine', 'ipfour')
31

    
32
        # Adding field 'Network.state'
33
        db.add_column('db_network', 'state', self.gf('django.db.models.fields.CharField')(default='ACTIVE', max_length=30), keep_default=False)
34

    
35
        # Adding field 'Network.public'
36
        db.add_column('db_network', 'public', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True), keep_default=False)
37

    
38
        # Removing M2M table for field machines on 'Network'
39
        db.delete_table('db_network_machines')
40

    
41

    
42
    def backwards(self, orm):
43
        
44
        # Deleting model 'NetworkInterface'
45
        db.delete_table('db_networkinterface')
46

    
47
        # Adding field 'VirtualMachine.ipsix'
48
        db.add_column('db_virtualmachine', 'ipsix', self.gf('django.db.models.fields.CharField')(default='', max_length=100), keep_default=False)
49

    
50
        # Adding field 'VirtualMachine.ipfour'
51
        db.add_column('db_virtualmachine', 'ipfour', self.gf('django.db.models.fields.IPAddressField')(default='', max_length=15), keep_default=False)
52

    
53
        # Deleting field 'Network.state'
54
        db.delete_column('db_network', 'state')
55

    
56
        # Deleting field 'Network.public'
57
        db.delete_column('db_network', 'public')
58

    
59
        # Adding M2M table for field machines on 'Network'
60
        db.create_table('db_network_machines', (
61
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
62
            ('network', models.ForeignKey(orm['db.network'], null=False)),
63
            ('virtualmachine', models.ForeignKey(orm['db.virtualmachine'], null=False))
64
        ))
65
        db.create_unique('db_network_machines', ['network_id', 'virtualmachine_id'])
66

    
67

    
68
    models = {
69
        'db.debit': {
70
            'Meta': {'object_name': 'Debit'},
71
            'description': ('django.db.models.fields.TextField', [], {}),
72
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
73
            'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
74
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"}),
75
            'when': ('django.db.models.fields.DateTimeField', [], {})
76
        },
77
        'db.disk': {
78
            'Meta': {'object_name': 'Disk'},
79
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
80
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
81
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
82
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}),
83
            'size': ('django.db.models.fields.PositiveIntegerField', [], {}),
84
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
85
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True', 'blank': 'True'})
86
        },
87
        'db.flavor': {
88
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk'),)", 'object_name': 'Flavor'},
89
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
90
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
91
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
92
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
93
        },
94
        'db.flavorcost': {
95
            'Meta': {'object_name': 'FlavorCost'},
96
            'cost_active': ('django.db.models.fields.PositiveIntegerField', [], {}),
97
            'cost_inactive': ('django.db.models.fields.PositiveIntegerField', [], {}),
98
            'effective_from': ('django.db.models.fields.DateTimeField', [], {}),
99
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
100
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
101
        },
102
        'db.image': {
103
            'Meta': {'object_name': 'Image'},
104
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
105
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
106
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
107
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}),
108
            'sourcevm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True'}),
109
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
110
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
111
        },
112
        'db.imagemetadata': {
113
            'Meta': {'object_name': 'ImageMetadata'},
114
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
115
            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Image']"}),
116
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
117
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'})
118
        },
119
        'db.limit': {
120
            'Meta': {'object_name': 'Limit'},
121
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
122
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
123
            'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
124
            'value': ('django.db.models.fields.IntegerField', [], {})
125
        },
126
        'db.network': {
127
            'Meta': {'object_name': 'Network'},
128
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
129
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
130
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
131
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
132
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
133
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
134
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
135
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
136
        },
137
        'db.networkinterface': {
138
            'Meta': {'object_name': 'NetworkInterface'},
139
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
140
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
141
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
142
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
143
            'ipv4': ('django.db.models.fields.IPAddressField', [], {'max_length': '15', 'null': 'True'}),
144
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
145
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '17', 'null': 'True'}),
146
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
147
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
148
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
149
        },
150
        'db.synnefouser': {
151
            'Meta': {'object_name': 'SynnefoUser'},
152
            'auth_token': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
153
            'auth_token_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
154
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
155
            'credit': ('django.db.models.fields.IntegerField', [], {}),
156
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
157
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255'}),
158
            'realname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255'}),
159
            'type': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
160
            'uniq': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
161
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
162
        },
163
        'db.virtualmachine': {
164
            'Meta': {'object_name': 'VirtualMachine'},
165
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
166
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
167
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
168
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
169
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
170
            'charged': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2011, 5, 25, 10, 10, 33, 528191)'}),
171
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
172
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
173
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
174
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
175
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
176
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
177
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
178
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
179
            'sourceimage': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Image']"}),
180
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
181
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
182
        },
183
        'db.virtualmachinegroup': {
184
            'Meta': {'object_name': 'VirtualMachineGroup'},
185
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
186
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
187
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'symmetrical': 'False'}),
188
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
189
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
190
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
191
        },
192
        'db.virtualmachinemetadata': {
193
            'Meta': {'object_name': 'VirtualMachineMetadata'},
194
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
195
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
196
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
197
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"})
198
        }
199
    }
200

    
201
    complete_apps = ['db']