name,def,remove
purchase_order_acqUnitIds_idx,"CREATE INDEX IF NOT EXISTS purchase_order_acqUnitIds_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''acqUnitIds'')),600))",f
purchase_order_assignedTo_idx,"CREATE INDEX IF NOT EXISTS purchase_order_assignedTo_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''assignedTo'')),600))",f
purchase_order_metadata_createdDate_idx,"CREATE INDEX IF NOT EXISTS purchase_order_metadata_createdDate_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->''metadata''->>''createdDate'')),600))",f
purchase_order_metadata_createdByUserId_idx,"CREATE INDEX IF NOT EXISTS purchase_order_metadata_createdByUserId_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->''metadata''->>''createdByUserId'')),600))",f
purchase_order_workflowStatus_idx,"CREATE INDEX IF NOT EXISTS purchase_order_workflowStatus_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''workflowStatus'')),600))",f
purchase_order_approved_idx,"CREATE INDEX IF NOT EXISTS purchase_order_approved_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''approved'')),600))",f
purchase_order_dateOrdered_idx,"CREATE INDEX IF NOT EXISTS purchase_order_dateOrdered_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''dateOrdered'')),600))",f
purchase_order_orderType_idx,"CREATE INDEX IF NOT EXISTS purchase_order_orderType_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''orderType'')),600))",f
purchase_order_reEncumber_idx,"CREATE INDEX IF NOT EXISTS purchase_order_reEncumber_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->>''reEncumber'')),600))",f
purchase_order_ongoing_manualRenewal_idx,"CREATE INDEX IF NOT EXISTS purchase_order_ongoing_manualRenewal_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->''ongoing''->>''manualRenewal'')),600))",f
purchase_order_ongoing_renewalDate_idx,"CREATE INDEX IF NOT EXISTS purchase_order_ongoing_renewalDate_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->''ongoing''->>''renewalDate'')),600))",f
purchase_order_ongoing_reviewPeriod_idx,"CREATE INDEX IF NOT EXISTS purchase_order_ongoing_reviewPeriod_idx ON diku_mod_orders_storage.purchase_order (left(lower(f_unaccent(jsonb->''ongoing''->>''reviewPeriod'')),600))",f
purchase_order_closeReason_reason_idx_ft,"CREATE INDEX IF NOT EXISTS purchase_order_closeReason_reason_idx_ft ON diku_mod_orders_storage.purchase_order USING GIN ( to_tsvector(''simple'', f_unaccent(jsonb->''closeReason''->>''reason'')) )",f
purchase_order_closeReason_note_idx_ft,"CREATE INDEX IF NOT EXISTS purchase_order_closeReason_note_idx_ft ON diku_mod_orders_storage.purchase_order USING GIN ( to_tsvector(''simple'', f_unaccent(jsonb->''closeReason''->>''note'')) )",f
po_line_eresource_accessProvider_idx,"CREATE INDEX IF NOT EXISTS po_line_eresource_accessProvider_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''eresource''->>''accessProvider'')),600))",f
po_line_eresource_activated_idx,"CREATE INDEX IF NOT EXISTS po_line_eresource_activated_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''eresource''->>''activated'')),600))",f
po_line_eresource_expectedActivation_idx,"CREATE INDEX IF NOT EXISTS po_line_eresource_expectedActivation_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''eresource''->>''expectedActivation'')),600))",f
po_line_eresource_trial_idx,"CREATE INDEX IF NOT EXISTS po_line_eresource_trial_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''eresource''->>''trial'')),600))",f
po_line_eresource_materialType_idx,"CREATE INDEX IF NOT EXISTS po_line_eresource_materialType_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''eresource''->>''materialType'')),600))",f
po_line_details_subscriptionFrom_idx,"CREATE INDEX IF NOT EXISTS po_line_details_subscriptionFrom_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''details''->>''subscriptionFrom'')),600))",f
po_line_details_subscriptionTo_idx,"CREATE INDEX IF NOT EXISTS po_line_details_subscriptionTo_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''details''->>''subscriptionTo'')),600))",f
po_line_location_locationId_idx,"CREATE INDEX IF NOT EXISTS po_line_location_locationId_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''location''->>''locationId'')),600))",f
po_line_physical_receiptDue_idx,"CREATE INDEX IF NOT EXISTS po_line_physical_receiptDue_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''physical''->>''receiptDue'')),600))",f
po_line_physical_expectedReceiptDate_idx,"CREATE INDEX IF NOT EXISTS po_line_physical_expectedReceiptDate_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''physical''->>''expectedReceiptDate'')),600))",f
po_line_physical_volumes_idx,"CREATE INDEX IF NOT EXISTS po_line_physical_volumes_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''physical''->>''volumes'')),600))",f
po_line_physical_materialType_idx,"CREATE INDEX IF NOT EXISTS po_line_physical_materialType_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''physical''->>''materialType'')),600))",f
po_line_claim_grace_idx,"CREATE INDEX IF NOT EXISTS po_line_claim_grace_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''claim''->>''grace'')),600))",f
po_line_claim_sent_idx,"CREATE INDEX IF NOT EXISTS po_line_claim_sent_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''claim''->>''sent'')),600))",f
po_line_collection_idx,"CREATE INDEX IF NOT EXISTS po_line_collection_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''collection'')),600))",f
po_line_receiptStatus_idx,"CREATE INDEX IF NOT EXISTS po_line_receiptStatus_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''receiptStatus'')),600))",f
po_line_paymentStatus_idx,"CREATE INDEX IF NOT EXISTS po_line_paymentStatus_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''paymentStatus'')),600))",f
po_line_orderFormat_idx,"CREATE INDEX IF NOT EXISTS po_line_orderFormat_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''orderFormat'')),600))",f
po_line_receiptDate_idx,"CREATE INDEX IF NOT EXISTS po_line_receiptDate_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''receiptDate'')),600))",f
po_line_metadata_createdDate_idx,"CREATE INDEX IF NOT EXISTS po_line_metadata_createdDate_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->''metadata''->>''createdDate'')),600))",f
po_line_rush_idx,"CREATE INDEX IF NOT EXISTS po_line_rush_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''rush'')),600))",f
po_line_source_idx,"CREATE INDEX IF NOT EXISTS po_line_source_idx ON diku_mod_orders_storage.po_line (left(lower(f_unaccent(jsonb->>''source'')),600))",f
po_line_fundDistribution_code_idx_gin,CREATE INDEX IF NOT EXISTS po_line_fundDistribution_code_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->'fundDistribution'->>'code'))) public.gin_trgm_ops),f
po_line_details_productIds_idx_gin,CREATE INDEX IF NOT EXISTS po_line_details_productIds_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->'details'->>'productIds'))) public.gin_trgm_ops),f
po_line_titleOrPackage_idx_gin,CREATE INDEX IF NOT EXISTS po_line_titleOrPackage_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->>'titleOrPackage'))) public.gin_trgm_ops),f
po_line_vendor_vendorAccount_idx_gin,CREATE INDEX IF NOT EXISTS po_line_vendor_vendorAccount_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->'vendor'->>'vendorAccount'))) public.gin_trgm_ops),f
po_line_vendor_refNumber_idx_gin,CREATE INDEX IF NOT EXISTS po_line_vendor_refNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->'vendor'->>'refNumber'))) public.gin_trgm_ops),f
po_line_tags_idx_gin,CREATE INDEX IF NOT EXISTS po_line_tags_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->>'tags'))) public.gin_trgm_ops),f
po_line_contributors_idx_gin,CREATE INDEX IF NOT EXISTS po_line_contributors_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->>'contributors'))) public.gin_trgm_ops),f
po_line_requester_idx_gin,CREATE INDEX IF NOT EXISTS po_line_requester_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->>'requester'))) public.gin_trgm_ops),f
po_line_poLineNumber_idx_gin,CREATE INDEX IF NOT EXISTS po_line_poLineNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN ((lower(f_unaccent(jsonb->>'poLineNumber'))) public.gin_trgm_ops),f
po_line_publisher_idx_ft,"CREATE INDEX IF NOT EXISTS po_line_publisher_idx_ft ON diku_mod_orders_storage.po_line USING GIN ( to_tsvector(''simple'', f_unaccent(jsonb->>''publisher'')) )",f
po_line_donor_idx_ft,"CREATE INDEX IF NOT EXISTS po_line_donor_idx_ft ON diku_mod_orders_storage.po_line USING GIN ( to_tsvector(''simple'', f_unaccent(jsonb->>''donor'')) )",f
po_line_selector_idx_ft,"CREATE INDEX IF NOT EXISTS po_line_selector_idx_ft ON diku_mod_orders_storage.po_line USING GIN ( to_tsvector(''simple'', f_unaccent(jsonb->>''selector'')) )",f
pieces_format_idx,"CREATE INDEX IF NOT EXISTS pieces_format_idx ON diku_mod_orders_storage.pieces (left(lower(f_unaccent(jsonb->>''format'')),600))",f
pieces_itemId_idx,"CREATE INDEX IF NOT EXISTS pieces_itemId_idx ON diku_mod_orders_storage.pieces (left(lower(f_unaccent(jsonb->>''itemId'')),600))",f
pieces_locationId_idx,"CREATE INDEX IF NOT EXISTS pieces_locationId_idx ON diku_mod_orders_storage.pieces (left(lower(f_unaccent(jsonb->>''locationId'')),600))",f
pieces_receivingStatus_idx,"CREATE INDEX IF NOT EXISTS pieces_receivingStatus_idx ON diku_mod_orders_storage.pieces (left(lower(f_unaccent(jsonb->>''receivingStatus'')),600))",f
pieces_receivedDate_idx,"CREATE INDEX IF NOT EXISTS pieces_receivedDate_idx ON diku_mod_orders_storage.pieces (left(lower(f_unaccent(jsonb->>''receivedDate'')),600))",f
pieces_supplement_idx,"CREATE INDEX IF NOT EXISTS pieces_supplement_idx ON diku_mod_orders_storage.pieces (left(lower(f_unaccent(jsonb->>''supplement'')),600))",f
pieces_caption_idx_gin,CREATE INDEX IF NOT EXISTS pieces_caption_idx_gin ON diku_mod_orders_storage.pieces USING GIN ((lower(f_unaccent(jsonb->>'caption'))) public.gin_trgm_ops),f
pieces_comment_idx_ft,"CREATE INDEX IF NOT EXISTS pieces_comment_idx_ft ON diku_mod_orders_storage.pieces USING GIN ( to_tsvector(''simple'', f_unaccent(jsonb->>''comment'')) )",f
acquisitions_unit_name_idx_unique,CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit (lower(f_unaccent(jsonb->>'name'))),f
acquisitions_unit_membership_userId_idx,"CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership (left(lower(f_unaccent(jsonb->>''userId'')),600))",f
order_templates_templateName_idx_unique,CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates (lower(f_unaccent(jsonb->>'templateName'))),f
reasons_for_closure_reason_idx_unique,CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure (lower(f_unaccent(jsonb->>'reason'))),f
prefixes_name_idx_unique,CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes (lower(f_unaccent(jsonb->>'name'))),f
suffixes_name_idx_unique,CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes (lower(f_unaccent(jsonb->>'name'))),f