 Database migration (structure + some data)
| Server connection : localhost | OK |
| Database connection : htech_ias | OK |
| Database server version | 10.6.20-MariaDB-cll-lve | | Client charset | utf8 | | Client collation | utf8_general_ci | | Please be patient... |
| | Choose migration script | 7.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);' |
| 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 (Req 164): 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 (Req 168): 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 processing | Error - Show-Hide details |
|
|
