|
| Choose migration script | 8.0.0-9.0.0.sql |
| Request 1 sql='ALTER TABLE llx_contrat_extrafields ADD INDEX idx_contrat_extrafields (fk_object);' |
| Request 2 sql='ALTER TABLE llx_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);' |
| Request 3 sql='ALTER TABLE llx_accounting_account DROP FOREIGN KEY fk_accounting_account_fk_pcg_version;' |
| Request 4 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN fk_pcg_version varchar(32) NOT NULL;' |
| Request 5 sql='ALTER TABLE llx_accounting_system MODIFY COLUMN pcg_version varchar(32) NOT NULL;' |
Error DB_ERROR_1833 (Req 5): ALTER TABLE llx_accounting_system MODIFY COLUMN pcg_version varchar(32) NOT NULL;
Cannot change column 'pcg_version': used in a foreign key constraint 'htech_ias/fk_accountingaccount_fk_pcg_version' of table 'htech_ias/llx_accountingaccount' |
| Request 6 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 7 sql='ALTER TABLE llx_facture ADD COLUMN module_source varchar(32);' |
| Request 8 sql='ALTER TABLE llx_facture ADD COLUMN pos_source varchar(32);' |
| Request 9 sql='create table llx_facture_rec_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 10 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_subject varchar(255) after email_msgid;' |
| Request 11 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_tocc varchar(255) after email_to;' |
| Request 12 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_tobcc varchar(255) after email_tocc;' |
| Request 13 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN code varchar(50);' |
| Request 14 sql='ALTER TABLE llx_extrafields ADD COLUMN help text NULL;' |
| Request 15 sql='ALTER TABLE llx_extrafields ADD COLUMN totalizable boolean DEFAULT FALSE after list;' |
| Request 16 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN desc_fourn text after ref_fourn;' |
| Request 17 sql='ALTER TABLE llx_user ADD COLUMN dateemploymentend date after dateemployment;' |
| Request 18 sql='ALTER TABLE llx_stock_mouvement ADD COLUMN fk_project integer;' |
| Request 19 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN elementtype varchar(32);' |
| Request 20 sql='ALTER TABLE llx_c_field_list ADD COLUMN visible tinyint DEFAULT 1 NOT NULL AFTER search;' |
| Request 21 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 22 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 23 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 24 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 25 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 26 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 27 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 28 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 29 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 30 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_DELETE','Expense report deleted','Executed when an expense report is deleted','expensereport',204);' |
| Request 31 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',202);' |
| Request 32 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',203);' |
| Request 33 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8001', 'Aktieselvskab A/S');' |
| Request 34 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8002', 'Anparts Selvskab ApS');' |
| Request 35 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8003', 'Personlig ejet selvskab');' |
| Request 36 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8004', 'Iværksætterselvskab IVS');' |
| Request 37 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8005', 'Interessentskab I/S');' |
| Request 38 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8006', 'Holdingselskab');' |
| Request 39 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8007', 'Selskab Med Begrænset Hæftelse SMBA');' |
| Request 40 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8008', 'Kommanditselskab K/S');' |
| Request 41 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8009', 'SPE-selskab');' |
| Request 42 sql='ALTER TABLE llx_payment_salary ADD COLUMN ref varchar(30) NULL after rowid;' |
| Request 43 sql='ALTER TABLE llx_payment_salary ADD COLUMN fk_projet integer DEFAULT NULL after amount;' |
| Request 44 sql='ALTER TABLE llx_payment_various ADD COLUMN ref varchar(30) NULL after rowid;' |
| Request 45 sql='ALTER TABLE llx_categorie ADD COLUMN ref_ext varchar(255);' |
| Request 46 sql='ALTER TABLE llx_paiement ADD COLUMN ext_payment_id varchar(128);' |
| Request 47 sql='ALTER TABLE llx_paiement ADD COLUMN ext_payment_site varchar(128);' |
| Request 48 sql='ALTER TABLE llx_societe ADD COLUMN twitter varchar(255) after skype;' |
| Request 49 sql='ALTER TABLE llx_societe ADD COLUMN facebook varchar(255) after skype;' |
| Request 50 sql='ALTER TABLE llx_societe ADD COLUMN instagram varchar(255) after skype;' |
| Request 51 sql='ALTER TABLE llx_societe ADD COLUMN snapchat varchar(255) after skype;' |
| Request 52 sql='ALTER TABLE llx_societe ADD COLUMN googleplus varchar(255) after skype;' |
| Request 53 sql='ALTER TABLE llx_societe ADD COLUMN youtube varchar(255) after skype;' |
| Request 54 sql='ALTER TABLE llx_societe ADD COLUMN whatsapp varchar(255) after skype;' |
| Request 55 sql='ALTER TABLE llx_socpeople ADD COLUMN twitter varchar(255) after skype;' |
| Request 56 sql='ALTER TABLE llx_socpeople ADD COLUMN facebook varchar(255) after skype;' |
| Request 57 sql='ALTER TABLE llx_socpeople ADD COLUMN instagram varchar(255) after skype;' |
| Request 58 sql='ALTER TABLE llx_socpeople ADD COLUMN snapchat varchar(255) after skype;' |
| Request 59 sql='ALTER TABLE llx_socpeople ADD COLUMN googleplus varchar(255) after skype;' |
| Request 60 sql='ALTER TABLE llx_socpeople ADD COLUMN youtube varchar(255) after skype;' |
| Request 61 sql='ALTER TABLE llx_socpeople ADD COLUMN whatsapp varchar(255) after skype;' |
| Request 62 sql='ALTER TABLE llx_adherent ADD COLUMN skype varchar(255);' |
| Request 63 sql='ALTER TABLE llx_adherent ADD COLUMN twitter varchar(255);' |
| Request 64 sql='ALTER TABLE llx_adherent ADD COLUMN facebook varchar(255);' |
| Request 65 sql='ALTER TABLE llx_adherent ADD COLUMN instagram varchar(255);' |
| Request 66 sql='ALTER TABLE llx_adherent ADD COLUMN snapchat varchar(255);' |
| Request 67 sql='ALTER TABLE llx_adherent ADD COLUMN googleplus varchar(255);' |
| Request 68 sql='ALTER TABLE llx_adherent ADD COLUMN youtube varchar(255);' |
| Request 69 sql='ALTER TABLE llx_adherent ADD COLUMN whatsapp varchar(255);' |
| Request 70 sql='ALTER TABLE llx_user ADD COLUMN skype varchar(255);' |
| Request 71 sql='ALTER TABLE llx_user ADD COLUMN twitter varchar(255);' |
| Request 72 sql='ALTER TABLE llx_user ADD COLUMN facebook varchar(255);' |
| Request 73 sql='ALTER TABLE llx_user ADD COLUMN instagram varchar(255);' |
| Request 74 sql='ALTER TABLE llx_user ADD COLUMN snapchat varchar(255);' |
| Request 75 sql='ALTER TABLE llx_user ADD COLUMN googleplus varchar(255);' |
| Request 76 sql='ALTER TABLE llx_user ADD COLUMN youtube varchar(255);' |
| Request 77 sql='ALTER TABLE llx_user ADD COLUMN whatsapp varchar(255);' |
| Request 78 sql='ALTER TABLE llx_website CHANGE COLUMN fk_user_create fk_user_creat integer;' |
| Request 79 sql='ALTER TABLE llx_website_page CHANGE COLUMN fk_user_create fk_user_creat integer;' |
| Request 80 sql='ALTER TABLE llx_website ADD COLUMN maincolor varchar(16);' |
| Request 81 sql='ALTER TABLE llx_website ADD COLUMN maincolorbis varchar(16);' |
| Request 82 sql='ALTER TABLE llx_website_page ADD COLUMN image varchar(255);' |
| Request 83 sql='CREATE TABLE llx_takepos_floor_tables( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, label varchar(255), leftpos float, toppos float, floor smallint ) ENGINE=innodb;' |
| Request 84 sql='UPDATE llx_c_payment_term SET decalage = nbjour, nbjour = 0 where decalage IS NULL AND type_cdr = 2;' |
| Request 85 sql='UPDATE llx_holiday SET ref = rowid WHERE ref IS NULL;' |
| Request 86 sql='CREATE TABLE llx_emailcollector_emailcollector( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, entity integer DEFAULT 1 NOT NULL, ref varchar(128) NOT NULL, label varchar(255), description text, host varchar(255), login varchar(128), password varchar(128), source_directory varchar(255) NOT NULL, target_directory varchar(255), datelastresult datetime, codelastresult varchar(16), lastresult varchar(255), 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 integer NOT NULL ) ENGINE=innodb;' |
| Request 87 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN login varchar(128);' |
| Request 88 sql='ALTER TABLE llx_emailcollector_emailcollector ADD INDEX idx_emailcollector_entity (entity);' |
| Request 89 sql='ALTER TABLE llx_emailcollector_emailcollector ADD INDEX idx_emailcollector_status (status);' |
| Request 90 sql='CREATE TABLE llx_emailcollector_emailcollectorfilter( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_emailcollector INTEGER NOT NULL, type varchar(128) NOT NULL, rulevalue varchar(128) 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, import_key varchar(14), status integer NOT NULL ) ENGINE=innodb;' |
| Request 91 sql='CREATE TABLE llx_emailcollector_emailcollectoraction( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_emailcollector INTEGER NOT NULL, type varchar(128) NOT NULL, actionparam varchar(255) 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, position integer DEFAULT 0, import_key varchar(14), status integer NOT NULL ) ENGINE=innodb;' |
| Request 92 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD INDEX idx_emailcollector_fk_emailcollector (fk_emailcollector);' |
| Request 93 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD CONSTRAINT fk_emailcollectorfilter_fk_emailcollector FOREIGN KEY (fk_emailcollector) REFERENCES llx_emailcollector_emailcollector(rowid);' |
| Request 94 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD INDEX idx_emailcollector_fk_emailcollector (fk_emailcollector);' |
| Request 95 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD CONSTRAINT fk_emailcollectoraction_fk_emailcollector FOREIGN KEY (fk_emailcollector) REFERENCES llx_emailcollector_emailcollector(rowid);' |
| Request 96 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD UNIQUE INDEX uk_emailcollector_emailcollectorfilter (fk_emailcollector, type, rulevalue);' |
| Request 97 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD UNIQUE INDEX uk_emailcollector_emailcollectoraction (fk_emailcollector, type);' |
| Request 98 sql='ALTER TABLE llx_societe_rib ADD COLUMN comment varchar(255);' |
| Request 99 sql='ALTER TABLE llx_societe_rib ADD COLUMN ipaddress varchar(68);' |
| Request 100 sql='DROP TABLE llx_ticket_logs;' |
| Request 101 sql='CREATE TABLE llx_pos_cash_fence( rowid INTEGER AUTO_INCREMENT PRIMARY KEY, entity INTEGER DEFAULT 1 NOT NULL, ref VARCHAR(64), label VARCHAR(255), opening double(24,8) default 0, cash double(24,8) default 0, card double(24,8) default 0, cheque double(24,8) default 0, status INTEGER, date_creation DATETIME NOT NULL, date_valid DATETIME, day_close INTEGER, month_close INTEGER, year_close INTEGER, posmodule VARCHAR(30), posnumber VARCHAR(30), fk_user_creat integer, fk_user_valid integer, tms TIMESTAMP NOT NULL, import_key VARCHAR(14) ) ENGINE=innodb;' |
| Request 102 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN account_number varchar(32) NOT NULL;' |
| Request 103 sql='UPDATE llx_const set name = __ENCRYPT('PRELEVEMENT_END_TO_END')__ where name = __ENCRYPT('END_TO_END')__;' |
| Request 104 sql='UPDATE llx_const set name = __ENCRYPT('PRELEVEMENT_USTRD')__ where name = __ENCRYPT('USTRD')__;' |
| Request 105 sql='DROP TABLE tmp_llx_accouting_account;' |
| Request 106 sql='CREATE TABLE tmp_llx_accouting_account AS SELECT MIN(rowid) as MINID, MAX(rowid) as MAXID, account_number, entity, fk_pcg_version, count(*) AS NB FROM llx_accounting_account group BY account_number, entity, fk_pcg_version HAVING count(*) >= 2 order by account_number, entity, fk_pcg_version;' |
| Request 107 sql='DELETE from llx_accounting_account where rowid in (select minid from tmp_llx_accouting_account where minid NOT IN (SELECT fk_code_ventilation from llx_facturedet) AND minid NOT IN (SELECT fk_code_ventilation from llx_facture_fourn_det) AND minid NOT IN (SELECT fk_code_ventilation from llx_expensereport_det));' |
| Request 108 sql='ALTER TABLE llx_accounting_account DROP INDEX uk_accounting_account;' |
| Request 109 sql='ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);' |
| Request 110 sql='UPDATE llx_projet SET fk_opp_status = NULL WHERE fk_opp_status = -1;' |
| Script processing | Error - Show-Hide details |
