Personal tools

VTigerCRM SVN 13095 to 13099

From Proxmox VE

Jump to: navigation, search

Upgrading vTiger SVN 13095 to 13099

SQL changes

ALTER TABLE `vtigercrm520`.`vtiger_asteriskincomingcalls`     ADD COLUMN `refuid` varchar(255) default NULL AFTER `timer`;
ALTER TABLE `vtigercrm520`.`vtiger_relcriteria`     ADD COLUMN `groupid` int(11) default '1' AFTER `value`;
ALTER TABLE `vtigercrm520`.`vtiger_relcriteria`     ADD COLUMN `column_condition` varchar(256) default 'and' AFTER `groupid`;

UPDATE `vtigercrm520`.`vtiger_cvadvfilter` 
	SET `comparator` = 'c' WHERE `columnindex` = 0 AND 
	`columnname` = 'vtiger_pbxmanager:status:status:PBXManager_Status:V' AND `comparator` = 'e';

CREATE TABLE `vtiger_asteriskincomingevents` (
 `uid` varchar(255) NOT NULL,
 `channel` varchar(100) default NULL,
 `from_number` bigint(20) default NULL,
 `from_name` varchar(100) default NULL,
 `to_number` bigint(20) default NULL,
 `callertype` varchar(100) default NULL,
 `timer` int(20) default NULL,
 `flag` varchar(3) default NULL,
 `pbxrecordid` int(19) default NULL,
 `relcrmid` int(19) default NULL,
 PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `vtiger_relcriteria_grouping` (
 `groupid` int(11) NOT NULL,
 `queryid` int(19) NOT NULL,
 `group_condition` varchar(256) default NULL,
 `condition_expression` text,
 PRIMARY KEY  (`groupid`,`queryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert  into `vtiger_relcriteria_grouping`(`groupid`,`queryid`,`group_condition`,`condition_expression`) values (1,1,,'0');
insert  into `vtiger_relcriteria_grouping`(`groupid`,`queryid`,`group_condition`,`condition_expression`) values (1,2,,'0');
insert  into `vtiger_relcriteria_grouping`(`groupid`,`queryid`,`group_condition`,`condition_expression`) values (1,3,,'0');
insert  into `vtiger_relcriteria_grouping`(`groupid`,`queryid`,`group_condition`,`condition_expression`) values (1,7,,'0');
insert  into `vtiger_relcriteria_grouping`(`groupid`,`queryid`,`group_condition`,`condition_expression`) values (1,12,,'0');
insert  into `vtiger_relcriteria_grouping`(`groupid`,`queryid`,`group_condition`,`condition_expression`) values (1,15,,'0 and 1');

Code Changes

cd /var/www/vtigercrm
wget http://www.sacollege.net/files/appliances/vtiger-svn-13070-13099.tar.gz
tar -zxvpf vtiger-svn-13070-13099.tar.gz
rm vtiger-svn-13070-13099.tar.gz
Retrieved from "http://pve.proxmox.com/wiki/VTigerCRM_SVN_13095_to_13099"
Virtual Appliances