Statistics
| Branch: | Tag: | Revision:

root / snf-app / synnefo / db / migrations / 0026_auto__del_legacy_fields.py @ 54ae949d

History | View | Annotate | Download (14.6 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
        # Deleting model 'FlavorCost'
12
        db.delete_table('db_flavorcost')
13

    
14
        # Deleting model 'Invitations'
15
        db.delete_table('db_invitations')
16

    
17
        # Deleting model 'VirtualMachineGroup'
18
        db.delete_table('db_virtualmachinegroup')
19

    
20
        # Removing M2M table for field machines on 'VirtualMachineGroup'
21
        db.delete_table('db_virtualmachinegroup_machines')
22

    
23
        # Deleting model 'Limit'
24
        db.delete_table('db_limit')
25

    
26
        # Deleting field 'SynnefoUser.credit'
27
        db.delete_column('db_synnefouser', 'credit')
28

    
29
        # Deleting field 'SynnefoUser.max_invitations'
30
        db.delete_column('db_synnefouser', 'max_invitations')
31

    
32

    
33
    def backwards(self, orm):
34
        
35
        # Adding model 'FlavorCost'
36
        db.create_table('db_flavorcost', (
37
            ('cost_active', self.gf('django.db.models.fields.PositiveIntegerField')()),
38
            ('effective_from', self.gf('django.db.models.fields.DateTimeField')()),
39
            ('flavor', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.Flavor'])),
40
            ('cost_inactive', self.gf('django.db.models.fields.PositiveIntegerField')()),
41
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
42
        ))
43
        db.send_create_signal('db', ['FlavorCost'])
44

    
45
        # Adding model 'Invitations'
46
        db.create_table('db_invitations', (
47
            ('source', self.gf('django.db.models.fields.related.ForeignKey')(related_name='source', to=orm['db.SynnefoUser'])),
48
            ('level', self.gf('django.db.models.fields.IntegerField')(null=True)),
49
            ('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
50
            ('target', self.gf('django.db.models.fields.related.ForeignKey')(related_name='target', to=orm['db.SynnefoUser'])),
51
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
52
            ('accepted', self.gf('django.db.models.fields.BooleanField')(default=False)),
53
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
54
        ))
55
        db.send_create_signal('db', ['Invitations'])
56

    
57
        # Adding model 'VirtualMachineGroup'
58
        db.create_table('db_virtualmachinegroup', (
59
            ('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
60
            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
61
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
62
            ('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])),
63
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
64
        ))
65
        db.send_create_signal('db', ['VirtualMachineGroup'])
66

    
67
        # Adding M2M table for field machines on 'VirtualMachineGroup'
68
        db.create_table('db_virtualmachinegroup_machines', (
69
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
70
            ('virtualmachinegroup', models.ForeignKey(orm['db.virtualmachinegroup'], null=False)),
71
            ('virtualmachine', models.ForeignKey(orm['db.virtualmachine'], null=False))
72
        ))
73
        db.create_unique('db_virtualmachinegroup_machines', ['virtualmachinegroup_id', 'virtualmachine_id'])
74

    
75
        # Adding model 'Limit'
76
        db.create_table('db_limit', (
77
            ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])),
78
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
79
            ('value', self.gf('django.db.models.fields.IntegerField')()),
80
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
81
        ))
82
        db.send_create_signal('db', ['Limit'])
83

    
84
        # Adding field 'SynnefoUser.credit'
85
        db.add_column('db_synnefouser', 'credit', self.gf('django.db.models.fields.IntegerField')(default=0), keep_default=False)
86

    
87
        # Adding field 'SynnefoUser.max_invitations'
88
        db.add_column('db_synnefouser', 'max_invitations', self.gf('django.db.models.fields.IntegerField')(null=True), keep_default=False)
89

    
90

    
91
    models = {
92
        'db.debit': {
93
            'Meta': {'object_name': 'Debit'},
94
            'description': ('django.db.models.fields.TextField', [], {}),
95
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
96
            'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
97
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"}),
98
            'when': ('django.db.models.fields.DateTimeField', [], {})
99
        },
100
        'db.disk': {
101
            'Meta': {'object_name': 'Disk'},
102
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
103
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
104
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
105
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}),
106
            'size': ('django.db.models.fields.PositiveIntegerField', [], {}),
107
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
108
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True', 'blank': 'True'})
109
        },
110
        'db.flavor': {
111
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk'),)", 'object_name': 'Flavor'},
112
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
113
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
114
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
115
            'disk_template': ('django.db.models.fields.CharField', [], {'default': "'drbd'", 'max_length': '32'}),
116
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
117
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
118
        },
119
        'db.image': {
120
            'Meta': {'object_name': 'Image'},
121
            'backend_id': ('django.db.models.fields.CharField', [], {'default': "'debian_base'", 'max_length': '50'}),
122
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
123
            'format': ('django.db.models.fields.CharField', [], {'default': "'dump'", 'max_length': '30'}),
124
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
125
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
126
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}),
127
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
128
            'sourcevm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True'}),
129
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
130
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
131
        },
132
        'db.imagemetadata': {
133
            'Meta': {'unique_together': "(('meta_key', 'image'),)", 'object_name': 'ImageMetadata'},
134
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
135
            'image': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.Image']"}),
136
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
137
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'})
138
        },
139
        'db.network': {
140
            'Meta': {'object_name': 'Network'},
141
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
142
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
143
            'link': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['db.NetworkLink']"}),
144
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
145
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
146
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True'}),
147
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
148
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
149
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
150
        },
151
        'db.networkinterface': {
152
            'Meta': {'object_name': 'NetworkInterface'},
153
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
154
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
155
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
156
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
157
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
158
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
159
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '17', 'null': 'True'}),
160
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
161
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
162
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
163
        },
164
        'db.networklink': {
165
            'Meta': {'object_name': 'NetworkLink'},
166
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
167
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
168
            'index': ('django.db.models.fields.IntegerField', [], {}),
169
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
170
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'to': "orm['db.Network']"})
171
        },
172
        'db.synnefouser': {
173
            'Meta': {'object_name': 'SynnefoUser'},
174
            'auth_token': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
175
            'auth_token_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
176
            'auth_token_expires': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
177
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
178
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
179
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255'}),
180
            'realname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255'}),
181
            'state': ('django.db.models.fields.CharField', [], {'default': "'ACTIVE'", 'max_length': '30'}),
182
            'tmp_auth_token': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
183
            'tmp_auth_token_expires': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
184
            'type': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
185
            'uniq': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
186
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
187
        },
188
        'db.virtualmachine': {
189
            'Meta': {'object_name': 'VirtualMachine'},
190
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
191
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
192
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
193
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
194
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
195
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
196
            'charged': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2012, 1, 23, 13, 34, 33, 344061)'}),
197
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
198
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
199
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
200
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
201
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
202
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
203
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
204
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
205
            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}),
206
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
207
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
208
        },
209
        'db.virtualmachinemetadata': {
210
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
211
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
212
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
213
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
214
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
215
        }
216
    }
217

    
218
    complete_apps = ['db']