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']
|