Dolibarr logo
8.0.3

Dolibarr install or upgrade

Database Database migration (structure + some data)

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

Choose migration script5.0.0-6.0.0.sql
Request 1 sql='ALTER TABLE llxmk_accounting_journal MODIFY code VARCHAR(20) CHARACTER SET utf8;'
Request 2 sql='ALTER TABLE llxmk_accounting_journal MODIFY code VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 3 sql='ALTER TABLE llxmk_bank_account MODIFY accountancy_journal VARCHAR(20) CHARACTER SET utf8;'
Request 4 sql='ALTER TABLE llxmk_bank_account MODIFY accountancy_journal VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 5 sql='ALTER TABLE llxmk_holiday_config MODIFY COLUMN name varchar(128);'
Request 6 sql='ALTER TABLE llxmk_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 llxmk_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 llxmk_adherent set datefin = NULL where DATE(STR_TO_DATE(datefin, '%Y-%m-%d')) IS NULL;'
Request 11 sql='ALTER TABLE llxmk_opensurvey_sondage MODIFY COLUMN tms timestamp DEFAULT '2001-01-01 00:00:00';'
Request 12 sql='ALTER TABLE llxmk_adherent MODIFY COLUMN datefin datetime NULL;'
Request 13 sql='ALTER TABLE llxmk_chargesociales MODIFY COLUMN date_ech datetime DEFAULT NULL;'
Request 14 sql='ALTER TABLE llxmk_chargesociales MODIFY COLUMN date_ech datetime NOT NULL;'
Request 15 sql='SET sql_mode = 'ALLOW_INVALID_DATES';'
Request 16 sql='update llxmk_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 llxmk_opensurvey_sondage set tms = date_fin where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;'
Request 19 sql='ALTER TABLE llxmk_opensurvey_sondage MODIFY COLUMN date_fin DATETIME NULL DEFAULT NULL;'
Request 20 sql='ALTER TABLE llxmk_opensurvey_sondage MODIFY COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP;'
Request 21 sql='ALTER TABLE llxmk_opensurvey_sondage ADD COLUMN fk_user_creat integer NOT NULL DEFAULT 0;'
Request 22 sql='ALTER TABLE llxmk_opensurvey_sondage ADD COLUMN status integer DEFAULT 1 after date_fin;'
Request 23 sql='ALTER TABLE llxmk_opensurvey_sondage ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 24 sql='ALTER TABLE llxmk_opensurvey_sondage ADD COLUMN allow_comments tinyint NOT NULL DEFAULT 1;'
Request 25 sql='ALTER TABLE llxmk_opensurvey_sondage ADD COLUMN allow_spy tinyint NOT NULL DEFAULT 1 AFTER allow_comments;'
Request 26 sql='ALTER TABLE llxmk_opensurvey_sondage ADD COLUMN sujet TEXT;'
Request 27 sql='ALTER TABLE llxmk_socpeople MODIFY COLUMN zip varchar(25);'
Request 28 sql='ALTER TABLE llxmk_extrafields ADD COLUMN fieldcomputed text;'
Request 29 sql='ALTER TABLE llxmk_extrafields ADD COLUMN fielddefault varchar(255);'
Request 30 sql='ALTER TABLE llxmk_c_typent MODIFY COLUMN libelle varchar(64);'
Request 31 sql='ALTER TABLE llxmk_holiday ADD COLUMN ref varchar(30) NULL;'
Request 32 sql='ALTER TABLE llxmk_holiday ADD COLUMN ref_ext varchar(255);'
Request 33 sql='CREATE TABLE llxmk_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 llxmk_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 35 sql='ALTER TABLE llxmk_extrafields ADD COLUMN langs varchar(24);'
Request 36 sql='ALTER TABLE llxmk_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;'
Request 37 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN ref varchar(128) AFTER rowid;'
Request 38 sql='ALTER TABLE llxmk_ecm_files CHANGE COLUMN fullpath filepath varchar(255);'
Request 39 sql='ALTER TABLE llxmk_ecm_files CHANGE COLUMN filepath filepath varchar(255);'
Request 40 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN position integer;'
Request 41 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN keyword varchar(750);'
Request 42 sql='ALTER TABLE llxmk_ecm_files CHANGE COLUMN keyword keyword varchar(750);'
Request 43 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN gen_or_uploaded varchar(12);'
Request 44 sql='ALTER TABLE llxmk_ecm_files DROP INDEX uk_ecm_files;'
Request 45 sql='ALTER TABLE llxmk_ecm_files ADD UNIQUE INDEX uk_ecm_files (filepath, filename, entity);'
Request 46 sql='ALTER TABLE llxmk_ecm_files ADD INDEX idx_ecm_files_label (label);'
Request 47 sql='ALTER TABLE llxmk_expedition ADD COLUMN fk_projet integer DEFAULT NULL after fk_soc;'
Request 48 sql='ALTER TABLE llxmk_holiday ADD COLUMN import_key varchar(14);'
Request 49 sql='ALTER TABLE llxmk_holiday ADD COLUMN extraparams varchar(255);'
Request 50 sql='ALTER TABLE llxmk_expensereport ADD COLUMN import_key varchar(14);'
Request 51 sql='ALTER TABLE llxmk_expensereport ADD COLUMN extraparams varchar(255);'
Request 52 sql='ALTER TABLE llxmk_actioncomm ADD COLUMN import_key varchar(14);'
Request 53 sql='ALTER TABLE llxmk_actioncomm ADD COLUMN extraparams varchar(255);'
Request 54 sql='ALTER TABLE llxmk_bank_account ADD COLUMN extraparams varchar(255);'
Request 55 sql='ALTER TABLE llxmk_bank ADD COLUMN numero_compte varchar(32) NULL;'
Request 56 sql='ALTER TABLE llxmk_bank_account MODIFY COLUMN state_id integer DEFAULT NULL;'
Request 57 sql='ALTER TABLE llxmk_adherent MODIFY COLUMN state_id integer DEFAULT NULL;'
Request 58 sql='ALTER TABLE llxmk_adherent MODIFY COLUMN country integer DEFAULT NULL;'
Request 59 sql='INSERT INTO llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_c_email_templates ADD COLUMN content_lines text;'
Request 68 sql='ALTER TABLE llxmk_loan ADD COLUMN fk_projet integer DEFAULT NULL;'
Request 69 sql='ALTER TABLE llxmk_holiday ADD COLUMN fk_user_modif integer;'
Request 70 sql='ALTER TABLE llxmk_projet ADD COLUMN fk_user_modif integer;'
Request 71 sql='ALTER TABLE llxmk_projet_task ADD COLUMN fk_user_modif integer;'
Request 72 sql='ALTER TABLE llxmk_projet_task_time ADD COLUMN datec date;'
Request 73 sql='ALTER TABLE llxmk_projet_task_time ADD COLUMN tms timestamp;'
Request 74 sql='ALTER TABLE llxmk_product_price ADD COLUMN fk_multicurrency integer;'
Request 75 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_code varchar(255);'
Request 76 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 77 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;'
Request 78 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;'
Request 79 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN fk_user_creat integer;'
Request 80 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN fk_user_modif integer;'
Request 81 sql='ALTER TABLE llxmk_product_price_by_qty DROP COLUMN date_price;'
Request 82 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN tms timestamp;'
Request 83 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN import_key varchar(14);'
Request 84 sql='ALTER TABLE llxmk_user ADD COLUMN import_key varchar(14);'
Request 85 sql='ALTER TABLE llxmk_facture_rec ADD COLUMN tms timestamp;'
Request 86 sql='UPDATE llxmk_facture_rec SET tms = datec where tms < '2000-01-01';'
Request 87 sql='CREATE TABLE llxmk_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 llxmk_product_attribute ADD CONSTRAINT unique_ref UNIQUE (ref);'
Request 89 sql='CREATE TABLE llxmk_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 llxmk_product_attribute_value ADD CONSTRAINT unique_ref UNIQUE (fk_product_attribute,ref);'
Request 91 sql='CREATE TABLE llxmk_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 llxmk_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 llxmk_bank_account DROP FOREIGN KEY bank_fk_accountancy_journal;'
Request 94 sql='ALTER TABLE llxmk_accounting_journal ADD COLUMN entity integer DEFAULT 1;'
Request 95 sql='INSERT INTO llxmk_accounting_journal (rowid, code, label, nature, active) VALUES (1,'VT', 'Sale journal', 2, 1);'
Request 96 sql='INSERT INTO llxmk_accounting_journal (rowid, code, label, nature, active) VALUES (2,'AC', 'Purchase journal', 3, 1);'
Request 97 sql='INSERT INTO llxmk_accounting_journal (rowid, code, label, nature, active) VALUES (3,'BQ', 'Bank journal', 4, 1);'
Request 98 sql='INSERT INTO llxmk_accounting_journal (rowid, code, label, nature, active) VALUES (4,'OD', 'Other journal', 1, 1);'
Request 99 sql='INSERT INTO llxmk_accounting_journal (rowid, code, label, nature, active) VALUES (5,'AN', 'Has new journal', 9, 1);'
Request 100 sql='INSERT INTO llxmk_accounting_journal (rowid, code, label, nature, active) VALUES (6,'ER', 'Expense report journal', 5, 1);'
Request 101 sql='UPDATE llxmk_accounting_journal SET nature = 1 WHERE code = 'OD' AND nature = 0;'
Request 102 sql='UPDATE llxmk_accounting_journal SET nature = 2 WHERE code = 'VT' AND nature = 1;'
Request 103 sql='UPDATE llxmk_accounting_journal SET nature = 3 WHERE code = 'AC' AND nature = 2;'
Request 104 sql='UPDATE llxmk_accounting_journal SET nature = 4 WHERE (code = 'BK' OR code = 'BQ') AND nature = 3;'
Request 105 sql='UPDATE llxmk_bank_account SET accountancy_journal = 'BQ' WHERE accountancy_journal = 'BK';'
Request 106 sql='UPDATE llxmk_bank_account SET accountancy_journal = 'OD' WHERE accountancy_journal IS NULL;'
Request 107 sql='ALTER TABLE llxmk_bank_account ADD COLUMN fk_accountancy_journal integer;'
Request 108 sql='ALTER TABLE llxmk_bank_account ADD INDEX idx_fk_accountancy_journal (fk_accountancy_journal);'
Request 109 sql='UPDATE llxmk_bank_account AS ba SET fk_accountancy_journal = (SELECT rowid FROM llxmk_accounting_journal AS aj WHERE ba.accountancy_journal = aj.code AND aj.entity = ba.entity) 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 llxmk_bank_account ADD CONSTRAINT fk_bank_account_accountancy_journal FOREIGN KEY (fk_accountancy_journal) REFERENCES llxmk_accounting_journal (rowid);'
Request 111 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN code_tiers varchar(32);'
Request 112 sql='ALTER TABLE llxmk_accounting_bookkeeping CHANGE COLUMN code_tiers thirdparty_code varchar(32);'
Request 113 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN subledger_account varchar(32);'
Request 114 sql='ALTER TABLE llxmk_accounting_bookkeeping CHANGE COLUMN thirdparty_label subledger_label varchar(255);'
Request 115 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN subledger_label varchar(255) AFTER subledger_account;'
Request 116 sql='UPDATE llxmk_accounting_bookkeeping SET subledger_account = numero_compte WHERE subledger_account IS NULL;'
Request 117 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN label_compte varchar(255);'
Request 118 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32);'
Request 119 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN label_operation varchar(255) AFTER label_compte;'
Request 120 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN multicurrency_amount double AFTER sens;'
Request 121 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN multicurrency_code varchar(255) AFTER multicurrency_amount;'
Request 122 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN lettering_code varchar(255) AFTER multicurrency_code;'
Request 123 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN date_lettering datetime AFTER lettering_code;'
Request 124 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN journal_label varchar(255) AFTER code_journal;'
Request 125 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN date_validated datetime AFTER validated;'
Request 126 sql='DROP TABLE llxmk_accounting_bookkeeping_tmp;'
Request 127 sql='CREATE TABLE llxmk_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 llxmk_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_doc_date (doc_date);'
Request 129 sql='ALTER TABLE llxmk_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_fk_docdet (fk_docdet);'
Request 130 sql='ALTER TABLE llxmk_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_numero_compte (numero_compte);'
Request 131 sql='ALTER TABLE llxmk_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_code_journal (code_journal);'
Request 132 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN debit double(24,8);'
Request 133 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN credit double(24,8);'
Request 134 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN montant double(24,8);'
Request 135 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY COLUMN multicurrency_amount double(24,8);'
Request 136 sql='ALTER TABLE llxmk_paiementfourn ADD COLUMN model_pdf varchar(255);'
Request 137 sql='insert into llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_societe_remise_except ADD COLUMN fk_invoice_supplier_line integer;'
Request 145 sql='ALTER TABLE llxmk_societe_remise_except ADD COLUMN fk_invoice_supplier integer;'
Request 146 sql='ALTER TABLE llxmk_societe_remise_except ADD COLUMN fk_invoice_supplier_source integer;'
Request 147 sql='ALTER TABLE llxmk_societe_remise_except ADD CONSTRAINT fk_soc_remise_fk_invoice_supplier_line FOREIGN KEY (fk_invoice_supplier_line) REFERENCES llxmk_facture_fourn_det (rowid);'
Request 148 sql='ALTER TABLE llxmk_societe_remise_except ADD CONSTRAINT fk_societe_remise_fk_invoice_supplier FOREIGN KEY (fk_invoice_supplier) REFERENCES llxmk_facture_fourn (rowid);'
Request 149 sql='ALTER TABLE llxmk_societe_remise_except ADD CONSTRAINT fk_societe_remise_fk_invoice_supplier_source FOREIGN KEY (fk_invoice_supplier) REFERENCES llxmk_facture_fourn (rowid);'
Request 150 sql='ALTER TABLE llxmk_facture_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '';'
Request 151 sql='ALTER TABLE llxmk_expensereport_det ADD COLUMN vat_src_code varchar(10) DEFAULT '';'
Request 152 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ADHERENT_BANK_USE_AUTO')__;'
Request 153 sql='UPDATE llxmk_const SET value = __ENCRYPT('moono-lisa')__ WHERE value = __ENCRYPT('moono')__ AND name = __ENCRYPT('FCKEDITOR_SKIN')__;'
Request 154 sql='DELETE FROM llxmk_document_model where nom = 'fsfe.fr.php' and type='donation';'
Request 155 sql='ALTER TABLE llxmk_product_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;'
Request 156 sql='ALTER TABLE llxmk_product_customer_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;'
Request 157 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;'
Request 158 sql='ALTER TABLE llxmk_user ADD COLUMN model_pdf varchar(255);'
Request 159 sql='ALTER TABLE llxmk_usergroup ADD COLUMN model_pdf varchar(255);'
Request 160 sql='INSERT INTO llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_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 llxmk_chargesociales ADD COLUMN ref varchar(16);'
Request 166 sql='ALTER TABLE llxmk_chargesociales ADD COLUMN fk_projet integer DEFAULT NULL;'
Request 167 sql='ALTER TABLE llxmk_cronjob ADD COLUMN processing integer NOT NULL DEFAULT 0;'
Request 168 sql='ALTER TABLE llxmk_website ADD COLUMN fk_user_create integer;'
Request 169 sql='ALTER TABLE llxmk_website ADD COLUMN fk_user_modif integer;'
Request 170 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 171 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;'
Request 172 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN fk_multicurrency integer;'
Request 173 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN multicurrency_code varchar(255);'
Request 174 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 175 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;'
Request 176 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;'
Request 177 sql='ALTER TABLE llxmk_product_fournisseur_price_log ADD COLUMN fk_multicurrency integer;'
Request 178 sql='ALTER TABLE llxmk_product_fournisseur_price_log ADD COLUMN multicurrency_code varchar(255);'
Request 179 sql='ALTER TABLE llxmk_product_fournisseur_price_log ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 180 sql='ALTER TABLE llxmk_product_fournisseur_price_log ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;'
Request 181 sql='ALTER TABLE llxmk_product_fournisseur_price_log ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;'
Request 182 sql='ALTER TABLE llxmk_product_customer_price_log ADD COLUMN default_vat_code varchar(10);'
Request 183 sql='UPDATE llxmk_contrat SET ref = rowid WHERE ref IS NULL OR ref = '';'
Request 184 sql='ALTER TABLE llxmk_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '';'
Request 185 sql='CREATE TABLE llxmk_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 186 sql='CREATE TABLE llxmk_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 187 sql='ALTER TABLE llxmk_default_values ADD UNIQUE INDEX uk_default_values(type, entity, user_id, page, param);'
Request 188 sql='ALTER TABLE llxmk_supplier_proposaldet ADD INDEX idx_supplier_proposaldet_fk_supplier_proposal (fk_supplier_proposal);'
Request 189 sql='ALTER TABLE llxmk_supplier_proposaldet ADD INDEX idx_supplier_proposaldet_fk_product (fk_product);'
Request 190 sql='UPDATE llxmk_supplier_proposaldet SET fk_unit = NULL where fk_unit not in (SELECT rowid from llxmk_c_units);'
Request 191 sql='ALTER TABLE llxmk_supplier_proposaldet ADD CONSTRAINT fk_supplier_proposaldet_fk_unit FOREIGN KEY (fk_unit) REFERENCES llxmk_c_units (rowid);'
Request 192 sql='ALTER TABLE llxmk_supplier_proposaldet ADD CONSTRAINT fk_supplier_proposaldet_fk_supplier_proposal FOREIGN KEY (fk_supplier_proposal) REFERENCES llxmk_supplier_proposal (rowid);'
Request 193 sql='CREATE TABLE llxmk_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 194 sql='CREATE TABLE llxmk_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 195 sql='ALTER TABLE llxmk_inventory ADD COLUMN datec datetime DEFAULT NULL;'
Request 196 sql='ALTER TABLE llxmk_inventory ADD COLUMN tms timestamp;'
Request 197 sql='ALTER TABLE llxmk_inventory ADD INDEX idx_inventory_tms (tms);'
Request 198 sql='ALTER TABLE llxmk_inventory ADD INDEX idx_inventory_datec (datec);'
Request 199 sql='ALTER TABLE llxmk_inventorydet ADD INDEX idx_inventorydet_tms (tms);'
Request 200 sql='ALTER TABLE llxmk_inventorydet ADD INDEX idx_inventorydet_datec (datec);'
Request 201 sql='ALTER TABLE llxmk_inventorydet ADD INDEX idx_inventorydet_fk_inventory (fk_inventory);'
Request 202 sql='INSERT INTO llxmk_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 203 sql='INSERT INTO llxmk_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 204 sql='INSERT INTO llxmk_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 205 sql='INSERT INTO llxmk_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 206 sql='ALTER TABLE llxmk_events MODIFY COLUMN ip varchar(250);'
Request 207 sql='ALTER TABLE llxmk_facture ADD COLUMN fk_fac_rec_source integer;'
Request 208 sql='DELETE FROM llxmk_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 llxmk_actioncomm);'
Request 209 sql='DELETE FROM llxmk_categorie_product WHERE fk_categorie NOT IN (SELECT rowid FROM llxmk_categorie WHERE type = 0);'
Request 210 sql='DELETE FROM llxmk_categorie_societe WHERE fk_categorie NOT IN (SELECT rowid FROM llxmk_categorie WHERE type IN (1, 2));'
Request 211 sql='DELETE FROM llxmk_categorie_member WHERE fk_categorie NOT IN (SELECT rowid FROM llxmk_categorie WHERE type = 3);'
Request 212 sql='DELETE FROM llxmk_categorie_contact WHERE fk_categorie NOT IN (SELECT rowid FROM llxmk_categorie WHERE type = 4);'
Request 213 sql='DELETE FROM llxmk_categorie_project WHERE fk_categorie NOT IN (SELECT rowid FROM llxmk_categorie WHERE type = 6);'
Request 214 sql='ALTER TABLE llxmk_inventory ADD COLUMN ref varchar(48);'
Request 215 sql='CREATE TABLE llxmk_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 216 sql='ALTER TABLE llxmk_tva ADD COLUMN datec date AFTER tms;'
Request 217 sql='ALTER TABLE llxmk_user_rights ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 218 sql='ALTER TABLE llxmk_user_rights DROP FOREIGN KEY fk_user_rights_fk_user_user;'
Request 219 sql='ALTER TABLE llxmk_user_rights DROP INDEX uk_user_rights;'
Request 220 sql='ALTER TABLE llxmk_user_rights DROP INDEX fk_user;'
Request 221 sql='ALTER TABLE llxmk_user_rights ADD UNIQUE INDEX uk_user_rights (entity, fk_user, fk_id);'
Request 222 sql='DELETE FROM llxmk_user_rights WHERE fk_user NOT IN (select rowid from llxmk_user);'
Request 223 sql='ALTER TABLE llxmk_user_rights ADD CONSTRAINT fk_user_rights_fk_user_user FOREIGN KEY (fk_user) REFERENCES llxmk_user (rowid);'
Request 224 sql='ALTER TABLE llxmk_usergroup_rights ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 225 sql='ALTER TABLE llxmk_usergroup_rights DROP FOREIGN KEY fk_usergroup_rights_fk_usergroup;'
Request 226 sql='ALTER TABLE llxmk_usergroup_rights DROP INDEX fk_usergroup;'
Request 227 sql='ALTER TABLE llxmk_usergroup_rights ADD UNIQUE INDEX uk_usergroup_rights (entity, fk_usergroup, fk_id);'
Request 228 sql='ALTER TABLE llxmk_usergroup_rights ADD CONSTRAINT fk_usergroup_rights_fk_usergroup FOREIGN KEY (fk_usergroup) REFERENCES llxmk_usergroup (rowid);'
Request 229 sql='CREATE TABLE llxmk_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 230 sql='ALTER TABLE llxmk_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);'
Request 231 sql='ALTER TABLE llxmk_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERENCES llxmk_website (rowid);'
Request 232 sql='ALTER TABLE llxmk_website_page ADD COLUMN fk_user_create integer;'
Request 233 sql='ALTER TABLE llxmk_website_page ADD COLUMN fk_user_modif integer;'
Request 234 sql='UPDATE llxmk_extrafields set elementtype='categorie' where elementtype='categories';'
Request 235 sql='CREATE TABLE llxmk_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 236 sql='ALTER TABLE llxmk_blockedlog ADD INDEX signature (signature);'
Request 237 sql='ALTER TABLE llxmk_blockedlog ADD INDEX fk_object_element (fk_object,element);'
Request 238 sql='ALTER TABLE llxmk_blockedlog ADD INDEX entity (entity);'
Request 239 sql='ALTER TABLE llxmk_blockedlog ADD INDEX fk_user (fk_user);'
Request 240 sql='ALTER TABLE llxmk_blockedlog ADD INDEX entity_action (entity,action);'
Request 241 sql='ALTER TABLE llxmk_blockedlog ADD INDEX entity_action_certified (entity,action,certified);'
Request 242 sql='CREATE TABLE llxmk_blockedlog_authority(rowid integer AUTO_INCREMENT PRIMARY KEY,blockchain longtext NOT NULL,signature varchar(100) NOT NULL,tms timestamp) ENGINE=innodb;'
Request 243 sql='ALTER TABLE llxmk_blockedlog_authority ADD INDEX signature (signature);'
Request 244 sql='INSERT IGNORE INTO llxmk_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 llxmk_product_batch as pb, llxmk_product_stock as ps, llxmk_entrepot as e WHERE pb.fk_product_stock = ps.rowid AND ps.fk_entrepot = e.rowid;'
Request 245 sql='UPDATE llxmk_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';'
Request 246 sql='UPDATE llxmk_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';'
Request 247 sql='UPDATE llxmk_bank SET label= '(payment_salary)' WHERE label LIKE 'Règlement salaire';'
Request 248 sql='ALTER TABLE llxmk_mailing_cibles MODIFY COLUMN source_url varchar(255);'
Request 249 sql='CREATE TABLE llxmk_facture_rec_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 250 sql='ALTER TABLE llxmk_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);'
Request 251 sql='CREATE TABLE llxmk_facturedet_rec_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14))ENGINE=innodb;'
Request 252 sql='ALTER TABLE llxmk_facturedet_rec_extrafields ADD INDEX idx_facturedet_rec_extrafields (fk_object);'
Request 253 sql='insert into llxmk_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 254 sql='insert into llxmk_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 255 sql='insert into llxmk_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 256 sql='insert into llxmk_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 257 sql='insert into llxmk_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 258 sql='insert into llxmk_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 259 sql='insert into llxmk_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 260 sql='insert into llxmk_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);'
Script processingOK