Dolibarr logo
20.0.1

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : localhostOK
Database connection : htech_iasOK
Database server version10.6.20-MariaDB-cll-lve
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script3.9.0-4.0.0.sql
Request 1 sql='DROP TABLE llx_accountingtransaction;'
Request 2 sql='DROP TABLE llx_accountingdebcred;'
Request 3 sql='ALTER TABLE llx_product ADD COLUMN localtax1_type varchar(10) NOT NULL DEFAULT '0' after localtax1_tx;'
Request 4 sql='ALTER TABLE llx_product ADD COLUMN localtax2_type varchar(10) NOT NULL DEFAULT '0' after localtax2_tx;'
Request 5 sql='ALTER TABLE llx_product_price ADD COLUMN localtax1_type varchar(10) NOT NULL DEFAULT '0' after localtax1_tx;'
Request 6 sql='ALTER TABLE llx_product_price ADD COLUMN localtax2_type varchar(10) NOT NULL DEFAULT '0' after localtax2_tx;'
Request 7 sql='ALTER TABLE llx_product_customer_price ADD COLUMN localtax1_type varchar(10) NOT NULL DEFAULT '0' after localtax1_tx;'
Request 8 sql='ALTER TABLE llx_product_customer_price ADD COLUMN localtax2_type varchar(10) NOT NULL DEFAULT '0' after localtax2_tx;'
Request 9 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN localtax1_type varchar(10) NOT NULL DEFAULT '0' after localtax1_tx;'
Request 10 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN localtax2_type varchar(10) NOT NULL DEFAULT '0' after localtax2_tx;'
Request 11 sql='ALTER TABLE llx_supplier_proposaldet CHANGE COLUMN fk_askpricesupplier fk_supplier_proposal integer NOT NULL;'
Request 12 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN status integer DEFAULT 1 after date_fin;'
Request 13 sql='ALTER TABLE llx_expedition ADD COLUMN billed smallint DEFAULT 0;'
Request 14 sql='insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (150, 'dolresource','internal', 'USERINCHARGE', 'In charge of resource', 1);'
Request 15 sql='insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (151, 'dolresource','external', 'THIRDINCHARGE', 'In charge of resource', 1);'
Request 16 sql='DELETE FROM llx_user_param where param = 'MAIN_THEME' and value in ('auguria', 'amarok', 'cameleo');'
Request 17 sql='CREATE TABLE llx_product_lot ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1, fk_product integer NOT NULL, batch varchar(30) DEFAULT NULL, eatby date DEFAULT NULL, sellby date DEFAULT NULL, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer, fk_user_modif integer, import_key integer ) ENGINE=InnoDB;'
Request 18 sql='ALTER TABLE llx_product_lot ADD UNIQUE INDEX uk_product_lot(fk_product, batch);'
Request 19 sql='ALTER TABLE llx_product_lot MODIFY COLUMN entity integer DEFAULT 1;'
Request 20 sql='UPDATE llx_product_lot SET entity = 1 WHERE entity IS NULL;'
Request 21 sql='DROP TABLE llx_stock_serial;'
Request 22 sql='ALTER TABLE llx_product ADD COLUMN note_public text;'
Request 23 sql='ALTER TABLE llx_user ADD COLUMN note_public text;'
Request 24 sql='ALTER TABLE llx_c_type_contact ADD COLUMN position integer NOT NULL DEFAULT 0;'
Request 25 sql='ALTER TABLE llx_product ADD COLUMN model_pdf varchar(255) default '';'
Request 26 sql='ALTER TABLE llx_product ADD COLUMN width float DEFAULT NULL;'
Request 27 sql='ALTER TABLE llx_product ADD COLUMN width_units tinyint DEFAULT NULL;'
Request 28 sql='ALTER TABLE llx_product ADD COLUMN height float DEFAULT NULL;'
Request 29 sql='ALTER TABLE llx_product ADD COLUMN height_units tinyint DEFAULT NULL;'
Request 30 sql='ALTER TABLE llx_product ADD COLUMN default_vat_code varchar(10) after cost_price;'
Request 31 sql='ALTER TABLE llx_product MODIFY COLUMN stock real;'
Request 32 sql='CREATE TABLE llx_categorie_user ( fk_categorie integer NOT NULL, fk_user integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 33 sql='ALTER TABLE llx_categorie_user ADD PRIMARY KEY pk_categorie_user (fk_categorie, fk_user);'
Request 34 sql='ALTER TABLE llx_categorie_user ADD INDEX idx_categorie_user_fk_categorie (fk_categorie);'
Request 35 sql='ALTER TABLE llx_categorie_user ADD INDEX idx_categorie_user_fk_user (fk_user);'
Request 36 sql='ALTER TABLE llx_categorie_user ADD CONSTRAINT fk_categorie_user_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 37 sql='ALTER TABLE llx_categorie_user ADD CONSTRAINT fk_categorie_user_fk_user FOREIGN KEY (fk_user) REFERENCES llx_user (rowid);'
Request 38 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN validated tinyint DEFAULT 0 NOT NULL;'
Request 39 sql='ALTER TABLE llx_bank_account MODIFY COLUMN accountancy_journal varchar(16) DEFAULT NULL;'
Request 40 sql='ALTER TABLE llx_fichinter ADD COLUMN datet date after duree;'
Request 41 sql='ALTER TABLE llx_fichinter ADD COLUMN datee date after duree;'
Request 42 sql='ALTER TABLE llx_fichinter ADD COLUMN dateo date after duree;'
Request 43 sql='ALTER TABLE llx_projet ADD COLUMN opp_percent double(5,2) after fk_opp_status;'
Request 44 sql='UPDATE llx_projet as p set opp_percent = (SELECT percent from llx_c_lead_status as cls where cls.rowid = p.fk_opp_status) where opp_percent IS NULL;'
Request 45 sql='ALTER TABLE llx_overwrite_trans ADD UNIQUE INDEX uk_overwrite_trans(lang, transkey);'
Request 46 sql='ALTER TABLE llx_cronjob MODIFY COLUMN unitfrequency varchar(255) NOT NULL DEFAULT '3600';'
Request 47 sql='ALTER TABLE llx_cronjob ADD COLUMN test varchar(255) DEFAULT '1';'
Request 48 sql='ALTER TABLE llx_facture ADD INDEX idx_facture_fk_statut (fk_statut);'
Request 49 sql='ALTER TABLE llx_facture ADD COLUMN date_pointoftax date DEFAULT NULL;'
Request 50 sql='UPDATE llx_projet as p set p.opp_percent = (SELECT percent FROM llx_c_lead_status as cls WHERE cls.rowid = p.fk_opp_status) WHERE p.opp_percent IS NULL AND p.fk_opp_status IS NOT NULL;'
Request 51 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_contract_line integer NULL AFTER rang;'
Request 52 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN import_key varchar(14);'
Request 53 sql='ALTER TABLE llx_chargesociales ADD COLUMN import_key varchar(14);'
Request 54 sql='ALTER TABLE llx_tva ADD COLUMN import_key varchar(14);'
Request 55 sql='CREATE TABLE llx_website ( rowid integer AUTO_INCREMENT NOT NULL PRIMARY KEY, entity integer DEFAULT 1, ref varchar(24) NOT NULL, description varchar(255), status integer, fk_default_home integer, date_creation datetime, date_modification datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=innodb;'
Request 56 sql='ALTER TABLE llx_website ADD COLUMN fk_default_home integer;'
Request 57 sql='ALTER TABLE llx_website CHANGE COLUMN shortname ref varchar(24) NOT NULL;'
Request 58 sql='ALTER TABLE llx_website ADD UNIQUE INDEX uk_website_ref (ref, entity);'
Request 59 sql='CREATE TABLE llx_website_page ( rowid integer AUTO_INCREMENT NOT NULL PRIMARY KEY, fk_website integer, pageurl varchar(16) NOT NULL, title varchar(255), description varchar(255), keywords varchar(255), content text, status integer, date_creation datetime, date_modification datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=innodb;'
Request 60 sql='ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);'
Request 61 sql='ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERENCES llx_website (rowid);'
Request 62 sql='CREATE TABLE llx_c_format_cards ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, code varchar(50) NOT NULL, name varchar(50) NOT NULL, paper_size varchar(20) NOT NULL, orientation varchar(1) NOT NULL, metric varchar(5) NOT NULL, leftmargin double(24,8) NOT NULL, topmargin double(24,8) NOT NULL, nx integer NOT NULL, ny integer NOT NULL, spacex double(24,8) NOT NULL, spacey double(24,8) NOT NULL, width double(24,8) NOT NULL, height double(24,8) NOT NULL, font_size integer NOT NULL, custom_x double(24,8) NOT NULL, custom_y double(24,8) NOT NULL, active integer NOT NULL ) ENGINE=InnoDB;'
Request 63 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (1, '5160', 'Avery-5160, WL-875WX', 'letter', 'P', 'mm', 5.58165000, 12.70000000, 3, 10, 3.55600000, 0.00000000, 65.87490000, 25.40000000, 7, 0.00000000, 0.00000000, 1);'
Request 64 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (2, '5161', 'Avery-5161, WL-75WX', 'letter', 'P', 'mm', 4.44500000, 12.70000000, 2, 10, 3.96800000, 0.00000000, 101.60000000, 25.40000000, 7, 0.00000000, 0.00000000, 1);'
Request 65 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (3, '5162', 'Avery-5162, WL-100WX', 'letter', 'P', 'mm', 3.87350000, 22.35200000, 2, 7, 4.95400000, 0.00000000, 101.60000000, 33.78100000, 8, 0.00000000, 0.00000000, 1);'
Request 66 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (4, '5163', 'Avery-5163, WL-125WX', 'letter', 'P', 'mm', 4.57200000, 12.70000000, 2, 5, 3.55600000, 0.00000000, 101.60000000, 50.80000000, 10, 0.00000000, 0.00000000, 1);'
Request 67 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (5, '5164', '5164 (Letter)', 'letter', 'P', 'in', 0.14800000, 0.50000000, 2, 3, 0.20310000, 0.00000000, 4.00000000, 3.33000000, 12, 0.00000000, 0.00000000, 0);'
Request 68 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (6, '8600', 'Avery-8600', 'letter', 'P', 'mm', 7.10000000, 19.00000000, 3, 10, 9.50000000, 3.10000000, 66.60000000, 25.40000000, 7, 0.00000000, 0.00000000, 1);'
Request 69 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (7, '99012', 'DYMO 99012 89*36mm', 'custom', 'L', 'mm', 1.00000000, 1.00000000, 1, 1, 0.00000000, 0.00000000, 36.00000000, 89.00000000, 10, 36.00000000, 89.00000000, 1);'
Request 70 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (8, '99014', 'DYMO 99014 101*54mm', 'custom', 'L', 'mm', 1.00000000, 1.00000000, 1, 1, 0.00000000, 0.00000000, 54.00000000, 101.00000000, 10, 54.00000000, 101.00000000, 1);'
Request 71 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (9, 'AVERYC32010', 'Avery-C32010', 'A4', 'P', 'mm', 15.00000000, 13.00000000, 2, 5, 10.00000000, 0.00000000, 85.00000000, 54.00000000, 10, 0.00000000, 0.00000000, 1);'
Request 72 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (10, 'CARD', 'Dolibarr Business cards', 'A4', 'P', 'mm', 15.00000000, 15.00000000, 2, 5, 0.00000000, 0.00000000, 85.00000000, 54.00000000, 10, 0.00000000, 0.00000000, 1);'
Request 73 sql='INSERT INTO llx_c_format_cards (rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active) VALUES (11, 'L7163', 'Avery-L7163', 'A4', 'P', 'mm', 5.00000000, 15.00000000, 2, 7, 2.50000000, 0.00000000, 99.10000000, 38.10000000, 8, 0.00000000, 0.00000000, 1);'
Request 74 sql='ALTER TABLE llx_extrafields ADD COLUMN ishidden integer DEFAULT 0;'
Request 75 sql='ALTER TABLE llx_paiementfourn ADD COLUMN ref varchar(30) AFTER rowid;'
Request 76 sql='ALTER TABLE llx_paiementfourn ADD COLUMN entity integer DEFAULT 1 AFTER ref;'
Request 77 sql='CREATE TABLE llx_multicurrency ( rowid integer AUTO_INCREMENT PRIMARY KEY, date_create datetime DEFAULT NULL, code varchar(255) DEFAULT NULL, name varchar(255) DEFAULT NULL, entity integer DEFAULT 1, fk_user integer DEFAULT NULL ) ENGINE=innodb;'
Request 78 sql='CREATE TABLE llx_multicurrency_rate ( rowid integer AUTO_INCREMENT PRIMARY KEY, date_sync datetime DEFAULT NULL, rate double NOT NULL DEFAULT 0, fk_multicurrency integer NOT NULL ) ENGINE=innodb;'
Request 79 sql='ALTER TABLE llx_societe ADD COLUMN fk_multicurrency integer;'
Request 80 sql='ALTER TABLE llx_societe ADD COLUMN multicurrency_code varchar(255);'
Request 81 sql='ALTER TABLE llx_societe ADD COLUMN fk_shipping_method integer AFTER cond_reglement_supplier;'
Request 82 sql='ALTER TABLE llx_product_price ADD COLUMN fk_multicurrency integer;'
Request 83 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_code varchar(255);'
Request 84 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price double(24,8) DEFAULT 0;'
Request 85 sql='ALTER TABLE llx_commande ADD COLUMN fk_multicurrency integer;'
Request 86 sql='ALTER TABLE llx_commande ADD COLUMN multicurrency_code varchar(255);'
Request 87 sql='ALTER TABLE llx_commande ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 88 sql='ALTER TABLE llx_commande ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 89 sql='ALTER TABLE llx_commande ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 90 sql='ALTER TABLE llx_commande ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 91 sql='ALTER TABLE llx_commandedet ADD COLUMN fk_multicurrency integer;'
Request 92 sql='ALTER TABLE llx_commandedet ADD COLUMN multicurrency_code varchar(255);'
Request 93 sql='ALTER TABLE llx_commandedet ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 94 sql='ALTER TABLE llx_commandedet ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 95 sql='ALTER TABLE llx_commandedet ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 96 sql='ALTER TABLE llx_commandedet ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 97 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN fk_multicurrency integer;'
Request 98 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN multicurrency_code varchar(255);'
Request 99 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 100 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 101 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 102 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 103 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN fk_multicurrency integer;'
Request 104 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN multicurrency_code varchar(255);'
Request 105 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 106 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 107 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 108 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 109 sql='ALTER TABLE llx_facture_fourn ADD COLUMN fk_multicurrency integer;'
Request 110 sql='ALTER TABLE llx_facture_fourn ADD COLUMN multicurrency_code varchar(255);'
Request 111 sql='ALTER TABLE llx_facture_fourn ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 112 sql='ALTER TABLE llx_facture_fourn ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 113 sql='ALTER TABLE llx_facture_fourn ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 114 sql='ALTER TABLE llx_facture_fourn ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 115 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN fk_multicurrency integer;'
Request 116 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN multicurrency_code varchar(255);'
Request 117 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 118 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 119 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 120 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 121 sql='ALTER TABLE llx_facture ADD COLUMN fk_multicurrency integer;'
Request 122 sql='ALTER TABLE llx_facture ADD COLUMN multicurrency_code varchar(255);'
Request 123 sql='ALTER TABLE llx_facture ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 124 sql='ALTER TABLE llx_facture ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 125 sql='ALTER TABLE llx_facture ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 126 sql='ALTER TABLE llx_facture ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 127 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_multicurrency integer;'
Request 128 sql='ALTER TABLE llx_facturedet ADD COLUMN multicurrency_code varchar(255);'
Request 129 sql='ALTER TABLE llx_facturedet ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 130 sql='ALTER TABLE llx_facturedet ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 131 sql='ALTER TABLE llx_facturedet ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 132 sql='ALTER TABLE llx_facturedet ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 133 sql='ALTER TABLE llx_propal ADD COLUMN fk_multicurrency integer;'
Request 134 sql='ALTER TABLE llx_propal ADD COLUMN multicurrency_code varchar(255);'
Request 135 sql='ALTER TABLE llx_propal ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 136 sql='ALTER TABLE llx_propal ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 137 sql='ALTER TABLE llx_propal ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 138 sql='ALTER TABLE llx_propal ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 139 sql='ALTER TABLE llx_propaldet ADD COLUMN fk_multicurrency integer;'
Request 140 sql='ALTER TABLE llx_propaldet ADD COLUMN multicurrency_code varchar(255);'
Request 141 sql='ALTER TABLE llx_propaldet ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 142 sql='ALTER TABLE llx_propaldet ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 143 sql='ALTER TABLE llx_propaldet ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 144 sql='ALTER TABLE llx_propaldet ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 145 sql='ALTER TABLE llx_facture_rec ADD COLUMN auto_validate integer DEFAULT 0;'
Request 146 sql='ALTER TABLE llx_facture_rec ADD COLUMN fk_account integer DEFAULT 0;'
Request 147 sql='ALTER TABLE llx_facture_rec ADD COLUMN fk_multicurrency integer;'
Request 148 sql='ALTER TABLE llx_facture_rec ADD COLUMN multicurrency_code varchar(255);'
Request 149 sql='ALTER TABLE llx_facture_rec ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 150 sql='ALTER TABLE llx_facture_rec ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 151 sql='ALTER TABLE llx_facture_rec ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 152 sql='ALTER TABLE llx_facture_rec ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 153 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN fk_multicurrency integer;'
Request 154 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN multicurrency_code varchar(255);'
Request 155 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 156 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 157 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 158 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 159 sql='ALTER TABLE llx_contratdet ADD COLUMN fk_multicurrency integer;'
Request 160 sql='ALTER TABLE llx_contratdet ADD COLUMN multicurrency_code varchar(255);'
Request 161 sql='ALTER TABLE llx_contratdet ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 162 sql='ALTER TABLE llx_contratdet ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 163 sql='ALTER TABLE llx_contratdet ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 164 sql='ALTER TABLE llx_contratdet ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 165 sql='ALTER TABLE llx_paiement ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 166 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 167 sql='ALTER TABLE llx_paiementfourn ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 168 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 169 sql='ALTER TABLE llx_societe_remise ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 170 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 171 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN multicurrency_amount_ht double(24,8) DEFAULT 0 NOT NULL;'
Request 172 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN multicurrency_amount_tva double(24,8) DEFAULT 0 NOT NULL;'
Request 173 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN multicurrency_amount_ttc double(24,8) DEFAULT 0 NOT NULL;'
Request 174 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN fk_multicurrency integer;'
Request 175 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN multicurrency_code varchar(255);'
Request 176 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 177 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 178 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 179 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 180 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN fk_multicurrency integer;'
Request 181 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN multicurrency_code varchar(255);'
Request 182 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 183 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 184 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 185 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 186 sql='ALTER TABLE llx_expensereport ADD COLUMN fk_multicurrency integer;'
Request 187 sql='ALTER TABLE llx_expensereport ADD COLUMN multicurrency_code varchar(255);'
Request 188 sql='ALTER TABLE llx_expensereport ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 189 sql='ALTER TABLE llx_expensereport ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 190 sql='ALTER TABLE llx_expensereport ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 191 sql='ALTER TABLE llx_expensereport ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 192 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_multicurrency integer;'
Request 193 sql='ALTER TABLE llx_expensereport_det ADD COLUMN multicurrency_code varchar(255);'
Request 194 sql='ALTER TABLE llx_expensereport_det ADD COLUMN multicurrency_subprice double(24,8) DEFAULT 0;'
Request 195 sql='ALTER TABLE llx_expensereport_det ADD COLUMN multicurrency_total_ht double(24,8) DEFAULT 0;'
Request 196 sql='ALTER TABLE llx_expensereport_det ADD COLUMN multicurrency_total_tva double(24,8) DEFAULT 0;'
Request 197 sql='ALTER TABLE llx_expensereport_det ADD COLUMN multicurrency_total_ttc double(24,8) DEFAULT 0;'
Request 198 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_facture integer DEFAULT 0;'
Request 199 sql='ALTER TABLE llx_product_lang ADD COLUMN import_key varchar(14) DEFAULT NULL;'
Request 200 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN elementtype varchar(255) DEFAULT NULL;'
Request 201 sql='ALTER TABLE llx_accounting_system DROP COLUMN fk_pays;'
Request 202 sql='ALTER TABLE llx_accounting_account ADD COLUMN fk_accounting_category integer DEFAULT 0 after label;'
Request 203 sql='CREATE TABLE llx_c_accounting_category ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, code varchar(16) NOT NULL, label varchar(255) NOT NULL, range_account varchar(255) NOT NULL, sens tinyint NOT NULL DEFAULT '0', category_type tinyint NOT NULL DEFAULT '0', formula varchar(255) NOT NULL, position integer DEFAULT 0, fk_country integer DEFAULT NULL, active integer DEFAULT 1 ) ENGINE=innodb;'
Request 204 sql='ALTER TABLE llx_c_accounting_category ADD UNIQUE INDEX uk_c_accounting_category(code);'
Request 205 sql='INSERT INTO llx_c_accounting_category (rowid, code, label, range_account, sens, category_type, formula, position, fk_country, active) VALUES ( 1,'VTE', 'Ventes de marchandises', '707xxx', 0, 0, '', '10', 1, 1);'
Request 206 sql='INSERT INTO llx_c_accounting_category (rowid, code, label, range_account, sens, category_type, formula, position, fk_country, active) VALUES ( 2,'MAR', 'Coût achats marchandises vendues', '603xxx | 607xxx | 609xxx', 0, 0, '', '20', 1, 1);'
Request 207 sql='INSERT INTO llx_c_accounting_category (rowid, code, label, range_account, sens, category_type, formula, position, fk_country, active) VALUES ( 3,'MARGE','Marge commerciale', '', 0, 1, '1 + 2', '30', 1, 1);'
Request 208 sql='UPDATE llx_accounting_account SET account_parent = '0' WHERE account_parent = '';'
Request 209 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN account_parent varchar(32) DEFAULT '0';'
Request 210 sql='CREATE TABLE llx_accounting_journal ( rowid integer AUTO_INCREMENT PRIMARY KEY, code varchar(32) NOT NULL, label varchar(128) NOT NULL, nature smallint DEFAULT 0 NOT NULL, active smallint DEFAULT 0 )ENGINE=innodb;'
Request 211 sql='ALTER TABLE llx_accounting_journal ADD UNIQUE INDEX uk_accounting_journal_code (code);'
Request 212 sql='DROP INDEX uk_bordereau_cheque ON llx_bordereau_cheque;'
Request 213 sql='ALTER TABLE llx_bordereau_cheque CHANGE COLUMN number ref VARCHAR(30) NOT NULL;'
Request 214 sql='CREATE UNIQUE INDEX uk_bordereau_cheque ON llx_bordereau_cheque (ref, entity);'
Request 215 sql='ALTER TABLE llx_societe_rib ADD COLUMN date_rum date after rum;'
Request 216 sql='update llx_c_action_trigger set rang = 140 where code = 'PROJECT_CREATE';'
Request 217 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_MODIFY','Project modified','Executed when a project is modified','project',141);'
Request 218 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_DELETE','Project deleted','Executed when a project is deleted','project',142);'
Request 219 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_CREATE','Supplier order validated','Executed when a supplier order is validated','order_supplier',11);'
Request 220 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_SUBMIT','Supplier order request submited','Executed when a supplier order is approved','order_supplier',12);'
Request 221 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_RECEIVE','Supplier order request received','Executed when a supplier order is received','order_supplier',12);'
Request 222 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_CLASSIFY_BILLED','Supplier order set billed','Executed when a supplier order is set as billed','order_supplier',14);'
Request 223 sql='ALTER TABLE llx_product_fournisseur_price ADD supplier_reputation varchar(10) NULL;'
Request 224 sql='ALTER TABLE llx_product ADD COLUMN default_vat_code varchar(10) after cost_price;'
Request 225 sql='CREATE TABLE llx_categorie_account ( fk_categorie integer NOT NULL, fk_account integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 226 sql='ALTER TABLE llx_categorie_account ADD PRIMARY KEY pk_categorie_account (fk_categorie, fk_account);'
Request 227 sql='ALTER TABLE llx_categorie_account ADD INDEX idx_categorie_account_fk_categorie (fk_categorie);'
Request 228 sql='ALTER TABLE llx_categorie_account ADD INDEX idx_categorie_account_fk_account (fk_account);'
Request 229 sql='ALTER TABLE llx_categorie_account ADD CONSTRAINT fk_categorie_account_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 230 sql='ALTER TABLE llx_categorie_account ADD CONSTRAINT fk_categorie_account_fk_account FOREIGN KEY (fk_account) REFERENCES llx_bank_account (rowid);'
Request 231 sql='ALTER TABLE llx_product_stock DROP COLUMN pmp;'
Request 232 sql='ALTER TABLE llx_resource ADD COLUMN asset_number varchar(255) after ref;'
Request 233 sql='ALTER TABLE llx_resource ADD COLUMN datec datetime DEFAULT NULL;'
Request 234 sql='ALTER TABLE llx_resource ADD COLUMN date_valid datetime DEFAULT NULL;'
Request 235 sql='ALTER TABLE llx_resource ADD COLUMN fk_user_author integer DEFAULT NULL;'
Request 236 sql='ALTER TABLE llx_resource ADD COLUMN fk_user_modif integer DEFAULT NULL;'
Request 237 sql='ALTER TABLE llx_resource ADD COLUMN fk_user_valid integer DEFAULT NULL;'
Request 238 sql='ALTER TABLE llx_resource ADD COLUMN fk_statut smallint NOT NULL DEFAULT '0';'
Request 239 sql='ALTER TABLE llx_resource ADD COLUMN import_key varchar(14);'
Request 240 sql='ALTER TABLE llx_resource ADD COLUMN extraparams varchar(255);'
Request 241 sql='ALTER TABLE llx_element_resources ADD COLUMN duree real;'
Request 242 sql='UPDATE llx_element_resources SET resource_type = 'dolresource' WHERE resource_type = 'resource';'
Request 243 sql='CREATE TABLE llx_advtargetemailing ( rowid integer NOT NULL auto_increment PRIMARY KEY, name varchar(200) NOT NULL, entity integer NOT NULL DEFAULT 1, fk_mailing integer NOT NULL, filtervalue text, fk_user_author integer NOT NULL, datec datetime NOT NULL, fk_user_mod integer NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP )ENGINE=InnoDB;'
Request 244 sql='ALTER TABLE llx_advtargetemailing ADD UNIQUE INDEX uk_advtargetemailing_name (name);'
Request 245 sql='update llx_product_batch set batch = '000000' where batch = 'Non défini';'
Request 246 sql='update llx_product_batch set batch = '000000' where batch = 'Non défini';'
Request 247 sql='update llx_product_batch set batch = '000000' where batch = 'Undefined';'
Request 248 sql='update llx_product_batch set batch = '000000' where batch = '';'
Request 249 sql='update llx_product_batch set batch = '000000' where batch = '';'
Request 250 sql='update llx_product_batch set batch = '000000' where batch = '';'
Request 251 sql='update llx_product_lot set batch = '000000' where batch = 'Undefined';'
Request 252 sql='update llx_stock_mouvement set batch = '000000' where batch = 'Undefined';'
Request 253 sql='ALTER TABLE llx_import_model MODIFY COLUMN type varchar(50);'
Request 254 sql='UPDATE llx_projet set fk_opp_status = NULL where fk_opp_status = -1;'
Request 255 sql='UPDATE llx_c_lead_status set code = 'WON' where code = 'WIN';'
Request 256 sql='UPDATE llx_c_lead_status set percent = 100 where code = 'WON';'
Request 257 sql='CREATE TABLE llx_oauth_token ( rowid integer AUTO_INCREMENT PRIMARY KEY, service varchar(36), token text, fk_user integer, fk_adherent integer, entity integer DEFAULT 1 )ENGINE=InnoDB;'
Request 258 sql='CREATE TABLE llx_oauth_state ( rowid integer AUTO_INCREMENT PRIMARY KEY, service varchar(36), state varchar(128), fk_user integer, fk_adherent integer, entity integer DEFAuLT 1 )ENGINE=InnoDB;'
Request 259 sql='ALTER TABLE llx_c_type_resource CHANGE COLUMN rowid rowid integer NOT NULL AUTO_INCREMENT;'
Request 260 sql='ALTER TABLE llx_product_batch ADD UNIQUE INDEX uk_product_batch (fk_product_stock, batch);'
Request 261 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (1781, 178, '7','0','ITBMS standard rate',1);'
Request 262 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (1782, 178, '0','0','ITBMS Rate 0',1);'
Request 263 sql='INSERT INTO llx_c_regions (fk_pays, code_region, cheflieu, tncc, nom, active) values ( 178, 17801, '', 0, 'Panama', 1);'
Request 264 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-1', 17801, '', 0, '', 'Bocas del Toro', 1);'
Request 265 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-2', 17801, '', 0, '', 'Coclé', 1);'
Request 266 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-3', 17801, '', 0, '', 'Colón', 1);'
Request 267 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-4', 17801, '', 0, '', 'Chiriquí', 1);'
Request 268 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-5', 17801, '', 0, '', 'Darién', 1);'
Request 269 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-6', 17801, '', 0, '', 'Herrera', 1);'
Request 270 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-7', 17801, '', 0, '', 'Los Santos', 1);'
Request 271 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-8', 17801, '', 0, '', 'Panamá', 1);'
Request 272 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-9', 17801, '', 0, '', 'Veraguas', 1);'
Request 273 sql='INSERT INTO llx_c_departements (code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA-13', 17801, '', 0, '', 'Panamá Oeste', 1);'
Request 274 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (178, '17801', 'Empresa individual', 1);'
Request 275 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (178, '17802', 'Asociación General', 1);'
Request 276 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (178, '17803', 'Sociedad de Responsabilidad Limitada', 1);'
Request 277 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (178, '17804', 'Sociedad Civil', 1);'
Request 278 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (178, '17805', 'Sociedad Anónima', 1);'
Request 279 sql='ALTER TABLE llx_establishment CHANGE COLUMN fk_user_mod fk_user_mod integer NULL;'
Request 280 sql='ALTER TABLE llx_multicurrency_rate ADD COLUMN entity integer DEFAULT 1;'
Request 281 sql='ALTER TABLE llx_user MODIFY COLUMN login varchar(50);'
Script processingOK - Show-Hide details