|
| Choose migration script | 5.0.0-6.0.0.sql |
| Request 1 sql='ALTER TABLE llx_accounting_journal MODIFY code VARCHAR(20) CHARACTER SET utf8;' |
| Request 2 sql='ALTER TABLE llx_accounting_journal MODIFY code VARCHAR(20) COLLATE utf8_unicode_ci;' |
| Request 3 sql='ALTER TABLE llx_bank_account MODIFY accountancy_journal VARCHAR(20) CHARACTER SET utf8;' |
| Request 4 sql='ALTER TABLE llx_bank_account MODIFY accountancy_journal VARCHAR(20) COLLATE utf8_unicode_ci;' |
| Request 5 sql='ALTER TABLE llx_holiday_config MODIFY COLUMN name varchar(128);' |
| Request 6 sql='ALTER TABLE llx_supplier_proposaldet CHANGE COLUMN fk_askpricesupplier fk_supplier_proposal integer NOT NULL;' |
| Request 7 sql='SET sql_mode = 'ALLOW_INVALID_DATES';' |
| Request 8 sql='update llx_adherent set datefin = NULL where DATE(STR_TO_DATE(datefin, '%Y-%m-%d')) IS NULL;' |
| Request 9 sql='SET sql_mode = 'NO_ZERO_DATE';' |
| Request 10 sql='update llx_adherent set datefin = NULL where DATE(STR_TO_DATE(datefin, '%Y-%m-%d')) IS NULL;' |
| Request 11 sql='ALTER TABLE llx_opensurvey_sondage MODIFY COLUMN tms timestamp DEFAULT '2001-01-01 00:00:00';' |
| Request 12 sql='ALTER TABLE llx_adherent MODIFY COLUMN datefin datetime NULL;' |
| Request 13 sql='ALTER TABLE llx_chargesociales MODIFY COLUMN date_ech datetime DEFAULT NULL;' |
| Request 14 sql='ALTER TABLE llx_chargesociales MODIFY COLUMN date_ech datetime NOT NULL;' |
| Request 15 sql='SET sql_mode = 'ALLOW_INVALID_DATES';' |
| Request 16 sql='update llx_opensurvey_sondage set tms = date_fin where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' |
| Request 17 sql='SET sql_mode = 'NO_ZERO_DATE';' |
| Request 18 sql='update llx_opensurvey_sondage set tms = date_fin where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' |
| Request 19 sql='ALTER TABLE llx_opensurvey_sondage MODIFY COLUMN date_fin DATETIME NULL DEFAULT NULL;' |
| Request 20 sql='ALTER TABLE llx_opensurvey_sondage MODIFY COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 21 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN fk_user_creat integer NOT NULL DEFAULT 0;' |
| Request 22 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN status integer DEFAULT 1 after date_fin;' |
| Request 23 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN entity integer DEFAULT 1 NOT NULL;' |
| Request 24 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_comments tinyint NOT NULL DEFAULT 1;' |
| Request 25 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN allow_spy tinyint NOT NULL DEFAULT 1 AFTER allow_comments;' |
| Request 26 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN sujet TEXT;' |
| Request 27 sql='ALTER TABLE llx_socpeople MODIFY COLUMN zip varchar(25);' |
| Request 28 sql='ALTER TABLE llx_extrafields ADD COLUMN fieldcomputed text;' |
| Request 29 sql='ALTER TABLE llx_extrafields ADD COLUMN fielddefault varchar(255);' |
| Request 30 sql='ALTER TABLE llx_c_typent MODIFY COLUMN libelle varchar(64);' |
| Request 31 sql='ALTER TABLE llx_holiday ADD COLUMN ref varchar(30) NULL;' |
| Request 32 sql='ALTER TABLE llx_holiday ADD COLUMN ref_ext varchar(255);' |
| Request 33 sql='CREATE TABLE llx_notify_def_object ( id integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, objet_type varchar(16), objet_id integer NOT NULL, type_notif varchar(16) DEFAULT 'browser', date_notif datetime, user_id integer, moreparam varchar(255) )ENGINE=innodb;' |
| Request 34 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;' |
| Request 35 sql='ALTER TABLE llx_extrafields ADD COLUMN langs varchar(24);' |
| Request 36 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;' |
| Request 37 sql='ALTER TABLE llx_ecm_files ADD COLUMN ref varchar(128) AFTER rowid;' |
| Request 38 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN fullpath filepath varchar(255);' |
| Request 39 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN filepath filepath varchar(255);' |
| Request 40 sql='ALTER TABLE llx_ecm_files ADD COLUMN position integer;' |
| Request 41 sql='ALTER TABLE llx_ecm_files ADD COLUMN keyword varchar(750);' |
| Request 42 sql='ALTER TABLE llx_ecm_files CHANGE COLUMN keyword keyword varchar(750);' |
| Request 43 sql='ALTER TABLE llx_ecm_files ADD COLUMN gen_or_uploaded varchar(12);' |
| Request 44 sql='ALTER TABLE llx_ecm_files DROP INDEX uk_ecm_files;' |
| Request 45 sql='ALTER TABLE llx_ecm_files ADD UNIQUE INDEX uk_ecm_files (filepath, filename, entity);' |
| Request 46 sql='ALTER TABLE llx_ecm_files ADD INDEX idx_ecm_files_label (label);' |
| Request 47 sql='ALTER TABLE llx_expedition ADD COLUMN fk_projet integer DEFAULT NULL after fk_soc;' |
| Request 48 sql='ALTER TABLE llx_holiday ADD COLUMN import_key varchar(14);' |
| Request 49 sql='ALTER TABLE llx_holiday ADD COLUMN extraparams varchar(255);' |
| Request 50 sql='ALTER TABLE llx_expensereport ADD COLUMN import_key varchar(14);' |
| Request 51 sql='ALTER TABLE llx_expensereport ADD COLUMN extraparams varchar(255);' |
| Request 52 sql='ALTER TABLE llx_actioncomm ADD COLUMN import_key varchar(14);' |
| Request 53 sql='ALTER TABLE llx_actioncomm ADD COLUMN extraparams varchar(255);' |
| Request 54 sql='ALTER TABLE llx_bank_account ADD COLUMN extraparams varchar(255);' |
| Request 55 sql='ALTER TABLE llx_bank ADD COLUMN numero_compte varchar(32) NULL;' |
| Request 56 sql='ALTER TABLE llx_bank_account MODIFY COLUMN state_id integer DEFAULT NULL;' |
| Request 57 sql='ALTER TABLE llx_adherent MODIFY COLUMN state_id integer DEFAULT NULL;' |
| Request 58 sql='ALTER TABLE llx_adherent MODIFY COLUMN country integer DEFAULT NULL;' |
| Request 59 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',30);' |
| Request 60 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',30);' |
| Request 61 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',30);' |
| Request 62 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','expense_report',201);' |
| Request 63 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','expense_report',201);' |
| Request 64 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','expense_report',202);' |
| Request 65 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','expense_report',203);' |
| Request 66 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('EXPENSE_REPORT_PAYED','Expense report billed','Executed when an expense report is set as billed','expense_report',204);' |
| Request 67 sql='ALTER TABLE llx_c_email_templates ADD COLUMN content_lines text;' |
| Request 68 sql='ALTER TABLE llx_loan ADD COLUMN fk_projet integer DEFAULT NULL;' |
| Request 69 sql='ALTER TABLE llx_holiday ADD COLUMN fk_user_modif integer;' |
| Request 70 sql='ALTER TABLE llx_projet ADD COLUMN fk_user_modif integer;' |
| Request 71 sql='ALTER TABLE llx_projet_task ADD COLUMN fk_user_modif integer;' |
| Request 72 sql='ALTER TABLE llx_projet_task_time ADD COLUMN datec date;' |
| Request 73 sql='ALTER TABLE llx_projet_task_time ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 74 sql='ALTER TABLE llx_product_price ADD COLUMN fk_multicurrency integer;' |
| Request 75 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_code varchar(255);' |
| Request 76 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' |
| Request 77 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' |
| Request 78 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' |
| Request 79 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN fk_user_creat integer;' |
| Request 80 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN fk_user_modif integer;' |
| Request 81 sql='ALTER TABLE llx_product_price_by_qty DROP COLUMN date_price;' |
| Request 82 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 83 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN import_key varchar(14);' |
| Request 84 sql='ALTER TABLE llx_user ADD COLUMN import_key varchar(14);' |
| Request 85 sql='ALTER TABLE llx_facture_rec ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 86 sql='UPDATE llx_facture_rec SET tms = datec where tms < '2000-01-01';' |
| Request 87 sql='CREATE TABLE llx_product_attribute ( rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT, ref VARCHAR(255) NOT NULL, label VARCHAR(255) NOT NULL, rang INT DEFAULT 0 NOT NULL, entity INT DEFAULT 1 NOT NULL );' |
| Request 88 sql='ALTER TABLE llx_product_attribute ADD CONSTRAINT unique_ref UNIQUE (ref);' |
| Request 89 sql='CREATE TABLE llx_product_attribute_value ( rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT, fk_product_attribute INT NOT NULL, ref VARCHAR(255) DEFAULT NULL, value VARCHAR(255) DEFAULT NULL, entity INT DEFAULT 1 NOT NULL );' |
| Request 90 sql='ALTER TABLE llx_product_attribute_value ADD CONSTRAINT unique_ref UNIQUE (fk_product_attribute,ref);' |
| Request 91 sql='CREATE TABLE llx_product_attribute_combination2val ( rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT, fk_prod_combination INT NOT NULL, fk_prod_attr INT NOT NULL, fk_prod_attr_val INT NOT NULL );' |
| Request 92 sql='CREATE TABLE llx_product_attribute_combination ( rowid INT PRIMARY KEY NOT NULL AUTO_INCREMENT, fk_product_parent INT NOT NULL, fk_product_child INT NOT NULL, variation_price FLOAT NOT NULL, variation_price_percentage INT NULL, variation_weight FLOAT NOT NULL, entity INT DEFAULT 1 NOT NULL );' |
| Request 93 sql='ALTER TABLE llx_bank_account DROP FOREIGN KEY bank_fk_accountancy_journal;' |
| Request 94 sql='ALTER TABLE llx_accounting_journal ADD COLUMN entity integer DEFAULT 1;' |
| Request 95 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (1,'VT', 'Sale journal', 2, 1);' |
| Request 96 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (2,'AC', 'Purchase journal', 3, 1);' |
| Request 97 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (3,'BQ', 'Bank journal', 4, 1);' |
| Request 98 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (4,'OD', 'Other journal', 1, 1);' |
| Request 99 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (5,'AN', 'Has new journal', 9, 1);' |
| Request 100 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (6,'ER', 'Expense report journal', 5, 1);' |
| Request 101 sql='UPDATE llx_accounting_journal SET nature = 1 WHERE code = 'OD' AND nature = 0;' |
| Request 102 sql='UPDATE llx_accounting_journal SET nature = 2 WHERE code = 'VT' AND nature = 1;' |
| Request 103 sql='UPDATE llx_accounting_journal SET nature = 3 WHERE code = 'AC' AND nature = 2;' |
| Request 104 sql='UPDATE llx_accounting_journal SET nature = 4 WHERE (code = 'BK' OR code = 'BQ') AND nature = 3;' |
| Request 105 sql='UPDATE llx_bank_account SET accountancy_journal = 'BQ' WHERE accountancy_journal = 'BK';' |
| Request 106 sql='UPDATE llx_bank_account SET accountancy_journal = 'OD' WHERE accountancy_journal IS NULL;' |
| Request 107 sql='ALTER TABLE llx_bank_account ADD COLUMN fk_accountancy_journal integer;' |
| Request 108 sql='ALTER TABLE llx_bank_account ADD INDEX idx_fk_accountancy_journal (fk_accountancy_journal);' |
| Request 109 sql='UPDATE llx_bank_account AS ba SET fk_accountancy_journal = (SELECT rowid FROM llx_accounting_journal AS aj WHERE ba.accountancy_journal = aj.code AND aj.entity = ba.entity) WHERE accountancy_journal NOT IN ('1', '2', '3', '4', '5', '6', '5', '8', '9', '10', '11', '12', '13', '14', '15');' |
| Request 110 sql='ALTER TABLE llx_bank_account ADD CONSTRAINT fk_bank_account_accountancy_journal FOREIGN KEY (fk_accountancy_journal) REFERENCES llx_accounting_journal (rowid);' |
| Request 111 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_tiers varchar(32);' |
| Request 112 sql='ALTER TABLE llx_accounting_bookkeeping CHANGE COLUMN code_tiers thirdparty_code varchar(32);' |
| Request 113 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN subledger_account varchar(32);' |
| Request 114 sql='ALTER TABLE llx_accounting_bookkeeping CHANGE COLUMN thirdparty_label subledger_label varchar(255);' |
| Request 115 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN subledger_label varchar(255) AFTER subledger_account;' |
| Request 116 sql='UPDATE llx_accounting_bookkeeping SET subledger_account = numero_compte WHERE subledger_account IS NULL;' |
| Request 117 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN label_compte varchar(255);' |
| Request 118 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32);' |
| Request 119 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN label_operation varchar(255) AFTER label_compte;' |
| Request 120 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN multicurrency_amount double AFTER sens;' |
| Request 121 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN multicurrency_code varchar(255) AFTER multicurrency_amount;' |
| Request 122 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN lettering_code varchar(255) AFTER multicurrency_code;' |
| Request 123 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_lettering datetime AFTER lettering_code;' |
| Request 124 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN journal_label varchar(255) AFTER code_journal;' |
| Request 125 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_validated datetime AFTER validated;' |
| Request 126 sql='DROP TABLE llx_accounting_bookkeeping_tmp;' |
| Request 127 sql='CREATE TABLE llx_accounting_bookkeeping_tmp ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, doc_date date NOT NULL, doc_type varchar(30) NOT NULL, doc_ref varchar(300) NOT NULL, fk_doc integer NOT NULL, fk_docdet integer NOT NULL, thirdparty_code varchar(32), subledger_account varchar(32), subledger_label varchar(255), numero_compte varchar(32), label_compte varchar(255) NOT NULL, label_operation varchar(255), debit double(24,8) NOT NULL, credit double(24,8) NOT NULL, montant double(24,8) NOT NULL, sens varchar(1) DEFAULT NULL, multicurrency_amount double(24,8), multicurrency_code varchar(255), lettering_code varchar(255), date_lettering datetime, fk_user_author integer NOT NULL, fk_user_modif integer, date_creation datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, import_key varchar(14), code_journal varchar(32) NOT NULL, journal_label varchar(255), piece_num integer NOT NULL, validated tinyint DEFAULT 0 NOT NULL, date_validated datetime ) ENGINE=innodb;' |
| Request 128 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_doc_date (doc_date);' |
| Request 129 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_fk_docdet (fk_docdet);' |
| Request 130 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_numero_compte (numero_compte);' |
| Request 131 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD INDEX idx_accounting_bookkeeping_tmp_code_journal (code_journal);' |
| Request 132 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN debit double(24,8);' |
| Request 133 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN credit double(24,8);' |
| Request 134 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN montant double(24,8);' |
| Request 135 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN multicurrency_amount double(24,8);' |
| Request 136 sql='ALTER TABLE llx_paiementfourn ADD COLUMN model_pdf varchar(255);' |
| Request 137 sql='ALTER TABLE llx_paiementfourn ADD COLUMN fk_user_modif integer AFTER fk_user_author;' |
| Request 138 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 139 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 140 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 141 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_REPORT_PAYED','Expense report billed','Executed when an expense report is set as billed','expensereport',204);' |
| Request 142 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_CREATE' ,'Leave request created','Executed when a leave request is created','holiday',221);' |
| Request 143 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Leave request validated','Executed when a leave request is validated','holiday',222);' |
| Request 144 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE' ,'Leave request approved','Executed when a leave request is approved','holiday',223);' |
| Request 145 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN fk_invoice_supplier_line integer;' |
| Request 146 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN fk_invoice_supplier integer;' |
| Request 147 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN fk_invoice_supplier_source integer;' |
| Request 148 sql='ALTER TABLE llx_societe_remise_except ADD CONSTRAINT fk_soc_remise_fk_invoice_supplier_line FOREIGN KEY (fk_invoice_supplier_line) REFERENCES llx_facture_fourn_det (rowid);' |
| Request 149 sql='ALTER TABLE llx_societe_remise_except ADD CONSTRAINT fk_societe_remise_fk_invoice_supplier FOREIGN KEY (fk_invoice_supplier) REFERENCES llx_facture_fourn (rowid);' |
| Request 150 sql='ALTER TABLE llx_societe_remise_except ADD CONSTRAINT fk_societe_remise_fk_invoice_supplier_source FOREIGN KEY (fk_invoice_supplier) REFERENCES llx_facture_fourn (rowid);' |
| Request 151 sql='ALTER TABLE llx_facture_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '';' |
| Request 152 sql='ALTER TABLE llx_expensereport_det ADD COLUMN vat_src_code varchar(10) DEFAULT '';' |
| Request 153 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ADHERENT_BANK_USE_AUTO')__;' |
| Request 154 sql='UPDATE llx_const SET value = __ENCRYPT('moono-lisa')__ WHERE value = __ENCRYPT('moono')__ AND name = __ENCRYPT('FCKEDITOR_SKIN')__;' |
| Request 155 sql='DELETE FROM llx_document_model where nom = 'fsfe.fr.php' and type='donation';' |
| Request 156 sql='ALTER TABLE llx_product_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' |
| Request 157 sql='ALTER TABLE llx_product_customer_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' |
| Request 158 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' |
| Request 159 sql='ALTER TABLE llx_user ADD COLUMN model_pdf varchar(255);' |
| Request 160 sql='ALTER TABLE llx_usergroup ADD COLUMN model_pdf varchar(255);' |
| Request 161 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('PRODUCT_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/products')__, 'chaine', 0, '');' |
| Request 162 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('CONTRACT_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/contracts')__, 'chaine', 0, '');' |
| Request 163 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('USERGROUP_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/usergroups')__, 'chaine', 0, '');' |
| Request 164 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('USER_ADDON_PDF_ODT_PATH')__, 1, __ENCRYPT('DOL_DATA_ROOT/doctemplates/users')__, 'chaine', 0, '');' |
| Request 165 sql='INSERT INTO llx_const (name, entity, value, type, visible, note) VALUES (__ENCRYPT('MAIN_ENABLE_OVERWRITE_TRANSLATION')__, 1, __ENCRYPT('1')__, 'chaine', 0, 'Enable overwrote of translation');' |
| Request 166 sql='ALTER TABLE llx_chargesociales ADD COLUMN ref varchar(16);' |
| Request 167 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_projet integer DEFAULT NULL;' |
| Request 168 sql='ALTER TABLE llx_cronjob ADD COLUMN processing integer NOT NULL DEFAULT 0;' |
| Request 169 sql='ALTER TABLE llx_website ADD COLUMN fk_user_create integer;' |
| Request 170 sql='ALTER TABLE llx_website ADD COLUMN fk_user_modif integer;' |
| Request 171 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' |
| Request 172 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' |
| Request 173 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_multicurrency integer;' |
| Request 174 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_code varchar(255);' |
| Request 175 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' |
| Request 176 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' |
| Request 177 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' |
| Request 178 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN fk_multicurrency integer;' |
| Request 179 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_code varchar(255);' |
| Request 180 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' |
| Request 181 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' |
| Request 182 sql='ALTER TABLE llx_product_fournisseur_price_log ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' |
| Request 183 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN default_vat_code varchar(10);' |
| Request 184 sql='UPDATE llx_contrat SET ref = rowid WHERE ref IS NULL OR ref = '';' |
| Request 185 sql='ALTER TABLE llx_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '';' |
| Request 186 sql='CREATE TABLE llx_payment_various ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, datec datetime, datep date, datev date, sens smallint DEFAULT 0 NOT NULL, amount double(24,8) DEFAULT 0 NOT NULL, fk_typepayment integer NOT NULL, num_payment varchar(50), label varchar(255), accountancy_code varchar(32), entity integer DEFAULT 1 NOT NULL, note text, fk_bank integer, fk_user_author integer, fk_user_modif integer )ENGINE=innodb;' |
| Request 187 sql='CREATE TABLE llx_default_values ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, type varchar(10), user_id integer DEFAULT 0 NOT NULL, page varchar(255), param varchar(255), value varchar(128) )ENGINE=innodb;' |
| Request 188 sql='ALTER TABLE llx_default_values ADD UNIQUE INDEX uk_default_values(type, entity, user_id, page, param);' |
| Request 189 sql='ALTER TABLE llx_supplier_proposaldet ADD INDEX idx_supplier_proposaldet_fk_supplier_proposal (fk_supplier_proposal);' |
| Request 190 sql='ALTER TABLE llx_supplier_proposaldet ADD INDEX idx_supplier_proposaldet_fk_product (fk_product);' |
| Request 191 sql='UPDATE llx_supplier_proposaldet SET fk_unit = NULL where fk_unit not in (SELECT rowid from llx_c_units);' |
| Request 192 sql='ALTER TABLE llx_supplier_proposaldet ADD CONSTRAINT fk_supplier_proposaldet_fk_unit FOREIGN KEY (fk_unit) REFERENCES llx_c_units (rowid);' |
| Request 193 sql='ALTER TABLE llx_supplier_proposaldet ADD CONSTRAINT fk_supplier_proposaldet_fk_supplier_proposal FOREIGN KEY (fk_supplier_proposal) REFERENCES llx_supplier_proposal (rowid);' |
| Request 194 sql='CREATE TABLE llx_inventory ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 0, ref varchar(48), datec datetime DEFAULT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_author integer, fk_user_modif integer, fk_user_valid integer, fk_warehouse integer DEFAULT 0, status integer DEFAULT 0, title varchar(255) NOT NULL, date_inventory datetime DEFAULT NULL, import_key varchar(14) )ENGINE=InnoDB;' |
| Request 195 sql='CREATE TABLE llx_inventorydet ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, datec datetime DEFAULT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_inventory integer DEFAULT 0, fk_warehouse integer DEFAULT 0, fk_product integer DEFAULT 0, batch varchar(30) DEFAULT NULL, qty_view double DEFAULT NULL, qty_stock double DEFAULT NULL, qty_regulated double DEFAULT NULL, pmp double DEFAULT 0, pa double DEFAULT 0, new_pmp double DEFAULT 0 )ENGINE=InnoDB;' |
| Request 196 sql='ALTER TABLE llx_inventory ADD COLUMN datec datetime DEFAULT NULL;' |
| Request 197 sql='ALTER TABLE llx_inventory ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 198 sql='ALTER TABLE llx_inventory ADD INDEX idx_inventory_tms (tms);' |
| Request 199 sql='ALTER TABLE llx_inventory ADD INDEX idx_inventory_datec (datec);' |
| Request 200 sql='ALTER TABLE llx_inventorydet ADD INDEX idx_inventorydet_tms (tms);' |
| Request 201 sql='ALTER TABLE llx_inventorydet ADD INDEX idx_inventorydet_datec (datec);' |
| Request 202 sql='ALTER TABLE llx_inventorydet ADD INDEX idx_inventorydet_fk_inventory (fk_inventory);' |
| Request 203 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,note,active) VALUES (1, '8.5', '85', '0','VAT standard rate (DOM sauf Guyane et Saint-Martin)',0);' |
| Request 204 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,note,active) VALUES (1, '8.5', '85NPR', '1','VAT standard rate (DOM sauf Guyane et Saint-Martin), non perçu par le vendeur mais récupérable par acheteur',0);' |
| Request 205 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,localtax1,localtax1_type,note,active) VALUES (1, '8.5', '85NPROM', '1', 2, 3, 'VAT standard rate (DOM sauf Guyane et Saint-Martin), NPR, Octroi de Mer',0);' |
| Request 206 sql='INSERT INTO llx_c_tva(fk_pays,taux,code,recuperableonly,localtax1,localtax1_type,localtax2,localtax2_type,note,active) VALUES (1, '8.5', '85NPROMOMR', '1', 2, 3, 2.5, 3, 'VAT standard rate (DOM sauf Guyane et Saint-Martin), NPR, Octroi de Mer et Octroi de Mer Regional',0);' |
| Request 207 sql='ALTER TABLE llx_events MODIFY COLUMN ip varchar(250);' |
| Request 208 sql='ALTER TABLE llx_facture ADD COLUMN fk_fac_rec_source integer;' |
| Request 209 sql='DELETE FROM llx_c_actioncomm WHERE code IN ('AC_PROP','AC_COM','AC_FAC','AC_SHIP','AC_SUP_ORD','AC_SUP_INV') AND id NOT IN (SELECT DISTINCT fk_action FROM llx_actioncomm);' |
| Request 210 sql='DELETE FROM llx_categorie_product WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 0);' |
| Request 211 sql='DELETE FROM llx_categorie_societe WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type IN (1, 2));' |
| Request 212 sql='DELETE FROM llx_categorie_member WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 3);' |
| Request 213 sql='DELETE FROM llx_categorie_contact WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 4);' |
| Request 214 sql='DELETE FROM llx_categorie_project WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie WHERE type = 6);' |
| Request 215 sql='ALTER TABLE llx_inventory ADD COLUMN ref varchar(48);' |
| Request 216 sql='CREATE TABLE llx_loan_schedule ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_loan integer, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, datep datetime, amount_capital real DEFAULT 0, amount_insurance real DEFAULT 0, amount_interest real DEFAULT 0, fk_typepayment integer NOT NULL, num_payment varchar(50), note_private text, note_public text, fk_bank integer NOT NULL, fk_user_creat integer, fk_user_modif integer )ENGINE=innodb;' |
| Request 217 sql='ALTER TABLE llx_tva ADD COLUMN datec date AFTER tms;' |
| Request 218 sql='ALTER TABLE llx_user_rights ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;' |
| Request 219 sql='ALTER TABLE llx_user_rights DROP FOREIGN KEY fk_user_rights_fk_user_user;' |
| Request 220 sql='ALTER TABLE llx_user_rights DROP INDEX uk_user_rights;' |
| Request 221 sql='ALTER TABLE llx_user_rights DROP INDEX fk_user;' |
| Request 222 sql='ALTER TABLE llx_user_rights ADD UNIQUE INDEX uk_user_rights (entity, fk_user, fk_id);' |
| Request 223 sql='DELETE FROM llx_user_rights WHERE fk_user NOT IN (select rowid from llx_user);' |
| Request 224 sql='ALTER TABLE llx_user_rights ADD CONSTRAINT fk_user_rights_fk_user_user FOREIGN KEY (fk_user) REFERENCES llx_user (rowid);' |
| Request 225 sql='ALTER TABLE llx_usergroup_rights ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;' |
| Request 226 sql='ALTER TABLE llx_usergroup_rights DROP FOREIGN KEY fk_usergroup_rights_fk_usergroup;' |
| Request 227 sql='ALTER TABLE llx_usergroup_rights DROP INDEX fk_usergroup;' |
| Request 228 sql='ALTER TABLE llx_usergroup_rights ADD UNIQUE INDEX uk_usergroup_rights (entity, fk_usergroup, fk_id);' |
| Request 229 sql='ALTER TABLE llx_usergroup_rights ADD CONSTRAINT fk_usergroup_rights_fk_usergroup FOREIGN KEY (fk_usergroup) REFERENCES llx_usergroup (rowid);' |
| Request 230 sql='CREATE TABLE llx_website_page ( rowid integer AUTO_INCREMENT NOT NULL PRIMARY KEY, fk_website integer NOT NULL, pageurl varchar(16) NOT NULL, title varchar(255), description varchar(255), keywords varchar(255), content mediumtext, status integer, fk_user_create integer, fk_user_modif integer, date_creation datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=innodb;' |
| Request 231 sql='ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);' |
| Request 232 sql='ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERENCES llx_website (rowid);' |
| Request 233 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;' |
| Request 234 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;' |
| Request 235 sql='UPDATE llx_extrafields set elementtype='categorie' where elementtype='categories';' |
| Request 236 sql='CREATE TABLE llx_blockedlog ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, action varchar(50), amounts real NOT NULL, signature varchar(100) NOT NULL, signature_line varchar(100) NOT NULL, element varchar(50), fk_object integer, ref_object varchar(100), date_object datetime, object_data text, fk_user integer, entity integer DEFAULT 1 NOT NULL, certified integer ) ENGINE=innodb;' |
| Request 237 sql='ALTER TABLE llx_blockedlog ADD INDEX signature (signature);' |
| Request 238 sql='ALTER TABLE llx_blockedlog ADD INDEX fk_object_element (fk_object,element);' |
| Request 239 sql='ALTER TABLE llx_blockedlog ADD INDEX entity (entity);' |
| Request 240 sql='ALTER TABLE llx_blockedlog ADD INDEX fk_user (fk_user);' |
| Request 241 sql='ALTER TABLE llx_blockedlog ADD INDEX entity_action (entity,action);' |
| Request 242 sql='ALTER TABLE llx_blockedlog ADD INDEX entity_action_certified (entity,action,certified);' |
| Request 243 sql='CREATE TABLE llx_blockedlog_authority ( rowid integer AUTO_INCREMENT PRIMARY KEY, blockchain longtext NOT NULL, signature varchar(100) NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=innodb;' |
| Request 244 sql='ALTER TABLE llx_blockedlog_authority ADD INDEX signature (signature);' |
| Request 245 sql='INSERT IGNORE INTO llx_product_lot (entity, fk_product, batch, eatby, sellby, datec, fk_user_creat, fk_user_modif) SELECT DISTINCT e.entity, ps.fk_product, pb.batch, pb.eatby, pb.sellby, pb.tms, e.fk_user_author, e.fk_user_author from llx_product_batch as pb, llx_product_stock as ps, llx_entrepot as e WHERE pb.fk_product_stock = ps.rowid AND ps.fk_entrepot = e.rowid;' |
| Request 246 sql='UPDATE llx_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';' |
| Request 247 sql='UPDATE llx_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';' |
| Request 248 sql='UPDATE llx_bank SET label= '(payment_salary)' WHERE label LIKE 'Règlement salaire';' |
| Request 249 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN source_url varchar(255);' |
| Request 250 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 251 sql='ALTER TABLE llx_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);' |
| Request 252 sql='CREATE TABLE llx_facturedet_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 253 sql='ALTER TABLE llx_facturedet_rec_extrafields ADD INDEX idx_facturedet_rec_extrafields (fk_object);' |
| Request 254 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1178, 117, 'C+S-5', 0, 2.5, '1', 2.5, '1', 0, 'CGST+SGST - Same state sales', 1);' |
| Request 255 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1179, 117, 'I-5' , 5, 0, '0', 0, '0', 0, 'IGST', 1);' |
| Request 256 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1180, 117, 'C+S-12', 0, 6, '1', 6, '1', 0, 'CGST+SGST - Same state sales', 1);' |
| Request 257 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1181, 117, 'I-12' , 12, 0, '0', 0, '0', 0, 'IGST', 1);' |
| Request 258 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1176, 117, 'C+S-18', 0, 9, '1', 9, '1', 0, 'CGST+SGST - Same state sales', 1);' |
| Request 259 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1177, 117, 'I-18' , 18, 0, '0', 0, '0', 0, 'IGST', 1);' |
| Request 260 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1182, 117, 'C+S-28', 0, 14, '1', 14, '1', 0, 'CGST+SGST - Same state sales', 1);' |
| Request 261 sql='insert into llx_c_tva(rowid,fk_pays,code,taux,localtax1,localtax1_type,localtax2,localtax2_type,recuperableonly,note,active) values (1183, 117, 'I-28' , 28, 0, '0', 0, '0', 0, 'IGST', 1);' |
| Script processing | OK - Show-Hide details |
