Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0031_auto__del_imagemetadata__del_unique_imagemetadata_meta_key_image__del_.py @ 4911365b

History | View | Annotate | Download (8.3 kB)

1 6ef51e9f Giorgos Verigakis
# encoding: utf-8
2 6ef51e9f Giorgos Verigakis
import datetime
3 6ef51e9f Giorgos Verigakis
from south.db import db
4 6ef51e9f Giorgos Verigakis
from south.v2 import SchemaMigration
5 6ef51e9f Giorgos Verigakis
from django.db import models
6 6ef51e9f Giorgos Verigakis
7 6ef51e9f Giorgos Verigakis
class Migration(SchemaMigration):
8 6ef51e9f Giorgos Verigakis
9 6ef51e9f Giorgos Verigakis
    def forwards(self, orm):
10 6ef51e9f Giorgos Verigakis
        
11 6ef51e9f Giorgos Verigakis
        # Removing unique constraint on 'ImageMetadata', fields ['meta_key', 'image']
12 6ef51e9f Giorgos Verigakis
        db.delete_unique('db_imagemetadata', ['meta_key', 'image_id'])
13 6ef51e9f Giorgos Verigakis
14 6ef51e9f Giorgos Verigakis
        # Deleting model 'ImageMetadata'
15 6ef51e9f Giorgos Verigakis
        db.delete_table('db_imagemetadata')
16 6ef51e9f Giorgos Verigakis
17 6ef51e9f Giorgos Verigakis
        # Deleting model 'Image'
18 6ef51e9f Giorgos Verigakis
        db.delete_table('db_image')
19 6ef51e9f Giorgos Verigakis
20 6ef51e9f Giorgos Verigakis
        # Deleting field 'VirtualMachine.charged'
21 6ef51e9f Giorgos Verigakis
        db.delete_column('db_virtualmachine', 'charged')
22 6ef51e9f Giorgos Verigakis
23 6ef51e9f Giorgos Verigakis
24 6ef51e9f Giorgos Verigakis
    def backwards(self, orm):
25 6ef51e9f Giorgos Verigakis
        
26 6ef51e9f Giorgos Verigakis
        # Adding model 'ImageMetadata'
27 6ef51e9f Giorgos Verigakis
        db.create_table('db_imagemetadata', (
28 6ef51e9f Giorgos Verigakis
            ('meta_value', self.gf('django.db.models.fields.CharField')(max_length=500)),
29 6ef51e9f Giorgos Verigakis
            ('image', self.gf('django.db.models.fields.related.ForeignKey')(related_name='metadata', to=orm['db.Image'])),
30 6ef51e9f Giorgos Verigakis
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
31 6ef51e9f Giorgos Verigakis
            ('meta_key', self.gf('django.db.models.fields.CharField')(max_length=50)),
32 6ef51e9f Giorgos Verigakis
        ))
33 6ef51e9f Giorgos Verigakis
        db.send_create_signal('db', ['ImageMetadata'])
34 6ef51e9f Giorgos Verigakis
35 6ef51e9f Giorgos Verigakis
        # Adding unique constraint on 'ImageMetadata', fields ['meta_key', 'image']
36 6ef51e9f Giorgos Verigakis
        db.create_unique('db_imagemetadata', ['meta_key', 'image_id'])
37 6ef51e9f Giorgos Verigakis
38 6ef51e9f Giorgos Verigakis
        # Adding model 'Image'
39 6ef51e9f Giorgos Verigakis
        db.create_table('db_image', (
40 6ef51e9f Giorgos Verigakis
            ('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
41 6ef51e9f Giorgos Verigakis
            ('format', self.gf('django.db.models.fields.CharField')(default='dump', max_length=30)),
42 6ef51e9f Giorgos Verigakis
            ('sourcevm', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.VirtualMachine'], null=True)),
43 6ef51e9f Giorgos Verigakis
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
44 6ef51e9f Giorgos Verigakis
            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
45 6ef51e9f Giorgos Verigakis
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
46 6ef51e9f Giorgos Verigakis
            ('backend_id', self.gf('django.db.models.fields.CharField')(default='debian_base', max_length=50)),
47 6ef51e9f Giorgos Verigakis
            ('userid', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
48 6ef51e9f Giorgos Verigakis
            ('state', self.gf('django.db.models.fields.CharField')(max_length=30)),
49 6ef51e9f Giorgos Verigakis
            ('public', self.gf('django.db.models.fields.BooleanField')(default=False)),
50 6ef51e9f Giorgos Verigakis
        ))
51 6ef51e9f Giorgos Verigakis
        db.send_create_signal('db', ['Image'])
52 6ef51e9f Giorgos Verigakis
53 6ef51e9f Giorgos Verigakis
        # Adding field 'VirtualMachine.charged'
54 6ef51e9f Giorgos Verigakis
        db.add_column('db_virtualmachine', 'charged', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime(2012, 1, 23, 15, 32, 51, 475392)), keep_default=False)
55 6ef51e9f Giorgos Verigakis
56 6ef51e9f Giorgos Verigakis
57 6ef51e9f Giorgos Verigakis
    models = {
58 6ef51e9f Giorgos Verigakis
        'db.flavor': {
59 6ef51e9f Giorgos Verigakis
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk'),)", 'object_name': 'Flavor'},
60 6ef51e9f Giorgos Verigakis
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
61 6ef51e9f Giorgos Verigakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
62 6ef51e9f Giorgos Verigakis
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
63 6ef51e9f Giorgos Verigakis
            'disk_template': ('django.db.models.fields.CharField', [], {'default': "'drbd'", 'max_length': '32'}),
64 6ef51e9f Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
65 6ef51e9f Giorgos Verigakis
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
66 6ef51e9f Giorgos Verigakis
        },
67 6ef51e9f Giorgos Verigakis
        'db.network': {
68 6ef51e9f Giorgos Verigakis
            'Meta': {'object_name': 'Network'},
69 6ef51e9f Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
70 6ef51e9f Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
71 6ef51e9f Giorgos Verigakis
            'link': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['db.NetworkLink']"}),
72 6ef51e9f Giorgos Verigakis
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
73 6ef51e9f Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
74 6ef51e9f Giorgos Verigakis
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
75 6ef51e9f Giorgos Verigakis
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
76 6ef51e9f Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
77 6ef51e9f Giorgos Verigakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'})
78 6ef51e9f Giorgos Verigakis
        },
79 6ef51e9f Giorgos Verigakis
        'db.networkinterface': {
80 6ef51e9f Giorgos Verigakis
            'Meta': {'object_name': 'NetworkInterface'},
81 6ef51e9f Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
82 6ef51e9f Giorgos Verigakis
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
83 6ef51e9f Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
84 6ef51e9f Giorgos Verigakis
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
85 6ef51e9f Giorgos Verigakis
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
86 6ef51e9f Giorgos Verigakis
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
87 6ef51e9f Giorgos Verigakis
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '17', 'null': 'True'}),
88 6ef51e9f Giorgos Verigakis
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
89 6ef51e9f Giorgos Verigakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
90 6ef51e9f Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
91 6ef51e9f Giorgos Verigakis
        },
92 6ef51e9f Giorgos Verigakis
        'db.networklink': {
93 6ef51e9f Giorgos Verigakis
            'Meta': {'object_name': 'NetworkLink'},
94 6ef51e9f Giorgos Verigakis
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
95 6ef51e9f Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
96 6ef51e9f Giorgos Verigakis
            'index': ('django.db.models.fields.IntegerField', [], {}),
97 6ef51e9f Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
98 6ef51e9f Giorgos Verigakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'to': "orm['db.Network']"})
99 6ef51e9f Giorgos Verigakis
        },
100 6ef51e9f Giorgos Verigakis
        'db.virtualmachine': {
101 6ef51e9f Giorgos Verigakis
            'Meta': {'object_name': 'VirtualMachine'},
102 6ef51e9f Giorgos Verigakis
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
103 6ef51e9f Giorgos Verigakis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
104 6ef51e9f Giorgos Verigakis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
105 6ef51e9f Giorgos Verigakis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
106 6ef51e9f Giorgos Verigakis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
107 6ef51e9f Giorgos Verigakis
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
108 6ef51e9f Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
109 6ef51e9f Giorgos Verigakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
110 6ef51e9f Giorgos Verigakis
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
111 6ef51e9f Giorgos Verigakis
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
112 6ef51e9f Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
113 6ef51e9f Giorgos Verigakis
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
114 6ef51e9f Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
115 6ef51e9f Giorgos Verigakis
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
116 6ef51e9f Giorgos Verigakis
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
117 6ef51e9f Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
118 6ef51e9f Giorgos Verigakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100'})
119 6ef51e9f Giorgos Verigakis
        },
120 6ef51e9f Giorgos Verigakis
        'db.virtualmachinemetadata': {
121 6ef51e9f Giorgos Verigakis
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
122 6ef51e9f Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
123 6ef51e9f Giorgos Verigakis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
124 6ef51e9f Giorgos Verigakis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
125 6ef51e9f Giorgos Verigakis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
126 6ef51e9f Giorgos Verigakis
        }
127 6ef51e9f Giorgos Verigakis
    }
128 6ef51e9f Giorgos Verigakis
129 6ef51e9f Giorgos Verigakis
    complete_apps = ['db']