# -*- coding: utf-8 -*-

import datetime

from south.db import db

from south.v2 import SchemaMigration

from django.db import models

class Migration(SchemaMigration):

    def forwards(self, orm):

        # Adding model 'Thesaurus'

        db.create_table(u'core_thesaurus', (

            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),

            ('label', self.gf('django.db.models.fields.CharField')(unique=True, max_length=128, db_index=True)),

            ('title', self.gf('django.db.models.fields.CharField')(max_length=1024)),

            ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('uri', self.gf('django.db.models.fields.URLField')(db_index=True, max_length=2048, null=True, blank=True)),

        ))

        db.send_create_signal('core', ['Thesaurus'])

        # Adding model 'Term'

        db.create_table(u'core_term', (

            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),

            ('label', self.gf('django.db.models.fields.CharField')(max_length=1024, db_index=True)),

            ('lang', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=128, null=True, blank=True)),

            ('uri', self.gf('django.db.models.fields.URLField')(db_index=True, max_length=2048, null=True, blank=True)),

            ('normalized_label', self.gf('django.db.models.fields.CharField')(max_length=1024, db_index=True)),

            ('wp_label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=1024, null=True, blank=True)),

            ('wp_alternative_label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=1024, null=True, blank=True)),

            ('thesaurus', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['core.Thesaurus'])),

            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),

            ('wikipedia_url', self.gf('django.db.models.fields.URLField')(db_index=True, max_length=2048, null=True, blank=True)),

            ('wikipedia_pageid', self.gf('django.db.models.fields.BigIntegerField')(db_index=True, null=True, blank=True)),

            ('wikipedia_revision_id', self.gf('django.db.models.fields.BigIntegerField')(null=True, blank=True)),

            ('alternative_wikipedia_url', self.gf('django.db.models.fields.URLField')(db_index=True, max_length=2048, null=True, blank=True)),

            ('alternative_wikipedia_pageid', self.gf('django.db.models.fields.BigIntegerField')(db_index=True, null=True, blank=True)),

            ('url_status', self.gf('django.db.models.fields.IntegerField')(default=None, null=True, db_index=True, blank=True)),

            ('dbpedia_uri', self.gf('django.db.models.fields.URLField')(db_index=True, max_length=2048, null=True, blank=True)),

            ('validation_date', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),

            ('validated', self.gf('django.db.models.fields.BooleanField')(default=False, db_index=True)),

            ('validator', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['jocondelab.User'], null=True, blank=True)),

        ))

        db.send_create_signal('core', ['Term'])

        # Adding model 'TermLabel'

        db.create_table(u'core_termlabel', (

            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),

            ('label', self.gf('django.db.models.fields.CharField')(max_length=1024, db_index=True)),

            ('lang', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=128, null=True, blank=True)),

            ('term', self.gf('django.db.models.fields.related.ForeignKey')(related_name='alternative_labels', to=orm['core.Term'])),

        ))

        db.send_create_signal('core', ['TermLabel'])

        # Adding model 'Notice'

        db.create_table(u'core_notice', (

            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),

            ('ref', self.gf('django.db.models.fields.CharField')(max_length=20, unique=True, null=True, blank=True)),

            ('adpt', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('appl', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('aptn', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('attr', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('autr', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('bibl', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('comm', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('contact', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('coor', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('copy', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('dacq', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('data', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('dation', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('ddpt', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('decv', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('deno', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('depo', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('desc', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('desy', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('dims', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),

            ('dmaj', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),

            ('dmis', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),

            ('domn', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('drep', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('ecol', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('epoq', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('etat', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('expo', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('gene', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('geohi', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('hist', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('image', self.gf('django.db.models.fields.BooleanField')(default=False)),

            ('insc', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('inv', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),

            ('label', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('labo', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('lieux', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('loca', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('loca2', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('mill', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('milu', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('mosa', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('msgcom', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('museo', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('nsda', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('onom', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('paut', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('pdat', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('pdec', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('peoc', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('peri', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

            ('peru', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('phot', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('pins', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('plieux', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('prep', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('puti', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('reda', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('refim', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),

            ('repr', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('srep', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('stat', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('tech', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),

            ('tico', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('titr', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),

            ('util', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)),

            ('video', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),

            ('www', self.gf('django.db.models.fields.CharField')(max_length=512, null=True, blank=True)),

        ))

        db.send_create_signal('core', ['Notice'])

        # Adding model 'NoticeImage'

        db.create_table(u'core_noticeimage', (

            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),

            ('relative_url', self.gf('django.db.models.fields.URLField')(unique=True, max_length='1024')),

            ('notice', self.gf('django.db.models.fields.related.ForeignKey')(related_name='images', to=orm['core.Notice'])),

        ))

        db.send_create_signal('core', ['NoticeImage'])

        # Adding model 'NoticeTerm'

        db.create_table(u'core_noticeterm', (

            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),

            ('notice', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['core.Notice'])),

            ('term', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['core.Term'])),

            ('graph', self.gf('django.db.models.fields.URLField')(max_length=2048, null=True, blank=True)),

        ))

        db.send_create_signal('core', ['NoticeTerm'])

        # Adding model 'AutrNoticeTerm'

        db.create_table(u'core_autrnoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['AutrNoticeTerm'])

        # Adding model 'DomnNoticeTerm'

        db.create_table(u'core_domnnoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['DomnNoticeTerm'])

        # Adding model 'EcolNoticeTerm'

        db.create_table(u'core_ecolnoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['EcolNoticeTerm'])

        # Adding model 'EpoqNoticeTerm'

        db.create_table(u'core_epoqnoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['EpoqNoticeTerm'])

        # Adding model 'LieuxNoticeTerm'

        db.create_table(u'core_lieuxnoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['LieuxNoticeTerm'])

        # Adding model 'PeriNoticeTerm'

        db.create_table(u'core_perinoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['PeriNoticeTerm'])

        # Adding model 'ReprNoticeTerm'

        db.create_table(u'core_reprnoticeterm', (

            (u'noticeterm_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['core.NoticeTerm'], unique=True, primary_key=True)),

        ))

        db.send_create_signal('core', ['ReprNoticeTerm'])

    def backwards(self, orm):

        # Deleting model 'Thesaurus'

        db.delete_table(u'core_thesaurus')

        # Deleting model 'Term'

        db.delete_table(u'core_term')

        # Deleting model 'TermLabel'

        db.delete_table(u'core_termlabel')

        # Deleting model 'Notice'

        db.delete_table(u'core_notice')

        # Deleting model 'NoticeImage'

        db.delete_table(u'core_noticeimage')

        # Deleting model 'NoticeTerm'

        db.delete_table(u'core_noticeterm')

        # Deleting model 'AutrNoticeTerm'

        db.delete_table(u'core_autrnoticeterm')

        # Deleting model 'DomnNoticeTerm'

        db.delete_table(u'core_domnnoticeterm')

        # Deleting model 'EcolNoticeTerm'

        db.delete_table(u'core_ecolnoticeterm')

        # Deleting model 'EpoqNoticeTerm'

        db.delete_table(u'core_epoqnoticeterm')

        # Deleting model 'LieuxNoticeTerm'

        db.delete_table(u'core_lieuxnoticeterm')

        # Deleting model 'PeriNoticeTerm'

        db.delete_table(u'core_perinoticeterm')

        # Deleting model 'ReprNoticeTerm'

        db.delete_table(u'core_reprnoticeterm')

    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'})

        },

        'core.autrnoticeterm': {

            'Meta': {'object_name': 'AutrNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.domnnoticeterm': {

            'Meta': {'object_name': 'DomnNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.ecolnoticeterm': {

            'Meta': {'object_name': 'EcolNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.epoqnoticeterm': {

            'Meta': {'object_name': 'EpoqNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.lieuxnoticeterm': {

            'Meta': {'object_name': 'LieuxNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.notice': {

            'Meta': {'object_name': 'Notice'},

            'adpt': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'appl': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'aptn': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'attr': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'autr': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'autr_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'autr+'", 'symmetrical': 'False', 'through': "orm['core.AutrNoticeTerm']", 'to': "orm['core.Term']"}),

            'bibl': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'comm': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'contact': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'coor': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'copy': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'dacq': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'data': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'dation': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'ddpt': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'decv': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'deno': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'depo': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'desc': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'desy': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'dims': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'dmaj': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),

            'dmis': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),

            'domn': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'domn_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'domn+'", 'symmetrical': 'False', 'through': "orm['core.DomnNoticeTerm']", 'to': "orm['core.Term']"}),

            'drep': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'ecol': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),