 Database migration (structure + some data)
| Server connection : localhost | OK |
| Database connection : actarus_dlbrr | OK |
| Database server version | 10.6.17-MariaDB | | Client charset | utf8mb3 | | Client collation | utf8mb3_general_ci | | Please be patient... |
| | Choose migration script | 3.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 (Req 88): 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 (Req 94): 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 (Req 140): 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 processing | Error - Show-Hide details |
|
|
