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.20-MariaDB-cll-lve
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script14.0.0-15.0.0.sql
Request 1 sql='ALTER TABLE llx_partnership MODIFY COLUMN date_partnership_end date NULL;'
Request 2 sql='ALTER TABLE llx_emailcollector_emailcollector MODIFY COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;'
Request 3 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN packaging real DEFAULT NULL;'
Request 4 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN packaging real DEFAULT NULL;'
Request 5 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL;'
Request 6 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD COLUMN fk_project integer NOT NULL;'
Request 7 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD COLUMN fk_invoice integer NULL;'
Request 8 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_soc;'
Request 9 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_actioncomm;'
Request 10 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_project;'
Request 11 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_rowid (rowid);'
Request 12 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_ref (ref);'
Request 13 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_fk_soc (fk_soc);'
Request 14 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_fk_actioncomm (fk_actioncomm);'
Request 15 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_email (email);'
Request 16 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_status (status);'
Request 17 sql='DROP INDEX uk_eventorganization_conferenceorboothattendee on llx_eventorganization_conferenceorboothattendee;'
Request 18 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD UNIQUE INDEX uk_eventorganization_conferenceorboothattendee(fk_project, email, fk_actioncomm);'
Request 19 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee MODIFY COLUMN fk_actioncomm integer NULL;'
Request 20 sql='ALTER TABLE llx_mrp_mo ADD COLUMN last_main_doc varchar(255);'
Request 21 sql='UPDATE llx_extrafields SET elementtype = 'salary' WHERE elementtype = 'payment_salary';'
Request 22 sql='ALTER TABLE llx_payment_salary_extrafields RENAME TO llx_salary_extrafields;'
Request 23 sql='DROP INDEX idx_payment_salary_extrafields on llx_salary_extrafields;'
Request 24 sql='ALTER TABLE llx_salary_extrafields ADD INDEX idx_salary_extrafields (fk_object);'
Request 25 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskConf)', 10, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskConf)__', '__(Hello)__,<br /><br />__(OrganizationEventConfRequestWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 26 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskBooth)', 20, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskBooth)__', '__(Hello)__,<br /><br />__(OrganizationEventBoothRequestWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 27 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailBoothPayment)', 30, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailBoothPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfBoothWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 28 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailRegistrationPayment)', 40, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailRegistrationPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfRegistrationWasReceived)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 29 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailAttendees)', 50, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailAttendees)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToAttendees)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 30 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailSpeakers)', 60, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailSpeakers)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToSpeakers)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 31 sql='UPDATE llx_c_email_templates SET label = '(EventOrganizationEmailBoothPayment)' WHERE label = '(EventOrganizationEmailSubsBooth)';'
Request 32 sql='UPDATE llx_c_email_templates SET label = '(EventOrganizationEmailRegistrationPayment)' WHERE label = '(EventOrganizationEmailSubsEvent)';'
Request 33 sql='UPDATE llx_facturedet SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and subprice > 0) OR (multicurrency_subprice > 0 and subprice < 0));'
Request 34 sql='UPDATE llx_facturedet SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 35 sql='UPDATE llx_facturedet SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));'
Request 36 sql='UPDATE llx_facturedet SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 37 sql='UPDATE llx_facture SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 38 sql='UPDATE llx_facture SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));'
Request 39 sql='UPDATE llx_facture SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 40 sql='UPDATE llx_facture_fourn_det SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and pu_ht > 0) OR (multicurrency_subprice > 0 and pu_ht < 0));'
Request 41 sql='UPDATE llx_facture_fourn_det SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 42 sql='UPDATE llx_facture_fourn_det SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and tva > 0) OR (multicurrency_total_tva > 0 and tva < 0));'
Request 43 sql='UPDATE llx_facture_fourn_det SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 44 sql='UPDATE llx_facture_fourn SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 45 sql='UPDATE llx_facture_fourn SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));'
Request 46 sql='UPDATE llx_facture_fourn SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 47 sql='ALTER TABLE llx_propaldet ADD COLUMN import_key varchar(14);'
Request 48 sql='ALTER TABLE llx_c_partnership_type ADD UNIQUE INDEX uk_c_partnership_type(entity, code);'
Request 49 sql='ALTER TABLE llx_partnership ADD COLUMN fk_type integer DEFAULT 0 NOT NULL;'
Request 50 sql='ALTER TABLE llx_c_holiday_types CHANGE COLUMN newByMonth newbymonth double(8,5) DEFAULT 0 NOT NULL;'
Request 51 sql='ALTER TABLE llx_product ADD COLUMN mandatory_period tinyint NULL DEFAULT 0;'
Request 52 sql='ALTER TABLE llx_holiday ADD COLUMN date_approve DATETIME DEFAULT NULL;'
Request 53 sql='ALTER TABLE llx_holiday ADD COLUMN fk_user_approve integer DEFAULT NULL;'
Request 54 sql='ALTER TABLE llx_ticket MODIFY COLUMN progress integer;'
Request 55 sql='ALTER TABLE llx_emailcollector_emailcollectoraction MODIFY COLUMN actionparam TEXT;'
Request 56 sql='ALTER TABLE llx_knowledgemanagement_knowledgerecord ADD COLUMN lang varchar(6);'
Request 57 sql='ALTER TABLE llx_knowledgemanagement_knowledgerecord ADD COLUMN entity integer DEFAULT 1;'
Request 58 sql='CREATE TABLE llx_categorie_ticket ( fk_categorie integer NOT NULL, fk_ticket integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 59 sql='ALTER TABLE llx_categorie_ticket ADD PRIMARY KEY pk_categorie_ticket (fk_categorie, fk_ticket);'
Request 60 sql='ALTER TABLE llx_categorie_ticket ADD INDEX idx_categorie_ticket_fk_categorie (fk_categorie);'
Request 61 sql='ALTER TABLE llx_categorie_ticket ADD INDEX idx_categorie_ticket_fk_ticket (fk_ticket);'
Request 62 sql='ALTER TABLE llx_categorie_ticket ADD CONSTRAINT fk_categorie_ticket_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 63 sql='ALTER TABLE llx_categorie_ticket ADD CONSTRAINT fk_categorie_ticket_ticket_rowid FOREIGN KEY (fk_ticket) REFERENCES llx_ticket (rowid);'
Request 64 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN ref_fourn varchar(128);'
Request 65 sql='ALTER TABLE llx_product_customer_price MODIFY COLUMN ref_customer varchar(128);'
Request 66 sql='ALTER TABLE llx_product_association ADD COLUMN rang integer DEFAULT 0;'
Request 67 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('ORDER_SUPPLIER_CANCEL','Supplier order request canceled','Executed when a supplier order is canceled','order_supplier',13);'
Request 68 sql='ALTER TABLE llx_product ADD COLUMN fk_default_bom integer DEFAULT NULL;'
Request 69 sql='ALTER TABLE llx_mrp_mo ADD COLUMN mrptype integer DEFAULT 0;'
Request 70 sql='DELETE FROM llx_menu WHERE type = 'top' AND module = 'cashdesk' AND mainmenu = 'cashdesk';'
Request 71 sql='INSERT INTO llx_c_action_trigger (code, label, description, elementtype, rang) values ('MEMBER_EXCLUDE', 'Member excluded', 'Executed when a member is excluded', 'member', 27);'
Request 72 sql='CREATE TABLE llx_categorie_knowledgemanagement ( fk_categorie integer NOT NULL, fk_knowledgemanagement integer NOT NULL, import_key varchar(14) )ENGINE=innodb;'
Request 73 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD PRIMARY KEY pk_categorie_knowledgemanagement (fk_categorie, fk_knowledgemanagement);'
Request 74 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD INDEX idx_categorie_knowledgemanagement_fk_categorie (fk_categorie);'
Request 75 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD INDEX idx_categorie_knowledgemanagement_fk_knowledgemanagement (fk_knowledgemanagement);'
Request 76 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD CONSTRAINT fk_categorie_knowledgemanagement_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 77 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD CONSTRAINT fk_categorie_knowledgemanagement_knowledgemanagement_rowid FOREIGN KEY (fk_knowledgemanagement) REFERENCES llx_knowledgemanagement_knowledgerecord (rowid);'
Request 78 sql='ALTER TABLE llx_product_lot ADD COLUMN barcode varchar(180) DEFAULT NULL;'
Request 79 sql='ALTER TABLE llx_product_lot ADD COLUMN fk_barcode_type integer DEFAULT NULL;'
Request 80 sql='ALTER TABLE llx_projet ADD COLUMN max_attendees integer DEFAULT 0;'
Request 81 sql='ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN cost_price double(24,8) DEFAULT 0;'
Request 82 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2001', 'Aktiebolag');'
Request 83 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2002', 'Publikt aktiebolag (AB publ)');'
Request 84 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2003', 'Ekonomisk förening (ek. för.)');'
Request 85 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2004', 'Bostadsrättsförening (BRF)');'
Request 86 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2005', 'Hyresrättsförening (HRF)');'
Request 87 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2006', 'Kooperativ');'
Request 88 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2007', 'Enskild firma (EF)');'
Request 89 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2008', 'Handelsbolag (HB)');'
Request 90 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2009', 'Kommanditbolag (KB)');'
Request 91 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2010', 'Enkelt bolag');'
Request 92 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2011', 'Ideell förening');'
Request 93 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2012', 'Stiftelse');'
Request 94 sql='CREATE TABLE llx_hrm_evaluation ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, ref varchar(128) DEFAULT '(PROV)' NOT NULL, label varchar(255), description text, note_public text, note_private text, 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), status smallint NOT NULL, date_eval date, fk_user integer NOT NULL, fk_job integer NOT NULL ) ENGINE=innodb;'
Request 95 sql='ALTER TABLE llx_hrm_evaluation ADD INDEX idx_hrm_evaluation_rowid (rowid);'
Request 96 sql='ALTER TABLE llx_hrm_evaluation ADD INDEX idx_hrm_evaluation_ref (ref);'
Request 97 sql='ALTER TABLE llx_hrm_evaluation ADD CONSTRAINT llx_hrm_evaluation_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 98 sql='ALTER TABLE llx_hrm_evaluation ADD INDEX idx_hrm_evaluation_status (status);'
Request 99 sql='create table llx_hrm_evaluation_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 100 sql='ALTER TABLE llx_hrm_evaluation_extrafields ADD INDEX idx_evaluation_fk_object(fk_object);'
Request 101 sql='CREATE TABLE llx_hrm_evaluationdet ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_skill integer NOT NULL, fk_evaluation integer NOT NULL, rankorder integer NOT NULL, required_rank integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 102 sql='ALTER TABLE llx_hrm_evaluationdet ADD INDEX idx_hrm_evaluationdet_rowid (rowid);'
Request 103 sql='ALTER TABLE llx_hrm_evaluationdet ADD CONSTRAINT llx_hrm_evaluationdet_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 104 sql='ALTER TABLE llx_hrm_evaluationdet ADD INDEX idx_hrm_evaluationdet_fk_skill (fk_skill);'
Request 105 sql='ALTER TABLE llx_hrm_evaluationdet ADD INDEX idx_hrm_evaluationdet_fk_evaluation (fk_evaluation);'
Request 106 sql='create table llx_hrm_evaluationdet_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 107 sql='ALTER TABLE llx_hrm_evaluationdet_extrafields ADD INDEX idx_evaluationdet_fk_object(fk_object);'
Request 108 sql='CREATE TABLE llx_hrm_job ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, label varchar(255) NOT NULL, description text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deplacement varchar(255), note_public text, note_private text, fk_user_creat integer, fk_user_modif integer ) ENGINE=innodb;'
Request 109 sql='ALTER TABLE llx_hrm_job ADD INDEX idx_hrm_job_rowid (rowid);'
Request 110 sql='ALTER TABLE llx_hrm_job ADD INDEX idx_hrm_job_label (label);'
Request 111 sql='create table llx_hrm_job_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 112 sql='ALTER TABLE llx_hrm_job_extrafields ADD INDEX idx_job_fk_object(fk_object);'
Request 113 sql='CREATE TABLE llx_hrm_job_user( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, description text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_contrat integer, fk_user integer, fk_job integer NOT NULL, date_start date, date_end date, abort_comment varchar(255), note_public text, note_private text, fk_user_creat integer, fk_user_modif integer ) ENGINE=innodb;'
Request 114 sql='ALTER TABLE llx_hrm_job_user ADD COLUMN abort_comment varchar(255);'
Request 115 sql='ALTER TABLE llx_hrm_job_user ADD INDEX idx_hrm_job_user_rowid (rowid);'
Request 116 sql='CREATE TABLE llx_hrm_skill ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, label varchar(255), description text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, required_level integer NOT NULL, date_validite integer NOT NULL, temps_theorique double(24,8) NOT NULL, skill_type integer NOT NULL, note_public text, note_private text ) ENGINE=innodb;'
Request 117 sql='ALTER TABLE llx_hrm_skill ADD INDEX idx_hrm_skill_rowid (rowid);'
Request 118 sql='ALTER TABLE llx_hrm_skill ADD CONSTRAINT llx_hrm_skill_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 119 sql='ALTER TABLE llx_hrm_skill ADD INDEX idx_hrm_skill_skill_type (skill_type);'
Request 120 sql='create table llx_hrm_skill_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 121 sql='ALTER TABLE llx_hrm_skill_extrafields ADD INDEX idx_skill_fk_object(fk_object);'
Request 122 sql='CREATE TABLE llx_hrm_skilldet ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, description text, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_skill integer NOT NULL, rankorder integer ) ENGINE=innodb;'
Request 123 sql='ALTER TABLE llx_hrm_skilldet ADD COLUMN rankorder integer NOT NULL DEFAULT '1';'
Request 124 sql='ALTER TABLE llx_hrm_skilldet ADD INDEX idx_hrm_skilldet_rowid (rowid);'
Request 125 sql='ALTER TABLE llx_hrm_skilldet ADD CONSTRAINT llx_hrm_skilldet_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 126 sql='CREATE TABLE llx_hrm_skillrank ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_skill integer NOT NULL, rankorder integer NOT NULL, fk_object integer NOT NULL, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, objecttype varchar(128) NOT NULL ) ENGINE=innodb;'
Request 127 sql='ALTER TABLE llx_hrm_skillrank ADD INDEX idx_hrm_skillrank_rowid (rowid);'
Request 128 sql='ALTER TABLE llx_hrm_skillrank ADD INDEX idx_hrm_skillrank_fk_skill (fk_skill);'
Request 129 sql='ALTER TABLE llx_hrm_skillrank ADD CONSTRAINT llx_hrm_skillrank_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 130 sql='ALTER TABLE llx_c_units ADD COLUMN sortorder smallint AFTER code;'
Request 131 sql='ALTER TABLE llx_societe_perentity ADD COLUMN accountancy_code_customer varchar(24) AFTER entity;'
Request 132 sql='ALTER TABLE llx_societe_perentity ADD COLUMN accountancy_code_supplier varchar(24) AFTER accountancy_code_customer;'
Request 133 sql='ALTER TABLE llx_projet_task ADD COLUMN budget_amount double(24,8) AFTER priority;'
Request 134 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_ticket_by_severity.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_ticket_by_severity.php' AND entity = 1);'
Request 135 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_nb_ticket_last_x_days.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_nb_ticket_last_x_days.php' AND entity = 1);'
Request 136 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_nb_tickets_type.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_nb_tickets_type.php' AND entity = 1);'
Request 137 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_new_vs_close_ticket.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_new_vs_close_ticket.php' AND entity = 1);'
Request 138 sql='ALTER TABLE llx_user DROP COLUMN jabberid;'
Request 139 sql='ALTER TABLE llx_user DROP COLUMN skype;'
Request 140 sql='ALTER TABLE llx_user DROP COLUMN twitter;'
Request 141 sql='ALTER TABLE llx_user DROP COLUMN facebook;'
Request 142 sql='ALTER TABLE llx_user DROP COLUMN linkedin;'
Request 143 sql='ALTER TABLE llx_user DROP COLUMN instagram;'
Request 144 sql='ALTER TABLE llx_user DROP COLUMN snapchat;'
Request 145 sql='ALTER TABLE llx_user DROP COLUMN googleplus;'
Request 146 sql='ALTER TABLE llx_user DROP COLUMN youtube;'
Request 147 sql='ALTER TABLE llx_user DROP COLUMN whatsapp;'
Request 148 sql='ALTER TABLE llx_adherent DROP COLUMN jabberid;'
Request 149 sql='ALTER TABLE llx_adherent DROP COLUMN skype;'
Request 150 sql='ALTER TABLE llx_adherent DROP COLUMN twitter;'
Request 151 sql='ALTER TABLE llx_adherent DROP COLUMN facebook;'
Request 152 sql='ALTER TABLE llx_adherent DROP COLUMN linkedin;'
Request 153 sql='ALTER TABLE llx_adherent DROP COLUMN instagram;'
Request 154 sql='ALTER TABLE llx_adherent DROP COLUMN snapchat;'
Request 155 sql='ALTER TABLE llx_adherent DROP COLUMN googleplus;'
Request 156 sql='ALTER TABLE llx_adherent DROP COLUMN youtube;'
Request 157 sql='ALTER TABLE llx_adherent DROP COLUMN whatsapp;'
Request 158 sql='ALTER TABLE llx_societe DROP COLUMN jabberid;'
Request 159 sql='ALTER TABLE llx_societe DROP COLUMN skype;'
Request 160 sql='ALTER TABLE llx_societe DROP COLUMN twitter;'
Request 161 sql='ALTER TABLE llx_societe DROP COLUMN facebook;'
Request 162 sql='ALTER TABLE llx_societe DROP COLUMN linkedin;'
Request 163 sql='ALTER TABLE llx_societe DROP COLUMN instagram;'
Request 164 sql='ALTER TABLE llx_societe DROP COLUMN snapchat;'
Request 165 sql='ALTER TABLE llx_societe DROP COLUMN googleplus;'
Request 166 sql='ALTER TABLE llx_societe DROP COLUMN youtube;'
Request 167 sql='ALTER TABLE llx_societe DROP COLUMN whatsapp;'
Request 168 sql='ALTER TABLE llx_socpeople DROP COLUMN jabberid;'
Request 169 sql='ALTER TABLE llx_socpeople DROP COLUMN skype;'
Request 170 sql='ALTER TABLE llx_socpeople DROP COLUMN twitter;'
Request 171 sql='ALTER TABLE llx_socpeople DROP COLUMN facebook;'
Request 172 sql='ALTER TABLE llx_socpeople DROP COLUMN linkedin;'
Request 173 sql='ALTER TABLE llx_socpeople DROP COLUMN instagram;'
Request 174 sql='ALTER TABLE llx_socpeople DROP COLUMN snapchat;'
Request 175 sql='ALTER TABLE llx_socpeople DROP COLUMN googleplus;'
Request 176 sql='ALTER TABLE llx_socpeople DROP COLUMN youtube;'
Request 177 sql='ALTER TABLE llx_socpeople DROP COLUMN whatsapp;'
Request 178 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (100, 'KLA', 'Klarna', 1, 0);'
Request 179 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (101, 'SOF', 'Sofort', 1, 0);'
Request 180 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (102, 'BAN', 'Bancontact', 1, 0);'
Request 181 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (103, 'IDE', 'iDeal', 1, 0);'
Request 182 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (104, 'GIR', 'Giropay', 1, 0);'
Request 183 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_code varchar(3);'
Request 184 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 185 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 186 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_code varchar(3);'
Request 187 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 188 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 189 sql='ALTER TABLE llx_commande_fournisseur MODIFY COLUMN multicurrency_code varchar(3);'
Request 190 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN multicurrency_code varchar(3);'
Request 191 sql='ALTER TABLE llx_commande MODIFY COLUMN multicurrency_code varchar(3);'
Request 192 sql='ALTER TABLE llx_commandedet MODIFY COLUMN multicurrency_code varchar(3);'
Request 193 sql='ALTER TABLE llx_contratdet MODIFY COLUMN multicurrency_code varchar(3);'
Request 194 sql='ALTER TABLE llx_expensereport_det MODIFY COLUMN multicurrency_code varchar(3);'
Request 195 sql='ALTER TABLE llx_expensereport MODIFY COLUMN multicurrency_code varchar(3);'
Request 196 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN multicurrency_code varchar(3);'
Request 197 sql='ALTER TABLE llx_facture_fourn MODIFY COLUMN multicurrency_code varchar(3);'
Request 198 sql='ALTER TABLE llx_facture_rec MODIFY COLUMN multicurrency_code varchar(3);'
Request 199 sql='ALTER TABLE llx_facture MODIFY COLUMN multicurrency_code varchar(3);'
Request 200 sql='ALTER TABLE llx_facturedet_rec MODIFY COLUMN multicurrency_code varchar(3);'
Request 201 sql='ALTER TABLE llx_facturedet MODIFY COLUMN multicurrency_code varchar(3);'
Request 202 sql='ALTER TABLE llx_paiement_facture MODIFY COLUMN multicurrency_code varchar(3);'
Request 203 sql='ALTER TABLE llx_paiementfourn_facturefourn MODIFY COLUMN multicurrency_code varchar(3);'
Request 204 sql='ALTER TABLE llx_product_fournisseur_price_log MODIFY COLUMN multicurrency_code varchar(3);'
Request 205 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN multicurrency_code varchar(3);'
Request 206 sql='ALTER TABLE llx_product_price_by_qty MODIFY COLUMN multicurrency_code varchar(3);'
Request 207 sql='ALTER TABLE llx_product_price MODIFY COLUMN multicurrency_code varchar(3);'
Request 208 sql='ALTER TABLE llx_propal MODIFY COLUMN multicurrency_code varchar(3);'
Request 209 sql='ALTER TABLE llx_propaldet MODIFY COLUMN multicurrency_code varchar(3);'
Request 210 sql='ALTER TABLE llx_societe MODIFY COLUMN multicurrency_code varchar(3);'
Request 211 sql='ALTER TABLE llx_supplier_proposal MODIFY COLUMN multicurrency_code varchar(3);'
Request 212 sql='ALTER TABLE llx_supplier_proposaldet MODIFY COLUMN multicurrency_code varchar(3);'
Request 213 sql='ALTER TABLE llx_propal ADD COLUMN online_sign_ip varchar(48);'
Request 214 sql='ALTER TABLE llx_propal ADD COLUMN online_sign_name varchar(64);'
Request 215 sql='ALTER TABLE llx_entrepot ADD COLUMN warehouse_usage integer DEFAULT 1;'
Request 216 sql='ALTER TABLE llx_session MODIFY COLUMN user_agent VARCHAR(255) NULL;'
Request 217 sql='ALTER TABLE llx_inventorydet ADD COLUMN fk_movement integer NULL;'
Request 218 sql='ALTER TABLE llx_stock_mouvement MODIFY COLUMN origintype varchar(64);'
Request 219 sql='ALTER TABLE llx_intracommreport CHANGE COLUMN period periods varchar(32);'
Request 220 sql='UPDATE llx_rights_def SET perms = 'writeall' WHERE perms = 'writeall_advance' AND module = 'holiday';'
Request 221 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_CREATE','User created','Executed when a user is created','user',301);'
Request 222 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_MODIFY','User update','Executed when a user is updated','user',302);'
Request 223 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_DELETE','User update','Executed when a user is deleted','user',303);'
Request 224 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_NEW_PASSWORD','User update','Executed when a user is change password','user',304);'
Request 225 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_ENABLEDISABLE','User update','Executed when a user is enable or disable','user',305);'
Request 226 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_CREATE','Holiday created','Executed when a holiday is created','holiday',800);'
Request 227 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_MODIFY','Holiday modified','Executed when a holiday is modified','holiday',801);'
Request 228 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Holiday validated','Executed when a holiday is validated','holiday',802);'
Request 229 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE','Holiday aprouved','Executed when a holiday is aprouved','holiday',803);'
Request 230 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_CANCEL','Holiday canceled','Executed when a holiday is canceled','holiday',802);'
Request 231 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_DELETE','Holiday deleted','Executed when a holiday is deleted','holiday',804);'
Request 232 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15401', '601 - General de Ley Personas Morales', 1);'
Request 233 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15402', '603 - Personas Morales con Fines no Lucrativos', 1);'
Request 234 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15403', '605 - Sueldos y Salarios e Ingresos Asimilados a Salarios', 1);'
Request 235 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15404', '606 - Arrendamiento', 1);'
Request 236 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15405', '607 - Régimen de Enajenación o Adquisición de Bienes', 1);'
Request 237 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15406', '608 - Demás ingresos', 1);'
Request 238 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15407', '610 - Residentes en el Extranjero sin Establecimiento Permanente en México', 1);'
Request 239 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15408', '611 - Ingresos por Dividendos (socios y accionistas)', 1);'
Request 240 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15409', '612 - Personas Físicas con Actividades Empresariales y Profesionales', 1);'
Request 241 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15410', '614 - Ingresos por intereses', 1);'
Request 242 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15411', '615 - Régimen de los ingresos por obtención de premios', 1);'
Request 243 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15412', '616 - Sin obligaciones fiscales', 1);'
Request 244 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15413', '620 - Sociedades Cooperativas de Producción que optan por diferir sus ingresos', 1);'
Request 245 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15414', '621 - Incorporación Fiscal', 1);'
Request 246 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15415', '622 - Actividades Agrícolas, Ganaderas, Silvícolas y Pesqueras', 1);'
Request 247 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15416', '623 - Opcional para Grupos de Sociedades', 1);'
Request 248 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15417', '624 - Coordinados', 1);'
Request 249 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15418', '625 - Régimen de las Actividades Empresariales con ingresos a través de Plataformas Tecnológicas', 1);'
Request 250 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (154, '15419', '626 - Régimen Simplificado de Confianza', 1);'
Request 251 sql='ALTER TABLE llx_user MODIFY COLUMN fk_soc integer NULL;'
Request 252 sql='CREATE TABLE llx_element_tag ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_categorie integer NOT NULL, fk_element integer NOT NULL, import_key varchar(14) )ENGINE=innodb;'
Request 253 sql='ALTER TABLE llx_element_tag ADD COLUMN fk_categorie integer;'
Request 254 sql='ALTER TABLE llx_element_tag ADD COLUMN fk_element integer;'
Request 255 sql='ALTER TABLE llx_element_tag ADD UNIQUE INDEX idx_element_tag_uk (fk_categorie, fk_element);'
Request 256 sql='ALTER TABLE llx_element_tag ADD CONSTRAINT fk_element_tag_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 257 sql='ALTER TABLE llx_bank ADD COLUMN amount_main_currency double(24,8) NULL;'
Request 258 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN ref varchar(128);'
Request 259 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN ref varchar(128);'
Request 260 sql='UPDATE llx_c_tva SET localtax2 = '-19:-15:-9' WHERE localtax2 = '-19' AND localtax2_type = '5' AND fk_pays = 4 AND taux = 21;'
Script processingOK - Show-Hide details