Dolibarr logo
20.0.1

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : localhostOK
Database connection : htech_iasOK
Database server version10.6.22-MariaDB-cll-lve-log
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script10.0.0-11.0.0.sql
Request 1 sql='ALTER TABLE llx_account_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL;'
Request 2 sql='ALTER TABLE llx_expensereport ADD COLUMN paid smallint default 0 NOT NULL;'
Request 3 sql='UPDATE llx_expensereport set paid = 1 WHERE fk_statut = 6 and paid = 0;'
Request 4 sql='UPDATE llx_c_units SET short_label = 'i' WHERE code = 'MI';'
Request 5 sql='UPDATE llx_c_units SET unit_type = 'weight', short_label = 'kg', scale = 0 WHERE code = 'KG';'
Request 6 sql='UPDATE llx_c_units SET unit_type = 'weight', short_label = 'g', scale = -3 WHERE code = 'G';'
Request 7 sql='UPDATE llx_c_units SET unit_type = 'time' WHERE code IN ('S','H','D');'
Request 8 sql='UPDATE llx_c_units SET unit_type = 'size' WHERE code IN ('M','LM');'
Request 9 sql='UPDATE llx_c_units SET label = 'SizeUnitm', scale = 0 WHERE code IN ('M');'
Request 10 sql='UPDATE llx_c_units SET active = 0, scale = 0 WHERE code IN ('LM');'
Request 11 sql='UPDATE llx_c_units SET unit_type = 'surface', scale = 0 WHERE code IN ('M2');'
Request 12 sql='UPDATE llx_c_units SET unit_type = 'volume', scale = 0 WHERE code IN ('M3','L');'
Request 13 sql='UPDATE llx_c_units SET scale = -3, active = 0 WHERE code IN ('L');'
Request 14 sql='UPDATE llx_c_units SET label = 'VolumeUnitm3' WHERE code IN ('M3');'
Request 15 sql='UPDATE llx_c_units SET label = 'SurfaceUnitm2' WHERE code IN ('M2');'
Request 16 sql='ALTER TABLE llx_adherent_type ADD UNIQUE INDEX uk_adherent_type_libelle (libelle, entity);'
Request 17 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN lastname varchar(160);'
Request 18 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN firstname varchar(160);'
Request 19 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN login varchar(128);'
Request 20 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN codelastresult varchar(16);'
Request 21 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD COLUMN position integer DEFAULT 0;'
Request 22 sql='ALTER TABLE llx_product_price MODIFY COLUMN tva_tx double(6,3) DEFAULT 0 NOT NULL;'
Request 23 sql='ALTER TABLE llx_facturedet MODIFY COLUMN situation_percent real DEFAULT 100;'
Request 24 sql='UPDATE llx_facturedet SET situation_percent = 100 WHERE situation_percent IS NULL AND fk_prev_id IS NULL;'
Request 25 sql='UPDATE llx_accounting_system SET fk_country = NULL, active = 0 WHERE pcg_version = 'SYSCOHADA';'
Request 26 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 20, 'BAS-K1-MINI', 'The Swedish mini chart of accounts', 1);'
Request 27 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN elementtype varchar(64) NOT NULL;'
Request 28 sql='ALTER TABLE llx_societe_account ADD COLUMN site_account varchar(128);'
Request 29 sql='UPDATE llx_holiday SET ref = rowid WHERE ref IS NULL;'
Request 30 sql='ALTER TABLE llx_holiday MODIFY COLUMN ref varchar(30) NOT NULL;'
Request 31 sql='ALTER TABLE llx_c_email_senderprofile MODIFY COLUMN active tinyint DEFAULT 1 NOT NULL;'
Request 32 sql='insert into llx_c_type_container (code,label,module,active) values ('menu', 'Menu', 'system', 1);'
Request 33 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('HELP', '15', 'Request for functionnal help', 1, 0, NULL);'
Request 34 sql='ALTER TABLE llx_don ADD COLUMN fk_user_modif integer;'
Request 35 sql='ALTER TABLE llx_expeditiondet ADD INDEX idx_expeditiondet_fk_origin_line (fk_origin_line);'
Error DB_ERROR_1072 (Req 35): ALTER TABLE llx_expeditiondet ADD INDEX idx_expeditiondet_fk_origin_line (fk_origin_line);
Key column 'fk_origin_line' doesn't exist in table
Request 36 sql='ALTER TABLE llx_rights_def ADD COLUMN module_position INTEGER NOT NULL DEFAULT 0;'
Request 37 sql='ALTER TABLE llx_rights_def ADD COLUMN family_position INTEGER NOT NULL DEFAULT 0;'
Request 38 sql='UPDATE llx_rights_def SET subperms = 'write' WHERE perms = 'fiscalyear' AND module = 'accounting' AND subperms IS NULL;'
Request 39 sql='ALTER TABLE llx_bom_bom ADD COLUMN duration double(24,8) DEFAULT NULL;'
Request 40 sql='ALTER TABLE llx_bom_bom ADD COLUMN fk_warehouse integer;'
Request 41 sql='ALTER TABLE llx_bom_bomline ADD COLUMN position integer NOT NULL DEFAULT 0;'
Request 42 sql='ALTER TABLE llx_bom_bomline ADD COLUMN qty_frozen smallint DEFAULT 0;'
Request 43 sql='ALTER TABLE llx_bom_bomline ADD COLUMN disable_stock_change smallint DEFAULT 0;'
Request 44 sql='ALTER TABLE llx_bom_bomline DROP COLUMN `rank`;'
Request 45 sql='create table llx_categorie_warehouse ( fk_categorie integer NOT NULL, fk_warehouse integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 46 sql='ALTER TABLE llx_categorie_warehouse ADD PRIMARY KEY pk_categorie_warehouse (fk_categorie, fk_warehouse);'
Request 47 sql='ALTER TABLE llx_categorie_warehouse ADD INDEX idx_categorie_warehouse_fk_categorie (fk_categorie);'
Request 48 sql='ALTER TABLE llx_categorie_warehouse ADD INDEX idx_categorie_warehouse_fk_warehouse (fk_warehouse);'
Request 49 sql='ALTER TABLE llx_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 50 sql='ALTER TABLE llx_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_fk_warehouse_rowid FOREIGN KEY (fk_warehouse) REFERENCES llx_entrepot (rowid);'
Request 51 sql='create table llx_holiday_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 52 sql='ALTER TABLE llx_holiday_extrafields ADD INDEX idx_holiday_extrafields (fk_object);'
Request 53 sql='ALTER TABLE llx_societe_rib MODIFY label varchar(200);'
Request 54 sql='ALTER TABLE llx_societe ADD COLUMN logo_squarred varchar(255);'
Request 55 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_SENTBYMAIL','Email sent','Executed when an email is sent from user card','user',300);'
Request 56 sql='create table llx_entrepot_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 57 sql='ALTER TABLE llx_entrepot_extrafields ADD INDEX idx_entrepot_extrafields (fk_object);'
Request 58 sql='ALTER TABLE llx_extrafields ADD COLUMN printable boolean DEFAULT FALSE;'
Request 59 sql='ALTER TABLE llx_facture ADD COLUMN retained_warranty real DEFAULT NULL after situation_final;'
Request 60 sql='ALTER TABLE llx_facture ADD COLUMN retained_warranty_date_limit date DEFAULT NULL after retained_warranty;'
Request 61 sql='ALTER TABLE llx_facture ADD COLUMN retained_warranty_fk_cond_reglement integer DEFAULT NULL after retained_warranty_date_limit;'
Request 62 sql='ALTER TABLE llx_facture ADD COLUMN date_closing datetime DEFAULT NULL after date_valid;'
Request 63 sql='ALTER TABLE llx_facture ADD COLUMN fk_user_closing integer DEFAULT NULL after fk_user_valid;'
Request 64 sql='ALTER TABLE llx_c_shipment_mode ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 65 sql='ALTER TABLE llx_c_shipment_mode DROP INDEX uk_c_shipment_mode;'
Request 66 sql='ALTER TABLE llx_c_shipment_mode ADD UNIQUE INDEX uk_c_shipment_mode (code, entity);'
Request 67 sql='ALTER TABLE llx_facture_fourn DROP COLUMN total;'
Request 68 sql='ALTER TABLE llx_user ADD COLUMN iplastlogin varchar(250);'
Request 69 sql='ALTER TABLE llx_user ADD COLUMN ippreviouslogin varchar(250);'
Request 70 sql='ALTER TABLE llx_events ADD COLUMN prefix_session varchar(255) NULL;'
Request 71 sql='create table llx_payment_salary_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 72 sql='ALTER TABLE llx_payment_salary_extrafields ADD INDEX idx_payment_salary_extrafields (fk_object);'
Request 73 sql='ALTER TABLE llx_c_price_expression MODIFY COLUMN expression varchar(255) NOT NULL;'
Request 74 sql='UPDATE llx_bank_url set url = REPLACE( url, 'compta/salaries/', 'salaries/');'
Request 75 sql='ALTER TABLE llx_stock_mouvement ADD COLUMN fk_projet INTEGER NOT NULL DEFAULT 0 AFTER model_pdf;'
Request 76 sql='ALTER TABLE llx_oauth_token ADD COLUMN fk_soc integer DEFAULT NULL after token;'
Request 77 sql='ALTER TABLE llx_adherent_type ADD COLUMN duration varchar(6) DEFAULT NULL after morphy;'
Request 78 sql='ALTER TABLE llx_mailing ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;'
Request 79 sql='ALTER TABLE llx_mailing_cibles ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;'
Request 80 sql='ALTER TABLE llx_projet ADD COLUMN usage_opportunity integer DEFAULT 0;'
Request 81 sql='ALTER TABLE llx_projet ADD COLUMN usage_task integer DEFAULT 1;'
Request 82 sql='ALTER TABLE llx_projet CHANGE COLUMN bill_time usage_bill_time integer DEFAULT 0;'
Request 83 sql='ALTER TABLE llx_projet ADD COLUMN usage_organize_event integer DEFAULT 0;'
Request 84 sql='UPDATE llx_projet set usage_opportunity = 1 WHERE fk_opp_status > 0;'
Request 85 sql='create table llx_societe_contacts ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, date_creation datetime NOT NULL, fk_soc integer NOT NULL, fk_c_type_contact int NOT NULL, fk_socpeople integer NOT NULL, tms TIMESTAMP, import_key VARCHAR(14) )ENGINE=innodb;'
Request 86 sql='ALTER TABLE llx_societe_contacts ADD UNIQUE INDEX idx_societe_contacts_idx1 (entity, fk_soc, fk_c_type_contact, fk_socpeople);'
Request 87 sql='ALTER TABLE llx_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_c_type_contact FOREIGN KEY (fk_c_type_contact) REFERENCES llx_c_type_contact(rowid);'
Request 88 sql='ALTER TABLE llx_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_soc FOREIGN KEY (fk_soc) REFERENCES llx_societe(rowid);'
Request 89 sql='ALTER TABLE llx_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_socpeople FOREIGN KEY (fk_socpeople) REFERENCES llx_socpeople(rowid);'
Request 90 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN rowid bigint AUTO_INCREMENT;'
Request 91 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_start datetime DEFAULT NULL;'
Request 92 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_end datetime DEFAULT NULL;'
Request 93 sql='create table llx_c_hrm_public_holiday ( id integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 0 NOT NULL, fk_country integer, code varchar(62), dayrule varchar(64) DEFAULT '', day integer, month integer, year integer, active integer DEFAULT 1, import_key varchar(14) )ENGINE=innodb;'
Request 94 sql='ALTER TABLE llx_c_hrm_public_holiday ADD UNIQUE INDEX uk_c_hrm_public_holiday(entity, code);'
Request 95 sql='ALTER TABLE llx_c_hrm_public_holiday ADD UNIQUE INDEX uk_c_hrm_public_holiday2(entity, fk_country, dayrule, day, month, year);'
Request 96 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('NEWYEARDAY1', 0, 0, 0, 1, 1, 1);'
Request 97 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('LABORDAY1', 0, 0, 0, 5, 1, 1);'
Request 98 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('ASSOMPTIONDAY1', 0, 0, 0, 8, 15, 1);'
Request 99 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('CHRISTMASDAY1', 0, 0, 0, 12, 25, 1);'
Request 100 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-VICTORYDAY', 0, 1, '', 0, 5, 8, 1);'
Request 101 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-NATIONALDAY', 0, 1, '', 0, 7, 14, 1);'
Request 102 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ASSOMPTION', 0, 1, '', 0, 8, 15, 1);'
Request 103 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-TOUSSAINT', 0, 1, '', 0, 11, 1, 1);'
Request 104 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ARMISTICE', 0, 1, '', 0, 11, 11, 1);'
Request 105 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-EASTER', 0, 1, 'eastermonday', 0, 0, 0, 1);'
Request 106 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ASCENSION', 0, 1, 'ascension', 0, 0, 0, 1);'
Request 107 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-PENTECOST', 0, 1, 'pentecost', 0, 0, 0, 1);'
Request 108 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-LIBEAZIONE', 0, 3, 0, 4, 25, 1);'
Request 109 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-EPIPHANY', 0, 3, 0, 6, 1, 1);'
Request 110 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-REPUBBLICA', 0, 3, 0, 6, 2, 1);'
Request 111 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-TUTTISANTIT', 0, 3, 0, 11, 1, 1);'
Request 112 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-IMMACULE', 0, 3, 0, 12, 8, 1);'
Request 113 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-SAINTSTEFAN', 0, 3, 0, 12, 26, 1);'
Request 114 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-EASTER', 0, 4, 'easter', 0, 0, 0, 1);'
Request 115 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-REYE', 0, 4, '', 0, 6, 1, 1);'
Request 116 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-HISPANIDAD', 0, 4, '', 0, 10, 12, 1);'
Request 117 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-TOUSSAINT', 0, 4, '', 0, 11, 1, 1);'
Request 118 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-CONSTITUIZION', 0, 4, '', 0, 12, 6, 1);'
Request 119 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-IMMACULE', 0, 4, '', 0, 12, 8, 1);'
Request 120 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-EASTER', 0, 41, 'eastermonday', 0, 0, 0, 1);'
Request 121 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-ASCENSION', 0, 41, 'ascension', 0, 0, 0, 1);'
Request 122 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-PENTECOST', 0, 41, 'pentecost', 0, 0, 0, 1);'
Request 123 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-FRONLEICHNAM', 0, 41, 'fronleichnam', 0, 0, 0, 1);'
Request 124 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-KONEGIE', 0, 41, '', 0, 6, 1, 1);'
Request 125 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-26OKT', 0, 41, '', 0, 10, 26, 1);'
Request 126 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-TOUSSAINT', 0, 41, '', 0, 11, 1, 1);'
Request 127 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-IMMACULE', 0, 41, '', 0, 12, 8, 1);'
Request 128 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-24DEC', 0, 41, '', 0, 12, 24, 1);'
Request 129 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-SAINTSTEFAN', 0, 41, '', 0, 12, 26, 1);'
Request 130 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-Silvester', 0, 41, '', 0, 12, 31, 1);'
Request 131 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('IN-REPUBLICDAY', 0, 117, '', 0, 1, 26, 1);'
Request 132 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('IN-GANDI', 0, 117, '', 0, 10, 2, 1);'
Request 133 sql='create table llx_c_socialnetworks ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, code varchar(100), label varchar(150), url text, icon varchar(20), active tinyint DEFAULT 1 NOT NULL )ENGINE=innodb;'
Request 134 sql='ALTER TABLE llx_c_socialnetworks ADD UNIQUE INDEX idx_c_socialnetworks_code (code);'
Request 135 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'facebook', 'Facebook', 'https://www.facebook.com/{socialid}', 'fa-facebook', 1);'
Request 136 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'skype', 'Skype', 'https://www.skype.com/{socialid}', 'fa-skype', 1);'
Request 137 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'twitter', 'Twitter', 'https://www.twitter.com/{socialid}', 'fa-twitter', 1);'
Request 138 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'linkedin', 'LinkedIn', 'https://www.linkedin.com/{socialid}', 'fa-linkedin', 1);'
Request 139 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'instagram', 'Instagram', 'https://www.instagram.com/{socialid}', 'fa-instagram', 1);'
Request 140 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'snapchat', 'Snapchat', '{socialid}', 'fa-snapchat', 1);'
Request 141 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'googleplus', 'GooglePlus', 'https://www.googleplus.com/{socialid}', 'fa-google-plus-g', 1);'
Request 142 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'youtube', 'Youtube', 'https://www.youtube.com/{socialid}', 'fa-youtube', 1);'
Request 143 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'whatsapp', 'Whatsapp', '{socialid}', 'fa-whatsapp', 1);'
Request 144 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'tumblr', 'Tumblr', 'https://www.tumblr.com/{socialid}', 'fa-tumblr', 0);'
Request 145 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'vero', 'Vero', 'https://vero.co/{socialid}', '', 0);'
Request 146 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'viadeo', 'Viadeo', 'https://fr.viadeo.com/fr/{socialid}', 'fa-viadeo', 0);'
Request 147 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'slack', 'Slack', '{socialid}', 'fa-slack', 0);'
Request 148 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'xing', 'Xing', '{socialid}', 'fa-xing', 0);'
Request 149 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'meetup', 'Meetup', '{socialid}', 'fa-meetup', 0);'
Request 150 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'pinterest', 'Pinterest', '{socialid}', 'fa-pinterest', 0);'
Request 151 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'flickr', 'Flickr', '{socialid}', 'fa-flickr', 0);'
Request 152 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, '500px', '500px', '{socialid}', 'fa-500px', 0);'
Request 153 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'giphy', 'Giphy', '{socialid}', '', 0);'
Request 154 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'gifycat', 'Gificat', '{socialid}', '', 0);'
Request 155 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'dailymotion', 'Dailymotion', '{socialid}', '', 0);'
Request 156 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'vimeo', 'Vimeo', '{socialid}', '', 0);'
Request 157 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'periscope', 'Periscope', '{socialid}', '', 0);'
Request 158 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'twitch', 'Twitch', '{socialid}', '', 0);'
Request 159 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'discord', 'Discord', '{socialid}', 'fa-discord', 0);'
Request 160 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'wikipedia', 'Wikipedia', '{socialid}', '', 0);'
Request 161 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'reddit', 'Reddit', '{socialid}', 'fa-reddit', 0);'
Request 162 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'quora', 'Quora', '{socialid}', '', 0);'
Request 163 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'tripadvisor', 'Tripadvisor', '{socialid}', '', 0);'
Request 164 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'mastodon', 'Mastodon', '{socialid}', '', 0);'
Request 165 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'diaspora', 'Diaspora', '{socialid}', '', 0);'
Request 166 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'viber', 'Viber', '{socialid}', '', 0);'
Request 167 sql='ALTER TABLE llx_adherent ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;'
Request 168 sql='ALTER TABLE llx_societe ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;'
Request 169 sql='ALTER TABLE llx_socpeople ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;'
Request 170 sql='ALTER TABLE llx_user ADD COLUMN socialnetworks text DEFAULT NULL AFTER personal_email;'
Request 171 sql='ALTER TABLE llx_product ADD COLUMN net_measure float;'
Request 172 sql='ALTER TABLE llx_product ADD COLUMN net_measure_units tinyint;'
Request 173 sql='create table llx_adherent_type_lang ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_type integer DEFAULT 0 NOT NULL, lang varchar(5) DEFAULT 0 NOT NULL, label varchar(255) NOT NULL, description text, email text, import_key varchar(14) DEFAULT NULL )ENGINE=innodb;'
Request 174 sql='create table llx_fichinter_rec ( rowid integer AUTO_INCREMENT PRIMARY KEY, titre varchar(50) NOT NULL, entity integer DEFAULT 1 NOT NULL, fk_soc integer DEFAULT NULL, datec datetime, fk_contrat integer DEFAULT 0, fk_user_author integer, fk_projet integer, duree real, description text, modelpdf varchar(50), note_private text, note_public text, frequency integer, unit_frequency varchar(2) DEFAULT 'm', date_when datetime DEFAULT NULL, date_last_gen datetime DEFAULT NULL, nb_gen_done integer DEFAULT NULL, nb_gen_max integer DEFAULT NULL, auto_validate integer NULL DEFAULT NULL )ENGINE=innodb;'
Request 175 sql='ALTER TABLE llx_fichinter_rec ADD UNIQUE INDEX idx_fichinter_rec_uk_titre (titre, entity);'
Error DB_ERROR_1072 (Req 175): ALTER TABLE llx_fichinter_rec ADD UNIQUE INDEX idx_fichinter_rec_uk_titre (titre, entity);
Key column 'titre' doesn't exist in table
Request 176 sql='ALTER TABLE llx_fichinter_rec ADD INDEX idx_fichinter_rec_fk_soc (fk_soc);'
Request 177 sql='ALTER TABLE llx_fichinter_rec ADD INDEX idx_fichinter_rec_fk_user_author (fk_user_author);'
Request 178 sql='ALTER TABLE llx_fichinter_rec ADD INDEX idx_fichinter_rec_fk_projet (fk_projet);'
Request 179 sql='ALTER TABLE llx_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid);'
Request 180 sql='ALTER TABLE llx_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_projet FOREIGN KEY (fk_projet) REFERENCES llx_projet (rowid);'
Request 181 sql='create table llx_fichinterdet_rec ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_fichinter integer NOT NULL, date datetime, description text, duree integer, rang integer DEFAULT 0, total_ht DOUBLE(24, 8) NULL DEFAULT NULL, subprice DOUBLE(24, 8) NULL DEFAULT NULL, fk_parent_line integer NULL DEFAULT NULL, fk_product integer NULL DEFAULT NULL, label varchar(255) NULL DEFAULT NULL, tva_tx DOUBLE(6, 3) NULL DEFAULT NULL, localtax1_tx DOUBLE(6, 3) NULL DEFAULT 0, localtax1_type VARCHAR(1) NULL DEFAULT NULL, localtax2_tx DOUBLE(6, 3) NULL DEFAULT 0, localtax2_type VARCHAR(1) NULL DEFAULT NULL, qty double NULL DEFAULT NULL, remise_percent double NULL DEFAULT 0, remise double NULL DEFAULT 0, fk_remise_except integer NULL DEFAULT NULL, price DOUBLE(24, 8) NULL DEFAULT NULL, total_tva DOUBLE(24, 8) NULL DEFAULT NULL, total_localtax1 DOUBLE(24, 8) NULL DEFAULT 0, total_localtax2 DOUBLE(24, 8) NULL DEFAULT 0, total_ttc DOUBLE(24, 8) NULL DEFAULT NULL, product_type INTEGER NULL DEFAULT 0, date_start datetime NULL DEFAULT NULL, date_end datetime NULL DEFAULT NULL, info_bits INTEGER NULL DEFAULT 0, buy_price_ht DOUBLE(24, 8) NULL DEFAULT 0, fk_product_fournisseur_price integer NULL DEFAULT NULL, fk_code_ventilation integer NOT NULL DEFAULT 0, fk_export_commpta integer NOT NULL DEFAULT 0, special_code integer UNSIGNED NULL DEFAULT 0, fk_unit integer NULL DEFAULT NULL, import_key varchar(14) NULL DEFAULT NULL )ENGINE=innodb;'
Request 182 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_start datetime DEFAULT NULL AFTER product_type;'
Request 183 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_end datetime DEFAULT NULL AFTER date_start;'
Request 184 sql='create table llx_expedition_package ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_expedition integer NOT NULL, description varchar(255), value double(24,8) DEFAULT 0, fk_parcel_type integer, height float, width float, size float, size_units integer, weight float, weight_units integer, dangerous_goods smallint DEFAULT 0, tail_lift smallint DEFAULT 0, rang integer DEFAULT 0 )ENGINE=innodb;'
Request 185 sql='create table llx_c_shipment_package_type ( rowid integer AUTO_INCREMENT PRIMARY KEY, label varchar(50) NOT NULL, description varchar(255), active integer DEFAULT 1 NOT NULL, entity integer DEFAULT 1 NOT NULL )ENGINE=innodb;'
Request 186 sql='CREATE TABLE llx_product_fournisseur_price_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 187 sql='ALTER TABLE llx_product_fournisseur_price_extrafields ADD INDEX idx_product_fournisseur_price_extrafields (fk_object);'
Request 188 sql='CREATE TABLE llx_mrp_mo( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, ref varchar(128) DEFAULT '(PROV)' NOT NULL, entity integer DEFAULT 1 NOT NULL, label varchar(255), qty real NOT NULL, fk_warehouse integer, fk_soc integer, note_public text, note_private text, date_creation datetime NOT NULL, date_valid datetime NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_user_valid integer, model_pdf varchar(255), import_key varchar(14), status integer NOT NULL, fk_product integer NOT NULL, date_start_planned datetime, date_end_planned datetime, fk_bom integer, fk_project integer ) ENGINE=innodb;'
Request 189 sql='ALTER TABLE llx_mrp_mo ADD COLUMN date_valid datetime NULL;'
Request 190 sql='ALTER TABLE llx_mrp_mo ADD COLUMN fk_user_valid integer;'
Request 191 sql='ALTER TABLE llx_bom_bom ADD COLUMN model_pdf varchar(255);'
Request 192 sql='ALTER TABLE llx_mrp_mo ADD COLUMN model_pdf varchar(255);'
Request 193 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_ref (ref);'
Request 194 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_entity (entity);'
Request 195 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_soc (fk_soc);'
Request 196 sql='ALTER TABLE llx_mrp_mo ADD CONSTRAINT fk_mrp_mo_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 197 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_status (status);'
Request 198 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_product (fk_product);'
Request 199 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_date_start_planned (date_start_planned);'
Request 200 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_date_end_planned (date_end_planned);'
Request 201 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_bom (fk_bom);'
Request 202 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_project (fk_project);'
Request 203 sql='create table llx_mrp_mo_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 204 sql='ALTER TABLE llx_mrp_mo_extrafields ADD INDEX idx_fk_object(fk_object);'
Request 205 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_VALIDATE','BOM validated','Executed when a BOM is validated','bom',650);'
Request 206 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_UNVALIDATE','BOM unvalidated','Executed when a BOM is unvalidated','bom',651);'
Request 207 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_CLOSE','BOM disabled','Executed when a BOM is disabled','bom',652);'
Request 208 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_REOPEN','BOM reopen','Executed when a BOM is re-open','bom',653);'
Request 209 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_DELETE','BOM deleted','Executed when a BOM deleted','bom',654);'
Request 210 sql='DELETE FROM llx_c_action_trigger where code LIKE 'MO_%';'
Request 211 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_VALIDATE','MO validated','Executed when a MO is validated','bom',660);'
Request 212 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_PRODUCED','MO produced','Executed when a MO is produced','bom',661);'
Request 213 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_DELETE','MO deleted','Executed when a MO is deleted','bom',662);'
Request 214 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_CANCEL','MO canceled','Executed when a MO is canceled','bom',663);'
Request 215 sql='ALTER TABLE llx_comment ADD COLUMN fk_user_modif integer DEFAULT NULL;'
Request 216 sql='CREATE TABLE llx_mrp_production( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_mo integer NOT NULL, position integer NOT NULL DEFAULT 0, fk_product integer NOT NULL, fk_warehouse integer, qty real NOT NULL DEFAULT 1, qty_frozen smallint DEFAULT 0, disable_stock_change smallint DEFAULT 0, batch varchar(30), role varchar(10), fk_mrp_production integer, fk_stock_movement integer, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, import_key varchar(14) ) ENGINE=innodb;'
Request 217 sql='ALTER TABLE llx_mrp_production MODIFY COLUMN qty real NOT NULL DEFAULT 1;'
Request 218 sql='ALTER TABLE llx_mrp_production ADD COLUMN qty_frozen smallint DEFAULT 0;'
Request 219 sql='ALTER TABLE llx_mrp_production ADD COLUMN disable_stock_change smallint DEFAULT 0;'
Request 220 sql='ALTER TABLE llx_mrp_production ADD CONSTRAINT fk_mrp_production_mo FOREIGN KEY (fk_mo) REFERENCES llx_mrp_mo (rowid);'
Request 221 sql='ALTER TABLE llx_mrp_production ADD CONSTRAINT fk_mrp_production_product FOREIGN KEY (fk_product) REFERENCES llx_product (rowid);'
Request 222 sql='ALTER TABLE llx_mrp_production ADD CONSTRAINT fk_mrp_production_stock_movement FOREIGN KEY (fk_stock_movement) REFERENCES llx_stock_mouvement (rowid);'
Request 223 sql='ALTER TABLE llx_mrp_production ADD INDEX idx_mrp_production_fk_mo (fk_mo);'
Request 224 sql='ALTER TABLE llx_emailcollector_emailcollector ADD UNIQUE INDEX uk_emailcollector_emailcollector_ref(ref, entity);'
Request 225 sql='ALTER TABLE llx_website ADD COLUMN use_manifest integer;'
Request 226 sql='ALTER TABLE llx_facture_rec MODIFY COLUMN fk_cond_reglement integer NOT NULL DEFAULT 1;'
Request 227 sql='create table llx_commande_fournisseur_dispatch_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 228 sql='ALTER TABLE llx_commande_fournisseur_dispatch_extrafields ADD INDEX idx_commande_fournisseur_dispatch_extrafields (fk_object);'
Request 229 sql='create table llx_facturedet_rec_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 230 sql='ALTER TABLE llx_facturedet_rec_extrafields ADD INDEX idx_facturedet_rec_extrafields (fk_object);'
Script processingError - Show-Hide details
Error(s) were reported during the migration process so next step is not available. To ignore errors, you can click here, but the application or some features may not work correctly until the errors are resolved.