Dolibarr logo
7.0.3

Dolibarr install or upgrade

Database Structure database migration

Server connection : localhostOK
Database connection : railplan_doli449OK
Database server version5.6.39-cll-lve
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script6.0.0-7.0.0.sql
Request 1 sql='ALTER TABLE llxmk_product ADD COLUMN accountancy_code_sell_intra varchar(32) AFTER accountancy_code_sell;'
Request 2 sql='ALTER TABLE llxmk_product ADD COLUMN accountancy_code_sell_export varchar(32) AFTER accountancy_code_sell_intra;'
Request 3 sql='ALTER TABLE llxmk_accounting_account DROP FOREIGN KEY fk_accountingaccount_fk_pcg_version;'
Request 4 sql='ALTER TABLE llxmk_accounting_account DROP FOREIGN KEY fk_accounting_account_fk_pcg_version;'
Request 5 sql='ALTER TABLE llxmk_accounting_account MODIFY fk_pcg_version VARCHAR(20) CHARACTER SET utf8;'
Request 6 sql='ALTER TABLE llxmk_accounting_account MODIFY fk_pcg_version VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 7 sql='ALTER TABLE llxmk_accounting_system MODIFY pcg_version VARCHAR(20) CHARACTER SET utf8;'
Request 8 sql='ALTER TABLE llxmk_accounting_system MODIFY pcg_version VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 9 sql='ALTER TABLE llxmk_accounting_account MODIFY account_number VARCHAR(20) CHARACTER SET utf8;'
Request 10 sql='ALTER TABLE llxmk_accounting_account MODIFY account_number VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 11 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY numero_compte VARCHAR(20) CHARACTER SET utf8;'
Request 12 sql='ALTER TABLE llxmk_accounting_bookkeeping MODIFY numero_compte VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 13 sql='ALTER TABLE llxmk_accounting_journal MODIFY code VARCHAR(20) CHARACTER SET utf8;'
Request 14 sql='ALTER TABLE llxmk_accounting_journal MODIFY code VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 15 sql='ALTER TABLE llxmk_bank_account MODIFY accountancy_journal VARCHAR(20) CHARACTER SET utf8;'
Request 16 sql='ALTER TABLE llxmk_bank_account MODIFY accountancy_journal VARCHAR(20) COLLATE utf8_unicode_ci;'
Request 17 sql='ALTER TABLE llxmk_stock_mouvement MODIFY batch VARCHAR(30) CHARACTER SET utf8;'
Request 18 sql='ALTER TABLE llxmk_stock_mouvement MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;'
Request 19 sql='ALTER TABLE llxmk_product_lot MODIFY batch VARCHAR(30) CHARACTER SET utf8;'
Request 20 sql='ALTER TABLE llxmk_product_lot MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;'
Request 21 sql='ALTER TABLE llxmk_expeditiondet_batch MODIFY batch VARCHAR(30) CHARACTER SET utf8;'
Request 22 sql='ALTER TABLE llxmk_expeditiondet_batch MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;'
Request 23 sql='ALTER TABLE llxmk_product_batch MODIFY batch VARCHAR(30) CHARACTER SET utf8;'
Request 24 sql='ALTER TABLE llxmk_product_batch MODIFY batch VARCHAR(30) COLLATE utf8_unicode_ci;'
Request 25 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_sell VARCHAR(32) CHARACTER SET utf8;'
Request 26 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_sell VARCHAR(32) COLLATE utf8_unicode_ci;'
Request 27 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_sell_intra VARCHAR(32) CHARACTER SET utf8;'
Request 28 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_sell_intra VARCHAR(32) COLLATE utf8_unicode_ci;'
Request 29 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_sell_export VARCHAR(32) CHARACTER SET utf8;'
Request 30 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_sell_export VARCHAR(32) COLLATE utf8_unicode_ci;'
Request 31 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_buy VARCHAR(32) CHARACTER SET utf8;'
Request 32 sql='ALTER TABLE llxmk_product MODIFY accountancy_code_buy VARCHAR(32) COLLATE utf8_unicode_ci;'
Request 33 sql='ALTER TABLE llxmk_c_type_fees MODIFY accountancy_code VARCHAR(32) CHARACTER SET utf8;'
Request 34 sql='ALTER TABLE llxmk_c_type_fees MODIFY accountancy_code VARCHAR(32) COLLATE utf8_unicode_ci;'
Request 35 sql='ALTER TABLE llxmk_accounting_account ADD CONSTRAINT fk_accounting_account_fk_pcg_version FOREIGN KEY (fk_pcg_version) REFERENCES llxmk_accounting_system (pcg_version);'
Request 36 sql='ALTER TABLE llxmk_user MODIFY login varchar(50) NOT NULL;'
Request 37 sql='ALTER TABLE llxmk_product_price ADD COLUMN fk_multicurrency integer;'
Request 38 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_code varchar(255);'
Request 39 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 40 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;'
Request 41 sql='ALTER TABLE llxmk_product_price ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;'
Request 42 sql='ALTER TABLE llxmk_product_customer_price_log ADD COLUMN default_vat_code varchar(10);'
Request 43 sql='ALTER TABLE llxmk_product_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;'
Request 44 sql='ALTER TABLE llxmk_product_customer_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;'
Request 45 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) AFTER tva_tx;'
Request 46 sql='ALTER TABLE llxmk_website_page ADD COLUMN fk_user_create integer;'
Request 47 sql='ALTER TABLE llxmk_website_page ADD COLUMN fk_user_modif integer;'
Request 48 sql='ALTER TABLE llxmk_website_page ADD COLUMN type_container varchar(16) NOT NULL DEFAULT 'page';'
Request 49 sql='delete from llxmk_c_action_trigger where code = 'MEMBER_SUBSCRIPTION';'
Request 50 sql='insert into llxmk_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 51 sql='insert into llxmk_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 52 sql='insert into llxmk_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 53 sql='ALTER TABLE llxmk_product_attribute_value DROP INDEX unique_ref;'
Request 54 sql='ALTER TABLE llxmk_product_attribute_value ADD UNIQUE INDEX uk_product_attribute_value (fk_product_attribute, ref);'
Request 55 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN quantity double DEFAULT NULL;'
Request 56 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN unitprice double(24,8) DEFAULT 0;'
Request 57 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN price_base_type varchar(3) DEFAULT 'HT';'
Request 58 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN fk_multicurrency integer;'
Request 59 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN multicurrency_code varchar(255);'
Request 60 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 61 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN multicurrency_price double(24,8) DEFAULT NULL;'
Request 62 sql='ALTER TABLE llxmk_product_price_by_qty ADD COLUMN multicurrency_price_ttc double(24,8) DEFAULT NULL;'
Request 63 sql='DROP INDEX uk_product_price_by_qty_level on llxmk_product_price_by_qty;'
Request 64 sql='ALTER TABLE llxmk_product_price_by_qty ADD UNIQUE INDEX uk_product_price_by_qty_level (fk_product_price, quantity);'
Request 65 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_fk_doc (fk_doc);'
Request 66 sql='ALTER TABLE llxmk_c_revenuestamp ADD COLUMN revenuestamp_type varchar(16) DEFAULT 'fixed' NOT NULL;'
Request 67 sql='UPDATE llxmk_contrat SET ref = rowid WHERE ref IS NULL OR ref = '';'
Request 68 sql='ALTER TABLE llxmk_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '';'
Request 69 sql='INSERT INTO llxmk_c_type_contact(rowid, element, source, code, libelle, active ) values (42, 'propal', 'external', 'SHIPPING', 'Customer contact for delivery', 1);'
Request 70 sql='ALTER TABLE llxmk_inventory ADD date_validation datetime DEFAULT NULL;'
Request 71 sql='ALTER TABLE llxmk_inventory CHANGE COLUMN datec date_creation datetime DEFAULT NULL;'
Request 72 sql='ALTER TABLE llxmk_inventory CHANGE COLUMN fk_user_author fk_user_creat integer;'
Request 73 sql='ALTER TABLE llxmk_inventory ADD UNIQUE INDEX uk_inventory_ref (ref, entity);'
Request 74 sql='ALTER table llxmk_entrepot CHANGE COLUMN label ref varchar(255);'
Request 75 sql='UPDATE llxmk_paiementfourn SET ref = rowid WHERE ref IS NULL;'
Request 76 sql='UPDATE llxmk_paiementfourn SET entity = 1 WHERE entity IS NULL;'
Request 77 sql='UPDATE llxmk_website SET entity = 1 WHERE entity IS NULL;'
Request 78 sql='ALTER TABLE llxmk_website MODIFY COLUMN entity integer NOT NULL DEFAULT 1;'
Request 79 sql='ALTER TABLE llxmk_user ADD COLUMN birth date;'
Request 80 sql='ALTER TABLE llxmk_holiday_users DROP PRIMARY KEY;'
Request 81 sql='ALTER TABLE llxmk_holiday_users ADD UNIQUE INDEX uk_holiday_users(fk_user, fk_type, nb_holiday);'
Request 82 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN localtax1_tx double(6,3) DEFAULT 0;'
Request 83 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN localtax1_type varchar(10) NOT NULL DEFAULT '0';'
Request 84 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN localtax2_tx double(6,3) DEFAULT 0;'
Request 85 sql='ALTER TABLE llxmk_product_fournisseur_price ADD COLUMN localtax2_type varchar(10) NOT NULL DEFAULT '0';'
Request 86 sql='insert into llxmk_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 87 sql='ALTER TABLE llxmk_ecm_files MODIFY label varchar(128) NOT NULL;'
Request 88 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN share varchar(128) NULL after label;'
Request 89 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN src_object_type varchar(32);'
Request 90 sql='ALTER TABLE llxmk_ecm_files ADD COLUMN src_object_id integer;'
Request 91 sql='ALTER TABLE llxmk_propal ADD COLUMN last_main_doc varchar(255);'
Request 92 sql='ALTER TABLE llxmk_commande ADD COLUMN last_main_doc varchar(255);'
Request 93 sql='ALTER TABLE llxmk_facture ADD COLUMN last_main_doc varchar(255);'
Request 94 sql='ALTER TABLE llxmk_contrat ADD COLUMN last_main_doc varchar(255);'
Request 95 sql='ALTER TABLE llxmk_expedition ADD COLUMN last_main_doc varchar(255);'
Request 96 sql='ALTER TABLE llxmk_fichinter ADD COLUMN last_main_doc varchar(255);'
Request 97 sql='ALTER TABLE llxmk_livraison ADD COLUMN last_main_doc varchar(255);'
Request 98 sql='ALTER TABLE llxmk_supplier_proposal ADD COLUMN last_main_doc varchar(255);'
Request 99 sql='ALTER TABLE llxmk_facture_fourn ADD COLUMN last_main_doc varchar(255);'
Request 100 sql='ALTER TABLE llxmk_commande_fournisseur ADD COLUMN last_main_doc varchar(255);'
Request 101 sql='ALTER TABLE llxmk_c_paiement ADD COLUMN position integer NOT NULL DEFAULT 0;'
Request 102 sql='ALTER TABLE llxmk_c_payment_term ADD COLUMN position integer NOT NULL DEFAULT 0;'
Request 103 sql='ALTER TABLE llxmk_product MODIFY COLUMN seuil_stock_alerte integer DEFAULT NULL;'
Request 104 sql='ALTER TABLE llxmk_facture_rec ADD COLUMN suspended integer DEFAULT 0;'
Request 105 sql='ALTER TABLE llxmk_facture_rec MODIFY COLUMN titre VARCHAR(100);'
Request 106 sql='ALTER TABLE llxmk_contrat MODIFY COLUMN ref varchar(50);'
Request 107 sql='ALTER TABLE llxmk_contrat MODIFY COLUMN ref_customer varchar(50);'
Request 108 sql='ALTER TABLE llxmk_contrat MODIFY COLUMN ref_supplier varchar(50);'
Request 109 sql='ALTER TABLE llxmk_contrat MODIFY COLUMN ref_ext varchar(50);'
Request 110 sql='UPDATE llxmk_c_email_templates SET position = 0 WHERE position IS NULL;'
Request 111 sql='UPDATE llxmk_c_email_templates SET lang = '' WHERE lang IS NULL;'
Request 112 sql='ALTER TABLE llxmk_c_email_templates ADD COLUMN enabled varchar(255) DEFAULT '1';'
Request 113 sql='ALTER TABLE llxmk_c_email_templates ADD COLUMN joinfiles varchar(255) DEFAULT '1';'
Request 114 sql='ALTER TABLE llxmk_c_email_templates MODIFY COLUMN content mediumtext;'
Request 115 sql='INSERT INTO llxmk_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,'(SendAnEMailToMember)',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 116 sql='INSERT INTO llxmk_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 117 sql='INSERT INTO llxmk_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 118 sql='INSERT INTO llxmk_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 119 sql='INSERT INTO llxmk_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 120 sql='UPDATE llxmk_c_accounting_category set code = 'VENTES', range_account='7xxxxx' where code = 'VTE';'
Request 121 sql='UPDATE llxmk_c_accounting_category set code = 'DEPENSES', range_account='6xxxxx' where code = 'MAR';'
Request 122 sql='UPDATE llxmk_c_accounting_category set code = 'PROFIT', range_account='Balance', formula = 'VENTES+DEPENSES' where code = 'MARGE';'
Request 123 sql='ALTER TABLE llxmk_menu MODIFY COLUMN perms text;'
Request 124 sql='ALTER TABLE llxmk_mailing MODIFY COLUMN titre varchar(128);'
Request 125 sql='ALTER TABLE llxmk_mailing MODIFY COLUMN sujet varchar(128);'
Request 126 sql='ALTER TABLE llxmk_mailing MODIFY COLUMN langs varchar(64);'
Request 127 sql='ALTER TABLE llxmk_facture_fourn ADD COLUMN date_pointoftax date DEFAULT NULL;'
Request 128 sql='ALTER TABLE llxmk_facture_fourn ADD COLUMN date_valid date;'
Request 129 sql='ALTER TABLE llxmk_bookmark DROP COLUMN fk_soc;'
Request 130 sql='ALTER TABLE llxmk_website MODIFY COLUMN ref varchar(128);'
Request 131 sql='ALTER TABLE llxmk_website_page MODIFY COLUMN pageurl varchar(255);'
Request 132 sql='ALTER TABLE llxmk_website_page ADD COLUMN lang varchar(6);'
Request 133 sql='ALTER TABLE llxmk_website_page ADD COLUMN fk_page integer;'
Request 134 sql='ALTER TABLE llxmk_website_page ADD COLUMN grabbed_from varchar(255);'
Request 135 sql='ALTER TABLE llxmk_website_page ADD COLUMN htmlheader mediumtext;'
Request 136 sql='ALTER TABLE llxmk_website_page MODIFY COLUMN htmlheader mediumtext;'
Request 137 sql='ALTER TABLE llxmk_website_page MODIFY COLUMN status INTEGER DEFAULT 1;'
Request 138 sql='UPDATE llxmk_website_page set status = 1 WHERE status IS NULL;'
Request 139 sql='ALTER TABLE llxmk_website ADD COLUMN import_key varchar(14);'
Request 140 sql='ALTER TABLE llxmk_website_page ADD COLUMN import_key varchar(14);'
Request 141 sql='ALTER TABLE llxmk_fichinter ADD COLUMN import_key varchar(14);'
Request 142 sql='ALTER TABLE llxmk_livraison ADD COLUMN import_key varchar(14);'
Request 143 sql='ALTER TABLE llxmk_livraison ADD COLUMN extraparams varchar(255);'
Request 144 sql='ALTER TABLE llxmk_don ADD COLUMN extraparams varchar(255);'
Request 145 sql='ALTER TABLE llxmk_accounting_account ADD COLUMN import_key varchar(14);'
Request 146 sql='ALTER TABLE llxmk_accounting_account ADD COLUMN extraparams varchar(255);'
Request 147 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN import_key varchar(14);'
Request 148 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN extraparams varchar(255);'
Request 149 sql='ALTER TABLE llxmk_accounting_bookkeeping_tmp ADD COLUMN extraparams varchar(255);'
Request 150 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN date_lim_reglement datetime DEFAULT NULL;'
Request 151 sql='ALTER TABLE llxmk_accounting_bookkeeping ADD COLUMN fk_user integer NULL;'
Request 152 sql='ALTER TABLE llxmk_accounting_bookkeeping_tmp ADD COLUMN date_lim_reglement datetime DEFAULT NULL;'
Request 153 sql='ALTER TABLE llxmk_accounting_bookkeeping_tmp ADD COLUMN fk_user integer NULL;'
Request 154 sql='ALTER TABLE llxmk_menu MODIFY fk_mainmenu varchar(100);'
Request 155 sql='ALTER TABLE llxmk_menu MODIFY fk_leftmenu varchar(100);'
Request 156 sql='CREATE TABLE llxmk_website_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 157 sql='ALTER TABLE llxmk_website_extrafields ADD INDEX idx_website_extrafields (fk_object);'
Request 158 sql='CREATE TABLE llxmk_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 NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,import_key varchar(14),status integer) ENGINE=innodb;'
Request 159 sql='ALTER TABLE llxmk_website_account ADD INDEX idx_website_account_rowid (rowid);'
Request 160 sql='ALTER TABLE llxmk_website_account ADD INDEX idx_website_account_login (login);'
Request 161 sql='ALTER TABLE llxmk_website_account ADD INDEX idx_website_account_import_key (import_key);'
Request 162 sql='ALTER TABLE llxmk_website_account ADD INDEX idx_website_account_status (status);'
Request 163 sql='ALTER TABLE llxmk_website_account ADD INDEX idx_website_account_fk_soc (fk_soc);'
Request 164 sql='ALTER TABLE llxmk_website_account ADD UNIQUE INDEX uk_website_account_login_website_soc(login, fk_website, fk_soc);'
Request 165 sql='ALTER TABLE llxmk_website_account ADD CONSTRAINT llxmk_website_account_fk_website FOREIGN KEY (fk_website) REFERENCES llxmk_website(rowid);'
Request 166 sql='CREATE TABLE llxmk_website_account_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 167 sql='ALTER TABLE llxmk_website_account_extrafields ADD INDEX idx_website_account_extrafields (fk_object);'
Request 168 sql='alter table llxmk_user add column pass_encoding varchar(24) NULL;'
Request 169 sql='CREATE TABLE IF NOT EXISTS llxmk_expensereport_ik (rowid integer AUTO_INCREMENT PRIMARY KEY,datec datetime DEFAULT NULL,tms 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 170 sql='ALTER TABLE llxmk_expensereport_ik ADD COLUMN ikoffset double DEFAULT 0 NOT NULL;'
Request 171 sql='CREATE TABLE IF NOT EXISTS llxmk_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 172 sql='CREATE TABLE IF NOT EXISTS llxmk_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 173 sql='INSERT INTO llxmk_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 174 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (1,4, 1, 0.41, 0);'
Request 175 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (2,4, 2, 0.244, 824);'
Request 176 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (3,4, 3, 0.286, 0);'
Request 177 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (4,5, 4, 0.493, 0);'
Request 178 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (5,5, 5, 0.277, 1082);'
Request 179 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (6,5, 6, 0.332, 0);'
Request 180 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (7,6, 7, 0.543, 0);'
Request 181 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (8,6, 8, 0.305, 1180);'
Request 182 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (9,6, 9, 0.364, 0);'
Request 183 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (10,7, 10, 0.568, 0);'
Request 184 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (11,7, 11, 0.32, 1244);'
Request 185 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (12,7, 12, 0.382, 0);'
Request 186 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (13,8, 13, 0.595, 0);'
Request 187 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (14,8, 14, 0.337, 1288);'
Request 188 sql='INSERT INTO llxmk_expensereport_ik (rowid, fk_c_exp_tax_cat, fk_range, coef, ikoffset) values (15,8, 15, 0.401, 0);'
Request 189 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (1,'ExpAutoCat', 1, 1);'
Request 190 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (2,'ExpCycloCat', 1, 1);'
Request 191 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (3,'ExpMotoCat', 1, 1);'
Request 192 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (4,'ExpAuto3CV', 1, 1);'
Request 193 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (5,'ExpAuto4CV', 1, 1);'
Request 194 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (6,'ExpAuto5CV', 1, 1);'
Request 195 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (7,'ExpAuto6CV', 1, 1);'
Request 196 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (8,'ExpAuto7CV', 1, 1);'
Request 197 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (9,'ExpAuto8CV', 1, 1);'
Request 198 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (10,'ExpAuto9CV', 1, 1);'
Request 199 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (11,'ExpAuto10CV', 1, 1);'
Request 200 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (12,'ExpAuto11CV', 1, 1);'
Request 201 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (13,'ExpAuto12CV', 1, 1);'
Request 202 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (14,'ExpAuto3PCV', 1, 1);'
Request 203 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (15,'ExpAuto4PCV', 1, 1);'
Request 204 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (16,'ExpAuto5PCV', 1, 1);'
Request 205 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (17,'ExpAuto6PCV', 1, 1);'
Request 206 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (18,'ExpAuto7PCV', 1, 1);'
Request 207 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (19,'ExpAuto8PCV', 1, 1);'
Request 208 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (20,'ExpAuto9PCV', 1, 1);'
Request 209 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (21,'ExpAuto10PCV', 1, 1);'
Request 210 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (22,'ExpAuto11PCV', 1, 1);'
Request 211 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (23,'ExpAuto12PCV', 1, 1);'
Request 212 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (24,'ExpAuto13PCV', 1, 1);'
Request 213 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (25,'ExpCyclo', 1, 1);'
Request 214 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (26,'ExpMoto12CV', 1, 1);'
Request 215 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (27,'ExpMoto345CV', 1, 1);'
Request 216 sql='INSERT INTO llxmk_c_exp_tax_cat (rowid, label, entity, active) values (28,'ExpMoto5PCV', 1, 1);'
Request 217 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (1,4, 0, 1, 1);'
Request 218 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (2,4, 5000, 1, 1);'
Request 219 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (3,4, 20000, 1, 1);'
Request 220 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (4,5, 0, 1, 1);'
Request 221 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (5,5, 5000, 1, 1);'
Request 222 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (6,5, 20000, 1, 1);'
Request 223 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (7,6, 0, 1, 1);'
Request 224 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (8,6, 5000, 1, 1);'
Request 225 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (9,6, 20000, 1, 1);'
Request 226 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (10,7, 0, 1, 1);'
Request 227 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (11,7, 5000, 1, 1);'
Request 228 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (12,7, 20000, 1, 1);'
Request 229 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (13,8, 0, 1, 1);'
Request 230 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (14,8, 5000, 1, 1);'
Request 231 sql='INSERT INTO llxmk_c_exp_tax_range (rowid,fk_c_exp_tax_cat,range_ik, entity, active) values (15,8, 20000, 1, 1);'
Request 232 sql='CREATE TABLE llxmk_expensereport_rules (rowid integer AUTO_INCREMENT PRIMARY KEY,datec datetime DEFAULT NULL,tms 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 233 sql='ALTER TABLE llxmk_expensereport_det ADD COLUMN rule_warning_message text;'
Request 234 sql='ALTER TABLE llxmk_expensereport_det ADD COLUMN fk_c_exp_tax_cat integer;'
Request 235 sql='ALTER TABLE llxmk_user ADD COLUMN default_range integer;'
Request 236 sql='ALTER TABLE llxmk_user ADD COLUMN default_c_exp_tax_cat integer;'
Request 237 sql='ALTER TABLE llxmk_extrafields ADD COLUMN fk_user_author integer;'
Request 238 sql='ALTER TABLE llxmk_extrafields ADD COLUMN fk_user_modif integer;'
Request 239 sql='ALTER TABLE llxmk_extrafields ADD COLUMN datec datetime;'
Request 240 sql='ALTER TABLE llxmk_extrafields ADD COLUMN enabled varchar(255) DEFAULT '1';'
Request 241 sql='ALTER TABLE llxmk_extrafields ADD COLUMN tms timestamp;'
Request 242 sql='UPDATE llxmk_extrafields SET list = 1 WHERE list = 0 AND fk_user_author IS NULL and fk_user_modif IS NULL and datec IS NULL;'
Request 243 sql='UPDATE llxmk_extrafields SET list = 3 WHERE type = 'separate' AND list != 3;'
Request 244 sql='ALTER TABLE llxmk_extrafields MODIFY COLUMN list integer DEFAULT 1;'
Request 245 sql='ALTER TABLE llxmk_extrafields MODIFY COLUMN langs varchar(64);'
Request 246 sql='ALTER TABLE llxmk_holiday_config MODIFY COLUMN name varchar(128);'
Request 247 sql='ALTER TABLE llxmk_holiday_config ADD UNIQUE INDEX idx_holiday_config (name);'
Request 248 sql='ALTER TABLE llxmk_societe MODIFY COLUMN ref_ext varchar(255);'
Request 249 sql='ALTER TABLE llxmk_socpeople MODIFY COLUMN ref_ext varchar(255);'
Request 250 sql='ALTER TABLE llxmk_actioncomm MODIFY COLUMN ref_ext varchar(255);'
Request 251 sql='ALTER TABLE llxmk_expedition MODIFY COLUMN ref_ext varchar(255);'
Request 252 sql='ALTER TABLE llxmk_livraison MODIFY COLUMN ref_ext varchar(255);'
Request 253 sql='ALTER TABLE llxmk_contrat MODIFY COLUMN ref_ext varchar(255);'
Request 254 sql='ALTER TABLE llxmk_actioncomm MODIFY COLUMN label varchar(255) NOT NULL;'
Request 255 sql='ALTER TABLE llxmk_actioncomm ADD INDEX idx_actioncomm_fk_user_action (fk_user_action);'
Request 256 sql='ALTER TABLE llxmk_actioncomm ADD INDEX idx_actioncomm_fk_project (fk_project);'
Request 257 sql='ALTER TABLE llxmk_actioncomm ADD INDEX idx_actioncomm_datep (datep);'
Request 258 sql='ALTER TABLE llxmk_actioncomm ADD INDEX idx_actioncomm_datep2 (datep2);'
Request 259 sql='ALTER TABLE llxmk_actioncomm ADD INDEX idx_actioncomm_recurid (recurid);'
Request 260 sql='ALTER TABLE llxmk_actioncomm ADD INDEX idx_actioncomm_ref_ext (ref_ext);'
Request 261 sql='ALTER TABLE llxmk_payment_various ADD COLUMN fk_projet integer DEFAULT NULL after accountancy_code;'
Request 262 sql='UPDATE llxmk_const set name = __ENCRYPT('ONLINE_PAYMENT_MESSAGE_OK')__ where name = __ENCRYPT('PAYPAL_MESSAGE_OK')__;'
Request 263 sql='UPDATE llxmk_const set name = __ENCRYPT('ONLINE_PAYMENT_MESSAGE_KO')__ where name = __ENCRYPT('PAYPAL_MESSAGE_KO')__;'
Request 264 sql='UPDATE llxmk_const set name = __ENCRYPT('ONLINE_PAYMENT_CREDITOR')__ where name = __ENCRYPT('PAYPAL_CREDITOR')__;'
Request 265 sql='UPDATE llxmk_const set name = __ENCRYPT('ONLINE_PAYMENT_CSS_URL')__ where name = __ENCRYPT('PAYPAL_CSS_URL')__;'
Request 266 sql='UPDATE llxmk_const set name = __ENCRYPT('ONLINE_PAYMENT_NEWFORMTEXT')__ where name = __ENCRYPT('PAYPAL_NEWFORMTEXT')__;'
Request 267 sql='UPDATE llxmk_const set name = __ENCRYPT('ONLINE_PAYMENT_LOGO')__ where name = __ENCRYPT('PAYPAL_LOGO')__;'
Request 268 sql='ALTER TABLE llxmk_accounting_system ADD COLUMN fk_country integer;'
Request 269 sql='UPDATE llxmk_accounting_account SET pcg_type = 'INCOME' where pcg_type = 'PROD';'
Request 270 sql='UPDATE llxmk_accounting_account SET pcg_type = 'EXPENSE' where pcg_type = 'CHARGE';'
Request 271 sql='UPDATE llxmk_accounting_account SET pcg_type = 'INCOME' where pcg_type = 'VENTAS_E_INGRESOS';'
Request 272 sql='UPDATE llxmk_accounting_account SET pcg_type = 'EXPENSE' where pcg_type = 'COMPRAS_GASTOS';'
Request 273 sql='ALTER TABLE llxmk_c_action_trigger MODIFY COLUMN elementtype varchar(24) NOT NULL;'
Request 274 sql='insert into llxmk_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 275 sql='insert into llxmk_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 276 sql='insert into llxmk_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 277 sql='insert into llxmk_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 278 sql='insert into llxmk_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 279 sql='DROP TABLE llxmk_projet_task_comment;'
Request 280 sql='CREATE TABLE llxmk_comment (rowid integer AUTO_INCREMENT PRIMARY KEY,datec datetime DEFAULT NULL,tms 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 281 sql='DELETE FROM llxmk_const where name = __ENCRYPT('MAIN_SHOW_WORKBOARD')__;'
Request 282 sql='UPDATE llxmk_const SET value = REPLACE(value, '%', '__') WHERE name LIKE 'ADHERENT%';'
Request 283 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_SELL_JOURNAL')__;'
Request 284 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_PURCHASE_JOURNAL')__;'
Request 285 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_SOCIAL_JOURNAL')__;'
Request 286 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_MISCELLANEOUS_JOURNAL')__;'
Request 287 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_GROUPBYACCOUNT')__;'
Request 288 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_GLOBAL_ACCOUNT')__;'
Request 289 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_LABEL')__;'
Request 290 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_AMOUNT')__;'
Request 291 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_DEVISE')__;'
Request 292 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_EXPORT_PIECE')__;'
Request 293 sql='DELETE FROM llxmk_const WHERE name = __ENCRYPT('ACCOUNTING_EXPENSEREPORT_JOURNAL')__;'
Request 294 sql='ALTER TABLE llxmk_c_paiement DROP PRIMARY KEY;'
Request 295 sql='ALTER TABLE llxmk_c_paiement ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER id;'
Request 296 sql='ALTER TABLE llxmk_c_paiement DROP INDEX uk_c_paiement;'
Request 297 sql='ALTER TABLE llxmk_c_paiement ADD UNIQUE INDEX uk_c_paiement(id, entity, code);'
Request 298 sql='ALTER TABLE llxmk_c_payment_term DROP PRIMARY KEY;'
Request 299 sql='ALTER TABLE llxmk_c_payment_term ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 300 sql='ALTER TABLE llxmk_c_payment_term ADD UNIQUE INDEX uk_c_payment_term(rowid, entity, code);'
Request 301 sql='ALTER TABLE llxmk_projet CHANGE datec datec datetime;'
Request 302 sql='create table llxmk_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,label varchar(255),email varchar(255),signature text,position smallint,active tinyint DEFAULT 1 NOT NULL)ENGINE=innodb;'
Request 303 sql='ALTER TABLE llxmk_c_email_senderprofile ADD UNIQUE INDEX uk_c_email_senderprofile(entity, label, email);'
Request 304 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 67,'PC-MIPYME', 'The PYME accountancy Chile plan', 1);'
Request 305 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 7,'ENG-BASE', 'England plan', 1);'
Request 306 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 49,'SYSCOHADA-BJ', 'Plan comptable Ouest-Africain', 1);'
Request 307 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 60,'SYSCOHADA-BF', 'Plan comptable Ouest-Africain', 1);'
Request 308 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 24,'SYSCOHADA-CM', 'Plan comptable Ouest-Africain', 1);'
Request 309 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 65,'SYSCOHADA-CF', 'Plan comptable Ouest-Africain', 1);'
Request 310 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 71,'SYSCOHADA-KM', 'Plan comptable Ouest-Africain', 1);'
Request 311 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 72,'SYSCOHADA-CG', 'Plan comptable Ouest-Africain', 1);'
Request 312 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 21,'SYSCOHADA-CI', 'Plan comptable Ouest-Africain', 1);'
Request 313 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 16,'SYSCOHADA-GA', 'Plan comptable Ouest-Africain', 1);'
Request 314 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 87,'SYSCOHADA-GQ', 'Plan comptable Ouest-Africain', 1);'
Request 315 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES (147,'SYSCOHADA-ML', 'Plan comptable Ouest-Africain', 1);'
Request 316 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES (168,'SYSCOHADA-NE', 'Plan comptable Ouest-Africain', 1);'
Request 317 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 73,'SYSCOHADA-CD', 'Plan comptable Ouest-Africain', 1);'
Request 318 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 22,'SYSCOHADA-SN', 'Plan comptable Ouest-Africain', 1);'
Request 319 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 66,'SYSCOHADA-TD', 'Plan comptable Ouest-Africain', 1);'
Request 320 sql='INSERT INTO llxmk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 15,'SYSCOHADA-TG', 'Plan comptable Ouest-Africain', 1);'
Request 321 sql='UPDATE llxmk_accounting_system SET fk_country = 1 WHERE pcg_version = 'PCG99-ABREGE';'
Request 322 sql='UPDATE llxmk_accounting_system SET fk_country = 1 WHERE pcg_version = 'PCG99-BASE';'
Request 323 sql='UPDATE llxmk_accounting_system SET fk_country = 1 WHERE pcg_version = 'PCG14-DEV';'
Request 324 sql='UPDATE llxmk_accounting_system SET fk_country = 2 WHERE pcg_version = 'PCMN-BASE';'
Request 325 sql='UPDATE llxmk_accounting_system SET fk_country = 4 WHERE pcg_version = 'PCG08-PYME';'
Request 326 sql='UPDATE llxmk_accounting_system SET fk_country = 10 WHERE pcg_version = 'PCT';'
Request 327 sql='UPDATE llxmk_accounting_system SET fk_country = 80 WHERE pcg_version = 'DK-STD';'
Request 328 sql='UPDATE llxmk_accounting_system SET fk_country = 67 WHERE pcg_version = 'PC-MIPYME';'
Request 329 sql='UPDATE llxmk_accounting_system SET fk_country = 6 WHERE pcg_version = 'PCG_SUISSE';'
Request 330 sql='UPDATE llxmk_accounting_system SET fk_country =140 WHERE pcg_version = 'PCN-LUXEMBURG';'
Request 331 sql='UPDATE llxmk_accounting_system SET fk_country = 12 WHERE pcg_version = 'PCG';'
Request 332 sql='CREATE TABLE llxmk_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 333 sql='ALTER TABLE llxmk_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_rowid (rowid);'
Request 334 sql='ALTER TABLE llxmk_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_dateremind (dateremind);'
Request 335 sql='ALTER TABLE llxmk_actioncomm_reminder ADD INDEX idx_actioncomm_reminder_fk_user (fk_user);'
Request 336 sql='ALTER TABLE llxmk_actioncomm_reminder ADD UNIQUE INDEX uk_actioncomm_reminder_unique(fk_user, typeremind, offsetvalue, offsetunit);'
Request 337 sql='UPDATE llxmk_tva SET datec = tms where datec IS NULL;'
Request 338 sql='create table llxmk_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,name varchar(255) NOT NULL,ip varchar(128),pathoffile varchar(255))ENGINE=innodb;'
Request 339 sql='ALTER TABLE llxmk_resource ADD UNIQUE INDEX uk_resource_ref (ref, entity);'
Request 340 sql='ALTER TABLE llxmk_facture_rec ADD COLUMN modelpdf varchar(255) AFTER note_public;'
Request 341 sql='ALTER TABLE llxmk_facture_rec ADD COLUMN generate_pdf integer DEFAULT 1 AFTER auto_validate;'
Request 342 sql='ALTER TABLE llxmk_blockedlog ADD COLUMN date_creation datetime;'
Request 343 sql='ALTER TABLE llxmk_blockedlog ADD COLUMN user_fullname varchar(255);'
Request 344 sql='ALTER TABLE llxmk_blockedlog MODIFY COLUMN ref_object varchar(255);'
Request 345 sql='ALTER TABLE llxmk_blockedlog MODIFY COLUMN amounts double(24,8);'
Request 346 sql='ALTER TABLE llxmk_chargessociales MODIFY COLUMN amount double(24,8);'
Request 347 sql='ALTER TABLE llxmk_commande MODIFY COLUMN amount_ht double(24,8);'
Request 348 sql='ALTER TABLE llxmk_commande_fournisseur MODIFY COLUMN amount_ht double(24,8);'
Request 349 sql='ALTER TABLE llxmk_don MODIFY COLUMN amount double(24,8);'
Request 350 sql='ALTER TABLE llxmk_expensereport_rules MODIFY COLUMN amount double(24,8);'
Request 351 sql='ALTER TABLE llxmk_loan MODIFY COLUMN capital double(24,8);'
Request 352 sql='ALTER TABLE llxmk_loan MODIFY COLUMN capital_position double(24,8);'
Request 353 sql='ALTER TABLE llxmk_loan_schedule MODIFY COLUMN amount_capital double(24,8);'
Request 354 sql='ALTER TABLE llxmk_loan_schedule MODIFY COLUMN amount_insurance double(24,8);'
Request 355 sql='ALTER TABLE llxmk_loan_schedule MODIFY COLUMN amount_interest double(24,8);'
Request 356 sql='ALTER TABLE llxmk_paiementcharge MODIFY COLUMN amount double(24,8);'
Request 357 sql='ALTER TABLE llxmk_paiementfourn MODIFY COLUMN amount double(24,8);'
Request 358 sql='ALTER TABLE llxmk_payment_donation MODIFY COLUMN amount double(24,8);'
Request 359 sql='ALTER TABLE llxmk_payment_expensereport MODIFY COLUMN amount double(24,8);'
Request 360 sql='ALTER TABLE llxmk_payment_loan MODIFY COLUMN amount_capital double(24,8);'
Request 361 sql='ALTER TABLE llxmk_payment_loan MODIFY COLUMN amount_insurance double(24,8);'
Request 362 sql='ALTER TABLE llxmk_payment_loan MODIFY COLUMN amount_interest double(24,8);'
Request 363 sql='ALTER TABLE llxmk_payment_salary MODIFY COLUMN salary double(24,8);'
Request 364 sql='ALTER TABLE llxmk_payment_salary MODIFY COLUMN amount double(24,8);'
Request 365 sql='ALTER TABLE llxmk_prelevement_bons MODIFY COLUMN amount double(24,8);'
Request 366 sql='ALTER TABLE llxmk_prelevement_facture_demande MODIFY COLUMN amount double(24,8);'
Request 367 sql='ALTER TABLE llxmk_prelevement_lignes MODIFY COLUMN amount double(24,8);'
Request 368 sql='ALTER TABLE llxmk_societe MODIFY COLUMN capital double(24,8);'
Request 369 sql='ALTER TABLE llxmk_tva MODIFY COLUMN amount double(24,8);'
Request 370 sql='ALTER TABLE llxmk_subscription MODIFY COLUMN subscription double(24,8);'
Request 371 sql='ALTER TABLE llxmk_resource ADD fk_country integer DEFAULT NULL;'
Request 372 sql='ALTER TABLE llxmk_resource ADD INDEX idx_resource_fk_country (fk_country);'
Request 373 sql='ALTER TABLE llxmk_resource ADD CONSTRAINT fk_resource_fk_country FOREIGN KEY (fk_country) REFERENCES llxmk_c_country (rowid);'
Request 374 sql='create table llxmk_facture_rec_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 375 sql='ALTER TABLE llxmk_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);'
Request 376 sql='UPDATE llxmk_cronjob set entity = 1 where entity = 0 and label in ('RecurringInvoices', 'SendEmailsReminders');'
Request 377 sql='UPDATE llxmk_cronjob set entity = 0 where entity = 1 and label in ('PurgeDeleteTemporaryFilesShort', 'MakeLocalDatabaseDumpShort');'
Script processingOK