 Database migration (structure + some data)
| Server connection : localhost | OK |
| Database connection : htech_ias | OK |
| Database server version | 10.6.20-MariaDB-cll-lve | | Client charset | utf8 | | Client collation | utf8_general_ci | | Please be patient... |
| | Choose migration script | 9.0.0-10.0.0.sql |
| Request 1 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN code varchar(50);' |
| Request 2 sql='DROP TABLE llx_ticket_logs;' |
| Request 3 sql='CREATE TABLE llx_pos_cash_fence( rowid INTEGER AUTO_INCREMENT PRIMARY KEY, entity INTEGER DEFAULT 1 NOT NULL, ref VARCHAR(64), label VARCHAR(255), opening double(24,8) default 0, cash double(24,8) default 0, card double(24,8) default 0, cheque double(24,8) default 0, status INTEGER, date_creation DATETIME NOT NULL, date_valid DATETIME, day_close INTEGER, month_close INTEGER, year_close INTEGER, posmodule VARCHAR(30), posnumber VARCHAR(30), fk_user_creat integer, fk_user_valid integer, tms TIMESTAMP NOT NULL, import_key VARCHAR(14) ) ENGINE=innodb;' |
| Request 4 sql='UPDATE llx_chargesociales SET date_creation = tms WHERE date_creation IS NULL;' |
| Request 5 sql='DROP TABLE llx_cotisation;' |
| Request 6 sql='ALTER TABLE llx_accounting_bookkeeping DROP COLUMN validated;' |
| Request 7 sql='ALTER TABLE llx_accounting_bookkeeping_tmp DROP COLUMN validated;' |
| Request 8 sql='ALTER TABLE llx_loan ADD COLUMN insurance_amount double(24,8) DEFAULT 0;' |
| Request 9 sql='ALTER TABLE llx_facture DROP INDEX idx_facture_uk_facnumber;' |
| Request 10 sql='ALTER TABLE llx_facture CHANGE facnumber ref VARCHAR(30) NOT NULL;' |
| Request 11 sql='ALTER TABLE llx_facture ADD UNIQUE INDEX uk_facture_ref (ref, entity);' |
| Request 12 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_CREATE','Ticket created','Executed when a ticket is created','ticket',161);' |
| Request 13 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_MODIFY','Ticket modified','Executed when a ticket is modified','ticket',163);' |
| Request 14 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_ASSIGNED','Ticket assigned','Executed when a ticket is assigned to another user','ticket',164);' |
| Request 15 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_CLOSE','Ticket closed','Executed when a ticket is closed','ticket',165);' |
| Request 16 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_SENTBYMAIL','Ticket message sent by email','Executed when a message is sent from the ticket record','ticket',166);' |
| Request 17 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_DELETE','Ticket deleted','Executed when a ticket is deleted','ticket',167);' |
| Request 18 sql='create table llx_mailing_unsubscribe ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, email varchar(255), unsubscribegroup varchar(128) DEFAULT '', ip varchar(128), date_creat datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP )ENGINE=innodb;' |
| Request 19 sql='ALTER TABLE llx_mailing_unsubscribe ADD UNIQUE uk_mailing_unsubscribe(email, entity, unsubscribegroup);' |
| Request 20 sql='ALTER TABLE llx_adherent ADD gender VARCHAR(10);' |
| Request 21 sql='ALTER TABLE llx_adherent_type ADD morphy VARCHAR(3);' |
| Request 22 sql='ALTER TABLE llx_subscription ADD fk_type integer;' |
| Request 23 sql='UPDATE llx_subscription as s SET fk_type = (SELECT fk_adherent_type FROM llx_adherent as a where a.rowid = s.fk_adherent) where fk_type IS NULL;' |
| Request 24 sql='ALTER TABLE llx_bank_url DROP INDEX uk_bank_url;' |
| Request 25 sql='ALTER TABLE llx_bank_url ADD UNIQUE INDEX uk_bank_url (fk_bank, url_id, type);' |
| Request 26 sql='ALTER TABLE llx_actioncomm ADD COLUMN calling_duration integer;' |
| Request 27 sql='ALTER TABLE llx_actioncomm ADD COLUMN visibility varchar(12) DEFAULT 'default';' |
| Request 28 sql='DROP TABLE llx_ticket_msg;' |
| Request 29 sql='ALTER TABLE llx_don ADD COLUMN fk_soc integer NULL;' |
| Request 30 sql='ALTER TABLE llx_payment_various ADD COLUMN subledger_account varchar(32);' |
| Request 31 sql='ALTER TABLE llx_prelevement_facture_demande ADD COLUMN entity integer;' |
| Request 32 sql='ALTER TABLE llx_prelevement_facture_demande ADD COLUMN sourcetype varchar(32);' |
| Request 33 sql='ALTER TABLE llx_prelevement_facture_demande ADD COLUMN ext_payment_id varchar(128) NULL;' |
| Request 34 sql='ALTER TABLE llx_prelevement_facture_demande ADD COLUMN ext_payment_site varchar(128) NULL;' |
| Request 35 sql='ALTER TABLE llx_c_units DROP INDEX uk_c_units_code;' |
| Request 36 sql='ALTER TABLE llx_c_units ADD COLUMN scale integer;' |
| Request 37 sql='ALTER TABLE llx_c_units ADD COLUMN unit_type varchar(10);' |
| Request 38 sql='CREATE TABLE llx_c_units( rowid integer AUTO_INCREMENT PRIMARY KEY, code varchar(3), scale integer, label varchar(50), short_label varchar(5), unit_type varchar(10), active tinyint DEFAULT 1 NOT NULL ) ENGINE=innodb;' |
| Request 39 sql='ALTER TABLE llx_c_units ADD UNIQUE uk_c_units_code(code);' |
| Request 40 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('T','3','WeightUnitton','T', 'weight', 1);' |
| Request 41 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('KG','0','WeightUnitkg','kg', 'weight', 1);' |
| Request 42 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('G','-3','WeightUnitg','g', 'weight', 1);' |
| Request 43 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('MG','-6','WeightUnitmg','mg', 'weight', 1);' |
| Request 44 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('OZ','98','WeightUnitounce','Oz', 'weight', 1);' |
| Request 45 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('LB','99','WeightUnitpound','lb', 'weight', 1);' |
| Request 46 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('M','0','SizeUnitm','m', 'size', 1);' |
| Request 47 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('DM','-1','SizeUnitdm','dm', 'size', 1);' |
| Request 48 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('CM','-2','SizeUnitcm','cm', 'size', 1);' |
| Request 49 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('MM','-3','SizeUnitmm','mm', 'size', 1);' |
| Request 50 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('FT','98','SizeUnitfoot','ft', 'size', 1);' |
| Request 51 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('IN','99','SizeUnitinch','in', 'size', 1);' |
| Request 52 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('M2','0','SurfaceUnitm2','m2', 'surface', 1);' |
| Request 53 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('DM2','-2','SurfaceUnitdm2','dm2', 'surface', 1);' |
| Request 54 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('CM2','-4','SurfaceUnitcm2','cm2', 'surface', 1);' |
| Request 55 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('MM2','-6','SurfaceUnitmm2','mm2', 'surface', 1);' |
| Request 56 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('FT2','98','SurfaceUnitfoot2','ft2', 'surface', 1);' |
| Request 57 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('IN2','99','SurfaceUnitinch2','in2', 'surface', 1);' |
| Request 58 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('M3','0','VolumeUnitm3','m3', 'volume', 1);' |
| Request 59 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('DM3','-3','VolumeUnitdm3','dm3', 'volume', 1);' |
| Request 60 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('CM3','-6','VolumeUnitcm3','cm3', 'volume', 1);' |
| Request 61 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('MM3','-9','VolumeUnitmm3','mm3', 'volume', 1);' |
| Request 62 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('FT3','88','VolumeUnitfoot3','ft3', 'volume', 1);' |
| Request 63 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('IN3','89','VolumeUnitinch3','in3', 'volume', 1);' |
| Request 64 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('OZ3','97','VolumeUnitounce','Oz', 'volume', 1);' |
| Request 65 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('L', '98','VolumeUnitlitre','L', 'volume', 1);' |
| Request 66 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('GAL','99','VolumeUnitgallon','gal', 'volume', 1);' |
| Request 67 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('P','0','Piece','p', 'qty', 1);' |
| Request 68 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('SET', '0','Set','set', 'qty', 1);' |
| Request 69 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('S','0','second','s', 'time', 1);' |
| Request 70 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('MI','60','minute','i', 'time', 1);' |
| Request 71 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('H','3600','hour','h', 'time', 1);' |
| Request 72 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('D','86400','day','d', 'time', 1);' |
| Request 73 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('W','604800','week','w', 'time', 1);' |
| Request 74 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('MO','2629800','month','m', 'time', 1);' |
| Request 75 sql='INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES ('Y','31557600','year','y', 'time', 1);' |
| Request 76 sql='UPDATE llx_c_units SET short_label = 'i' WHERE code = 'MI';' |
| Request 77 sql='UPDATE llx_c_units SET unit_type = 'weight', short_label = 'kg', scale = 0 WHERE code = 'KG';' |
| Request 78 sql='UPDATE llx_c_units SET unit_type = 'weight', short_label = 'g', scale = -3 WHERE code = 'G';' |
| Request 79 sql='UPDATE llx_c_units SET unit_type = 'time' WHERE code IN ('S','H','D');' |
| Request 80 sql='UPDATE llx_c_units SET unit_type = 'size' WHERE code IN ('M','LM');' |
| Request 81 sql='UPDATE llx_c_units SET label = 'SizeUnitm', scale = 0 WHERE code IN ('M');' |
| Request 82 sql='UPDATE llx_c_units SET active = 0, scale = 0 WHERE code IN ('LM');' |
| Request 83 sql='UPDATE llx_c_units SET unit_type = 'surface', scale = 0 WHERE code IN ('M2');' |
| Request 84 sql='UPDATE llx_c_units SET unit_type = 'volume', scale = 0 WHERE code IN ('M3','L');' |
| Request 85 sql='UPDATE llx_c_units SET scale = -3, active = 0 WHERE code IN ('L');' |
| Request 86 sql='UPDATE llx_c_units SET label = 'VolumeUnitm3' WHERE code IN ('M3');' |
| Request 87 sql='UPDATE llx_c_units SET label = 'SurfaceUnitm2' WHERE code IN ('M2');' |
| Request 88 sql='ALTER TABLE llx_user ADD COLUMN fk_warehouse INTEGER NULL;' |
| Request 89 sql='ALTER TABLE llx_commande ADD COLUMN module_source varchar(32);' |
| Request 90 sql='ALTER TABLE llx_commande ADD COLUMN pos_source varchar(32);' |
| Request 91 sql='ALTER TABLE llx_societe ADD COLUMN linkedin varchar(255) after whatsapp;' |
| Request 92 sql='ALTER TABLE llx_socpeople ADD COLUMN linkedin varchar(255) after whatsapp;' |
| Request 93 sql='ALTER TABLE llx_adherent ADD COLUMN linkedin varchar(255) after whatsapp;' |
| Request 94 sql='ALTER TABLE llx_user ADD COLUMN linkedin varchar(255) after whatsapp;' |
| Request 95 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_ecm_files integer DEFAULT NULL;' |
| Request 96 sql='ALTER TABLE llx_expensereport ADD COLUMN paid smallint default 0 NOT NULL;' |
| Request 97 sql='UPDATE llx_expensereport set paid = 1 WHERE fk_statut = 6 and paid = 0;' |
| Request 98 sql='CREATE TABLE llx_bom_bom( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, entity integer DEFAULT 1 NOT NULL, ref varchar(128) NOT NULL, label varchar(255), description text, note_public text, note_private text, fk_product integer, qty double(24,8), efficiency double(8,4), date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, date_valid datetime, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_user_valid integer, import_key varchar(14), status integer NOT NULL ) ENGINE=innodb;' |
| Request 99 sql='ALTER TABLE llx_bom_bom ADD COLUMN efficiency double(8,4) DEFAULT 1;' |
| Request 100 sql='ALTER TABLE llx_bom_bom ADD COLUMN entity integer DEFAULT 1 NOT NULL;' |
| Request 101 sql='ALTER TABLE llx_bom_bom ADD COLUMN date_valid datetime;' |
| Request 102 sql='create table llx_bom_bom_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 103 sql='CREATE TABLE llx_bom_bomline( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_bom integer NOT NULL, fk_product integer NOT NULL, fk_bom_child integer NULL, description text, import_key varchar(14), qty double(24,8) NOT NULL, efficiency double(8,4) NOT NULL DEFAULT 1, position integer NOT NULL ) ENGINE=innodb;' |
| Request 104 sql='ALTER TABLE llx_bom_bomline ADD COLUMN efficiency double(8,4) DEFAULT 1;' |
| Request 105 sql='ALTER TABLE llx_bom_bomline ADD COLUMN fk_bom_child integer NULL;' |
| Request 106 sql='ALTER TABLE llx_bom_bomline ADD COLUMN position integer NOT NULL;' |
| Request 107 sql='create table llx_bom_bomline_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 108 sql='ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_rowid (rowid);' |
| Request 109 sql='ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_ref (ref);' |
| Request 110 sql='ALTER TABLE llx_bom_bom ADD CONSTRAINT llx_bom_bom_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);' |
| Request 111 sql='ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_status (status);' |
| Request 112 sql='ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_fk_product (fk_product);' |
| Request 113 sql='ALTER TABLE llx_bom_bomline ADD INDEX idx_bom_bomline_rowid (rowid);' |
| Request 114 sql='ALTER TABLE llx_bom_bomline ADD INDEX idx_bom_bomline_fk_product (fk_product);' |
| Request 115 sql='ALTER TABLE llx_bom_bomline ADD INDEX idx_bom_bomline_fk_bom (fk_bom);' |
| Request 116 sql='ALTER TABLE llx_bom_bom ADD UNIQUE INDEX uk_bom_bom_ref(ref, entity);' |
| Request 117 sql='ALTER TABLE llx_bom_bomline ADD CONSTRAINT llx_bom_bomline_fk_bom FOREIGN KEY (fk_bom) REFERENCES llx_bom_bom(rowid);' |
| Request 118 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN barcode varchar(180) DEFAULT NULL;' |
| Request 119 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_barcode_type integer DEFAULT NULL;' |
| Request 120 sql='ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_barcode (barcode);' |
| Request 121 sql='ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_fk_barcode_type (fk_barcode_type);' |
| Request 122 sql='ALTER TABLE llx_product_fournisseur_price ADD UNIQUE INDEX uk_product_barcode (barcode, fk_barcode_type, entity);' |
| Request 123 sql='ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid);' |
| Request 124 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN buy_price_ht double(24,8) DEFAULT 0;' |
| Request 125 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN fk_product_fournisseur_price integer DEFAULT NULL;' |
| Request 126 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN fk_user_author integer;' |
| Request 127 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN fk_user_modif integer;' |
| Request 128 sql='ALTER TABLE llx_expensereport_det MODIFY COLUMN value_unit double(24,8) NOT NULL;' |
| Request 129 sql='ALTER TABLE llx_expensereport_det ADD COLUMN subprice double(24,8) DEFAULT 0 NOT NULL after qty;' |
| Request 130 sql='ALTER TABLE llx_product_attribute_combination ADD INDEX idx_product_att_com_product_parent (fk_product_parent);' |
| Request 131 sql='ALTER TABLE llx_product_attribute_combination ADD INDEX idx_product_att_com_product_child (fk_product_child);' |
| Request 132 sql='ALTER TABLE llx_user ADD COLUMN fk_user_expense_validator integer after fk_user;' |
| Request 133 sql='ALTER TABLE llx_user ADD COLUMN fk_user_holiday_validator integer after fk_user_expense_validator;' |
| Request 134 sql='ALTER TABLE llx_user ADD COLUMN personal_email varchar(255) after email;' |
| Request 135 sql='ALTER TABLE llx_user ADD COLUMN personal_mobile varchar(20) after user_mobile;' |
| Request 136 sql='ALTER TABLE llx_product ADD COLUMN fk_project integer DEFAULT NULL;' |
| Request 137 sql='ALTER TABLE llx_product ADD INDEX idx_product_fk_project (fk_project);' |
| Request 138 sql='ALTER TABLE llx_actioncomm ADD COLUMN calling_duration integer;' |
| Request 139 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN datelastok datetime;' |
| Request 140 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN maxemailpercollect integer DEFAULT 100;' |
| Request 141 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('THEME_ELDY_USE_HOVER')__ AND value = __ENCRYPT('0')__;' |
| Request 142 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('THEME_ELDY_USE_CHECKED')__ AND value = __ENCRYPT('0')__;' |
| Request 143 sql='ALTER TABLE llx_inventorydet DROP COLUMN pmp;' |
| Request 144 sql='ALTER TABLE llx_inventorydet DROP COLUMN pa;' |
| Request 145 sql='ALTER TABLE llx_inventorydet DROP COLUMN new_pmp;' |
| Request 146 sql='UPDATE llx_c_shipment_mode SET label = 'https://www.laposte.fr/outils/suivre-vos-envois?code={TRACKID}' WHERE code IN ('COLSUI');' |
| Request 147 sql='UPDATE llx_c_shipment_mode SET label = 'https://www.laposte.fr/outils/suivre-vos-envois?code={TRACKID}' WHERE code IN ('LETTREMAX');' |
| Request 148 sql='ALTER TABLE llx_holiday MODIFY COLUMN ref varchar(30) NULL;' |
| Request 149 sql='create table llx_reception ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ref varchar(30) NOT NULL, entity integer DEFAULT 1 NOT NULL, fk_soc integer NOT NULL, fk_projet integer DEFAULT NULL, ref_ext varchar(30), ref_int varchar(30), ref_supplier varchar(30), date_creation datetime, fk_user_author integer, fk_user_modif integer, date_valid datetime, fk_user_valid integer, date_delivery datetime DEFAULT NULL, date_reception datetime, fk_shipping_method integer, tracking_number varchar(50), fk_statut smallint DEFAULT 0, billed smallint DEFAULT 0, height float, width float, size_units integer, size float, weight_units integer, weight float, note_private text, note_public text, model_pdf varchar(255), fk_incoterms integer, location_incoterms varchar(255), import_key varchar(14), extraparams varchar(255) )ENGINE=innodb;' |
| Request 150 sql='ALTER TABLE llx_reception ADD UNIQUE INDEX idx_reception_uk_ref (ref, entity);' |
| Request 151 sql='ALTER TABLE llx_reception ADD INDEX idx_reception_fk_soc (fk_soc);' |
| Request 152 sql='ALTER TABLE llx_reception ADD INDEX idx_reception_fk_user_author (fk_user_author);' |
| Request 153 sql='ALTER TABLE llx_reception ADD INDEX idx_reception_fk_user_valid (fk_user_valid);' |
| Request 154 sql='ALTER TABLE llx_reception ADD INDEX idx_reception_fk_shipping_method (fk_shipping_method);' |
| Request 155 sql='create table llx_reception_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 156 sql='ALTER TABLE llx_reception_extrafields ADD INDEX idx_reception_extrafields (fk_object);' |
| Request 157 sql='ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN fk_projet integer DEFAULT NULL;' |
| Request 158 sql='ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN fk_reception integer DEFAULT NULL;' |
| Request 159 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL after date_validated;' |
| Request 160 sql='insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (110, 'supplier_proposal', 'internal', 'SALESREPFOLL', 'Responsable suivi de la demande', 1);' |
| Request 161 sql='insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (111, 'supplier_proposal', 'external', 'BILLING', 'Contact fournisseur facturation', 1);' |
| Request 162 sql='insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (112, 'supplier_proposal', 'external', 'SHIPPING', 'Contact fournisseur livraison', 1);' |
| Request 163 sql='insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (113, 'supplier_proposal', 'external', 'SERVICE', 'Contact fournisseur prestation', 1);' |
| Request 164 sql='ALTER TABLE llx_ticket_extrafields ADD INDEX idx_ticket_extrafields (fk_object);' |
| Request 165 sql='UPDATE llx_facturedet AS fd LEFT JOIN llx_facture AS f ON f.rowid = fd.fk_facture SET fd.special_code = 4 WHERE f.module_source = 'takepos' AND fd.special_code = 3;' |
| Request 166 sql='UPDATE llx_website_page set fk_user_creat = fk_user_modif WHERE fk_user_creat IS NULL and fk_user_modif IS NOT NULL;' |
| Script processing | OK - Show-Hide details |
|
|
