Dolibarr logo
12.0.1

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : localhostOK
Database connection : hcspharma_dol193OK
Database server version5.5.5-10.3.27-MariaDB
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script7.0.0-8.0.0.sql
Request 1 sql='ALTER TABLE llx_c_ziptown DROP FOREIGN KEY fk_c_ziptown_fk_pays;'
Request 2 sql='ALTER TABLE llx_c_ziptown ADD CONSTRAINT fk_c_ziptown_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_country(rowid);'
Request 3 sql='DROP INDEX nom on llx_societe;'
Request 4 sql='ALTER TABLE llx_c_regions drop FOREIGN KEY fk_c_regions_fk_pays;'
Request 5 sql='ALTER TABLE llx_product_association ADD COLUMN rowid integer AUTO_INCREMENT PRIMARY KEY;'
Request 6 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;'
Request 7 sql='ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;'
Request 8 sql='ALTER TABLE llx_website_page ADD COLUMN type_container varchar(16) NOT NULL DEFAULT 'page';'
Request 9 sql='ALTER TABLE llx_ecm_files DROP INDEX uk_ecm_files;'
Request 10 sql='ALTER TABLE llx_ecm_files ADD UNIQUE INDEX uk_ecm_files (filepath, filename, entity);'
Request 11 sql='UPDATE llx_const set name = __ENCRYPT('INVOICE_FREE_TEXT')__ where name = __ENCRYPT('FACTURE_FREE_TEXT')__;'
Request 12 sql='ALTER TABLE llx_chargesociales MODIFY COLUMN amount double(24,8);'
Request 13 sql='DROP TABLE llx_c_accountancy_category;'
Request 14 sql='DROP TABLE llx_c_accountingaccount;'
Request 15 sql='update llx_propal set fk_statut = 1 where fk_statut = -1;'
Request 16 sql='ALTER TABLE llx_inventory ADD COLUMN fk_user_creat integer;'
Request 17 sql='ALTER TABLE llx_inventory ADD COLUMN fk_user_modif integer;'
Request 18 sql='ALTER TABLE llx_inventory ADD COLUMN fk_user_valid integer;'
Request 19 sql='ALTER TABLE llx_inventory ADD COLUMN import_key varchar(14);'
Request 20 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, 'PCG14-DEV', 'The developed accountancy french plan 2014', 1);'
Request 21 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 6, 'PCG_SUISSE', 'Switzerland plan', 1);'
Request 22 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (140, 'PCN-LUXEMBURG', 'Plan comptable normalisé Luxembourgeois', 1);'
Request 23 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 80, 'DK-STD', 'Standardkontoplan fra SKAT', 1);'
Request 24 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 10, 'PCT', 'The Tunisia plan', 1);'
Request 25 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 12, 'PCG', 'The Moroccan chart of accounts', 1);'
Request 26 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 67,'PC-MIPYME', 'The PYME accountancy Chile plan', 1);'
Request 27 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 7,'ENG-BASE', 'England plan', 1);'
Request 28 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 49,'SYSCOHADA-BJ', 'Plan comptable Ouest-Africain', 1);'
Request 29 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 60,'SYSCOHADA-BF', 'Plan comptable Ouest-Africain', 1);'
Request 30 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 24,'SYSCOHADA-CM', 'Plan comptable Ouest-Africain', 1);'
Request 31 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 65,'SYSCOHADA-CF', 'Plan comptable Ouest-Africain', 1);'
Request 32 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 71,'SYSCOHADA-KM', 'Plan comptable Ouest-Africain', 1);'
Request 33 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 72,'SYSCOHADA-CG', 'Plan comptable Ouest-Africain', 1);'
Request 34 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 21,'SYSCOHADA-CI', 'Plan comptable Ouest-Africain', 1);'
Request 35 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 16,'SYSCOHADA-GA', 'Plan comptable Ouest-Africain', 1);'
Request 36 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 87,'SYSCOHADA-GQ', 'Plan comptable Ouest-Africain', 1);'
Request 37 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (147,'SYSCOHADA-ML', 'Plan comptable Ouest-Africain', 1);'
Request 38 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (168,'SYSCOHADA-NE', 'Plan comptable Ouest-Africain', 1);'
Request 39 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 73,'SYSCOHADA-CD', 'Plan comptable Ouest-Africain', 1);'
Request 40 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 22,'SYSCOHADA-SN', 'Plan comptable Ouest-Africain', 1);'
Request 41 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 66,'SYSCOHADA-TD', 'Plan comptable Ouest-Africain', 1);'
Request 42 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 15,'SYSCOHADA-TG', 'Plan comptable Ouest-Africain', 1);'
Request 43 sql='DROP TABLE llx_website_account;'
Request 44 sql='DROP TABLE llx_website_account_extrafields;'
Request 45 sql='ALTER TABLE llx_paiementfourn ADD COLUMN fk_user_modif integer AFTER fk_user_author;'
Request 46 sql='DELETE FROM llx_rights_def WHERE perms = 'main' and module = 'commercial';'
Request 47 sql='delete from llx_rights_def where perms IS NULL;'
Request 48 sql='delete from llx_user_rights where fk_user not IN (select rowid from llx_user);'
Request 49 sql='delete from llx_usergroup_rights where fk_usergroup not in (select rowid from llx_usergroup);'
Request 50 sql='delete from llx_usergroup_rights where fk_id not in (select id from llx_rights_def);'
Request 51 sql='ALTER TABLE llx_inventory ADD COLUMN fk_product integer DEFAULT NULL;'
Request 52 sql='ALTER TABLE llx_inventory MODIFY COLUMN fk_warehouse integer DEFAULT NULL;'
Request 53 sql='ALTER TABLE llx_c_type_fees DROP COLUMN llx_c_type_fees;'
Request 54 sql='ALTER TABLE llx_c_type_fees ADD COLUMN type integer DEFAULT 0;'
Request 55 sql='ALTER TABLE llx_c_ecotaxe CHANGE COLUMN libelle label varchar(255);'
Request 56 sql='ALTER TABLE llx_product_fournisseur_price DROP COLUMN unitcharges;'
Request 57 sql='ALTER TABLE llx_societe ADD COLUMN fk_entrepot integer DEFAULT 0;'
Request 58 sql='ALTER TABLE llx_projet ADD COLUMN bill_time integer DEFAULT 0;'
Request 59 sql='ALTER TABLE llx_societe ADD COLUMN order_min_amount double(24,8) DEFAULT NULL AFTER outstanding_limit;'
Request 60 sql='ALTER TABLE llx_societe ADD COLUMN supplier_order_min_amount double(24,8) DEFAULT NULL AFTER order_min_amount;'
Request 61 sql='create table llx_c_type_container(rowid integer AUTO_INCREMENT PRIMARY KEY,code varchar(32) NOT NULL,entity integer DEFAULT 1 NOT NULL,label varchar(64) NOT NULL,module varchar(32) NULL,active tinyint DEFAULT 1 NOT NULL)ENGINE=innodb;'
Request 62 sql='ALTER TABLE llx_c_type_container ADD UNIQUE INDEX uk_c_type_container_id (code, entity);'
Request 63 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN discount_type integer DEFAULT 0 NOT NULL AFTER fk_soc;'
Request 64 sql='ALTER TABLE llx_societe_remise_except ADD INDEX idx_societe_remise_except_discount_type (discount_type);'
Request 65 sql='ALTER TABLE llx_societe ADD COLUMN remise_supplier real DEFAULT 0 AFTER remise_client;'
Request 66 sql='CREATE TABLE llx_societe_remise_supplier(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,fk_soc integer NOT NULL,tms timestamp,datec datetime,fk_user_author integer,remise_supplier double(6,3) DEFAULT 0 NOT NULL,note text)ENGINE=innodb;'
Request 67 sql='insert into llx_c_type_container (code,label,module,active) values ('page', 'Page', 'system', 1);'
Request 68 sql='insert into llx_c_type_container (code,label,module,active) values ('banner', 'Banner', 'system', 1);'
Request 69 sql='insert into llx_c_type_container (code,label,module,active) values ('blogpost', 'BlogPost', 'system', 1);'
Request 70 sql='insert into llx_c_type_container (code,label,module,active) values ('other', 'Other', 'system', 1);'
Request 71 sql='ALTER TABLE llx_product_fournisseur_price CHANGE COLUMN multicurrency_price_ttc multicurrency_unitprice DOUBLE(24,8) NULL DEFAULT NULL;'
Request 72 sql='ALTER TABLE llx_product_fournisseur_price_log CHANGE COLUMN multicurrency_price_ttc multicurrency_unitprice DOUBLE(24,8) NULL DEFAULT NULL;'
Request 73 sql='ALTER TABLE llx_expensereport_det ADD COLUMN docnumber varchar(128) after fk_expensereport;'
Request 74 sql='ALTER TABLE llx_website_page ADD COLUMN aliasalt varchar(255) after pageurl;'
Request 75 sql='DELETE FROM llx_c_paiement WHERE code = '' or code = '-' or id = 0;'
Request 76 sql='DROP TABLE llx_c_paiement_temp;'
Request 77 sql='CREATE TABLE llx_c_paiement_temp AS SELECT * FROM llx_c_paiement;'
Request 78 sql='DELETE FROM llx_c_paiement WHERE entity > 1 AND id IN (SELECT cp2.id FROM llx_c_paiement_temp as cp2 WHERE cp2.entity = 1);'
Request 79 sql='ALTER TABLE llx_c_paiement DROP INDEX uk_c_paiement;'
Request 80 sql='ALTER TABLE llx_c_paiement ADD UNIQUE INDEX uk_c_paiement_code(entity, code);'
Request 81 sql='ALTER TABLE llx_c_paiement CHANGE COLUMN id id INTEGER AUTO_INCREMENT PRIMARY KEY;'
Request 82 sql='ALTER TABLE llx_c_payment_term DROP INDEX uk_c_payment_term;'
Request 83 sql='ALTER TABLE llx_c_payment_term ADD UNIQUE INDEX uk_c_payment_term_code(entity, code);'
Request 84 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN rowid rowid INTEGER AUTO_INCREMENT PRIMARY KEY;'
Request 85 sql='ALTER TABLE llx_oauth_token ADD COLUMN tokenstring text;'
Request 86 sql='ALTER TABLE llx_societe_rib ADD COLUMN type varchar(32) DEFAULT 'ban' after rowid;'
Request 87 sql='ALTER TABLE llx_societe_rib ADD COLUMN last_four varchar(4);'
Request 88 sql='ALTER TABLE llx_societe_rib ADD COLUMN card_type varchar(255);'
Request 89 sql='ALTER TABLE llx_societe_rib ADD COLUMN cvn varchar(255);'
Request 90 sql='ALTER TABLE llx_societe_rib ADD COLUMN exp_date_month INTEGER;'
Request 91 sql='ALTER TABLE llx_societe_rib ADD COLUMN exp_date_year INTEGER;'
Request 92 sql='ALTER TABLE llx_societe_rib ADD COLUMN country_code varchar(10);'
Request 93 sql='ALTER TABLE llx_societe_rib ADD COLUMN approved integer DEFAULT 0;'
Request 94 sql='ALTER TABLE llx_societe_rib ADD COLUMN email varchar(255);'
Request 95 sql='ALTER TABLE llx_societe_rib ADD COLUMN ending_date date;'
Request 96 sql='ALTER TABLE llx_societe_rib ADD COLUMN max_total_amount_of_all_payments double(24,8);'
Request 97 sql='ALTER TABLE llx_societe_rib ADD COLUMN preapproval_key varchar(255);'
Request 98 sql='ALTER TABLE llx_societe_rib ADD COLUMN starting_date date;'
Request 99 sql='ALTER TABLE llx_societe_rib ADD COLUMN total_amount_of_all_payments double(24,8);'
Request 100 sql='ALTER TABLE llx_societe_rib ADD COLUMN stripe_card_ref varchar(128);'
Request 101 sql='ALTER TABLE llx_societe_rib ADD COLUMN status integer NOT NULL DEFAULT 1;'
Request 102 sql='UPDATE llx_societe_rib set type = 'ban' where type = '' OR type IS NULL;'
Request 103 sql='ALTER TABLE llx_societe_rib MODIFY COLUMN type varchar(32) NOT NULL;'
Request 104 sql='ALTER TABLE llx_ticket_msg DROP FOREIGN KEY fk_ticket_msg_fk_track_id;'
Request 105 sql='CREATE TABLE llx_ticket(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1,ref varchar(128) NOT NULL,track_id varchar(128) NOT NULL,fk_soc integer DEFAULT 0,fk_project integer DEFAULT 0,origin_email varchar(128),fk_user_create integer,fk_user_assign integer,subject varchar(255),message text,fk_statut integer,resolution integer,progress varchar(100),timing varchar(20),type_code varchar(32),category_code varchar(32),severity_code varchar(32),datec datetime,date_read datetime,date_close datetime,notify_tiers_at_create tinyint,tms timestamp)ENGINE=innodb;'
Request 106 sql='ALTER TABLE llx_ticket ADD COLUMN notify_tiers_at_create integer;'
Request 107 sql='ALTER TABLE llx_ticket DROP INDEX uk_ticket_rowid_track_id;'
Request 108 sql='ALTER TABLE llx_ticket ADD UNIQUE uk_ticket_track_id (track_id);'
Request 109 sql='CREATE TABLE llx_ticket_msg(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1,fk_track_id varchar(128),fk_user_action integer,datec datetime,message text,private integer DEFAULT 0)ENGINE=innodb;'
Request 110 sql='ALTER TABLE llx_ticket_msg ADD CONSTRAINT fk_ticket_msg_fk_track_id FOREIGN KEY (fk_track_id) REFERENCES llx_ticket (track_id);'
Request 111 sql='CREATE TABLE llx_ticket_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14))ENGINE=innodb;'
Request 112 sql='create table llx_facture_rec_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 113 sql='create table llx_c_ticket_severity(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1,code varchar(32) NOT NULL,pos varchar(32) NOT NULL,label varchar(128) NOT NULL,color varchar(10) NOT NULL,active integer DEFAULT 1,use_default integer DEFAULT 1,description varchar(255))ENGINE=innodb;'
Request 114 sql='create table llx_c_ticket_type(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1,code varchar(32) NOT NULL,pos varchar(32) NOT NULL,label varchar(128) NOT NULL,active integer DEFAULT 1,use_default integer DEFAULT 1,description varchar(255))ENGINE=innodb;'
Request 115 sql='create table llx_c_ticket_category(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1,code varchar(32) NOT NULL,pos varchar(32) NOT NULL,label varchar(128) NOT NULL,active integer DEFAULT 1,use_default integer DEFAULT 1,description varchar(255))ENGINE=innodb;'
Request 116 sql='ALTER TABLE llx_c_ticket_category ADD UNIQUE INDEX uk_code (code, entity);'
Request 117 sql='ALTER TABLE llx_c_ticket_severity ADD UNIQUE INDEX uk_code (code, entity);'
Request 118 sql='ALTER TABLE llx_c_ticket_type ADD UNIQUE INDEX uk_code (code, entity);'
Request 119 sql='INSERT INTO llx_c_ticket_severity (code, pos, label, color, active, use_default, description) VALUES('LOW', '10', 'Low', '', 1, 0, NULL);'
Request 120 sql='INSERT INTO llx_c_ticket_severity (code, pos, label, color, active, use_default, description) VALUES('NORMAL', '20', 'Normal', '', 1, 1, NULL);'
Request 121 sql='INSERT INTO llx_c_ticket_severity (code, pos, label, color, active, use_default, description) VALUES('HIGH', '30', 'High', '', 1, 0, NULL);'
Request 122 sql='INSERT INTO llx_c_ticket_severity (code, pos, label, color, active, use_default, description) VALUES('BLOCKING', '40', 'Critical / blocking', '', 1, 0, NULL);'
Request 123 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('COM', '10', 'Commercial question', 1, 1, NULL);'
Request 124 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('ISSUE', '20', 'Issue or problem' , 1, 0, NULL);'
Request 125 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('REQUEST', '25', 'Change or enhancement request', 1, 0, NULL);'
Request 126 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('PROJECT', '30', 'Project', 0, 0, NULL);'
Request 127 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('OTHER', '40', 'Other', 1, 0, NULL);'
Request 128 sql='INSERT INTO llx_c_ticket_category (code, pos, label, active, use_default, description) VALUES('OTHER', '10', 'Other', 1, 1, NULL);'
Request 129 sql='INSERT INTO llx_c_type_contact (rowid, element, source, code, libelle, active, module) VALUES(155, 'ticket', 'internal', 'SUPPORTTEC', 'Utilisateur contact support', 1, NULL);'
Request 130 sql='INSERT INTO llx_c_type_contact (rowid, element, source, code, libelle, active, module) VALUES(156, 'ticket', 'internal', 'CONTRIBUTOR', 'Intervenant', 1, NULL);'
Request 131 sql='INSERT INTO llx_c_type_contact (rowid, element, source, code, libelle, active, module) VALUES(157, 'ticket', 'external', 'SUPPORTCLI', 'Contact client suivi incident', 1, NULL);'
Request 132 sql='INSERT INTO llx_c_type_contact (rowid, element, source, code, libelle, active, module) VALUES(158, 'ticket', 'external', 'CONTRIBUTOR', 'Intervenant', 1, NULL);'
Request 133 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN date_start_fill integer DEFAULT 0;'
Request 134 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN date_end_fill integer DEFAULT 0;'
Request 135 sql='CREATE TABLE llx_societe_account(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,entity integer DEFAULT 1,key_account varchar(128),login varchar(128) NOT NULL,pass_encoding varchar(24),pass_crypted varchar(128),pass_temp varchar(128),fk_soc integer,site varchar(128),fk_website integer,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 136 sql='ALTER TABLE llx_societe_account MODIFY COLUMN pass_encoding varchar(24) NULL;'
Request 137 sql='ALTER TABLE llx_const MODIFY type varchar(64) DEFAULT 'string';'
Request 138 sql='UPDATE llx_const set type = 'text' where type = 'texte';'
Request 139 sql='UPDATE llx_const set type = 'html' where name in (__ENCRYPT('ADHERENT_AUTOREGISTER_NOTIF_MAIL')__,__ENCRYPT('ADHERENT_AUTOREGISTER_MAIL')__,__ENCRYPT('ADHERENT_MAIL_VALID')__,__ENCRYPT('ADHERENT_MAIL_COTIS')__,__ENCRYPT('ADHERENT_MAIL_RESIL')__);'
Request 140 sql='ALTER TABLE llx_societe_account ADD COLUMN key_account varchar(128);'
Request 141 sql='ALTER TABLE llx_societe_account ADD INDEX idx_societe_account_rowid (rowid);'
Request 142 sql='ALTER TABLE llx_societe_account ADD INDEX idx_societe_account_login (login);'
Request 143 sql='ALTER TABLE llx_societe_account ADD INDEX idx_societe_account_status (status);'
Request 144 sql='ALTER TABLE llx_societe_account ADD INDEX idx_societe_account_fk_website (fk_website);'
Request 145 sql='ALTER TABLE llx_societe_account ADD INDEX idx_societe_account_fk_soc (fk_soc);'
Request 146 sql='ALTER TABLE llx_societe_account ADD UNIQUE INDEX uk_societe_account_login_website_soc(entity, fk_soc, login, site, fk_website);'
Request 147 sql='ALTER TABLE llx_societe_account ADD UNIQUE INDEX uk_societe_account_key_account_soc(entity, fk_soc, key_account, site, fk_website);'
Request 148 sql='ALTER TABLE llx_societe_account ADD CONSTRAINT llx_societe_account_fk_website FOREIGN KEY (fk_website) REFERENCES llx_website(rowid);'
Request 149 sql='ALTER TABLE llx_societe_account ADD CONSTRAINT llx_societe_account_fk_societe FOREIGN KEY (fk_soc) REFERENCES llx_societe(rowid);'
Request 150 sql='ALTER TABLE llx_societe_rib MODIFY COLUMN max_total_amount_of_all_payments double(24,8);'
Request 151 sql='ALTER TABLE llx_societe_rib MODIFY COLUMN total_amount_of_all_payments double(24,8);'
Request 152 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'adherent','member','',0,null,null,'(SendingEmailOnAutoSubscription)' ,10,1,1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourMembershipRequestWasReceived)__','__(Hello)__ __MEMBER_FULLNAME__,<br><br>\n\n__(ThisIsContentOfYourMembershipRequestWasReceived)__<br>\n<br>__ONLINE_PAYMENT_TEXT_AND_URL__<br>\n<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null, 0);'
Request 153 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'adherent','member','',0,null,null,'(SendingEmailOnMemberValidation)' ,20,1,1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourMembershipWasValidated)__', '__(Hello)__ __MEMBER_FULLNAME__,<br><br>\n\n__(ThisIsContentOfYourMembershipWasValidated)__<br>\n<br>__ONLINE_PAYMENT_TEXT_AND_URL__<br>\n<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null, 0);'
Request 154 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'adherent','member','',0,null,null,'(SendingEmailOnNewSubscription)' ,30,1,1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourSubscriptionWasRecorded)__', '__(Hello)__ __MEMBER_FULLNAME__,<br><br>\n\n__(ThisIsContentOfYourSubscriptionWasRecorded)__<br>\n\n<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null, 1);'
Request 155 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'adherent','member','',0,null,null,'(SendingReminderForExpiredSubscription)',40,1,1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(SubscriptionReminderEmail)__', '__(Hello)__ __MEMBER_FULLNAME__,<br><br>\n\n__(ThisIsContentOfSubscriptionReminderEmail)__<br>\n<br>__ONLINE_PAYMENT_TEXT_AND_URL__<br>\n<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null, 0);'
Request 156 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'adherent','member','',0,null,null,'(SendingEmailOnCancelation)' ,50,1,1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourMembershipWasCanceled)__', '__(Hello)__ __MEMBER_FULLNAME__,<br><br>\n\n__(YourMembershipWasCanceled)__<br>\n<br><br>\n__(Sincerely)__<br>__USER_SIGNATURE__',null, 0);'
Request 157 sql='INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines,joinfiles) VALUES (0,'adherent','member','',0,null,null,'(SendingAnEMailToMember)' ,60,1,1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(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, 0);'
Request 158 sql='ALTER TABLE llx_product ADD COLUMN fk_default_warehouse integer DEFAULT NULL;'
Request 159 sql='ALTER TABLE llx_product ADD CONSTRAINT fk_product_default_warehouse FOREIGN KEY (fk_default_warehouse) REFERENCES llx_entrepot (rowid);'
Request 160 sql='CREATE TABLE llx_asset(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,ref varchar(128) NOT NULL,entity integer DEFAULT 1 NOT NULL,label varchar(255),amount_ht double(24,8) DEFAULT NULL,amount_vat double(24,8) DEFAULT NULL,fk_asset_type integer NOT NULL,description text,note_public text,note_private text,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 NOT NULL) ENGINE=innodb;'
Request 161 sql='ALTER TABLE llx_asset ADD INDEX idx_asset_rowid (rowid);'
Request 162 sql='ALTER TABLE llx_asset ADD INDEX idx_asset_ref (ref);'
Request 163 sql='ALTER TABLE llx_asset ADD INDEX idx_asset_entity (entity);'
Request 164 sql='ALTER TABLE llx_asset ADD INDEX idx_asset_fk_asset_type (fk_asset_type);'
Request 165 sql='create table llx_asset_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 166 sql='create table llx_asset_type(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,tms timestamp,label varchar(50) NOT NULL,accountancy_code_asset varchar(32),accountancy_code_depreciation_asset varchar(32),accountancy_code_depreciation_expense varchar(32),note text)ENGINE=innodb;'
Request 167 sql='ALTER TABLE llx_asset_type ADD UNIQUE INDEX uk_asset_type_label (label, entity);'
Request 168 sql='ALTER TABLE llx_asset ADD CONSTRAINT fk_asset_asset_type FOREIGN KEY (fk_asset_type) REFERENCES llx_asset_type (rowid);'
Request 169 sql='create table llx_asset_type_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 170 sql='ALTER TABLE llx_asset_type_extrafields ADD INDEX idx_asset_type_extrafields (fk_object);'
Request 171 sql='INSERT INTO llx_accounting_journal (rowid, code, label, nature, active) VALUES (7,'INV', 'Inventory journal', 8, 1);'
Request 172 sql='UPDATE llx_accounting_account set account_parent = 0 WHERE account_parent = '' OR account_parent IS NULL;'
Request 173 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN account_parent integer DEFAULT 0;'
Request 174 sql='ALTER TABLE llx_accounting_account ADD INDEX idx_accounting_account_account_parent (account_parent);'
Request 175 sql='UPDATE llx_accounting_bookkeeping set date_creation = tms where date_creation IS NULL;'
Request 176 sql='ALTER TABLE llx_extrafields MODIFY COLUMN list VARCHAR(128);'
Request 177 sql='UPDATE llx_rights_def set module = 'asset' where module = 'assets';'
Request 178 sql='ALTER TABLE llx_c_accounting_category ADD COLUMN entity integer NOT NULL DEFAULT 1 AFTER rowid;'
Request 179 sql='DROP INDEX uk_c_accounting_category on llx_c_accounting_category;'
Request 180 sql='ALTER TABLE llx_c_accounting_category ADD UNIQUE INDEX uk_c_accounting_category(code,entity);'
Request 181 sql='DROP INDEX uk_accounting_journal_code on llx_accounting_journal;'
Request 182 sql='ALTER TABLE llx_accounting_journal ADD UNIQUE INDEX uk_accounting_journal_code (code,entity);'
Request 183 sql='UPDATE llx_c_email_templates SET lang = '' WHERE lang IS NULL;'
Request 184 sql='ALTER TABLE llx_entrepot ADD COLUMN model_pdf VARCHAR(255) AFTER fk_user_author;'
Request 185 sql='ALTER TABLE llx_stock_mouvement ADD COLUMN model_pdf VARCHAR(255) AFTER origintype;'
Request 186 sql='insert into llx_c_regions (fk_pays, code_region, cheflieu, tncc, nom, active) values ( 118, 11801, '', 0, 'Indonesia', 1);'
Request 187 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('BA', 11801, NULL, 0, 'BA', 'Bali', 1);'
Request 188 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('BB', 11801, NULL, 0, 'BB', 'Bangka Belitung', 1);'
Request 189 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('BT', 11801, NULL, 0, 'BT', 'Banten', 1);'
Request 190 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('BE', 11801, NULL, 0, 'BA', 'Bengkulu', 1);'
Request 191 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('YO', 11801, NULL, 0, 'YO', 'DI Yogyakarta', 1);'
Request 192 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('JK', 11801, NULL, 0, 'JK', 'DKI Jakarta', 1);'
Request 193 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('GO', 11801, NULL, 0, 'GO', 'Gorontalo', 1);'
Request 194 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('JA', 11801, NULL, 0, 'JA', 'Jambi', 1);'
Request 195 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('JB', 11801, NULL, 0, 'JB', 'Jawa Barat', 1);'
Request 196 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('JT', 11801, NULL, 0, 'JT', 'Jawa Tengah', 1);'
Request 197 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('JI', 11801, NULL, 0, 'JI', 'Jawa Timur', 1);'
Request 198 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('KB', 11801, NULL, 0, 'KB', 'Kalimantan Barat', 1);'
Request 199 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('KS', 11801, NULL, 0, 'KS', 'Kalimantan Selatan', 1);'
Request 200 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('KT', 11801, NULL, 0, 'KT', 'Kalimantan Tengah', 1);'
Request 201 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('KI', 11801, NULL, 0, 'KI', 'Kalimantan Timur', 1);'
Request 202 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('KU', 11801, NULL, 0, 'KU', 'Kalimantan Utara', 1);'
Request 203 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('KR', 11801, NULL, 0, 'KR', 'Kepulauan Riau', 1);'
Request 204 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('LA', 11801, NULL, 0, 'LA', 'Lampung', 1);'
Request 205 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('MA', 11801, NULL, 0, 'MA', 'Maluku', 1);'
Request 206 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('MU', 11801, NULL, 0, 'MU', 'Maluku Utara', 1);'
Request 207 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('AC', 11801, NULL, 0, 'AC', 'Nanggroe Aceh Darussalam', 1);'
Request 208 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('NB', 11801, NULL, 0, 'NB', 'Nusa Tenggara Barat', 1);'
Request 209 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('NT', 11801, NULL, 0, 'NT', 'Nusa Tenggara Timur', 1);'
Request 210 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PA', 11801, NULL, 0, 'PA', 'Papua', 1);'
Request 211 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('PB', 11801, NULL, 0, 'PB', 'Papua Barat', 1);'
Request 212 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('RI', 11801, NULL, 0, 'RI', 'Riau', 1);'
Request 213 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SR', 11801, NULL, 0, 'SR', 'Sulawesi Barat', 1);'
Request 214 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SN', 11801, NULL, 0, 'SN', 'Sulawesi Selatan', 1);'
Request 215 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('ST', 11801, NULL, 0, 'ST', 'Sulawesi Tengah', 1);'
Request 216 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SG', 11801, NULL, 0, 'SG', 'Sulawesi Tenggara', 1);'
Request 217 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SA', 11801, NULL, 0, 'SA', 'Sulawesi Utara', 1);'
Request 218 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SB', 11801, NULL, 0, 'SB', 'Sumatera Barat', 1);'
Request 219 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SS', 11801, NULL, 0, 'SS', 'Sumatera Selatan', 1);'
Request 220 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('SU', 11801, NULL, 0, 'SU', 'Sumatera Utara ', 1);'
Request 221 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (188, 'RO-BASE', 'Plan de conturi romanesc', 1);'
Request 222 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 5, 'SKR03', 'Standardkontenrahmen SKR 03', 1);'
Request 223 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 5, 'SKR04', 'Standardkontenrahmen SKR 04', 1);'
Request 224 sql='ALTER TABLE llx_advtargetemailing ADD COLUMN fk_element integer NOT NULL;'
Request 225 sql='ALTER TABLE llx_advtargetemailing ADD COLUMN type_element varchar(180) NOT NULL;'
Request 226 sql='UPDATE llx_advtargetemailing SET fk_element = fk_mailing, type_element='mailing';'
Request 227 sql='ALTER TABLE llx_advtargetemailing DROP COLUMN fk_mailing;'
Request 228 sql='DROP TABLE llx_ticket_logs;'
Request 229 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN code varchar(50);'
Script processingOK