Statistics
| Branch: | Tag: | Revision:

root / edumanage / migrations / 0016_auto__add_field_institution_ertype__del_field_institutiondetails_ertyp.py @ b23b3d10

History | View | Annotate | Download (13.1 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 field 'Institution.ertype'
12
        db.add_column('edumanage_institution', 'ertype', self.gf('django.db.models.fields.PositiveIntegerField')(default=1, max_length=1, db_column='type'), keep_default=False)
13

    
14
        # Deleting field 'InstitutionDetails.ertype'
15
        db.delete_column('edumanage_institutiondetails', 'type')
16
    
17
    
18
    def backwards(self, orm):
19
        
20
        # Deleting field 'Institution.ertype'
21
        db.delete_column('edumanage_institution', 'type')
22

    
23
        # Adding field 'InstitutionDetails.ertype'
24
        db.add_column('edumanage_institutiondetails', 'ertype', self.gf('django.db.models.fields.PositiveIntegerField')(default=3, max_length=1, db_column='type'), keep_default=False)
25
    
26
    
27
    models = {
28
        'contenttypes.contenttype': {
29
            'Meta': {'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
30
            'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
31
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
32
            'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
33
            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
34
        },
35
        'edumanage.contact': {
36
            'Meta': {'object_name': 'Contact'},
37
            'email': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_email'"}),
38
            'firstname': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_firstname'"}),
39
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
40
            'lastname': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_lastname'"}),
41
            'phone': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_phone'"})
42
        },
43
        'edumanage.institution': {
44
            'Meta': {'object_name': 'Institution'},
45
            'ertype': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '1', 'db_column': "'type'"}),
46
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
47
            'realmid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Realm']"})
48
        },
49
        'edumanage.institutioncontactpool': {
50
            'Meta': {'object_name': 'InstitutionContactPool'},
51
            'contact': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['edumanage.Contact']", 'unique': 'True'}),
52
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
53
            'institution': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"})
54
        },
55
        'edumanage.institutiondetails': {
56
            'Meta': {'object_name': 'InstitutionDetails'},
57
            'address_city': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
58
            'address_street': ('django.db.models.fields.CharField', [], {'max_length': '96'}),
59
            'contact': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.Contact']", 'symmetrical': 'False'}),
60
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
61
            'institution': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['edumanage.Institution']", 'unique': 'True'}),
62
            'number_id': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '6'}),
63
            'number_user': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '6', 'null': 'True', 'blank': 'True'}),
64
            'oper_name': ('django.db.models.fields.CharField', [], {'max_length': '24', 'null': 'True', 'blank': 'True'}),
65
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
66
        },
67
        'edumanage.instrealm': {
68
            'Meta': {'object_name': 'InstRealm'},
69
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
70
            'instid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
71
            'proxyto': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.InstServer']", 'symmetrical': 'False'}),
72
            'realm': ('django.db.models.fields.CharField', [], {'max_length': '160'})
73
        },
74
        'edumanage.instrealmmon': {
75
            'Meta': {'object_name': 'InstRealmMon'},
76
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
77
            'instid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
78
            'mon_type': ('django.db.models.fields.CharField', [], {'max_length': '8'}),
79
            'realm': ('django.db.models.fields.CharField', [], {'max_length': '20'})
80
        },
81
        'edumanage.instserver': {
82
            'Meta': {'object_name': 'InstServer'},
83
            'acct_port': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5', 'null': 'True', 'blank': 'True'}),
84
            'ertype': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '1', 'db_column': "'type'"}),
85
            'host': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
86
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
87
            'instid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
88
            'name': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
89
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5', 'null': 'True', 'blank': 'True'}),
90
            'proto': ('django.db.models.fields.CharField', [], {'max_length': '12'}),
91
            'retry': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '2', 'null': 'True', 'blank': 'True'}),
92
            'secret': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
93
            'status_server': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
94
            'timeout': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '2', 'null': 'True', 'blank': 'True'}),
95
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
96
        },
97
        'edumanage.monlocaleapoldata': {
98
            'Meta': {'object_name': 'MonLocalEAPOLData'},
99
            'cert': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
100
            'eap_method': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
101
            'exp_response': ('django.db.models.fields.CharField', [], {'max_length': '6'}),
102
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
103
            'instrealmmonid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.InstRealmMon']"}),
104
            'passwp': ('django.db.models.fields.CharField', [], {'max_length': '24', 'db_column': "'pass'"}),
105
            'phase2': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
106
            'username': ('django.db.models.fields.CharField', [], {'max_length': '24'})
107
        },
108
        'edumanage.monproxybackclient': {
109
            'Meta': {'object_name': 'MonProxybackClient'},
110
            'host': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
111
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
112
            'instrealmmonid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.InstRealmMon']"}),
113
            'name': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
114
            'proto': ('django.db.models.fields.CharField', [], {'max_length': '12'}),
115
            'secret': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
116
            'status_server': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
117
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
118
        },
119
        'edumanage.name_i18n': {
120
            'Meta': {'object_name': 'Name_i18n'},
121
            'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']", 'null': 'True', 'blank': 'True'}),
122
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
123
            'lang': ('django.db.models.fields.CharField', [], {'max_length': '5'}),
124
            'name': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
125
            'object_id': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True', 'blank': 'True'})
126
        },
127
        'edumanage.realm': {
128
            'Meta': {'object_name': 'Realm'},
129
            'address_city': ('django.db.models.fields.CharField', [], {'max_length': '24'}),
130
            'address_street': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
131
            'contact': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.Contact']", 'symmetrical': 'False'}),
132
            'country': ('django.db.models.fields.CharField', [], {'max_length': '2'}),
133
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
134
            'stype': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'max_length': '1'}),
135
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
136
        },
137
        'edumanage.realmdata': {
138
            'Meta': {'object_name': 'RealmData'},
139
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
140
            'number_IdP': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
141
            'number_IdPSP': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
142
            'number_SP': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
143
            'number_id': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '9'}),
144
            'number_inst': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
145
            'number_user': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '9'}),
146
            'realmid': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['edumanage.Realm']", 'unique': 'True'}),
147
            'ts': ('django.db.models.fields.DateTimeField', [], {})
148
        },
149
        'edumanage.serviceloc': {
150
            'AP_no': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '3'}),
151
            'IPv6': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
152
            'Meta': {'object_name': 'ServiceLoc'},
153
            'NAT': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
154
            'SSID': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
155
            'address_city': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
156
            'address_street': ('django.db.models.fields.CharField', [], {'max_length': '96'}),
157
            'contact': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.Contact']", 'symmetrical': 'False'}),
158
            'enc_level': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
159
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
160
            'institutionid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
161
            'latitude': ('django.db.models.fields.DecimalField', [], {'max_digits': '8', 'decimal_places': '6'}),
162
            'longitude': ('django.db.models.fields.DecimalField', [], {'max_digits': '8', 'decimal_places': '6'}),
163
            'port_restrict': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
164
            'transp_proxy': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
165
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
166
            'wired': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'})
167
        },
168
        'edumanage.url_i18n': {
169
            'Meta': {'object_name': 'URL_i18n'},
170
            'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']", 'null': 'True', 'blank': 'True'}),
171
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
172
            'lang': ('django.db.models.fields.CharField', [], {'max_length': '5'}),
173
            'object_id': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True', 'blank': 'True'}),
174
            'url': ('django.db.models.fields.CharField', [], {'max_length': '180', 'db_column': "'URL'"}),
175
            'urltype': ('django.db.models.fields.CharField', [], {'max_length': '10', 'db_column': "'type'"})
176
        }
177
    }
178
    
179
    complete_apps = ['edumanage']