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 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);'
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,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,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,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;'
Request 79 sql='ALTER TABLE llx_mailing_cibles ADD COLUMN tms 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);'
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,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,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,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,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,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,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 processingOK