Dolibarr logo
3.9.3


Dolibarr install or upgrade

Structure database migration

Server connection : localhostOK
Database connection : ceronor_doli739OK
Database server version5.5.51-38.2
Please be patient...

Choose migration script3.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_comments ADD INDEX idx_id_comment (id_comment);'
Request 146 sql='ALTER TABLE llx_opensurvey_comments ADD INDEX idx_id_sondage (id_sondage);'
Request 147 sql='ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_id_sondage_admin (id_sondage_admin);'
Error DB_ERROR_1072: ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_id_sondage_admin (id_sondage_admin);
Key column 'id_sondage_admin' doesn't exist in table
Request 148 sql='ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_date_fin (date_fin);'
Request 149 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_id_users (id_users);'
Request 150 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_nom (nom);'
Request 151 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_id_sondage (id_sondage);'
Request 152 sql='ALTER TABLE llx_boxes ADD COLUMN params varchar(255);'
Request 153 sql='UPDATE llx_extrafields SET elementtype='socpeople' WHERE elementtype='contact';'
Request 154 sql='UPDATE llx_extrafields SET elementtype='actioncomm' WHERE elementtype='action';'
Request 155 sql='UPDATE llx_extrafields SET elementtype='adherent' WHERE elementtype='member';'
Request 156 sql='UPDATE llx_extrafields SET elementtype='societe' WHERE elementtype='company';'
Request 157 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 158 sql='ALTER TABLE llx_commande_fournisseur_extrafields ADD INDEX idx_commande_fournisseur_extrafields (fk_object);'
Request 159 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 160 sql='ALTER TABLE llx_facture_fourn_extrafields ADD INDEX idx_facture_fourn_extrafields (fk_object);'
Request 161 sql='ALTER TABLE llx_user_clicktodial ADD COLUMN url varchar(255) AFTER fk_user;'
Request 162 sql='ALTER TABLE llx_fichinterdet ADD COLUMN fk_parent_line integer NULL AFTER fk_fichinter;'
Request 163 sql='ALTER TABLE llx_societe_address CHANGE COLUMN tel phone varchar(20);'
Request 164 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 165 sql='DELETE FROM llx_document_model WHERE nom ='elevement' AND type='delivery';'
Request 166 sql='DELETE FROM llx_document_model WHERE nom ='' AND type='delivery';'
Script processingKO