git.parisson.com Git - telecaster-client.git/blob

   1 # -*- coding: 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
   8 class Migration(SchemaMigration):
   9
  10     def forwards(self, orm):
  11         # Deleting model 'Session'
  12         db.delete_table('telecaster_session')
  13
  14         # Deleting model 'Department'
  15         db.delete_table('telecaster_department')
  16
  17         # Deleting model 'Organization'
  18         db.delete_table('telecaster_organization')
  19
  20         # Deleting model 'Professor'
  21         db.delete_table('telecaster_professor')
  22
  23         # Deleting model 'Conference'
  24         db.delete_table('telecaster_conference')
  25
  26
  27         # Changing field 'Station.conference'
  28         db.alter_column('telecaster_station', 'conference_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['teleforma.Conference']))
  29
  30         # Changing field 'Station.professor'
  31         db.alter_column('telecaster_station', 'professor_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['teleforma.Professor']))
  32
  33         # Renaming column for 'Station.session' to match new field type.
  34         db.rename_column('telecaster_station', 'session_id', 'session')
  35         # Changing field 'Station.session'
  36         db.alter_column('telecaster_station', 'session', self.gf('django.db.models.fields.CharField')(max_length=16))
  37         # Removing index on 'Station', fields ['session']
  38         db.delete_index('telecaster_station', ['session_id'])
  39
  40
  41         # Changing field 'Station.department'
  42         db.alter_column('telecaster_station', 'department_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['teleforma.Department']))
  43
  44         # Changing field 'Station.organization'
  45         db.alter_column('telecaster_station', 'organization_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['teleforma.Organization']))
  46     def backwards(self, orm):
  47         # Adding index on 'Station', fields ['session']
  48         db.create_index('telecaster_station', ['session_id'])
  49
  50         # Adding model 'Session'
  51         db.create_table('telecaster_session', (
  52             ('number', self.gf('django.db.models.fields.IntegerField')()),
  53             ('description', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  54             ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  55             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  56         ))
  57         db.send_create_signal('telecaster', ['Session'])
  58
  59         # Adding model 'Department'
  60         db.create_table('telecaster_department', (
  61             ('description', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  62             ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  63             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  64         ))
  65         db.send_create_signal('telecaster', ['Department'])
  66
  67         # Adding model 'Organization'
  68         db.create_table('telecaster_organization', (
  69             ('description', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  70             ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  71             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  72         ))
  73         db.send_create_signal('telecaster', ['Organization'])
  74
  75         # Adding model 'Professor'
  76         db.create_table('telecaster_professor', (
  77             ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  78             ('institution', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  79             ('telephone', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  80             ('email', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  81             ('address', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  82             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  83         ))
  84         db.send_create_signal('telecaster', ['Professor'])
  85
  86         # Adding model 'Conference'
  87         db.create_table('telecaster_conference', (
  88             ('department', self.gf('django.db.models.fields.related.ForeignKey')(related_name='conferences', to=orm['telecaster.Department'])),
  89             ('title', self.gf('django.db.models.fields.CharField')(max_length=255)),
  90             ('description', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  91             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  92         ))
  93         db.send_create_signal('telecaster', ['Conference'])
  94
  95
  96         # Changing field 'Station.conference'
  97         db.alter_column('telecaster_station', 'conference_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['telecaster.Conference']))
  98
  99         # Changing field 'Station.professor'
 100         db.alter_column('telecaster_station', 'professor_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['telecaster.Professor']))
 101
 102         # Renaming column for 'Station.session' to match new field type.
 103         db.rename_column('telecaster_station', 'session', 'session_id')
 104         # Changing field 'Station.session'
 105         db.alter_column('telecaster_station', 'session_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['telecaster.Session']))
 106
 107         # Changing field 'Station.department'
 108         db.alter_column('telecaster_station', 'department_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['telecaster.Department']))
 109
 110         # Changing field 'Station.organization'
 111         db.alter_column('telecaster_station', 'organization_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['telecaster.Organization']))
 112     models = {
 113         'auth.group': {
 114             'Meta': {'object_name': 'Group'},
 115             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 116             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
 117             'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
 118         },
 119         'auth.permission': {
 120             'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
 121             'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
 122             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
 123             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 124             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
 125         },
 126         'auth.user': {
 127             'Meta': {'object_name': 'User'},
 128             'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
 129             'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
 130             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
 131             'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
 132             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 133             'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
 134             'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 135             'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 136             'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
 137             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
 138             'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
 139             'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
 140             'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
 141         },
 142         'contenttypes.contenttype': {
 143             'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
 144             'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
 145             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 146             'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
 147             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
 148         },
 149         'notes.note': {
 150             'Meta': {'object_name': 'Note'},
 151             'author': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True', 'blank': 'True'}),
 152             'content': ('django.db.models.fields.TextField', [], {}),
 153             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
 154             'created': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now', 'blank': 'True'}),
 155             'date': ('django.db.models.fields.DateField', [], {'default': 'datetime.datetime(2012, 6, 25, 0, 0)'}),
 156             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 157             'markup': ('django.db.models.fields.CharField', [], {'default': "'m'", 'max_length': '1'}),
 158             'modified': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now', 'blank': 'True'}),
 159             'object_id': ('django.db.models.fields.PositiveIntegerField', [], {}),
 160             'public': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
 161             'rendered_content': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
 162             'topic': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['notes.Topic']"})
 163         },
 164         'notes.topic': {
 165             'Meta': {'object_name': 'Topic'},
 166             'created': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now', 'blank': 'True'}),
 167             'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
 168             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 169             'modified': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now', 'blank': 'True'}),
 170             'slug': ('django_extensions.db.fields.AutoSlugField', [], {'allow_duplicates': 'False', 'max_length': '50', 'separator': "u'-'", 'blank': 'True', 'populate_from': "'title'", 'overwrite': 'False'}),
 171             'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 172         },
 173         'telecaster.record': {
 174             'Meta': {'object_name': 'Record'},
 175             'datetime': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
 176             'file': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
 177             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 178             'station': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'records'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['telecaster.Station']"})
 179         },
 180         'telecaster.station': {
 181             'Meta': {'object_name': 'Station'},
 182             'comment': ('telecaster.models.ShortTextField', [], {'blank': 'True'}),
 183             'conference': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'station'", 'null': 'True', 'to': "orm['teleforma.Conference']"}),
 184             'datetime_start': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 185             'datetime_stop': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 186             'department': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'station'", 'null': 'True', 'to': "orm['teleforma.Department']"}),
 187             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 188             'organization': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'station'", 'null': 'True', 'to': "orm['teleforma.Organization']"}),
 189             'professor': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'station'", 'null': 'True', 'to': "orm['teleforma.Professor']"}),
 190             'public_id': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 191             'session': ('django.db.models.fields.CharField', [], {'default': "'1'", 'max_length': '16'}),
 192             'started': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
 193         },
 194         'teleforma.conference': {
 195             'Meta': {'ordering': "['-date_begin']", 'object_name': 'Conference'},
 196             'comment': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 197             'course': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'conference'", 'to': "orm['teleforma.Course']"}),
 198             'course_type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'conference'", 'to': "orm['teleforma.CourseType']"}),
 199             'date_begin': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 200             'date_end': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
 201             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 202             'professor': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['teleforma.Professor']"}),
 203             'readers': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['auth.User']"}),
 204             'room': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'conference'", 'null': 'True', 'to': "orm['teleforma.Room']"}),
 205             'session': ('django.db.models.fields.CharField', [], {'default': "'1'", 'max_length': '16'})
 206         },
 207         'teleforma.course': {
 208             'Meta': {'ordering': "['number']", 'object_name': 'Course'},
 209             'code': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 210             'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
 211             'department': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'course'", 'to': "orm['teleforma.Department']"}),
 212             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 213             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 214             'magistral': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 215             'number': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
 216             'obligation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 217             'synthesis_note': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
 218             'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 219         },
 220         'teleforma.coursetype': {
 221             'Meta': {'object_name': 'CourseType', 'db_table': "'teleforma_course_type'"},
 222             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 223             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 224             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 225         },
 226         'teleforma.department': {
 227             'Meta': {'object_name': 'Department'},
 228             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 229             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 230             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 231             'organization': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'department'", 'to': "orm['teleforma.Organization']"})
 232         },
 233         'teleforma.organization': {
 234             'Meta': {'object_name': 'Organization'},
 235             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 236             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 237             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
 238         },
 239         'teleforma.professor': {
 240             'Meta': {'object_name': 'Professor'},
 241             'courses': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'professor'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['teleforma.Course']"}),
 242             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 243             'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'professor'", 'unique': 'True', 'to': "orm['auth.User']"})
 244         },
 245         'teleforma.room': {
 246             'Meta': {'object_name': 'Room'},
 247             'description': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
 248             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
 249             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
 250             'organization': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'room'", 'to': "orm['teleforma.Organization']"})
 251         }
 252     }
 253
 254     complete_apps = ['telecaster']