-- Table structure for table `vtiger_cvstdfilter`
--

CREATE TABLE `vtiger_cvstdfilter` (
  `cvid` int(11) NOT NULL,
  `columnname` varchar(250) DEFAULT '',
  `stdfilter` varchar(250) DEFAULT '',
  `startdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  KEY `cvstdfilter_cvid_idx` (`cvid`),
  CONSTRAINT `fk_1_vtiger_cvstdfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_cvstdfilter`
--

INSERT INTO `vtiger_cvstdfilter` VALUES (3,'vtiger_crmentity:modifiedtime:modifiedtime:Leads_Modified_Time','thismonth','2005-06-01','2005-06-30');

--
-- Table structure for table `vtiger_dashboard_tabs`
--

CREATE TABLE `vtiger_dashboard_tabs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tabname` varchar(50) DEFAULT NULL,
  `isdefault` int(11) DEFAULT 0,
  `sequence` int(11) DEFAULT 2,
  `appname` varchar(20) DEFAULT NULL,
  `modulename` varchar(50) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tabname` (`tabname`,`userid`),
  KEY `vtiger_dashboard_tabs_ibfk_1` (`userid`),
  CONSTRAINT `vtiger_dashboard_tabs_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_dashboard_tabs`
--

INSERT INTO `vtiger_dashboard_tabs` VALUES (2,'My Dashboard',1,1,'','',1),(8,'My Dashboard',1,1,'','',5),(10,'My Dashboard',1,1,'','',6),(16,'My Dashboard',1,1,'','',8),(26,'My Dashboard',1,1,'','',9),(27,'My Dashboard',1,1,'','',10),(35,'My Dashboard',1,1,'','',11),(56,'Customer 01',0,2,NULL,NULL,6),(75,'My Dashboard',1,1,'','',12),(76,'My Dashboard',1,1,'','',13);

--
-- Table structure for table `vtiger_datashare_grp2grp`
--

CREATE TABLE `vtiger_datashare_grp2grp` (
  `shareid` int(11) NOT NULL,
  `share_groupid` int(11) DEFAULT NULL,
  `to_groupid` int(11) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_grp2grp_share_groupid_idx` (`share_groupid`),
  KEY `datashare_grp2grp_to_groupid_idx` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2grp` FOREIGN KEY (`to_groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2grp`
--


--
-- Table structure for table `vtiger_datashare_grp2role`
--

CREATE TABLE `vtiger_datashare_grp2role` (
  `shareid` int(11) NOT NULL,
  `share_groupid` int(11) DEFAULT NULL,
  `to_roleid` varchar(255) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `idx_datashare_grp2role_share_groupid` (`share_groupid`),
  KEY `idx_datashare_grp2role_to_roleid` (`to_roleid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2role`
--

INSERT INTO `vtiger_datashare_grp2role` VALUES (9,4,'H8',0);

--
-- Table structure for table `vtiger_datashare_grp2rs`
--

CREATE TABLE `vtiger_datashare_grp2rs` (
  `shareid` int(11) NOT NULL,
  `share_groupid` int(11) DEFAULT NULL,
  `to_roleandsubid` varchar(255) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_grp2rs_share_groupid_idx` (`share_groupid`),
  KEY `datashare_grp2rs_to_roleandsubid_idx` (`to_roleandsubid`),
  CONSTRAINT `fk_3_vtiger_datashare_grp2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_grp2rs`
--


--
-- Table structure for table `vtiger_datashare_module_rel`
--

CREATE TABLE `vtiger_datashare_module_rel` (
  `shareid` int(11) NOT NULL,
  `tabid` int(11) NOT NULL,
  `relationtype` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `idx_datashare_module_rel_tabid` (`tabid`),
  CONSTRAINT `fk_1_vtiger_datashare_module_rel` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_module_rel`
--

INSERT INTO `vtiger_datashare_module_rel` VALUES (9,13,'GRP::ROLE');

--
-- Table structure for table `vtiger_datashare_module_rel_seq`
--

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

--
-- Dumping data for table `vtiger_datashare_module_rel_seq`
--

INSERT INTO `vtiger_datashare_module_rel_seq` VALUES (9);

--
-- Table structure for table `vtiger_datashare_relatedmodule_permission`
--

CREATE TABLE `vtiger_datashare_relatedmodule_permission` (
  `shareid` int(11) NOT NULL,
  `datashare_relatedmodule_id` int(11) NOT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`,`datashare_relatedmodule_id`),
  KEY `datashare_relatedmodule_permission_shareid_permissions_idx` (`shareid`,`permission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_relatedmodule_permission`
--


--
-- Table structure for table `vtiger_datashare_relatedmodules`
--

CREATE TABLE `vtiger_datashare_relatedmodules` (
  `datashare_relatedmodule_id` int(11) NOT NULL,
  `tabid` int(11) DEFAULT NULL,
  `relatedto_tabid` int(11) DEFAULT NULL,
  PRIMARY KEY (`datashare_relatedmodule_id`),
  KEY `datashare_relatedmodules_tabid_idx` (`tabid`),
  KEY `datashare_relatedmodules_relatedto_tabid_idx` (`relatedto_tabid`),
  CONSTRAINT `fk_2_vtiger_datashare_relatedmodules` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_relatedmodules`
--

INSERT INTO `vtiger_datashare_relatedmodules` VALUES (1,6,2),(2,6,13),(3,6,20),(4,6,22),(5,6,23),(6,2,20),(7,2,22),(8,20,22),(9,22,23);

--
-- Table structure for table `vtiger_datashare_relatedmodules_seq`
--

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

--
-- Dumping data for table `vtiger_datashare_relatedmodules_seq`
--

INSERT INTO `vtiger_datashare_relatedmodules_seq` VALUES (9);

--
-- Table structure for table `vtiger_datashare_role2group`
--

CREATE TABLE `vtiger_datashare_role2group` (
  `shareid` int(11) NOT NULL,
  `share_roleid` varchar(255) DEFAULT NULL,
  `to_groupid` int(11) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `idx_datashare_role2group_share_roleid` (`share_roleid`),
  KEY `idx_datashare_role2group_to_groupid` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_role2group` FOREIGN KEY (`share_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_role2group`
--


--
-- Table structure for table `vtiger_datashare_role2role`
--

CREATE TABLE `vtiger_datashare_role2role` (
  `shareid` int(11) NOT NULL,
  `share_roleid` varchar(255) DEFAULT NULL,
  `to_roleid` varchar(255) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_role2role_share_roleid_idx` (`share_roleid`),
  KEY `datashare_role2role_to_roleid_idx` (`to_roleid`),
  CONSTRAINT `fk_3_vtiger_datashare_role2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_role2role`
--


--
-- Table structure for table `vtiger_datashare_role2rs`
--

CREATE TABLE `vtiger_datashare_role2rs` (
  `shareid` int(11) NOT NULL,
  `share_roleid` varchar(255) DEFAULT NULL,
  `to_roleandsubid` varchar(255) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_role2s_share_roleid_idx` (`share_roleid`),
  KEY `datashare_role2s_to_roleandsubid_idx` (`to_roleandsubid`),
  CONSTRAINT `fk_3_vtiger_datashare_role2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_role2rs`
--


--
-- Table structure for table `vtiger_datashare_rs2grp`
--

CREATE TABLE `vtiger_datashare_rs2grp` (
  `shareid` int(11) NOT NULL,
  `share_roleandsubid` varchar(255) DEFAULT NULL,
  `to_groupid` int(11) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_rs2grp_share_roleandsubid_idx` (`share_roleandsubid`),
  KEY `datashare_rs2grp_to_groupid_idx` (`to_groupid`),
  CONSTRAINT `fk_3_vtiger_datashare_rs2grp` FOREIGN KEY (`share_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_rs2grp`
--


--
-- Table structure for table `vtiger_datashare_rs2role`
--

CREATE TABLE `vtiger_datashare_rs2role` (
  `shareid` int(11) NOT NULL,
  `share_roleandsubid` varchar(255) DEFAULT NULL,
  `to_roleid` varchar(255) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_rs2role_share_roleandsubid_idx` (`share_roleandsubid`),
  KEY `datashare_rs2role_to_roleid_idx` (`to_roleid`),
  CONSTRAINT `fk_3_vtiger_datashare_rs2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_rs2role`
--


--
-- Table structure for table `vtiger_datashare_rs2rs`
--

CREATE TABLE `vtiger_datashare_rs2rs` (
  `shareid` int(11) NOT NULL,
  `share_roleandsubid` varchar(255) DEFAULT NULL,
  `to_roleandsubid` varchar(255) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`shareid`),
  KEY `datashare_rs2rs_share_roleandsubid_idx` (`share_roleandsubid`),
  KEY `idx_datashare_rs2rs_to_roleandsubid_idx` (`to_roleandsubid`),
  CONSTRAINT `fk_3_vtiger_datashare_rs2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_datashare_rs2rs`
--


--
-- Table structure for table `vtiger_date_format`
--

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

--
-- Dumping data for table `vtiger_date_format`
--

INSERT INTO `vtiger_date_format` VALUES (1,'dd-mm-yyyy',0,1),(2,'mm-dd-yyyy',1,1),(3,'yyyy-mm-dd',2,1),(4,'dd.mm.yyyy',3,1),(5,'dd/mm/yyyy',4,1);

--
-- Table structure for table `vtiger_date_format_seq`
--

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

--
-- Dumping data for table `vtiger_date_format_seq`
--

INSERT INTO `vtiger_date_format_seq` VALUES (3);

--
-- Table structure for table `vtiger_dayoftheweek`
--

CREATE TABLE `vtiger_dayoftheweek` (
  `dayoftheweekid` int(11) NOT NULL AUTO_INCREMENT,
  `dayoftheweek` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`dayoftheweekid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_dayoftheweek`
--

INSERT INTO `vtiger_dayoftheweek` VALUES (1,'Sunday',0,1),(2,'Monday',1,1),(3,'Tuesday',2,1),(4,'Wednesday',3,1),(5,'Thursday',4,1),(6,'Friday',5,1),(7,'Saturday',6,1);

--
-- Table structure for table `vtiger_dayoftheweek_seq`
--

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

--
-- Dumping data for table `vtiger_dayoftheweek_seq`
--

INSERT INTO `vtiger_dayoftheweek_seq` VALUES (7);

--
-- Table structure for table `vtiger_def_org_field`
--

CREATE TABLE `vtiger_def_org_field` (
  `tabid` int(11) DEFAULT NULL,
  `fieldid` int(11) NOT NULL,
  `visible` int(11) DEFAULT NULL,
  `readonly` int(11) DEFAULT NULL,
  PRIMARY KEY (`fieldid`),
  KEY `def_org_field_tabid_fieldid_idx` (`tabid`,`fieldid`),
  KEY `def_org_field_tabid_idx` (`tabid`),
  KEY `def_org_field_visible_fieldid_idx` (`visible`,`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_def_org_field`
--

INSERT INTO `vtiger_def_org_field` VALUES (6,1,0,0),(6,2,0,0),(6,3,0,0),(6,4,0,0),(6,5,0,0),(6,6,0,0),(6,7,0,0),(6,8,0,0),(6,9,0,0),(6,10,0,0),(6,11,0,0),(6,12,0,0),(6,13,0,0),(6,14,0,0),(6,15,0,0),(6,16,0,0),(6,17,0,0),(6,18,0,0),(6,19,0,0),(6,20,0,0),(6,21,0,0),(6,22,0,0),(6,23,0,0),(6,24,0,0),(6,25,0,0),(6,26,0,0),(6,27,0,0),(6,28,0,0),(6,29,0,0),(6,30,0,0),(6,31,0,0),(6,32,0,0),(6,33,0,0),(6,34,0,0),(6,35,0,0),(6,36,0,0),(7,37,0,0),(7,38,0,0),(7,39,0,0),(7,40,0,0),(7,41,0,0),(7,42,0,0),(7,43,0,0),(7,44,0,0),(7,45,0,0),(7,46,0,0),(7,47,0,0),(7,48,0,0),(7,49,0,0),(7,50,0,0),(7,51,0,0),(7,52,0,0),(7,53,0,0),(7,54,0,0),(7,55,0,0),(7,56,0,0),(7,57,0,0),(7,58,0,0),(7,59,0,0),(7,60,0,0),(7,61,0,0),(7,62,0,0),(7,63,0,0),(7,64,0,0),(7,65,0,0),(4,66,0,0),(4,67,0,0),(4,68,0,0),(4,69,0,0),(4,70,0,0),(4,71,0,0),(4,72,0,0),(4,73,0,0),(4,74,0,0),(4,75,0,0),(4,76,0,0),(4,77,0,0),(4,78,0,0),(4,79,0,0),(4,80,0,0),(4,81,0,0),(4,82,0,0),(4,83,0,0),(4,84,0,0),(4,85,0,0),(4,86,0,0),(4,87,0,0),(4,88,0,0),(4,89,0,0),(4,90,0,0),(4,91,0,0),(4,92,0,0),(4,93,0,0),(4,94,0,0),(4,95,0,0),(4,96,0,0),(4,97,0,0),(4,98,0,0),(4,99,0,0),(4,100,0,0),(4,101,0,0),(4,102,0,0),(4,103,0,0),(4,104,0,0),(4,105,0,0),(4,106,0,0),(4,107,0,0),(4,108,0,0),(4,109,0,0),(2,110,0,0),(2,111,0,0),(2,112,0,0),(2,113,0,0),(2,114,0,0),(2,115,0,0),(2,116,0,0),(2,117,0,0),(2,118,0,0),(2,119,0,0),(2,120,0,0),(2,121,0,0),(2,122,0,0),(2,123,0,0),(2,124,0,0),(2,125,0,0),(26,126,0,0),(26,127,0,0),(26,128,0,0),(26,129,0,0),(26,130,0,0),(26,131,0,0),(26,132,0,0),(26,133,0,0),(26,134,0,0),(26,135,0,0),(26,136,0,0),(26,137,0,0),(26,138,0,0),(26,139,0,0),(26,140,0,0),(26,141,0,0),(26,142,0,0),(26,143,0,0),(26,144,0,0),(26,145,0,0),(26,146,0,0),(26,147,0,0),(26,148,0,0),(26,149,0,0),(26,150,0,0),(4,151,0,0),(6,152,0,0),(7,153,0,0),(26,154,0,0),(13,155,0,0),(13,156,0,0),(13,157,0,0),(13,158,0,0),(13,159,0,0),(13,160,0,0),(13,161,0,0),(13,162,0,0),(13,163,0,0),(13,164,0,0),(13,165,0,0),(13,166,0,0),(13,167,0,0),(13,168,0,0),(13,169,0,0),(13,170,0,0),(13,171,0,0),(13,172,0,0),(13,173,0,0),(14,174,0,0),(14,175,0,0),(14,176,0,0),(14,177,0,0),(14,178,0,0),(14,179,0,0),(14,180,0,0),(14,181,0,0),(14,182,0,0),(14,183,0,0),(14,184,0,0),(14,185,0,0),(14,186,0,0),(14,187,0,0),(14,188,0,0),(14,189,0,0),(14,190,0,0),(14,191,0,0),(14,192,0,0),(14,193,0,0),(14,194,0,0),(14,195,0,0),(14,196,0,0),(14,197,0,0),(14,198,0,0),(14,199,0,0),(14,200,0,0),(14,201,0,0),(14,202,0,0),(14,203,0,0),(14,204,0,0),(8,205,0,0),(8,206,0,0),(8,207,0,0),(8,208,0,0),(8,209,0,0),(8,210,0,0),(8,211,0,0),(8,212,0,0),(8,213,0,0),(8,214,0,0),(8,215,0,0),(8,216,0,0),(8,217,0,0),(8,218,0,0),(8,219,0,0),(10,220,0,0),(10,221,0,0),(10,222,0,0),(10,223,0,0),(10,224,0,0),(10,225,0,0),(10,226,0,0),(10,227,0,0),(10,228,0,0),(10,229,0,0),(10,230,0,0),(10,231,0,0),(9,232,0,0),(9,233,0,0),(9,234,0,0),(9,235,0,0),(9,236,0,0),(9,237,0,0),(9,238,0,0),(9,239,0,0),(9,240,0,0),(9,241,0,0),(9,242,0,0),(9,243,0,0),(9,244,0,0),(9,245,0,0),(9,246,0,0),(9,247,0,0),(9,248,0,0),(9,249,0,0),(9,250,0,0),(9,251,0,0),(9,252,0,0),(9,253,0,0),(9,254,0,0),(9,255,0,0),(16,256,0,0),(16,257,0,0),(16,258,0,0),(16,259,0,0),(16,260,0,0),(16,261,0,0),(16,262,0,0),(16,263,0,0),(16,264,0,0),(16,265,0,0),(16,266,0,0),(16,267,0,0),(16,268,0,0),(16,269,0,0),(16,270,0,0),(16,271,0,0),(16,272,0,0),(16,273,0,0),(16,274,0,0),(16,275,0,0),(16,276,0,0),(16,277,0,0),(16,278,0,0),(15,279,0,0),(15,280,0,0),(15,281,0,0),(15,282,0,0),(15,283,0,0),(15,284,0,0),(15,285,0,0),(15,286,0,0),(15,287,0,0),(15,288,0,0),(18,289,0,0),(18,290,0,0),(18,291,0,0),(18,292,0,0),(18,293,0,0),(18,294,0,0),(18,295,0,0),(18,296,0,0),(18,297,0,0),(18,298,0,0),(18,299,0,0),(18,300,0,0),(18,301,0,0),(18,302,0,0),(18,303,0,0),(18,304,0,0),(18,305,0,0),(19,306,0,0),(19,307,0,0),(19,308,0,0),(19,309,0,0),(19,310,0,0),(19,311,0,0),(19,312,0,0),(19,313,0,0),(20,314,0,0),(20,315,0,0),(20,316,0,0),(20,317,0,0),(20,318,0,0),(20,319,0,0),(20,320,0,0),(20,321,0,0),(20,322,0,0),(20,323,0,0),(20,324,0,0),(20,325,0,0),(20,326,0,0),(20,327,0,0),(20,328,0,0),(20,329,0,0),(20,330,0,0),(20,331,0,0),(20,332,0,0),(20,333,0,0),(20,334,0,0),(20,335,0,0),(20,336,0,0),(20,337,0,0),(20,338,0,0),(20,339,0,0),(20,340,0,0),(20,341,0,0),(20,342,0,0),(20,343,0,0),(20,344,0,0),(20,345,0,0),(20,346,0,0),(20,347,0,0),(20,348,0,0),(20,349,0,0),(20,350,0,0),(21,351,0,0),(21,352,0,0),(21,353,0,0),(21,354,0,0),(21,355,0,0),(21,356,0,0),(21,357,0,0),(21,358,0,0),(21,359,0,0),(21,360,0,0),(21,361,0,0),(21,362,0,0),(21,363,0,0),(21,364,0,0),(21,365,0,0),(21,366,0,0),(21,367,0,0),(21,368,0,0),(21,369,0,0),(21,370,0,0),(21,371,0,0),(21,372,0,0),(21,373,0,0),(21,374,0,0),(21,375,0,0),(21,376,0,0),(21,377,0,0),(21,378,0,0),(21,379,0,0),(21,380,0,0),(21,381,0,0),(21,382,0,0),(21,383,0,0),(21,384,0,0),(21,385,0,0),(21,386,0,0),(21,387,0,0),(21,388,0,0),(22,389,0,0),(22,390,0,0),(22,391,0,0),(22,392,0,0),(22,393,0,0),(22,394,0,0),(22,395,0,0),(22,396,0,0),(22,397,0,0),(22,398,0,0),(22,399,0,0),(22,400,0,0),(22,401,0,0),(22,402,0,0),(22,403,0,0),(22,404,0,0),(22,405,0,0),(22,406,0,0),(22,407,0,0),(22,408,0,0),(22,409,0,0),(22,410,0,0),(22,411,0,0),(22,412,0,0),(22,413,0,0),(22,414,0,0),(22,415,0,0),(22,416,0,0),(22,417,0,0),(22,418,0,0),(22,419,0,0),(22,420,0,0),(22,421,0,0),(22,422,0,0),(22,423,0,0),(22,424,0,0),(22,425,0,0),(22,426,0,0),(22,427,0,0),(22,428,0,0),(22,429,0,0),(22,430,0,0),(22,431,0,0),(22,432,0,0),(22,433,0,0),(22,434,0,0),(22,435,0,0),(23,436,0,0),(23,437,0,0),(23,438,0,0),(23,439,0,0),(23,440,0,0),(23,441,0,0),(23,442,0,0),(23,443,0,0),(23,444,0,0),(23,445,0,0),(23,446,0,0),(23,447,0,0),(23,448,0,0),(23,449,0,0),(23,450,0,0),(23,451,0,0),(23,452,0,0),(23,453,0,0),(23,454,0,0),(23,455,0,0),(23,456,0,0),(23,457,0,0),(23,458,0,0),(23,459,0,0),(23,460,0,0),(23,461,0,0),(23,462,0,0),(23,463,0,0),(23,464,0,0),(23,465,0,0),(23,466,0,0),(23,467,0,0),(23,468,0,0),(23,469,0,0),(23,470,0,0),(23,471,0,0),(23,472,0,0),(23,473,0,0),(23,474,0,0),(29,475,0,0),(29,479,0,0),(29,480,0,0),(29,481,0,0),(29,482,0,0),(29,489,0,0),(29,490,0,0),(29,491,0,0),(29,492,0,0),(29,493,0,0),(29,494,0,0),(29,495,0,0),(29,496,0,0),(29,497,0,0),(29,498,0,0),(29,499,0,0),(29,504,0,0),(29,505,0,0),(29,506,0,0),(29,507,0,0),(29,510,0,0),(29,515,0,0),(10,520,0,0),(10,521,0,0),(10,522,0,0),(10,523,0,0),(10,524,0,0),(10,525,0,0),(34,526,0,0),(34,527,0,0),(34,528,0,0),(34,529,0,0),(34,530,0,0),(34,531,0,0),(34,532,0,0),(34,533,0,0),(34,534,0,0),(34,535,0,0),(34,536,0,0),(34,537,0,0),(34,538,0,0),(34,539,0,0),(34,540,0,0),(34,541,0,0),(34,542,0,0),(29,543,0,0),(35,544,0,0),(35,545,0,0),(35,546,0,0),(35,547,0,0),(35,548,0,0),(35,549,0,0),(35,550,0,0),(35,551,0,0),(35,552,0,0),(35,553,0,0),(35,554,0,0),(35,555,0,0),(35,556,0,0),(35,557,0,0),(35,558,0,0),(35,559,0,0),(35,560,0,0),(35,561,0,0),(35,562,0,0),(35,563,0,0),(35,564,0,0),(35,565,0,0),(36,566,0,0),(36,567,0,0),(36,568,0,0),(36,569,0,0),(36,570,0,0),(36,571,0,0),(36,572,0,0),(36,573,0,0),(36,574,0,0),(36,575,0,0),(36,576,0,0),(36,577,0,0),(36,578,0,0),(36,579,0,0),(36,580,0,0),(36,581,0,0),(36,582,0,0),(36,583,0,0),(36,584,0,0),(36,585,0,0),(36,586,0,0),(36,587,0,0),(38,588,0,0),(38,589,0,0),(38,590,0,0),(38,591,0,0),(38,592,0,0),(38,593,0,0),(38,594,0,0),(38,595,0,0),(38,596,0,0),(38,597,0,0),(38,598,0,0),(38,599,0,0),(38,600,0,0),(38,601,0,0),(38,602,0,0),(38,603,0,0),(38,604,0,0),(38,605,0,0),(38,606,0,0),(38,607,0,0),(38,608,0,0),(42,609,0,0),(42,610,0,0),(42,611,0,0),(42,612,0,0),(42,613,0,0),(42,614,0,0),(42,615,0,0),(42,616,0,0),(43,617,0,0),(43,618,0,0),(43,619,0,0),(43,620,0,0),(43,621,0,0),(43,622,0,0),(43,623,0,0),(43,624,0,0),(43,625,0,0),(43,626,0,0),(43,627,0,0),(43,628,0,0),(43,629,0,0),(44,630,0,0),(44,631,0,0),(44,632,0,0),(44,633,0,0),(44,634,0,0),(44,635,0,0),(44,636,0,0),(44,637,0,0),(44,638,0,0),(44,639,0,0),(44,640,0,0),(44,641,0,0),(44,642,0,0),(44,643,0,0),(44,644,0,0),(44,645,0,0),(44,646,0,0),(44,647,0,0),(45,648,0,0),(45,649,0,0),(45,650,0,0),(45,651,0,0),(45,652,0,0),(45,653,0,0),(45,654,0,0),(45,655,0,0),(45,656,0,0),(45,657,0,0),(45,658,0,0),(45,659,0,0),(45,660,0,0),(45,661,0,0),(45,662,0,0),(45,663,0,0),(45,664,0,0),(45,665,0,0),(45,666,0,0),(45,667,0,0),(47,668,0,0),(47,669,0,0),(47,670,0,0),(47,671,0,0),(47,672,0,0),(47,673,0,0),(2,674,0,0),(29,675,0,0),(23,676,0,0),(23,677,0,0),(23,678,0,0),(23,679,0,0),(23,680,0,0),(23,681,0,0),(23,682,0,0),(23,683,0,0),(23,684,0,0),(22,685,0,0),(22,686,0,0),(22,687,0,0),(22,688,0,0),(22,689,0,0),(22,690,0,0),(22,691,0,0),(22,692,0,0),(22,693,0,0),(21,694,0,0),(21,695,0,0),(21,696,0,0),(21,697,0,0),(21,698,0,0),(21,699,0,0),(21,700,0,0),(21,701,0,0),(21,702,0,0),(20,703,0,0),(20,704,0,0),(20,705,0,0),(20,706,0,0),(20,707,0,0),(20,708,0,0),(20,709,0,0),(20,710,0,0),(20,711,0,0),(29,712,0,0),(44,713,0,0),(42,714,0,0),(29,715,0,0),(29,716,0,0),(29,717,0,0),(23,718,0,0),(22,719,0,0),(21,720,0,0),(20,721,0,0),(29,722,0,0),(6,723,0,0),(4,724,0,0),(2,725,0,0),(29,726,0,0),(23,727,0,0),(23,728,0,0),(21,729,0,0),(21,730,0,0),(18,731,0,0),(7,732,0,0),(42,733,0,0),(42,734,0,0),(23,735,0,0),(20,736,0,0),(21,737,0,0),(22,738,0,0),(29,739,0,0),(2,740,0,0),(13,741,0,0),(29,742,0,0),(29,743,0,0),(29,744,0,0),(29,745,0,0),(14,772,0,0),(36,773,0,0),(23,774,0,0),(29,775,0,0),(23,776,0,0),(23,777,0,0),(23,778,0,0),(20,779,0,0),(20,780,0,0),(20,781,0,0),(21,782,0,0),(22,783,0,0),(22,784,0,0),(22,785,0,0),(42,786,0,0),(42,787,0,0),(42,788,0,0),(2,789,0,0),(4,790,0,0),(6,791,0,0),(7,792,0,0),(8,793,0,0),(9,794,0,0),(10,795,0,0),(13,796,0,0),(14,797,0,0),(15,798,0,0),(16,799,0,0),(18,800,0,0),(19,801,0,0),(20,802,0,0),(21,803,0,0),(22,804,0,0),(23,805,0,0),(26,806,0,0),(10,807,0,0),(2,808,0,0),(4,809,0,0),(6,810,0,0),(7,811,0,0),(8,812,0,0),(9,813,0,0),(10,814,0,0),(13,815,0,0),(14,816,0,0),(15,817,0,0),(16,818,0,0),(18,819,0,0),(19,820,0,0),(20,821,0,0),(21,822,0,0),(22,823,0,0),(23,824,0,0),(26,825,0,0),(2,826,0,0),(4,827,0,0),(6,828,0,0),(7,829,0,0),(8,830,0,0),(9,831,0,0),(10,832,0,0),(13,833,0,0),(14,834,0,0),(15,835,0,0),(16,836,0,0),(18,837,0,0),(19,838,0,0),(20,839,0,0),(21,840,0,0),(22,841,0,0),(23,842,0,0),(26,843,0,0),(20,844,0,0),(21,845,0,0),(22,846,0,0),(23,847,0,0),(45,848,0,0),(45,849,0,0),(29,850,0,0),(22,851,0,0),(29,852,0,0),(13,856,0,0),(6,858,0,0),(13,860,0,0),(13,862,0,0),(13,864,0,0),(13,866,0,0),(4,868,0,0),(13,870,0,0),(13,872,0,0),(13,874,0,0),(13,876,0,0),(13,878,0,0),(13,880,0,0),(13,882,0,0),(13,884,0,0),(13,886,0,0),(13,892,0,0),(13,894,0,0),(13,896,0,0),(13,898,0,0),(6,900,0,0),(13,901,0,0);

--
-- Table structure for table `vtiger_def_org_share`
--

CREATE TABLE `vtiger_def_org_share` (
  `ruleid` int(11) NOT NULL AUTO_INCREMENT,
  `tabid` int(11) NOT NULL,
  `permission` int(11) DEFAULT NULL,
  `editstatus` int(11) DEFAULT NULL,
  PRIMARY KEY (`ruleid`),
  KEY `fk_1_vtiger_def_org_share` (`permission`),
  CONSTRAINT `fk_1_vtiger_def_org_share` FOREIGN KEY (`permission`) REFERENCES `vtiger_org_share_action_mapping` (`share_action_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_def_org_share`
--

INSERT INTO `vtiger_def_org_share` VALUES (1,2,2,0),(2,4,2,0),(3,6,2,0),(4,7,2,0),(5,9,2,1),(6,13,3,0),(7,16,2,2),(8,20,2,0),(9,21,2,0),(10,22,2,0),(11,23,2,0),(12,26,2,0),(13,8,3,0),(14,14,2,0),(15,34,3,0),(16,35,3,0),(17,36,2,0),(18,38,2,0),(19,42,2,0),(20,43,2,0),(21,44,2,0),(22,45,2,0),(23,47,2,0),(24,18,2,0),(25,10,2,0);

--
-- Table structure for table `vtiger_def_org_share_seq`
--

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

--
-- Dumping data for table `vtiger_def_org_share_seq`
--

INSERT INTO `vtiger_def_org_share_seq` VALUES (25);

--
-- Table structure for table `vtiger_default_record_view`
--

CREATE TABLE `vtiger_default_record_view` (
  `default_record_viewid` int(11) NOT NULL AUTO_INCREMENT,
  `default_record_view` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`default_record_viewid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_default_record_view`
--

INSERT INTO `vtiger_default_record_view` VALUES (1,'Summary',0,1),(2,'Detail',1,1);

--
-- Table structure for table `vtiger_default_record_view_seq`
--

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

--
-- Dumping data for table `vtiger_default_record_view_seq`
--

INSERT INTO `vtiger_default_record_view_seq` VALUES (2);

--
-- Table structure for table `vtiger_defaultactivitytype`
--

CREATE TABLE `vtiger_defaultactivitytype` (
  `defaultactivitytypeid` int(11) NOT NULL AUTO_INCREMENT,
  `defaultactivitytype` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  PRIMARY KEY (`defaultactivitytypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_defaultactivitytype`
--

INSERT INTO `vtiger_defaultactivitytype` VALUES (1,'Call',1,299,1),(2,'Meeting',1,300,2);

--
-- Table structure for table `vtiger_defaultactivitytype_seq`
--

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

--
-- Dumping data for table `vtiger_defaultactivitytype_seq`
--

INSERT INTO `vtiger_defaultactivitytype_seq` VALUES (2);

--
-- Table structure for table `vtiger_defaultcalendarview`
--

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

--
-- Dumping data for table `vtiger_defaultcalendarview`
--

INSERT INTO `vtiger_defaultcalendarview` VALUES (1,'ListView',0,1),(2,'MyCalendar',1,1),(3,'SharedCalendar',2,1);

--
-- Table structure for table `vtiger_defaultcalendarview_seq`
--

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

--
-- Dumping data for table `vtiger_defaultcalendarview_seq`
--

INSERT INTO `vtiger_defaultcalendarview_seq` VALUES (3);

--
-- Table structure for table `vtiger_defaultcv`
--

CREATE TABLE `vtiger_defaultcv` (
  `tabid` int(11) NOT NULL,
  `defaultviewname` varchar(50) NOT NULL,
  `query` text DEFAULT NULL,
  PRIMARY KEY (`tabid`),
  CONSTRAINT `fk_1_vtiger_defaultcv` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_defaultcv`
--


--
-- Table structure for table `vtiger_defaulteventstatus`
--

CREATE TABLE `vtiger_defaulteventstatus` (
  `defaulteventstatusid` int(11) NOT NULL AUTO_INCREMENT,
  `defaulteventstatus` varchar(200) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `picklist_valueid` int(11) NOT NULL DEFAULT 0,
  `sortorderid` int(11) DEFAULT 0,
  PRIMARY KEY (`defaulteventstatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_defaulteventstatus`
--

INSERT INTO `vtiger_defaulteventstatus` VALUES (1,'Planned',1,296,1),(2,'Held',1,297,2),(3,'Not Held',1,298,3);

--
-- Table structure for table `vtiger_defaulteventstatus_seq`
--

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

--
-- Dumping data for table `vtiger_defaulteventstatus_seq`
--

INSERT INTO `vtiger_defaulteventstatus_seq` VALUES (3);

--
-- Table structure for table `vtiger_defaultlandingpage`
--

CREATE TABLE `vtiger_defaultlandingpage` (
  `defaultlandingpageid` int(11) NOT NULL AUTO_INCREMENT,
  `defaultlandingpage` 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 (`defaultlandingpageid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_defaultlandingpage`
--

INSERT INTO `vtiger_defaultlandingpage` VALUES (1,'true',1,303,1,NULL),(2,'false',1,304,2,NULL);

--
-- Table structure for table `vtiger_defaultlandingpage_seq`
--

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

--
-- Dumping data for table `vtiger_defaultlandingpage_seq`
--

INSERT INTO `vtiger_defaultlandingpage_seq` VALUES (2);

--
-- Table structure for table `vtiger_duration_minutes`
--

CREATE TABLE `vtiger_duration_minutes` (
  `minutesid` int(11) NOT NULL AUTO_INCREMENT,
  `duration_minutes` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`minutesid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_duration_minutes`
--

INSERT INTO `vtiger_duration_minutes` VALUES (1,'00',0,1,NULL),(2,'15',1,1,NULL),(3,'30',2,1,NULL),(4,'45',3,1,NULL);

--
-- Table structure for table `vtiger_duration_minutes_seq`
--

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

--
-- Dumping data for table `vtiger_duration_minutes_seq`
--

INSERT INTO `vtiger_duration_minutes_seq` VALUES (4);

--
-- Table structure for table `vtiger_durationhrs`
--

CREATE TABLE `vtiger_durationhrs` (
  `hrsid` int(11) NOT NULL AUTO_INCREMENT,
  `hrs` varchar(50) DEFAULT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`hrsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_durationhrs`
--


--
-- Table structure for table `vtiger_durationmins`
--

CREATE TABLE `vtiger_durationmins` (
  `minsid` int(11) NOT NULL AUTO_INCREMENT,
  `mins` varchar(50) DEFAULT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`minsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_durationmins`
--


--
-- Table structure for table `vtiger_email_access`
--

CREATE TABLE `vtiger_email_access` (
  `crmid` int(11) DEFAULT NULL,
  `mailid` int(11) DEFAULT NULL,
  `accessdate` date DEFAULT NULL,
  `accesstime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_email_access`
--

INSERT INTO `vtiger_email_access` VALUES (36,55,'2023-03-21','2023-03-21 02:22:46'),(38,56,'2023-03-21','2023-03-21 02:25:09'),(77,135,'2023-04-15','2023-04-15 03:17:47'),(78,136,'2023-04-15','2023-04-15 03:18:03'),(132,194,'2023-04-15','2023-04-15 03:18:18'),(131,193,'2023-04-15','2023-04-15 03:18:40'),(131,192,'2023-04-15','2023-04-15 03:18:54'),(130,190,'2023-04-15','2023-04-15 05:56:41'),(105,164,'2023-04-15','2023-04-15 06:02:23'),(104,163,'2023-04-15','2023-04-15 06:02:45'),(103,162,'2023-04-15','2023-04-15 06:02:55'),(102,161,'2023-04-15','2023-04-15 06:02:56'),(101,160,'2023-04-15','2023-04-15 06:03:18'),(100,159,'2023-04-15','2023-04-15 06:03:19'),(99,158,'2023-04-15','2023-04-15 06:03:20'),(98,157,'2023-04-15','2023-04-15 06:03:20'),(97,156,'2023-04-15','2023-04-15 06:03:22'),(95,154,'2023-04-15','2023-04-15 06:03:23'),(132,197,'2023-04-17','2023-04-17 20:22:05'),(200,202,'2023-04-18','2023-04-18 19:15:42'),(130,190,'2023-04-20','2023-04-20 04:48:31'),(127,213,'2023-04-20','2023-04-20 18:39:23'),(128,214,'2023-04-20','2023-04-20 18:57:08'),(130,215,'2023-04-20','2023-04-20 19:00:38'),(130,216,'2023-04-20','2023-04-20 20:07:26'),(223,225,'2023-04-20','2023-04-20 21:24:11'),(228,230,'2023-04-20','2023-04-20 22:38:13'),(227,229,'2023-04-20','2023-04-20 22:38:27'),(218,219,'2023-04-20','2023-04-20 22:44:32'),(223,225,'2023-04-20','2023-04-20 22:45:15'),(250,251,'2023-04-20','2023-04-20 22:56:35'),(256,260,'2023-04-21','2023-04-21 01:04:15'),(272,274,'2023-04-21','2023-04-21 02:37:10'),(256,260,'2023-04-21','2023-04-21 02:37:13'),(250,251,'2023-04-21','2023-04-21 02:37:28'),(218,219,'2023-04-21','2023-04-21 02:37:39'),(207,211,'2023-04-21','2023-04-21 02:37:58'),(132,197,'2023-04-21','2023-04-21 02:39:03'),(200,205,'2023-04-21','2023-04-21 17:34:49'),(200,201,'2023-04-21','2023-04-21 17:34:49'),(200,204,'2023-04-21','2023-04-21 17:34:49'),(200,206,'2023-04-21','2023-04-21 17:34:49'),(285,286,'2023-04-22','2023-04-22 02:58:39'),(130,216,'2023-04-22','2023-04-22 03:15:59'),(200,206,'2023-04-24','2023-04-24 15:45:13'),(200,201,'2023-04-24','2023-04-24 15:45:27'),(130,216,'2023-04-27','2023-04-27 23:37:57'),(287,289,'2023-04-29','2023-04-29 02:19:55'),(285,286,'2023-04-30','2023-04-30 21:57:23'),(287,288,'2023-05-02','2023-05-02 17:10:54'),(290,292,'2023-05-04','2023-05-04 23:23:18'),(130,216,'2023-05-07','2023-05-07 07:35:32'),(130,215,'2023-05-08','2023-05-08 17:31:09'),(130,190,'2023-05-08','2023-05-08 17:31:35'),(129,189,'2023-05-08','2023-05-08 17:31:36'),(293,294,'2023-05-08','2023-05-08 18:08:29'),(293,294,'2023-05-09','2023-05-09 01:36:51'),(290,302,'2023-05-09','2023-05-09 03:16:53'),(290,298,'2023-05-09','2023-05-09 03:16:53'),(290,311,'2023-05-09','2023-05-09 03:16:53'),(290,308,'2023-05-09','2023-05-09 03:16:53'),(290,297,'2023-05-09','2023-05-09 03:16:53'),(290,300,'2023-05-09','2023-05-09 03:16:53'),(290,301,'2023-05-09','2023-05-09 03:16:53'),(290,305,'2023-05-09','2023-05-09 03:16:53'),(290,312,'2023-05-09','2023-05-09 03:16:53'),(290,303,'2023-05-09','2023-05-09 03:16:53'),(290,299,'2023-05-09','2023-05-09 03:16:53'),(290,309,'2023-05-09','2023-05-09 03:16:53'),(290,306,'2023-05-09','2023-05-09 03:16:53'),(290,310,'2023-05-09','2023-05-09 03:16:54'),(290,314,'2023-05-09','2023-05-09 03:16:54'),(290,307,'2023-05-09','2023-05-09 03:16:54'),(290,304,'2023-05-09','2023-05-09 03:16:54'),(130,215,'2023-05-09','2023-05-09 04:39:08'),(285,286,'2023-05-09','2023-05-09 04:55:23'),(130,318,'2023-05-09','2023-05-09 08:48:42'),(130,318,'2023-05-09','2023-05-09 10:31:00'),(290,314,'2023-05-09','2023-05-09 15:04:13'),(290,314,'2023-05-10','2023-05-10 14:28:54'),(290,325,'2023-05-10','2023-05-10 17:51:32'),(290,328,'2023-05-10','2023-05-10 17:51:40'),(344,346,'2023-05-10','2023-05-10 18:18:28'),(290,342,'2023-05-10','2023-05-10 18:18:30'),(290,339,'2023-05-10','2023-05-10 18:18:36'),(290,335,'2023-05-10','2023-05-10 18:18:39'),(290,322,'2023-05-10','2023-05-10 18:20:01'),(344,345,'2023-05-10','2023-05-10 18:20:13'),(290,343,'2023-05-10','2023-05-10 18:20:16'),(290,341,'2023-05-10','2023-05-10 18:20:22'),(290,340,'2023-05-10','2023-05-10 18:20:23'),(290,338,'2023-05-10','2023-05-10 18:20:24'),(290,337,'2023-05-10','2023-05-10 18:20:25'),(290,336,'2023-05-10','2023-05-10 18:20:26'),(290,334,'2023-05-10','2023-05-10 18:20:26'),(290,333,'2023-05-10','2023-05-10 18:20:27'),(290,332,'2023-05-10','2023-05-10 18:20:28'),(290,329,'2023-05-10','2023-05-10 18:20:28'),(290,327,'2023-05-10','2023-05-10 18:20:29'),(290,326,'2023-05-10','2023-05-10 18:20:30'),(290,324,'2023-05-10','2023-05-10 18:20:30'),(112,171,'2023-05-10','2023-05-10 18:40:22'),(118,178,'2023-05-10','2023-05-10 18:51:16'),(110,169,'2023-05-10','2023-05-10 18:53:31'),(233,237,'2023-05-10','2023-05-10 18:55:44'),(285,286,'2023-05-10','2023-05-10 18:59:09'),(248,249,'2023-05-10','2023-05-10 19:00:31'),(290,339,'2023-05-10','2023-05-10 20:44:10'),(248,249,'2023-05-10','2023-05-10 21:48:06'),(119,358,'2023-05-10','2023-05-10 21:57:10'),(233,356,'2023-05-10','2023-05-10 21:57:17'),(293,294,'2023-05-10','2023-05-10 21:57:30'),(359,360,'2023-05-10','2023-05-10 23:17:03'),(344,346,'2023-05-11','2023-05-11 00:47:01'),(365,366,'2023-05-11','2023-05-11 02:05:57'),(367,370,'2023-05-11','2023-05-11 02:36:38'),(367,369,'2023-05-11','2023-05-11 02:48:30'),(371,372,'2023-05-11','2023-05-11 02:55:43'),(359,360,'2023-05-11','2023-05-11 03:08:44'),(385,386,'2023-05-11','2023-05-11 03:24:15'),(387,389,'2023-05-11','2023-05-11 07:23:49'),(385,386,'2023-05-11','2023-05-11 08:28:30'),(396,397,'2023-05-11','2023-05-11 09:44:55'),(391,393,'2023-05-11','2023-05-11 09:56:45'),(367,400,'2023-05-11','2023-05-11 19:10:28'),(396,397,'2023-05-11','2023-05-11 20:17:11'),(367,400,'2023-05-12','2023-05-12 00:45:29'),(401,402,'2023-05-12','2023-05-12 00:46:37'),(401,402,'2023-05-12','2023-05-12 02:33:38'),(367,369,'2023-05-12','2023-05-12 04:38:54'),(367,400,'2023-05-12','2023-05-12 07:25:07'),(401,402,'2023-05-12','2023-05-12 18:13:15'),(401,402,'2023-05-12','2023-05-12 22:05:23'),(401,402,'2023-05-13','2023-05-13 19:53:02'),(401,402,'2023-05-14','2023-05-14 03:22:30'),(401,402,'2023-05-14','2023-05-14 04:31:53'),(401,402,'2023-05-14','2023-05-14 13:13:33'),(367,369,'2023-05-14','2023-05-14 13:31:36'),(367,369,'2023-05-14','2023-05-14 21:43:58'),(401,402,'2023-05-14','2023-05-14 23:35:13'),(367,369,'2023-05-14','2023-05-14 23:39:31'),(385,386,'2023-05-15','2023-05-15 04:06:41'),(367,369,'2023-05-15','2023-05-15 13:06:18'),(130,216,'2023-05-15','2023-05-15 14:59:41'),(401,402,'2023-05-15','2023-05-15 16:08:56'),(371,372,'2023-05-15','2023-05-15 17:01:01'),(401,402,'2023-05-15','2023-05-15 17:21:19'),(367,369,'2023-05-15','2023-05-15 19:21:34'),(367,407,'2023-05-15','2023-05-15 20:51:49'),(371,372,'2023-05-15','2023-05-15 20:52:01'),(359,406,'2023-05-15','2023-05-15 20:53:20'),(359,406,'2023-05-16','2023-05-16 04:43:01'),(367,407,'2023-05-16','2023-05-16 04:43:01'),(365,366,'2023-05-16','2023-05-16 20:32:09'),(367,407,'2023-05-16','2023-05-16 21:02:38'),(401,402,'2023-05-17','2023-05-17 01:16:28'),(401,408,'2023-05-17','2023-05-17 02:33:01'),(401,402,'2023-05-17','2023-05-17 16:17:22'),(409,411,'2023-05-17','2023-05-17 18:13:15'),(375,413,'2023-05-19','2023-05-19 06:38:11'),(385,414,'2023-05-19','2023-05-19 06:39:33'),(385,417,'2023-05-19','2023-05-19 06:40:59'),(371,418,'2023-05-19','2023-05-19 06:43:40'),(391,419,'2023-05-19','2023-05-19 06:44:55'),(365,366,'2023-05-19','2023-05-19 18:28:22'),(420,421,'2023-05-21','2023-05-21 02:23:10'),(420,421,'2023-05-21','2023-05-21 20:12:52'),(422,423,'2023-05-21','2023-05-21 20:14:22'),(422,424,'2023-05-21','2023-05-21 20:53:40'),(422,425,'2023-05-21','2023-05-21 20:53:41'),(401,408,'2023-05-22','2023-05-22 03:06:47'),(422,423,'2023-05-22','2023-05-22 08:21:00'),(422,425,'2023-05-22','2023-05-22 08:21:00'),(422,424,'2023-05-22','2023-05-22 08:21:00'),(365,366,'2023-05-22','2023-05-22 12:38:40'),(422,423,'2023-05-22','2023-05-22 19:55:57'),(409,446,'2023-05-22','2023-05-22 22:25:54'),(409,446,'2023-05-23','2023-05-23 02:38:28'),(365,366,'2023-05-24','2023-05-24 15:58:00'),(447,448,'2023-05-24','2023-05-24 16:09:45'),(453,457,'2023-05-25','2023-05-25 16:02:27'),(453,457,'2023-05-25','2023-05-25 17:41:17'),(453,457,'2023-05-26','2023-05-26 17:45:45');

--
-- Table structure for table `vtiger_email_track`
--

CREATE TABLE `vtiger_email_track` (
  `crmid` int(11) DEFAULT NULL,
  `mailid` int(11) DEFAULT NULL,
  `access_count` int(11) DEFAULT NULL,
  `click_count` int(11) NOT NULL DEFAULT 0,
  UNIQUE KEY `link_tabidtype_idx` (`crmid`,`mailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_email_track`
--

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

--
-- Table structure for table `vtiger_emaildetails`
--

CREATE TABLE `vtiger_emaildetails` (
  `emailid` int(11) NOT NULL,
  `from_email` varchar(50) NOT NULL DEFAULT '',
  `to_email` text DEFAULT NULL,
  `cc_email` text DEFAULT NULL,
  `bcc_email` text DEFAULT NULL,
  `assigned_user_email` varchar(50) NOT NULL DEFAULT '',
  `idlists` text DEFAULT NULL,
  `email_flag` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_emaildetails`
--

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

--
-- Table structure for table `vtiger_emails_recipientprefs`
--

CREATE TABLE `vtiger_emails_recipientprefs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tabid` int(11) NOT NULL,
  `prefs` varchar(255) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_emails_recipientprefs`
--


--
-- Table structure for table `vtiger_emailslookup`
--

CREATE TABLE `vtiger_emailslookup` (
  `crmid` int(11) DEFAULT NULL,
  `setype` varchar(100) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL,
  `fieldid` int(11) DEFAULT NULL,
  UNIQUE KEY `emailslookup_crmid_setype_fieldname_uk` (`crmid`,`setype`,`fieldid`),
  KEY `emailslookup_fieldid_setype_idx` (`fieldid`,`setype`),
  CONSTRAINT `emailslookup_crmid_fk` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_emailslookup`
--

INSERT INTO `vtiger_emailslookup` VALUES (198,'Contacts','cgarcia@creantis.com',80),(207,'Contacts','admin@mybluetechnology.com',80),(359,'HelpDesk','support@dynamixcloud.com',898),(295,'HelpDesk','frontline@dynamixsupport.com',898),(365,'HelpDesk','frontline@dynamixsupport.com',898),(367,'HelpDesk','frontline@dynamixsupport.com',898),(371,'HelpDesk','frontline@dynamixsupport.com',898),(385,'HelpDesk','frontline@dynamixsupport.com',898),(375,'HelpDesk','frontline@dynamixsupport.com',898),(272,'HelpDesk','frontline@dynamixsupport.com',898),(391,'HelpDesk','frontline@dynamixsupport.com',898),(396,'HelpDesk','frontline@dynamixsupport.com',898),(401,'HelpDesk','frontline@dynamixsupport.com',898),(409,'Contacts','dynamix@mybluetechnology.com',80),(420,'HelpDesk','frontline@dynamixsupport.com',898),(447,'HelpDesk','frontline@dynamixsupport.com',898),(453,'HelpDesk','frontline@dynamixsupport.com',898);

--
-- Table structure for table `vtiger_emailtemplates`
--

CREATE TABLE `vtiger_emailtemplates` (
  `foldername` varchar(100) DEFAULT NULL,
  `templatename` varchar(100) DEFAULT NULL,
  `templatepath` varchar(100) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `body` text DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `templateid` int(11) NOT NULL AUTO_INCREMENT,
  `systemtemplate` int(11) NOT NULL DEFAULT 0,
  `module` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`templateid`),
  KEY `emailtemplates_foldernamd_templatename_subject_idx` (`foldername`,`templatename`,`subject`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_emailtemplates`
--

INSERT INTO `vtiger_emailtemplates` VALUES ('Public','Announcement for Release','','Announcement for Release','Announcement of a release','Hello!   <br />\n	<br />\n	On behalf of the vtiger team,  I am pleased to announce the release of vtiger crm4.2 . This is a feature packed release including the mass email template handling, custom view feature, vtiger_reports feature and a host of other utilities. vtiger runs on all platforms.    <br />\n        <br />\n	Notable Features of vtiger are :   <br />\n	<br />\n	-Email Client Integration    <br />\n	-Trouble Ticket Integration   <br />\n	-Invoice Management Integration   <br />\n	-Reports Integration   <br />\n	-Portal Integration   <br />\n	-Enhanced Word Plugin Support   <br />\n	-Custom View Integration   <br />\n	<br />\n	Known Issues:   <br />\n	-ABCD   <br />\n	-EFGH   <br />\n	-IJKL   <br />\n	-MNOP   <br />\n	-QRST',0,1,0,'Contacts'),('Public','Pending Invoices','','Invoices Pending','Payment Due','name <br />\nstreet, <br />\ncity, <br />\nstate, <br />\n zip) <br />\n  <br />\n Dear <br />\n <br />\n Please check the following invoices that are yet to be paid by you: <br />\n <br />\n No. Date      Amount <br />\n 1   1/1/01    $4000 <br />\n 2   2/2//01   $5000 <br />\n 3   3/3/01    $10000 <br />\n 4   7/4/01    $23560 <br />\n <br />\n Kindly let us know if there are any issues that you feel are pending to be discussed. <br />\n We will be more than happy to give you a call. <br />\n We would like to continue our business with you.',0,2,0,'Contacts'),('Public','Acceptance Proposal','','Acceptance Proposal','Acceptance of Proposal',' Dear <br />\n <br />\nYour proposal on the project XYZW has been reviewed by us <br />\nand is acceptable in its entirety. <br />\n <br />\nWe are eagerly looking forward to this project <br />\nand are pleased about having the opportunity to work <br />\ntogether. We look forward to a long standing relationship <br />\nwith your esteemed firm. <br />\n<br />\nI would like to take this opportunity to invite you <br />\nto a game of golf on Wednesday morning 9am at the <br />\nCuff Links Ground. We will be waiting for you in the <br />\nExecutive Lounge. <br />\n<br />\nLooking forward to seeing you there.',0,3,0,'Contacts'),('Public','Goods received acknowledgement','','Goods received acknowledgement','Acknowledged Receipt of Goods',' The undersigned hereby acknowledges receipt and delivery of the goods. <br />\nThe undersigned will release the payment subject to the goods being discovered not satisfactory. <br />\n<br />\nSigned under seal this <date>',0,4,0,'Contacts'),('Public','Accept Order','','Accept Order','Acknowledgement/Acceptance of Order',' Dear <br />\n         We are in receipt of your order as contained in the <br />\n   purchase order form.We consider this to be final and binding on both sides. <br />\nIf there be any exceptions noted, we shall consider them <br />\nonly if the objection is received within ten days of receipt of <br />\nthis notice. <br />\n <br />\nThank you for your patronage.',0,5,0,'Contacts'),('Public','Address Change','','Change of Address','Address Change','Dear <br />\n <br />\nWe are relocating our office to <br />\n11111,XYZDEF Cross, <br />\nUVWWX Circle <br />\nThe telephone number for this new location is (101) 1212-1328. <br />\n<br />\nOur Manufacturing Division will continue operations <br />\nat 3250 Lovedale Square Avenue, in Frankfurt. <br />\n<br />\nWe hope to keep in touch with you all. <br />\nPlease update your addressbooks.',0,6,0,'Contacts'),('Public','Follow Up','','Follow Up','Follow Up of meeting','Dear <br />\n<br />\nThank you for extending us the opportunity to meet with <br />\nyou and members of your staff. <br />\n<br />\nI know that John Doe serviced your account <br />\nfor many years and made many friends at your firm. He has personally <br />\ndiscussed with me the deep relationship that he had with your firm. <br />\nWhile his presence will be missed, I can promise that we will <br />\ncontinue to provide the fine service that was accorded by <br />\nJohn to your firm. <br />\n<br />\nI was genuinely touched to receive such fine hospitality. <br />\n<br />\nThank you once again.',0,7,0,'Contacts'),('Public','Target Crossed!','','Target Crossed!','Fantastic Sales Spree!','Congratulations! <br />\n<br />\nThe numbers are in and I am proud to inform you that our <br />\ntotal sales for the previous quarter <br />\namounts to $100,000,00.00!. This is the first time <br />\nwe have exceeded the target by almost 30%. <br />\nWe have also beat the previous quarter record by a <br />\nwhopping 75%! <br />\n<br />\nLet us meet at Smoking Joe for a drink in the evening! <br />\n\nC you all there guys!',0,8,0,'Contacts'),('Public','Thanks Note','','Thanks Note','Note of thanks','Dear <br />\n<br />\nThank you for your confidence in our ability to serve you. <br />\nWe are glad to be given the chance to serve you.I look <br />\nforward to establishing a long term partnership with you. <br />\nConsider me as a friend. <br />\nShould any need arise,please do give us a call.',0,9,0,'Contacts'),('Public','Customer Login Details','','Customer Portal Login Details','Send Portal login details to customer','<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">\r\n<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body class=\"scayt-enabled\" data-gr-ext-installed=\"\" data-new-gr-c-s-check-loaded=\"14.1029.0\"><!-- <center> -->\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"borderGrey\" style=\"margin-left:0px;\" width=\"600px\">\r\n	<tbody>\r\n		<tr>\r\n			<td colspan=\"6\"><!-- Begin Pre header --><!-- // End Pre header \\ --></td>\r\n		</tr>\r\n		<tr style=\"height:50px;\">\r\n			<td colspan=\"6\" style=\"\r\n                  font-family: Helvetica,Verdana,sans-serif\">\r\n			<div style=\"margin-bottom:10px;color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\"><br />\r\n			Dear $contacts-firstname$ $contacts-lastname$,</div>\r\n\r\n			<div style=\"margin-top:20px;margin-bottom:20px; color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">As our customer, you can be assured of getting excellent support from our team. I would like to take this opportunity to introduce the portal we have setup for valuable customers like you. You can submit questions/issues via the portal, see past issues and responses. In addition, Portal provides you access to our knowledge base and documents we shared with you in the past.</div>\r\n\r\n			<div style=\"margin-top:10px;color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">$URL$ to login to the portal, with the credentials below.</div>\r\n\r\n			<div style=\"margin-top:20px;color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">Your Username: $login_name$</div>\r\n\r\n			<div style=\"margin-bottom:20px;color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">Your Password: $password$</div>\r\n\r\n			<div class=\"gmail_extra\" style=\"margin-top:10px;color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);\">Thank you,<br />\r\n			$contacts-smownerid$<br />\r\n			<br />\r\n			BLUE TECHNOLOGY TICKETING SYSTEM&nbsp;</div>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td colspan=\"6\" style=\"font-family: Helvetica,Verdana,sans-serif;font-size: 11px;color: #666666;\"></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<!-- </center> --></body>\r\n<grammarly-desktop-integration data-grammarly-shadow-root=\"true\"></grammarly-desktop-integration></html>\r\n',0,10,0,'Contacts'),('Public','Support end notification before a week','','VtigerCRM Support Notification','Send Notification mail to customer before a week of support end date','<table width=\"700\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: normal; text-decoration: none; background-color: rgb(122, 122, 254);\">\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td width=\"50\"> </td>\n            <td>\n            <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tr>\n                        <td>\n                        <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"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;\">\n                                <tr>\n                                    <td align=\"center\" rowspan=\"4\">$logo$</td>\n                                    <td align=\"center\"> </td>\n                                </tr>\n                                <tr>\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>\n                                </tr>\n                                <tr>\n                                    <td align=\"right\" style=\"padding-right: 100px;\">The honest Open Source CRM </td>\n                                </tr>\n                                <tr>\n                                    <td> </td>\n                                </tr>\n                        </table>\n                        </td>\n                    </tr>\n                    <tr>\n                        <td>\n                        <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"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);\">\n                                <tr>\n                                    <td valign=\"top\">\n                                    <table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\">\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\n                                                <td> </td>\n                                            </tr>\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\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 /><span style=\"font-weight: bold;\">Priority:</span> Urgent<br />Your Support is going to expire on next week<br />Please contact support@vtiger.com.<br /><br /><br /></td>\n                                            </tr>\n                                            <tr>\n                                                <td align=\"center\"><br /></td>\n                                            </tr>\n                                            <tr>\n                                                <td align=\"right\"><strong style=\"padding: 2px; font-family: Arial,Helvetica,sans-serif; font-size: 12px; color: rgb(0, 0, 0); font-weight: bold;\"><br /><br />Sincerly</strong></td>\n                                            </tr>\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\n                                                <td align=\"right\"><a style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: bolder; text-decoration: none; color: rgb(66, 66, 253);\" href=\"http://www.vtiger.com\">www.vtiger.com</a></td>\n                                            </tr>\n                                            <tr>\n                                                <td> </td>\n                                            </tr>\n                                    </table>\n                                    </td>\n                                    <td width=\"1%\" valign=\"top\"> </td>\n                                </tr>\n                        </table>\n                        </td>\n                    </tr>\n                    <tr>\n                        <td>\n                        <table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"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);\">\n                                <tr>\n                                    <td align=\"center\">Shree Narayana Complex, No 11 Sarathy Nagar, Vijaya Nagar , Velachery, Chennai - 600 042 India </td>\n                                </tr>\n                                <tr>\n                                    <td align=\"center\">Telephone No: +91 - 44 - 4202 - 1990     Toll Free No: +1 877 788 4437</td>\n                                </tr>\n                                <tr>\n                                    <td align=\"center\">Email Id: <a style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: bolder; text-decoration: none; color: rgb(255, 255, 255);\" href=\"mailto:info@vtiger.com\">info@vtiger.com</a></td>\n                                </tr>\n                        </table>\n                        </td>\n                    </tr>\n            </table>\n            </td>\n            <td width=\"50\"> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n</table>',0,11,0,'Contacts'),('Public','Support end notification before a month','','VtigerCRM Support Notification','Send Notification mail to customer before a month of support end date','<table width=\"700\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\" style=\"font-family: Arial,Helvetica,sans-serif; font-size: 12px; font-weight: normal; text-decoration: none; background-color: rgb(122, 122, 254);\">\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td width=\"50\"> </td>\n            <td>\n            <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                    <tr>\n                        <td>\n                        <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"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;\">\n                                <tr>\n                                    <td align=\"center\" rowspan=\"4\">$logo$</td>\n                                    <td align=\"center\"> </td>\n                                </tr>\n                                <tr>\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>\n                                </tr>\n                                <tr>\n                                    <td align=\"right\" style=\"padding-right: 100px;\">The honest Open Source CRM </td>\n                                </tr>\n                                <tr>\n                                    <td> </td>\n                                </tr>\n                        </table>\n                        </td>\n                    </tr>\n                    <tr>\n                        <td>\n                        <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"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);\">\n                                <tr>\n                                    <td valign=\"top\">\n                                    <table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\">\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\n                                                <td> </td>\n                                            </tr>\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\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 /><span style=\"font-weight: bold;\">Priority:</span> Normal<br />Your Support is going to expire on next month.<br />Please contact support@vtiger.com<br /><br /><br /></td>\n                                            </tr>\n                                            <tr>\n                                                <td align=\"center\"><br /></td>\n                                            </tr>\n                                            <tr>\n                                                <td align=\"right\"><strong style=\"padding: 2px; font-family: Arial,Helvetica,sans-serif; font-size: 12px; color: rgb(0, 0, 0); font-weight: bold;\"><br /><br />Sincerly</strong></td>\n                                            </tr>\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\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>\n                                            </tr>\n                                            <tr>\n                                                <td> </td>\n                                            </tr>\n                                    </table>\n                                    </td>\n                                    <td width=\"1%\" valign=\"top\"> </td>\n                                </tr>\n                        </table>\n                        </td>\n                    </tr>\n                    <tr>\n                        <td>\n                        <table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"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);\">\n                                <tr>\n                                    <td align=\"center\">Shree Narayana Complex, No 11 Sarathy Nagar, Vijaya Nagar , Velachery, Chennai - 600 042 India </td>\n                                </tr>\n                                <tr>\n                                    <td align=\"center\">Telephone No: +91 - 44 - 4202 - 1990     Toll Free No: +1 877 788 4437</td>\n                                </tr>\n                                <tr>\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>\n                                </tr>\n                        </table>\n                        </td>\n                    </tr>\n            </table>\n            </td>\n            <td width=\"50\"> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n        <tr>\n            <td> </td>\n            <td> </td>\n            <td> </td>\n        </tr>\n</table>',0,12,0,'Contacts'),('Public','Activity Reminder',NULL,'Reminder','Reminder','<p>This is a reminder notification for the Activity<br/>The details are :<br/> \n							&nbsp; Subject : $events-subject$<br/> \n							&nbsp; Start Date & Time : $events-date_start$<br/>\n							&nbsp; End Date & Time : $events-due_date$<br/> \n							&nbsp; Status : $events-eventstatus$<br/> \n							&nbsp; Location : $events-location$<br/> \n							&nbsp; Description : $events-description$<br/><br/> \n							<p/>',0,14,1,'Events'),('Public','ToDo Reminder',NULL,'Activity Reminder','Reminder','<p>This is a reminder notification for the Activity<br/>The details are :<br/>\n								&nbsp; Subject : $calendar-subject$<br/>\n								&nbsp; Start Date & Time : $calendar-date_start$<br/>\n								&nbsp; Due Date : $calendar-due_date$<br/>\n								&nbsp; Status : $calendar-status$<br/>\n								&nbsp; Location : $calendar-location$<br/>\n								&nbsp; Description : $calendar-description$<br/><br/>\n								<p/>',0,15,1,'Events'),('Public','Invite Users',NULL,'Invitation','Invite Users','<p>$invitee_name$,<br/><br/>You have been invited for an activity<br/><br/>The details are :<br/>\n								&nbsp; Subject : $events-subject$<br/>\n								&nbsp; Start Date & Time : $events-date_start$<br/> \n								&nbsp; End Date & Time : $events-due_date$<br/>\n								&nbsp; Status : $events-eventstatus$<br/>\n								&nbsp; Priority : $events-priority$<br/>\n								&nbsp; Related To : $events-crmid$<br/>\n								&nbsp; Contact List : $events-contactid$<br/>\n								&nbsp; Location : $events-location$<br/>\n								&nbsp; Description : $events-description$<br/><br/>\n								Thanks & Regards,<br/>\n								$current_user_name$\n								<p/>',0,16,1,'Events');

--
-- Table structure for table `vtiger_emailtemplates_seq`
--

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

--
-- Dumping data for table `vtiger_emailtemplates_seq`
--

INSERT INTO `vtiger_emailtemplates_seq` VALUES (16);

--
-- Table structure for table `vtiger_entityname`
--

CREATE TABLE `vtiger_entityname` (
  `tabid` int(11) NOT NULL DEFAULT 0,
  `modulename` varchar(100) DEFAULT NULL,
  `tablename` varchar(100) NOT NULL,
  `fieldname` varchar(150) NOT NULL,
  `entityidfield` varchar(150) NOT NULL,
  `entityidcolumn` varchar(150) NOT NULL,
  PRIMARY KEY (`tabid`),
  KEY `entityname_tabid_idx` (`tabid`),
  CONSTRAINT `fk_1_vtiger_entityname` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_entityname`
--

INSERT INTO `vtiger_entityname` VALUES (2,'Potentials','vtiger_potential','potentialname','potentialid','potential_id'),(4,'Contacts','vtiger_contactdetails','firstname,lastname','contactid','contact_id'),(6,'Accounts','vtiger_account','accountname','accountid','account_id'),(7,'Leads','vtiger_leaddetails','firstname,lastname','leadid','leadid'),(8,'Documents','vtiger_notes','title','notesid','notesid'),(9,'Calendar','vtiger_activity','subject','activityid','activityid'),(10,'Emails','vtiger_activity','subject','activityid','activityid'),(13,'HelpDesk','vtiger_troubletickets','title','ticketid','ticketid'),(14,'Products','vtiger_products','productname','productid','product_id'),(15,'Faq','vtiger_faq','question','id','id'),(18,'Vendors','vtiger_vendor','vendorname','vendorid','vendor_id'),(19,'PriceBooks','vtiger_pricebook','bookname','pricebookid','pricebookid'),(20,'Quotes','vtiger_quotes','subject','quoteid','quote_id'),(21,'PurchaseOrder','vtiger_purchaseorder','subject','purchaseorderid','purchaseorderid'),(22,'SalesOrder','vtiger_salesorder','subject','salesorderid','salesorder_id'),(23,'Invoice','vtiger_invoice','subject','invoiceid','invoiceid'),(26,'Campaigns','vtiger_campaign','campaignname','campaignid','campaignid'),(29,'Users','vtiger_users','first_name,last_name','id','id'),(34,'PBXManager','vtiger_pbxmanager','customernumber','pbxmanagerid','pbxmanagerid'),(35,'ServiceContracts','vtiger_servicecontracts','subject','servicecontractsid','servicecontractsid'),(36,'Services','vtiger_service','servicename','serviceid','serviceid'),(38,'Assets','vtiger_assets','assetname','assetsid','assetsid'),(42,'ModComments','vtiger_modcomments','commentcontent','modcommentsid','modcommentsid'),(43,'ProjectMilestone','vtiger_projectmilestone','projectmilestonename','projectmilestoneid','projectmilestoneid'),(44,'ProjectTask','vtiger_projecttask','projecttaskname','projecttaskid','projecttaskid'),(45,'Project','vtiger_project','projectname','projectid','projectid'),(47,'SMSNotifier','vtiger_smsnotifier','message','smsnotifierid','smsnotifierid');

--
-- Table structure for table `vtiger_eventhandler_module`
--

CREATE TABLE `vtiger_eventhandler_module` (
  `eventhandler_module_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(100) DEFAULT NULL,
  `handler_class` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`eventhandler_module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_eventhandler_module`
--

INSERT INTO `vtiger_eventhandler_module` VALUES (1,'ModTracker','ModTrackerHandler'),(2,'ServiceContracts','ServiceContractsHandler'),(3,'Invoice','InvoiceHandler'),(4,'PurchaseOrder','PurchaseOrderHandler');

--
-- Table structure for table `vtiger_eventhandler_module_seq`
--

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

--
-- Dumping data for table `vtiger_eventhandler_module_seq`
--

INSERT INTO `vtiger_eventhandler_module_seq` VALUES (4);

--
-- Table structure for table `vtiger_eventhandlers`
--

CREATE TABLE `vtiger_eventhandlers` (
  `eventhandler_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_name` varchar(100) NOT NULL,
  `handler_path` varchar(400) NOT NULL,
  `handler_class` varchar(100) NOT NULL,
  `cond` text DEFAULT NULL,
  `is_active` int(11) NOT NULL,
  `dependent_on` varchar(255) DEFAULT '[]',
  PRIMARY KEY (`eventhandler_id`,`event_name`,`handler_class`),
  UNIQUE KEY `eventhandler_idx` (`eventhandler_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_eventhandlers`
--

INSERT INTO `vtiger_eventhandlers` VALUES (1,'vtiger.entity.aftersave','modules/SalesOrder/RecurringInvoiceHandler.php','RecurringInvoiceHandler','',1,'[]'),(2,'vtiger.entity.beforesave','data/VTEntityDelta.php','VTEntityDelta','',1,'[]'),(3,'vtiger.entity.aftersave','data/VTEntityDelta.php','VTEntityDelta','',1,'[]'),(4,'vtiger.entity.aftersave','modules/com_vtiger_workflow/VTEventHandler.inc','VTWorkflowEventHandler','',1,'[\"VTEntityDelta\"]'),(5,'vtiger.entity.afterrestore','modules/com_vtiger_workflow/VTEventHandler.inc','VTWorkflowEventHandler','',1,'[]'),(6,'vtiger.entity.aftersave.final','modules/HelpDesk/HelpDeskHandler.php','HelpDeskHandler','',1,'[]'),(7,'vtiger.entity.aftersave.final','modules/ModTracker/ModTrackerHandler.php','ModTrackerHandler','',1,'[]'),(8,'vtiger.entity.beforedelete','modules/ModTracker/ModTrackerHandler.php','ModTrackerHandler','',1,'[]'),(9,'vtiger.entity.afterrestore','modules/ModTracker/ModTrackerHandler.php','ModTrackerHandler','',1,'[]'),(16,'vtiger.entity.beforesave','modules/ServiceContracts/ServiceContractsHandler.php','ServiceContractsHandler','',1,'[]'),(17,'vtiger.entity.aftersave','modules/ServiceContracts/ServiceContractsHandler.php','ServiceContractsHandler','',1,'[]'),(18,'vtiger.entity.aftersave','modules/WSAPP/WorkFlowHandlers/WSAPPAssignToTracker.php','WSAPPAssignToTracker','',1,'[\"VTEntityDelta\"]'),(19,'vtiger.entity.aftersave','modules/Invoice/InvoiceHandler.php','InvoiceHandler','',1,'[]'),(20,'vtiger.entity.aftersave','modules/PurchaseOrder/PurchaseOrderHandler.php','PurchaseOrderHandler','',1,'[]'),(21,'vtiger.entity.aftersave','modules/ModComments/ModCommentsHandler.php','ModCommentsHandler','',1,'[]'),(22,'vtiger.picklist.afterrename','modules/Settings/Picklist/handlers/PickListHandler.php','PickListHandler','',1,'[]'),(23,'vtiger.picklist.afterdelete','modules/Settings/Picklist/handlers/PickListHandler.php','PickListHandler','',1,'[]'),(24,'vtiger.entity.aftersave','modules/Vtiger/handlers/EmailLookupHandler.php','EmailLookupHandler','',1,'[\"VTEntityDelta\"]'),(25,'vtiger.entity.afterdelete','modules/Vtiger/handlers/EmailLookupHandler.php','EmailLookupHandler','',1,'[]'),(26,'vtiger.entity.afterrestore','modules/Vtiger/handlers/EmailLookupHandler.php','EmailLookupHandler','',1,'[]'),(27,'vtiger.batchevent.save','modules/Vtiger/handlers/EmailLookupHandler.php','EmailLookupBatchHandler','',1,'[]'),(28,'vtiger.lead.convertlead','modules/Leads/handlers/LeadHandler.php','LeadHandler','',1,'[]'),(29,'vtiger.entity.beforesave','modules/Vtiger/handlers/CheckDuplicateHandler.php','CheckDuplicateHandler','',1,'[]'),(30,'vtiger.entity.beforerestore','modules/Vtiger/handlers/CheckDuplicateHandler.php','CheckDuplicateHandler','',1,'[]'),(31,'vtiger.entity.aftersave','modules/Vtiger/handlers/FollowRecordHandler.php','FollowRecordHandler','',1,'[]'),(32,'vtiger.field.afterdelete','modules/Vtiger/handlers/FieldEventHandler.php','FieldEventHandler','',1,'[]'),(33,'vtiger.entity.beforerelate','modules/Vtiger/handlers/RelateEntitesHandler.php','RelateEntitesHandler','',1,'[]'),(34,'vtiger.entity.afterrelate','modules/Vtiger/handlers/RelateEntitesHandler.php','RelateEntitesHandler','',1,'[]'),(35,'vtiger.entity.aftersave','modules/PBXManager/PBXManagerHandler.php','PBXManagerHandler','',1,'[\"VTEntityDelta\"]'),(36,'vtiger.entity.afterdelete','modules/PBXManager/PBXManagerHandler.php','PBXManagerHandler','',1,'[]'),(37,'vtiger.entity.afterrestore','modules/PBXManager/PBXManagerHandler.php','PBXManagerHandler','',1,'[]'),(38,'vtiger.batchevent.save','modules/PBXManager/PBXManagerHandler.php','PBXManagerBatchHandler','',1,'[]'),(39,'vtiger.batchevent.delete','modules/PBXManager/PBXManagerHandler.php','PBXManagerBatchHandler','',1,'[]'),(40,'vtiger.lead.convertlead','modules/PBXManager/PBXManagerHandler.php','PBXManagerHandler','',1,'[]');

--
-- Table structure for table `vtiger_eventhandlers_seq`
--

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

--
-- Dumping data for table `vtiger_eventhandlers_seq`
--

INSERT INTO `vtiger_eventhandlers_seq` VALUES (40);

--
-- Table structure for table `vtiger_eventstatus`
--

CREATE TABLE `vtiger_eventstatus` (
  `eventstatusid` int(11) NOT NULL AUTO_INCREMENT,
  `eventstatus` 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 (`eventstatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_eventstatus`
--

INSERT INTO `vtiger_eventstatus` VALUES (1,'Planned',0,38,0,NULL),(2,'Held',0,39,1,NULL),(3,'Not Held',0,40,2,NULL);

--
-- Table structure for table `vtiger_eventstatus_seq`
--

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

--
-- Dumping data for table `vtiger_eventstatus_seq`
--

INSERT INTO `vtiger_eventstatus_seq` VALUES (3);

--
-- Table structure for table `vtiger_expectedresponse`
--

CREATE TABLE `vtiger_expectedresponse` (
  `expectedresponseid` int(11) NOT NULL AUTO_INCREMENT,
  `expectedresponse` 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 (`expectedresponseid`),
  UNIQUE KEY `CampaignExpRes_UK01` (`expectedresponse`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_expectedresponse`
--

INSERT INTO `vtiger_expectedresponse` VALUES (2,'Excellent',1,42,1,NULL),(3,'Good',1,43,2,NULL),(4,'Average',1,44,3,NULL),(5,'Poor',1,45,4,NULL);

--
-- Table structure for table `vtiger_expectedresponse_seq`
--

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

--
-- Dumping data for table `vtiger_expectedresponse_seq`
--

INSERT INTO `vtiger_expectedresponse_seq` VALUES (5);

--
-- Table structure for table `vtiger_extnstore_users`
--

CREATE TABLE `vtiger_extnstore_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(75) DEFAULT NULL,
  `instanceurl` varchar(255) DEFAULT NULL,
  `createdon` datetime DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_extnstore_users`
--


--
-- Table structure for table `vtiger_faq`
--

CREATE TABLE `vtiger_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `faq_no` varchar(100) NOT NULL,
  `product_id` varchar(100) DEFAULT NULL,
  `question` text DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `category` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `faq_id_idx` (`id`),
  CONSTRAINT `fk_1_vtiger_faq` FOREIGN KEY (`id`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_faq`
--


--
-- Table structure for table `vtiger_faqcategories`
--

CREATE TABLE `vtiger_faqcategories` (
  `faqcategories_id` int(11) NOT NULL AUTO_INCREMENT,
  `faqcategories` varchar(200) DEFAULT 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 (`faqcategories_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_faqcategories`
--

INSERT INTO `vtiger_faqcategories` VALUES (1,'General',1,46,0,NULL);

--
-- Table structure for table `vtiger_faqcategories_seq`
--

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

--
-- Dumping data for table `vtiger_faqcategories_seq`
--

INSERT INTO `vtiger_faqcategories_seq` VALUES (1);

--
-- Table structure for table `vtiger_faqcf`
--

CREATE TABLE `vtiger_faqcf` (
  `faqid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`faqid`),
  CONSTRAINT `fk_1_vtiger_faqcf` FOREIGN KEY (`faqid`) REFERENCES `vtiger_faq` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_faqcf`
--


--
-- Table structure for table `vtiger_faqcomments`
--

CREATE TABLE `vtiger_faqcomments` (
  `commentid` int(11) NOT NULL AUTO_INCREMENT,
  `faqid` int(11) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `createdtime` datetime NOT NULL,
  PRIMARY KEY (`commentid`),
  KEY `faqcomments_faqid_idx` (`faqid`),
  CONSTRAINT `fk_1_vtiger_faqcomments` FOREIGN KEY (`faqid`) REFERENCES `vtiger_faq` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_faqcomments`
--


--
-- Table structure for table `vtiger_faqstatus`
--

CREATE TABLE `vtiger_faqstatus` (
  `faqstatus_id` int(11) NOT NULL AUTO_INCREMENT,
  `faqstatus` varchar(200) DEFAULT 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 (`faqstatus_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_faqstatus`
--

INSERT INTO `vtiger_faqstatus` VALUES (1,'Draft',0,47,0,NULL),(2,'Reviewed',0,48,1,NULL),(3,'Published',0,49,2,NULL),(4,'Obsolete',0,50,3,NULL);

--
-- Table structure for table `vtiger_faqstatus_seq`
--

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

--
-- Dumping data for table `vtiger_faqstatus_seq`
--

INSERT INTO `vtiger_faqstatus_seq` VALUES (4);

--
-- Table structure for table `vtiger_feedback`
--

CREATE TABLE `vtiger_feedback` (
  `userid` int(11) DEFAULT NULL,
  `dontshow` varchar(19) DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_feedback`
--


--
-- Table structure for table `vtiger_field`
--

CREATE TABLE `vtiger_field` (
  `tabid` int(11) NOT NULL,
  `fieldid` int(11) NOT NULL AUTO_INCREMENT,
  `columnname` varchar(30) NOT NULL,
  `tablename` varchar(100) DEFAULT NULL,
  `generatedtype` int(11) NOT NULL DEFAULT 0,
  `uitype` varchar(30) NOT NULL,
  `fieldname` varchar(50) NOT NULL,
  `fieldlabel` varchar(50) NOT NULL,
  `readonly` int(11) NOT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `defaultvalue` text DEFAULT NULL,
  `maximumlength` int(11) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `block` int(11) DEFAULT NULL,
  `displaytype` int(11) DEFAULT NULL,
  `typeofdata` varchar(100) DEFAULT NULL,
  `quickcreate` int(11) NOT NULL DEFAULT 1,
  `quickcreatesequence` int(11) DEFAULT NULL,
  `info_type` varchar(20) DEFAULT NULL,
  `masseditable` int(11) NOT NULL DEFAULT 1,
  `helpinfo` text DEFAULT NULL,
  `summaryfield` int(11) NOT NULL DEFAULT 0,
  `headerfield` int(11) DEFAULT 0,
  `isunique` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`fieldid`),
  KEY `field_tabid_idx` (`tabid`),
  KEY `field_fieldname_idx` (`fieldname`),
  KEY `field_block_idx` (`block`),
  KEY `field_displaytype_idx` (`displaytype`),
  CONSTRAINT `fk_1_vtiger_field` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=902 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_field`
--



--
-- Table structure for table `vtiger_field_seq`
--

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

--
-- Dumping data for table `vtiger_field_seq`
--

INSERT INTO `vtiger_field_seq` VALUES (901);

--
-- Table structure for table `vtiger_fieldmodulerel`
--

CREATE TABLE `vtiger_fieldmodulerel` (
  `fieldid` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `relmodule` varchar(100) NOT NULL,
  `status` varchar(10) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_fieldmodulerel`
--

INSERT INTO `vtiger_fieldmodulerel` VALUES (113,'Potentials','Accounts',NULL,0),(535,'PBXManager','Leads',NULL,NULL),(535,'PBXManager','Contacts',NULL,NULL),(535,'PBXManager','Accounts',NULL,NULL),(549,'ServiceContracts','Contacts',NULL,NULL),(549,'ServiceContracts','Accounts',NULL,NULL),(589,'Assets','Products',NULL,NULL),(595,'Assets','Invoice',NULL,NULL),(600,'Assets','Accounts',NULL,NULL),(601,'Assets','Contacts',NULL,NULL),(613,'ModComments','Leads',NULL,NULL),(613,'ModComments','Contacts',NULL,NULL),(613,'ModComments','Accounts',NULL,NULL),(615,'ModComments','ModComments',NULL,NULL),(613,'ModComments','Potentials',NULL,NULL),(619,'ProjectMilestone','Project',NULL,NULL),(633,'ProjectTask','Project',NULL,NULL),(613,'ModComments','ProjectTask',NULL,NULL),(654,'Project','Accounts',NULL,NULL),(654,'Project','Contacts',NULL,NULL),(613,'ModComments','Project',NULL,NULL),(676,'Invoice','Products',NULL,NULL),(676,'Invoice','Services',NULL,NULL),(685,'SalesOrder','Products',NULL,NULL),(685,'SalesOrder','Services',NULL,NULL),(694,'PurchaseOrder','Products',NULL,NULL),(694,'PurchaseOrder','Services',NULL,NULL),(703,'Quotes','Products',NULL,NULL),(703,'Quotes','Services',NULL,NULL),(714,'ModComments','Contacts',NULL,NULL),(613,'ModComments','HelpDesk',NULL,NULL),(613,'ModComments','Faq',NULL,NULL),(740,'Potentials','Contacts',NULL,NULL),(157,'HelpDesk','Accounts',NULL,NULL),(741,'HelpDesk','Contacts',NULL,NULL),(238,'Accounts','Calendar',NULL,NULL),(238,'Leads','Calendar',NULL,NULL),(238,'HelpDesk','Calendar',NULL,NULL),(238,'Campaigns','Calendar',NULL,NULL),(238,'Potentials','Calendar',NULL,NULL),(238,'PurchaseOrder','Calendar',NULL,NULL),(238,'SalesOrder','Calendar',NULL,NULL),(238,'Quotes','Calendar',NULL,NULL),(238,'Invoice','Calendar',NULL,NULL),(239,'Contacts','Calendar',NULL,NULL),(774,'Invoice','Potentials',NULL,NULL),(613,'ModComments','Invoice',NULL,NULL),(613,'ModComments','Quotes',NULL,NULL),(613,'ModComments','PurchaseOrder',NULL,NULL),(613,'ModComments','SalesOrder',NULL,NULL),(849,'Project','Potentials',NULL,NULL);

--
-- Table structure for table `vtiger_freetagged_objects`
--

CREATE TABLE `vtiger_freetagged_objects` (
  `tag_id` int(11) NOT NULL DEFAULT 0,
  `tagger_id` int(11) NOT NULL DEFAULT 0,
  `object_id` int(11) NOT NULL DEFAULT 0,
  `tagged_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `module` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tag_id`,`tagger_id`,`object_id`),
  KEY `freetagged_objects_tag_id_tagger_id_object_id_idx` (`tag_id`,`tagger_id`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_freetagged_objects`
--


--
-- Table structure for table `vtiger_freetags`
--

CREATE TABLE `vtiger_freetags` (
  `id` int(11) NOT NULL,
  `tag` varchar(50) NOT NULL DEFAULT '',
  `raw_tag` varchar(50) NOT NULL DEFAULT '',
  `visibility` varchar(100) NOT NULL DEFAULT 'PRIVATE',
  `owner` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_freetags`
--


--
-- Table structure for table `vtiger_freetags_seq`
--

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

--
-- Dumping data for table `vtiger_freetags_seq`
--

INSERT INTO `vtiger_freetags_seq` VALUES (1);

--
-- Table structure for table `vtiger_glacct`
--

CREATE TABLE `vtiger_glacct` (
  `glacctid` int(11) NOT NULL AUTO_INCREMENT,
  `glacct` 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 (`glacctid`),
  UNIQUE KEY `glacct_glacct_idx` (`glacct`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_glacct`
--

INSERT INTO `vtiger_glacct` VALUES (1,'300-Sales-Software',1,51,0,NULL),(2,'301-Sales-Hardware',1,52,1,NULL),(3,'302-Rental-Income',1,53,2,NULL),(4,'303-Interest-Income',1,54,3,NULL),(5,'304-Sales-Software-Support',1,55,4,NULL),(6,'305-Sales Other',1,56,5,NULL),(7,'306-Internet Sales',1,57,6,NULL),(8,'307-Service-Hardware Labor',1,58,7,NULL),(9,'308-Sales-Books',1,59,8,NULL);

--
-- Table structure for table `vtiger_glacct_seq`
--

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

--
-- Dumping data for table `vtiger_glacct_seq`
--

INSERT INTO `vtiger_glacct_seq` VALUES (9);

--
-- Table structure for table `vtiger_google_event_calendar_mapping`
--

CREATE TABLE `vtiger_google_event_calendar_mapping` (
  `event_id` varchar(255) DEFAULT NULL,
  `calendar_id` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_google_event_calendar_mapping`
--


--
-- Table structure for table `vtiger_google_oauth2`
--

CREATE TABLE `vtiger_google_oauth2` (
  `service` varchar(20) DEFAULT NULL,
  `access_token` varchar(500) DEFAULT NULL,
  `refresh_token` varchar(500) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_google_oauth2`
--


--
-- Table structure for table `vtiger_google_sync_fieldmapping`
--

CREATE TABLE `vtiger_google_sync_fieldmapping` (
  `vtiger_field` varchar(255) DEFAULT NULL,
  `google_field` varchar(255) DEFAULT NULL,
  `google_field_type` varchar(255) DEFAULT NULL,
  `google_custom_label` varchar(255) DEFAULT NULL,
  `user` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_google_sync_fieldmapping`
--


--
-- Table structure for table `vtiger_google_sync_settings`
--

CREATE TABLE `vtiger_google_sync_settings` (
  `user` int(11) DEFAULT NULL,
  `module` varchar(50) DEFAULT NULL,
  `clientgroup` varchar(255) DEFAULT NULL,
  `direction` varchar(50) DEFAULT NULL,
  `enabled` tinyint(4) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_google_sync_settings`
--


--
-- Table structure for table `vtiger_group2grouprel`
--

CREATE TABLE `vtiger_group2grouprel` (
  `groupid` int(11) NOT NULL,
  `containsgroupid` int(11) NOT NULL,
  PRIMARY KEY (`groupid`,`containsgroupid`),
  CONSTRAINT `fk_2_vtiger_group2grouprel` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_group2grouprel`
--


--
-- Table structure for table `vtiger_group2role`
--

CREATE TABLE `vtiger_group2role` (
  `groupid` int(11) NOT NULL,
  `roleid` varchar(255) NOT NULL,
  PRIMARY KEY (`groupid`,`roleid`),
  KEY `fk_2_vtiger_group2role` (`roleid`),
  CONSTRAINT `fk_2_vtiger_group2role` FOREIGN KEY (`roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_group2role`
--

INSERT INTO `vtiger_group2role` VALUES (2,'H4'),(3,'H2');

--
-- Table structure for table `vtiger_group2rs`
--

CREATE TABLE `vtiger_group2rs` (
  `groupid` int(11) NOT NULL,
  `roleandsubid` varchar(255) NOT NULL,
  PRIMARY KEY (`groupid`,`roleandsubid`),
  KEY `fk_2_vtiger_group2rs` (`roleandsubid`),
  CONSTRAINT `fk_2_vtiger_group2rs` FOREIGN KEY (`roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_group2rs`
--

INSERT INTO `vtiger_group2rs` VALUES (2,'H5'),(3,'H3');

--
-- Table structure for table `vtiger_groups`
--

CREATE TABLE `vtiger_groups` (
  `groupid` int(11) NOT NULL,
  `groupname` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`groupid`),
  UNIQUE KEY `groups_groupname_idx` (`groupname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_groups`
--

INSERT INTO `vtiger_groups` VALUES (2,'Team Selling','Group Related to Sales'),(3,'Marketing Group','Group Related to Marketing Activities'),(4,'BOH Support Group','Group Related to providing Support to Customers');

--
-- Table structure for table `vtiger_home_layout`
--

CREATE TABLE `vtiger_home_layout` (
  `userid` int(11) NOT NULL,
  `layout` int(11) NOT NULL DEFAULT 4,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_home_layout`
--


--
-- Table structure for table `vtiger_homedashbd`
--

CREATE TABLE `vtiger_homedashbd` (
  `stuffid` int(11) NOT NULL DEFAULT 0,
  `dashbdname` varchar(100) DEFAULT NULL,
  `dashbdtype` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`stuffid`),
  KEY `stuff_stuffid_idx` (`stuffid`),
  CONSTRAINT `fk_1_vtiger_homedashbd` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homedashbd`
--


--
-- Table structure for table `vtiger_homedefault`
--

CREATE TABLE `vtiger_homedefault` (
  `stuffid` int(11) NOT NULL DEFAULT 0,
  `hometype` varchar(30) NOT NULL,
  `maxentries` int(11) DEFAULT NULL,
  `setype` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`stuffid`),
  KEY `stuff_stuffid_idx` (`stuffid`),
  CONSTRAINT `fk_1_vtiger_homedefault` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homedefault`
--

INSERT INTO `vtiger_homedefault` VALUES (16,'ALVT',5,'Accounts'),(17,'HDB',5,'Dashboard'),(18,'PLVT',5,'Potentials'),(19,'QLTQ',5,'Quotes'),(20,'CVLVT',5,'NULL'),(21,'HLT',5,'HelpDesk'),(22,'UA',5,'Calendar'),(23,'GRT',5,'NULL'),(24,'OLTSO',5,'SalesOrder'),(25,'ILTI',5,'Invoice'),(26,'MNL',5,'Leads'),(27,'OLTPO',5,'PurchaseOrder'),(28,'PA',5,'Calendar'),(29,'LTFAQ',5,'Faq'),(31,'ALVT',5,'Accounts'),(32,'HDB',5,'Dashboard'),(33,'PLVT',5,'Potentials'),(34,'QLTQ',5,'Quotes'),(35,'CVLVT',5,'NULL'),(36,'HLT',5,'HelpDesk'),(37,'UA',5,'Calendar'),(38,'GRT',5,'NULL'),(39,'OLTSO',5,'SalesOrder'),(40,'ILTI',5,'Invoice'),(41,'MNL',5,'Leads'),(42,'OLTPO',5,'PurchaseOrder'),(43,'PA',5,'Calendar'),(44,'LTFAQ',5,'Faq'),(76,'ALVT',5,'Accounts'),(77,'HDB',5,'Dashboard'),(78,'PLVT',5,'Potentials'),(79,'QLTQ',5,'Quotes'),(80,'CVLVT',5,'NULL'),(81,'HLT',5,'HelpDesk'),(82,'UA',5,'Calendar'),(83,'GRT',5,'NULL'),(84,'OLTSO',5,'SalesOrder'),(85,'ILTI',5,'Invoice'),(86,'MNL',5,'Leads'),(87,'OLTPO',5,'PurchaseOrder'),(88,'PA',5,'Calendar'),(89,'LTFAQ',5,'Faq'),(91,'ALVT',5,'Accounts'),(92,'HDB',5,'Dashboard'),(93,'PLVT',5,'Potentials'),(94,'QLTQ',5,'Quotes'),(95,'CVLVT',5,'NULL'),(96,'HLT',5,'HelpDesk'),(97,'UA',5,'Calendar'),(98,'GRT',5,'NULL'),(99,'OLTSO',5,'SalesOrder'),(100,'ILTI',5,'Invoice'),(101,'MNL',5,'Leads'),(102,'OLTPO',5,'PurchaseOrder'),(103,'PA',5,'Calendar'),(104,'LTFAQ',5,'Faq'),(121,'ALVT',5,'Accounts'),(122,'HDB',5,'Dashboard'),(123,'PLVT',5,'Potentials'),(124,'QLTQ',5,'Quotes'),(125,'CVLVT',5,'NULL'),(126,'HLT',5,'HelpDesk'),(127,'UA',5,'Calendar'),(128,'GRT',5,'NULL'),(129,'OLTSO',5,'SalesOrder'),(130,'ILTI',5,'Invoice'),(131,'MNL',5,'Leads'),(132,'OLTPO',5,'PurchaseOrder'),(133,'PA',5,'Calendar'),(134,'LTFAQ',5,'Faq'),(136,'ALVT',5,'Accounts'),(137,'HDB',5,'Dashboard'),(138,'PLVT',5,'Potentials'),(139,'QLTQ',5,'Quotes'),(140,'CVLVT',5,'NULL'),(141,'HLT',5,'HelpDesk'),(142,'UA',5,'Calendar'),(143,'GRT',5,'NULL'),(144,'OLTSO',5,'SalesOrder'),(145,'ILTI',5,'Invoice'),(146,'MNL',5,'Leads'),(147,'OLTPO',5,'PurchaseOrder'),(148,'PA',5,'Calendar'),(149,'LTFAQ',5,'Faq');

--
-- Table structure for table `vtiger_homemodule`
--

CREATE TABLE `vtiger_homemodule` (
  `stuffid` int(11) NOT NULL,
  `modulename` varchar(100) DEFAULT NULL,
  `maxentries` int(11) NOT NULL,
  `customviewid` int(11) NOT NULL,
  `setype` varchar(30) NOT NULL,
  PRIMARY KEY (`stuffid`),
  KEY `stuff_stuffid_idx` (`stuffid`),
  CONSTRAINT `fk_1_vtiger_homemodule` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homemodule`
--


--
-- Table structure for table `vtiger_homemoduleflds`
--

CREATE TABLE `vtiger_homemoduleflds` (
  `stuffid` int(11) DEFAULT NULL,
  `fieldname` varchar(100) DEFAULT NULL,
  KEY `stuff_stuffid_idx` (`stuffid`),
  CONSTRAINT `fk_1_vtiger_homemoduleflds` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homemodule` (`stuffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homemoduleflds`
--


--
-- Table structure for table `vtiger_homereportchart`
--

CREATE TABLE `vtiger_homereportchart` (
  `stuffid` int(11) NOT NULL,
  `reportid` int(11) DEFAULT NULL,
  `reportcharttype` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`stuffid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homereportchart`
--


--
-- Table structure for table `vtiger_homerss`
--

CREATE TABLE `vtiger_homerss` (
  `stuffid` int(11) NOT NULL DEFAULT 0,
  `url` varchar(100) DEFAULT NULL,
  `maxentries` int(11) NOT NULL,
  PRIMARY KEY (`stuffid`),
  KEY `stuff_stuffid_idx` (`stuffid`),
  CONSTRAINT `fk_1_vtiger_homerss` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homerss`
--


--
-- Table structure for table `vtiger_homestuff`
--

CREATE TABLE `vtiger_homestuff` (
  `stuffid` int(11) NOT NULL DEFAULT 0,
  `stuffsequence` int(11) NOT NULL DEFAULT 0,
  `stufftype` varchar(100) DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `visible` int(11) NOT NULL DEFAULT 0,
  `stufftitle` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`stuffid`),
  KEY `stuff_stuffid_idx` (`stuffid`),
  KEY `fk_1_vtiger_homestuff` (`userid`),
  CONSTRAINT `fk_1_vtiger_homestuff` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_homestuff`
--

INSERT INTO `vtiger_homestuff` VALUES (16,1,'Default',5,1,'Top Accounts'),(17,2,'Default',5,1,'Home Page Dashboard'),(18,3,'Default',5,1,'Top Potentials'),(19,4,'Default',5,1,'Top Quotes'),(20,5,'Default',5,1,'Key Metrics'),(21,6,'Default',5,1,'Top Trouble Tickets'),(22,7,'Default',5,1,'Upcoming Activities'),(23,8,'Default',5,1,'My Group Allocation'),(24,9,'Default',5,1,'Top Sales Orders'),(25,10,'Default',5,1,'Top Invoices'),(26,11,'Default',5,1,'My New Leads'),(27,12,'Default',5,1,'Top Purchase Orders'),(28,13,'Default',5,1,'Pending Activities'),(29,14,'Default',5,1,'My Recent FAQs'),(30,15,'Tag Cloud',5,0,'Tag Cloud'),(31,1,'Default',6,1,'Top Accounts'),(32,2,'Default',6,1,'Home Page Dashboard'),(33,3,'Default',6,1,'Top Potentials'),(34,4,'Default',6,1,'Top Quotes'),(35,5,'Default',6,1,'Key Metrics'),(36,6,'Default',6,1,'Top Trouble Tickets'),(37,7,'Default',6,1,'Upcoming Activities'),(38,8,'Default',6,1,'My Group Allocation'),(39,9,'Default',6,1,'Top Sales Orders'),(40,10,'Default',6,1,'Top Invoices'),(41,11,'Default',6,1,'My New Leads'),(42,12,'Default',6,1,'Top Purchase Orders'),(43,13,'Default',6,1,'Pending Activities'),(44,14,'Default',6,1,'My Recent FAQs'),(45,15,'Tag Cloud',6,0,'Tag Cloud'),(76,1,'Default',9,1,'Top Accounts'),(77,2,'Default',9,1,'Home Page Dashboard'),(78,3,'Default',9,1,'Top Potentials'),(79,4,'Default',9,1,'Top Quotes'),(80,5,'Default',9,1,'Key Metrics'),(81,6,'Default',9,1,'Top Trouble Tickets'),(82,7,'Default',9,1,'Upcoming Activities'),(83,8,'Default',9,1,'My Group Allocation'),(84,9,'Default',9,1,'Top Sales Orders'),(85,10,'Default',9,1,'Top Invoices'),(86,11,'Default',9,1,'My New Leads'),(87,12,'Default',9,1,'Top Purchase Orders'),(88,13,'Default',9,1,'Pending Activities'),(89,14,'Default',9,1,'My Recent FAQs'),(90,15,'Tag Cloud',9,0,'Tag Cloud'),(91,1,'Default',10,1,'Top Accounts'),(92,2,'Default',10,1,'Home Page Dashboard'),(93,3,'Default',10,1,'Top Potentials'),(94,4,'Default',10,1,'Top Quotes'),(95,5,'Default',10,1,'Key Metrics'),(96,6,'Default',10,1,'Top Trouble Tickets'),(97,7,'Default',10,1,'Upcoming Activities'),(98,8,'Default',10,1,'My Group Allocation'),(99,9,'Default',10,1,'Top Sales Orders'),(100,10,'Default',10,1,'Top Invoices'),(101,11,'Default',10,1,'My New Leads'),(102,12,'Default',10,1,'Top Purchase Orders'),(103,13,'Default',10,1,'Pending Activities'),(104,14,'Default',10,1,'My Recent FAQs'),(105,15,'Tag Cloud',10,0,'Tag Cloud'),(121,1,'Default',12,1,'Top Accounts'),(122,2,'Default',12,1,'Home Page Dashboard'),(123,3,'Default',12,1,'Top Potentials'),(124,4,'Default',12,1,'Top Quotes'),(125,5,'Default',12,1,'Key Metrics'),(126,6,'Default',12,1,'Top Trouble Tickets'),(127,7,'Default',12,1,'Upcoming Activities'),(128,8,'Default',12,1,'My Group Allocation'),(129,9,'Default',12,1,'Top Sales Orders'),(130,10,'Default',12,1,'Top Invoices'),(131,11,'Default',12,1,'My New Leads'),(132,12,'Default',12,1,'Top Purchase Orders'),(133,13,'Default',12,1,'Pending Activities'),(134,14,'Default',12,1,'My Recent FAQs'),(135,15,'Tag Cloud',12,0,'Tag Cloud'),(136,1,'Default',13,1,'Top Accounts'),(137,2,'Default',13,1,'Home Page Dashboard'),(138,3,'Default',13,1,'Top Potentials'),(139,4,'Default',13,1,'Top Quotes'),(140,5,'Default',13,1,'Key Metrics'),(141,6,'Default',13,1,'Top Trouble Tickets'),(142,7,'Default',13,1,'Upcoming Activities'),(143,8,'Default',13,1,'My Group Allocation'),(144,9,'Default',13,1,'Top Sales Orders'),(145,10,'Default',13,1,'Top Invoices'),(146,11,'Default',13,1,'My New Leads'),(147,12,'Default',13,1,'Top Purchase Orders'),(148,13,'Default',13,1,'Pending Activities'),(149,14,'Default',13,1,'My Recent FAQs'),(150,15,'Tag Cloud',13,0,'Tag Cloud');

--
-- Table structure for table `vtiger_homestuff_seq`
--

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

--
-- Dumping data for table `vtiger_homestuff_seq`
--

INSERT INTO `vtiger_homestuff_seq` VALUES (150);

--
-- Table structure for table `vtiger_hour_format`
--

CREATE TABLE `vtiger_hour_format` (
  `hour_formatid` int(11) NOT NULL AUTO_INCREMENT,
  `hour_format` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`hour_formatid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_hour_format`
--

INSERT INTO `vtiger_hour_format` VALUES (1,'12',0,1),(2,'24',1,1);

--
-- Table structure for table `vtiger_hour_format_seq`
--

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

--
-- Dumping data for table `vtiger_hour_format_seq`
--

INSERT INTO `vtiger_hour_format_seq` VALUES (2);

--
-- Table structure for table `vtiger_import_1`
--

CREATE TABLE `vtiger_import_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` int(11) DEFAULT 0,
  `recordid` int(11) DEFAULT NULL,
  `accountname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `vtiger_import_1`
--

INSERT INTO `vtiger_import_1` VALUES (1,1,3,'CBRD001-The Bird - New Montgomery'),(2,1,4,'CBRD002-The Bird Hayes-AWB'),(3,1,5,'CSD001-SD Castro (Mburger LLC)'),(4,1,6,'CSD002-SD FIDI (JBURGER LLC)'),(5,1,7,'CSD003-SD Chestnut  (Eburger LLC)'),(6,1,8,'CSD004-SD Mill Valley (Dburger LLC)'),(7,1,9,'CSD005-SD Metreon (Metburger LLC)'),(8,1,10,'CSD007-SD Embarcadero (Mission 98 Super LLC)'),(9,1,11,'CSD008-SD Novato (Super Novato LLC)'),(10,1,12,'CSD010-SD Los Gatos (Super Los Gatos)'),(11,1,13,'CSD011-SD Concord - The Veranda Super LLC'),(12,1,14,'CSD012-SD Berkeley (2355 Telegraph LLC) '),(13,1,15,'CSD013-SD Westgate (5399 Prospect Road LLC)'),(14,1,16,'CSD014-SD Emeryville - SuperEmeryvilleLLC'),(15,1,17,'CSD019-SD Laurel Village (3401 California LLC)'),(16,1,18,'CSD020 - SD Serramonte - (Super Serramonte LLC)'),(17,1,19,'CSD021-SD Napa (Super Napa LLC)'),(18,1,20,'CUDT001-Unos Dos Tacos'),(19,1,21,'FAMA001-aMano SF'),(20,1,22,'FBER001-Beretta '),(21,1,23,'FBER002-Beretta Popup'),(22,1,24,'FDLA001-DeLaRosa Chestnut'),(23,1,25,'FDLA002-DeLaRosa-Yerba Buena'),(24,1,26,'FDLA003-DelaRosa San Ramon'),(25,1,27,'FFLR001-Flores Union'),(26,1,28,'FFLR002-Flores Corte Madera'),(27,1,29,'FLOL001-Lolinda'),(28,1,30,'FRDR001 - Rad Radish'),(29,1,31,'FSRB001-Starbelly'),(30,1,32,'FTAI001-Tailors Son'),(31,1,33,'FWLD001 - Wildseed Union'),(32,1,34,'FWLD002-Wildseed-PaloAlto'),(33,1,35,'Back of the House Inc.');

--
-- Table structure for table `vtiger_import_locks`
--

CREATE TABLE `vtiger_import_locks` (
  `vtiger_import_lock_id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `tabid` int(11) NOT NULL,
  `importid` int(11) NOT NULL,
  `locked_since` datetime DEFAULT NULL,
  PRIMARY KEY (`vtiger_import_lock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_import_locks`
--


--
-- Table structure for table `vtiger_import_locks_seq`
--

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

--
-- Dumping data for table `vtiger_import_locks_seq`
--

INSERT INTO `vtiger_import_locks_seq` VALUES (1);

--
-- Table structure for table `vtiger_import_maps`
--

CREATE TABLE `vtiger_import_maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(36) NOT NULL,
  `module` varchar(36) NOT NULL,
  `content` longblob DEFAULT NULL,
  `has_header` int(11) NOT NULL DEFAULT 1,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `date_entered` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `date_modified` datetime DEFAULT NULL,
  `assigned_user_id` varchar(36) DEFAULT NULL,
  `is_published` varchar(3) NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`),
  KEY `import_maps_assigned_user_id_module_name_deleted_idx` (`assigned_user_id`,`module`,`name`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_import_maps`
--


--
-- Table structure for table `vtiger_import_queue`
--

CREATE TABLE `vtiger_import_queue` (
  `importid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `tabid` int(11) NOT NULL,
  `field_mapping` text DEFAULT NULL,
  `default_values` text DEFAULT NULL,
  `merge_type` int(11) DEFAULT NULL,
  `merge_fields` text DEFAULT NULL,
  `status` int(11) DEFAULT 0,
  `lineitem_currency_id` int(11) DEFAULT NULL,
  `paging` int(11) DEFAULT 0,
  PRIMARY KEY (`importid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_import_queue`
--


--
-- Table structure for table `vtiger_import_queue_seq`
--

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

--
-- Dumping data for table `vtiger_import_queue_seq`
--

INSERT INTO `vtiger_import_queue_seq` VALUES (1);

--
-- Table structure for table `vtiger_industry`
--

CREATE TABLE `vtiger_industry` (
  `industryid` int(11) NOT NULL AUTO_INCREMENT,
  `industry` 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 (`industryid`),
  UNIQUE KEY `industry_industry_idx` (`industry`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_industry`
--

INSERT INTO `vtiger_industry` VALUES (2,'Apparel',1,61,1,NULL),(3,'Banking',1,62,2,NULL),(4,'Biotechnology',1,63,3,NULL),(5,'Chemicals',1,64,4,NULL),(6,'Communications',1,65,5,NULL),(7,'Construction',1,66,6,NULL),(8,'Consulting',1,67,7,NULL),(9,'Education',1,68,8,NULL),(10,'Electronics',1,69,9,NULL),(11,'Energy',1,70,10,NULL),(12,'Engineering',1,71,11,NULL),(13,'Entertainment',1,72,12,NULL),(14,'Environmental',1,73,13,NULL),(15,'Finance',1,74,14,NULL),(16,'Food & Beverage',1,75,15,NULL),(17,'Government',1,76,16,NULL),(18,'Healthcare',1,77,17,NULL),(19,'Hospitality',1,78,18,NULL),(20,'Insurance',1,79,19,NULL),(21,'Machinery',1,80,20,NULL),(22,'Manufacturing',1,81,21,NULL),(23,'Media',1,82,22,NULL),(24,'Not For Profit',1,83,23,NULL),(25,'Recreation',1,84,24,NULL),(26,'Retail',1,85,25,NULL),(27,'Shipping',1,86,26,NULL),(28,'Technology',1,87,27,NULL),(29,'Telecommunications',1,88,28,NULL),(30,'Transportation',1,89,29,NULL),(31,'Utilities',1,90,30,NULL),(32,'Other',1,91,31,NULL);

--
-- Table structure for table `vtiger_industry_seq`
--

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

--
-- Dumping data for table `vtiger_industry_seq`
--

INSERT INTO `vtiger_industry_seq` VALUES (32);

--
-- Table structure for table `vtiger_inventory_tandc`
--

CREATE TABLE `vtiger_inventory_tandc` (
  `id` int(11) NOT NULL,
  `type` varchar(30) NOT NULL,
  `tandc` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventory_tandc`
--

INSERT INTO `vtiger_inventory_tandc` VALUES (2,'Invoice','\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.'),(3,'Quotes','\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.'),(4,'PurchaseOrder','\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.'),(5,'SalesOrder','\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.');

--
-- Table structure for table `vtiger_inventory_tandc_seq`
--

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

--
-- Dumping data for table `vtiger_inventory_tandc_seq`
--

INSERT INTO `vtiger_inventory_tandc_seq` VALUES (5);

--
-- Table structure for table `vtiger_inventorycharges`
--

CREATE TABLE `vtiger_inventorycharges` (
  `chargeid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `format` varchar(10) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `value` decimal(12,5) DEFAULT NULL,
  `regions` text DEFAULT NULL,
  `istaxable` int(11) NOT NULL DEFAULT 1,
  `taxes` varchar(1024) DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`chargeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventorycharges`
--

INSERT INTO `vtiger_inventorycharges` VALUES (1,'Shipping & Handling','Flat','Fixed',NULL,'[]',1,'[\"1\",\"2\",\"3\"]',0);

--
-- Table structure for table `vtiger_inventorychargesrel`
--

CREATE TABLE `vtiger_inventorychargesrel` (
  `recordid` int(11) NOT NULL,
  `charges` text DEFAULT NULL,
  KEY `record_idx` (`recordid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventorychargesrel`
--


--
-- Table structure for table `vtiger_inventorynotification`
--

CREATE TABLE `vtiger_inventorynotification` (
  `notificationid` int(11) NOT NULL AUTO_INCREMENT,
  `notificationname` varchar(200) DEFAULT NULL,
  `notificationsubject` varchar(200) DEFAULT NULL,
  `notificationbody` text DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`notificationid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventorynotification`
--

INSERT INTO `vtiger_inventorynotification` VALUES (1,'InvoiceNotification','{PRODUCTNAME} Stock Level is Low','Dear {HANDLER},\n\nThe current stock of {PRODUCTNAME} in our warehouse is {CURRENTSTOCK}. Kindly procure required number of units as the stock level is below reorder level {REORDERLEVELVALUE}.\n\nPlease treat this information as Urgent as the invoice is already sent  to the customer.\n\nSeverity: Critical\n\nThanks,\n{CURRENTUSER} ','InvoiceNotificationDescription',NULL),(2,'QuoteNotification','Quote given for {PRODUCTNAME}','Dear {HANDLER},\n\nQuote is generated for {QUOTEQUANTITY} units of {PRODUCTNAME}. The current stock of {PRODUCTNAME} in our warehouse is {CURRENTSTOCK}.\n\nSeverity: Minor\n\nThanks,\n{CURRENTUSER} ','QuoteNotificationDescription',NULL),(3,'SalesOrderNotification','Sales Order generated for {PRODUCTNAME}','Dear {HANDLER},\n\nSalesOrder is generated for {SOQUANTITY} units of {PRODUCTNAME}. The current stock of {PRODUCTNAME} in our warehouse is {CURRENTSTOCK}.\n\nPlease treat this information  with priority as the sales order is already generated.\n\nSeverity: Major\n\nThanks,\n{CURRENTUSER} ','SalesOrderNotificationDescription',NULL);

--
-- Table structure for table `vtiger_inventorynotification_seq`
--

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

--
-- Dumping data for table `vtiger_inventorynotification_seq`
--

INSERT INTO `vtiger_inventorynotification_seq` VALUES (3);

--
-- Table structure for table `vtiger_inventoryproductrel`
--

CREATE TABLE `vtiger_inventoryproductrel` (
  `id` int(11) DEFAULT NULL,
  `productid` int(11) DEFAULT NULL,
  `sequence_no` int(11) DEFAULT NULL,
  `quantity` decimal(25,3) DEFAULT NULL,
  `listprice` decimal(27,8) DEFAULT NULL,
  `discount_percent` decimal(7,3) DEFAULT NULL,
  `discount_amount` decimal(27,8) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `incrementondel` int(11) NOT NULL DEFAULT 0,
  `lineitem_id` int(11) NOT NULL AUTO_INCREMENT,
  `tax1` decimal(7,3) DEFAULT NULL,
  `tax2` decimal(7,3) DEFAULT NULL,
  `tax3` decimal(7,3) DEFAULT NULL,
  `image` varchar(2) DEFAULT NULL,
  `purchase_cost` decimal(27,8) DEFAULT NULL,
  `margin` decimal(27,8) DEFAULT NULL,
  PRIMARY KEY (`lineitem_id`),
  KEY `inventoryproductrel_id_idx` (`id`),
  KEY `inventoryproductrel_productid_idx` (`productid`),
  CONSTRAINT `fk_crmid_vtiger_inventoryproductrel` FOREIGN KEY (`id`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventoryproductrel`
--


--
-- Table structure for table `vtiger_inventoryproductrel_seq`
--

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

--
-- Dumping data for table `vtiger_inventoryproductrel_seq`
--

INSERT INTO `vtiger_inventoryproductrel_seq` VALUES (0);

--
-- Table structure for table `vtiger_inventoryshippingrel`
--

CREATE TABLE `vtiger_inventoryshippingrel` (
  `id` int(11) DEFAULT NULL,
  `shtax1` decimal(7,3) DEFAULT NULL,
  `shtax2` decimal(7,3) DEFAULT NULL,
  `shtax3` decimal(7,3) DEFAULT NULL,
  KEY `inventoryishippingrel_id_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventoryshippingrel`
--


--
-- Table structure for table `vtiger_inventorysubproductrel`
--

CREATE TABLE `vtiger_inventorysubproductrel` (
  `id` int(11) NOT NULL,
  `sequence_no` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `quantity` int(11) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventorysubproductrel`
--


--
-- Table structure for table `vtiger_inventorytaxinfo`
--

CREATE TABLE `vtiger_inventorytaxinfo` (
  `taxid` int(11) NOT NULL,
  `taxname` varchar(50) DEFAULT NULL,
  `taxlabel` varchar(50) DEFAULT NULL,
  `percentage` decimal(7,3) DEFAULT NULL,
  `deleted` int(11) DEFAULT NULL,
  `method` varchar(10) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `compoundon` varchar(400) DEFAULT NULL,
  `regions` text DEFAULT NULL,
  PRIMARY KEY (`taxid`),
  KEY `inventorytaxinfo_taxname_idx` (`taxname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_inventorytaxinfo`
--

INSERT INTO `vtiger_inventorytaxinfo` VALUES (1,'tax1','VAT',4.500,0,'Simple','Fixed','[]','[]'),(2,'tax2','Sales',10.000,0,'Simple','Fixed','[]','[]'),(3,'tax3','Service',12.500,0,'Simple','Fixed','[]','[]');

--
-- Table structure for table `vtiger_inventorytaxinfo_seq`
--

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

--
-- Dumping data for table `vtiger_inventorytaxinfo_seq`
--

INSERT INTO `vtiger_inventorytaxinfo_seq` VALUES (3);

--
-- Table structure for table `vtiger_invitees`
--

CREATE TABLE `vtiger_invitees` (
  `activityid` int(11) NOT NULL,
  `inviteeid` int(11) NOT NULL,
  `status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`activityid`,`inviteeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invitees`
--


--
-- Table structure for table `vtiger_invoice`
--

CREATE TABLE `vtiger_invoice` (
  `invoiceid` int(11) NOT NULL DEFAULT 0,
  `subject` varchar(100) DEFAULT NULL,
  `salesorderid` int(11) DEFAULT NULL,
  `customerno` varchar(100) DEFAULT NULL,
  `contactid` int(11) DEFAULT NULL,
  `notes` varchar(100) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `invoiceterms` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `adjustment` decimal(25,8) DEFAULT NULL,
  `salescommission` decimal(25,3) DEFAULT NULL,
  `exciseduty` decimal(25,3) DEFAULT NULL,
  `subtotal` decimal(25,8) DEFAULT NULL,
  `total` decimal(25,8) DEFAULT NULL,
  `taxtype` varchar(25) DEFAULT NULL,
  `discount_percent` decimal(25,3) DEFAULT NULL,
  `discount_amount` decimal(25,8) DEFAULT NULL,
  `s_h_amount` decimal(25,8) DEFAULT NULL,
  `shipping` varchar(100) DEFAULT NULL,
  `accountid` int(11) DEFAULT NULL,
  `terms_conditions` text DEFAULT NULL,
  `purchaseorder` varchar(200) DEFAULT NULL,
  `invoicestatus` varchar(200) DEFAULT NULL,
  `invoice_no` varchar(100) DEFAULT NULL,
  `currency_id` int(11) NOT NULL DEFAULT 1,
  `conversion_rate` decimal(10,3) NOT NULL DEFAULT 1.000,
  `compound_taxes_info` text DEFAULT NULL,
  `pre_tax_total` decimal(25,8) DEFAULT NULL,
  `received` decimal(25,8) DEFAULT NULL,
  `balance` decimal(25,8) DEFAULT NULL,
  `s_h_percent` decimal(25,8) DEFAULT NULL,
  `potential_id` varchar(100) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  `region_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`invoiceid`),
  KEY `invoice_purchaseorderid_idx` (`invoiceid`),
  KEY `fk_2_vtiger_invoice` (`salesorderid`),
  CONSTRAINT `fk_2_vtiger_invoice` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE,
  CONSTRAINT `fk_crmid_vtiger_invoice` FOREIGN KEY (`invoiceid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoice`
--


--
-- Table structure for table `vtiger_invoice_recurring_info`
--

CREATE TABLE `vtiger_invoice_recurring_info` (
  `salesorderid` int(11) NOT NULL,
  `recurring_frequency` varchar(200) DEFAULT NULL,
  `start_period` date DEFAULT NULL,
  `end_period` date DEFAULT NULL,
  `last_recurring_date` date DEFAULT NULL,
  `payment_duration` varchar(200) DEFAULT NULL,
  `invoice_status` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`salesorderid`),
  CONSTRAINT `fk_salesorderid_vtiger_invoice_recurring_info` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoice_recurring_info`
--


--
-- Table structure for table `vtiger_invoicebillads`
--

CREATE TABLE `vtiger_invoicebillads` (
  `invoicebilladdressid` 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 (`invoicebilladdressid`),
  CONSTRAINT `fk_1_vtiger_invoicebillads` FOREIGN KEY (`invoicebilladdressid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoicebillads`
--


--
-- Table structure for table `vtiger_invoicecf`
--

CREATE TABLE `vtiger_invoicecf` (
  `invoiceid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`invoiceid`),
  CONSTRAINT `fk_1_vtiger_invoicecf` FOREIGN KEY (`invoiceid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoicecf`
--


--
-- Table structure for table `vtiger_invoiceshipads`
--

CREATE TABLE `vtiger_invoiceshipads` (
  `invoiceshipaddressid` 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_street` varchar(250) DEFAULT NULL,
  `ship_pobox` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`invoiceshipaddressid`),
  CONSTRAINT `fk_1_vtiger_invoiceshipads` FOREIGN KEY (`invoiceshipaddressid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoiceshipads`
--


--
-- Table structure for table `vtiger_invoicestatus`
--

CREATE TABLE `vtiger_invoicestatus` (
  `invoicestatusid` int(11) NOT NULL AUTO_INCREMENT,
  `invoicestatus` 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 (`invoicestatusid`),
  UNIQUE KEY `invoicestatus_invoiestatus_idx` (`invoicestatus`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoicestatus`
--

INSERT INTO `vtiger_invoicestatus` VALUES (1,'AutoCreated',0,92,0,NULL),(2,'Created',0,93,1,NULL),(3,'Approved',0,94,2,NULL),(4,'Sent',0,95,3,NULL),(5,'Credit Invoice',0,96,4,NULL),(6,'Paid',0,97,5,NULL),(7,'Cancel',1,288,1,NULL);

--
-- Table structure for table `vtiger_invoicestatus_seq`
--

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

--
-- Dumping data for table `vtiger_invoicestatus_seq`
--

INSERT INTO `vtiger_invoicestatus_seq` VALUES (7);

--
-- Table structure for table `vtiger_invoicestatushistory`
--

CREATE TABLE `vtiger_invoicestatushistory` (
  `historyid` int(11) NOT NULL AUTO_INCREMENT,
  `invoiceid` int(11) NOT NULL,
  `accountname` varchar(100) DEFAULT NULL,
  `total` decimal(10,0) DEFAULT NULL,
  `invoicestatus` varchar(200) DEFAULT NULL,
  `lastmodified` datetime DEFAULT NULL,
  PRIMARY KEY (`historyid`),
  KEY `invoicestatushistory_invoiceid_idx` (`invoiceid`),
  CONSTRAINT `fk_1_vtiger_invoicestatushistory` FOREIGN KEY (`invoiceid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_invoicestatushistory`
--


--
-- Table structure for table `vtiger_language`
--

CREATE TABLE `vtiger_language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `prefix` varchar(10) DEFAULT NULL,
  `label` varchar(30) DEFAULT NULL,
  `lastupdated` datetime DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `isdefault` int(11) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_language`
--

INSERT INTO `vtiger_language` VALUES (1,'English','en_us','US English','2023-02-09 21:57:07',NULL,1,1),(2,'Arabic','ar_ae','Arabic','2023-04-04 22:52:27',NULL,0,1),(3,'Brazilian','pt_br','PT Brasil','2023-04-04 22:52:28',NULL,0,1),(4,'British English','en_gb','British English','2023-04-04 22:52:28',NULL,0,1),(5,'Deutsch','de_de','DE Deutsch','2023-04-04 22:52:28',NULL,0,1),(6,'Dutch','nl_nl','NL-Dutch','2023-04-04 22:52:28',NULL,0,1),(7,'Pack de langue français','fr_fr','Pack de langue français','2023-04-04 22:52:27',NULL,0,1),(8,'Hungarian','hu_hu','HU Magyar','2023-04-04 22:52:27',NULL,0,1),(9,'Italian','it_it','IT Italian','2023-04-04 22:52:27',NULL,0,1),(10,'Mexican Spanish','es_mx','ES Mexico','2023-04-04 22:52:28',NULL,0,1),(11,'Język Polski','pl_pl','Język Polski','2023-04-04 22:52:28',NULL,0,1),(12,'Romana','ro_ro','Romana','2023-04-04 22:52:27',NULL,0,1),(13,'Russian','ru_ru','Russian','2023-04-04 22:52:28',NULL,0,1),(14,'Spanish','es_es','ES Spanish','2023-04-04 22:52:27',NULL,0,1),(15,'Swedish','sv_se','Swedish','2023-04-04 22:52:28',NULL,0,1),(16,'Turkce','tr_tr','Turkce Dil Paketi','2023-04-04 22:52:27',NULL,0,1),(17,'SpanishPeru','es_pe','ES Peru','2023-02-15 22:36:55',NULL,0,1);

--
-- Table structure for table `vtiger_language_seq`
--

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

--
-- Dumping data for table `vtiger_language_seq`
--

INSERT INTO `vtiger_language_seq` VALUES (17);

--
-- Table structure for table `vtiger_lead_view`
--

CREATE TABLE `vtiger_lead_view` (
  `lead_viewid` int(11) NOT NULL AUTO_INCREMENT,
  `lead_view` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`lead_viewid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_lead_view`
--

INSERT INTO `vtiger_lead_view` VALUES (1,'Today',0,1),(2,'Last 2 Days',1,1),(3,'Last Week',2,1);

--
-- Table structure for table `vtiger_lead_view_seq`
--

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

--
-- Dumping data for table `vtiger_lead_view_seq`
--

INSERT INTO `vtiger_lead_view_seq` VALUES (3);

--
-- Table structure for table `vtiger_leadaddress`
--

CREATE TABLE `vtiger_leadaddress` (
  `leadaddressid` int(11) NOT NULL DEFAULT 0,
  `city` varchar(30) DEFAULT NULL,
  `code` varchar(30) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL,
  `pobox` varchar(30) DEFAULT NULL,
  `country` varchar(30) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `fax` varchar(50) DEFAULT NULL,
  `lane` varchar(250) DEFAULT NULL,
  `leadaddresstype` varchar(30) DEFAULT 'Billing',
  PRIMARY KEY (`leadaddressid`),
  CONSTRAINT `fk_1_vtiger_leadaddress` FOREIGN KEY (`leadaddressid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_leadaddress`
--


--
-- Table structure for table `vtiger_leaddetails`
--

CREATE TABLE `vtiger_leaddetails` (
  `leadid` int(11) NOT NULL,
  `lead_no` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `interest` varchar(50) DEFAULT NULL,
  `firstname` varchar(40) DEFAULT NULL,
  `salutation` varchar(200) DEFAULT NULL,
  `lastname` varchar(80) NOT NULL,
  `company` varchar(100) NOT NULL,
  `annualrevenue` decimal(25,8) DEFAULT NULL,
  `industry` varchar(200) DEFAULT NULL,
  `campaign` varchar(30) DEFAULT NULL,
  `rating` varchar(200) DEFAULT NULL,
  `leadstatus` varchar(200) DEFAULT NULL,
  `leadsource` varchar(200) DEFAULT NULL,
  `converted` int(11) DEFAULT 0,
  `designation` varchar(50) DEFAULT 'SalesMan',
  `licencekeystatus` varchar(50) DEFAULT NULL,
  `space` varchar(250) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `priority` varchar(50) DEFAULT NULL,
  `demorequest` varchar(50) DEFAULT NULL,
  `partnercontact` varchar(50) DEFAULT NULL,
  `productversion` varchar(20) DEFAULT NULL,
  `product` varchar(50) DEFAULT NULL,
  `maildate` date DEFAULT NULL,
  `nextstepdate` date DEFAULT NULL,
  `fundingsituation` varchar(50) DEFAULT NULL,
  `purpose` varchar(50) DEFAULT NULL,
  `evaluationstatus` varchar(50) DEFAULT NULL,
  `transferdate` date DEFAULT NULL,
  `revenuetype` varchar(50) DEFAULT NULL,
  `noofemployees` int(11) DEFAULT NULL,
  `secondaryemail` varchar(100) DEFAULT NULL,
  `assignleadchk` int(11) DEFAULT 0,
  `emailoptout` varchar(3) DEFAULT NULL,
  `tags` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`leadid`),
  KEY `leaddetails_converted_leadstatus_idx` (`converted`,`leadstatus`),
  KEY `email_idx` (`email`),
  CONSTRAINT `fk_1_vtiger_leaddetails` FOREIGN KEY (`leadid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_leaddetails`
--


--
-- Table structure for table `vtiger_leadscf`
--

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

--
-- Dumping data for table `vtiger_leadscf`
--


--
-- Table structure for table `vtiger_leadsource`
--

CREATE TABLE `vtiger_leadsource` (
  `leadsourceid` int(11) NOT NULL AUTO_INCREMENT,
  `leadsource` 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 (`leadsourceid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_leadsource`
--

INSERT INTO `vtiger_leadsource` VALUES (2,'Cold Call',1,99,1,NULL),(3,'Existing Customer',1,100,2,NULL),(4,'Self Generated',1,101,3,NULL),(5,'Employee',1,102,4,NULL),(6,'Partner',1,103,5,NULL),(7,'Public Relations',1,104,6,NULL),(8,'Direct Mail',1,105,7,NULL),(9,'Conference',1,106,8,NULL),(10,'Trade Show',1,107,9,NULL),(11,'Web Site',1,108,10,NULL),(12,'Word of mouth',1,109,11,NULL),(13,'Other',1,110,12,NULL);

--
-- Table structure for table `vtiger_leadsource_seq`
--

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

--
-- Dumping data for table `vtiger_leadsource_seq`
--

INSERT INTO `vtiger_leadsource_seq` VALUES (13);

--
-- Table structure for table `vtiger_leadstage`
--

CREATE TABLE `vtiger_leadstage` (
  `leadstageid` int(11) NOT NULL AUTO_INCREMENT,
  `stage` varchar(200) NOT NULL,
  `sortorderid` int(11) NOT NULL DEFAULT 0,
  `presence` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`leadstageid`),
  UNIQUE KEY `leadstage_stage_idx` (`stage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_leadstage`
--


--
-- Table structure for table `vtiger_leadstatus`
--

CREATE TABLE `vtiger_leadstatus` (
  `leadstatusid` int(11) NOT NULL AUTO_INCREMENT,
  `leadstatus` 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 (`leadstatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_leadstatus`
--

INSERT INTO `vtiger_leadstatus` VALUES (2,'Attempted to Contact',1,112,1,NULL),(3,'Cold',1,113,2,NULL),(4,'Contact in Future',1,114,3,NULL),(5,'Contacted',1,115,4,NULL),(6,'Hot',1,116,5,NULL),(7,'Junk Lead',1,117,6,NULL),(8,'Lost Lead',1,118,7,NULL),(9,'Not Contacted',1,119,8,NULL),(10,'Pre Qualified',1,120,9,NULL),(11,'Qualified',1,121,10,NULL),(12,'Warm',1,122,11,NULL);

--
-- Table structure for table `vtiger_leadstatus_seq`
--

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

--
-- Dumping data for table `vtiger_leadstatus_seq`
--

INSERT INTO `vtiger_leadstatus_seq` VALUES (12);

--
-- Table structure for table `vtiger_leadsubdetails`
--

CREATE TABLE `vtiger_leadsubdetails` (
  `leadsubscriptionid` int(11) NOT NULL DEFAULT 0,
  `website` varchar(255) DEFAULT NULL,
  `callornot` int(11) DEFAULT 0,
  `readornot` int(11) DEFAULT 0,
  `empct` int(11) DEFAULT 0,
  PRIMARY KEY (`leadsubscriptionid`),
  CONSTRAINT `fk_1_vtiger_leadsubdetails` FOREIGN KEY (`leadsubscriptionid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_leadsubdetails`
--


--
-- Table structure for table `vtiger_links`
--

CREATE TABLE `vtiger_links` (
  `linkid` int(11) NOT NULL,
  `tabid` int(11) DEFAULT NULL,
  `linktype` varchar(50) DEFAULT NULL,
  `linklabel` varchar(50) DEFAULT NULL,
  `linkurl` varchar(255) DEFAULT NULL,
  `linkicon` varchar(100) DEFAULT NULL,
  `sequence` int(11) DEFAULT NULL,
  `handler_path` varchar(128) DEFAULT NULL,
  `handler_class` varchar(50) DEFAULT NULL,
  `handler` varchar(50) DEFAULT NULL,
  `parent_link` int(11) DEFAULT NULL,
  PRIMARY KEY (`linkid`),
  KEY `link_tabidtype_idx` (`tabid`,`linktype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_links`
--

INSERT INTO `vtiger_links` VALUES (2,6,'DETAILVIEW','LBL_SHOW_ACCOUNT_HIERARCHY','index.php?module=Accounts&action=AccountHierarchy&accountid=$RECORD$','',0,NULL,NULL,NULL,NULL),(11,7,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(12,4,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(13,6,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(14,2,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(15,42,'HEADERSCRIPT','ModCommentsCommonHeaderScript','modules/ModComments/ModCommentsCommon.js','',0,NULL,NULL,NULL,NULL),(34,2,'DASHBOARDWIDGET','History','index.php?module=Potentials&view=ShowWidget&name=History','',1,NULL,NULL,NULL,NULL),(35,2,'DASHBOARDWIDGET','Upcoming Activities','index.php?module=Potentials&view=ShowWidget&name=CalendarActivities','',2,NULL,NULL,NULL,NULL),(36,2,'DASHBOARDWIDGET','Funnel','index.php?module=Potentials&view=ShowWidget&name=GroupedBySalesStage','',3,NULL,NULL,NULL,NULL),(37,2,'DASHBOARDWIDGET','Potentials by Stage','index.php?module=Potentials&view=ShowWidget&name=GroupedBySalesPerson','',4,NULL,NULL,NULL,NULL),(38,2,'DASHBOARDWIDGET','Pipelined Amount','index.php?module=Potentials&view=ShowWidget&name=PipelinedAmountPerSalesPerson','',5,NULL,NULL,NULL,NULL),(39,2,'DASHBOARDWIDGET','Total Revenue','index.php?module=Potentials&view=ShowWidget&name=TotalRevenuePerSalesPerson','',6,NULL,NULL,NULL,NULL),(40,2,'DASHBOARDWIDGET','Top Potentials','index.php?module=Potentials&view=ShowWidget&name=TopPotentials','',7,NULL,NULL,NULL,NULL),(41,2,'DASHBOARDWIDGET','Overdue Activities','index.php?module=Potentials&view=ShowWidget&name=OverdueActivities','',9,NULL,NULL,NULL,NULL),(42,6,'DASHBOARDWIDGET','History','index.php?module=Accounts&view=ShowWidget&name=History','',1,NULL,NULL,NULL,NULL),(43,6,'DASHBOARDWIDGET','Upcoming Activities','index.php?module=Accounts&view=ShowWidget&name=CalendarActivities','',2,NULL,NULL,NULL,NULL),(44,6,'DASHBOARDWIDGET','Overdue Activities','index.php?module=Accounts&view=ShowWidget&name=OverdueActivities','',3,NULL,NULL,NULL,NULL),(45,4,'DASHBOARDWIDGET','History','index.php?module=Contacts&view=ShowWidget&name=History','',1,NULL,NULL,NULL,NULL),(46,4,'DASHBOARDWIDGET','Upcoming Activities','index.php?module=Contacts&view=ShowWidget&name=CalendarActivities','',2,NULL,NULL,NULL,NULL),(47,4,'DASHBOARDWIDGET','Overdue Activities','index.php?module=Contacts&view=ShowWidget&name=OverdueActivities','',3,NULL,NULL,NULL,NULL),(48,7,'DASHBOARDWIDGET','History','index.php?module=Leads&view=ShowWidget&name=History','',1,NULL,NULL,NULL,NULL),(49,7,'DASHBOARDWIDGET','Upcoming Activities','index.php?module=Leads&view=ShowWidget&name=CalendarActivities','',2,NULL,NULL,NULL,NULL),(50,7,'DASHBOARDWIDGET','Leads by Status','index.php?module=Leads&view=ShowWidget&name=LeadsByStatus','',4,NULL,NULL,NULL,NULL),(51,7,'DASHBOARDWIDGET','Leads by Source','index.php?module=Leads&view=ShowWidget&name=LeadsBySource','',5,NULL,NULL,NULL,NULL),(52,7,'DASHBOARDWIDGET','Leads by Industry','index.php?module=Leads&view=ShowWidget&name=LeadsByIndustry','',6,NULL,NULL,NULL,NULL),(53,7,'DASHBOARDWIDGET','Overdue Activities','index.php?module=Leads&view=ShowWidget&name=OverdueActivities','',7,NULL,NULL,NULL,NULL),(54,13,'DASHBOARDWIDGET','Tickets by Status','index.php?module=HelpDesk&view=ShowWidget&name=TicketsByStatus','',1,NULL,NULL,NULL,NULL),(55,13,'DASHBOARDWIDGET','Open Tickets','index.php?module=HelpDesk&view=ShowWidget&name=OpenTickets','',2,NULL,NULL,NULL,NULL),(56,3,'DASHBOARDWIDGET','History','index.php?module=Home&view=ShowWidget&name=History','',1,NULL,NULL,NULL,NULL),(57,3,'DASHBOARDWIDGET','Upcoming Activities','index.php?module=Home&view=ShowWidget&name=CalendarActivities','',2,NULL,NULL,NULL,NULL),(58,3,'DASHBOARDWIDGET','Funnel','index.php?module=Potentials&view=ShowWidget&name=GroupedBySalesStage','',3,NULL,NULL,NULL,NULL),(59,3,'DASHBOARDWIDGET','Potentials by Stage','index.php?module=Potentials&view=ShowWidget&name=GroupedBySalesPerson','',4,NULL,NULL,NULL,NULL),(60,3,'DASHBOARDWIDGET','Pipelined Amount','index.php?module=Potentials&view=ShowWidget&name=PipelinedAmountPerSalesPerson','',5,NULL,NULL,NULL,NULL),(61,3,'DASHBOARDWIDGET','Total Revenue','index.php?module=Potentials&view=ShowWidget&name=TotalRevenuePerSalesPerson','',6,NULL,NULL,NULL,NULL),(62,3,'DASHBOARDWIDGET','Top Potentials','index.php?module=Potentials&view=ShowWidget&name=TopPotentials','',7,NULL,NULL,NULL,NULL),(63,3,'DASHBOARDWIDGET','Leads by Status','index.php?module=Leads&view=ShowWidget&name=LeadsByStatus','',10,NULL,NULL,NULL,NULL),(64,3,'DASHBOARDWIDGET','Leads by Source','index.php?module=Leads&view=ShowWidget&name=LeadsBySource','',11,NULL,NULL,NULL,NULL),(65,3,'DASHBOARDWIDGET','Leads by Industry','index.php?module=Leads&view=ShowWidget&name=LeadsByIndustry','',12,NULL,NULL,NULL,NULL),(66,3,'DASHBOARDWIDGET','Overdue Activities','index.php?module=Home&view=ShowWidget&name=OverdueActivities','',13,NULL,NULL,NULL,NULL),(67,3,'DASHBOARDWIDGET','Tickets by Status','index.php?module=HelpDesk&view=ShowWidget&name=TicketsByStatus','',13,NULL,NULL,NULL,NULL),(68,3,'DASHBOARDWIDGET','Open Tickets','index.php?module=HelpDesk&view=ShowWidget&name=OpenTickets','',14,NULL,NULL,NULL,NULL),(69,13,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(70,15,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(99,3,'DASHBOARDWIDGET','Key Metrics','index.php?module=Home&view=ShowWidget&name=KeyMetrics','',0,NULL,NULL,NULL,NULL),(100,3,'DASHBOARDWIDGET','Mini List','index.php?module=Home&view=ShowWidget&name=MiniList','',0,NULL,NULL,NULL,NULL),(101,3,'DASHBOARDWIDGET','Tag Cloud','index.php?module=Home&view=ShowWidget&name=TagCloud','',0,NULL,NULL,NULL,NULL),(102,2,'DASHBOARDWIDGET','Funnel Amount','index.php?module=Potentials&view=ShowWidget&name=FunnelAmount','',10,NULL,NULL,NULL,NULL),(103,3,'DASHBOARDWIDGET','Funnel Amount','index.php?module=Potentials&view=ShowWidget&name=FunnelAmount','',10,NULL,NULL,NULL,NULL),(104,3,'DASHBOARDWIDGET','Notebook','index.php?module=Home&view=ShowWidget&name=Notebook','',0,NULL,NULL,NULL,NULL),(105,25,'LISTVIEWBASIC','LBL_ADD_RECORD','','',0,NULL,NULL,NULL,NULL),(106,25,'LISTVIEWBASIC','LBL_DETAIL_REPORT','javascript:Reports_List_Js.addReport(\"index.php?module=Reports&view=Edit\")','',0,'modules/Reports/models/Module.php','Reports_Module_Model','checkLinkAccess',105),(107,25,'LISTVIEWBASIC','LBL_CHARTS','javascript:Reports_List_Js.addReport(\"index.php?module=Reports&view=ChartEdit\")','',0,'modules/Reports/models/Module.php','Reports_Module_Model','checkLinkAccess',105),(108,25,'LISTVIEWBASIC','LBL_ADD_FOLDER','javascript:Reports_List_Js.triggerAddFolder(\"index.php?module=Reports&view=EditFolder\")','',0,'modules/Reports/models/Module.php','Reports_Module_Model','checkLinkAccess',NULL),(109,4,'EXTENSIONLINK','Google','index.php?module=Contacts&view=Extension&extensionModule=Google&extensionView=Index','',0,NULL,NULL,NULL,NULL),(110,9,'EXTENSIONLINK','Google','index.php?module=Calendar&view=Extension&extensionModule=Google&extensionView=Index','',0,NULL,NULL,NULL,NULL),(111,47,'HEADERSCRIPT','SMSNotifierCommonJS','modules/SMSNotifier/SMSNotifierCommon.js','',0,NULL,NULL,NULL,NULL),(112,7,'LISTVIEWBASIC','Send SMS','SMSNotifierCommon.displaySelectWizard(this, \'$MODULE$\');','',0,NULL,NULL,NULL,NULL),(113,7,'DETAILVIEW','Send SMS','javascript:SMSNotifierCommon.displaySelectWizard_DetailView(\'$MODULE$\', \'$RECORD$\');','',0,NULL,NULL,NULL,NULL),(114,4,'LISTVIEWBASIC','Send SMS','SMSNotifierCommon.displaySelectWizard(this, \'$MODULE$\');','',0,NULL,NULL,NULL,NULL),(115,4,'DETAILVIEW','Send SMS','javascript:SMSNotifierCommon.displaySelectWizard_DetailView(\'$MODULE$\', \'$RECORD$\');','',0,NULL,NULL,NULL,NULL),(116,6,'LISTVIEWBASIC','Send SMS','SMSNotifierCommon.displaySelectWizard(this, \'$MODULE$\');','',0,NULL,NULL,NULL,NULL),(117,6,'DETAILVIEW','Send SMS','javascript:SMSNotifierCommon.displaySelectWizard_DetailView(\'$MODULE$\', \'$RECORD$\');','',0,NULL,NULL,NULL,NULL),(124,44,'DETAILVIEWBASIC','Add Note','index.php?module=Documents&action=EditView&return_module=ProjectTask&return_action=DetailView&return_id=$RECORD$&parent_id=$RECORD$','',0,NULL,NULL,NULL,NULL),(125,44,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(126,45,'DETAILVIEWBASIC','Add Project Task','index.php?module=ProjectTask&action=EditView&projectid=$RECORD$&return_module=Project&return_action=DetailView&return_id=$RECORD$','',0,NULL,NULL,NULL,NULL),(127,45,'DETAILVIEWBASIC','Add Note','index.php?module=Documents&action=EditView&return_module=Project&return_action=DetailView&return_id=$RECORD$&parent_id=$RECORD$','',1,NULL,NULL,NULL,NULL),(128,45,'DETAILVIEWWIDGET','DetailViewBlockCommentWidget','block://ModComments:modules/ModComments/ModComments.php','',0,NULL,NULL,NULL,NULL),(129,49,'HEADERSCRIPT','ExtensionStoreCommonHeaderScript','modules/ExtensionStore/ExtensionStore.js','',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `vtiger_links_seq`
--

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

--
-- Dumping data for table `vtiger_links_seq`
--

INSERT INTO `vtiger_links_seq` VALUES (129);

--
-- Table structure for table `vtiger_loginhistory`
--

CREATE TABLE `vtiger_loginhistory` (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) DEFAULT NULL,
  `user_ip` varchar(25) NOT NULL,
  `logout_time` timestamp NULL DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `status` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`login_id`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vtiger_loginhistory`
--

INSERT INTO `vtiger_loginhistory` VALUES (1,'admin','38.25.16.205','2023-02-10 04:31:12','2023-02-09 21:58:13','Signed off'),(2,'admin','38.25.16.205','2023-02-10 04:35:53','2023-02-09 23:35:53','Signed in'),(3,'admin','179.6.201.91','2023-02-16 02:50:18','2023-02-15 21:39:23','Signed off'),(4,'admin','38.25.16.205','2023-02-16 03:29:12','2023-02-15 22:29:12','Signed in'),(5,'admin','179.6.201.91','2023-02-16 04:28:23','2023-02-15 23:11:56','Signed off'),(6,'admin','179.6.201.91','2023-02-16 05:02:07','2023-02-15 23:35:28','Signed off'),(7,'admin','67.58.227.88','2023-02-16 21:09:35','2023-02-16 16:09:35','Signed in'),(8,'admin','67.58.227.88','2023-02-17 02:05:30','2023-02-16 17:45:14','Signed off'),(9,'admin','2604:ca00:11c:88dd::261:f','2023-02-17 00:28:41','2023-02-16 19:28:41','Signed in'),(10,'admin','2604:ca00:11c:88dd::261:f','2023-02-17 00:29:15','2023-02-16 19:29:15','Signed in'),(11,'yannd','67.58.227.88','2023-02-17 00:34:56','2023-02-16 19:34:56','Signed in'),(12,'yannd','67.58.227.88','2023-02-17 02:41:45','2023-02-16 20:06:14','Signed off'),(13,'admin','179.6.201.91','2023-02-17 02:18:59','2023-02-16 21:05:27','Signed off'),(14,'admin','67.58.227.88','2023-02-17 03:22:41','2023-02-16 21:05:55','Signed off'),(15,'admin','179.6.201.91','2023-02-17 02:19:18','2023-02-16 21:19:06','Signed off'),(16,'admin','179.6.201.91','2023-02-17 02:22:00','2023-02-16 21:21:40','Signed off'),(17,'yannd','179.6.201.91','2023-02-17 02:22:07','2023-02-16 21:22:07','Signed in'),(18,'yannd','67.58.227.88','2023-02-17 02:42:11','2023-02-16 21:42:11','Signed in'),(19,'yannd','67.58.227.88','2023-02-17 03:01:09','2023-02-16 22:01:09','Signed in'),(20,'yannd','67.58.227.88','2023-02-17 03:51:10','2023-02-16 22:11:25','Signed off'),(21,'jci','67.58.227.88','2023-02-17 03:47:59','2023-02-16 22:22:49','Signed off'),(22,'tech02','67.58.227.88','2023-02-17 03:50:36','2023-02-16 22:40:34','Signed off'),(23,'jci','67.58.227.88','2023-02-17 03:51:30','2023-02-16 22:51:30','Signed in'),(24,'tech02','67.58.227.88','2023-02-17 11:43:45','2023-02-16 23:01:09','Signed off'),(25,'yannd','67.58.227.88','2023-02-17 11:44:05','2023-02-17 04:58:51','Signed off'),(26,'jci','67.58.227.88','2023-02-17 10:39:08','2023-02-17 05:39:08','Signed in'),(27,'jci','67.58.227.88','2023-02-17 11:47:52','2023-02-17 05:39:10','Signed off'),(28,'admin','181.224.249.36','2023-02-17 20:02:09','2023-02-17 15:02:09','Signed in'),(29,'jci','67.58.227.88','2023-02-18 03:03:18','2023-02-17 22:03:18','Signed in'),(30,'tech02','67.58.227.88','2023-02-18 03:07:36','2023-02-17 22:07:36','Signed in'),(31,'admin','179.6.201.91','2023-03-02 04:07:11','2023-03-01 23:07:11','Signed in'),(32,'yannd','179.6.201.91','2023-03-02 04:08:39','2023-03-01 23:08:39','Signed in'),(33,'tech02','67.58.227.88','2023-03-07 03:40:08','2023-03-06 22:40:08','Signed in'),(34,'admin','181.65.56.40','2023-03-07 04:02:10','2023-03-06 23:02:10','Signed in'),(35,'tech02','181.65.56.40','2023-03-07 04:07:35','2023-03-06 23:07:35','Signed in'),(36,'cgarcia','181.65.56.204','2023-03-13 18:19:53','2023-03-13 14:15:23','Signed off'),(37,'admin','181.65.56.204','2023-03-13 18:21:01','2023-03-13 14:21:01','Signed in'),(38,'cgarcia','181.65.56.204','2023-03-13 18:30:23','2023-03-13 14:30:23','Signed in'),(39,'cgarcia','181.65.56.204','2023-03-13 18:30:38','2023-03-13 14:30:38','Signed in'),(40,'admin','73.222.126.31','2023-03-15 20:08:34','2023-03-15 16:08:34','Signed in'),(41,'admin','67.58.227.88','2023-03-16 09:56:47','2023-03-16 05:52:10','Signed off'),(42,'admin','67.58.227.88','2023-03-16 09:57:11','2023-03-16 05:56:58','Signed off'),(43,'admin','67.58.227.88','2023-03-16 09:58:48','2023-03-16 05:57:46','Signed off'),(44,'admin','67.58.227.88','2023-03-16 10:05:24','2023-03-16 06:02:28','Signed off'),(45,'tech02','67.58.227.88','2023-03-16 10:06:19','2023-03-16 06:05:36','Signed off'),(46,'yannd','67.58.227.88','2023-03-16 10:07:00','2023-03-16 06:06:33','Signed off'),(47,'admin','67.58.227.88','2023-03-16 10:09:48','2023-03-16 06:07:33','Signed off'),(48,'jci','67.58.227.88','2023-03-16 10:09:53','2023-03-16 06:09:53','Signed in'),(49,'admin','181.65.56.204','2023-03-17 01:37:11','2023-03-16 21:37:11','Signed in'),(50,'admin','181.65.56.14','2023-03-21 18:49:00','2023-03-21 14:49:00','Signed in'),(51,'jci','135.26.144.132','2023-04-01 01:37:09','2023-03-31 21:37:09','Signed in'),(52,'tech02','135.26.144.132','2023-04-01 03:21:28','2023-03-31 23:21:28','Signed in'),(53,'tech02','135.26.144.132','2023-04-01 11:19:53','2023-04-01 07:19:53','Signed in'),(54,'admin','181.65.56.207','2023-04-04 22:53:14','2023-04-04 22:41:15','Signed off'),(55,'admin','181.65.56.207','2023-04-04 23:14:30','2023-04-04 23:14:30','Signed in'),(56,'admin','181.65.56.207','2023-04-04 23:17:36','2023-04-04 23:17:36','Signed in'),(57,'jci','135.26.144.132','2023-04-05 00:47:09','2023-04-05 00:47:09','Signed in'),(58,'jci','135.26.144.132','2023-04-06 02:45:23','2023-04-05 19:45:23','Signed in'),(59,'jci','170.82.98.224','2023-04-06 03:11:05','2023-04-05 20:11:05','Signed in'),(60,'yannd','135.26.144.132','2023-04-06 03:42:42','2023-04-05 20:36:59','Signed off'),(61,'angel','135.26.144.132','2023-04-06 03:43:17','2023-04-05 20:42:52','Signed off'),(62,'bim','135.26.144.132','2023-04-06 03:44:05','2023-04-05 20:43:51','Signed off'),(63,'angel','135.26.144.132','2023-04-06 04:06:13','2023-04-05 20:55:30','Signed off'),(64,'yannd','135.26.144.132','2023-04-06 04:06:18','2023-04-05 21:06:18','Signed in'),(65,'jci','38.25.12.188','2023-04-06 06:26:15','2023-04-05 23:26:15','Signed in'),(66,'jci','38.25.12.188','2023-04-06 07:09:12','2023-04-06 00:09:12','Signed in'),(67,'jci','135.26.144.132','2023-04-06 09:52:27','2023-04-06 02:52:27','Signed in'),(68,'yannd','135.26.144.132','2023-04-06 09:54:32','2023-04-06 02:54:32','Signed in'),(69,'yannd','135.26.144.132','2023-04-06 10:43:12','2023-04-06 03:41:12','Signed off'),(70,'yannd','135.26.144.132','2023-04-06 10:45:47','2023-04-06 03:43:14','Signed off'),(71,'yannd','135.26.144.132','2023-04-07 00:01:26','2023-04-06 17:00:58','Signed off'),(72,'jci','135.26.144.132','2023-04-07 00:02:31','2023-04-06 17:02:31','Signed in'),(73,'yannd','135.26.144.132','2023-04-11 03:18:33','2023-04-10 20:18:33','Signed in'),(74,'jci','181.65.56.36','2023-04-11 03:31:32','2023-04-10 20:31:32','Signed in'),(75,'yannd','181.65.56.36','2023-04-11 03:59:52','2023-04-10 20:37:23','Signed off'),(76,'admin','167.250.207.141','2023-04-11 03:53:01','2023-04-10 20:53:01','Signed in'),(77,'cristian','181.65.56.36','2023-04-11 04:22:54','2023-04-10 20:59:59','Signed off'),(78,'yannd','181.65.56.36','2023-04-11 04:23:05','2023-04-10 21:23:05','Signed in'),(79,'yannd','38.25.15.7','2023-04-11 04:35:51','2023-04-10 21:35:51','Signed in'),(80,'admin','38.25.15.7','2023-04-11 04:36:11','2023-04-10 21:36:11','Signed in'),(81,'admin','181.65.56.36','2023-04-11 07:00:40','2023-04-10 23:33:47','Signed off'),(82,'yannd','181.65.56.36','2023-04-11 07:01:29','2023-04-11 00:01:01','Signed off'),(83,'admin','181.65.56.36','2023-04-11 07:02:49','2023-04-11 00:01:40','Signed off'),(84,'yannd','181.65.56.36','2023-04-11 07:03:38','2023-04-11 00:03:02','Signed off'),(85,'admin','181.65.56.36','2023-04-11 07:04:21','2023-04-11 00:03:56','Signed off'),(86,'yannd','181.65.56.36','2023-04-11 07:04:38','2023-04-11 00:04:38','Signed in'),(87,'jci','135.26.144.132','2023-04-11 07:22:19','2023-04-11 00:22:19','Signed in'),(88,'yannd','135.26.144.132','2023-04-11 07:23:41','2023-04-11 00:23:41','Signed in'),(89,'jci','135.26.144.132','2023-04-11 09:14:06','2023-04-11 02:14:06','Signed in'),(90,'yannd','135.26.144.132','2023-04-11 09:41:28','2023-04-11 02:41:28','Signed in'),(91,'jci','135.26.144.132','2023-04-11 09:42:36','2023-04-11 02:42:36','Signed in'),(92,'angel','135.26.144.132','2023-04-11 09:52:28','2023-04-11 02:50:42','Signed off'),(93,'bim','135.26.144.132','2023-04-11 09:52:49','2023-04-11 02:52:49','Signed in'),(94,'admin','181.65.56.60','2023-04-11 22:08:40','2023-04-11 14:48:12','Signed off'),(95,'jci','181.65.56.60','2023-04-11 22:08:49','2023-04-11 15:08:49','Signed in'),(96,'admin','181.65.56.60','2023-04-11 23:43:48','2023-04-11 16:43:48','Signed in'),(97,'jci','135.26.144.132','2023-04-12 00:32:59','2023-04-11 17:32:59','Signed in'),(98,'jci','135.26.144.132','2023-04-14 11:55:57','2023-04-14 04:55:57','Signed in'),(99,'jci','135.26.144.132','2023-04-15 05:28:05','2023-04-14 22:28:05','Signed in'),(100,'admin','181.65.56.194','2023-04-15 05:50:21','2023-04-14 22:50:21','Signed in'),(101,'admin','167.250.207.141','2023-04-15 06:39:51','2023-04-14 23:06:11','Signed off'),(102,'admin','167.250.207.141','2023-04-15 06:40:04','2023-04-14 23:40:04','Signed in'),(103,'admin','167.250.207.141','2023-04-15 06:41:20','2023-04-14 23:41:20','Signed in'),(104,'admin','179.6.201.91','2023-04-15 06:47:44','2023-04-14 23:43:30','Signed off'),(105,'admin','167.250.207.141','2023-04-15 06:47:34','2023-04-14 23:47:34','Signed in'),(106,'admin','167.250.207.141','2023-04-15 06:49:16','2023-04-14 23:49:16','Signed in'),(107,'jci','135.26.144.132','2023-04-15 07:01:45','2023-04-15 00:01:45','Signed in'),(108,'admin','181.65.56.194','2023-04-15 07:29:39','2023-04-15 00:18:24','Signed off'),(109,'jci','135.26.144.132','2023-04-15 08:19:00','2023-04-15 00:19:49','Signed off'),(110,'admin','167.250.207.141','2023-04-15 07:23:45','2023-04-15 00:20:07','Signed off'),(111,'admin','167.250.207.141','2023-04-15 07:25:04','2023-04-15 00:24:26','Signed off'),(112,'admin','167.250.207.141','2023-04-15 07:25:27','2023-04-15 00:25:27','Signed in'),(113,'admin','167.250.207.141','2023-04-15 07:34:01','2023-04-15 00:29:08','Signed off'),(114,'admin','167.250.207.141','2023-04-15 07:43:03','2023-04-15 00:39:40','Signed off'),(115,'admin','167.250.207.141','2023-04-15 07:47:12','2023-04-15 00:47:11','Signed off'),(116,'admin','167.250.207.141','2023-04-15 07:49:46','2023-04-15 00:49:46','Signed in'),(117,'admin','179.6.201.91','2023-04-15 07:56:15','2023-04-15 00:56:15','Signed in'),(118,'admin','179.6.201.91','2023-04-15 07:57:17','2023-04-15 00:57:17','Signed in'),(119,'admin','181.65.56.194','2023-04-15 07:59:44','2023-04-15 00:59:44','Signed in'),(120,'admin','167.250.207.141','2023-04-15 08:14:51','2023-04-15 01:14:51','Signed in'),(121,'jci','135.26.144.132','2023-04-15 08:20:01','2023-04-15 01:19:19','Signed off'),(122,'angel','135.26.144.132','2023-04-15 08:23:23','2023-04-15 01:23:23','Signed in'),(123,'jci','135.26.144.132','2023-04-15 09:04:38','2023-04-15 01:25:34','Signed off'),(124,'admin','179.6.201.91','2023-04-15 09:05:00','2023-04-15 01:50:04','Signed off'),(125,'jci','135.26.144.132','2023-04-15 09:04:43','2023-04-15 02:04:43','Signed in'),(126,'admin','179.6.201.91','2023-04-15 09:05:47','2023-04-15 02:05:47','Signed in'),(127,'admin','181.65.56.194','2023-04-15 09:59:26','2023-04-15 02:59:26','Signed in'),(128,'jci','135.26.144.132','2023-04-15 13:20:04','2023-04-15 05:59:49','Signed off'),(129,'jci','135.26.144.132','2023-04-15 13:20:07','2023-04-15 06:20:07','Signed in'),(130,'jci','135.26.144.132','2023-04-15 13:47:20','2023-04-15 06:47:20','Signed in'),(131,'jci','135.26.144.132','2023-04-16 03:24:46','2023-04-15 20:24:46','Signed in'),(132,'jci','135.26.144.132','2023-04-16 04:48:38','2023-04-15 21:48:38','Signed in'),(133,'jci','67.58.227.88','2023-04-16 05:32:28','2023-04-15 22:32:28','Signed in'),(134,'admin','179.6.201.91','2023-04-17 23:29:54','2023-04-17 16:29:54','Signed in'),(135,'admin','181.65.56.206','2023-04-18 00:42:14','2023-04-17 17:42:14','Signed in'),(136,'jci','135.26.144.132','2023-04-18 02:03:49','2023-04-17 18:58:37','Signed off'),(137,'jci','135.26.144.132','2023-04-18 03:22:59','2023-04-17 20:22:59','Signed in'),(138,'jci','135.26.144.132','2023-04-18 04:20:37','2023-04-17 21:20:37','Signed in'),(139,'admin','179.6.201.91','2023-04-18 05:22:38','2023-04-17 22:10:35','Signed off'),(140,'jci','135.26.144.132','2023-04-18 05:16:21','2023-04-17 22:16:21','Signed in'),(141,'admin','179.6.201.91','2023-04-18 05:24:04','2023-04-17 22:24:04','Signed in'),(142,'admin','181.65.56.206','2023-04-18 05:36:27','2023-04-17 22:36:27','Signed in'),(143,'admin','38.25.15.7','2023-04-18 05:38:46','2023-04-17 22:38:46','Signed in'),(144,'admin','179.6.201.91','2023-04-18 06:55:40','2023-04-17 23:55:06','Signed off'),(145,'jci','135.26.144.132','2023-04-18 07:36:04','2023-04-18 00:07:17','Signed off'),(146,'jci','135.26.144.132','2023-04-18 07:36:06','2023-04-18 00:36:06','Signed in'),(147,'admin','181.65.56.206','2023-04-18 08:20:42','2023-04-18 01:20:42','Signed in'),(148,'jci','135.26.144.132','2023-04-18 08:25:22','2023-04-18 01:25:22','Signed in'),(149,'jci','135.26.144.132','2023-04-18 09:13:35','2023-04-18 02:13:35','Signed in'),(150,'jci','135.26.144.132','2023-04-18 09:46:33','2023-04-18 02:45:54','Signed off'),(151,'jci','135.26.144.132','2023-04-18 09:46:35','2023-04-18 02:46:35','Signed in'),(152,'jci','135.26.144.132','2023-04-18 09:49:18','2023-04-18 02:49:18','Signed in'),(153,'jci','135.26.144.132','2023-04-19 00:22:28','2023-04-18 17:22:28','Signed in'),(154,'admin','181.65.56.225','2023-04-19 02:14:11','2023-04-18 19:14:11','Signed in'),(155,'jci','135.26.144.132','2023-04-19 02:17:57','2023-04-18 19:17:57','Signed in'),(156,'jci','170.82.98.224','2023-04-19 02:30:12','2023-04-18 19:30:12','Signed in'),(157,'jci','135.26.144.132','2023-04-19 07:53:55','2023-04-19 00:53:55','Signed in'),(158,'jci','135.26.144.132','2023-04-19 22:45:06','2023-04-19 15:45:06','Signed in'),(159,'jci','170.82.98.224','2023-04-20 00:26:57','2023-04-19 17:26:57','Signed in'),(160,'admin','181.65.56.225','2023-04-20 03:16:39','2023-04-19 20:16:30','Signed off'),(161,'admin','181.65.56.225','2023-04-20 03:21:12','2023-04-19 20:17:19','Signed off'),(162,'admin','181.65.56.225','2023-04-20 05:49:13','2023-04-19 20:24:32','Signed off'),(163,'jci','73.222.126.31','2023-04-20 04:38:04','2023-04-19 21:38:04','Signed in'),(164,'admin','181.65.56.225','2023-04-20 05:49:19','2023-04-19 22:49:19','Signed in'),(165,'jci','38.25.12.188','2023-04-20 07:40:44','2023-04-20 00:40:44','Signed in'),(166,'jci','135.26.144.132','2023-04-20 11:42:34','2023-04-20 04:42:34','Signed in'),(167,'jci','38.25.12.188','2023-04-20 12:15:56','2023-04-20 05:15:56','Signed in'),(168,'jci','170.82.98.224','2023-04-20 23:31:53','2023-04-20 16:31:53','Signed in'),(169,'jci','135.26.144.132','2023-04-21 00:05:07','2023-04-20 17:05:07','Signed in'),(170,'jci','170.82.98.224','2023-04-21 00:09:43','2023-04-20 17:09:43','Signed in'),(171,'jci','170.82.98.224','2023-04-21 01:13:41','2023-04-20 18:13:41','Signed in'),(172,'jci','135.26.144.132','2023-04-21 02:22:17','2023-04-20 19:22:17','Signed in'),(173,'jci','172.56.169.169','2023-04-21 04:28:39','2023-04-20 21:28:39','Signed in'),(174,'jci','135.26.144.132','2023-04-21 05:16:32','2023-04-20 22:16:32','Signed in'),(175,'jci','38.25.12.188','2023-04-21 07:35:12','2023-04-21 00:35:12','Signed in'),(176,'jci','135.26.144.132','2023-04-21 07:41:44','2023-04-21 00:41:44','Signed in'),(177,'jci','38.25.12.188','2023-04-21 09:45:22','2023-04-21 02:45:22','Signed in'),(178,'jci','38.25.12.188','2023-04-21 09:49:38','2023-04-21 02:49:38','Signed in'),(179,'jci','135.26.144.132','2023-04-21 09:58:41','2023-04-21 02:58:41','Signed in'),(180,'jci','38.25.12.188','2023-04-21 10:00:31','2023-04-21 03:00:31','Signed in'),(181,'jci','38.25.12.188','2023-04-21 10:00:33','2023-04-21 03:00:33','Signed in'),(182,'jci','135.26.144.132','2023-04-21 11:33:08','2023-04-21 04:33:08','Signed in'),(183,'jci','172.56.169.62','2023-04-22 00:49:56','2023-04-21 17:49:56','Signed in'),(184,'jci','170.82.98.224','2023-04-22 03:17:57','2023-04-21 20:17:57','Signed in'),(185,'jci','170.82.98.224','2023-04-22 03:17:58','2023-04-21 20:17:58','Signed in'),(186,'admin','181.65.56.225','2023-04-25 12:11:17','2023-04-25 05:11:17','Signed in'),(187,'jci','135.26.144.132','2023-04-26 10:37:05','2023-04-26 03:37:05','Signed in'),(188,'admin','181.65.56.144','2023-05-05 05:02:12','2023-05-04 22:02:12','Signed in'),(189,'jci','67.58.227.88','2023-05-05 05:19:38','2023-05-04 22:19:38','Signed in'),(190,'jci','135.26.144.132','2023-05-05 21:54:43','2023-05-05 14:54:43','Signed in'),(191,'jci','135.26.144.132','2023-05-06 02:55:25','2023-05-05 19:55:25','Signed in'),(192,'jci','67.58.227.88','2023-05-09 00:45:48','2023-05-08 17:45:48','Signed in'),(193,'jci','67.58.227.88','2023-05-09 04:37:05','2023-05-08 21:37:05','Signed in'),(194,'admin','181.65.56.199','2023-05-09 06:17:40','2023-05-08 23:17:40','Signed in'),(195,'jci','67.58.227.88','2023-05-09 08:04:18','2023-05-09 01:04:18','Signed in'),(196,'jci','67.58.227.88','2023-05-09 11:24:31','2023-05-09 04:24:31','Signed in'),(197,'jci','67.58.227.88','2023-05-10 05:27:35','2023-05-09 22:27:35','Signed in'),(198,'admin','181.65.56.216','2023-05-10 21:28:36','2023-05-10 14:28:36','Signed in'),(199,'jci','67.58.227.88','2023-05-11 01:30:07','2023-05-10 18:30:07','Signed in'),(200,'jci','67.58.227.88','2023-05-11 04:52:12','2023-05-10 21:52:12','Signed in'),(201,'jci','67.58.227.88','2023-05-11 06:41:42','2023-05-10 23:41:42','Signed in'),(202,'jci','67.58.227.88','2023-05-11 07:38:38','2023-05-11 00:38:38','Signed in'),(203,'bim','73.92.211.132','2023-05-11 08:25:50','2023-05-11 01:25:50','Signed in'),(204,'jci','67.58.227.88','2023-05-11 13:49:40','2023-05-11 06:49:40','Signed in'),(205,'jci','67.58.227.88','2023-05-11 23:22:51','2023-05-11 16:22:51','Signed in'),(206,'yann','67.58.227.88','2023-05-11 23:43:40','2023-05-11 16:43:40','Signed in'),(207,'bim','73.92.211.132','2023-05-12 00:02:18','2023-05-11 17:02:18','Signed in'),(208,'yann','67.58.227.88','2023-05-12 03:19:19','2023-05-11 20:19:19','Signed in'),(209,'jci','67.58.227.88','2023-05-12 03:20:49','2023-05-11 20:20:49','Signed in'),(210,'jci','67.58.227.88','2023-05-12 07:26:55','2023-05-12 00:26:55','Signed in'),(211,'jci','67.58.227.88','2023-05-12 10:45:34','2023-05-12 03:45:34','Signed in'),(212,'admin','181.65.56.212','2023-05-12 23:58:30','2023-05-12 16:58:30','Signed in'),(213,'jci','67.58.227.88','2023-05-15 22:17:47','2023-05-15 15:17:47','Signed in'),(214,'bim','136.24.107.22','2023-05-16 01:42:10','2023-05-15 18:42:10','Signed in'),(215,'jci','67.58.227.88','2023-05-17 01:03:20','2023-05-16 18:03:20','Signed in'),(216,'admin','181.65.56.180','2023-05-17 01:14:22','2023-05-16 18:14:22','Signed in'),(217,'admin','181.65.56.180','2023-05-17 01:14:23','2023-05-16 18:14:23','Signed in'),(218,'jci','67.58.227.88','2023-05-17 01:38:21','2023-05-16 18:38:21','Signed in'),(219,'jci','67.58.227.88','2023-05-17 03:03:52','2023-05-16 20:03:52','Signed in'),(220,'jci','67.58.227.88','2023-05-17 04:55:21','2023-05-16 21:55:21','Signed in'),(221,'jci','67.58.227.88','2023-05-17 05:01:54','2023-05-16 22:01:54','Signed in'),(222,'jci','67.58.227.88','2023-05-17 05:03:54','2023-05-16 22:03:54','Signed in'),(223,'jci','67.58.227.88','2023-05-17 07:54:08','2023-05-17 00:54:08','Signed in'),(224,'yann','162.217.73.50','2023-05-17 08:39:37','2023-05-17 01:39:37','Signed in'),(225,'jci','67.58.227.88','2023-05-17 12:58:33','2023-05-17 05:58:33','Signed in'),(226,'admin','181.65.56.5','2023-05-17 21:41:04','2023-05-17 14:39:21','Signed off'),(227,'jci','181.65.56.5','2023-05-17 21:41:17','2023-05-17 14:41:17','Signed in'),(228,'jci','67.58.227.88','2023-05-17 23:47:34','2023-05-17 16:47:34','Signed in'),(229,'admin','181.65.56.5','2023-05-18 00:25:02','2023-05-17 17:25:02','Signed in'),(230,'jci','67.58.227.88','2023-05-18 00:25:24','2023-05-17 17:25:24','Signed in'),(231,'admin','167.250.207.141','2023-05-18 00:36:26','2023-05-17 17:36:26','Signed in'),(232,'bohadmin','67.58.227.88','2023-05-18 00:45:59','2023-05-17 17:45:59','Signed in'),(233,'angel','67.58.227.88','2023-05-18 00:53:32','2023-05-17 17:51:58','Signed off'),(234,'rodrigo','67.58.227.88','2023-05-18 00:58:12','2023-05-17 17:54:07','Signed off'),(235,'angel','67.58.227.88','2023-05-18 01:01:29','2023-05-17 17:58:16','Signed off'),(236,'yann','67.58.227.88','2023-05-18 01:04:23','2023-05-17 18:03:20','Signed off'),(237,'bim','67.58.227.88','2023-05-18 01:15:12','2023-05-17 18:04:52','Signed off'),(238,'bim','67.58.227.88','2023-05-18 01:49:32','2023-05-17 18:49:32','Signed in'),(239,'yann','162.217.73.50','2023-05-18 11:09:34','2023-05-18 04:09:34','Signed in'),(240,'rodrigo','73.222.126.31','2023-05-18 11:22:48','2023-05-18 04:22:48','Signed in'),(241,'bohadmin','73.222.126.31','2023-05-18 11:26:54','2023-05-18 04:26:54','Signed in'),(242,'jci','67.58.227.88','2023-05-18 11:29:41','2023-05-18 04:29:41','Signed in'),(243,'admin','181.65.56.141','2023-05-19 05:37:10','2023-05-18 22:37:10','Signed in'),(244,'yann','162.217.73.50','2023-05-19 09:36:47','2023-05-19 02:36:47','Signed in'),(245,'rodrigo','73.222.126.31','2023-05-19 11:31:00','2023-05-19 04:31:00','Signed in'),(246,'jci','67.58.227.88','2023-05-19 12:09:07','2023-05-19 05:09:07','Signed in'),(247,'jci','67.58.227.88','2023-05-19 13:10:38','2023-05-19 06:10:38','Signed in'),(248,'bim','73.92.211.132','2023-05-21 06:56:11','2023-05-20 23:56:11','Signed in'),(249,'jci','67.58.227.88','2023-05-21 08:40:08','2023-05-21 01:40:08','Signed in'),(250,'bohadmin','67.58.227.88','2023-05-22 02:58:26','2023-05-21 19:58:07','Signed off'),(251,'jci','67.58.227.88','2023-05-22 02:58:35','2023-05-21 19:58:35','Signed in'),(252,'bim','73.92.211.132','2023-05-22 03:27:25','2023-05-21 20:27:25','Signed in'),(253,'yann','76.21.57.133','2023-05-22 05:13:59','2023-05-21 22:13:59','Signed in'),(254,'angel','99.35.216.73','2023-05-22 22:23:00','2023-05-22 15:23:00','Signed in'),(255,'jci','67.58.227.88','2023-05-23 04:40:06','2023-05-22 21:40:06','Signed in'),(256,'jci','67.58.227.88','2023-05-23 22:13:02','2023-05-23 15:13:02','Signed in'),(257,'angel','73.71.205.3','2023-05-23 23:01:35','2023-05-23 16:01:35','Signed in'),(258,'admin','181.65.56.230','2023-05-23 23:54:54','2023-05-23 16:54:54','Signed in'),(259,'jci','67.58.227.88','2023-05-24 01:10:24','2023-05-23 18:10:24','Signed in'),(260,'jci','67.58.227.88','2023-05-24 02:33:27','2023-05-23 19:33:27','Signed in'),(261,'jci','67.58.227.88','2023-05-24 22:37:07','2023-05-24 15:37:07','Signed in'),(262,'jci','67.58.227.88','2023-05-24 23:51:21','2023-05-24 16:51:21','Signed in'),(263,'jci','67.58.227.88','2023-05-25 04:38:48','2023-05-24 21:38:48','Signed in'),(264,'jci','67.58.227.88','2023-05-25 05:07:15','2023-05-24 22:07:15','Signed in'),(265,'yann','162.217.73.50','2023-05-25 07:58:06','2023-05-25 00:58:06','Signed in'),(266,'jci','67.58.227.88','2023-05-25 10:19:21','2023-05-25 03:19:21','Signed in'),(267,'bim','67.58.227.88','2023-05-25 10:57:16','2023-05-25 03:57:16','Signed in'),(268,'jci','67.58.227.88','2023-05-25 23:13:50','2023-05-25 16:13:50','Signed in'),(269,'jci','67.58.227.88','2023-05-26 05:00:22','2023-05-25 22:00:22','Signed in'),(270,'jci','67.58.227.88','2023-05-26 06:25:59','2023-05-25 23:25:59','Signed in'),(271,'jci','67.58.227.88','2023-05-26 11:19:42','2023-05-26 04:19:42','Signed in'),(272,'jci','67.58.227.88','2023-05-26 23:05:38','2023-05-26 16:05:38','Signed in'),(273,'admin','179.7.88.112','2023-05-27 03:41:21','2023-05-26 20:41:21','Signed in'),(274,'admin','181.65.56.108','2023-05-30 07:27:25','2023-05-30 00:27:25','Signed in'),(275,'admin','181.65.56.108','2023-05-30 08:21:06','2023-05-30 01:20:02','Signed off'),(276,'admin','181.65.56.108','2023-05-30 08:23:29','2023-05-30 01:23:29','Signed in');

--
-- Table structure for table `vtiger_mailer_queue`
--

CREATE TABLE `vtiger_mailer_queue` (
  `id` int(11) NOT NULL,
  `fromname` varchar(100) DEFAULT NULL,
  `fromemail` varchar(100) DEFAULT NULL,
  `mailer` varchar(10) DEFAULT NULL,
  `content_type` varchar(15) DEFAULT NULL,
  `subject` varchar(999) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `relcrmid` int(11) DEFAULT NULL,
  `failed` int(11) NOT NULL DEFAULT 0,
  `failreason` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_mailer_queue`
--


--
-- Table structure for table `vtiger_mailer_queueattachments`
--

CREATE TABLE `vtiger_mailer_queueattachments` (
  `id` int(11) DEFAULT NULL,
  `path` text DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `encoding` varchar(50) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_mailer_queueattachments`
--


--
-- Table structure for table `vtiger_mailer_queueinfo`
--

CREATE TABLE `vtiger_mailer_queueinfo` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `type` varchar(7) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_mailer_queueinfo`
--


--
-- Table structure for table `vtiger_mailmanager_mailattachments`
--

CREATE TABLE `vtiger_mailmanager_mailattachments` (
  `userid` int(11) DEFAULT NULL,
  `muid` int(11) DEFAULT NULL,
  `aname` varchar(100) DEFAULT NULL,
  `lastsavedtime` int(11) DEFAULT NULL,
  `attachid` int(11) NOT NULL,
  `path` varchar(200) NOT NULL,
  `cid` varchar(100) DEFAULT NULL,
  KEY `userid_muid_idx` (`userid`,`muid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_mailmanager_mailattachments`
--


--
-- Table structure for table `vtiger_mailmanager_mailrecord`
--

CREATE TABLE `vtiger_mailmanager_mailrecord` (
  `userid` int(11) DEFAULT NULL,
  `mfrom` varchar(255) DEFAULT NULL,
  `mto` varchar(255) DEFAULT NULL,
  `mcc` varchar(500) DEFAULT NULL,
  `mbcc` varchar(500) DEFAULT NULL,
  `mdate` varchar(20) DEFAULT NULL,
  `msubject` varchar(500) DEFAULT NULL,
  `mbody` text DEFAULT NULL,
  `mcharset` varchar(10) DEFAULT NULL,
  `misbodyhtml` int(11) DEFAULT NULL,
  `mplainmessage` int(11) DEFAULT NULL,
  `mhtmlmessage` int(11) DEFAULT NULL,
  `muniqueid` varchar(500) DEFAULT NULL,
  `mbodyparsed` int(11) DEFAULT NULL,
  `muid` int(11) DEFAULT NULL,
  `lastsavedtime` int(11) DEFAULT NULL,
  `folder` varchar(250) DEFAULT NULL,
  `mfolder` varchar(250) DEFAULT NULL,
  KEY `userid_lastsavedtime_idx` (`userid`,`lastsavedtime`),
  KEY `userid_muid_idx` (`userid`,`muid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vtiger_mailmanager_mailrecord`
--

