text: # -*- coding: utf-8 -*-
  from south.utils import datetime_utils as datetime
  from south.db import db
  from south.v2 import SchemaMigration
  from django.db import models
  
  
  class Migration(SchemaMigration):
  
      def forwards(self, orm):
          # Adding field 'Signature.document_sha'
          db.add_column(u'main_signature', 'document_sha',
                        self.gf('django.db.models.fields.CharField')(default='', max_length=255),
                        keep_default=False)
  
  
      def backwards(self, orm):
          # Deleting field 'Signature.document_sha'
          db.delete_column(u'main_signature', 'document_sha')
  
  
      models = {
          u'auth.group': {
              'Meta': {'object_name': 'Group'},
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
              'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
          },
          u'auth.permission': {
              'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'},
              'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
              'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
          },
          u'contenttypes.contenttype': {
              'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
              'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
          },
          u'main.file': {
              'Meta': {'object_name': 'File'},
              'access': ('django.db.models.fields.CharField', [], {'default': "'agep'", 'max_length': '64'}),
              'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'file': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
              'group': ('django.db.models.fields.CharField', [], {'default': "'misc'", 'max_length': '64'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
          },
          u'main.filelogging': {
              'Meta': {'object_name': 'FileLogging'},
              'extra_data': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'logs'", 'to': u"orm['main.File']"}),
              'what': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.fileviews': {
              'Meta': {'object_name': 'FileViews'},
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'views'", 'to': u"orm['main.File']"}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.homepagenews': {
              'Meta': {'object_name': 'HomePageNews'},
              'content': ('django.db.models.fields.TextField', [], {}),
              'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'end_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'start_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
              'status': ('django.db.models.fields.CharField', [], {'default': "'0_draft'", 'max_length': '255'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
          },
          u'main.homepagenewslogging': {
              'Meta': {'object_name': 'HomePageNewsLogging'},
              'extra_data': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'logs'", 'to': u"orm['main.HomePageNews']"}),
              'what': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.homepagenewsviews': {
              'Meta': {'object_name': 'HomePageNewsViews'},
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'views'", 'to': u"orm['main.HomePageNews']"}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.link': {
              'Meta': {'object_name': 'Link'},
              'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'icon': ('django.db.models.fields.CharField', [], {'default': "'fa-external-link-square'", 'max_length': '128'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'leftmenu': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'unit': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['units.Unit']"}),
              'url': ('django.db.models.fields.URLField', [], {'max_length': '200'})
          },
          u'main.linklogging': {
              'Meta': {'object_name': 'LinkLogging'},
              'extra_data': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'logs'", 'to': u"orm['main.Link']"}),
              'what': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.linkviews': {
              'Meta': {'object_name': 'LinkViews'},
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'views'", 'to': u"orm['main.Link']"}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.signabledocument': {
              'Meta': {'object_name': 'SignableDocument'},
              'active': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'file': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'roles': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['units.Role']", 'symmetrical': 'False'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
          },
          u'main.signabledocumentlogging': {
              'Meta': {'object_name': 'SignableDocumentLogging'},
              'extra_data': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'logs'", 'to': u"orm['main.SignableDocument']"}),
              'what': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.signabledocumentviews': {
              'Meta': {'object_name': 'SignableDocumentViews'},
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'views'", 'to': u"orm['main.SignableDocument']"}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'who': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"})
          },
          u'main.signature': {
              'Meta': {'object_name': 'Signature'},
              'document': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['main.SignableDocument']"}),
              'document_sha': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'ip': ('django.db.models.fields.IPAddressField', [], {'max_length': '15'}),
              'user': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['users.TruffeUser']"}),
              'useragent': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'when': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'})
          },
          u'units.role': {
              'Meta': {'object_name': 'Role'},
              'access': ('multiselectfield.db.fields.MultiSelectField', [], {'max_length': '97', 'null': 'True', 'blank': 'True'}),
              'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'id_epfl': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'need_validation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'order': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
          },
          u'units.unit': {
              'Meta': {'object_name': 'Unit'},
              'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'id_epfl': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'}),
              'is_commission': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'is_equipe': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'is_hidden': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'parent_hierarchique': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['units.Unit']", 'null': 'True', 'blank': 'True'}),
              'url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'})
          },
          u'users.truffeuser': {
              'Meta': {'object_name': 'TruffeUser'},
              'adresse': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
              'avatar': ('django.db.models.fields.files.ImageField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}),
              'body': ('django.db.models.fields.CharField', [], {'default': "'.'", 'max_length': '1'}),
              'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
              'email': ('django.db.models.fields.EmailField', [], {'max_length': '255'}),
              'email_perso': ('django.db.models.fields.EmailField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
              'first_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
              'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Group']"}),
              'homepage': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'iban_ou_ccp': ('django.db.models.fields.CharField', [], {'max_length': '128', 'blank': 'True'}),
              u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
              'is_betatester': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
              'last_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
              'mobile': ('django.db.models.fields.CharField', [], {'max_length': '25', 'blank': 'True'}),
              'nom_banque': ('django.db.models.fields.CharField', [], {'max_length': '128', 'blank': 'True'}),
              'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Permission']"}),
              'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'})
          }
      }
  
      complete_apps = ['main']