Missing indexes on dolibarr database
List of DDL to create missing indexes on foreign keys.
| Table | Missing index |
|---|---|
| llx_prelevement_facture | CREATE INDEX idx_llx_prelevement_facture_fk_prelevement_lignes ON llx_prelevement_facture (fk_prelevement_lignes) |
| llx_actioncomm_extrafields | CREATE INDEX idx_llx_actioncomm_extrafields_rowid ON llx_actioncomm_extrafields (rowid) |
| llx_stock_mouvement | CREATE INDEX idx_llx_stock_mouvement_rowid ON llx_stock_mouvement (rowid) |
| llx_notify | CREATE INDEX idx_llx_notify_rowid ON llx_notify (rowid) |
| llx_contratdet_log | CREATE INDEX idx_llx_contratdet_log_rowid ON llx_contratdet_log (rowid) |
| llx_contratdet | CREATE INDEX idx_llx_contratdet_rowid ON llx_contratdet (rowid) |
| llx_agefodd_session | CREATE INDEX idx_llx_agefodd_session_fk_formation_catalogue ON llx_agefodd_session (fk_formation_catalogue) |
| llx_agefodd_formation_catalogue_extrafields | CREATE INDEX idx_llx_agefodd_formation_catalogue_extrafields_rowid ON llx_agefodd_formation_catalogue_extrafields (rowid) |
| llx_mailing | CREATE INDEX idx_llx_mailing_rowid ON llx_mailing (rowid) |
| llx_texts | CREATE INDEX idx_llx_texts_rowid ON llx_texts (rowid) |
| llx_agefodd_session_contact | CREATE INDEX idx_llx_agefodd_session_contact_rowid ON llx_agefodd_session_contact (rowid) |
| llx_expedition | CREATE INDEX idx_llx_expedition_fk_shipping_method ON llx_expedition (fk_shipping_method) |
| llx_paiement_facture | CREATE INDEX idx_llx_paiement_facture_fk_facture ON llx_paiement_facture (fk_facture) |
| llx_product_fournisseur_price | CREATE INDEX idx_llx_product_fournisseur_price_rowid ON llx_product_fournisseur_price (rowid) |
| llx_accountingaccount | CREATE INDEX idx_llx_accountingaccount_fk_pcg_version ON llx_accountingaccount (fk_pcg_version) |
| llx_projet_extrafields | CREATE INDEX idx_llx_projet_extrafields_rowid ON llx_projet_extrafields (rowid) |
| llx_product_lang | CREATE INDEX idx_llx_product_lang_rowid ON llx_product_lang (rowid) |
| llx_facture_fourn_det | CREATE INDEX idx_llx_facture_fourn_det_rowid ON llx_facture_fourn_det (rowid) |
| llx_agefodd_place | CREATE INDEX idx_llx_agefodd_place_rowid ON llx_agefodd_place (rowid) |
| llx_projet_task_time | CREATE INDEX idx_llx_projet_task_time_rowid ON llx_projet_task_time (rowid) |
| llx_agefodd_reg_interieur | CREATE INDEX idx_llx_agefodd_reg_interieur_rowid ON llx_agefodd_reg_interieur (rowid) |
| llx_contratdet_log | CREATE INDEX idx_llx_contratdet_log_fk_contratdet ON llx_contratdet_log (fk_contratdet) |
| llx_document_model | CREATE INDEX idx_llx_document_model_rowid ON llx_document_model (rowid) |
| llx_facturedet_rec | CREATE INDEX idx_llx_facturedet_rec_rowid ON llx_facturedet_rec (rowid) |
| llx_fichinterdet | CREATE INDEX idx_llx_fichinterdet_rowid ON llx_fichinterdet (rowid) |
| llx_c_paiement | CREATE INDEX idx_llx_c_paiement_id ON llx_c_paiement (id) |
| llx_propal | CREATE INDEX idx_llx_propal_fk_projet ON llx_propal (fk_projet) |
| llx_agefodd_opca | CREATE INDEX idx_llx_agefodd_opca_rowid ON llx_agefodd_opca (rowid) |
| llx_element_contact | CREATE INDEX idx_llx_element_contact_rowid ON llx_element_contact (rowid) |
| llx_c_availability | CREATE INDEX idx_llx_c_availability_rowid ON llx_c_availability (rowid) |
| llx_agefodd_formation_objectifs_peda | CREATE INDEX idx_llx_agefodd_formation_objectifs_peda_fk_formation_catalogue ON llx_agefodd_formation_objectifs_peda (fk_formation_catalogue) |
| llx_livraisondet | CREATE INDEX idx_llx_livraisondet_rowid ON llx_livraisondet (rowid) |
| llx_c_paper_format | CREATE INDEX idx_llx_c_paper_format_rowid ON llx_c_paper_format (rowid) |
| llx_mailing_cibles | CREATE INDEX idx_llx_mailing_cibles_rowid ON llx_mailing_cibles (rowid) |
| llx_agefodd_session_stagiaire | CREATE INDEX idx_llx_agefodd_session_stagiaire_fk_stagiaire ON llx_agefodd_session_stagiaire (fk_stagiaire) |
| llx_expedition | CREATE INDEX idx_llx_expedition_rowid ON llx_expedition (rowid) |
| llx_agefodd_formation_catalogue_type | CREATE INDEX idx_llx_agefodd_formation_catalogue_type_rowid ON llx_agefodd_formation_catalogue_type (rowid) |
| llx_agefodd_session_formateur | CREATE INDEX idx_llx_agefodd_session_formateur_rowid ON llx_agefodd_session_formateur (rowid) |
| llx_societe_remise_except | CREATE INDEX idx_llx_societe_remise_except_rowid ON llx_societe_remise_except (rowid) |
| llx_usergroup_user | CREATE INDEX idx_llx_usergroup_user_fk_usergroup ON llx_usergroup_user (fk_usergroup) |
| llx_domain | CREATE INDEX idx_llx_domain_rowid ON llx_domain (rowid) |
| llx_notify_def | CREATE INDEX idx_llx_notify_def_rowid ON llx_notify_def (rowid) |
| llx_categorie_product | CREATE INDEX idx_llx_categorie_product_fk_categorie ON llx_categorie_product (fk_categorie) |
| llx_holiday_users | CREATE INDEX idx_llx_holiday_users_fk_user ON llx_holiday_users (fk_user) |
| llx_compta_account | CREATE INDEX idx_llx_compta_account_rowid ON llx_compta_account (rowid) |
| llx_product | CREATE INDEX idx_llx_product_rowid ON llx_product (rowid) |
| llx_fichinterdet | CREATE INDEX idx_llx_fichinterdet_fk_fichinter ON llx_fichinterdet (fk_fichinter) |
| llx_c_civilite | CREATE INDEX idx_llx_c_civilite_rowid ON llx_c_civilite (rowid) |
| llx_projet_task | CREATE INDEX idx_llx_projet_task_fk_projet ON llx_projet_task (fk_projet) |
| llx_don | CREATE INDEX idx_llx_don_rowid ON llx_don (rowid) |
| llx_expeditiondet | CREATE INDEX idx_llx_expeditiondet_rowid ON llx_expeditiondet (rowid) |
| llx_c_action_trigger | CREATE INDEX idx_llx_c_action_trigger_rowid ON llx_c_action_trigger (rowid) |
| llx_facture | CREATE INDEX idx_llx_facture_rowid ON llx_facture (rowid) |
| llx_projet_task_extrafields | CREATE INDEX idx_llx_projet_task_extrafields_rowid ON llx_projet_task_extrafields (rowid) |
| llx_ecm_documents | CREATE INDEX idx_llx_ecm_documents_rowid ON llx_ecm_documents (rowid) |
| llx_societe_log | CREATE INDEX idx_llx_societe_log_id ON llx_societe_log (id) |
| llx_fichinter | CREATE INDEX idx_llx_fichinter_rowid ON llx_fichinter (rowid) |
| llx_commande_extrafields | CREATE INDEX idx_llx_commande_extrafields_rowid ON llx_commande_extrafields (rowid) |
| llx_agefodd_session_contact | CREATE INDEX idx_llx_agefodd_session_contact_fk_session_agefodd ON llx_agefodd_session_contact (fk_session_agefodd) |
| llx_c_actioncomm | CREATE INDEX idx_llx_c_actioncomm_id ON llx_c_actioncomm (id) |
| llx_paiementfourn | CREATE INDEX idx_llx_paiementfourn_rowid ON llx_paiementfourn (rowid) |
| llx_ecm_directories | CREATE INDEX idx_llx_ecm_directories_fk_user_c ON llx_ecm_directories (fk_user_c) |
| llx_c_forme_juridique | CREATE INDEX idx_llx_c_forme_juridique_rowid ON llx_c_forme_juridique (rowid) |
| llx_accountingtransaction | CREATE INDEX idx_llx_accountingtransaction_rowid ON llx_accountingtransaction (rowid) |
| llx_bank_categ | CREATE INDEX idx_llx_bank_categ_rowid ON llx_bank_categ (rowid) |
| llx_c_prospectlevel | CREATE INDEX idx_llx_c_prospectlevel_code ON llx_c_prospectlevel (code) |
| llx_c_tva | CREATE INDEX idx_llx_c_tva_rowid ON llx_c_tva (rowid) |
| llx_product_cnv_livre_contrat | CREATE INDEX idx_llx_product_cnv_livre_contrat_rowid ON llx_product_cnv_livre_contrat (rowid) |
| llx_commande | CREATE INDEX idx_llx_commande_fk_currency ON llx_commande (fk_currency) |
| llx_projet_task | CREATE INDEX idx_llx_projet_task_rowid ON llx_projet_task (rowid) |
| llx_agefodd_training_admlevel | CREATE INDEX idx_llx_agefodd_training_admlevel_rowid ON llx_agefodd_training_admlevel (rowid) |
| llx_facture_fourn | CREATE INDEX idx_llx_facture_fourn_fk_user_author ON llx_facture_fourn (fk_user_author) |
| llx_bank | CREATE INDEX idx_llx_bank_rowid ON llx_bank (rowid) |
| llx_entity | CREATE INDEX idx_llx_entity_rowid ON llx_entity (rowid) |
| llx_c_input_reason | CREATE INDEX idx_llx_c_input_reason_rowid ON llx_c_input_reason (rowid) |
| llx_categorie_member | CREATE INDEX idx_llx_categorie_member_fk_categorie_fk_member ON llx_categorie_member (fk_categorie.fk_member) |
| llx_socpeople | CREATE INDEX idx_llx_socpeople_fk_soc ON llx_socpeople (fk_soc) |
| llx_c_propalst | CREATE INDEX idx_llx_c_propalst_id ON llx_c_propalst (id) |
| llx_c_type_contact | CREATE INDEX idx_llx_c_type_contact_rowid ON llx_c_type_contact (rowid) |
| llx_categorie_member | CREATE INDEX idx_llx_categorie_member_fk_categorie ON llx_categorie_member (fk_categorie) |
| llx_commande | CREATE INDEX idx_llx_commande_fk_soc ON llx_commande (fk_soc) |
| llx_propal | CREATE INDEX idx_llx_propal_fk_currency ON llx_propal (fk_currency) |
| llx_export_model | CREATE INDEX idx_llx_export_model_rowid ON llx_export_model (rowid) |
| llx_holiday_events | CREATE INDEX idx_llx_holiday_events_rowid ON llx_holiday_events (rowid) |
| llx_agefodd_session_commercial | CREATE INDEX idx_llx_agefodd_session_commercial_fk_session_agefodd ON llx_agefodd_session_commercial (fk_session_agefodd) |
| llx_agefodd_stagiaire_certif | CREATE INDEX idx_llx_agefodd_stagiaire_certif_rowid ON llx_agefodd_stagiaire_certif (rowid) |
| llx_prelevement_lignes | CREATE INDEX idx_llx_prelevement_lignes_fk_prelevement_bons ON llx_prelevement_lignes (fk_prelevement_bons) |
| llx_propaldet | CREATE INDEX idx_llx_propaldet_rowid ON llx_propaldet (rowid) |
| llx_propal | CREATE INDEX idx_llx_propal_fk_user_valid ON llx_propal (fk_user_valid) |
| llx_user_param | CREATE INDEX idx_llx_user_param_param_fk_user_entity ON llx_user_param (param.fk_user.entity) |
| llx_product_price | CREATE INDEX idx_llx_product_price_rowid ON llx_product_price (rowid) |
| llx_propal | CREATE INDEX idx_llx_propal_rowid ON llx_propal (rowid) |
| llx_product_extrafields | CREATE INDEX idx_llx_product_extrafields_rowid ON llx_product_extrafields (rowid) |
| llx_projet | CREATE INDEX idx_llx_projet_fk_soc ON llx_projet (fk_soc) |
| llx_entrepot | CREATE INDEX idx_llx_entrepot_rowid ON llx_entrepot (rowid) |
| llx_facture | CREATE INDEX idx_llx_facture_fk_currency ON llx_facture (fk_currency) |
| llx_categorie_fournisseur | CREATE INDEX idx_llx_categorie_fournisseur_fk_societe ON llx_categorie_fournisseur (fk_societe) |
| llx_product_fournisseur_price | CREATE INDEX idx_llx_product_fournisseur_price_fk_product ON llx_product_fournisseur_price (fk_product) |
| llx_adherent_extrafields | CREATE INDEX idx_llx_adherent_extrafields_rowid ON llx_adherent_extrafields (rowid) |
| llx_agefodd_session | CREATE INDEX idx_llx_agefodd_session_rowid ON llx_agefodd_session (rowid) |
| llx_agefodd_session_stagiaire | CREATE INDEX idx_llx_agefodd_session_stagiaire_fk_session_agefodd ON llx_agefodd_session_stagiaire (fk_session_agefodd) |
| llx_c_shipment_mode | CREATE INDEX idx_llx_c_shipment_mode_rowid ON llx_c_shipment_mode (rowid) |
| llx_commandedet | CREATE INDEX idx_llx_commandedet_rowid ON llx_commandedet (rowid) |
| llx_facture_fourn_det | CREATE INDEX idx_llx_facture_fourn_det_fk_facture_fourn ON llx_facture_fourn_det (fk_facture_fourn) |
| llx_holiday_config | CREATE INDEX idx_llx_holiday_config_name ON llx_holiday_config (name) |
| llx_element_contact | CREATE INDEX idx_llx_element_contact_fk_c_type_contact ON llx_element_contact (fk_c_type_contact) |
| llx_element_tag | CREATE INDEX idx_llx_element_tag_rowid ON llx_element_tag (rowid) |
| llx_propal | CREATE INDEX idx_llx_propal_fk_user_author ON llx_propal (fk_user_author) |
| llx_societe_remise | CREATE INDEX idx_llx_societe_remise_rowid ON llx_societe_remise (rowid) |
| llx_menu | CREATE INDEX idx_llx_menu_rowid ON llx_menu (rowid) |
| llx_opensurvey_comments | CREATE INDEX idx_llx_opensurvey_comments_id_comment ON llx_opensurvey_comments (id_comment) |
| llx_opensurvey_comments | CREATE INDEX idx_llx_opensurvey_comments_id_comment ON llx_opensurvey_comments (id_comment) |
| llx_contratdet | CREATE INDEX idx_llx_contratdet_fk_product ON llx_contratdet (fk_product) |
| llx_societe_remise_except | CREATE INDEX idx_llx_societe_remise_except_fk_facture ON llx_societe_remise_except (fk_facture) |
| llx_categorie_association | CREATE INDEX idx_llx_categorie_association_fk_categorie_mere_fk_categorie_fille ON llx_categorie_association (fk_categorie_mere.fk_categorie_fille) |
| llx_categorie_association | CREATE INDEX idx_llx_categorie_association_fk_categorie_mere_fk_categorie_fille ON llx_categorie_association (fk_categorie_mere.fk_categorie_fille) |
| llx_commande_fournisseur | CREATE INDEX idx_llx_commande_fournisseur_rowid ON llx_commande_fournisseur (rowid) |
| llx_energie_groupe | CREATE INDEX idx_llx_energie_groupe_rowid ON llx_energie_groupe (rowid) |
| llx_c_typent | CREATE INDEX idx_llx_c_typent_id ON llx_c_typent (id) |
| llx_categorie_societe | CREATE INDEX idx_llx_categorie_societe_fk_societe ON llx_categorie_societe (fk_societe) |
| llx_usergroup_rights | CREATE INDEX idx_llx_usergroup_rights_fk_usergroup ON llx_usergroup_rights (fk_usergroup) |
| llx_pos_tmp | CREATE INDEX idx_llx_pos_tmp_id ON llx_pos_tmp (id) |
| llx_c_stcomm | CREATE INDEX idx_llx_c_stcomm_id ON llx_c_stcomm (id) |
| llx_accounting_system | CREATE INDEX idx_llx_accounting_system_rowid ON llx_accounting_system (rowid) |
| llx_agefodd_session_contact | CREATE INDEX idx_llx_agefodd_session_contact_fk_agefodd_contact ON llx_agefodd_session_contact (fk_agefodd_contact) |
| llx_facturedet | CREATE INDEX idx_llx_facturedet_fk_facture ON llx_facturedet (fk_facture) |
| llx_livraison | CREATE INDEX idx_llx_livraison_fk_user_valid ON llx_livraison (fk_user_valid) |
| llx_categorie_product | CREATE INDEX idx_llx_categorie_product_fk_product_fk_categorie ON llx_categorie_product (fk_product.fk_categorie) |
| llx_agefodd_session_extrafields | CREATE INDEX idx_llx_agefodd_session_extrafields_rowid ON llx_agefodd_session_extrafields (rowid) |
| llx_societe_remise_except | CREATE INDEX idx_llx_societe_remise_except_fk_facture_line ON llx_societe_remise_except (fk_facture_line) |
| llx_accountingaccount | CREATE INDEX idx_llx_accountingaccount_rowid ON llx_accountingaccount (rowid) |
| llx_localtax | CREATE INDEX idx_llx_localtax_rowid ON llx_localtax (rowid) |
| llx_adherent_type_extrafields | CREATE INDEX idx_llx_adherent_type_extrafields_rowid ON llx_adherent_type_extrafields (rowid) |
| llx_facture_extrafields | CREATE INDEX idx_llx_facture_extrafields_rowid ON llx_facture_extrafields (rowid) |
| llx_facture | CREATE INDEX idx_llx_facture_fk_facture_source ON llx_facture (fk_facture_source) |
| llx_bank_url | CREATE INDEX idx_llx_bank_url_rowid ON llx_bank_url (rowid) |
| llx_paiementcharge | CREATE INDEX idx_llx_paiementcharge_rowid ON llx_paiementcharge (rowid) |
| llx_c_ziptown | CREATE INDEX idx_llx_c_ziptown_rowid ON llx_c_ziptown (rowid) |
| llx_facture_rec | CREATE INDEX idx_llx_facture_rec_fk_soc ON llx_facture_rec (fk_soc) |
| llx_bookmark | CREATE INDEX idx_llx_bookmark_rowid ON llx_bookmark (rowid) |
| llx_user_extrafields | CREATE INDEX idx_llx_user_extrafields_rowid ON llx_user_extrafields (rowid) |
| llx_agefodd_session_commercial | CREATE INDEX idx_llx_agefodd_session_commercial_rowid ON llx_agefodd_session_commercial (rowid) |
| llx_adherent_type | CREATE INDEX idx_llx_adherent_type_rowid ON llx_adherent_type (rowid) |
| llx_agefodd_contact | CREATE INDEX idx_llx_agefodd_contact_fk_socpeople ON llx_agefodd_contact (fk_socpeople) |
| llx_agefodd_formation_objectifs_peda | CREATE INDEX idx_llx_agefodd_formation_objectifs_peda_rowid ON llx_agefodd_formation_objectifs_peda (rowid) |
| llx_paiementfourn_facturefourn | CREATE INDEX idx_llx_paiementfourn_facturefourn_rowid ON llx_paiementfourn_facturefourn (rowid) |
| llx_c_regions | CREATE INDEX idx_llx_c_regions_fk_pays ON llx_c_regions (fk_pays) |
| llx_agefodd_contact | CREATE INDEX idx_llx_agefodd_contact_rowid ON llx_agefodd_contact (rowid) |
| llx_prelevement_bons | CREATE INDEX idx_llx_prelevement_bons_rowid ON llx_prelevement_bons (rowid) |
| llx_categorie_fournisseur | CREATE INDEX idx_llx_categorie_fournisseur_fk_categorie ON llx_categorie_fournisseur (fk_categorie) |
| llx_actioncomm | CREATE INDEX idx_llx_actioncomm_id ON llx_actioncomm (id) |
| llx_events | CREATE INDEX idx_llx_events_rowid ON llx_events (rowid) |
| llx_socpeople_extrafields | CREATE INDEX idx_llx_socpeople_extrafields_rowid ON llx_socpeople_extrafields (rowid) |
| llx_printer_ipp | CREATE INDEX idx_llx_printer_ipp_rowid ON llx_printer_ipp (rowid) |
| llx_product_lang | CREATE INDEX idx_llx_product_lang_fk_product ON llx_product_lang (fk_product) |
| llx_document_generator | CREATE INDEX idx_llx_document_generator_rowid ON llx_document_generator (rowid) |
| llx_projet_task | CREATE INDEX idx_llx_projet_task_fk_user_creat ON llx_projet_task (fk_user_creat) |
| llx_bank_class | CREATE INDEX idx_llx_bank_class_lineid_fk_categ ON llx_bank_class (lineid.fk_categ) |
| llx_bank_class | CREATE INDEX idx_llx_bank_class_lineid_fk_categ ON llx_bank_class (lineid.fk_categ) |
| llx_agefodd_session | CREATE INDEX idx_llx_agefodd_session_fk_session_place ON llx_agefodd_session (fk_session_place) |
| llx_agefodd_facture | CREATE INDEX idx_llx_agefodd_facture_fk_session ON llx_agefodd_facture (fk_session) |
| llx_livraison | CREATE INDEX idx_llx_livraison_fk_soc ON llx_livraison (fk_soc) |
| llx_livraison | CREATE INDEX idx_llx_livraison_fk_user_author ON llx_livraison (fk_user_author) |
| llx_bank_account | CREATE INDEX idx_llx_bank_account_rowid ON llx_bank_account (rowid) |
| llx_facture_fourn | CREATE INDEX idx_llx_facture_fourn_rowid ON llx_facture_fourn (rowid) |
| llx_categorie_societe | CREATE INDEX idx_llx_categorie_societe_fk_categorie ON llx_categorie_societe (fk_categorie) |
| llx_agefodd_session_stagiaire | CREATE INDEX idx_llx_agefodd_session_stagiaire_rowid ON llx_agefodd_session_stagiaire (rowid) |
| llx_agefodd_formateur | CREATE INDEX idx_llx_agefodd_formateur_rowid ON llx_agefodd_formateur (rowid) |
| llx_agefodd_session_calendrier | CREATE INDEX idx_llx_agefodd_session_calendrier_fk_actioncomm ON llx_agefodd_session_calendrier (fk_actioncomm) |
| llx_agefodd_convention | CREATE INDEX idx_llx_agefodd_convention_rowid ON llx_agefodd_convention (rowid) |
| llx_adherent | CREATE INDEX idx_llx_adherent_rowid ON llx_adherent (rowid) |
| llx_product_fournisseur_price | CREATE INDEX idx_llx_product_fournisseur_price_fk_user ON llx_product_fournisseur_price (fk_user) |
| llx_c_currencies | CREATE INDEX idx_llx_c_currencies_code_iso ON llx_c_currencies (code_iso) |
| llx_c_type_fees | CREATE INDEX idx_llx_c_type_fees_id ON llx_c_type_fees (id) |
| llx_facture_rec | CREATE INDEX idx_llx_facture_rec_rowid ON llx_facture_rec (rowid) |
| llx_contrat | CREATE INDEX idx_llx_contrat_rowid ON llx_contrat (rowid) |
| llx_bordereau_cheque | CREATE INDEX idx_llx_bordereau_cheque_rowid ON llx_bordereau_cheque (rowid) |
| llx_commandedet | CREATE INDEX idx_llx_commandedet_fk_commande ON llx_commandedet (fk_commande) |
| llx_product_price_by_qty | CREATE INDEX idx_llx_product_price_by_qty_fk_product_price ON llx_product_price_by_qty (fk_product_price) |
| llx_usergroup | CREATE INDEX idx_llx_usergroup_rowid ON llx_usergroup (rowid) |
| llx_categorie_member | CREATE INDEX idx_llx_categorie_member_fk_member ON llx_categorie_member (fk_member) |
| llx_propal | CREATE INDEX idx_llx_propal_fk_soc ON llx_propal (fk_soc) |
| llx_commande | CREATE INDEX idx_llx_commande_fk_user_author ON llx_commande (fk_user_author) |
| llx_facture_rec | CREATE INDEX idx_llx_facture_rec_fk_projet ON llx_facture_rec (fk_projet) |
| llx_import_model | CREATE INDEX idx_llx_import_model_rowid ON llx_import_model (rowid) |
| llx_c_chargesociales | CREATE INDEX idx_llx_c_chargesociales_id ON llx_c_chargesociales (id) |
| llx_societe_remise_except | CREATE INDEX idx_llx_societe_remise_except_fk_facture_source ON llx_societe_remise_except (fk_facture_source) |
| llx_projet | CREATE INDEX idx_llx_projet_rowid ON llx_projet (rowid) |
| llx_cronjob | CREATE INDEX idx_llx_cronjob_rowid ON llx_cronjob (rowid) |
| llx_product_stock | CREATE INDEX idx_llx_product_stock_rowid ON llx_product_stock (rowid) |
| llx_product_fournisseur_price_log | CREATE INDEX idx_llx_product_fournisseur_price_log_rowid ON llx_product_fournisseur_price_log (rowid) |
| llx_user_rights | CREATE INDEX idx_llx_user_rights_rowid ON llx_user_rights (rowid) |
| llx_agefodd_training_admlevel | CREATE INDEX idx_llx_agefodd_training_admlevel_fk_training ON llx_agefodd_training_admlevel (fk_training) |
| llx_usergroup_rights | CREATE INDEX idx_llx_usergroup_rights_rowid ON llx_usergroup_rights (rowid) |
| llx_agefodd_stagiaire | CREATE INDEX idx_llx_agefodd_stagiaire_civilite ON llx_agefodd_stagiaire (civilite) |
| llx_commande_fournisseur_extrafields | CREATE INDEX idx_llx_commande_fournisseur_extrafields_rowid ON llx_commande_fournisseur_extrafields (rowid) |
| llx_facture | CREATE INDEX idx_llx_facture_fk_soc ON llx_facture (fk_soc) |
| llx_agefodd_stagiaire | CREATE INDEX idx_llx_agefodd_stagiaire_rowid ON llx_agefodd_stagiaire (rowid) |
| llx_droitpret_rapport | CREATE INDEX idx_llx_droitpret_rapport_rowid ON llx_droitpret_rapport (rowid) |
| llx_holiday | CREATE INDEX idx_llx_holiday_rowid ON llx_holiday (rowid) |
| llx_c_regions | CREATE INDEX idx_llx_c_regions_rowid ON llx_c_regions (rowid) |
| llx_propaldet | CREATE INDEX idx_llx_propaldet_fk_propal ON llx_propaldet (fk_propal) |
| llx_export_compta | CREATE INDEX idx_llx_export_compta_rowid ON llx_export_compta (rowid) |
| llx_contrat | CREATE INDEX idx_llx_contrat_fk_soc ON llx_contrat (fk_soc) |
| llx_facture | CREATE INDEX idx_llx_facture_fk_projet ON llx_facture (fk_projet) |
| llx_facture_rec | CREATE INDEX idx_llx_facture_rec_fk_user_author ON llx_facture_rec (fk_user_author) |
| llx_deplacement | CREATE INDEX idx_llx_deplacement_rowid ON llx_deplacement (rowid) |
| llx_contrat | CREATE INDEX idx_llx_contrat_fk_user_author ON llx_contrat (fk_user_author) |
| llx_facture | CREATE INDEX idx_llx_facture_fk_user_valid ON llx_facture (fk_user_valid) |
| llx_societe_extrafields | CREATE INDEX idx_llx_societe_extrafields_rowid ON llx_societe_extrafields (rowid) |
| llx_user | CREATE INDEX idx_llx_user_rowid ON llx_user (rowid) |
| llx_c_field_list | CREATE INDEX idx_llx_c_field_list_rowid ON llx_c_field_list (rowid) |
| llx_societe_rib | CREATE INDEX idx_llx_societe_rib_rowid ON llx_societe_rib (rowid) |
| llx_compta | CREATE INDEX idx_llx_compta_rowid ON llx_compta (rowid) |
| llx_socpeople | CREATE INDEX idx_llx_socpeople_fk_user_creat ON llx_socpeople (fk_user_creat) |
| llx_element_element | CREATE INDEX idx_llx_element_element_rowid ON llx_element_element (rowid) |
| llx_agefodd_session_commercial | CREATE INDEX idx_llx_agefodd_session_commercial_fk_user_com ON llx_agefodd_session_commercial (fk_user_com) |
| llx_prelevement_facture | CREATE INDEX idx_llx_prelevement_facture_rowid ON llx_prelevement_facture (rowid) |
| llx_user_entrepot | CREATE INDEX idx_llx_user_entrepot_rowid ON llx_user_entrepot (rowid) |
| llx_holiday_config | CREATE INDEX idx_llx_holiday_config_rowid ON llx_holiday_config (rowid) |
| llx_categorie_fournisseur | CREATE INDEX idx_llx_categorie_fournisseur_fk_categorie_fk_societe ON llx_categorie_fournisseur (fk_categorie.fk_societe) |
| llx_facture_fourn | CREATE INDEX idx_llx_facture_fourn_fk_projet ON llx_facture_fourn (fk_projet) |
| llx_agefodd_session_stagiaire | CREATE INDEX idx_llx_agefodd_session_stagiaire_fk_agefodd_stagiaire_type ON llx_agefodd_session_stagiaire (fk_agefodd_stagiaire_type) |
| llx_c_input_method | CREATE INDEX idx_llx_c_input_method_rowid ON llx_c_input_method (rowid) |
| llx_compta_compte_generaux | CREATE INDEX idx_llx_compta_compte_generaux_rowid ON llx_compta_compte_generaux (rowid) |
| llx_propal | CREATE INDEX idx_llx_propal_fk_user_cloture ON llx_propal (fk_user_cloture) |
| llx_agefodd_facture | CREATE INDEX idx_llx_agefodd_facture_rowid ON llx_agefodd_facture (rowid) |
| llx_categorie_societe | CREATE INDEX idx_llx_categorie_societe_fk_categorie_fk_societe ON llx_categorie_societe (fk_categorie.fk_societe) |
| llx_energie_compteur_releve | CREATE INDEX idx_llx_energie_compteur_releve_rowid ON llx_energie_compteur_releve (rowid) |
| llx_agefodd_place | CREATE INDEX idx_llx_agefodd_place_fk_pays ON llx_agefodd_place (fk_pays) |
| llx_agefodd_stagiaire_type | CREATE INDEX idx_llx_agefodd_stagiaire_type_rowid ON llx_agefodd_stagiaire_type (rowid) |
| llx_rights_def | CREATE INDEX idx_llx_rights_def_id_entity ON llx_rights_def (id.entity) |
| llx_contratdet | CREATE INDEX idx_llx_contratdet_fk_contrat ON llx_contratdet (fk_contrat) |
| llx_ecm_directories | CREATE INDEX idx_llx_ecm_directories_rowid ON llx_ecm_directories (rowid) |
| llx_societe | CREATE INDEX idx_llx_societe_rowid ON llx_societe (rowid) |
| llx_prelevement_rejet | CREATE INDEX idx_llx_prelevement_rejet_rowid ON llx_prelevement_rejet (rowid) |
| llx_holiday_logs | CREATE INDEX idx_llx_holiday_logs_rowid ON llx_holiday_logs (rowid) |
| llx_product_cnv_livre | CREATE INDEX idx_llx_product_cnv_livre_rowid ON llx_product_cnv_livre (rowid) |
| llx_facture_fourn | CREATE INDEX idx_llx_facture_fourn_fk_soc ON llx_facture_fourn (fk_soc) |
| llx_agefodd_session_calendrier | CREATE INDEX idx_llx_agefodd_session_calendrier_fk_agefodd_session ON llx_agefodd_session_calendrier (fk_agefodd_session) |
| llx_livraison | CREATE INDEX idx_llx_livraison_rowid ON llx_livraison (rowid) |
| llx_categorie | CREATE INDEX idx_llx_categorie_rowid ON llx_categorie (rowid) |
| llx_extrafields | CREATE INDEX idx_llx_extrafields_rowid ON llx_extrafields (rowid) |
| llx_adherent | CREATE INDEX idx_llx_adherent_fk_soc ON llx_adherent (fk_soc) |
| llx_societe_prices | CREATE INDEX idx_llx_societe_prices_rowid ON llx_societe_prices (rowid) |
| llx_boxes_def | CREATE INDEX idx_llx_boxes_def_rowid ON llx_boxes_def (rowid) |
| llx_categorie_product | CREATE INDEX idx_llx_categorie_product_fk_product ON llx_categorie_product (fk_product) |
| llx_agefodd_session_adminsitu | CREATE INDEX idx_llx_agefodd_session_adminsitu_rowid ON llx_agefodd_session_adminsitu (rowid) |
| llx_agefodd_session_admlevel | CREATE INDEX idx_llx_agefodd_session_admlevel_rowid ON llx_agefodd_session_admlevel (rowid) |
| llx_product_association | CREATE INDEX idx_llx_product_association_rowid ON llx_product_association (rowid) |
| llx_commande | CREATE INDEX idx_llx_commande_fk_user_cloture ON llx_commande (fk_user_cloture) |
| llx_facture_fourn_extrafields | CREATE INDEX idx_llx_facture_fourn_extrafields_rowid ON llx_facture_fourn_extrafields (rowid) |
| llx_societe_commerciaux | CREATE INDEX idx_llx_societe_commerciaux_rowid ON llx_societe_commerciaux (rowid) |
| llx_commande_fournisseur | CREATE INDEX idx_llx_commande_fournisseur_fk_soc ON llx_commande_fournisseur (fk_soc) |
| llx_agefodd_calendrier | CREATE INDEX idx_llx_agefodd_calendrier_rowid ON llx_agefodd_calendrier (rowid) |
| llx_boxes | CREATE INDEX idx_llx_boxes_rowid ON llx_boxes (rowid) |
| llx_c_revenuestamp | CREATE INDEX idx_llx_c_revenuestamp_rowid ON llx_c_revenuestamp (rowid) |
| llx_paiement_facture | CREATE INDEX idx_llx_paiement_facture_fk_paiement ON llx_paiement_facture (fk_paiement) |
| llx_projet_task | CREATE INDEX idx_llx_projet_task_fk_user_valid ON llx_projet_task (fk_user_valid) |
| llx_prelevement_facture_demande | CREATE INDEX idx_llx_prelevement_facture_demande_rowid ON llx_prelevement_facture_demande (rowid) |
| llx_agefodd_certificate_type | CREATE INDEX idx_llx_agefodd_certificate_type_rowid ON llx_agefodd_certificate_type (rowid) |
| llx_c_ziptown | CREATE INDEX idx_llx_c_ziptown_fk_county ON llx_c_ziptown (fk_county) |
| llx_agefodd_session_calendrier | CREATE INDEX idx_llx_agefodd_session_calendrier_rowid ON llx_agefodd_session_calendrier (rowid) |
| llx_commande | CREATE INDEX idx_llx_commande_rowid ON llx_commande (rowid) |
| llx_socpeople | CREATE INDEX idx_llx_socpeople_rowid ON llx_socpeople (rowid) |
| llx_c_barcode_type | CREATE INDEX idx_llx_c_barcode_type_rowid ON llx_c_barcode_type (rowid) |
| llx_product_price_by_qty | CREATE INDEX idx_llx_product_price_by_qty_rowid ON llx_product_price_by_qty (rowid) |
| llx_paiement | CREATE INDEX idx_llx_paiement_rowid ON llx_paiement (rowid) |
| llx_facture_fourn | CREATE INDEX idx_llx_facture_fourn_fk_user_valid ON llx_facture_fourn (fk_user_valid) |
| llx_propal_merge_pdf_product | CREATE INDEX idx_llx_propal_merge_pdf_product_rowid ON llx_propal_merge_pdf_product (rowid) |
| llx_c_departements | CREATE INDEX idx_llx_c_departements_rowid ON llx_c_departements (rowid) |
| llx_expeditiondet | CREATE INDEX idx_llx_expeditiondet_fk_expedition ON llx_expeditiondet (fk_expedition) |
| llx_societe_remise_except | CREATE INDEX idx_llx_societe_remise_except_fk_soc ON llx_societe_remise_except (fk_soc) |
| llx_transaction_bplc | CREATE INDEX idx_llx_transaction_bplc_rowid ON llx_transaction_bplc (rowid) |
| llx_commande_fournisseur_log | CREATE INDEX idx_llx_commande_fournisseur_log_rowid ON llx_commande_fournisseur_log (rowid) |
| llx_expedition | CREATE INDEX idx_llx_expedition_fk_user_author ON llx_expedition (fk_user_author) |
| llx_livraisondet | CREATE INDEX idx_llx_livraisondet_fk_livraison ON llx_livraisondet (fk_livraison) |
| llx_propal_extrafields | CREATE INDEX idx_llx_propal_extrafields_rowid ON llx_propal_extrafields (rowid) |
| llx_const | CREATE INDEX idx_llx_const_rowid ON llx_const (rowid) |
| llx_prelevement_lignes | CREATE INDEX idx_llx_prelevement_lignes_rowid ON llx_prelevement_lignes (rowid) |
| llx_usergroup_user | CREATE INDEX idx_llx_usergroup_user_fk_user ON llx_usergroup_user (fk_user) |
| llx_expedition | CREATE INDEX idx_llx_expedition_fk_soc ON llx_expedition (fk_soc) |
| llx_facture | CREATE INDEX idx_llx_facture_fk_user_author ON llx_facture (fk_user_author) |
| llx_tva | CREATE INDEX idx_llx_tva_rowid ON llx_tva (rowid) |
| llx_c_payment_term | CREATE INDEX idx_llx_c_payment_term_rowid ON llx_c_payment_term (rowid) |
| llx_societe_address | CREATE INDEX idx_llx_societe_address_rowid ON llx_societe_address (rowid) |
| llx_energie_compteur | CREATE INDEX idx_llx_energie_compteur_rowid ON llx_energie_compteur (rowid) |
| llx_fichinter | CREATE INDEX idx_llx_fichinter_fk_soc ON llx_fichinter (fk_soc) |
| llx_agefodd_convention | CREATE INDEX idx_llx_agefodd_convention_fk_agefodd_session ON llx_agefodd_convention (fk_agefodd_session) |
| llx_facturedet | CREATE INDEX idx_llx_facturedet_rowid ON llx_facturedet (rowid) |
| llx_commande | CREATE INDEX idx_llx_commande_fk_user_valid ON llx_commande (fk_user_valid) |
| llx_user_rights | CREATE INDEX idx_llx_user_rights_fk_user ON llx_user_rights (fk_user) |
| llx_commande | CREATE INDEX idx_llx_commande_fk_projet ON llx_commande (fk_projet) |
| llx_chargesociales | CREATE INDEX idx_llx_chargesociales_rowid ON llx_chargesociales (rowid) |
| llx_agefodd_session_formateur | CREATE INDEX idx_llx_agefodd_session_formateur_fk_session ON llx_agefodd_session_formateur (fk_session) |
| llx_paiement_facture | CREATE INDEX idx_llx_paiement_facture_rowid ON llx_paiement_facture (rowid) |
| llx_cotisation | CREATE INDEX idx_llx_cotisation_rowid ON llx_cotisation (rowid) |
| llx_opensurvey_user_studs | CREATE INDEX idx_llx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs (id_users) |
| llx_opensurvey_user_studs | CREATE INDEX idx_llx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs (id_users) |
| llx_product_subproduct | CREATE INDEX idx_llx_product_subproduct_rowid ON llx_product_subproduct (rowid) |
| llx_usergroup_user | CREATE INDEX idx_llx_usergroup_user_rowid ON llx_usergroup_user (rowid) |
| llx_agefodd_certif_state | CREATE INDEX idx_llx_agefodd_certif_state_rowid ON llx_agefodd_certif_state (rowid) |
| llx_adherent | CREATE INDEX idx_llx_adherent_fk_adherent_type ON llx_adherent (fk_adherent_type) |
| llx_c_ecotaxe | CREATE INDEX idx_llx_c_ecotaxe_rowid ON llx_c_ecotaxe (rowid) |
| llx_societe_remise_except | CREATE INDEX idx_llx_societe_remise_except_fk_user ON llx_societe_remise_except (fk_user) |
| llx_c_effectif | CREATE INDEX idx_llx_c_effectif_id ON llx_c_effectif (id) |
| llx_opensurvey_sondage | CREATE INDEX idx_llx_opensurvey_sondage_id_sondage ON llx_opensurvey_sondage (id_sondage) |
| llx_agefodd_session_adminsitu | CREATE INDEX idx_llx_agefodd_session_adminsitu_fk_agefodd_session ON llx_agefodd_session_adminsitu (fk_agefodd_session) |
| llx_user_alert | CREATE INDEX idx_llx_user_alert_rowid ON llx_user_alert (rowid) |
| llx_agefodd_session_formateur | CREATE INDEX idx_llx_agefodd_session_formateur_fk_agefodd_formateur ON llx_agefodd_session_formateur (fk_agefodd_formateur) |
| llx_boxes | CREATE INDEX idx_llx_boxes_box_id ON llx_boxes (box_id) |
| llx_user_clicktodial | CREATE INDEX idx_llx_user_clicktodial_fk_user ON llx_user_clicktodial (fk_user) |
| llx_commande_fournisseur_dispatch | CREATE INDEX idx_llx_commande_fournisseur_dispatch_rowid ON llx_commande_fournisseur_dispatch (rowid) |
| llx_agefodd_formation_catalogue | CREATE INDEX idx_llx_agefodd_formation_catalogue_rowid ON llx_agefodd_formation_catalogue (rowid) |
| llx_expedition | CREATE INDEX idx_llx_expedition_fk_user_valid ON llx_expedition (fk_user_valid) |
| llx_ecm_directories | CREATE INDEX idx_llx_ecm_directories_fk_user_m ON llx_ecm_directories (fk_user_m) |
| llx_c_pays | CREATE INDEX idx_llx_c_pays_rowid ON llx_c_pays (rowid) |
| llx_commande_fournisseurdet | CREATE INDEX idx_llx_commande_fournisseurdet_rowid ON llx_commande_fournisseurdet (rowid) |