| Server connection : localhost | OK |
| Database connection : myat_db2 | OK |
| Database server version | 10.3.32-MariaDB-cll-lve |
| Client charset | utf8 |
| Client collation | utf8_general_ci |
| Please be patient... |
|
| Choose migration script | 13.0.0-14.0.0.sql |
| Request 1 sql='SET sql_mode = 'ALLOW_INVALID_DATES';' |
| Request 2 sql='update db_propal set tms = datec where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' |
| Request 3 sql='SET sql_mode = 'NO_ZERO_DATE';' |
| Request 4 sql='update db_propal set tms = null where DATE(STR_TO_DATE(tms, '%Y-%m-%d')) IS NULL;' |
| Request 5 sql='ALTER TABLE db_ecm_files ADD COLUMN note_private text AFTER fk_user_m;' |
| Request 6 sql='ALTER TABLE db_ecm_files ADD COLUMN note_public text AFTER note_private;' |
| Request 7 sql='ALTER TABLE db_accounting_bookkeeping DROP INDEX idx_accounting_bookkeeping_numero_compte;' |
| Request 8 sql='ALTER TABLE db_accounting_bookkeeping DROP INDEX idx_accounting_bookkeeping_code_journal;' |
| Request 9 sql='ALTER TABLE db_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_fk_docdet (fk_docdet);' |
| Request 10 sql='ALTER TABLE db_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_doc_date (doc_date);' |
| Request 11 sql='ALTER TABLE db_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_numero_compte (numero_compte, entity);' |
| Request 12 sql='ALTER TABLE db_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_code_journal (code_journal, entity);' |
| Request 13 sql='ALTER TABLE db_accounting_bookkeeping ADD INDEX idx_accounting_bookkeeping_piece_num (piece_num, entity);' |
| Request 14 sql='ALTER TABLE db_recruitment_recruitmentcandidature MODIFY COLUMN email_msgid VARCHAR(175);' |
| Request 15 sql='ALTER TABLE db_asset CHANGE COLUMN amount amount_ht double(24,8) DEFAULT NULL;' |
| Request 16 sql='ALTER TABLE db_asset ADD COLUMN amount_vat double(24,8) DEFAULT NULL;' |
| Request 17 sql='ALTER TABLE db_supplier_proposal_extrafields ADD INDEX idx_supplier_proposal_extrafields (fk_object);' |
| Request 18 sql='ALTER TABLE db_supplier_proposaldet_extrafields ADD INDEX idx_supplier_proposaldet_extrafields (fk_object);' |
| Request 19 sql='ALTER TABLE db_asset_extrafields ADD INDEX idx_asset_extrafields (fk_object);' |
| Request 20 sql='insert into db_c_actioncomm (id, code, type, libelle, module, active, position) values ( 6,'AC_EMAIL_IN','system','reception Email',NULL, 1, 4);' |
| Request 21 sql='ALTER TABLE db_accounting_bookkeeping MODIFY COLUMN montant double(24,8) NULL;' |
| Request 22 sql='UPDATE db_c_country SET eec = 1 WHERE code IN ('AT','BE','BG','CY','CZ','DE','DK','EE','ES','FI','FR','GR','HR','NL','HU','IE','IM','IT','LT','LU','LV','MC','MT','PL','PT','RO','SE','SK','SI');' |
| Request 23 sql='INSERT INTO db_accounting_system (fk_country, pcg_version, label, active) VALUES ( 11, 'US-BASE', 'USA basic chart of accounts', 1);' |
| Request 24 sql='INSERT INTO db_accounting_system (fk_country, pcg_version, label, active) VALUES ( 14, 'CA-ENG-BASE', 'Canadian basic chart of accounts - English', 1);' |
| Request 25 sql='INSERT INTO db_accounting_system (fk_country, pcg_version, label, active) VALUES ( 154, 'SAT/24-2019', 'Catalogo y codigo agrupador fiscal del 2019', 1);' |
| Request 26 sql='UPDATE db_accounting_system SET fk_country = 1 WHERE fk_country IS NULL;' |
| Request 27 sql='UPDATE db_const set value = __ENCRYPT('eldy')__ WHERE __DECRYPT('value')__ = 'auguria';' |
| Request 28 sql='UPDATE db_const set value = __ENCRYPT('eldy')__ WHERE __DECRYPT('value')__ = 'bureau2crea';' |
| Request 29 sql='UPDATE db_const set value = __ENCRYPT('eldy')__ WHERE __DECRYPT('value')__ = 'amarok';' |
| Request 30 sql='UPDATE db_const set value = __ENCRYPT('eldy')__ WHERE __DECRYPT('value')__ = 'cameleo';' |
| Request 31 sql='DELETE FROM db_user_param where param = 'MAIN_THEME' and value in ('auguria', 'amarok', 'cameleo');' |
| Request 32 sql='UPDATE db_facturedet SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and subprice > 0) OR (multicurrency_subprice > 0 and subprice < 0));' |
| Request 33 sql='UPDATE db_facturedet SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));' |
| Request 34 sql='UPDATE db_facturedet SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));' |
| Request 35 sql='UPDATE db_facturedet SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));' |
| Request 36 sql='UPDATE db_facture SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));' |
| Request 37 sql='UPDATE db_facture SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));' |
| Request 38 sql='UPDATE db_facture SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));' |
| Request 39 sql='UPDATE db_facture_fourn_det SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and pu_ht > 0) OR (multicurrency_subprice > 0 and pu_ht < 0));' |
| Request 40 sql='UPDATE db_facture_fourn_det SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));' |
| Request 41 sql='UPDATE db_facture_fourn_det SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and tva > 0) OR (multicurrency_total_tva > 0 and tva < 0));' |
| Request 42 sql='UPDATE db_facture_fourn_det SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));' |
| Request 43 sql='UPDATE db_facture_fourn SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));' |
| Request 44 sql='UPDATE db_facture_fourn SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));' |
| Request 45 sql='UPDATE db_facture_fourn SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));' |
| Request 46 sql='UPDATE db_c_ticket_type set label = 'Issue or bug' WHERE code = 'ISSUE';' |
| Request 47 sql='INSERT INTO db_c_ticket_type (code, pos, label, active, use_default, description) VALUES('PROBLEM', '22', 'Problem', 0, 0, NULL);' |
| Request 48 sql='ALTER TABLE db_import_model MODIFY COLUMN type varchar(64);' |
| Request 49 sql='ALTER TABLE db_export_model MODIFY COLUMN type varchar(64);' |
| Request 50 sql='ALTER TABLE db_import_model ADD COLUMN entity integer DEFAULT 0 NOT NULL;' |
| Request 51 sql='ALTER TABLE db_export_model ADD COLUMN entity integer DEFAULT 0 NOT NULL;' |
| Request 52 sql='ALTER TABLE db_product_lot ADD COLUMN eol_date datetime NULL;' |
| Request 53 sql='ALTER TABLE db_product_lot ADD COLUMN manufacturing_date datetime NULL;' |
| Request 54 sql='ALTER TABLE db_product_lot ADD COLUMN scrapping_date datetime NULL;' |
| Request 55 sql='create table db_accounting_groups_account(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_accounting_account INTEGER NOT NULL,fk_c_accounting_category INTEGER NOT NULL)ENGINE=innodb;' |
| Request 56 sql='ALTER TABLE db_oauth_token ADD COLUMN restricted_ips varchar(200);' |
| Request 57 sql='ALTER TABLE db_oauth_token ADD COLUMN datec datetime DEFAULT NULL;' |
| Request 58 sql='ALTER TABLE db_oauth_token ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 59 sql='ALTER TABLE db_events ADD COLUMN authentication_method varchar(64) NULL;' |
| Request 60 sql='ALTER TABLE db_events ADD COLUMN fk_oauth_token integer NULL;' |
| Request 61 sql='ALTER TABLE db_mailing_cibles MODIFY COLUMN tag varchar(64) NULL;' |
| Request 62 sql='ALTER TABLE db_mailing_cibles ADD INDEX idx_mailing_cibles_tag (tag);' |
| Request 63 sql='ALTER TABLE db_c_availability ADD COLUMN position integer NOT NULL DEFAULT 0;' |
| Request 64 sql='ALTER TABLE db_adherent ADD COLUMN ref varchar(30) AFTER rowid;' |
| Request 65 sql='UPDATE db_adherent SET ref = rowid WHERE ref = '' or ref IS NULL;' |
| Request 66 sql='ALTER TABLE db_adherent MODIFY COLUMN ref varchar(30) NOT NULL;' |
| Request 67 sql='ALTER TABLE db_adherent ADD UNIQUE INDEX uk_adherent_ref (ref, entity);' |
| Request 68 sql='ALTER TABLE db_societe ADD COLUMN accountancy_code_sell varchar(32) AFTER webservices_key;' |
| Request 69 sql='ALTER TABLE db_societe ADD COLUMN accountancy_code_buy varchar(32) AFTER accountancy_code_sell;' |
| Request 70 sql='ALTER TABLE db_bank_account ADD COLUMN ics varchar(32) NULL;' |
| Request 71 sql='ALTER TABLE db_bank_account ADD COLUMN ics_transfer varchar(32) NULL;' |
| Request 72 sql='ALTER TABLE db_facture MODIFY COLUMN date_valid DATETIME NULL DEFAULT NULL;' |
| Request 73 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_dolibarr_state_board.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_dolibarr_state_board.php' AND entity = 1);' |
| Request 74 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_members_last_modified.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_members_last_modified.php' AND entity = 1);' |
| Request 75 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_members_last_subscriptions.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_members_last_subscriptions.php' AND entity = 1);' |
| Request 76 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_members_subscriptions_by_year.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_members_subscriptions_by_year.php' AND entity = 1);' |
| Request 77 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_members_by_type.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_members_by_type.php' AND entity = 1);' |
| Request 78 sql='ALTER TABLE db_website ADD COLUMN lastaccess datetime NULL;' |
| Request 79 sql='ALTER TABLE db_website ADD COLUMN pageviews_month BIGINT UNSIGNED DEFAULT 0;' |
| Request 80 sql='ALTER TABLE db_website ADD COLUMN pageviews_total BIGINT UNSIGNED DEFAULT 0;' |
| Request 81 sql='ALTER TABLE db_workstation_workstation DROP FOREIGN KEY db_workstation_workstation_fk_user_creat;' |
| Request 82 sql='ALTER TABLE db_propal DROP FOREIGN KEY db_propal_fk_warehouse;' |
| Request 83 sql='CREATE TABLE db_workstation_workstation(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,ref varchar(128) DEFAULT '(PROV)' NOT NULL,label varchar(255),type varchar(7),note_public text,entity int DEFAULT 1,note_private text,date_creation datetime NOT NULL,tms timestamp,fk_user_creat integer NOT NULL,fk_user_modif integer,import_key varchar(14),status smallint NOT NULL,nb_operators_required integer,thm_operator_estimated double,thm_machine_estimated double) ENGINE=innodb;' |
| Request 84 sql='ALTER TABLE db_workstation_workstation ADD INDEX idx_workstation_workstation_rowid (rowid);' |
| Request 85 sql='ALTER TABLE db_workstation_workstation ADD INDEX idx_workstation_workstation_ref (ref);' |
| Request 86 sql='ALTER TABLE db_workstation_workstation ADD CONSTRAINT fk_workstation_workstation_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES db_user(rowid);' |
| Request 87 sql='ALTER TABLE db_workstation_workstation ADD INDEX idx_workstation_workstation_status (status);' |
| Request 88 sql='CREATE TABLE db_workstation_workstation_resource(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,tms timestamp,fk_resource integer,fk_workstation integer) ENGINE=innodb;' |
| Request 89 sql='CREATE TABLE db_workstation_workstation_usergroup(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,tms timestamp,fk_usergroup integer,fk_workstation integer) ENGINE=innodb;' |
| Request 90 sql='DROP TABLE db_c_producbatch_qcstatus;' |
| Request 91 sql='CREATE TABLE db_c_productbatch_qcstatus(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,entity integer NOT NULL DEFAULT 1,code varchar(16) NOT NULL,label varchar(50) NOT NULL,active integer DEFAULT 1 NOT NULL) ENGINE=innodb;' |
| Request 92 sql='ALTER TABLE db_c_productbatch_qcstatus ADD UNIQUE INDEX uk_c_productbatch_qcstatus(code, entity);' |
| Request 93 sql='INSERT INTO db_c_productbatch_qcstatus (code, label, active) VALUES ('OK', 'InWorkingOrder', 1);' |
| Request 94 sql='INSERT INTO db_c_productbatch_qcstatus (code, label, active) VALUES ('KO', 'OutOfOrder', 1);' |
| Request 95 sql='ALTER TABLE db_product_customer_price ADD COLUMN ref_customer varchar(30);' |
| Request 96 sql='ALTER TABLE db_product_customer_price_log ADD COLUMN ref_customer varchar(30);' |
| Request 97 sql='ALTER TABLE db_propal ADD COLUMN fk_warehouse integer DEFAULT NULL AFTER fk_shipping_method;' |
| Request 98 sql='ALTER TABLE db_propal ADD INDEX idx_propal_fk_warehouse(fk_warehouse);' |
| Request 99 sql='ALTER TABLE db_societe DROP INDEX idx_societe_entrepot;' |
| Request 100 sql='ALTER TABLE db_societe CHANGE fk_entrepot fk_warehouse INTEGER DEFAULT NULL;' |
| Request 101 sql='ALTER TABLE db_societe ADD INDEX idx_societe_warehouse(fk_warehouse);' |
| Request 102 sql='ALTER TABLE db_societe MODIFY COLUMN fk_typent integer NULL;' |
| Request 103 sql='UPDATE db_societe SET fk_typent=NULL, tms=tms WHERE fk_typent=0;' |
| Request 104 sql='DELETE FROM db_c_typent WHERE code='TE_UNKNOWN';' |
| Request 105 sql='ALTER TABLE db_socpeople MODIFY poste varchar(255);' |
| Request 106 sql='ALTER TABLE db_menu ADD COLUMN prefix varchar(255) NULL AFTER titre;' |
| Request 107 sql='ALTER TABLE db_chargesociales ADD COLUMN fk_user integer DEFAULT NULL;' |
| Request 108 sql='ALTER TABLE db_mrp_production ADD COLUMN origin_id integer AFTER fk_mo;' |
| Request 109 sql='ALTER TABLE db_mrp_production ADD COLUMN origin_type varchar(10) AFTER origin_id;' |
| Request 110 sql='ALTER TABLE db_fichinter ADD COLUMN last_main_doc varchar(255) AFTER model_pdf;' |
| Request 111 sql='ALTER TABLE db_projet ADD COLUMN last_main_doc varchar(255) AFTER model_pdf;' |
| Request 112 sql='ALTER TABLE db_expensereport ADD COLUMN last_main_doc varchar(255) DEFAULT NULL AFTER model_pdf;' |
| Request 113 sql='create table db_payment_vat(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_tva integer,datec datetime,tms timestamp,datep datetime,amount double(24,8) DEFAULT 0,fk_typepaiement integer NOT NULL,num_paiement varchar(50),note text,fk_bank integer NOT NULL,fk_user_creat integer,fk_user_modif integer)ENGINE=innodb;' |
| Request 114 sql='ALTER TABLE db_tva ADD COLUMN paye smallint default 1 NOT NULL;' |
| Request 115 sql='ALTER TABLE db_tva ADD COLUMN fk_account integer;' |
| Request 116 sql='INSERT INTO db_payment_vat (rowid, fk_tva, datec, datep, amount, fk_typepaiement, num_paiement, note, fk_bank, fk_user_creat, fk_user_modif) SELECT rowid, rowid, NOW(), datep, amount, COALESCE(fk_typepayment, 0), num_payment, 'Created automatically by migration v13 to v14', fk_bank, fk_user_creat, fk_user_modif FROM db_tva WHERE fk_bank IS NOT NULL;' |
| Request 117 sql='ALTER TABLE db_tva ALTER COLUMN paye SET DEFAULT 0;' |
| Request 118 sql='INSERT INTO db_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskConf)', 10, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskConf)__', '__(Hello)__,<br /><br />__(OrganizationEventConfRequestWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
| Request 119 sql='INSERT INTO db_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskBooth)', 20, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskBooth)__', '__(Hello)__,<br /><br />__(OrganizationEventBoothRequestWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
| Request 120 sql='INSERT INTO db_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailSubsBooth)', 30, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailBoothPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfBoothWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
| Request 121 sql='INSERT INTO db_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailSubsEvent)', 40, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailRegistrationPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfRegistrationWasReceived)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
| Request 122 sql='INSERT INTO db_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailAttendees)', 50, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailAttendees)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToAttendees)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
| Request 123 sql='INSERT INTO db_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailSpeakers)', 60, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailSpeakers)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToSpeakers)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);' |
| Request 124 sql='ALTER TABLE db_projet ADD COLUMN accept_conference_suggestions integer DEFAULT 0;' |
| Request 125 sql='ALTER TABLE db_projet ADD COLUMN accept_booth_suggestions integer DEFAULT 0;' |
| Request 126 sql='ALTER TABLE db_projet ADD COLUMN price_registration double(24,8);' |
| Request 127 sql='ALTER TABLE db_projet ADD COLUMN price_booth double(24,8);' |
| Request 128 sql='ALTER TABLE db_actioncomm ADD COLUMN num_vote integer DEFAULT NULL AFTER reply_to;' |
| Request 129 sql='ALTER TABLE db_actioncomm ADD COLUMN event_paid smallint NOT NULL DEFAULT 0 AFTER num_vote;' |
| Request 130 sql='ALTER TABLE db_actioncomm ADD COLUMN status smallint NOT NULL DEFAULT 0 AFTER event_paid;' |
| Request 131 sql='ALTER TABLE db_actioncomm ADD COLUMN ref varchar(30) AFTER id;' |
| Request 132 sql='UPDATE db_actioncomm SET ref = id WHERE ref = '' OR ref IS NULL;' |
| Request 133 sql='ALTER TABLE db_actioncomm MODIFY COLUMN ref varchar(30) NOT NULL;' |
| Request 134 sql='ALTER TABLE db_actioncomm ADD UNIQUE INDEX uk_actioncomm_ref (ref, entity);' |
| Request 135 sql='ALTER TABLE db_c_actioncomm MODIFY code varchar(50) NOT NULL;' |
| Request 136 sql='ALTER TABLE db_c_actioncomm MODIFY module varchar(50) DEFAULT NULL;' |
| Request 137 sql='INSERT INTO db_c_actioncomm (id, code, type, libelle, module, active, position) VALUES ( 60,'AC_EO_ONLINECONF','module','Online/Virtual conference','conference@eventorganization', 1, 60);' |
| Request 138 sql='INSERT INTO db_c_actioncomm (id, code, type, libelle, module, active, position) VALUES ( 61,'AC_EO_INDOORCONF','module','Indoor conference','conference@eventorganization', 1, 61);' |
| Request 139 sql='INSERT INTO db_c_actioncomm (id, code, type, libelle, module, active, position) VALUES ( 62,'AC_EO_ONLINEBOOTH','module','Online/Virtual booth','booth@eventorganization', 1, 62);' |
| Request 140 sql='INSERT INTO db_c_actioncomm (id, code, type, libelle, module, active, position) VALUES ( 63,'AC_EO_INDOORBOOTH','module','Indoor booth','booth@eventorganization', 1, 63);' |
| Request 141 sql='ALTER TABLE db_commande CHANGE COLUMN tva total_tva double(24,8) default 0;' |
| Request 142 sql='ALTER TABLE db_supplier_proposal CHANGE COLUMN tva total_tva double(24,8) default 0;' |
| Request 143 sql='ALTER TABLE db_supplier_proposal CHANGE COLUMN total total_ttc double(24,8) default 0;' |
| Request 144 sql='ALTER TABLE db_propal CHANGE COLUMN tva total_tva double(24,8) default 0;' |
| Request 145 sql='ALTER TABLE db_propal CHANGE COLUMN total total_ttc double(24,8) default 0;' |
| Request 146 sql='ALTER TABLE db_facture CHANGE COLUMN tva total_tva double(24,8) default 0;' |
| Request 147 sql='ALTER TABLE db_facture CHANGE COLUMN total total_ht double(24,8) default 0;' |
| Request 148 sql='ALTER TABLE db_facture_rec CHANGE COLUMN tva total_tva double(24,8) default 0;' |
| Request 149 sql='ALTER TABLE db_facture_rec CHANGE COLUMN total total_ht double(24,8) default 0;' |
| Request 150 sql='ALTER TABLE db_commande_fournisseur CHANGE COLUMN tva total_tva double(24,8) default 0;' |
| Request 151 sql='create table db_salary(rowid integer AUTO_INCREMENT PRIMARY KEY,ref varchar(30) NULL,label varchar(255),tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,datec datetime,fk_user integer NOT NULL,datep date,datev date,salary double(24,8),amount double(24,8) NOT NULL DEFAULT 0,fk_projet integer DEFAULT NULL,datesp date,dateep date,entity integer DEFAULT 1 NOT NULL,note text,fk_bank integer,paye smallint default 1 NOT NULL,fk_typepayment integer NOT NULL,fk_account integer,fk_user_author integer,fk_user_modif integer) ENGINE=innodb;' |
| Request 152 sql='ALTER TABLE db_payment_salary CHANGE COLUMN fk_user fk_user integer NULL;' |
| Request 153 sql='ALTER TABLE db_payment_salary ADD COLUMN fk_salary integer;' |
| Request 154 sql='INSERT INTO db_salary (rowid, ref, fk_user, amount, fk_projet, fk_typepayment, label, datesp, dateep, entity, note, fk_bank, paye) SELECT ps.rowid, ps.rowid, ps.fk_user, ps.amount, ps.fk_projet, ps.fk_typepayment, ps.label, ps.datesp, ps.dateep, ps.entity, ps.note, ps.fk_bank, 1 FROM db_payment_salary ps WHERE ps.fk_salary IS NULL;' |
| Request 155 sql='UPDATE db_payment_salary SET fk_salary = rowid WHERE fk_salary IS NULL;' |
| Request 156 sql='UPDATE db_payment_salary SET ref = rowid WHERE ref IS NULL;' |
| Request 157 sql='ALTER TABLE db_salary ALTER COLUMN paye set default 0;' |
| Request 158 sql='UPDATE db_extrafields SET elementtype = 'salary' WHERE elementtype = 'payment_salary';' |
| Request 159 sql='ALTER TABLE db_payment_salary_extrafields RENAME TO db_salary_extrafields;' |
| Request 160 sql='DROP INDEX idx_payment_salary_extrafields on db_salary_extrafields;' |
| Request 161 sql='ALTER TABLE db_salary_extrafields ADD INDEX idx_salary_extrafields (fk_object);' |
| Request 162 sql='DELETE FROM db_boxes WHERE box_id IN (SELECT rowid FROM db_boxes_def WHERE file IN ('box_graph_ticket_by_severity', 'box_ticket_by_severity.php', 'box_nb_ticket_last_x_days.php', 'box_nb_tickets_type.php', 'box_new_vs_close_ticket.php'));' |
| Request 163 sql='DELETE FROM db_boxes_def WHERE file IN ('box_graph_ticket_by_severity', 'box_ticket_by_severity.php', 'box_nb_ticket_last_x_days.php', 'box_nb_tickets_type.php', 'box_new_vs_close_ticket.php');' |
| Request 164 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_graph_ticket_by_severity.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_graph_ticket_by_severity.php' AND entity = 1);' |
| Request 165 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_graph_nb_ticket_last_x_days.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_graph_nb_ticket_last_x_days.php' AND entity = 1);' |
| Request 166 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_graph_nb_tickets_type.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_graph_nb_tickets_type.php' AND entity = 1);' |
| Request 167 sql='INSERT INTO db_boxes_def (file, entity) SELECT 'box_graph_new_vs_close_ticket.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM db_boxes_def WHERE file = 'box_graph_new_vs_close_ticket.php' AND entity = 1);' |
| Request 168 sql='create table db_product_perentity(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_product integer,entity integer DEFAULT 1 NOT NULL,accountancy_code_sell varchar(32),accountancy_code_sell_intra varchar(32),accountancy_code_sell_export varchar(32),accountancy_code_buy varchar(32),accountancy_code_buy_intra varchar(32),accountancy_code_buy_export varchar(32),pmp double(24,8))ENGINE=innodb;' |
| Request 169 sql='ALTER TABLE db_product_perentity ADD INDEX idx_product_perentity_fk_product (fk_product);' |
| Request 170 sql='ALTER TABLE db_product_perentity ADD UNIQUE INDEX uk_product_perentity (fk_product, entity);' |
| Request 171 sql='create table db_societe_perentity(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_soc integer,entity integer DEFAULT 1 NOT NULL,accountancy_code_sell varchar(32),accountancy_code_buy varchar(32))ENGINE=innodb;' |
| Request 172 sql='ALTER TABLE db_societe_perentity ADD INDEX idx_societe_perentity_fk_soc (fk_soc);' |
| Request 173 sql='ALTER TABLE db_societe_perentity ADD UNIQUE INDEX uk_societe_perentity (fk_soc, entity);' |
| Request 174 sql='CREATE TABLE db_eventorganization_conferenceorboothattendee(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,ref varchar(128) NOT NULL,fk_soc integer,fk_actioncomm integer,fk_project integer NOT NULL,fk_invoice integer NULL,email varchar(100),date_subscription datetime,amount double DEFAULT NULL,note_public text,note_private text,date_creation datetime NOT NULL,tms timestamp,fk_user_creat integer,fk_user_modif integer,last_main_doc varchar(255),import_key varchar(14),model_pdf varchar(255),status smallint NOT NULL) ENGINE=innodb;' |
| Request 175 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee MODIFY COLUMN fk_actioncomm integer NULL;' |
| Request 176 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD COLUMN fk_project integer NOT NULL;' |
| Request 177 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD COLUMN fk_invoice integer NULL;' |
| Request 178 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_soc;' |
| Request 179 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_actioncomm;' |
| Request 180 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee DROP FOREIGN KEY fx_eventorganization_conferenceorboothattendee_fk_project;' |
| Request 181 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_rowid (rowid);' |
| Request 182 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_ref (ref);' |
| Request 183 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_fk_soc (fk_soc);' |
| Request 184 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_fk_actioncomm (fk_actioncomm);' |
| Request 185 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_email (email);' |
| Request 186 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD INDEX idx_eventorganization_conferenceorboothattendee_status (status);' |
| Request 187 sql='DROP INDEX uk_eventorganization_conferenceorboothattendee on db_eventorganization_conferenceorboothattendee;' |
| Request 188 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee ADD UNIQUE INDEX uk_eventorganization_conferenceorboothattendee(fk_project, email, fk_actioncomm);' |
| Request 189 sql='create table db_eventorganization_conferenceorboothattendee_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 190 sql='ALTER TABLE db_eventorganization_conferenceorboothattendee_extrafields ADD INDEX idx_conferenceorboothattendee_fk_object(fk_object);' |
| Request 191 sql='ALTER TABLE db_c_ticket_category ADD COLUMN public integer DEFAULT 0;' |
| Request 192 sql='ALTER TABLE db_c_ticket_category MODIFY COLUMN pos integer DEFAULT 0 NOT NULL;' |
| Request 193 sql='ALTER TABLE db_propal ADD COLUMN date_signature datetime AFTER date_valid;' |
| Request 194 sql='ALTER TABLE db_propal ADD COLUMN fk_user_signature integer AFTER fk_user_valid;' |
| Request 195 sql='ALTER TABLE db_propal ADD CONSTRAINT fk_propal_fk_user_signature FOREIGN KEY (fk_user_signature) REFERENCES db_user (rowid);' |
| Request 196 sql='UPDATE db_propal SET fk_user_signature = fk_user_cloture WHERE fk_user_signature IS NULL AND fk_user_cloture IS NOT NULL;' |
| Request 197 sql='UPDATE db_propal SET date_signature = date_cloture WHERE date_signature IS NULL AND date_cloture IS NOT NULL;' |
| Request 198 sql='ALTER TABLE db_product ADD COLUMN batch_mask VARCHAR(32) DEFAULT NULL;' |
| Request 199 sql='ALTER TABLE db_product ADD COLUMN lifetime INTEGER NULL;' |
| Request 200 sql='ALTER TABLE db_product ADD COLUMN qc_frequency INTEGER NULL;' |
| Request 201 sql='insert into db_c_type_contact(rowid, element, source, code, libelle, active ) values (210, 'conferenceorbooth', 'internal', 'MANAGER', 'Conference or Booth manager', 1);' |
| Request 202 sql='insert into db_c_type_contact(rowid, element, source, code, libelle, active ) values (211, 'conferenceorbooth', 'external', 'SPEAKER', 'Conference Speaker', 1);' |
| Request 203 sql='insert into db_c_type_contact(rowid, element, source, code, libelle, active ) values (212, 'conferenceorbooth', 'external', 'RESPONSIBLE', 'Booth responsible', 1);' |
| Request 204 sql='CREATE TABLE db_partnership(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,ref varchar(128) DEFAULT '(PROV)' NOT NULL,status smallint NOT NULL DEFAULT '0',fk_soc integer,fk_member integer,date_partnership_start date NOT NULL,date_partnership_end date NULL,entity integer DEFAULT 1 NOT NULL,reason_decline_or_cancel text NULL,date_creation datetime NOT NULL,fk_user_creat integer NOT NULL,tms timestamp,fk_user_modif integer,note_private text,note_public text,last_main_doc varchar(255),count_last_url_check_error integer DEFAULT '0',last_check_backlink datetime NULL,import_key varchar(14),model_pdf varchar(255)) ENGINE=innodb;' |
| Request 205 sql='ALTER TABLE db_partnership ADD COLUMN last_check_backlink datetime NULL;' |
| Request 206 sql='ALTER TABLE db_partnership ADD INDEX idx_partnership_rowid (rowid);' |
| Request 207 sql='ALTER TABLE db_partnership ADD INDEX idx_partnership_ref (ref);' |
| Request 208 sql='ALTER TABLE db_partnership ADD INDEX idx_partnership_fk_soc (fk_soc);' |
| Request 209 sql='ALTER TABLE db_partnership ADD CONSTRAINT db_partnership_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES db_user(rowid);' |
| Request 210 sql='ALTER TABLE db_partnership ADD INDEX idx_partnership_status (status);' |
| Request 211 sql='ALTER TABLE db_partnership ADD INDEX idx_partnership_fk_member (fk_member);' |
| Request 212 sql='create table db_partnership_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 213 sql='ALTER TABLE db_partnership_extrafields ADD INDEX idx_partnership_fk_object(fk_object);' |
| Request 214 sql='INSERT INTO db_c_email_templates (entity,module,type_template,label,lang,position,topic,joinfiles,content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipWillSoonBeCanceled)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipWillSoonBeCanceledTopic)__', 0, '<body>\n <p>Hello,<br><br>\n__(YourPartnershipWillSoonBeCanceledContent)__</p>\n<br />\n\n<br />\n\n __(Sincerely)__ <br />\n __[MAIN_INFO_SOCIETE_NOM]__ <br />\n </body>\n');' |
| Request 215 sql='INSERT INTO db_c_email_templates (entity,module,type_template,label,lang,position,topic,joinfiles,content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipCanceled)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipCanceledTopic)__', 0, '<body>\n <p>Hello,<br><br>\n__(YourPartnershipCanceledContent)__</p>\n<br />\n\n<br />\n\n __(Sincerely)__ <br />\n __[MAIN_INFO_SOCIETE_NOM]__ <br />\n </body>\n');' |
| Request 216 sql='INSERT INTO db_c_email_templates (entity,module,type_template,label,lang,position,topic,joinfiles,content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipRefused)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipRefusedTopic)__', 0, '<body>\n <p>Hello,<br><br>\n__(YourPartnershipRefusedContent)__</p>\n<br />\n\n<br />\n\n __(Sincerely)__ <br />\n __[MAIN_INFO_SOCIETE_NOM]__ <br />\n </body>\n');' |
| Request 217 sql='INSERT INTO db_c_email_templates (entity,module,type_template,label,lang,position,topic,joinfiles,content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipAccepted)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipAcceptedTopic)__', 0, '<body>\n <p>Hello,<br><br>\n__(YourPartnershipAcceptedContent)__</p>\n<br />\n\n<br />\n\n __(Sincerely)__ <br />\n __[MAIN_INFO_SOCIETE_NOM]__ <br />\n </body>\n');' |
| Request 218 sql='ALTER TABLE db_adherent ADD COLUMN url varchar(255) NULL AFTER email;' |
| Request 219 sql='ALTER TABLE db_facture_fourn ADD COLUMN date_closing datetime DEFAULT NULL after date_valid;' |
| Request 220 sql='ALTER TABLE db_facture_fourn ADD COLUMN fk_user_closing integer DEFAULT NULL after fk_user_valid;' |
| Request 221 sql='ALTER TABLE db_entrepot ADD COLUMN fk_project INTEGER DEFAULT NULL AFTER entity;' |
| Request 222 sql='ALTER TABLE db_payment_donation ADD COLUMN ext_payment_site varchar(128) AFTER note;' |
| Request 223 sql='ALTER TABLE db_payment_donation ADD COLUMN ext_payment_id varchar(128) AFTER note;' |
| Request 224 sql='UPDATE db_const SET type = 'chaine', value = __ENCRYPT('github')__ WHERE __DECRYPT('name')__ = 'MAIN_BUGTRACK_ENABLELINK' AND __DECRYPT('value')__ = '1';' |
| Request 225 sql='ALTER TABLE db_facture_fourn_det ADD COLUMN fk_remise_except integer DEFAULT NULL after remise_percent;' |
| Request 226 sql='ALTER TABLE db_facture_fourn_det ADD UNIQUE INDEX uk_fk_remise_except (fk_remise_except, fk_facture_fourn);' |
| Request 227 sql='CREATE TABLE db_knowledgemanagement_knowledgerecord(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,ref varchar(128) NOT NULL,date_creation datetime NOT NULL,tms timestamp,last_main_doc varchar(255),fk_user_creat integer NOT NULL,fk_user_modif integer,fk_user_valid integer,import_key varchar(14),model_pdf varchar(255),question text NOT NULL,answer text,url varchar(255),fk_ticket integer,fk_c_ticket_category integer,status integer NOT NULL) ENGINE=innodb;' |
| Request 228 sql='ALTER TABLE db_knowledgemanagement_knowledgerecord ADD COLUMN fk_ticket integer;' |
| Request 229 sql='ALTER TABLE db_knowledgemanagement_knowledgerecord ADD COLUMN fk_c_ticket_category integer;' |
| Request 230 sql='ALTER TABLE db_knowledgemanagement_knowledgerecord ADD COLUMN url varchar(255);' |
| Request 231 sql='create table db_knowledgemanagement_knowledgerecord_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;' |
| Request 232 sql='ALTER TABLE db_adherent_type ADD COLUMN amount DOUBLE(24,8) NULL DEFAULT NULL AFTER subscription;' |
| Request 233 sql='INSERT INTO db_c_action_trigger (code,label,description,elementtype,rang) VALUES ('COMPANY_MODIFY','Third party update','Executed when you update third party','societe',1);' |
| Request 234 sql='INSERT INTO db_c_action_trigger (code,label,description,elementtype,rang) VALUES ('CONTACT_MODIFY','Contact address update','Executed when a contact is updated','contact',51);' |
| Request 235 sql='create table db_c_partnership_type(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,code varchar(32) NOT NULL,label varchar(64) NOT NULL,active tinyint DEFAULT 1 NOT NULL)ENGINE=innodb;' |
| Request 236 sql='DELETE FROM db_rights_def WHERE module = 'hrm' AND perms = 'employee';' |
| Request 237 sql='CREATE TABLE db_ecm_directories_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 238 sql='DROP TABLE db_categorie_association;' |
| Request 239 sql='DROP TABLE db_cond_reglement;' |
| Request 240 sql='DROP TABLE db_zapier_hook_extrafields;' |
| Request 241 sql='CREATE TABLE db_onlinesignature(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,object_type varchar(32) NOT NULL,object_id integer NOT NULL,datec datetime NOT NULL,tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,name varchar(255) NOT NULL,ip varchar(128),pathoffile varchar(255))ENGINE=innodb;' |
| Request 242 sql='ALTER TABLE db_partnership MODIFY COLUMN date_partnership_end date NULL;' |
| Request 243 sql='ALTER TABLE db_facture_fourn CHANGE COLUMN fk_mode_transport fk_transport_mode integer;' |
| Request 244 sql='ALTER TABLE db_c_socialnetworks DROP INDEX idx_c_socialnetworks_code;' |
| Request 245 sql='ALTER TABLE db_c_socialnetworks ADD UNIQUE INDEX idx_c_socialnetworks_code_entity (code, entity);' |
| Script processing | OK - Show-Hide details |
