Dolibarr logo
7.0.3

Dolibarr install or upgrade

Database Structure database migration

Server connection : localhostOK
Database connection : railplan_doli449OK
Database server version5.6.39-cll-lve
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script4.0.0-5.0.0.sql
Request 1 sql='UPDATE llxmk_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRPARTY_CREATION_INDIVIDUAL')__;'
Request 2 sql='UPDATE llxmk_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRDPARTY_CREATION_INDIVIDUAL')__;'
Request 3 sql='ALTER TABLE llxmk_product_lot MODIFY COLUMN entity integer DEFAULT 1;'
Request 4 sql='UPDATE llxmk_product_lot SET entity = 1 WHERE entity IS NULL;'
Request 5 sql='ALTER TABLE llxmk_bank_account ADD COLUMN extraparams varchar(255);'
Request 6 sql='ALTER TABLE llxmk_societe ALTER COLUMN fk_stcomm SET DEFAULT 0;'
Request 7 sql='ALTER TABLE llxmk_c_actioncomm ADD COLUMN picto varchar(48);'
Request 8 sql='ALTER TABLE llxmk_facturedet ADD INDEX idx_facturedet_fk_code_ventilation (fk_code_ventilation);'
Request 9 sql='ALTER TABLE llxmk_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_code_ventilation (fk_code_ventilation);'
Request 10 sql='ALTER TABLE llxmk_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_product (fk_product);'
Request 11 sql='ALTER TABLE llxmk_facture_rec ADD COLUMN fk_user_modif integer;'
Request 12 sql='ALTER TABLE llxmk_expedition ADD COLUMN fk_user_modif integer;'
Request 13 sql='ALTER TABLE llxmk_projet ADD COLUMN fk_user_modif integer;'
Request 14 sql='ALTER TABLE llxmk_adherent ADD COLUMN model_pdf varchar(255);'
Request 15 sql='ALTER TABLE llxmk_don ADD COLUMN date_valid datetime;'
Request 16 sql='DELETE FROM llxmk_menu where module='expensereport';'
Request 17 sql='ALTER TABLE llxmk_facturedet ADD COLUMN fk_user_author integer after fk_unit;'
Request 18 sql='ALTER TABLE llxmk_facturedet ADD COLUMN fk_user_modif integer after fk_unit;'
Request 19 sql='ALTER TABLE llxmk_user DROP COLUMN phenix_login;'
Request 20 sql='ALTER TABLE llxmk_user DROP COLUMN phenix_pass;'
Request 21 sql='ALTER TABLE llxmk_user ADD COLUMN dateemployment datetime;'
Request 22 sql='ALTER TABLE llxmk_user MODIFY login varchar(50) NOT NULL;'
Request 23 sql='ALTER TABLE llxmk_societe ADD COLUMN fk_account integer;'
Request 24 sql='ALTER TABLE llxmk_commandedet ADD COLUMN fk_commandefourndet integer DEFAULT NULL after import_key;'
Request 25 sql='ALTER TABLE llxmk_commandedet MODIFY COLUMN fk_commandefourndet integer DEFAULT NULL;'
Request 26 sql='ALTER TABLE llxmk_website ADD COLUMN virtualhost varchar(255) after fk_default_home;'
Request 27 sql='ALTER TABLE llxmk_chargesociales ADD COLUMN fk_account integer after fk_type;'
Request 28 sql='ALTER TABLE llxmk_chargesociales ADD COLUMN fk_mode_reglement integer after fk_account;'
Request 29 sql='ALTER TABLE llxmk_chargesociales ADD COLUMN fk_user_author integer;'
Request 30 sql='ALTER TABLE llxmk_chargesociales ADD COLUMN fk_user_modif integer;'
Request 31 sql='ALTER TABLE llxmk_chargesociales ADD COLUMN fk_user_valid integer;'
Request 32 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN gen_or_uploaded varchar(12) after cover;'
Request 33 sql='DROP TABLE llxmk_document_generator;'
Request 34 sql='DROP TABLE llxmk_ecm_documents;'
Request 35 sql='DROP TABLE llxmk_holiday_events;'
Request 36 sql='DROP TABLE llxmk_holiday_types;'
Request 37 sql='ALTER TABLE llxmk_notify ADD COLUMN type_target varchar(16) NULL;'
Request 38 sql='ALTER TABLE llxmk_entrepot DROP COLUMN valo_pmp;'
Request 39 sql='ALTER TABLE llxmk_notify_def MODIFY COLUMN fk_soc integer NULL;'
Request 40 sql='create table llxmk_categorie_project(fk_categorie integer NOT NULL,fk_project integer NOT NULL,import_key varchar(14))ENGINE=innodb;'
Request 41 sql='ALTER TABLE llxmk_categorie_project ADD PRIMARY KEY pk_categorie_project (fk_categorie, fk_project);'
Request 42 sql='ALTER TABLE llxmk_categorie_project ADD INDEX idx_categorie_project_fk_categorie (fk_categorie);'
Request 43 sql='ALTER TABLE llxmk_categorie_project ADD INDEX idx_categorie_project_fk_project (fk_project);'
Request 44 sql='ALTER TABLE llxmk_categorie_project ADD CONSTRAINT fk_categorie_project_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llxmk_categorie (rowid);'
Request 45 sql='ALTER TABLE llxmk_categorie_project ADD CONSTRAINT fk_categorie_project_fk_project_rowid FOREIGN KEY (fk_project) REFERENCES llxmk_projet (rowid);'
Request 46 sql='ALTER TABLE llxmk_societe_remise_except ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;'
Request 47 sql='ALTER TABLE llxmk_societe_remise ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;'
Request 48 sql='create table llxmk_expensereport_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 49 sql='ALTER TABLE llxmk_expensereport_extrafields ADD INDEX idx_expensereport_extrafields (fk_object);'
Request 50 sql='ALTER TABLE llxmk_cotisation RENAME TO llxmk_subscription;'
Request 51 sql='ALTER TABLE llxmk_subscription ADD UNIQUE INDEX uk_subscription (fk_adherent,dateadh);'
Request 52 sql='ALTER TABLE llxmk_subscription CHANGE COLUMN cotisation subscription real;'
Request 53 sql='ALTER TABLE llxmk_adherent_type CHANGE COLUMN cotisation subscription varchar(3) NOT NULL DEFAULT '1';'
Request 54 sql='UPDATE llxmk_adherent_type SET subscription = '1' WHERE subscription = 'yes';'
Request 55 sql='CREATE TABLE llxmk_product_lot_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 56 sql='ALTER TABLE llxmk_product_lot_extrafields ADD INDEX idx_product_lot_extrafields (fk_object);'
Request 57 sql='ALTER TABLE llxmk_website_page MODIFY COLUMN content MEDIUMTEXT;'
Request 58 sql='CREATE TABLE llxmk_product_warehouse_properties(rowid integer AUTO_INCREMENT PRIMARY KEY,tms 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 llxmk_accounting_bookkeeping ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 60 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN fk_user_modif integer;'
Request 61 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN date_creation datetime;'
Request 62 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN tms timestamp;'
Request 63 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN numero_compte varchar(32) NOT NULL;'
Request 64 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32) NOT NULL;'
Request 65 sql='ALTER TABLE llxmk_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);'
Request 66 sql='ALTER TABLE llxmk_expensereport_det ADD COLUMN fk_code_ventilation integer DEFAULT 0;'
Request 67 sql='ALTER TABLE llxmk_c_payment_term CHANGE COLUMN fdm type_cdr tinyint;'
Request 68 sql='ALTER TABLE llxmk_facturedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 69 sql='ALTER TABLE llxmk_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 70 sql='ALTER TABLE llxmk_facture_fourn_det ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 71 sql='ALTER TABLE llxmk_commandedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 72 sql='ALTER TABLE llxmk_commande_fournisseurdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 73 sql='ALTER TABLE llxmk_propaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 74 sql='ALTER TABLE llxmk_supplier_proposaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 75 sql='ALTER TABLE llxmk_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;'
Request 76 sql='ALTER TABLE llxmk_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 77 sql='ALTER TABLE llxmk_c_payment_term CHANGE COLUMN fdm type_cdr TINYINT;'
Request 78 sql='ALTER TABLE llxmk_entrepot ADD COLUMN fk_parent integer DEFAULT 0;'
Request 79 sql='create table llxmk_resource_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 80 sql='ALTER TABLE llxmk_resource_extrafields ADD INDEX idx_resource_extrafields (fk_object);'
Request 81 sql='INSERT INTO llxmk_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 llxmk_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 llxmk_bank_account ADD COLUMN note_public text;'
Request 84 sql='ALTER TABLE llxmk_bank_account ADD COLUMN model_pdf varchar(255);'
Request 85 sql='ALTER TABLE llxmk_bank_account ADD COLUMN import_key varchar(14);'
Request 86 sql='ALTER TABLE llxmk_projet ADD COLUMN import_key varchar(14);'
Request 87 sql='ALTER TABLE llxmk_projet_task ADD COLUMN import_key varchar(14);'
Request 88 sql='ALTER TABLE llxmk_projet_task_time ADD COLUMN import_key varchar(14);'
Request 89 sql='ALTER TABLE llxmk_overwrite_trans ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 90 sql='ALTER TABLE llxmk_mailing_cibles ADD COLUMN error_text varchar(255);'
Request 91 sql='ALTER TABLE llxmk_c_actioncomm MODIFY COLUMN type varchar(50) DEFAULT 'system' NOT NULL;'
Request 92 sql='create table llxmk_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,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 llxmk_expensereport ADD INDEX idx_expensereport_date_debut (date_debut);'
Request 94 sql='ALTER TABLE llxmk_expensereport ADD INDEX idx_expensereport_date_fin (date_fin);'
Request 95 sql='ALTER TABLE llxmk_expensereport ADD INDEX idx_expensereport_fk_statut (fk_statut);'
Request 96 sql='ALTER TABLE llxmk_expensereport ADD INDEX idx_expensereport_fk_user_author (fk_user_author);'
Request 97 sql='ALTER TABLE llxmk_expensereport ADD INDEX idx_expensereport_fk_user_valid (fk_user_valid);'
Request 98 sql='ALTER TABLE llxmk_expensereport ADD INDEX idx_expensereport_fk_user_approve (fk_user_approve);'
Request 99 sql='ALTER TABLE llxmk_expensereport ADD INDEX idx_expensereport_fk_refuse (fk_user_approve);'
Request 100 sql='DELETE FROM llxmk_actioncomm_resources WHERE fk_actioncomm not in (select id from llxmk_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 llxmk_links WHERE label IS NOT NULL GROUP BY objectid, label HAVING COUNT(rowid) >= 2);'
Request 103 sql='DELETE FROM llxmk_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 llxmk_links ADD UNIQUE INDEX uk_links (objectid,label);'
Request 106 sql='ALTER TABLE llxmk_expensereport ADD UNIQUE INDEX idx_expensereport_uk_ref (ref, entity);'
Request 107 sql='UPDATE llxmk_projet_task SET ref = NULL WHERE ref = '';'
Request 108 sql='ALTER TABLE llxmk_projet_task ADD UNIQUE INDEX uk_projet_task_ref (ref, entity);'
Request 109 sql='ALTER TABLE llxmk_contrat ADD COLUMN fk_user_modif integer;'
Request 110 sql='UPDATE llxmk_accounting_account SET account_parent = 0 WHERE account_parent = '';'
Request 111 sql='ALTER TABLE llxmk_product_price MODIFY COLUMN date_price DATETIME NULL;'
Request 112 sql='ALTER TABLE llxmk_product_price ALTER COLUMN date_price SET DEFAULT NULL;'
Request 113 sql='ALTER TABLE llxmk_product_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 114 sql='ALTER TABLE llxmk_product_customer_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 115 sql='ALTER TABLE llxmk_product_customer_price_log ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 116 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 117 sql='ALTER TABLE llxmk_events MODIFY COLUMN ip varchar(250);'
Request 118 sql='UPDATE llxmk_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';'
Request 119 sql='UPDATE llxmk_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';'
Script processingOK