Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0027_auto__del_legacy_fields.py @ 9290cfab

History | View | Annotate | Download (14.8 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 model 'Debit'
27
        db.delete_table('db_debit')
28

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

    
32
        # Deleting field 'SynnefoUser.max_invitations'
33
        db.delete_column('db_synnefouser', 'max_invitations')
34

    
35

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

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

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

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

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

    
87
        # Adding model 'Debit'
88
        db.create_table('db_debit', (
89
            ('description', self.gf('django.db.models.fields.TextField')()),
90
            ('when', self.gf('django.db.models.fields.DateTimeField')()),
91
            ('vm', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.VirtualMachine'])),
92
            ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])),
93
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
94
        ))
95
        db.send_create_signal('db', ['Debit'])
96

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

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

    
103

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

    
223
    complete_apps = ['db']