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. :)
--
Vennlig hilsen
Petter Reinholdtsen