Skip to content
Snippets Groups Projects

Reset migrations

Merged Reset migrations
terraforming into master
Merged ml bonhomme requested to merge terraforming into master

Closes #1434 (closed)

  • HStoreExtension in ponos 0001
  • in users 0001 
    CreateCollation(
          'case_insensitive',
          provider='icu',
          locale='und-u-ks-level2',
          deterministic=False,
      ),
  • BtreeGistExtension in documents 0001-0003 (needed in 0003)
  • CreateExtension('postgis') in images 0001
  • CreateExtension('uuid-ossp') in documents 0001
  • https://gitlab.com/teklia/arkindex/backend/-/merge_requests/1998/diffs in documents 0004

old_schema_clean: old/current migrations applied to a new empty db, old_schema is my very suspicious personal dev database

old_schema.sql

old_schema_clean.sql

new_schema.sql

Edited by Erwan Rouchet

Merge request reports

Checking pipeline status.

Merged by Erwan RouchetErwan Rouchet 1 year ago (Jun 5, 2023 3:07pm UTC)

Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • ml bonhomme requested review from @erwanrouchet

    requested review from @erwanrouchet

  • ml bonhomme assigned to @mlbonhomme

    assigned to @mlbonhomme

  • ml bonhomme changed the description

    changed the description

  • ml bonhomme changed the description

    changed the description

  • ml bonhomme added 1 commit

    added 1 commit

    Compare with previous version

  • ml bonhomme changed the description

    changed the description

  • ml bonhomme added 1 commit

    added 1 commit

    Compare with previous version

  • Erwan Rouchet
    Erwan Rouchet @erouchet ·
    Maintainer

    These queries are the difference between old_schema_clean.sql and new_schema.sql. They will need to be run by developers so that their existing databases match exactly the new database that gets created with the new migrations. This assumes they have a perfectly clean database, which is probably not true.

    Very hopeful script 
    BEGIN; 

ALTER SEQUENCE process_dataimport_files_id_seq RENAME TO process_process_files_id_seq;

ALTER TABLE process_processelement RENAME CONSTRAINT process_dataimportelement_pkey TO process_processelement_pkey;
ALTER TABLE process_processelement RENAME CONSTRAINT process_dataimportelemen_dataimport_id_element_id_edd46f23_uniq TO process_processelement_process_id_element_id_86b1de71_uniq;
ALTER TABLE process_processelement RENAME CONSTRAINT process_dataimportel_element_id_e4737453_fk_documents TO process_processeleme_element_id_c03913cb_fk_documents;

ALTER INDEX process_dataimportelement_dataimport_id_cc010213 RENAME TO process_processelement_process_id_e2597c38;
ALTER INDEX process_dataimportelement_element_id_e4737453 RENAME TO process_processelement_element_id_c03913cb;

ALTER TABLE ponos_task RENAME CONSTRAINT ponos_task_token_8d8e6d89_uniq TO ponos_task_token_key;

ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_pkey TO process_process_pkey;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_workflow_id_key TO process_process_workflow_id_key;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_corpus_id_7db9bebf_fk_documents_corpus_id TO process_process_corpus_id_65f65cd7_fk_documents_corpus_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_creator_id_0bdf8388_fk_users_user_id TO process_process_creator_id_811b6dab_fk_users_user_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_element_id_e602e87b_fk_documents_element_id TO process_process_element_id_3e8c9124_fk_documents_element_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_element_type_id_b298e8eb_fk_documents TO process_process_element_type_id_7ae9af6c_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_folder_type_id_729fdbea_fk_documents TO process_process_folder_type_id_34fb751c_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_model_id_b01aae9a_fk_training_model_id TO process_process_model_id_962e229a_fk_training_model_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_revision_id_5b6f64ef_fk_process_revision_id TO process_process_revision_id_4e74a9e4_fk_process_revision_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_test_folder_id_b250f09b_fk_documents TO process_process_test_folder_id_d60addd2_fk_documents_element_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_train_folder_id_4fcebd87_fk_documents TO process_process_train_folder_id_a0b76610_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_validation_folder_id_fdd908d5_fk_documents TO process_process_validation_folder_id_88532f5f_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_workflow_id_96751ace_fk_ponos_workflow_id TO process_process_workflow_id_1cdc071c_fk_ponos_workflow_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_collection_id_check TO process_process_collection_id_check;

ALTER INDEX process_dataimport_revision_id_5b6f64ef RENAME TO process_process_revision_id_4e74a9e4;
ALTER INDEX process_dataimport_folder_type_id_729fdbea RENAME TO process_process_folder_type_id_34fb751c;
ALTER INDEX process_dataimport_corpus_id_7db9bebf RENAME TO process_process_corpus_id_65f65cd7;
ALTER INDEX process_dataimport_template_id_dd21c63c RENAME TO process_process_template_id_a9202cc6;
ALTER INDEX process_dataimport_validation_folder_id_fdd908d5 RENAME TO process_process_validation_folder_id_88532f5f;
ALTER INDEX process_dataimport_element_id_e602e87b RENAME TO process_process_element_id_3e8c9124;
ALTER INDEX process_dataimport_element_type_id_b298e8eb RENAME TO process_process_element_type_id_7ae9af6c;
ALTER INDEX process_dataimport_creator_id_0bdf8388 RENAME TO process_process_creator_id_811b6dab;
ALTER INDEX process_dataimport_test_folder_id_b250f09b RENAME TO process_process_test_folder_id_d60addd2;
ALTER INDEX process_dataimport_model_id_b01aae9a RENAME TO process_process_model_id_962e229a;
ALTER INDEX process_dataimport_train_folder_id_4fcebd87 RENAME TO process_process_train_folder_id_a0b76610;

ALTER TABLE process_workerrun RENAME CONSTRAINT process_workerrun_version_id_dataimport_id_cb9da2bc_uniq TO process_workerrun_version_id_process_id_e7c11fd2_uniq;

ALTER INDEX process_workerrun_dataimport_id_44bb28ec RENAME TO process_workerrun_process_id_b071e292;

ALTER TABLE process_process_files RENAME CONSTRAINT process_dataimport_files_pkey TO process_process_files_pkey;
ALTER TABLE process_process_files RENAME CONSTRAINT process_dataimport_files_dataimport_id_datafile_i_bcb52051_uniq TO process_process_files_process_id_datafile_id_818c7357_uniq;
ALTER TABLE process_process_files RENAME CONSTRAINT process_dataimport_f_datafile_id_cc156d4c_fk_process_d TO process_process_file_datafile_id_98bc8b34_fk_process_d;

ALTER INDEX process_dataimport_files_dataimport_id_fc6009ec RENAME TO process_process_files_process_id_f46cc759;
ALTER INDEX process_dataimport_files_datafile_id_cc156d4c RENAME TO process_process_files_datafile_id_98bc8b34;

COMMIT;
    Edited by Erwan Rouchet
  • ml bonhomme added 1 commit

    added 1 commit

    Compare with previous version

  • ml bonhomme added 1 commit

    added 1 commit

    Compare with previous version

  • ml bonhomme added 4 commits

    added 4 commits

    Compare with previous version

    Toggle commit list
  • ml bonhomme marked this merge request as ready

    marked this merge request as ready

  • Erwan Rouchet
  • Erwan Rouchet
  • Erwan Rouchet
  • Erwan Rouchet changed the description

    changed the description

  • Erwan Rouchet changed title from Reset migrations!!! to Reset migrations

    changed title from Reset migrations!!! to Reset migrations

  • Erwan Rouchet changed milestone to %Arkindex 1.4.3

    changed milestone to %Arkindex 1.4.3

  • Erwan Rouchet
    Erwan Rouchet @erouchet ·
    Maintainer

    Chaotic good reset script for devs

    This script combines all the scripts I wrote in https://notes.teklia.com/s/lErTeDKEK# to try to fix anything encountered anywhere.

    This should not be run in production as it does not give any guarantees of fully migrating the database, but it might be able to fix most developer setups.

    It does not run everything inside of a transaction, since some queries might cause errors if your database is not broken enough.

    I did get to fix my own setup with this and had no relevant differences with a new database created from scratch.

    View script 
    -- Apply every ALTER command of every script of every instance (deduplicated) to hopefully fix every known issue
-- You might get a few NOTICE messages if the indices or sequences do not exist.
ALTER INDEX IF EXISTS dataimport_corpusworkerversion_corpus_id_240ccc60 RENAME TO process_corpusworkerversion_corpus_id_41b79cc2;
ALTER INDEX IF EXISTS dataimport_corpusworkerversion_worker_version_id_60455918 RENAME TO process_corpusworkerversion_worker_version_id_94104f92;
ALTER INDEX IF EXISTS dataimport_datafile_corpus_id_1822bc94 RENAME TO process_datafile_corpus_id_d46c0018;
ALTER INDEX IF EXISTS dataimport_dataimport_corpus_id_eab423b4 RENAME TO process_dataimport_corpus_id_7db9bebf;
ALTER INDEX IF EXISTS dataimport_dataimport_creator_id_262a3af9 RENAME TO process_dataimport_creator_id_0bdf8388;
ALTER INDEX IF EXISTS dataimport_dataimportelement_dataimport_id_fcd13316 RENAME TO process_dataimportelement_dataimport_id_cc010213;
ALTER INDEX IF EXISTS dataimport_dataimportelement_element_id_6e6de0bd RENAME TO process_dataimportelement_element_id_e4737453;
ALTER INDEX IF EXISTS dataimport_dataimport_element_id_313cb622 RENAME TO process_dataimport_element_id_e602e87b;
ALTER INDEX IF EXISTS dataimport_dataimport_element_type_id_bf132afb RENAME TO process_dataimport_element_type_id_b298e8eb;
ALTER INDEX IF EXISTS dataimport_dataimport_files_datafile_id_4c4547a0 RENAME TO process_dataimport_files_datafile_id_cc156d4c;
ALTER INDEX IF EXISTS dataimport_dataimport_files_dataimport_id_db823dcd RENAME TO process_dataimport_files_dataimport_id_fc6009ec;
ALTER INDEX IF EXISTS dataimport_dataimport_folder_type_id_e51648ab RENAME TO process_dataimport_folder_type_id_729fdbea;
ALTER INDEX IF EXISTS dataimport_dataimport_model_id_9d72ae46 RENAME TO process_dataimport_model_id_b01aae9a;
ALTER INDEX IF EXISTS dataimport_dataimport_revision_id_9ae13461 RENAME TO process_dataimport_revision_id_5b6f64ef;
ALTER INDEX IF EXISTS dataimport_dataimport_template_id_6983d85d RENAME TO process_dataimport_template_id_dd21c63c;
ALTER INDEX IF EXISTS dataimport_dataimport_test_folder_id_305cdd71 RENAME TO process_dataimport_test_folder_id_b250f09b;
ALTER INDEX IF EXISTS dataimport_dataimport_train_folder_id_14399217 RENAME TO process_dataimport_train_folder_id_4fcebd87;
ALTER INDEX IF EXISTS dataimport_dataimport_validation_folder_id_59560629 RENAME TO process_dataimport_validation_folder_id_fdd908d5;
ALTER INDEX IF EXISTS dataimport_gitref_repository_id_c6ea9f78 RENAME TO process_gitref_repository_id_9ccfaf64;
ALTER INDEX IF EXISTS dataimport_gitref_revision_id_20c77e38 RENAME TO process_gitref_revision_id_61fc391a;
ALTER INDEX IF EXISTS dataimport_repository_credentials_id_6c6fc107 RENAME TO process_repository_credentials_id_7b685b46;
ALTER INDEX IF EXISTS dataimport_repository_hook_token_aec09b74_like RENAME TO process_repository_hook_token_7616df85_like;
ALTER INDEX IF EXISTS dataimport_repository_url_0b37b5b7_like RENAME TO process_repository_url_df3b137b_like;
ALTER INDEX IF EXISTS dataimport_revision_repo_id_188ac6f4 RENAME TO process_revision_repo_id_c961c3f6;
ALTER INDEX IF EXISTS dataimport_workeractivity_configuration_id_1534265a RENAME TO process_workeractivity_configuration_id_2f1ce1e9;
ALTER INDEX IF EXISTS dataimport_workeractivity_element_id_0232ee01 RENAME TO process_workeractivity_element_id_9a98b12a;
ALTER INDEX IF EXISTS dataimport_workeractivity_process_id_96a889da RENAME TO process_workeractivity_process_id_b86dbdd6;
ALTER INDEX IF EXISTS dataimport_workeractivity_worker_version_id_40a17723 RENAME TO process_workeractivity_worker_version_id_5d0ba52d;
ALTER INDEX IF EXISTS dataimport_workerconfiguration_worker_id_c48bceaa RENAME TO process_workerconfiguration_worker_id_67df215a;
ALTER INDEX IF EXISTS dataimport_worker_repository_id_9cf91beb RENAME TO process_worker_repository_id_3239903f;
ALTER INDEX IF EXISTS dataimport_workerrun_configuration_id_7b80a991 RENAME TO process_workerrun_configuration_id_ea6b2f6c;
ALTER INDEX IF EXISTS dataimport_workerrun_dataimport_id_7c7e040c RENAME TO process_workerrun_dataimport_id_44bb28ec;
ALTER INDEX IF EXISTS dataimport_workerrun_model_version_id_57609eaf RENAME TO process_workerrun_model_version_id_a26f4920;
ALTER INDEX IF EXISTS dataimport_workerrun_version_id_66ecfea5 RENAME TO process_workerrun_version_id_03829b30;
ALTER INDEX IF EXISTS dataimport_worker_type_id_9fac96d4 RENAME TO process_worker_type_id_af829416;
ALTER INDEX IF EXISTS dataimport_workertype_slug_7ffba2e9_like RENAME TO process_workertype_slug_07bbd0f1_like;
ALTER INDEX IF EXISTS dataimport_workerversion_docker_image_id_d71b869f RENAME TO process_workerversion_docker_image_id_75774773;
ALTER INDEX IF EXISTS dataimport_workerversion_revision_id_24329d96 RENAME TO process_workerversion_revision_id_b8ff1b9f;
ALTER INDEX IF EXISTS dataimport_workerversion_worker_id_55f3d4bc RENAME TO process_workerversion_worker_id_dc5b372a;
ALTER INDEX IF EXISTS documents_elementnewtype_corpus_id_681e7f16 RENAME TO documents_elementtype_corpus_id_1a26f6cf;
ALTER INDEX IF EXISTS documents_element_new_type_id_6ae25be3 RENAME TO documents_element_type_id_bc9a4d56;
ALTER INDEX IF EXISTS documents_elementnewtype_slug_e2065c37_like RENAME TO documents_elementtype_slug_d7b48d88_like;
ALTER INDEX IF EXISTS documents_elementnewtype_slug_e2065c37 RENAME TO documents_elementtype_slug_d7b48d88;
ALTER INDEX IF EXISTS "documents_elementpath_AlakrPex_element_id_d99627b5" RENAME TO documents_elementpath_element_id_cb0bcf2f;
ALTER INDEX IF EXISTS documents_element_polygon_id RENAME TO documents_element_polygon_4dc2119a_id;
ALTER SEQUENCE IF EXISTS dataimport_dataimport_files_id_seq RENAME TO process_dataimport_files_id_seq;
ALTER TABLE documents_corpus DROP CONSTRAINT IF EXISTS documents_corpus_id_a63b4007_uniq;

-- "RENAME CONSTRAINT IF EXISTS" unfortunately does not exist, so this will cause some errors if the constraints do not exist.
ALTER TABLE documents_classification RENAME CONSTRAINT documents_classifica_worker_run_id_94f3a432_fk_dataimpor TO documents_classifica_worker_run_id_94f3a432_fk_process_w;
ALTER TABLE documents_classification RENAME CONSTRAINT documents_classifica_worker_version_id_88c53ba9_fk_dataimpor TO documents_classifica_worker_version_id_88c53ba9_fk_process_w;
ALTER TABLE documents_corpus RENAME CONSTRAINT documents_corpus_id_a63b4007_pk TO documents_corpus_pkey;
ALTER TABLE documents_elementpath RENAME CONSTRAINT "documents_elementpath_AlakrPex_ordering_check" TO documents_elementpath_ordering_check;
ALTER TABLE documents_elementpath RENAME CONSTRAINT "documents_elementpath_AlakrPex_pkey" TO documents_elementpath_pkey;
ALTER TABLE documents_element RENAME CONSTRAINT documents_element_worker_run_id_794288c7_fk_dataimpor TO documents_element_worker_run_id_794288c7_fk_process_w;
ALTER TABLE documents_element RENAME CONSTRAINT documents_element_worker_version_id_29d47f5a_fk_dataimpor TO documents_element_worker_version_id_29d47f5a_fk_process_w;
ALTER TABLE documents_elementtype RENAME CONSTRAINT documents_elementnew_corpus_id_681e7f16_fk_documents TO documents_elementtype_corpus_id_1a26f6cf_fk_documents_corpus_id;
ALTER TABLE documents_elementtype RENAME CONSTRAINT documents_elementnewtype_pkey TO documents_elementtype_pkey;
ALTER TABLE documents_entity RENAME CONSTRAINT documents_entity_worker_run_id_000b6a90_fk_dataimpor TO documents_entity_worker_run_id_000b6a90_fk_process_workerrun_id;
ALTER TABLE documents_entity RENAME CONSTRAINT documents_entity_worker_version_id_71699a6d_fk_dataimpor TO documents_entity_worker_version_id_71699a6d_fk_process_w;
ALTER TABLE documents_metadata RENAME CONSTRAINT documents_metadata_worker_run_id_b140b454_fk_dataimpor TO documents_metadata_worker_run_id_b140b454_fk_process_w;
ALTER TABLE documents_metadata RENAME CONSTRAINT documents_metadata_worker_version_id_12aac05d_fk_dataimpor TO documents_metadata_worker_version_id_12aac05d_fk_process_w;
ALTER TABLE documents_transcriptionentity RENAME CONSTRAINT documents_transcript_worker_run_id_e8492c1f_fk_dataimpor TO documents_transcript_worker_run_id_e8492c1f_fk_process_w;
ALTER TABLE documents_transcriptionentity RENAME CONSTRAINT documents_transcript_worker_version_id_1cb7ea28_fk_dataimpor TO documents_transcript_worker_version_id_1cb7ea28_fk_process_w;
ALTER TABLE documents_transcription RENAME CONSTRAINT documents_transcriptionnew_pkey TO documents_transcription_pkey;
ALTER TABLE documents_transcription RENAME CONSTRAINT documents_transcript_worker_run_id_6801e6d0_fk_dataimpor TO documents_transcript_worker_run_id_6801e6d0_fk_process_w;
ALTER TABLE documents_transcription RENAME CONSTRAINT documents_transcript_worker_version_id_d9f4e4d3_fk_dataimpor TO documents_transcript_worker_version_id_d9f4e4d3_fk_process_w;
ALTER TABLE images_imageserver RENAME CONSTRAINT images_imageserver_url_e32640ce_uniq TO images_imageserver_url_key;
ALTER TABLE process_corpusworkerversion RENAME CONSTRAINT dataimport_corpuswor_corpus_id_240ccc60_fk_documents TO process_corpusworker_corpus_id_41b79cc2_fk_documents;
ALTER TABLE process_corpusworkerversion RENAME CONSTRAINT dataimport_corpusworkerv_corpus_id_worker_version_bdbcf080_uniq TO process_corpusworkervers_corpus_id_worker_version_40e3f618_uniq;
ALTER TABLE process_corpusworkerversion RENAME CONSTRAINT dataimport_corpusworkerversion_pkey TO process_corpusworkerversion_pkey;
ALTER TABLE process_corpusworkerversion RENAME CONSTRAINT dataimport_corpuswor_worker_version_id_60455918_fk_dataimpor TO process_corpusworker_worker_version_id_94104f92_fk_process_w;
ALTER TABLE process_datafile RENAME CONSTRAINT dataimport_datafile_corpus_id_1822bc94_fk_documents_corpus_id TO process_datafile_corpus_id_d46c0018_fk_documents_corpus_id;
ALTER TABLE process_datafile RENAME CONSTRAINT dataimport_datafile_pkey TO process_datafile_pkey;
ALTER TABLE process_datafile RENAME CONSTRAINT dataimport_datafile_size_check TO process_datafile_size_check;
ALTER TABLE process_gitref RENAME CONSTRAINT dataimport_gitref_name_repository_id_511e1bf6_uniq TO process_gitref_name_repository_id_69d1693d_uniq;
ALTER TABLE process_gitref RENAME CONSTRAINT dataimport_gitref_pkey TO process_gitref_pkey;
ALTER TABLE process_gitref RENAME CONSTRAINT dataimport_gitref_repository_id_c6ea9f78_fk_dataimpor TO process_gitref_repository_id_9ccfaf64_fk_process_repository_id;
ALTER TABLE process_gitref RENAME CONSTRAINT dataimport_gitref_revision_id_20c77e38_fk_dataimpor TO process_gitref_revision_id_61fc391a_fk_process_revision_id;
ALTER TABLE process_processelement RENAME CONSTRAINT dataimport_dataimpor_dataimport_id_fcd13316_fk_dataimpor TO process_processeleme_process_id_e2597c38_fk_process_p;
ALTER TABLE process_processelement RENAME CONSTRAINT dataimport_dataimpor_element_id_6e6de0bd_fk_documents TO process_dataimportel_element_id_e4737453_fk_documents;
ALTER TABLE process_processelement RENAME CONSTRAINT dataimport_dataimportele_dataimport_id_element_id_ee35380e_uniq TO process_dataimportelemen_dataimport_id_element_id_edd46f23_uniq;
ALTER TABLE process_processelement RENAME CONSTRAINT dataimport_dataimportelement_pkey TO process_dataimportelement_pkey;
ALTER TABLE process_processelement RENAME CONSTRAINT dataimport_processel_process_id_39ddc479_fk_dataimpor TO process_processeleme_process_id_e2597c38_fk_process_p;
ALTER TABLE process_process_files RENAME CONSTRAINT dataimport_dataimpor_datafile_id_4c4547a0_fk_dataimpor TO process_dataimport_f_datafile_id_cc156d4c_fk_process_d;
ALTER TABLE process_process_files RENAME CONSTRAINT dataimport_dataimpor_dataimport_id_db823dcd_fk_dataimpor TO process_process_files_process_id_f46cc759_fk_process_process_id;
ALTER TABLE process_process_files RENAME CONSTRAINT dataimport_dataimport_fi_dataimport_id_datafile_i_577962c8_uniq TO process_dataimport_files_dataimport_id_datafile_i_bcb52051_uniq;
ALTER TABLE process_process_files RENAME CONSTRAINT dataimport_dataimport_files_pkey TO process_dataimport_files_pkey;
ALTER TABLE process_process_files RENAME CONSTRAINT dataimport_process_f_process_id_1f324c77_fk_dataimpor TO process_process_files_process_id_f46cc759_fk_process_process_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_element_id_313cb622_fk_documents TO process_dataimport_element_id_e602e87b_fk_documents_element_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_element_type_id_bf132afb_fk_documents TO process_dataimport_element_type_id_b298e8eb_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_folder_type_id_e51648ab_fk_documents TO process_dataimport_folder_type_id_729fdbea_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_revision_id_9ae13461_fk_dataimpor TO process_dataimport_revision_id_5b6f64ef_fk_process_revision_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_collection_id_check TO process_dataimport_collection_id_check;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_corpus_id_eab423b4_fk_documents_corpus_id TO process_dataimport_corpus_id_7db9bebf_fk_documents_corpus_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_creator_id_262a3af9_fk_users_user_id TO process_dataimport_creator_id_0bdf8388_fk_users_user_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_template_id_6983d85d_fk_dataimpor TO process_process_template_id_a9202cc6_fk_process_process_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_test_folder_id_305cdd71_fk_documents TO process_dataimport_test_folder_id_b250f09b_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_model_id_9d72ae46_fk_training_model_id TO process_dataimport_model_id_b01aae9a_fk_training_model_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_pkey TO process_dataimport_pkey;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_train_folder_id_14399217_fk_documents TO process_dataimport_train_folder_id_4fcebd87_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_workflow_id_2e48cdb1_fk_ponos_workflow_id TO process_dataimport_workflow_id_96751ace_fk_ponos_workflow_id;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimport_workflow_id_key TO process_dataimport_workflow_id_key;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_dataimpor_validation_folder_id_59560629_fk_documents TO process_dataimport_validation_folder_id_fdd908d5_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT dataimport_process_template_id_85726a13_fk_dataimpor TO process_process_template_id_a9202cc6_fk_process_process_id;
ALTER TABLE process_repository RENAME CONSTRAINT dataimport_repositor_credentials_id_6c6fc107_fk_users_oau TO process_repository_credentials_id_7b685b46_fk_users_oau;
ALTER TABLE process_repository RENAME CONSTRAINT dataimport_repository_hook_token_key TO process_repository_hook_token_key;
ALTER TABLE process_repository RENAME CONSTRAINT dataimport_repository_pkey TO process_repository_pkey;
ALTER TABLE process_repository RENAME CONSTRAINT dataimport_repository_url_key TO process_repository_url_key;
ALTER TABLE process_revision RENAME CONSTRAINT dataimport_revision_pkey TO process_revision_pkey;
ALTER TABLE process_revision RENAME CONSTRAINT dataimport_revision_repo_id_188ac6f4_fk_dataimpor TO process_revision_repo_id_c961c3f6_fk_process_repository_id;
ALTER TABLE process_revision RENAME CONSTRAINT dataimport_revision_repo_id_hash_fc5596b8_uniq TO process_revision_repo_id_hash_d1e2a976_uniq;
ALTER TABLE process_workeractivity RENAME CONSTRAINT dataimport_workeract_configuration_id_1534265a_fk_dataimpor TO process_workeractivi_configuration_id_2f1ce1e9_fk_process_w;
ALTER TABLE process_workeractivity RENAME CONSTRAINT dataimport_workeract_element_id_0232ee01_fk_documents TO process_workeractivi_element_id_9a98b12a_fk_documents;
ALTER TABLE process_workeractivity RENAME CONSTRAINT dataimport_workeractivity_pkey TO process_workeractivity_pkey;
ALTER TABLE process_workeractivity RENAME CONSTRAINT dataimport_workeract_worker_version_id_40a17723_fk_dataimpor TO process_workeractivi_worker_version_id_5d0ba52d_fk_process_w;
ALTER TABLE process_workerconfiguration RENAME CONSTRAINT dataimport_workerconfiguration_pkey TO process_workerconfiguration_pkey;
ALTER TABLE process_workerconfiguration RENAME CONSTRAINT dataimport_workerconfiguration_worker_id_name_c82a4531_uniq TO process_workerconfiguration_worker_id_name_9000ad01_uniq;
ALTER TABLE process_workerconfiguration RENAME CONSTRAINT dataimport_workerconfigu_worker_id_configuration__3fabccbd_uniq TO process_workerconfigurat_worker_id_configuration__964c2ad5_uniq;
ALTER TABLE process_workerconfiguration RENAME CONSTRAINT dataimport_workercon_worker_id_c48bceaa_fk_dataimpor TO process_workerconfig_worker_id_67df215a_fk_process_w;
ALTER TABLE process_worker RENAME CONSTRAINT dataimport_worker_pkey TO process_worker_pkey;
ALTER TABLE process_worker RENAME CONSTRAINT dataimport_worker_repository_id_9cf91beb_fk_dataimpor TO process_worker_repository_id_3239903f_fk_process_repository_id;
ALTER TABLE process_worker RENAME CONSTRAINT dataimport_worker_slug_repository_id_7787594f_uniq TO process_worker_slug_repository_id_5f05fef4_uniq;
ALTER TABLE process_worker RENAME CONSTRAINT dataimport_worker_type_id_9fac96d4_fk_dataimport_workertype_id TO process_worker_type_id_af829416_fk_process_workertype_id;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_configuration_id_7b80a991_fk_dataimpor TO process_workerrun_configuration_id_ea6b2f6c_fk_process_w;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_dataimport_id_7c7e040c_fk_dataimpor TO process_workerrun_process_id_b071e292_fk_process_process_id;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_model_version_id_57609eaf_fk_training_ TO process_workerrun_model_version_id_a26f4920_fk_training_;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_pkey TO process_workerrun_pkey;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_process_id_d8c72447_fk_dataimpor TO process_workerrun_process_id_b071e292_fk_process_process_id;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_version_id_66ecfea5_fk_dataimpor TO process_workerrun_version_id_03829b30_fk_process_w;
ALTER TABLE process_workerrun RENAME CONSTRAINT dataimport_workerrun_version_id_dataimport_id_22647784_uniq TO process_workerrun_version_id_dataimport_id_cb9da2bc_uniq;
ALTER TABLE process_workertype RENAME CONSTRAINT dataimport_workertype_pkey TO process_workertype_pkey;
ALTER TABLE process_workertype RENAME CONSTRAINT dataimport_workertype_slug_key TO process_workertype_slug_key;
ALTER TABLE process_workerversion RENAME CONSTRAINT dataimport_workerver_docker_image_id_d71b869f_fk_ponos_art TO process_workerversio_docker_image_id_75774773_fk_ponos_art;
ALTER TABLE process_workerversion RENAME CONSTRAINT dataimport_workerver_revision_id_24329d96_fk_dataimpor TO process_workerversio_revision_id_b8ff1b9f_fk_process_r;
ALTER TABLE process_workerversion RENAME CONSTRAINT dataimport_workerversion_pkey TO process_workerversion_pkey;
ALTER TABLE process_workerversion RENAME CONSTRAINT dataimport_workerversion_worker_id_revision_id_d524304f_uniq TO process_workerversion_worker_id_revision_id_fea45518_uniq;
ALTER TABLE process_workerversion RENAME CONSTRAINT dataimport_workerver_worker_id_55f3d4bc_fk_dataimpor TO process_workerversion_worker_id_dc5b372a_fk_process_worker_id;
ALTER TABLE training_model_compatible_workers RENAME CONSTRAINT training_model_compa_worker_id_31ed2de4_fk_dataimpor TO training_model_compa_worker_id_31ed2de4_fk_process_w;

-- The database is now probably at the right state, so we can apply the consequences of the reset itself.
-- If this transaction fails, then your database is broken in ways that were not yet identified and you should compare your database schema with `old_schema_clean.sql` from this MR to troubleshoot.
BEGIN; 

ALTER SEQUENCE process_dataimport_files_id_seq RENAME TO process_process_files_id_seq;

ALTER TABLE process_processelement RENAME CONSTRAINT process_dataimportelement_pkey TO process_processelement_pkey;
ALTER TABLE process_processelement RENAME CONSTRAINT process_dataimportelemen_dataimport_id_element_id_edd46f23_uniq TO process_processelement_process_id_element_id_86b1de71_uniq;
ALTER TABLE process_processelement RENAME CONSTRAINT process_dataimportel_element_id_e4737453_fk_documents TO process_processeleme_element_id_c03913cb_fk_documents;

ALTER INDEX process_dataimportelement_dataimport_id_cc010213 RENAME TO process_processelement_process_id_e2597c38;
ALTER INDEX process_dataimportelement_element_id_e4737453 RENAME TO process_processelement_element_id_c03913cb;

ALTER TABLE ponos_task RENAME CONSTRAINT ponos_task_token_8d8e6d89_uniq TO ponos_task_token_key;

ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_pkey TO process_process_pkey;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_workflow_id_key TO process_process_workflow_id_key;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_corpus_id_7db9bebf_fk_documents_corpus_id TO process_process_corpus_id_65f65cd7_fk_documents_corpus_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_creator_id_0bdf8388_fk_users_user_id TO process_process_creator_id_811b6dab_fk_users_user_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_element_id_e602e87b_fk_documents_element_id TO process_process_element_id_3e8c9124_fk_documents_element_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_element_type_id_b298e8eb_fk_documents TO process_process_element_type_id_7ae9af6c_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_folder_type_id_729fdbea_fk_documents TO process_process_folder_type_id_34fb751c_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_model_id_b01aae9a_fk_training_model_id TO process_process_model_id_962e229a_fk_training_model_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_revision_id_5b6f64ef_fk_process_revision_id TO process_process_revision_id_4e74a9e4_fk_process_revision_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_test_folder_id_b250f09b_fk_documents TO process_process_test_folder_id_d60addd2_fk_documents_element_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_train_folder_id_4fcebd87_fk_documents TO process_process_train_folder_id_a0b76610_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_validation_folder_id_fdd908d5_fk_documents TO process_process_validation_folder_id_88532f5f_fk_documents;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_workflow_id_96751ace_fk_ponos_workflow_id TO process_process_workflow_id_1cdc071c_fk_ponos_workflow_id;
ALTER TABLE process_process RENAME CONSTRAINT process_dataimport_collection_id_check TO process_process_collection_id_check;

ALTER INDEX process_dataimport_revision_id_5b6f64ef RENAME TO process_process_revision_id_4e74a9e4;
ALTER INDEX process_dataimport_folder_type_id_729fdbea RENAME TO process_process_folder_type_id_34fb751c;
ALTER INDEX process_dataimport_corpus_id_7db9bebf RENAME TO process_process_corpus_id_65f65cd7;
ALTER INDEX process_dataimport_template_id_dd21c63c RENAME TO process_process_template_id_a9202cc6;
ALTER INDEX process_dataimport_validation_folder_id_fdd908d5 RENAME TO process_process_validation_folder_id_88532f5f;
ALTER INDEX process_dataimport_element_id_e602e87b RENAME TO process_process_element_id_3e8c9124;
ALTER INDEX process_dataimport_element_type_id_b298e8eb RENAME TO process_process_element_type_id_7ae9af6c;
ALTER INDEX process_dataimport_creator_id_0bdf8388 RENAME TO process_process_creator_id_811b6dab;
ALTER INDEX process_dataimport_test_folder_id_b250f09b RENAME TO process_process_test_folder_id_d60addd2;
ALTER INDEX process_dataimport_model_id_b01aae9a RENAME TO process_process_model_id_962e229a;
ALTER INDEX process_dataimport_train_folder_id_4fcebd87 RENAME TO process_process_train_folder_id_a0b76610;

ALTER TABLE process_workerrun RENAME CONSTRAINT process_workerrun_version_id_dataimport_id_cb9da2bc_uniq TO process_workerrun_version_id_process_id_e7c11fd2_uniq;

ALTER INDEX process_workerrun_dataimport_id_44bb28ec RENAME TO process_workerrun_process_id_b071e292;

ALTER TABLE process_process_files RENAME CONSTRAINT process_dataimport_files_pkey TO process_process_files_pkey;
ALTER TABLE process_process_files RENAME CONSTRAINT process_dataimport_files_dataimport_id_datafile_i_bcb52051_uniq TO process_process_files_process_id_datafile_id_818c7357_uniq;
ALTER TABLE process_process_files RENAME CONSTRAINT process_dataimport_f_datafile_id_cc156d4c_fk_process_d TO process_process_file_datafile_id_98bc8b34_fk_process_d;

ALTER INDEX process_dataimport_files_dataimport_id_fc6009ec RENAME TO process_process_files_process_id_f46cc759;
ALTER INDEX process_dataimport_files_datafile_id_cc156d4c RENAME TO process_process_files_datafile_id_98bc8b34;

COMMIT;
    Edited by Erwan Rouchet
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
    • Please register or sign in to reply