|
| Choose migration script | 4.0.0-5.0.0.sql |
| Request 1 sql='UPDATE llx_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRPARTY_CREATION_INDIVIDUAL')__;' |
| Request 2 sql='UPDATE llx_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRDPARTY_CREATION_INDIVIDUAL')__;' |
| Request 3 sql='ALTER TABLE llx_product_lot MODIFY COLUMN entity integer DEFAULT 1;' |
| Request 4 sql='UPDATE llx_product_lot SET entity = 1 WHERE entity IS NULL;' |
| Request 5 sql='ALTER TABLE llx_bank_account ADD COLUMN extraparams varchar(255);' |
| Request 6 sql='ALTER TABLE llx_societe ALTER COLUMN fk_stcomm SET DEFAULT 0;' |
| Request 7 sql='ALTER TABLE llx_c_actioncomm ADD COLUMN picto varchar(48);' |
| Request 8 sql='ALTER TABLE llx_facturedet ADD INDEX idx_facturedet_fk_code_ventilation (fk_code_ventilation);' |
| Request 9 sql='ALTER TABLE llx_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_code_ventilation (fk_code_ventilation);' |
| Request 10 sql='ALTER TABLE llx_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_product (fk_product);' |
| Request 11 sql='ALTER TABLE llx_facture_rec ADD COLUMN fk_user_modif integer;' |
| Request 12 sql='ALTER TABLE llx_expedition ADD COLUMN fk_user_modif integer;' |
| Request 13 sql='ALTER TABLE llx_projet ADD COLUMN fk_user_modif integer;' |
| Request 14 sql='ALTER TABLE llx_adherent ADD COLUMN model_pdf varchar(255);' |
| Request 15 sql='ALTER TABLE llx_don ADD COLUMN date_valid datetime;' |
| Request 16 sql='DELETE FROM llx_menu where module='expensereport';' |
| Request 17 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_user_author integer after fk_unit;' |
| Request 18 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_user_modif integer after fk_unit;' |
| Request 19 sql='ALTER TABLE llx_user DROP COLUMN phenix_login;' |
| Request 20 sql='ALTER TABLE llx_user DROP COLUMN phenix_pass;' |
| Request 21 sql='ALTER TABLE llx_user ADD COLUMN dateemployment datetime;' |
| Request 22 sql='ALTER TABLE llx_user MODIFY login varchar(50) NOT NULL;' |
| Request 23 sql='ALTER TABLE llx_societe ADD COLUMN fk_account integer;' |
| Request 24 sql='ALTER TABLE llx_commandedet ADD COLUMN fk_commandefourndet integer DEFAULT NULL after import_key;' |
| Request 25 sql='ALTER TABLE llx_commandedet MODIFY COLUMN fk_commandefourndet integer DEFAULT NULL;' |
| Request 26 sql='ALTER TABLE llx_website ADD COLUMN virtualhost varchar(255) after fk_default_home;' |
| Request 27 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_account integer after fk_type;' |
| Request 28 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_mode_reglement integer after fk_account;' |
| Request 29 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_author integer;' |
| Request 30 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_modif integer;' |
| Request 31 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_valid integer;' |
| Request 32 sql='ALTER TABLE llx_ecm_files ADD COLUMN gen_or_uploaded varchar(12) after cover;' |
| Request 33 sql='DROP TABLE llx_document_generator;' |
| Request 34 sql='DROP TABLE llx_ecm_documents;' |
| Request 35 sql='DROP TABLE llx_holiday_events;' |
| Request 36 sql='DROP TABLE llx_holiday_types;' |
| Request 37 sql='ALTER TABLE llx_notify ADD COLUMN type_target varchar(16) NULL;' |
| Request 38 sql='ALTER TABLE llx_entrepot DROP COLUMN valo_pmp;' |
| Request 39 sql='ALTER TABLE llx_notify_def MODIFY COLUMN fk_soc integer NULL;' |
| Request 40 sql='create table llx_categorie_project ( fk_categorie integer NOT NULL, fk_project integer NOT NULL, import_key varchar(14) )ENGINE=innodb;' |
| Request 41 sql='ALTER TABLE llx_categorie_project ADD PRIMARY KEY pk_categorie_project (fk_categorie, fk_project);' |
| Request 42 sql='ALTER TABLE llx_categorie_project ADD INDEX idx_categorie_project_fk_categorie (fk_categorie);' |
| Request 43 sql='ALTER TABLE llx_categorie_project ADD INDEX idx_categorie_project_fk_project (fk_project);' |
| Request 44 sql='ALTER TABLE llx_categorie_project ADD CONSTRAINT fk_categorie_project_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
| Request 45 sql='ALTER TABLE llx_categorie_project ADD CONSTRAINT fk_categorie_project_fk_project_rowid FOREIGN KEY (fk_project) REFERENCES llx_projet (rowid);' |
| Request 46 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;' |
| Request 47 sql='ALTER TABLE llx_societe_remise ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;' |
| Request 48 sql='create table llx_expensereport_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 49 sql='ALTER TABLE llx_expensereport_extrafields ADD INDEX idx_expensereport_extrafields (fk_object);' |
| Request 50 sql='ALTER TABLE llx_cotisation RENAME TO llx_subscription;' |
| Request 51 sql='ALTER TABLE llx_subscription ADD UNIQUE INDEX uk_subscription (fk_adherent,dateadh);' |
| Request 52 sql='ALTER TABLE llx_subscription CHANGE COLUMN cotisation subscription real;' |
| Request 53 sql='ALTER TABLE llx_adherent_type CHANGE COLUMN cotisation subscription varchar(3) NOT NULL DEFAULT '1';' |
| Request 54 sql='UPDATE llx_adherent_type SET subscription = '1' WHERE subscription = 'yes';' |
| Request 55 sql='CREATE TABLE llx_product_lot_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 56 sql='ALTER TABLE llx_product_lot_extrafields ADD INDEX idx_product_lot_extrafields (fk_object);' |
| Request 57 sql='ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;' |
| Request 58 sql='CREATE TABLE llx_product_warehouse_properties ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_product integer NOT NULL, fk_entrepot integer NOT NULL, seuil_stock_alerte integer DEFAULT 0, desiredstock integer DEFAULT 0, import_key varchar(14) )ENGINE=innodb;' |
| Request 59 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN entity integer DEFAULT 1 NOT NULL;' |
| Request 60 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN fk_user_modif integer;' |
| Request 61 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_creation datetime;' |
| Request 62 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 63 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN numero_compte varchar(32) NOT NULL;' |
| Request 64 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32) NOT NULL;' |
| Request 65 sql='ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);' |
| Request 66 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_code_ventilation integer DEFAULT 0;' |
| Request 67 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN fdm type_cdr tinyint;' |
| Request 68 sql='ALTER TABLE llx_facturedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 69 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 70 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 71 sql='ALTER TABLE llx_commandedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 72 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 73 sql='ALTER TABLE llx_propaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 74 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 75 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;' |
| Request 76 sql='ALTER TABLE llx_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 77 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN fdm type_cdr TINYINT;' |
| Request 78 sql='ALTER TABLE llx_entrepot ADD COLUMN fk_parent integer DEFAULT 0;' |
| Request 79 sql='create table llx_resource_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_resource_extrafields ADD INDEX idx_resource_extrafields (fk_object);' |
| Request 81 sql='INSERT INTO llx_const (name, value, type, note, visible, entity) values (__ENCRYPT('MAIN_SIZE_SHORTLIST_LIMIT')__, __ENCRYPT('3')__, 'chaine', 'Max length for small lists (tabs)', 0, 0);' |
| Request 82 sql='INSERT INTO llx_const (name, value, type, note, visible, entity) values (__ENCRYPT('EXPEDITION_ADDON_NUMBER')__, __ENCRYPT('mod_expedition_safor')__, 'chaine','Name for numbering manager for shipments',0,1);' |
| Request 83 sql='ALTER TABLE llx_bank_account ADD COLUMN note_public text;' |
| Request 84 sql='ALTER TABLE llx_bank_account ADD COLUMN model_pdf varchar(255);' |
| Request 85 sql='ALTER TABLE llx_bank_account ADD COLUMN import_key varchar(14);' |
| Request 86 sql='ALTER TABLE llx_projet ADD COLUMN import_key varchar(14);' |
| Request 87 sql='ALTER TABLE llx_projet_task ADD COLUMN import_key varchar(14);' |
| Request 88 sql='ALTER TABLE llx_projet_task_time ADD COLUMN import_key varchar(14);' |
| Request 89 sql='ALTER TABLE llx_overwrite_trans ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;' |
| Request 90 sql='ALTER TABLE llx_mailing_cibles ADD COLUMN error_text varchar(255);' |
| Request 91 sql='ALTER TABLE llx_c_actioncomm MODIFY COLUMN type varchar(50) DEFAULT 'system' NOT NULL;' |
| Request 92 sql='create table llx_user_employment ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, ref varchar(50), ref_ext varchar(50), fk_user integer, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer, fk_user_modif integer, job varchar(128), status integer NOT NULL, salary double(24,8), salaryextra double(24,8), weeklyhours double(16,8), dateemployment date, dateemploymentend date )ENGINE=innodb;' |
| Request 93 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_date_debut (date_debut);' |
| Request 94 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_date_fin (date_fin);' |
| Request 95 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_statut (fk_statut);' |
| Request 96 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_author (fk_user_author);' |
| Request 97 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_valid (fk_user_valid);' |
| Request 98 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_approve (fk_user_approve);' |
| Request 99 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_refuse (fk_user_approve);' |
| Request 100 sql='DELETE FROM llx_actioncomm_resources WHERE fk_actioncomm not in (select id from llx_actioncomm);' |
| Request 101 sql='DROP TABLE tmp_links_double;' |
| Request 102 sql='CREATE TABLE tmp_links_double AS (SELECT objectid, label, MAX(rowid) AS max_rowid, COUNT(rowid) AS count_rowid FROM llx_links WHERE label IS NOT NULL GROUP BY objectid, label HAVING COUNT(rowid) >= 2);' |
| Request 103 sql='DELETE FROM llx_links WHERE (rowid, label) IN (SELECT max_rowid, label FROM tmp_links_double);' |
| Request 104 sql='DROP TABLE tmp_links_double;' |
| Request 105 sql='ALTER TABLE llx_links ADD UNIQUE INDEX uk_links (objectid,label);' |
| Request 106 sql='ALTER TABLE llx_expensereport ADD UNIQUE INDEX idx_expensereport_uk_ref (ref, entity);' |
| Request 107 sql='UPDATE llx_projet_task SET ref = NULL WHERE ref = '';' |
| Request 108 sql='ALTER TABLE llx_projet_task ADD UNIQUE INDEX uk_projet_task_ref (ref, entity);' |
| Request 109 sql='ALTER TABLE llx_contrat ADD COLUMN fk_user_modif integer;' |
| Request 110 sql='UPDATE llx_accounting_account SET account_parent = 0 WHERE account_parent = '';' |
| Request 111 sql='ALTER TABLE llx_product_price MODIFY COLUMN date_price DATETIME NULL;' |
| Request 112 sql='ALTER TABLE llx_product_price ALTER COLUMN date_price SET DEFAULT NULL;' |
| Request 113 sql='ALTER TABLE llx_product_price ADD COLUMN default_vat_code varchar(10) after tva_tx;' |
| Request 114 sql='ALTER TABLE llx_product_customer_price ADD COLUMN default_vat_code varchar(10) after tva_tx;' |
| Request 115 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN default_vat_code varchar(10) after tva_tx;' |
| Request 116 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) after tva_tx;' |
| Request 117 sql='ALTER TABLE llx_events MODIFY COLUMN ip varchar(250);' |
| Request 118 sql='UPDATE llx_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';' |
| Request 119 sql='UPDATE llx_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';' |
| Script processing | OK - Show-Hide details |
