migration_log.txt

650-201611 ==> 650-201707 Database changes -- Starts.
CREATE INDEX idx_crmentityrel_crmid ON vtiger_crmentityrel(crmid) Success
CREATE INDEX idx_crmentityrel_relcrmid ON vtiger_crmentityrel(relcrmid) Success
UPDATE vtiger_field SET `masseditable`=1 WHERE `tabid`=43 AND `tablename`='vtiger_sp_actbillads' Success
UPDATE vtiger_field SET `masseditable`=1 WHERE `tabid`=43 AND `tablename`='vtiger_sp_actshipads' Success
UPDATE vtiger_field SET `masseditable`=1 WHERE `tabid`=43 AND `fieldname` IN ('actdate', 'account_id','salesorder_id', 'contact_id', 'description') Success
UPDATE vtiger_field SET `masseditable`=1 WHERE `tabid`=46 AND `tablename`='vtiger_sp_consignmentbillads' Success
UPDATE vtiger_field SET `masseditable`=1 WHERE `tabid`=46 AND `tablename`='vtiger_sp_consignmentshipads' Success
UPDATE vtiger_field SET `masseditable`=1 WHERE `tabid`=46 AND `fieldname` IN ('salesorder_id', 'consigmentdate', 'account_id', 'contact_id', 'description', 'has_goods_consignment', 'goods_consignment_no') Success
UPDATE `vtiger_customview` SET `viewname`='Черновики БЗ' WHERE `viewname`='Черновики ЧаВо' Success
UPDATE `vtiger_customview` SET `viewname`='Опубликованные БЗ' WHERE `viewname`='Опубликованные ЧаВо' Success
UPDATE `vtiger_modentity_num` SET `prefix`='БЗ_' WHERE `prefix`='ЧаВо_' Success
UPDATE `vtiger_faq` SET `faq_no`=CONCAT('БЗ_','_no\r\n') Success
ALTER TABLE sp_custom_reports DROP COLUMN functionname Success
ALTER TABLE sp_custom_reports DROP COLUMN accountfilter Success
ALTER TABLE sp_custom_reports DROP COLUMN ownerfilter Success
ALTER TABLE sp_custom_reports DROP COLUMN datefilter Success
650-201611 ==> 650-201707 Database changes -- Ends.
650-201707 ==> 701-201707 Database changes -- Starts.
INSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES ('7','Act') Success
INSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES ('7','Consignment') Success
UPDATE vtiger_ws_entity SET handler_path='include/Webservices/LineItem/VtigerInventoryOperation.php',handler_class='VtigerInventoryOperation' where name in ('Invoice','Quotes','PurchaseOrder','SalesOrder','Act','Consignment'); Success
DELETE FROM vtiger_field WHERE tabid IN ('44','52','23','21','20','22') AND fieldname IN ('shtax1') Success