|
| Choose migration script | 12.0.0-13.0.0.sql |
| Request 1 sql='ALTER TABLE llx_payment_salary MODIFY COLUMN ref varchar(30) NULL;' |
| Request 2 sql='ALTER TABLE llx_payment_various MODIFY COLUMN ref varchar(30) NULL;' |
| Request 3 sql='ALTER TABLE llx_prelevement_bons ADD COLUMN type varchar(16) DEFAULT 'debit-order';' |
| Request 4 sql='ALTER TABLE llx_prelevement_facture CHANGE COLUMN fk_facture_foun fk_facture_fourn integer NULL;' |
| Request 5 sql='ALTER TABLE llx_prelevement_facture_demande ADD COLUMN fk_facture_fourn INTEGER NULL;' |
| Request 6 sql='ALTER TABLE llx_prelevement_facture_demande ADD INDEX idx_prelevement_facture_demande_fk_facture (fk_facture);' |
| Request 7 sql='ALTER TABLE llx_prelevement_facture_demande ADD INDEX idx_prelevement_facture_demande_fk_facture_fourn (fk_facture_fourn);' |
| Request 8 sql='ALTER TABLE llx_document_model MODIFY COLUMN type varchar(64);' |
| Request 9 sql='ALTER TABLE llx_bom_bom MODIFY COLUMN duration double(24,8);' |
| Request 10 sql='ALTER TABLE llx_bom_bom_extrafields ADD INDEX idx_bom_bom_extrafields_fk_object (fk_object);' |
| Request 11 sql='create table llx_mrp_mo_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 12 sql='ALTER TABLE llx_mrp_mo_extrafields DROP INDEX idx_fk_object;' |
| Request 13 sql='ALTER TABLE llx_mrp_mo_extrafields ADD INDEX idx_mrp_mo_fk_object(fk_object);' |
| Request 14 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (111,11, '0','0','No Sales Tax',1);' |
| Request 15 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (112,11, '4','0','Sales Tax 4%',1);' |
| Request 16 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,note,active) values (113,11, '6','0','Sales Tax 6%',1);' |
| Request 17 sql='ALTER TABLE llx_bom_bom ADD COLUMN bomtype integer DEFAULT 0;' |
| Request 18 sql='UPDATE llx_emailcollector_emailcollector SET ref = 'Collect_Ticket_Requests' WHERE ref = 'Collect_Ticket_Requets';' |
| Request 19 sql='UPDATE llx_emailcollector_emailcollector SET ref = 'Collect_Responses_In' WHERE ref = 'Collect_Responses';' |
| Request 20 sql='UPDATE llx_document_model set nom = 'standard' where nom = 'Standard' and type ='stock';' |
| Request 21 sql='UPDATE llx_document_model set nom = 'stdmovement', type = 'movement' where nom = 'StdMouvement' and type ='mouvement';' |
| Request 22 sql='UPDATE llx_const SET value = 0 WHERE name = 'FACTURE_TVAOPTION' and value = 'franchise';' |
| Request 23 sql='UPDATE llx_const SET value = 1 WHERE name = 'FACTURE_TVAOPTION' and value <> 'franchise' AND value <> '0' AND value <> '1';' |
| Request 24 sql='ALTER TABLE llx_commande MODIFY COLUMN date_livraison DATETIME;' |
| Request 25 sql='ALTER TABLE llx_website ADD COLUMN position integer DEFAULT 0;' |
| Request 26 sql='ALTER TABLE llx_establishment ADD COLUMN ref varchar(30);' |
| Request 27 sql='ALTER TABLE llx_establishment ADD COLUMN label varchar(128);' |
| Request 28 sql='UPDATE llx_establishment SET ref = rowid WHERE ref IS NULL;' |
| Request 29 sql='ALTER TABLE llx_establishment MODIFY COLUMN ref varchar(30) NOT NULL;' |
| Request 30 sql='ALTER TABLE llx_establishment MODIFY COLUMN label varchar(128);' |
| Request 31 sql='INSERT INTO llx_const (name, entity, value, type, visible) VALUES ('PRODUCT_PRICE_BASE_TYPE', 0, 'HT', 'string', 0);' |
| Request 32 sql='ALTER TABLE llx_subscription MODIFY COLUMN datef DATETIME;' |
| Request 33 sql='ALTER TABLE llx_loan_schedule ADD column fk_payment_loan INTEGER;' |
| Request 34 sql='ALTER TABLE llx_user DROP COLUMN jabberid;' |
| Request 35 sql='ALTER TABLE llx_user DROP COLUMN skype;' |
| Request 36 sql='ALTER TABLE llx_user DROP COLUMN twitter;' |
| Request 37 sql='ALTER TABLE llx_user DROP COLUMN facebook;' |
| Request 38 sql='ALTER TABLE llx_user DROP COLUMN linkedin;' |
| Request 39 sql='ALTER TABLE llx_user DROP COLUMN instagram;' |
| Request 40 sql='ALTER TABLE llx_user DROP COLUMN snapchat;' |
| Request 41 sql='ALTER TABLE llx_user DROP COLUMN googleplus;' |
| Request 42 sql='ALTER TABLE llx_user DROP COLUMN youtube;' |
| Request 43 sql='ALTER TABLE llx_user DROP COLUMN whatsapp;' |
| Request 44 sql='ALTER TABLE llx_user ADD COLUMN datelastpassvalidation datetime;' |
| Request 45 sql='ALTER TABLE llx_user ADD COLUMN datestartvalidity datetime;' |
| Request 46 sql='ALTER TABLE llx_user ADD COLUMN dateendvalidity datetime;' |
| Request 47 sql='ALTER TABLE llx_user ADD COLUMN idpers1 varchar(128);' |
| Request 48 sql='ALTER TABLE llx_user ADD COLUMN idpers2 varchar(128);' |
| Request 49 sql='ALTER TABLE llx_user ADD COLUMN idpers3 varchar(128);' |
| Request 50 sql='CREATE TABLE llx_c_transport_mode ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, code varchar(3) NOT NULL, label varchar(255) NOT NULL, active tinyint DEFAULT 1 NOT NULL ) ENGINE=innodb;' |
| Request 51 sql='ALTER TABLE llx_c_transport_mode ADD UNIQUE INDEX uk_c_transport_mode (code, entity);' |
| Request 52 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('MAR', 'Transport maritime (y compris camions ou wagons sur bateau)', 1);' |
| Request 53 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('TRA', 'Transport par chemin de fer (y compris camions sur wagon)', 1);' |
| Request 54 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('ROU', 'Transport par route', 1);' |
| Request 55 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('AIR', 'Transport par air', 1);' |
| Request 56 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('POS', 'Envois postaux', 1);' |
| Request 57 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('OLE', 'Installations de transport fixe (oléoduc)', 1);' |
| Request 58 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('NAV', 'Transport par navigation intérieure', 1);' |
| Request 59 sql='INSERT INTO llx_c_transport_mode (code, label, active) VALUES ('PRO', 'Propulsion propre', 1);' |
| Request 60 sql='ALTER TABLE llx_facture ADD COLUMN fk_transport_mode integer after location_incoterms;' |
| Request 61 sql='ALTER TABLE llx_facture_fourn ADD COLUMN fk_transport_mode integer after location_incoterms;' |
| Request 62 sql='ALTER TABLE llx_societe ADD COLUMN transport_mode tinyint after cond_reglement;' |
| Request 63 sql='ALTER TABLE llx_societe ADD COLUMN transport_mode_supplier tinyint after cond_reglement_supplier;' |
| Request 64 sql='CREATE TABLE llx_intracommreport ( rowid integer AUTO_INCREMENT PRIMARY KEY, ref varchar(30) NOT NULL, entity integer DEFAULT 1 NOT NULL, type_declaration varchar(32), periods varchar(32), mode varchar(32), content_xml text, type_export varchar(10), datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP )ENGINE=innodb;' |
| Request 65 sql='ALTER TABLE llx_c_incoterms ADD COLUMN label varchar(100) NULL;' |
| Request 66 sql='CREATE TABLE llx_recruitment_recruitmentjobposition( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, ref varchar(128) DEFAULT '(PROV)' NOT NULL, entity INTEGER DEFAULT 1 NOT NULL, label varchar(255) NOT NULL, qty integer DEFAULT 1 NOT NULL, fk_soc integer, fk_project integer, fk_user_recruiter integer, fk_user_supervisor integer, fk_establishment integer, date_planned date, remuneration_suggested 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, last_main_doc varchar(255), import_key varchar(14), model_pdf varchar(255), status smallint NOT NULL ) ENGINE=innodb;' |
| Request 67 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD INDEX idx_recruitment_recruitmentjobposition_rowid (rowid);' |
| Request 68 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD INDEX idx_recruitment_recruitmentjobposition_ref (ref);' |
| Request 69 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD INDEX idx_recruitment_recruitmentjobposition_fk_soc (fk_soc);' |
| Request 70 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD INDEX idx_recruitment_recruitmentjobposition_fk_project (fk_project);' |
| Request 71 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD CONSTRAINT llx_recruitment_recruitmentjobposition_fk_user_recruiter FOREIGN KEY (fk_user_recruiter) REFERENCES llx_user(rowid);' |
| Request 72 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD CONSTRAINT llx_recruitment_recruitmentjobposition_fk_user_supervisor FOREIGN KEY (fk_user_supervisor) REFERENCES llx_user(rowid);' |
| Request 73 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD CONSTRAINT llx_recruitment_recruitmentjobposition_fk_establishment FOREIGN KEY (fk_establishment) REFERENCES llx_establishment(rowid);' |
| Request 74 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD CONSTRAINT llx_recruitment_recruitmentjobposition_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);' |
| Request 75 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD INDEX idx_recruitment_recruitmentjobposition_status (status);' |
| Request 76 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD COLUMN email_recruiter varchar(255);' |
| Request 77 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD COLUMN entity INTEGER DEFAULT 1 NOT NULL;' |
| Request 78 sql='ALTER TABLE llx_recruitment_recruitmentjobposition ADD COLUMN remuneration_suggested varchar(255);' |
| Request 79 sql='create table llx_recruitment_recruitmentjobposition_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 80 sql='ALTER TABLE llx_recruitment_recruitmentjobposition_extrafields ADD INDEX idx_recruitmentjobposition_fk_object(fk_object);' |
| Request 81 sql='CREATE TABLE llx_recruitment_recruitmentcandidature( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, entity integer NOT NULL DEFAULT 1, fk_recruitmentjobposition INTEGER NULL, ref varchar(128) DEFAULT '(PROV)' NOT NULL, 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), model_pdf varchar(255), status smallint NOT NULL, firstname varchar(128), lastname varchar(128), email varchar(255), phone varchar(64), date_birth date, remuneration_requested integer, remuneration_proposed integer, email_msgid varchar(255), fk_recruitment_origin INTEGER NULL ) ENGINE=innodb;' |
| Request 82 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD COLUMN entity integer NOT NULL DEFAULT 1;' |
| Request 83 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD COLUMN email_msgid varchar(255);' |
| Request 84 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD COLUMN fk_recruitment_origin INTEGER NULL;' |
| Request 85 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD COLUMN date_birth date;' |
| Request 86 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD INDEX idx_recruitment_recruitmentcandidature_rowid (rowid);' |
| Request 87 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD INDEX idx_recruitment_recruitmentcandidature_ref (ref);' |
| Request 88 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD CONSTRAINT llx_recruitment_recruitmentcandidature_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);' |
| Request 89 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD INDEX idx_recruitment_recruitmentcandidature_status (status);' |
| Request 90 sql='create table llx_recruitment_recruitmentcandidature_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 91 sql='ALTER TABLE llx_recruitment_recruitmentcandidature_extrafields ADD INDEX idx_recruitmentcandidature_fk_object(fk_object);' |
| Request 92 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD UNIQUE INDEX uk_recruitmentcandidature_email_msgid(email_msgid);' |
| Request 93 sql='ALTER TABLE llx_product_attribute ADD COLUMN ref_ext VARCHAR(255) after ref;' |
| Request 94 sql='ALTER TABLE llx_product_attribute_combination ADD COLUMN variation_ref_ext varchar(255) AFTER variation_weight;' |
| Request 95 sql='CREATE TABLE llx_product_attribute_combination_price_level ( rowid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, fk_product_attribute_combination INTEGER DEFAULT 1 NOT NULL, fk_price_level INTEGER DEFAULT 1 NOT NULL, variation_price DOUBLE(24,8) NOT NULL, variation_price_percentage INTEGER NULL )ENGINE=innodb;' |
| Request 96 sql='ALTER TABLE llx_product_attribute_combination_price_level ADD UNIQUE( fk_product_attribute_combination, fk_price_level);' |
Error DB_ERROR_1069: ALTER TABLE llx_product_attribute_combination_price_level ADD UNIQUE( fk_product_attribute_combination, fk_price_level);
Too many keys specified; max 64 keys allowed |
| Request 97 sql='create table llx_c_prospectcontactlevel ( code varchar(12) PRIMARY KEY, label varchar(30), sortorder smallint, active smallint DEFAULT 1 NOT NULL, module varchar(32) NULL ) ENGINE=innodb;' |
| Request 98 sql='insert into llx_c_prospectcontactlevel (code,label,sortorder) values ('PL_NONE', 'None', 1);' |
| Request 99 sql='insert into llx_c_prospectcontactlevel (code,label,sortorder) values ('PL_LOW', 'Low', 2);' |
| Request 100 sql='insert into llx_c_prospectcontactlevel (code,label,sortorder) values ('PL_MEDIUM', 'Medium', 3);' |
| Request 101 sql='insert into llx_c_prospectcontactlevel (code,label,sortorder) values ('PL_HIGH', 'High', 4);' |
| Request 102 sql='create table llx_c_stcommcontact ( id integer PRIMARY KEY, code varchar(12) NOT NULL, libelle varchar(30), picto varchar(128), active tinyint default 1 NOT NULL )ENGINE=innodb;' |
| Request 103 sql='ALTER TABLE llx_c_stcommcontact ADD UNIQUE INDEX uk_c_stcommcontact(code);' |
| Request 104 sql='insert into llx_c_stcommcontact (id,code,libelle) values (-1, 'ST_NO', 'Do not contact');' |
| Request 105 sql='insert into llx_c_stcommcontact (id,code,libelle) values ( 0, 'ST_NEVER', 'Never contacted');' |
| Request 106 sql='insert into llx_c_stcommcontact (id,code,libelle) values ( 1, 'ST_TODO', 'To contact');' |
| Request 107 sql='insert into llx_c_stcommcontact (id,code,libelle) values ( 2, 'ST_PEND', 'Contact in progress');' |
| Request 108 sql='insert into llx_c_stcommcontact (id,code,libelle) values ( 3, 'ST_DONE', 'Contacted');' |
| Request 109 sql='ALTER TABLE llx_socpeople ADD COLUMN fk_prospectcontactlevel varchar(12) AFTER priv;' |
| Request 110 sql='ALTER TABLE llx_socpeople ADD COLUMN fk_stcommcontact integer DEFAULT 0 NOT NULL AFTER fk_prospectcontactlevel;' |
| Request 111 sql='create table llx_c_recruitment_origin ( rowid integer AUTO_INCREMENT PRIMARY KEY, code varchar(32) NOT NULL, label varchar(64) NOT NULL, active tinyint DEFAULT 1 NOT NULL )ENGINE=innodb;' |
| Request 112 sql='ALTER TABLE llx_recruitment_recruitmentcandidature ADD UNIQUE INDEX uk_recruitmentcandidature_email_msgid(email_msgid);' |
| Request 113 sql='ALTER TABLE llx_product MODIFY COLUMN seuil_stock_alerte float;' |
| Request 114 sql='ALTER TABLE llx_product MODIFY COLUMN desiredstock float;' |
| Request 115 sql='ALTER TABLE llx_product_warehouse_properties MODIFY COLUMN seuil_stock_alerte float;' |
| Request 116 sql='ALTER TABLE llx_product_warehouse_properties MODIFY COLUMN desiredstock float;' |
| Request 117 sql='ALTER TABLE llx_product ADD COLUMN fk_state integer DEFAULT NULL AFTER fk_country;' |
| Request 118 sql='ALTER TABLE llx_projet ADD COLUMN email_msgid varchar(255);' |
| Request 119 sql='ALTER TABLE llx_ticket ADD COLUMN email_msgid varchar(255);' |
| Request 120 sql='ALTER TABLE llx_actioncomm ADD COLUMN reply_to varchar(255);' |
| Request 121 sql='ALTER TABLE llx_paiement ADD pos_change DOUBLE(24,8) DEFAULT 0 AFTER fk_export_compta;' |
| Request 122 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 123 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 adress card','contact',51);' |
| Request 124 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',52);' |
| Request 125 sql='ALTER TABLE llx_opensurvey_sondage CHANGE COLUMN tms tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 126 sql='ALTER TABLE llx_ecm_directories CHANGE COLUMN date_m tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 127 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN date_m tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 128 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'recruitment','recruitmentcandidature_send','',0,null,null,'(AnswerCandidature)' ,100,'$conf->recruitment->enabled',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourCandidature)__', '__(Hello)__ __CANDIDATE_FULLNAME__,<br><br>\n\n__(YourCandidatureAnswer)__<br>\n<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null, 0);' |
| Request 129 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN code varchar(64) NOT NULL;' |
| Request 130 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 131 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 132 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 133 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 134 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 135 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 136 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 137 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 138 sql='ALTER TABLE llx_actioncomm_reminder ADD COLUMN entity integer NOT NULL DEFAULT 1;' |
| Request 139 sql='ALTER TABLE llx_actioncomm_reminder ADD COLUMN fk_actioncomm integer NOT NULL;' |
| Request 140 sql='ALTER TABLE llx_actioncomm_reminder ADD COLUMN fk_email_template integer;' |
| Request 141 sql='ALTER TABLE llx_actioncomm_reminder ADD COLUMN lasterror varchar(128) NULL;' |
| Request 142 sql='ALTER TABLE llx_actioncomm_reminder DROP INDEX uk_actioncomm_reminder_unique;' |
| Request 143 sql='ALTER TABLE llx_actioncomm_reminder ADD UNIQUE uk_actioncomm_reminder_unique (fk_user, typeremind, offsetvalue, offsetunit, fk_actioncomm);' |
| Request 144 sql='ALTER TABLE llx_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_status (status);' |
| Request 145 sql='ALTER TABLE llx_inventorydet ADD COLUMN fk_warehouse integer DEFAULT 0;' |
| Request 146 sql='ALTER TABLE llx_inventorydet ADD UNIQUE uk_inventorydet(fk_inventory, fk_warehouse, fk_product, batch);' |
| Request 147 sql='ALTER TABLE llx_commandedet ADD COLUMN ref_ext varchar(255) AFTER label;' |
| Request 148 sql='ALTER TABLE llx_facturedet ADD COLUMN ref_ext varchar(255) AFTER multicurrency_total_ttc;' |
| Request 149 sql='ALTER TABLE llx_c_ticket_category ADD COLUMN fk_parent integer DEFAULT 0 NOT NULL;' |
| Request 150 sql='ALTER TABLE llx_c_ticket_category ADD COLUMN force_severity varchar(32) NULL;' |
| Request 151 sql='ALTER TABLE llx_c_ticket_severity CHANGE color color VARCHAR(10) NULL;' |
| Request 152 sql='ALTER TABLE llx_expensereport ADD COLUMN fk_user_creat integer NULL;' |
| Request 153 sql='ALTER TABLE llx_expensereport_ik ADD COLUMN ikoffset double DEFAULT 0 NOT NULL;' |
| Request 154 sql='ALTER TABLE llx_paiement ADD COLUMN ref_ext varchar(255) AFTER ref;' |
| Request 155 sql='ALTER TABLE llx_bank ADD COLUMN origin_id integer;' |
| Request 156 sql='ALTER TABLE llx_bank ADD COLUMN origin_type varchar(64) NULL;' |
| Request 157 sql='ALTER TABLE llx_bank ADD COLUMN import_key varchar(14);' |
| Request 158 sql='ALTER TABLE llx_menu MODIFY COLUMN enabled text;' |
| Request 159 sql='CREATE TABLE llx_ecm_files_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 160 sql='ALTER TABLE llx_ecm_files_extrafields ADD INDEX idx_ecm_files_extrafields (fk_object);' |
| Request 161 sql='ALTER TABLE llx_ecm_files ADD COLUMN note_private text AFTER fk_user_m;' |
| Request 162 sql='ALTER TABLE llx_ecm_files ADD COLUMN note_public text AFTER note_private;' |
| Request 163 sql='CREATE TABLE llx_ecm_directories_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 164 sql='ALTER TABLE llx_ecm_directories_extrafields ADD INDEX idx_ecm_directories_extrafields (fk_object);' |
| Request 165 sql='ALTER TABLE llx_ecm_directories ADD COLUMN note_private text AFTER fk_user_m;' |
| Request 166 sql='ALTER TABLE llx_ecm_directories ADD COLUMN note_public text AFTER note_private;' |
| Request 167 sql='ALTER TABLE llx_website_page ADD COLUMN allowed_in_frames integer DEFAULT 0;' |
| Request 168 sql='ALTER TABLE llx_website_page ADD COLUMN object_type varchar(255);' |
| Request 169 sql='ALTER TABLE llx_website_page ADD COLUMN fk_object varchar(255);' |
| Request 170 sql='DELETE FROM llx_const WHERE name in ('MAIN_INCLUDE_ZERO_VAT_IN_REPORTS');' |
| Request 171 sql='UPDATE llx_projet_task_time SET tms = null WHERE tms = 0;' |
| Request 172 sql='ALTER TABLE llx_projet_task_time CHANGE COLUMN tms tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 173 sql='ALTER TABLE llx_projet_task_time MODIFY COLUMN datec datetime;' |
| Request 174 sql='DELETE FROM llx_user_rights WHERE fk_id IN (SELECT id FROM llx_rights_def where module = 'holiday' and perms = 'lire_tous');' |
| Request 175 sql='DELETE FROM llx_rights_def where module = 'holiday' and perms = 'lire_tous';' |
| Request 176 sql='UPDATE llx_rights_def set perms = 'readall' WHERE perms = 'read_all' and module = 'holiday';' |
| Request 177 sql='CREATE TABLE llx_c_product_nature ( rowid integer AUTO_INCREMENT PRIMARY KEY, code tinyint NOT NULL, label varchar(100), active tinyint DEFAULT 1 NOT NULL ) ENGINE=innodb;' |
| Request 178 sql='ALTER TABLE llx_product DROP FOREIGN KEY fk_product_finished;' |
| Request 179 sql='DROP INDEX uk_c_product_nature on llx_c_product_nature;' |
| Request 180 sql='ALTER TABLE llx_c_product_nature ADD UNIQUE INDEX uk_c_product_nature(code);' |
| Request 181 sql='INSERT INTO llx_c_product_nature (code, label, active) VALUES (0, 'RowMaterial', 1);' |
| Request 182 sql='INSERT INTO llx_c_product_nature (code, label, active) VALUES (1, 'Finished', 1);' |
| Request 183 sql='ALTER TABLE llx_product MODIFY COLUMN finished tinyint DEFAULT NULL;' |
| Request 184 sql='ALTER TABLE llx_product ADD CONSTRAINT fk_product_finished FOREIGN KEY (finished) REFERENCES llx_c_product_nature (code);' |
Error DB_ERROR_1822: ALTER TABLE llx_product ADD CONSTRAINT fk_product_finished FOREIGN KEY (finished) REFERENCES llx_c_product_nature (code);
Failed to add the foreign key constraint. Missing index for constraint 'fk_product_finished' in the referenced table 'llx_c_product_nature' |
| Request 185 sql='ALTER TABLE llx_livraison DROP FOREIGN KEY fk_livraison_fk_soc;' |
| Request 186 sql='ALTER TABLE llx_livraison DROP FOREIGN KEY fk_livraison_fk_user_author;' |
| Request 187 sql='ALTER TABLE llx_livraison DROP FOREIGN KEY fk_livraison_fk_user_valid;' |
| Request 188 sql='ALTER TABLE llx_livraison RENAME TO llx_delivery;' |
| Request 189 sql='ALTER TABLE llx_livraison_extrafields RENAME TO llx_delivery_extrafields;' |
| Request 190 sql='ALTER TABLE llx_livraisondet RENAME TO llx_deliverydet;' |
| Request 191 sql='ALTER TABLE llx_livraisondet_extrafields RENAME TO llx_deliverydet_extrafields;' |
| Request 192 sql='ALTER TABLE llx_delivery DROP INDEX idx_livraison_uk_ref;' |
| Request 193 sql='ALTER TABLE llx_delivery ADD UNIQUE INDEX idx_delivery_uk_ref (ref, entity);' |
| Request 194 sql='ALTER TABLE llx_delivery DROP INDEX idx_livraison_fk_soc;' |
| Request 195 sql='ALTER TABLE llx_delivery ADD INDEX idx_delivery_fk_soc (fk_soc);' |
| Request 196 sql='ALTER TABLE llx_delivery DROP INDEX idx_livraison_fk_user_author;' |
| Request 197 sql='ALTER TABLE llx_delivery ADD INDEX idx_delivery_fk_user_author (fk_user_author);' |
| Request 198 sql='ALTER TABLE llx_delivery DROP INDEX idx_livraison_fk_user_valid;' |
| Request 199 sql='ALTER TABLE llx_delivery ADD INDEX idx_delivery_fk_user_valid (fk_user_valid);' |
| Request 200 sql='ALTER TABLE llx_delivery DROP FOREIGN KEY fk_livraison_fk_soc;' |
| Request 201 sql='ALTER TABLE llx_delivery DROP FOREIGN KEY fk_livraison_fk_user_author;' |
| Request 202 sql='ALTER TABLE llx_delivery DROP FOREIGN KEY fk_livraison_fk_user_valid;' |
| Request 203 sql='ALTER TABLE llx_delivery ADD CONSTRAINT fk_delivery_fk_soc FOREIGN KEY (fk_soc) REFERENCES llx_societe (rowid);' |
| Request 204 sql='ALTER TABLE llx_delivery ADD CONSTRAINT fk_delivery_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid);' |
| Request 205 sql='ALTER TABLE llx_delivery ADD CONSTRAINT fk_delivery_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid);' |
| Request 206 sql='ALTER TABLE llx_deliverydet DROP FOREIGN KEY fk_livraisondet_fk_livraison;' |
| Request 207 sql='ALTER TABLE llx_deliverydet DROP INDEX idx_livraisondet_fk_expedition;' |
| Request 208 sql='ALTER TABLE llx_deliverydet CHANGE COLUMN fk_livraison fk_delivery integer;' |
| Request 209 sql='ALTER TABLE llx_deliverydet ADD INDEX idx_deliverydet_fk_delivery (fk_delivery);' |
| Request 210 sql='ALTER TABLE llx_deliverydet ADD CONSTRAINT fk_deliverydet_fk_delivery FOREIGN KEY (fk_delivery) REFERENCES llx_delivery (rowid);' |
| Request 211 sql='UPDATE llx_extrafields SET elementtype = 'delivery' WHERE elementtype = 'livraison';' |
| Request 212 sql='UPDATE llx_extrafields SET elementtype = 'deliverydet' WHERE elementtype = 'livraisondet';' |
| Request 213 sql='UPDATE llx_ecm_files SET src_object_type = 'delivery' WHERE src_object_type = 'livraison';' |
| Request 214 sql='UPDATE llx_links SET objecttype = 'delivery' WHERE objecttype = 'livraison';' |
| Request 215 sql='UPDATE llx_document_model SET type = 'delivery' WHERE type = 'livraison';' |
| Request 216 sql='UPDATE llx_object_lang SET type_object = 'delivery' WHERE type_object = 'livraison';' |
| Request 217 sql='UPDATE llx_c_type_contact SET element = 'delivery' WHERE element = 'livraison';' |
| Request 218 sql='UPDATE llx_c_email_template SET type_template = 'delivery' WHERE type_template = 'livraison';' |
| Request 219 sql='UPDATE llx_element_element SET sourcetype = 'delivery' WHERE sourcetype = 'livraison';' |
| Request 220 sql='UPDATE llx_element_element SET targettype = 'delivery' WHERE targettype = 'livraison';' |
| Request 221 sql='UPDATE llx_actioncomm SET element_type = 'delivery' WHERE element_type = 'livraison';' |
| Request 222 sql='UPDATE llx_const set name = 'DELIVERY_ADDON_NUMBER' WHERE name = 'LIVRAISON_ADDON_NUMBER';' |
| Request 223 sql='UPDATE llx_const set value = 'mod_delivery_jade' WHERE value = 'mod_livraison_jade' AND name = 'DELIVERY_ADDON_NUMBER';' |
| Request 224 sql='UPDATE llx_const set value = 'mod_delivery_saphir' WHERE value = 'mod_livraison_saphir' AND name = 'DELIVERY_ADDON_NUMBER';' |
| Request 225 sql='UPDATE llx_rights_def set perms = 'delivery' WHERE perms = 'livraison' and module = 'expedition';' |
| Request 226 sql='UPDATE llx_rights_def set perms = 'delivery_advance' WHERE perms = 'livraison_advance' and module = 'expedition';' |
| Request 227 sql='ALTER TABLE llx_commande_fournisseurdet ADD INDEX idx_commande_fournisseurdet_fk_commande (fk_commande);' |
| Request 228 sql='ALTER TABLE llx_commande_fournisseurdet ADD INDEX idx_commande_fournisseurdet_fk_product (fk_product);' |
| Request 229 sql='CREATE TABLE llx_zapier_hook( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, url varchar(255), event varchar(255), module varchar(128), action varchar(128), status integer, date_creation datetime NOT NULL, fk_user integer NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, import_key varchar(14) ) ENGINE=innodb;' |
| Request 230 sql='CREATE TABLE llx_session( session_id varchar(50) PRIMARY KEY, session_variable text, last_accessed datetime NOT NULL, fk_user integer NOT NULL, remote_ip varchar(64) NULL, user_agent varchar(128) NULL ) ENGINE=innodb;' |
| Request 231 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'github', 'Github', 'https://github.com/{socialid}', 'fa-github', 1);' |
| Request 232 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_funnel_of_prospection.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_funnel_of_prospection.php' AND entity = 1);' |
| Request 233 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_customers_outstanding_bill_reached.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_customers_outstanding_bill_reached.php' AND entity = 1);' |
| Request 234 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_scheduled_jobs.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_scheduled_jobs.php' AND entity = 1);' |
| Request 235 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN packaging varchar(64) DEFAULT NULL;' |
| Request 236 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN packaging varchar(64) DEFAULT NULL;' |
| Request 237 sql='ALTER TABLE llx_projet ADD COLUMN fk_opp_status_end integer DEFAULT NULL;' |
| Request 238 sql='UPDATE llx_c_action_trigger SET elementtype = 'expensereport' where elementtype = 'expense_report' AND code like 'EXPENSE_%';' |
| Request 239 sql='UPDATE llx_c_action_trigger SET code = 'EXPENSE_REPORT_PAID' where code = 'EXPENSE_REPORT_PAYED';' |
| Request 240 sql='UPDATE llx_c_action_trigger SET code = 'EXPENSE_REPORT_DELETE' where code = 'EXPENSE_DELETE';' |
| Request 241 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 242 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 243 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 244 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 245 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 246 sql='insert into llx_c_actioncomm (id, code, type, libelle, module, active, position) values ( 6,'AC_EMAIL_IN','system','reception Email',NULL, 1, 4);' |
| Request 247 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN montant double(24,8) NULL;' |
| Request 248 sql='ALTER TABLE llx_export_model MODIFY COLUMN type varchar(64);' |
| Script processing | Error - Show-Hide details |
