Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0047_auto__chg_field_networkinterface_mac__add_unique_networkinterface_mac_.py @ df8a7015

History | View | Annotate | Download (12.7 kB)

1 3165f027 Christos Stavrakakis
# encoding: utf-8
2 3165f027 Christos Stavrakakis
import datetime
3 3165f027 Christos Stavrakakis
from south.db import db
4 3165f027 Christos Stavrakakis
from south.v2 import SchemaMigration
5 3165f027 Christos Stavrakakis
from django.db import models
6 3165f027 Christos Stavrakakis
7 3165f027 Christos Stavrakakis
class Migration(SchemaMigration):
8 3165f027 Christos Stavrakakis
    
9 3165f027 Christos Stavrakakis
    def forwards(self, orm):
10 3165f027 Christos Stavrakakis
        
11 3165f027 Christos Stavrakakis
        # Changing field 'NetworkInterface.mac'
12 3165f027 Christos Stavrakakis
        db.alter_column('db_networkinterface', 'mac', self.gf('django.db.models.fields.CharField')(unique=True, max_length=32))
13 3165f027 Christos Stavrakakis
14 3165f027 Christos Stavrakakis
        # Adding unique constraint on 'NetworkInterface', fields ['mac']
15 3165f027 Christos Stavrakakis
        db.create_unique('db_networkinterface', ['mac'])
16 3165f027 Christos Stavrakakis
17 3165f027 Christos Stavrakakis
        # Adding field 'Backend.index'
18 3165f027 Christos Stavrakakis
        db.add_column('db_backend', 'index', self.gf('django.db.models.fields.PositiveIntegerField')(default=0, unique=True), keep_default=False)
19 3165f027 Christos Stavrakakis
20 3165f027 Christos Stavrakakis
        # Changing field 'Network.mac_prefix'
21 d0411c0a Christos Stavrakakis
        db.alter_column('db_network', 'mac_prefix',self.gf('django.db.models.fields.CharField')(default='', max_length=32, null=True))
22 3165f027 Christos Stavrakakis
23 3165f027 Christos Stavrakakis
        # Adding field 'BackendNetwork.mac_prefix'
24 3165f027 Christos Stavrakakis
        db.add_column('db_backendnetwork', 'mac_prefix', self.gf('django.db.models.fields.CharField')(default='', max_length=32), keep_default=False)
25 3165f027 Christos Stavrakakis
    
26 3165f027 Christos Stavrakakis
    
27 3165f027 Christos Stavrakakis
    def backwards(self, orm):
28 3165f027 Christos Stavrakakis
        
29 3165f027 Christos Stavrakakis
        # Changing field 'NetworkInterface.mac'
30 3165f027 Christos Stavrakakis
        db.alter_column('db_networkinterface', 'mac', self.gf('django.db.models.fields.CharField')(max_length=32, null=True))
31 3165f027 Christos Stavrakakis
32 3165f027 Christos Stavrakakis
        # Removing unique constraint on 'NetworkInterface', fields ['mac']
33 3165f027 Christos Stavrakakis
        db.delete_unique('db_networkinterface', ['mac'])
34 3165f027 Christos Stavrakakis
35 3165f027 Christos Stavrakakis
        # Deleting field 'Backend.index'
36 3165f027 Christos Stavrakakis
        db.delete_column('db_backend', 'index')
37 3165f027 Christos Stavrakakis
38 3165f027 Christos Stavrakakis
        # Changing field 'Network.mac_prefix'
39 3165f027 Christos Stavrakakis
        db.alter_column('db_network', 'mac_prefix', self.gf('django.db.models.fields.CharField')(max_length=32, null=True))
40 3165f027 Christos Stavrakakis
41 3165f027 Christos Stavrakakis
        # Deleting field 'BackendNetwork.mac_prefix'
42 3165f027 Christos Stavrakakis
        db.delete_column('db_backendnetwork', 'mac_prefix')
43 3165f027 Christos Stavrakakis
    
44 3165f027 Christos Stavrakakis
    
45 3165f027 Christos Stavrakakis
    models = {
46 3165f027 Christos Stavrakakis
        'db.backend': {
47 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'Backend'},
48 3165f027 Christos Stavrakakis
            'clustername': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}),
49 3165f027 Christos Stavrakakis
            'ctotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
50 3165f027 Christos Stavrakakis
            'dfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
51 3165f027 Christos Stavrakakis
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
52 3165f027 Christos Stavrakakis
            'dtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
53 3165f027 Christos Stavrakakis
            'hash': ('django.db.models.fields.CharField', [], {'max_length': '40'}),
54 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
55 3165f027 Christos Stavrakakis
            'index': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'unique': 'True'}),
56 3165f027 Christos Stavrakakis
            'mfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
57 3165f027 Christos Stavrakakis
            'mtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
58 3165f027 Christos Stavrakakis
            'offline': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
59 3165f027 Christos Stavrakakis
            'password_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
60 3165f027 Christos Stavrakakis
            'pinst_cnt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
61 3165f027 Christos Stavrakakis
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'default': '5080'}),
62 3165f027 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
63 3165f027 Christos Stavrakakis
            'username': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'})
64 3165f027 Christos Stavrakakis
        },
65 3165f027 Christos Stavrakakis
        'db.backendnetwork': {
66 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'BackendNetwork'},
67 3165f027 Christos Stavrakakis
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'networks'", 'to': "orm['db.Backend']"}),
68 3165f027 Christos Stavrakakis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
69 3165f027 Christos Stavrakakis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
70 3165f027 Christos Stavrakakis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
71 3165f027 Christos Stavrakakis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
72 3165f027 Christos Stavrakakis
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
73 3165f027 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
74 3165f027 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
75 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
76 3165f027 Christos Stavrakakis
            'mac_prefix': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '32'}),
77 3165f027 Christos Stavrakakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'backend_networks'", 'to': "orm['db.Network']"}),
78 3165f027 Christos Stavrakakis
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '30'}),
79 3165f027 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
80 3165f027 Christos Stavrakakis
        },
81 3165f027 Christos Stavrakakis
        'db.bridgepool': {
82 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'BridgePool'},
83 3165f027 Christos Stavrakakis
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
84 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
85 3165f027 Christos Stavrakakis
            'index': ('django.db.models.fields.IntegerField', [], {'unique': 'True'}),
86 3165f027 Christos Stavrakakis
            'value': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
87 3165f027 Christos Stavrakakis
        },
88 3165f027 Christos Stavrakakis
        'db.flavor': {
89 3165f027 Christos Stavrakakis
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk', 'disk_template'),)", 'object_name': 'Flavor'},
90 3165f027 Christos Stavrakakis
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
91 3165f027 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
92 3165f027 Christos Stavrakakis
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
93 3165f027 Christos Stavrakakis
            'disk_template': ('django.db.models.fields.CharField', [], {'default': "'drbd'", 'max_length': '32'}),
94 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
95 3165f027 Christos Stavrakakis
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
96 3165f027 Christos Stavrakakis
        },
97 3165f027 Christos Stavrakakis
        'db.macprefixpool': {
98 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'MacPrefixPool'},
99 3165f027 Christos Stavrakakis
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
100 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
101 3165f027 Christos Stavrakakis
            'index': ('django.db.models.fields.IntegerField', [], {'unique': 'True'}),
102 3165f027 Christos Stavrakakis
            'value': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
103 3165f027 Christos Stavrakakis
        },
104 3165f027 Christos Stavrakakis
        'db.network': {
105 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'Network'},
106 3165f027 Christos Stavrakakis
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '32', 'null': 'True'}),
107 3165f027 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
108 3165f027 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
109 3165f027 Christos Stavrakakis
            'dhcp': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
110 3165f027 Christos Stavrakakis
            'gateway': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
111 3165f027 Christos Stavrakakis
            'gateway6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
112 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
113 3165f027 Christos Stavrakakis
            'link': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
114 d0411c0a Christos Stavrakakis
            'mac_prefix': ('django.db.models.fields.CharField', [], {'default':
115 d0411c0a Christos Stavrakakis
                "''", 'max_length': '32', 'null':'True'}),
116 3165f027 Christos Stavrakakis
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
117 3165f027 Christos Stavrakakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
118 3165f027 Christos Stavrakakis
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
119 3165f027 Christos Stavrakakis
            'reservations': ('django.db.models.fields.TextField', [], {'default': "''"}),
120 3165f027 Christos Stavrakakis
            'state': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '32'}),
121 3165f027 Christos Stavrakakis
            'subnet': ('django.db.models.fields.CharField', [], {'default': "'10.0.0.0/24'", 'max_length': '32'}),
122 3165f027 Christos Stavrakakis
            'subnet6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
123 3165f027 Christos Stavrakakis
            'type': ('django.db.models.fields.CharField', [], {'default': "'PRIVATE_PHYSICAL_VLAN'", 'max_length': '50'}),
124 3165f027 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
125 3165f027 Christos Stavrakakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'})
126 3165f027 Christos Stavrakakis
        },
127 3165f027 Christos Stavrakakis
        'db.networkinterface': {
128 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'NetworkInterface'},
129 3165f027 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
130 3165f027 Christos Stavrakakis
            'dirty': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
131 3165f027 Christos Stavrakakis
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
132 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
133 3165f027 Christos Stavrakakis
            'index': ('django.db.models.fields.IntegerField', [], {}),
134 3165f027 Christos Stavrakakis
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
135 3165f027 Christos Stavrakakis
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
136 3165f027 Christos Stavrakakis
            'mac': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '32'}),
137 3165f027 Christos Stavrakakis
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
138 3165f027 Christos Stavrakakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
139 3165f027 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
140 3165f027 Christos Stavrakakis
        },
141 3165f027 Christos Stavrakakis
        'db.virtualmachine': {
142 3165f027 Christos Stavrakakis
            'Meta': {'object_name': 'VirtualMachine'},
143 3165f027 Christos Stavrakakis
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
144 3165f027 Christos Stavrakakis
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machines'", 'null': 'True', 'to': "orm['db.Backend']"}),
145 3165f027 Christos Stavrakakis
            'backend_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
146 3165f027 Christos Stavrakakis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
147 3165f027 Christos Stavrakakis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
148 3165f027 Christos Stavrakakis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
149 3165f027 Christos Stavrakakis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
150 3165f027 Christos Stavrakakis
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
151 3165f027 Christos Stavrakakis
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
152 3165f027 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
153 3165f027 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
154 3165f027 Christos Stavrakakis
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
155 3165f027 Christos Stavrakakis
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
156 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
157 3165f027 Christos Stavrakakis
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
158 3165f027 Christos Stavrakakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
159 3165f027 Christos Stavrakakis
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
160 3165f027 Christos Stavrakakis
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
161 3165f027 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
162 3165f027 Christos Stavrakakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100'})
163 3165f027 Christos Stavrakakis
        },
164 3165f027 Christos Stavrakakis
        'db.virtualmachinemetadata': {
165 3165f027 Christos Stavrakakis
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
166 3165f027 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
167 3165f027 Christos Stavrakakis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
168 3165f027 Christos Stavrakakis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
169 3165f027 Christos Stavrakakis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
170 3165f027 Christos Stavrakakis
        }
171 3165f027 Christos Stavrakakis
    }
172 3165f027 Christos Stavrakakis
    
173 3165f027 Christos Stavrakakis
    complete_apps = ['db']