Comptabilité Avancé Compte produits

hightech-ouest · Mai 14, 2019, 2:29

Bonjour

j utilise Dolibarr depuis quelque je viens d activer la compta avance j arrive à paramétrer les journaux, le model de plan, le plan comptable, compte par défaut, compte bancaire, compte de TVA ,compte de charge, par contre quand je veux paramétrer compte de produits

voici l erreur

Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic (Vous pouvez fixer l’option $dolibarr_main_prod sur ‹ 1 › pour supprimer quelques notifications):
Date: 20190514161333
Dolibarr: 9.0.3
PHP: 5.5.9-1ubuntu4.29
Server: Apache
OS: Linux SRV-Web 3.19.0-80-generic #88~14.04.1-Ubuntu SMP Fri Jan 13 14:54:07 UTC 2017 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36

Url sollicitée: /accountancy/admin/productaccount.php?mainmenu=accountancy&leftmenu=accountancy_admin
Referer: https://xxxx/admin/dict.php?id=17&from=accountancy&mainmenu=accountancy&leftmenu=accountancy_admin
Gestionnaire de menu: eldy_menu.php

Type gestionnaire de base de données: mysqli
Requête dernier accès en base en erreur: SELECT p.rowid, p.ref, p.label, p.description, p.tosell, p.tobuy, p.accountancy_code_sell, p.accountancy_code_buy, p.tms, p.fk_product_type as product_type, aa.rowid as aaid FROM llx_product as p LEFT JOIN llx_accounting_account as aa ON p.accountancy_code_sell = aa.account_number AND aa.fk_pcg_version = ‹ PCG99-ABREGE › WHERE p.entity IN (1) AND aa.account_number IS NULL ORDER BY p.ref ASC LIMIT 26
Code retour dernier accès en base en erreur: DB_ERROR_1267
Information sur le dernier accès en base en erreur: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‹ = ›

avez vous une solution pour résoudre ce problème

ksar · Mai 14, 2019, 2:31

Bonjour,

Une petite recherche ?
www.dolibarr.fr/forum/t/illegal-mix-of-collations-utf8-unicode-ci-implici/26923/3

hightech-ouest · Mai 14, 2019, 3:49

Bonjour je viens de faire la manip

non de domaine/install/repair.php?force_utf8_on_tables=confirmed

voici le resultat

Repair
Option standard (0 or ‹ confirmed ›) is 0
Option restore_thirdparties_logos (0 or ‹ confirmed ›) is 0
Option clean_linked_elements (0 or ‹ confirmed ›) is 0
Option clean_menus (0 or ‹ test › or ‹ confirmed ›) is 0
Option clean_orphelin_dir (0 or ‹ test › or ‹ confirmed ›) is 0
Option clean_product_stock_batch (0 or ‹ test › or ‹ confirmed ›) is 0
Option set_empty_time_spent_amount (0 or ‹ test › or ‹ confirmed ›) is 0
Option rebuild_product_thumbs (0 or ‹ test › or ‹ confirmed ›) is 0
Option force_disable_of_modules_not_found (0 or ‹ test › or ‹ confirmed ›) is 0
Option clean_perm_table (0 or ‹ test › or ‹ confirmed ›) is 0
Option force_utf8_on_tables, for mysql/mariadb only (0 or ‹ test › or ‹ confirmed ›) is confirmed

Connexion au serveur : localhost OK
Connexion à la base : xxxOK
Version du serveur de base de données 5.5.62-0ubuntu0.14.04.1
Merci de patienter quelques instants…

*** Force page code and collation of tables into utf8/utf8_unicode_ci (for mysql/mariadb only)

par contre le problème persiste

ksar · Mai 14, 2019, 7:30

Bonjour,

Si vous avez accés à phpmyadmin passez toutes vos tables en utf8_unicode_ci
Vous avez une des deux tables lx_product ou llx_accounting_account qui est en utf8_general_ci

hightech-ouest · Mai 15, 2019, 11:23

Bonjour je viens de passer les deux table en
lx_product ou llx_accounting_account en unicode_ci
idem

je vais passer l ensemble des table en unicode-ci savez vous comment faire dans une requet sql

merci d avance

aspangaro-Easya · Mai 15, 2019, 11:56

Hello,

Voici le script que j’utilise sur une v7 non compatible comportant l’erreur, il doit manquer quelques tables dans la liste pour des versions supérieures :

ALTER TABLE llx_accounting_account NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_bookkeeping NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_bookkeeping_tmp NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_fiscalyear NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_journal NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_system NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm_reminder NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm_resources NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent_type NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent_type_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_advtargetemailing NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bank NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_account NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_account_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_categ NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_class NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_url NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_blockedlog NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_blockedlog_authority NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bookmark NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_bordereau_cheque NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_boxes NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_boxes_def NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_budget NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_budget_lines NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_accounting_category NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_action_trigger NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_actioncomm NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_availability NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_barcode_type NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_chargesociales NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_civility NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_codenaf NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_country NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_currencies NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_departements NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_ecotaxe NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_effectif NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_email_senderprofile NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_email_templates NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_exp_tax_cat NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_exp_tax_range NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_extentedemail_generic_email NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_field_list NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_format_cards NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_forme_juridique NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_holiday_types NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_hrm_department NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_hrm_function NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_incoterms NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_input_method NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_input_reason NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_lead_status NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_paiement NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_paper_format NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_payment_term NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_price_expression NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_price_global_variable NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_price_global_variable_updater NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_propalst NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_prospectingmap_region NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_prospectingmap_region_cbl_department NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_prospectlevel NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_regions NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_revenuestamp NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_shipment_mode NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_stcomm NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_subtotal_free_text NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_tva NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_type_contact NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_type_fees NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_type_resource NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_typent NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_units NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_c_ziptown NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_account NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_contact NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_fournisseur NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_lang NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_member NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_product NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_project NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_societe NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_user NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_categories_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_chargesociales NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur_dispatch NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur_log NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseurdet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseurdet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commandedet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_commandedet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_comment NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_const NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_contrat NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_contrat_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_contratdet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_contratdet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_contratdet_log NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_cronjob NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_default_values NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_deplacement NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_document_model NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_don NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_don_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_ecm_directories NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_ecm_files NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_element_contact NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_element_element NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_element_resources NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_entity NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_entity_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_entity_thirdparty NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_entrepot NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_establishment NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_event_element NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_events NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expedition NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expedition_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expeditiondet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expeditiondet_batch NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expeditiondet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_det NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_ik NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_rules NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_export_compta NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_export_model NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_extentedemail_user_generic_email NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn_det NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn_det_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_rec NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_rec_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet_rec NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet_rec_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinter NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinter_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinterdet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinterdet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday_config NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday_logs NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday_users NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_import_model NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_inventory NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_inventorydet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_links NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_livraison NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_livraison_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_livraisondet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_livraisondet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_loan NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_loan_schedule NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_localtax NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_mailing NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_mailing_cibles NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_menu NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_multicurrency NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_multicurrency_rate NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_notify NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_notify_def NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_notify_def_object NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_oauth_state NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_oauth_token NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_onlinesignature NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_comments NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_formquestions NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_sondage NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_user_formanswers NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_user_studs NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_overwrite_trans NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_paiement NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_paiement_facture NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_paiementcharge NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_paiementfourn NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_paiementfourn_facturefourn NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_donation NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_expensereport NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_loan NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_salary NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_various NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_bons NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_facture NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_facture_demande NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_lignes NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_rejet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_printing NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_association NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute_combination NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute_combination2val NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute_value NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_batch NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_customer_price NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_customer_price_log NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_fournisseur_price NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_fournisseur_price_log NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_lang NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_lot NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_lot_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_price NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_price_by_qty NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_pricerules NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_stock NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_product_warehouse_properties NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_projet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_task NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_task_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_task_time NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_propal NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_propal_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_propal_merge_pdf_product NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_propaldet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_propaldet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_propale_history NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_prospectingmap_coordinate NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_quicklist NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_quicklist_usergroup NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_resource NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_resource_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_rights_def NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_address NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_commerciaux NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_log NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_prices NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_remise NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_remise_except NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_rib NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_socpeople NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_socpeople_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_stock_mouvement NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_subscription NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposal NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposal_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposaldet NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposaldet_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_tva NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_alert NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_clicktodial NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_employment NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_param NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_rib NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_user_rights NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup_rights NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup_user NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_website NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_website_account NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_website_account_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_website_extrafields NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_website_page NOCHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_account CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_accounting_bookkeeping CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_accounting_bookkeeping_tmp CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_accounting_fiscalyear CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_accounting_journal CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_accounting_system CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_actioncomm CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_actioncomm_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_actioncomm_reminder CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_actioncomm_resources CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_adherent CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_adherent_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_adherent_type CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_adherent_type_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_advtargetemailing CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bank CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bank_account CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bank_account_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bank_categ CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bank_class CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bank_url CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_blockedlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_blockedlog_authority CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bookmark CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_bordereau_cheque CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_boxes CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_boxes_def CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_budget CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_budget_lines CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_accounting_category CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_action_trigger CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_actioncomm CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_availability CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_barcode_type CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_chargesociales CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_civility CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_codenaf CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_country CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_currencies CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_departements CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_ecotaxe CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_effectif CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_email_senderprofile CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_email_templates CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_exp_tax_cat CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_exp_tax_range CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_extentedemail_generic_email CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_field_list CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_format_cards CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_forme_juridique CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_holiday_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_hrm_department CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_hrm_function CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_incoterms CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_input_method CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_input_reason CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_lead_status CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_paiement CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_paper_format CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_payment_term CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_price_expression CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_price_global_variable CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_price_global_variable_updater CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_propalst CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_prospectingmap_region CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_prospectingmap_region_cbl_department CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_prospectlevel CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_regions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_revenuestamp CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_shipment_mode CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_stcomm CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_subtotal_free_text CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_tva CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_type_contact CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_type_fees CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_type_resource CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_typent CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_units CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_c_ziptown CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_account CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_contact CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_fournisseur CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_lang CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_member CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_product CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_project CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_societe CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categorie_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_categories_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_chargesociales CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_fournisseur CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_fournisseur_dispatch CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_fournisseur_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_fournisseur_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_fournisseurdet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commande_fournisseurdet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commandedet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_commandedet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_comment CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_const CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_contrat CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_contrat_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_contratdet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_contratdet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_contratdet_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_cronjob CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_default_values CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_deplacement CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_document_model CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_don CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_don_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_ecm_directories CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_ecm_files CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_element_contact CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_element_element CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_element_resources CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_entity CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_entity_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_entity_thirdparty CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_entrepot CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_establishment CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_event_element CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_events CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expedition CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expedition_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expeditiondet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expeditiondet_batch CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expeditiondet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expensereport CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expensereport_det CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expensereport_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expensereport_ik CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_expensereport_rules CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_export_compta CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_export_model CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_extentedemail_user_generic_email CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_fourn CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_fourn_det CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_fourn_det_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_fourn_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_rec CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facture_rec_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facturedet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facturedet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facturedet_rec CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_facturedet_rec_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_fichinter CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_fichinter_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_fichinterdet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_fichinterdet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_holiday CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_holiday_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_holiday_logs CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_holiday_users CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_import_model CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_inventory CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_inventorydet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_livraison CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_livraison_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_livraisondet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_livraisondet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_loan CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_loan_schedule CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_localtax CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_mailing CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_mailing_cibles CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_menu CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_multicurrency CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_multicurrency_rate CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_notify CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_notify_def CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_notify_def_object CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_oauth_state CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_oauth_token CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_onlinesignature CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_opensurvey_comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_opensurvey_formquestions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_opensurvey_sondage CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_opensurvey_user_formanswers CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_opensurvey_user_studs CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_overwrite_trans CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_paiement CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_paiement_facture CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_paiementcharge CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_paiementfourn CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_paiementfourn_facturefourn CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_payment_donation CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_payment_expensereport CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_payment_loan CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_payment_salary CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_payment_various CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_prelevement_bons CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_prelevement_facture CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_prelevement_facture_demande CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_prelevement_lignes CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_prelevement_rejet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_printing CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_association CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_attribute CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_attribute_combination CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_attribute_combination2val CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_attribute_value CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_batch CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_customer_price CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_customer_price_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_fournisseur_price CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_fournisseur_price_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_lang CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_lot CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_lot_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_price CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_price_by_qty CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_pricerules CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_stock CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_product_warehouse_properties CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_projet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_projet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_projet_task CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_projet_task_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_projet_task_time CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_propal CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_propal_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_propal_merge_pdf_product CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_propaldet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_propaldet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_propale_history CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_prospectingmap_coordinate CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_quicklist CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_quicklist_usergroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_resource CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_resource_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_rights_def CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_address CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_commerciaux CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_prices CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_remise CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_remise_except CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_societe_rib CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_socpeople CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_socpeople_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_stock_mouvement CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_subscription CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_supplier_proposal CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_supplier_proposal_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_supplier_proposaldet CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_supplier_proposaldet_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_tva CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_alert CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_clicktodial CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_employment CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_param CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_rib CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_user_rights CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_usergroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_usergroup_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_usergroup_rights CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_usergroup_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_website CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_website_account CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_website_account_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_website_extrafields CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_website_page CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE llx_accounting_account CHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_bookkeeping CHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_bookkeeping_tmp CHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_fiscalyear CHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_journal CHECK CONSTRAINT ALL;
ALTER TABLE llx_accounting_system CHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm CHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm_reminder CHECK CONSTRAINT ALL;
ALTER TABLE llx_actioncomm_resources CHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent CHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent_type CHECK CONSTRAINT ALL;
ALTER TABLE llx_adherent_type_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_advtargetemailing CHECK CONSTRAINT ALL;
ALTER TABLE llx_bank CHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_account CHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_account_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_categ CHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_class CHECK CONSTRAINT ALL;
ALTER TABLE llx_bank_url CHECK CONSTRAINT ALL;
ALTER TABLE llx_blockedlog CHECK CONSTRAINT ALL;
ALTER TABLE llx_blockedlog_authority CHECK CONSTRAINT ALL;
ALTER TABLE llx_bookmark CHECK CONSTRAINT ALL;
ALTER TABLE llx_bordereau_cheque CHECK CONSTRAINT ALL;
ALTER TABLE llx_boxes CHECK CONSTRAINT ALL;
ALTER TABLE llx_boxes_def CHECK CONSTRAINT ALL;
ALTER TABLE llx_budget CHECK CONSTRAINT ALL;
ALTER TABLE llx_budget_lines CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_accounting_category CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_action_trigger CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_actioncomm CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_availability CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_barcode_type CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_chargesociales CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_civility CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_codenaf CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_country CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_currencies CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_departements CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_ecotaxe CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_effectif CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_email_senderprofile CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_email_templates CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_exp_tax_cat CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_exp_tax_range CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_extentedemail_generic_email CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_field_list CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_format_cards CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_forme_juridique CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_holiday_types CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_hrm_department CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_hrm_function CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_incoterms CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_input_method CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_input_reason CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_lead_status CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_paiement CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_paper_format CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_payment_term CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_price_expression CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_price_global_variable CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_price_global_variable_updater CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_propalst CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_prospectingmap_region CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_prospectingmap_region_cbl_department CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_prospectlevel CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_regions CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_revenuestamp CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_shipment_mode CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_stcomm CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_subtotal_free_text CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_tva CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_type_contact CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_type_fees CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_type_resource CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_typent CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_units CHECK CONSTRAINT ALL;
ALTER TABLE llx_c_ziptown CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_account CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_contact CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_fournisseur CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_lang CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_member CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_product CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_project CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_societe CHECK CONSTRAINT ALL;
ALTER TABLE llx_categorie_user CHECK CONSTRAINT ALL;
ALTER TABLE llx_categories_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_chargesociales CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur_dispatch CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseur_log CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseurdet CHECK CONSTRAINT ALL;
ALTER TABLE llx_commande_fournisseurdet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_commandedet CHECK CONSTRAINT ALL;
ALTER TABLE llx_commandedet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_comment CHECK CONSTRAINT ALL;
ALTER TABLE llx_const CHECK CONSTRAINT ALL;
ALTER TABLE llx_contrat CHECK CONSTRAINT ALL;
ALTER TABLE llx_contrat_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_contratdet CHECK CONSTRAINT ALL;
ALTER TABLE llx_contratdet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_contratdet_log CHECK CONSTRAINT ALL;
ALTER TABLE llx_cronjob CHECK CONSTRAINT ALL;
ALTER TABLE llx_default_values CHECK CONSTRAINT ALL;
ALTER TABLE llx_deplacement CHECK CONSTRAINT ALL;
ALTER TABLE llx_document_model CHECK CONSTRAINT ALL;
ALTER TABLE llx_don CHECK CONSTRAINT ALL;
ALTER TABLE llx_don_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_ecm_directories CHECK CONSTRAINT ALL;
ALTER TABLE llx_ecm_files CHECK CONSTRAINT ALL;
ALTER TABLE llx_element_contact CHECK CONSTRAINT ALL;
ALTER TABLE llx_element_element CHECK CONSTRAINT ALL;
ALTER TABLE llx_element_resources CHECK CONSTRAINT ALL;
ALTER TABLE llx_entity CHECK CONSTRAINT ALL;
ALTER TABLE llx_entity_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_entity_thirdparty CHECK CONSTRAINT ALL;
ALTER TABLE llx_entrepot CHECK CONSTRAINT ALL;
ALTER TABLE llx_establishment CHECK CONSTRAINT ALL;
ALTER TABLE llx_event_element CHECK CONSTRAINT ALL;
ALTER TABLE llx_events CHECK CONSTRAINT ALL;
ALTER TABLE llx_expedition CHECK CONSTRAINT ALL;
ALTER TABLE llx_expedition_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_expeditiondet CHECK CONSTRAINT ALL;
ALTER TABLE llx_expeditiondet_batch CHECK CONSTRAINT ALL;
ALTER TABLE llx_expeditiondet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport CHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_det CHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_ik CHECK CONSTRAINT ALL;
ALTER TABLE llx_expensereport_rules CHECK CONSTRAINT ALL;
ALTER TABLE llx_export_compta CHECK CONSTRAINT ALL;
ALTER TABLE llx_export_model CHECK CONSTRAINT ALL;
ALTER TABLE llx_extentedemail_user_generic_email CHECK CONSTRAINT ALL;
ALTER TABLE llx_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn_det CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn_det_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_fourn_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_rec CHECK CONSTRAINT ALL;
ALTER TABLE llx_facture_rec_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet CHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet_rec CHECK CONSTRAINT ALL;
ALTER TABLE llx_facturedet_rec_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinter CHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinter_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinterdet CHECK CONSTRAINT ALL;
ALTER TABLE llx_fichinterdet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday CHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday_config CHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday_logs CHECK CONSTRAINT ALL;
ALTER TABLE llx_holiday_users CHECK CONSTRAINT ALL;
ALTER TABLE llx_import_model CHECK CONSTRAINT ALL;
ALTER TABLE llx_inventory CHECK CONSTRAINT ALL;
ALTER TABLE llx_inventorydet CHECK CONSTRAINT ALL;
ALTER TABLE llx_links CHECK CONSTRAINT ALL;
ALTER TABLE llx_livraison CHECK CONSTRAINT ALL;
ALTER TABLE llx_livraison_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_livraisondet CHECK CONSTRAINT ALL;
ALTER TABLE llx_livraisondet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_loan CHECK CONSTRAINT ALL;
ALTER TABLE llx_loan_schedule CHECK CONSTRAINT ALL;
ALTER TABLE llx_localtax CHECK CONSTRAINT ALL;
ALTER TABLE llx_mailing CHECK CONSTRAINT ALL;
ALTER TABLE llx_mailing_cibles CHECK CONSTRAINT ALL;
ALTER TABLE llx_menu CHECK CONSTRAINT ALL;
ALTER TABLE llx_multicurrency CHECK CONSTRAINT ALL;
ALTER TABLE llx_multicurrency_rate CHECK CONSTRAINT ALL;
ALTER TABLE llx_notify CHECK CONSTRAINT ALL;
ALTER TABLE llx_notify_def CHECK CONSTRAINT ALL;
ALTER TABLE llx_notify_def_object CHECK CONSTRAINT ALL;
ALTER TABLE llx_oauth_state CHECK CONSTRAINT ALL;
ALTER TABLE llx_oauth_token CHECK CONSTRAINT ALL;
ALTER TABLE llx_onlinesignature CHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_comments CHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_formquestions CHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_sondage CHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_user_formanswers CHECK CONSTRAINT ALL;
ALTER TABLE llx_opensurvey_user_studs CHECK CONSTRAINT ALL;
ALTER TABLE llx_overwrite_trans CHECK CONSTRAINT ALL;
ALTER TABLE llx_paiement CHECK CONSTRAINT ALL;
ALTER TABLE llx_paiement_facture CHECK CONSTRAINT ALL;
ALTER TABLE llx_paiementcharge CHECK CONSTRAINT ALL;
ALTER TABLE llx_paiementfourn CHECK CONSTRAINT ALL;
ALTER TABLE llx_paiementfourn_facturefourn CHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_donation CHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_expensereport CHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_loan CHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_salary CHECK CONSTRAINT ALL;
ALTER TABLE llx_payment_various CHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_bons CHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_facture CHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_facture_demande CHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_lignes CHECK CONSTRAINT ALL;
ALTER TABLE llx_prelevement_rejet CHECK CONSTRAINT ALL;
ALTER TABLE llx_printing CHECK CONSTRAINT ALL;
ALTER TABLE llx_product CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_association CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute_combination CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute_combination2val CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_attribute_value CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_batch CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_customer_price CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_customer_price_log CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_fournisseur_price CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_fournisseur_price_log CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_lang CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_lot CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_lot_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_price CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_price_by_qty CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_pricerules CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_stock CHECK CONSTRAINT ALL;
ALTER TABLE llx_product_warehouse_properties CHECK CONSTRAINT ALL;
ALTER TABLE llx_projet CHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_task CHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_task_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_projet_task_time CHECK CONSTRAINT ALL;
ALTER TABLE llx_propal CHECK CONSTRAINT ALL;
ALTER TABLE llx_propal_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_propal_merge_pdf_product CHECK CONSTRAINT ALL;
ALTER TABLE llx_propaldet CHECK CONSTRAINT ALL;
ALTER TABLE llx_propaldet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_propale_history CHECK CONSTRAINT ALL;
ALTER TABLE llx_prospectingmap_coordinate CHECK CONSTRAINT ALL;
ALTER TABLE llx_quicklist CHECK CONSTRAINT ALL;
ALTER TABLE llx_quicklist_usergroup CHECK CONSTRAINT ALL;
ALTER TABLE llx_resource CHECK CONSTRAINT ALL;
ALTER TABLE llx_resource_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_rights_def CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_address CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_commerciaux CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_log CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_prices CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_remise CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_remise_except CHECK CONSTRAINT ALL;
ALTER TABLE llx_societe_rib CHECK CONSTRAINT ALL;
ALTER TABLE llx_socpeople CHECK CONSTRAINT ALL;
ALTER TABLE llx_socpeople_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_stock_mouvement CHECK CONSTRAINT ALL;
ALTER TABLE llx_subscription CHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposal CHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposal_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposaldet CHECK CONSTRAINT ALL;
ALTER TABLE llx_supplier_proposaldet_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_tva CHECK CONSTRAINT ALL;
ALTER TABLE llx_user CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_alert CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_clicktodial CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_employment CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_param CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_rib CHECK CONSTRAINT ALL;
ALTER TABLE llx_user_rights CHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup CHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup_rights CHECK CONSTRAINT ALL;
ALTER TABLE llx_usergroup_user CHECK CONSTRAINT ALL;
ALTER TABLE llx_website CHECK CONSTRAINT ALL;
ALTER TABLE llx_website_account CHECK CONSTRAINT ALL;
ALTER TABLE llx_website_account_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_website_extrafields CHECK CONSTRAINT ALL;
ALTER TABLE llx_website_page CHECK CONSTRAINT ALL;

hightech-ouest · Mai 16, 2019, 1:26

Bonjour tout d abord je tenais a vous remercier de votre aide

j ai pu régler le problème en changent juste la table llx_accounting_account en passant en utf8_unicode_ci l enssemble des tables

Merci encore