Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0006_auto__add_networkinterface.py @ df8a7015

History | View | Annotate | Download (13.3 kB)

1 f533f224 Vangelis Koukis
# encoding: utf-8
2 f533f224 Vangelis Koukis
import datetime
3 f533f224 Vangelis Koukis
from south.db import db
4 f533f224 Vangelis Koukis
from south.v2 import SchemaMigration
5 f533f224 Vangelis Koukis
from django.db import models
6 f533f224 Vangelis Koukis
7 f533f224 Vangelis Koukis
class Migration(SchemaMigration):
8 f533f224 Vangelis Koukis
9 f533f224 Vangelis Koukis
    def forwards(self, orm):
10 f533f224 Vangelis Koukis
        
11 f533f224 Vangelis Koukis
        # Adding model 'NetworkInterface'
12 f533f224 Vangelis Koukis
        db.create_table('db_networkinterface', (
13 f533f224 Vangelis Koukis
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
14 f533f224 Vangelis Koukis
            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(related_name='nics', to=orm['db.VirtualMachine'])),
15 f533f224 Vangelis Koukis
            ('network', self.gf('django.db.models.fields.related.ForeignKey')(related_name='nics', to=orm['db.Network'])),
16 f533f224 Vangelis Koukis
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
17 f533f224 Vangelis Koukis
            ('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
18 f533f224 Vangelis Koukis
            ('index', self.gf('django.db.models.fields.IntegerField')(null=True)),
19 f533f224 Vangelis Koukis
            ('mac', self.gf('django.db.models.fields.CharField')(max_length=17, null=True)),
20 f533f224 Vangelis Koukis
            ('ipv4', self.gf('django.db.models.fields.IPAddressField')(max_length=15, null=True)),
21 f533f224 Vangelis Koukis
            ('ipv6', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
22 f533f224 Vangelis Koukis
            ('firewall_profile', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
23 f533f224 Vangelis Koukis
        ))
24 f533f224 Vangelis Koukis
        db.send_create_signal('db', ['NetworkInterface'])
25 f533f224 Vangelis Koukis
26 f533f224 Vangelis Koukis
        # Deleting field 'VirtualMachine.ipsix'
27 f533f224 Vangelis Koukis
        db.delete_column('db_virtualmachine', 'ipsix')
28 f533f224 Vangelis Koukis
29 f533f224 Vangelis Koukis
        # Deleting field 'VirtualMachine.ipfour'
30 f533f224 Vangelis Koukis
        db.delete_column('db_virtualmachine', 'ipfour')
31 f533f224 Vangelis Koukis
32 f533f224 Vangelis Koukis
        # Adding field 'Network.state'
33 f533f224 Vangelis Koukis
        db.add_column('db_network', 'state', self.gf('django.db.models.fields.CharField')(default='ACTIVE', max_length=30), keep_default=False)
34 f533f224 Vangelis Koukis
35 f533f224 Vangelis Koukis
        # Adding field 'Network.public'
36 f533f224 Vangelis Koukis
        db.add_column('db_network', 'public', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True), keep_default=False)
37 f533f224 Vangelis Koukis
38 f533f224 Vangelis Koukis
        # Removing M2M table for field machines on 'Network'
39 f533f224 Vangelis Koukis
        db.delete_table('db_network_machines')
40 f533f224 Vangelis Koukis
41 f533f224 Vangelis Koukis
42 f533f224 Vangelis Koukis
    def backwards(self, orm):
43 f533f224 Vangelis Koukis
        
44 f533f224 Vangelis Koukis
        # Deleting model 'NetworkInterface'
45 f533f224 Vangelis Koukis
        db.delete_table('db_networkinterface')
46 f533f224 Vangelis Koukis
47 f533f224 Vangelis Koukis
        # Adding field 'VirtualMachine.ipsix'
48 f533f224 Vangelis Koukis
        db.add_column('db_virtualmachine', 'ipsix', self.gf('django.db.models.fields.CharField')(default='', max_length=100), keep_default=False)
49 f533f224 Vangelis Koukis
50 f533f224 Vangelis Koukis
        # Adding field 'VirtualMachine.ipfour'
51 f533f224 Vangelis Koukis
        db.add_column('db_virtualmachine', 'ipfour', self.gf('django.db.models.fields.IPAddressField')(default='', max_length=15), keep_default=False)
52 f533f224 Vangelis Koukis
53 f533f224 Vangelis Koukis
        # Deleting field 'Network.state'
54 f533f224 Vangelis Koukis
        db.delete_column('db_network', 'state')
55 f533f224 Vangelis Koukis
56 f533f224 Vangelis Koukis
        # Deleting field 'Network.public'
57 f533f224 Vangelis Koukis
        db.delete_column('db_network', 'public')
58 f533f224 Vangelis Koukis
59 f533f224 Vangelis Koukis
        # Adding M2M table for field machines on 'Network'
60 f533f224 Vangelis Koukis
        db.create_table('db_network_machines', (
61 f533f224 Vangelis Koukis
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
62 f533f224 Vangelis Koukis
            ('network', models.ForeignKey(orm['db.network'], null=False)),
63 f533f224 Vangelis Koukis
            ('virtualmachine', models.ForeignKey(orm['db.virtualmachine'], null=False))
64 f533f224 Vangelis Koukis
        ))
65 f533f224 Vangelis Koukis
        db.create_unique('db_network_machines', ['network_id', 'virtualmachine_id'])
66 f533f224 Vangelis Koukis
67 f533f224 Vangelis Koukis
68 f533f224 Vangelis Koukis
    models = {
69 f533f224 Vangelis Koukis
        'db.debit': {
70 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'Debit'},
71 f533f224 Vangelis Koukis
            'description': ('django.db.models.fields.TextField', [], {}),
72 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
73 f533f224 Vangelis Koukis
            'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
74 f533f224 Vangelis Koukis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"}),
75 f533f224 Vangelis Koukis
            'when': ('django.db.models.fields.DateTimeField', [], {})
76 f533f224 Vangelis Koukis
        },
77 f533f224 Vangelis Koukis
        'db.disk': {
78 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'Disk'},
79 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
80 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
81 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
82 f533f224 Vangelis Koukis
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}),
83 f533f224 Vangelis Koukis
            'size': ('django.db.models.fields.PositiveIntegerField', [], {}),
84 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
85 f533f224 Vangelis Koukis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True', 'blank': 'True'})
86 f533f224 Vangelis Koukis
        },
87 f533f224 Vangelis Koukis
        'db.flavor': {
88 f533f224 Vangelis Koukis
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk'),)", 'object_name': 'Flavor'},
89 f533f224 Vangelis Koukis
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
90 f533f224 Vangelis Koukis
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
91 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
92 f533f224 Vangelis Koukis
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
93 f533f224 Vangelis Koukis
        },
94 f533f224 Vangelis Koukis
        'db.flavorcost': {
95 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'FlavorCost'},
96 f533f224 Vangelis Koukis
            'cost_active': ('django.db.models.fields.PositiveIntegerField', [], {}),
97 f533f224 Vangelis Koukis
            'cost_inactive': ('django.db.models.fields.PositiveIntegerField', [], {}),
98 f533f224 Vangelis Koukis
            'effective_from': ('django.db.models.fields.DateTimeField', [], {}),
99 f533f224 Vangelis Koukis
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
100 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
101 f533f224 Vangelis Koukis
        },
102 f533f224 Vangelis Koukis
        'db.image': {
103 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'Image'},
104 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
105 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
106 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
107 f533f224 Vangelis Koukis
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}),
108 f533f224 Vangelis Koukis
            'sourcevm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True'}),
109 f533f224 Vangelis Koukis
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
110 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
111 f533f224 Vangelis Koukis
        },
112 f533f224 Vangelis Koukis
        'db.imagemetadata': {
113 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'ImageMetadata'},
114 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
115 f533f224 Vangelis Koukis
            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Image']"}),
116 f533f224 Vangelis Koukis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
117 f533f224 Vangelis Koukis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'})
118 f533f224 Vangelis Koukis
        },
119 f533f224 Vangelis Koukis
        'db.limit': {
120 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'Limit'},
121 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
122 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
123 f533f224 Vangelis Koukis
            'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
124 f533f224 Vangelis Koukis
            'value': ('django.db.models.fields.IntegerField', [], {})
125 f533f224 Vangelis Koukis
        },
126 f533f224 Vangelis Koukis
        'db.network': {
127 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'Network'},
128 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
129 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
130 f533f224 Vangelis Koukis
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
131 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
132 f533f224 Vangelis Koukis
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
133 f533f224 Vangelis Koukis
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
134 f533f224 Vangelis Koukis
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
135 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
136 f533f224 Vangelis Koukis
        },
137 f533f224 Vangelis Koukis
        'db.networkinterface': {
138 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'NetworkInterface'},
139 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
140 f533f224 Vangelis Koukis
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
141 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
142 f533f224 Vangelis Koukis
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
143 f533f224 Vangelis Koukis
            'ipv4': ('django.db.models.fields.IPAddressField', [], {'max_length': '15', 'null': 'True'}),
144 f533f224 Vangelis Koukis
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
145 f533f224 Vangelis Koukis
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '17', 'null': 'True'}),
146 f533f224 Vangelis Koukis
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
147 f533f224 Vangelis Koukis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
148 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
149 f533f224 Vangelis Koukis
        },
150 f533f224 Vangelis Koukis
        'db.synnefouser': {
151 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'SynnefoUser'},
152 f533f224 Vangelis Koukis
            'auth_token': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
153 f533f224 Vangelis Koukis
            'auth_token_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
154 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
155 f533f224 Vangelis Koukis
            'credit': ('django.db.models.fields.IntegerField', [], {}),
156 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
157 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255'}),
158 f533f224 Vangelis Koukis
            'realname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255'}),
159 f533f224 Vangelis Koukis
            'type': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
160 f533f224 Vangelis Koukis
            'uniq': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
161 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
162 f533f224 Vangelis Koukis
        },
163 f533f224 Vangelis Koukis
        'db.virtualmachine': {
164 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'VirtualMachine'},
165 f533f224 Vangelis Koukis
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
166 f533f224 Vangelis Koukis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
167 f533f224 Vangelis Koukis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
168 f533f224 Vangelis Koukis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
169 f533f224 Vangelis Koukis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
170 f533f224 Vangelis Koukis
            'charged': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2011, 5, 25, 10, 10, 33, 528191)'}),
171 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
172 f533f224 Vangelis Koukis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
173 f533f224 Vangelis Koukis
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
174 f533f224 Vangelis Koukis
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
175 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
176 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
177 f533f224 Vangelis Koukis
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
178 f533f224 Vangelis Koukis
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
179 f533f224 Vangelis Koukis
            'sourceimage': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Image']"}),
180 f533f224 Vangelis Koukis
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
181 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
182 f533f224 Vangelis Koukis
        },
183 f533f224 Vangelis Koukis
        'db.virtualmachinegroup': {
184 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'VirtualMachineGroup'},
185 f533f224 Vangelis Koukis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
186 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
187 f533f224 Vangelis Koukis
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'symmetrical': 'False'}),
188 f533f224 Vangelis Koukis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
189 f533f224 Vangelis Koukis
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
190 f533f224 Vangelis Koukis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
191 f533f224 Vangelis Koukis
        },
192 f533f224 Vangelis Koukis
        'db.virtualmachinemetadata': {
193 f533f224 Vangelis Koukis
            'Meta': {'object_name': 'VirtualMachineMetadata'},
194 f533f224 Vangelis Koukis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
195 f533f224 Vangelis Koukis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
196 f533f224 Vangelis Koukis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
197 f533f224 Vangelis Koukis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"})
198 f533f224 Vangelis Koukis
        }
199 f533f224 Vangelis Koukis
    }
200 f533f224 Vangelis Koukis
201 f533f224 Vangelis Koukis
    complete_apps = ['db']