11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         CREATE INDEX IF NOT EXISTS pieces_poLineId_idx           ON diku_mod_orders_storage.pieces (poLineId);
11:42:17 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42P07', message='relation "pieces_polineid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          CREATE INDEX IF NOT EXISTS pieces_poLineId_idx           ON diku_mod_orders_storage.pieces (poLineId);
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('pieces');
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('pieces');
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS titleId UUID;
11:42:17 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42701', message='column "titleid" of relation "pieces" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6291', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS titleId UUID;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE pieces
              ADD CONSTRAINT titleId_titles_fkey
              FOREIGN KEY (titleId) REFERENCES titles;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE pieces
              ADD CONSTRAINT titleId_titles_fkey
              FOREIGN KEY (titleId) REFERENCES titles;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         CREATE INDEX IF NOT EXISTS pieces_titleId_idx           ON diku_mod_orders_storage.pieces (titleId);
11:42:17 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42P07', message='relation "pieces_titleid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          CREATE INDEX IF NOT EXISTS pieces_titleId_idx           ON diku_mod_orders_storage.pieces (titleId);
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('pieces');
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('pieces');
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_pieces_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      NEW.titleId = (NEW.jsonb->>'titleId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_pieces_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      NEW.titleId = (NEW.jsonb->>'titleId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_pieces_references ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_pieces_references ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     CREATE TRIGGER update_pieces_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_pieces_references();
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      CREATE TRIGGER update_pieces_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_pieces_references();
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'poLineId_po_line_fkey' || i;
      END LOOP;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'titleId_titles_fkey' || i;
      END LOOP;
    END $$;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'poLineId_po_line_fkey' || i;
      END LOOP;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE pieces DROP CONSTRAINT IF EXISTS '
                || 'titleId_titles_fkey' || i;
      END LOOP;
    END $$;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.pieces_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.pieces_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_pieces_md_trigger ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_pieces_md_trigger ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_pieces_md_trigger BEFORE INSERT ON diku_mod_orders_storage.pieces    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.pieces_set_md();
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_pieces_md_trigger BEFORE INSERT ON diku_mod_orders_storage.pieces    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.pieces_set_md();
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_pieces_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_pieces_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_pieces_md_json_trigger ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_pieces_md_json_trigger ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_pieces_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.pieces   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_pieces_md_json();
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_pieces_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.pieces   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_pieces_md_json();
11:42:17 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_pieces_ol_version_trigger     ON diku_mod_orders_storage.pieces CASCADE;
11:42:17 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_pieces_ol_version_trigger" for relation "diku_mod_orders_storage.pieces" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_pieces_ol_version_trigger     ON diku_mod_orders_storage.pieces CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.pieces_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.pieces_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.pieces_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_invoice_relationship', 'order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique ON diku_mod_orders_storage.order_invoice_relationship '
      || $rmb$(lower(f_unaccent(concat_space_sql(order_invoice_relationship.jsonb->>'purchaseOrderId' , order_invoice_relationship.jsonb->>'invoiceId'))))$rmb$      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_invoice_relationship', 'order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_invoiceId_idx_unique ON diku_mod_orders_storage.order_invoice_relationship '
      || $rmb$(lower(f_unaccent(concat_space_sql(order_invoice_relationship.jsonb->>'purchaseOrderId' , order_invoice_relationship.jsonb->>'invoiceId'))))$rmb$      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         ALTER TABLE diku_mod_orders_storage.order_invoice_relationship           ADD COLUMN IF NOT EXISTS purchaseOrderId UUID;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42701', message='column "purchaseorderid" of relation "order_invoice_relationship" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6291', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          ALTER TABLE diku_mod_orders_storage.order_invoice_relationship           ADD COLUMN IF NOT EXISTS purchaseOrderId UUID;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE order_invoice_relationship
              ADD CONSTRAINT purchaseOrderId_purchase_order_fkey
              FOREIGN KEY (purchaseOrderId) REFERENCES purchase_order;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE order_invoice_relationship
              ADD CONSTRAINT purchaseOrderId_purchase_order_fkey
              FOREIGN KEY (purchaseOrderId) REFERENCES purchase_order;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         CREATE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_idx           ON diku_mod_orders_storage.order_invoice_relationship (purchaseOrderId);11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42P07', message='relation "order_invoice_relationship_purchaseorderid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          CREATE INDEX IF NOT EXISTS order_invoice_relationship_purchaseOrderId_idx           ON diku_mod_orders_storage.order_invoice_relationship (purchaseOrderId);
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('order_invoice_relationship');
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('order_invoice_relationship');
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_order_invoice_relationship_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.purchaseOrderId = (NEW.jsonb->>'purchaseOrderId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_order_invoice_relationship_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.purchaseOrderId = (NEW.jsonb->>'purchaseOrderId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_order_invoice_relationship_references ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_order_invoice_relationship_references ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     CREATE TRIGGER update_order_invoice_relationship_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.order_invoice_relationship       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_order_invoice_relationship_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      CREATE TRIGGER update_order_invoice_relationship_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.order_invoice_relationship       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_order_invoice_relationship_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE order_invoice_relationship DROP CONSTRAINT IF EXISTS '
                || 'purchaseOrderId_purchase_order_fkey' || i;
      END LOOP;
    END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE order_invoice_relationship DROP CONSTRAINT IF EXISTS '
                || 'purchaseOrderId_purchase_order_fkey' || i;
      END LOOP;
    END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_invoice_relationship_set_md() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.order_invoice_relationship_set_md() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_invoice_relationship_set_md() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_order_invoice_relationship_md_trigger ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_invoice_relationship_md_trigger" for relation "diku_mod_orders_storage.order_invoice_relationship" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_order_invoice_relationship_md_trigger ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_order_invoice_relationship_md_json() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.set_order_invoice_relationship_md_json() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_order_invoice_relationship_md_json() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_order_invoice_relationship_md_json_trigger ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_invoice_relationship_md_json_trigger" for relation "diku_mod_orders_storage.order_invoice_relationship" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_order_invoice_relationship_md_json_trigger ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_order_invoice_relationship_ol_version_trigger     ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_invoice_relationship_ol_version_trigger" for relation "diku_mod_orders_storage.order_invoice_relationship" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_order_invoice_relationship_ol_version_trigger     ON diku_mod_orders_storage.order_invoice_relationship CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_invoice_relationship_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.order_invoice_relationship_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_invoice_relationship_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_isDeleted_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_isDeleted_idx ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(left(lower(f_unaccent(jsonb->>'isDeleted')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_isDeleted_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_isDeleted_idx ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(left(lower(f_unaccent(jsonb->>'isDeleted')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_protectRead_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_protectRead_idx ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(left(lower(f_unaccent(jsonb->>'protectRead')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_protectRead_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_protectRead_idx ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(left(lower(f_unaccent(jsonb->>'protectRead')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_acquisitions_unit_references ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_acquisitions_unit_references" for relation "diku_mod_orders_storage.acquisitions_unit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_acquisitions_unit_references ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisitions_unit_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_acquisitions_unit_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisitions_unit_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.acquisitions_unit_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.acquisitions_unit_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_acquisitions_unit_md_trigger ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [281423/proxy;533346/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  RestRouting          invoking getTenantByOperationId
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_acquisitions_unit_md_trigger ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_acquisitions_unit_md_trigger BEFORE INSERT ON diku_mod_orders_storage.acquisitions_unit    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.acquisitions_unit_set_md();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_acquisitions_unit_md_trigger BEFORE INSERT ON diku_mod_orders_storage.acquisitions_unit    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.acquisitions_unit_set_md();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_acquisitions_unit_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_acquisitions_unit_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_acquisitions_unit_md_json_trigger ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_acquisitions_unit_md_json_trigger ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_acquisitions_unit_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.acquisitions_unit   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_acquisitions_unit_md_json();
11:42:18 [281423/proxy;533346/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  LogUtil              10.0.2.15:58774 GET /_/tenant/d61c148a-5b56-47db-9cb2-30d239a49579 null HTTP_1_1 200 434 41 tid=diku OK
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_acquisitions_unit_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.acquisitions_unit   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_acquisitions_unit_md_json();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_acquisitions_unit_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisitions_unit_ol_version_trigger" for relation "diku_mod_orders_storage.acquisitions_unit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_acquisitions_unit_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisitions_unit_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit_membership', 'acquisitions_unit_membership_userId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership '
      || $rmb$(left(lower(f_unaccent(jsonb->>'userId')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit_membership', 'acquisitions_unit_membership_userId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership '
      || $rmb$(left(lower(f_unaccent(jsonb->>'userId')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         ALTER TABLE diku_mod_orders_storage.acquisitions_unit_membership           ADD COLUMN IF NOT EXISTS acquisitionsUnitId UUID;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42701', message='column "acquisitionsunitid" of relation "acquisitions_unit_membership" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='tablecmds.c', line='6291', routine='check_for_column_name_collision', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          ALTER TABLE diku_mod_orders_storage.acquisitions_unit_membership           ADD COLUMN IF NOT EXISTS acquisitionsUnitId UUID;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         DO $$
        BEGIN
          BEGIN
            ALTER TABLE acquisitions_unit_membership
              ADD CONSTRAINT acquisitionsUnitId_acquisitions_unit_fkey
              FOREIGN KEY (acquisitionsUnitId) REFERENCES acquisitions_unit;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          DO $$
        BEGIN
          BEGIN
            ALTER TABLE acquisitions_unit_membership
              ADD CONSTRAINT acquisitionsUnitId_acquisitions_unit_fkey
              FOREIGN KEY (acquisitionsUnitId) REFERENCES acquisitions_unit;
          EXCEPTION
            WHEN duplicate_object OR duplicate_table THEN NULL;
          END;
        END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_acquisitionsUnitId_idx           ON diku_mod_orders_storage.acquisitions_unit_membership (acquisitionsUnitId);
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='42P07', message='relation "acquisitions_unit_membership_acquisitionsunitid_idx" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='index.c', line='852', routine='index_create', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_acquisitionsUnitId_idx           ON diku_mod_orders_storage.acquisitions_unit_membership (acquisitionsUnitId);
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}         INSERT INTO rmb_internal_analyze VALUES ('acquisitions_unit_membership');
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed          INSERT INTO rmb_internal_analyze VALUES ('acquisitions_unit_membership');
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_acquisitions_unit_membership_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.acquisitionsUnitId = (NEW.jsonb->>'acquisitionsUnitId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_acquisitions_unit_membership_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.acquisitionsUnitId = (NEW.jsonb->>'acquisitionsUnitId');
      RETURN NEW;
    END;
    $$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_acquisitions_unit_membership_references ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_acquisitions_unit_membership_references ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     CREATE TRIGGER update_acquisitions_unit_membership_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.acquisitions_unit_membership       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_acquisitions_unit_membership_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      CREATE TRIGGER update_acquisitions_unit_membership_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.acquisitions_unit_membership       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_acquisitions_unit_membership_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE acquisitions_unit_membership DROP CONSTRAINT IF EXISTS '
                || 'acquisitionsUnitId_acquisitions_unit_fkey' || i;
      END LOOP;
    END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $$
    DECLARE
      version TEXT;
      i INT;
    BEGIN
      SELECT jsonb->>'rmbVersion' INTO version FROM rmb_internal;
      IF version !~ '^(\d\.|1\d\.|2\d\.|30\.0\.)' THEN
        RETURN;
      END IF;
      FOR i IN 1..50 LOOP
        EXECUTE 'ALTER TABLE acquisitions_unit_membership DROP CONSTRAINT IF EXISTS '
                || 'acquisitionsUnitId_acquisitions_unit_fkey' || i;
      END LOOP;
    END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.acquisitions_unit_membership_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.acquisitions_unit_membership_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_md_trigger ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_md_trigger ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_acquisitions_unit_membership_md_trigger BEFORE INSERT ON diku_mod_orders_storage.acquisitions_unit_membership    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.acquisitions_unit_membership_set_md();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_acquisitions_unit_membership_md_trigger BEFORE INSERT ON diku_mod_orders_storage.acquisitions_unit_membership    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.acquisitions_unit_membership_set_md();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_acquisitions_unit_membership_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_acquisitions_unit_membership_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_md_json_trigger ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_md_json_trigger ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_acquisitions_unit_membership_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.acquisitions_unit_membership   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_acquisitions_unit_membership_md_json();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_acquisitions_unit_membership_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.acquisitions_unit_membership   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_acquisitions_unit_membership_md_json();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisitions_unit_membership_ol_version_trigger" for relation "diku_mod_orders_storage.acquisitions_unit_membership" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_acquisitions_unit_membership_ol_version_trigger     ON diku_mod_orders_storage.acquisitions_unit_membership CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_membership_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisitions_unit_membership_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisitions_unit_membership_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_templates', 'order_templates_templateName_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates '
      || $rmb$(lower(f_unaccent(jsonb->>'templateName')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_templates', 'order_templates_templateName_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates '
      || $rmb$(lower(f_unaccent(jsonb->>'templateName')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_order_templates_references ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_order_templates_references" for relation "diku_mod_orders_storage.order_templates" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_order_templates_references ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_order_templates_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_order_templates_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_order_templates_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_templates_set_md() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.order_templates_set_md() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_templates_set_md() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_order_templates_md_trigger ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_templates_md_trigger" for relation "diku_mod_orders_storage.order_templates" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_order_templates_md_trigger ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_order_templates_md_json() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.set_order_templates_md_json() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_order_templates_md_json() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_order_templates_md_json_trigger ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_templates_md_json_trigger" for relation "diku_mod_orders_storage.order_templates" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_order_templates_md_json_trigger ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_order_templates_ol_version_trigger     ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_order_templates_ol_version_trigger" for relation "diku_mod_orders_storage.order_templates" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_order_templates_ol_version_trigger     ON diku_mod_orders_storage.order_templates CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_templates_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.order_templates_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.order_templates_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'reasons_for_closure', 'reasons_for_closure_reason_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure '
      || $rmb$(lower(f_unaccent(jsonb->>'reason')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'reasons_for_closure', 'reasons_for_closure_reason_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure '
      || $rmb$(lower(f_unaccent(jsonb->>'reason')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_reasons_for_closure_references ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_reasons_for_closure_references" for relation "diku_mod_orders_storage.reasons_for_closure" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_reasons_for_closure_references ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_reasons_for_closure_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_reasons_for_closure_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_reasons_for_closure_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.reasons_for_closure_set_md() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.reasons_for_closure_set_md() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.reasons_for_closure_set_md() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_reasons_for_closure_md_trigger ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_reasons_for_closure_md_trigger" for relation "diku_mod_orders_storage.reasons_for_closure" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_reasons_for_closure_md_trigger ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_reasons_for_closure_md_json() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.set_reasons_for_closure_md_json() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_reasons_for_closure_md_json() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_reasons_for_closure_md_json_trigger ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_reasons_for_closure_md_json_trigger" for relation "diku_mod_orders_storage.reasons_for_closure" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_reasons_for_closure_md_json_trigger ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_reasons_for_closure_ol_version_trigger     ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_reasons_for_closure_ol_version_trigger" for relation "diku_mod_orders_storage.reasons_for_closure" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_reasons_for_closure_ol_version_trigger     ON diku_mod_orders_storage.reasons_for_closure CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.reasons_for_closure_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.reasons_for_closure_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.reasons_for_closure_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'prefixes', 'prefixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'prefixes', 'prefixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_prefixes_references ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_prefixes_references" for relation "diku_mod_orders_storage.prefixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_prefixes_references ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_prefixes_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_prefixes_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_prefixes_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.prefixes_set_md() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.prefixes_set_md() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.prefixes_set_md() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_prefixes_md_trigger ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_prefixes_md_trigger" for relation "diku_mod_orders_storage.prefixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_prefixes_md_trigger ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_prefixes_md_json() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.set_prefixes_md_json() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_prefixes_md_json() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_prefixes_md_json_trigger ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_prefixes_md_json_trigger" for relation "diku_mod_orders_storage.prefixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_prefixes_md_json_trigger ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_prefixes_ol_version_trigger     ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_prefixes_ol_version_trigger" for relation "diku_mod_orders_storage.prefixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_prefixes_ol_version_trigger     ON diku_mod_orders_storage.prefixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.prefixes_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.prefixes_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.prefixes_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'suffixes', 'suffixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'suffixes', 'suffixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_suffixes_references ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_suffixes_references" for relation "diku_mod_orders_storage.suffixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_suffixes_references ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_suffixes_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_suffixes_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_suffixes_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.suffixes_set_md() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.suffixes_set_md() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.suffixes_set_md() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_suffixes_md_trigger ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_suffixes_md_trigger" for relation "diku_mod_orders_storage.suffixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_suffixes_md_trigger ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_suffixes_md_json() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.set_suffixes_md_json() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_suffixes_md_json() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_suffixes_md_json_trigger ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_suffixes_md_json_trigger" for relation "diku_mod_orders_storage.suffixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_suffixes_md_json_trigger ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_suffixes_ol_version_trigger     ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_suffixes_ol_version_trigger" for relation "diku_mod_orders_storage.suffixes" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_suffixes_ol_version_trigger     ON diku_mod_orders_storage.suffixes CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.suffixes_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.suffixes_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.suffixes_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisition_method', 'acquisition_method_value_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisition_method_value_idx_unique ON diku_mod_orders_storage.acquisition_method '
      || $rmb$(lower(f_unaccent(jsonb->>'value')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisition_method', 'acquisition_method_value_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisition_method_value_idx_unique ON diku_mod_orders_storage.acquisition_method '
      || $rmb$(lower(f_unaccent(jsonb->>'value')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_acquisition_method_references ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_acquisition_method_references" for relation "diku_mod_orders_storage.acquisition_method" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_acquisition_method_references ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisition_method_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_acquisition_method_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_acquisition_method_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisition_method_set_md() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisition_method_set_md() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisition_method_set_md() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_acquisition_method_md_trigger ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisition_method_md_trigger" for relation "diku_mod_orders_storage.acquisition_method" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_acquisition_method_md_trigger ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_acquisition_method_md_json() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.set_acquisition_method_md_json() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP FUNCTION IF EXISTS diku_mod_orders_storage.set_acquisition_method_md_json() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_acquisition_method_md_json_trigger ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisition_method_md_json_trigger" for relation "diku_mod_orders_storage.acquisition_method" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_acquisition_method_md_json_trigger ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_acquisition_method_ol_version_trigger     ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_acquisition_method_ol_version_trigger" for relation "diku_mod_orders_storage.acquisition_method" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_acquisition_method_ol_version_trigger     ON diku_mod_orders_storage.acquisition_method CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisition_method_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.acquisition_method_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.acquisition_method_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'export_history', 'export_history_exportDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS export_history_exportDate_idx ON diku_mod_orders_storage.export_history '
      || $rmb$(left(lower(f_unaccent(jsonb->>'exportDate')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'export_history', 'export_history_exportDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS export_history_exportDate_idx ON diku_mod_orders_storage.export_history '
      || $rmb$(left(lower(f_unaccent(jsonb->>'exportDate')),600))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'export_history', 'export_history_exportJobId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS export_history_exportJobId_idx_unique ON diku_mod_orders_storage.export_history '
      || $rmb$(lower(f_unaccent(jsonb->>'exportJobId')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'export_history', 'export_history_exportJobId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS export_history_exportJobId_idx_unique ON diku_mod_orders_storage.export_history '
      || $rmb$(lower(f_unaccent(jsonb->>'exportJobId')))$rmb$
      );
    END $do$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP TRIGGER IF EXISTS update_export_history_references ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "update_export_history_references" for relation "diku_mod_orders_storage.export_history" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP TRIGGER IF EXISTS update_export_history_references ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}     DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_export_history_references();
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.update_export_history_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed      DROP FUNCTION IF EXISTS diku_mod_orders_storage.update_export_history_references();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.export_history_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.export_history_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(createdDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_export_history_md_trigger ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_export_history_md_trigger ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_export_history_md_trigger BEFORE INSERT ON diku_mod_orders_storage.export_history    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.export_history_set_md();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_export_history_md_trigger BEFORE INSERT ON diku_mod_orders_storage.export_history    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.export_history_set_md();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_export_history_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;441759/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  RestRouting          invoking getTenantByOperationId
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_export_history_md_json() RETURNS TRIGGER AS $$
DECLARE
  input text;
  updatedDate timestamp;
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(to_char(NEW.creation_date, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;

  input = NEW.jsonb->'metadata'->>'updatedDate';
  if input IS NOT NULL then
    -- time stamp without time zone?
    IF (input::timestamp::timestamptz = input::timestamptz) THEN
      -- updatedDate already has no time zone, normalize using ::timestamp
      updatedDate = input::timestamp;
    ELSE
      -- updatedDate has a time zone string
      -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
      updatedDate = input::timestamptz AT TIME ZONE '+00';
    END IF;
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,updatedDate}', to_jsonb(to_char(updatedDate, 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"')));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql';
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DROP TRIGGER IF EXISTS set_export_history_md_json_trigger ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DROP TRIGGER IF EXISTS set_export_history_md_json_trigger ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TRIGGER set_export_history_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.export_history   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_export_history_md_json();
11:42:18 [281423/proxy;441759/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  LogUtil              10.0.2.15:58774 GET /_/tenant/d61c148a-5b56-47db-9cb2-30d239a49579 null HTTP_1_1 200 434 14 tid=diku OK
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TRIGGER set_export_history_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.export_history   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_export_history_md_json();
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP TRIGGER IF EXISTS set_export_history_ol_version_trigger     ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='trigger "set_export_history_ol_version_trigger" for relation "diku_mod_orders_storage.export_history" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP TRIGGER IF EXISTS set_export_history_ol_version_trigger     ON diku_mod_orders_storage.export_history CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {}   DROP FUNCTION IF EXISTS diku_mod_orders_storage.export_history_set_ol_version() CASCADE;
11:42:18 [] [] [] [] WARN  ?                    Backend notice: severity='NOTICE', code='00000', message='function diku_mod_orders_storage.export_history_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='491', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null'
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed    DROP FUNCTION IF EXISTS diku_mod_orders_storage.export_history_set_ol_version() CASCADE;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TABLE IF NOT EXISTS outbox_event_log (   event_id uuid NOT NULL PRIMARY KEY,   entity_type text NOT NULL,   action text NOT NULL,   payload jsonb );
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TABLE IF NOT EXISTS outbox_event_log (   event_id uuid NOT NULL PRIMARY KEY,   entity_type text NOT NULL,   action text NOT NULL,   payload jsonb );
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} CREATE TABLE IF NOT EXISTS internal_lock (   lock_name text NOT NULL PRIMARY KEY );
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  CREATE TABLE IF NOT EXISTS internal_lock (   lock_name text NOT NULL PRIMARY KEY );
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} INSERT INTO internal_lock(lock_name) VALUES ('audit_outbox') ON CONFLICT DO NOTHING;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  INSERT INTO internal_lock(lock_name) VALUES ('audit_outbox') ON CONFLICT DO NOTHING;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DO $$DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM diku_mod_orders_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE 'DROP INDEX IF EXISTS ' || aname;
  END LOOP;
END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM diku_mod_orders_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE 'DROP INDEX IF EXISTS ' || aname;
  END LOOP;
END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DO $$DECLARE
  version TEXT;
  i RECORD;
  newindexdef TEXT;
BEGIN
  SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_orders_storage.rmb_internal;
  IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN
    -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x
    RETURN;
  END IF;
  FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_orders_storage'
  LOOP
    newindexdef := regexp_replace(i.indexdef,
      -- \m = beginning of a word, \M = end of a word
      '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M',
      'diku_mod_orders_storage.\1',
      'g');
    IF newindexdef <> i.indexdef THEN
      EXECUTE 'DROP INDEX ' || i.indexname;
      EXECUTE newindexdef;
      EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename;
    END IF;
  END LOOP;
END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DO $$
DECLARE
  version TEXT;
  i RECORD;
  newindexdef TEXT;
BEGIN
  SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_orders_storage.rmb_internal;
  IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN
    -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x
    RETURN;
  END IF;
  FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_orders_storage'
  LOOP
    newindexdef := regexp_replace(i.indexdef,
      -- \m = beginning of a word, \M = end of a word
      '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M',
      'diku_mod_orders_storage.\1',
      'g');
    IF newindexdef <> i.indexdef THEN
      EXECUTE 'DROP INDEX ' || i.indexname;
      EXECUTE newindexdef;
      EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename;
    END IF;
  END LOOP;
END $$;
11:42:18 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} DO $$DECLARE
  t TEXT;
BEGIN
  FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze
  LOOP
    EXECUTE 'ANALYZE ' || t;
  END LOOP;
END $$;
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  DO $$
DECLARE
  t TEXT;
BEGIN
  FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze
  LOOP
    EXECUTE 'ANALYZE ' || t;
  END LOOP;
END $$;
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} TRUNCATE rmb_internal_analyze;
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  TRUNCATE rmb_internal_analyze;
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_orders_storage TO diku_mod_orders_storage;
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_orders_storage TO diku_mod_orders_storage;
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       trying to execute: {} UPDATE diku_mod_orders_storage.rmb_internal   SET jsonb = jsonb || jsonb_build_object(     'rmbVersion', '35.0.1',     'moduleVersion', 'mod-orders-storage-13.4.1-SNAPSHOT.293',     'schemaJson', $mainftl${
  "exactCount" : 40000,
  "scripts": [
    {
      "run": "after",
      "snippetPath": "views/receiving_history_view.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS orders_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS order_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS purchase_orders_view;",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS po_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/9.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-9.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/update_title.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.1"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/pieces_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/po_line_sync_fund_code.sql",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/purchase_order_encumber_flag.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/pol_status_for_ongoing_orders.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/reference_number_migration.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/delete_order_invoices_relation_duplicates.ftl",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.1.0/restriction_for_fund_codes.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.2.0/update_acquisition_method.ftl",
      "fromModuleVersion": "mod-orders-storage-13.2.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.2.0/update_ongoing_manual_renewal.sql",
      "fromModuleVersion": "mod-orders-storage-13.2.2"
    },
    {
      "run": "after",
      "snippetPath": "tables/create_audit_outbox_table.sql",
      "fromModuleVersion": "mod-orders-storage-13.5.0"
    },
    {
      "run": "after",
      "snippetPath": "tables/create_internal_lock_table.sql",
      "fromModuleVersion": "mod-orders-storage-13.5.0"
    }
  ],
  "tables": [
    {
      "tableName": "alert",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "reporting_code",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "purchase_order",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "withMetadata": true,
      "customSnippetPath": "purchase_order_table.sql",
      "index": [
        {
          "fieldName": "acqUnitIds",
          "caseSensitive": false
        },
        {
          "fieldName": "assignedTo",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdByUserId",
          "caseSensitive": false
        },
        {
          "fieldName": "workflowStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "approved",
          "caseSensitive": false
        },
        {
          "fieldName": "dateOrdered",
          "caseSensitive": false
        },
        {
          "fieldName": "orderType",
          "caseSensitive": false
        },
        {
          "fieldName": "reEncumber",
          "caseSensitive": false
        },
        {
          "fieldName": "renewal.manualRenewal",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.renewalDate",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.reviewPeriod",
          "tOps": "DELETE"
        },
        {
          "fieldName": "ongoing.manualRenewal",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.renewalDate",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.reviewPeriod",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "closeReason.reason"
        },
        {
          "fieldName": "closeReason.note"
        },
        {
          "fieldName": "acqUnitIds"
        }
      ]
    },
    {
      "tableName": "po_line",
      "fromModuleVersion": "mod-orders-storage-12.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "poLine",
          "targetTableAlias": "purchaseOrder"
        }
      ],
      "index": [
        {
          "fieldName": "eresource.accessProvider",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.activated",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.expectedActivation",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.trial",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionFrom",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionTo",
          "caseSensitive": false
        },
        {
          "fieldName": "location.locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.receiptDue",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.expectedReceiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.volumes",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.grace",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.sent",
          "caseSensitive": false
        },
        {
          "fieldName": "collection",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "paymentStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "orderFormat",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "rush",
          "caseSensitive": false
        },
        {
          "fieldName": "source",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "publisher",
          "tOps": "DELETE"
        },
        {
          "fieldName": "donor",
          "tOps": "DELETE"
        },
        {
          "fieldName": "selector",
          "tOps": "DELETE"
        },
        {
          "fieldName": "vendorDetail.referenceNumbers",
          "caseSensitive": false,
          "removeAccents": true,
          "arraySubfield": "refNumber",
          "arrayModifiers": ["refNumberType", "vendorDetailsSource"]
        }
      ],
      "ginIndex": [
        {
          "fieldName": "fundDistribution.code",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "details.productIds",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "title",
          "tOps": "DELETE"
        },
        {
          "fieldName": "titleOrPackage",
          "caseSensitive": false,
          "removeAccents": true,
          "tOps": "ADD"
        },
        {
          "fieldName": "vendorDetail.vendorAccount",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "tags",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "contributors",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "requester",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "poLineNumber",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "publisher",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "donor",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "selector",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "vendorDetail.referenceNumbers",
          "caseSensitive": false,
          "removeAccents": true,
          "arraySubfield": "refNumber",
          "arrayModifiers": ["refNumberType", "vendorDetailsSource"]
        },
        {
          "fieldName": "physical.volumes",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "titles",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable":      "po_line",
          "targetTableAlias": "poLine",
          "tableAlias": "titles",
          "tOps": "ADD"
        },
        {
          "targetPath": ["poLineId", "purchaseOrderId"],
          "targetTable":      "purchase_order",
          "targetTableAlias": "purchaseOrder",
          "tableAlias": "titles"
        }
      ]
    },
    {
      "tableName": "pieces",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable": "po_line"
        },
        {
          "fieldName": "titleId",
          "targetTable": "titles",
          "targetTableAlias": "titles",
          "tableAlias": "pieces",
          "tOps": "ADD"
        }
      ],
      "index": [
        {
          "fieldName": "format",
          "caseSensitive": false
        },
        {
          "fieldName": "itemId",
          "caseSensitive": false
        },
        {
          "fieldName": "locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "receivingStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "receivedDate",
          "caseSensitive": false
        },
        {
          "fieldName": "supplement",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "comment"
        }
      ],
      "ginIndex": [
        {
          "fieldName": "caption",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "order_invoice_relationship",
      "fromModuleVersion": "mod-orders-storage-12.1.0",
      "withMetadata": false,
      "uniqueIndex": [
        {
          "fieldName": "purchaseOrderId_invoiceId",
          "multiFieldNames": "purchaseOrderId,invoiceId",
          "tOps": "ADD"
        }
      ],
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "orderInvoiceRel",
          "targetTableAlias": "purchase_order",
          "tOps": "ADD"
        }
      ]
    },
    {
      "tableName": "acquisitions_unit",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "uniqueIndex": [
        {
            "fieldName" : "name"
        }
      ],
      "index": [
        {
          "fieldName": "isDeleted",
          "caseSensitive": false
        },
        {
          "fieldName": "protectRead",
          "caseSensitive": false
        }
      ]
    },
    {
      "tableName": "acquisitions_unit_assignments",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "mode": "delete",
      "auditingTableName": "NOT_EXISTING_AUDITING_TABLE"
    },
    {
    "tableName": "acquisitions_unit_membership",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "acquisitionsUnitId",
          "targetTable": "acquisitions_unit"
        }
      ],
      "index": [
         {
            "fieldName" : "userId"
         }
       ]
     },
     {
      "tableName": "order_templates",
      "fromModuleVersion": "mod-orders-storage-8.0.0",
      "withMetadata": false,
      "uniqueIndex": [
         {
           "fieldName" : "templateName"
         }
       ]
     },
    {
      "tableName": "reasons_for_closure",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "reason"
        }
      ]
    },
    {
      "tableName": "prefixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "suffixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "acquisition_method",
      "fromModuleVersion": "mod-orders-storage-13.2.0",
      "uniqueIndex": [
        {
          "fieldName" : "value"
        }
      ]
    },
    {
      "tableName": "export_history",
      "fromModuleVersion": "mod-orders-storage-13.2.0",
      "withMetadata": true,
      "index": [
        {
          "fieldName": "exportDate",
          "caseSensitive": false
        }
      ],
      "uniqueIndex": [
        {
          "fieldName": "exportJobId",
          "caseSensitive": false
        }
      ]
    }
  ]
}
$mainftl$);
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Successfully executed  UPDATE diku_mod_orders_storage.rmb_internal   SET jsonb = jsonb || jsonb_build_object(     'rmbVersion', '35.0.1',     'moduleVersion', 'mod-orders-storage-13.4.1-SNAPSHOT.293',     'schemaJson', $mainftl${
  "exactCount" : 40000,
  "scripts": [
    {
      "run": "after",
      "snippetPath": "views/receiving_history_view.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS orders_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS order_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS purchase_orders_view;",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS po_lines_view;",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/9.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-9.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/po_line_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/10.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/purchase_order_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/update_title.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.1"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/11.0.0/pieces_table.sql",
      "fromModuleVersion": "mod-orders-storage-11.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/po_line_sync_fund_code.sql",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/purchase_order_encumber_flag.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/pol_status_for_ongoing_orders.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/reference_number_migration.sql",
      "fromModuleVersion": "mod-orders-storage-12.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/12.0.0/delete_order_invoices_relation_duplicates.ftl",
      "fromModuleVersion": "mod-orders-storage-12.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.1.0/restriction_for_fund_codes.sql",
      "fromModuleVersion": "mod-orders-storage-13.1.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.2.0/update_acquisition_method.ftl",
      "fromModuleVersion": "mod-orders-storage-13.2.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/13.2.0/update_ongoing_manual_renewal.sql",
      "fromModuleVersion": "mod-orders-storage-13.2.2"
    },
    {
      "run": "after",
      "snippetPath": "tables/create_audit_outbox_table.sql",
      "fromModuleVersion": "mod-orders-storage-13.5.0"
    },
    {
      "run": "after",
      "snippetPath": "tables/create_internal_lock_table.sql",
      "fromModuleVersion": "mod-orders-storage-13.5.0"
    }
  ],
  "tables": [
    {
      "tableName": "alert",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "reporting_code",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true
    },
    {
      "tableName": "purchase_order",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "withMetadata": true,
      "customSnippetPath": "purchase_order_table.sql",
      "index": [
        {
          "fieldName": "acqUnitIds",
          "caseSensitive": false
        },
        {
          "fieldName": "assignedTo",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdByUserId",
          "caseSensitive": false
        },
        {
          "fieldName": "workflowStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "approved",
          "caseSensitive": false
        },
        {
          "fieldName": "dateOrdered",
          "caseSensitive": false
        },
        {
          "fieldName": "orderType",
          "caseSensitive": false
        },
        {
          "fieldName": "reEncumber",
          "caseSensitive": false
        },
        {
          "fieldName": "renewal.manualRenewal",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.renewalDate",
          "tOps": "DELETE"
        },
        {
          "fieldName": "renewal.reviewPeriod",
          "tOps": "DELETE"
        },
        {
          "fieldName": "ongoing.manualRenewal",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.renewalDate",
          "caseSensitive": false
        },
        {
          "fieldName": "ongoing.reviewPeriod",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "closeReason.reason"
        },
        {
          "fieldName": "closeReason.note"
        },
        {
          "fieldName": "acqUnitIds"
        }
      ]
    },
    {
      "tableName": "po_line",
      "fromModuleVersion": "mod-orders-storage-12.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "poLine",
          "targetTableAlias": "purchaseOrder"
        }
      ],
      "index": [
        {
          "fieldName": "eresource.accessProvider",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.activated",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.expectedActivation",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.trial",
          "caseSensitive": false
        },
        {
          "fieldName": "eresource.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionFrom",
          "caseSensitive": false
        },
        {
          "fieldName": "details.subscriptionTo",
          "caseSensitive": false
        },
        {
          "fieldName": "location.locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.receiptDue",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.expectedReceiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.volumes",
          "caseSensitive": false
        },
        {
          "fieldName": "physical.materialType",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.grace",
          "caseSensitive": false
        },
        {
          "fieldName": "claim.sent",
          "caseSensitive": false
        },
        {
          "fieldName": "collection",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "paymentStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "orderFormat",
          "caseSensitive": false
        },
        {
          "fieldName": "receiptDate",
          "caseSensitive": false
        },
        {
          "fieldName": "metadata.createdDate",
          "caseSensitive": false
        },
        {
          "fieldName": "rush",
          "caseSensitive": false
        },
        {
          "fieldName": "source",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "publisher",
          "tOps": "DELETE"
        },
        {
          "fieldName": "donor",
          "tOps": "DELETE"
        },
        {
          "fieldName": "selector",
          "tOps": "DELETE"
        },
        {
          "fieldName": "vendorDetail.referenceNumbers",
          "caseSensitive": false,
          "removeAccents": true,
          "arraySubfield": "refNumber",
          "arrayModifiers": ["refNumberType", "vendorDetailsSource"]
        }
      ],
      "ginIndex": [
        {
          "fieldName": "fundDistribution.code",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "details.productIds",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "title",
          "tOps": "DELETE"
        },
        {
          "fieldName": "titleOrPackage",
          "caseSensitive": false,
          "removeAccents": true,
          "tOps": "ADD"
        },
        {
          "fieldName": "vendorDetail.vendorAccount",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "tags",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "contributors",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "requester",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "poLineNumber",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "publisher",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "donor",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "selector",
          "caseSensitive": false,
          "removeAccents": true
        },
        {
          "fieldName": "vendorDetail.referenceNumbers",
          "caseSensitive": false,
          "removeAccents": true,
          "arraySubfield": "refNumber",
          "arrayModifiers": ["refNumberType", "vendorDetailsSource"]
        },
        {
          "fieldName": "physical.volumes",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "titles",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable":      "po_line",
          "targetTableAlias": "poLine",
          "tableAlias": "titles",
          "tOps": "ADD"
        },
        {
          "targetPath": ["poLineId", "purchaseOrderId"],
          "targetTable":      "purchase_order",
          "targetTableAlias": "purchaseOrder",
          "tableAlias": "titles"
        }
      ]
    },
    {
      "tableName": "pieces",
      "fromModuleVersion": "mod-orders-storage-11.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "poLineId",
          "targetTable": "po_line"
        },
        {
          "fieldName": "titleId",
          "targetTable": "titles",
          "targetTableAlias": "titles",
          "tableAlias": "pieces",
          "tOps": "ADD"
        }
      ],
      "index": [
        {
          "fieldName": "format",
          "caseSensitive": false
        },
        {
          "fieldName": "itemId",
          "caseSensitive": false
        },
        {
          "fieldName": "locationId",
          "caseSensitive": false
        },
        {
          "fieldName": "receivingStatus",
          "caseSensitive": false
        },
        {
          "fieldName": "receivedDate",
          "caseSensitive": false
        },
        {
          "fieldName": "supplement",
          "caseSensitive": false
        }
      ],
      "fullTextIndex": [
        {
          "fieldName": "comment"
        }
      ],
      "ginIndex": [
        {
          "fieldName": "caption",
          "caseSensitive": false,
          "removeAccents": true
        }
      ]
    },
    {
      "tableName": "order_invoice_relationship",
      "fromModuleVersion": "mod-orders-storage-12.1.0",
      "withMetadata": false,
      "uniqueIndex": [
        {
          "fieldName": "purchaseOrderId_invoiceId",
          "multiFieldNames": "purchaseOrderId,invoiceId",
          "tOps": "ADD"
        }
      ],
      "foreignKeys": [
        {
          "fieldName": "purchaseOrderId",
          "targetTable": "purchase_order",
          "tableAlias": "orderInvoiceRel",
          "targetTableAlias": "purchase_order",
          "tOps": "ADD"
        }
      ]
    },
    {
      "tableName": "acquisitions_unit",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "uniqueIndex": [
        {
            "fieldName" : "name"
        }
      ],
      "index": [
        {
          "fieldName": "isDeleted",
          "caseSensitive": false
        },
        {
          "fieldName": "protectRead",
          "caseSensitive": false
        }
      ]
    },
    {
      "tableName": "acquisitions_unit_assignments",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "mode": "delete",
      "auditingTableName": "NOT_EXISTING_AUDITING_TABLE"
    },
    {
    "tableName": "acquisitions_unit_membership",
      "fromModuleVersion": "mod-orders-storage-7.0.0",
      "withMetadata": true,
      "foreignKeys": [
        {
          "fieldName": "acquisitionsUnitId",
          "targetTable": "acquisitions_unit"
        }
      ],
      "index": [
         {
            "fieldName" : "userId"
         }
       ]
     },
     {
      "tableName": "order_templates",
      "fromModuleVersion": "mod-orders-storage-8.0.0",
      "withMetadata": false,
      "uniqueIndex": [
         {
           "fieldName" : "templateName"
         }
       ]
     },
    {
      "tableName": "reasons_for_closure",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "reason"
        }
      ]
    },
    {
      "tableName": "prefixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "suffixes",
      "fromModuleVersion": "mod-orders-storage-10.0.0",
      "uniqueIndex": [
        {
          "fieldName" : "name"
        }
      ]
    },
    {
      "tableName": "acquisition_method",
      "fromModuleVersion": "mod-orders-storage-13.2.0",
      "uniqueIndex": [
        {
          "fieldName" : "value"
        }
      ]
    },
    {
      "tableName": "export_history",
      "fromModuleVersion": "mod-orders-storage-13.2.0",
      "withMetadata": true,
      "index": [
        {
          "fieldName": "exportDate",
          "caseSensitive": false
        }
      ],
      "uniqueIndex": [
        {
          "fieldName": "exportJobId",
          "caseSensitive": false
        }
      ]
    }
  ]
}
$mainftl$);
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  TenantReferenceAPI   postTenant
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  RestRouting          invoking getOrdersStorageConfigurationReasonsForClosureById
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       DB config read from environment variables
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       Using schema: diku
11:42:19 [281423/proxy;859704/tenant] [diku] [2656dbe1-6f2d-584d-8f9d-6b5ff27dab88] [mod_orders_storage] INFO  PostgresClient       postgreSQLClientConfig = {"port":5432,"username":"diku_mod_orders_storage","host":"10.0.2.15","database":"okapi_modules","password":"...","postgres_tester":false}