|
Choose migration script | 6.0.0-7.0.0.sql |
Request 1 sql='ALTER TABLE llx_product ADD COLUMN accountancy_code_sell_intra varchar(32) AFTER accountancy_code_sell;' |
Request 2 sql='ALTER TABLE llx_product ADD COLUMN accountancy_code_sell_export varchar(32) AFTER accountancy_code_sell_intra;' |
Request 3 sql='ALTER TABLE llx_accounting_account DROP FOREIGN KEY fk_accountingaccount_fk_pcg_version;' |
Request 4 sql='ALTER TABLE llx_accounting_account DROP FOREIGN KEY fk_accounting_account_fk_pcg_version;' |
Request 5 sql='SET sql_mode = 'ALLOW_INVALID_DATES';' |
Request 6 sql='update llx_accounting_account set tms = datec where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' |
Request 7 sql='SET sql_mode = 'NO_ZERO_DATE';' |
Request 8 sql='update llx_accounting_account set tms = datec where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' |
Request 9 sql='ALTER TABLE llx_accounting_account MODIFY fk_pcg_version VARCHAR(20) CHARACTER SET utf8;' |
Request 10 sql='ALTER TABLE llx_accounting_account MODIFY fk_pcg_version VARCHAR(20) COLLATE utf8_unicode_ci;' |
Request 11 sql='ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) CHARACTER SET utf8;' |
Error DB_ERROR_3780: ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) CHARACTER SET utf8; Referencing column 'fk_pcg_version' and referenced column 'pcg_version' in foreign key constraint 'fk_accountingaccount_fk_pcg_version' are incompatible. |
Request 12 sql='ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) COLLATE utf8_unicode_ci;' |
Error DB_ERROR_3780: ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) COLLATE utf8_unicode_ci; Referencing column 'fk_pcg_version' and referenced column 'pcg_version' in foreign key constraint 'fk_accountingaccount_fk_pcg_version' are incompatible. |
Request 13 sql='ALTER TABLE llx_accounting_account MODIFY account_number VARCHAR(20) CHARACTER SET utf8;' |
Request 14 sql='ALTER TABLE llx_accounting_account MODIFY account_number VARCHAR(20) COLLATE utf8_unicode_ci;' |
Request 15 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY numero_compte VARCHAR(20) CHARACTER SET utf8;' |
Request 16 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY numero_compte VARCHAR(20) COLLATE utf8_unicode_ci;' |
Request 17 sql='ALTER TABLE llx_accounting_journal MODIFY code VARCHAR(20) CHARACTER SET utf8;' |
Request 18 sql='ALTER TABLE llx_accounting_journal MODIFY code VARCHAR(20) COLLATE utf8_unicode_ci;' |
Request 19 sql='ALTER TABLE llx_bank_account MODIFY accountancy_journal VARCHAR(20) CHARACTER SET utf8;' |
Request 20 sql='ALTER TABLE llx_bank_account MODIFY accountancy_journal VARCHAR(20) COLLATE utf8_unicode_ci;' |
Request 21 sql='ALTER TABLE llx_stock_mouvement MODIFY batch VARCHAR(30) CHARACTER SET utf8;' |
Request 22 sql='ALTER TABLE llx_stock_mouvement MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;' |
Request 23 sql='ALTER TABLE llx_product_lot MODIFY batch VARCHAR(30) CHARACTER SET utf8;' |
Request 24 sql='ALTER TABLE llx_product_lot MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;' |
Request 25 sql='ALTER TABLE llx_expeditiondet_batch MODIFY batch VARCHAR(30) CHARACTER SET utf8;' |
Request 26 sql='ALTER TABLE llx_expeditiondet_batch MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;' |
Request 27 sql='ALTER TABLE llx_product_batch MODIFY batch VARCHAR(30) CHARACTER SET utf8;' |
Request 28 sql='ALTER TABLE llx_product_batch MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;' |
Request 29 sql='ALTER TABLE llx_product MODIFY accountancy_code_sell VARCHAR(32) CHARACTER SET utf8;' |
Request 30 sql='ALTER TABLE llx_product MODIFY accountancy_code_sell VARCHAR(32) COLLATE utf8_unicode_ci;' |
Request 31 sql='ALTER TABLE llx_product MODIFY accountancy_code_sell_intra VARCHAR(32) CHARACTER SET utf8;' |
Request 32 sql='ALTER TABLE llx_product MODIFY accountancy_code_sell_intra VARCHAR(32) COLLATE utf8_unicode_ci;' |
Request 33 sql='ALTER TABLE llx_product MODIFY accountancy_code_sell_export VARCHAR(32) CHARACTER SET utf8;' |
Request 34 sql='ALTER TABLE llx_product MODIFY accountancy_code_sell_export VARCHAR(32) COLLATE utf8_unicode_ci;' |
Request 35 sql='ALTER TABLE llx_product MODIFY accountancy_code_buy VARCHAR(32) CHARACTER SET utf8;' |
Request 36 sql='ALTER TABLE llx_product MODIFY accountancy_code_buy VARCHAR(32) COLLATE utf8_unicode_ci;' |
Request 37 sql='ALTER TABLE llx_c_type_fees MODIFY accountancy_code VARCHAR(32) CHARACTER SET utf8;' |
Request 38 sql='ALTER TABLE llx_c_type_fees MODIFY accountancy_code VARCHAR(32) COLLATE utf8_unicode_ci;' |
Request 39 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 40 sql='ALTER TABLE llx_user MODIFY login varchar(50) NOT NULL;' |
Request 41 sql='ALTER TABLE llx_product_price ADD COLUMN fk_multicurrency integer;' |
Request 42 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_code varchar(255);' |
Request 43 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' |
Request 44 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' |
Request 45 sql='ALTER TABLE llx_product_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' |
Request 46 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN default_vat_code varchar(10);' |
Request 47 sql='ALTER TABLE llx_product_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' |
Request 48 sql='ALTER TABLE llx_product_customer_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' |
Request 49 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;' |
Request 50 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;' |
Request 51 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;' |
Request 52 sql='ALTER TABLE llx_website_page ADD COLUMN type_container varchar(16) NOT NULL DEFAULT 'page';' |
Request 53 sql='delete from llx_c_action_trigger where code = 'MEMBER_SUBSCRIPTION';' |
Request 54 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SUBSCRIPTION_CREATE','Member subscribtion recorded','Executed when a member subscribtion is deleted','member',24);' |
Request 55 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SUBSCRIPTION_MODIFY','Member subscribtion modified','Executed when a member subscribtion is modified','member',24);' |
Request 56 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SUBSCRIPTION_DELETE','Member subscribtion deleted','Executed when a member subscribtion is deleted','member',24);' |
Request 57 sql='ALTER TABLE llx_product_attribute_value DROP INDEX unique_ref;' |
Request 58 sql='ALTER TABLE llx_product_attribute_value ADD UNIQUE INDEX uk_product_attribute_value (fk_product_attribute, ref);' |
Request 59 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN quantity double DEFAULT NULL;' |
Request 60 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN unitprice double(24,8) DEFAULT 0;' |
Request 61 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN price_base_type varchar(3) DEFAULT 'HT';' |
Request 62 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN fk_multicurrency integer;' |
Request 63 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN multicurrency_code varchar(255);' |
Request 64 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;' |
Request 65 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;' |
Request 66 sql='ALTER TABLE llx_product_price_by_qty ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;' |
Request 67 sql='DROP INDEX uk_product_price_by_qty_level on llx_product_price_by_qty;' |
Request 68 sql='ALTER TABLE llx_product_price_by_qty ADD UNIQUE INDEX uk_product_price_by_qty_level (fk_product_price, quantity);' |
Request 69 sql='ALTER TABLE llx_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_fk_doc (fk_doc);' |
Request 70 sql='ALTER TABLE llx_c_revenuestamp ADD COLUMN revenuestamp_type varchar(16) DEFAULT 'fixed' NOT NULL;' |
Request 71 sql='UPDATE llx_contrat SET ref = rowid WHERE ref IS NULL OR ref = '';' |
Request 72 sql='ALTER TABLE llx_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '';' |
Request 73 sql='INSERT INTO llx_c_type_contact(rowid, element, source, code, libelle, active ) values (42, 'propal', 'external', 'SHIPPING', 'Customer contact for delivery', 1);' |
Request 74 sql='ALTER TABLE llx_inventory ADD date_validation datetime DEFAULT NULL;' |
Request 75 sql='ALTER TABLE llx_inventory CHANGE COLUMN datec date_creation datetime DEFAULT NULL;' |
Request 76 sql='ALTER TABLE llx_inventory CHANGE COLUMN fk_user_author fk_user_creat integer;' |
Request 77 sql='ALTER TABLE llx_inventory ADD UNIQUE INDEX uk_inventory_ref (ref, entity);' |
Request 78 sql='ALTER table llx_entrepot CHANGE COLUMN label ref varchar(255);' |
Request 79 sql='UPDATE llx_paiementfourn SET ref = rowid WHERE ref IS NULL;' |
Request 80 sql='UPDATE llx_paiementfourn SET entity = 1 WHERE entity IS NULL;' |
Request 81 sql='UPDATE llx_website SET entity = 1 WHERE entity IS NULL;' |
Request 82 sql='ALTER TABLE llx_website MODIFY COLUMN entity integer NOT NULL DEFAULT 1;' |
Request 83 sql='ALTER TABLE llx_user ADD COLUMN birth date;' |
Request 84 sql='ALTER TABLE llx_holiday_users DROP PRIMARY KEY;' |
Request 85 sql='ALTER TABLE llx_holiday_users ADD UNIQUE INDEX uk_holiday_users(fk_user, fk_type, nb_holiday);' |
Request 86 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN localtax1_tx double(6,3) DEFAULT 0;' |
Request 87 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN localtax1_type varchar(10) NOT NULL DEFAULT '0';' |
Request 88 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN localtax2_tx double(6,3) DEFAULT 0;' |
Request 89 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN localtax2_type varchar(10) NOT NULL DEFAULT '0';' |
Request 90 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MEMBER_SENTBYMAIL','Mails sent from member card','Executed when you send email from member card','member',23);' |
Request 91 sql='ALTER TABLE llx_ecm_files MODIFY label varchar(128) NOT NULL;' |
Request 92 sql='ALTER TABLE llx_ecm_files ADD COLUMN share varchar(128) NULL after label;' |
Request 93 sql='ALTER TABLE llx_ecm_files ADD COLUMN src_object_type varchar(32);' |
Request 94 sql='ALTER TABLE llx_ecm_files ADD COLUMN src_object_id integer;' |
Request 95 sql='ALTER TABLE llx_propal ADD COLUMN last_main_doc varchar(255);' |
Request 96 sql='ALTER TABLE llx_commande ADD COLUMN last_main_doc varchar(255);' |
Request 97 sql='ALTER TABLE llx_facture ADD COLUMN last_main_doc varchar(255);' |
Request 98 sql='ALTER TABLE llx_contrat ADD COLUMN last_main_doc varchar(255);' |
Request 99 sql='ALTER TABLE llx_expedition ADD COLUMN last_main_doc varchar(255);' |
Request 100 sql='ALTER TABLE llx_fichinter ADD COLUMN last_main_doc varchar(255);' |
Request 101 sql='ALTER TABLE llx_livraison ADD COLUMN last_main_doc varchar(255);' |
Request 102 sql='ALTER TABLE llx_supplier_proposal ADD COLUMN last_main_doc varchar(255);' |
Request 103 sql='ALTER TABLE llx_facture_fourn ADD COLUMN last_main_doc varchar(255);' |
Request 104 sql='ALTER TABLE llx_commande_fournisseur ADD COLUMN last_main_doc varchar(255);' |
Request 105 sql='ALTER TABLE llx_c_paiement ADD COLUMN position integer NOT NULL DEFAULT 0;' |
Request 106 sql='ALTER TABLE llx_c_payment_term ADD COLUMN position integer NOT NULL DEFAULT 0;' |
Request 107 sql='ALTER TABLE llx_product MODIFY COLUMN seuil_stock_alerte integer DEFAULT NULL;' |
Request 108 sql='ALTER TABLE llx_facture_rec ADD COLUMN suspended integer DEFAULT 0;' |
Request 109 sql='ALTER TABLE llx_facture_rec MODIFY COLUMN titre VARCHAR(100);' |
Request 110 sql='ALTER TABLE llx_contrat MODIFY COLUMN ref varchar(50);' |
Request 111 sql='ALTER TABLE llx_contrat MODIFY COLUMN ref_customer varchar(50);' |
Request 112 sql='ALTER TABLE llx_contrat MODIFY COLUMN ref_supplier varchar(50);' |
Request 113 sql='ALTER TABLE llx_contrat MODIFY COLUMN ref_ext varchar(50);' |
Request 114 sql='UPDATE llx_c_email_templates SET position = 0 WHERE position IS NULL;' |
Request 115 sql='UPDATE llx_c_email_templates SET lang = '' WHERE lang IS NULL;' |
Request 116 sql='ALTER TABLE llx_c_email_templates ADD COLUMN enabled varchar(255) DEFAULT '1';' |
Request 117 sql='ALTER TABLE llx_c_email_templates ADD COLUMN joinfiles varchar(255) DEFAULT '1';' |
Request 118 sql='ALTER TABLE llx_c_email_templates MODIFY COLUMN content mediumtext;' |
Request 119 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines) VALUES (0,'adherent','member','',0,null,null,'(SendingAnEMailToMember)',1,1,1,'__(CardContent)__','__(Hello)__,<br><br>\n\n__(ThisIsContentOfYourCard)__<br>\n__(ID)__ : __ID__<br>\n__(Civiliyty)__ : __MEMBER_CIVILITY__<br>\n__(Firstname)__ : __MEMBER_FIRSTNAME__<br>\n__(Lastname)__ : __MEMBER_LASTNAME__<br>\n__(Fullname)__ : __MEMBER_FULLNAME__<br>\n__(Company)__ : __MEMBER_COMPANY__<br>\n__(Address)__ : __MEMBER_ADDRESS__<br>\n__(Zip)__ : __MEMBER_ZIP__<br>\n__(Town)__ : __MEMBER_TOWN__<br>\n__(Country)__ : __MEMBER_COUNTRY__<br>\n__(Email)__ : __MEMBER_EMAIL__<br>\n__(Birthday)__ : __MEMBER_BIRTH__<br>\n__(Photo)__ : __MEMBER_PHOTO__<br>\n__(Login)__ : __MEMBER_LOGIN__<br>\n__(Password)__ : __MEMBER_PASSWORD__<br>\n__(Phone)__ : __MEMBER_PHONE__<br>\n__(PhonePerso)__ : __MEMBER_PHONEPRO__<br>\n__(PhoneMobile)__ : __MEMBER_PHONEMOBILE__<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null);' |
Request 120 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines) VALUES (0,'banque','thirdparty','',0,null,null,'(YourSEPAMandate)',1,1,0,'__(YourSEPAMandate)__','__(Hello)__,<br><br>\n\n__(FindYourSEPAMandate)__ :<br>\n__MYCOMPANY_NAME__<br>\n__MYCOMPANY_FULLADDRESS__<br><br>\n__(Sincerely)__<br>\n__USER_SIGNATURE__',null);' |
Request 121 sql='INSERT INTO llx_c_accounting_category (rowid, code, label, range_account, sens, category_type, formula, position, fk_country, active) VALUES ( 1, 'VENTES', 'Income of products/services', 'Exemple: 7xxxxx', 0, 0, '', '10', 1, 1);' |
Request 122 sql='INSERT INTO llx_c_accounting_category (rowid, code, label, range_account, sens, category_type, formula, position, fk_country, active) VALUES ( 2, 'DEPENSES', 'Expenses of products/services', 'Exemple: 6xxxxx', 0, 0, '', '20', 1, 1);' |
Request 123 sql='INSERT INTO llx_c_accounting_category (rowid, code, label, range_account, sens, category_type, formula, position, fk_country, active) VALUES ( 3, 'PROFIT', 'Balance', '', 0, 1, 'VENTES+DEPENSES', '30', 1, 1);' |
Request 124 sql='UPDATE llx_c_accounting_category set code = 'VENTES', range_account='7xxxxx' where code = 'VTE';' |
Request 125 sql='UPDATE llx_c_accounting_category set code = 'DEPENSES', range_account='6xxxxx' where code = 'MAR';' |
Request 126 sql='UPDATE llx_c_accounting_category set code = 'PROFIT', range_account='Balance', formula = 'VENTES+DEPENSES' where code = 'MARGE';' |
Request 127 sql='ALTER TABLE llx_menu MODIFY COLUMN perms text;' |
Request 128 sql='ALTER TABLE llx_mailing MODIFY COLUMN titre varchar(128);' |
Request 129 sql='ALTER TABLE llx_mailing MODIFY COLUMN sujet varchar(128);' |
Request 130 sql='ALTER TABLE llx_mailing MODIFY COLUMN langs varchar(64);' |
Request 131 sql='ALTER TABLE llx_facture_fourn ADD COLUMN date_pointoftax date DEFAULT NULL;' |
Request 132 sql='ALTER TABLE llx_facture_fourn ADD COLUMN date_valid date;' |
Request 133 sql='ALTER TABLE llx_bookmark DROP COLUMN fk_soc;' |
Request 134 sql='ALTER TABLE llx_website MODIFY COLUMN ref varchar(128);' |
Request 135 sql='ALTER TABLE llx_website_page MODIFY COLUMN pageurl varchar(255);' |
Request 136 sql='ALTER TABLE llx_website_page ADD COLUMN lang varchar(6);' |
Request 137 sql='ALTER TABLE llx_website_page ADD COLUMN fk_page integer;' |
Request 138 sql='ALTER TABLE llx_website_page ADD COLUMN grabbed_from varchar(255);' |
Request 139 sql='ALTER TABLE llx_website_page ADD COLUMN htmlheader mediumtext;' |
Request 140 sql='ALTER TABLE llx_website_page MODIFY COLUMN htmlheader mediumtext;' |
Request 141 sql='ALTER TABLE llx_website_page MODIFY COLUMN status INTEGER DEFAULT 1;' |
Request 142 sql='UPDATE llx_website_page set status = 1 WHERE status IS NULL;' |
Request 143 sql='ALTER TABLE llx_website ADD COLUMN import_key varchar(14);' |
Request 144 sql='ALTER TABLE llx_website_page ADD COLUMN import_key varchar(14);' |
Request 145 sql='ALTER TABLE llx_fichinter ADD COLUMN import_key varchar(14);' |
Request 146 sql='ALTER TABLE llx_livraison ADD COLUMN import_key varchar(14);' |
Request 147 sql='ALTER TABLE llx_livraison ADD COLUMN extraparams varchar(255);' |
Request 148 sql='ALTER TABLE llx_don ADD COLUMN extraparams varchar(255);' |
Request 149 sql='ALTER TABLE llx_accounting_account ADD COLUMN import_key varchar(14);' |
Request 150 sql='ALTER TABLE llx_accounting_account ADD COLUMN extraparams varchar(255);' |
Request 151 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN import_key varchar(14);' |
Request 152 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN extraparams varchar(255);' |
Request 153 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD COLUMN extraparams varchar(255);' |
Request 154 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_lim_reglement datetime DEFAULT NULL;' |
Request 155 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN fk_user integer NULL;' |
Request 156 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD COLUMN date_lim_reglement datetime DEFAULT NULL;' |
Request 157 sql='ALTER TABLE llx_accounting_bookkeeping_tmp ADD COLUMN fk_user integer NULL;' |
Request 158 sql='ALTER TABLE llx_menu MODIFY fk_mainmenu varchar(100);' |
Request 159 sql='ALTER TABLE llx_menu MODIFY fk_leftmenu varchar(100);' |
Request 160 sql='CREATE TABLE llx_website_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 161 sql='ALTER TABLE llx_website_extrafields ADD INDEX idx_website_extrafields (fk_object);' |
Request 162 sql='CREATE TABLE llx_website_account( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, login varchar(64) NOT NULL, pass_encoding varchar(24) NOT NULL, pass_crypted varchar(128), pass_temp varchar(128), fk_soc integer, fk_website integer NOT NULL, note_private text, date_last_login datetime, date_previous_login datetime, 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 ) ENGINE=innodb;' |
Request 163 sql='ALTER TABLE llx_website_account ADD INDEX idx_website_account_rowid (rowid);' |
Request 164 sql='ALTER TABLE llx_website_account ADD INDEX idx_website_account_login (login);' |
Request 165 sql='ALTER TABLE llx_website_account ADD INDEX idx_website_account_import_key (import_key);' |
Request 166 sql='ALTER TABLE llx_website_account ADD INDEX idx_website_account_status (status);' |
Request 167 sql='ALTER TABLE llx_website_account ADD INDEX idx_website_account_fk_soc (fk_soc);' |
Request 168 sql='ALTER TABLE llx_website_account ADD INDEX idx_website_account_fk_website (fk_website);' |
Request 169 sql='ALTER TABLE llx_website_account ADD UNIQUE INDEX uk_website_account_login_website_soc(login, fk_website, fk_soc);' |
Request 170 sql='ALTER TABLE llx_website_account ADD CONSTRAINT llx_website_account_fk_website FOREIGN KEY (fk_website) REFERENCES llx_website(rowid);' |
Request 171 sql='CREATE TABLE llx_website_account_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 172 sql='ALTER TABLE llx_website_account_extrafields ADD INDEX idx_website_account_extrafields (fk_object);' |
Request 173 sql='alter table llx_user add column pass_encoding varchar(24) NULL;' |
Request 174 sql='CREATE TABLE IF NOT EXISTS llx_expensereport_ik ( rowid integer AUTO_INCREMENT PRIMARY KEY, datec datetime DEFAULT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_c_exp_tax_cat integer DEFAULT 0 NOT NULL, fk_range integer DEFAULT 0 NOT NULL, coef double DEFAULT 0 NOT NULL, ikoffset double DEFAULT 0 NOT NULL, active integer DEFAULT 1 )ENGINE=innodb;' |
Request 175 sql='ALTER TABLE llx_expensereport_ik ADD COLUMN ikoffset double DEFAULT 0 NOT NULL;' |
Request 176 sql='CREATE TABLE IF NOT EXISTS llx_c_exp_tax_cat ( rowid integer AUTO_INCREMENT PRIMARY KEY, label varchar(48) NOT NULL, entity integer DEFAULT 1 NOT NULL, active integer DEFAULT 1 NOT NULL )ENGINE=innodb;' |
Request 177 sql='CREATE TABLE IF NOT EXISTS llx_c_exp_tax_range ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_c_exp_tax_cat integer DEFAULT 1 NOT NULL, range_ik double DEFAULT 0 NOT NULL, entity integer DEFAULT 1 NOT NULL, active integer DEFAULT 1 NOT NULL )ENGINE=innodb;' |
Request 178 sql='INSERT INTO llx_c_type_fees (code, label, active, accountancy_code) VALUES ('EX_KME', 'ExpLabelKm', 1, '625100'), ('EX_FUE', 'ExpLabelFuelCV', 0, '606150'), ('EX_HOT', 'ExpLabelHotel', 0, '625160'), ('EX_PAR', 'ExpLabelParkingCV', 0, '625160'), ('EX_TOL', 'ExpLabelTollCV', 0, '625160'), ('EX_TAX', 'ExpLabelVariousTaxes', 0, '637800'), ('EX_IND', 'ExpLabelIndemnityTranspSub', 0, '648100'), ('EX_SUM', 'ExpLabelMaintenanceSupply', 0, '606300'), ('EX_SUO', 'ExpLabelOfficeSupplies', 0, '606400'), ('EX_CAR', 'ExpLabelCarRental', 0, '613000'), ('EX_DOC', 'ExpLabelDocumentation', 0, '618100'), ('EX_CUR', 'ExpLabelCustomersReceiving', 0, '625710'), ('EX_OTR', 'ExpLabelOtherReceiving', 0, '625700'), ('EX_POS', 'ExpLabelPostage', 0, '626100'), ('EX_CAM', 'ExpLabelMaintenanceRepairCV', 0, '615300'), ('EX_EMM', 'ExpLabelEmployeesMeal', 0, '625160'), ('EX_GUM', 'ExpLabelGuestsMeal', 0, '625160'), ('EX_BRE', 'ExpLabelBreakfast', 0, '625160'), ('EX_FUE_VP', 'ExpLabelFuelPV', 0, '606150'), ('EX_TOL_VP', 'ExpLabelTollPV', 0, '625160'), ('EX_PAR_VP', 'ExpLabelParkingPV', 0, '625160'), ('EX_CAM_VP', 'ExpLabelMaintenanceRepairPV', 0, '615300');' |
Request 179 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (1,4, 1, 0.41, 0);' |
Request 180 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (2,4, 2, 0.244, 824);' |
Request 181 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (3,4, 3, 0.286, 0);' |
Request 182 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (4,5, 4, 0.493, 0);' |
Request 183 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (5,5, 5, 0.277, 1082);' |
Request 184 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (6,5, 6, 0.332, 0);' |
Request 185 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (7,6, 7, 0.543, 0);' |
Request 186 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (8,6, 8, 0.305, 1180);' |
Request 187 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (9,6, 9, 0.364, 0);' |
Request 188 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (10,7, 10, 0.568, 0);' |
Request 189 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (11,7, 11, 0.32, 1244);' |
Request 190 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (12,7, 12, 0.382, 0);' |
Request 191 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (13,8, 13, 0.595, 0);' |
Request 192 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (14,8, 14, 0.337, 1288);' |
Request 193 sql='INSERT INTO llx_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (15,8, 15, 0.401, 0);' |
Request 194 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (1,'ExpAutoCat', 1, 1);' |
Request 195 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (2,'ExpCycloCat', 1, 1);' |
Request 196 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (3,'ExpMotoCat', 1, 1);' |
Request 197 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (4,'ExpAuto3CV', 1, 1);' |
Request 198 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (5,'ExpAuto4CV', 1, 1);' |
Request 199 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (6,'ExpAuto5CV', 1, 1);' |
Request 200 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (7,'ExpAuto6CV', 1, 1);' |
Request 201 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (8,'ExpAuto7CV', 1, 1);' |
Request 202 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (9,'ExpAuto8CV', 1, 1);' |
Request 203 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (10,'ExpAuto9CV', 1, 1);' |
Request 204 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (11,'ExpAuto10CV', 1, 1);' |
Request 205 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (12,'ExpAuto11CV', 1, 1);' |
Request 206 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (13,'ExpAuto12CV', 1, 1);' |
Request 207 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (14,'ExpAuto3PCV', 1, 1);' |
Request 208 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (15,'ExpAuto4PCV', 1, 1);' |
Request 209 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (16,'ExpAuto5PCV', 1, 1);' |
Request 210 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (17,'ExpAuto6PCV', 1, 1);' |
Request 211 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (18,'ExpAuto7PCV', 1, 1);' |
Request 212 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (19,'ExpAuto8PCV', 1, 1);' |
Request 213 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (20,'ExpAuto9PCV', 1, 1);' |
Request 214 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (21,'ExpAuto10PCV', 1, 1);' |
Request 215 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (22,'ExpAuto11PCV', 1, 1);' |
Request 216 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (23,'ExpAuto12PCV', 1, 1);' |
Request 217 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (24,'ExpAuto13PCV', 1, 1);' |
Request 218 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (25,'ExpCyclo', 1, 1);' |
Request 219 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (26,'ExpMoto12CV', 1, 1);' |
Request 220 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (27,'ExpMoto345CV', 1, 1);' |
Request 221 sql='INSERT INTO llx_c_exp_tax_cat (rowid, label, entity, active) values (28,'ExpMoto5PCV', 1, 1);' |
Request 222 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (1,4, 0, 1, 1);' |
Request 223 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (2,4, 5000, 1, 1);' |
Request 224 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (3,4, 20000, 1, 1);' |
Request 225 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (4,5, 0, 1, 1);' |
Request 226 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (5,5, 5000, 1, 1);' |
Request 227 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (6,5, 20000, 1, 1);' |
Request 228 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (7,6, 0, 1, 1);' |
Request 229 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (8,6, 5000, 1, 1);' |
Request 230 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (9,6, 20000, 1, 1);' |
Request 231 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (10,7, 0, 1, 1);' |
Request 232 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (11,7, 5000, 1, 1);' |
Request 233 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (12,7, 20000, 1, 1);' |
Request 234 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (13,8, 0, 1, 1);' |
Request 235 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (14,8, 5000, 1, 1);' |
Request 236 sql='INSERT INTO llx_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (15,8, 20000, 1, 1);' |
Request 237 sql='CREATE TABLE llx_expensereport_rules ( rowid integer AUTO_INCREMENT PRIMARY KEY, datec datetime DEFAULT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dates datetime NOT NULL, datee datetime NOT NULL, amount numeric(24,8) NOT NULL, restrictive tinyint NOT NULL, fk_user integer DEFAULT NULL, fk_usergroup integer DEFAULT NULL, fk_c_type_fees integer NOT NULL, code_expense_rules_type varchar(50) NOT NULL, is_for_all tinyint DEFAULT 0, entity integer DEFAULT 1 )ENGINE=innodb;' |
Request 238 sql='ALTER TABLE llx_expensereport_det ADD COLUMN rule_warning_message text;' |
Request 239 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_c_exp_tax_cat integer;' |
Request 240 sql='ALTER TABLE llx_user ADD COLUMN default_range integer;' |
Request 241 sql='ALTER TABLE llx_user ADD COLUMN default_c_exp_tax_cat integer;' |
Request 242 sql='ALTER TABLE llx_extrafields ADD COLUMN fk_user_author integer;' |
Request 243 sql='ALTER TABLE llx_extrafields ADD COLUMN fk_user_modif integer;' |
Request 244 sql='ALTER TABLE llx_extrafields ADD COLUMN datec datetime;' |
Request 245 sql='ALTER TABLE llx_extrafields ADD COLUMN enabled varchar(255) DEFAULT '1';' |
Request 246 sql='ALTER TABLE llx_extrafields ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
Request 247 sql='ALTER TABLE llx_extrafields MODIFY COLUMN langs varchar(64);' |
Request 248 sql='ALTER TABLE llx_holiday_config MODIFY COLUMN name varchar(128) NOT NULL;' |
Request 249 sql='ALTER TABLE llx_holiday_config ADD UNIQUE INDEX idx_holiday_config (name);' |
Request 250 sql='ALTER TABLE llx_societe MODIFY COLUMN ref_ext varchar(255);' |
Request 251 sql='ALTER TABLE llx_socpeople MODIFY COLUMN ref_ext varchar(255);' |
Request 252 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN ref_ext varchar(255);' |
Request 253 sql='ALTER TABLE llx_expedition MODIFY COLUMN ref_ext varchar(255);' |
Request 254 sql='ALTER TABLE llx_livraison MODIFY COLUMN ref_ext varchar(255);' |
Request 255 sql='ALTER TABLE llx_contrat MODIFY COLUMN ref_ext varchar(255);' |
Request 256 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN label varchar(255) NOT NULL;' |
Request 257 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_fk_user_action (fk_user_action);' |
Request 258 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_fk_project (fk_project);' |
Request 259 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_datep (datep);' |
Request 260 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_datep2 (datep2);' |
Request 261 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_recurid (recurid);' |
Request 262 sql='ALTER TABLE llx_actioncomm ADD INDEX idx_actioncomm_ref_ext (ref_ext);' |
Request 263 sql='ALTER TABLE llx_payment_various ADD COLUMN fk_projet integer DEFAULT NULL after accountancy_code;' |
Request 264 sql='UPDATE llx_const set name = __ENCRYPT('ONLINE_PAYMENT_MESSAGE_OK')__ where name = __ENCRYPT('PAYPAL_MESSAGE_OK')__;' |
Request 265 sql='UPDATE llx_const set name = __ENCRYPT('ONLINE_PAYMENT_MESSAGE_KO')__ where name = __ENCRYPT('PAYPAL_MESSAGE_KO')__;' |
Request 266 sql='UPDATE llx_const set name = __ENCRYPT('ONLINE_PAYMENT_CREDITOR')__ where name = __ENCRYPT('PAYPAL_CREDITOR')__;' |
Request 267 sql='UPDATE llx_const set name = __ENCRYPT('ONLINE_PAYMENT_CSS_URL')__ where name = __ENCRYPT('PAYPAL_CSS_URL')__;' |
Request 268 sql='UPDATE llx_const set name = __ENCRYPT('ONLINE_PAYMENT_NEWFORMTEXT')__ where name = __ENCRYPT('PAYPAL_NEWFORMTEXT')__;' |
Request 269 sql='UPDATE llx_const set name = __ENCRYPT('ONLINE_PAYMENT_LOGO')__ where name = __ENCRYPT('PAYPAL_LOGO')__;' |
Request 270 sql='ALTER TABLE llx_accounting_system ADD COLUMN fk_country integer;' |
Request 271 sql='UPDATE llx_accounting_account SET pcg_type = 'INCOME' where pcg_type = 'PROD';' |
Request 272 sql='UPDATE llx_accounting_account SET pcg_type = 'EXPENSE' where pcg_type = 'CHARGE';' |
Request 273 sql='UPDATE llx_accounting_account SET pcg_type = 'INCOME' where pcg_type = 'VENTAS_E_INGRESOS';' |
Request 274 sql='UPDATE llx_accounting_account SET pcg_type = 'EXPENSE' where pcg_type = 'COMPRAS_GASTOS';' |
Request 275 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN elementtype varchar(24) NOT NULL;' |
Request 276 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_SENTBYMAIL','Contract sent by mail','Executed when a contract is sent by mail','contrat',18);' |
Request 277 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_VALIDATE','Price request validated','Executed when a commercial proposal is validated','proposal_supplier',10);' |
Request 278 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_SENTBYMAIL','Price request sent by mail','Executed when a commercial proposal is sent by mail','proposal_supplier',10);' |
Request 279 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_CLOSE_SIGNED','Price request closed signed','Executed when a customer proposal is closed signed','proposal_supplier',10);' |
Request 280 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_CLOSE_REFUSED','Price request closed refused','Executed when a customer proposal is closed refused','proposal_supplier',10);' |
Request 281 sql='DROP TABLE llx_projet_task_comment;' |
Request 282 sql='CREATE TABLE llx_comment ( rowid integer AUTO_INCREMENT PRIMARY KEY, datec datetime DEFAULT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, description text NOT NULL, fk_user_author integer DEFAULT NULL, fk_element integer DEFAULT NULL, element_type varchar(50) DEFAULT NULL, entity integer DEFAULT 1, import_key varchar(125) DEFAULT NULL )ENGINE=innodb;' |
Request 283 sql='DELETE FROM llx_const where name = __ENCRYPT('MAIN_SHOW_WORKBOARD')__;' |
Request 284 sql='UPDATE llx_const SET value = REPLACE(value, '%', '__') WHERE name LIKE 'ADHERENT%';' |
Request 285 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_SELL_JOURNAL')__;' |
Request 286 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_PURCHASE_JOURNAL')__;' |
Request 287 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_SOCIAL_JOURNAL')__;' |
Request 288 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_MISCELLANEOUS_JOURNAL')__;' |
Request 289 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_GROUPBYACCOUNT')__;' |
Request 290 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_GLOBAL_ACCOUNT')__;' |
Request 291 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_LABEL')__;' |
Request 292 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_AMOUNT')__;' |
Request 293 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_DEVISE')__;' |
Request 294 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_PIECE')__;' |
Request 295 sql='DELETE FROM llx_const WHERE name = __ENCRYPT('ACCOUNTING_EXPENSEREPORT_JOURNAL')__;' |
Request 296 sql='ALTER TABLE llx_c_paiement DROP PRIMARY KEY;' |
Request 297 sql='ALTER TABLE llx_c_paiement ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER id;' |
Request 298 sql='ALTER TABLE llx_c_paiement DROP INDEX uk_c_paiement;' |
Request 299 sql='ALTER TABLE llx_c_paiement ADD UNIQUE INDEX uk_c_paiement(id, entity, code);' |
Request 300 sql='ALTER TABLE llx_c_payment_term DROP PRIMARY KEY;' |
Request 301 sql='ALTER TABLE llx_c_payment_term ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;' |
Request 302 sql='ALTER TABLE llx_c_payment_term ADD UNIQUE INDEX uk_c_payment_term(rowid, entity, code);' |
Request 303 sql='ALTER TABLE llx_projet CHANGE datec datec datetime;' |
Request 304 sql='create table llx_c_email_senderprofile ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, private smallint DEFAULT 0 NOT NULL, date_creation datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, label varchar(255), email varchar(255), signature text, position smallint, active tinyint DEFAULT 1 NOT NULL )ENGINE=innodb;' |
Request 305 sql='ALTER TABLE llx_c_email_senderprofile ADD UNIQUE INDEX uk_c_email_senderprofile(entity, label, email);' |
Request 306 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 67,'PC-MIPYME', 'The PYME accountancy Chile plan', 1);' |
Request 307 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 7,'ENG-BASE', 'England plan', 1);' |
Request 308 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 49,'SYSCOHADA-BJ', 'Plan comptable Ouest-Africain', 1);' |
Request 309 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 60,'SYSCOHADA-BF', 'Plan comptable Ouest-Africain', 1);' |
Request 310 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 24,'SYSCOHADA-CM', 'Plan comptable Ouest-Africain', 1);' |
Request 311 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 65,'SYSCOHADA-CF', 'Plan comptable Ouest-Africain', 1);' |
Request 312 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 71,'SYSCOHADA-KM', 'Plan comptable Ouest-Africain', 1);' |
Request 313 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 72,'SYSCOHADA-CG', 'Plan comptable Ouest-Africain', 1);' |
Request 314 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 21,'SYSCOHADA-CI', 'Plan comptable Ouest-Africain', 1);' |
Request 315 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 16,'SYSCOHADA-GA', 'Plan comptable Ouest-Africain', 1);' |
Request 316 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 87,'SYSCOHADA-GQ', 'Plan comptable Ouest-Africain', 1);' |
Request 317 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (147,'SYSCOHADA-ML', 'Plan comptable Ouest-Africain', 1);' |
Request 318 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (168,'SYSCOHADA-NE', 'Plan comptable Ouest-Africain', 1);' |
Request 319 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 73,'SYSCOHADA-CD', 'Plan comptable Ouest-Africain', 1);' |
Request 320 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 22,'SYSCOHADA-SN', 'Plan comptable Ouest-Africain', 1);' |
Request 321 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 66,'SYSCOHADA-TD', 'Plan comptable Ouest-Africain', 1);' |
Request 322 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 15,'SYSCOHADA-TG', 'Plan comptable Ouest-Africain', 1);' |
Request 323 sql='UPDATE llx_accounting_system SET fk_country = 1 WHERE pcg_version = 'PCG99-ABREGE';' |
Request 324 sql='UPDATE llx_accounting_system SET fk_country = 1 WHERE pcg_version = 'PCG99-BASE';' |
Request 325 sql='UPDATE llx_accounting_system SET fk_country = 1 WHERE pcg_version = 'PCG14-DEV';' |
Request 326 sql='UPDATE llx_accounting_system SET fk_country = 2 WHERE pcg_version = 'PCMN-BASE';' |
Request 327 sql='UPDATE llx_accounting_system SET fk_country = 4 WHERE pcg_version = 'PCG08-PYME';' |
Request 328 sql='UPDATE llx_accounting_system SET fk_country = 10 WHERE pcg_version = 'PCT';' |
Request 329 sql='UPDATE llx_accounting_system SET fk_country = 80 WHERE pcg_version = 'DK-STD';' |
Request 330 sql='UPDATE llx_accounting_system SET fk_country = 67 WHERE pcg_version = 'PC-MIPYME';' |
Request 331 sql='UPDATE llx_accounting_system SET fk_country = 6 WHERE pcg_version = 'PCG_SUISSE';' |
Request 332 sql='UPDATE llx_accounting_system SET fk_country =140 WHERE pcg_version = 'PCN-LUXEMBURG';' |
Request 333 sql='UPDATE llx_accounting_system SET fk_country = 12 WHERE pcg_version = 'PCG';' |
Request 334 sql='CREATE TABLE llx_actioncomm_reminder( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, dateremind datetime NOT NULL, typeremind varchar(32) NOT NULL, fk_user integer NOT NULL, offsetvalue integer NOT NULL, offsetunit varchar(1) NOT NULL, status integer NOT NULL DEFAULT 0 ) ENGINE=innodb;' |
Request 335 sql='ALTER TABLE llx_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_rowid (rowid);' |
Request 336 sql='ALTER TABLE llx_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_dateremind (dateremind);' |
Request 337 sql='ALTER TABLE llx_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_fk_user (fk_user);' |
Request 338 sql='ALTER TABLE llx_actioncomm_reminder ADD UNIQUE INDEX uk_actioncomm_reminder_unique(fk_user, typeremind, offsetvalue, offsetunit);' |
Request 339 sql='UPDATE llx_tva SET datec = tms where datec IS NULL;' |
Request 340 sql='create table llx_onlinesignature ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, object_type varchar(32) NOT NULL, object_id integer NOT NULL, datec datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, name varchar(255) NOT NULL, ip varchar(128), pathoffile varchar(255) )ENGINE=innodb;' |
Request 341 sql='ALTER TABLE llx_resource ADD UNIQUE INDEX uk_resource_ref (ref, entity);' |
Request 342 sql='ALTER TABLE llx_facture_rec ADD COLUMN modelpdf varchar(255) AFTER note_public;' |
Request 343 sql='ALTER TABLE llx_facture_rec ADD COLUMN generate_pdf integer DEFAULT 1 AFTER auto_validate;' |
Request 344 sql='ALTER TABLE llx_blockedlog ADD COLUMN date_creation datetime;' |
Request 345 sql='ALTER TABLE llx_blockedlog ADD COLUMN user_fullname varchar(255);' |
Request 346 sql='ALTER TABLE llx_blockedlog MODIFY COLUMN ref_object varchar(255);' |
Request 347 sql='ALTER TABLE llx_blockedlog MODIFY COLUMN amounts double(24,8) NOT NULL;' |
Request 348 sql='ALTER TABLE llx_chargesociales MODIFY COLUMN amount double(24,8);' |
Request 349 sql='ALTER TABLE llx_commande MODIFY COLUMN amount_ht double(24,8) default 0;' |
Request 350 sql='ALTER TABLE llx_commande_fournisseur MODIFY COLUMN amount_ht double(24,8);' |
Request 351 sql='ALTER TABLE llx_don MODIFY COLUMN amount double(24,8);' |
Request 352 sql='ALTER TABLE llx_expensereport_rules MODIFY COLUMN amount double(24,8);' |
Request 353 sql='ALTER TABLE llx_loan MODIFY COLUMN capital double(24,8);' |
Request 354 sql='ALTER TABLE llx_loan MODIFY COLUMN capital_position double(24,8);' |
Request 355 sql='ALTER TABLE llx_loan_schedule MODIFY COLUMN amount_capital double(24,8);' |
Request 356 sql='ALTER TABLE llx_loan_schedule MODIFY COLUMN amount_insurance double(24,8);' |
Request 357 sql='ALTER TABLE llx_loan_schedule MODIFY COLUMN amount_interest double(24,8);' |
Request 358 sql='ALTER TABLE llx_paiementcharge MODIFY COLUMN amount double(24,8);' |
Request 359 sql='ALTER TABLE llx_paiementfourn MODIFY COLUMN amount double(24,8);' |
Request 360 sql='ALTER TABLE llx_payment_donation MODIFY COLUMN amount double(24,8);' |
Request 361 sql='ALTER TABLE llx_payment_expensereport MODIFY COLUMN amount double(24,8);' |
Request 362 sql='ALTER TABLE llx_payment_loan MODIFY COLUMN amount_capital double(24,8);' |
Request 363 sql='ALTER TABLE llx_payment_loan MODIFY COLUMN amount_insurance double(24,8);' |
Request 364 sql='ALTER TABLE llx_payment_loan MODIFY COLUMN amount_interest double(24,8);' |
Request 365 sql='ALTER TABLE llx_payment_salary MODIFY COLUMN salary double(24,8);' |
Request 366 sql='ALTER TABLE llx_payment_salary MODIFY COLUMN amount double(24,8);' |
Request 367 sql='ALTER TABLE llx_prelevement_bons MODIFY COLUMN amount double(24,8);' |
Request 368 sql='ALTER TABLE llx_prelevement_facture_demande MODIFY COLUMN amount double(24,8);' |
Request 369 sql='ALTER TABLE llx_prelevement_lignes MODIFY COLUMN amount double(24,8);' |
Request 370 sql='ALTER TABLE llx_societe MODIFY COLUMN capital double(24,8);' |
Request 371 sql='ALTER TABLE llx_tva MODIFY COLUMN amount double(24,8);' |
Request 372 sql='ALTER TABLE llx_subscription MODIFY COLUMN subscription double(24,8);' |
Request 373 sql='ALTER TABLE llx_resource ADD fk_country integer DEFAULT NULL;' |
Request 374 sql='ALTER TABLE llx_resource ADD INDEX idx_resource_fk_country (fk_country);' |
Request 375 sql='ALTER TABLE llx_resource ADD CONSTRAINT fk_resource_fk_country FOREIGN KEY (fk_country) REFERENCES llx_c_country (rowid);' |
Request 376 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 377 sql='ALTER TABLE llx_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);' |
Request 378 sql='ALTER TABLE llx_product_association ADD COLUMN rowid integer AUTO_INCREMENT PRIMARY KEY;' |
Request 379 sql='DROP TABLE llx_c_accountancy_category;' |
Request 380 sql='UPDATE llx_cronjob set entity = 1 where entity = 0 and label in ('RecurringInvoices', 'SendEmailsReminders');' |
Request 381 sql='UPDATE llx_cronjob set entity = 0 where entity = 1 and label in ('PurgeDeleteTemporaryFilesShort', 'MakeLocalDatabaseDumpShort');' |
Request 382 sql='ALTER TABLE llx_c_shipment_mode MODIFY COLUMN tracking varchar(255) NULL;' |
Request 383 sql='ALTER TABLE llx_paiementfourn ADD COLUMN fk_user_modif integer AFTER fk_user_author;' |
Script processing | Error - Show-Hide details |