diff options
-rw-r--r-- | archaeological_context_records/migrations/0116_recordrelations_import_relationship.py | 12 | ||||
-rw-r--r-- | archaeological_operations/migrations/0115_recordrelations_import_relationship.py | 12 |
2 files changed, 24 insertions, 0 deletions
diff --git a/archaeological_context_records/migrations/0116_recordrelations_import_relationship.py b/archaeological_context_records/migrations/0116_recordrelations_import_relationship.py index 89fc8b753..661178b23 100644 --- a/archaeological_context_records/migrations/0116_recordrelations_import_relationship.py +++ b/archaeological_context_records/migrations/0116_recordrelations_import_relationship.py @@ -3,6 +3,17 @@ from django.db import migrations, models +# on vanilla installation imports relations are already created on 0101_squashed +# via heritage -> ishtar_common.models.GeneralRecordRelations + +DELETE_IMPORTS_RELATIONS = """ +DROP TABLE IF EXISTS archaeological_context_records_recordrelations_imports; +DROP TABLE IF EXISTS archaeological_context_records_recordrelations_imports_updated; +ALTER TABLE archaeological_context_records_recordrelations DROP COLUMN IF EXISTS timestamp_geo; +ALTER TABLE archaeological_context_records_recordrelations DROP COLUMN IF EXISTS timestamp_label; +""" + + class Migration(migrations.Migration): dependencies = [ @@ -11,6 +22,7 @@ class Migration(migrations.Migration): ] operations = [ + migrations.RunSQL(DELETE_IMPORTS_RELATIONS), migrations.AddField( model_name='recordrelations', name='imports', diff --git a/archaeological_operations/migrations/0115_recordrelations_import_relationship.py b/archaeological_operations/migrations/0115_recordrelations_import_relationship.py index 27cd19f51..675d1fe05 100644 --- a/archaeological_operations/migrations/0115_recordrelations_import_relationship.py +++ b/archaeological_operations/migrations/0115_recordrelations_import_relationship.py @@ -3,6 +3,17 @@ from django.db import migrations, models +# on vanilla installation imports relations are already created on 0101_squashed +# via heritage -> ishtar_common.models.GeneralRecordRelations + +DELETE_IMPORTS_RELATIONS = """ +DROP TABLE IF EXISTS archaeological_operations_recordrelations_imports; +DROP TABLE IF EXISTS archaeological_operations_recordrelations_imports_updated; +ALTER TABLE archaeological_operations_recordrelations DROP COLUMN IF EXISTS timestamp_geo; +ALTER TABLE archaeological_operations_recordrelations DROP COLUMN IF EXISTS timestamp_label; +""" + + class Migration(migrations.Migration): dependencies = [ @@ -11,6 +22,7 @@ class Migration(migrations.Migration): ] operations = [ + migrations.RunSQL(DELETE_IMPORTS_RELATIONS), migrations.AddField( model_name='recordrelations', name='imports', |