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 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 DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_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 DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_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);'
Error DB_ERROR_3780: ALTER TABLE llx_ticket_msg ADD CONSTRAINT fk_ticket_msg_fk_track_id FOREIGN KEY (fk_track_id) REFERENCES llx_ticket (track_id);
Referencing column 'fk_track_id' and referenced column 'track_id' in foreign key constraint 'fk_ticket_msg_fk_track_id' are incompatible.
Request 111 sql='CREATE TABLE llx_ticket_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 112 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 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 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 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 DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 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);'
Error DB_ERROR_1072: ALTER TABLE llx_asset ADD INDEX idx_asset_fk_asset_type (fk_asset_type);
Key column 'fk_asset_type' doesn't exist in table
Request 165 sql='create table llx_asset_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 166 sql='create table llx_asset_type ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_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);'
Error DB_ERROR_1072: ALTER TABLE llx_asset ADD CONSTRAINT fk_asset_asset_type FOREIGN KEY (fk_asset_type) REFERENCES llx_asset_type (rowid);
Key column 'fk_asset_type' doesn't exist in table
Request 169 sql='create table llx_asset_type_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 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 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.