git.parisson.com Git - teleforma.git/blob

   1 # -*- coding: utf-8 -*-
   2 from south.utils import datetime_utils as datetime
   3 from south.db import db
   4 from south.v2 import SchemaMigration
   5 from django.db import models
   6 from django.db import connection
   7
   8
   9 class Migration(SchemaMigration):
  10
  11     def forwards(self, orm):
  12         if not db.dry_run:
  13             cursor = connection.cursor()
  14             cursor.execute("select id, appointment_period_id, date from teleforma_appointment_date")
  15             results = cursor.fetchall()
  16
  17             dates = []
  18             for result in results:
  19
  20                 cursor.execute("select id from teleforma_appointment_slot where day_id=%s" % result[0])
  21                 slots_ids = [slot[0] for slot in cursor.fetchall()]
  22
  23                 cursor.execute("select id, name, address from teleforma_appointment_jury where day_id=%s" % result[0])
  24                 jurys_sql = cursor.fetchall()
  25                 slots = []
  26                 for slot_id in slots_ids:
  27                     jurys = []
  28                     for jury in jurys_sql:
  29                         cursor.execute("select id, slot_id from teleforma_appointment where jury_id=%s" % jury[0])
  30                         apps = cursor.fetchall()
  31                         appointments = [app[0] for app in apps if app[1]==slot_id]
  32                         print appointments
  33                         jurys.append({
  34                             'id': jury[0],
  35                             'name': jury[1],
  36                             'address': jury[2],
  37                             'appointments': appointments
  38                         })
  39
  40                     slots.append({
  41                         'id':slot_id,
  42                         'jurys':jurys
  43                     })
  44                 print slots
  45
  46
  47                 dates.append({
  48                     'id':result[0],
  49                     'period': result[1],
  50                     'date': result[2],
  51                     'slots':slots
  52                 })
  53
  54             # appointments = {}
  55             # cursor.execute("select id, jury_id from teleforma_appointment")
  56             # for appointment in cursor.fetchall():
  57             #     appointments[appointment[0]] = appointment[1]
  58
  59             print dates
  60
  61
  62             # from teleforma.models import AppointmentDay
  63             # for day in AppointmentDay.objects.all():
  64             #
  65             #     corpus.descriptions = corpus.description
  66             #     corpus.save()
  67             #
  68             # for fonds in MediaFonds.objects.all():
  69             #     fonds.descriptions = fonds.description
  70             #     fonds.save()
  71
  72
  73         # Deleting model 'AppointmentDay'
  74         db.delete_table('teleforma_appointment_date')
  75
  76         # Deleting field 'AppointmentPeriod.book_delay'
  77         db.delete_column('teleforma_appointment_period', 'book_delay')
  78
  79         # Deleting field 'AppointmentPeriod.nb_appointments'
  80         db.delete_column('teleforma_appointment_period', 'nb_appointments')
  81
  82         # Deleting field 'AppointmentJury.day'
  83         db.delete_column('teleforma_appointment_jury', 'day_id')
  84
  85         # Adding field 'AppointmentJury.slot'
  86         db.add_column('teleforma_appointment_jury', 'slot',
  87                       self.gf('django.db.models.fields.related.ForeignKey')(related_name='jurys', null=True, to=orm['teleforma.AppointmentSlot']),
  88                       keep_default=False)
  89
  90         # Deleting field 'AppointmentSlot.day'
  91         db.delete_column('teleforma_appointment_slot', 'day_id')
  92
  93         # Adding field 'AppointmentSlot.date'
  94         db.add_column('teleforma_appointment_slot', 'date',
  95                       self.gf('django.db.models.fields.DateField')(null=True),
  96                       keep_default=False)
  97
  98         # Adding field 'AppointmentSlot.appointment_period'
  99         db.add_column('teleforma_appointment_slot', 'appointment_period',
 100                       self.gf('django.db.models.fields.related.ForeignKey')(related_name='slots', null=True,
 101                                                                             to=orm['teleforma.AppointmentPeriod']),
 102                       keep_default=False)
 103
 104         # Changing field 'Appointment.jury'
 105         db.alter_column('teleforma_appointment', 'jury_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, on_delete=models.SET_NULL, to=orm['teleforma.AppointmentJury']))
 106
 107         if not db.dry_run:
 108             from teleforma.models import Appointment, AppointmentSlot, AppointmentJury
 109             AppointmentJury.objects.all().delete()
 110
 111             for date in dates:
 112
 113                 # recreate juries and update slot date
 114                 for slotD in date['slots']:
 115                     # import pdb;pdb.set_trace()
 116                     slot = AppointmentSlot.objects.get(id=slotD['id'])
 117                     slot.date = date['date']
 118                     slot.appointment_period_id = date['period']
 119                     slot.save()
 120                     for jury in slotD['jurys']:
 121                         juryObj = AppointmentJury(slot=slot, name=jury['name'], address=jury['address'])
 122                         juryObj.save()
 123                         for app in jury['appointments']:
 124                             appointment = Appointment.objects.get(id=app)
 125                             appointment.jury = juryObj
 126                             appointment.save()
 127
 128
 129
 130
 131     def backwards(self, orm):
 132         pass
 133         # # User chose to not deal with backwards NULL issues for 'AppointmentJury.day'
 134         # raise RuntimeError("Cannot reverse this migration. 'AppointmentJury.day' and its values cannot be restored.")
 135         #
 136         # # Adding model 'AppointmentDay'
 137         # db.create_table('teleforma_appointment_date', (
 138         #     ('date', self.gf('django.db.models.fields.DateField')()),
 139         #     ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
 140         #     ('appointment_period', self.gf('django.db.models.fields.related.ForeignKey')(related_name='days', to=orm['teleforma.AppointmentPeriod'])),
 141         # ))
 142         # db.send_create_signal('teleforma', ['AppointmentDay'])
 143         #
 144         # # Adding field 'AppointmentPeriod.book_delay'
 145         # db.add_column('teleforma_appointment_period', 'book_delay',
 146         #               self.gf('django.db.models.fields.IntegerField')(default=2),
 147         #               keep_default=False)
 148         #
 149         # # Adding field 'AppointmentPeriod.nb_appointments'
 150         # db.add_column('teleforma_appointment_period', 'nb_appointments',
 151         #               self.gf('django.db.models.fields.IntegerField')(default=1),
 152         #               keep_default=False)
 153         #
 154         #
 155         #
 156         #
 157         # # The following code is provided here to aid in writing a correct migration        # Adding field 'AppointmentJury.day'
 158         # db.add_column('teleforma_appointment_jury', 'day',
 159         #               self.gf('django.db.models.fields.related.ForeignKey')(related_name='jurys', to=orm['teleforma.AppointmentDay']),
 160         #               keep_default=False)
 161         #
 162         # # Deleting field 'AppointmentJury.slot'
 163         # db.delete_column('teleforma_appointment_jury', 'slot_id')
 164         #
 165         #
 166         # # User chose to not deal with backwards NULL issues for 'AppointmentSlot.day'
 167         # raise RuntimeError("Cannot reverse this migration. 'AppointmentSlot.day' and its values cannot be restored.")
 168         #
 169         # # The following code is provided here to aid in writing a correct migration        # Adding field 'AppointmentSlot.day'
 170         # db.add_column('teleforma_appointment_slot', 'day',
 171         #               self.gf('django.db.models.fields.related.ForeignKey')(related_name='slots', to=orm['teleforma.AppointmentDay']),
 172         #               keep_default=False)
 173         #
 174         # # Deleting field 'AppointmentSlot.date'
 175         # db.delete_column('teleforma_appointment_slot', 'date')
 176         #
 177         # Deleting field 'AppointmentSlot.appointment_period'
 178         # db.delete_column('teleforma_appointment_slot', 'appointment_period_id')
 179         # The following code is provided here to aid in writing a correct migration
 180         # Changing field 'Appointment.jury'
 181         #db.alter_column('teleforma_appointment', 'jury_id',
 182         #                self.gf('django.db.models.fields.related.ForeignKey')(to=orm['teleforma.AppointmentJury']))
 183         # Deleting field 'AppointmentSlot.appointment_period'
 184         #db.delete_column('teleforma_appointment_slot', 'appointment_period_id')
 185
 186
 187     models = {
 188         'auth.group': {
 189             'Meta': {'object_name': 'Group'},
 190             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 191             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
 192             'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
 193         },
 194         'auth.permission': {
 195             'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
 196             'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
 197             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
 198             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 199             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
 200         },
 201         'auth.user': {
 202             'Meta': {'object_name': 'User'},
 203             'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
 204             'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
 205             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
 206             'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
 207             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 208             'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
 209             'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 210             'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 211             'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
 212             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
 213             'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
 214             'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
 215             'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
 216         },
 217         'contenttypes.contenttype': {
 218             'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
 219             'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
 220             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 221             'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
 222             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
 223         },
 224         'quiz.category': {
 225             'Meta': {'object_name': 'Category'},
 226             'category': ('django.db.models.fields.CharField', [], {'max_length': '250', 'unique': 'True', 'null': 'True', 'blank': 'True'}),
 227             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
 228         },
 229         'quiz.quiz': {
 230             'Meta': {'object_name': 'Quiz'},
 231             'answers_at_end': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 232             'category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['quiz.Category']", 'null': 'True', 'blank': 'True'}),
 233             'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
 234             'draft': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 235             'exam_paper': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 236             'fail_text': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
 237             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 238             'max_questions': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True', 'blank': 'True'}),
 239             'pass_mark': ('django.db.models.fields.SmallIntegerField', [], {'default': '0', 'blank': 'True'}),
 240             'random_order': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 241             'single_attempt': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 242             'success_text': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
 243             'title': ('django.db.models.fields.CharField', [], {'max_length': '60'}),
 244             'url': ('django.db.models.fields.SlugField', [], {'max_length': '60'})
 245         },
 246         'teleforma.aestudent': {
 247             'Meta': {'ordering': "['user__last_name']", 'object_name': 'AEStudent', 'db_table': "'teleforma_ae_student'"},
 248             'courses': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'ae_student'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Course']"}),
 249             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 250             'period': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'ae_student'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Period']"}),
 251             'platform_only': ('telemeta.models.core.BooleanField', [], {'default': 'False'}),
 252             'user': ('telemeta.models.core.ForeignKey', [], {'related_name': "'ae_student'", 'unique': 'True', 'to': "orm['auth.User']"})
 253         },
 254         'teleforma.appointment': {
 255             'Meta': {'unique_together': "(('slot', 'jury', 'slot_nb'),)", 'object_name': 'Appointment'},
 256             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 257             'jury': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'appointments'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.AppointmentJury']"}),
 258             'slot': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'appointments'", 'to': "orm['teleforma.AppointmentSlot']"}),
 259             'slot_nb': ('django.db.models.fields.IntegerField', [], {}),
 260             'student': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'appointments'", 'to': "orm['auth.User']"})
 261         },
 262         'teleforma.appointmentjury': {
 263             'Meta': {'ordering': "('id',)", 'object_name': 'AppointmentJury', 'db_table': "'teleforma_appointment_jury'"},
 264             'address': ('django.db.models.fields.TextField', [], {}),
 265             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 266             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 267             'slot': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'jurys'", 'null': 'True', 'to': "orm['teleforma.AppointmentSlot']"})
 268         },
 269         'teleforma.appointmentperiod': {
 270             'Meta': {'ordering': "('id',)", 'object_name': 'AppointmentPeriod', 'db_table': "'teleforma_appointment_period'"},
 271             'appointment_mail_text': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
 272             'appointment_slot_size': ('django.db.models.fields.IntegerField', [], {'default': '40'}),
 273             'cancel_delay': ('django.db.models.fields.IntegerField', [], {'default': '2'}),
 274             'enable_appointment': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
 275             'end': ('django.db.models.fields.DateField', [], {}),
 276             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 277             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 278             'periods': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'appointment_periods'", 'symmetrical': 'False', 'to': "orm['teleforma.Period']"}),
 279             'start': ('django.db.models.fields.DateField', [], {})
 280         },
 281         'teleforma.appointmentslot': {
 282             'Meta': {'ordering': "('id',)", 'object_name': 'AppointmentSlot', 'db_table': "'teleforma_appointment_slot'"},
 283             'appointment_period': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'slots'", 'null': 'True', 'to': "orm['teleforma.AppointmentPeriod']"}),
 284             'date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
 285             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 286             'nb': ('django.db.models.fields.IntegerField', [], {}),
 287             'start': ('django.db.models.fields.TimeField', [], {})
 288         },
 289         'teleforma.conference': {
 290             'Meta': {'ordering': "['-date_begin']", 'object_name': 'Conference'},
 291             'comment': ('teleforma.fields.ShortTextField', [], {'max_length': '255', 'blank': 'True'}),
 292             'course': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'conference'", 'to': "orm['teleforma.Course']"}),
 293             'course_type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'conference'", 'to': "orm['teleforma.CourseType']"}),
 294             'date_begin': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 295             'date_end': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 296             'department': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Department']"}),
 297             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 298             'period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Period']"}),
 299             'professor': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Professor']"}),
 300             'public_id': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 301             'readers': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['auth.User']"}),
 302             'room': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'to': "orm['teleforma.Room']"}),
 303             'session': ('django.db.models.fields.CharField', [], {'default': "'1'", 'max_length': '16'}),
 304             'status': ('django.db.models.fields.IntegerField', [], {'default': '2'}),
 305             'web_class_group': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conferences'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.WebClassGroup']"})
 306         },
 307         'teleforma.course': {
 308             'Meta': {'ordering': "['number']", 'object_name': 'Course'},
 309             'code': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 310             'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'null': 'True', 'blank': 'True'}),
 311             'department': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'course'", 'to': "orm['teleforma.Department']"}),
 312             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 313             'has_exam_scripts': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
 314             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 315             'magistral': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 316             'number': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
 317             'obligation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 318             'oral_1': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 319             'oral_2': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 320             'oral_speciality': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 321             'procedure': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 322             'quiz': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['quiz.Quiz']", 'null': 'True', 'blank': 'True'}),
 323             'synthesis_note': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 324             'title': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 325             'title_tweeter': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 326             'written_speciality': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
 327         },
 328         'teleforma.coursegroup': {
 329             'Meta': {'object_name': 'CourseGroup', 'db_table': "'teleforma_course_group'"},
 330             'courses': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'course_groups'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Course']"}),
 331             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 332             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 333         },
 334         'teleforma.coursetype': {
 335             'Meta': {'object_name': 'CourseType', 'db_table': "'teleforma_course_type'"},
 336             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 337             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 338             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 339         },
 340         'teleforma.department': {
 341             'Meta': {'object_name': 'Department'},
 342             'default_period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'departments'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Period']"}),
 343             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 344             'domain': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 345             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 346             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 347             'organization': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'department'", 'to': "orm['teleforma.Organization']"})
 348         },
 349         'teleforma.discount': {
 350             'Meta': {'object_name': 'Discount', 'db_table': "'teleforma_discounts'"},
 351             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 352             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 353             'student': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'discounts'", 'to': "orm['teleforma.Student']"}),
 354             'value': ('django.db.models.fields.FloatField', [], {})
 355         },
 356         'teleforma.document': {
 357             'Meta': {'ordering': "['-date_added']", 'object_name': 'Document'},
 358             'annal_year': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
 359             'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 360             'conference': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'document'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Conference']"}),
 361             'course': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'document'", 'to': "orm['teleforma.Course']"}),
 362             'course_type': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'document'", 'blank': 'True', 'to': "orm['teleforma.CourseType']"}),
 363             'credits': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 364             'date_added': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
 365             'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'null': 'True', 'blank': 'True'}),
 366             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 367             'file': ('telemeta.models.core.FileField', [], {'default': "''", 'max_length': '1024', 'db_column': "'filename'", 'blank': 'True'}),
 368             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 369             'iej': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'document'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.IEJ']"}),
 370             'is_annal': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 371             'is_published': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 372             'mime_type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 373             'periods': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'documents'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Period']"}),
 374             'readers': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'document'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['auth.User']"}),
 375             'session': ('django.db.models.fields.CharField', [], {'default': "'1'", 'max_length': '16'}),
 376             'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 377             'type': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'document'", 'null': 'True', 'to': "orm['teleforma.DocumentType']"}),
 378             'weight': ('django.db.models.fields.IntegerField', [], {'default': '1', 'blank': 'True'})
 379         },
 380         'teleforma.documentsimple': {
 381             'Meta': {'ordering': "['-date_added']", 'object_name': 'DocumentSimple', 'db_table': "'teleforma_document_simple'"},
 382             'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 383             'credits': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 384             'date_added': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
 385             'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'null': 'True', 'blank': 'True'}),
 386             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 387             'file': ('telemeta.models.core.FileField', [], {'default': "''", 'max_length': '1024', 'db_column': "'filename'", 'blank': 'True'}),
 388             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 389             'is_published': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 390             'mime_type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 391             'period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'document_simple'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Period']"}),
 392             'readers': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'document_simple'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['auth.User']"}),
 393             'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 394             'weight': ('django.db.models.fields.IntegerField', [], {'default': '1', 'blank': 'True'})
 395         },
 396         'teleforma.documenttype': {
 397             'Meta': {'ordering': "['number']", 'object_name': 'DocumentType', 'db_table': "'teleforma_document_type'"},
 398             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 399             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 400             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 401             'number': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
 402         },
 403         'teleforma.groupedmessage': {
 404             'Meta': {'object_name': 'GroupedMessage', 'db_table': "'teleforma_grouped_messages'"},
 405             'date_sent': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 406             'group': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'grouped_messages'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.StudentGroup']"}),
 407             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 408             'message': ('django.db.models.fields.TextField', [], {}),
 409             'sender': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'grouped_messages'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),
 410             'sent': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 411             'subject': ('django.db.models.fields.CharField', [], {'max_length': '119'}),
 412             'to_send': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
 413         },
 414         'teleforma.home': {
 415             'Meta': {'object_name': 'Home'},
 416             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 417             'text': ('tinymce.models.HTMLField', [], {'blank': 'True'}),
 418             'video': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['teleforma.Media']", 'null': 'True', 'blank': 'True'})
 419         },
 420         'teleforma.iej': {
 421             'Meta': {'ordering': "['name']", 'object_name': 'IEJ'},
 422             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 423             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 424             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 425         },
 426         'teleforma.livestream': {
 427             'Meta': {'object_name': 'LiveStream', 'db_table': "'teleforma_live_stream'"},
 428             'conference': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'livestream'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Conference']"}),
 429             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 430             'server': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'livestream'", 'to': "orm['teleforma.StreamingServer']"}),
 431             'stream_type': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
 432             'streaming': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
 433         },
 434         'teleforma.media': {
 435             'Meta': {'ordering': "['-date_modified', '-conference__session']", 'object_name': 'Media'},
 436             'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 437             'conference': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'media'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Conference']"}),
 438             'course': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'media'", 'null': 'True', 'to': "orm['teleforma.Course']"}),
 439             'course_type': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'media'", 'null': 'True', 'to': "orm['teleforma.CourseType']"}),
 440             'credits': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 441             'date_added': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
 442             'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'null': 'True', 'blank': 'True'}),
 443             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 444             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 445             'is_published': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 446             'item': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'media'", 'null': 'True', 'to': "orm['telemeta.MediaItem']"}),
 447             'mime_type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 448             'period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'media'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Period']"}),
 449             'readers': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'media'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['auth.User']"}),
 450             'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 451             'type': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
 452             'weight': ('django.db.models.fields.IntegerField', [], {'default': '1', 'blank': 'True'})
 453         },
 454         'teleforma.newsitem': {
 455             'Meta': {'object_name': 'NewsItem'},
 456             'course': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'newsitems'", 'to': "orm['teleforma.Course']"}),
 457             'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
 458             'creator': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'newsitems'", 'to': "orm['auth.User']"}),
 459             'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 460             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 461             'period': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'newsitems'", 'null': 'True', 'to': "orm['teleforma.Period']"}),
 462             'text': ('tinymce.models.HTMLField', [], {}),
 463             'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 464         },
 465         'teleforma.optionalfee': {
 466             'Meta': {'object_name': 'OptionalFee', 'db_table': "'teleforma_optional_fees'"},
 467             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 468             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 469             'student': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'optional_fees'", 'to': "orm['teleforma.Student']"}),
 470             'value': ('django.db.models.fields.FloatField', [], {})
 471         },
 472         'teleforma.organization': {
 473             'Meta': {'object_name': 'Organization'},
 474             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 475             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 476             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 477         },
 478         'teleforma.payback': {
 479             'Meta': {'object_name': 'Payback', 'db_table': "'teleforma_paybacks'"},
 480             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 481             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 482             'student': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'paybacks'", 'to': "orm['teleforma.Student']"}),
 483             'value': ('django.db.models.fields.FloatField', [], {})
 484         },
 485         'teleforma.payment': {
 486             'Meta': {'ordering': "['month']", 'object_name': 'Payment', 'db_table': "'teleforma_payments'"},
 487             'collected': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 488             'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
 489             'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
 490             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 491             'month': ('django.db.models.fields.IntegerField', [], {'default': '1'}),
 492             'student': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'payments'", 'to': "orm['teleforma.Student']"}),
 493             'type': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
 494             'value': ('django.db.models.fields.FloatField', [], {})
 495         },
 496         'teleforma.period': {
 497             'Meta': {'ordering': "['name']", 'object_name': 'Period'},
 498             'date_begin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
 499             'date_end': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
 500             'date_exam_end': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 501             'date_password_init': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
 502             'department': ('telemeta.models.core.ForeignKey', [], {'default': 'None', 'related_name': "'period'", 'null': 'True', 'blank': 'True', 'to': "orm['teleforma.Department']"}),
 503             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 504             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 505             'is_open': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
 506             'message_local': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
 507             'message_platform': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
 508             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 509             'parent': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'children'", 'null': 'True', 'to': "orm['teleforma.Period']"})
 510         },
 511         'teleforma.professor': {
 512             'Meta': {'ordering': "['user__last_name']", 'object_name': 'Professor'},
 513             'courses': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'professor'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Course']"}),
 514             'department': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'professor'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Department']"}),
 515             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 516             'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'professor'", 'unique': 'True', 'to': "orm['auth.User']"})
 517         },
 518         'teleforma.profile': {
 519             'Meta': {'object_name': 'Profile', 'db_table': "'teleforma_profiles'"},
 520             'address': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 521             'address_detail': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
 522             'birthday': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
 523             'city': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 524             'country': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 525             'expiration_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
 526             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 527             'init_password': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 528             'language': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 529             'postal_code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 530             'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 531             'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'profile'", 'unique': 'True', 'to': "orm['auth.User']"}),
 532             'wifi_login': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 533             'wifi_pass': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
 534         },
 535         'teleforma.room': {
 536             'Meta': {'object_name': 'Room'},
 537             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 538             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 539             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 540             'organization': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'room'", 'to': "orm['teleforma.Organization']"})
 541         },
 542         'teleforma.streamingserver': {
 543             'Meta': {'object_name': 'StreamingServer', 'db_table': "'teleforma_streaming_server'"},
 544             'admin_password': ('django.db.models.fields.CharField', [], {'max_length': '32', 'blank': 'True'}),
 545             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 546             'host': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 547             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 548             'port': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
 549             'source_password': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
 550             'type': ('django.db.models.fields.CharField', [], {'max_length': '32'})
 551         },
 552         'teleforma.student': {
 553             'Meta': {'ordering': "['user__last_name', '-date_subscribed']", 'object_name': 'Student'},
 554             'application_fees': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 555             'confirmation_sent': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 556             'date_registered': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}),
 557             'date_subscribed': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 558             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 559             'iej': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'student'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.IEJ']"}),
 560             'is_subscribed': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 561             'level': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
 562             'options': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'options_students'", 'null': 'True', 'to': "orm['teleforma.Course']"}),
 563             'oral_1': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'oral_1_students'", 'null': 'True', 'to': "orm['teleforma.Course']"}),
 564             'oral_2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'oral_2_students'", 'null': 'True', 'to': "orm['teleforma.Course']"}),
 565             'oral_speciality': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'oral_speciality_students'", 'null': 'True', 'to': "orm['teleforma.Course']"}),
 566             'period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'student'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Period']"}),
 567             'platform_only': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 568             'procedure': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'procedure_students'", 'null': 'True', 'to': "orm['teleforma.Course']"}),
 569             'promo_code': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
 570             'subscription_fees': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
 571             'training': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'student_training'", 'null': 'True', 'to': "orm['teleforma.Training']"}),
 572             'trainings': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'student_trainings'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Training']"}),
 573             'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'student'", 'unique': 'True', 'to': "orm['auth.User']"}),
 574             'written_speciality': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'written_speciality_2students'", 'null': 'True', 'to': "orm['teleforma.Course']"})
 575         },
 576         'teleforma.studentgroup': {
 577             'Meta': {'object_name': 'StudentGroup', 'db_table': "'teleforma_student_groups'"},
 578             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 579             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 580             'students': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'groups'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Student']"})
 581         },
 582         'teleforma.training': {
 583             'Meta': {'object_name': 'Training'},
 584             'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 585             'code': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 586             'cost': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
 587             'description': ('django.db.models.fields.CharField', [], {'max_length': '512', 'blank': 'True'}),
 588             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 589             'magistral': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_magistral'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 590             'name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 591             'obligation': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_obligation'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 592             'options': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_options'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 593             'oral_1': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_oral_1'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 594             'oral_2': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_oral_2'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 595             'oral_speciality': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_oral_speciality'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 596             'parent': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'children'", 'null': 'True', 'to': "orm['teleforma.Training']"}),
 597             'period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'training'", 'null': 'True', 'to': "orm['teleforma.Period']"}),
 598             'procedure': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_procedure'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 599             'synthesis_note': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_synthesis_note'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"}),
 600             'written_speciality': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'training_written_speciality'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.CourseType']"})
 601         },
 602         'teleforma.webclassgroup': {
 603             'Meta': {'ordering': "['name']", 'object_name': 'WebClassGroup'},
 604             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 605             'iejs': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'web_class_group'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.IEJ']"}),
 606             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 607         },
 608         'telemeta.acquisitionmode': {
 609             'Meta': {'ordering': "['value']", 'object_name': 'AcquisitionMode', 'db_table': "'acquisition_modes'"},
 610             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 611             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 612         },
 613         'telemeta.adconversion': {
 614             'Meta': {'ordering': "['value']", 'object_name': 'AdConversion', 'db_table': "'ad_conversions'"},
 615             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 616             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 617         },
 618         'telemeta.ethnicgroup': {
 619             'Meta': {'ordering': "['value']", 'object_name': 'EthnicGroup', 'db_table': "'ethnic_groups'"},
 620             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 621             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 622         },
 623         'telemeta.genericstyle': {
 624             'Meta': {'ordering': "['value']", 'object_name': 'GenericStyle', 'db_table': "'generic_styles'"},
 625             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 626             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 627         },
 628         'telemeta.language': {
 629             'Meta': {'ordering': "['name']", 'object_name': 'Language', 'db_table': "'languages'"},
 630             'comment': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 631             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 632             'identifier': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '3', 'blank': 'True'}),
 633             'name': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 634             'part1': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '1', 'blank': 'True'}),
 635             'part2B': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '3', 'blank': 'True'}),
 636             'part2T': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '3', 'blank': 'True'}),
 637             'scope': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '1', 'blank': 'True'}),
 638             'type': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '1', 'blank': 'True'})
 639         },
 640         'telemeta.legalright': {
 641             'Meta': {'ordering': "['value']", 'object_name': 'LegalRight', 'db_table': "'legal_rights'"},
 642             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 643             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 644         },
 645         'telemeta.location': {
 646             'Meta': {'ordering': "['name']", 'object_name': 'Location', 'db_table': "'locations'"},
 647             'complete_type': ('telemeta.models.core.ForeignKey', [], {'related_name': "'locations'", 'to': "orm['telemeta.LocationType']"}),
 648             'current_location': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'past_names'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.Location']"}),
 649             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 650             'is_authoritative': ('telemeta.models.core.BooleanField', [], {'default': 'False'}),
 651             'latitude': ('telemeta.models.core.FloatField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
 652             'longitude': ('telemeta.models.core.FloatField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
 653             'name': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '150'}),
 654             'type': ('telemeta.models.core.IntegerField', [], {'default': '0', 'db_index': 'True', 'blank': 'True'})
 655         },
 656         'telemeta.locationtype': {
 657             'Meta': {'ordering': "['name']", 'object_name': 'LocationType', 'db_table': "'location_types'"},
 658             'code': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '64'}),
 659             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 660             'name': ('telemeta.models.core.CharField', [], {'max_length': '150'})
 661         },
 662         'telemeta.mediacollection': {
 663             'Meta': {'ordering': "['code']", 'object_name': 'MediaCollection', 'db_table': "'media_collections'"},
 664             'a_informer_07_03': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 665             'acquisition_mode': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.AcquisitionMode']"}),
 666             'ad_conversion': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.AdConversion']"}),
 667             'alt_ids': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 668             'alt_title': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 669             'approx_duration': ('telemeta.models.core.DurationField', [], {'default': "'0'", 'blank': 'True'}),
 670             'auto_period_access': ('telemeta.models.core.BooleanField', [], {'default': 'True'}),
 671             'booklet_author': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 672             'booklet_description': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 673             'cnrs_contributor': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 674             'code': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'}),
 675             'collector': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 676             'collector_is_creator': ('telemeta.models.core.BooleanField', [], {'default': 'False'}),
 677             'comment': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 678             'conservation_site': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 679             'creator': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 680             'doctype_code': ('telemeta.models.core.IntegerField', [], {'default': '0', 'blank': 'True'}),
 681             'external_references': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 682             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 683             'is_published': ('telemeta.models.core.BooleanField', [], {'default': 'False'}),
 684             'items_done': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 685             'legal_rights': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.LegalRight']"}),
 686             'metadata_author': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.MetadataAuthor']"}),
 687             'metadata_writer': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.MetadataWriter']"}),
 688             'old_code': ('telemeta.models.core.CharField', [], {'default': 'None', 'max_length': '250', 'null': 'True', 'blank': 'True'}),
 689             'physical_format': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.PhysicalFormat']"}),
 690             'physical_items_num': ('telemeta.models.core.IntegerField', [], {'default': '0', 'blank': 'True'}),
 691             'public_access': ('telemeta.models.core.CharField', [], {'default': "'metadata'", 'max_length': '16', 'blank': 'True'}),
 692             'publisher': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.Publisher']"}),
 693             'publisher_collection': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.PublisherCollection']"}),
 694             'publisher_serial': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 695             'publishing_status': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.PublishingStatus']"}),
 696             'recorded_from_year': ('telemeta.models.core.IntegerField', [], {'default': '0', 'blank': 'True'}),
 697             'recorded_to_year': ('telemeta.models.core.IntegerField', [], {'default': '0', 'blank': 'True'}),
 698             'recording_context': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'collections'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.RecordingContext']"}),
 699             'reference': ('telemeta.models.core.CharField', [], {'default': 'None', 'max_length': '250', 'unique': 'True', 'null': 'True', 'blank': 'True'}),
 700             'state': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 701             'title': ('telemeta.models.core.CharField', [], {'max_length': '250'}),
 702             'travail': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 703             'year_published': ('telemeta.models.core.IntegerField', [], {'default': '0', 'blank': 'True'})
 704         },
 705         'telemeta.mediaitem': {
 706             'Meta': {'object_name': 'MediaItem', 'db_table': "'media_items'"},
 707             'alt_title': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 708             'approx_duration': ('telemeta.models.core.DurationField', [], {'default': "'0'", 'blank': 'True'}),
 709             'author': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 710             'auto_period_access': ('telemeta.models.core.BooleanField', [], {'default': 'True'}),
 711             'code': ('telemeta.models.core.CharField', [], {'default': "''", 'unique': 'True', 'max_length': '250', 'blank': 'True'}),
 712             'collection': ('telemeta.models.core.ForeignKey', [], {'related_name': "'items'", 'to': "orm['telemeta.MediaCollection']"}),
 713             'collector': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 714             'collector_from_collection': ('telemeta.models.core.BooleanField', [], {'default': 'False'}),
 715             'collector_selection': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 716             'comment': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 717             'context_comment': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 718             'contributor': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 719             'copied_from_item': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'copies'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.MediaItem']"}),
 720             'creator_reference': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 721             'cultural_area': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 722             'depositor': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 723             'digitalist': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 724             'digitization_date': ('telemeta.models.core.DateField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
 725             'ethnic_group': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'items'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.EthnicGroup']"}),
 726             'external_references': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 727             'file': ('telemeta.models.core.FileField', [], {'default': "''", 'max_length': '1024', 'db_column': "'filename'", 'blank': 'True'}),
 728             'generic_style': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'items'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.GenericStyle']"}),
 729             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 730             'language': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 731             'language_iso': ('telemeta.models.core.ForeignKey', [], {'related_name': "'items'", 'on_delete': 'models.SET_NULL', 'default': 'None', 'to': "orm['telemeta.Language']", 'blank': 'True', 'null': 'True'}),
 732             'location': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'to': "orm['telemeta.Location']", 'null': 'True', 'blank': 'True'}),
 733             'location_comment': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 734             'mimetype': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
 735             'moda_execut': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 736             'old_code': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 737             'organization': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'to': "orm['telemeta.Organization']", 'null': 'True', 'blank': 'True'}),
 738             'public_access': ('telemeta.models.core.CharField', [], {'default': "'metadata'", 'max_length': '16', 'blank': 'True'}),
 739             'publishing_date': ('telemeta.models.core.DateField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
 740             'recorded_from_date': ('telemeta.models.core.DateField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
 741             'recorded_to_date': ('telemeta.models.core.DateField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
 742             'recordist': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 743             'rights': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'to': "orm['telemeta.Rights']", 'null': 'True', 'blank': 'True'}),
 744             'scientist': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 745             'summary': ('telemeta.models.core.TextField', [], {'default': "''", 'blank': 'True'}),
 746             'title': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 747             'topic': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'to': "orm['telemeta.Topic']", 'null': 'True', 'blank': 'True'}),
 748             'track': ('telemeta.models.core.CharField', [], {'default': "''", 'max_length': '250', 'blank': 'True'}),
 749             'url': ('django.db.models.fields.URLField', [], {'max_length': '512', 'blank': 'True'}),
 750             'vernacular_style': ('telemeta.models.core.WeakForeignKey', [], {'default': 'None', 'related_name': "'items'", 'null': 'True', 'blank': 'True', 'to': "orm['telemeta.VernacularStyle']"})
 751         },
 752         'telemeta.metadataauthor': {
 753             'Meta': {'ordering': "['value']", 'object_name': 'MetadataAuthor', 'db_table': "'metadata_authors'"},
 754             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 755             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 756         },
 757         'telemeta.metadatawriter': {
 758             'Meta': {'ordering': "['value']", 'object_name': 'MetadataWriter', 'db_table': "'metadata_writers'"},
 759             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 760             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 761         },
 762         'telemeta.organization': {
 763             'Meta': {'ordering': "['value']", 'object_name': 'Organization', 'db_table': "'organization'"},
 764             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 765             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 766         },
 767         'telemeta.physicalformat': {
 768             'Meta': {'ordering': "['value']", 'object_name': 'PhysicalFormat', 'db_table': "'physical_formats'"},
 769             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 770             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 771         },
 772         'telemeta.publisher': {
 773             'Meta': {'ordering': "['value']", 'object_name': 'Publisher', 'db_table': "'publishers'"},
 774             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 775             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 776         },
 777         'telemeta.publishercollection': {
 778             'Meta': {'ordering': "['value']", 'object_name': 'PublisherCollection', 'db_table': "'publisher_collections'"},
 779             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 780             'publisher': ('telemeta.models.core.ForeignKey', [], {'related_name': "'publisher_collections'", 'to': "orm['telemeta.Publisher']"}),
 781             'value': ('telemeta.models.core.CharField', [], {'max_length': '250'})
 782         },
 783         'telemeta.publishingstatus': {
 784             'Meta': {'ordering': "['value']", 'object_name': 'PublishingStatus', 'db_table': "'publishing_status'"},
 785             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 786             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 787         },
 788         'telemeta.recordingcontext': {
 789             'Meta': {'ordering': "['value']", 'object_name': 'RecordingContext', 'db_table': "'recording_contexts'"},
 790             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 791             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 792         },
 793         'telemeta.rights': {
 794             'Meta': {'ordering': "['value']", 'object_name': 'Rights', 'db_table': "'rights'"},
 795             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 796             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 797         },
 798         'telemeta.topic': {
 799             'Meta': {'ordering': "['value']", 'object_name': 'Topic', 'db_table': "'topic'"},
 800             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 801             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 802         },
 803         'telemeta.vernacularstyle': {
 804             'Meta': {'ordering': "['value']", 'object_name': 'VernacularStyle', 'db_table': "'vernacular_styles'"},
 805             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 806             'value': ('telemeta.models.core.CharField', [], {'unique': 'True', 'max_length': '250'})
 807         }
 808     }
 809
 810     complete_apps = ['teleforma']