Dolibarr logo
12.0.1

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : localhostOK
Database connection : hcspharma_dol193OK
Database server version5.5.5-10.3.27-MariaDB
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script8.0.0-9.0.0.sql
Request 1 sql='ALTER TABLE llx_contrat_extrafields ADD INDEX idx_contrat_extrafields (fk_object);'
Request 2 sql='ALTER TABLE llx_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);'
Request 3 sql='ALTER TABLE llx_accounting_account DROP FOREIGN KEY fk_accounting_account_fk_pcg_version;'
Request 4 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN fk_pcg_version varchar(32) NOT NULL;'
Request 5 sql='ALTER TABLE llx_accounting_system MODIFY COLUMN pcg_version varchar(32) NOT NULL;'
Request 6 sql='ALTER TABLE llx_accounting_account ADD CONSTRAINT fk_accounting_account_fk_pcg_version FOREIGN KEY (fk_pcg_version) REFERENCES llx_accounting_system (pcg_version);'
Request 7 sql='ALTER TABLE llx_facture ADD COLUMN module_source varchar(32);'
Request 8 sql='ALTER TABLE llx_facture ADD COLUMN pos_source varchar(32);'
Request 9 sql='create table llx_facture_rec_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 10 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_subject varchar(255) after email_msgid;'
Request 11 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_tocc varchar(255) after email_to;'
Request 12 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_tobcc varchar(255) after email_tocc;'
Request 13 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN code varchar(50);'
Request 14 sql='ALTER TABLE llx_extrafields ADD COLUMN help text NULL;'
Request 15 sql='ALTER TABLE llx_extrafields ADD COLUMN totalizable boolean DEFAULT FALSE after list;'
Request 16 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN desc_fourn text after ref_fourn;'
Request 17 sql='ALTER TABLE llx_user ADD COLUMN dateemploymentend date after dateemployment;'
Request 18 sql='ALTER TABLE llx_stock_mouvement ADD COLUMN fk_project integer;'
Request 19 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN elementtype varchar(32);'
Request 20 sql='ALTER TABLE llx_c_field_list ADD COLUMN visible tinyint DEFAULT 1 NOT NULL AFTER search;'
Request 21 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('COMPANY_DELETE','Third party deleted','Executed when you delete third party','societe',1);'
Request 22 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_DELETE','Customer proposal deleted','Executed when a customer proposal is deleted','propal',2);'
Request 23 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_DELETE','Customer order deleted','Executed when a customer order is deleted','commande',5);'
Request 24 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_DELETE','Customer invoice deleted','Executed when a customer invoice is deleted','facture',9);'
Request 25 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_DELETE','Price request deleted','Executed when a customer proposal delete','proposal_supplier',10);'
Request 26 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_DELETE','Supplier order deleted','Executed when a supplier order is deleted','order_supplier',14);'
Request 27 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_DELETE','Supplier invoice deleted','Executed when a supplier invoice is deleted','invoice_supplier',17);'
Request 28 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_DELETE','Contract deleted','Executed when a contract is deleted','contrat',18);'
Request 29 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_DELETE','Intervention is deleted','Executed when a intervention is deleted','ficheinter',35);'
Request 30 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_DELETE','Expense report deleted','Executed when an expense report is deleted','expensereport',204);'
Request 31 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Expense report validated','Executed when an expense report is validated','expensereport',202);'
Request 32 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE','Expense report approved','Executed when an expense report is approved','expensereport',203);'
Request 33 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8001', 'Aktieselvskab A/S');'
Request 34 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8002', 'Anparts Selvskab ApS');'
Request 35 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8003', 'Personlig ejet selvskab');'
Request 36 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8004', 'Iværksætterselvskab IVS');'
Request 37 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8005', 'Interessentskab I/S');'
Request 38 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8006', 'Holdingselskab');'
Request 39 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8007', 'Selskab Med Begrænset Hæftelse SMBA');'
Request 40 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8008', 'Kommanditselskab K/S');'
Request 41 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8009', 'SPE-selskab');'
Request 42 sql='ALTER TABLE llx_payment_salary ADD COLUMN ref varchar(30) NULL after rowid;'
Request 43 sql='ALTER TABLE llx_payment_salary ADD COLUMN fk_projet integer DEFAULT NULL after amount;'
Request 44 sql='ALTER TABLE llx_payment_various ADD COLUMN ref varchar(30) NULL after rowid;'
Request 45 sql='ALTER TABLE llx_categorie ADD COLUMN ref_ext varchar(255);'
Request 46 sql='ALTER TABLE llx_paiement ADD COLUMN ext_payment_id varchar(128);'
Request 47 sql='ALTER TABLE llx_paiement ADD COLUMN ext_payment_site varchar(128);'
Request 48 sql='ALTER TABLE llx_societe ADD COLUMN twitter varchar(255) after skype;'
Request 49 sql='ALTER TABLE llx_societe ADD COLUMN facebook varchar(255) after skype;'
Request 50 sql='ALTER TABLE llx_societe ADD COLUMN instagram varchar(255) after skype;'
Request 51 sql='ALTER TABLE llx_societe ADD COLUMN snapchat varchar(255) after skype;'
Request 52 sql='ALTER TABLE llx_societe ADD COLUMN googleplus varchar(255) after skype;'
Request 53 sql='ALTER TABLE llx_societe ADD COLUMN youtube varchar(255) after skype;'
Request 54 sql='ALTER TABLE llx_societe ADD COLUMN whatsapp varchar(255) after skype;'
Request 55 sql='ALTER TABLE llx_socpeople ADD COLUMN twitter varchar(255) after skype;'
Request 56 sql='ALTER TABLE llx_socpeople ADD COLUMN facebook varchar(255) after skype;'
Request 57 sql='ALTER TABLE llx_socpeople ADD COLUMN instagram varchar(255) after skype;'
Request 58 sql='ALTER TABLE llx_socpeople ADD COLUMN snapchat varchar(255) after skype;'
Request 59 sql='ALTER TABLE llx_socpeople ADD COLUMN googleplus varchar(255) after skype;'
Request 60 sql='ALTER TABLE llx_socpeople ADD COLUMN youtube varchar(255) after skype;'
Request 61 sql='ALTER TABLE llx_socpeople ADD COLUMN whatsapp varchar(255) after skype;'
Request 62 sql='ALTER TABLE llx_adherent ADD COLUMN skype varchar(255);'
Request 63 sql='ALTER TABLE llx_adherent ADD COLUMN twitter varchar(255);'
Request 64 sql='ALTER TABLE llx_adherent ADD COLUMN facebook varchar(255);'
Request 65 sql='ALTER TABLE llx_adherent ADD COLUMN instagram varchar(255);'
Request 66 sql='ALTER TABLE llx_adherent ADD COLUMN snapchat varchar(255);'
Request 67 sql='ALTER TABLE llx_adherent ADD COLUMN googleplus varchar(255);'
Request 68 sql='ALTER TABLE llx_adherent ADD COLUMN youtube varchar(255);'
Request 69 sql='ALTER TABLE llx_adherent ADD COLUMN whatsapp varchar(255);'
Request 70 sql='ALTER TABLE llx_user ADD COLUMN skype varchar(255);'
Request 71 sql='ALTER TABLE llx_user ADD COLUMN twitter varchar(255);'
Request 72 sql='ALTER TABLE llx_user ADD COLUMN facebook varchar(255);'
Request 73 sql='ALTER TABLE llx_user ADD COLUMN instagram varchar(255);'
Request 74 sql='ALTER TABLE llx_user ADD COLUMN snapchat varchar(255);'
Request 75 sql='ALTER TABLE llx_user ADD COLUMN googleplus varchar(255);'
Request 76 sql='ALTER TABLE llx_user ADD COLUMN youtube varchar(255);'
Request 77 sql='ALTER TABLE llx_user ADD COLUMN whatsapp varchar(255);'
Request 78 sql='ALTER TABLE llx_website CHANGE COLUMN fk_user_create fk_user_creat integer;'
Request 79 sql='ALTER TABLE llx_website_page CHANGE COLUMN fk_user_create fk_user_creat integer;'
Request 80 sql='ALTER TABLE llx_website ADD COLUMN maincolor varchar(16);'
Request 81 sql='ALTER TABLE llx_website ADD COLUMN maincolorbis varchar(16);'
Request 82 sql='ALTER TABLE llx_website_page ADD COLUMN image varchar(255);'
Request 83 sql='CREATE TABLE llx_takepos_floor_tables(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,label varchar(255),leftpos float,toppos float,floor smallint) ENGINE=innodb;'
Request 84 sql='UPDATE llx_c_payment_term SET decalage = nbjour, nbjour = 0 where decalage IS NULL AND type_cdr = 2;'
Request 85 sql='UPDATE llx_holiday SET ref = rowid WHERE ref IS NULL;'
Request 86 sql='CREATE TABLE llx_emailcollector_emailcollector(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,entity integer DEFAULT 1 NOT NULL,ref varchar(128) NOT NULL,label varchar(255),description text,host varchar(255),login varchar(128),password varchar(128),source_directory varchar(255) NOT NULL,target_directory varchar(255),datelastresult datetime,codelastresult varchar(16),lastresult varchar(255),note_public text,note_private text,date_creation datetime NOT NULL,tms timestamp NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;'
Request 87 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN login varchar(128);'
Request 88 sql='ALTER TABLE llx_emailcollector_emailcollector ADD INDEX idx_emailcollector_entity (entity);'
Request 89 sql='ALTER TABLE llx_emailcollector_emailcollector ADD INDEX idx_emailcollector_status (status);'
Request 90 sql='CREATE TABLE llx_emailcollector_emailcollectorfilter(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,fk_emailcollector INTEGER NOT NULL,type varchar(128) NOT NULL,rulevalue varchar(128) NULL,date_creation datetime NOT NULL,tms timestamp NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;'
Request 91 sql='CREATE TABLE llx_emailcollector_emailcollectoraction(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,fk_emailcollector INTEGER NOT NULL,type varchar(128) NOT NULL,actionparam varchar(255) NULL,date_creation datetime NOT NULL,tms timestamp NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,position integer DEFAULT 0,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;'
Request 92 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD INDEX idx_emailcollector_fk_emailcollector (fk_emailcollector);'
Request 93 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD CONSTRAINT fk_emailcollectorfilter_fk_emailcollector FOREIGN KEY (fk_emailcollector) REFERENCES llx_emailcollector_emailcollector(rowid);'
Request 94 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD INDEX idx_emailcollector_fk_emailcollector (fk_emailcollector);'
Request 95 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD CONSTRAINT fk_emailcollectoraction_fk_emailcollector FOREIGN KEY (fk_emailcollector) REFERENCES llx_emailcollector_emailcollector(rowid);'
Request 96 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD UNIQUE INDEX uk_emailcollector_emailcollectorfilter (fk_emailcollector, type, rulevalue);'
Request 97 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD UNIQUE INDEX uk_emailcollector_emailcollectoraction (fk_emailcollector, type);'
Request 98 sql='ALTER TABLE llx_societe_rib ADD COLUMN comment varchar(255);'
Request 99 sql='ALTER TABLE llx_societe_rib ADD COLUMN ipaddress varchar(68);'
Request 100 sql='DROP TABLE llx_ticket_logs;'
Request 101 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 102 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN account_number varchar(32) NOT NULL;'
Request 103 sql='UPDATE llx_const set name = __ENCRYPT('PRELEVEMENT_END_TO_END')__ where name = __ENCRYPT('END_TO_END')__;'
Request 104 sql='UPDATE llx_const set name = __ENCRYPT('PRELEVEMENT_USTRD')__ where name = __ENCRYPT('USTRD')__;'
Request 105 sql='DROP TABLE tmp_llx_accouting_account;'
Request 106 sql='CREATE TABLE tmp_llx_accouting_account AS SELECT MIN(rowid) as MINID, MAX(rowid) as MAXID, account_number, entity, fk_pcg_version, count(*) AS NB FROM llx_accounting_account group BY account_number, entity, fk_pcg_version HAVING count(*) >= 2 order by account_number, entity, fk_pcg_version;'
Request 107 sql='DELETE from llx_accounting_account where rowid in (select minid from tmp_llx_accouting_account where minid NOT IN (SELECT fk_code_ventilation from llx_facturedet) AND minid NOT IN (SELECT fk_code_ventilation from llx_facture_fourn_det) AND minid NOT IN (SELECT fk_code_ventilation from llx_expensereport_det));'
Request 108 sql='ALTER TABLE llx_accounting_account DROP INDEX uk_accounting_account;'
Request 109 sql='ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);'
Request 110 sql='UPDATE llx_projet SET fk_opp_status = NULL WHERE fk_opp_status = -1;'
Script processingOK