1-- 2-- Be carefull to requests order. 3-- This file must be loaded by calling /install/index.php page 4-- when current version is 12.0.0 or higher. 5-- 6-- To restrict request to Mysql version x.y minimum use -- VMYSQLx.y 7-- To restrict request to Pgsql version x.y minimum use -- VPGSQLx.y 8-- To rename a table: ALTER TABLE llx_table RENAME TO llx_table_new; 9-- To add a column: ALTER TABLE llx_table ADD COLUMN newcol varchar(60) NOT NULL DEFAULT '0' AFTER existingcol; 10-- To rename a column: ALTER TABLE llx_table CHANGE COLUMN oldname newname varchar(60); 11-- To drop a column: ALTER TABLE llx_table DROP COLUMN oldname; 12-- To change type of field: ALTER TABLE llx_table MODIFY COLUMN name varchar(60); 13-- To drop a foreign key: ALTER TABLE llx_table DROP FOREIGN KEY fk_name; 14-- To create a unique index ALTER TABLE llx_table ADD UNIQUE INDEX uk_table_field (field); 15-- To drop an index: -- VMYSQL4.1 DROP INDEX nomindex on llx_table 16-- To drop an index: -- VPGSQL8.2 DROP INDEX nomindex 17-- To make pk to be auto increment (mysql): -- VMYSQL4.3 ALTER TABLE llx_table CHANGE COLUMN rowid rowid INTEGER NOT NULL AUTO_INCREMENT; 18-- To make pk to be auto increment (postgres): 19-- -- VPGSQL8.2 CREATE SEQUENCE llx_table_rowid_seq OWNED BY llx_table.rowid; 20-- -- VPGSQL8.2 ALTER TABLE llx_table ADD PRIMARY KEY (rowid); 21-- -- VPGSQL8.2 ALTER TABLE llx_table ALTER COLUMN rowid SET DEFAULT nextval('llx_table_rowid_seq'); 22-- -- VPGSQL8.2 SELECT setval('llx_table_rowid_seq', MAX(rowid)) FROM llx_table; 23-- To set a field as NULL: -- VMYSQL4.3 ALTER TABLE llx_table MODIFY COLUMN name varchar(60) NULL; 24-- To set a field as NULL: -- VPGSQL8.2 ALTER TABLE llx_table ALTER COLUMN name DROP NOT NULL; 25-- To set a field as NOT NULL: -- VMYSQL4.3 ALTER TABLE llx_table MODIFY COLUMN name varchar(60) NOT NULL; 26-- To set a field as NOT NULL: -- VPGSQL8.2 ALTER TABLE llx_table ALTER COLUMN name SET NOT NULL; 27-- To set a field as default NULL: -- VPGSQL8.2 ALTER TABLE llx_table ALTER COLUMN name SET DEFAULT NULL; 28-- Note: fields with type BLOB/TEXT can't have default value. 29 30 31-- Missing in v11 32 33UPDATE llx_c_units set scale = 3600 where code = 'H' and unit_type = 'time'; 34UPDATE llx_c_units set scale = 86400 where code = 'D' and unit_type = 'time'; 35 36create table llx_commande_fournisseur_dispatch_extrafields 37( 38 rowid integer AUTO_INCREMENT PRIMARY KEY, 39 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 40 fk_object integer NOT NULL, -- object id 41 import_key varchar(14) -- import key 42)ENGINE=innodb; 43 44ALTER TABLE llx_commande_fournisseur_dispatch_extrafields ADD INDEX idx_commande_fournisseur_dispatch_extrafields (fk_object); 45 46UPDATE llx_accounting_system SET fk_country = NULL, active = 0 WHERE pcg_version = 'SYSCOHADA'; 47 48create table llx_c_shipment_package_type 49( 50 rowid integer AUTO_INCREMENT PRIMARY KEY, 51 label varchar(50) NOT NULL, -- Short name 52 description varchar(255), -- Description 53 active integer DEFAULT 1 NOT NULL, -- Active or not 54 entity integer DEFAULT 1 NOT NULL -- Multi company id 55)ENGINE=innodb; 56 57create table llx_facturedet_rec_extrafields 58( 59 rowid integer AUTO_INCREMENT PRIMARY KEY, 60 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 61 fk_object integer NOT NULL, -- object id 62 import_key varchar(14) -- import key 63)ENGINE=innodb; 64 65ALTER TABLE llx_facturedet_rec_extrafields ADD INDEX idx_facturedet_rec_extrafields (fk_object); 66 67ALTER TABLE llx_facture_rec MODIFY COLUMN titre varchar(200) NOT NULL; 68 69create table llx_mrp_mo_extrafields 70( 71 rowid integer AUTO_INCREMENT PRIMARY KEY, 72 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 73 fk_object integer NOT NULL, 74 import_key varchar(14) -- import key 75) ENGINE=innodb; 76 77ALTER TABLE llx_mrp_mo_extrafields DROP INDEX idx_fk_object; 78 79ALTER TABLE llx_mrp_mo_extrafields ADD INDEX idx_mrp_mo_fk_object(fk_object); 80 81 82 83-- This var is per entity now, so we remove const if global if exists 84delete from llx_const where name in ('PROJECT_HIDE_TASKS', 'MAIN_BUGTRACK_ENABLELINK', 'MAIN_HELP_DISABLELINK') and entity = 0; 85 86-- For v12 87 88ALTER TABLE llx_bom_bom MODIFY COLUMN duration double(24,8); 89 90ALTER TABLE llx_prelevement_bons ADD COLUMN type varchar(16) DEFAULT 'debit-order'; 91 92ALTER TABLE llx_ecm_files MODIFY COLUMN src_object_type varchar(64); 93 94ALTER TABLE llx_document_model MODIFY COLUMN type varchar(64); 95 96 97-- Delete an old index that is duplicated 98-- VMYSQL4.1 DROP INDEX ix_fk_product_stock on llx_product_batch; 99-- VPGSQL8.2 DROP INDEX ix_fk_product_stock; 100 101ALTER TABLE llx_actioncomm DROP COLUMN punctual; 102 103DELETE FROM llx_menu where module='supplier_proposal'; 104 105UPDATE llx_website SET lang = 'en' WHERE lang like 'en_%'; 106UPDATE llx_website SET lang = 'fr' WHERE lang like 'fr_%'; 107UPDATE llx_website SET lang = 'es' WHERE lang like 'es_%'; 108UPDATE llx_website SET lang = 'de' WHERE lang like 'de_%'; 109UPDATE llx_website SET lang = 'it' WHERE lang like 'it_%'; 110UPDATE llx_website SET lang = 'pt' WHERE lang like 'pt_%'; 111UPDATE llx_website_page SET lang = 'en' WHERE lang like 'en_%'; 112UPDATE llx_website_page SET lang = 'fr' WHERE lang like 'fr_%'; 113UPDATE llx_website_page SET lang = 'es' WHERE lang like 'es_%'; 114UPDATE llx_website_page SET lang = 'de' WHERE lang like 'de_%'; 115UPDATE llx_website_page SET lang = 'it' WHERE lang like 'it_%'; 116UPDATE llx_website_page SET lang = 'pt' WHERE lang like 'pt_%'; 117 118ALTER TABLE llx_website ADD COLUMN lang varchar(8); 119ALTER TABLE llx_website ADD COLUMN otherlang varchar(255); 120 121ALTER TABLE llx_website_page ADD COLUMN author_alias varchar(64); 122 123UPDATE llx_rights_def SET perms = 'order_advance', subperms = 'close' WHERE module = 'commande' AND perms = 'cloturer'; 124UPDATE llx_rights_def SET perms = 'propal_advance', subperms = 'close' WHERE module = 'propale' AND perms = 'cloturer'; 125 126ALTER TABLE llx_holiday_users DROP INDEX uk_holiday_users; 127ALTER TABLE llx_holiday_users ADD UNIQUE INDEX uk_holiday_users(fk_user, fk_type); 128 129ALTER TABLE llx_ticket ADD COLUMN import_key varchar(14); 130 131ALTER TABLE llx_ticket ADD UNIQUE uk_ticket_ref (ref, entity); 132ALTER TABLE llx_ticket ADD INDEX idx_ticket_entity (entity); 133ALTER TABLE llx_ticket ADD INDEX idx_ticket_fk_soc (fk_soc); 134ALTER TABLE llx_ticket ADD INDEX idx_ticket_fk_user_assign (fk_user_assign); 135ALTER TABLE llx_ticket ADD INDEX idx_ticket_fk_project (fk_project); 136ALTER TABLE llx_ticket ADD INDEX idx_ticket_fk_statut (fk_statut); 137 138 139--ALTER TABLE llx_facturerec DROP COLUMN vat_src_code; 140 141 142-- Migration to the new regions (France) 143UPDATE llx_c_regions set nom = 'Centre-Val de Loire' WHERE fk_pays = 1 AND code_region = 24; 144insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 27, '21231', 0, 'Bourgogne-Franche-Comté'); 145insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 28, '76540', 0, 'Normandie'); 146insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 32, '59350', 4, 'Hauts-de-France'); 147insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 44, '67482', 2, 'Grand Est'); 148insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 75, '33063', 0, 'Nouvelle-Aquitaine'); 149insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 76, '31355', 1, 'Occitanie'); 150insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 84, '69123', 1, 'Auvergne-Rhône-Alpes'); 151 152UPDATE llx_c_departements set fk_region = 27 WHERE fk_region = 26 OR fk_region = 43; 153UPDATE llx_c_departements set fk_region = 28 WHERE fk_region = 25 OR fk_region = 23; 154UPDATE llx_c_departements set fk_region = 32 WHERE fk_region = 22 OR fk_region = 31; 155UPDATE llx_c_departements set fk_region = 44 WHERE fk_region = 21 OR fk_region = 41 OR fk_region = 42; 156UPDATE llx_c_departements set fk_region = 75 WHERE fk_region = 54 OR fk_region = 74 OR fk_region = 72; 157UPDATE llx_c_departements set fk_region = 76 WHERE fk_region = 73 OR fk_region = 91; 158UPDATE llx_c_departements set fk_region = 84 WHERE fk_region = 82 OR fk_region = 83; 159 160DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 21; 161DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 22; 162DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 23; 163DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 25; 164DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 26; 165DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 31; 166DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 41; 167DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 42; 168DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 43; 169DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 54; 170DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 72; 171DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 73; 172DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 74; 173DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 82; 174DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 83; 175DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 91; 176 177ALTER TABLE llx_bookmark DROP INDEX uk_bookmark_url; 178ALTER TABLE llx_bookmark DROP INDEX uk_bookmark_title; 179 180ALTER TABLE llx_bookmark MODIFY COLUMN url TEXT; 181 182ALTER TABLE llx_bookmark ADD UNIQUE uk_bookmark_title (fk_user, entity, title); 183 184ALTER TABLE llx_societe_rib MODIFY COLUMN owner_address varchar(255); 185ALTER TABLE llx_societe_rib MODIFY COLUMN default_rib smallint NOT NULL DEFAULT 0; 186 187ALTER TABLE llx_societe_rib ADD COLUMN stripe_account varchar(128); 188 189create table llx_object_lang 190( 191 rowid integer AUTO_INCREMENT PRIMARY KEY, 192 fk_object integer DEFAULT 0 NOT NULL, 193 type_object varchar(32) NOT NULL, -- value found into $object->element 194 property varchar(32) NOT NULL, 195 lang varchar(5) DEFAULT 0 NOT NULL, 196 value text, 197 import_key varchar(14) DEFAULT NULL 198)ENGINE=innodb; 199 200 201ALTER TABLE llx_object_lang ADD UNIQUE INDEX uk_object_lang (fk_object, type_object, property, lang); 202 203 204CREATE TABLE llx_categorie_actioncomm 205( 206 fk_categorie integer NOT NULL, 207 fk_actioncomm integer NOT NULL, 208 import_key varchar(14) 209) ENGINE=innodb; 210 211ALTER TABLE llx_categorie_actioncomm ADD PRIMARY KEY pk_categorie_actioncomm (fk_categorie, fk_actioncomm); 212ALTER TABLE llx_categorie_actioncomm ADD INDEX idx_categorie_actioncomm_fk_categorie (fk_categorie); 213ALTER TABLE llx_categorie_actioncomm ADD INDEX idx_categorie_actioncomm_fk_actioncomm (fk_actioncomm); 214 215ALTER TABLE llx_categorie_actioncomm ADD CONSTRAINT fk_categorie_actioncomm_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid); 216ALTER TABLE llx_categorie_actioncomm ADD CONSTRAINT fk_categorie_actioncomm_fk_actioncomm FOREIGN KEY (fk_actioncomm) REFERENCES llx_actioncomm (id); 217 218 219ALTER TABLE llx_accounting_account ADD COLUMN labelshort varchar(255) DEFAULT NULL after label; 220 221ALTER TABLE llx_subscription ADD COLUMN fk_user_creat integer DEFAULT NULL; 222ALTER TABLE llx_subscription ADD COLUMN fk_user_valid integer DEFAULT NULL; 223 224UPDATE llx_c_forme_juridique set libelle = 'SRL - Société à responsabilité limitée' WHERE code = '201'; 225 226ALTER TABLE llx_c_country ADD COLUMN eec integer; 227UPDATE llx_c_country SET eec = 1 WHERE code IN ('AT','BE','BG','CY','CZ','DE','DK','EE','ES','FI','FR','GB','GR','HR','NL','HU','IE','IM','IT','LT','LU','LV','MC','MT','PL','PT','RO','SE','SK','SI','UK'); 228 229INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, 'PCG18-ASSOC', 'French foundation chart of accounts 2018', 1); 230 231INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, 'PCGAFR14-DEV', 'The developed farm accountancy french plan 2014', 1); 232 233INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 41, 'AT-BASE', 'Plan Austria', 1); 234 235 236 237create table llx_c_ticket_resolution 238( 239 rowid integer AUTO_INCREMENT PRIMARY KEY, 240 entity integer DEFAULT 1, 241 code varchar(32) NOT NULL, 242 pos varchar(32) NOT NULL, 243 label varchar(128) NOT NULL, 244 active integer DEFAULT 1, 245 use_default integer DEFAULT 1, 246 description varchar(255) 247)ENGINE=innodb; 248 249ALTER TABLE llx_c_ticket_resolution ADD UNIQUE INDEX uk_code (code, entity); 250 251INSERT INTO llx_c_ticket_resolution (code, pos, label, active, use_default, description) VALUES('SOLVED', '10', 'Solved', 1, 0, NULL); 252INSERT INTO llx_c_ticket_resolution (code, pos, label, active, use_default, description) VALUES('CANCELED', '50', 'Canceled', 1, 0, NULL); 253INSERT INTO llx_c_ticket_resolution (code, pos, label, active, use_default, description) VALUES('OTHER', '90', 'Other', 1, 0, NULL); 254 255DELETE FROM llx_const WHERE name = __ENCRYPT('DONATION_ART885')__; 256 257-- VMYSQL4.1 ALTER TABLE llx_extrafields MODIFY COLUMN printable integer DEFAULT 0; 258-- VPGSQL8.2 ALTER TABLE llx_extrafields ALTER COLUMN printable DROP DEFAULT; 259-- VPGSQL8.2 ALTER TABLE llx_extrafields MODIFY COLUMN printable integer USING printable::integer; 260-- VPGSQL8.2 ALTER TABLE llx_extrafields ALTER COLUMN printable SET DEFAULT 0; 261ALTER TABLE llx_extrafields ADD COLUMN printable integer DEFAULT 0; 262 263UPDATE llx_const SET name = 'INVOICE_USE_RETAINED_WARRANTY' WHERE name = 'INVOICE_USE_SITUATION_RETAINED_WARRANTY'; 264 265ALTER TABLE llx_accounting_account DROP COLUMN pcg_subtype; 266 267ALTER TABLE llx_product ADD COLUMN accountancy_code_buy_intra varchar(32) AFTER accountancy_code_buy; 268ALTER TABLE llx_product ADD COLUMN accountancy_code_buy_export varchar(32) AFTER accountancy_code_buy_intra; 269 270ALTER TABLE llx_entrepot ADD COLUMN fax varchar(20) DEFAULT NULL; 271ALTER TABLE llx_entrepot ADD COLUMN phone varchar(20) DEFAULT NULL; 272 273ALTER TABLE llx_accounting_account ADD COLUMN reconcilable tinyint DEFAULT 0 NOT NULL after active; 274 275ALTER TABLE llx_categorie MODIFY type integer NOT NULL DEFAULT 1; 276 277ALTER TABLE llx_societe_remise_except ADD COLUMN vat_src_code varchar(10) DEFAULT ''; 278 279ALTER TABLE llx_blockedlog MODIFY COLUMN object_data mediumtext; 280ALTER TABLE llx_blockedlog ADD COLUMN object_version varchar(32) DEFAULT ''; 281 282ALTER TABLE llx_product_lot MODIFY COLUMN batch varchar(128); 283ALTER TABLE llx_product_batch MODIFY COLUMN batch varchar(128); 284ALTER TABLE llx_expeditiondet_batch MODIFY COLUMN batch varchar(128); 285ALTER TABLE llx_commande_fournisseur_dispatch MODIFY COLUMN batch varchar(128); 286ALTER TABLE llx_stock_mouvement MODIFY COLUMN batch varchar(128); 287ALTER TABLE llx_mrp_production MODIFY COLUMN batch varchar(128); 288ALTER TABLE llx_mrp_production MODIFY qty real NOT NULL DEFAULT 1; 289ALTER TABLE llx_expeditiondet_batch MODIFY COLUMN batch varchar(128); 290 291create table llx_categorie_website_page 292( 293 fk_categorie integer NOT NULL, 294 fk_website_page integer NOT NULL, 295 import_key varchar(14) 296)ENGINE=innodb; 297 298ALTER TABLE llx_categorie_website_page ADD PRIMARY KEY pk_categorie_website_page (fk_categorie, fk_website_page); 299ALTER TABLE llx_categorie_website_page ADD INDEX idx_categorie_website_page_fk_categorie (fk_categorie); 300ALTER TABLE llx_categorie_website_page ADD INDEX idx_categorie_website_page_fk_website_page (fk_website_page); 301 302ALTER TABLE llx_categorie_website_page ADD CONSTRAINT fk_categorie_website_page_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid); 303ALTER TABLE llx_categorie_website_page ADD CONSTRAINT fk_categorie_website_page_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid); 304 305ALTER TABLE llx_categorie ADD COLUMN date_creation datetime; 306ALTER TABLE llx_categorie ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP; 307ALTER TABLE llx_categorie ADD COLUMN fk_user_creat integer; 308ALTER TABLE llx_categorie ADD COLUMN fk_user_modif integer; 309 310ALTER TABLE llx_commandedet ADD CONSTRAINT fk_commandedet_fk_commandefourndet FOREIGN KEY (fk_commandefourndet) REFERENCES llx_commande_fournisseurdet (rowid); 311 312-- VMYSQL4.3 ALTER TABLE llx_prelevement_facture_demande MODIFY COLUMN fk_facture INTEGER NULL; 313-- VPGSQL8.2 ALTER TABLE llx_prelevement_facture_demande ALTER COLUMN fk_facture DROP NOT NULL; 314ALTER TABLE llx_prelevement_facture_demande ADD COLUMN fk_facture_fourn INTEGER NULL; 315 316-- VMYSQL4.3 ALTER TABLE llx_prelevement_facture MODIFY COLUMN fk_facture INTEGER NULL; 317-- VPGSQL8.2 ALTER TABLE llx_prelevement_facture ALTER COLUMN fk_facture DROP NOT NULL; 318ALTER TABLE llx_prelevement_facture ADD COLUMN fk_facture_fourn INTEGER NULL; 319 320ALTER TABLE llx_menu MODIFY COLUMN module varchar(255); 321 322UPDATE llx_actioncomm SET fk_action = 50 where fk_action = 40 AND code = 'TICKET_MSG'; 323 324ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN hostcharset varchar(16) DEFAULT 'UTF-8'; 325 326ALTER TABLE llx_adherent_type MODIFY subscription varchar(3) NOT NULL DEFAULT '1'; 327ALTER TABLE llx_adherent_type MODIFY vote varchar(3) NOT NULL DEFAULT '1'; 328 329UPDATE llx_prelevement_facture_demande SET entity = 1 WHERE entity IS NULL; 330 331ALTER TABLE llx_prelevement_facture_demande ADD INDEX idx_prelevement_facture_demande_fk_facture (fk_facture); 332ALTER TABLE llx_prelevement_facture_demande ADD INDEX idx_prelevement_facture_demande_fk_facture_fourn (fk_facture_fourn); 333 334insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (721, 72, '0','0','VAT Rate 0',1); 335insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,localtax1,localtax1_type,note,active) values (722, 72, '18','0', '0.9', '1', 'VAT Rate 18+0.9', 1); 336 337ALTER TABLE llx_expedition ADD COLUMN billed smallint DEFAULT 0; 338 339-- VMYSQL4.3 ALTER TABLE llx_mrp_mo MODIFY COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP; 340 341ALTER TABLE llx_commande_fournisseurdet ADD INDEX idx_commande_fournisseurdet_fk_commande (fk_commande); 342ALTER TABLE llx_commande_fournisseurdet ADD INDEX idx_commande_fournisseurdet_fk_product (fk_product); 343 344 345-- VMYSQL4.3 ALTER TABLE llx_c_shipment_mode MODIFY COLUMN tracking varchar(255) NULL; 346-- VPGSQL8.2 ALTER TABLE llx_c_shipment_mode ALTER COLUMN tracking DROP NOT NULL; 347 348INSERT INTO llx_c_shipment_mode (rowid,code,libelle,description,tracking,active) VALUES (9,'INPERSON', 'In person at your site', NULL, NULL, 0); 349INSERT INTO llx_c_shipment_mode (rowid,code,libelle,description,tracking,active) VALUES (10,'FEDEX', 'Fedex', NULL, 'https://www.fedex.com/apps/fedextrack/index.html?tracknumbers={TRACKID}', 0); 350INSERT INTO llx_c_shipment_mode (rowid,code,libelle,description,tracking,active) VALUES (11,'TNT', 'TNT', NULL, 'https://www.tnt.com/express/fr_fr/site/outils-expedition/suivi.html?searchType=con&cons=={TRACKID}', 0); 351INSERT INTO llx_c_shipment_mode (rowid,code,libelle,description,tracking,active) VALUES (12,'DHL', 'DHL', NULL, 'https://www.dhl.com/fr-fr/home/tracking/tracking-global-forwarding.html?submit=1&tracking-id={TRACKID}', 0); 352INSERT INTO llx_c_shipment_mode (rowid,code,libelle,description,tracking,active) VALUES (13,'DPD', 'DPD', NULL, 'https://www.dpd.fr/trace/{TRACKID}', 0); 353INSERT INTO llx_c_shipment_mode (rowid,code,libelle,description,tracking,active) VALUES (14,'MAINFREIGHT', 'Mainfreight', NULL, 'https://www.mainfreight.com/track?{TRACKID}', 0); 354 355 356UPDATE llx_menu SET perms = '$user->rights->societe->creer' WHERE titre = 'MenuNewThirdParty' AND url = '/societe/card.php?mainmenu=companies&action=create'; 357UPDATE llx_menu SET url = '/societe/list.php?mainmenu=companies&leftmenu=thirdparties' WHERE titre = 'List' AND url = '/societe/list.php?mainmenu=companies&action=create'; 358 359