| Server connection : localhost | OK |
| Database connection : hcspharma_dol193 | OK |
| Database server version | 5.5.5-10.3.27-MariaDB |
| Client charset | utf8 |
| Client collation | utf8_general_ci |
| Please be patient... |
|
| Choose migration script | 3.3.0-3.4.0.sql |
| Request 1 sql='ALTER TABLE llx_menu MODIFY COLUMN leftmenu varchar(100);' |
| Request 2 sql='create table llx_adherent_type_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 3 sql='ALTER TABLE llx_adherent_type_extrafields ADD INDEX idx_adherent_type_extrafields (fk_object);' |
| Request 4 sql='UPDATE llx_const set value = __ENCRYPT('eldy_menu.php')__ where __DECRYPT('value')__ = 'eldy_backoffice.php';' |
| Request 5 sql='UPDATE llx_const set value = __ENCRYPT('eldy_menu.php')__ where __DECRYPT('value')__ = 'eldy_frontoffice.php';' |
| Request 6 sql='UPDATE llx_const set value = __ENCRYPT('auguria_menu.php')__ where __DECRYPT('value')__ = 'auguria_backoffice.php';' |
| Request 7 sql='UPDATE llx_const set value = __ENCRYPT('auguria_menu.php')__ where __DECRYPT('value')__ = 'auguria_frontoffice.php';' |
| Request 8 sql='UPDATE llx_const set value = __ENCRYPT('smartphone_menu.php')__ where __DECRYPT('value')__ = 'smartphone_backoffice.php';' |
| Request 9 sql='UPDATE llx_const set value = __ENCRYPT('smartphone_menu.php')__ where __DECRYPT('value')__ = 'smartphone_frontoffice.php';' |
| Request 10 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_ADDRESS')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_ADRESSE';' |
| Request 11 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_TOWN')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_VILLE';' |
| Request 12 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_ZIP')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_CP';' |
| Request 13 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_COUNTRY')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_PAYS';' |
| Request 14 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_STATE')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_DEPARTEMENT';' |
| Request 15 sql='UPDATE llx_const set name = __ENCRYPT('LIVRAISON_ADDON_NUMBER')__ where __DECRYPT('name')__ = 'LIVRAISON_ADDON';' |
| Request 16 sql='ALTER TABLE llx_user add COLUMN fk_user integer;' |
| Request 17 sql='alter table llx_contratdet add column fk_product_fournisseur_price integer after info_bits;' |
| Request 18 sql='alter table llx_contratdet add column buy_price_ht double(24,8) DEFAULT 0 after fk_product_fournisseur_price;' |
| Request 19 sql='alter table llx_extrafields add column param text after pos;' |
| Request 20 sql='ALTER TABLE llx_facture_fourn ADD COLUMN ref varchar(30) after rowid;' |
| Request 21 sql='ALTER TABLE llx_facture_fourn MODIFY COLUMN ref varchar(30);' |
| Request 22 sql='ALTER TABLE llx_facture_fourn DROP INDEX uk_facture_fourn;' |
| Request 23 sql='ALTER TABLE llx_facture_fourn DROP INDEX uk_facture_fourn_ref;' |
| Request 24 sql='UPDATE llx_facture_fourn set ref = NULL where ref = '';' |
| Request 25 sql='ALTER TABLE llx_facture_fourn ADD UNIQUE INDEX uk_facture_fourn_ref (ref, entity);' |
| Request 26 sql='ALTER TABLE llx_facture_fourn CHANGE COLUMN facnumber ref_supplier varchar(50);' |
| Request 27 sql='ALTER TABLE llx_facture_fourn ADD UNIQUE INDEX uk_facture_fourn_ref_supplier (ref_supplier, fk_soc, entity);' |
| Request 28 sql='alter table llx_propal CHANGE COLUMN fk_adresse_livraison fk_delivery_address integer;' |
| Request 29 sql='alter table llx_commande CHANGE COLUMN fk_adresse_livraison fk_delivery_address integer;' |
| Request 30 sql='alter table llx_don CHANGE COLUMN adresse address text;' |
| Request 31 sql='alter table llx_don CHANGE COLUMN ville town text;' |
| Request 32 sql='alter table llx_don CHANGE COLUMN prenom firstname varchar(50);' |
| Request 33 sql='alter table llx_don CHANGE COLUMN nom lastname varchar(50);' |
| Request 34 sql='alter table llx_don CHANGE COLUMN cp zip varchar(10);' |
| Request 35 sql='alter table llx_don CHANGE COLUMN pays country varchar(50);' |
| Request 36 sql='alter table llx_adherent CHANGE COLUMN adresse address text;' |
| Request 37 sql='alter table llx_adherent CHANGE COLUMN nom lastname varchar(50);' |
| Request 38 sql='alter table llx_adherent CHANGE COLUMN prenom firstname varchar(50);' |
| Request 39 sql='alter table llx_adherent CHANGE COLUMN ville town text;' |
| Request 40 sql='alter table llx_adherent CHANGE COLUMN cp zip varchar(10);' |
| Request 41 sql='alter table llx_adherent CHANGE COLUMN pays country varchar(50);' |
| Request 42 sql='alter table llx_adherent CHANGE COLUMN naiss birth date;' |
| Request 43 sql='alter table llx_adherent CHANGE COLUMN fk_departement state_id varchar(50);' |
| Request 44 sql='alter table llx_bank_account CHANGE COLUMN adresse_proprio owner_address text;' |
| Request 45 sql='alter table llx_bank_account CHANGE COLUMN fk_departement state_id varchar(50);' |
| Request 46 sql='alter table llx_mailing_cibles CHANGE COLUMN nom lastname varchar(50);' |
| Request 47 sql='alter table llx_mailing_cibles CHANGE COLUMN prenom firstname varchar(50);' |
| Request 48 sql='alter table llx_user CHANGE COLUMN name lastname varchar(50);' |
| Request 49 sql='alter table llx_entrepot CHANGE COLUMN ville town text;' |
| Request 50 sql='alter table llx_entrepot CHANGE COLUMN cp zip varchar(10);' |
| Request 51 sql='alter table llx_societe CHANGE COLUMN ville town text;' |
| Request 52 sql='alter table llx_societe CHANGE COLUMN cp zip varchar(10);' |
| Request 53 sql='alter table llx_societe CHANGE COLUMN tel phone varchar(20);' |
| Request 54 sql='alter table llx_socpeople CHANGE COLUMN name lastname varchar(50);' |
| Request 55 sql='alter table llx_socpeople CHANGE COLUMN ville town text;' |
| Request 56 sql='alter table llx_socpeople CHANGE COLUMN cp zip varchar(10);' |
| Request 57 sql='alter table llx_societe_rib CHANGE COLUMN adresse_proprio owner_address text;' |
| Request 58 sql='alter table llx_societe_address CHANGE COLUMN ville town text;' |
| Request 59 sql='alter table llx_societe_address CHANGE COLUMN cp zip varchar(10);' |
| Request 60 sql='ALTER TABLE llx_expedition DROP FOREIGN KEY fk_expedition_fk_expedition_methode;' |
| Request 61 sql='ALTER TABLE llx_expedition DROP FOREIGN KEY fk_expedition_fk_shipping_method;' |
| Request 62 sql='ALTER TABLE llx_expedition DROP INDEX idx_expedition_fk_expedition_methode;' |
| Request 63 sql='ALTER TABLE llx_expedition CHANGE COLUMN fk_expedition_methode fk_shipping_method integer;' |
| Request 64 sql='ALTER TABLE llx_c_shipment_mode ADD COLUMN tracking VARCHAR(255) NOT NULL DEFAULT '' AFTER description;' |
| Request 65 sql='ALTER TABLE llx_c_shipment_mode CHANGE COLUMN rowid rowid INTEGER NOT NULL AUTO_INCREMENT;' |
| Request 66 sql='ALTER TABLE llx_expedition ADD INDEX idx_expedition_fk_shipping_method (fk_shipping_method);' |
| Request 67 sql='ALTER TABLE llx_expedition ADD CONSTRAINT fk_expedition_fk_shipping_method FOREIGN KEY (fk_shipping_method) REFERENCES llx_c_shipment_mode (rowid);' |
| Request 68 sql='ALTER TABLE llx_stock_mouvement MODIFY COLUMN value real;' |
| Request 69 sql='create table llx_propal_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 70 sql='ALTER TABLE llx_propal_extrafields ADD INDEX idx_propal_extrafields (fk_object);' |
| Request 71 sql='create table llx_facture_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 72 sql='ALTER TABLE llx_facture_extrafields ADD INDEX idx_facture_extrafields (fk_object);' |
| Request 73 sql='ALTER TABLE llx_facture ADD COLUMN revenuestamp double(24,8) DEFAULT 0 AFTER localtax2;' |
| Request 74 sql='CREATE TABLE llx_c_revenuestamp(rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY,fk_pays integer NOT NULL,taux double NOT NULL,note varchar(128),active tinyint DEFAULT 1 NOT NULL,accountancy_code_sell varchar(15) DEFAULT NULL,accountancy_code_buy varchar(15) DEFAULT NULL) ENGINE=innodb;' |
| Request 75 sql='insert into llx_c_revenuestamp(rowid,fk_pays,taux,note,active) values (101, 10, '0.4', 'Timbre fiscal', 1);' |
| Request 76 sql='ALTER TABLE llx_c_tva MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 77 sql='ALTER TABLE llx_c_tva MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 78 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 79 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 80 sql='ALTER TABLE llx_commandedet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 81 sql='ALTER TABLE llx_commandedet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 82 sql='ALTER TABLE llx_contratdet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 83 sql='ALTER TABLE llx_contratdet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 84 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 85 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 86 sql='ALTER TABLE llx_facturedet_rec MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 87 sql='ALTER TABLE llx_facturedet_rec MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 88 sql='ALTER TABLE llx_facturedet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 89 sql='ALTER TABLE llx_facturedet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 90 sql='ALTER TABLE llx_propaldet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 91 sql='ALTER TABLE llx_propaldet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 92 sql='UPDATE llx_c_tva set localtax1=0, localtax1_type='0' where localtax1_type = '7';' |
| Request 93 sql='UPDATE llx_c_tva set localtax2=0, localtax2_type='0' where localtax2_type = '7';' |
| Request 94 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN info_bits integer NOT NULL DEFAULT 0 after date_end;' |
| Request 95 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN info_bits integer NOT NULL DEFAULT 0 after tva_tx;' |
| Request 96 sql='ALTER TABLE llx_actioncomm ADD COLUMN code varchar(32) NULL after fk_action;' |
| Request 97 sql='ALTER TABLE llx_holiday ADD COLUMN note text;' |
| Request 98 sql='ALTER TABLE llx_holiday ADD COLUMN note_public text;' |
| Request 99 sql='INSERT INTO llx_c_action_trigger (rowid,code,label,description,elementtype,rang) values (28,'BILL_UNVALIDATE','Customer invoice unvalidated','Executed when a customer invoice status set back to draft','facture',10);' |
| Request 100 sql='ALTER TABLE llx_c_action_trigger ADD INDEX idx_action_trigger_rang (rang);' |
| Request 101 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN fk_code_ventilation integer DEFAULT 0 NOT NULL;' |
| Request 102 sql='ALTER TABLE llx_facturedet DROP COLUMN fk_export_compta;' |
| Request 103 sql='CREATE TABLE llx_cronjob(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,datec datetime,jobtype varchar(10) NOT NULL,label text NOT NULL,command varchar(255),classesname varchar(255),objectname varchar(255),methodename varchar(255),params text NOT NULL,md5params varchar(32),module_name varchar(255),priority integer DEFAULT 0,datelastrun datetime,datenextrun datetime,datestart datetime,dateend datetime,datelastresult datetime,lastresult text,lastoutput text,unitfrequency integer NOT NULL DEFAULT 0,frequency integer NOT NULL DEFAULT 0,nbrun integer,status integer NOT NULL DEFAULT 1,fk_user_author integer DEFAULT NULL,fk_user_mod integer DEFAULT NULL,note text)ENGINE=innodb;' |
| Request 104 sql='ALTER TABLE llx_societe MODIFY COLUMN zip varchar(25);' |
| Request 105 sql='ALTER TABLE llx_user ADD COLUMN address varchar(255);' |
| Request 106 sql='ALTER TABLE llx_user ADD COLUMN zip varchar(25);' |
| Request 107 sql='ALTER TABLE llx_user ADD COLUMN town varchar(50);' |
| Request 108 sql='ALTER TABLE llx_user ADD COLUMN fk_state integer DEFAULT 0;' |
| Request 109 sql='ALTER TABLE llx_user ADD COLUMN fk_country integer DEFAULT 0;' |
| Request 110 sql='ALTER TABLE llx_user ADD COLUMN color varchar(6);' |
| Request 111 sql='ALTER TABLE llx_product_price ADD COLUMN import_key varchar(14) AFTER price_by_qty;' |
| Request 112 sql='DROP TABLE llx_printer_ipp;' |
| Request 113 sql='CREATE TABLE llx_printer_ipp(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,datec datetime,printer_name text NOT NULL,printer_location text NOT NULL,printer_uri varchar(255) NOT NULL,copy integer NOT NULL DEFAULT '1',module varchar(16) NOT NULL,login varchar(32) NOT NULL) ENGINE=innodb;' |
| Request 114 sql='ALTER TABLE llx_socpeople ADD COLUMN ref_ext varchar(128) after entity;' |
| Request 115 sql='ALTER TABLE llx_adherent MODIFY COLUMN ref_ext varchar(128);' |
| Request 116 sql='create table llx_commande_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 117 sql='ALTER TABLE llx_commande_extrafields ADD INDEX idx_commande_extrafields (fk_object);' |
| Request 118 sql='ALTER TABLE llx_socpeople ADD COLUMN note_public text after note;' |
| Request 119 sql='ALTER TABLE llx_societe ADD COLUMN note_public text after note;' |
| Request 120 sql='ALTER TABLE llx_actioncomm ADD COLUMN transparency integer after fk_user_action;' |
| Request 121 sql='INSERT INTO llx_c_action_trigger (rowid,code,label,description,elementtype,rang) VALUES (29,'FICHINTER_SENTBYMAIL','Intervention sent by mail','Executed when a intervention is sent by mail','ficheinter',29);' |
| Request 122 sql='ALTER TABLE llx_adherent ADD COLUMN canvas varchar(32) after fk_user_valid;' |
| Request 123 sql='ALTER TABLE llx_expedition CHANGE COLUMN note note_private text;' |
| Request 124 sql='ALTER TABLE llx_expedition ADD COLUMN note_public text after note_private;' |
| Request 125 sql='ALTER TABLE llx_livraison CHANGE COLUMN note note_private text;' |
| Request 126 sql='ALTER TABLE llx_facture CHANGE COLUMN note note_private text;' |
| Request 127 sql='ALTER TABLE llx_commande CHANGE COLUMN note note_private text;' |
| Request 128 sql='ALTER TABLE llx_propal CHANGE COLUMN note note_private text;' |
| Request 129 sql='ALTER TABLE llx_commande_fournisseur CHANGE COLUMN note note_private text;' |
| Request 130 sql='ALTER TABLE llx_contrat CHANGE COLUMN note note_private text;' |
| Request 131 sql='ALTER TABLE llx_deplacement CHANGE COLUMN note note_private text;' |
| Request 132 sql='ALTER TABLE llx_don CHANGE COLUMN note note_private text;' |
| Request 133 sql='ALTER TABLE llx_facture_fourn CHANGE COLUMN note note_private text;' |
| Request 134 sql='ALTER TABLE llx_facture_rec CHANGE COLUMN note note_private text;' |
| Request 135 sql='ALTER TABLE llx_holiday CHANGE COLUMN note note_private text;' |
| Request 136 sql='ALTER TABLE llx_societe CHANGE COLUMN note note_private text;' |
| Request 137 sql='ALTER TABLE llx_socpeople CHANGE COLUMN note note_private text;' |
| Request 138 sql='create table llx_projet_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 139 sql='ALTER TABLE llx_projet_extrafields ADD INDEX idx_projet_extrafields (fk_object);' |
| Request 140 sql='create table llx_projet_task_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 141 sql='ALTER TABLE llx_projet_task_extrafields ADD INDEX idx_projet_task_extrafields (fk_object);' |
| Request 142 sql='CREATE TABLE llx_opensurvey_comments (id_comment INTEGER unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,id_sondage CHAR(16) NOT NULL,comment text NOT NULL,tms timestamp,usercomment text) ENGINE=InnoDB;' |
| Request 143 sql='CREATE TABLE llx_opensurvey_sondage (id_sondage VARCHAR(16) PRIMARY KEY,id_sondage_admin CHAR(24),commentaires text,mail_admin VARCHAR(128),nom_admin VARCHAR(64),titre text,date_fin datetime,format VARCHAR(2),mailsonde varchar(2) DEFAULT '0',survey_link_visible integer DEFAULT 1,canedit integer DEFAULT 0,origin varchar(64),tms timestamp,sujet TEXT) ENGINE=InnoDB;' |
| Request 144 sql='CREATE TABLE llx_opensurvey_user_studs (id_users INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,nom VARCHAR(64) NOT NULL,id_sondage VARCHAR(16) NOT NULL,reponses VARCHAR(100) NOT NULL,tms timestamp) ENGINE=InnoDB;' |
| Request 145 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN id_sondage_admin CHAR(24);' |
| Request 146 sql='ALTER TABLE llx_opensurvey_comments ADD INDEX idx_id_comment (id_comment);' |
| Request 147 sql='ALTER TABLE llx_opensurvey_comments ADD INDEX idx_id_sondage (id_sondage);' |
| Request 148 sql='ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_id_sondage_admin (id_sondage_admin);' |
| Request 149 sql='ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_date_fin (date_fin);' |
| Request 150 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_id_users (id_users);' |
| Request 151 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_nom (nom);' |
| Request 152 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_id_sondage (id_sondage);' |
| Request 153 sql='ALTER TABLE llx_boxes ADD COLUMN params varchar(255);' |
| Request 154 sql='UPDATE llx_extrafields SET elementtype='socpeople' WHERE elementtype='contact';' |
| Request 155 sql='UPDATE llx_extrafields SET elementtype='actioncomm' WHERE elementtype='action';' |
| Request 156 sql='UPDATE llx_extrafields SET elementtype='adherent' WHERE elementtype='member';' |
| Request 157 sql='UPDATE llx_extrafields SET elementtype='societe' WHERE elementtype='company';' |
| Request 158 sql='create table llx_commande_fournisseur_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 159 sql='ALTER TABLE llx_commande_fournisseur_extrafields ADD INDEX idx_commande_fournisseur_extrafields (fk_object);' |
| Request 160 sql='create table llx_facture_fourn_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 161 sql='ALTER TABLE llx_facture_fourn_extrafields ADD INDEX idx_facture_fourn_extrafields (fk_object);' |
| Request 162 sql='ALTER TABLE llx_user_clicktodial ADD COLUMN url varchar(255) AFTER fk_user;' |
| Request 163 sql='ALTER TABLE llx_fichinterdet ADD COLUMN fk_parent_line integer NULL AFTER fk_fichinter;' |
| Request 164 sql='ALTER TABLE llx_societe_address CHANGE COLUMN tel phone varchar(20);' |
| Request 165 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,localtax1,localtax1_type,note,active) values (143, 14,'5','0','9.975','1','TPS and TVQ rate',1);' |
| Request 166 sql='DELETE FROM llx_document_model WHERE nom ='elevement' AND type='delivery';' |
| Request 167 sql='DELETE FROM llx_document_model WHERE nom ='' AND type='delivery';' |
| Script processing | OK |
