|
Choose migration script | 14.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_product_fournisseur_price ADD COLUMN packaging real DEFAULT NULL;' |
Request 3 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN packaging real DEFAULT NULL;' |
Request 4 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL;' |
Request 5 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD COLUMN fk_project integer NOT NULL;' |
Request 6 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD COLUMN fk_invoice integer NULL;' |
Request 7 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_soc;' |
Request 8 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_actioncomm;' |
Request 9 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_project;' |
Request 10 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_rowid (rowid);' |
Request 11 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_ref (ref);' |
Request 12 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_fk_soc (fk_soc);' |
Request 13 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_fk_actioncomm (fk_actioncomm);' |
Request 14 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_email (email);' |
Request 15 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_status (status);' |
Request 16 sql='DROP INDEX uk_eventorganization_conferenceorboothattendee on llx_eventorganization_conferenceorboothattendee;' |
Request 17 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD UNIQUE INDEX uk_eventorganization_conferenceorboothattendee(fk_project, email, fk_actioncomm);' |
Request 18 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee MODIFY COLUMN fk_actioncomm integer NULL;' |
Request 19 sql='ALTER TABLE llx_mrp_mo ADD COLUMN last_main_doc varchar(255);' |
Request 20 sql='UPDATE llx_extrafields SET elementtype = 'salary' WHERE elementtype = 'payment_salary';' |
Request 21 sql='ALTER TABLE llx_payment_salary_extrafields RENAME TO llx_salary_extrafields;' |
Request 22 sql='DROP INDEX idx_payment_salary_extrafields on llx_salary_extrafields;' |
Request 23 sql='ALTER TABLE llx_salary_extrafields ADD INDEX idx_salary_extrafields (fk_object);' |
Request 24 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 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, '(EventOrganizationEmailAskBooth)', 20, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskBooth)__', '__(Hello)__,<br /><br />__(OrganizationEventBoothRequestWasReceived)__<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, '(EventOrganizationEmailBoothPayment)', 30, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailBoothPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfBoothWasReceived)__<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, '(EventOrganizationEmailRegistrationPayment)', 40, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailRegistrationPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfRegistrationWasReceived)__<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, '(EventOrganizationMassEmailAttendees)', 50, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailAttendees)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToAttendees)__<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, '(EventOrganizationMassEmailSpeakers)', 60, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailSpeakers)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToSpeakers)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
Request 30 sql='UPDATE llx_c_email_templates SET label = '(EventOrganizationEmailBoothPayment)' WHERE label = '(EventOrganizationEmailSubsBooth)';' |
Request 31 sql='UPDATE llx_c_email_templates SET label = '(EventOrganizationEmailRegistrationPayment)' WHERE label = '(EventOrganizationEmailSubsEvent)';' |
Request 32 sql='UPDATE llx_facturedet SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and subprice > 0) OR (multicurrency_subprice > 0 and subprice < 0));' |
Request 33 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 34 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 35 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 36 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 37 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 38 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 39 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 40 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 41 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 42 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 43 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 44 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 45 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 46 sql='ALTER TABLE llx_propaldet ADD COLUMN import_key varchar(14);' |
Request 47 sql='ALTER TABLE llx_c_partnership_type ADD UNIQUE INDEX uk_c_partnership_type(entity, code);' |
Request 48 sql='ALTER TABLE llx_partnership ADD COLUMN fk_type integer DEFAULT 0 NOT NULL;' |
Request 49 sql='ALTER TABLE llx_c_holiday_types CHANGE COLUMN newByMonth newbymonth double(8,5) DEFAULT 0 NOT NULL;' |
Request 50 sql='ALTER TABLE llx_product ADD COLUMN mandatory_period tinyint NULL DEFAULT 0;' |
Request 51 sql='ALTER TABLE llx_holiday ADD COLUMN date_approve DATETIME DEFAULT NULL;' |
Request 52 sql='ALTER TABLE llx_holiday ADD COLUMN fk_user_approve integer DEFAULT NULL;' |
Request 53 sql='ALTER TABLE llx_ticket MODIFY COLUMN progress integer;' |
Request 54 sql='ALTER TABLE llx_emailcollector_emailcollectoraction MODIFY COLUMN actionparam TEXT;' |
Request 55 sql='ALTER TABLE llx_knowledgemanagement_knowledgerecord ADD COLUMN lang varchar(6);' |
Request 56 sql='ALTER TABLE llx_knowledgemanagement_knowledgerecord ADD COLUMN entity integer DEFAULT 1;' |
Request 57 sql='CREATE TABLE llx_categorie_ticket ( fk_categorie integer NOT NULL, fk_ticket integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
Request 58 sql='ALTER TABLE llx_categorie_ticket ADD PRIMARY KEY pk_categorie_ticket (fk_categorie, fk_ticket);' |
Request 59 sql='ALTER TABLE llx_categorie_ticket ADD INDEX idx_categorie_ticket_fk_categorie (fk_categorie);' |
Request 60 sql='ALTER TABLE llx_categorie_ticket ADD INDEX idx_categorie_ticket_fk_ticket (fk_ticket);' |
Request 61 sql='ALTER TABLE llx_categorie_ticket ADD CONSTRAINT fk_categorie_ticket_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
Request 62 sql='ALTER TABLE llx_categorie_ticket ADD CONSTRAINT fk_categorie_ticket_ticket_rowid FOREIGN KEY (fk_ticket) REFERENCES llx_ticket (rowid);' |
Request 63 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN ref_fourn varchar(128);' |
Request 64 sql='ALTER TABLE llx_product_customer_price MODIFY COLUMN ref_customer varchar(128);' |
Request 65 sql='ALTER TABLE llx_product_association ADD COLUMN rang integer DEFAULT 0;' |
Request 66 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 67 sql='ALTER TABLE llx_product ADD COLUMN fk_default_bom integer DEFAULT NULL;' |
Request 68 sql='ALTER TABLE llx_mrp_mo ADD COLUMN mrptype integer DEFAULT 0;' |
Request 69 sql='DELETE FROM llx_menu WHERE type = 'top' AND module = 'cashdesk' AND mainmenu = 'cashdesk';' |
Request 70 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 71 sql='CREATE TABLE llx_categorie_knowledgemanagement ( fk_categorie integer NOT NULL, fk_knowledgemanagement integer NOT NULL, import_key varchar(14) )ENGINE=innodb;' |
Request 72 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD PRIMARY KEY pk_categorie_knowledgemanagement (fk_categorie, fk_knowledgemanagement);' |
Request 73 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD INDEX idx_categorie_knowledgemanagement_fk_categorie (fk_categorie);' |
Request 74 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD INDEX idx_categorie_knowledgemanagement_fk_knowledgemanagement (fk_knowledgemanagement);' |
Request 75 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD CONSTRAINT fk_categorie_knowledgemanagement_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
Request 76 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD CONSTRAINT fk_categorie_knowledgemanagement_knowledgemanagement_rowid FOREIGN KEY (fk_knowledgemanagement) REFERENCES llx_knowledgemanagement_knowledgerecord (rowid);' |
Request 77 sql='ALTER TABLE llx_product_lot ADD COLUMN barcode varchar(180) DEFAULT NULL;' |
Request 78 sql='ALTER TABLE llx_product_lot ADD COLUMN fk_barcode_type integer DEFAULT NULL;' |
Request 79 sql='ALTER TABLE llx_projet ADD COLUMN max_attendees integer DEFAULT 0;' |
Request 80 sql='ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN cost_price double(24,8) DEFAULT 0;' |
Request 81 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2001', 'Aktiebolag');' |
Request 82 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2002', 'Publikt aktiebolag (AB publ)');' |
Request 83 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2003', 'Ekonomisk förening (ek. för.)');' |
Request 84 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2004', 'Bostadsrättsförening (BRF)');' |
Request 85 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2005', 'Hyresrättsförening (HRF)');' |
Request 86 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2006', 'Kooperativ');' |
Request 87 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2007', 'Enskild firma (EF)');' |
Request 88 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2008', 'Handelsbolag (HB)');' |
Request 89 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2009', 'Kommanditbolag (KB)');' |
Request 90 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2010', 'Enkelt bolag');' |
Request 91 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2011', 'Ideell förening');' |
Request 92 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2012', 'Stiftelse');' |
Request 93 sql='ALTER TABLE llx_c_holiday_types ADD COLUMN block_if_negative integer NOT NULL DEFAULT 0 AFTER fk_country;' |
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 processing | OK - Show-Hide details |