Dolibarr logo
17.0.2

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : ecoledusdoli.mysql.dbOK
Database connection : ecoledusdoliOK
Database server version8.0.39-30
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script6.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 processingError - Show-Hide details
Error(s) were reported during the migration process so next step is not available. To ignore errors, you can click here, but the application or some features may not work correctly until the errors are resolved.