|
| Choose migration script | 22.0.0-23.0.0.sql |
| Request 1 sql='ALTER TABLE llx_extrafields ADD module varchar(64) AFTER enabled;' |
| Request 2 sql='ALTER TABLE llx_opensurvey_user_studs ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 3 sql='ALTER TABLE llx_usergroup ADD color VARCHAR(6) AFTER tms;' |
| Request 4 sql='create table llx_categorie_project_task ( fk_categorie integer NOT NULL, fk_project_task integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 5 sql='ALTER TABLE llx_categorie_project_task ADD PRIMARY KEY pk_categorie_propal (fk_categorie, fk_project_task);' |
| Request 6 sql='ALTER TABLE llx_categorie_project_task ADD INDEX idx_categorie_project_fk_categorie (fk_categorie);' |
| Request 7 sql='ALTER TABLE llx_categorie_project_task ADD CONSTRAINT fk_categorie_project_task_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
| Request 8 sql='ALTER TABLE llx_categorie_project_task DROP FOREIGN KEY fk_categorie_project_task_rowid;' |
| Request 9 sql='DROP INDEX idx_categorie_project_fk_task ON llx_categorie_project_task;' |
| Request 10 sql='ALTER TABLE llx_categorie_project_task ADD INDEX idx_categorie_project_fk_task (fk_project_task);' |
| Request 11 sql='ALTER TABLE llx_categorie_project_task ADD CONSTRAINT fk_categorie_project_task_rowid FOREIGN KEY (fk_project_task) REFERENCES llx_projet_task (rowid);' |
| Request 12 sql='UPDATE llx_actioncomm SET elementtype = 'project_task' WHERE elementtype = 'task';' |
| Request 13 sql='ALTER TABLE llx_document_model ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 14 sql='ALTER TABLE llx_ticket ADD COLUMN note_public text after resolution;' |
| Request 15 sql='ALTER TABLE llx_ticket ADD COLUMN note_private text after resolution;' |
| Request 16 sql='ALTER TABLE llx_ticket ADD COLUMN fk_user_modif integer after resolution;' |
| Request 17 sql='CREATE TABLE llx_paiement_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 18 sql='ALTER TABLE llx_paiement_extrafields ADD UNIQUE INDEX uk_paiement_extrafields (fk_object);' |
| Request 19 sql='CREATE TABLE llx_accounting_analytic_axis ( rowid integer AUTO_INCREMENT PRIMARY KEY, label varchar(255) NOT NULL, code varchar(32) NOT NULL, active integer DEFAULT 1, entity integer DEFAULT 1 NOT NULL, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_author integer NOT NULL, fk_user_modif integer, import_key varchar(14) ) ENGINE=innodb;' |
| Request 20 sql='ALTER TABLE llx_accounting_analytic_axis ADD UNIQUE INDEX uk_accounting_analytic_axis(code, entity);' |
| Request 21 sql='CREATE TABLE llx_accounting_analytic_account ( rowid integer AUTO_INCREMENT PRIMARY KEY, label varchar(255) NOT NULL, code varchar(32) NOT NULL, description text, fk_axis integer NOT NULL, active integer DEFAULT 1, entity integer DEFAULT 1 NOT NULL, date_start date, date_end date, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_author integer NOT NULL, fk_user_modif integer, import_key varchar(14) ) ENGINE=innodb;' |
| Request 22 sql='ALTER TABLE llx_accounting_analytic_account ADD UNIQUE INDEX uk_accounting_analytic_account(code, entity);' |
| Request 23 sql='ALTER TABLE llx_accounting_analytic_account ADD CONSTRAINT fk_accounting_analytic_account_fk_axis FOREIGN KEY (fk_axis) REFERENCES llx_accounting_analytic_axis (rowid);' |
| Request 24 sql='CREATE TABLE llx_accounting_analytic_distribution ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_source_line integer NOT NULL, sourcetype varchar(32) NOT NULL, fk_analytic_account integer NOT NULL, percentage real DEFAULT 100, amount double(24,8), entity integer DEFAULT 1, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_author integer NOT NULL, fk_user_modif integer, import_key varchar(14) ) ENGINE=innodb;' |
| Request 25 sql='ALTER TABLE llx_accounting_analytic_distribution ADD CONSTRAINT fk_accounting_analytic_distribution_fk_analytic_account FOREIGN KEY (fk_analytic_account) REFERENCES llx_accounting_analytic_account (rowid);' |
| Request 26 sql='ALTER TABLE llx_facture ADD COLUMN dispute_status integer DEFAULT 0 after payment_reference;' |
| Request 27 sql='ALTER TABLE llx_facture ADD COLUMN ip varchar(250);' |
| Request 28 sql='ALTER TABLE llx_facture ADD COLUMN pos_print_counter integer DEFAULT 0;' |
| Request 29 sql='ALTER TABLE llx_facture ADD COLUMN email_sent_counter integer DEFAULT 0;' |
| Request 30 sql='ALTER TABLE llx_commande ADD COLUMN ip varchar(250);' |
| Request 31 sql='ALTER TABLE llx_commande ADD COLUMN user_agent varchar(255);' |
| Request 32 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN date_reception datetime default NULL;' |
| Request 33 sql='ALTER TABLE llx_c_currencies ADD COLUMN max_decimal_unit tinyint NULL;' |
| Request 34 sql='ALTER TABLE llx_c_currencies ADD COLUMN max_decimal_tot tinyint NULL;' |
| Request 35 sql='ALTER TABLE llx_oauth_token ADD COLUMN lastaccess datetime NULL;' |
| Request 36 sql='ALTER TABLE llx_oauth_token ADD COLUMN apicount_previous_month BIGINT UNSIGNED DEFAULT 0;' |
| Request 37 sql='ALTER TABLE llx_oauth_token ADD COLUMN apicount_month BIGINT UNSIGNED DEFAULT 0;' |
| Request 38 sql='ALTER TABLE llx_oauth_token ADD COLUMN apicount_total BIGINT UNSIGNED DEFAULT 0;' |
| Request 39 sql='ALTER TABLE llx_webhook_target ADD COLUMN entity integer DEFAULT 1 NOT NULL;' |
| Request 40 sql='ALTER TABLE llx_webhook_history MODIFY COLUMN url varchar(255);' |
| Request 41 sql='CREATE TABLE llx_webhook_history( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, trigger_code varchar(128) NOT NULL, trigger_data text NOT NULL, fk_target integer NOT NULL, url varchar(255) NOT NULL, error_message text, note_private text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, import_key varchar(14), status integer DEFAULT 1 NOT NULL ) ENGINE=innodb;' |
| Request 42 sql='ALTER TABLE llx_webhook_history ADD COLUMN trigger_code varchar(128) NOT NULL DEFAULT 'UNKOWN';' |
| Request 43 sql='ALTER TABLE llx_webhook_history ADD COLUMN error_message text;' |
| Request 44 sql='ALTER TABLE llx_extrafields ADD COLUMN emptyonclone integer DEFAULT 0 AFTER alwayseditable;' |
| Request 45 sql='ALTER TABLE llx_blockedlog ADD COLUMN object_format varchar(16) DEFAULT 'V1' AFTER object_version;' |
| Request 46 sql='UPDATE llx_blockedlog SET object_format = '' WHERE object_version = '18' OR object_version = '' OR object_version IS NULL;' |
| Request 47 sql='INSERT INTO llx_c_country (rowid, code, code_iso, label, active, favorite, numeric_code) VALUES (248, 'BQ', 'BES', 'Bonaire, Sint Eustatius and Saba', 1, 0, 535);' |
| Request 48 sql='INSERT INTO llx_c_country (rowid, code, code_iso, label, active, favorite, numeric_code) VALUES (249, 'GP', 'GLP', 'Guadeloupe', 0, 0, 312);' |
| Request 49 sql='INSERT INTO llx_c_country (rowid, code, code_iso, label, active, favorite, numeric_code) VALUES (250, 'GY', 'GUY', 'Guyana', 0, 0, 328);' |
| Request 50 sql='INSERT INTO llx_c_country (rowid, code, code_iso, label, active, favorite, numeric_code) VALUES (251, 'MQ', 'MTQ', 'Martinique', 0, 0, 474);' |
| Request 51 sql='INSERT INTO llx_c_country (rowid, code, code_iso, label, active, favorite, numeric_code) VALUES (252, 'RE', 'REU', 'Reunion', 0, 0, 638);' |
| Request 52 sql='INSERT INTO llx_c_country (rowid, code, code_iso, label, active, favorite, numeric_code) VALUES (253, 'SS', 'SSD', 'South Sudan', 1, 0, 728);' |
| Request 53 sql='UPDATE llx_c_country SET sepa = 1 WHERE code IN ('AD','AL','AT','AX','BE','BG','BL','CH','CY','CZ','DE','DK','EE','ES','FI','FR','GB','GF','GG','GI','GP','GR','HR','HU','IE','IM','IS','IT','JE','LI','LT','LU','LV','MC','MD','ME','MF','MK','MQ','MT','NL','NO','PL','PM','PT','RE','RO','RS','SE','SI','SK','SM','VA','YT');' |
| Request 54 sql='ALTER TABLE llx_user DROP COLUMN egroupware_id;' |
| Request 55 sql='ALTER TABLE llx_user ADD COLUMN access_hours varchar(128) DEFAULT NULL;' |
| Request 56 sql='ALTER TABLE llx_adherent ADD COLUMN birth_place varchar(64) after birth;' |
| Request 57 sql='ALTER TABLE llx_societe ADD COLUMN birth date DEFAULT NULL after fk_forme_juridique;' |
| Request 58 sql='ALTER TABLE llx_societe ADD vatexemptcode varchar(24) DEFAULT NULL;' |
| Request 59 sql='DELETE FROM llx_user_rights WHERE fk_id IN (SELECT id FROM llx_rights_def WHERE module = 'webhook' AND perms = 'webhook_target');' |
| Request 60 sql='DELETE FROM llx_usergroup_rights WHERE fk_id IN (SELECT id FROM llx_rights_def WHERE module = 'webhook' AND perms = 'webhook_target');' |
| Request 61 sql='DELETE FROM llx_rights_def WHERE module = 'webhook' AND perms = 'webhook_target';' |
| Request 62 sql='DELETE FROM llx_user_rights WHERE fk_id IN (SELECT id FROM llx_rights_def WHERE module = 'eventorganization');' |
| Request 63 sql='DELETE FROM llx_usergroup_rights WHERE fk_id IN (SELECT id FROM llx_rights_def WHERE module = 'eventorganization');' |
| Request 64 sql='DELETE FROM llx_rights_def WHERE module = 'eventorganization';' |
| Request 65 sql='ALTER TABLE llx_rights_def ADD COLUMN family VARCHAR(64) AFTER module_position;' |
| Request 66 sql='UPDATE llx_rights_def SET module_position = 64 WHERE module = 'intracommreport' AND module_position <> 64;' |
| Request 67 sql='UPDATE llx_rights_def SET module_position = 62 WHERE module = 'accounting' AND module_position <> 62;' |
| Request 68 sql='ALTER TABLE llx_prelevement_lignes ADD COLUMN bic varchar(11);' |
| Request 69 sql='ALTER TABLE llx_prelevement_lignes ADD COLUMN iban varchar(80);' |
| Request 70 sql='ALTER TABLE llx_prelevement_lignes ADD COLUMN rum varchar(32);' |
| Request 71 sql='ALTER TABLE llx_product_customer_price CHANGE COLUMN localtax1_tx localtax1_tx varchar(20) DEFAULT '0';' |
| Request 72 sql='ALTER TABLE llx_product_customer_price CHANGE COLUMN localtax2_tx localtax2_tx varchar(20) DEFAULT '0';' |
| Request 73 sql='ALTER TABLE llx_product_customer_price_log CHANGE COLUMN localtax1_tx localtax1_tx varchar(20) DEFAULT '0';' |
| Request 74 sql='ALTER TABLE llx_product_customer_price_log CHANGE COLUMN localtax2_tx localtax2_tx varchar(20) DEFAULT '0';' |
| Request 75 sql='ALTER TABLE llx_subscription DROP INDEX idx_subscription_fk_adherent;' |
| Request 76 sql='ALTER TABLE llx_subscription DROP INDEX idx_subscription_fk_bank;' |
| Request 77 sql='ALTER TABLE llx_subscription DROP INDEX idx_subscription_dateadh;' |
| Request 78 sql='ALTER TABLE llx_subscription ADD INDEX idx_subscription_fk_adherent (fk_adherent);' |
| Request 79 sql='ALTER TABLE llx_subscription ADD INDEX idx_subscription_fk_bank (fk_bank);' |
| Request 80 sql='ALTER TABLE llx_subscription ADD INDEX idx_subscription_dateadh (dateadh);' |
| Request 81 sql='ALTER TABLE llx_subscription ADD COLUMN ref_ext varchar(128);' |
| Request 82 sql='ALTER TABLE llx_subscription ADD COLUMN note_private text;' |
| Request 83 sql='ALTER TABLE llx_bank_import ADD COLUMN fitid varchar(255) NULL after id_account;' |
| Request 84 sql='ALTER TABLE llx_element_contact ADD mandatory_signature TINYINT AFTER element_id;' |
| Request 85 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN deposit_percent varchar(63) DEFAULT NULL AFTER fk_cond_reglement;' |
| Request 86 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN deposit_percent varchar(63) DEFAULT NULL AFTER fk_cond_reglement;' |
| Request 87 sql='ALTER TABLE llx_subscription ADD COLUMN import_key varchar(14) NULL;' |
| Request 88 sql='ALTER TABLE llx_categorie ADD COLUMN extraparams varchar(255) AFTER fk_soc;' |
| Request 89 sql='CREATE TABLE llx_categorie_propal ( fk_categorie integer NOT NULL, fk_propal integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 90 sql='ALTER TABLE llx_categorie_propal ADD PRIMARY KEY pk_categorie_propal (fk_categorie, fk_propal);' |
| Request 91 sql='ALTER TABLE llx_categorie_propal ADD INDEX idx_categorie_propal_fk_categorie (fk_categorie);' |
| Request 92 sql='ALTER TABLE llx_categorie_propal ADD INDEX idx_categorie_propal_fk_propal (fk_propal);' |
| Request 93 sql='ALTER TABLE llx_categorie_propal ADD CONSTRAINT fk_categorie_propal_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
| Request 94 sql='ALTER TABLE llx_categorie_propal ADD CONSTRAINT fk_categorie_propal_fk_propal_rowid FOREIGN KEY (fk_propal) REFERENCES llx_propal (rowid);' |
| Request 95 sql='create table llx_categorie_supplier_proposal ( fk_categorie integer NOT NULL, fk_supplier_proposal integer NOT NULL, import_key varchar(14) )ENGINE=innodb;' |
| Request 96 sql='CREATE TABLE llx_accounting_bookkeeping_piece ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, ref varchar(128), tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, datec datetime, datep date NOT NULL, statut smallint DEFAULT 0, note_private text, note_public text, fk_user_author integer, fk_user_modif integer, fk_user_valid integer, fk_user_closing integer, import_key varchar(14), extraparams varchar(255) ) ENGINE=innodb;' |
| Request 97 sql='ALTER TABLE llx_accounting_bookkeeping_piece ADD UNIQUE INDEX uk_accounting_bookkeeping_piece_ref (ref, entity);' |
| Request 98 sql='ALTER TABLE llx_accounting_bookkeeping_piece ADD INDEX idx_accounting_bookkeeping_piece_fk_user_author (fk_user_author);' |
| Request 99 sql='ALTER TABLE llx_accounting_bookkeeping_piece ADD INDEX idx_accounting_bookkeeping_piece_fk_user_modif (fk_user_modif);' |
| Request 100 sql='ALTER TABLE llx_accounting_bookkeeping_piece ADD INDEX idx_accounting_bookkeeping_piece_fk_user_valid (fk_user_valid);' |
| Request 101 sql='ALTER TABLE llx_accounting_bookkeeping_piece ADD INDEX idx_accounting_bookkeeping_piece_fk_user_closing (fk_user_closing);' |
| Request 102 sql='ALTER TABLE llx_mailing ADD COLUMN fk_project integer DEFAULT NULL;' |
| Request 103 sql='UPDATE llx_c_units SET label = 'unitP' WHERE code = 'P';' |
| Request 104 sql='ALTER TABLE llx_receptiondet_batch ADD COLUMN description text AFTER fk_product;' |
| Request 105 sql='ALTER TABLE llx_receptiondet_batch ADD COLUMN fk_unit integer AFTER qty;' |
| Request 106 sql='ALTER TABLE llx_receptiondet_batch ADD COLUMN rang integer DEFAULT 0 AFTER cost_price;' |
| Request 107 sql='ALTER TABLE llx_ecm_files ADD INDEX idx_ecm_files_src_object_type_id (src_object_type, src_object_id);' |
| Request 108 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '511', 'eGbR - eingetragene Gesellschaft bürgerlichen Rechts', 1);' |
| Request 109 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '512', 'Einzelunternehmen', 1);' |
| Request 110 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '513', 'PartG - Partnerschaftsgesellschaft', 1);' |
| Request 111 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '514', 'PartG mbB - Partnerschaftsgesellschaft mit beschränkter Berufshaftung', 1);' |
| Request 112 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '515', 'KGaA - Kommanditgesellschaft auf Aktien', 1);' |
| Request 113 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '516', 'GmbH & Co. KGaA - Gesellschaft mit beschränkter Haftung & Compagnie Kommanditgesellschaft auf Aktien', 1);' |
| Request 114 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '517', 'SE - Societas Europaea', 1);' |
| Request 115 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '518', 'Stiftung', 1);' |
| Request 116 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '519', 'gGmbH - gemeinnützige Gesellschaft mit beschränkter Haftung', 1);' |
| Request 117 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle, active) VALUES (5, '520', 'gUG - gemeinnützige Unternehmergesellschaft (haftungsbeschränkt)', 1);' |
| Request 118 sql='ALTER TABLE llx_oauth_token ADD COLUMN tokenstring_refresh text NULL AFTER tokenstring;' |
| Request 119 sql='ALTER TABLE llx_oauth_token ADD COLUMN expire_at datetime NULL AFTER lastaccess;' |
| Request 120 sql='ALTER TABLE llx_blockedlog ADD COLUMN linktoref text;' |
| Request 121 sql='ALTER TABLE llx_blockedlog DROP FOREIGN KEY fk_linktoref;' |
| Request 122 sql='ALTER TABLE llx_blockedlog DROP INDEX fk_linktoref;' |
| Request 123 sql='ALTER TABLE llx_blockedlog DROP INDEX idx_linktoref;' |
| Request 124 sql='ALTER TABLE llx_blockedlog MODIFY COLUMN linktoref text;' |
| Request 125 sql='ALTER TABLE llx_blockedlog ADD COLUMN linktype varchar(16);' |
| Request 126 sql='ALTER TABLE llx_blockedlog ADD COLUMN module_source varchar(32) DEFAULT '' AFTER action;' |
| Request 127 sql='ALTER TABLE llx_blockedlog ADD COLUMN amounts_taxexcl double(24,8) DEFAULT NULL AFTER amounts;' |
| Request 128 sql='ALTER TABLE llx_blockedlog ADD INDEX idx_linktoref (linktoref(255));' |
| Request 129 sql='ALTER TABLE llx_c_incoterms MODIFY code varchar(8) NOT NULL;' |
| Request 130 sql='INSERT INTO llx_c_incoterms (code, label, libelle, active) VALUES ('DPU', 'Delivered at Place Unloaded', 'Delivered at Place Unloaded, marchandises déchargées et livrées au lieu de destination désigné (remplace DAT, élargit les lieux de livraison possibles)', 1);' |
| Request 131 sql='INSERT INTO llx_c_incoterms (code, label, libelle, active) VALUES ('DTP', 'Delivered at Terminal Paid', 'Delivered at Terminal Paid, marchandises livrées et dédouanées dans un terminal du pays de destination', 0);' |
| Request 132 sql='INSERT INTO llx_c_incoterms (code, label, libelle, active) VALUES ('DPP', 'Delivered at Place Paid', 'Delivered at Place Paid, marchandises livrées et dédouanées à une adresse précise du pays de destination', 0);' |
| Request 133 sql='INSERT INTO llx_c_incoterms (code, label, libelle, active) VALUES ('DTP(DHL)', 'Duties and Taxes Paid', 'Duties and Taxes Paid (service DHL) : l''expéditeur paie les droits de douane et taxes à l''importation (spécifique à DHL)', 0);' |
| Request 134 sql='UPDATE llx_c_incoterms SET libelle = 'Cost and Freight, chargé dans le bateau, livraison au port de départ, frais payés jusqu''au port d''arrivée, sans assurance pour le transport, non déchargé du navire à destination (les frais de déchargement sont inclus ou non au port d''arrivée)' WHERE code = 'CFR';' |
| Request 135 sql='UPDATE llx_c_incoterms SET libelle = 'Cost, Insurance and Freight, chargé sur le bateau, frais jusqu''au port d''arrivée, avec l''assurance marchandise transportée souscrite par le vendeur pour le compte de l''acheteur (couverture standard, 10% de la valeur commerciale)' WHERE code = 'CIF';' |
| Request 136 sql='UPDATE llx_c_incoterms SET libelle = 'Carriage and Insurance Paid to, idem CPT, avec assurance marchandise transportée souscrite par le vendeur pour le compte de l''acheteur (couverture tous risques)' WHERE code = 'CIP';' |
| Request 137 sql='UPDATE llx_oauth_token SET tokenstring = token, token = NULL WHERE service = 'dolibarr_rest_api' AND tokenstring IS NULL AND token IS NOT NULL;' |
| Request 138 sql='ALTER TABLE llx_categorie_supplier_proposal ADD PRIMARY KEY pk_categorie_supplier_proposal (fk_categorie, fk_supplier_proposal);' |
| Request 139 sql='ALTER TABLE llx_categorie_supplier_proposal ADD INDEX idx_categorie_supplier_proposal_fk_categorie (fk_categorie);' |
| Request 140 sql='ALTER TABLE llx_categorie_supplier_proposal ADD INDEX idx_categorie_supplier_proposal_fk_supplier_proposal (fk_supplier_proposal);' |
| Request 141 sql='ALTER TABLE llx_categorie_supplier_proposal ADD CONSTRAINT fk_categorie_supplier_proposal_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
| Request 142 sql='ALTER TABLE llx_categorie_supplier_proposal ADD CONSTRAINT fk_categorie_supplier_proposal_fk_supplier_proposal_rowid FOREIGN KEY (fk_supplier_proposal) REFERENCES llx_supplier_proposal (rowid);' |
| Request 143 sql='ALTER TABLE llx_blockedlog DROP INDEX entity;' |
| Request 144 sql='ALTER TABLE llx_blockedlog DROP INDEX entity_action_certified;' |
| Request 145 sql='ALTER TABLE llx_blockedlog ADD INDEX idx_entity_action (entity,action);' |
| Request 146 sql='ALTER TABLE llx_blockedlog DROP COLUMN signature_line;' |
| Request 147 sql='ALTER TABLE llx_blockedlog ADD COLUMN actionrefisunique varchar(16) DEFAULT NULL;' |
| Request 148 sql='ALTER TABLE llx_blockedlog ADD INDEX idx_ref_object (ref_object);' |
| Request 149 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN matching_general tinyint DEFAULT 0 NOT NULL AFTER multicurrency_code;' |
| Request 150 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD COLUMN matching_general tinyint DEFAULT 0 NOT NULL AFTER multicurrency_code;' |
| Request 151 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'CDF', '[70,67]', 1, 'Congolese Franc');' |
| Request 152 sql='ALTER TABLE llx_societe MODIFY COLUMN mode_reglement integer;' |
| Request 153 sql='ALTER TABLE llx_ecm_files ADD COLUMN geolat double(24,8) DEFAULT NULL;' |
| Request 154 sql='ALTER TABLE llx_ecm_files ADD COLUMN geolong double(24,8) DEFAULT NULL;' |
| Request 155 sql='ALTER TABLE llx_ecm_files ADD COLUMN geopoint point DEFAULT NULL;' |
| Request 156 sql='ALTER TABLE llx_ecm_files ADD COLUMN georesultcode varchar(16) NULL;' |
| Request 157 sql='CREATE TABLE llx_expensereport_det_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 158 sql='ALTER TABLE llx_fichinterdet ADD COLUMN special_code integer DEFAULT 0 AFTER fk_parent_line;' |
| Request 159 sql='ALTER TABLE llx_fichinterdet ADD COLUMN product_type integer DEFAULT 0 AFTER special_code;' |
| Request 160 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN hour_close INTEGER DEFAULT null after year_close;' |
| Request 161 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN min_close INTEGER DEFAULT null after hour_close;' |
| Request 162 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN sec_close INTEGER DEFAULT null after min_close;' |
| Request 163 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN cash_declared double(24,8) DEFAULT null;' |
| Request 164 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN card_declared double(24,8) DEFAULT null;' |
| Request 165 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN cheque_declared double(24,8) DEFAULT null;' |
| Request 166 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN cash_lifetime double(24,8) DEFAULT null;' |
| Request 167 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN card_lifetime double(24,8) DEFAULT null;' |
| Request 168 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN cheque_lifetime double(24,8) DEFAULT null;' |
| Request 169 sql='ALTER TABLE llx_pos_cash_fence ADD COLUMN lifetime_start datetime DEFAULT NULL;' |
| Request 170 sql='UPDATE llx_cronjob set test = 'getDolDBType() == ''mysqli''' WHERE label = 'MakeLocalDatabaseDumpShort';' |
| Request 171 sql='UPDATE llx_cronjob set test = 'getDolGlobalString(''MAIN_ALLOW_BACKUP_BY_EMAIL'') && getDolDBType() == ''mysqli''' WHERE label = 'MakeSendLocalDatabaseDumpShort';' |
| Request 172 sql='UPDATE llx_c_socialnetworks SET icon = 'fa-mastodon' WHERE icon = '' AND code = 'mastodon';' |
| Request 173 sql='INSERT INTO llx_c_currencies ( code_iso, unicode, active, label ) VALUES ( 'PGK', '[75]', 1, 'Papua New Guinea Kina');' |
| Request 174 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, 'PCG25-DEV', 'The developed accountancy french plan 2025', 1);' |
| Request 175 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 4, 'PCG08-PYME-CAT', 'The PYME accountancy spanish plan in catalan language', 1);' |
| Request 176 sql='UPDATE llx_const SET name = 'MAIN_AUTHENTICATION_OIDC_ON' WHERE name = 'MAIN_MODULE_OPENIDCONNECT';' |
| Request 177 sql='CREATE TABLE llx_workstation_workstation_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 178 sql='ALTER TABLE llx_workstation_workstation_extrafields ADD INDEX idx_workstation_workstation_extrafields (fk_object);' |
| Request 179 sql='ALTER TABLE llx_adherent MODIFY COLUMN societe VARCHAR(128);' |
| Script processing | Success - Show-Hide details |
