Statistics
| Branch: | Tag: | Revision:

root / edumanage / migrations / 0010_auto__add_field_url_i18n_object_id__add_field_url_i18n_content_type.py @ af9d484b

History | View | Annotate | Download (14.2 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
        # Removing M2M table for field url on 'Realm'
12
        db.delete_table('edumanage_realm_url')
13

    
14
        # Removing M2M table for field url on 'InstitutionDetails'
15
        db.delete_table('edumanage_institutiondetails_url')
16

    
17
        # Removing M2M table for field url on 'ServiceLoc'
18
        db.delete_table('edumanage_serviceloc_url')
19

    
20
        # Adding field 'URL_i18n.object_id'
21
        db.add_column('edumanage_url_i18n', 'object_id', self.gf('django.db.models.fields.PositiveIntegerField')(null=True, blank=True), keep_default=False)
22

    
23
        # Adding field 'URL_i18n.content_type'
24
        db.add_column('edumanage_url_i18n', 'content_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['contenttypes.ContentType'], null=True, blank=True), keep_default=False)
25
    
26
    
27
    def backwards(self, orm):
28
        
29
        # Adding M2M table for field url on 'Realm'
30
        db.create_table('edumanage_realm_url', (
31
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
32
            ('realm', models.ForeignKey(orm['edumanage.realm'], null=False)),
33
            ('url_i18n', models.ForeignKey(orm['edumanage.url_i18n'], null=False))
34
        ))
35
        db.create_unique('edumanage_realm_url', ['realm_id', 'url_i18n_id'])
36

    
37
        # Adding M2M table for field url on 'InstitutionDetails'
38
        db.create_table('edumanage_institutiondetails_url', (
39
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
40
            ('institutiondetails', models.ForeignKey(orm['edumanage.institutiondetails'], null=False)),
41
            ('url_i18n', models.ForeignKey(orm['edumanage.url_i18n'], null=False))
42
        ))
43
        db.create_unique('edumanage_institutiondetails_url', ['institutiondetails_id', 'url_i18n_id'])
44

    
45
        # Adding M2M table for field url on 'ServiceLoc'
46
        db.create_table('edumanage_serviceloc_url', (
47
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
48
            ('serviceloc', models.ForeignKey(orm['edumanage.serviceloc'], null=False)),
49
            ('url_i18n', models.ForeignKey(orm['edumanage.url_i18n'], null=False))
50
        ))
51
        db.create_unique('edumanage_serviceloc_url', ['serviceloc_id', 'url_i18n_id'])
52

    
53
        # Deleting field 'URL_i18n.object_id'
54
        db.delete_column('edumanage_url_i18n', 'object_id')
55

    
56
        # Deleting field 'URL_i18n.content_type'
57
        db.delete_column('edumanage_url_i18n', 'content_type_id')
58
    
59
    
60
    models = {
61
        'contenttypes.contenttype': {
62
            'Meta': {'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
63
            'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
64
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
65
            'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
66
            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
67
        },
68
        'edumanage.contact': {
69
            'Meta': {'object_name': 'Contact'},
70
            'email': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_email'"}),
71
            'firstname': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_firstname'"}),
72
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
73
            'lastname': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_lastname'"}),
74
            'phone': ('django.db.models.fields.CharField', [], {'max_length': '80', 'db_column': "'contact_phone'"})
75
        },
76
        'edumanage.institution': {
77
            'Meta': {'object_name': 'Institution'},
78
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
79
            'realmid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Realm']"})
80
        },
81
        'edumanage.institutiondetails': {
82
            'Meta': {'object_name': 'InstitutionDetails'},
83
            'address_city': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
84
            'address_street': ('django.db.models.fields.CharField', [], {'max_length': '96'}),
85
            'contact': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.Contact']", 'symmetrical': 'False'}),
86
            'ertype': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '1', 'db_column': "'type'"}),
87
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
88
            'institution': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['edumanage.Institution']", 'unique': 'True'}),
89
            'number_id': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '6'}),
90
            'number_user': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '6'}),
91
            'oper_name': ('django.db.models.fields.CharField', [], {'max_length': '24'}),
92
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
93
        },
94
        'edumanage.instrealm': {
95
            'Meta': {'object_name': 'InstRealm'},
96
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
97
            'instid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
98
            'priority': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '3'}),
99
            'proxyto': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.InstServer']", 'symmetrical': 'False'}),
100
            'realmexpr': ('django.db.models.fields.CharField', [], {'max_length': '20'})
101
        },
102
        'edumanage.instrealmmon': {
103
            'Meta': {'object_name': 'InstRealmMon'},
104
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
105
            'instid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
106
            'mon_type': ('django.db.models.fields.CharField', [], {'max_length': '8'}),
107
            'realm': ('django.db.models.fields.CharField', [], {'max_length': '20'})
108
        },
109
        'edumanage.instserver': {
110
            'Meta': {'object_name': 'InstServer'},
111
            'acct_port': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
112
            'ertype': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '1', 'db_column': "'type'"}),
113
            'host': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
114
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
115
            'instid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
116
            'name': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
117
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
118
            'proto': ('django.db.models.fields.CharField', [], {'max_length': '12'}),
119
            'retry': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '2'}),
120
            'secret': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
121
            'status_server': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
122
            'timeout': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '2'}),
123
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
124
        },
125
        'edumanage.monlocaleapoldata': {
126
            'Meta': {'object_name': 'MonLocalEAPOLData'},
127
            'cert': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
128
            'eap_method': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
129
            'exp_response': ('django.db.models.fields.CharField', [], {'max_length': '6'}),
130
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
131
            'instrealmmonid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.InstRealmMon']"}),
132
            'passwp': ('django.db.models.fields.CharField', [], {'max_length': '24', 'db_column': "'pass'"}),
133
            'phase2': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
134
            'username': ('django.db.models.fields.CharField', [], {'max_length': '24'})
135
        },
136
        'edumanage.monproxybackclient': {
137
            'Meta': {'object_name': 'MonProxybackClient'},
138
            'host': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
139
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
140
            'instrealmmonid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.InstRealmMon']"}),
141
            'name': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
142
            'proto': ('django.db.models.fields.CharField', [], {'max_length': '12'}),
143
            'secret': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
144
            'status_server': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
145
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
146
        },
147
        'edumanage.name_i18n': {
148
            'Meta': {'object_name': 'Name_i18n'},
149
            'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']", 'null': 'True', 'blank': 'True'}),
150
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
151
            'lang': ('django.db.models.fields.CharField', [], {'max_length': '5'}),
152
            'name': ('django.db.models.fields.CharField', [], {'max_length': '80'}),
153
            'object_id': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True', 'blank': 'True'})
154
        },
155
        'edumanage.realm': {
156
            'Meta': {'object_name': 'Realm'},
157
            'address_city': ('django.db.models.fields.CharField', [], {'max_length': '24'}),
158
            'address_street': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
159
            'contact': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.Contact']", 'symmetrical': 'False'}),
160
            'country': ('django.db.models.fields.CharField', [], {'max_length': '2'}),
161
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
162
            'stype': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'max_length': '1'}),
163
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
164
        },
165
        'edumanage.realmdata': {
166
            'Meta': {'object_name': 'RealmData'},
167
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
168
            'number_IdP': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
169
            'number_IdPSP': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
170
            'number_SP': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
171
            'number_id': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '9'}),
172
            'number_inst': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '5'}),
173
            'number_user': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '9'}),
174
            'realmid': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['edumanage.Realm']", 'unique': 'True'}),
175
            'ts': ('django.db.models.fields.DateTimeField', [], {})
176
        },
177
        'edumanage.serviceloc': {
178
            'AP_no': ('django.db.models.fields.PositiveIntegerField', [], {'max_length': '3'}),
179
            'IPv6': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
180
            'Meta': {'object_name': 'ServiceLoc'},
181
            'NAT': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
182
            'SSID': ('django.db.models.fields.CharField', [], {'max_length': '16'}),
183
            'address_city': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
184
            'address_street': ('django.db.models.fields.CharField', [], {'max_length': '96'}),
185
            'contact': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['edumanage.Contact']", 'symmetrical': 'False'}),
186
            'enc_level': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
187
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
188
            'institutionid': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['edumanage.Institution']"}),
189
            'latitude': ('django.db.models.fields.DecimalField', [], {'max_digits': '8', 'decimal_places': '6'}),
190
            'longitude': ('django.db.models.fields.DecimalField', [], {'max_digits': '8', 'decimal_places': '6'}),
191
            'port_restrict': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
192
            'transp_proxy': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
193
            'ts': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
194
            'wired': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'})
195
        },
196
        'edumanage.url_i18n': {
197
            'Meta': {'object_name': 'URL_i18n'},
198
            'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']", 'null': 'True', 'blank': 'True'}),
199
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
200
            'lang': ('django.db.models.fields.CharField', [], {'max_length': '5'}),
201
            'object_id': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True', 'blank': 'True'}),
202
            'url': ('django.db.models.fields.CharField', [], {'max_length': '180', 'db_column': "'URL'"}),
203
            'urltype': ('django.db.models.fields.CharField', [], {'max_length': '10', 'db_column': "'type'"})
204
        }
205
    }
206
    
207
    complete_apps = ['edumanage']