Dolibarr logo
17.0.2

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : ecoledusdoli.mysql.dbOK
Database connection : ecoledusdoliOK
Database server version8.0.39-30
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script4.0.0-5.0.0.sql
Request 1 sql='UPDATE llx_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRPARTY_CREATION_INDIVIDUAL')__;'
Request 2 sql='UPDATE llx_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRDPARTY_CREATION_INDIVIDUAL')__;'
Request 3 sql='ALTER TABLE llx_product_lot MODIFY COLUMN entity integer DEFAULT 1;'
Request 4 sql='UPDATE llx_product_lot SET entity = 1 WHERE entity IS NULL;'
Request 5 sql='ALTER TABLE llx_bank_account ADD COLUMN extraparams varchar(255);'
Request 6 sql='ALTER TABLE llx_societe ALTER COLUMN fk_stcomm SET DEFAULT 0;'
Request 7 sql='ALTER TABLE llx_c_actioncomm ADD COLUMN picto varchar(48);'
Request 8 sql='ALTER TABLE llx_facturedet ADD INDEX idx_facturedet_fk_code_ventilation (fk_code_ventilation);'
Request 9 sql='ALTER TABLE llx_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_code_ventilation (fk_code_ventilation);'
Request 10 sql='ALTER TABLE llx_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_product (fk_product);'
Request 11 sql='ALTER TABLE llx_facture_rec ADD COLUMN fk_user_modif integer;'
Request 12 sql='ALTER TABLE llx_expedition ADD COLUMN fk_user_modif integer;'
Request 13 sql='ALTER TABLE llx_projet ADD COLUMN fk_user_modif integer;'
Request 14 sql='ALTER TABLE llx_adherent ADD COLUMN model_pdf varchar(255);'
Request 15 sql='ALTER TABLE llx_don ADD COLUMN date_valid datetime;'
Request 16 sql='DELETE FROM llx_menu where module='expensereport';'
Request 17 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_user_author integer after fk_unit;'
Request 18 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_user_modif integer after fk_unit;'
Request 19 sql='ALTER TABLE llx_user DROP COLUMN phenix_login;'
Request 20 sql='ALTER TABLE llx_user DROP COLUMN phenix_pass;'
Request 21 sql='ALTER TABLE llx_user ADD COLUMN dateemployment datetime;'
Request 22 sql='ALTER TABLE llx_user MODIFY login varchar(50) NOT NULL;'
Request 23 sql='ALTER TABLE llx_societe ADD COLUMN fk_account integer;'
Request 24 sql='ALTER TABLE llx_commandedet ADD COLUMN fk_commandefourndet integer DEFAULT NULL after import_key;'
Request 25 sql='ALTER TABLE llx_commandedet MODIFY COLUMN fk_commandefourndet integer DEFAULT NULL;'
Request 26 sql='ALTER TABLE llx_website ADD COLUMN virtualhost varchar(255) after fk_default_home;'
Request 27 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_account integer after fk_type;'
Request 28 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_mode_reglement integer after fk_account;'
Request 29 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_author integer;'
Request 30 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_modif integer;'
Request 31 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_valid integer;'
Request 32 sql='ALTER TABLE llx_ecm_files ADD COLUMN gen_or_uploaded varchar(12) after cover;'
Request 33 sql='DROP TABLE llx_document_generator;'
Request 34 sql='DROP TABLE llx_ecm_documents;'
Request 35 sql='DROP TABLE llx_holiday_events;'
Request 36 sql='DROP TABLE llx_holiday_types;'
Request 37 sql='ALTER TABLE llx_notify ADD COLUMN type_target varchar(16) NULL;'
Request 38 sql='ALTER TABLE llx_entrepot DROP COLUMN valo_pmp;'
Request 39 sql='ALTER TABLE llx_notify_def MODIFY COLUMN fk_soc integer NULL;'
Request 40 sql='create table llx_categorie_project ( fk_categorie integer NOT NULL, fk_project integer NOT NULL, import_key varchar(14) )ENGINE=innodb;'
Request 41 sql='ALTER TABLE llx_categorie_project ADD PRIMARY KEY pk_categorie_project (fk_categorie, fk_project);'
Request 42 sql='ALTER TABLE llx_categorie_project ADD INDEX idx_categorie_project_fk_categorie (fk_categorie);'
Request 43 sql='ALTER TABLE llx_categorie_project ADD INDEX idx_categorie_project_fk_project (fk_project);'
Request 44 sql='ALTER TABLE llx_categorie_project ADD CONSTRAINT fk_categorie_project_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 45 sql='ALTER TABLE llx_categorie_project ADD CONSTRAINT fk_categorie_project_fk_project_rowid FOREIGN KEY (fk_project) REFERENCES llx_projet (rowid);'
Request 46 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;'
Request 47 sql='ALTER TABLE llx_societe_remise ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;'
Request 48 sql='create table llx_expensereport_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 49 sql='ALTER TABLE llx_expensereport_extrafields ADD INDEX idx_expensereport_extrafields (fk_object);'
Request 50 sql='ALTER TABLE llx_cotisation RENAME TO llx_subscription;'
Request 51 sql='ALTER TABLE llx_subscription ADD UNIQUE INDEX uk_subscription (fk_adherent,dateadh);'
Request 52 sql='ALTER TABLE llx_subscription CHANGE COLUMN cotisation subscription real;'
Request 53 sql='ALTER TABLE llx_adherent_type CHANGE COLUMN cotisation subscription varchar(3) NOT NULL DEFAULT '1';'
Request 54 sql='UPDATE llx_adherent_type SET subscription = '1' WHERE subscription = 'yes';'
Request 55 sql='CREATE TABLE llx_product_lot_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 56 sql='ALTER TABLE llx_product_lot_extrafields ADD INDEX idx_product_lot_extrafields (fk_object);'
Request 57 sql='ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;'
Request 58 sql='CREATE TABLE llx_product_warehouse_properties ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_product integer NOT NULL, fk_entrepot integer NOT NULL, seuil_stock_alerte integer DEFAULT 0, desiredstock integer DEFAULT 0, import_key varchar(14) )ENGINE=innodb;'
Request 59 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 60 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN fk_user_modif integer;'
Request 61 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_creation datetime;'
Request 62 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;'
Request 63 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN numero_compte varchar(32) NOT NULL;'
Request 64 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32) NOT NULL;'
Request 65 sql='ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);'
Request 66 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_code_ventilation integer DEFAULT 0;'
Request 67 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN fdm type_cdr tinyint;'
Request 68 sql='ALTER TABLE llx_facturedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 69 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 70 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 71 sql='ALTER TABLE llx_commandedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 72 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 73 sql='ALTER TABLE llx_propaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 74 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 75 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;'
Request 76 sql='ALTER TABLE llx_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 77 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN fdm type_cdr TINYINT;'
Request 78 sql='ALTER TABLE llx_entrepot ADD COLUMN fk_parent integer DEFAULT 0;'
Request 79 sql='create table llx_resource_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 80 sql='ALTER TABLE llx_resource_extrafields ADD INDEX idx_resource_extrafields (fk_object);'
Request 81 sql='INSERT INTO llx_const (name, value, type, note, visible, entity) values (__ENCRYPT('MAIN_SIZE_SHORTLIST_LIMIT')__, __ENCRYPT('3')__, 'chaine', 'Max length for small lists (tabs)', 0, 0);'
Request 82 sql='INSERT INTO llx_const (name, value, type, note, visible, entity) values (__ENCRYPT('EXPEDITION_ADDON_NUMBER')__, __ENCRYPT('mod_expedition_safor')__, 'chaine','Name for numbering manager for shipments',0,1);'
Request 83 sql='ALTER TABLE llx_bank_account ADD COLUMN note_public text;'
Request 84 sql='ALTER TABLE llx_bank_account ADD COLUMN model_pdf varchar(255);'
Request 85 sql='ALTER TABLE llx_bank_account ADD COLUMN import_key varchar(14);'
Request 86 sql='ALTER TABLE llx_projet ADD COLUMN import_key varchar(14);'
Request 87 sql='ALTER TABLE llx_projet_task ADD COLUMN import_key varchar(14);'
Request 88 sql='ALTER TABLE llx_projet_task_time ADD COLUMN import_key varchar(14);'
Request 89 sql='ALTER TABLE llx_overwrite_trans ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 90 sql='ALTER TABLE llx_mailing_cibles ADD COLUMN error_text varchar(255);'
Request 91 sql='ALTER TABLE llx_c_actioncomm MODIFY COLUMN type varchar(50) DEFAULT 'system' NOT NULL;'
Request 92 sql='create table llx_user_employment ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, ref varchar(50), ref_ext varchar(50), fk_user integer, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer, fk_user_modif integer, job varchar(128), status integer NOT NULL, salary double(24,8), salaryextra double(24,8), weeklyhours double(16,8), dateemployment date, dateemploymentend date )ENGINE=innodb;'
Request 93 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_date_debut (date_debut);'
Request 94 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_date_fin (date_fin);'
Request 95 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_statut (fk_statut);'
Request 96 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_author (fk_user_author);'
Request 97 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_valid (fk_user_valid);'
Request 98 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_approve (fk_user_approve);'
Request 99 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_refuse (fk_user_approve);'
Request 100 sql='DELETE FROM llx_actioncomm_resources WHERE fk_actioncomm not in (select id from llx_actioncomm);'
Request 101 sql='DROP TABLE tmp_links_double;'
Request 102 sql='CREATE TABLE tmp_links_double AS (SELECT objectid, label, MAX(rowid) AS max_rowid, COUNT(rowid) AS count_rowid FROM llx_links WHERE label IS NOT NULL GROUP BY objectid, label HAVING COUNT(rowid) >= 2);'
Request 103 sql='DELETE FROM llx_links WHERE (rowid, label) IN (SELECT max_rowid, label FROM tmp_links_double);'
Request 104 sql='DROP TABLE tmp_links_double;'
Request 105 sql='ALTER TABLE llx_links ADD UNIQUE INDEX uk_links (objectid,label);'
Request 106 sql='ALTER TABLE llx_expensereport ADD UNIQUE INDEX idx_expensereport_uk_ref (ref, entity);'
Request 107 sql='UPDATE llx_projet_task SET ref = NULL WHERE ref = '';'
Request 108 sql='ALTER TABLE llx_projet_task ADD UNIQUE INDEX uk_projet_task_ref (ref, entity);'
Request 109 sql='ALTER TABLE llx_contrat ADD COLUMN fk_user_modif integer;'
Request 110 sql='UPDATE llx_accounting_account SET account_parent = 0 WHERE account_parent = '';'
Request 111 sql='ALTER TABLE llx_product_price MODIFY COLUMN date_price DATETIME NULL;'
Request 112 sql='ALTER TABLE llx_product_price ALTER COLUMN date_price SET DEFAULT NULL;'
Request 113 sql='ALTER TABLE llx_product_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 114 sql='ALTER TABLE llx_product_customer_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 115 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 116 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 117 sql='ALTER TABLE llx_events MODIFY COLUMN ip varchar(250);'
Request 118 sql='UPDATE llx_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';'
Request 119 sql='UPDATE llx_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';'
Script processingOK - Show-Hide details