CREATE INDEX cif_contact_reference_idx ON `accor`(DISTINCT ARRAY v.externalid FOR v IN cif_contact_reference END) WHERE typed="contact" WITH {"num_replica":1};

CREATE INDEX contact_like_lastnameupper_idx on `accor`(distinct array array_element for array_element in suffixes(lastnameupper) end) where typed = "contact" WITH {"num_replica":1};
CREATE INDEX contact_like_firstnameupper_idx on `accor`(distinct array array_element for array_element in suffixes(firstnameupper) end) where typed = "contact" WITH {"num_replica":1};

CREATE INDEX contact_alternative_email_idx ON `accor`(DISTINCT ARRAY v.comadremail FOR v IN communication_addresses END) WHERE typed="contact" WITH {"num_replica":1};
CREATE INDEX contact_personalcountry_idx ON `accor`(DISTINCT ARRAY v.persocountry FOR v IN personnal_addresses END) WHERE typed="contact" WITH {"num_replica":1};
CREATE INDEX contact_personalpostalcode_idx ON `accor`(DISTINCT ARRAY v.persopostalcode FOR v IN personnal_addresses END) WHERE typed="contact" WITH {"num_replica":1};

CREATE INDEX loyalty_cards_contact_idx ON `accor`(`contactid`) WHERE (`typed` = "loyalty_card")  WITH {"num_replica":1}
CREATE INDEX access_logs_contact_idx ON `accor`(`contactid`) WHERE (`typed` = "connexion_date")  WITH {"num_replica":1}