Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0030_auto__del_synnefouser__del_field_virtualmachine_owner__del_field_image.py @ 1679a0ea

History | View | Annotate | Download (10.7 kB)

1 244c552b Giorgos Verigakis
# encoding: utf-8
2 244c552b Giorgos Verigakis
import datetime
3 244c552b Giorgos Verigakis
from south.db import db
4 244c552b Giorgos Verigakis
from south.v2 import SchemaMigration
5 244c552b Giorgos Verigakis
from django.db import models
6 244c552b Giorgos Verigakis
7 244c552b Giorgos Verigakis
class Migration(SchemaMigration):
8 244c552b Giorgos Verigakis
9 244c552b Giorgos Verigakis
    def forwards(self, orm):
10 244c552b Giorgos Verigakis
        
11 244c552b Giorgos Verigakis
        # Deleting model 'SynnefoUser'
12 244c552b Giorgos Verigakis
        db.delete_table('db_synnefouser')
13 244c552b Giorgos Verigakis
14 244c552b Giorgos Verigakis
        # Deleting field 'VirtualMachine.owner'
15 244c552b Giorgos Verigakis
        db.delete_column('db_virtualmachine', 'owner_id')
16 244c552b Giorgos Verigakis
17 244c552b Giorgos Verigakis
        # Deleting field 'Image.owner'
18 244c552b Giorgos Verigakis
        db.delete_column('db_image', 'owner_id')
19 244c552b Giorgos Verigakis
20 244c552b Giorgos Verigakis
        # Changing field 'Image.userid'
21 244c552b Giorgos Verigakis
        db.alter_column('db_image', 'userid', self.gf('django.db.models.fields.CharField')(max_length=100, null=True))
22 244c552b Giorgos Verigakis
23 244c552b Giorgos Verigakis
        # Deleting field 'Network.owner'
24 244c552b Giorgos Verigakis
        db.delete_column('db_network', 'owner_id')
25 244c552b Giorgos Verigakis
26 244c552b Giorgos Verigakis
        # Changing field 'Network.userid'
27 244c552b Giorgos Verigakis
        db.alter_column('db_network', 'userid', self.gf('django.db.models.fields.CharField')(max_length=100, null=True))
28 244c552b Giorgos Verigakis
29 244c552b Giorgos Verigakis
30 244c552b Giorgos Verigakis
    def backwards(self, orm):
31 244c552b Giorgos Verigakis
        
32 244c552b Giorgos Verigakis
        # Adding model 'SynnefoUser'
33 244c552b Giorgos Verigakis
        db.create_table('db_synnefouser', (
34 244c552b Giorgos Verigakis
            ('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
35 244c552b Giorgos Verigakis
            ('realname', self.gf('django.db.models.fields.CharField')(default='', max_length=255)),
36 244c552b Giorgos Verigakis
            ('auth_token', self.gf('django.db.models.fields.CharField')(max_length=32, null=True)),
37 244c552b Giorgos Verigakis
            ('tmp_auth_token_expires', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, null=True, blank=True)),
38 244c552b Giorgos Verigakis
            ('tmp_auth_token', self.gf('django.db.models.fields.CharField')(max_length=32, null=True)),
39 244c552b Giorgos Verigakis
            ('auth_token_expires', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, null=True, blank=True)),
40 244c552b Giorgos Verigakis
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
41 244c552b Giorgos Verigakis
            ('auth_token_created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, null=True, blank=True)),
42 244c552b Giorgos Verigakis
            ('name', self.gf('django.db.models.fields.CharField')(default='', max_length=255)),
43 244c552b Giorgos Verigakis
            ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
44 244c552b Giorgos Verigakis
            ('state', self.gf('django.db.models.fields.CharField')(default='ACTIVE', max_length=30)),
45 244c552b Giorgos Verigakis
            ('uniq', self.gf('django.db.models.fields.CharField')(max_length=255, null=True)),
46 244c552b Giorgos Verigakis
            ('type', self.gf('django.db.models.fields.CharField')(max_length=30)),
47 244c552b Giorgos Verigakis
        ))
48 244c552b Giorgos Verigakis
        db.send_create_signal('db', ['SynnefoUser'])
49 244c552b Giorgos Verigakis
50 244c552b Giorgos Verigakis
        # User chose to not deal with backwards NULL issues for 'VirtualMachine.owner'
51 244c552b Giorgos Verigakis
        raise RuntimeError("Cannot reverse this migration. 'VirtualMachine.owner' and its values cannot be restored.")
52 244c552b Giorgos Verigakis
53 244c552b Giorgos Verigakis
        # Adding field 'Image.owner'
54 244c552b Giorgos Verigakis
        db.add_column('db_image', 'owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'], null=True, blank=True), keep_default=False)
55 244c552b Giorgos Verigakis
56 244c552b Giorgos Verigakis
        # Changing field 'Image.userid'
57 244c552b Giorgos Verigakis
        db.alter_column('db_image', 'userid', self.gf('django.db.models.fields.CharField')(max_length=100))
58 244c552b Giorgos Verigakis
59 244c552b Giorgos Verigakis
        # Adding field 'Network.owner'
60 244c552b Giorgos Verigakis
        db.add_column('db_network', 'owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser'], null=True), keep_default=False)
61 244c552b Giorgos Verigakis
62 244c552b Giorgos Verigakis
        # Changing field 'Network.userid'
63 244c552b Giorgos Verigakis
        db.alter_column('db_network', 'userid', self.gf('django.db.models.fields.CharField')(max_length=100))
64 244c552b Giorgos Verigakis
65 244c552b Giorgos Verigakis
66 244c552b Giorgos Verigakis
    models = {
67 244c552b Giorgos Verigakis
        'db.flavor': {
68 244c552b Giorgos Verigakis
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk'),)", 'object_name': 'Flavor'},
69 244c552b Giorgos Verigakis
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
70 244c552b Giorgos Verigakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
71 244c552b Giorgos Verigakis
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
72 244c552b Giorgos Verigakis
            'disk_template': ('django.db.models.fields.CharField', [], {'default': "'drbd'", 'max_length': '32'}),
73 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
74 244c552b Giorgos Verigakis
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
75 244c552b Giorgos Verigakis
        },
76 244c552b Giorgos Verigakis
        'db.image': {
77 244c552b Giorgos Verigakis
            'Meta': {'object_name': 'Image'},
78 244c552b Giorgos Verigakis
            'backend_id': ('django.db.models.fields.CharField', [], {'default': "'debian_base'", 'max_length': '50'}),
79 244c552b Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
80 244c552b Giorgos Verigakis
            'format': ('django.db.models.fields.CharField', [], {'default': "'dump'", 'max_length': '30'}),
81 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
82 244c552b Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
83 244c552b Giorgos Verigakis
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
84 244c552b Giorgos Verigakis
            'sourcevm': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.VirtualMachine']", 'null': 'True'}),
85 244c552b Giorgos Verigakis
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
86 244c552b Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
87 244c552b Giorgos Verigakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'})
88 244c552b Giorgos Verigakis
        },
89 244c552b Giorgos Verigakis
        'db.imagemetadata': {
90 244c552b Giorgos Verigakis
            'Meta': {'unique_together': "(('meta_key', 'image'),)", 'object_name': 'ImageMetadata'},
91 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
92 244c552b Giorgos Verigakis
            'image': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.Image']"}),
93 244c552b Giorgos Verigakis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
94 244c552b Giorgos Verigakis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'})
95 244c552b Giorgos Verigakis
        },
96 244c552b Giorgos Verigakis
        'db.network': {
97 244c552b Giorgos Verigakis
            'Meta': {'object_name': 'Network'},
98 244c552b Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
99 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
100 244c552b Giorgos Verigakis
            'link': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['db.NetworkLink']"}),
101 244c552b Giorgos Verigakis
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
102 244c552b Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
103 244c552b Giorgos Verigakis
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
104 244c552b Giorgos Verigakis
            'state': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
105 244c552b Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
106 244c552b Giorgos Verigakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'})
107 244c552b Giorgos Verigakis
        },
108 244c552b Giorgos Verigakis
        'db.networkinterface': {
109 244c552b Giorgos Verigakis
            'Meta': {'object_name': 'NetworkInterface'},
110 244c552b Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
111 244c552b Giorgos Verigakis
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
112 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
113 244c552b Giorgos Verigakis
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
114 244c552b Giorgos Verigakis
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
115 244c552b Giorgos Verigakis
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
116 244c552b Giorgos Verigakis
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '17', 'null': 'True'}),
117 244c552b Giorgos Verigakis
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
118 244c552b Giorgos Verigakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
119 244c552b Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
120 244c552b Giorgos Verigakis
        },
121 244c552b Giorgos Verigakis
        'db.networklink': {
122 244c552b Giorgos Verigakis
            'Meta': {'object_name': 'NetworkLink'},
123 244c552b Giorgos Verigakis
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
124 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
125 244c552b Giorgos Verigakis
            'index': ('django.db.models.fields.IntegerField', [], {}),
126 244c552b Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
127 244c552b Giorgos Verigakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'to': "orm['db.Network']"})
128 244c552b Giorgos Verigakis
        },
129 244c552b Giorgos Verigakis
        'db.virtualmachine': {
130 244c552b Giorgos Verigakis
            'Meta': {'object_name': 'VirtualMachine'},
131 244c552b Giorgos Verigakis
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
132 244c552b Giorgos Verigakis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
133 244c552b Giorgos Verigakis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
134 244c552b Giorgos Verigakis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
135 244c552b Giorgos Verigakis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
136 244c552b Giorgos Verigakis
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
137 244c552b Giorgos Verigakis
            'charged': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2012, 1, 23, 15, 32, 51, 475392)'}),
138 244c552b Giorgos Verigakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
139 244c552b Giorgos Verigakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
140 244c552b Giorgos Verigakis
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
141 244c552b Giorgos Verigakis
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
142 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
143 244c552b Giorgos Verigakis
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
144 244c552b Giorgos Verigakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
145 244c552b Giorgos Verigakis
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
146 244c552b Giorgos Verigakis
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
147 244c552b Giorgos Verigakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
148 244c552b Giorgos Verigakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100'})
149 244c552b Giorgos Verigakis
        },
150 244c552b Giorgos Verigakis
        'db.virtualmachinemetadata': {
151 244c552b Giorgos Verigakis
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
152 244c552b Giorgos Verigakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
153 244c552b Giorgos Verigakis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
154 244c552b Giorgos Verigakis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
155 244c552b Giorgos Verigakis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
156 244c552b Giorgos Verigakis
        }
157 244c552b Giorgos Verigakis
    }
158 244c552b Giorgos Verigakis
159 244c552b Giorgos Verigakis
    complete_apps = ['db']