 Database migration (structure + some data)
| Server connection : ecoledusdoli.mysql.db | OK |
| Database connection : ecoledusdoli | OK |
| Database server version | 8.0.41-32 | | Client charset | utf8 | | Client collation | utf8_general_ci | | Please be patient... |
| | Choose migration script | 16.0.0-17.0.0.sql |
| Request 1 sql='ALTER TABLE llx_accounting_account DROP FOREIGN KEY fk_accounting_account_fk_pcg_version;' |
| Request 2 sql='ALTER TABLE llx_accounting_system MODIFY COLUMN pcg_version varchar(32) NOT NULL;' |
| Request 3 sql='ALTER TABLE llx_accounting_account ADD CONSTRAINT fk_accounting_account_fk_pcg_version FOREIGN KEY (fk_pcg_version) REFERENCES llx_accounting_system (pcg_version);' |
| Request 4 sql='ALTER TABLE llx_c_action_trigger MODIFY elementtype VARCHAR(64);' |
| Request 5 sql='ALTER TABLE llx_c_email_templates ADD COLUMN joinfiles text;' |
| Request 6 sql='ALTER TABLE llx_c_email_templates ADD COLUMN email_from varchar(255);' |
| Request 7 sql='ALTER TABLE llx_c_email_templates ADD COLUMN email_to varchar(255);' |
| Request 8 sql='ALTER TABLE llx_c_email_templates ADD COLUMN email_tocc varchar(255);' |
| Request 9 sql='ALTER TABLE llx_c_email_templates ADD COLUMN email_tobcc varchar(255);' |
| Request 10 sql='ALTER TABLE llx_c_email_templates ADD COLUMN content_lines text;' |
| Request 11 sql='ALTER TABLE llx_c_email_templates ADD COLUMN enabled varchar(255) DEFAULT '1';' |
| Request 12 sql='ALTER TABLE llx_expedition ADD COLUMN billed smallint DEFAULT 0;' |
| Request 13 sql='ALTER TABLE llx_user DROP COLUMN idpers1;' |
| Request 14 sql='ALTER TABLE llx_user DROP COLUMN idpers2;' |
| Request 15 sql='ALTER TABLE llx_user DROP COLUMN idpers3;' |
| Request 16 sql='UPDATE llx_c_actioncomm SET type = 'system' WHERE code = 'AC_OTH';' |
| Request 17 sql='ALTER TABLE llx_opensurvey_user_studs MODIFY reponses VARCHAR(200) NOT NULL;' |
| Request 18 sql='ALTER TABLE llx_overwrite_trans DROP INDEX uk_overwrite_trans;' |
| Request 19 sql='ALTER TABLE llx_overwrite_trans ADD UNIQUE INDEX uk_overwrite_trans(lang, transkey, entity);' |
| Request 20 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN source_type varchar(32);' |
| Request 21 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_percent (percent);' |
| Request 22 sql='UPDATE llx_c_paiement SET code = 'BANCON' WHERE code = 'BAN' AND libelle = 'Bancontact';' |
| Request 23 sql='ALTER TABLE llx_partnership DROP FOREIGN KEY llx_partnership_fk_user_creat;' |
| Request 24 sql='ALTER TABLE llx_partnership MODIFY COLUMN fk_user_creat integer NULL;' |
| Request 25 sql='ALTER TABLE llx_partnership ADD COLUMN ip varchar(250);' |
| Request 26 sql='ALTER TABLE llx_adherent ADD COLUMN ip varchar(250);' |
| Request 27 sql='ALTER TABLE llx_projet ADD COLUMN ip varchar(250);' |
| Request 28 sql='ALTER TABLE llx_actioncomm ADD COLUMN ip varchar(250);' |
| Request 29 sql='ALTER TABLE llx_eventorganization_conferenceorboothattendee ADD COLUMN ip varchar(250);' |
| Request 30 sql='ALTER TABLE llx_opensurvey_user_studs ADD COLUMN ip varchar(250);' |
| Request 31 sql='ALTER TABLE llx_opensurvey_comments ADD COLUMN ip varchar(250);' |
| Request 32 sql='ALTER TABLE llx_fichinterdet_rec DROP COLUMN remise;' |
| Request 33 sql='ALTER TABLE llx_fichinterdet_rec DROP COLUMN fk_export_commpta;' |
| Request 34 sql='UPDATE llx_const set name = 'ADHERENT_MAILMAN_ADMIN_PASSWORD' WHERE name = 'ADHERENT_MAILMAN_ADMINPW';' |
| Request 35 sql='ALTER TABLE llx_oauth_token ADD COLUMN state text after tokenstring;' |
| Request 36 sql='ALTER TABLE llx_adherent ADD COLUMN default_lang VARCHAR(6) DEFAULT NULL AFTER datefin;' |
| Request 37 sql='ALTER TABLE llx_adherent_type ADD COLUMN caneditamount integer DEFAULT 0 AFTER amount;' |
| Request 38 sql='ALTER TABLE llx_holiday CHANGE COLUMN date_approve date_approval datetime;' |
| Request 39 sql='UPDATE llx_holiday SET date_approval = date_valid WHERE statut = 3 AND date_approval IS NULL;' |
| Request 40 sql='UPDATE llx_holiday SET fk_user_approve = fk_user_valid WHERE statut = 3 AND fk_user_approve IS NULL;' |
| Request 41 sql='ALTER TABLE llx_inventory ADD COLUMN categories_product VARCHAR(255) DEFAULT NULL AFTER fk_product;' |
| Request 42 sql='ALTER TABLE llx_societe ADD last_main_doc VARCHAR(255) NULL AFTER model_pdf;' |
| Request 43 sql='ALTER TABLE llx_emailcollector_emailcollector MODIFY COLUMN lastresult text;' |
| Request 44 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN port varchar(10) DEFAULT '993';' |
| Request 45 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN acces_type integer DEFAULT 0;' |
| Request 46 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN oauth_service varchar(128) DEFAULT NULL;' |
| Request 47 sql='ALTER TABLE llx_bank ADD COLUMN position integer DEFAULT 0;' |
| Request 48 sql='ALTER TABLE llx_commande_fournisseur_dispatch ADD INDEX idx_commande_fournisseur_dispatch_fk_product (fk_product);' |
| Request 49 sql='INSERT INTO llx_const (name, entity, value, type, visible) VALUES ('MAIN_SECURITY_MAX_IMG_IN_HTML_CONTENT', 1, 1000, 'int', 0);' |
| Request 50 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN port varchar(10) DEFAULT '993';' |
| Request 51 sql='ALTER TABLE llx_facture ADD COLUMN close_missing_amount double(24, 8) after close_code;' |
| Request 52 sql='ALTER TABLE llx_facture_fourn ADD COLUMN close_missing_amount double(24, 8) after close_code;' |
| Request 53 sql='ALTER TABLE llx_inventory ADD COLUMN categories_product VARCHAR(255) DEFAULT NULL AFTER fk_product;' |
| Request 54 sql='ALTER TABLE llx_product ADD COLUMN sell_or_eat_by_mandatory tinyint DEFAULT 0 NOT NULL AFTER tobatch;' |
| Request 55 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD email_date datetime after email_msgid;' |
| Request 56 sql='ALTER TABLE llx_ticket ADD COLUMN ip varchar(250);' |
| Request 57 sql='ALTER TABLE llx_ticket ADD email_date datetime after email_msgid;' |
| Request 58 sql='ALTER TABLE llx_ticket MODIFY COLUMN message mediumtext;' |
| Request 59 sql='ALTER TABLE llx_cronjob ADD COLUMN pid integer;' |
| Request 60 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-VICTORYDAY', 0, 2, '', 0, 5, 8, 1);' |
| Request 61 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-NATIONALDAY', 0, 2, '', 0, 7, 21, 1);' |
| Request 62 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-ASSOMPTION', 0, 2, '', 0, 8, 15, 1);' |
| Request 63 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-TOUSSAINT', 0, 2, '', 0, 11, 1, 1);' |
| Request 64 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-ARMISTICE', 0, 2, '', 0, 11, 11, 1);' |
| Request 65 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-EASTER', 0, 2, 'eastermonday', 0, 0, 0, 1);' |
| Request 66 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-ASCENSION', 0, 2, 'ascension', 0, 0, 0, 1);' |
| Request 67 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('BE-PENTECOST', 0, 2, 'pentecost', 0, 0, 0, 1);' |
| Request 68 sql='ALTER TABLE llx_societe_rib ADD COLUMN state_id integer AFTER default_rib;' |
| Request 69 sql='ALTER TABLE llx_societe_rib ADD COLUMN fk_country integer AFTER state_id;' |
| Request 70 sql='ALTER TABLE llx_societe_rib ADD COLUMN currency_code varchar(3) AFTER fk_country;' |
| Request 71 sql='DELETE FROM llx_societe_rib WHERE fk_soc = 0;' |
| Request 72 sql='ALTER TABLE llx_societe_rib ADD CONSTRAINT llx_societe_rib_fk_societe FOREIGN KEY (fk_soc) REFERENCES llx_societe(rowid);' |
| Request 73 sql='ALTER TABLE llx_user_rib ADD COLUMN state_id integer AFTER owner_address;' |
| Request 74 sql='ALTER TABLE llx_user_rib ADD COLUMN fk_country integer AFTER state_id;' |
| Request 75 sql='ALTER TABLE llx_user_rib ADD COLUMN currency_code varchar(3) AFTER fk_country;' |
| Request 76 sql='CREATE TABLE llx_bank_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 77 sql='ALTER TABLE llx_bank_extrafields ADD INDEX idx_bank_extrafields (fk_object);' |
| Request 78 sql='ALTER TABLE llx_product_lot ADD COLUMN note_public text DEFAULT NULL after batch;' |
| Request 79 sql='ALTER TABLE llx_product_lot ADD COLUMN note_private text DEFAULT NULL after note_public;' |
| Request 80 sql='ALTER TABLE llx_user CHANGE COLUMN note note_private text;' |
| Request 81 sql='UPDATE llx_c_effectif SET code='EF101-500', libelle='101 - 500' WHERE code='EF100-500';' |
| Request 82 sql='ALTER TABLE llx_product ADD COLUMN fk_default_workstation integer DEFAULT NULL;' |
| Request 83 sql='ALTER TABLE llx_bom_bomline ADD COLUMN fk_unit integer DEFAULT NULL;' |
| Request 84 sql='ALTER TABLE llx_rights_def ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 85 sql='UPDATE llx_establishment SET name='' WHERE name IS NULL;' |
| Request 86 sql='ALTER TABLE llx_establishment CHANGE name label varchar(255) NOT NULL;' |
| Request 87 sql='ALTER TABLE llx_don ADD UNIQUE INDEX idx_don_uk_ref (ref, entity);' |
| Request 88 sql='ALTER TABLE llx_don ADD INDEX idx_don_fk_soc (fk_soc);' |
| Request 89 sql='ALTER TABLE llx_don ADD INDEX idx_don_fk_project (fk_projet);' |
| Request 90 sql='ALTER TABLE llx_don ADD INDEX idx_don_fk_user_author (fk_user_author);' |
| Request 91 sql='ALTER TABLE llx_don ADD INDEX idx_don_fk_user_valid (fk_user_valid);' |
| Request 92 sql='ALTER TABLE llx_commande ADD COLUMN revenuestamp double(24,8) DEFAULT 0 after localtax2;' |
| Request 93 sql='create table llx_element_categorie ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_categorie integer NOT NULL, fk_element integer NOT NULL, import_key varchar(14) )ENGINE=innodb;' |
| Request 94 sql='ALTER TABLE llx_element_categorie ADD UNIQUE INDEX idx_element_categorie_idx (fk_element, fk_categorie);' |
| Request 95 sql='ALTER TABLE llx_element_categorie ADD CONSTRAINT fk_element_categorie_fk_categorie FOREIGN KEY (fk_categorie) REFERENCES llx_categorie(rowid);' |
| Request 96 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('PROJECT_SENTBYMAIL','Project sent by mail','Executed when a project is sent by email','project',144);' |
| Request 97 sql='ALTER TABLE llx_socpeople ADD INDEX idx_socpeople_lastname (lastname);' |
| Request 98 sql='ALTER TABLE llx_societe ADD INDEX idx_societe_nom(nom);' |
| Request 99 sql='ALTER TABLE llx_extrafields MODIFY COLUMN fielddefault text;' |
| Request 100 sql='ALTER TABLE llx_bank_url ADD INDEX idx_bank_url_url_id (url_id);' |
| Request 101 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN multicurrency_code varchar(3) NULL;' |
| Request 102 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN multicurrency_tx double(24,8) NULL;' |
| Request 103 sql='ALTER TABLE llx_hrm_evaluationdet CHANGE COLUMN `rank` rankorder integer;' |
| Request 104 sql='ALTER TABLE llx_hrm_skillrank CHANGE COLUMN `rank` rankorder integer;' |
| Request 105 sql='UPDATE llx_const SET name = 'MAIN_LIST_HIDE_PUBLIC_NOTES' WHERE name = 'MAIN_LIST_ALLOW_PUBLIC_NOTES';' |
| Request 106 sql='UPDATE llx_const SET name = 'MAIN_LIST_HIDE_PRIVATE_NOTES' WHERE name = 'MAIN_LIST_ALLOW_PRIVATE_NOTES';' |
| Request 107 sql='ALTER TABLE llx_projet ADD COLUMN date_start_event datetime;' |
| Request 108 sql='ALTER TABLE llx_projet ADD COLUMN date_end_event datetime;' |
| Request 109 sql='ALTER TABLE llx_projet ADD COLUMN location varchar(255);' |
| Request 110 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN code varchar(128);' |
| Request 111 sql='ALTER TABLE llx_overwrite_trans DROP INDEX uk_overwrite_trans;' |
| Request 112 sql='ALTER TABLE llx_overwrite_trans ADD UNIQUE INDEX uk_overwrite_trans(entity, lang, transkey);' |
| Request 113 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('COMPANY_CREATE','Third party created','Executed when a third party is created','societe',1);' |
| Request 114 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('COMPANY_MODIFY','Third party update','Executed when you update third party','societe',1);' |
| Request 115 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('COMPANY_SENTBYMAIL','Mails sent from third party card','Executed when you send email from third party card','societe',1);' |
| Request 116 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('COMPANY_DELETE','Third party deleted','Executed when you delete third party','societe',1);' |
| Request 117 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_VALIDATE','Customer proposal validated','Executed when a commercial proposal is validated','propal',2);' |
| Request 118 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_MODIFY','Customer proposal modified','Executed when a customer proposal is modified','propal',2);' |
| Request 119 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_SENTBYMAIL','Commercial proposal sent by mail','Executed when a commercial proposal is sent by mail','propal',3);' |
| Request 120 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_CLOSE_SIGNED','Customer proposal closed signed','Executed when a customer proposal is closed signed','propal',2);' |
| Request 121 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_CLOSE_REFUSED','Customer proposal closed refused','Executed when a customer proposal is closed refused','propal',2);' |
| Request 122 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_CLASSIFY_BILLED','Customer proposal set billed','Executed when a customer proposal is set to billed','propal',2);' |
| Request 123 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_DELETE','Customer proposal deleted','Executed when a customer proposal is deleted','propal',2);' |
| Request 124 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_VALIDATE','Customer order validate','Executed when a customer order is validated','commande',4);' |
| Request 125 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_CLOSE','Customer order classify delivered','Executed when a customer order is set delivered','commande',5);' |
| Request 126 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_MODIFY','Customer order modified','Executed when a customer order is set modified','commande',5);' |
| Request 127 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_CLASSIFY_BILLED','Customer order classify billed','Executed when a customer order is set to billed','commande',5);' |
| Request 128 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_CANCEL','Customer order canceled','Executed when a customer order is canceled','commande',5);' |
| Request 129 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SENTBYMAIL','Customer order sent by mail','Executed when a customer order is sent by mail ','commande',5);' |
| Request 130 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_DELETE','Customer order deleted','Executed when a customer order is deleted','commande',5);' |
| Request 131 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_VALIDATE','Customer invoice validated','Executed when a customer invoice is approved','facture',6);' |
| Request 132 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_MODIFY','Customer invoice modified','Executed when a customer invoice is modified','facture',7);' |
| Request 133 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_PAYED','Customer invoice payed','Executed when a customer invoice is payed','facture',7);' |
| Request 134 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_CANCEL','Customer invoice canceled','Executed when a customer invoice is conceled','facture',8);' |
| Request 135 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SENTBYMAIL','Customer invoice sent by mail','Executed when a customer invoice is sent by mail','facture',9);' |
| Request 136 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_UNVALIDATE','Customer invoice unvalidated','Executed when a customer invoice status set back to draft','facture',9);' |
| Request 137 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_DELETE','Customer invoice deleted','Executed when a customer invoice is deleted','facture',9);' |
| Request 138 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_VALIDATE','Price request validated','Executed when a commercial proposal is validated','proposal_supplier',10);' |
| Request 139 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_MODIFY','Price request modified','Executed when a commercial proposal is modified','proposal_supplier',10);' |
| Request 140 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_SENTBYMAIL','Price request sent by mail','Executed when a commercial proposal is sent by mail','proposal_supplier',10);' |
| Request 141 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_CLOSE_SIGNED','Price request closed signed','Executed when a customer proposal is closed signed','proposal_supplier',10);' |
| Request 142 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_CLOSE_REFUSED','Price request closed refused','Executed when a customer proposal is closed refused','proposal_supplier',10);' |
| Request 143 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_DELETE','Price request deleted','Executed when a customer proposal delete','proposal_supplier',10);' |
| Request 144 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_VALIDATE','Supplier order validated','Executed when a supplier order is validated','order_supplier',12);' |
| Request 145 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_APPROVE','Supplier order request approved','Executed when a supplier order is approved','order_supplier',13);' |
| Request 146 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_MODIFY','Supplier order request modified','Executed when a supplier order is modified','order_supplier',13);' |
| Request 147 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_SUBMIT','Supplier order request submited','Executed when a supplier order is approved','order_supplier',13);' |
| Request 148 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_RECEIVE','Supplier order request received','Executed when a supplier order is received','order_supplier',13);' |
| Request 149 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_REFUSE','Supplier order request refused','Executed when a supplier order is refused','order_supplier',13);' |
| Request 150 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 151 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_SENTBYMAIL','Supplier order sent by mail','Executed when a supplier order is sent by mail','order_supplier',14);' |
| Request 152 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_CLASSIFY_BILLED','Supplier order set billed','Executed when a supplier order is set as billed','order_supplier',14);' |
| Request 153 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_DELETE','Supplier order deleted','Executed when a supplier order is deleted','order_supplier',14);' |
| Request 154 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_VALIDATE','Supplier invoice validated','Executed when a supplier invoice is validated','invoice_supplier',15);' |
| Request 155 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_MODIFY','Supplier invoice modified','Executed when a supplier invoice is modified','invoice_supplier',15);' |
| Request 156 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_UNVALIDATE','Supplier invoice unvalidated','Executed when a supplier invoice status is set back to draft','invoice_supplier',15);' |
| Request 157 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_PAYED','Supplier invoice payed','Executed when a supplier invoice is payed','invoice_supplier',16);' |
| Request 158 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_SENTBYMAIL','Supplier invoice sent by mail','Executed when a supplier invoice is sent by mail','invoice_supplier',17);' |
| Request 159 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_CANCELED','Supplier invoice cancelled','Executed when a supplier invoice is cancelled','invoice_supplier',17);' |
| Request 160 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_DELETE','Supplier invoice deleted','Executed when a supplier invoice is deleted','invoice_supplier',17);' |
| Request 161 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_VALIDATE','Contract validated','Executed when a contract is validated','contrat',18);' |
| Request 162 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_MODIFY','Contract modified','Executed when a contract is modified','contrat',18);' |
| Request 163 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_SENTBYMAIL','Contract sent by mail','Executed when a contract is sent by mail','contrat',18);' |
| Request 164 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_DELETE','Contract deleted','Executed when a contract is deleted','contrat',18);' |
| Request 165 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('SHIPPING_VALIDATE','Shipping validated','Executed when a shipping is validated','shipping',20);' |
| Request 166 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('SHIPPING_MODIFY','Shipping modified','Executed when a shipping is modified','shipping',20);' |
| Request 167 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('SHIPPING_SENTBYMAIL','Shipping sent by mail','Executed when a shipping is sent by mail','shipping',21);' |
| Request 168 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('SHIPPING_DELETE','Shipping sent is deleted','Executed when a shipping is deleted','shipping',21);' |
| Request 169 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECEPTION_VALIDATE','Reception validated','Executed when a reception is validated','reception',22);' |
| Request 170 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECEPTION_SENTBYMAIL','Reception sent by mail','Executed when a reception is sent by mail','reception',22);' |
| Request 171 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_VALIDATE','Member validated','Executed when a member is validated','member',22);' |
| Request 172 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_MODIFY','Member modified','Executed when a member is modified','member',23);' |
| Request 173 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SENTBYMAIL','Mails sent from member card','Executed when you send email from member card','member',23);' |
| Request 174 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SUBSCRIPTION_CREATE','Member subscribtion recorded','Executed when a member subscribtion is deleted','member',24);' |
| Request 175 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SUBSCRIPTION_MODIFY','Member subscribtion modified','Executed when a member subscribtion is modified','member',24);' |
| Request 176 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SUBSCRIPTION_DELETE','Member subscribtion deleted','Executed when a member subscribtion is deleted','member',24);' |
| Request 177 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_RESILIATE','Member resiliated','Executed when a member is resiliated','member',25);' |
| Request 178 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_DELETE','Member deleted','Executed when a member is deleted','member',26);' |
| Request 179 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 180 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_VALIDATE','Intervention validated','Executed when a intervention is validated','ficheinter',30);' |
| Request 181 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_MODIFY','Intervention modify','Executed when a intervention is modify','ficheinter',30);' |
| Request 182 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_CLASSIFY_BILLED','Intervention set billed','Executed when a intervention is set to billed (when option FICHINTER_CLASSIFY_BILLED is set)','ficheinter',32);' |
| Request 183 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_CLASSIFY_UNBILLED','Intervention set unbilled','Executed when a intervention is set to unbilled (when option FICHINTER_CLASSIFY_BILLED is set)','ficheinter',33);' |
| Request 184 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_REOPEN','Intervention opened','Executed when a intervention is re-opened','ficheinter',34);' |
| Request 185 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_SENTBYMAIL','Intervention sent by mail','Executed when a intervention is sent by mail','ficheinter',35);' |
| Request 186 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_DELETE','Intervention is deleted','Executed when a intervention is deleted','ficheinter',35);' |
| Request 187 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PRODUCT_CREATE','Product or service created','Executed when a product or sevice is created','product',40);' |
| Request 188 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PRODUCT_MODIFY','Product or service modified','Executed when a product or sevice is modified','product',41);' |
| Request 189 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PRODUCT_DELETE','Product or service deleted','Executed when a product or sevice is deleted','product',42);' |
| Request 190 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_CREATE','Expense report created','Executed when an expense report is created','expensereport',201);' |
| Request 191 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_VALIDATE','Expense report validated','Executed when an expense report is validated','expensereport',202);' |
| Request 192 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_MODIFY','Expense report modified','Executed when an expense report is modified','expensereport',202);' |
| Request 193 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_APPROVE','Expense report approved','Executed when an expense report is approved','expensereport',203);' |
| Request 194 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_PAID','Expense report billed','Executed when an expense report is set as billed','expensereport',204);' |
| Request 195 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_DELETE','Expense report deleted','Executed when an expense report is deleted','expensereport',205);' |
| Request 196 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Expense report validated','Executed when an expense report is validated','expensereport',211);' |
| Request 197 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_MODIFY','Expense report modified','Executed when an expense report is modified','expensereport',212);' |
| Request 198 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE','Expense report approved','Executed when an expense report is approved','expensereport',212);' |
| Request 199 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_CREATE','Project creation','Executed when a project is created','project',140);' |
| Request 200 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_VALIDATE','Project validation','Executed when a project is validated','project',141);' |
| Request 201 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_MODIFY','Project modified','Executed when a project is modified','project',142);' |
| Request 202 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_DELETE','Project deleted','Executed when a project is deleted','project',143);' |
| Request 203 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROJECT_SENTBYMAIL','Project sent by mail','Executed when a project is sent by email','project',144);' |
| Request 204 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_CREATE','Ticket created','Executed when a ticket is created','ticket',161);' |
| Request 205 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_MODIFY','Ticket modified','Executed when a ticket is modified','ticket',163);' |
| Request 206 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_ASSIGNED','Ticket assigned','Executed when a ticket is modified','ticket',164);' |
| Request 207 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_CLOSE','Ticket closed','Executed when a ticket is closed','ticket',165);' |
| Request 208 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_SENTBYMAIL','Ticket message sent by email','Executed when a message is sent from the ticket record','ticket',166);' |
| Request 209 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TICKET_DELETE','Ticket deleted','Executed when a ticket is deleted','ticket',167);' |
| Request 210 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 211 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 212 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 213 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 214 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 215 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 216 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_MODIFY','Intervention modified','Executed when a intervention is modified','ficheinter',19);' |
| Request 217 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 218 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 219 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 220 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 221 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 222 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_VALIDATE','MO validated','Executed when a MO is validated','mrp',660);' |
| Request 223 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_PRODUCED','MO produced','Executed when a MO is produced','mrp',661);' |
| Request 224 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_DELETE','MO deleted','Executed when a MO is deleted','mrp',662);' |
| Request 225 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_CANCEL','MO canceled','Executed when a MO is canceled','mrp',663);' |
| Request 226 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTACT_CREATE','Contact address created','Executed when a contact is created','contact',50);' |
| Request 227 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTACT_MODIFY','Contact address update','Executed when a contact is updated','contact',51);' |
| Request 228 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTACT_SENTBYMAIL','Mails sent from third party card','Executed when you send email from contact address record','contact',52);' |
| Request 229 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTACT_DELETE','Contact address deleted','Executed when a contact is deleted','contact',53);' |
| Request 230 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTJOBPOSITION_CREATE','Job created','Executed when a job is created','recruitment',7500);' |
| Request 231 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTJOBPOSITION_MODIFY','Job modified','Executed when a job is modified','recruitment',7502);' |
| Request 232 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTJOBPOSITION_SENTBYMAIL','Mails sent from job record','Executed when you send email from job record','recruitment',7504);' |
| Request 233 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTJOBPOSITION_DELETE','Job deleted','Executed when a job is deleted','recruitment',7506);' |
| Request 234 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTCANDIDATURE_CREATE','Candidature created','Executed when a candidature is created','recruitment',7510);' |
| Request 235 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTCANDIDATURE_MODIFY','Candidature modified','Executed when a candidature is modified','recruitment',7512);' |
| Request 236 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTCANDIDATURE_SENTBYMAIL','Mails sent from candidature record','Executed when you send email from candidature record','recruitment',7514);' |
| Request 237 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('RECRUITMENTCANDIDATURE_DELETE','Candidature deleted','Executed when a candidature is deleted','recruitment',7516);' |
| Request 238 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TASK_CREATE','Task created','Executed when a project task is created','project',150);' |
| Request 239 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TASK_MODIFY','Task modified','Executed when a project task is modified','project',151);' |
| Request 240 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('TASK_DELETE','Task deleted','Executed when a project task is deleted','project',152);' |
| Request 241 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ACTION_CREATE','Action added','Executed when an action is added to the agenda','agenda',700);' |
| Request 242 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 243 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 244 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 245 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 246 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 247 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 248 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILLREC_CREATE','Template invoices created','Executed when a Template invoices is created','facturerec',900);' |
| Request 249 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILLREC_MODIFY','Template invoices update','Executed when a Template invoices is updated','facturerec',901);' |
| Request 250 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILLREC_DELETE','Template invoices deleted','Executed when a Template invoices is deleted','facturerec',902);' |
| Request 251 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILLREC_AUTOCREATEBILL','Template invoices use to create invoices with auto batch','Executed when a Template invoices is use to create invoice with auto batch','facturerec',903);' |
| Request 252 sql='ALTER TABLE llx_prelevement_facture RENAME TO llx_prelevement;' |
| Request 253 sql='ALTER TABLE llx_prelevement_facture_demande RENAME TO llx_prelevement_demande;' |
| Request 254 sql='ALTER TABLE llx_prelevement ADD COLUMN fk_salary INTEGER NULL AFTER fk_facture_fourn;' |
| Request 255 sql='ALTER TABLE llx_prelevement_demande ADD COLUMN fk_salary INTEGER NULL AFTER fk_facture_fourn;' |
| Request 256 sql='ALTER TABLE llx_user ADD COLUMN birth_place varchar(64);' |
| Request 257 sql='ALTER TABLE llx_opensurvey_user_studs ADD COLUMN date_creation datetime NULL;' |
| Request 258 sql='ALTER TABLE llx_opensurvey_comments ADD COLUMN date_creation datetime NULL;' |
| Request 259 sql='ALTER TABLE llx_c_tva ADD COLUMN use_default tinyint DEFAULT 0;' |
| Request 260 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN ref varchar(128);' |
| Request 261 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN ref varchar(128);' |
| Request 262 sql='ALTER TABLE llx_projet ADD COLUMN extraparams varchar(255);' |
| Request 263 sql='DELETE FROM llx_const WHERE name = 'TICKET_CREATE_THIRD_PARTY_WITH_CONTACT_IF_NOT_EXIST';' |
| Script processing | OK - Show-Hide details |
|
|
