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

#

# Copyright IRI (c) 2013

#

# contact@iri.centrepompidou.fr

#

# This software is governed by the CeCILL-B license under French law and

# abiding by the rules of distribution of free software.  You can  use, 

# modify and/ or redistribute the software under the terms of the CeCILL-B

# license as circulated by CEA, CNRS and INRIA at the following URL

# "http://www.cecill.info". 

#

# As a counterpart to the access to the source code and  rights to copy,

# modify and redistribute granted by the license, users are provided only

# with a limited warranty  and the software's author,  the holder of the

# economic rights,  and the successive licensors  have only  limited

# liability. 

#

# In this respect, the user's attention is drawn to the risks associated

# with loading,  using,  modifying and/or developing or reproducing the

# software by the user in light of its specific status of free software,

# that may mean  that it is complicated to manipulate,  and  that  also

# therefore means  that it is reserved for developers  and  experienced

# professionals having in-depth computer knowledge. Users are therefore

# encouraged to load and test the software's suitability as regards their

# requirements in conditions enabling the security of their systems and/or 

# data to be ensured and,  more generally, to use and operate it in the 

# same conditions as regards security. 

#

# The fact that you are presently reading this means that you have had

# knowledge of the CeCILL-B license and that you accept its terms.

#

import datetime

from django.db import models

from south.db import db

from south.v2 import SchemaMigration

class Migration(SchemaMigration):

    def forwards(self, orm):

        # Adding model 'User'

        db.create_table(u'p4l_user', (

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

            ('password', self.gf('django.db.models.fields.CharField')(max_length=128)),

            ('last_login', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),

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

            ('username', self.gf('django.db.models.fields.CharField')(unique=True, max_length=30)),

            ('first_name', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),

            ('last_name', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),

            ('email', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)),

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

            ('is_active', self.gf('django.db.models.fields.BooleanField')(default=True)),

            ('date_joined', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),

            ('language', self.gf('django.db.models.fields.CharField')(default='en', max_length=2)),

        ))

        db.send_create_signal('p4l', ['User'])

        # Adding M2M table for field groups on 'User'

        db.create_table(u'p4l_user_groups', (

            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),

            ('user', models.ForeignKey(orm['p4l.user'], null=False)),

            ('group', models.ForeignKey(orm[u'auth.group'], null=False))

        ))

        db.create_unique(u'p4l_user_groups', ['user_id', 'group_id'])

        # Adding M2M table for field user_permissions on 'User'

        db.create_table(u'p4l_user_user_permissions', (

            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),

            ('user', models.ForeignKey(orm['p4l.user'], null=False)),

            ('permission', models.ForeignKey(orm[u'auth.permission'], null=False))

        ))

        db.create_unique(u'p4l_user_user_permissions', ['user_id', 'permission_id'])

        # Adding model 'Imprint'

        db.create_table(u'p4l_imprint', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='imprints', to=orm['p4l.Record'])),

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

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

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

        ))

        db.send_create_signal('p4l', ['Imprint'])

        # Adding model 'Serie'

        db.create_table(u'p4l_serie', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='series', to=orm['p4l.Record'])),

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

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

        ))

        db.send_create_signal('p4l', ['Serie'])

        # Adding model 'ProjectName'

        db.create_table(u'p4l_projectname', (

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

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

        ))

        db.send_create_signal('p4l', ['ProjectName'])

        # Adding model 'CorporateAuthor'

        db.create_table(u'p4l_corporateauthor', (

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

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

        ))

        db.send_create_signal('p4l', ['CorporateAuthor'])

        # Adding model 'Url'

        db.create_table(u'p4l_url', (

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='urls', to=orm['p4l.Record'])),

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

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

        ))

        db.send_create_signal('p4l', ['Url'])

        # Adding model 'Subject'

        db.create_table(u'p4l_subject', (

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

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

        ))

        db.send_create_signal('p4l', ['Subject'])

        # Adding model 'Theme'

        db.create_table(u'p4l_theme', (

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

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

        ))

        db.send_create_signal('p4l', ['Theme'])

        # Adding model 'Country'

        db.create_table(u'p4l_country', (

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

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

        ))

        db.send_create_signal('p4l', ['Country'])

        # Adding model 'Audience'

        db.create_table(u'p4l_audience', (

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

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

        ))

        db.send_create_signal('p4l', ['Audience'])

        # Adding model 'Isbn'

        db.create_table(u'p4l_isbn', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='isbns', to=orm['p4l.Record'])),

            ('isbn', self.gf('django.db.models.fields.CharField')(max_length=128)),

        ))

        db.send_create_signal('p4l', ['Isbn'])

        # Adding model 'Issn'

        db.create_table(u'p4l_issn', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='issns', to=orm['p4l.Record'])),

            ('issn', self.gf('django.db.models.fields.CharField')(max_length=128)),

        ))

        db.send_create_signal('p4l', ['Issn'])

        # Adding model 'DocumentCode'

        db.create_table(u'p4l_documentcode', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='documentCodes', to=orm['p4l.Record'])),

            ('documentCode', self.gf('django.db.models.fields.CharField')(max_length=128)),

        ))

        db.send_create_signal('p4l', ['DocumentCode'])

        # Adding model 'Language'

        db.create_table(u'p4l_language', (

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

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

        ))

        db.send_create_signal('p4l', ['Language'])

        # Adding model 'Title'

        db.create_table(u'p4l_title', (

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

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='titles', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['Title'])

        # Adding model 'AddedTitle'

        db.create_table(u'p4l_addedtitle', (

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

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='addedTitles', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['AddedTitle'])

        # Adding model 'TitleMainDocument'

        db.create_table(u'p4l_titlemaindocument', (

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

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='titlesMainDocument', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['TitleMainDocument'])

        # Adding model 'Abstract'

        db.create_table(u'p4l_abstract', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='abstracts', to=orm['p4l.Record'])),

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

        ))

        db.send_create_signal('p4l', ['Abstract'])

        # Adding model 'Collation'

        db.create_table(u'p4l_collation', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='collations', to=orm['p4l.Record'])),

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

        ))

        db.send_create_signal('p4l', ['Collation'])

        # Adding model 'VolumeIssue'

        db.create_table(u'p4l_volumeissue', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='volumeIssues', to=orm['p4l.Record'])),

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

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

        ))

        db.send_create_signal('p4l', ['VolumeIssue'])

        # Adding model 'Author'

        db.create_table(u'p4l_author', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='authors', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['Author'])

        # Adding model 'SubjectPerson'

        db.create_table(u'p4l_subjectperson', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='subjectPersons', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['SubjectPerson'])

        # Adding model 'Periodical'

        db.create_table(u'p4l_periodical', (

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='periodicals', to=orm['p4l.Record'])),

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

        ))

        db.send_create_signal('p4l', ['Periodical'])

        # Adding model 'Meeting'

        db.create_table(u'p4l_meeting', (

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

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

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

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

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

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='meetings', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['Meeting'])

        # Adding model 'SubjectMeeting'

        db.create_table(u'p4l_subjectmeeting', (

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

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

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

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

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

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

            ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='subjectMeetings', to=orm['p4l.Record'])),

        ))

        db.send_create_signal('p4l', ['SubjectMeeting'])

        # Adding model 'Record'

        db.create_table(u'p4l_record', (

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

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

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

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

            ('language', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['p4l.Language'], null=True, blank=True)),

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

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

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

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

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

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

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

            ('modification_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),

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

        ))

        db.send_create_signal('p4l', ['Record'])

        # Adding M2M table for field subjects on 'Record'

        db.create_table(u'p4l_record_subjects', (

            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),

            ('record', models.ForeignKey(orm['p4l.record'], null=False)),

            ('subject', models.ForeignKey(orm['p4l.subject'], null=False))

        ))

        db.create_unique(u'p4l_record_subjects', ['record_id', 'subject_id'])

        # Adding M2M table for field themes on 'Record'

        db.create_table(u'p4l_record_themes', (

            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),

            ('record', models.ForeignKey(orm['p4l.record'], null=False)),

            ('theme', models.ForeignKey(orm['p4l.theme'], null=False))