|
| 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_1833 (Req 11): ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) CHARACTER SET utf8;
Cannot change column 'pcg_version': used in a foreign key constraint 'fk_accountingaccount_fk_pcg_version' of table 'actarus_dolitst.llx_accountingaccount' |
| Request 12 sql='ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) COLLATE utf8_unicode_ci;' |
Error DB_ERROR_1833 (Req 12): ALTER TABLE llx_accounting_system MODIFY pcg_version VARCHAR(20) COLLATE utf8_unicode_ci;
Cannot change column 'pcg_version': used in a foreign key constraint 'fk_accountingaccount_fk_pcg_version' of table 'actarus_dolitst.llx_accountingaccount' |
| 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 |
