Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / userdata / migrations / 0003_auto__chg_field_publickeypair_fingerprint__chg_field_publickeypair_use.py @ 0dae1b9f

History | View | Annotate | Download (2.3 kB)

1 85f1cd1e Kostas Papadimitriou
# encoding: utf-8
2 85f1cd1e Kostas Papadimitriou
import datetime
3 85f1cd1e Kostas Papadimitriou
from south.db import db
4 85f1cd1e Kostas Papadimitriou
from south.v2 import SchemaMigration
5 85f1cd1e Kostas Papadimitriou
from django.db import models
6 85f1cd1e Kostas Papadimitriou
7 85f1cd1e Kostas Papadimitriou
class Migration(SchemaMigration):
8 e17979fe Kostas Papadimitriou
9 ab8aecf2 Kostas Papadimitriou
    needed_by = (
10 ab8aecf2 Kostas Papadimitriou
        ("db", "0027_auto__del_legacy_fields"),
11 ab8aecf2 Kostas Papadimitriou
    )
12 ab8aecf2 Kostas Papadimitriou
13 85f1cd1e Kostas Papadimitriou
    def forwards(self, orm):
14 e17979fe Kostas Papadimitriou
15 85f1cd1e Kostas Papadimitriou
        # Changing field 'PublicKeyPair.fingerprint'
16 85f1cd1e Kostas Papadimitriou
        db.alter_column('userdata_publickeypair', 'fingerprint', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True))
17 85f1cd1e Kostas Papadimitriou
18 ab8aecf2 Kostas Papadimitriou
        try:
19 ab8aecf2 Kostas Papadimitriou
            db.drop_foreign_key('userdata_publickeypair', 'user_id')
20 ab8aecf2 Kostas Papadimitriou
        except:
21 ab8aecf2 Kostas Papadimitriou
            pass
22 85f1cd1e Kostas Papadimitriou
        # Renaming column for 'PublicKeyPair.user' to match new field type.
23 85f1cd1e Kostas Papadimitriou
        db.rename_column('userdata_publickeypair', 'user_id', 'user')
24 85f1cd1e Kostas Papadimitriou
        # Changing field 'PublicKeyPair.user'
25 85f1cd1e Kostas Papadimitriou
        db.alter_column('userdata_publickeypair', 'user', self.gf('django.db.models.fields.CharField')(max_length=100))
26 85f1cd1e Kostas Papadimitriou
27 e17979fe Kostas Papadimitriou
        try:
28 ab8aecf2 Kostas Papadimitriou
            # Removing index on 'PublicKeyPair', fields ['user']
29 e17979fe Kostas Papadimitriou
            db.delete_index('userdata_publickeypair', ['user_id'])
30 e17979fe Kostas Papadimitriou
        except:
31 e17979fe Kostas Papadimitriou
            pass
32 e17979fe Kostas Papadimitriou
33 e17979fe Kostas Papadimitriou
34 85f1cd1e Kostas Papadimitriou
    def backwards(self, orm):
35 e17979fe Kostas Papadimitriou
36 85f1cd1e Kostas Papadimitriou
        # Changing field 'PublicKeyPair.fingerprint'
37 85f1cd1e Kostas Papadimitriou
        db.alter_column('userdata_publickeypair', 'fingerprint', self.gf('django.db.models.fields.CharField')(max_length=100))
38 85f1cd1e Kostas Papadimitriou
39 85f1cd1e Kostas Papadimitriou
        # Renaming column for 'PublicKeyPair.user' to match new field type.
40 85f1cd1e Kostas Papadimitriou
        db.rename_column('userdata_publickeypair', 'user', 'user_id')
41 85f1cd1e Kostas Papadimitriou
        # Changing field 'PublicKeyPair.user'
42 85f1cd1e Kostas Papadimitriou
        db.alter_column('userdata_publickeypair', 'user_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['db.SynnefoUser']))
43 85f1cd1e Kostas Papadimitriou
44 85f1cd1e Kostas Papadimitriou
        # Adding index on 'PublicKeyPair', fields ['user']
45 85f1cd1e Kostas Papadimitriou
        db.create_index('userdata_publickeypair', ['user_id'])
46 e17979fe Kostas Papadimitriou
47 e17979fe Kostas Papadimitriou
48 85f1cd1e Kostas Papadimitriou
    models = {
49 85f1cd1e Kostas Papadimitriou
        'userdata.publickeypair': {
50 85f1cd1e Kostas Papadimitriou
            'Meta': {'object_name': 'PublicKeyPair'},
51 85f1cd1e Kostas Papadimitriou
            'content': ('django.db.models.fields.TextField', [], {}),
52 85f1cd1e Kostas Papadimitriou
            'fingerprint': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
53 85f1cd1e Kostas Papadimitriou
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
54 85f1cd1e Kostas Papadimitriou
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
55 85f1cd1e Kostas Papadimitriou
            'user': ('django.db.models.fields.CharField', [], {'max_length': '100'})
56 85f1cd1e Kostas Papadimitriou
        }
57 85f1cd1e Kostas Papadimitriou
    }
58 e17979fe Kostas Papadimitriou
59 85f1cd1e Kostas Papadimitriou
    complete_apps = ['userdata']