Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `vtiger830`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `com_vtiger_workflows`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `com_vtiger_workflows` (

[20] Fix | Delete

`workflow_id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`module_name` varchar(100) DEFAULT NULL,

[22] Fix | Delete

`summary` varchar(400) NOT NULL,

[23] Fix | Delete

`test` text NOT NULL,

[24] Fix | Delete

`execution_condition` int(11) NOT NULL,

[25] Fix | Delete

`defaultworkflow` int(1) DEFAULT NULL,

[26] Fix | Delete

`type` varchar(255) DEFAULT NULL,

[27] Fix | Delete

`filtersavedinnew` int(1) DEFAULT NULL,

[28] Fix | Delete

`schtypeid` int(10) DEFAULT NULL,

[29] Fix | Delete

`schdayofmonth` varchar(100) DEFAULT NULL,

[30] Fix | Delete

`schdayofweek` varchar(100) DEFAULT NULL,

[31] Fix | Delete

`schannualdates` varchar(500) DEFAULT NULL,

[32] Fix | Delete

`schtime` varchar(50) DEFAULT NULL,

[33] Fix | Delete

`nexttrigger_time` datetime DEFAULT NULL,

[34] Fix | Delete

`status` tinyint(1) DEFAULT '1',

[35] Fix | Delete

`workflowname` varchar(100) DEFAULT NULL,

[36] Fix | Delete

PRIMARY KEY (`workflow_id`),

[37] Fix | Delete

UNIQUE KEY `com_vtiger_workflows_idx` (`workflow_id`)

[38] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;

[39] Fix | Delete

[40] Fix | Delete

[41] Fix | Delete

-- Dumping data for table `com_vtiger_workflows`

[42] Fix | Delete

[43] Fix | Delete

[44] Fix | Delete

INSERT INTO `com_vtiger_workflows` VALUES

[45] Fix | Delete

(1, 'Invoice', 'UpdateInventoryProducts On Every Save', '[{"fieldname":"subject","operation":"does not contain","value":"`!`"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'UpdateInventoryProducts On Every Save'),

[46] Fix | Delete

(2, 'Accounts', 'Send Email to user when Notifyowner is True', '[{"fieldname":"notify_owner","operation":"is","value":"true:boolean"}]', 2, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to user when Notifyowner is True'),

[47] Fix | Delete

(3, 'Contacts', 'Send Email to user when Notifyowner is True', '[{"fieldname":"notify_owner","operation":"is","value":"true:boolean"}]', 2, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to user when Notifyowner is True'),

[48] Fix | Delete

(4, 'Contacts', 'Send Email to user when Portal User is True', '[{"fieldname":"portal","operation":"is","value":"1","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"email","operation":"is not empty","value":"","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to user when Portal User is True'),

[49] Fix | Delete

(5, 'Potentials', 'Send Email to users on Potential creation', '[]', 1, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to users on Potential creation'),

[50] Fix | Delete

(6, 'Contacts', 'Workflow for Contact Creation or Modification', '[]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Contact Creation or Modification'),

[51] Fix | Delete

(7, 'HelpDesk', 'Ticket Creation From Portal : Send Email to Record Owner and Contact', '[{"fieldname":"from_portal","operation":"is","value":1,"valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":0}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From Portal : Send Email to Record Owner and Contact'),

[52] Fix | Delete

(9, 'HelpDesk', 'Send Email to Contact on Ticket Update', '[{"fieldname":"(contact_id : (Contacts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":0,"valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":0},{"fieldname":"ticketstatus","operation":"has changed to","value":"Closed","valuetype":"rawtext","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"solution","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"description","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to Contact on Ticket Update'),

[53] Fix | Delete

(10, 'Events', 'Workflow for Events when Send Notification is True', '[{"fieldname":"sendnotification","operation":"is","value":"true:boolean"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Events when Send Notification is True'),

[54] Fix | Delete

(11, 'Calendar', 'Workflow for Calendar Todos when Send Notification is True', '[{"fieldname":"sendnotification","operation":"is","value":"true:boolean"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Calendar Todos when Send Notification is True'),

[55] Fix | Delete

(12, 'Potentials', 'Calculate or Update forecast amount', '[]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Calculate or Update forecast amount'),

[56] Fix | Delete

(13, 'Events', 'Workflow for Events when Send Notification is True', '[{"fieldname":"sendnotification","operation":"is","value":"true:boolean"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Events when Send Notification is True'),

[57] Fix | Delete

(14, 'Calendar', 'Workflow for Calendar Todos when Send Notification is True', '[{"fieldname":"sendnotification","operation":"is","value":"true:boolean"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Calendar Todos when Send Notification is True'),

[58] Fix | Delete

(15, 'HelpDesk', 'Comment Added From CRM : Send Email to Organization', '[{"fieldname":"_VT_add_comment","operation":"is added","value":"","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":"0","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"(parent_id : (Accounts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Comment Added From CRM : Send Email to Organization'),

[59] Fix | Delete

(16, 'PurchaseOrder', 'Update Inventory Products On Every Save', '[]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Update Inventory Products On Every Save'),

[60] Fix | Delete

(17, 'HelpDesk', 'Comment Added From Portal : Send Email to Record Owner', '[{"fieldname":"_VT_add_comment","operation":"is added","value":"","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":"1","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Comment Added From Portal : Send Email to Record Owner'),

[61] Fix | Delete

(18, 'HelpDesk', 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User', '[{"fieldname":"(contact_id : (Contacts) portal)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"_VT_add_comment","operation":"is added","value":"","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":"0","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"(contact_id : (Contacts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User'),

[62] Fix | Delete

(19, 'HelpDesk', 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User', '[{"fieldname":"(contact_id : (Contacts) portal)","operation":"is","value":"1","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"_VT_add_comment","operation":"is added","value":"","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":"0","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"},{"fieldname":"(contact_id : (Contacts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User'),

[63] Fix | Delete

(20, 'HelpDesk', 'Send Email to Record Owner on Ticket Update', '[{"fieldname":"from_portal","operation":"is","value":0,"valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":0},{"fieldname":"ticketstatus","operation":"has changed to","value":"Closed","valuetype":"rawtext","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"solution","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"assigned_user_id","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"description","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to Record Owner on Ticket Update'),

[64] Fix | Delete

(21, 'HelpDesk', 'Ticket Creation From CRM : Send Email to Record Owner', '[{"fieldname":"from_portal","operation":"is","value":"0","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From CRM : Send Email to Record Owner'),

[65] Fix | Delete

(22, 'HelpDesk', 'Send Email to Organization on Ticket Update', '[{"fieldname":"(parent_id : (Accounts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":0,"valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":0},{"fieldname":"ticketstatus","operation":"has changed to","value":"Closed","valuetype":"rawtext","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"solution","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"},{"fieldname":"description","operation":"has changed","value":"","valuetype":"","joincondition":"or","groupjoin":"and","groupid":"1"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to Organization on Ticket Update'),

[66] Fix | Delete

(23, 'HelpDesk', 'Ticket Creation From CRM : Send Email to Organization', '[{"fieldname":"(parent_id : (Accounts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":"0","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From CRM : Send Email to Organization'),

[67] Fix | Delete

(24, 'HelpDesk', 'Ticket Creation From CRM : Send Email to Contact', '[{"fieldname":"(contact_id : (Contacts) emailoptout)","operation":"is","value":"0","valuetype":"rawtext","joincondition":"and","groupjoin":"and","groupid":"0"},{"fieldname":"from_portal","operation":"is","value":"0","valuetype":"rawtext","joincondition":"","groupjoin":"and","groupid":"0"}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From CRM : Send Email to Contact');

[68] Fix | Delete

[69] Fix | Delete

-- --------------------------------------------------------

[70] Fix | Delete

[71] Fix | Delete

[72] Fix | Delete

-- Table structure for table `com_vtiger_workflows_seq`

[73] Fix | Delete

[74] Fix | Delete

[75] Fix | Delete

CREATE TABLE `com_vtiger_workflows_seq` (

[76] Fix | Delete

`id` int(11) NOT NULL

[77] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[78] Fix | Delete

[79] Fix | Delete

[80] Fix | Delete

-- Dumping data for table `com_vtiger_workflows_seq`

[81] Fix | Delete

[82] Fix | Delete

[83] Fix | Delete

INSERT INTO `com_vtiger_workflows_seq` VALUES

[84] Fix | Delete

(24);

[85] Fix | Delete

[86] Fix | Delete

-- --------------------------------------------------------

[87] Fix | Delete

[88] Fix | Delete

[89] Fix | Delete

-- Table structure for table `com_vtiger_workflowtasks`

[90] Fix | Delete

[91] Fix | Delete

[92] Fix | Delete

CREATE TABLE `com_vtiger_workflowtasks` (

[93] Fix | Delete

`task_id` int(11) NOT NULL AUTO_INCREMENT,

[94] Fix | Delete

`workflow_id` int(11) DEFAULT NULL,

[95] Fix | Delete

`summary` varchar(400) NOT NULL,

[96] Fix | Delete

`task` text NOT NULL,

[97] Fix | Delete

PRIMARY KEY (`task_id`),

[98] Fix | Delete

UNIQUE KEY `com_vtiger_workflowtasks_idx` (`task_id`)

[99] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

[100] Fix | Delete

[101] Fix | Delete

[102] Fix | Delete

-- Dumping data for table `com_vtiger_workflowtasks`

[103] Fix | Delete

[104] Fix | Delete

[105] Fix | Delete

INSERT INTO `com_vtiger_workflowtasks` VALUES

[106] Fix | Delete

(1, 1, '', 'O:18:"VTEntityMethodTask":6:{s:18:"executeImmediately";b:1;s:10:"workflowId";i:1;s:7:"summary";s:0:"";s:6:"active";b:1;s:10:"methodName";s:15:"UpdateInventory";s:2:"id";i:1;}'),

[107] Fix | Delete

(2, 2, 'An account has been created ', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"2";s:7:"summary";s:28:"An account has been created ";s:6:"active";s:1:"1";s:10:"methodName";s:11:"NotifyOwner";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:26:"Regarding Account Creation";s:7:"content";s:301:"An Account has been assigned to you on vtigerCRM Details of account are : AccountId:$account_no AccountName:$accountname Rating:$rating Industry:$industry AccountType:$accounttype Description:$description Thank You Admin";s:2:"id";s:1:"2";}'),

[108] Fix | Delete

(3, 3, 'An contact has been created ', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"3";s:7:"summary";s:28:"An contact has been created ";s:6:"active";s:1:"1";s:10:"methodName";s:11:"NotifyOwner";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:26:"Regarding Contact Creation";s:7:"content";s:305:"An Contact has been assigned to you on vtigerCRM Details of Contact are : Contact Id:$contact_no LastName:$lastname FirstName:$firstname Lead Source:$leadsource Department:$department Description:$description Thank You Admin";s:2:"id";s:1:"3";}'),

[109] Fix | Delete

(4, 4, 'Email Customer Portal Login Details', 'O:18:"VTEntityMethodTask":6:{s:18:"executeImmediately";b:1;s:10:"workflowId";i:4;s:7:"summary";s:35:"Email Customer Portal Login Details";s:6:"active";b:1;s:10:"methodName";s:22:"SendPortalLoginDetails";s:2:"id";i:4;}'),

[110] Fix | Delete

(5, 5, 'An Potential has been created ', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"5";s:7:"summary";s:30:"An Potential has been created ";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:30:"Regarding Potential Assignment";s:7:"content";s:342:"An Potential has been assigned to you on vtigerCRM Details of Potential are : Potential No:$potential_no Potential Name:$potentialname Amount:$amount Expected Close Date:$closingdate ($_DATE_FORMAT_) Type:$opportunity_type Description :$description Thank You Admin";s:2:"id";s:1:"5";}'),

[111] Fix | Delete

(6, 6, 'An contact has been created ', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"6";s:7:"summary";s:28:"An contact has been created ";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:28:"Regarding Contact Assignment";s:7:"content";s:384:"An Contact has been assigned to you on vtigerCRM Details of Contact are : Contact Id:$contact_no LastName:$lastname FirstName:$firstname Lead Source:$leadsource Department:$department Description:$description And CustomerPortal Login Details is sent to the EmailID :-$email Thank You Admin";s:2:"id";s:1:"6";}'),

[112] Fix | Delete

(7, 7, 'Notify Related Contact when Ticket is created from Portal', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:57:"Notify Related Contact when Ticket is created from Portal";s:6:"active";s:1:"1";s:2:"id";s:1:"7";s:10:"workflowId";s:1:"7";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:93:"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:158:"Ticket No : $ticket_no \n Ticket ID : $(general : (__VtigerMeta__) recordId) \n Ticket Title : $ticket_title \n $description";}'),

[113] Fix | Delete

(10, 9, 'Send Email to Contact on Ticket Update', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:38:"Send Email to Contact on Ticket Update";s:6:"active";s:1:"1";s:2:"id";s:2:"10";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:624:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution \n The comments are : \n $allComments \n Regards Support Administrator";s:10:"workflowId";s:1:"9";}'),

[114] Fix | Delete

(13, 12, 'update forecast amount', 'O:18:"VTUpdateFieldsTask":7:{s:18:"executeImmediately";b:1;s:43:"\0VTUpdateFieldsTask\0referenceFieldFocusList";a:0:{}s:10:"workflowId";i:12;s:7:"summary";s:22:"update forecast amount";s:6:"active";b:1;s:19:"field_value_mapping";s:95:"[{"fieldname":"forecast_amount","valuetype":"expression","value":"amount * probability / 100"}]";s:2:"id";i:13;}'),

[115] Fix | Delete

(14, 13, 'Send Notification Email to Record Owner', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:2:"13";s:7:"summary";s:39:"Send Notification Email to Record Owner";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:17:"Event : $subject";s:7:"content";s:771:"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) , Activity Notification Details: Subject : $subject Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone)) End date and time : $due_date ($(general : (__VtigerMeta__) usertimezone)) Status : $eventstatus Priority : $taskpriority Related To : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname) Contacts List : $contact_id Location : $location Description : $description";s:2:"id";s:2:"14";}'),

[116] Fix | Delete

(15, 14, 'Send Notification Email to Record Owner', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:2:"14";s:7:"summary";s:39:"Send Notification Email to Record Owner";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:16:"Task : $subject";s:7:"content";s:689:"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) , Task Notification Details: Subject : $subject Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone)) End date and time : $due_date ($_DATE_FORMAT_) Status : $taskstatus Priority : $taskpriority Related To : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname) Contacts List : $contact_id Description : $description";s:2:"id";s:2:"15";}'),

[117] Fix | Delete

(18, 16, 'Update Inventory Products', 'O:18:"VTEntityMethodTask":6:{s:18:"executeImmediately";b:1;s:10:"workflowId";i:16;s:7:"summary";s:25:"Update Inventory Products";s:6:"active";b:1;s:10:"methodName";s:15:"UpdateInventory";s:2:"id";i:18;}'),

[118] Fix | Delete

(19, 17, 'Comment Added From Portal : Send Email to Record Owner', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:54:"Comment Added From Portal : Send Email to Record Owner";s:6:"active";s:1:"1";s:2:"id";s:2:"19";s:10:"workflowId";s:2:"17";s:9:"fromEmail";s:112:"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(contact_id : (Contacts) email)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:92:"Respond to Ticket ID## $(general : (__VtigerMeta__) recordId) ## in Customer Portal - URGENT";s:7:"content";s:325:"Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name), \n Customer has provided the following additional information to your reply: \n $lastComment \n Kindly respond to above ticket at the earliest. \n Regards Support Administrator";}'),

[119] Fix | Delete

(20, 18, 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:82:"Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User";s:6:"active";s:1:"1";s:2:"id";s:2:"20";s:10:"workflowId";s:2:"18";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:514:"Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution \n The comments are : \n $allComments \n Regards Support Administrator";}'),

[120] Fix | Delete

(21, 19, 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:76:"Comment Added From CRM : Send Email to Contact, where Contact is Portal User";s:6:"active";s:1:"1";s:2:"id";s:2:"21";s:10:"workflowId";s:2:"19";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:547:"Ticket No : $ticket_no \n Ticket Id : $(general : (__VtigerMeta__) recordId) \n Subject : $ticket_title \n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname), \n There is a reply to $ticket_title in the "Customer Portal" at VTiger.\n You can use the following link to view the replies made: \n <a href="$(general : (__VtigerMeta__) portaldetailviewurl)">Ticket Details</a> \n Thanks $(general : (__VtigerMeta__) supportName)";}'),

[121] Fix | Delete

(22, 15, 'Comment Added From CRM : Send Email to Organization', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:51:"Comment Added From CRM : Send Email to Organization";s:6:"active";s:1:"1";s:2:"id";s:2:"22";s:10:"workflowId";s:2:"15";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:34:",$(parent_id : (Accounts) email1),";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:589:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(parent_id : (Accounts) accountname), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution \n The comments are : \n $allComments \n Regards Support Administrator";}'),

[122] Fix | Delete

(23, 7, 'Notify Record Owner when Ticket is created from Portal', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:54:"Notify Record Owner when Ticket is created from Portal";s:6:"active";s:1:"1";s:2:"id";s:2:"23";s:10:"workflowId";s:1:"7";s:9:"fromEmail";s:124:"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:93:"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:158:"Ticket No : $ticket_no \n Ticket ID : $(general : (__VtigerMeta__) recordId) \n Ticket Title : $ticket_title \n $description";}'),

[123] Fix | Delete

(24, 20, 'Send Email to Record Owner on Ticket Update', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:43:"Send Email to Record Owner on Ticket Update";s:6:"active";s:1:"1";s:2:"id";s:2:"24";s:10:"workflowId";s:2:"20";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:40:"Ticket Number : $ticket_no $ticket_title";s:7:"content";s:596:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution\n $allComments \n Regards Support Administrator";}'),

[124] Fix | Delete

(25, 21, 'Ticket Creation From CRM : Send Email to Record Owner', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:53:"Ticket Creation From CRM : Send Email to Record Owner";s:6:"active";s:1:"1";s:2:"id";s:2:"25";s:10:"workflowId";s:2:"21";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:40:"Ticket Number : $ticket_no $ticket_title";s:7:"content";s:596:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution\n $allComments \n Regards Support Administrator";}'),

[125] Fix | Delete

(26, 22, 'Send Email to Organization on Ticket Update', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:43:"Send Email to Organization on Ticket Update";s:6:"active";s:1:"1";s:2:"id";s:2:"26";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(parent_id : (Accounts) email1)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:589:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(parent_id : (Accounts) accountname), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution \n The comments are : \n $allComments \n Regards Support Administrator";s:10:"workflowId";s:2:"22";}'),

[126] Fix | Delete

(27, 23, 'Ticket Creation From CRM : Send Email to Organization', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:53:"Ticket Creation From CRM : Send Email to Organization";s:6:"active";s:1:"1";s:2:"id";s:2:"27";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(parent_id : (Accounts) email1)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:589:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(parent_id : (Accounts) accountname), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution \n The comments are : \n $allComments \n Regards Support Administrator";s:10:"workflowId";s:2:"23";}'),

[127] Fix | Delete

(28, 24, 'Ticket Creation From CRM : Send Email to Contact', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:48:"Ticket Creation From CRM : Send Email to Contact";s:6:"active";s:1:"1";s:2:"id";s:2:"28";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:624:"Ticket ID : $(general : (__VtigerMeta__) recordId) Ticket Title : $ticket_title \n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname), \n The Ticket is replied the details are : \n Ticket No : $ticket_no \n Status : $ticketstatus \n Category : $ticketcategories \n Severity : $ticketseverities \n Priority : $ticketpriorities \n Description : $description \n Solution : $solution \n The comments are : \n $allComments \n Regards Support Administrator";s:10:"workflowId";s:2:"24";}');

[128] Fix | Delete

[129] Fix | Delete

-- --------------------------------------------------------

[130] Fix | Delete

[131] Fix | Delete

[132] Fix | Delete

-- Table structure for table `com_vtiger_workflowtasks_entitymethod`

[133] Fix | Delete

[134] Fix | Delete

[135] Fix | Delete

CREATE TABLE `com_vtiger_workflowtasks_entitymethod` (

[136] Fix | Delete

`workflowtasks_entitymethod_id` int(11) NOT NULL,

[137] Fix | Delete

`module_name` varchar(100) DEFAULT NULL,

[138] Fix | Delete

`method_name` varchar(100) DEFAULT NULL,

[139] Fix | Delete

`function_path` varchar(400) DEFAULT NULL,

[140] Fix | Delete

`function_name` varchar(100) DEFAULT NULL,

[141] Fix | Delete

PRIMARY KEY (`workflowtasks_entitymethod_id`),

[142] Fix | Delete

UNIQUE KEY `com_vtiger_workflowtasks_entitymethod_idx` (`workflowtasks_entitymethod_id`)

[143] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[144] Fix | Delete

[145] Fix | Delete

[146] Fix | Delete

-- Dumping data for table `com_vtiger_workflowtasks_entitymethod`

[147] Fix | Delete

[148] Fix | Delete

[149] Fix | Delete

INSERT INTO `com_vtiger_workflowtasks_entitymethod` VALUES

[150] Fix | Delete

(1, 'SalesOrder', 'UpdateInventory', 'include/InventoryHandler.php', 'handleInventoryProductRel'),

[151] Fix | Delete

(2, 'Invoice', 'UpdateInventory', 'include/InventoryHandler.php', 'handleInventoryProductRel'),

[152] Fix | Delete

(3, 'Contacts', 'SendPortalLoginDetails', 'modules/Contacts/ContactsHandler.php', 'Contacts_sendCustomerPortalLoginDetails'),

[153] Fix | Delete

(4, 'HelpDesk', 'NotifyOnPortalTicketCreation', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_nofifyOnPortalTicketCreation'),

[154] Fix | Delete

(5, 'HelpDesk', 'NotifyOnPortalTicketComment', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_notifyOnPortalTicketComment'),

[155] Fix | Delete

(6, 'HelpDesk', 'NotifyOwnerOnTicketChange', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_notifyOwnerOnTicketChange'),

[156] Fix | Delete

(7, 'HelpDesk', 'NotifyParentOnTicketChange', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_notifyParentOnTicketChange'),

[157] Fix | Delete

(8, 'ModComments', 'CustomerCommentFromPortal', 'modules/ModComments/ModCommentsHandler.php', 'CustomerCommentFromPortal'),

[158] Fix | Delete

(9, 'ModComments', 'TicketOwnerComments', 'modules/ModComments/ModCommentsHandler.php', 'TicketOwnerComments'),

[159] Fix | Delete

(10, 'PurchaseOrder', 'UpdateInventory', 'include/InventoryHandler.php', 'handleInventoryProductRel');

[160] Fix | Delete

[161] Fix | Delete

-- --------------------------------------------------------

[162] Fix | Delete

[163] Fix | Delete

[164] Fix | Delete

-- Table structure for table `com_vtiger_workflowtasks_entitymethod_seq`

[165] Fix | Delete

[166] Fix | Delete

[167] Fix | Delete

CREATE TABLE `com_vtiger_workflowtasks_entitymethod_seq` (

[168] Fix | Delete

`id` int(11) NOT NULL

[169] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[170] Fix | Delete

[171] Fix | Delete

[172] Fix | Delete

-- Dumping data for table `com_vtiger_workflowtasks_entitymethod_seq`

[173] Fix | Delete

[174] Fix | Delete

[175] Fix | Delete

INSERT INTO `com_vtiger_workflowtasks_entitymethod_seq` VALUES

[176] Fix | Delete

(10);

[177] Fix | Delete

[178] Fix | Delete

-- --------------------------------------------------------

[179] Fix | Delete

[180] Fix | Delete

[181] Fix | Delete

-- Table structure for table `com_vtiger_workflowtasks_seq`

[182] Fix | Delete

[183] Fix | Delete

[184] Fix | Delete

CREATE TABLE `com_vtiger_workflowtasks_seq` (

[185] Fix | Delete

`id` int(11) NOT NULL

[186] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[187] Fix | Delete

[188] Fix | Delete

[189] Fix | Delete

-- Dumping data for table `com_vtiger_workflowtasks_seq`

[190] Fix | Delete

[191] Fix | Delete

[192] Fix | Delete

INSERT INTO `com_vtiger_workflowtasks_seq` VALUES

[193] Fix | Delete

(28);

[194] Fix | Delete

[195] Fix | Delete

-- --------------------------------------------------------

[196] Fix | Delete

[197] Fix | Delete

[198] Fix | Delete

-- Table structure for table `com_vtiger_workflowtask_queue`

[199] Fix | Delete

[200] Fix | Delete

[201] Fix | Delete

CREATE TABLE `com_vtiger_workflowtask_queue` (

[202] Fix | Delete

`task_id` int(11) DEFAULT NULL,

[203] Fix | Delete

`entity_id` varchar(100) DEFAULT NULL,

[204] Fix | Delete

`do_after` int(11) DEFAULT NULL,

[205] Fix | Delete

`relatedinfo` varchar(255) DEFAULT NULL,

[206] Fix | Delete

`task_contents` text

[207] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[208] Fix | Delete

[209] Fix | Delete

-- --------------------------------------------------------

[210] Fix | Delete

[211] Fix | Delete

[212] Fix | Delete

-- Table structure for table `com_vtiger_workflowtemplates`

[213] Fix | Delete

[214] Fix | Delete

[215] Fix | Delete

CREATE TABLE `com_vtiger_workflowtemplates` (

[216] Fix | Delete

`template_id` int(11) NOT NULL AUTO_INCREMENT,

[217] Fix | Delete

`module_name` varchar(100) DEFAULT NULL,

[218] Fix | Delete

`title` varchar(400) DEFAULT NULL,

[219] Fix | Delete

`template` text,

[220] Fix | Delete

PRIMARY KEY (`template_id`)

[221] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[222] Fix | Delete

[223] Fix | Delete

-- --------------------------------------------------------

[224] Fix | Delete

[225] Fix | Delete

[226] Fix | Delete

-- Table structure for table `com_vtiger_workflow_activatedonce`

[227] Fix | Delete

[228] Fix | Delete

[229] Fix | Delete

CREATE TABLE `com_vtiger_workflow_activatedonce` (

[230] Fix | Delete

`workflow_id` int(11) NOT NULL,

[231] Fix | Delete

`entity_id` int(11) NOT NULL,

[232] Fix | Delete

PRIMARY KEY (`workflow_id`,`entity_id`)

[233] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[234] Fix | Delete

[235] Fix | Delete

-- --------------------------------------------------------

[236] Fix | Delete

[237] Fix | Delete

[238] Fix | Delete

-- Table structure for table `com_vtiger_workflow_tasktypes`

[239] Fix | Delete

[240] Fix | Delete

[241] Fix | Delete

CREATE TABLE `com_vtiger_workflow_tasktypes` (

[242] Fix | Delete

`id` int(11) NOT NULL,

[243] Fix | Delete

`tasktypename` varchar(255) NOT NULL,

[244] Fix | Delete

`label` varchar(255) DEFAULT NULL,

[245] Fix | Delete

`classname` varchar(255) DEFAULT NULL,

[246] Fix | Delete

`classpath` varchar(255) DEFAULT NULL,

[247] Fix | Delete

`templatepath` varchar(255) DEFAULT NULL,

[248] Fix | Delete

`modules` varchar(500) DEFAULT NULL,

[249] Fix | Delete

`sourcemodule` varchar(255) DEFAULT NULL

[250] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[251] Fix | Delete

[252] Fix | Delete

[253] Fix | Delete

-- Dumping data for table `com_vtiger_workflow_tasktypes`

[254] Fix | Delete

[255] Fix | Delete

[256] Fix | Delete

INSERT INTO `com_vtiger_workflow_tasktypes` VALUES

[257] Fix | Delete

(1, 'VTEmailTask', 'Send Mail', 'VTEmailTask', 'modules/com_vtiger_workflow/tasks/VTEmailTask.inc', 'modules/Settings/Workflows/Tasks/VTEmailTask.tpl', '{"include":[],"exclude":[]}', ''),

[258] Fix | Delete

(2, 'VTEntityMethodTask', 'Invoke Custom Function', 'VTEntityMethodTask', 'modules/com_vtiger_workflow/tasks/VTEntityMethodTask.inc', 'modules/Settings/Workflows/Tasks/VTEntityMethodTask.tpl', '{"include":[],"exclude":[]}', ''),

[259] Fix | Delete

(3, 'VTCreateTodoTask', 'Create Todo', 'VTCreateTodoTask', 'modules/com_vtiger_workflow/tasks/VTCreateTodoTask.inc', 'modules/Settings/Workflows/Tasks/VTCreateTodoTask.tpl', '{"include":["Leads","Accounts","Potentials","Contacts","HelpDesk","Campaigns","Quotes","PurchaseOrder","SalesOrder","Invoice","Project"],"exclude":["Calendar","FAQ","Events"]}', ''),

[260] Fix | Delete

(4, 'VTCreateEventTask', 'Create Event', 'VTCreateEventTask', 'modules/com_vtiger_workflow/tasks/VTCreateEventTask.inc', 'modules/Settings/Workflows/Tasks/VTCreateEventTask.tpl', '{"include":["Leads","Accounts","Potentials","Contacts","HelpDesk","Campaigns","Project"],"exclude":["Calendar","FAQ","Events"]}', ''),

[261] Fix | Delete

(5, 'VTUpdateFieldsTask', 'Update Fields', 'VTUpdateFieldsTask', 'modules/com_vtiger_workflow/tasks/VTUpdateFieldsTask.inc', 'modules/Settings/Workflows/Tasks/VTUpdateFieldsTask.tpl', '{"include":[],"exclude":[]}', ''),

[262] Fix | Delete

(6, 'VTCreateEntityTask', 'Create Entity', 'VTCreateEntityTask', 'modules/com_vtiger_workflow/tasks/VTCreateEntityTask.inc', 'modules/Settings/Workflows/Tasks/VTCreateEntityTask.tpl', '{"include":[],"exclude":[]}', ''),

[263] Fix | Delete

(7, 'VTSMSTask', 'SMS Task', 'VTSMSTask', 'modules/com_vtiger_workflow/tasks/VTSMSTask.inc', 'modules/Settings/Workflows/Tasks/VTSMSTask.tpl', '{"include":[],"exclude":[]}', 'SMSNotifier');

[264] Fix | Delete

[265] Fix | Delete

-- --------------------------------------------------------

[266] Fix | Delete

[267] Fix | Delete

[268] Fix | Delete

-- Table structure for table `com_vtiger_workflow_tasktypes_seq`

[269] Fix | Delete

[270] Fix | Delete

[271] Fix | Delete

CREATE TABLE `com_vtiger_workflow_tasktypes_seq` (

[272] Fix | Delete

`id` int(11) NOT NULL

[273] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[274] Fix | Delete

[275] Fix | Delete

[276] Fix | Delete

-- Dumping data for table `com_vtiger_workflow_tasktypes_seq`

[277] Fix | Delete

[278] Fix | Delete

[279] Fix | Delete

INSERT INTO `com_vtiger_workflow_tasktypes_seq` VALUES

[280] Fix | Delete

(7);

[281] Fix | Delete

[282] Fix | Delete

-- --------------------------------------------------------

[283] Fix | Delete

[284] Fix | Delete

[285] Fix | Delete

-- Table structure for table `vtiger_account`

[286] Fix | Delete

[287] Fix | Delete

[288] Fix | Delete

CREATE TABLE `vtiger_account` (

[289] Fix | Delete

`accountid` int(19) NOT NULL DEFAULT '0',

[290] Fix | Delete

`account_no` varchar(100) NOT NULL,

[291] Fix | Delete

`accountname` varchar(100) NOT NULL,

[292] Fix | Delete

`parentid` int(19) DEFAULT '0',

[293] Fix | Delete

`account_type` varchar(200) DEFAULT NULL,

[294] Fix | Delete

`industry` varchar(200) DEFAULT NULL,

[295] Fix | Delete

`annualrevenue` decimal(25,8) DEFAULT NULL,

[296] Fix | Delete

`rating` varchar(200) DEFAULT NULL,

[297] Fix | Delete

`ownership` varchar(50) DEFAULT NULL,

[298] Fix | Delete

`siccode` varchar(50) DEFAULT NULL,

[299] Fix | Delete

`tickersymbol` varchar(30) DEFAULT NULL,

[300] Fix | Delete

`phone` varchar(30) DEFAULT NULL,

[301] Fix | Delete

`otherphone` varchar(30) DEFAULT NULL,

[302] Fix | Delete

`email1` varchar(100) DEFAULT NULL,

[303] Fix | Delete

`email2` varchar(100) DEFAULT NULL,

[304] Fix | Delete

`website` varchar(100) DEFAULT NULL,

[305] Fix | Delete

`fax` varchar(30) DEFAULT NULL,

[306] Fix | Delete

`employees` int(10) DEFAULT '0',

[307] Fix | Delete

`emailoptout` varchar(3) DEFAULT '0',

[308] Fix | Delete

`notify_owner` varchar(3) DEFAULT '0',

[309] Fix | Delete

`isconvertedfromlead` varchar(3) DEFAULT '0',

[310] Fix | Delete

`tags` varchar(1) DEFAULT NULL,

[311] Fix | Delete

PRIMARY KEY (`accountid`),

[312] Fix | Delete

KEY `account_account_type_idx` (`account_type`),

[313] Fix | Delete

KEY `email_idx` (`email1`,`email2`)

[314] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[315] Fix | Delete

[316] Fix | Delete

-- --------------------------------------------------------

[317] Fix | Delete

[318] Fix | Delete

[319] Fix | Delete

-- Table structure for table `vtiger_accountbillads`

[320] Fix | Delete

[321] Fix | Delete

[322] Fix | Delete

CREATE TABLE `vtiger_accountbillads` (

[323] Fix | Delete

`accountaddressid` int(19) NOT NULL DEFAULT '0',

[324] Fix | Delete

`bill_city` varchar(30) DEFAULT NULL,

[325] Fix | Delete

`bill_code` varchar(30) DEFAULT NULL,

[326] Fix | Delete

`bill_country` varchar(30) DEFAULT NULL,

[327] Fix | Delete

`bill_state` varchar(30) DEFAULT NULL,

[328] Fix | Delete

`bill_street` varchar(250) DEFAULT NULL,

[329] Fix | Delete

`bill_pobox` varchar(30) DEFAULT NULL,

[330] Fix | Delete

PRIMARY KEY (`accountaddressid`)

[331] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[332] Fix | Delete

[333] Fix | Delete

-- --------------------------------------------------------

[334] Fix | Delete

[335] Fix | Delete

[336] Fix | Delete

-- Table structure for table `vtiger_accountrating`

[337] Fix | Delete

[338] Fix | Delete

[339] Fix | Delete

CREATE TABLE `vtiger_accountrating` (

[340] Fix | Delete

`accountratingid` int(19) NOT NULL AUTO_INCREMENT,

[341] Fix | Delete

`rating` varchar(200) NOT NULL,

[342] Fix | Delete

`sortorderid` int(19) NOT NULL DEFAULT '0',

[343] Fix | Delete

`presence` int(1) NOT NULL DEFAULT '1',

[344] Fix | Delete

PRIMARY KEY (`accountratingid`),

[345] Fix | Delete

UNIQUE KEY `accountrating_rating_idx` (`rating`)

[346] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[347] Fix | Delete

[348] Fix | Delete

-- --------------------------------------------------------

[349] Fix | Delete

[350] Fix | Delete

[351] Fix | Delete

-- Table structure for table `vtiger_accountscf`

[352] Fix | Delete

[353] Fix | Delete

[354] Fix | Delete

CREATE TABLE `vtiger_accountscf` (

[355] Fix | Delete

`accountid` int(19) NOT NULL DEFAULT '0',

[356] Fix | Delete

PRIMARY KEY (`accountid`)

[357] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[358] Fix | Delete

[359] Fix | Delete

-- --------------------------------------------------------

[360] Fix | Delete

[361] Fix | Delete

[362] Fix | Delete

-- Table structure for table `vtiger_accountshipads`

[363] Fix | Delete

[364] Fix | Delete

[365] Fix | Delete

CREATE TABLE `vtiger_accountshipads` (

[366] Fix | Delete

`accountaddressid` int(19) NOT NULL DEFAULT '0',

[367] Fix | Delete

`ship_city` varchar(30) DEFAULT NULL,

[368] Fix | Delete

`ship_code` varchar(30) DEFAULT NULL,

[369] Fix | Delete

`ship_country` varchar(30) DEFAULT NULL,

[370] Fix | Delete

`ship_state` varchar(30) DEFAULT NULL,

[371] Fix | Delete

`ship_pobox` varchar(30) DEFAULT NULL,

[372] Fix | Delete

`ship_street` varchar(250) DEFAULT NULL,

[373] Fix | Delete

PRIMARY KEY (`accountaddressid`)

[374] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[375] Fix | Delete

[376] Fix | Delete

-- --------------------------------------------------------

[377] Fix | Delete

[378] Fix | Delete

[379] Fix | Delete

-- Table structure for table `vtiger_accounttype`

[380] Fix | Delete

[381] Fix | Delete

[382] Fix | Delete

CREATE TABLE `vtiger_accounttype` (

[383] Fix | Delete

`accounttypeid` int(19) NOT NULL AUTO_INCREMENT,

[384] Fix | Delete

`accounttype` varchar(200) NOT NULL,

[385] Fix | Delete

`presence` int(1) NOT NULL DEFAULT '1',

[386] Fix | Delete

`picklist_valueid` int(19) NOT NULL DEFAULT '0',

[387] Fix | Delete

`sortorderid` int(11) DEFAULT NULL,

[388] Fix | Delete

`color` varchar(10) DEFAULT NULL,

[389] Fix | Delete

PRIMARY KEY (`accounttypeid`),

[390] Fix | Delete

UNIQUE KEY `accounttype_accounttype_idx` (`accounttype`)

[391] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

[392] Fix | Delete

[393] Fix | Delete

[394] Fix | Delete

-- Dumping data for table `vtiger_accounttype`

[395] Fix | Delete

[396] Fix | Delete

[397] Fix | Delete

INSERT INTO `vtiger_accounttype` VALUES

[398] Fix | Delete

(2, 'Analyst', 1, 2, 1, NULL),

[399] Fix | Delete

(3, 'Competitor', 1, 3, 2, NULL),

[400] Fix | Delete

(4, 'Customer', 1, 4, 3, NULL),

[401] Fix | Delete

(5, 'Integrator', 1, 5, 4, NULL),

[402] Fix | Delete

(6, 'Investor', 1, 6, 5, NULL),

[403] Fix | Delete

(7, 'Partner', 1, 7, 6, NULL),

[404] Fix | Delete

(8, 'Press', 1, 8, 7, NULL),

[405] Fix | Delete

(9, 'Prospect', 1, 9, 8, NULL),

[406] Fix | Delete

(10, 'Reseller', 1, 10, 9, NULL),

[407] Fix | Delete

(11, 'Other', 1, 11, 10, NULL);

[408] Fix | Delete

[409] Fix | Delete

-- --------------------------------------------------------

[410] Fix | Delete

[411] Fix | Delete

[412] Fix | Delete

-- Table structure for table `vtiger_accounttype_seq`

[413] Fix | Delete

[414] Fix | Delete

[415] Fix | Delete

CREATE TABLE `vtiger_accounttype_seq` (

[416] Fix | Delete

`id` int(11) NOT NULL

[417] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[418] Fix | Delete

[419] Fix | Delete

[420] Fix | Delete

-- Dumping data for table `vtiger_accounttype_seq`

[421] Fix | Delete

[422] Fix | Delete

[423] Fix | Delete

INSERT INTO `vtiger_accounttype_seq` VALUES

[424] Fix | Delete

(11);

[425] Fix | Delete

[426] Fix | Delete

-- --------------------------------------------------------

[427] Fix | Delete

[428] Fix | Delete

[429] Fix | Delete

-- Table structure for table `vtiger_actionmapping`

[430] Fix | Delete

[431] Fix | Delete

[432] Fix | Delete

CREATE TABLE `vtiger_actionmapping` (

[433] Fix | Delete

`actionid` int(19) NOT NULL,

[434] Fix | Delete

`actionname` varchar(200) NOT NULL,

[435] Fix | Delete

`securitycheck` int(19) DEFAULT NULL,

[436] Fix | Delete

PRIMARY KEY (`actionid`,`actionname`)

[437] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[438] Fix | Delete

[439] Fix | Delete

[440] Fix | Delete

-- Dumping data for table `vtiger_actionmapping`

[441] Fix | Delete

[442] Fix | Delete

[443] Fix | Delete

INSERT INTO `vtiger_actionmapping` VALUES

[444] Fix | Delete

(0, 'Save', 0),

[445] Fix | Delete

(0, 'SavePriceBook', 1),

[446] Fix | Delete

(0, 'SaveVendor', 1),

[447] Fix | Delete

(1, 'DetailViewAjax', 1),

[448] Fix | Delete

(1, 'EditView', 0),

[449] Fix | Delete

(1, 'PriceBookEditView', 1),

[450] Fix | Delete

(1, 'QuickCreate', 1),

[451] Fix | Delete

(1, 'VendorEditView', 1),

[452] Fix | Delete

(2, 'Delete', 0),

[453] Fix | Delete

(2, 'DeletePriceBook', 1),

[454] Fix | Delete

(2, 'DeleteVendor', 1),

[455] Fix | Delete

(3, 'index', 0),

[456] Fix | Delete

(3, 'Popup', 1),

[457] Fix | Delete

(4, 'DetailView', 0),

[458] Fix | Delete

(4, 'PriceBookDetailView', 1),

[459] Fix | Delete

(4, 'TagCloud', 1),

[460] Fix | Delete

(4, 'VendorDetailView', 1),

[461] Fix | Delete

(5, 'Import', 0),

[462] Fix | Delete

(6, 'Export', 0),

[463] Fix | Delete

(7, 'CreateView', 0),

[464] Fix | Delete

(8, 'Merge', 0),

[465] Fix | Delete

(9, 'ConvertLead', 0),

[466] Fix | Delete

(10, 'DuplicatesHandling', 0),

[467] Fix | Delete

(11, 'ReceiveIncomingCalls', 0),

[468] Fix | Delete

(12, 'MakeOutgoingCalls', 0),

[469] Fix | Delete

(13, 'Print', 0);

[470] Fix | Delete

[471] Fix | Delete

-- --------------------------------------------------------

[472] Fix | Delete

[473] Fix | Delete

[474] Fix | Delete

-- Table structure for table `vtiger_activity`

[475] Fix | Delete

[476] Fix | Delete

[477] Fix | Delete

CREATE TABLE `vtiger_activity` (

[478] Fix | Delete

`activityid` int(19) NOT NULL DEFAULT '0',

[479] Fix | Delete

`subject` varchar(255) DEFAULT NULL,

[480] Fix | Delete

`semodule` varchar(20) DEFAULT NULL,

[481] Fix | Delete

`activitytype` varchar(200) NOT NULL,

[482] Fix | Delete

`date_start` date NOT NULL,

[483] Fix | Delete

`due_date` date DEFAULT NULL,

[484] Fix | Delete

`time_start` varchar(50) DEFAULT NULL,

[485] Fix | Delete

`time_end` varchar(50) DEFAULT NULL,

[486] Fix | Delete

`sendnotification` varchar(3) NOT NULL DEFAULT '0',

[487] Fix | Delete

`duration_hours` varchar(200) DEFAULT NULL,

[488] Fix | Delete

`duration_minutes` varchar(200) DEFAULT NULL,

[489] Fix | Delete

`status` varchar(200) DEFAULT NULL,

[490] Fix | Delete

`eventstatus` varchar(200) DEFAULT NULL,

[491] Fix | Delete

`priority` varchar(200) DEFAULT NULL,

[492] Fix | Delete

`location` varchar(150) DEFAULT NULL,

[493] Fix | Delete

`notime` varchar(3) NOT NULL DEFAULT '0',

[494] Fix | Delete

`visibility` varchar(50) NOT NULL DEFAULT 'all',

[495] Fix | Delete

`recurringtype` varchar(200) DEFAULT NULL,

[496] Fix | Delete

`tags` varchar(1) DEFAULT NULL,

[497] Fix | Delete

PRIMARY KEY (`activityid`),

[498] Fix | Delete

KEY `activity_activityid_subject_idx` (`activityid`,`subject`),

[499] Fix | Delete

12 3 4 5 6 ...42