diff options
Diffstat (limited to 'archaeological_operations/migrations/0001_initial.py')
| -rw-r--r-- | archaeological_operations/migrations/0001_initial.py | 719 | 
1 files changed, 562 insertions, 157 deletions
| diff --git a/archaeological_operations/migrations/0001_initial.py b/archaeological_operations/migrations/0001_initial.py index 2039268aa..6e4b66ce6 100644 --- a/archaeological_operations/migrations/0001_initial.py +++ b/archaeological_operations/migrations/0001_initial.py @@ -8,23 +8,13 @@ from django.db import models  class Migration(SchemaMigration):      def forwards(self, orm): -        # Adding model 'OperationType' -        db.create_table('archaeological_operations_operationtype', ( -            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), -            ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), -            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=30)), -            ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), -            ('available', self.gf('django.db.models.fields.BooleanField')(default=False)), -        )) -        db.send_create_signal('archaeological_operations', ['OperationType']) -          # Adding model 'RemainType'          db.create_table('archaeological_operations_remaintype', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),              ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), -            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=30)), +            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)),              ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), -            ('available', self.gf('django.db.models.fields.BooleanField')(default=False)), +            ('available', self.gf('django.db.models.fields.BooleanField')(default=True)),          ))          db.send_create_signal('archaeological_operations', ['RemainType']) @@ -32,9 +22,9 @@ class Migration(SchemaMigration):          db.create_table('archaeological_operations_period', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),              ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), -            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=30)), +            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)),              ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), -            ('available', self.gf('django.db.models.fields.BooleanField')(default=False)), +            ('available', self.gf('django.db.models.fields.BooleanField')(default=True)),              ('order', self.gf('django.db.models.fields.IntegerField')()),              ('start_date', self.gf('django.db.models.fields.IntegerField')()),              ('end_date', self.gf('django.db.models.fields.IntegerField')()), @@ -42,16 +32,66 @@ class Migration(SchemaMigration):          ))          db.send_create_signal('archaeological_operations', ['Period']) +        # Adding model 'ReportState' +        db.create_table('archaeological_operations_reportstate', ( +            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), +            ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), +            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)), +            ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('available', self.gf('django.db.models.fields.BooleanField')(default=True)), +            ('order', self.gf('django.db.models.fields.IntegerField')()), +        )) +        db.send_create_signal('archaeological_operations', ['ReportState']) + +        # Adding model 'ArchaeologicalSite' +        db.create_table('archaeological_operations_archaeologicalsite', ( +            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), +            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('history_creator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('reference', self.gf('django.db.models.fields.CharField')(unique=True, max_length=20)), +            ('name', self.gf('django.db.models.fields.CharField')(max_length=200, null=True, blank=True)), +        )) +        db.send_create_signal('archaeological_operations', ['ArchaeologicalSite']) + +        # Adding M2M table for field imports on 'ArchaeologicalSite' +        db.create_table('archaeological_operations_archaeologicalsite_imports', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('archaeologicalsite', models.ForeignKey(orm['archaeological_operations.archaeologicalsite'], null=False)), +            ('import', models.ForeignKey(orm['ishtar_common.import'], null=False)) +        )) +        db.create_unique('archaeological_operations_archaeologicalsite_imports', ['archaeologicalsite_id', 'import_id']) + +        # Adding M2M table for field periods on 'ArchaeologicalSite' +        db.create_table('archaeological_operations_archaeologicalsite_periods', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('archaeologicalsite', models.ForeignKey(orm['archaeological_operations.archaeologicalsite'], null=False)), +            ('period', models.ForeignKey(orm['archaeological_operations.period'], null=False)) +        )) +        db.create_unique('archaeological_operations_archaeologicalsite_periods', ['archaeologicalsite_id', 'period_id']) + +        # Adding M2M table for field remains on 'ArchaeologicalSite' +        db.create_table('archaeological_operations_archaeologicalsite_remains', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('archaeologicalsite', models.ForeignKey(orm['archaeological_operations.archaeologicalsite'], null=False)), +            ('remaintype', models.ForeignKey(orm['archaeological_operations.remaintype'], null=False)) +        )) +        db.create_unique('archaeological_operations_archaeologicalsite_remains', ['archaeologicalsite_id', 'remaintype_id']) +          # Adding model 'HistoricalOperation'          db.create_table('archaeological_operations_historicaloperation', (              ('id', self.gf('django.db.models.fields.IntegerField')(db_index=True, blank=True)),              ('history_modifier_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('history_creator_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('creation_date', self.gf('django.db.models.fields.DateField')(default=datetime.date.today)), +            ('end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),              ('start_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),              ('excavation_end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), -            ('end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('report_delivery_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('scientist_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('operator_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('in_charge_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), -            ('year', self.gf('django.db.models.fields.IntegerField')()), -            ('operation_code', self.gf('django.db.models.fields.IntegerField')()), +            ('year', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('operation_code', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('associated_file_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('operation_type_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('surface', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), @@ -59,16 +99,24 @@ class Migration(SchemaMigration):              ('scheduled_man_days', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('optional_man_days', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('effective_man_days', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), -            ('code_patriarche', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('report_processing_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('code_patriarche', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('code_dracar', self.gf('django.db.models.fields.CharField')(max_length=10, null=True, blank=True)),              ('fnap_financing', self.gf('django.db.models.fields.FloatField')(null=True, blank=True)),              ('fnap_cost', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('zoning_prescription', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),              ('large_area_prescription', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),              ('geoarchaeological_context_prescription', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)), +            ('cira_rapporteur_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('negative_result', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)), +            ('cira_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('eas_number', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)),              ('operator_reference', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)), -            ('common_name', self.gf('django.db.models.fields.CharField')(max_length=120, null=True, blank=True)), +            ('common_name', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),              ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('cached_label', self.gf('django.db.models.fields.CharField')(max_length=500, null=True, blank=True)), +            ('virtual_operation', self.gf('django.db.models.fields.BooleanField')(default=False)), +            ('record_quality', self.gf('django.db.models.fields.CharField')(max_length=2, null=True, blank=True)),              ('history_id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),              ('history_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),              ('history_user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True)), @@ -79,33 +127,54 @@ class Migration(SchemaMigration):          # Adding model 'Operation'          db.create_table('archaeological_operations_operation', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), -            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['auth.User'])), +            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('history_creator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('creation_date', self.gf('django.db.models.fields.DateField')(default=datetime.date.today)), +            ('end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),              ('start_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),              ('excavation_end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), -            ('end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), -            ('in_charge', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, to=orm['ishtar_common.Person'])), -            ('year', self.gf('django.db.models.fields.IntegerField')()), -            ('operation_code', self.gf('django.db.models.fields.IntegerField')()), +            ('report_delivery_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('scientist', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='operation_scientist_responsability', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Person'])), +            ('operator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='operator', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Organization'])), +            ('in_charge', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='operation_responsability', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Person'])), +            ('year', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('operation_code', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('associated_file', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='operations', null=True, to=orm['archaeological_files.File'])), -            ('operation_type', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['archaeological_operations.OperationType'])), +            ('operation_type', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['ishtar_common.OperationType'])),              ('surface', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('cost', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('scheduled_man_days', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('optional_man_days', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('effective_man_days', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), -            ('code_patriarche', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('report_processing', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['archaeological_operations.ReportState'], null=True, blank=True)), +            ('code_patriarche', self.gf('django.db.models.fields.IntegerField')(unique=True, null=True, blank=True)),              ('code_dracar', self.gf('django.db.models.fields.CharField')(max_length=10, null=True, blank=True)),              ('fnap_financing', self.gf('django.db.models.fields.FloatField')(null=True, blank=True)),              ('fnap_cost', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('zoning_prescription', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),              ('large_area_prescription', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),              ('geoarchaeological_context_prescription', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)), +            ('cira_rapporteur', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='cira_rapporteur', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Person'])), +            ('negative_result', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)), +            ('cira_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('eas_number', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)),              ('operator_reference', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)), -            ('common_name', self.gf('django.db.models.fields.CharField')(max_length=120, null=True, blank=True)), +            ('common_name', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),              ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('cached_label', self.gf('django.db.models.fields.CharField')(max_length=500, null=True, blank=True)), +            ('virtual_operation', self.gf('django.db.models.fields.BooleanField')(default=False)), +            ('record_quality', self.gf('django.db.models.fields.CharField')(max_length=2, null=True, blank=True)),          ))          db.send_create_signal('archaeological_operations', ['Operation']) +        # Adding M2M table for field imports on 'Operation' +        db.create_table('archaeological_operations_operation_imports', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('operation', models.ForeignKey(orm['archaeological_operations.operation'], null=False)), +            ('import', models.ForeignKey(orm['ishtar_common.import'], null=False)) +        )) +        db.create_unique('archaeological_operations_operation_imports', ['operation_id', 'import_id']) +          # Adding M2M table for field remains on 'Operation'          db.create_table('archaeological_operations_operation_remains', (              ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), @@ -130,16 +199,58 @@ class Migration(SchemaMigration):          ))          db.create_unique('archaeological_operations_operation_periods', ['operation_id', 'period_id']) +        # Adding M2M table for field archaeological_sites on 'Operation' +        db.create_table('archaeological_operations_operation_archaeological_sites', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('operation', models.ForeignKey(orm['archaeological_operations.operation'], null=False)), +            ('archaeologicalsite', models.ForeignKey(orm['archaeological_operations.archaeologicalsite'], null=False)) +        )) +        db.create_unique('archaeological_operations_operation_archaeological_sites', ['operation_id', 'archaeologicalsite_id']) + +        # Adding model 'RelationType' +        db.create_table('archaeological_operations_relationtype', ( +            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), +            ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), +            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)), +            ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('available', self.gf('django.db.models.fields.BooleanField')(default=True)), +            ('order', self.gf('django.db.models.fields.IntegerField')(default=1)), +            ('symmetrical', self.gf('django.db.models.fields.BooleanField')(default=False)), +            ('inverse_relation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['archaeological_operations.RelationType'], null=True, blank=True)), +        )) +        db.send_create_signal('archaeological_operations', ['RelationType']) + +        # Adding model 'RecordRelations' +        db.create_table('archaeological_operations_recordrelations', ( +            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), +            ('left_record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='right_relations', to=orm['archaeological_operations.Operation'])), +            ('right_record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='left_relations', to=orm['archaeological_operations.Operation'])), +            ('relation_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['archaeological_operations.RelationType'])), +        )) +        db.send_create_signal('archaeological_operations', ['RecordRelations']) +          # Adding model 'OperationSource'          db.create_table('archaeological_operations_operationsource', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), -            ('title', self.gf('django.db.models.fields.CharField')(max_length=200)), +            ('title', self.gf('django.db.models.fields.CharField')(max_length=300)), +            ('external_id', self.gf('django.db.models.fields.CharField')(max_length=12, null=True, blank=True)),              ('source_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ishtar_common.SourceType'])), +            ('support_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ishtar_common.SupportType'], null=True, blank=True)), +            ('format_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ishtar_common.Format'], null=True, blank=True)), +            ('scale', self.gf('django.db.models.fields.CharField')(max_length=30, null=True, blank=True)),              ('associated_url', self.gf('django.db.models.fields.URLField')(max_length=200, null=True, blank=True)),              ('receipt_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),              ('creation_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('receipt_date_in_documentation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), +            ('item_number', self.gf('django.db.models.fields.IntegerField')(default=1)), +            ('reference', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), +            ('internal_reference', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), +            ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('additional_information', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('duplicate', self.gf('django.db.models.fields.BooleanField')(default=False)),              ('operation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='source', to=orm['archaeological_operations.Operation'])), -            ('index', self.gf('django.db.models.fields.IntegerField')()), +            ('index', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),          ))          db.send_create_signal('archaeological_operations', ['OperationSource']) @@ -155,27 +266,42 @@ class Migration(SchemaMigration):          db.create_table('archaeological_operations_acttype', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),              ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), -            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=30)), +            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)),              ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), -            ('available', self.gf('django.db.models.fields.BooleanField')(default=False)), +            ('available', self.gf('django.db.models.fields.BooleanField')(default=True)),              ('intented_to', self.gf('django.db.models.fields.CharField')(max_length=1)), +            ('code', self.gf('django.db.models.fields.CharField')(max_length=10, null=True, blank=True)), +            ('indexed', self.gf('django.db.models.fields.BooleanField')(default=False)),          ))          db.send_create_signal('archaeological_operations', ['ActType']) +        # Adding M2M table for field associated_template on 'ActType' +        db.create_table('archaeological_operations_acttype_associated_template', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('acttype', models.ForeignKey(orm['archaeological_operations.acttype'], null=False)), +            ('documenttemplate', models.ForeignKey(orm['ishtar_common.documenttemplate'], null=False)) +        )) +        db.create_unique('archaeological_operations_acttype_associated_template', ['acttype_id', 'documenttemplate_id']) +          # Adding model 'HistoricalAdministrativeAct'          db.create_table('archaeological_operations_historicaladministrativeact', (              ('id', self.gf('django.db.models.fields.IntegerField')(db_index=True, blank=True)),              ('history_modifier_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('history_creator_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('act_type_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('in_charge_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('index', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('operator_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), -            ('scientific_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)), +            ('scientist_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('signatory_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('operation_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('associated_file_id', self.gf('django.db.models.fields.IntegerField')(db_index=True, null=True, blank=True)),              ('signature_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), -            ('act_object', self.gf('django.db.models.fields.CharField')(max_length=200)), -            ('ref_sra', self.gf('django.db.models.fields.CharField')(max_length=15)), +            ('year', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('act_object', self.gf('django.db.models.fields.TextField')(max_length=300, null=True, blank=True)), +            ('ref_sra', self.gf('django.db.models.fields.CharField')(max_length=15, null=True, blank=True)), +            ('departments_label', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('towns_label', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),              ('history_id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),              ('history_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),              ('history_user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True)), @@ -186,63 +312,123 @@ class Migration(SchemaMigration):          # Adding model 'AdministrativeAct'          db.create_table('archaeological_operations_administrativeact', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), -            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['auth.User'])), +            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('history_creator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])),              ('act_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['archaeological_operations.ActType'])), -            ('in_charge', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, to=orm['ishtar_common.Person'])), -            ('operator', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ishtar_common.Organization'], null=True, blank=True)), -            ('scientific', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, to=orm['ishtar_common.Person'])), -            ('signatory', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, to=orm['ishtar_common.Person'])), +            ('in_charge', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='adminact_operation_in_charge', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Person'])), +            ('index', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('operator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='adminact_operator', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Organization'])), +            ('scientist', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='adminact_scientist', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Person'])), +            ('signatory', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='signatory', null=True, on_delete=models.SET_NULL, to=orm['ishtar_common.Person'])),              ('operation', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='administrative_act', null=True, to=orm['archaeological_operations.Operation'])),              ('associated_file', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='administrative_act', null=True, to=orm['archaeological_files.File'])),              ('signature_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), -            ('act_object', self.gf('django.db.models.fields.CharField')(max_length=200)), -            ('ref_sra', self.gf('django.db.models.fields.CharField')(max_length=15)), +            ('year', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), +            ('act_object', self.gf('django.db.models.fields.TextField')(max_length=300, null=True, blank=True)), +            ('ref_sra', self.gf('django.db.models.fields.CharField')(max_length=15, null=True, blank=True)), +            ('departments_label', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('towns_label', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),          ))          db.send_create_signal('archaeological_operations', ['AdministrativeAct']) +        # Adding M2M table for field imports on 'AdministrativeAct' +        db.create_table('archaeological_operations_administrativeact_imports', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('administrativeact', models.ForeignKey(orm['archaeological_operations.administrativeact'], null=False)), +            ('import', models.ForeignKey(orm['ishtar_common.import'], null=False)) +        )) +        db.create_unique('archaeological_operations_administrativeact_imports', ['administrativeact_id', 'import_id']) +          # Adding model 'Parcel'          db.create_table('archaeological_operations_parcel', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), -            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['auth.User'])), +            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('history_creator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])),              ('history_date', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),              ('associated_file', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='parcels', null=True, to=orm['archaeological_files.File'])),              ('operation', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='parcels', null=True, to=orm['archaeological_operations.Operation'])),              ('year', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),              ('town', self.gf('django.db.models.fields.related.ForeignKey')(related_name='parcels', to=orm['ishtar_common.Town'])),              ('section', self.gf('django.db.models.fields.CharField')(max_length=4)), -            ('parcel_number', self.gf('django.db.models.fields.CharField')(max_length=6)), +            ('parcel_number', self.gf('django.db.models.fields.CharField')(max_length=6, null=True, blank=True)), +            ('external_id', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), +            ('address', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),          ))          db.send_create_signal('archaeological_operations', ['Parcel']) +        # Adding M2M table for field imports on 'Parcel' +        db.create_table('archaeological_operations_parcel_imports', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('parcel', models.ForeignKey(orm['archaeological_operations.parcel'], null=False)), +            ('import', models.ForeignKey(orm['ishtar_common.import'], null=False)) +        )) +        db.create_unique('archaeological_operations_parcel_imports', ['parcel_id', 'import_id']) +          # Adding model 'ParcelOwner'          db.create_table('archaeological_operations_parcelowner', (              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), -            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['auth.User'])), +            ('history_modifier', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])), +            ('history_creator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='+', null=True, on_delete=models.SET_NULL, to=orm['auth.User'])),              ('history_date', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), -            ('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ishtar_common.Person'])), -            ('parcel', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['archaeological_operations.Parcel'])), +            ('owner', self.gf('django.db.models.fields.related.ForeignKey')(related_name='parcel_owner', to=orm['ishtar_common.Person'])), +            ('parcel', self.gf('django.db.models.fields.related.ForeignKey')(related_name='owners', to=orm['archaeological_operations.Parcel'])),              ('start_date', self.gf('django.db.models.fields.DateField')()),              ('end_date', self.gf('django.db.models.fields.DateField')()),          ))          db.send_create_signal('archaeological_operations', ['ParcelOwner']) +        # Adding M2M table for field imports on 'ParcelOwner' +        db.create_table('archaeological_operations_parcelowner_imports', ( +            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), +            ('parcelowner', models.ForeignKey(orm['archaeological_operations.parcelowner'], null=False)), +            ('import', models.ForeignKey(orm['ishtar_common.import'], null=False)) +        )) +        db.create_unique('archaeological_operations_parcelowner_imports', ['parcelowner_id', 'import_id']) + +        # Adding model 'OperationTypeOld' +        db.create_table('archaeological_operations_operationtypeold', ( +            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), +            ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), +            ('txt_idx', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)), +            ('comment', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), +            ('available', self.gf('django.db.models.fields.BooleanField')(default=True)), +            ('order', self.gf('django.db.models.fields.IntegerField')(default=1)), +            ('preventive', self.gf('django.db.models.fields.BooleanField')(default=True)), +        )) +        db.send_create_signal('archaeological_operations', ['OperationTypeOld']) -    def backwards(self, orm): -        # Deleting model 'OperationType' -        db.delete_table('archaeological_operations_operationtype') +    def backwards(self, orm):          # Deleting model 'RemainType'          db.delete_table('archaeological_operations_remaintype')          # Deleting model 'Period'          db.delete_table('archaeological_operations_period') +        # Deleting model 'ReportState' +        db.delete_table('archaeological_operations_reportstate') + +        # Deleting model 'ArchaeologicalSite' +        db.delete_table('archaeological_operations_archaeologicalsite') + +        # Removing M2M table for field imports on 'ArchaeologicalSite' +        db.delete_table('archaeological_operations_archaeologicalsite_imports') + +        # Removing M2M table for field periods on 'ArchaeologicalSite' +        db.delete_table('archaeological_operations_archaeologicalsite_periods') + +        # Removing M2M table for field remains on 'ArchaeologicalSite' +        db.delete_table('archaeological_operations_archaeologicalsite_remains') +          # Deleting model 'HistoricalOperation'          db.delete_table('archaeological_operations_historicaloperation')          # Deleting model 'Operation'          db.delete_table('archaeological_operations_operation') +        # Removing M2M table for field imports on 'Operation' +        db.delete_table('archaeological_operations_operation_imports') +          # Removing M2M table for field remains on 'Operation'          db.delete_table('archaeological_operations_operation_remains') @@ -252,6 +438,15 @@ class Migration(SchemaMigration):          # Removing M2M table for field periods on 'Operation'          db.delete_table('archaeological_operations_operation_periods') +        # Removing M2M table for field archaeological_sites on 'Operation' +        db.delete_table('archaeological_operations_operation_archaeological_sites') + +        # Deleting model 'RelationType' +        db.delete_table('archaeological_operations_relationtype') + +        # Deleting model 'RecordRelations' +        db.delete_table('archaeological_operations_recordrelations') +          # Deleting model 'OperationSource'          db.delete_table('archaeological_operations_operationsource') @@ -261,101 +456,159 @@ class Migration(SchemaMigration):          # Deleting model 'ActType'          db.delete_table('archaeological_operations_acttype') +        # Removing M2M table for field associated_template on 'ActType' +        db.delete_table('archaeological_operations_acttype_associated_template') +          # Deleting model 'HistoricalAdministrativeAct'          db.delete_table('archaeological_operations_historicaladministrativeact')          # Deleting model 'AdministrativeAct'          db.delete_table('archaeological_operations_administrativeact') +        # Removing M2M table for field imports on 'AdministrativeAct' +        db.delete_table('archaeological_operations_administrativeact_imports') +          # Deleting model 'Parcel'          db.delete_table('archaeological_operations_parcel') +        # Removing M2M table for field imports on 'Parcel' +        db.delete_table('archaeological_operations_parcel_imports') +          # Deleting model 'ParcelOwner'          db.delete_table('archaeological_operations_parcelowner') +        # Removing M2M table for field imports on 'ParcelOwner' +        db.delete_table('archaeological_operations_parcelowner_imports') + +        # Deleting model 'OperationTypeOld' +        db.delete_table('archaeological_operations_operationtypeold') +      models = {          'archaeological_files.file': { -            'Meta': {'ordering': "['-year', '-numeric_reference']", 'object_name': 'File'}, +            'Meta': {'ordering': "('cached_label',)", 'object_name': 'File'},              'address': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), -            'address_complement': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'cached_label': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'cira_advised': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'classified_area': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), -            'creation_date': ('django.db.models.fields.DateField', [], {'default': 'datetime.date.today'}), +            'corporation_general_contractor': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'general_contractor_files'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Organization']"}), +            'creation_date': ('django.db.models.fields.DateField', [], {'default': 'datetime.date.today', 'null': 'True', 'blank': 'True'}), +            'departments': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['ishtar_common.Department']", 'null': 'True', 'blank': 'True'}),              'end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'external_id': ('django.db.models.fields.CharField', [], {'max_length': '120', 'null': 'True', 'blank': 'True'}),              'file_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_files.FileType']"}), -            'general_contractor': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'general_contractor': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'general_contractor_files'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'in_charge': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['ishtar_common.Person']"}), -            'internal_reference': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '60'}), -            'numeric_reference': ('django.db.models.fields.IntegerField', [], {}), -            'permit_reference': ('django.db.models.fields.CharField', [], {'max_length': '60', 'null': 'True', 'blank': 'True'}), +            'imported_line': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_archaeological_files_file'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'in_charge': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'file_responsability'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}), +            'instruction_deadline': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'internal_reference': ('django.db.models.fields.CharField', [], {'max_length': '60', 'null': 'True', 'blank': 'True'}), +            'locality': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'main_town': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'file_main'", 'null': 'True', 'to': "orm['ishtar_common.Town']"}), +            'mh_listing': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'mh_register': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'name': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'numeric_reference': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'organization': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'files'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Organization']"}), +            'permit_reference': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'permit_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_files.PermitType']", 'null': 'True', 'blank': 'True'}), +            'planning_service': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'planning_service_files'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Organization']"}),              'postal_code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}), +            'protected_area': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'raw_general_contractor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), +            'raw_town_planning_service': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}),              'reception_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), -            'reference_number': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'related_file': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_files.File']", 'null': 'True', 'blank': 'True'}), +            'requested_operation_type': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.OperationType']"}), +            'research_comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'responsible_town_planning_service': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'responsible_town_planning_service_files'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}),              'saisine_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_files.SaisineType']", 'null': 'True', 'blank': 'True'}), +            'scientist': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'scientist'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}),              'total_developed_surface': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'total_surface': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), -            'town_planning_service': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.Organization']"}),              'towns': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'file'", 'symmetrical': 'False', 'to': "orm['ishtar_common.Town']"}), -            'year': ('django.db.models.fields.IntegerField', [], {'default': '2012'}) +            'year': ('django.db.models.fields.IntegerField', [], {'default': '2016'})          },          'archaeological_files.filetype': { -            'Meta': {'object_name': 'FileType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'FileType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'archaeological_files.permittype': { -            'Meta': {'object_name': 'PermitType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'PermitType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'archaeological_files.saisinetype': { -            'Meta': {'object_name': 'SaisineType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'SaisineType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), -            'delay': ('django.db.models.fields.IntegerField', [], {}), +            'delay': ('django.db.models.fields.IntegerField', [], {'default': '30'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'archaeological_operations.acttype': { -            'Meta': {'object_name': 'ActType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'ActType'}, +            'associated_template': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'acttypes'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.DocumentTemplate']"}), +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'indexed': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),              'intented_to': ('django.db.models.fields.CharField', [], {'max_length': '1'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'archaeological_operations.administrativeact': { -            'Meta': {'object_name': 'AdministrativeAct'}, -            'act_object': ('django.db.models.fields.CharField', [], {'max_length': '200'}), +            'Meta': {'ordering': "('year', 'signature_date', 'index', 'act_type')", 'object_name': 'AdministrativeAct'}, +            'act_object': ('django.db.models.fields.TextField', [], {'max_length': '300', 'null': 'True', 'blank': 'True'}),              'act_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_operations.ActType']"}),              'associated_file': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'administrative_act'", 'null': 'True', 'to': "orm['archaeological_files.File']"}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'departments_label': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'in_charge': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_archaeological_operations_administrativeact'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'in_charge': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'adminact_operation_in_charge'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}), +            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'operation': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'administrative_act'", 'null': 'True', 'to': "orm['archaeological_operations.Operation']"}), -            'operator': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.Organization']", 'null': 'True', 'blank': 'True'}), -            'ref_sra': ('django.db.models.fields.CharField', [], {'max_length': '15'}), -            'scientific': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), -            'signatory': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), -            'signature_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}) +            'operator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'adminact_operator'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Organization']"}), +            'ref_sra': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True', 'blank': 'True'}), +            'scientist': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'adminact_scientist'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}), +            'signatory': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'signatory'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}), +            'signature_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'towns_label': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'year': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}) +        }, +        'archaeological_operations.archaeologicalsite': { +            'Meta': {'object_name': 'ArchaeologicalSite'}, +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_archaeological_operations_archaeologicalsite'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'name': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), +            'periods': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['archaeological_operations.Period']", 'null': 'True', 'blank': 'True'}), +            'reference': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '20'}), +            'remains': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['archaeological_operations.RemainType']", 'null': 'True', 'blank': 'True'})          },          'archaeological_operations.historicaladministrativeact': {              'Meta': {'ordering': "('-history_date', '-history_id')", 'object_name': 'HistoricalAdministrativeAct'}, -            'act_object': ('django.db.models.fields.CharField', [], {'max_length': '200'}), +            'act_object': ('django.db.models.fields.TextField', [], {'max_length': '300', 'null': 'True', 'blank': 'True'}),              'act_type_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'associated_file_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), +            'departments_label': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'history_creator_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'history_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),              'history_id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'history_modifier_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), @@ -363,27 +616,36 @@ class Migration(SchemaMigration):              'history_user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True'}),              'id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'blank': 'True'}),              'in_charge_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), +            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'operation_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'operator_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), -            'ref_sra': ('django.db.models.fields.CharField', [], {'max_length': '15'}), -            'scientific_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), +            'ref_sra': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True', 'blank': 'True'}), +            'scientist_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'signatory_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), -            'signature_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}) +            'signature_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'towns_label': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'year': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})          },          'archaeological_operations.historicaloperation': {              'Meta': {'ordering': "('-history_date', '-history_id')", 'object_name': 'HistoricalOperation'},              'associated_file_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), +            'cached_label': ('django.db.models.fields.CharField', [], {'max_length': '500', 'null': 'True', 'blank': 'True'}), +            'cira_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'cira_rapporteur_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'code_dracar': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}), -            'code_patriarche': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'code_patriarche': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), -            'common_name': ('django.db.models.fields.CharField', [], {'max_length': '120', 'null': 'True', 'blank': 'True'}), +            'common_name': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'cost': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'creation_date': ('django.db.models.fields.DateField', [], {'default': 'datetime.date.today'}), +            'eas_number': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),              'effective_man_days': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),              'excavation_end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),              'fnap_cost': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'fnap_financing': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),              'geoarchaeological_context_prescription': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'history_creator_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'history_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),              'history_id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'history_modifier_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), @@ -392,45 +654,67 @@ class Migration(SchemaMigration):              'id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'blank': 'True'}),              'in_charge_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'large_area_prescription': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), -            'operation_code': ('django.db.models.fields.IntegerField', [], {}), +            'negative_result': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'operation_code': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'operation_type_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}), +            'operator_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'operator_reference': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),              'optional_man_days': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'record_quality': ('django.db.models.fields.CharField', [], {'max_length': '2', 'null': 'True', 'blank': 'True'}), +            'report_delivery_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'report_processing_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'scheduled_man_days': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'scientist_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),              'start_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),              'surface': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), -            'year': ('django.db.models.fields.IntegerField', [], {}), +            'virtual_operation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'year': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'zoning_prescription': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'})          },          'archaeological_operations.operation': { -            'Meta': {'object_name': 'Operation'}, +            'Meta': {'ordering': "('cached_label',)", 'object_name': 'Operation'}, +            'archaeological_sites': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['archaeological_operations.ArchaeologicalSite']", 'null': 'True', 'blank': 'True'}),              'associated_file': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'operations'", 'null': 'True', 'to': "orm['archaeological_files.File']"}), +            'cached_label': ('django.db.models.fields.CharField', [], {'max_length': '500', 'null': 'True', 'blank': 'True'}), +            'cira_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'cira_rapporteur': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'cira_rapporteur'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}),              'code_dracar': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}), -            'code_patriarche': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'code_patriarche': ('django.db.models.fields.IntegerField', [], {'unique': 'True', 'null': 'True', 'blank': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), -            'common_name': ('django.db.models.fields.CharField', [], {'max_length': '120', 'null': 'True', 'blank': 'True'}), +            'common_name': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'cost': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'creation_date': ('django.db.models.fields.DateField', [], {'default': 'datetime.date.today'}), +            'eas_number': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),              'effective_man_days': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),              'excavation_end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),              'fnap_cost': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'fnap_financing': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),              'geoarchaeological_context_prescription': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'in_charge': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_archaeological_operations_operation'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'in_charge': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'operation_responsability'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}),              'large_area_prescription': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), -            'operation_code': ('django.db.models.fields.IntegerField', [], {}), -            'operation_type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['archaeological_operations.OperationType']"}), +            'negative_result': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), +            'operation_code': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'operation_type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['ishtar_common.OperationType']"}), +            'operator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'operator'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Organization']"}),              'operator_reference': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),              'optional_man_days': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), -            'periods': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['archaeological_operations.Period']", 'symmetrical': 'False'}), -            'remains': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['archaeological_operations.RemainType']", 'symmetrical': 'False'}), +            'periods': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['archaeological_operations.Period']", 'null': 'True', 'blank': 'True'}), +            'record_quality': ('django.db.models.fields.CharField', [], {'max_length': '2', 'null': 'True', 'blank': 'True'}), +            'remains': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['archaeological_operations.RemainType']", 'null': 'True', 'blank': 'True'}), +            'report_delivery_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'report_processing': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_operations.ReportState']", 'null': 'True', 'blank': 'True'}),              'scheduled_man_days': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'scientist': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'operation_scientist_responsability'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Person']"}),              'start_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),              'surface': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'towns': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['ishtar_common.Town']", 'symmetrical': 'False'}), -            'year': ('django.db.models.fields.IntegerField', [], {}), +            'virtual_operation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'year': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),              'zoning_prescription': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'})          },          'archaeological_operations.operationbydepartment': { @@ -441,32 +725,50 @@ class Migration(SchemaMigration):          },          'archaeological_operations.operationsource': {              'Meta': {'object_name': 'OperationSource'}, +            'additional_information': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'associated_url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), -            'authors': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['ishtar_common.Author']", 'symmetrical': 'False'}), +            'authors': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'operationsource_related'", 'symmetrical': 'False', 'to': "orm['ishtar_common.Author']"}), +            'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'creation_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'duplicate': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'external_id': ('django.db.models.fields.CharField', [], {'max_length': '12', 'null': 'True', 'blank': 'True'}), +            'format_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.Format']", 'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'index': ('django.db.models.fields.IntegerField', [], {}), +            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'internal_reference': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'item_number': ('django.db.models.fields.IntegerField', [], {'default': '1'}),              'operation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'source'", 'to': "orm['archaeological_operations.Operation']"}),              'receipt_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'receipt_date_in_documentation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), +            'reference': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'scale': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),              'source_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.SourceType']"}), -            'title': ('django.db.models.fields.CharField', [], {'max_length': '200'}) +            'support_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.SupportType']", 'null': 'True', 'blank': 'True'}), +            'title': ('django.db.models.fields.CharField', [], {'max_length': '300'})          }, -        'archaeological_operations.operationtype': { -            'Meta': {'object_name': 'OperationType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +        'archaeological_operations.operationtypeold': { +            'Meta': {'ordering': "['-preventive', 'order', 'label']", 'object_name': 'OperationTypeOld'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'order': ('django.db.models.fields.IntegerField', [], {'default': '1'}), +            'preventive': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'archaeological_operations.parcel': { -            'Meta': {'object_name': 'Parcel'}, +            'Meta': {'ordering': "('year', 'section', 'parcel_number')", 'object_name': 'Parcel'}, +            'address': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'associated_file': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'parcels'", 'null': 'True', 'to': "orm['archaeological_files.File']"}), +            'external_id': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'history_date': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_archaeological_operations_parcel'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}),              'operation': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'parcels'", 'null': 'True', 'to': "orm['archaeological_operations.Operation']"}), -            'parcel_number': ('django.db.models.fields.CharField', [], {'max_length': '6'}), +            'parcel_number': ('django.db.models.fields.CharField', [], {'max_length': '6', 'null': 'True', 'blank': 'True'}),              'section': ('django.db.models.fields.CharField', [], {'max_length': '4'}),              'town': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'parcels'", 'to': "orm['ishtar_common.Town']"}),              'year': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}) @@ -474,16 +776,18 @@ class Migration(SchemaMigration):          'archaeological_operations.parcelowner': {              'Meta': {'object_name': 'ParcelOwner'},              'end_date': ('django.db.models.fields.DateField', [], {}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'history_date': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.Person']"}), -            'parcel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_operations.Parcel']"}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_archaeological_operations_parcelowner'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'owner': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'parcel_owner'", 'to': "orm['ishtar_common.Person']"}), +            'parcel': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'owners'", 'to': "orm['archaeological_operations.Parcel']"}),              'start_date': ('django.db.models.fields.DateField', [], {})          },          'archaeological_operations.period': { -            'Meta': {'object_name': 'Period'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('order',)", 'object_name': 'Period'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'end_date': ('django.db.models.fields.IntegerField', [], {}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), @@ -491,15 +795,42 @@ class Migration(SchemaMigration):              'order': ('django.db.models.fields.IntegerField', [], {}),              'parent': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_operations.Period']", 'null': 'True', 'blank': 'True'}),              'start_date': ('django.db.models.fields.IntegerField', [], {}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}) +        }, +        'archaeological_operations.recordrelations': { +            'Meta': {'ordering': "('left_record', 'relation_type')", 'object_name': 'RecordRelations'}, +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'left_record': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'right_relations'", 'to': "orm['archaeological_operations.Operation']"}), +            'relation_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_operations.RelationType']"}), +            'right_record': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'left_relations'", 'to': "orm['archaeological_operations.Operation']"}) +        }, +        'archaeological_operations.relationtype': { +            'Meta': {'ordering': "('order',)", 'object_name': 'RelationType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'inverse_relation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['archaeological_operations.RelationType']", 'null': 'True', 'blank': 'True'}), +            'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'order': ('django.db.models.fields.IntegerField', [], {'default': '1'}), +            'symmetrical': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'archaeological_operations.remaintype': { -            'Meta': {'object_name': 'RemainType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'RemainType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}) +        }, +        'archaeological_operations.reportstate': { +            'Meta': {'ordering': "('order',)", 'object_name': 'ReportState'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'order': ('django.db.models.fields.IntegerField', [], {}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'auth.group': {              'Meta': {'object_name': 'Group'}, @@ -547,15 +878,15 @@ class Migration(SchemaMigration):              'Meta': {'object_name': 'Author'},              'author_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.AuthorType']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'person': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.Person']"}) +            'person': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'author'", 'to': "orm['ishtar_common.Person']"})          },          'ishtar_common.authortype': {              'Meta': {'object_name': 'AuthorType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'ishtar_common.canton': {              'Meta': {'object_name': 'Canton'}, @@ -567,64 +898,151 @@ class Migration(SchemaMigration):              'Meta': {'ordering': "['number']", 'object_name': 'Department'},              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '30'}), -            'number': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}) +            'number': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}), +            'state': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.State']", 'null': 'True', 'blank': 'True'}) +        }, +        'ishtar_common.documenttemplate': { +            'Meta': {'ordering': "['associated_object_name', 'name']", 'object_name': 'DocumentTemplate'}, +            'associated_object_name': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'template': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}) +        }, +        'ishtar_common.format': { +            'Meta': {'object_name': 'Format'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}) +        }, +        'ishtar_common.import': { +            'Meta': {'object_name': 'Import'}, +            'conservative_import': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'creation_date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'null': 'True', 'blank': 'True'}), +            'encoding': ('django.db.models.fields.CharField', [], {'default': "'utf-8'", 'max_length': '15'}), +            'end_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), +            'error_file': ('django.db.models.fields.files.FileField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'imported_file': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), +            'imported_images': ('django.db.models.fields.files.FileField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'importer_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.ImporterType']"}), +            'match_file': ('django.db.models.fields.files.FileField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'result_file': ('django.db.models.fields.files.FileField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'seconds_remaining': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), +            'skip_lines': ('django.db.models.fields.IntegerField', [], {'default': '1'}), +            'state': ('django.db.models.fields.CharField', [], {'default': "'C'", 'max_length': '2'}), +            'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.IshtarUser']"}) +        }, +        'ishtar_common.importertype': { +            'Meta': {'object_name': 'ImporterType'}, +            'associated_models': ('django.db.models.fields.CharField', [], {'max_length': '200'}), +            'description': ('django.db.models.fields.CharField', [], {'max_length': '500', 'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'is_template': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'slug': ('django.db.models.fields.SlugField', [], {'max_length': '100', 'unique': 'True', 'null': 'True', 'blank': 'True'}), +            'unicity_keys': ('django.db.models.fields.CharField', [], {'max_length': '500', 'null': 'True', 'blank': 'True'}), +            'users': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['ishtar_common.IshtarUser']", 'null': 'True', 'blank': 'True'}) +        }, +        'ishtar_common.ishtaruser': { +            'Meta': {'object_name': 'IshtarUser', '_ormbases': ['auth.User']}, +            'person': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ishtaruser'", 'unique': 'True', 'to': "orm['ishtar_common.Person']"}), +            'user_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['auth.User']", 'unique': 'True', 'primary_key': 'True'}) +        }, +        'ishtar_common.operationtype': { +            'Meta': {'ordering': "['-preventive', 'order', 'label']", 'object_name': 'OperationType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'order': ('django.db.models.fields.IntegerField', [], {'default': '1'}), +            'preventive': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'ishtar_common.organization': {              'Meta': {'object_name': 'Organization'},              'address': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'address_complement': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'country': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'null': 'True', 'blank': 'True'}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_ishtar_common_organization'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'merge_candidate': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'merge_candidate_rel_+'", 'null': 'True', 'to': "orm['ishtar_common.Organization']"}), +            'merge_exclusion': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'merge_exclusion_rel_+'", 'null': 'True', 'to': "orm['ishtar_common.Organization']"}), +            'merge_key': ('django.db.models.fields.CharField', [], {'max_length': '300', 'null': 'True', 'blank': 'True'}),              'mobile_phone': ('django.db.models.fields.CharField', [], {'max_length': '18', 'null': 'True', 'blank': 'True'}), -            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'name': ('django.db.models.fields.CharField', [], {'max_length': '300'}),              'organization_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.OrganizationType']"}),              'phone': ('django.db.models.fields.CharField', [], {'max_length': '18', 'null': 'True', 'blank': 'True'}),              'postal_code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}), -            'town': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}) +            'town': ('django.db.models.fields.CharField', [], {'max_length': '70', 'null': 'True', 'blank': 'True'})          },          'ishtar_common.organizationtype': { -            'Meta': {'object_name': 'OrganizationType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'OrganizationType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'ishtar_common.person': {              'Meta': {'object_name': 'Person'},              'address': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'address_complement': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), -            'attached_to': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.Organization']", 'null': 'True', 'blank': 'True'}), +            'attached_to': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'members'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['ishtar_common.Organization']"}),              'country': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}), -            'email': ('django.db.models.fields.CharField', [], {'max_length': '40', 'null': 'True', 'blank': 'True'}), -            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['auth.User']"}), +            'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'null': 'True', 'blank': 'True'}), +            'history_creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}), +            'history_modifier': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['auth.User']"}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'imports': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'imported_ishtar_common_person'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['ishtar_common.Import']"}), +            'merge_candidate': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'merge_candidate_rel_+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), +            'merge_exclusion': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'merge_exclusion_rel_+'", 'null': 'True', 'to': "orm['ishtar_common.Person']"}), +            'merge_key': ('django.db.models.fields.CharField', [], {'max_length': '300', 'null': 'True', 'blank': 'True'}),              'mobile_phone': ('django.db.models.fields.CharField', [], {'max_length': '18', 'null': 'True', 'blank': 'True'}), -            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}), -            'person_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.PersonType']"}), +            'name': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'}), +            'person_types': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['ishtar_common.PersonType']", 'symmetrical': 'False'}),              'phone': ('django.db.models.fields.CharField', [], {'max_length': '18', 'null': 'True', 'blank': 'True'}),              'postal_code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}), -            'surname': ('django.db.models.fields.CharField', [], {'max_length': '20'}), -            'title': ('django.db.models.fields.CharField', [], {'max_length': '2'}), -            'town': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}) +            'raw_name': ('django.db.models.fields.CharField', [], {'max_length': '300', 'null': 'True', 'blank': 'True'}), +            'surname': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}), +            'title': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), +            'town': ('django.db.models.fields.CharField', [], {'max_length': '70', 'null': 'True', 'blank': 'True'})          },          'ishtar_common.persontype': { -            'Meta': {'object_name': 'PersonType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'Meta': {'ordering': "('label',)", 'object_name': 'PersonType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['auth.Group']", 'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'rights': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['ishtar_common.WizardStep']", 'symmetrical': 'False'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'ishtar_common.sourcetype': {              'Meta': {'object_name': 'SourceType'}, -            'available': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),              'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),              'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), -            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}) +        }, +        'ishtar_common.state': { +            'Meta': {'ordering': "['number']", 'object_name': 'State'}, +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'label': ('django.db.models.fields.CharField', [], {'max_length': '30'}), +            'number': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}) +        }, +        'ishtar_common.supporttype': { +            'Meta': {'object_name': 'SupportType'}, +            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), +            'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), +            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), +            'label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), +            'txt_idx': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})          },          'ishtar_common.town': {              'Meta': {'ordering': "['numero_insee']", 'object_name': 'Town'}, @@ -635,19 +1053,6 @@ class Migration(SchemaMigration):              'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}),              'numero_insee': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '6'}),              'surface': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}) -        }, -        'ishtar_common.wizard': { -            'Meta': {'ordering': "['url_name']", 'object_name': 'Wizard'}, -            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'url_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}) -        }, -        'ishtar_common.wizardstep': { -            'Meta': {'ordering': "['wizard', 'order']", 'object_name': 'WizardStep'}, -            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), -            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}), -            'order': ('django.db.models.fields.IntegerField', [], {}), -            'url_name': ('django.db.models.fields.CharField', [], {'max_length': '128'}), -            'wizard': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['ishtar_common.Wizard']"})          }      } | 
