Dolibarr logo
17.0.2

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : ecoledusdoli.mysql.dbOK
Database connection : ecoledusdoliOK
Database server version8.0.39-30
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script3.1.0-3.2.0.sql
Request 1 sql='DELETE FROM llx_user_param WHERE param = 'MAIN_THEME' and value = 'freelug';'
Request 2 sql='update llx_propal set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 3 sql='update llx_commande set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 4 sql='update llx_facture set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 5 sql='update llx_commande_fournisseur set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 6 sql='update llx_contrat set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 7 sql='update llx_deplacement set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 8 sql='update llx_facture_fourn set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 9 sql='update llx_facture_rec set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 10 sql='update llx_fichinter set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 11 sql='update llx_projet_task set fk_projet = null where fk_projet not in (select rowid from llx_projet);'
Request 12 sql='update llx_propal set fk_user_author = null where fk_user_author not in (select rowid from llx_user);'
Request 13 sql='update llx_propal set fk_user_valid = null where fk_user_valid not in (select rowid from llx_user);'
Request 14 sql='update llx_propal set fk_user_cloture = null where fk_user_cloture not in (select rowid from llx_user);'
Request 15 sql='update llx_commande set fk_user_author = null where fk_user_author not in (select rowid from llx_user);'
Request 16 sql='update llx_commande set fk_user_valid = null where fk_user_valid not in (select rowid from llx_user);'
Request 17 sql='ALTER TABLE llx_extrafields ADD COLUMN type VARCHAR(8);'
Request 18 sql='UPDATE llx_c_paper_format SET active=1 WHERE active=0;'
Request 19 sql='ALTER TABLE llx_actioncomm ADD COLUMN ref_ext varchar(128) after id;'
Request 20 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_availability integer AFTER fk_product_fournisseur;'
Request 21 sql='ALTER TABLE llx_element_element MODIFY COLUMN sourcetype varchar(32) NOT NULL;'
Request 22 sql='ALTER TABLE llx_element_element MODIFY COLUMN targettype varchar(32) NOT NULL;'
Request 23 sql='ALTER TABLE llx_user MODIFY ref_ext varchar(50);'
Request 24 sql='ALTER TABLE llx_user ADD COLUMN ref_int varchar(50) AFTER ref_ext;'
Request 25 sql='ALTER TABLE llx_societe MODIFY code_client varchar(24);'
Request 26 sql='ALTER TABLE llx_societe MODIFY code_fournisseur varchar(24);'
Request 27 sql='ALTER TABLE llx_societe MODIFY siren varchar(128);'
Request 28 sql='ALTER TABLE llx_societe MODIFY siret varchar(128);'
Request 29 sql='ALTER TABLE llx_societe MODIFY ape varchar(128);'
Request 30 sql='ALTER TABLE llx_societe MODIFY idprof4 varchar(128);'
Request 31 sql='ALTER TABLE llx_societe ADD COLUMN idprof5 varchar(128);'
Request 32 sql='ALTER TABLE llx_societe MODIFY code_compta varchar(24);'
Request 33 sql='ALTER TABLE llx_societe MODIFY code_compta_fournisseur varchar(24);'
Request 34 sql='ALTER TABLE llx_chargesociales ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;'
Request 35 sql='ALTER TABLE llx_chargesociales ADD COLUMN date_creation datetime;'
Request 36 sql='ALTER TABLE llx_chargesociales ADD COLUMN date_valid datetime;'
Request 37 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (1, 'EU4A0', 'Format 4A0', '1682', '2378', 'mm', 1);'
Request 38 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (2, 'EU2A0', 'Format 2A0', '1189', '1682', 'mm', 1);'
Request 39 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (3, 'EUA0', 'Format A0', '840', '1189', 'mm', 1);'
Request 40 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (4, 'EUA1', 'Format A1', '594', '840', 'mm', 1);'
Request 41 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (5, 'EUA2', 'Format A2', '420', '594', 'mm', 1);'
Request 42 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (6, 'EUA3', 'Format A3', '297', '420', 'mm', 1);'
Request 43 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (7, 'EUA4', 'Format A4', '210', '297', 'mm', 1);'
Request 44 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (8, 'EUA5', 'Format A5', '148', '210', 'mm', 1);'
Request 45 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (9, 'EUA6', 'Format A6', '105', '148', 'mm', 1);'
Request 46 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (100, 'USLetter', 'Format Letter (A)', '216', '279', 'mm', 1);'
Request 47 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (105, 'USLegal', 'Format Legal', '216', '356', 'mm', 1);'
Request 48 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (110, 'USExecutive', 'Format Executive', '190', '254', 'mm', 1);'
Request 49 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (115, 'USLedger', 'Format Ledger/Tabloid (B)', '279', '432', 'mm', 1);'
Request 50 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (200, 'CAP1', 'Format Canadian P1', '560', '860', 'mm', 1);'
Request 51 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (205, 'CAP2', 'Format Canadian P2', '430', '560', 'mm', 1);'
Request 52 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (210, 'CAP3', 'Format Canadian P3', '280', '430', 'mm', 1);'
Request 53 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (215, 'CAP4', 'Format Canadian P4', '215', '280', 'mm', 1);'
Request 54 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (220, 'CAP5', 'Format Canadian P5', '140', '215', 'mm', 1);'
Request 55 sql='INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (225, 'CAP6', 'Format Canadian P6', '107', '140', 'mm', 1);'
Request 56 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_product integer after tms;'
Request 57 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_soc integer after fk_product;'
Request 58 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN ref_fourn varchar(30) after fk_soc;'
Request 59 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 60 sql='UPDATE llx_product_fournisseur_price as a, llx_product_fournisseur as b SET a.fk_product = b.fk_product, a.fk_soc = b.fk_soc, a.ref_fourn = b.ref_fourn, a.entity = b.entity WHERE a.fk_product_fournisseur = b.rowid AND (a.fk_product IS NULL OR a.fk_soc IS NULL OR a.fk_product = 0 OR a.fk_soc = 0);'
Request 61 sql='ALTER TABLE llx_product_fournisseur_price DROP INDEX uk_product_fournisseur_price_ref;'
Request 62 sql='ALTER TABLE llx_product_fournisseur_price ADD UNIQUE INDEX uk_product_fournisseur_price_ref (ref_fourn, fk_soc, quantity, entity);'
Request 63 sql='ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_fourn_price_fk_product (fk_product, entity);'
Request 64 sql='ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_fourn_price_fk_soc (fk_soc, entity);'
Request 65 sql='ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_fk_product FOREIGN KEY (fk_product) REFERENCES llx_product (rowid);'
Request 66 sql='ALTER TABLE llx_product_fournisseur_price DROP FOREIGN KEY fk_product_fournisseur_price_fk_product_fournisseur;'
Request 67 sql='DROP TABLE IF EXISTS llx_pos_tmp;'
Request 68 sql='ALTER TABLE llx_deplacement ADD COLUMN fk_user_modif integer AFTER fk_user_author;'
Request 69 sql='CREATE TABLE llx_localtax ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer NOT NULL DEFAULT '1', tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, datep date DEFAULT NULL, datev date DEFAULT NULL, amount double NOT NULL DEFAULT '0', label varchar(255) DEFAULT NULL, note text, fk_bank integer DEFAULT NULL, fk_user_creat integer DEFAULT NULL, fk_user_modif integer DEFAULT NULL ) ENGINE=InnoDB;'
Request 70 sql='ALTER TABLE llx_propal MODIFY ref_int varchar(255);'
Request 71 sql='ALTER TABLE llx_propal MODIFY ref_ext varchar(255);'
Request 72 sql='ALTER TABLE llx_propal MODIFY ref_client varchar(255);'
Request 73 sql='ALTER TABLE llx_commande MODIFY ref_int varchar(255);'
Request 74 sql='ALTER TABLE llx_commande MODIFY ref_ext varchar(255);'
Request 75 sql='ALTER TABLE llx_commande MODIFY ref_client varchar(255);'
Request 76 sql='ALTER TABLE llx_facture MODIFY ref_int varchar(255);'
Request 77 sql='ALTER TABLE llx_facture MODIFY ref_ext varchar(255);'
Request 78 sql='ALTER TABLE llx_facture MODIFY ref_client varchar(255);'
Request 79 sql='UPDATE llx_societe SET fk_stcomm = 0 WHERE fk_stcomm IS NULL;'
Request 80 sql='ALTER TABLE llx_societe MODIFY COLUMN fk_stcomm integer NOT NULL;'
Request 81 sql='ALTER TABLE llx_societe CHANGE COLUMN gencod barcode varchar(255);'
Request 82 sql='ALTER TABLE llx_societe ADD COLUMN fk_barcode_type integer DEFAULT 0;'
Request 83 sql='UPDATE llx_menu SET leftmenu = NULL where leftmenu in ('', '0', '1');'
Request 84 sql='ALTER TABLE llx_categorie_societe DROP INDEX fk_categorie;'
Request 85 sql='ALTER TABLE llx_categorie_societe DROP INDEX fk_societe;'
Request 86 sql='ALTER TABLE llx_categorie_fournisseur DROP INDEX fk_categorie;'
Request 87 sql='ALTER TABLE llx_categorie_fournisseur DROP PRIMARY KEY;'
Request 88 sql='ALTER TABLE llx_categorie_fournisseur ADD PRIMARY KEY pk_categorie_fournisseur (fk_categorie, fk_societe);'
Error DB_ERROR_1072: ALTER TABLE llx_categorie_fournisseur ADD PRIMARY KEY pk_categorie_fournisseur (fk_categorie, fk_societe);
Key column 'fk_societe' doesn't exist in table
Request 89 sql='ALTER TABLE llx_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_categorie (fk_categorie);'
Request 90 sql='ALTER TABLE llx_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_societe (fk_societe);'
Request 91 sql='DELETE FROM llx_categorie_fournisseur WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie);'
Request 92 sql='DELETE FROM llx_categorie_fournisseur WHERE fk_societe NOT IN (SELECT rowid FROM llx_societe);'
Request 93 sql='ALTER TABLE llx_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 94 sql='ALTER TABLE llx_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_fk_soc FOREIGN KEY (fk_societe) REFERENCES llx_societe (rowid);'
Error DB_ERROR_1072: ALTER TABLE llx_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_fk_soc FOREIGN KEY (fk_societe) REFERENCES llx_societe (rowid);
Key column 'fk_societe' doesn't exist in table
Request 95 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23201, 232, 23201, '', 0, 'Los Andes', 1);'
Request 96 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23202, 232, 23202, '', 0, 'Capital', 1);'
Request 97 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23203, 232, 23203, '', 0, 'Central', 1);'
Request 98 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23204, 232, 23204, '', 0, 'Cento Occidental', 1);'
Request 99 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23205, 232, 23205, '', 0, 'Guayana', 1);'
Request 100 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23206, 232, 23206, '', 0, 'Insular', 1);'
Request 101 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23207, 232, 23207, '', 0, 'Los Llanos', 1);'
Request 102 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23208, 232, 23208, '', 0, 'Nor-Oriental', 1);'
Request 103 sql='INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23209, 232, 23209, '', 0, 'Zuliana', 1);'
Request 104 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-L', 23201, '', 0, 'VE-L', 'Mérida', 1);'
Request 105 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-T', 23201, '', 0, 'VE-T', 'Trujillo', 1);'
Request 106 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-E', 23201, '', 0, 'VE-E', 'Barinas', 1);'
Request 107 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-M', 23202, '', 0, 'VE-M', 'Miranda', 1);'
Request 108 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-W', 23202, '', 0, 'VE-W', 'Vargas', 1);'
Request 109 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-A', 23202, '', 0, 'VE-A', 'Distrito Capital', 1);'
Request 110 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-D', 23203, '', 0, 'VE-D', 'Aragua', 1);'
Request 111 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-G', 23203, '', 0, 'VE-G', 'Carabobo', 1);'
Request 112 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-I', 23204, '', 0, 'VE-I', 'Falcón', 1);'
Request 113 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-K', 23204, '', 0, 'VE-K', 'Lara', 1);'
Request 114 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-U', 23204, '', 0, 'VE-U', 'Yaracuy', 1);'
Request 115 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-F', 23205, '', 0, 'VE-F', 'Bolívar', 1);'
Request 116 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-X', 23205, '', 0, 'VE-X', 'Amazonas', 1);'
Request 117 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-Y', 23205, '', 0, 'VE-Y', 'Delta Amacuro', 1);'
Request 118 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-O', 23206, '', 0, 'VE-O', 'Nueva Esparta', 1);'
Request 119 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-Z', 23206, '', 0, 'VE-Z', 'Dependencias Federales', 1);'
Request 120 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-C', 23207, '', 0, 'VE-C', 'Apure', 1);'
Request 121 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-J', 23207, '', 0, 'VE-J', 'Guárico', 1);'
Request 122 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-H', 23207, '', 0, 'VE-H', 'Cojedes', 1);'
Request 123 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-P', 23207, '', 0, 'VE-P', 'Portuguesa', 1);'
Request 124 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-B', 23208, '', 0, 'VE-B', 'Anzoátegui', 1);'
Request 125 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-N', 23208, '', 0, 'VE-N', 'Monagas', 1);'
Request 126 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-R', 23208, '', 0, 'VE-R', 'Sucre', 1);'
Request 127 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-V', 23209, '', 0, 'VE-V', 'Zulia', 1);'
Request 128 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('VE-S', 23209, '', 0, 'VE-S', 'Táchira', 1);'
Request 129 sql='insert into llx_c_currencies ( code, code_iso, active, label ) VALUES ( 'VE', 'VEF', 1, 'Venezuelan Bolívar');'
Request 130 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (2321,232, '0','0','No VAT',1);'
Request 131 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (2322,232, '12','0','VAT 12%',1);'
Request 132 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (2323,232, '8','0','VAT 8%',1);'
Request 133 sql='update llx_cotisation set fk_bank = null where fk_bank not in (select rowid from llx_bank);'
Request 134 sql='insert into llx_c_chargesociales (id, libelle, deductible, active, code, fk_pays) values (12, 'Cotisation foncière des entreprises', 0, 1, 'TAXCFE', '1');'
Request 135 sql='insert into llx_c_chargesociales (id, libelle, deductible, active, code, fk_pays) values (13, 'Cotisation sur la valeur ajoutée des entreprises', 0, 1, 'TAXCVAE', '1');'
Request 136 sql='ALTER TABLE llx_paiement ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 137 sql='ALTER TABLE llx_product_price ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 138 sql='UPDATE llx_expedition SET fk_expedition_methode = null WHERE fk_expedition_methode NOT IN (SELECT rowid FROM llx_c_shipment_mode);'
Request 139 sql='ALTER TABLE llx_expedition DROP FOREIGN KEY fk_expedition_fk_expedition_methode;'
Request 140 sql='ALTER TABLE llx_expedition ADD CONSTRAINT fk_expedition_fk_expedition_methode FOREIGN KEY (fk_expedition_methode) REFERENCES llx_c_shipment_mode (rowid);'
Error DB_ERROR_1072: ALTER TABLE llx_expedition ADD CONSTRAINT fk_expedition_fk_expedition_methode FOREIGN KEY (fk_expedition_methode) REFERENCES llx_c_shipment_mode (rowid);
Key column 'fk_expedition_methode' doesn't exist in table
Request 141 sql='UPDATE llx_chargesociales set tms = date_creation WHERE tms = '0000-00-00 00:00:00';'
Request 142 sql='ALTER TABLE llx_propal MODIFY fk_projet integer DEFAULT NULL;'
Request 143 sql='ALTER TABLE llx_propal ADD COLUMN fk_account integer AFTER total;'
Request 144 sql='ALTER TABLE llx_propal ADD COLUMN fk_currency varchar(2) AFTER fk_account;'
Request 145 sql='ALTER TABLE llx_propal ADD INDEX idx_propal_fk_user_author (fk_user_author);'
Request 146 sql='ALTER TABLE llx_propal ADD INDEX idx_propal_fk_user_valid (fk_user_valid);'
Request 147 sql='ALTER TABLE llx_propal ADD INDEX idx_propal_fk_user_cloture (fk_user_cloture);'
Request 148 sql='ALTER TABLE llx_propal ADD INDEX idx_propal_fk_projet (fk_projet);'
Request 149 sql='ALTER TABLE llx_propal ADD INDEX idx_propal_fk_account(fk_account);'
Request 150 sql='ALTER TABLE llx_propal ADD INDEX idx_propal_fk_currency(fk_currency);'
Request 151 sql='ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid);'
Request 152 sql='ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid);'
Request 153 sql='ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_user_cloture FOREIGN KEY (fk_user_cloture) REFERENCES llx_user (rowid);'
Request 154 sql='ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_projet FOREIGN KEY (fk_projet) REFERENCES llx_projet (rowid);'
Request 155 sql='ALTER TABLE llx_propal DROP FOREIGN KEY fk_propal_fk_account;'
Request 156 sql='ALTER TABLE llx_propal DROP FOREIGN KEY fk_propal_fk_currency;'
Request 157 sql='ALTER TABLE llx_commande MODIFY fk_projet integer DEFAULT NULL;'
Request 158 sql='ALTER TABLE llx_commande ADD COLUMN fk_account integer AFTER facture;'
Request 159 sql='ALTER TABLE llx_commande ADD COLUMN fk_currency varchar(2) AFTER fk_account;'
Request 160 sql='ALTER TABLE llx_commande ADD INDEX idx_commande_fk_user_author (fk_user_author);'
Request 161 sql='ALTER TABLE llx_commande ADD INDEX idx_commande_fk_user_valid (fk_user_valid);'
Request 162 sql='ALTER TABLE llx_commande ADD INDEX idx_commande_fk_user_cloture (fk_user_cloture);'
Request 163 sql='ALTER TABLE llx_commande ADD INDEX idx_commande_fk_projet (fk_projet);'
Request 164 sql='ALTER TABLE llx_commande ADD INDEX idx_commande_fk_account(fk_account);'
Request 165 sql='ALTER TABLE llx_commande ADD INDEX idx_commande_fk_currency(fk_currency);'
Request 166 sql='ALTER TABLE llx_commande ADD CONSTRAINT fk_commande_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid);'
Request 167 sql='ALTER TABLE llx_commande ADD CONSTRAINT fk_commande_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid);'
Request 168 sql='ALTER TABLE llx_commande ADD CONSTRAINT fk_commande_fk_user_cloture FOREIGN KEY (fk_user_cloture) REFERENCES llx_user (rowid);'
Request 169 sql='ALTER TABLE llx_commande ADD CONSTRAINT fk_commande_fk_projet FOREIGN KEY (fk_projet) REFERENCES llx_projet (rowid);'
Request 170 sql='ALTER TABLE llx_commande DROP FOREIGN KEY fk_commande_fk_account;'
Request 171 sql='ALTER TABLE llx_commande DROP FOREIGN KEY fk_commande_fk_currency;'
Request 172 sql='ALTER TABLE llx_facture MODIFY fk_projet integer DEFAULT NULL;'
Request 173 sql='ALTER TABLE llx_facture ADD COLUMN fk_account integer AFTER fk_projet;'
Request 174 sql='ALTER TABLE llx_facture ADD COLUMN fk_currency varchar(2) AFTER fk_account;'
Request 175 sql='ALTER TABLE llx_facture ADD INDEX idx_facture_fk_account (fk_account);'
Request 176 sql='ALTER TABLE llx_facture ADD INDEX idx_facture_fk_currency (fk_currency);'
Request 177 sql='ALTER TABLE llx_facture DROP FOREIGN KEY fk_facture_fk_account;'
Request 178 sql='ALTER TABLE llx_facture DROP FOREIGN KEY fk_facture_fk_currency;'
Request 179 sql='ALTER TABLE llx_actioncomm DROP COLUMN propalrowid;'
Request 180 sql='ALTER TABLE llx_actioncomm DROP COLUMN fk_facture;'
Request 181 sql='ALTER TABLE llx_actioncomm DROP COLUMN fk_supplier_order;'
Request 182 sql='ALTER TABLE llx_actioncomm DROP COLUMN fk_supplier_invoice;'
Request 183 sql='ALTER TABLE llx_actioncomm DROP COLUMN fk_commande;'
Request 184 sql='ALTER TABLE llx_product_stock DROP COLUMN location;'
Request 185 sql='ALTER TABLE llx_adherent_extrafields ADD COLUMN import_key varchar(14);'
Request 186 sql='ALTER TABLE llx_product_extrafields ADD COLUMN import_key varchar(14);'
Request 187 sql='ALTER TABLE llx_societe_extrafields ADD COLUMN import_key varchar(14);'
Request 188 sql='DROP TABLE llx_c_currencies;'
Request 189 sql='create table llx_c_currencies ( code_iso varchar(3) PRIMARY KEY, label varchar(64) NOT NULL, unicode varchar(32) DEFAULT NULL, active tinyint DEFAULT 1 NOT NULL )ENGINE=innodb;'
Request 190 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ALL', '[76,101,107]', 1, 'Albania Lek');'
Request 191 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'DZD', NULL, 1, 'Algeria Dinar');'
Request 192 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'AFN', '[1547]', 1, 'Afghanistan Afghani');'
Request 193 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ARS', '[36]', 1, 'Argentino Peso');'
Request 194 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'AWG', '[402]', 1, 'Aruba Guilder');'
Request 195 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'AUD', '[36]', 1, 'Australia Dollar');'
Request 196 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'AZN', '[1084,1072,1085]', 1, 'Azerbaijan New Manat');'
Request 197 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BSD', '[36]', 1, 'Bahamas Dollar');'
Request 198 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BBD', '[36]', 1, 'Barbados Dollar');'
Request 199 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BYR', '[112,46]', 1, 'Belarus Ruble');'
Request 200 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BZD', '[66,90,36]', 1, 'Belize Dollar');'
Request 201 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BMD', '[36]', 1, 'Bermuda Dollar');'
Request 202 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BOB', '[36,98]', 1, 'Bolivia Boliviano');'
Request 203 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BAM', '[75,77]', 1, 'Bosnia and Herzegovina Convertible Marka');'
Request 204 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BWP', '[80]', 1, 'Botswana Pula');'
Request 205 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BGN', '[1083,1074]', 1, 'Bulgaria Lev');'
Request 206 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BRL', '[82,36]', 1, 'Brazil Real');'
Request 207 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BND', '[36]', 1, 'Brunei Darussalam Dollar');'
Request 208 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'KHR', '[6107]', 1, 'Cambodia Riel');'
Request 209 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CAD', '[36]', 1, 'Canada Dollar');'
Request 210 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'KYD', '[36]', 1, 'Cayman Islands Dollar');'
Request 211 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CLP', '[36]', 1, 'Chile Peso');'
Request 212 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CNY', '[165]', 1, 'China Yuan Renminbi');'
Request 213 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'COP', '[36]', 1, 'Colombia Peso');'
Request 214 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CRC', '[8353]', 1, 'Costa Rica Colon');'
Request 215 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'HRK', '[107,110]', 1, 'Croatia Kuna');'
Request 216 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CUP', '[8369]', 1, 'Cuba Peso');'
Request 217 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CZK', '[75,269]', 1, 'Czech Republic Koruna');'
Request 218 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'DKK', '[107,114]', 1, 'Denmark Krone');'
Request 219 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'DOP', '[82,68,36]', 1, 'Dominican Republic Peso');'
Request 220 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'XCD', '[36]', 1, 'East Caribbean Dollar');'
Request 221 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'EGP', '[163]', 1, 'Egypt Pound');'
Request 222 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SVC', '[36]', 1, 'El Salvador Colon');'
Request 223 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'EEK', '[107,114]', 1, 'Estonia Kroon');'
Request 224 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'EUR', '[8364]', 1, 'Euro Member Countries');'
Request 225 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'FKP', '[163]', 1, 'Falkland Islands (Malvinas) Pound');'
Request 226 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'FJD', '[36]', 1, 'Fiji Dollar');'
Request 227 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GHC', '[162]', 1, 'Ghana Cedis');'
Request 228 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GIP', '[163]', 1, 'Gibraltar Pound');'
Request 229 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GTQ', '[81]', 1, 'Guatemala Quetzal');'
Request 230 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GGP', '[163]', 1, 'Guernsey Pound');'
Request 231 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GYD', '[36]', 1, 'Guyana Dollar');'
Request 232 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'HNL', '[76]', 1, 'Honduras Lempira');'
Request 233 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'HKD', '[36]', 1, 'Hong Kong Dollar');'
Request 234 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'HUF', '[70,116]', 1, 'Hungary Forint');'
Request 235 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ISK', '[107,114]', 1, 'Iceland Krona');'
Request 236 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'INR', NULL, 1, 'India Rupee');'
Request 237 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'IDR', '[82,112]', 1, 'Indonesia Rupiah');'
Request 238 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'IRR', '[65020]', 1, 'Iran Rial');'
Request 239 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'IMP', '[163]', 1, 'Isle of Man Pound');'
Request 240 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ILS', '[8362]', 1, 'Israel Shekel');'
Request 241 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'JMD', '[74,36]', 1, 'Jamaica Dollar');'
Request 242 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'JPY', '[165]', 1, 'Japan Yen');'
Request 243 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'JEP', '[163]', 1, 'Jersey Pound');'
Request 244 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'KZT', '[1083,1074]', 1, 'Kazakhstan Tenge');'
Request 245 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'KPW', '[8361]', 1, 'Korea (North) Won');'
Request 246 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'KRW', '[8361]', 1, 'Korea (South) Won');'
Request 247 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'KGS', '[1083,1074]', 1, 'Kyrgyzstan Som');'
Request 248 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LAK', '[8365]', 1, 'Laos Kip');'
Request 249 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LVL', '[76,115]', 1, 'Latvia Lat');'
Request 250 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LBP', '[163]', 1, 'Lebanon Pound');'
Request 251 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LRD', '[36]', 1, 'Liberia Dollar');'
Request 252 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LTL', '[76,116]', 1, 'Lithuania Litas');'
Request 253 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MKD', '[1076,1077,1085]', 1, 'Macedonia Denar');'
Request 254 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MYR', '[82,77]', 1, 'Malaysia Ringgit');'
Request 255 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MRO', NULL, 1, 'Mauritania Ouguiya');'
Request 256 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MUR', '[8360]', 1, 'Mauritius Rupee');'
Request 257 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MXN', '[36]', 1, 'Mexico Peso');'
Request 258 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MNT', '[8366]', 1, 'Mongolia Tughrik');'
Request 259 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MAD', NULL, 1, 'Morocco Dirham');'
Request 260 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MZN', '[77,84]', 1, 'Mozambique Metical');'
Request 261 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NAD', '[36]', 1, 'Namibia Dollar');'
Request 262 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NPR', '[8360]', 1, 'Nepal Rupee');'
Request 263 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ANG', '[402]', 1, 'Netherlands Antilles Guilder');'
Request 264 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NZD', '[36]', 1, 'New Zealand Dollar');'
Request 265 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NIO', '[67,36]', 1, 'Nicaragua Cordoba');'
Request 266 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NGN', '[8358]', 1, 'Nigeria Naira');'
Request 267 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NOK', '[107,114]', 1, 'Norway Krone');'
Request 268 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'OMR', '[65020]', 1, 'Oman Rial');'
Request 269 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PKR', '[8360]', 1, 'Pakistan Rupee');'
Request 270 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PAB', '[66,47,46]', 1, 'Panama Balboa');'
Request 271 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PYG', '[71,115]', 1, 'Paraguay Guarani');'
Request 272 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PEN', '[83,47,46]', 1, 'Peru Nuevo Sol');'
Request 273 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PHP', '[8369]', 1, 'Philippines Peso');'
Request 274 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PLN', '[122,322]', 1, 'Poland Zloty');'
Request 275 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'QAR', '[65020]', 1, 'Qatar Riyal');'
Request 276 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'RON', '[108,101,105]', 1, 'Romania New Leu');'
Request 277 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'RUB', '[1088,1091,1073]', 1, 'Russia Ruble');'
Request 278 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SHP', '[163]', 1, 'Saint Helena Pound');'
Request 279 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SAR', '[65020]', 1, 'Saudi Arabia Riyal');'
Request 280 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'RSD', '[1044,1080,1085,46]', 1, 'Serbia Dinar');'
Request 281 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SCR', '[8360]', 1, 'Seychelles Rupee');'
Request 282 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SGD', '[36]', 1, 'Singapore Dollar');'
Request 283 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SBD', '[36]', 1, 'Solomon Islands Dollar');'
Request 284 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SOS', '[83]', 1, 'Somalia Shilling');'
Request 285 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ZAR', '[82]', 1, 'South Africa Rand');'
Request 286 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LKR', '[8360]', 1, 'Sri Lanka Rupee');'
Request 287 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SEK', '[107,114]', 1, 'Sweden Krona');'
Request 288 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CHF', '[67,72,70]', 1, 'Switzerland Franc');'
Request 289 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SRD', '[36]', 1, 'Suriname Dollar');'
Request 290 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SYP', '[163]', 1, 'Syria Pound');'
Request 291 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'TWD', '[78,84,36]', 1, 'Taiwan New Dollar');'
Request 292 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'THB', '[3647]', 1, 'Thailand Baht');'
Request 293 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'TTD', '[84,84,36]', 1, 'Trinidad and Tobago Dollar');'
Request 294 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'TND', NULL, 1, 'Tunisia Dinar');'
Request 295 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'TRL', '[84,76]', 1, 'Turkey Lira');'
Request 296 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'TRY', '[8356]', 1, 'Turkey Lira');'
Request 297 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'TVD', '[36]', 1, 'Tuvalu Dollar');'
Request 298 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'UAH', '[8372]', 1, 'Ukraine Hryvna');'
Request 299 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'AED', NULL, 1, 'United Arab Emirates Dirham');'
Request 300 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GBP', '[163]', 1, 'United Kingdom Pound');'
Request 301 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'USD', '[36]', 1, 'United States Dollar');'
Request 302 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'UYU', '[36,85]', 1, 'Uruguay Peso');'
Request 303 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'UZS', '[1083,1074]', 1, 'Uzbekistan Som');'
Request 304 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'VEF', '[66,115]', 1, 'Venezuela Bolivar Fuerte');'
Request 305 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'VND', '[8363]', 1, 'Viet Nam Dong');'
Request 306 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'XAF', NULL, 1, 'Communaute Financiere Africaine (BEAC) CFA Franc');'
Request 307 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'XOF', NULL, 1, 'Communaute Financiere Africaine (BCEAO) Franc');'
Request 308 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'YER', '[65020]', 1, 'Yemen Rial');'
Request 309 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ZWD', '[90,36]', 1, 'Zimbabwe Dollar');'
Request 310 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ATS', NULL, 0, 'Shiliing autrichiens');'
Request 311 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'BEF', NULL, 0, 'Francs belges');'
Request 312 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'DEM', NULL, 0, 'Deutsch mark');'
Request 313 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ESP', NULL, 0, 'Pesete');'
Request 314 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'FIM', NULL, 0, 'Mark finlandais');'
Request 315 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'FRF', NULL, 0, 'Francs francais');'
Request 316 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'GRD', NULL, 0, 'Drachme (grece)');'
Request 317 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'IEP', NULL, 0, 'Livres irlandaises');'
Request 318 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ITL', NULL, 0, 'Lires');'
Request 319 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'LUF', NULL, 0, 'Francs luxembourgeois');'
Request 320 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'NLG', NULL, 0, 'Florins');'
Request 321 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PTE', NULL, 0, 'Escudos');'
Request 322 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SKK', NULL, 0, 'Couronnes slovaques');'
Request 323 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'SUR', NULL, 0, 'Rouble');'
Request 324 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'XEU', NULL, 0, 'Ecus');'
Request 325 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'ARP', NULL, 0, 'Pesos argentins');'
Request 326 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'MXP', NULL, 0, 'Pesos Mexicans');'
Request 327 sql='ALTER TABLE llx_expedition DROP COLUMN billed;'
Request 328 sql='ALTER TABLE llx_product_fournisseur_price DROP FOREIGN KEY fk_product_fournisseur_price_fk_product_fournisseur;'
Request 329 sql='ALTER TABLE llx_product_fournisseur_price DROP INDEX idx_product_fournisseur_price_fk_product_fournisseur;'
Request 330 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN tva_tx double(6,3) NOT NULL DEFAULT 0 AFTER unitprice;'
Request 331 sql='UPDATE llx_c_departements SET ncc='JUJUY', nom = 'Jujuy' WHERE code_departement='2302' and fk_region='2301';'
Request 332 sql='ALTER TABLE llx_propal ADD COLUMN import_key varchar(14) AFTER fk_demand_reason;'
Request 333 sql='ALTER TABLE llx_propal ADD COLUMN extraparams varchar(255) AFTER import_key;'
Request 334 sql='ALTER TABLE llx_commande ADD COLUMN extraparams varchar(255) AFTER import_key;'
Request 335 sql='ALTER TABLE llx_facture ADD COLUMN extraparams varchar(255) AFTER import_key;'
Request 336 sql='ALTER TABLE llx_fichinter ADD COLUMN extraparams varchar(255) AFTER model_pdf;'
Request 337 sql='ALTER TABLE llx_deplacement ADD COLUMN extraparams varchar(255) AFTER note_public;'
Request 338 sql='ALTER TABLE llx_contrat ADD COLUMN import_key varchar(14) AFTER note_public;'
Request 339 sql='ALTER TABLE llx_contrat ADD COLUMN extraparams varchar(255) AFTER import_key;'
Request 340 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN extraparams varchar(255) AFTER import_key;'
Request 341 sql='ALTER TABLE llx_facture_fourn ADD COLUMN extraparams varchar(255) AFTER import_key;'
Request 342 sql='ALTER TABLE llx_boxes ADD COLUMN maxline integer NULL;'
Request 343 sql='ALTER TABLE llx_product_fournisseur_price MODIFY fk_product_fournisseur integer DEFAULT 0;'
Request 344 sql='UPDATE llx_product SET canvas = NULL where canvas = 'default@product';'
Request 345 sql='UPDATE llx_product SET canvas = NULL where canvas = 'product@product';'
Request 346 sql='UPDATE llx_product SET canvas = NULL where canvas = 'service@product';'
Request 347 sql='DELETE FROM llx_const WHERE __DECRYPT('name')__ = 'SOCIETE_CODECOMPTA_ADDON' AND __DECRYPT('value')__ = 'mod_codecompta_digitaria';'
Request 348 sql='ALTER TABLE llx_c_barcode_type ADD UNIQUE INDEX uk_c_barcode_type(code, entity);'
Request 349 sql='ALTER TABLE llx_c_tva ADD COLUMN localtax1_type varchar(1) default '0' after localtax1;'
Request 350 sql='ALTER TABLE llx_c_tva ADD COLUMN localtax2_type varchar(1) default '0' after localtax2;'
Script processingError - Show-Hide details
Error(s) were reported during the migration process so next step is not available. To ignore errors, you can click here, but the application or some features may not work correctly until the errors are resolved.