--
-- Host: localhost    Database: rootcpanel_crmvtiger
-- ------------------------------------------------------


--
-- Table structure for table `com_vtiger_workflow_activatedonce`
--

CREATE TABLE `com_vtiger_workflow_activatedonce` (
  `workflow_id` int(11) NOT NULL,
  `entity_id` int(11) NOT NULL,
  PRIMARY KEY (`workflow_id`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflow_activatedonce`
--


--
-- Table structure for table `com_vtiger_workflow_tasktypes`
--

CREATE TABLE `com_vtiger_workflow_tasktypes` (
  `id` int(11) NOT NULL,
  `tasktypename` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `classname` varchar(255) DEFAULT NULL,
  `classpath` varchar(255) DEFAULT NULL,
  `templatepath` varchar(255) DEFAULT NULL,
  `modules` varchar(500) DEFAULT NULL,
  `sourcemodule` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflow_tasktypes`
--

INSERT INTO `com_vtiger_workflow_tasktypes` VALUES (1,'VTEmailTask','Send Mail','VTEmailTask','modules/com_vtiger_workflow/tasks/VTEmailTask.inc','modules/Settings/Workflows/Tasks/VTEmailTask.tpl','{\"include\":[],\"exclude\":[]}',''),(2,'VTEntityMethodTask','Invoke Custom Function','VTEntityMethodTask','modules/com_vtiger_workflow/tasks/VTEntityMethodTask.inc','modules/Settings/Workflows/Tasks/VTEntityMethodTask.tpl','{\"include\":[],\"exclude\":[]}',''),(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\"]}',''),(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\"]}',''),(5,'VTUpdateFieldsTask','Update Fields','VTUpdateFieldsTask','modules/com_vtiger_workflow/tasks/VTUpdateFieldsTask.inc','modules/Settings/Workflows/Tasks/VTUpdateFieldsTask.tpl','{\"include\":[],\"exclude\":[]}',''),(6,'VTCreateEntityTask','Create Entity','VTCreateEntityTask','modules/com_vtiger_workflow/tasks/VTCreateEntityTask.inc','modules/Settings/Workflows/Tasks/VTCreateEntityTask.tpl','{\"include\":[],\"exclude\":[]}',''),(7,'VTSMSTask','SMS Task','VTSMSTask','modules/com_vtiger_workflow/tasks/VTSMSTask.inc','modules/Settings/Workflows/Tasks/VTSMSTask.tpl','{\"include\":[],\"exclude\":[]}','SMSNotifier');

--
-- Table structure for table `com_vtiger_workflow_tasktypes_seq`
--

CREATE TABLE `com_vtiger_workflow_tasktypes_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflow_tasktypes_seq`
--

INSERT INTO `com_vtiger_workflow_tasktypes_seq` VALUES (7);

--
-- Table structure for table `com_vtiger_workflows`
--

CREATE TABLE `com_vtiger_workflows` (
  `workflow_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(100) DEFAULT NULL,
  `summary` varchar(400) NOT NULL,
  `test` text DEFAULT NULL,
  `execution_condition` int(11) NOT NULL,
  `defaultworkflow` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `filtersavedinnew` int(11) DEFAULT NULL,
  `schtypeid` int(11) DEFAULT NULL,
  `schdayofmonth` varchar(100) DEFAULT NULL,
  `schdayofweek` varchar(100) DEFAULT NULL,
  `schannualdates` varchar(100) DEFAULT NULL,
  `schtime` varchar(50) DEFAULT NULL,
  `nexttrigger_time` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `workflowname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`workflow_id`),
  UNIQUE KEY `com_vtiger_workflows_idx` (`workflow_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflows`
--

INSERT INTO `com_vtiger_workflows` VALUES (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'),(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'),(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'),(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'),(5,'Potentials','Send Email to users on Potential creation',NULL,1,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to users on Potential creation'),(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'),(7,'HelpDesk','Ticket Creation From Portal : Send Email to Record Owner and Contact','[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"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'),(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'),(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'),(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'),(12,'Potentials','Calculate or Update forecast amount','',3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Calculate or Update forecast amount'),(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'),(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'),(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'),(16,'PurchaseOrder','Update Inventory Products On Every Save',NULL,3,1,'basic',5,NULL,NULL,NULL,NULL,NULL,NULL,1,'Update Inventory Products On Every Save'),(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'),(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'),(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'),(20,'HelpDesk','Send Email to Record Owner on Ticket Update','[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":null,\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":null,\"groupid\":\"1\"},{\"fieldname\":\"assigned_user_id\",\"operation\":\"has changed\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":null,\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":null,\"groupid\":\"1\"},{\"fieldname\":\"cf_865\",\"operation\":\"has changed\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":null,\"groupid\":\"1\"},{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":null,\"groupid\":\"1\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Send Email to Record Owner on Ticket Update'),(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'),(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'),(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'),(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\"}]',3,1,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Ticket Creation From CRM : Send Email to Contact'),(27,'HelpDesk','Hours email to dispatch  =(Request \'cf_869\' \'cf_871\' - eMail \'cf_877\' \'cf_879\' ): Hours','[{\"fieldname\":\"cf_877\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_879\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_873\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_875\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,NULL,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Hours email to dispatch '),(28,'HelpDesk','Hours Request to Checkin = (Request \'cf_869\' \'cf_871\' - Checkin \'cf_859\' \'cf_861\' ): Hours','[{\"fieldname\":\"cf_869\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_871\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_859\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_861\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,NULL,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Hours Request to Checkin '),(29,'HelpDesk','Hours checkin to checkout   = (Check-in \'cf_859\' \'cf_861\' - Check out \'cf_863\' \'cf_865\' ): Hours','[{\"fieldname\":\"cf_859\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_861\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_863\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"cf_865\",\"operation\":\"is not empty\",\"value\":null,\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',3,NULL,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Hours checkin to checkout '),(30,'ModComments','','[{\"fieldname\":\"is_private\",\"operation\":\"equal to\",\"value\":\"1\",\"valuetype\":\"\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]',1,NULL,'basic',6,NULL,NULL,NULL,NULL,NULL,NULL,1,'Comments public -  is_private = 0');

--
-- Table structure for table `com_vtiger_workflows_seq`
--

CREATE TABLE `com_vtiger_workflows_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflows_seq`
--

INSERT INTO `com_vtiger_workflows_seq` VALUES (30);

--
-- Table structure for table `com_vtiger_workflowtask_queue`
--

CREATE TABLE `com_vtiger_workflowtask_queue` (
  `task_id` int(11) DEFAULT NULL,
  `entity_id` varchar(100) DEFAULT NULL,
  `do_after` int(11) DEFAULT NULL,
  `relatedinfo` varchar(255) DEFAULT NULL,
  `task_contents` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtask_queue`
--


--
-- Table structure for table `com_vtiger_workflowtasks`
--

CREATE TABLE `com_vtiger_workflowtasks` (
  `task_id` int(11) NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) DEFAULT NULL,
  `summary` varchar(400) NOT NULL,
  `task` text DEFAULT NULL,
  PRIMARY KEY (`task_id`),
  UNIQUE KEY `com_vtiger_workflowtasks_idx` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks`
--

INSERT INTO `com_vtiger_workflowtasks` VALUES (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;}'),(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<br>Details of account are :<br><br>AccountId:<b>$account_no</b><br>AccountName:<b>$accountname</b><br>Rating:<b>$rating</b><br>Industry:<b>$industry</b><br>AccountType:<b>$accounttype</b><br>Description:<b>$description</b><br><br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"2\";}'),(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<br>Details of Contact are :<br><br>Contact Id:<b>$contact_no</b><br>LastName:<b>$lastname</b><br>FirstName:<b>$firstname</b><br>Lead Source:<b>$leadsource</b><br>Department:<b>$department</b><br>Description:<b>$description</b><br><br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"3\";}'),(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;}'),(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<br>Details of Potential are :<br><br>Potential No:<b>$potential_no</b><br>Potential Name:<b>$potentialname</b><br>Amount:<b>$amount</b><br>Expected Close Date:<b>$closingdate ($_DATE_FORMAT_)</b><br>Type:<b>$opportunity_type</b><br><br><br>Description :$description<br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"5\";}'),(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<br>Details of Contact are :<br><br>Contact Id:<b>$contact_no</b><br>LastName:<b>$lastname</b><br>FirstName:<b>$firstname</b><br>Lead Source:<b>$leadsource</b><br>Department:<b>$department</b><br>Description:<b>$description</b><br><br><br>And <b>CustomerPortal Login Details</b> is sent to the EmailID :-$email<br><br>Thank You<br>Admin\";s:2:\"id\";s:1:\"6\";}'),(7,7,'Notify Related Contact when Ticket is created from Portal','O:11:\"VTEmailTask\":17:{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:87:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";N;s:7:\"content\";s:615:\"<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">You have created a new Ticket:&nbsp;$ticket_no in the Blue Technology Support Ticketing System<br />\r\nTicket No : $ticket_no<br />\r\nTicket ID : $(general : (__VtigerMeta__) recordId)<br />\r\nTicket Title : $ticket_title<br />\r\n<br />\r\n$description<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n\";s:7:\"trigger\";N;s:7:\"emailcc\";s:0:\"\";s:8:\"emailbcc\";s:0:\"\";s:3:\"pdf\";s:0:\"\";s:13:\"pdfTemplateId\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:7:\"replyTo\";s:0:\"\";s:19:\"field_value_mapping\";s:4:\"null\";}'),(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)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";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)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";s:10:\"workflowId\";s:1:\"9\";}'),(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;}'),(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) ,<br/><b>Activity Notification Details:</b><br/>Subject             : $subject<br/>Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))<br/>End date and time   : $due_date ($(general : (__VtigerMeta__) usertimezone)) <br/>Status              : $eventstatus <br/>Priority            : $taskpriority <br/>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) <br/>Contacts List       : $contact_id <br/>Location            : $location <br/>Description         : $description\";s:2:\"id\";s:2:\"14\";}'),(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) ,<br/><b>Task Notification Details:</b><br/>Subject : $subject<br/>Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))<br/>End date and time   : $due_date ($_DATE_FORMAT_) <br/>Status              : $taskstatus <br/>Priority            : $taskpriority <br/>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) <br/>Contacts List       : $contact_id <br/>Description         : $description\";s:2:\"id\";s:2:\"15\";}'),(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;}'),(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)&lt;$(contact_id : (Contacts) email)&gt;\";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),<br><br>\n								Customer has provided the following additional information to your reply:<br><br>\n								<b>$lastComment</b><br><br>\n								Kindly respond to above ticket at the earliest.<br><br>\n								Regards<br>Support Administrator\";}'),(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)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";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),<br><br>\n							The Ticket is replied the details are :<br><br>\n							Ticket No : $ticket_no<br>\n							Status : $ticketstatus<br>\n							Category : $ticketcategories<br>\n							Severity : $ticketseverities<br>\n							Priority : $ticketpriorities<br><br>\n							Description : <br>$description<br><br>\n							Solution : <br>$solution<br>\n							The comments are : <br>\n							$allComments<br><br>\n							Regards<br>Support Administrator\";}'),(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)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";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<br>\n										Ticket Id : $(general : (__VtigerMeta__) recordId)<br>\n										Subject : $ticket_title<br><br>\n										Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n										There is a reply to <b>$ticket_title</b> in the \"Customer Portal\" at VTiger.\n										You can use the following link to view the replies made:<br>\n										<a href=\"$(general : (__VtigerMeta__) portaldetailviewurl)\">Ticket Details</a><br><br>\n										Thanks<br>$(general : (__VtigerMeta__) supportName)\";}'),(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)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";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)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(parent_id : (Accounts) accountname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";}'),(23,7,'Notify Record Owner when Ticket is created from Portal','O:11:\"VTEmailTask\":17:{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:118:\"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:70:\",$(assigned_user_id : (Users) email1),$(contact_id : (Contacts) email)\";s:7:\"subject\";s:53:\"A new ticket has been created on the Customer Portal \";s:7:\"content\";s:471:\"<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">A ticket has been created on the Blue Technology Customer Portal.<br />\r\n<br />\r\nTicket No : $ticket_no<br />\r\nTicket ID : $(general : (__VtigerMeta__) recordId)<br />\r\nTicket Title : $ticket_title<br />\r\n<br />\r\n$description<br />\r\n<br />\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n\";s:7:\"trigger\";N;s:7:\"emailcc\";s:0:\"\";s:8:\"emailbcc\";s:0:\"\";s:3:\"pdf\";s:0:\"\";s:13:\"pdfTemplateId\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:7:\"replyTo\";s:0:\"\";s:19:\"field_value_mapping\";s:4:\"null\";}'),(24,20,'Send Email to Record Owner on Ticket Update','O:11:\"VTEmailTask\":17:{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:87:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:70:\"UPDATE Ticket Number : $ticket_no $ticket_title DYNAMIX Number $cf_855\";s:7:\"content\";s:1014:\"<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1030.0\">Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br />\r\n<br />\r\n<br />\r\nThere is an update to:<br />\r\n<br />\r\nTicket ID : $(general : (__VtigerMeta__) recordId)<br />\r\nTicket Title : $ticket_title<br />\r\n<br />\r\n<br />\r\nTicket No : $ticket_no<br />\r\nStatus : $ticketstatus<br />\r\nCategory : $ticketcategories<br />\r\nSeverity : $ticketseverities<br />\r\nPriority : $ticketpriorities<br />\r\n<br />\r\nDescription :<br />\r\n$description<br />\r\n<br />\r\nSolution :<br />\r\n$solution $allComments<br />\r\n<br />\r\n$(assigned_user_id : (Users) description)<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n\";s:7:\"trigger\";N;s:7:\"emailcc\";s:8:\",$cf_897\";s:8:\"emailbcc\";s:0:\"\";s:3:\"pdf\";s:0:\"\";s:13:\"pdfTemplateId\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:7:\"replyTo\";s:0:\"\";s:19:\"field_value_mapping\";s:4:\"null\";}'),(25,21,'Ticket Creation From CRM : Send Email to Record Owner','O:11:\"VTEmailTask\":17:{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:87:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:45:\",$(assigned_user_id : (Users) email1),$cf_897\";s:7:\"subject\";s:104:\"YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : $ticket_no $ticket_title DYNAMIX NUMBER $cf_855\";s:7:\"content\";s:973:\"<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : $(general : (__VtigerMeta__) recordId)<br />\r\nTicket Title : $ticket_title<br />\r\n<br />\r\nDear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br />\r\n<br />\r\nYou have been assigned to the following ticket:<br />\r\n<br />\r\nTicket No : $ticket_no<br />\r\nStatus : $ticketstatus<br />\r\nCategory : $ticketcategories<br />\r\nSeverity : $ticketseverities<br />\r\nPriority : $ticketpriorities<br />\r\n<br />\r\nDYNAMIX TICKET NUMBER:&nbsp;$cf_855<br />\r\n<br />\r\nDescription :<br />\r\n$description<br />\r\n<br />\r\n<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size:20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family:verdana,geneva,sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n\";s:7:\"trigger\";N;s:7:\"emailcc\";s:23:\"jc@mybluetechnology.com\";s:8:\"emailbcc\";s:0:\"\";s:3:\"pdf\";s:0:\"\";s:13:\"pdfTemplateId\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:7:\"replyTo\";s:0:\"\";s:19:\"field_value_mapping\";s:4:\"null\";}'),(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)&lt;$(general : (__VtigerMeta__) supportEmailId)&gt;\";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)<br>Ticket Title : $ticket_title<br><br>\n								Dear $(parent_id : (Accounts) accountname),<br><br>\n								The Ticket is replied the details are :<br><br>\n								Ticket No : $ticket_no<br>\n								Status : $ticketstatus<br>\n								Category : $ticketcategories<br>\n								Severity : $ticketseverities<br>\n								Priority : $ticketpriorities<br><br>\n								Description : <br>$description<br><br>\n								Solution : <br>$solution<br>\n								The comments are : <br>\n								$allComments<br><br>\n								Regards<br>Support Administrator\";s:10:\"workflowId\";s:2:\"22\";}'),(27,23,'Ticket Creation From CRM : Send Email to Organization','O:11:\"VTEmailTask\":17:{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:87:\"$(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:837:\"<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : $(general : (__VtigerMeta__) recordId)<br />\r\nTicket Title : $ticket_title<br />\r\n<br />\r\nDear $(parent_id : (Accounts) accountname),<br />\r\n<br />\r\nThe Ticket is replied the details are :<br />\r\n<br />\r\nTicket No : $ticket_no<br />\r\nStatus : $ticketstatus<br />\r\nCategory : $ticketcategories<br />\r\nSeverity : $ticketseverities<br />\r\nPriority : $ticketpriorities<br />\r\n<br />\r\nDescription :<br />\r\n$description<br />\r\n<br />\r\nSolution :<br />\r\n$solution<br />\r\nThe comments are :<br />\r\n$allComments<br />\r\n<br />\r\nRegards<br />\r\nBLUE TECHNIOLOGY TICKETING SYSTEM<br />\r\nSupport Administrator</body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n\";s:10:\"workflowId\";s:2:\"23\";s:7:\"trigger\";N;s:7:\"emailcc\";s:0:\"\";s:8:\"emailbcc\";s:0:\"\";s:3:\"pdf\";s:0:\"\";s:13:\"pdfTemplateId\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:7:\"replyTo\";s:0:\"\";s:19:\"field_value_mapping\";s:4:\"null\";}'),(28,24,'Ticket Creation From CRM : Send Email to Contact','O:11:\"VTEmailTask\":17:{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:87:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:90:\"NEW TICKET $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:983:\"<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\">Ticket ID : $(general : (__VtigerMeta__) recordId)<br />\r\nTicket Title : $ticket_title<br />\r\n<br />\r\nDear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br />\r\n<br />\r\nThe Ticket is replied the details are :<br />\r\n<br />\r\nTicket No : $ticket_no<br />\r\nStatus : $ticketstatus<br />\r\nCategory : $ticketcategories<br />\r\nSeverity : $ticketseverities<br />\r\nPriority : $ticketpriorities<br />\r\n<br />\r\nDescription :<br />\r\n$description<br />\r\n<br />\r\nSolution :<br />\r\n$solution<br />\r\nThe comments are :<br />\r\n$allComments<br />\r\n<br />\r\nRegards,<br />\r\n<span style=\"font-size: 20px;\"><strong>JC</strong></span><br />\r\n<span style=\"font-family: verdana, geneva, sans-serif;\">BLUE TECHNOLOGY<br />\r\nSupport Administrator</span><grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></body>\r\n</html>\r\n\";s:10:\"workflowId\";s:2:\"24\";s:7:\"trigger\";N;s:7:\"emailcc\";s:0:\"\";s:8:\"emailbcc\";s:0:\"\";s:3:\"pdf\";s:0:\"\";s:13:\"pdfTemplateId\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:7:\"replyTo\";s:0:\"\";s:19:\"field_value_mapping\";s:4:\"null\";}'),(31,27,'CalTimeHours','O:18:\"VTEntityMethodTask\":8:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"27\";s:7:\"summary\";s:12:\"CalTimeHours\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:32:\"Workflow Creantis - CalTimeHours\";s:19:\"field_value_mapping\";s:4:\"null\";s:2:\"id\";i:31;}'),(32,28,'CalTimeHoursCheckin','O:18:\"VTEntityMethodTask\":8:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"28\";s:7:\"summary\";s:19:\"CalTimeHoursCheckin\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:39:\"Workflow Creantis - CalTimeHoursCheckin\";s:19:\"field_value_mapping\";s:4:\"null\";s:2:\"id\";i:32;}'),(33,29,'CalTimeHoursCheckout','O:18:\"VTEntityMethodTask\":8:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";s:2:\"29\";s:7:\"summary\";s:20:\"CalTimeHoursCheckout\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:10:\"methodName\";s:40:\"Workflow Creantis - CalTimeHoursCheckout\";s:19:\"field_value_mapping\";s:4:\"null\";s:2:\"id\";i:33;}'),(34,30,'private = 0','O:18:\"VTUpdateFieldsTask\":8:{s:18:\"executeImmediately\";b:1;s:43:\"\0VTUpdateFieldsTask\0referenceFieldFocusList\";a:0:{}s:10:\"workflowId\";s:2:\"30\";s:7:\"summary\";s:11:\"private = 0\";s:6:\"active\";b:1;s:7:\"trigger\";N;s:19:\"field_value_mapping\";s:62:\"[{\"fieldname\":\"is_private\",\"value\":\"0\",\"valuetype\":\"rawtext\"}]\";s:2:\"id\";i:34;}');

--
-- Table structure for table `com_vtiger_workflowtasks_entitymethod`
--

CREATE TABLE `com_vtiger_workflowtasks_entitymethod` (
  `workflowtasks_entitymethod_id` int(11) NOT NULL,
  `module_name` varchar(100) DEFAULT NULL,
  `method_name` varchar(100) DEFAULT NULL,
  `function_path` varchar(400) DEFAULT NULL,
  `function_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`workflowtasks_entitymethod_id`),
  UNIQUE KEY `com_vtiger_workflowtasks_entitymethod_idx` (`workflowtasks_entitymethod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks_entitymethod`
--

INSERT INTO `com_vtiger_workflowtasks_entitymethod` VALUES (1,'SalesOrder','UpdateInventory','include/InventoryHandler.php','handleInventoryProductRel'),(2,'Invoice','UpdateInventory','include/InventoryHandler.php','handleInventoryProductRel'),(3,'Contacts','SendPortalLoginDetails','modules/Contacts/ContactsHandler.php','Contacts_sendCustomerPortalLoginDetails'),(4,'HelpDesk','NotifyOnPortalTicketCreation','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_nofifyOnPortalTicketCreation'),(5,'HelpDesk','NotifyOnPortalTicketComment','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_notifyOnPortalTicketComment'),(6,'HelpDesk','NotifyOwnerOnTicketChange','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_notifyOwnerOnTicketChange'),(7,'HelpDesk','NotifyParentOnTicketChange','modules/HelpDesk/HelpDeskHandler.php','HelpDesk_notifyParentOnTicketChange'),(8,'ModComments','CustomerCommentFromPortal','modules/ModComments/ModCommentsHandler.php','CustomerCommentFromPortal'),(9,'ModComments','TicketOwnerComments','modules/ModComments/ModCommentsHandler.php','TicketOwnerComments'),(10,'PurchaseOrder','UpdateInventory','include/InventoryHandler.php','handleInventoryProductRel'),(11,'HelpDesk','Workflow Creantis - CalTimeHours','workflows/HelpDesk/CalTimeHours.inc','CalTimeHours'),(12,'HelpDesk','Workflow Creantis - CalTimeHoursCheckin','workflows/HelpDesk/CalTimeHoursCheckin.inc','CalTimeHoursCheckin'),(13,'HelpDesk','Workflow Creantis - CalTimeHoursCheckout','workflows/HelpDesk/CalTimeHoursCheckout.inc','CalTimeHoursCheckout');

--
-- Table structure for table `com_vtiger_workflowtasks_entitymethod_seq`
--

CREATE TABLE `com_vtiger_workflowtasks_entitymethod_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks_entitymethod_seq`
--

INSERT INTO `com_vtiger_workflowtasks_entitymethod_seq` VALUES (13);

--
-- Table structure for table `com_vtiger_workflowtasks_seq`
--

CREATE TABLE `com_vtiger_workflowtasks_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtasks_seq`
--

INSERT INTO `com_vtiger_workflowtasks_seq` VALUES (34);

--
-- Table structure for table `com_vtiger_workflowtemplates`
--

CREATE TABLE `com_vtiger_workflowtemplates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(100) DEFAULT NULL,
  `title` varchar(400) DEFAULT NULL,
  `template` text DEFAULT NULL,
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `com_vtiger_workflowtemplates`
--


--
-- Table structure for table `log_fieldallmodule`
--

CREATE TABLE `log_fieldallmodule` (
  `id_log_field_all_module` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `tabla_bloque` varchar(255) NOT NULL,
  `uitype` text NOT NULL,
  `displaytype` text NOT NULL,
  `label_view` text NOT NULL,
  `columna_database` text NOT NULL,
  `columntype_database` text DEFAULT NULL,
  PRIMARY KEY (`id_log_field_all_module`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `log_fieldallmodule`
--

INSERT INTO `log_fieldallmodule` VALUES (1,'vtiger_troubletickets [LBL_TICKET_INFORMATION]','(1) TEXT - V~O','1','Portal-Organization-Name','cr_orgname_portaltext','TEXT');

--
-- Table structure for table `vtiger_account`
--

CREATE TABLE `vtiger_account` (
  `accountid` int(11) NOT NULL DEFAULT 0,
  `account_no` varchar(100) NOT NULL,
  `accountname` varchar(100) NOT NULL,
  `parentid` int(11) DEFAULT 0,
  `account_type` varchar(200) DEFAULT NULL,
  `industry` varchar(200) DEFAULT NULL,
  `annualrevenue` decimal(25,8) DEFAULT NULL,
  `rating` varchar(200) DEFAULT NULL,
  `ownership` varchar(50) DEFAULT NULL,
  `siccode` varchar(50) DEFAULT NULL,
  `tickersymbol` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `otherphone` varchar(30) DEFAULT NULL,
  `email1` varchar(100) DEFAULT NULL,
  `email2` varchar(100) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `fax` varchar(30) DEFAULT NULL,
  `employees` int(11) DEFAULT 0,
  `emailoptout` varchar(3) DEFAULT '0',
  `notify_owner` varchar(3) DEFAULT '0',
  `isconvertedfromlead` varchar(3) DEFAULT '0',
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`accountid`),
  KEY `account_account_type_idx` (`account_type`),
  KEY `email_idx` (`email1`,`email2`),
  CONSTRAINT `fk_1_vtiger_account` FOREIGN KEY (`accountid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_account`
--

INSERT INTO `vtiger_account` VALUES (2,'ACC000001','Back Of the House',0,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(3,'ACC000002','CBRD001-The Bird - New Montgomery',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(4,'ACC000003','CBRD002-The Bird Hayes-AWB',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(5,'ACC000004','CSD001-SD Castro (Mburger LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(6,'ACC000005','CSD002-SD FIDI (JBURGER LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(7,'ACC000006','CSD003-SD Chestnut  (Eburger LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(8,'ACC000007','CSD004-SD Mill Valley (Dburger LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(9,'ACC000008','CSD005-SD Metreon (Metburger LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(10,'ACC000009','CSD007-SD Embarcadero (Mission 98 Super LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(11,'ACC000010','CSD008-SD Novato (Super Novato LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(12,'ACC000011','CSD010-SD Los Gatos (Super Los Gatos)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(13,'ACC000012','CSD011-SD Concord - The Veranda Super LLC',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(14,'ACC000013','CSD012-SD Berkeley (2355 Telegraph LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(15,'ACC000014','CSD013-SD Westgate (5399 Prospect Road LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(16,'ACC000015','CSD014-SD Emeryville - SuperEmeryvilleLLC',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(17,'ACC000016','CSD019-SD Laurel Village (3401 California LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(18,'ACC000017','CSD020 - SD Serramonte - (Super Serramonte LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(19,'ACC000018','CSD021-SD Napa (Super Napa LLC)',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(20,'ACC000019','CUDT001-Unos Dos Tacos',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(21,'ACC000020','FAMA001-aMano SF',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(22,'ACC000021','FBER001-Beretta',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(23,'ACC000022','FBER002-Beretta Popup',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(24,'ACC000023','FDLA001-DeLaRosa Chestnut',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(25,'ACC000024','FDLA002-DeLaRosa-Yerba Buena',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(26,'ACC000025','FDLA003-DelaRosa San Ramon',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(27,'ACC000026','FFLR001-Flores Union',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(28,'ACC000027','FFLR002-Flores Corte Madera',0,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(29,'ACC000028','FLOL001-Lolinda',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(30,'ACC000029','FRDR001 - Rad Radish',0,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(31,'ACC000030','FSRB001-Starbelly',0,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(32,'ACC000031','FTAI001-Tailors Son',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(33,'ACC000032','FWLD001 - Wildseed Union',0,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(34,'ACC000033','FWLD002-Wildseed-PaloAlto',2,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(35,'ACC000034','Back of the House Inc. Headquarter',0,'','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(449,'ACC000035','FCOR001 Corzetti',2,'Customer','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0',''),(450,'ACC000036','FLOL001ET-El Techo',2,'Customer','',NULL,NULL,NULL,'',NULL,'','',NULL,NULL,'',NULL,0,'0','0','0','');

--
-- Table structure for table `vtiger_accountbillads`
--

CREATE TABLE `vtiger_accountbillads` (
  `accountaddressid` int(11) NOT NULL DEFAULT 0,
  `bill_city` varchar(30) DEFAULT NULL,
  `bill_code` varchar(30) DEFAULT NULL,
  `bill_country` varchar(30) DEFAULT NULL,
  `bill_state` varchar(30) DEFAULT NULL,
  `bill_street` varchar(250) DEFAULT NULL,
  `bill_pobox` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`accountaddressid`),
  CONSTRAINT `fk_1_vtiger_accountbillads` FOREIGN KEY (`accountaddressid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_accountbillads`
--

INSERT INTO `vtiger_accountbillads` VALUES (2,'','','','','',''),(3,'','','','','',''),(4,'','','','','',''),(5,'','','','','',''),(6,'','','','','',''),(7,'','','','','',''),(8,'','','','','',''),(9,'','','','','',''),(10,'','','','','',''),(11,'','','','','',''),(12,'','','','','',''),(13,'','','','','',''),(14,'','','','','',''),(15,'','','','','',''),(16,'','','','','',''),(17,'','','','','',''),(18,'','','','','',''),(19,'','','','','',''),(20,'','','','','',''),(21,'','','','','',''),(22,'','','','','',''),(23,'','','','','',''),(24,'','','','','',''),(25,'','','','','',''),(26,'','','','','',''),(27,'','','','','',''),(28,'','','','','',''),(29,'','','','','',''),(30,'','','','','',''),(31,'','','','','',''),(32,'','','','','',''),(33,'','','','','',''),(34,'','','','','',''),(35,'','','','','',''),(449,'','','','','386 Geary St, San Francisco, CA 94102',''),(450,'','','','','','');

--
-- Table structure for table `vtiger_accountrating`
--

CREATE TABLE `vtiger_accountrating` (
  `accountratingid` int(11) NOT NULL AUTO_INCREMENT,
  `rating` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`accountratingid`),
  UNIQUE KEY `accountrating_rating_idx` (`rating`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_accountrating`
--


--
-- Table structure for table `vtiger_accountscf`
--

CREATE TABLE `vtiger_accountscf` (
  `accountid` int(11) NOT NULL DEFAULT 0,
  `cf_857` varchar(50) DEFAULT '',
  `cf_899` varchar(1) DEFAULT '',
  PRIMARY KEY (`accountid`),
  CONSTRAINT `fk_1_vtiger_accountscf` FOREIGN KEY (`accountid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_accountscf`
--

INSERT INTO `vtiger_accountscf` VALUES (2,'',''),(3,'',''),(4,'',''),(5,'',''),(6,'',''),(7,'',''),(8,'',''),(9,'',''),(10,'',''),(11,'',''),(12,'',''),(13,'',''),(14,'',''),(15,'',''),(16,'',''),(17,'',''),(18,'',''),(19,'',''),(20,'',''),(21,'',''),(22,'',''),(23,'',''),(24,'',''),(25,'',''),(26,'',''),(27,'',''),(28,'',''),(29,'',''),(30,'',''),(31,'',''),(32,'',''),(33,'',''),(34,'',''),(35,'',''),(449,'',''),(450,'','');

--
-- Table structure for table `vtiger_accountshipads`
--

CREATE TABLE `vtiger_accountshipads` (
  `accountaddressid` int(11) NOT NULL DEFAULT 0,
  `ship_city` varchar(30) DEFAULT NULL,
  `ship_code` varchar(30) DEFAULT NULL,
  `ship_country` varchar(30) DEFAULT NULL,
  `ship_state` varchar(30) DEFAULT NULL,
  `ship_pobox` varchar(30) DEFAULT NULL,
  `ship_street` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`accountaddressid`),
  CONSTRAINT `fk_1_vtiger_accountshipads` FOREIGN KEY (`accountaddressid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_accountshipads`
--

INSERT INTO `vtiger_accountshipads` VALUES (2,'','','','','',''),(3,'','','','','',''),(4,'','','','','',''),(5,'','','','','',''),(6,'','','','','',''),(7,'','','','','',''),(8,'','','','','',''),(9,'','','','','',''),(10,'','','','','',''),(11,'','','','','',''),(12,'','','','','',''),(13,'','','','','',''),(14,'','','','','',''),(15,'','','','','',''),(16,'','','','','',''),(17,'','','','','',''),(18,'','','','','',''),(19,'','','','','',''),(20,'','','','','',''),(21,'','','','','',''),(22,'','','','','',''),(23,'','','','','',''),(24,'','','','','',''),(25,'','','','','',''),(26,'','','','','',''),(27,'','','','','',''),(28,'','','','','',''),(29,'','','','','',''),(30,'','','','','',''),(31,'','','','','',''),(32,'','','','','',''),(33,'','','','','',''),(34,'','','','','',''),(35,'','','','','',''),(449,'','','','','','386 Geary St, San Francisco, CA 94102'),(450,'','','','','','');

--
-- Table structure for table `vtiger_accounttype`
--

CREATE TABLE `vtiger_accounttype` (
  `accounttypeid` int(11) NOT NULL AUTO_INCREMENT,
  `accounttype` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`accounttypeid`),
  UNIQUE KEY `accounttype_accounttype_idx` (`accounttype`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_accounttype`
--

INSERT INTO `vtiger_accounttype` VALUES (2,'Analyst',1,2,1,NULL),(3,'Competitor',1,3,2,NULL),(4,'Customer',1,4,3,NULL),(5,'Integrator',1,5,4,NULL),(6,'Investor',1,6,5,NULL),(7,'Partner',1,7,6,NULL),(8,'Press',1,8,7,NULL),(9,'Prospect',1,9,8,NULL),(10,'Reseller',1,10,9,NULL),(11,'Other',1,11,10,NULL);

--
-- Table structure for table `vtiger_accounttype_seq`
--

CREATE TABLE `vtiger_accounttype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_accounttype_seq`
--

INSERT INTO `vtiger_accounttype_seq` VALUES (11);

--
-- Table structure for table `vtiger_actionmapping`
--

CREATE TABLE `vtiger_actionmapping` (
  `actionid` int(11) NOT NULL,
  `actionname` varchar(200) NOT NULL,
  `securitycheck` int(11) DEFAULT NULL,
  PRIMARY KEY (`actionid`,`actionname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_actionmapping`
--

INSERT INTO `vtiger_actionmapping` VALUES (0,'Save',0),(0,'SavePriceBook',1),(0,'SaveVendor',1),(1,'DetailViewAjax',1),(1,'EditView',0),(1,'PriceBookEditView',1),(1,'QuickCreate',1),(1,'VendorEditView',1),(2,'Delete',0),(2,'DeletePriceBook',1),(2,'DeleteVendor',1),(3,'index',0),(3,'Popup',1),(4,'DetailView',0),(4,'PriceBookDetailView',1),(4,'TagCloud',1),(4,'VendorDetailView',1),(5,'Import',0),(6,'Export',0),(7,'CreateView',0),(8,'Merge',0),(9,'ConvertLead',0),(10,'DuplicatesHandling',0),(13,'Print',0);

--
-- Table structure for table `vtiger_activity`
--

CREATE TABLE `vtiger_activity` (
  `activityid` int(11) NOT NULL DEFAULT 0,
  `subject` varchar(255) DEFAULT NULL,
  `semodule` varchar(20) DEFAULT NULL,
  `activitytype` varchar(200) NOT NULL,
  `date_start` date NOT NULL,
  `due_date` date DEFAULT NULL,
  `time_start` varchar(50) DEFAULT NULL,
  `time_end` varchar(50) DEFAULT NULL,
  `sendnotification` varchar(3) NOT NULL DEFAULT '0',
  `duration_hours` varchar(200) DEFAULT NULL,
  `duration_minutes` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `eventstatus` varchar(200) DEFAULT NULL,
  `priority` varchar(200) DEFAULT NULL,
  `location` varchar(150) DEFAULT NULL,
  `notime` varchar(3) NOT NULL DEFAULT '0',
  `visibility` varchar(50) NOT NULL DEFAULT 'all',
  `recurringtype` varchar(200) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`activityid`),
  KEY `activity_activityid_subject_idx` (`activityid`,`subject`),
  KEY `activity_activitytype_date_start_idx` (`activitytype`,`date_start`),
  KEY `activity_date_start_due_date_idx` (`date_start`,`due_date`),
  KEY `activity_date_start_time_start_idx` (`date_start`,`time_start`),
  KEY `activity_eventstatus_idx` (`eventstatus`),
  KEY `activity_status_idx` (`status`),
  CONSTRAINT `fk_1_vtiger_activity` FOREIGN KEY (`activityid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activity`
--

INSERT INTO `vtiger_activity` VALUES (37,'test','','Emails','2023-02-16',NULL,'21:33',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(44,'Test 2','','Emails','2023-02-16',NULL,'22:29',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(45,'VtigerCRM Support Notification','','Emails','2023-02-16',NULL,'22:30',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(52,'prueba de envio de correo de Creantis','','Emails','2023-03-01',NULL,'23:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(54,'Customer Portal Login Details','','Emails','2023-03-16',NULL,'22:36',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(55,'Ticket Number : TKT000001 Internet connection','','Emails','2023-03-20',NULL,'21:50:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(56,'Ticket Number : TKT000002 Test Call','','Emails','2023-03-20',NULL,'21:50:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(57,'Ticket Number : TKT000003 test 2','','Emails','2023-03-20',NULL,'21:50:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(58,'Ticket Number : TKT000003 test 2','','Emails','2023-03-20',NULL,'21:50:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(59,'Ticket Number : TKT000004 prueba creantis','','Emails','2023-03-20',NULL,'21:50:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(60,'Regarding Contact Assignment','','Emails','2023-03-20',NULL,'21:50:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(61,'Customer Portal Login Details','','Emails','2023-03-21',NULL,'14:51',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(62,'testing','','Emails','2023-03-21',NULL,'15:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(63,'test 2','','Emails','2023-03-21',NULL,'15:18',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(64,'Customer Portal Login Details','','Emails','2023-03-21',NULL,'23:49',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(65,'test2','','Emails','2023-03-21',NULL,'23:53',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(69,'Regarding Contact Assignment','','Emails','2023-03-22',NULL,'00:21:22',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(133,'Ticket Number : TKT000005 SD Serramonte SDWAN equipment pickup','','Emails','2023-04-15',NULL,'03:02:11',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(134,'Ticket Number : TKT000006 Troubleshoot Dayforce Offline-El Techo','','Emails','2023-04-15',NULL,'03:02:20',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(135,'Ticket Number : TKT000007 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:02:31',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(136,'Ticket Number : TKT000008 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:02:40',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(137,'Ticket Number : TKT000009 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:02:51',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(138,'Ticket Number : TKT000010 omcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:02:56',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(139,'Ticket Number : TKT000011 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:03:05',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(140,'Ticket Number : TKT000012 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:03:15',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(141,'Ticket Number : TKT000013 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:03:25',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(142,'Ticket Number : TKT000014 omcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:03:35',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(143,'Ticket Number : TKT000014 omcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:03:45',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(144,'Ticket Number : TKT000015 Comcast Enterprise Services Planned Maintenance Notification - CM004269753','','Emails','2023-04-15',NULL,'03:03:55',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(145,'Ticket Number : TKT000016 Internet Disruption at A Mano','','Emails','2023-04-15',NULL,'03:04:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(146,'Ticket Number : TKT000017 After Work Bar / Montaje seguro para televisores de barra','','Emails','2023-04-15',NULL,'03:04:11',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(147,'Ticket Number : TKT000018 Super Duper-Castro / Toast Tap Installation','','Emails','2023-04-15',NULL,'03:04:21',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(148,'Ticket Number : TKT000019 Cash Drawer Tech Install','','Emails','2023-04-15',NULL,'03:04:26',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(149,'Ticket Number : TKT000020 Super Duper-Castro / Toast Tap Installation','','Emails','2023-04-15',NULL,'03:04:36',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(150,'Ticket Number : TKT000021 Super Duper-Castro / Toast Tap Installation / Tech No Show','','Emails','2023-04-15',NULL,'03:04:43',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(151,'Ticket Number : TKT000022 107721 / Super Duper - Emeryville / Toast Tap Replacement','','Emails','2023-04-15',NULL,'03:04:49',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(152,'Ticket Number : TKT000023 Super Duper Castro / PG&E Electrical service interruption.','','Emails','2023-04-15',NULL,'03:04:51',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(153,'Ticket Number : TKT000024 108064 / Flores Union / Printer Routing Issue','','Emails','2023-04-15',NULL,'03:05:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(154,'Ticket Number : TKT000025 Super Duper Castro / PG&E Electrical service interruption.','','Emails','2023-04-15',NULL,'03:05:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(155,'Ticket Number : TKT000026 107721 / Super Duper - Emeryville / Toast Tap Replacement','','Emails','2023-04-15',NULL,'03:05:22',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(156,'Ticket Number : TKT000027 Super Duper Castro / PG&E Electrical service interruption.','','Emails','2023-04-15',NULL,'03:05:32',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(157,'Ticket Number : TKT000028 108232 / After Work Bar / To troubleshoot the Cash Drawer and Printer','','Emails','2023-04-15',NULL,'03:05:37',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(158,'Ticket Number : TKT000029 108059 / Super Duper - Castro / Schedule Power Interruption','','Emails','2023-04-15',NULL,'03:05:47',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(159,'Ticket Number : TKT000030 The Tailor\'s Son / Onboarding of Handhelds','','Emails','2023-04-15',NULL,'03:05:48',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(160,'Ticket Number : TKT000031 DVR/Camera Setup','','Emails','2023-04-15',NULL,'03:05:57',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(161,'Ticket Number : TKT000032 Super Duper - Castro / Scheduled Power Interruption','','Emails','2023-04-15',NULL,'03:06:07',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(162,'Ticket Number : TKT000033 Field Tech Visit Request','','Emails','2023-04-15',NULL,'03:06:17',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(163,'Ticket Number : TKT000034 00108672 / Delarosa Yerba Buena / Printer issue','','Emails','2023-04-15',NULL,'03:06:23',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(164,'Ticket Number : TKT000035 108772 - aMano network rack','','Emails','2023-04-15',NULL,'03:06:33',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(165,'Ticket Number : TKT000036 Troubleshoot KDS 2 (kept on rebooting)','','Emails','2023-04-15',NULL,'03:06:44',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(166,'Ticket Number : TKT000037 108772 - aMano network rack','','Emails','2023-04-15',NULL,'03:06:54',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(167,'Ticket Number : TKT000038 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music','','Emails','2023-04-15',NULL,'03:07:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(168,'Ticket Number : TKT000039 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music','','Emails','2023-04-15',NULL,'03:07:05',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(169,'Ticket Number : TKT000040 108772 - aMano network rack','','Emails','2023-04-15',NULL,'03:07:07',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(170,'Ticket Number : TKT000041 SD Downtown - Printer offline/Device Irregularities','','Emails','2023-04-15',NULL,'03:07:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(171,'Ticket Number : TKT000042 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music','','Emails','2023-04-15',NULL,'03:07:25',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(172,'Ticket Number : TKT000043 108410 / Super Duper Los Gatos / installation of replacement KDS','','Emails','2023-04-15',NULL,'03:07:35',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(173,'Ticket Number : TKT000044 Beretta - Pop Up / Troubleshoot wireless phone','','Emails','2023-04-15',NULL,'03:07:46',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(174,'Ticket Number : TKT000045 Uno Dos Tacos / Connect Yealink Receiver to network','','Emails','2023-04-15',NULL,'03:07:52',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(175,'Ticket Number : TKT000045 Uno Dos Tacos / Connect Yealink Receiver to network','','Emails','2023-04-15',NULL,'03:08:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(176,'Ticket Number : TKT000046 Field Tech Request - NAPA','','Emails','2023-04-15',NULL,'03:08:11',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(177,'Ticket Number : TKT000047 108892 / SD Castro / Cash Drawer not opening automatically','','Emails','2023-04-15',NULL,'03:08:22',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(178,'Ticket Number : TKT000048 Super Duper - Berkeley / Resolve camera 2','','Emails','2023-04-15',NULL,'03:08:32',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(179,'Ticket Number : TKT000049 Flores Corte Madera / Cameras are offline','','Emails','2023-04-15',NULL,'03:08:38',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(180,'Ticket Number : TKT000050 Super Duper - Emeryville /  Phone Setup','','Emails','2023-04-15',NULL,'03:08:42',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(181,'Ticket Number : TKT000051 Installation of replacement KDS at SD Novato','','Emails','2023-04-15',NULL,'03:08:47',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(182,'Ticket Number : TKT000052 Tech Request: Damage outside cable TV / After work Bar','','Emails','2023-04-15',NULL,'03:08:58',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(183,'Ticket Number : TKT000053 nstallation of replacement KDS at SD Novato','','Emails','2023-04-15',NULL,'03:09:07',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(184,'Ticket Number : TKT000054 SD Downtown Replacement Kitchen Printer Onboarding','','Emails','2023-04-15',NULL,'03:09:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(185,'Ticket Number : TKT000055 SD Downtown Replacement Kitchen Printer Onboarding','','Emails','2023-04-15',NULL,'03:09:16',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(186,'Ticket Number : TKT000056 Uno Dos Tacos / Phone installation and activation','','Emails','2023-04-15',NULL,'03:09:27',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(187,'Ticket Number : TKT000057 Request Tech Visit LRS Pager','','Emails','2023-04-15',NULL,'03:09:29',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(188,'Ticket Number : TKT000058 Tech Request at SD Serramonte SDWAN equipment pickup','','Emails','2023-04-15',NULL,'03:09:31',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(189,'Ticket Number : TKT000059 The Tailor\'s Son / Outdoor speaker issue','','Emails','2023-04-15',NULL,'03:09:43',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(190,'Ticket Number : TKT000060 Hello Blue Technology,   We would like to request a technician for the location below: Address: 2516 Mission St- El Techo and Lolinda Date:  ASAP, If possible today April 5 Time: 9PM PST  Access to Store:  C/o Staff  Dynamix Ref ','','Emails','2023-04-15',NULL,'03:09:54',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(191,'Ticket Number : TKT000061 Troubleshoot Dayforce Offline-El Techo','','Emails','2023-04-15',NULL,'03:10:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(192,'Ticket Number : TKT000061 Troubleshoot Dayforce Offline-El Techo','','Emails','2023-04-15',NULL,'03:10:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(193,'Ticket Number : TKT000061 Troubleshoot Dayforce Offline-El Techo','','Emails','2023-04-15',NULL,'03:10:23',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(194,'Regarding Contact Assignment','','Emails','2023-04-15',NULL,'03:10:29',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(195,'Customer Portal Login Details','','Emails','2023-04-15',NULL,'03:40',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(197,'Regarding Contact Assignment','','Emails','2023-04-17',NULL,'20:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(199,'Regarding Contact Assignment','','Emails','2023-04-17',NULL,'22:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(201,'[From Portal] TKT000062 [ Ticket Id : 200 ] pepe estoy en test','','Emails','2023-04-18',NULL,'19:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(202,'[From Portal] TKT000062 [ Ticket Id : 200 ] pepe estoy en test','','Emails','2023-04-18',NULL,'19:15:10',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(203,'Regarding Contact Assignment','','Emails','2023-04-18',NULL,'19:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(204,'TKT000062 [ Ticket Id : 200 ] pepe estoy en test','','Emails','2023-04-19',NULL,'01:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(205,'TKT000062 [ Ticket Id : 200 ] pepe estoy en test','','Emails','2023-04-19',NULL,'01:00:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(206,'TKT000062 [ Ticket Id : 200 ] pepe estoy en test','','Emails','2023-04-19',NULL,'01:00:19',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(208,'Regarding Contact Assignment','','Emails','2023-04-19',NULL,'16:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(209,'Regarding Contact Assignment','','Emails','2023-04-19',NULL,'16:30:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(210,'Regarding Contact Assignment','','Emails','2023-04-19',NULL,'16:30:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(211,'Regarding Contact Assignment','','Emails','2023-04-19',NULL,'16:30:24',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(212,'Ticket Number : TKT000061 Troubleshoot Dayforce Offline-El Techo','','Emails','2023-04-20',NULL,'05:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(213,'Ticket Number : TKT000057 Request Tech Visit LRS Pager','','Emails','2023-04-20',NULL,'18:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(214,'Ticket Number : TKT000058 Tech Request at SD Serramonte SDWAN equipment pickup','','Emails','2023-04-20',NULL,'18:30:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(215,'Ticket Number : TKT000060 Hello Blue Technology,   We would like to request a technician for the location below: Address: 2516 Mission St- El Techo and Lolinda Date:  ASAP, If possible today April 5 Time: 9PM PST  Access to Store:  C/o Staff  Dynamix Ref ','','Emails','2023-04-20',NULL,'19:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(216,'Ticket Number : TKT000060 Hello Blue Technology,   We would like to request a technician for the location below: Address: 2516 Mission St- El Techo and Lolinda Date:  ASAP, If possible today April 5 Time: 9PM PST  Access to Store:  C/o Staff  Dynamix Ref ','','Emails','2023-04-20',NULL,'19:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(217,'Ticket Number : TKT000058 Tech Request at SD Serramonte SDWAN equipment pickup','','Emails','2023-04-20',NULL,'20:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(219,'Ticket Number : TKT000063 Troubleshoot Dayforce Offline at The Tailor\'s Son','','Emails','2023-04-20',NULL,'20:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(221,'Ticket Number : TKT000064 Wireless','','Emails','2023-04-20',NULL,'21:00:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(224,'Ticket Number : TKT000065 BRD Day Force Clock In Error','','Emails','2023-04-20',NULL,'21:15:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(225,'Ticket Number : TKT000066 Dayforce Tablet Offline','','Emails','2023-04-20',NULL,'21:15:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(226,'Ticket Number : TKT000065 BRD Day Force Clock In Error','','Emails','2023-04-20',NULL,'21:15:24',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(229,'Ticket Number : TKT000067 Dayforce Tablet','','Emails','2023-04-20',NULL,'21:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(230,'Ticket Number : TKT000068 Run a test why expo printer didnt work on offline mode','','Emails','2023-04-20',NULL,'21:30:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(235,'Ticket Number : TKT000069 Clock-In Devise at SD-Downtown','','Emails','2023-04-20',NULL,'21:45:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(236,'Ticket Number : TKT000070 Dayforce clock','','Emails','2023-04-20',NULL,'21:45:08',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(237,'Ticket Number : TKT000071 Napa SD - DayForce Tablet Issues','','Emails','2023-04-20',NULL,'21:45:16',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(238,'Ticket Number : TKT000072 Troubleshoot Dayforce Offline at SD Castro','','Emails','2023-04-20',NULL,'21:45:23',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(239,'Ticket Number : TKT000067 Dayforce Tablet','','Emails','2023-04-20',NULL,'21:45:32',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(240,'Ticket Number : TKT000069 Clock-In Devise at SD-Downtown','','Emails','2023-04-20',NULL,'21:45:42',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(241,'Ticket Number : TKT000070 Dayforce clock','','Emails','2023-04-20',NULL,'21:45:51',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(242,'Ticket Number : TKT000068 Run a test why expo printer didnt work on offline mode','','Emails','2023-04-20',NULL,'21:46:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(243,'Ticket Number : TKT000072 Troubleshoot Dayforce Offline at SD Castro','','Emails','2023-04-20',NULL,'22:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(246,'Ticket Number : TKT000073 Printer Red Light On','','Emails','2023-04-20',NULL,'22:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(247,'Ticket Number : TKT000074 Reconnect Dayforce Touchclocks Wirelessly to BOHTC / 98 Mission Street','','Emails','2023-04-20',NULL,'22:15:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(249,'Ticket Number : TKT000075 Super Duper Laurel Village / Reconnect Dayforce Touchclock to the Network','','Emails','2023-04-20',NULL,'22:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(251,'Ticket Number : TKT000076 Super Duper Laurel Village / Reconnect Dayforce Touchclock to the Network','','Emails','2023-04-20',NULL,'22:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(254,'Ticket Number : TKT000077 110064 / Super Duper - Novato / KDS offline, KDS displays wrong time','','Emails','2023-04-21',NULL,'00:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(255,'Ticket Number : TKT000078 Investigate the Beeping sounds','','Emails','2023-04-21',NULL,'00:45:08',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(258,'Ticket Number : TKT000077 110064 / Super Duper - Novato / KDS offline, KDS displays wrong time','','Emails','2023-04-21',NULL,'01:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(259,'Ticket Number : TKT000078 Investigate the Beeping sounds','','Emails','2023-04-21',NULL,'01:00:15',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(260,'Ticket Number : TKT000079 110152 / Wildseed Palo Alto / Investigate Grill printer not printing / FWLD002-KP-GRILL','','Emails','2023-04-21',NULL,'01:00:24',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(261,'Ticket Number : TKT000080 Investigate Terminal Printer and Back-up printer not working- Receipts rerouted to Kiosk Printer','','Emails','2023-04-21',NULL,'01:00:34',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(262,'Ticket Number : TKT000080 Investigate Terminal Printer and Back-up printer not working- Receipts rerouted to Kiosk Printer','','Emails','2023-04-21',NULL,'01:00:44',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(264,'Ticket Number : TKT000081 The Bird Hayes / Reset AV Matrix','','Emails','2023-04-21',NULL,'01:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(265,'Ticket Number : TKT000081 The Bird Hayes / Reset AV Matrix','','Emails','2023-04-21',NULL,'01:15:11',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(268,'Ticket Number : TKT000082 Super Duper -Los Gatos / Intermittent Internet Connection','','Emails','2023-04-21',NULL,'01:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(269,'Ticket Number : TKT000082 Super Duper -Los Gatos / Intermittent Internet Connection','','Emails','2023-04-21',NULL,'01:45:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(270,'Ticket Number : TKT000083 Field Tech Request Urgent','','Emails','2023-04-21',NULL,'01:45:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(273,'Ticket Number : TKT000084 BT Tech Request','','Emails','2023-04-21',NULL,'02:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(274,'Ticket Number : TKT000085 Wildseed Palo Alto / Printer Replacement','','Emails','2023-04-21',NULL,'02:00:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(276,'Ticket Number : TKT000086 nstallation of Toast Flex Counter, Receipt Printer and Direct attached Toast Tap','','Emails','2023-04-21',NULL,'20:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(278,'Ticket Number : TKT000087 The Tailor\'s Son / Cash Drawer replacement','','Emails','2023-04-21',NULL,'20:45:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(279,'Ticket Number : TKT000017 After Work Bar / Montaje seguro para televisores de barra','','Emails','2023-04-21',NULL,'20:45:10',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(280,'Ticket Number : TKT000021 Super Duper-Castro / Toast Tap Installation / Tech No Show','','Emails','2023-04-21',NULL,'21:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(281,'Ticket Number : TKT000017 After Work Bar / Montaje seguro para televisores de barra','','Emails','2023-04-21',NULL,'21:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(282,'Ticket Number : TKT000026 107721 / Super Duper - Emeryville / Toast Tap Replacement','','Emails','2023-04-21',NULL,'21:15:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(283,'Ticket Number : TKT000023 Super Duper Castro / PG&E Electrical service interruption.','','Emails','2023-04-21',NULL,'21:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(284,'Ticket Number : TKT000024 108064 / Flores Union / Printer Routing Issue','','Emails','2023-04-21',NULL,'21:30:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(286,'Ticket Number : TKT000088 Request for BT Tech Dispatch at SD Laurel Village','','Emails','2023-04-21',NULL,'22:15:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(288,'[From Portal] TKT000089 [ Ticket Id : 287 ] testing data en dev','','Emails','2023-04-28',NULL,'20:45:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(289,'[From Portal] TKT000089 [ Ticket Id : 287 ] testing data en dev','','Emails','2023-04-28',NULL,'20:45:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(291,'[From Portal] TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-04',NULL,'23:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(292,'[From Portal] TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-04',NULL,'23:15:08',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(294,'Ticket Number : TKT000091 Super Duper - NAPA network h','','Emails','2023-05-08',NULL,'18:00:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(296,'Ticket Number : TKT000092 nvestigate why kitchen printers wouldn\'t print','','Emails','2023-05-08',NULL,'21:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(297,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:15:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(298,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:15:11',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(299,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:15:21',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(300,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:15:31',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(301,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:15:42',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(302,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:15:54',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(303,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(304,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:30:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(305,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:30:23',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(306,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:30:34',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(307,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:30:38',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(308,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:30:49',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(309,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:45:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(310,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:45:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(311,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:45:19',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(312,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'01:45:29',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(314,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-09',NULL,'02:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(315,'Ticket Number : TKT000093 tEST 10','','Emails','2023-05-09',NULL,'02:45:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(316,'Ticket Number : TKT000046 Field Tech Request - NAPA','','Emails','2023-05-09',NULL,'03:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(317,'Ticket Number : TKT000046 Field Tech Request - NAPA','','Emails','2023-05-09',NULL,'03:00:10',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(318,'Ticket Number : TKT000060 Hello Blue Technology,   We would like to request a technician for the location below: Address: 2516 Mission St- El Techo and Lolinda Date:  ASAP, If possible today April 5 Time: 9PM PST  Access to Store:  C/o Staff  Dynamix Ref ','','Emails','2023-05-09',NULL,'05:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(319,'Ticket Number : TKT000058 Tech Request at SD Serramonte SDWAN equipment pickup','','Emails','2023-05-09',NULL,'05:00:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(320,'Ticket Number : TKT000092 Investigate why kitchen printers wouldn\'t print','','Emails','2023-05-09',NULL,'22:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(321,'test','','Emails','2023-05-10',NULL,'14:39',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(322,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'15:00:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(323,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'15:00:05',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(324,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'17:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(325,'Ticket Number : TKT000090 TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'17:30:08',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(326,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'17:30:18',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(327,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'17:30:28',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(328,'Ticket Number : TKT000090 TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'17:30:38',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(329,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'17:30:48',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(330,'Regarding Contact Assignment','','Emails','2023-05-10',NULL,'18:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(331,'Regarding Contact Assignment','','Emails','2023-05-10',NULL,'18:00:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(332,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(333,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:15',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(334,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:17',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(335,'Ticket Number : TKT000090 TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:18',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(336,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:30',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(337,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:39',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(338,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:49',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(339,'Ticket Number : TKT000090 TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:00:54',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(340,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:01:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(341,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:01:15',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(342,'Ticket Number : TKT000090 TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:01:21',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(343,'TKT000090 [ Ticket Id : 290 ] TESTING 7.5 Insert','','Emails','2023-05-10',NULL,'18:01:23',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(345,'[From Portal] TKT000094 [ Ticket Id : 344 ] Creantis','','Emails','2023-05-10',NULL,'18:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(346,'[From Portal] TKT000094 [ Ticket Id : 344 ] Creantis','','Emails','2023-05-10',NULL,'18:15:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(349,'Ticket Number : TKT000091 Super Duper - NAPA network h','','Emails','2023-05-10',NULL,'18:45:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(350,'Ticket Number : TKT000091 Super Duper - NAPA network h','','Emails','2023-05-10',NULL,'18:45:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(351,'Ticket Number : TKT000042 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music','','Emails','2023-05-10',NULL,'19:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(352,'Ticket Number : TKT000048 Super Duper - Berkeley / Resolve camera 2','','Emails','2023-05-10',NULL,'19:00:10',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(353,'Ticket Number : TKT000085 Wildseed Palo Alto / Printer Replacement','','Emails','2023-05-10',NULL,'19:00:17',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(354,'Ticket Number : TKT000040 108772 - aMano network rack','','Emails','2023-05-10',NULL,'19:00:25',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(355,'Ticket Number : TKT000051 Installation of replacement KDS at SD Novato','','Emails','2023-05-10',NULL,'19:00:35',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(356,'Ticket Number : TKT000071 Napa SD - DayForce Tablet Issues','','Emails','2023-05-10',NULL,'19:00:46',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(357,'Ticket Number : TKT000088 Request for BT Tech Dispatch at SD Laurel Village','','Emails','2023-05-10',NULL,'19:00:55',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(358,'Ticket Number : TKT000049 Flores Corte Madera / Cameras are offline','','Emails','2023-05-10',NULL,'19:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(360,'Ticket Number : TKT000095 Tech Visit at Dela Rosa Yerba Buena /  Connect Newly Opened Ports to Patch Panel','','Emails','2023-05-10',NULL,'22:00:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(366,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000096 Network Monitoring - Service Downtime DYNAMIX NUMBER 110647','','Emails','2023-05-11',NULL,'02:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(369,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX NUMBER 110406','','Emails','2023-05-11',NULL,'02:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(370,'UPDATE Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX Number 110406','','Emails','2023-05-11',NULL,'02:15:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(372,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX NUMBER 110291','','Emails','2023-05-11',NULL,'02:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(379,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000099 Tech Visit Beretta /UPS Replacement DYNAMIX NUMBER 110134','','Emails','2023-05-11',NULL,'02:45:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(384,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000100 110355/Lolinda/Installation of 2 Handhelds DYNAMIX NUMBER 110355','','Emails','2023-05-11',NULL,'03:00:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(386,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000101 RE: 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX NUMBER 11450','','Emails','2023-05-11',NULL,'03:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(388,'UPDATE Ticket Number : TKT000085 Wildseed Palo Alto / Printer Replacement DYNAMIX Number 110291','','Emails','2023-05-11',NULL,'07:15:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(389,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000102 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX NUMBER 110450','','Emails','2023-05-11',NULL,'07:15:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(390,'UPDATE Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX Number 110388','','Emails','2023-05-11',NULL,'07:30:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(392,'UPDATE Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX Number 110388','','Emails','2023-05-11',NULL,'07:45:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(393,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000103 110352 / Afterwork bar / Reconnect Television to Matrix DYNAMIX NUMBER 110352','','Emails','2023-05-11',NULL,'07:45:11',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(395,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000104 Request Tech Visit Switch Installation at SD Concord DYNAMIX NUMBER 999999','','Emails','2023-05-11',NULL,'08:00:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(397,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000105 Super Duper - Novato/Installation of KDS DYNAMIX NUMBER 110353','','Emails','2023-05-11',NULL,'08:15:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(398,'UPDATE Ticket Number : TKT000084 BT Tech Request DYNAMIX Number 109070','','Emails','2023-05-11',NULL,'08:15:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(399,'UPDATE Ticket Number : TKT000104 Request Tech Visit Switch Installation at SD Concord DYNAMIX Number 999999','','Emails','2023-05-11',NULL,'17:28:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(400,'UPDATE Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX Number 110406','','Emails','2023-05-11',NULL,'17:58:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(402,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000106 Installation of replacement KDS FWLD002-KDS-001 DYNAMIX NUMBER 110888','','Emails','2023-05-12',NULL,'00:44:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(406,'UPDATE Ticket Number : TKT000095 Tech Visit at Dela Rosa Yerba Buena /  Connect Newly Opened Ports to Patch Panel DYNAMIX Number 110406','','Emails','2023-05-15',NULL,'18:54:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(407,'UPDATE Ticket Number : TKT000097 Dela Rosa Yerba Buena / Wiring issue from Patch DYNAMIX Number 110406','','Emails','2023-05-15',NULL,'19:08:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(408,'UPDATE Ticket Number : TKT000106 Installation of replacement KDS FWLD002-KDS-001 DYNAMIX Number 110888','','Emails','2023-05-17',NULL,'02:24:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(411,'Regarding Contact Assignment','','Emails','2023-05-17',NULL,'17:18:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(412,'UPDATE Ticket Number : TKT000084 BT Tech Request DYNAMIX Number 109070','','Emails','2023-05-19',NULL,'02:56:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(413,'UPDATE Ticket Number : TKT000099 Tech Visit Beretta /UPS Replacement DYNAMIX Number 110134','','Emails','2023-05-19',NULL,'02:56:08',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(414,'UPDATE Ticket Number : TKT000101 RE: 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX Number 110450','','Emails','2023-05-19',NULL,'02:56:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(415,'UPDATE Ticket Number : TKT000100 110355/Lolinda/Installation of 2 Handhelds DYNAMIX Number 110355','','Emails','2023-05-19',NULL,'02:56:16',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(416,'UPDATE Ticket Number : TKT000051 Installation of replacement KDS at SD Novato DYNAMIX Number 109234','','Emails','2023-05-19',NULL,'03:10:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(417,'UPDATE Ticket Number : TKT000101 RE: 110450 / Afterwork Bar / TV sounds and TV outside DYNAMIX Number 110450','','Emails','2023-05-19',NULL,'03:52:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(418,'UPDATE Ticket Number : TKT000098 110388/Wildseed Palo Alto/Remove 6 Port Switch DYNAMIX Number 110291','','Emails','2023-05-19',NULL,'04:06:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(419,'UPDATE Ticket Number : TKT000103 110352 / Afterwork bar / Reconnect Television to Matrix DYNAMIX Number 11450','','Emails','2023-05-19',NULL,'04:20:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(421,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000107 Super Duper - Novato /  UPS Replacement / 110762 DYNAMIX NUMBER 110762','','Emails','2023-05-21',NULL,'01:48:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(423,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000108 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch DYNAMIX NUMBER 110406','','Emails','2023-05-21',NULL,'20:14:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(424,'UPDATE Ticket Number : TKT000108 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch DYNAMIX Number 110406','','Emails','2023-05-21',NULL,'20:42:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(425,'UPDATE Ticket Number : TKT000108 110406 / Dela Rosa Yerba Buena / Wirirng issue from Patch DYNAMIX Number 110406','','Emails','2023-05-21',NULL,'20:42:08',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(426,'UPDATE Ticket Number : TKT000040 108772 - aMano network rack DYNAMIX Number 108772','','Emails','2023-05-21',NULL,'22:40:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(427,'UPDATE Ticket Number : TKT000048 Super Duper - Berkeley / Resolve camera 2 DYNAMIX Number 108769','','Emails','2023-05-21',NULL,'22:54:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(428,'UPDATE Ticket Number : TKT000024 108064 / Flores Union / Printer Routing Issue DYNAMIX Number 108064','','Emails','2023-05-21',NULL,'23:08:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(429,'UPDATE Ticket Number : TKT000042 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music DYNAMIX Number 108817','','Emails','2023-05-21',NULL,'23:08:13',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(430,'UPDATE Ticket Number : TKT000026 107721 / Super Duper - Emeryville / Toast Tap Replacement DYNAMIX Number 107721','','Emails','2023-05-21',NULL,'23:22:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(431,'UPDATE Ticket Number : TKT000017 After Work Bar / Montaje seguro para televisores de barra DYNAMIX Number 108024','','Emails','2023-05-21',NULL,'23:22:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(432,'UPDATE Ticket Number : TKT000087 The Tailor\'s Son / Cash Drawer replacement DYNAMIX Number 107807','','Emails','2023-05-21',NULL,'23:22:04',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(433,'UPDATE Ticket Number : TKT000086 nstallation of Toast Flex Counter, Receipt Printer and Direct attached Toast Tap DYNAMIX Number 107780','','Emails','2023-05-21',NULL,'23:50:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(434,'UPDATE Ticket Number : TKT000083 Field Tech Request Urgent DYNAMIX Number 110263','','Emails','2023-05-22',NULL,'00:04:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(435,'UPDATE Ticket Number : TKT000082 Super Duper -Los Gatos / Intermittent Internet Connection DYNAMIX Number 110158','','Emails','2023-05-22',NULL,'00:04:10',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(436,'UPDATE Ticket Number : TKT000081 The Bird Hayes / Reset AV Matrix DYNAMIX Number 110135','','Emails','2023-05-22',NULL,'00:04:12',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(437,'UPDATE Ticket Number : TKT000061 Troubleshoot Dayforce Offline-El Techo DYNAMIX Number 109888','','Emails','2023-05-22',NULL,'00:04:14',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(438,'UPDATE Ticket Number : TKT000045 Uno Dos Tacos / Connect Yealink Receiver to network DYNAMIX Number 108896','','Emails','2023-05-22',NULL,'00:20:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(439,'UPDATE Ticket Number : TKT000039 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music DYNAMIX Number 108825','','Emails','2023-05-22',NULL,'00:20:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(440,'UPDATE Ticket Number : TKT000038 108817 and 108825 / Super Duper – Metreon / Printer not printing and No sound on their Music DYNAMIX Number 108817','','Emails','2023-05-22',NULL,'00:34:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(441,'UPDATE Ticket Number : TKT000015 Comcast Enterprise Services Planned Maintenance Notification - CM004269753 DYNAMIX Number 107832','','Emails','2023-05-22',NULL,'00:34:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(442,'UPDATE Ticket Number : TKT000014 omcast Enterprise Services Planned Maintenance Notification - CM004269753 DYNAMIX Number 0','','Emails','2023-05-22',NULL,'00:48:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(443,'UPDATE Ticket Number : TKT000006 Troubleshoot Dayforce Offline-El Techo DYNAMIX Number 109888','','Emails','2023-05-22',NULL,'00:48:09',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(444,'UPDATE Ticket Number : TKT000005 SD Serramonte SDWAN equipment pickup DYNAMIX Number 109856','','Emails','2023-05-22',NULL,'01:02:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(445,'UPDATE Ticket Number : TKT000107 Super Duper - Novato /  UPS Replacement / 110762 DYNAMIX Number 110762','','Emails','2023-05-22',NULL,'15:36:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(446,'Regarding Contact Assignment','','Emails','2023-05-22',NULL,'21:44:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(448,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000109 Urgent: Super Duper Laurel Village /  Network Down DYNAMIX NUMBER 111239','','Emails','2023-05-24',NULL,'15:50:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(451,'UPDATE Ticket Number : TKT000109 Urgent: Super Duper Laurel Village /  Network Down DYNAMIX Number 111239','','Emails','2023-05-25',NULL,'01:06:02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(454,'','','Emails','2023-05-25',NULL,'03:32:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(455,'A new ticket has been created on the Customer Portal ','','Emails','2023-05-25',NULL,'03:32:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(456,'UPDATE Ticket Number : TKT000110 FCOR001 Corzetti :  Re: Items for storage DYNAMIX Number 0','','Emails','2023-05-25',NULL,'03:32:03',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(457,'YOU HAVE BEEN ASSIGNED TO A NEW TICKET - Ticket Number : TKT000111 Re: Internet Downtime Update DYNAMIX NUMBER 1112861','','Emails','2023-05-25',NULL,'03:32:05',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,''),(464,'UPDATE Ticket Number : TKT000110 FCOR001 Corzetti :  Re: Items for storage DYNAMIX Number 0','','Emails','2023-05-25',NULL,'03:46:01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0','all',NULL,'');

--
-- Table structure for table `vtiger_activity_recurring_info`
--

CREATE TABLE `vtiger_activity_recurring_info` (
  `activityid` int(11) NOT NULL,
  `recurrenceid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_activity_recurring_info`
--


--
-- Table structure for table `vtiger_activity_reminder`
--

CREATE TABLE `vtiger_activity_reminder` (
  `activity_id` int(11) NOT NULL,
  `reminder_time` int(11) NOT NULL,
  `reminder_sent` int(11) NOT NULL,
  `recurringid` int(11) NOT NULL,
  PRIMARY KEY (`activity_id`,`recurringid`),
  CONSTRAINT `fk_activityid_vtiger_activity_reminder` FOREIGN KEY (`activity_id`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activity_reminder`
--


--
-- Table structure for table `vtiger_activity_reminder_popup`
--

CREATE TABLE `vtiger_activity_reminder_popup` (
  `reminderid` int(11) NOT NULL AUTO_INCREMENT,
  `semodule` varchar(100) NOT NULL,
  `recordid` int(11) NOT NULL,
  `date_start` date NOT NULL,
  `time_start` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`reminderid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activity_reminder_popup`
--


--
-- Table structure for table `vtiger_activity_view`
--

CREATE TABLE `vtiger_activity_view` (
  `activity_viewid` int(11) NOT NULL AUTO_INCREMENT,
  `activity_view` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`activity_viewid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activity_view`
--

INSERT INTO `vtiger_activity_view` VALUES (1,'Today',0,1),(2,'This Week',1,1),(3,'This Month',2,1),(4,'This Year',3,1),(5,'Agenda',4,1);

--
-- Table structure for table `vtiger_activity_view_seq`
--

CREATE TABLE `vtiger_activity_view_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activity_view_seq`
--

INSERT INTO `vtiger_activity_view_seq` VALUES (5);

--
-- Table structure for table `vtiger_activitycf`
--

CREATE TABLE `vtiger_activitycf` (
  `activityid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`activityid`),
  CONSTRAINT `fk_activityid_vtiger_activitycf` FOREIGN KEY (`activityid`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activitycf`
--


--
-- Table structure for table `vtiger_activityproductrel`
--

CREATE TABLE `vtiger_activityproductrel` (
  `activityid` int(11) NOT NULL DEFAULT 0,
  `productid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`activityid`,`productid`),
  KEY `activityproductrel_activityid_idx` (`activityid`),
  KEY `activityproductrel_productid_idx` (`productid`),
  CONSTRAINT `fk_2_vtiger_activityproductrel` FOREIGN KEY (`productid`) REFERENCES `vtiger_products` (`productid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activityproductrel`
--


--
-- Table structure for table `vtiger_activitytype`
--

CREATE TABLE `vtiger_activitytype` (
  `activitytypeid` int(11) NOT NULL AUTO_INCREMENT,
  `activitytype` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`activitytypeid`),
  UNIQUE KEY `activitytype_activitytype_idx` (`activitytype`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activitytype`
--

INSERT INTO `vtiger_activitytype` VALUES (1,'Call',0,12,0,NULL),(2,'Meeting',0,13,1,NULL),(3,'Mobile Call',0,295,1,NULL);

--
-- Table structure for table `vtiger_activitytype_seq`
--

CREATE TABLE `vtiger_activitytype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_activitytype_seq`
--

INSERT INTO `vtiger_activitytype_seq` VALUES (3);

--
-- Table structure for table `vtiger_announcement`
--

CREATE TABLE `vtiger_announcement` (
  `creatorid` int(11) NOT NULL,
  `announcement` text DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`creatorid`),
  KEY `announcement_creatorid_idx` (`creatorid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_announcement`
--


--
-- Table structure for table `vtiger_app2tab`
--

CREATE TABLE `vtiger_app2tab` (
  `tabid` int(11) DEFAULT NULL,
  `appname` varchar(20) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `visible` int(11) DEFAULT 1,
  KEY `vtiger_app2tab_fk_tab` (`tabid`),
  CONSTRAINT `vtiger_app2tab_fk_tab` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_app2tab`
--

INSERT INTO `vtiger_app2tab` VALUES (34,'TOOLS',5,1),(35,'SUPPORT',2,1),(36,'INVENTORY',2,1),(40,'TOOLS',1,1),(46,'TOOLS',4,1),(49,'SETTINGS',1,1),(2,'SALES',1,1),(20,'SALES',2,1),(4,'SALES',6,1),(6,'SALES',7,1),(14,'SALES',3,1),(36,'SALES',4,1),(4,'MARKETING',3,1),(6,'MARKETING',4,1),(7,'MARKETING',2,1),(26,'MARKETING',1,1),(4,'INVENTORY',8,1),(6,'INVENTORY',9,1),(22,'INVENTORY',5,1),(23,'INVENTORY',4,1),(14,'INVENTORY',1,1),(18,'INVENTORY',7,1),(19,'INVENTORY',3,1),(21,'INVENTORY',6,1),(4,'SUPPORT',4,1),(6,'SUPPORT',5,1),(13,'SUPPORT',1,1),(15,'SUPPORT',2,1),(38,'SUPPORT',4,1),(45,'PROJECT',1,1),(44,'PROJECT',2,1),(43,'PROJECT',3,1),(4,'PROJECT',4,0),(6,'PROJECT',5,0),(47,'SALES',1,1),(47,'SUPPORT',3,1),(24,'TOOLS',2,1),(27,'TOOLS',3,1);

--
-- Table structure for table `vtiger_assets`
--

CREATE TABLE `vtiger_assets` (
  `assetsid` int(11) NOT NULL,
  `asset_no` varchar(30) NOT NULL,
  `account` int(11) DEFAULT NULL,
  `product` int(11) NOT NULL,
  `serialnumber` varchar(200) DEFAULT NULL,
  `datesold` date DEFAULT NULL,
  `dateinservice` date DEFAULT NULL,
  `assetstatus` varchar(200) DEFAULT 'In Service',
  `tagnumber` varchar(300) DEFAULT NULL,
  `invoiceid` int(11) DEFAULT NULL,
  `shippingmethod` varchar(200) DEFAULT NULL,
  `shippingtrackingnumber` varchar(200) DEFAULT NULL,
  `assetname` varchar(100) DEFAULT NULL,
  `contact` int(11) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`assetsid`),
  CONSTRAINT `fk_1_vtiger_assets` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assets`
--


--
-- Table structure for table `vtiger_assetscf`
--

CREATE TABLE `vtiger_assetscf` (
  `assetsid` int(11) NOT NULL,
  PRIMARY KEY (`assetsid`),
  CONSTRAINT `fk_assetsid_vtiger_assetscf` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_assets` (`assetsid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assetscf`
--


--
-- Table structure for table `vtiger_assetstatus`
--

CREATE TABLE `vtiger_assetstatus` (
  `assetstatusid` int(11) NOT NULL AUTO_INCREMENT,
  `assetstatus` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`assetstatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_assetstatus`
--

INSERT INTO `vtiger_assetstatus` VALUES (1,'In Service',1,235,1,NULL),(2,'Out-of-service',1,236,2,NULL);

--
-- Table structure for table `vtiger_assetstatus_seq`
--

CREATE TABLE `vtiger_assetstatus_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_assetstatus_seq`
--

INSERT INTO `vtiger_assetstatus_seq` VALUES (2);

--
-- Table structure for table `vtiger_asterisk`
--

CREATE TABLE `vtiger_asterisk` (
  `server` varchar(30) DEFAULT NULL,
  `port` varchar(30) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `version` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_asterisk`
--


--
-- Table structure for table `vtiger_asteriskextensions`
--

CREATE TABLE `vtiger_asteriskextensions` (
  `userid` int(11) DEFAULT NULL,
  `asterisk_extension` varchar(50) DEFAULT NULL,
  `use_asterisk` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_asteriskextensions`
--

INSERT INTO `vtiger_asteriskextensions` VALUES (1,NULL,NULL),(5,NULL,NULL),(6,NULL,NULL),(7,NULL,NULL),(8,NULL,NULL),(9,NULL,NULL),(10,NULL,NULL),(11,NULL,NULL),(12,NULL,NULL),(13,NULL,NULL);

--
-- Table structure for table `vtiger_asteriskincomingcalls`
--

CREATE TABLE `vtiger_asteriskincomingcalls` (
  `from_number` varchar(50) DEFAULT NULL,
  `from_name` varchar(50) DEFAULT NULL,
  `to_number` varchar(50) DEFAULT NULL,
  `callertype` varchar(30) DEFAULT NULL,
  `flag` int(11) DEFAULT NULL,
  `timer` int(11) DEFAULT NULL,
  `refuid` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_asteriskincomingcalls`
--


--
-- Table structure for table `vtiger_asteriskincomingevents`
--

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(11) DEFAULT NULL,
  `flag` varchar(3) DEFAULT NULL,
  `pbxrecordid` int(11) DEFAULT NULL,
  `relcrmid` int(11) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_asteriskincomingevents`
--


--
-- Table structure for table `vtiger_attachments`
--

CREATE TABLE `vtiger_attachments` (
  `attachmentsid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `path` text DEFAULT NULL,
  `storedname` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`attachmentsid`),
  KEY `attachments_attachmentsid_idx` (`attachmentsid`),
  CONSTRAINT `fk_1_vtiger_attachments` FOREIGN KEY (`attachmentsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_attachments`
--

INSERT INTO `vtiger_attachments` VALUES (43,'SD_98_Mission.jpg',NULL,'image/jpeg','storage/2023/February/week3/','af09ddeac2421019ade95512ae639878.jpg',NULL),(46,'SD_98_Mission.jpg','<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: normal; text-decoration: none; background-color: rgb(122, 122, 254);\" width=\"700\">\r\n	<tbody>\r\n		<tr>\r\n			<td></td>\r\n			<td></td>\r\n			<td></td>\r\n		</tr>\r\n		<tr>\r\n			<td></td>\r\n			<td></td>\r\n			<td></td>\r\n		</tr>\r\n		<tr>\r\n			<td></td>\r\n			<td></td>\r\n			<td></td>\r\n		</tr>\r\n		<tr>\r\n			<td width=\"50\"></td>\r\n			<td>\r\n			<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n				<tbody>\r\n					<tr>\r\n						<td>\r\n						<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: rgb(27, 77, 140); font-family: Arial,Helvetica,sans-serif; font-size: 14px; color: rgb(255, 255, 255); font-weight: normal; line-height: 25px;\" width=\"100%\">\r\n							<tbody>\r\n								<tr>\r\n									<td align=\"center\" rowspan=\"4\">$logo$</td>\r\n									<td align=\"center\"></td>\r\n								</tr>\r\n								<tr>\r\n									<td align=\"left\" style=\"background-color: rgb(27, 77, 140); font-family: Arial,Helvetica,sans-serif; font-size: 24px; color: rgb(255, 255, 255); font-weight: bolder; line-height: 35px;\">vtiger CRM</td>\r\n								</tr>\r\n								<tr>\r\n									<td align=\"right\" style=\"padding-right: 100px;\">The honest Open Source CRM</td>\r\n								</tr>\r\n								<tr>\r\n									<td></td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td>\r\n						<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: normal; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);\" width=\"100%\">\r\n							<tbody>\r\n								<tr>\r\n									<td valign=\"top\">\r\n									<table border=\"0\" cellpadding=\"5\" cellspacing=\"0\" width=\"100%\">\r\n										<tbody>\r\n											<tr>\r\n												<td align=\"right\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: bolder; text-decoration: none; color: rgb(66, 66, 253);\"></td>\r\n											</tr>\r\n											<tr>\r\n												<td></td>\r\n											</tr>\r\n											<tr>\r\n												<td style=\"font-family: Arial,Helvetica,sans-serif; font-size: 14px; color: rgb(22, 72, 134); font-weight: bolder; line-height: 15px;\">Dear $contacts-lastname$,</td>\r\n											</tr>\r\n											<tr>\r\n												<td style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; color: rgb(0, 0, 0); font-weight: normal; text-align: justify; line-height: 20px;\">This is just a notification mail regarding your support end.<br />\r\n												<span style=\"font-weight: bold;\">Priority:</span> Normal<br />\r\n												Your Support is going to expire on next month.<br />\r\n												Please contact support@vtiger.com<br />\r\n												<br />\r\n												&nbsp;</td>\r\n											</tr>\r\n											<tr>\r\n												<td align=\"center\"></td>\r\n											</tr>\r\n											<tr>\r\n												<td align=\"right\"><br />\r\n												<br />\r\n												<strong style=\"padding: 2px; font-family: Arial,Helvetica,sans-serif; font-size: 12px; color: rgb(0, 0, 0); font-weight: bold;\">Sincerly</strong></td>\r\n											</tr>\r\n											<tr>\r\n												<td align=\"right\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; color: rgb(0, 0, 0); font-weight: normal; line-height: 20px;\">Support Team</td>\r\n											</tr>\r\n											<tr>\r\n												<td align=\"right\"><a href=\"http://www.vtiger.com\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: bolder; text-decoration: none; color: rgb(66, 66, 253);\">www.vtiger.com</a></td>\r\n											</tr>\r\n											<tr>\r\n												<td></td>\r\n											</tr>\r\n										</tbody>\r\n									</table>\r\n									</td>\r\n									<td valign=\"top\" width=\"1%\"></td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td>\r\n						<table border=\"0\" cellpadding=\"5\" cellspacing=\"0\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; color: rgb(255, 255, 255); font-weight: normal; line-height: 15px; background-color: rgb(51, 51, 51);\" width=\"100%\">\r\n							<tbody>\r\n								<tr>\r\n									<td align=\"center\">Shree Narayana Complex, No 11 Sarathy Nagar, Vijaya Nagar , Velachery, Chennai - 600 042 India</td>\r\n								</tr>\r\n								<tr>\r\n									<td align=\"center\">Telephone No: +91 - 44 - 4202 - 1990 Toll Free No: +1 877 788 4437</td>\r\n								</tr>\r\n								<tr>\r\n									<td align=\"center\">Email Id: <a href=\"mailto:info@vtiger.com\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: bolder; text-decoration: none; color: rgb(255, 255, 255);\">info@vtiger.com</a></td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n			<td width=\"50\"></td>\r\n		</tr>\r\n		<tr>\r\n			<td></td>\r\n			<td></td>\r\n			<td></td>\r\n		</tr>\r\n		<tr>\r\n			<td></td>\r\n			<td></td>\r\n			<td></td>\r\n		</tr>\r\n		<tr>\r\n			<td></td>\r\n			<td></td>\r\n			<td></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</body>\r\n</html>\r\n','image/jpeg','storage/2023/February/week3/','2c41fd2f29501f7ab354dc87e890d8c3.jpg',NULL),(48,'SD_98_Mission.jpg',NULL,'image/jpeg','storage/2023/February/week3/','ccf365b2a9ee960c5d0f118abd6b7990.jpg',NULL),(196,'BT_Circle.jpg','','image/jpeg','storage/2023/April/week3/','94107bceee3e7b9d34c52363288ef6c7.jpg',NULL),(348,'107054.png',NULL,'image/png','storage/2023/May/week2/','887eca342744a70b7210716a457f16ad.png',NULL),(374,'Palo_Alto_Updated.xlsx',NULL,'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','storage/2023/May/week2/','a76793a6135ea265bd90b39397648073.xlsx',NULL),(377,'20230427_102522.jpg',NULL,'image/jpeg','storage/2023/May/week2/','d0776e738707d2b42229dbd692193fcf.jpg',NULL),(378,'20230427_110459.jpg',NULL,'image/jpeg','storage/2023/May/week2/','7540f9ebd89e81aca9627352d24f9ccf.jpg',NULL),(382,'20230426_133219.jpg',NULL,'image/jpeg','storage/2023/May/week2/','b7351f695ebbe70c647548adfd87e8aa.jpg',NULL),(383,'20230426_133421.jpg',NULL,'image/jpeg','storage/2023/May/week2/','ff48796df21d3d07105e9eb087dc9df2.jpg',NULL),(404,'Delarosa_direct_connected.jpg',NULL,'image/jpeg','storage/2023/May/week3/','a903c02fc223f4584924e491dc15def1.jpg',NULL),(405,'KDS_Pizza_IP_connected_Switch_port_14.JPEG',NULL,'image/jpeg','storage/2023/May/week3/','9a192c6f85248f3d43ee029957abf69d.JPEG',NULL),(410,'Dynamix_Logo_2019.png','','image/png','storage/2023/May/week3/','6be34dd35b3dad9f1b34666c8375b354.png',NULL),(459,'P1.jpg',NULL,'image/jpeg','storage/2023/May/week4/','67b595b0baef07064cd8517bf6e009fb.jpg',NULL),(460,'p2.jpg',NULL,'image/jpeg','storage/2023/May/week4/','39a9ea2c1caa7d7621d5ac1995daa9e6.jpg',NULL),(461,'p3.jpg',NULL,'image/jpeg','storage/2023/May/week4/','191376d536ed918729a6cfbbbd484875.jpg',NULL),(462,'p4.jpg',NULL,'image/jpeg','storage/2023/May/week4/','d82768623b5688a08f889b7ce4849269.jpg',NULL),(463,'p5.jpg',NULL,'image/jpeg','storage/2023/May/week4/','6d6d236dc406d139b5fdc0f440329faf.jpg',NULL);

--
-- Table structure for table `vtiger_attachmentsfolder`
--

CREATE TABLE `vtiger_attachmentsfolder` (
  `folderid` int(11) NOT NULL AUTO_INCREMENT,
  `foldername` varchar(200) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `createdby` int(11) NOT NULL,
  `sequence` int(11) DEFAULT NULL,
  PRIMARY KEY (`folderid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_attachmentsfolder`
--

INSERT INTO `vtiger_attachmentsfolder` VALUES (1,'Default','This is a Default Folder',1,1);

--
-- Table structure for table `vtiger_attachmentsfolder_seq`
--

CREATE TABLE `vtiger_attachmentsfolder_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_attachmentsfolder_seq`
--

INSERT INTO `vtiger_attachmentsfolder_seq` VALUES (1);

--
-- Table structure for table `vtiger_audit_trial`
--

CREATE TABLE `vtiger_audit_trial` (
  `auditid` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `recordid` varchar(20) DEFAULT NULL,
  `actiondate` datetime DEFAULT NULL,
  PRIMARY KEY (`auditid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_audit_trial`
--


--
-- Table structure for table `vtiger_blocks`
--

CREATE TABLE `vtiger_blocks` (
  `blockid` int(11) NOT NULL,
  `tabid` int(11) NOT NULL,
  `blocklabel` varchar(100) NOT NULL,
  `sequence` int(11) DEFAULT NULL,
  `show_title` int(11) DEFAULT NULL,
  `visible` int(11) NOT NULL DEFAULT 0,
  `create_view` int(11) NOT NULL DEFAULT 0,
  `edit_view` int(11) NOT NULL DEFAULT 0,
  `detail_view` int(11) NOT NULL DEFAULT 0,
  `display_status` int(11) NOT NULL DEFAULT 1,
  `iscustom` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`blockid`),
  KEY `block_tabid_idx` (`tabid`),
  CONSTRAINT `fk_1_vtiger_blocks` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_blocks`
--

INSERT INTO `vtiger_blocks` VALUES (1,2,'LBL_OPPORTUNITY_INFORMATION',1,0,0,0,0,0,1,0),(2,2,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(3,2,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(4,4,'LBL_CONTACT_INFORMATION',1,0,0,0,0,0,1,0),(5,4,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(6,4,'LBL_CUSTOMER_PORTAL_INFORMATION',3,0,0,0,0,0,1,0),(7,4,'LBL_ADDRESS_INFORMATION',4,0,0,0,0,0,1,0),(8,4,'LBL_DESCRIPTION_INFORMATION',5,0,0,0,0,0,1,0),(9,6,'LBL_ACCOUNT_INFORMATION',1,0,0,0,0,0,1,0),(10,6,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(11,6,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(12,6,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(13,7,'LBL_LEAD_INFORMATION',1,0,0,0,0,0,1,0),(14,7,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(15,7,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(16,7,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(17,8,'LBL_NOTE_INFORMATION',1,0,0,0,0,0,1,0),(18,8,'LBL_FILE_INFORMATION',3,1,0,0,0,0,1,0),(19,9,'LBL_TASK_INFORMATION',1,0,0,0,0,0,1,0),(20,9,'LBL_DESCRIPTION_INFORMATION',3,1,0,0,0,0,1,0),(21,10,'LBL_EMAIL_INFORMATION',1,0,0,0,0,0,1,0),(22,10,'Emails_Block1',2,1,0,0,0,0,1,0),(23,10,'Emails_Block2',3,1,0,0,0,0,1,0),(24,10,'Emails_Block3',4,1,0,0,0,0,1,0),(25,13,'LBL_TICKET_INFORMATION',1,0,0,0,0,0,1,0),(26,13,'',5,1,0,0,0,0,1,0),(27,13,'LBL_CUSTOM_INFORMATION',6,0,0,0,0,0,1,0),(28,13,'LBL_DESCRIPTION_INFORMATION',7,0,0,0,0,0,1,0),(29,13,'LBL_TICKET_RESOLUTION',5,0,0,1,0,0,1,0),(30,13,'LBL_COMMENTS',9,0,0,1,0,0,1,0),(31,14,'LBL_PRODUCT_INFORMATION',1,0,0,0,0,0,1,0),(32,14,'LBL_PRICING_INFORMATION',2,0,0,0,0,0,1,0),(33,14,'LBL_STOCK_INFORMATION',3,0,0,0,0,0,1,0),(34,14,'LBL_CUSTOM_INFORMATION',4,0,0,0,0,0,1,0),(35,14,'LBL_IMAGE_INFORMATION',5,0,0,0,0,0,1,0),(36,14,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(37,15,'LBL_FAQ_INFORMATION',1,0,0,0,0,0,1,0),(38,15,'LBL_COMMENT_INFORMATION',4,0,0,1,0,0,1,0),(39,16,'LBL_EVENT_INFORMATION',1,0,0,0,0,0,1,0),(40,16,'LBL_REMINDER_INFORMATION',2,0,0,0,0,0,1,0),(41,16,'LBL_DESCRIPTION_INFORMATION',5,0,0,0,0,0,1,0),(42,18,'LBL_VENDOR_INFORMATION',1,0,0,0,0,0,1,0),(43,18,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(44,18,'LBL_VENDOR_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(45,18,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(46,19,'LBL_PRICEBOOK_INFORMATION',1,0,0,0,0,0,1,0),(47,19,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(48,19,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(49,20,'LBL_QUOTE_INFORMATION',1,0,0,0,0,0,1,0),(50,20,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(51,20,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(52,20,'LBL_RELATED_PRODUCTS',4,0,0,0,0,0,1,0),(53,20,'LBL_TERMS_INFORMATION',5,0,0,0,0,0,1,0),(54,20,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(55,21,'LBL_PO_INFORMATION',1,0,0,0,0,0,1,0),(56,21,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(57,21,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(58,21,'LBL_RELATED_PRODUCTS',4,0,0,0,0,0,1,0),(59,21,'LBL_TERMS_INFORMATION',5,0,0,0,0,0,1,0),(60,21,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(61,22,'LBL_SO_INFORMATION',1,0,0,0,0,0,1,0),(62,22,'LBL_CUSTOM_INFORMATION',3,0,0,0,0,0,1,0),(63,22,'LBL_ADDRESS_INFORMATION',4,0,0,0,0,0,1,0),(64,22,'LBL_RELATED_PRODUCTS',5,0,0,0,0,0,1,0),(65,22,'LBL_TERMS_INFORMATION',6,0,0,0,0,0,1,0),(66,22,'LBL_DESCRIPTION_INFORMATION',7,0,0,0,0,0,1,0),(67,23,'LBL_INVOICE_INFORMATION',1,0,0,0,0,0,1,0),(68,23,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(69,23,'LBL_ADDRESS_INFORMATION',3,0,0,0,0,0,1,0),(70,23,'LBL_RELATED_PRODUCTS',4,0,0,0,0,0,1,0),(71,23,'LBL_TERMS_INFORMATION',5,0,0,0,0,0,1,0),(72,23,'LBL_DESCRIPTION_INFORMATION',6,0,0,0,0,0,1,0),(73,4,'LBL_IMAGE_INFORMATION',6,0,0,0,0,0,1,0),(74,26,'LBL_CAMPAIGN_INFORMATION',1,0,0,0,0,0,1,0),(75,26,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(76,26,'LBL_EXPECTATIONS_AND_ACTUALS',3,0,0,0,0,0,1,0),(77,29,'LBL_USERLOGIN_ROLE',1,0,0,0,0,0,1,0),(78,29,'LBL_CURRENCY_CONFIGURATION',3,0,0,0,0,0,1,0),(79,29,'LBL_MORE_INFORMATION',4,0,0,0,0,0,1,0),(80,29,'LBL_ADDRESS_INFORMATION',5,0,0,0,0,0,1,0),(81,26,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(82,29,'LBL_USER_IMAGE_INFORMATION',5,0,0,0,0,0,1,0),(83,29,'LBL_USER_ADV_OPTIONS',6,0,0,0,0,0,1,0),(84,8,'LBL_DESCRIPTION',2,0,0,0,0,0,1,0),(85,22,'Recurring Invoice Information',2,0,0,0,0,0,1,0),(86,9,'LBL_CUSTOM_INFORMATION',4,0,0,0,0,0,1,0),(87,16,'LBL_CUSTOM_INFORMATION',6,0,0,0,0,0,1,0),(88,34,'LBL_PBXMANAGER_INFORMATION',1,0,0,0,0,0,1,0),(89,35,'LBL_SERVICE_CONTRACT_INFORMATION',1,0,0,0,0,0,1,0),(90,35,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(91,36,'LBL_SERVICE_INFORMATION',1,0,0,0,0,0,1,0),(92,36,'LBL_PRICING_INFORMATION',2,0,0,0,0,0,1,0),(93,36,'LBL_CUSTOM_INFORMATION',3,0,0,0,0,0,1,0),(94,36,'LBL_DESCRIPTION_INFORMATION',4,0,0,0,0,0,1,0),(95,38,'LBL_ASSET_INFORMATION',1,0,0,0,0,0,1,0),(96,38,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(97,38,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(98,42,'LBL_MODCOMMENTS_INFORMATION',1,0,0,0,0,0,1,0),(99,42,'LBL_OTHER_INFORMATION',2,0,0,0,0,0,1,0),(100,42,'LBL_CUSTOM_INFORMATION',3,0,0,0,0,0,1,0),(101,43,'LBL_PROJECT_MILESTONE_INFORMATION',1,0,0,0,0,0,1,0),(102,43,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(103,43,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(104,44,'LBL_PROJECT_TASK_INFORMATION',1,0,0,0,0,0,1,0),(105,44,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(106,44,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(107,45,'LBL_PROJECT_INFORMATION',1,0,0,0,0,0,1,0),(108,45,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(109,45,'LBL_DESCRIPTION_INFORMATION',3,0,0,0,0,0,1,0),(110,47,'LBL_SMSNOTIFIER_INFORMATION',1,0,0,0,0,0,1,0),(111,47,'LBL_CUSTOM_INFORMATION',2,0,0,0,0,0,1,0),(112,47,'StatusInformation',3,0,0,0,0,0,1,0),(113,23,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(114,22,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(115,21,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(116,20,'LBL_ITEM_DETAILS',5,0,0,0,0,0,1,0),(117,16,'LBL_RECURRENCE_INFORMATION',3,0,0,0,0,0,1,0),(118,29,'LBL_CALENDAR_SETTINGS',2,0,0,0,0,0,1,0),(119,16,'LBL_RELATED_TO',4,0,0,0,0,0,1,0),(120,9,'LBL_REMINDER_INFORMATION',2,0,0,0,0,0,1,0),(121,4,'System Information',7,0,0,0,0,0,1,1),(122,6,'System Information',5,0,0,0,0,0,1,1),(123,13,'Time Calculations',3,0,0,0,0,0,1,1),(124,13,'Timing',2,0,0,0,0,0,1,1),(125,13,'Other Charges',4,0,0,0,0,0,1,1);

--
-- Table structure for table `vtiger_blocks_seq`
--

CREATE TABLE `vtiger_blocks_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_blocks_seq`
--

INSERT INTO `vtiger_blocks_seq` VALUES (125);

--
-- Table structure for table `vtiger_calendar_default_activitytypes`
--

CREATE TABLE `vtiger_calendar_default_activitytypes` (
  `id` int(11) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  `fieldname` varchar(50) DEFAULT NULL,
  `defaultcolor` varchar(50) DEFAULT NULL,
  `isdefault` int(11) DEFAULT 1,
  `conditions` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_calendar_default_activitytypes`
--

INSERT INTO `vtiger_calendar_default_activitytypes` VALUES (1,'Events','[\"date_start\",\"due_date\"]','#17309A',1,''),(2,'Calendar','[\"date_start\",\"due_date\"]','#3A87AD',1,''),(3,'Potentials','[\"closingdate\"]','#AA6705',1,''),(4,'Contacts','[\"support_end_date\"]','#953B39',1,''),(5,'Contacts','[\"birthday\"]','#545252',1,''),(6,'Invoice','[\"duedate\"]','#87865D',1,''),(7,'Project','[\"startdate\",\"targetenddate\"]','#C71585',1,''),(8,'ProjectTask','[\"startdate\",\"enddate\"]','#006400',1,'');

--
-- Table structure for table `vtiger_calendar_default_activitytypes_seq`
--

CREATE TABLE `vtiger_calendar_default_activitytypes_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_calendar_default_activitytypes_seq`
--

INSERT INTO `vtiger_calendar_default_activitytypes_seq` VALUES (8);

--
-- Table structure for table `vtiger_calendar_user_activitytypes`
--

CREATE TABLE `vtiger_calendar_user_activitytypes` (
  `id` int(11) NOT NULL,
  `defaultid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `visible` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_calendar_user_activitytypes`
--

INSERT INTO `vtiger_calendar_user_activitytypes` VALUES (1,1,1,'#17309A',1),(2,2,1,'#3A87AD',1),(3,3,1,'#AA6705',1),(4,4,1,'#953B39',1),(5,5,1,'#545252',1),(6,6,1,'#87865D',1),(7,7,1,'#C71585',1),(8,8,1,'#006400',1),(9,1,5,'#17309A',1),(10,2,5,'#3A87AD',1),(11,3,5,'#AA6705',1),(12,4,5,'#953B39',1),(13,5,5,'#545252',1),(14,6,5,'#87865D',1),(15,7,5,'#C71585',1),(16,8,5,'#006400',1),(17,1,6,'#17309A',1),(18,2,6,'#3A87AD',1),(19,3,6,'#AA6705',1),(20,4,6,'#953B39',1),(21,5,6,'#545252',1),(22,6,6,'#87865D',1),(23,7,6,'#C71585',1),(24,8,6,'#006400',1),(25,1,7,'#17309A',1),(26,2,7,'#3A87AD',1),(27,3,7,'#AA6705',1),(28,4,7,'#953B39',1),(29,5,7,'#545252',1),(30,6,7,'#87865D',1),(31,7,7,'#C71585',1),(32,8,7,'#006400',1),(33,1,8,'#17309A',1),(34,2,8,'#3A87AD',1),(35,3,8,'#AA6705',1),(36,4,8,'#953B39',1),(37,5,8,'#545252',1),(38,6,8,'#87865D',1),(39,7,8,'#C71585',1),(40,8,8,'#006400',1),(41,1,9,'#17309A',1),(42,2,9,'#3A87AD',1),(43,3,9,'#AA6705',1),(44,4,9,'#953B39',1),(45,5,9,'#545252',1),(46,6,9,'#87865D',1),(47,7,9,'#C71585',1),(48,8,9,'#006400',1),(49,1,10,'#17309A',1),(50,2,10,'#3A87AD',1),(51,3,10,'#AA6705',1),(52,4,10,'#953B39',1),(53,5,10,'#545252',1),(54,6,10,'#87865D',1),(55,7,10,'#C71585',1),(56,8,10,'#006400',1),(57,1,11,'#17309A',1),(58,2,11,'#3A87AD',1),(59,3,11,'#AA6705',1),(60,4,11,'#953B39',1),(61,5,11,'#545252',1),(62,6,11,'#87865D',1),(63,7,11,'#C71585',1),(64,8,11,'#006400',1),(65,1,12,'#17309A',1),(66,2,12,'#3A87AD',1),(67,3,12,'#AA6705',1),(68,4,12,'#953B39',1),(69,5,12,'#545252',1),(70,6,12,'#87865D',1),(71,7,12,'#C71585',1),(72,8,12,'#006400',1),(73,1,13,'#17309A',1),(74,2,13,'#3A87AD',1),(75,3,13,'#AA6705',1),(76,4,13,'#953B39',1),(77,5,13,'#545252',1),(78,6,13,'#87865D',1),(79,7,13,'#C71585',1),(80,8,13,'#006400',1);

--
-- Table structure for table `vtiger_calendar_user_activitytypes_seq`
--

CREATE TABLE `vtiger_calendar_user_activitytypes_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_calendar_user_activitytypes_seq`
--

INSERT INTO `vtiger_calendar_user_activitytypes_seq` VALUES (80);

--
-- Table structure for table `vtiger_calendarsharedtype`
--

CREATE TABLE `vtiger_calendarsharedtype` (
  `calendarsharedtypeid` int(11) NOT NULL AUTO_INCREMENT,
  `calendarsharedtype` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`calendarsharedtypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_calendarsharedtype`
--

INSERT INTO `vtiger_calendarsharedtype` VALUES (1,'public',0,1),(2,'private',1,1),(3,'seletedusers',2,1);

--
-- Table structure for table `vtiger_calendarsharedtype_seq`
--

CREATE TABLE `vtiger_calendarsharedtype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_calendarsharedtype_seq`
--

INSERT INTO `vtiger_calendarsharedtype_seq` VALUES (3);

--
-- Table structure for table `vtiger_callduration`
--

CREATE TABLE `vtiger_callduration` (
  `calldurationid` int(11) NOT NULL AUTO_INCREMENT,
  `callduration` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`calldurationid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_callduration`
--

INSERT INTO `vtiger_callduration` VALUES (1,'5',0,1),(2,'10',1,1),(3,'30',2,1),(4,'60',3,1),(5,'120',4,1);

--
-- Table structure for table `vtiger_callduration_seq`
--

CREATE TABLE `vtiger_callduration_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_callduration_seq`
--

INSERT INTO `vtiger_callduration_seq` VALUES (5);

--
-- Table structure for table `vtiger_campaign`
--

CREATE TABLE `vtiger_campaign` (
  `campaign_no` varchar(100) NOT NULL,
  `campaignname` varchar(255) DEFAULT NULL,
  `campaigntype` varchar(200) DEFAULT NULL,
  `campaignstatus` varchar(200) DEFAULT NULL,
  `expectedrevenue` decimal(25,8) DEFAULT NULL,
  `budgetcost` decimal(25,8) DEFAULT NULL,
  `actualcost` decimal(25,8) DEFAULT NULL,
  `expectedresponse` varchar(200) DEFAULT NULL,
  `numsent` decimal(11,0) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `sponsor` varchar(255) DEFAULT NULL,
  `targetaudience` varchar(255) DEFAULT NULL,
  `targetsize` int(11) DEFAULT NULL,
  `expectedresponsecount` int(11) DEFAULT NULL,
  `expectedsalescount` int(11) DEFAULT NULL,
  `expectedroi` decimal(25,8) DEFAULT NULL,
  `actualresponsecount` int(11) DEFAULT NULL,
  `actualsalescount` int(11) DEFAULT NULL,
  `actualroi` decimal(25,8) DEFAULT NULL,
  `campaignid` int(11) NOT NULL,
  `closingdate` date DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`campaignid`),
  KEY `campaign_campaignstatus_idx` (`campaignstatus`),
  KEY `campaign_campaignname_idx` (`campaignname`),
  KEY `campaign_campaignid_idx` (`campaignid`),
  CONSTRAINT `fk_crmid_vtiger_campaign` FOREIGN KEY (`campaignid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaign`
--


--
-- Table structure for table `vtiger_campaignaccountrel`
--

CREATE TABLE `vtiger_campaignaccountrel` (
  `campaignid` int(11) DEFAULT NULL,
  `accountid` int(11) DEFAULT NULL,
  `campaignrelstatusid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignaccountrel`
--


--
-- Table structure for table `vtiger_campaigncontrel`
--

CREATE TABLE `vtiger_campaigncontrel` (
  `campaignid` int(11) NOT NULL DEFAULT 0,
  `contactid` int(11) NOT NULL DEFAULT 0,
  `campaignrelstatusid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`campaignid`,`contactid`,`campaignrelstatusid`),
  KEY `campaigncontrel_contractid_idx` (`contactid`),
  CONSTRAINT `fk_2_vtiger_campaigncontrel` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaigncontrel`
--


--
-- Table structure for table `vtiger_campaignleadrel`
--

CREATE TABLE `vtiger_campaignleadrel` (
  `campaignid` int(11) NOT NULL DEFAULT 0,
  `leadid` int(11) NOT NULL DEFAULT 0,
  `campaignrelstatusid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`campaignid`,`leadid`,`campaignrelstatusid`),
  KEY `campaignleadrel_leadid_campaignid_idx` (`leadid`,`campaignid`),
  CONSTRAINT `fk_2_vtiger_campaignleadrel` FOREIGN KEY (`leadid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignleadrel`
--


--
-- Table structure for table `vtiger_campaignrelstatus`
--

CREATE TABLE `vtiger_campaignrelstatus` (
  `campaignrelstatusid` int(11) DEFAULT NULL,
  `campaignrelstatus` varchar(256) DEFAULT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignrelstatus`
--

INSERT INTO `vtiger_campaignrelstatus` VALUES (2,'Contacted - Successful',1,1,NULL),(3,'Contacted - Unsuccessful',2,1,NULL),(4,'Contacted - Never Contact Again',3,1,NULL);

--
-- Table structure for table `vtiger_campaignrelstatus_seq`
--

CREATE TABLE `vtiger_campaignrelstatus_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignrelstatus_seq`
--

INSERT INTO `vtiger_campaignrelstatus_seq` VALUES (4);

--
-- Table structure for table `vtiger_campaignscf`
--

CREATE TABLE `vtiger_campaignscf` (
  `campaignid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`campaignid`),
  CONSTRAINT `fk_1_vtiger_campaignscf` FOREIGN KEY (`campaignid`) REFERENCES `vtiger_campaign` (`campaignid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignscf`
--


--
-- Table structure for table `vtiger_campaignstatus`
--

CREATE TABLE `vtiger_campaignstatus` (
  `campaignstatusid` int(11) NOT NULL AUTO_INCREMENT,
  `campaignstatus` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`campaignstatusid`),
  KEY `campaignstatus_campaignstatus_idx` (`campaignstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignstatus`
--

INSERT INTO `vtiger_campaignstatus` VALUES (2,'Planning',1,15,1,NULL),(3,'Active',1,16,2,NULL),(4,'Inactive',1,17,3,NULL),(5,'Completed',1,18,4,NULL),(6,'Cancelled',1,19,5,NULL);

--
-- Table structure for table `vtiger_campaignstatus_seq`
--

CREATE TABLE `vtiger_campaignstatus_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaignstatus_seq`
--

INSERT INTO `vtiger_campaignstatus_seq` VALUES (6);

--
-- Table structure for table `vtiger_campaigntype`
--

CREATE TABLE `vtiger_campaigntype` (
  `campaigntypeid` int(11) NOT NULL AUTO_INCREMENT,
  `campaigntype` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`campaigntypeid`),
  UNIQUE KEY `campaigntype_campaigntype_idx` (`campaigntype`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaigntype`
--

INSERT INTO `vtiger_campaigntype` VALUES (2,'Conference',1,21,1,NULL),(3,'Webinar',1,22,2,NULL),(4,'Trade Show',1,23,3,NULL),(5,'Public Relations',1,24,4,NULL),(6,'Partners',1,25,5,NULL),(7,'Referral Program',1,26,6,NULL),(8,'Advertisement',1,27,7,NULL),(9,'Banner Ads',1,28,8,NULL),(10,'Direct Mail',1,29,9,NULL),(11,'Email',1,30,10,NULL),(12,'Telemarketing',1,31,11,NULL),(13,'Others',1,32,12,NULL);

--
-- Table structure for table `vtiger_campaigntype_seq`
--

CREATE TABLE `vtiger_campaigntype_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_campaigntype_seq`
--

INSERT INTO `vtiger_campaigntype_seq` VALUES (13);

--
-- Table structure for table `vtiger_carrier`
--

CREATE TABLE `vtiger_carrier` (
  `carrierid` int(11) NOT NULL AUTO_INCREMENT,
  `carrier` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`carrierid`),
  UNIQUE KEY `carrier_carrier_idx` (`carrier`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_carrier`
--

INSERT INTO `vtiger_carrier` VALUES (1,'FedEx',1,33,0,NULL),(2,'UPS',1,34,1,NULL),(3,'USPS',1,35,2,NULL),(4,'DHL',1,36,3,NULL),(5,'BlueDart',1,37,4,NULL);

--
-- Table structure for table `vtiger_carrier_seq`
--

CREATE TABLE `vtiger_carrier_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_carrier_seq`
--

INSERT INTO `vtiger_carrier_seq` VALUES (5);

--
-- Table structure for table `vtiger_cntactivityrel`
--

CREATE TABLE `vtiger_cntactivityrel` (
  `contactid` int(11) NOT NULL DEFAULT 0,
  `activityid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`contactid`,`activityid`),
  KEY `cntactivityrel_contactid_idx` (`contactid`),
  KEY `cntactivityrel_activityid_idx` (`activityid`),
  CONSTRAINT `fk_2_vtiger_cntactivityrel` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cntactivityrel`
--


--
-- Table structure for table `vtiger_contactaddress`
--

CREATE TABLE `vtiger_contactaddress` (
  `contactaddressid` int(11) NOT NULL DEFAULT 0,
  `mailingcity` varchar(40) DEFAULT NULL,
  `mailingstreet` varchar(250) DEFAULT NULL,
  `mailingcountry` varchar(40) DEFAULT NULL,
  `othercountry` varchar(30) DEFAULT NULL,
  `mailingstate` varchar(30) DEFAULT NULL,
  `mailingpobox` varchar(30) DEFAULT NULL,
  `othercity` varchar(40) DEFAULT NULL,
  `otherstate` varchar(50) DEFAULT NULL,
  `mailingzip` varchar(30) DEFAULT NULL,
  `otherzip` varchar(30) DEFAULT NULL,
  `otherstreet` varchar(250) DEFAULT NULL,
  `otherpobox` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`contactaddressid`),
  CONSTRAINT `fk_1_vtiger_contactaddress` FOREIGN KEY (`contactaddressid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contactaddress`
--

INSERT INTO `vtiger_contactaddress` VALUES (53,'','','','','','','','','','','',''),(66,'','','','','','','','','','','',''),(67,'Barquisimeto','Orinoco Av Capanaparo Transv 2 Casa 84 Fundalara\nFundalara','','','Lima','','','','3001','','Orinoco Av Capanaparo Transv 2 Casa 84 Fundalara\nFundalara',''),(68,'','','','','','','','','','','',''),(70,'','','','','','','','','','','',''),(71,'','','','','','','','','','','',''),(72,'Barquisimeto','Orinoco Av Capanaparo Transv 2 Casa 84 Fundalara\nFundalara','','','Lima','','','','3001','','Orinoco Av Capanaparo Transv 2 Casa 84 Fundalara\nFundalara',''),(73,'','','','','','','','','','','',''),(132,'','','','','','','','','','','',''),(198,'','','','','','','','','','','',''),(207,'','','','','','','','','','','',''),(409,'','','','','','','','','','','','');

--
-- Table structure for table `vtiger_contactdetails`
--

CREATE TABLE `vtiger_contactdetails` (
  `contactid` int(11) NOT NULL DEFAULT 0,
  `contact_no` varchar(100) NOT NULL,
  `accountid` int(11) DEFAULT NULL,
  `salutation` varchar(200) DEFAULT NULL,
  `firstname` varchar(40) DEFAULT NULL,
  `lastname` varchar(80) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `department` varchar(30) DEFAULT NULL,
  `fax` varchar(50) DEFAULT NULL,
  `reportsto` varchar(30) DEFAULT NULL,
  `training` varchar(50) DEFAULT NULL,
  `usertype` varchar(50) DEFAULT NULL,
  `contacttype` varchar(50) DEFAULT NULL,
  `otheremail` varchar(100) DEFAULT NULL,
  `secondaryemail` varchar(100) DEFAULT NULL,
  `donotcall` varchar(3) DEFAULT NULL,
  `emailoptout` varchar(3) DEFAULT '0',
  `imagename` varchar(150) DEFAULT NULL,
  `reference` varchar(3) DEFAULT NULL,
  `notify_owner` varchar(3) DEFAULT '0',
  `isconvertedfromlead` varchar(3) DEFAULT '0',
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`contactid`),
  KEY `contactdetails_accountid_idx` (`accountid`),
  KEY `email_idx` (`email`),
  CONSTRAINT `fk_1_vtiger_contactdetails` FOREIGN KEY (`contactid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contactdetails`
--

INSERT INTO `vtiger_contactdetails` VALUES (53,'CON000001',0,'','Christian Daniel','garcia','cgarcia@creantis.com','','','','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(66,'CON000002',0,'Mr.','Christian Daniel','garcia','chdgp1988@gmail.com','','','','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(67,'CON000003',0,'Mr.','Christian Daniel','garcia','chdgp1988@gmail.com','916168746','','','',NULL,'0',NULL,NULL,NULL,NULL,'cgarcia@creantis.com',NULL,'0','',NULL,'0','0',''),(68,'CON000004',0,'Mr.','Christian Daniel','garcia','chdgp1988@gmail.com','916168746','','','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(70,'CON000005',0,'','Kimssss','garcia','chdgp1988@gmail.com','','','','',NULL,'0',NULL,NULL,NULL,NULL,'cgarcia@creantis.com',NULL,'0','',NULL,'0','0',''),(71,'CON000006',0,'Mr.','Christian Daniel','feijoo valdivia','chdgp1988@gmail.com','916168746','','','',NULL,'0',NULL,NULL,NULL,NULL,'cgarcia@creantis.com',NULL,'0','',NULL,'0','0',''),(72,'CON000007',0,'Mr.','Kimssss','feijoo valdivia','chdgp1988@gmail.com','999 300 275','','','',NULL,'0',NULL,NULL,NULL,NULL,'chdgp1988@gmail.com',NULL,'0','',NULL,'0','0',''),(73,'CON000008',0,'Mr.','Kimssss','garcia','chdgp1988@gmail.com','916168746','','','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(132,'CON000009',2,'','Nuranne','JC','admin@mybluetechnology.com','9167412707','','','IT',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(198,'CON000010',2,'Prof.','creantis','admin','cgarcia@creantis.com','','','','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(207,'CON000011',16,'','Nuranne','Dayrkee','admin@mybluetechnology.com','9167412707','9167412707','Manager','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','',NULL,'0','0',''),(409,'CON000012',2,'','Dynamix','Support','dynamix@mybluetechnology.com','','','Support Management','',NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'0','Dynamix_Logo_2019.png',NULL,'0','0','');

--
-- Table structure for table `vtiger_contactscf`
--

CREATE TABLE `vtiger_contactscf` (
  `contactid` int(11) NOT NULL DEFAULT 0,
  `cf_867` varchar(100) DEFAULT '',
  PRIMARY KEY (`contactid`),
  CONSTRAINT `fk_1_vtiger_contactscf` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contactscf`
--

INSERT INTO `vtiger_contactscf` VALUES (53,''),(66,''),(67,''),(68,''),(70,''),(71,''),(72,''),(73,''),(132,''),(198,''),(207,''),(409,'Back of the House');

--
-- Table structure for table `vtiger_contactsubdetails`
--

CREATE TABLE `vtiger_contactsubdetails` (
  `contactsubscriptionid` int(11) NOT NULL DEFAULT 0,
  `homephone` varchar(50) DEFAULT NULL,
  `otherphone` varchar(50) DEFAULT NULL,
  `assistant` varchar(30) DEFAULT NULL,
  `assistantphone` varchar(50) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `laststayintouchrequest` int(11) DEFAULT 0,
  `laststayintouchsavedate` int(11) DEFAULT 0,
  `leadsource` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`contactsubscriptionid`),
  CONSTRAINT `fk_1_vtiger_contactsubdetails` FOREIGN KEY (`contactsubscriptionid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contactsubdetails`
--

INSERT INTO `vtiger_contactsubdetails` VALUES (53,'','',NULL,NULL,NULL,0,0,NULL),(66,'','',NULL,NULL,NULL,0,0,NULL),(67,'','',NULL,NULL,NULL,0,0,NULL),(68,'','',NULL,NULL,NULL,0,0,NULL),(70,'','',NULL,NULL,NULL,0,0,NULL),(71,'','',NULL,NULL,NULL,0,0,NULL),(72,'','',NULL,NULL,NULL,0,0,NULL),(73,'','',NULL,NULL,NULL,0,0,NULL),(132,'','',NULL,NULL,NULL,0,0,NULL),(198,'','',NULL,NULL,NULL,0,0,NULL),(207,'','',NULL,NULL,NULL,0,0,NULL),(409,'','',NULL,NULL,NULL,0,0,NULL);

--
-- Table structure for table `vtiger_contpotentialrel`
--

CREATE TABLE `vtiger_contpotentialrel` (
  `contactid` int(11) NOT NULL DEFAULT 0,
  `potentialid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`contactid`,`potentialid`),
  KEY `contpotentialrel_potentialid_idx` (`potentialid`),
  KEY `contpotentialrel_contactid_idx` (`contactid`),
  CONSTRAINT `fk_2_vtiger_contpotentialrel` FOREIGN KEY (`potentialid`) REFERENCES `vtiger_potential` (`potentialid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contpotentialrel`
--


--
-- Table structure for table `vtiger_contract_priority`
--

CREATE TABLE `vtiger_contract_priority` (
  `contract_priorityid` int(11) NOT NULL AUTO_INCREMENT,
  `contract_priority` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`contract_priorityid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_contract_priority`
--

INSERT INTO `vtiger_contract_priority` VALUES (1,'Low',1,220,1,NULL),(2,'Normal',1,221,2,NULL),(3,'High',1,222,3,NULL);

--
-- Table structure for table `vtiger_contract_priority_seq`
--

CREATE TABLE `vtiger_contract_priority_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contract_priority_seq`
--

INSERT INTO `vtiger_contract_priority_seq` VALUES (3);

--
-- Table structure for table `vtiger_contract_status`
--

CREATE TABLE `vtiger_contract_status` (
  `contract_statusid` int(11) NOT NULL AUTO_INCREMENT,
  `contract_status` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`contract_statusid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_contract_status`
--

INSERT INTO `vtiger_contract_status` VALUES (1,'Undefined',1,214,1,NULL),(2,'In Planning',1,215,2,NULL),(3,'In Progress',1,216,3,NULL),(4,'On Hold',1,217,4,NULL),(5,'Complete',0,218,5,NULL),(6,'Archived',1,219,6,NULL);

--
-- Table structure for table `vtiger_contract_status_seq`
--

CREATE TABLE `vtiger_contract_status_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contract_status_seq`
--

INSERT INTO `vtiger_contract_status_seq` VALUES (6);

--
-- Table structure for table `vtiger_contract_type`
--

CREATE TABLE `vtiger_contract_type` (
  `contract_typeid` int(11) NOT NULL AUTO_INCREMENT,
  `contract_type` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`contract_typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_contract_type`
--

INSERT INTO `vtiger_contract_type` VALUES (1,'Support',1,223,1,NULL),(2,'Services',1,224,2,NULL),(3,'Administrative',1,225,3,NULL);

--
-- Table structure for table `vtiger_contract_type_seq`
--

CREATE TABLE `vtiger_contract_type_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_contract_type_seq`
--

INSERT INTO `vtiger_contract_type_seq` VALUES (3);

--
-- Table structure for table `vtiger_convertleadmapping`
--

CREATE TABLE `vtiger_convertleadmapping` (
  `cfmid` int(11) NOT NULL AUTO_INCREMENT,
  `leadfid` int(11) NOT NULL,
  `accountfid` int(11) DEFAULT NULL,
  `contactfid` int(11) DEFAULT NULL,
  `potentialfid` int(11) DEFAULT NULL,
  `editable` int(11) DEFAULT 1,
  PRIMARY KEY (`cfmid`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_convertleadmapping`
--

INSERT INTO `vtiger_convertleadmapping` VALUES (1,43,1,0,110,0),(2,49,14,0,0,1),(3,40,3,69,0,1),(4,44,5,77,0,1),(5,52,13,0,0,1),(6,46,9,80,0,0),(7,48,4,0,0,1),(8,61,26,98,0,1),(9,60,30,0,0,1),(10,62,32,104,0,1),(11,63,28,100,0,1),(12,59,24,96,0,1),(13,64,34,106,0,1),(14,61,27,0,0,1),(15,60,31,0,0,1),(16,62,33,0,0,1),(17,63,29,0,0,1),(18,59,25,0,0,1),(19,64,35,0,0,1),(20,65,36,109,125,1),(21,37,0,66,0,1),(22,38,0,67,0,0),(23,41,0,70,0,0),(24,42,0,71,0,1),(25,45,0,76,0,1),(26,55,0,83,0,1),(27,47,0,74,117,1),(28,50,0,0,0,1),(29,53,10,0,0,1),(30,51,17,0,0,1);

--
-- Table structure for table `vtiger_convertpotentialmapping`
--

CREATE TABLE `vtiger_convertpotentialmapping` (
  `cfmid` int(11) NOT NULL AUTO_INCREMENT,
  `potentialfid` int(11) NOT NULL,
  `projectfid` int(11) DEFAULT NULL,
  `editable` int(11) DEFAULT 1,
  PRIMARY KEY (`cfmid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_convertpotentialmapping`
--

INSERT INTO `vtiger_convertpotentialmapping` VALUES (1,110,648,NULL),(2,125,664,NULL);

--
-- Table structure for table `vtiger_crmentity`
--

CREATE TABLE `vtiger_crmentity` (
  `crmid` int(11) NOT NULL,
  `smcreatorid` int(11) NOT NULL DEFAULT 0,
  `smownerid` int(11) NOT NULL DEFAULT 0,
  `modifiedby` int(11) NOT NULL DEFAULT 0,
  `setype` varchar(100) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `createdtime` datetime NOT NULL,
  `modifiedtime` datetime NOT NULL,
  `viewedtime` datetime DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `version` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) DEFAULT 1,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `smgroupid` int(11) DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`crmid`),
  KEY `crmentity_smcreatorid_idx` (`smcreatorid`),
  KEY `crmentity_modifiedby_idx` (`modifiedby`),
  KEY `crmentity_deleted_idx` (`deleted`),
  KEY `crm_ownerid_del_setype_idx` (`smownerid`,`deleted`,`setype`),
  KEY `vtiger_crmentity_labelidx` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmentity`
--



--
-- Table structure for table `vtiger_crmentity_seq`
--

CREATE TABLE `vtiger_crmentity_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmentity_seq`
--

INSERT INTO `vtiger_crmentity_seq` VALUES (464);

--
-- Table structure for table `vtiger_crmentity_user_field`
--

CREATE TABLE `vtiger_crmentity_user_field` (
  `recordid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `starred` varchar(100) DEFAULT NULL,
  KEY `record_user_idx` (`recordid`,`userid`),
  CONSTRAINT `fk_vtiger_crmentity_user_field_recordid` FOREIGN KEY (`recordid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_crmentity_user_field`
--

INSERT INTO `vtiger_crmentity_user_field` VALUES (2,1,'0'),(3,1,'0'),(4,1,'0'),(5,1,'0'),(6,1,'0'),(7,1,'0'),(8,1,'0'),(9,1,'0'),(10,1,'0'),(11,1,'0'),(12,1,'0'),(13,1,'0'),(14,1,'0'),(15,1,'0'),(16,1,'0'),(17,1,'0'),(18,1,'0'),(19,1,'0'),(20,1,'0'),(21,1,'0'),(22,1,'0'),(23,1,'0'),(24,1,'0'),(25,1,'0'),(26,1,'0'),(27,1,'0'),(28,1,'0'),(29,1,'0'),(30,1,'0'),(31,1,'0'),(32,1,'0'),(33,1,'0'),(34,1,'0'),(35,1,'0'),(36,1,'0'),(37,1,'0'),(38,1,'0'),(39,1,'0'),(40,6,'1'),(44,6,'0'),(45,6,'0'),(51,1,'0'),(52,1,'0'),(53,1,'0'),(54,1,'0'),(55,1,'0'),(56,1,'0'),(57,1,'0'),(58,1,'0'),(59,1,'0'),(60,1,'0'),(61,1,'0'),(62,1,'0'),(63,1,'0'),(64,1,'0'),(65,1,'0'),(66,1,'0'),(67,1,'0'),(68,1,'0'),(69,1,'0'),(70,1,'0'),(71,1,'0'),(72,1,'0'),(73,1,'0'),(51,6,'1'),(36,6,'1'),(38,6,'1'),(74,6,'0'),(75,6,'0'),(76,6,'0'),(77,6,'0'),(78,6,'0'),(79,6,'0'),(80,6,'0'),(81,6,'0'),(82,6,'0'),(83,6,'0'),(84,6,'0'),(85,6,'0'),(86,6,'0'),(87,6,'0'),(88,6,'0'),(89,6,'0'),(90,6,'0'),(91,6,'0'),(92,6,'0'),(93,6,'0'),(94,6,'0'),(95,6,'0'),(96,6,'0'),(97,6,'0'),(98,6,'0'),(99,6,'0'),(100,6,'0'),(101,6,'0'),(102,6,'0'),(103,6,'0'),(104,6,'0'),(105,6,'0'),(106,6,'0'),(107,6,'0'),(108,6,'0'),(109,6,'0'),(110,6,'0'),(111,6,'0'),(112,6,'0'),(113,6,'0'),(114,6,'0'),(115,6,'0'),(116,6,'0'),(117,6,'0'),(118,6,'0'),(119,6,'0'),(120,6,'0'),(121,6,'0'),(122,6,'0'),(123,6,'0'),(124,6,'0'),(125,6,'0'),(126,6,'0'),(127,6,'0'),(128,6,'0'),(129,6,'0'),(130,6,'0'),(131,6,'0'),(15,6,'0'),(11,6,'0'),(27,6,'0'),(7,6,'0'),(32,6,'0'),(23,6,'0'),(10,6,'0'),(16,6,'0'),(6,6,'0'),(26,6,'0'),(9,6,'0'),(22,6,'0'),(25,6,'0'),(34,6,'0'),(5,6,'0'),(8,6,'0'),(24,6,'0'),(18,6,'0'),(21,6,'0'),(4,6,'0'),(12,6,'0'),(13,6,'0'),(14,6,'0'),(17,6,'0'),(19,6,'0'),(20,6,'0'),(2,6,'0'),(131,1,'0'),(132,6,'0'),(133,1,'0'),(134,1,'0'),(135,1,'0'),(136,1,'0'),(137,1,'0'),(138,1,'0'),(139,1,'0'),(140,1,'0'),(141,1,'0'),(142,1,'0'),(143,1,'0'),(144,1,'0'),(145,1,'0'),(146,1,'0'),(147,1,'0'),(148,1,'0'),(149,1,'0'),(150,1,'0'),(151,1,'0'),(152,1,'0'),(153,1,'0'),(154,1,'0'),(155,1,'0'),(156,1,'0'),(157,1,'0'),(158,1,'0'),(159,1,'0'),(160,1,'0'),(161,1,'0'),(162,1,'0'),(163,1,'0'),(164,1,'0'),(165,1,'0'),(166,1,'0'),(167,1,'0'),(168,1,'0'),(169,1,'0'),(170,1,'0'),(171,1,'0'),(172,1,'0'),(173,1,'0'),(174,1,'0'),(175,1,'0'),(176,1,'0'),(177,1,'0'),(178,1,'0'),(179,1,'0'),(180,1,'0'),(181,1,'0'),(182,1,'0'),(183,1,'0'),(184,1,'0'),(185,1,'0'),(186,1,'0'),(187,1,'0'),(188,1,'0'),(189,1,'0'),(190,1,'0'),(191,1,'0'),(192,1,'0'),(193,1,'0'),(194,1,'0'),(195,1,'0'),(132,1,'0'),(197,1,'0'),(198,1,'0'),(199,1,'0'),(130,1,'0'),(200,1,'0'),(201,1,'0'),(202,1,'0'),(198,6,'0'),(203,1,'0'),(200,6,'0'),(204,1,'0'),(205,1,'0'),(206,1,'0'),(207,6,'0'),(208,1,'0'),(209,1,'0'),(210,1,'0'),(211,1,'0'),(212,1,'0'),(213,1,'0'),(214,1,'0'),(215,1,'0'),(216,1,'0'),(217,1,'0'),(218,6,'0'),(219,1,'0'),(220,6,'0'),(221,1,'0'),(222,6,'0'),(223,6,'0'),(224,1,'0'),(225,1,'0'),(226,1,'0'),(227,6,'0'),(228,6,'0'),(229,1,'0'),(230,1,'0'),(231,6,'0'),(232,6,'0'),(233,6,'0'),(234,6,'0'),(235,1,'0'),(236,1,'0'),(237,1,'0'),(238,1,'0'),(239,1,'0'),(240,1,'0'),(241,1,'0'),(242,1,'0'),(243,1,'0'),(244,6,'0'),(245,6,'0'),(246,1,'0'),(247,1,'0'),(248,6,'0'),(249,1,'0'),(250,6,'0'),(251,1,'0'),(252,6,'0'),(253,6,'0'),(254,1,'0'),(255,1,'0'),(256,6,'0'),(257,6,'0'),(258,1,'0'),(259,1,'0'),(260,1,'0'),(261,1,'0'),(262,1,'0'),(263,6,'0'),(264,1,'0'),(265,1,'0'),(266,6,'0'),(267,6,'0'),(268,1,'0'),(269,1,'0'),(270,1,'0'),(271,6,'0'),(272,6,'0'),(273,1,'0'),(274,1,'0'),(275,6,'0'),(276,1,'0'),(277,6,'0'),(278,1,'0'),(279,1,'0'),(280,1,'0'),(281,1,'0'),(282,1,'0'),(283,1,'0'),(284,1,'0'),(285,6,'0'),(286,1,'0'),(287,1,'0'),(288,1,'0'),(289,1,'0'),(290,1,'0'),(291,1,'0'),(292,1,'0'),(293,6,'0'),(294,1,'0'),(295,6,'0'),(296,1,'0'),(128,1,'0'),(290,6,'0'),(297,1,'0'),(298,1,'0'),(299,1,'0'),(300,1,'0'),(301,1,'0'),(302,1,'0'),(303,1,'0'),(304,1,'0'),(305,1,'0'),(306,1,'0'),(307,1,'0'),(308,1,'0'),(309,1,'0'),(310,1,'0'),(311,1,'0'),(312,1,'0'),(313,6,'0'),(314,1,'0'),(315,1,'0'),(316,1,'0'),(317,1,'0'),(318,1,'0'),(319,1,'0'),(320,1,'0'),(321,1,'0'),(322,1,'0'),(323,1,'0'),(324,1,'0'),(325,1,'0'),(326,1,'0'),(327,1,'0'),(328,1,'0'),(329,1,'0'),(330,1,'0'),(331,1,'0'),(332,1,'0'),(333,1,'0'),(334,1,'0'),(335,1,'0'),(336,1,'0'),(337,1,'0'),(338,1,'0'),(339,1,'0'),(340,1,'0'),(341,1,'0'),(342,1,'0'),(343,1,'0'),(344,1,'0'),(345,1,'0'),(346,1,'0'),(349,1,'0'),(350,1,'0'),(351,1,'0'),(352,1,'0'),(353,1,'0'),(354,1,'0'),(355,1,'0'),(356,1,'0'),(357,1,'0'),(358,1,'0'),(359,6,'0'),(360,1,'0'),(365,6,'0'),(366,1,'0'),(367,6,'0'),(369,1,'0'),(370,1,'0'),(371,6,'0'),(372,1,'0'),(375,6,'0'),(379,1,'0'),(380,6,'0'),(384,1,'0'),(385,6,'0'),(386,1,'0'),(387,6,'0'),(388,1,'0'),(389,1,'0'),(390,1,'0'),(391,6,'0'),(392,1,'0'),(393,1,'0'),(394,6,'0'),(395,1,'0'),(396,6,'0'),(397,1,'0'),(398,1,'0'),(399,1,'0'),(367,10,'0'),(400,1,'0'),(401,6,'0'),(402,1,'0'),(359,10,'0'),(406,1,'0'),(407,1,'0'),(401,5,'0'),(408,1,'0'),(409,6,'0'),(411,1,'0'),(271,5,'0'),(375,5,'0'),(385,5,'0'),(380,5,'0'),(412,1,'0'),(413,1,'0'),(414,1,'0'),(415,1,'0'),(121,5,'0'),(416,1,'0'),(365,5,'0'),(417,1,'0'),(371,5,'0'),(418,1,'0'),(391,5,'0'),(419,1,'0'),(420,6,'0'),(421,1,'0'),(422,6,'0'),(423,1,'0'),(422,10,'0'),(424,1,'0'),(425,1,'0'),(110,5,'0'),(426,1,'0'),(118,5,'0'),(427,1,'0'),(94,5,'0'),(112,5,'0'),(428,1,'0'),(429,1,'0'),(96,5,'0'),(87,5,'0'),(277,5,'0'),(430,1,'0'),(431,1,'0'),(432,1,'0'),(275,5,'0'),(433,1,'0'),(267,5,'0'),(266,5,'0'),(263,5,'0'),(131,5,'0'),(434,1,'0'),(435,1,'0'),(436,1,'0'),(437,1,'0'),(115,5,'0'),(109,5,'0'),(438,1,'0'),(439,1,'0'),(108,5,'0'),(85,5,'0'),(440,1,'0'),(441,1,'0'),(84,5,'0'),(76,5,'0'),(442,1,'0'),(443,1,'0'),(74,5,'0'),(444,1,'0'),(420,9,'0'),(445,1,'0'),(446,1,'0'),(447,6,'0'),(448,1,'0'),(449,6,'0'),(450,6,'0'),(447,5,'0'),(451,1,'0'),(452,1,'0'),(452,6,'0'),(453,6,'0'),(454,1,'0'),(455,1,'0'),(456,1,'0'),(457,1,'0'),(464,1,'0');

--
-- Table structure for table `vtiger_crmentityrel`
--

CREATE TABLE `vtiger_crmentityrel` (
  `crmid` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `relcrmid` int(11) NOT NULL,
  `relmodule` varchar(100) NOT NULL,
  KEY `crmid_idx` (`crmid`),
  KEY `relcrmid_idx` (`relcrmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmentityrel`
--

INSERT INTO `vtiger_crmentityrel` VALUES (38,'HelpDesk',39,'ServiceContracts'),(53,'Contacts',54,'Emails'),(36,'HelpDesk',55,'Emails'),(38,'HelpDesk',56,'Emails'),(40,'HelpDesk',57,'Emails'),(40,'HelpDesk',58,'Emails'),(51,'HelpDesk',59,'Emails'),(53,'Contacts',60,'Emails'),(53,'Contacts',61,'Emails'),(53,'Contacts',62,'Emails'),(53,'Contacts',63,'Emails'),(53,'Contacts',64,'Emails'),(53,'Contacts',65,'Emails'),(68,'Contacts',69,'Emails'),(74,'HelpDesk',133,'Emails'),(76,'HelpDesk',134,'Emails'),(77,'HelpDesk',135,'Emails'),(78,'HelpDesk',136,'Emails'),(79,'HelpDesk',137,'Emails'),(80,'HelpDesk',138,'Emails'),(81,'HelpDesk',139,'Emails'),(82,'HelpDesk',140,'Emails'),(83,'HelpDesk',141,'Emails'),(84,'HelpDesk',142,'Emails'),(84,'HelpDesk',143,'Emails'),(85,'HelpDesk',144,'Emails'),(86,'HelpDesk',145,'Emails'),(87,'HelpDesk',146,'Emails'),(88,'HelpDesk',147,'Emails'),(89,'HelpDesk',148,'Emails'),(90,'HelpDesk',149,'Emails'),(91,'HelpDesk',150,'Emails'),(92,'HelpDesk',151,'Emails'),(93,'HelpDesk',152,'Emails'),(94,'HelpDesk',153,'Emails'),(95,'HelpDesk',154,'Emails'),(96,'HelpDesk',155,'Emails'),(97,'HelpDesk',156,'Emails'),(98,'HelpDesk',157,'Emails'),(99,'HelpDesk',158,'Emails'),(100,'HelpDesk',159,'Emails'),(101,'HelpDesk',160,'Emails'),(102,'HelpDesk',161,'Emails'),(103,'HelpDesk',162,'Emails'),(104,'HelpDesk',163,'Emails'),(105,'HelpDesk',164,'Emails'),(106,'HelpDesk',165,'Emails'),(107,'HelpDesk',166,'Emails'),(108,'HelpDesk',167,'Emails'),(109,'HelpDesk',168,'Emails'),(110,'HelpDesk',169,'Emails'),(111,'HelpDesk',170,'Emails'),(112,'HelpDesk',171,'Emails'),(113,'HelpDesk',172,'Emails'),(114,'HelpDesk',173,'Emails'),(115,'HelpDesk',174,'Emails'),(115,'HelpDesk',175,'Emails'),(116,'HelpDesk',176,'Emails'),(117,'HelpDesk',177,'Emails'),(118,'HelpDesk',178,'Emails'),(119,'HelpDesk',179,'Emails'),(120,'HelpDesk',180,'Emails'),(121,'HelpDesk',181,'Emails'),(122,'HelpDesk',182,'Emails'),(123,'HelpDesk',183,'Emails'),(124,'HelpDesk',184,'Emails'),(125,'HelpDesk',185,'Emails'),(126,'HelpDesk',186,'Emails'),(127,'HelpDesk',187,'Emails'),(128,'HelpDesk',188,'Emails'),(129,'HelpDesk',189,'Emails'),(130,'HelpDesk',190,'Emails'),(131,'HelpDesk',191,'Emails'),(131,'HelpDesk',192,'Emails'),(131,'HelpDesk',193,'Emails'),(132,'Contacts',194,'Emails'),(73,'Contacts',195,'Emails'),(132,'Contacts',197,'Emails'),(198,'Contacts',199,'Emails'),(200,'HelpDesk',201,'Emails'),(200,'HelpDesk',202,'Emails'),(198,'Contacts',203,'Emails'),(200,'HelpDesk',204,'Emails'),(200,'HelpDesk',205,'Emails'),(200,'HelpDesk',206,'Emails'),(207,'Contacts',208,'Emails'),(207,'Contacts',209,'Emails'),(207,'Contacts',210,'Emails'),(207,'Contacts',211,'Emails'),(131,'HelpDesk',212,'Emails'),(127,'HelpDesk',213,'Emails'),(128,'HelpDesk',214,'Emails'),(130,'HelpDesk',215,'Emails'),(130,'HelpDesk',216,'Emails'),(128,'HelpDesk',217,'Emails'),(218,'HelpDesk',219,'Emails'),(220,'HelpDesk',221,'Emails'),(222,'HelpDesk',224,'Emails'),(223,'HelpDesk',225,'Emails'),(222,'HelpDesk',226,'Emails'),(227,'HelpDesk',229,'Emails'),(228,'HelpDesk',230,'Emails'),(231,'HelpDesk',235,'Emails'),(232,'HelpDesk',236,'Emails'),(233,'HelpDesk',237,'Emails'),(234,'HelpDesk',238,'Emails'),(227,'HelpDesk',239,'Emails'),(231,'HelpDesk',240,'Emails'),(232,'HelpDesk',241,'Emails'),(228,'HelpDesk',242,'Emails'),(234,'HelpDesk',243,'Emails'),(244,'HelpDesk',246,'Emails'),(245,'HelpDesk',247,'Emails'),(248,'HelpDesk',249,'Emails'),(250,'HelpDesk',251,'Emails'),(252,'HelpDesk',254,'Emails'),(253,'HelpDesk',255,'Emails'),(252,'HelpDesk',258,'Emails'),(253,'HelpDesk',259,'Emails'),(256,'HelpDesk',260,'Emails'),(257,'HelpDesk',261,'Emails'),(257,'HelpDesk',262,'Emails'),(263,'HelpDesk',264,'Emails'),(263,'HelpDesk',265,'Emails'),(266,'HelpDesk',268,'Emails'),(266,'HelpDesk',269,'Emails'),(267,'HelpDesk',270,'Emails'),(271,'HelpDesk',273,'Emails'),(272,'HelpDesk',274,'Emails'),(275,'HelpDesk',276,'Emails'),(277,'HelpDesk',278,'Emails'),(87,'HelpDesk',279,'Emails'),(91,'HelpDesk',280,'Emails'),(87,'HelpDesk',281,'Emails'),(96,'HelpDesk',282,'Emails'),(93,'HelpDesk',283,'Emails'),(94,'HelpDesk',284,'Emails'),(285,'HelpDesk',286,'Emails'),(287,'HelpDesk',288,'Emails'),(287,'HelpDesk',289,'Emails'),(290,'HelpDesk',291,'Emails'),(290,'HelpDesk',292,'Emails'),(293,'HelpDesk',294,'Emails'),(295,'HelpDesk',296,'Emails'),(290,'HelpDesk',297,'Emails'),(290,'HelpDesk',298,'Emails'),(290,'HelpDesk',299,'Emails'),(290,'HelpDesk',300,'Emails'),(290,'HelpDesk',301,'Emails'),(290,'HelpDesk',302,'Emails'),(290,'HelpDesk',303,'Emails'),(290,'HelpDesk',304,'Emails'),(290,'HelpDesk',305,'Emails'),(290,'HelpDesk',306,'Emails'),(290,'HelpDesk',307,'Emails'),(290,'HelpDesk',308,'Emails'),(290,'HelpDesk',309,'Emails'),(290,'HelpDesk',310,'Emails'),(290,'HelpDesk',311,'Emails'),(290,'HelpDesk',312,'Emails'),(290,'HelpDesk',314,'Emails'),(116,'HelpDesk',316,'Emails'),(116,'HelpDesk',317,'Emails'),(130,'HelpDesk',318,'Emails'),(128,'HelpDesk',319,'Emails'),(295,'HelpDesk',320,'Emails'),(198,'Contacts',321,'Emails'),(290,'HelpDesk',322,'Emails'),(290,'HelpDesk',323,'Emails'),(290,'HelpDesk',324,'Emails'),(290,'HelpDesk',325,'Emails'),(290,'HelpDesk',326,'Emails'),(290,'HelpDesk',327,'Emails'),(290,'HelpDesk',328,'Emails'),(290,'HelpDesk',329,'Emails'),(198,'Contacts',330,'Emails'),(198,'Contacts',331,'Emails'),(290,'HelpDesk',332,'Emails'),(290,'HelpDesk',333,'Emails'),(290,'HelpDesk',334,'Emails'),(290,'HelpDesk',335,'Emails'),(290,'HelpDesk',336,'Emails'),(290,'HelpDesk',337,'Emails'),(290,'HelpDesk',338,'Emails'),(290,'HelpDesk',339,'Emails'),(290,'HelpDesk',340,'Emails'),(290,'HelpDesk',341,'Emails'),(290,'HelpDesk',342,'Emails'),(290,'HelpDesk',343,'Emails'),(344,'HelpDesk',345,'Emails'),(344,'HelpDesk',346,'Emails'),(293,'HelpDesk',349,'Emails'),(293,'HelpDesk',350,'Emails'),(112,'HelpDesk',351,'Emails'),(118,'HelpDesk',352,'Emails'),(272,'HelpDesk',353,'Emails'),(110,'HelpDesk',354,'Emails'),(121,'HelpDesk',355,'Emails'),(233,'HelpDesk',356,'Emails'),(285,'HelpDesk',357,'Emails'),(119,'HelpDesk',358,'Emails'),(359,'HelpDesk',360,'Emails'),(365,'HelpDesk',366,'Emails'),(367,'HelpDesk',369,'Emails'),(367,'HelpDesk',370,'Emails'),(371,'HelpDesk',372,'Emails'),(375,'HelpDesk',379,'Emails'),(380,'HelpDesk',384,'Emails'),(385,'HelpDesk',386,'Emails'),(272,'HelpDesk',388,'Emails'),(387,'HelpDesk',389,'Emails'),(371,'HelpDesk',390,'Emails'),(371,'HelpDesk',392,'Emails'),(391,'HelpDesk',393,'Emails'),(394,'HelpDesk',395,'Emails'),(396,'HelpDesk',397,'Emails'),(271,'HelpDesk',398,'Emails'),(394,'HelpDesk',399,'Emails'),(367,'HelpDesk',400,'Emails'),(401,'HelpDesk',402,'Emails'),(359,'HelpDesk',406,'Emails'),(367,'HelpDesk',407,'Emails'),(401,'HelpDesk',408,'Emails'),(409,'Contacts',411,'Emails'),(271,'HelpDesk',412,'Emails'),(375,'HelpDesk',413,'Emails'),(385,'HelpDesk',414,'Emails'),(380,'HelpDesk',415,'Emails'),(121,'HelpDesk',416,'Emails'),(385,'HelpDesk',417,'Emails'),(371,'HelpDesk',418,'Emails'),(391,'HelpDesk',419,'Emails'),(420,'HelpDesk',421,'Emails'),(422,'HelpDesk',423,'Emails'),(422,'HelpDesk',424,'Emails'),(422,'HelpDesk',425,'Emails'),(110,'HelpDesk',426,'Emails'),(118,'HelpDesk',427,'Emails'),(94,'HelpDesk',428,'Emails'),(112,'HelpDesk',429,'Emails'),(96,'HelpDesk',430,'Emails'),(87,'HelpDesk',431,'Emails'),(277,'HelpDesk',432,'Emails'),(275,'HelpDesk',433,'Emails'),(267,'HelpDesk',434,'Emails'),(266,'HelpDesk',435,'Emails'),(263,'HelpDesk',436,'Emails'),(131,'HelpDesk',437,'Emails'),(115,'HelpDesk',438,'Emails'),(109,'HelpDesk',439,'Emails'),(108,'HelpDesk',440,'Emails'),(85,'HelpDesk',441,'Emails'),(84,'HelpDesk',442,'Emails'),(76,'HelpDesk',443,'Emails'),(74,'HelpDesk',444,'Emails'),(420,'HelpDesk',445,'Emails'),(409,'Contacts',446,'Emails'),(447,'HelpDesk',448,'Emails'),(447,'HelpDesk',451,'Emails'),(452,'HelpDesk',454,'Emails'),(452,'HelpDesk',455,'Emails'),(452,'HelpDesk',456,'Emails'),(453,'HelpDesk',457,'Emails'),(452,'HelpDesk',464,'Emails');

--
-- Table structure for table `vtiger_crmsetup`
--

CREATE TABLE `vtiger_crmsetup` (
  `userid` int(11) DEFAULT NULL,
  `setup_status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_crmsetup`
--

INSERT INTO `vtiger_crmsetup` VALUES (1,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(13,1),(12,1);

--
-- Table structure for table `vtiger_cron_task`
--

CREATE TABLE `vtiger_cron_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `handler_file` varchar(100) DEFAULT NULL,
  `frequency` int(11) DEFAULT NULL,
  `laststart` int(10) unsigned DEFAULT NULL,
  `lastend` int(10) unsigned DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `module` varchar(100) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `handler_file` (`handler_file`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cron_task`
--

INSERT INTO `vtiger_cron_task` VALUES (1,'Workflow','cron/modules/com_vtiger_workflow/com_vtiger_workflow.service',900,1685457361,1685457361,1,'com_vtiger_workflow',1,'Recommended frequency for Workflow is 15 mins'),(2,'RecurringInvoice','cron/modules/SalesOrder/RecurringInvoice.service',43200,1681528442,1681528442,0,'SalesOrder',2,'Recommended frequency for RecurringInvoice is 12 hours'),(3,'SendReminder','cron/SendReminder.service',900,1685456642,1685456642,1,'Calendar',3,'Recommended frequency for SendReminder is 15 mins'),(5,'MailScanner','cron/MailScanner.service',900,1685456642,0,2,'Settings',5,'Recommended frequency for MailScanner is 15 mins'),(7,'ScheduleReports','cron/modules/Reports/ScheduleReports.service',900,1685457121,1685457121,1,'Reports',7,'Recommended frequency for ScheduleReports is 15 mins'),(9,'Scheduled Import','cron/modules/Import/ScheduledImport.service',900,NULL,NULL,0,'Import',8,'Recommended frequency for MailScanner is 15 mins');

--
-- Table structure for table `vtiger_currencies`
--

CREATE TABLE `vtiger_currencies` (
  `currencyid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(200) DEFAULT NULL,
  `currency_code` varchar(50) DEFAULT NULL,
  `currency_symbol` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`currencyid`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currencies`
--

INSERT INTO `vtiger_currencies` VALUES (1,'Albania, Leke','ALL','Lek'),(2,'Argentina, Pesos','ARS','$'),(3,'Aruba, Guilders','AWG','ƒ'),(4,'Australia, Dollars','AUD','$'),(5,'Azerbaijan, New Manats','AZN','ман'),(6,'Bahamas, Dollars','BSD','$'),(7,'Bahrain, Dinar','BHD','BD'),(8,'Barbados, Dollars','BBD','$'),(9,'Belarus, Rubles','BYR','p.'),(10,'Belize, Dollars','BZD','BZ$'),(11,'Bermuda, Dollars','BMD','$'),(12,'Bolivia, Bolivianos','BOB','$b'),(13,'China, Yuan Renminbi','CNY','¥'),(14,'Convertible Marka','BAM','KM'),(15,'Botswana, Pulas','BWP','P'),(16,'Bulgaria, Leva','BGN','лв'),(17,'Brazil, Reais','BRL','R$'),(18,'Great Britain Pounds','GBP','£'),(19,'Brunei Darussalam, Dollars','BND','$'),(20,'Canada, Dollars','CAD','$'),(21,'Cayman Islands, Dollars','KYD','$'),(22,'Chile, Pesos','CLP','$'),(23,'Colombia, Pesos','COP','$'),(24,'Costa Rica, Colón','CRC','₡'),(25,'Croatia, Kuna','HRK','kn'),(26,'Cuba, Pesos','CUP','₱'),(27,'Czech Republic, Koruny','CZK','Kč'),(28,'Cyprus, Pounds','CYP','£'),(29,'Denmark, Kroner','DKK','kr'),(30,'Dominican Republic, Pesos','DOP','RD$'),(31,'East Caribbean, Dollars','XCD','$'),(32,'Egypt, Pounds','EGP','E£'),(33,'El Salvador, Colón','SVC','₡'),(34,'England, Pounds','GBP','£'),(35,'Estonia, Krooni','EEK','kr'),(36,'Euro','EUR','€'),(37,'Falkland Islands, Pounds','FKP','£'),(38,'Fiji, Dollars','FJD','$'),(39,'Ghana, Cedis','GHC','¢'),(40,'Gibraltar, Pounds','GIP','£'),(41,'Guatemala, Quetzales','GTQ','Q'),(42,'Guernsey, Pounds','GGP','£'),(43,'Guyana, Dollars','GYD','$'),(44,'Honduras, Lempiras','HNL','L'),(45,'Hong Kong, Dollars','HKD','HK$'),(46,'Hungary, Forint','HUF','Ft'),(47,'Iceland, Krona','ISK','kr'),(48,'India, Rupees','INR','₹'),(49,'Indonesia, Rupiahs','IDR','Rp'),(50,'Iran, Rials','IRR','﷼'),(51,'Isle of Man, Pounds','IMP','£'),(52,'Israel, New Shekels','ILS','₪'),(53,'Jamaica, Dollars','JMD','J$'),(54,'Japan, Yen','JPY','¥'),(55,'Jersey, Pounds','JEP','£'),(56,'Jordan, Dinar','JOD','JOD'),(57,'Kazakhstan, Tenge','KZT','〒'),(58,'Kenya, Shilling','KES','KES'),(59,'Korea (North), Won','KPW','₩'),(60,'Korea (South), Won','KRW','₩'),(61,'Kuwait, Dinar','KWD','KWD'),(62,'Kyrgyzstan, Soms','KGS','лв'),(63,'Laos, Kips','LAK','₭'),(64,'Latvia, Lati','LVL','Ls'),(65,'Lebanon, Pounds','LBP','£'),(66,'Liberia, Dollars','LRD','$'),(67,'Switzerland Francs','CHF','CHF'),(68,'Lithuania, Litai','LTL','Lt'),(69,'MADAGASCAR, Malagasy Ariary','MGA','MGA'),(70,'Macedonia, Denars','MKD','ден'),(71,'Malaysia, Ringgits','MYR','RM'),(72,'Malta, Liri','MTL','₤'),(73,'Mauritius, Rupees','MUR','₨'),(74,'Mexico, Pesos','MXN','$'),(75,'Mongolia, Tugriks','MNT','₮'),(76,'Mozambique, Meticais','MZN','MT'),(77,'Namibia, Dollars','NAD','$'),(78,'Nepal, Rupees','NPR','₨'),(79,'Netherlands Antilles, Guilders','ANG','ƒ'),(80,'New Zealand, Dollars','NZD','$'),(81,'Nicaragua, Cordobas','NIO','C$'),(82,'Nigeria, Nairas','NGN','₦'),(83,'North Korea, Won','KPW','₩'),(84,'Norway, Krone','NOK','kr'),(85,'Oman, Rials','OMR','﷼'),(86,'Pakistan, Rupees','PKR','₨'),(87,'Panama, Balboa','PAB','B/.'),(88,'Paraguay, Guarani','PYG','Gs'),(89,'Peru, Nuevos Soles','PEN','S/.'),(90,'Philippines, Pesos','PHP','Php'),(91,'Poland, Zlotych','PLN','zł'),(92,'Qatar, Rials','QAR','﷼'),(93,'Romania, New Lei','RON','lei'),(94,'Russia, Rubles','RUB','руб'),(95,'Saint Helena, Pounds','SHP','£'),(96,'Saudi Arabia, Riyals','SAR','﷼'),(97,'Serbia, Dinars','RSD','Дин.'),(98,'Seychelles, Rupees','SCR','₨'),(99,'Singapore, Dollars','SGD','$'),(100,'Solomon Islands, Dollars','SBD','$'),(101,'Somalia, Shillings','SOS','S'),(102,'South Africa, Rand','ZAR','R'),(103,'South Korea, Won','KRW','₩'),(104,'Sri Lanka, Rupees','LKR','₨'),(105,'Sweden, Kronor','SEK','kr'),(106,'Switzerland, Francs','CHF','CHF'),(107,'Suriname, Dollars','SRD','$'),(108,'Syria, Pounds','SYP','£'),(109,'Taiwan, New Dollars','TWD','NT$'),(110,'Thailand, Baht','THB','฿'),(111,'Trinidad and Tobago, Dollars','TTD','TT$'),(112,'Turkey, New Lira','TRY','YTL'),(113,'Turkey, Liras','TRL','₤'),(114,'Tuvalu, Dollars','TVD','$'),(115,'Ukraine, Hryvnia','UAH','₴'),(116,'United Arab Emirates, Dirham','AED','AED'),(117,'United Kingdom, Pounds','GBP','£'),(118,'United Republic of Tanzania, Shilling','TZS','TZS'),(119,'USA, Dollars','USD','$'),(120,'Uruguay, Pesos','UYU','$U'),(121,'Uzbekistan, Sums','UZS','лв'),(122,'Venezuela, Bolivares Fuertes','VEF','Bs'),(123,'Vietnam, Dong','VND','₫'),(124,'Zambia, Kwacha','ZMK','ZMK'),(125,'Yemen, Rials','YER','﷼'),(126,'Zimbabwe Dollars','ZWD','Z$'),(127,'Malawi, Kwacha','MWK','MK'),(128,'Tunisian, Dinar','TD','TD'),(129,'Moroccan, Dirham','MAD','DH'),(130,'Iraqi Dinar','IQD','ID'),(131,'Maldivian Ruffiya','MVR','MVR'),(132,'Ugandan Shilling','UGX','Sh'),(133,'Sudanese Pound','SDG','£'),(134,'CFA Franc BCEAO','XOF','CFA'),(135,'CFA Franc BEAC','XAF','CFA'),(136,'Haiti, Gourde','HTG','G'),(137,'Libya, Dinar','LYD','LYD'),(138,'CFP Franc','XPF','F');

--
-- Table structure for table `vtiger_currencies_seq`
--

CREATE TABLE `vtiger_currencies_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currencies_seq`
--

INSERT INTO `vtiger_currencies_seq` VALUES (138);

--
-- Table structure for table `vtiger_currency`
--

CREATE TABLE `vtiger_currency` (
  `currencyid` int(11) NOT NULL AUTO_INCREMENT,
  `currency` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currencyid`),
  UNIQUE KEY `currency_currency_idx` (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency`
--


--
-- Table structure for table `vtiger_currency_decimal_separator`
--

CREATE TABLE `vtiger_currency_decimal_separator` (
  `currency_decimal_separatorid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_decimal_separator` varchar(2) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_decimal_separatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_decimal_separator`
--

INSERT INTO `vtiger_currency_decimal_separator` VALUES (1,'.',0,1),(2,',',1,1),(3,'\'',2,1),(4,' ',3,1),(5,'$',4,1);

--
-- Table structure for table `vtiger_currency_decimal_separator_seq`
--

CREATE TABLE `vtiger_currency_decimal_separator_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_decimal_separator_seq`
--

INSERT INTO `vtiger_currency_decimal_separator_seq` VALUES (5);

--
-- Table structure for table `vtiger_currency_grouping_pattern`
--

CREATE TABLE `vtiger_currency_grouping_pattern` (
  `currency_grouping_patternid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_grouping_pattern` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_grouping_patternid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_pattern`
--

INSERT INTO `vtiger_currency_grouping_pattern` VALUES (1,'123,456,789',0,1),(2,'123456789',1,1),(3,'123456,789',2,1),(4,'12,34,56,789',3,1);

--
-- Table structure for table `vtiger_currency_grouping_pattern_seq`
--

CREATE TABLE `vtiger_currency_grouping_pattern_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_pattern_seq`
--

INSERT INTO `vtiger_currency_grouping_pattern_seq` VALUES (4);

--
-- Table structure for table `vtiger_currency_grouping_separator`
--

CREATE TABLE `vtiger_currency_grouping_separator` (
  `currency_grouping_separatorid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_grouping_separator` varchar(2) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_grouping_separatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_separator`
--

INSERT INTO `vtiger_currency_grouping_separator` VALUES (1,',',0,1),(2,'.',1,1),(3,'\'',2,1),(4,' ',3,1),(5,'$',4,1);

--
-- Table structure for table `vtiger_currency_grouping_separator_seq`
--

CREATE TABLE `vtiger_currency_grouping_separator_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_grouping_separator_seq`
--

INSERT INTO `vtiger_currency_grouping_separator_seq` VALUES (5);

--
-- Table structure for table `vtiger_currency_info`
--

CREATE TABLE `vtiger_currency_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(100) DEFAULT NULL,
  `currency_code` varchar(100) DEFAULT NULL,
  `currency_symbol` varchar(30) DEFAULT NULL,
  `conversion_rate` decimal(12,5) DEFAULT NULL,
  `currency_status` varchar(25) DEFAULT NULL,
  `defaultid` varchar(10) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_info`
--

INSERT INTO `vtiger_currency_info` VALUES (1,'USA, Dollars','USD','$',1.00000,'Active','-11',0);

--
-- Table structure for table `vtiger_currency_info_seq`
--

CREATE TABLE `vtiger_currency_info_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_info_seq`
--

INSERT INTO `vtiger_currency_info_seq` VALUES (1);

--
-- Table structure for table `vtiger_currency_symbol_placement`
--

CREATE TABLE `vtiger_currency_symbol_placement` (
  `currency_symbol_placementid` int(11) NOT NULL AUTO_INCREMENT,
  `currency_symbol_placement` varchar(30) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`currency_symbol_placementid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_symbol_placement`
--

INSERT INTO `vtiger_currency_symbol_placement` VALUES (1,'$1.0',0,1),(2,'1.0$',1,1);

--
-- Table structure for table `vtiger_currency_symbol_placement_seq`
--

CREATE TABLE `vtiger_currency_symbol_placement_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_currency_symbol_placement_seq`
--

INSERT INTO `vtiger_currency_symbol_placement_seq` VALUES (2);

--
-- Table structure for table `vtiger_customaction`
--

CREATE TABLE `vtiger_customaction` (
  `cvid` int(11) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `module` varchar(50) NOT NULL,
  `content` text DEFAULT NULL,
  KEY `customaction_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_customaction` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customaction`
--


--
-- Table structure for table `vtiger_customerdetails`
--

CREATE TABLE `vtiger_customerdetails` (
  `customerid` int(11) NOT NULL,
  `portal` varchar(3) DEFAULT NULL,
  `support_start_date` date DEFAULT NULL,
  `support_end_date` date DEFAULT NULL,
  PRIMARY KEY (`customerid`),
  CONSTRAINT `fk_1_vtiger_customerdetails` FOREIGN KEY (`customerid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerdetails`
--

INSERT INTO `vtiger_customerdetails` VALUES (53,'0',NULL,NULL),(66,'0',NULL,NULL),(67,'0',NULL,NULL),(68,'0',NULL,NULL),(70,'0',NULL,NULL),(71,'0',NULL,NULL),(72,'0',NULL,NULL),(73,'1','2023-03-05','2023-03-31'),(132,'0',NULL,NULL),(198,'1','2023-04-16','2024-04-17'),(207,'1','2022-10-18','2025-03-03'),(409,'1','2023-05-01','2029-05-01');

--
-- Table structure for table `vtiger_customerportal_fields`
--

CREATE TABLE `vtiger_customerportal_fields` (
  `tabid` int(11) NOT NULL,
  `fieldinfo` text DEFAULT NULL,
  `records_visible` int(11) DEFAULT NULL,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_customerportal_fields`
--

INSERT INTO `vtiger_customerportal_fields` VALUES (4,'{\"lastname\":1,\"assigned_user_id\":1}',1),(6,'{\"accountname\":1,\"assigned_user_id\":1}',1),(8,'{\"notes_title\":1,\"assigned_user_id\":1,\"filename\":0}',1),(13,'{\"ticket_title\":1,\"assigned_user_id\":0,\"ticketpriorities\":1,\"ticketstatus\":1,\"description\":1,\"product_id\":0,\"ticketseverities\":1,\"ticketcategories\":1,\"cr_orgname_portaltext\":1,\"parent_id\":0}',1),(14,'{\"assigned_user_id\":1,\"productname\":1}',1),(15,'{\"faqstatus\":1,\"question\":1,\"faq_answer\":1}',1),(20,'{\"subject\":1,\"quotestage\":1,\"account_id\":1,\"assigned_user_id\":1,\"bill_street\":1,\"ship_street\":1}',1),(23,'{\"bill_street\":1,\"ship_street\":1,\"subject\":1,\"account_id\":1,\"assigned_user_id\":1}',1),(35,'{\"subject\":1,\"assigned_user_id\":1}',NULL),(36,'{\"servicename\":1}',1),(38,'{\"product\":1,\"assigned_user_id\":1,\"serialnumber\":1,\"datesold\":1,\"dateinservice\":1,\"assetstatus\":1,\"assetname\":1,\"account\":1}',1),(43,'{\"projectmilestonename\":1,\"projectid\":1,\"assigned_user_id\":1}',1),(44,'{\"projecttaskname\":1,\"projectid\":1,\"assigned_user_id\":1}',1),(45,'{\"projectname\":1,\"assigned_user_id\":1}',1);

--
-- Table structure for table `vtiger_customerportal_prefs`
--

CREATE TABLE `vtiger_customerportal_prefs` (
  `tabid` int(11) NOT NULL,
  `prefkey` varchar(100) NOT NULL,
  `prefvalue` int(11) DEFAULT NULL,
  PRIMARY KEY (`tabid`,`prefkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_prefs`
--

INSERT INTO `vtiger_customerportal_prefs` VALUES (0,'defaultassignee',6),(0,'userid',6),(4,'showrelatedinfo',1),(6,'showrelatedinfo',1),(8,'showrelatedinfo',1),(13,'showrelatedinfo',1),(14,'showrelatedinfo',1),(15,'showrelatedinfo',1),(20,'showrelatedinfo',1),(23,'showrelatedinfo',1),(36,'showrelatedinfo',1),(38,'showrelatedinfo',1),(43,'showrelatedinfo',1),(44,'showrelatedinfo',1),(45,'showrelatedinfo',1);

--
-- Table structure for table `vtiger_customerportal_relatedmoduleinfo`
--

CREATE TABLE `vtiger_customerportal_relatedmoduleinfo` (
  `tabid` int(11) NOT NULL,
  `relatedmodules` text DEFAULT NULL,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_relatedmoduleinfo`
--

INSERT INTO `vtiger_customerportal_relatedmoduleinfo` VALUES (8,'[{\"name\":\"History\",\"value\":1}]'),(13,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"Documents\",\"value\":1}]'),(14,'[{\"name\":\"History\",\"value\":1}]'),(20,'[{\"name\":\"History\",\"value\":1}]'),(23,'[{\"name\":\"History\",\"value\":1}]'),(35,'[{\"name\":\"History\",\"value\":1}]'),(36,'[{\"name\":\"History\",\"value\":1}]'),(38,'[{\"name\":\"History\",\"value\":1}]'),(43,'[{\"name\":\"History\",\"value\":1}]'),(44,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1}]'),(45,'[{\"name\":\"History\",\"value\":1},{\"name\":\"ModComments\",\"value\":1},{\"name\":\"ProjectTask\",\"value\":1},{\"name\":\"ProjectMilestone\",\"value\":1},{\"name\":\"Documents\",\"value\":1}]');

--
-- Table structure for table `vtiger_customerportal_settings`
--

CREATE TABLE `vtiger_customerportal_settings` (
  `id` int(11) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `default_assignee` int(11) DEFAULT NULL,
  `support_notification` int(11) DEFAULT NULL,
  `announcement` text DEFAULT NULL,
  `shortcuts` text DEFAULT NULL,
  `widgets` text DEFAULT NULL,
  `charts` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_settings`
--

INSERT INTO `vtiger_customerportal_settings` VALUES (1,NULL,6,0,'You are now on the Blue Technology Support Ticket System','{\"Documents\":{\"LBL_ADD_DOCUMENT\":1},\"HelpDesk\":{\"LBL_CREATE_TICKET\":1,\"LBL_OPEN_TICKETS\":1}}','{\"widgets\":{\"HelpDesk\":\"1\",\"Documents\":\"1\",\"Faq\":\"1\"}}','{\"charts\":{\"OpenTicketsByPriority\":1,\"TicketsClosureTimeByPriority\":1}}');

--
-- Table structure for table `vtiger_customerportal_tabs`
--

CREATE TABLE `vtiger_customerportal_tabs` (
  `tabid` int(11) NOT NULL,
  `visible` int(11) DEFAULT 1,
  `sequence` int(11) DEFAULT NULL,
  `createrecord` tinyint(1) NOT NULL DEFAULT 0,
  `editrecord` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`tabid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customerportal_tabs`
--

INSERT INTO `vtiger_customerportal_tabs` VALUES (4,0,9,0,1),(6,0,10,0,1),(8,0,5,1,0),(13,1,2,1,1),(14,1,6,0,0),(15,1,4,0,0),(20,1,5,0,0),(23,0,3,0,0),(35,0,6,0,0),(36,1,7,0,0),(38,1,11,0,1),(43,1,12,0,0),(44,1,13,0,0),(45,1,14,0,0);

--
-- Table structure for table `vtiger_customview`
--

CREATE TABLE `vtiger_customview` (
  `cvid` int(11) NOT NULL,
  `viewname` varchar(100) NOT NULL,
  `setdefault` int(11) DEFAULT 0,
  `setmetrics` int(11) DEFAULT 0,
  `entitytype` varchar(25) NOT NULL,
  `status` int(11) DEFAULT 1,
  `userid` int(11) DEFAULT 1,
  PRIMARY KEY (`cvid`),
  KEY `customview_entitytype_idx` (`entitytype`),
  CONSTRAINT `fk_1_vtiger_customview` FOREIGN KEY (`entitytype`) REFERENCES `vtiger_tab` (`name`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customview`
--

INSERT INTO `vtiger_customview` VALUES (1,'All',1,0,'Leads',0,6),(2,'Hot Leads',0,1,'Leads',3,6),(3,'This Month Leads',0,0,'Leads',3,6),(4,'All',1,0,'Accounts',0,6),(7,'All',1,0,'Contacts',0,6),(10,'All',1,0,'Potentials',0,6),(11,'Potentials Won',0,1,'Potentials',3,6),(12,'Prospecting',0,0,'Potentials',3,6),(13,'All',1,0,'HelpDesk',0,6),(16,'All',1,0,'Quotes',0,6),(17,'Open Quotes',0,1,'Quotes',3,6),(18,'Rejected Quotes',0,0,'Quotes',3,6),(19,'All',1,0,'Calendar',0,6),(20,'All',1,0,'Emails',0,6),(21,'All',1,0,'Invoice',0,6),(22,'All',1,0,'Documents',0,6),(23,'All',1,0,'PriceBooks',0,6),(24,'All',1,0,'Products',0,6),(25,'All',1,0,'PurchaseOrder',0,6),(26,'All',1,0,'SalesOrder',0,6),(27,'All',1,0,'Vendors',0,6),(28,'All',1,0,'Faq',0,6),(29,'All',1,0,'Campaigns',0,6),(30,'All',1,0,'Webmails',0,6),(31,'Drafted FAQ',0,0,'Faq',3,6),(32,'Published FAQ',0,0,'Faq',3,6),(33,'Open Purchase Orders',0,0,'PurchaseOrder',3,6),(34,'Received Purchase Orders',0,0,'PurchaseOrder',3,6),(35,'Open Invoices',0,0,'Invoice',3,6),(36,'Paid Invoices',0,0,'Invoice',3,6),(37,'Pending Sales Orders',0,0,'SalesOrder',3,6),(59,'All',1,0,'ServiceContracts',0,6),(60,'All',1,0,'Services',0,6),(61,'All',1,0,'PBXManager',0,6),(62,'All',0,0,'ModComments',0,6),(63,'All',1,0,'ProjectMilestone',0,6),(64,'All',1,0,'ProjectTask',0,6),(65,'All',1,0,'Project',0,6),(66,'All',1,0,'Assets',0,6),(67,'All',0,0,'SMSNotifier',0,6),(71,'Today tickets',0,0,'HelpDesk',3,1),(75,'Service Calls 04-21-2023 to 05-20-2023',0,0,'HelpDesk',1,6),(76,'Seach Organization Name for \'F\'',0,0,'HelpDesk',1,6),(77,'Shared Ticket List',0,0,'HelpDesk',1,6);

--
-- Table structure for table `vtiger_customview_seq`
--

CREATE TABLE `vtiger_customview_seq` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_customview_seq`
--

INSERT INTO `vtiger_customview_seq` VALUES (77);

--
-- Table structure for table `vtiger_cv2group`
--

CREATE TABLE `vtiger_cv2group` (
  `cvid` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  KEY `vtiger_cv2group_ibfk_1` (`cvid`),
  KEY `vtiger_groups_ibfk_1` (`groupid`),
  CONSTRAINT `vtiger_customview_ibfk_2` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_groups_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2group`
--


--
-- Table structure for table `vtiger_cv2role`
--

CREATE TABLE `vtiger_cv2role` (
  `cvid` int(25) NOT NULL,
  `roleid` varchar(255) NOT NULL,
  KEY `vtiger_cv2role_ibfk_1` (`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2role`
--


--
-- Table structure for table `vtiger_cv2rs`
--

CREATE TABLE `vtiger_cv2rs` (
  `cvid` int(25) NOT NULL,
  `rsid` varchar(255) NOT NULL,
  KEY `vtiger_cv2role_ibfk_1` (`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2rs`
--


--
-- Table structure for table `vtiger_cv2users`
--

CREATE TABLE `vtiger_cv2users` (
  `cvid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  KEY `vtiger_cv2users_ibfk_1` (`cvid`),
  KEY `vtiger_users_ibfk_1` (`userid`),
  CONSTRAINT `vtiger_customview_ibfk_1` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE,
  CONSTRAINT `vtiger_users_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_cv2users`
--

INSERT INTO `vtiger_cv2users` VALUES (77,13);

--
-- Table structure for table `vtiger_cvadvfilter`
--

CREATE TABLE `vtiger_cvadvfilter` (
  `cvid` int(11) NOT NULL,
  `columnindex` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  `comparator` varchar(20) DEFAULT NULL,
  `value` varchar(512) DEFAULT NULL,
  `groupid` int(11) DEFAULT 1,
  `column_condition` varchar(255) DEFAULT 'and',
  PRIMARY KEY (`cvid`,`columnindex`),
  KEY `cvadvfilter_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvadvfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvadvfilter`
--

INSERT INTO `vtiger_cvadvfilter` VALUES (2,0,'vtiger_leaddetails:leadstatus:leadstatus:Leads_Lead_Status:V','e','Hot',1,'and'),(11,0,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V','e','Closed Won',1,'and'),(12,0,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V','e','Prospecting',1,'and'),(17,0,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V','n','Accepted',1,'and'),(17,1,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V','n','Rejected',1,'and'),(18,0,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V','e','Rejected',1,'and'),(31,0,'vtiger_faq:status:faqstatus:Faq_Status:V','e','Draft',1,'and'),(32,0,'vtiger_faq:status:faqstatus:Faq_Status:V','e','Published',1,'and'),(33,0,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V','e','Created, Approved, Delivered',1,'and'),(34,0,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V','e','Received Shipment',1,'and'),(35,0,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V','e','Created, Approved, Sent',1,'and'),(36,0,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V','e','Paid',1,'and'),(37,0,'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V','e','Created, Approved',1,'and'),(71,0,'vtiger_crmentity:createdtime:createdtime:HelpDesk_Created_Time:DT','today','2023-04-14 07:00:00',1,''),(75,0,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D','bw','2023-04-21,2023-05-20',1,''),(76,0,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V','s','F',1,'');

--
-- Table structure for table `vtiger_cvadvfilter_grouping`
--

CREATE TABLE `vtiger_cvadvfilter_grouping` (
  `groupid` int(11) NOT NULL,
  `cvid` int(11) NOT NULL,
  `group_condition` varchar(255) DEFAULT NULL,
  `condition_expression` text DEFAULT NULL,
  PRIMARY KEY (`groupid`,`cvid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvadvfilter_grouping`
--

INSERT INTO `vtiger_cvadvfilter_grouping` VALUES (1,2,'',''),(1,11,'',''),(1,12,'',''),(1,17,'',''),(1,18,'',''),(1,31,'',''),(1,32,'',''),(1,33,'',''),(1,34,'',''),(1,35,'',''),(1,36,'',''),(1,37,'',''),(1,71,'and',' 0 '),(1,75,'and',' 0 '),(1,76,'and',' 0 ');

--
-- Table structure for table `vtiger_cvcolumnlist`
--

CREATE TABLE `vtiger_cvcolumnlist` (
  `cvid` int(11) NOT NULL,
  `columnindex` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  PRIMARY KEY (`cvid`,`columnindex`),
  KEY `cvcolumnlist_columnindex_idx` (`columnindex`),
  KEY `cvcolumnlist_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvcolumnlist` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvcolumnlist`
--

INSERT INTO `vtiger_cvcolumnlist` VALUES (1,1,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(1,2,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(1,3,'vtiger_leaddetails:company:company:Leads_Company:V'),(1,4,'vtiger_leadaddress:phone:phone:Leads_Phone:V'),(1,5,'vtiger_leadsubdetails:website:website:Leads_Website:V'),(1,6,'vtiger_leaddetails:email:email:Leads_Email:V'),(1,7,'vtiger_crmentity:smownerid:assigned_user_id:Leads_Assigned_To:V'),(2,0,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(2,1,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(2,2,'vtiger_leaddetails:company:company:Leads_Company:V'),(2,3,'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V'),(2,4,'vtiger_leadsubdetails:website:website:Leads_Website:V'),(2,5,'vtiger_leaddetails:email:email:Leads_Email:E'),(3,0,'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'),(3,1,'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'),(3,2,'vtiger_leaddetails:company:company:Leads_Company:V'),(3,3,'vtiger_leaddetails:leadsource:leadsource:Leads_Lead_Source:V'),(3,4,'vtiger_leadsubdetails:website:website:Leads_Website:V'),(3,5,'vtiger_leaddetails:email:email:Leads_Email:E'),(4,0,'vtiger_account:accountname:(account_id ; (Accounts) accountname):Accounts_Member_Of-Organization_Name:V'),(4,1,'vtiger_account:accountname:accountname:Accounts_Account_Name:V'),(4,2,'vtiger_account:phone:phone:Accounts_Phone:V'),(4,3,'vtiger_accountscf:cf_857:cf_857:Accounts_Billing_eMail:E'),(4,4,'vtiger_account:siccode:siccode:Accounts_SIC_Code:V'),(4,5,'vtiger_account:website:website:Accounts_Website:V'),(4,6,'vtiger_account:industry:industry:Accounts_industry:V'),(7,0,'vtiger_contactdetails:firstname:firstname:Contacts_First_Name:V'),(7,1,'vtiger_contactdetails:lastname:lastname:Contacts_Last_Name:V'),(7,2,'vtiger_contactdetails:title:title:Contacts_Title:V'),(7,3,'vtiger_contactdetails:accountid:account_id:Contacts_Account_Name:V'),(7,4,'vtiger_contactdetails:email:email:Contacts_Email:V'),(7,5,'vtiger_contactdetails:phone:phone:Contacts_Office_Phone:V'),(7,6,'vtiger_crmentity:smownerid:assigned_user_id:Contacts_Assigned_To:V'),(7,7,'vtiger_customerdetails:portal:portal:Contacts_Portal_User:C'),(10,1,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),(10,2,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),(10,3,'vtiger_potential:sales_stage:sales_stage:Potentials_Sales_Stage:V'),(10,4,'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V'),(10,5,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),(10,6,'vtiger_potential:amount:amount:Potentials_Amount:N'),(10,7,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),(10,8,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),(11,0,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),(11,1,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),(11,2,'vtiger_potential:amount:amount:Potentials_Amount:N'),(11,3,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),(11,4,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),(11,5,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),(12,0,'vtiger_potential:potentialname:potentialname:Potentials_Potential_Name:V'),(12,1,'vtiger_potential:related_to:related_to:Potentials_Related_To:V'),(12,2,'vtiger_potential:amount:amount:Potentials_Amount:N'),(12,3,'vtiger_potential:leadsource:leadsource:Potentials_Lead_Source:V'),(12,4,'vtiger_potential:closingdate:closingdate:Potentials_Expected_Close_Date:D'),(12,5,'vtiger_crmentity:smownerid:assigned_user_id:Potentials_Assigned_To:V'),(12,6,'vtiger_potential:contact_id:contact_id:Potentials_Contact_Name:V'),(13,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(13,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(13,2,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(13,3,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(13,4,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(13,5,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(13,6,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D'),(13,7,'vtiger_ticketcf:cf_871:cf_871:HelpDesk_Request_Time:T'),(13,8,'vtiger_ticketcf:cf_859:cf_859:HelpDesk_Check-in_Date:D'),(13,9,'vtiger_ticketcf:cf_861:cf_861:HelpDesk_Check_in_time:T'),(13,10,'vtiger_ticketcf:cf_863:cf_863:HelpDesk_Check_out_date:D'),(13,11,'vtiger_ticketcf:cf_865:cf_865:HelpDesk_Check_out_time:T'),(13,12,'vtiger_ticketcf:cf_885:cf_885:HelpDesk_Hours_checkin_to_checkout:V'),(13,13,'vtiger_ticketcf:cf_883:cf_883:HelpDesk_Hours_Request_to_Checkin:V'),(13,14,'vtiger_ticketcf:cf_895:cf_895:HelpDesk_Driving_Hours:NN'),(16,1,'vtiger_quotes:subject:subject:Quotes_Subject:V'),(16,2,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V'),(16,3,'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:V'),(16,4,'vtiger_quotes:accountid:account_id:Quotes_Account_Name:V'),(16,5,'vtiger_quotes:total:hdnGrandTotal:Quotes_Total:N'),(16,6,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),(17,0,'vtiger_quotes:subject:subject:Quotes_Subject:V'),(17,1,'vtiger_quotes:quotestage:quotestage:Quotes_Quote_Stage:V'),(17,2,'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I'),(17,3,'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I'),(17,4,'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D'),(17,5,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),(18,0,'vtiger_quotes:subject:subject:Quotes_Subject:V'),(18,1,'vtiger_quotes:potentialid:potential_id:Quotes_Potential_Name:I'),(18,2,'vtiger_quotes:accountid:account_id:Quotes_Account_Name:I'),(18,3,'vtiger_quotes:validtill:validtill:Quotes_Valid_Till:D'),(18,4,'vtiger_crmentity:smownerid:assigned_user_id:Quotes_Assigned_To:V'),(19,0,'vtiger_activity:status:taskstatus:Calendar_Status:V'),(19,1,'vtiger_activity:activitytype:activitytype:Calendar_Activity_Type:V'),(19,2,'vtiger_activity:subject:subject:Calendar_Subject:V'),(19,3,'vtiger_seactivityrel:crmid:parent_id:Calendar_Related_To:V'),(19,4,'vtiger_activity:date_start:date_start:Calendar_Start_Date_&_Time:DT'),(19,5,'vtiger_activity:due_date:due_date:Calendar_Due_Date:D'),(19,6,'vtiger_crmentity:smownerid:assigned_user_id:Calendar_Assigned_To:V'),(20,0,'vtiger_activity:subject:subject:Emails_Subject:V'),(20,1,'vtiger_emaildetails:to_email:saved_toid:Emails_To:V'),(20,2,'vtiger_activity:date_start:date_start:Emails_Date_&_Time_Sent:DT'),(21,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),(21,2,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:V'),(21,3,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),(21,4,'vtiger_invoice:total:hdnGrandTotal:Invoice_Total:N'),(21,5,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),(22,1,'vtiger_notes:title:notes_title:Documents_Title:V'),(22,2,'vtiger_notes:filename:filename:Documents_File_Name:V'),(22,3,'vtiger_crmentity:modifiedtime:modifiedtime:Documents_Modified_Time:DT'),(22,4,'vtiger_crmentity:smownerid:assigned_user_id:Documents_Assigned_To:V'),(23,1,'vtiger_pricebook:bookname:bookname:PriceBooks_Price_Book_Name:V'),(23,2,'vtiger_pricebook:active:active:PriceBooks_Active:C'),(23,3,'vtiger_pricebook:currency_id:currency_id:PriceBooks_Currency:V'),(24,1,'vtiger_products:productname:productname:Products_Product_Name:V'),(24,2,'vtiger_products:productcode:productcode:Products_Part_Number:V'),(24,3,'vtiger_products:commissionrate:commissionrate:Products_Commission_Rate:N'),(24,4,'vtiger_products:qtyinstock:qtyinstock:Products_Qty_In_Stock:NN'),(24,5,'vtiger_products:qty_per_unit:qty_per_unit:Products_Qty/Unit:N'),(24,6,'vtiger_products:unit_price:unit_price:Products_Unit_Price:N'),(25,1,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),(25,2,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:V'),(25,3,'vtiger_purchaseorder:tracking_no:tracking_no:PurchaseOrder_Tracking_Number:V'),(25,4,'vtiger_purchaseorder:total:hdnGrandTotal:PurchaseOrder_Total:N'),(25,5,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),(26,1,'vtiger_salesorder:subject:subject:SalesOrder_Subject:V'),(26,2,'vtiger_salesorder:accountid:account_id:SalesOrder_Account_Name:V'),(26,3,'vtiger_salesorder:quoteid:quote_id:SalesOrder_Quote_Name:V'),(26,4,'vtiger_salesorder:total:hdnGrandTotal:SalesOrder_Total:N'),(26,5,'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V'),(27,1,'vtiger_vendor:vendorname:vendorname:Vendors_Vendor_Name:V'),(27,2,'vtiger_vendor:phone:phone:Vendors_Phone:V'),(27,3,'vtiger_vendor:email:email:Vendors_Email:V'),(27,4,'vtiger_vendor:category:category:Vendors_Category:V'),(27,5,'vtiger_crmentity:smownerid:assigned_user_id:Vendors_Assigned_To:V'),(28,1,'vtiger_faq:question:question:Faq_Question:V'),(28,2,'vtiger_faq:category:faqcategories:Faq_Category:V'),(28,3,'vtiger_faq:product_id:product_id:Faq_Product_Name:V'),(28,4,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),(28,5,'vtiger_crmentity:modifiedtime:modifiedtime:Faq_Modified_Time:DT'),(29,1,'vtiger_campaign:campaignname:campaignname:Campaigns_Campaign_Name:V'),(29,2,'vtiger_campaign:campaigntype:campaigntype:Campaigns_Campaign_Type:V'),(29,3,'vtiger_campaign:campaignstatus:campaignstatus:Campaigns_Campaign_Status:V'),(29,4,'vtiger_campaign:expectedrevenue:expectedrevenue:Campaigns_Expected_Revenue:N'),(29,5,'vtiger_campaign:closingdate:closingdate:Campaigns_Expected_Close_Date:D'),(29,6,'vtiger_crmentity:smownerid:assigned_user_id:Campaigns_Assigned_To:V'),(30,0,'subject:subject:subject:Subject:V'),(30,1,'from:fromname:fromname:From:N'),(30,2,'to:tpname:toname:To:N'),(30,3,'body:body:body:Body:V'),(31,0,'vtiger_faq:question:question:Faq_Question:V'),(31,1,'vtiger_faq:status:faqstatus:Faq_Status:V'),(31,2,'vtiger_faq:product_id:product_id:Faq_Product_Name:I'),(31,3,'vtiger_faq:category:faqcategories:Faq_Category:V'),(31,4,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),(32,0,'vtiger_faq:question:question:Faq_Question:V'),(32,1,'vtiger_faq:answer:faq_answer:Faq_Answer:V'),(32,2,'vtiger_faq:status:faqstatus:Faq_Status:V'),(32,3,'vtiger_faq:product_id:product_id:Faq_Product_Name:I'),(32,4,'vtiger_faq:category:faqcategories:Faq_Category:V'),(32,5,'vtiger_crmentity:createdtime:createdtime:Faq_Created_Time:DT'),(33,0,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),(33,1,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V'),(33,2,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I'),(33,3,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),(33,4,'vtiger_purchaseorder:duedate:duedate:PurchaseOrder_Due_Date:V'),(34,0,'vtiger_purchaseorder:subject:subject:PurchaseOrder_Subject:V'),(34,1,'vtiger_purchaseorder:vendorid:vendor_id:PurchaseOrder_Vendor_Name:I'),(34,2,'vtiger_crmentity:smownerid:assigned_user_id:PurchaseOrder_Assigned_To:V'),(34,3,'vtiger_purchaseorder:postatus:postatus:PurchaseOrder_Status:V'),(34,4,'vtiger_purchaseorder:carrier:carrier:PurchaseOrder_Carrier:V'),(34,5,'vtiger_poshipads:ship_street:ship_street:PurchaseOrder_Shipping_Address:V'),(35,0,'vtiger_invoice:invoice_no:invoice_no:Invoice_Invoice_No:V'),(35,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),(35,2,'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I'),(35,3,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I'),(35,4,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),(35,5,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),(35,6,'vtiger_crmentity:createdtime:createdtime:Invoice_Created_Time:DT'),(36,0,'vtiger_invoice:invoice_no:invoice_no:Invoice_Invoice_No:V'),(36,1,'vtiger_invoice:subject:subject:Invoice_Subject:V'),(36,2,'vtiger_invoice:accountid:account_id:Invoice_Account_Name:I'),(36,3,'vtiger_invoice:salesorderid:salesorder_id:Invoice_Sales_Order:I'),(36,4,'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V'),(36,5,'vtiger_invoiceshipads:ship_street:ship_street:Invoice_Shipping_Address:V'),(36,6,'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V'),(37,0,'vtiger_salesorder:subject:subject:SalesOrder_Subject:V'),(37,1,'vtiger_salesorder:accountid:account_id:SalesOrder_Account_Name:I'),(37,2,'vtiger_salesorder:sostatus:sostatus:SalesOrder_Status:V'),(37,3,'vtiger_crmentity:smownerid:assigned_user_id:SalesOrder_Assigned_To:V'),(37,4,'vtiger_soshipads:ship_street:ship_street:SalesOrder_Shipping_Address:V'),(37,5,'vtiger_salesorder:carrier:carrier:SalesOrder_Carrier:V'),(59,0,'vtiger_servicecontracts:contract_no:contract_no:ServiceContracts_Contract_No:V'),(59,1,'vtiger_servicecontracts:subject:subject:ServiceContracts_Subject:V'),(59,2,'vtiger_servicecontracts:sc_related_to:sc_related_to:ServiceContracts_Related_to:V'),(59,3,'vtiger_crmentity:smownerid:assigned_user_id:ServiceContracts_Assigned_To:V'),(59,4,'vtiger_servicecontracts:start_date:start_date:ServiceContracts_Start_Date:D'),(59,5,'vtiger_servicecontracts:due_date:due_date:ServiceContracts_Due_date:D'),(59,7,'vtiger_servicecontracts:progress:progress:ServiceContracts_Progress:N'),(59,8,'vtiger_servicecontracts:contract_status:contract_status:ServiceContracts_Status:V'),(60,0,'vtiger_service:service_no:service_no:Services_Service_No:V'),(60,1,'vtiger_service:servicename:servicename:Services_Service_Name:V'),(60,2,'vtiger_service:service_usageunit:service_usageunit:Services_Usage_Unit:V'),(60,3,'vtiger_service:unit_price:unit_price:Services_Price:N'),(60,4,'vtiger_service:qty_per_unit:qty_per_unit:Services_No_of_Units:N'),(60,5,'vtiger_service:servicecategory:servicecategory:Services_Service_Category:V'),(60,6,'vtiger_crmentity:smownerid:assigned_user_id:Services_Owner:I'),(61,0,'vtiger_pbxmanager:callstatus:callstatus:PBXManager_Call_Status:V'),(61,1,'vtiger_pbxmanager:customernumber:customernumber:PBXManager_Customer_Number:V'),(61,2,'vtiger_pbxmanager:customer:customer:PBXManager_Customer:V'),(61,3,'vtiger_pbxmanager:user:user:PBXManager_User:V'),(61,4,'vtiger_pbxmanager:recordingurl:recordingurl:PBXManager_Recording_URL:V'),(61,5,'vtiger_pbxmanager:totalduration:totalduration:PBXManager_Total_Duration:I'),(61,6,'vtiger_pbxmanager:starttime:starttime:PBXManager_Start_Time:DT'),(62,0,'vtiger_modcomments:commentcontent:commentcontent:ModComments_Comment:V'),(62,1,'vtiger_modcomments:related_to:related_to:ModComments_Related_To:V'),(62,2,'vtiger_crmentity:modifiedtime:modifiedtime:ModComments_Modified_Time:DT'),(62,3,'vtiger_crmentity:smownerid:assigned_user_id:ModComments_Assigned_To:V'),(63,0,'vtiger_projectmilestone:projectmilestonename:projectmilestonename:ProjectMilestone_Project_Milestone_Name:V'),(63,1,'vtiger_projectmilestone:projectmilestonedate:projectmilestonedate:ProjectMilestone_Milestone_Date:D'),(63,3,'vtiger_crmentity:description:description:ProjectMilestone_Description:V'),(63,4,'vtiger_crmentity:createdtime:createdtime:ProjectMilestone_Created_Time:DT'),(63,5,'vtiger_crmentity:modifiedtime:modifiedtime:ProjectMilestone_Modified_Time:DT'),(64,2,'vtiger_projecttask:projecttaskname:projecttaskname:ProjectTask_Project_Task_Name:V'),(64,3,'vtiger_projecttask:projectid:projectid:ProjectTask_Related_to:V'),(64,4,'vtiger_projecttask:projecttaskpriority:projecttaskpriority:ProjectTask_Priority:V'),(64,5,'vtiger_projecttask:projecttaskprogress:projecttaskprogress:ProjectTask_Progress:V'),(64,6,'vtiger_projecttask:projecttaskhours:projecttaskhours:ProjectTask_Worked_Hours:V'),(64,7,'vtiger_projecttask:startdate:startdate:ProjectTask_Start_Date:D'),(64,8,'vtiger_projecttask:enddate:enddate:ProjectTask_End_Date:D'),(64,9,'vtiger_crmentity:smownerid:assigned_user_id:ProjectTask_Assigned_To:V'),(65,0,'vtiger_project:projectname:projectname:Project_Project_Name:V'),(65,1,'vtiger_project:linktoaccountscontacts:linktoaccountscontacts:Project_Related_to:V'),(65,2,'vtiger_project:startdate:startdate:Project_Start_Date:D'),(65,3,'vtiger_project:targetenddate:targetenddate:Project_Target_End_Date:D'),(65,4,'vtiger_project:actualenddate:actualenddate:Project_Actual_End_Date:D'),(65,5,'vtiger_project:targetbudget:targetbudget:Project_Target_Budget:V'),(65,6,'vtiger_project:progress:progress:Project_Progress:V'),(65,7,'vtiger_project:projectstatus:projectstatus:Project_Status:V'),(65,8,'vtiger_crmentity:smownerid:assigned_user_id:Project_Assigned_To:V'),(66,0,'vtiger_assets:asset_no:asset_no:Assets_Asset_No:V'),(66,1,'vtiger_assets:assetname:assetname:Assets_Asset_Name:V'),(66,2,'vtiger_assets:account:account:Assets_Customer_Name:V'),(66,3,'vtiger_assets:product:product:Assets_Product_Name:V'),(67,0,'vtiger_smsnotifier:message:message:SMSNotifier_message:V'),(67,2,'vtiger_crmentity:smownerid:assigned_user_id:SMSNotifier_Assigned_To:V'),(67,3,'vtiger_crmentity:createdtime:createdtime:SMSNotifier_Created_Time:DT'),(67,4,'vtiger_crmentity:modifiedtime:modifiedtime:SMSNotifier_Modified_Time:DT'),(71,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(71,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(71,2,'vtiger_troubletickets:contact_id:contact_id:HelpDesk_Contact_Name:V'),(71,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(71,4,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(71,5,'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V'),(71,6,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(71,7,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(75,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(75,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(75,2,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(75,3,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(75,4,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(75,5,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(75,6,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D'),(75,7,'vtiger_ticketcf:cf_871:cf_871:HelpDesk_Request_Time:T'),(75,8,'vtiger_ticketcf:cf_859:cf_859:HelpDesk_Check-in_Date:D'),(75,9,'vtiger_ticketcf:cf_861:cf_861:HelpDesk_Check_in_time:T'),(75,10,'vtiger_ticketcf:cf_863:cf_863:HelpDesk_Check_out_date:D'),(75,11,'vtiger_ticketcf:cf_865:cf_865:HelpDesk_Check_out_time:T'),(75,12,'vtiger_ticketcf:cf_885:cf_885:HelpDesk_Hours_checkin_to_checkout:V'),(75,13,'vtiger_ticketcf:cf_883:cf_883:HelpDesk_Hours_Request_to_Checkin:V'),(75,14,'vtiger_crmentity:description:description:HelpDesk_Description:V'),(75,15,'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V'),(75,16,'vtiger_troubletickets:severity:ticketseverities:HelpDesk_Severity:V'),(75,17,'vtiger_ticketcf:cf_877:cf_877:HelpDesk_Ticket_eMail_Date:D'),(75,18,'vtiger_ticketcf:cf_879:cf_879:HelpDesk_Ticket_eMail_Time:T'),(75,19,'vtiger_ticketcf:cf_873:cf_873:HelpDesk_Dispatch_Date:D'),(75,20,'vtiger_ticketcf:cf_875:cf_875:HelpDesk_Dispatch_Time:T'),(76,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(76,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(76,2,'vtiger_troubletickets:contact_id:contact_id:HelpDesk_Contact_Name:V'),(76,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(76,4,'vtiger_crmentity:description:description:HelpDesk_Description:V'),(76,5,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(76,6,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(76,7,'vtiger_troubletickets:priority:ticketpriorities:HelpDesk_Priority:V'),(76,8,'vtiger_troubletickets:severity:ticketseverities:HelpDesk_Severity:V'),(76,9,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(76,10,'vtiger_ticketcf:cf_877:cf_877:HelpDesk_Ticket_eMail_Date:D'),(76,11,'vtiger_ticketcf:cf_879:cf_879:HelpDesk_Ticket_eMail_Time:T'),(76,12,'vtiger_ticketcf:cf_873:cf_873:HelpDesk_Dispatch_Date:D'),(76,13,'vtiger_ticketcf:cf_875:cf_875:HelpDesk_Dispatch_Time:T'),(76,14,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D'),(77,0,'vtiger_troubletickets:title:ticket_title:HelpDesk_Title:V'),(77,1,'vtiger_troubletickets:parent_id:parent_id:HelpDesk_Related_To:V'),(77,2,'vtiger_troubletickets:contact_id:contact_id:HelpDesk_Contact_Name:V'),(77,3,'vtiger_troubletickets:ticket_no:ticket_no:HelpDesk_Ticket_No:V'),(77,4,'vtiger_crmentity:description:description:HelpDesk_Description:V'),(77,5,'vtiger_crmentity:smownerid:assigned_user_id:HelpDesk_Assigned_To:V'),(77,6,'vtiger_troubletickets:status:ticketstatus:HelpDesk_Status:V'),(77,7,'vtiger_troubletickets:severity:ticketseverities:HelpDesk_Severity:V'),(77,8,'vtiger_ticketcf:cf_855:cf_855:HelpDesk_Dynamix_Ticket_Number:I'),(77,9,'vtiger_ticketcf:cf_877:cf_877:HelpDesk_Ticket_eMail_Date:D'),(77,10,'vtiger_ticketcf:cf_879:cf_879:HelpDesk_Ticket_eMail_Time:T'),(77,11,'vtiger_ticketcf:cf_873:cf_873:HelpDesk_Dispatch_Date:D'),(77,12,'vtiger_ticketcf:cf_875:cf_875:HelpDesk_Dispatch_Time:T'),(77,13,'vtiger_ticketcf:cf_869:cf_869:HelpDesk_Request_Date:D');

--
