Connexion au serveur : localhost OK Connexion à la base : dolibarrdebian OK Version du serveur de base de données 5.5.58-0+deb8u1 Merci de patienter quelques instants… Choix du script de migration 5.0.0-6.0.0.sql Request 1 sql='ALTER TABLE llx_accounting_journal MODIFY code VARCHAR(20) CHARACTER SET utf8;' Request 2 sql='ALTER TABLE llx_accounting_journal MODIFY code VARCHAR(20) COLLATE utf8_unicode_ci;' Request 3 sql='ALTER TABLE llx_bank_account MODIFY accountancy_journal VARCHAR(20) CHARACTER SET utf8;' Request 4 sql='ALTER TABLE llx_bank_account MODIFY accountancy_journal VARCHAR(20) COLLATE utf8_unicode_ci;' Request 5 sql='ALTER TABLE llx_holiday_config MODIFY COLUMN name varchar(128);' Request 6 sql='ALTER TABLE llx_supplier_proposaldet CHANGE COLUMN fk_askpricesupplier fk_supplier_proposal integer NOT NULL;' Request 7 sql='SET sql_mode = 'ALLOW_INVALID_DATES';' Request 8 sql='update llx_adherent set datefin = NULL where DATE(STR_TO_DATE(datefin, '%Y-%m-%d')) IS NULL;' Request 9 sql='SET sql_mode = 'NO_ZERO_DATE';' Request 10 sql='update llx_adherent set datefin = NULL where DATE(STR_TO_DATE(datefin, '%Y-%m-%d')) IS NULL;' Request 11 sql='ALTER TABLE llx_opensurvey_sondage MODIFY COLUMN tms timestamp DEFAULT '2001-01-01 00:00:00';' Request 12 sql='ALTER TABLE llx_adherent MODIFY COLUMN datefin datetime NULL;' Request 13 sql='ALTER TABLE llx_chargesociales MODIFY COLUMN date_ech datetime DEFAULT NULL;' Request 14 sql='ALTER TABLE llx_chargesociales MODIFY COLUMN date_ech datetime NOT NULL;' Request 15 sql='SET sql_mode = 'ALLOW_INVALID_DATES';' Request 16 sql='update llx_opensurvey_sondage set tms = date_fin where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' Request 17 sql='SET sql_mode = 'NO_ZERO_DATE';' Request 18 sql='update llx_opensurvey_sondage set tms = date_fin where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' Request 19 sql='ALTER TABLE llx_opensurvey_sondage MODIFY COLUMN date_fin DATETIME NULL DEFAULT NULL;' Request 20 sql='ALTER TABLE llx_opensurvey_sondage MODIFY COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP;' Request 21 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN fk_user_creat integer NOT NULL DEFAULT 0;' Request 22 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN status integer DEFAULT 1 after date_fin;' Request 23 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN entity integer DEFAULT 1 NOT NULL;' Request 24 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_comments tinyint NOT NULL DEFAULT 1;' Request 25 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_spy tinyint NOT NULL DEFAULT 1 AFTER allow_comments;' Request 26 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN sujet TEXT;' Request 27 sql='ALTER TABLE llx_socpeople MODIFY COLUMN zip varchar(25);' Request 28 sql='ALTER TABLE llx_extrafields ADD COLUMN fieldcomputed text;' Request 29 sql='ALTER TABLE llx_extrafields ADD COLUMN fielddefault varchar(255);' Request 30 sql='ALTER TABLE llx_c_typent MODIFY COLUMN libelle varchar(64);' Request 31 sql='ALTER TABLE llx_holiday ADD COLUMN ref varchar(30) NULL;' Request 32 sql='ALTER TABLE llx_holiday ADD COLUMN ref_ext varchar(255);' Request 33 sql='CREATE TABLE llx_notify_def_object(id integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,objet_type varchar(16),objet_id integer NOT NULL,type_notif varchar(16) DEFAULT 'browser',date_notif datetime,user_id integer,moreparam varchar(255))ENGINE=innodb;' Request 34 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' Request 35 sql='ALTER TABLE llx_extrafields ADD COLUMN langs varchar(24);' Request 36 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;' Request 37 sql='ALTER TABLE llx_ecm_files ADD COLUMN ref varchar(128) AFTER rowid;' Request 38 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN fullpath filepath varchar(255);' Request 39 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN filepath filepath varchar(255);' Request 40 sql='ALTER TABLE llx_ecm_files ADD COLUMN position integer;' Request 41 sql='ALTER TABLE llx_ecm_files ADD COLUMN keyword varchar(750);' Request 42 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN keyword keyword varchar(750);' Request 43 sql='ALTER TABLE llx_ecm_files ADD COLUMN gen_or_uploaded varchar(12);' Request 44 sql='ALTER TABLE llx_ecm_files DROP INDEX uk_ecm_files;' Request 45 sql='ALTER TABLE llx_ecm_files ADD UNIQUE INDEX uk_ecm_files (filepath, filename, entity);' Request 46 sql='ALTER TABLE llx_ecm_files ADD INDEX idx_ecm_files_label (label);' Request 47 sql='ALTER TABLE llx_expedition ADD COLUMN fk_projet integer DEFAULT NULL after fk_soc;' Request 48 sql='ALTER TABLE llx_holiday ADD COLUMN import_key varchar(14);' Request 49 sql='ALTER TABLE llx_holiday ADD COLUMN extraparams varchar(255);' Request 50 sql='ALTER TABLE llx_expensereport ADD COLUMN import_key varchar(14);' Request 51 sql='ALTER TABLE llx_expensereport ADD COLUMN extraparams varchar(255);' Request 52 sql='ALTER TABLE llx_actioncomm ADD COLUMN import_key varchar(14);' Request 53 sql='ALTER TABLE llx_actioncomm ADD COLUMN extraparams varchar(255);' Request 54 sql='ALTER TABLE llx_bank_account ADD COLUMN extraparams varchar(255);' Request 55 sql='ALTER TABLE llx_bank ADD COLUMN numero_compte varchar(32) NULL;' Request 56 sql='ALTER TABLE llx_bank_account MODIFY COLUMN state_id integer DEFAULT NULL;' Request 57 sql='ALTER TABLE llx_adherent MODIFY COLUMN state_id integer DEFAULT NULL;' Request 58 sql='ALTER TABLE llx_adherent MODIFY COLUMN country integer DEFAULT NULL;' Request 59 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('PRODUCT_CREATE','Product or service created','Executed when a product or sevice is created','product',30);' Request 60 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('PRODUCT_MODIFY','Product or service modified','Executed when a product or sevice is modified','product',30);' Request 61 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('PRODUCT_DELETE','Product or service deleted','Executed when a product or sevice is deleted','product',30);' Request 62 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('EXPENSE_REPORT_CREATE','Expense report created','Executed when an expense report is created','expense_report',201);' Request 63 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('EXPENSE_REPORT_CREATE','Expense report created','Executed when an expense report is created','expense_report',201);' Request 64 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('EXPENSE_REPORT_VALIDATE','Expense report validated','Executed when an expense report is validated','expense_report',202);' Request 65 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('EXPENSE_REPORT_APPROVE','Expense report approved','Executed when an expense report is approved','expense_report',203);' Request 66 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('EXPENSE_REPORT_PAYED','Expense report billed','Executed when an expense report is set as billed','expense_report',204);' Request 67 sql='ALTER TABLE llx_c_email_templates ADD COLUMN content_lines text;' Request 68 sql='ALTER TABLE llx_loan ADD COLUMN fk_projet integer DEFAULT NULL;' Request 69 sql='ALTER TABLE llx_holiday ADD COLUMN fk_user_modif integer;' Request 70 sql='ALTER TABLE llx_projet ADD COLUMN fk_user_modif integer;' Request 71 sql='ALTER TABLE llx_projet_task ADD COLUMN fk_user_modif integer;' Request 72 sql='ALTER TABLE llx_projet_task_time ADD COLUMN datec date;' Request 73 sql='ALTER TABLE llx_projet_task_time ADD COLUMN tms timestamp;' Request 74 sql='ALTER TABLE llx_product_price ADD COLUMN fk_multicurrency integer;' Request 75 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_code varchar(255);' Request 76 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' Request 77 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' Request 78 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' Request 79 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN fk_user_creat integer;' Request 80 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN fk_user_modif integer;' Request 81 sql='ALTER TABLE llx_product_price_by_qty DROP COLUMN date_price;' Request 82 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN tms timestamp;' Request 83 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN import_key varchar(14);' Request 84 sql='ALTER TABLE llx_user ADD COLUMN import_key varchar(14);' Request 85 sql='ALTER TABLE llx_facture_rec ADD COLUMN tms timestamp;' Request 86 sql='UPDATE llx_facture_rec SET tms = datec where tms < '2000-01-01';' Request 87 sql='CREATE TABLE llx_product_attribute(rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT,ref VARCHAR(255) NOT NULL,label VARCHAR(255) NOT NULL,rang INT DEFAULT 0 NOT NULL,entity INT DEFAULT 1 NOT NULL);' Request 88 sql='ALTER TABLE llx_product_attribute ADD CONSTRAINT unique_ref UNIQUE (ref);' Request 89 sql='CREATE TABLE llx_product_attribute_value(rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT,fk_product_attribute INT NOT NULL,ref VARCHAR(255) DEFAULT NULL,value VARCHAR(255) DEFAULT NULL,entity INT DEFAULT 1 NOT NULL);' Request 90 sql='ALTER TABLE llx_product_attribute_value ADD CONSTRAINT unique_ref UNIQUE (fk_product_attribute,ref);' Request 91 sql='CREATE TABLE llx_product_attribute_combination2val(rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT,fk_prod_combination INT NOT NULL,fk_prod_attr INT NOT NULL,fk_prod_attr_val INT NOT NULL);' Request 92 sql='CREATE TABLE llx_product_attribute_combination(rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT,fk_product_parent INT NOT NULL,fk_product_child INT NOT NULL,variation_price FLOAT NOT NULL,variation_price_percentage INT NULL,variation_weight FLOAT NOT NULL,entity INT DEFAULT 1 NOT NULL);' Request 93 sql='ALTER TABLE llx_bank_account DROP FOREIGN KEY bank_fk_accountancy_journal;' Request 94 sql='ALTER TABLE llx_accounting_journal ADD COLUMN entity integer DEFAULT 1;' Request 95 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (1,'VT', 'Sale journal', 2, 1);' Request 96 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (2,'AC', 'Purchase journal', 3, 1);' Request 97 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (3,'BQ', 'Bank journal', 4, 1);' Request 98 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (4,'OD', 'Other journal', 1, 1);' Request 99 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (5,'AN', 'Has new journal', 9, 1);' Request 100 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (6,'ER', 'Expense report journal', 5, 1);' Request 101 sql='UPDATE llx_accounting_journal SET nature = 1 WHERE code = 'OD' AND nature = 0;' Request 102 sql='UPDATE llx_accounting_journal SET nature = 2 WHERE code = 'VT' AND nature = 1;' Request 103 sql='UPDATE llx_accounting_journal SET nature = 3 WHERE code = 'AC' AND nature = 2;' Request 104 sql='UPDATE llx_accounting_journal SET nature = 4 WHERE (code = 'BK' OR code = 'BQ') AND nature = 3;' Request 105 sql='UPDATE llx_bank_account SET accountancy_journal = 'BQ' WHERE accountancy_journal = 'BK';' Request 106 sql='UPDATE llx_bank_account SET accountancy_journal = 'OD' WHERE accountancy_journal IS NULL;' Request 107 sql='ALTER TABLE llx_bank_account ADD COLUMN fk_accountancy_journal integer;' Request 108 sql='ALTER TABLE llx_bank_account ADD INDEX idx_fk_accountancy_journal (fk_accountancy_journal);' Request 109 sql='UPDATE llx_bank_account AS ba SET fk_accountancy_journal = (SELECT rowid FROM llx_accounting_journal AS aj WHERE ba.accountancy_journal = aj.code) WHERE accountancy_journal NOT IN ('1', '2', '3', '4', '5', '6', '5', '8', '9', '10', '11', '12', '13', '14', '15');' Request 110 sql='ALTER TABLE llx_bank_account ADD CONSTRAINT fk_bank_account_accountancy_journal FOREIGN KEY (fk_accountancy_journal) REFERENCES llx_accounting_journal (rowid);' Request 111 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_tiers varchar(32);' Request 112 sql='ALTER TABLE llx_accounting_bookkeeping CHANGE COLUMN code_tiers thirdparty_code varchar(32);' Request 113 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN subledger_account varchar(32);' Request 114 sql='ALTER TABLE llx_accounting_bookkeeping CHANGE COLUMN thirdparty_label subledger_label varchar(255);' Request 115 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN subledger_label varchar(255) AFTER subledger_account;' Request 116 sql='UPDATE llx_accounting_bookkeeping SET subledger_account = numero_compte WHERE subledger_account IS NULL;' Request 117 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN label_compte varchar(255);' Request 118 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32);' Request 119 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN label_operation varchar(255) AFTER label_compte;' Request 120 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN multicurrency_amount double AFTER sens;' Request 121 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN multicurrency_code varchar(255) AFTER multicurrency_amount;' Request 122 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN lettering_code varchar(255) AFTER multicurrency_code;' Request 123 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_lettering datetime AFTER lettering_code;' Request 124 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN journal_label varchar(255) AFTER code_journal;' Request 125 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_validated datetime AFTER validated;' Request 126 sql='DROP TABLE llx_accounting_bookkeeping_tmp;' Request 127 sql='CREATE TABLE llx_accounting_bookkeeping_tmp(rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,doc_date date NOT NULL,doc_type varchar(30) NOT NULL,doc_ref varchar(300) NOT NULL,fk_doc integer NOT NULL,fk_docdet integer NOT NULL,thirdparty_code varchar(32),subledger_account varchar(32),subledger_label varchar(255),numero_compte varchar(32),label_compte varchar(255) NOT NULL,label_operation varchar(255),debit double(24,8) NOT NULL,credit double(24,8) NOT NULL,montant double(24,8) NOT NULL,sens varchar(1) DEFAULT NULL,multicurrency_amount double(24,8),multicurrency_code varchar(255),lettering_code varchar(255),date_lettering datetime,fk_user_author integer NOT NULL,fk_user_modif integer,date_creation datetime,tms timestamp,import_key varchar(14),code_journal varchar(32) NOT NULL,journal_label varchar(255),piece_num integer NOT NULL,validated tinyint DEFAULT 0 NOT NULL,date_validated datetime) ENGINE=innodb;' Request 128 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_doc_date (doc_date);' Request 129 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_fk_docdet (fk_docdet);' Request 130 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_numero_compte (numero_compte);' Request 131 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_code_journal (code_journal);' Request 132 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN debit double(24,8);' Request 133 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN credit double(24,8);' Request 134 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN montant double(24,8);' Request 135 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN multicurrency_amount double(24,8);' Request 136 sql='ALTER TABLE llx_paiementfourn ADD COLUMN model_pdf varchar(255);' Request 137 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_CREATE','Expense report created','Executed when an expense report is created','expensereport',201);' Request 138 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_VALIDATE','Expense report validated','Executed when an expense report is validated','expensereport',202);' Request 139 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_APPROVE','Expense report approved','Executed when an expense report is approved','expensereport',203);' Request 140 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_PAYED','Expense report billed','Executed when an expense report is set as billed','expensereport',204);' Request 141 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_CREATE' ,'Leave request created','Executed when a leave request is created','holiday',221);' Request 142 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Leave request validated','Executed when a leave request is validated','holiday',222);' Request 143 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE' ,'Leave request approved','Executed when a leave request is approved','holiday',223);' Request 144 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN fk_invoice_supplier_line integer;' Request 145 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN fk_invoice_supplier integer;' Request 146 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN fk_invoice_supplier_source integer;' Request 147 sql='ALTER TABLE llx_societe_remise_except ADD CONSTRAINT fk_soc_remise_fk_invoice_supplier_line FOREIGN KEY (fk_invoice_supplier_line) REFERENCES llx_facture_fourn_det (rowid);' Request 148 sql='ALTER TABLE llx_societe_remise_except ADD CONSTRAINT fk_societe_remise_fk_invoice_supplier FOREIGN KEY (fk_invoice_supplier) REFERENCES llx_facture_fourn (rowid);' Request 149 sql='ALTER TABLE llx_societe_remise_except ADD CONSTRAINT fk_societe_remise_fk_invoice_supplier_source FOREIGN KEY (fk_invoice_supplier) REFERENCES llx_facture_fourn (rowid);' Request 150 sql='ALTER TABLE llx_facture_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '';' Request 151 sql='ALTER TABLE llx_expensereport_det ADD COLUMN vat_src_code varchar(10) DEFAULT '';' Request 152 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ADHERENT_BANK_USE_AUTO')__;' Request 153 sql='UPDATE llx_const SET value = __ENCRYPT('moono-lisa')__ WHERE value = __ENCRYPT('moono')__ AND name = __ENCRYPT('FCKEDITOR_SKIN')__;' Request 154 sql='DELETE FROM llx_document_model where nom = 'fsfe.fr.php' and type='donation';' Request 155 sql='ALTER TABLE llx_product_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' Request 156 sql='ALTER TABLE llx_product_customer_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' Request 157 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' Request 158 sql='ALTER TABLE llx_user ADD COLUMN model_pdf varchar(255);' Request 159 sql='ALTER TABLE llx_usergroup ADD COLUMN model_pdf varchar(255);' Request 160 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('PRODUCT_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/products')__, 'chaine', 0, '');' Request 161 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('CONTRACT_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/contracts')__, 'chaine', 0, '');' Request 162 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('USERGROUP_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/usergroups')__, 'chaine', 0, '');' Request 163 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('USER_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/users')__, 'chaine', 0, '');' Request 164 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('MAIN_ENABLE_OVERWRITE_TRANSLATION')__, 1, __ENCRYPT('1')__, 'chaine', 0, 'Enable overwrote of translation');' Request 165 sql='ALTER TABLE llx_chargesociales ADD COLUMN ref varchar(16);' Request 166 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_projet integer DEFAULT NULL;' Request 167 sql='ALTER TABLE llx_cronjob ADD COLUMN processing integer NOT NULL DEFAULT 0;' Request 168 sql='ALTER TABLE llx_website ADD COLUMN fk_user_create integer;' Request 169 sql='ALTER TABLE llx_website ADD COLUMN fk_user_modif integer;' Request 170 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' Request 171 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' Request 172 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_multicurrency integer;' Request 173 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_code varchar(255);' Request 174 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' Request 175 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' Request 176 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' Request 177 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN fk_multicurrency integer;' Request 178 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_code varchar(255);' Request 179 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' Request 180 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' Request 181 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' Request 182 sql='UPDATE llx_contrat SET ref = rowid WHERE ref IS NULL OR ref = '';' Request 183 sql='ALTER TABLE llx_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '';' Request 184 sql='CREATE TABLE llx_payment_various(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,datec datetime,datep date,datev date,sens smallint DEFAULT 0 NOT NULL,amount double(24,8) DEFAULT 0 NOT NULL,fk_typepayment integer NOT NULL,num_payment varchar(50),label varchar(255),accountancy_code varchar(32),entity integer DEFAULT 1 NOT NULL,note text,fk_bank integer,fk_user_author integer,fk_user_modif integer)ENGINE=innodb;' Request 185 sql='CREATE TABLE llx_default_values(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,type varchar(10),user_id integer DEFAULT 0 NOT NULL,page varchar(255),param varchar(255),value varchar(128))ENGINE=innodb;' Request 186 sql='ALTER TABLE llx_default_values ADD UNIQUE INDEX uk_default_values(type, entity, user_id, page, param);' Request 187 sql='ALTER TABLE llx_supplier_proposaldet ADD INDEX idx_supplier_proposaldet_fk_supplier_proposal (fk_supplier_proposal);' Request 188 sql='ALTER TABLE llx_supplier_proposaldet ADD INDEX idx_supplier_proposaldet_fk_product (fk_product);' Request 189 sql='UPDATE llx_supplier_proposaldet SET fk_unit = NULL where fk_unit not in (SELECT rowid from llx_c_units);' Request 190 sql='ALTER TABLE llx_supplier_proposaldet ADD CONSTRAINT fk_supplier_proposaldet_fk_unit FOREIGN KEY (fk_unit) REFERENCES llx_c_units (rowid);' Request 191 sql='ALTER TABLE llx_supplier_proposaldet ADD CONSTRAINT fk_supplier_proposaldet_fk_supplier_proposal FOREIGN KEY (fk_supplier_proposal) REFERENCES llx_supplier_proposal (rowid);' Request 192 sql='CREATE TABLE llx_inventory(rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 0,ref varchar(48),datec datetime DEFAULT NULL,tms timestamp,fk_user_author integer,fk_user_modif integer,fk_user_valid integer,fk_warehouse integer DEFAULT 0,status integer DEFAULT 0,title varchar(255) NOT NULL,date_inventory datetime DEFAULT NULL,import_key varchar(14))ENGINE=InnoDB;' Request 193 sql='CREATE TABLE llx_inventorydet(rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY,datec datetime DEFAULT NULL,tms timestamp,fk_inventory integer DEFAULT 0,fk_warehouse integer DEFAULT 0,fk_product integer DEFAULT 0,batch varchar(30) DEFAULT NULL,qty_view double DEFAULT NULL,qty_stock double DEFAULT NULL,qty_regulated double DEFAULT NULL,pmp double DEFAULT 0,pa double DEFAULT 0,new_pmp double DEFAULT 0)ENGINE=InnoDB;' Request 194 sql='ALTER TABLE llx_inventory ADD COLUMN datec datetime DEFAULT NULL;' Request 195 sql='ALTER TABLE llx_inventory ADD INDEX idx_inventory_tms (tms);' Request 196 sql='ALTER TABLE llx_inventory ADD INDEX idx_inventory_datec (datec);' Request 197 sql='ALTER TABLE llx_inventorydet ADD INDEX idx_inventorydet_tms (tms);' Request 198 sql='ALTER TABLE llx_inventorydet ADD INDEX idx_inventorydet_datec (datec);' Request 199 sql='ALTER TABLE llx_inventorydet ADD INDEX idx_inventorydet_fk_inventory (fk_inventory);' Request 200 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,note,active) VALUES (1, '8.5', '85', '0','VAT standard rate (DOM sauf Guyane et Saint-Martin)',0);' Request 201 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,note,active) VALUES (1, '8.5', '85NPR', '1','VAT standard rate (DOM sauf Guyane et Saint-Martin), non perçu par le vendeur mais récupérable par acheteur',0);' Request 202 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,localtax1,localtax1_type,note,active) VALUES (1, '8.5', '85NPROM', '1', 2, 3, 'VAT standard rate (DOM sauf Guyane et Saint-Martin), NPR, Octroi de Mer',0);' Request 203 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,localtax1,localtax1_type,localtax2,localtax2_type,note,active) VALUES (1, '8.5', '85NPROMOMR', '1', 2, 3, 2.5, 3, 'VAT standard rate (DOM sauf Guyane et Saint-Martin), NPR, Octroi de Mer et Octroi de Mer Regional',0);' Request 204 sql='ALTER TABLE llx_events MODIFY COLUMN ip varchar(250);' Request 205 sql='ALTER TABLE llx_facture ADD COLUMN fk_fac_rec_source integer;' Request 206 sql='DELETE FROM llx_c_actioncomm WHERE code IN ('AC_PROP','AC_COM','AC_FAC','AC_SHIP','AC_SUP_ORD','AC_SUP_INV') AND id NOT IN (SELECT DISTINCT fk_action FROM llx_actioncomm);' Request 207 sql='DELETE FROM llx_categorie_product WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 0);' Request 208 sql='DELETE FROM llx_categorie_societe WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type IN (1, 2));' Request 209 sql='DELETE FROM llx_categorie_member WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 3);' Request 210 sql='DELETE FROM llx_categorie_contact WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 4);' Request 211 sql='DELETE FROM llx_categorie_project WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 5);' Request 212 sql='ALTER TABLE llx_inventory ADD COLUMN ref varchar(48);' Request 213 sql='CREATE TABLE llx_loan_schedule(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_loan integer,datec datetime,tms timestamp,datep datetime,amount_capital real DEFAULT 0,amount_insurance real DEFAULT 0,amount_interest real DEFAULT 0,fk_typepayment integer NOT NULL,num_payment varchar(50),note_private text,note_public text,fk_bank integer NOT NULL,fk_user_creat integer,fk_user_modif integer)ENGINE=innodb;' Request 214 sql='ALTER TABLE llx_tva ADD COLUMN datec date AFTER tms;' Request 215 sql='ALTER TABLE llx_user_rights ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;' Request 216 sql='ALTER TABLE llx_user_rights DROP FOREIGN KEY fk_user_rights_fk_user_user;' Request 217 sql='ALTER TABLE llx_user_rights DROP INDEX uk_user_rights;' Request 218 sql='ALTER TABLE llx_user_rights DROP INDEX fk_user;' Request 219 sql='ALTER TABLE llx_user_rights ADD UNIQUE INDEX uk_user_rights (entity, fk_user, fk_id);' Request 220 sql='DELETE FROM llx_user_rights WHERE fk_user NOT IN (select rowid from llx_user);' Request 221 sql='ALTER TABLE llx_user_rights ADD CONSTRAINT fk_user_rights_fk_user_user FOREIGN KEY (fk_user) REFERENCES llx_user (rowid);' Request 222 sql='ALTER TABLE llx_usergroup_rights ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;' Request 223 sql='ALTER TABLE llx_usergroup_rights DROP FOREIGN KEY fk_usergroup_rights_fk_usergroup;' Request 224 sql='ALTER TABLE llx_usergroup_rights DROP INDEX fk_usergroup;' Request 225 sql='ALTER TABLE llx_usergroup_rights ADD UNIQUE INDEX uk_usergroup_rights (entity, fk_usergroup, fk_id);' Request 226 sql='ALTER TABLE llx_usergroup_rights ADD CONSTRAINT fk_usergroup_rights_fk_usergroup FOREIGN KEY (fk_usergroup) REFERENCES llx_usergroup (rowid);' Request 227 sql='CREATE TABLE llx_website_page(rowid integer AUTO_INCREMENT NOT NULL PRIMARY KEY,fk_website integer NOT NULL,pageurl varchar(16) NOT NULL,title varchar(255),description varchar(255),keywords varchar(255),content mediumtext,status integer,fk_user_create integer,fk_user_modif integer,date_creation datetime,tms timestamp) ENGINE=innodb;' Request 228 sql='ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);' Request 229 sql='ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERENCES llx_website (rowid);' Request 230 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;' Request 231 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;' Request 232 sql='UPDATE llx_extrafields set elementtype='categorie' where elementtype='categories';' Request 233 sql='CREATE TABLE llx_blockedlog(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,action varchar(50),amounts real NOT NULL,signature varchar(100) NOT NULL,signature_line varchar(100) NOT NULL,element varchar(50),fk_object integer,ref_object varchar(100),date_object datetime,object_data text,fk_user integer,entity integer DEFAULT 1 NOT NULL,certified integer) ENGINE=innodb;' Request 234 sql='ALTER TABLE llx_blockedlog ADD INDEX signature (signature);' Request 235 sql='ALTER TABLE llx_blockedlog ADD INDEX fk_object_element (fk_object,element);' Request 236 sql='ALTER TABLE llx_blockedlog ADD INDEX entity (entity);' Request 237 sql='ALTER TABLE llx_blockedlog ADD INDEX fk_user (fk_user);' Request 238 sql='ALTER TABLE llx_blockedlog ADD INDEX entity_action (entity,action);' Request 239 sql='ALTER TABLE llx_blockedlog ADD INDEX entity_action_certified (entity,action,certified);' Request 240 sql='CREATE TABLE llx_blockedlog_authority(rowid integer AUTO_INCREMENT PRIMARY KEY,blockchain longtext NOT NULL,signature varchar(100) NOT NULL,tms timestamp) ENGINE=innodb;' Request 241 sql='ALTER TABLE llx_blockedlog_authority ADD INDEX signature (signature);' Request 242 sql='INSERT IGNORE INTO llx_product_lot (entity, fk_product, batch, eatby, sellby, datec, fk_user_creat, fk_user_modif) SELECT DISTINCT e.entity, ps.fk_product, pb.batch, pb.eatby, pb.sellby, pb.tms, e.fk_user_author, e.fk_user_author from llx_product_batch as pb, llx_product_stock as ps, llx_entrepot as e WHERE pb.fk_product_stock = ps.rowid AND ps.fk_entrepot = e.rowid;' Request 243 sql='UPDATE llx_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';' Request 244 sql='UPDATE llx_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';' Request 245 sql='UPDATE llx_bank SET label= '(payment_salary)' WHERE label LIKE 'Règlement salaire';' Request 246 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN source_url varchar(255);' Request 247 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1178, 117, 'C+S-5', 0, 2.5, '1', 2.5, '1', 0, 'CGST+SGST - Same state sales', 1);' Request 248 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1179, 117, 'I-5' , 5, 0, '0', 0, '0', 0, 'IGST', 1);' Request 249 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1180, 117, 'C+S-12', 0, 6, '1', 6, '1', 0, 'CGST+SGST - Same state sales', 1);' Request 250 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1181, 117, 'I-12' , 12, 0, '0', 0, '0', 0, 'IGST', 1);' Request 251 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1176, 117, 'C+S-18', 0, 9, '1', 9, '1', 0, 'CGST+SGST - Same state sales', 1);' Request 252 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1177, 117, 'I-18' , 18, 0, '0', 0, '0', 0, 'IGST', 1);' Request 253 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1182, 117, 'C+S-28', 0, 14, '1', 14, '1', 0, 'CGST+SGST - Same state sales', 1);' Request 254 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1183, 117, 'I-28' , 28, 0, '0', 0, '0', 0, 'IGST', 1);' Exécution du script OK