--
-- Host: localhost    Database: care_new
-- ------------------------------------------------------


--
-- Table structure for table `cpumetrics`
--

CREATE TABLE `cpumetrics` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `cpuuniqueid` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `system_id` varchar(255) NOT NULL,
  `user` float NOT NULL,
  `sys` float NOT NULL,
  `iowait` float NOT NULL,
  `steal` float NOT NULL,
  `idle` float NOT NULL,
  `created_at` varchar(255) NOT NULL,
  `nice` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `cpuuniqueid` (`cpuuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cpumetrics`
--

INSERT INTO `cpumetrics` VALUES (1,'f92b52915f7e408b999f0d8121a2bca3','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7',6.78,0,0.81,2.21,90.02,'2021-04-09 15:28:51.362355\n','0'),(2,'0e26b6456fa7486a8d4869a2d591f12f','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061',7.85,0,0.85,2.54,88.74,'2021-04-09 15:28:51.362355\n','0');

--
-- Table structure for table `customer_mang`
--

CREATE TABLE `customer_mang` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `cusuniqueid` varchar(255) NOT NULL,
  `cuscomname` varchar(255) NOT NULL,
  `cuscontactname` varchar(255) NOT NULL,
  `cusmobnum` varchar(255) NOT NULL,
  `cusaddress` longtext NOT NULL,
  `cusemail` varchar(255) NOT NULL,
  `cuspassword` varchar(255) NOT NULL,
  `isverified` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `created_at` varchar(255) NOT NULL,
  `modified_at` varchar(255) NOT NULL,
  `sub_by` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `cusuniqueid` (`cusuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_mang`
--

INSERT INTO `customer_mang` VALUES (1,'4fb3adfe982011eb898e4397c39d3dcd','Canopus GBS','Rakesh Reddy','8904700327','Bangalore','rakesh.reddy@canopusgbs.com','$2b$12$n2KkKpNS931Pc2t3KA.Nj.nZ3u9gH6TwFor3/0iYhndld0.teNC/a',0,1,'2021-04-08 09:40:10.848361','2021-04-08 09:40:10.848368','rakesh.reddy@canopusgbs.com'),(2,'142e7776ecd74360a046824067864785','','','','','','$2b$12$tq5SOrvTObDPnQjQpx7FvO3M1cFSM56HYEefOtuwv0p.cNRSMvcEK',0,1,'2021-04-14 15:41:01.549410','2021-04-14 15:41:01.549417','');

--
-- Table structure for table `fsmetircs`
--

CREATE TABLE `fsmetircs` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `fsuniqueid` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `system_id` varchar(255) NOT NULL,
  `filesys` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `used` varchar(255) NOT NULL,
  `available` varchar(255) NOT NULL,
  `perc` varchar(255) DEFAULT NULL,
  `Mounted_On` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `fsuniqueid` (`fsuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fsmetircs`
--

INSERT INTO `fsmetircs` VALUES (1,'3c8d2fc2c9cb45fbb8552921a9c78c0c','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','devtmpfs','3.9G','0','3.9G','0%','/dev','2021-04-09 13:58:06.303995'),(2,'efe563bdbe2c404a943f533f6747bac9','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','tmpfs','29G','12K','29G','1%','/dev/shm','2021-04-09 13:58:06.303995'),(3,'e880a316576a4095b1238214fc977a39','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','tmpfs','3.9G','386M','3.6G','10%','/run','2021-04-09 13:58:06.303995'),(4,'ff90d5fd8fee4d3999c440980e824472','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','tmpfs','3.9G','0','3.9G','0%','/sys/fs/cgroup','2021-04-09 13:58:06.303995'),(5,'6c5a8b1ccc2549c38edd4dc4cb967be0','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','/dev/xvda2','600G','460G','141G','77%','/','2021-04-09 13:58:06.303995'),(6,'fcb43e53e3ed474dbf5b7952e37dec8d','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','/dev/xvda1','297M','90M','208M','31%','/boot','2021-04-09 13:58:06.303995'),(7,'4f1da47b2741429988480b10f3d84025','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','tmpfs','797M','48K','797M','1%','/run/user/470','2021-04-09 13:58:06.303995'),(8,'01b72abe3bb54d6db1f887cb1ee0daeb','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','devtmpfs','3.9G','0','3.9G','0%','/dev','2021-04-09 13:58:06.303995'),(9,'dedb08ab58e646f7815e13b8b9ace813','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','tmpfs','30G','0','30G','0%','/dev/shm','2021-04-09 13:58:06.303995'),(10,'9c64332d337d40d9a7c09b41d4de4b5b','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','tmpfs','3.9G','81M','3.9G','3%','/run','2021-04-09 13:58:06.303995'),(11,'069e4d8bebc747638d70622373b2e1ce','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','tmpfs','3.9G','0','3.9G','0%','/sys/fs/cgroup','2021-04-09 13:58:06.303995'),(12,'49061d714f0a44eea5e30354466ae987','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','/dev/xvda3','300G','226G','75G','76%','/','2021-04-09 13:58:06.303995'),(13,'1c97c278d319422ea359d6888c21d5ed','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','/dev/xvda2','20M','1.2M','19M','6%','/boot/efi','2021-04-09 13:58:06.303995'),(14,'e769d781f733450a88400888207b769c','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','tmpfs','795M','0','795M','0%','/run/user/1000','2021-04-09 13:58:06.303995');

--
-- Table structure for table `instancelist`
--

CREATE TABLE `instancelist` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `insuniqueid` varchar(255) NOT NULL,
  `system_id` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `sysname` varchar(255) NOT NULL,
  `instanceno` int NOT NULL,
  `http_port` int NOT NULL,
  `https_port` int NOT NULL,
  `start_priority` int NOT NULL,
  `instancewsdlurl` varchar(255) NOT NULL,
  `features` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` varchar(255) NOT NULL,
  `modified_at` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `insuniqueid` (`insuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `instancelist`
--

INSERT INTO `instancelist` VALUES (1,'fa04c5cc031a45b9808de4c14d29ec8d','f4396c89b0a9401ebc1a35f4bff9cae7','4fb3adfe982011eb898e4397c39d3dcd','integrtrdev',1,50113,50114,1,'http://integrtrdev.integrtr.com:50113/?wsdl','GATEWAY|MESSAGESERVER|ENQUE|WEBDISP','SAPControl-GREEN','2021-04-08 19:10:28.802029','2021-04-08 19:10:28.802064'),(2,'5596ef27ff2c4926969ef2e68fb7d548','f4396c89b0a9401ebc1a35f4bff9cae7','4fb3adfe982011eb898e4397c39d3dcd','integrtrdev',0,50013,50014,3,'http://integrtrdev.integrtr.com:50013/?wsdl','ABAP|GATEWAY|ICMAN|IGS','SAPControl-GREEN','2021-04-08 19:10:28.959668','2021-04-08 19:10:28.959704'),(3,'715051fdb55347ac883d8267b5f9d9ca','d19d4d9aefca4546a7e8f34e8f403061','4fb3adfe982011eb898e4397c39d3dcd','integrtrqas',0,50013,50014,3,'http://integrtrqas.integrtr.com:50013/?wsdl','ABAP|GATEWAY|ICMAN|IGS','SAPControl-GREEN','2021-04-08 19:10:29.674998','2021-04-08 19:10:29.675028'),(4,'d248d063fffe4ada8fc6a3a8fdbc06cd','d19d4d9aefca4546a7e8f34e8f403061','4fb3adfe982011eb898e4397c39d3dcd','integrtrqas',1,50113,50114,1,'http://integrtrqas.integrtr.com:50113/?wsdl','MESSAGESERVER|ENQUE','SAPControl-GREEN','2021-04-08 19:10:29.946943','2021-04-08 19:10:29.946979');

--
-- Table structure for table `memorymetrics`
--

CREATE TABLE `memorymetrics` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `memuniqueid` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `system_id` varchar(255) NOT NULL,
  `memtype` varchar(255) NOT NULL,
  `total` varchar(255) NOT NULL,
  `used` varchar(255) NOT NULL,
  `free` varchar(255) NOT NULL,
  `shared` varchar(255) NOT NULL,
  `cache` varchar(255) NOT NULL,
  `available` varchar(255) NOT NULL,
  `port` int DEFAULT NULL,
  `created_at` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `memuniqueid` (`memuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `memorymetrics`
--

INSERT INTO `memorymetrics` VALUES (1,'60ca1e6be0d64093beed39bd8cd59e76','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','Mem','7.8G','6.2G','159M','1.1G','1.4G','243M',50013,'2021-04-09 15:36:31.793058\n'),(2,'0c40bdcd7b674b01b325cc64f2457e34','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','Swap','29G','10G','159M','0','0','0',50013,'2021-04-09 15:45:26.962033\n'),(3,'a15fbe54b05448ed865c8db5c0bfd37b','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','Mem','7.8G','6.2G','158M','1.1G','1.4G','242M',50113,'2021-04-09 15:45:38.252317'),(4,'46a3637e3bcf429dba71b2e410bca496','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','Swap','29G','10G','158M','0','0','0',50113,'2021-04-09 15:45:48.078023'),(5,'27c8d7f86acf427b8b44d24d7cba6bf5','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','Mem','7.8Gi','3.0Gi','254Mi','4.3Gi','4.5Gi','212Mi',50013,'2021-04-09 15:45:55.053725'),(6,'9a6699bb6a7c4fa3a539b9649f5defc6','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','Swap','30Gi','7.6Gi','245Mi','0','0','0',50013,'2021-04-09 15:46:02.539863'),(7,'bf4ef726787e48249da015c51a83feae','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','Mem','7.8Gi','3.0Gi','245Mi','4.3Gi','4.5Gi','212Mi',50113,'2021-04-09 15:46:12.020505'),(8,'2dcadd99d5e04b269a23504ae971a5d6','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','Swap','30Gi','7.6Gi','245Mi','0','0','0',50113,'2021-04-09 15:46:19.293512');

--
-- Table structure for table `process_list`
--

CREATE TABLE `process_list` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `processuniqueid` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `system_id` varchar(255) NOT NULL,
  `pname` varchar(255) NOT NULL,
  `pdesc` varchar(255) NOT NULL,
  `dispstatus` varchar(255) NOT NULL,
  `stime` varchar(255) NOT NULL,
  `created_at` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `processuniqueid` (`processuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `process_list`
--

INSERT INTO `process_list` VALUES (1,'77a098887c2d4cdaace72b7bb31d2f90','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','disp+work','Dispatcher','SAPControl-GREEN','2021-02-02 19:40:56','2021-04-09 11:52:00.869238'),(2,'14b914050d504cbc84e05b7deec6f01e','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','igswd_mt','IGS Watchdog','SAPControl-GREEN','2021-02-02 19:40:56','2021-04-09 11:52:01.063274'),(3,'0750312afa9347e0b5696a60098ae435','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','gwrd','Gateway','SAPControl-GREEN','2021-02-02 19:40:57','2021-04-09 11:52:01.207757'),(4,'60d2a65bafa441e4b9337ad75cf86c4c','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','icman','ICM','SAPControl-GREEN','2021-02-02 19:40:57','2021-04-09 11:52:01.330018'),(5,'c5ff4c14453744b4964b657a666dd67b','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','disp+work','Dispatcher','SAPControl-GREEN','2021-03-31 22:07:48','2021-04-09 11:52:02.169550'),(6,'3f22e138ef3246e7a9fb36b94ba287a6','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','igswd_mt','IGS Watchdog','SAPControl-GREEN','2021-03-31 22:07:48','2021-04-09 11:52:02.329852'),(7,'65c911ef891b40f9bef75ca45d069c05','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','gwrd','Gateway','SAPControl-GREEN','2021-03-31 22:07:49','2021-04-09 11:52:02.441459'),(8,'60603ef51ba84bc6bea30d836ae569f4','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','icman','ICM','SAPControl-GREEN','2021-03-31 22:07:49','2021-04-09 11:52:02.642838');

--
-- Table structure for table `systems`
--

CREATE TABLE `systems` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `sysuniqueid` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `sysname` varchar(255) NOT NULL,
  `sid` varchar(255) NOT NULL,
  `ostype` varchar(255) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `portnum` int NOT NULL,
  `syspassword` varchar(255) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `sitetype` varchar(255) NOT NULL,
  `siteincharge` varchar(255) NOT NULL,
  `siteaddress` longtext NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` varchar(255) NOT NULL,
  `modified_at` varchar(255) NOT NULL,
  `sub_by` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `sysuniqueid` (`sysuniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `systems`
--

INSERT INTO `systems` VALUES (1,'f4396c89b0a9401ebc1a35f4bff9cae7','4fb3adfe982011eb898e4397c39d3dcd','integrtrdev','indadm','SUSE Linux','integrtrdev.integrtr.com',50013,'$2b$12$Dzh13RxdaI9UXJ1qKyNgcumo8C8dslHqE.s0vC9JRYaebJ2qXaT.a','DR','Cloud','YK Naidu','Bangalore',1,'2021-04-08 19:06:09.897698','2021-04-08 19:06:09.897720','rakesh.reddy@canopusgbs.com'),(2,'d19d4d9aefca4546a7e8f34e8f403061','4fb3adfe982011eb898e4397c39d3dcd','integrtrqas','inqadm','SUSE Linux','integrtrqas.integrtr.com',50013,'$2b$12$NAsjmfeONtXbJb/XK0x2QeZWI8X2P4nNJ8j89pGGvkkdSWhupb6XO','DR','Cloud','YK Naidu','Bangalore',1,'2021-04-08 19:07:14.506484','2021-04-08 19:07:14.506492','rakesh.reddy@canopusgbs.com'),(3,'p19d4d9aefca1234a7e8f34e8f403061','4fb3adfe982011eb898e4397c39d3dcd','SAP Oracle','gbsadm','Microsoft Windows Server','106.51.159.2',50013,'India_12345','DC','Offshore','YK Naidu','Bangalore',1,'2021-04-08 19:07:14.506484','2021-04-08 19:07:14.506492','rakesh.reddy@canopusgbs.com'),(4,'y47k4d9aefca4546a7e8f34e8f403061','4fb3adfe982011eb898e4397c39d3dcd','SAP Java','administrator','Red Hat','106.51.159.2',50013,'Canopus!123','DC','Offshore','YK Naidu','Bangalore',1,'2021-04-08 19:07:14.506484','2021-04-08 19:07:14.506492','rakesh.reddy@canopusgbs.com'),(5,'r9396c89b0a9041ebc1a35f4bff9cae7','4fb3adfe982011eb898e4397c39d3dcd','SAP Netweaver','abcadm','SUSE Linux','65.1.246.165',50013,'canopus@123','DR','Cloud','YK Naidu','Mumbai',1,'2021-04-08 19:07:14.506484','','rakesh.reddy@canopusgbs.com');

--
-- Table structure for table `systemwsdl`
--

CREATE TABLE `systemwsdl` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `sywsdluniqueid` varchar(255) NOT NULL,
  `customer_id` varchar(255) NOT NULL,
  `system_id` varchar(255) NOT NULL,
  `syswsdlurl` varchar(255) NOT NULL,
  `created_at` varchar(255) NOT NULL,
  `modified_at` varchar(255) NOT NULL,
  `sub_by` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `sywsdluniqueid` (`sywsdluniqueid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `systemwsdl`
--

INSERT INTO `systemwsdl` VALUES (1,'fcb18d0affa44e8abb7d79d4b662ca94','4fb3adfe982011eb898e4397c39d3dcd','f4396c89b0a9401ebc1a35f4bff9cae7','http://integrtrdev.integrtr.com:50013/?wsdl','2021-04-08 19:06:09.897698','2021-04-08 19:06:09.897720','rakesh.reddy@canopusgbs.com'),(2,'fed095565ac74df8891c3521829746d0','4fb3adfe982011eb898e4397c39d3dcd','d19d4d9aefca4546a7e8f34e8f403061','http://integrtrqas.integrtr.com:50013/?wsdl','2021-04-08 19:07:14.506484','2021-04-08 19:07:14.506492','rakesh.reddy@canopusgbs.com');


