root / snf-cyclades-app / synnefo / db / migrations / 0001_initial.py @ 9ca32eaa
History | View | Annotate | Download (17.7 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 'SynnefoUser'
|
12 |
db.create_table('db_synnefouser', (
|
13 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
14 |
('name', self.gf('django.db.models.fields.CharField')(max_length=255)), |
15 |
('credit', self.gf('django.db.models.fields.IntegerField')()), |
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 |
)) |
19 |
db.send_create_signal('db', ['SynnefoUser']) |
20 |
|
21 |
# Adding model 'Image'
|
22 |
db.create_table('db_image', (
|
23 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
24 |
('name', self.gf('django.db.models.fields.CharField')(max_length=255)), |
25 |
('state', self.gf('django.db.models.fields.CharField')(max_length=30)), |
26 |
('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'], null=True, blank=True)), |
27 |
('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), |
28 |
('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), |
29 |
('sourcevm', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.VirtualMachine'], null=True)), |
30 |
)) |
31 |
db.send_create_signal('db', ['Image']) |
32 |
|
33 |
# Adding model 'ImageMetadata'
|
34 |
db.create_table('db_imagemetadata', (
|
35 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
36 |
('meta_key', self.gf('django.db.models.fields.CharField')(max_length=50)), |
37 |
('meta_value', self.gf('django.db.models.fields.CharField')(max_length=500)), |
38 |
('image', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.Image'])), |
39 |
)) |
40 |
db.send_create_signal('db', ['ImageMetadata']) |
41 |
|
42 |
# Adding model 'Limit'
|
43 |
db.create_table('db_limit', (
|
44 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
45 |
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])), |
46 |
('name', self.gf('django.db.models.fields.CharField')(max_length=30)), |
47 |
('value', self.gf('django.db.models.fields.IntegerField')()), |
48 |
)) |
49 |
db.send_create_signal('db', ['Limit']) |
50 |
|
51 |
# Adding model 'Flavor'
|
52 |
db.create_table('db_flavor', (
|
53 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
54 |
('cpu', self.gf('django.db.models.fields.IntegerField')(default=0)), |
55 |
('ram', self.gf('django.db.models.fields.IntegerField')(default=0)), |
56 |
('disk', self.gf('django.db.models.fields.IntegerField')(default=0)), |
57 |
)) |
58 |
db.send_create_signal('db', ['Flavor']) |
59 |
|
60 |
# Adding unique constraint on 'Flavor', fields ['cpu', 'ram', 'disk']
|
61 |
db.create_unique('db_flavor', ['cpu', 'ram', 'disk']) |
62 |
|
63 |
# Adding model 'FlavorCost'
|
64 |
db.create_table('db_flavorcost', (
|
65 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
66 |
('cost_active', self.gf('django.db.models.fields.PositiveIntegerField')()), |
67 |
('cost_inactive', self.gf('django.db.models.fields.PositiveIntegerField')()), |
68 |
('effective_from', self.gf('django.db.models.fields.DateTimeField')()), |
69 |
('flavor', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.Flavor'])), |
70 |
)) |
71 |
db.send_create_signal('db', ['FlavorCost']) |
72 |
|
73 |
# Adding model 'VirtualMachine'
|
74 |
db.create_table('db_virtualmachine', (
|
75 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
76 |
('name', self.gf('django.db.models.fields.CharField')(max_length=255)), |
77 |
('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])), |
78 |
('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), |
79 |
('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), |
80 |
('charged', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime(2011, 4, 12, 13, 36, 55, 200332))), |
81 |
('sourceimage', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.Image'])), |
82 |
('hostid', self.gf('django.db.models.fields.CharField')(max_length=100)), |
83 |
('ipfour', self.gf('django.db.models.fields.IPAddressField')(max_length=15)), |
84 |
('ipsix', self.gf('django.db.models.fields.CharField')(max_length=100)), |
85 |
('flavor', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.Flavor'])), |
86 |
('deleted', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), |
87 |
('suspended', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), |
88 |
('action', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)), |
89 |
('operstate', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)), |
90 |
('backendjobid', self.gf('django.db.models.fields.PositiveIntegerField')(null=True)), |
91 |
('backendopcode', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)), |
92 |
('backendjobstatus', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)), |
93 |
('backendlogmsg', self.gf('django.db.models.fields.TextField')(null=True)), |
94 |
)) |
95 |
db.send_create_signal('db', ['VirtualMachine']) |
96 |
|
97 |
# Adding model 'VirtualMachineGroup'
|
98 |
db.create_table('db_virtualmachinegroup', (
|
99 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
100 |
('name', self.gf('django.db.models.fields.CharField')(max_length=255)), |
101 |
('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), |
102 |
('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), |
103 |
('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])), |
104 |
)) |
105 |
db.send_create_signal('db', ['VirtualMachineGroup']) |
106 |
|
107 |
# Adding M2M table for field machines on 'VirtualMachineGroup'
|
108 |
db.create_table('db_virtualmachinegroup_machines', (
|
109 |
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), |
110 |
('virtualmachinegroup', models.ForeignKey(orm['db.virtualmachinegroup'], null=False)), |
111 |
('virtualmachine', models.ForeignKey(orm['db.virtualmachine'], null=False)) |
112 |
)) |
113 |
db.create_unique('db_virtualmachinegroup_machines', ['virtualmachinegroup_id', 'virtualmachine_id']) |
114 |
|
115 |
# Adding model 'VirtualMachineMetadata'
|
116 |
db.create_table('db_virtualmachinemetadata', (
|
117 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
118 |
('meta_key', self.gf('django.db.models.fields.CharField')(max_length=50)), |
119 |
('meta_value', self.gf('django.db.models.fields.CharField')(max_length=500)), |
120 |
('vm', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.VirtualMachine'])), |
121 |
)) |
122 |
db.send_create_signal('db', ['VirtualMachineMetadata']) |
123 |
|
124 |
# Adding model 'Debit'
|
125 |
db.create_table('db_debit', (
|
126 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
127 |
('when', self.gf('django.db.models.fields.DateTimeField')()), |
128 |
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'])), |
129 |
('vm', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.VirtualMachine'])), |
130 |
('description', self.gf('django.db.models.fields.TextField')()), |
131 |
)) |
132 |
db.send_create_signal('db', ['Debit']) |
133 |
|
134 |
# Adding model 'Disk'
|
135 |
db.create_table('db_disk', (
|
136 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), |
137 |
('name', self.gf('django.db.models.fields.CharField')(max_length=255)), |
138 |
('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), |
139 |
('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), |
140 |
('size', self.gf('django.db.models.fields.PositiveIntegerField')()), |
141 |
('vm', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.VirtualMachine'], null=True, blank=True)), |
142 |
('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'], null=True, blank=True)), |
143 |
)) |
144 |
db.send_create_signal('db', ['Disk']) |
145 |
|
146 |
|
147 |
def backwards(self, orm): |
148 |
|
149 |
# Deleting model 'SynnefoUser'
|
150 |
db.delete_table('db_synnefouser')
|
151 |
|
152 |
# Deleting model 'Image'
|
153 |
db.delete_table('db_image')
|
154 |
|
155 |
# Deleting model 'ImageMetadata'
|
156 |
db.delete_table('db_imagemetadata')
|
157 |
|
158 |
# Deleting model 'Limit'
|
159 |
db.delete_table('db_limit')
|
160 |
|
161 |
# Deleting model 'Flavor'
|
162 |
db.delete_table('db_flavor')
|
163 |
|
164 |
# Removing unique constraint on 'Flavor', fields ['cpu', 'ram', 'disk']
|
165 |
db.delete_unique('db_flavor', ['cpu', 'ram', 'disk']) |
166 |
|
167 |
# Deleting model 'FlavorCost'
|
168 |
db.delete_table('db_flavorcost')
|
169 |
|
170 |
# Deleting model 'VirtualMachine'
|
171 |
db.delete_table('db_virtualmachine')
|
172 |
|
173 |
# Deleting model 'VirtualMachineGroup'
|
174 |
db.delete_table('db_virtualmachinegroup')
|
175 |
|
176 |
# Removing M2M table for field machines on 'VirtualMachineGroup'
|
177 |
db.delete_table('db_virtualmachinegroup_machines')
|
178 |
|
179 |
# Deleting model 'VirtualMachineMetadata'
|
180 |
db.delete_table('db_virtualmachinemetadata')
|
181 |
|
182 |
# Deleting model 'Debit'
|
183 |
db.delete_table('db_debit')
|
184 |
|
185 |
# Deleting model 'Disk'
|
186 |
db.delete_table('db_disk')
|
187 |
|
188 |
|
189 |
models = { |
190 |
'db.debit': {
|
191 |
'Meta': {'object_name': 'Debit'}, |
192 |
'description': ('django.db.models.fields.TextField', [], {}), |
193 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
194 |
'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}), |
195 |
'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"}), |
196 |
'when': ('django.db.models.fields.DateTimeField', [], {}) |
197 |
}, |
198 |
'db.disk': {
|
199 |
'Meta': {'object_name': 'Disk'}, |
200 |
'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), |
201 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
202 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}), |
203 |
'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}), |
204 |
'size': ('django.db.models.fields.PositiveIntegerField', [], {}), |
205 |
'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}), |
206 |
'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True', 'blank': 'True'}) |
207 |
}, |
208 |
'db.flavor': {
|
209 |
'Meta': {'unique_together': "(('cpu', 'ram', 'disk'),)", 'object_name': 'Flavor'}, |
210 |
'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}), |
211 |
'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}), |
212 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
213 |
'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'}) |
214 |
}, |
215 |
'db.flavorcost': {
|
216 |
'Meta': {'object_name': 'FlavorCost'}, |
217 |
'cost_active': ('django.db.models.fields.PositiveIntegerField', [], {}), |
218 |
'cost_inactive': ('django.db.models.fields.PositiveIntegerField', [], {}), |
219 |
'effective_from': ('django.db.models.fields.DateTimeField', [], {}), |
220 |
'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}), |
221 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}) |
222 |
}, |
223 |
'db.image': {
|
224 |
'Meta': {'object_name': 'Image'}, |
225 |
'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), |
226 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
227 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}), |
228 |
'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']", 'null': 'True', 'blank': 'True'}), |
229 |
'sourcevm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True'}), |
230 |
'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}), |
231 |
'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}) |
232 |
}, |
233 |
'db.imagemetadata': {
|
234 |
'Meta': {'object_name': 'ImageMetadata'}, |
235 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
236 |
'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Image']"}), |
237 |
'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}), |
238 |
'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}) |
239 |
}, |
240 |
'db.limit': {
|
241 |
'Meta': {'object_name': 'Limit'}, |
242 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
243 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}), |
244 |
'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}), |
245 |
'value': ('django.db.models.fields.IntegerField', [], {}) |
246 |
}, |
247 |
'db.synnefouser': {
|
248 |
'Meta': {'object_name': 'SynnefoUser'}, |
249 |
'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), |
250 |
'credit': ('django.db.models.fields.IntegerField', [], {}), |
251 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
252 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}), |
253 |
'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}) |
254 |
}, |
255 |
'db.virtualmachine': {
|
256 |
'Meta': {'object_name': 'VirtualMachine'}, |
257 |
'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}), |
258 |
'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}), |
259 |
'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}), |
260 |
'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}), |
261 |
'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}), |
262 |
'charged': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2011, 4, 12, 13, 36, 55, 200332)'}), |
263 |
'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), |
264 |
'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), |
265 |
'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}), |
266 |
'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}), |
267 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
268 |
'ipfour': ('django.db.models.fields.IPAddressField', [], {'max_length': '15'}), |
269 |
'ipsix': ('django.db.models.fields.CharField', [], {'max_length': '100'}), |
270 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}), |
271 |
'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}), |
272 |
'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}), |
273 |
'sourceimage': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Image']"}), |
274 |
'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), |
275 |
'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}) |
276 |
}, |
277 |
'db.virtualmachinegroup': {
|
278 |
'Meta': {'object_name': 'VirtualMachineGroup'}, |
279 |
'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), |
280 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
281 |
'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'symmetrical': 'False'}), |
282 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}), |
283 |
'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.SynnefoUser']"}), |
284 |
'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}) |
285 |
}, |
286 |
'db.virtualmachinemetadata': {
|
287 |
'Meta': {'object_name': 'VirtualMachineMetadata'}, |
288 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), |
289 |
'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}), |
290 |
'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}), |
291 |
'vm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']"}) |
292 |
} |
293 |
} |
294 |
|
295 |
complete_apps = ['db']
|