Jeg måtte inn med følgende endring for å få nikita-tables-drop-psql til å fungere med siste master:
diff --git a/scripts/psql/nikita-tables-drop-psql b/scripts/psql/nikita-tables-drop-psql index 4f115d86f..320a9c0a7 100755 --- a/scripts/psql/nikita-tables-drop-psql +++ b/scripts/psql/nikita-tables-drop-psql @@ -36,8 +36,6 @@ DROP TABLE sa_case_file ; DROP TABLE sa_sequence_generator ; DROP TABLE ad_administrative_unit_user ; DROP TABLE ad_administrative_unit ; -DROP TABLE ad_user_authority ; -DROP TABLE ad_authority ; DROP TABLE as_document_flow ; DROP TABLE log_change_log ; DROP TABLE log_create_log ; @@ -138,7 +136,8 @@ DROP TABLE md_screening_metadata ; DROP TABLE md_series_status ; DROP TABLE md_sign_off_method ; DROP TABLE md_variant_format ; +DROP TABLE file_upload_chunks ; +DROP TABLE file_upload_register ; DROP TABLE system_id_entity; -DROP SEQUENCE authority_seq; END TRANSACTION; "
I tillegg kan jeg bekrefte at indeksintroduksjonen fungerte etter planen:
diff --git a/src/main/java/app/domain/noark5/bsm/BSMBase.java b/src/main/java/app/domain/noark5/bsm/BSMBase.java index 013400564..a8d995ee9 100644 --- a/src/main/java/app/domain/noark5/bsm/BSMBase.java +++ b/src/main/java/app/domain/noark5/bsm/BSMBase.java @@ -23,7 +23,21 @@ import static app.utils.constants.Constants.*; import static jakarta.persistence.FetchType.LAZY;
@Entity -@Table(name = TABLE_BSM_BASE) +@Table(name = TABLE_BSM_BASE, + indexes = { + @Index(name = TABLE_BSM_BASE + "_" + BSM_FILE_ID + "_index", + columnList = BSM_FILE_ID), + @Index(name = TABLE_BSM_BASE + "_" + BSM_RECORD_ID + "_index", + columnList = BSM_RECORD_ID), + @Index(name = TABLE_BSM_BASE + "_" + BSM_PART_ID + "_index", + columnList = BSM_PART_ID), + @Index(name = TABLE_BSM_BASE + "_" + BSM_CORRESPONDENCE_PART_ID + "_index", + columnList = BSM_CORRESPONDENCE_PART_ID), + @Index(name = TABLE_BSM_BASE + "_" + BSM_DOCUMENT_DESCRIPTION_ID + "_index", + columnList = BSM_DOCUMENT_DESCRIPTION_ID), + @Index(name = TABLE_BSM_BASE + "_" + BSM_ADMINISTRATIVE_UNIT_ID + "_index", + columnList = BSM_ADMINISTRATIVE_UNIT_ID) + }) @JsonDeserialize(using = BSMDeserializer.class) @LinksPacker(using = BSMBaseLinksBuilder.class) @LinksObject(using = BSMBaseLinks.class)
Ny legantoimport er igang, vet om rundt 10 timer hvor lang tid det tar denne gangen. :)