--
-- Host: localhost    Database: styloo_identity
-- ------------------------------------------------------


--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_name` varchar(150) DEFAULT NULL,
  `client_code` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `client`
--

INSERT INTO `client` VALUES (1,'Monex','MN');

--
-- Table structure for table `user_login_details`
--

CREATE TABLE `user_login_details` (
  `user_login_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(250) DEFAULT NULL,
  `user_ip` varchar(100) DEFAULT NULL,
  `login_date` date DEFAULT NULL,
  `login_time` time DEFAULT NULL,
  `is_success` int(11) DEFAULT NULL,
  `invalid_login_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_login_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_login_details`
--

INSERT INTO `user_login_details` VALUES (4,'styloo@gmail.com','10.20.100.4','2022-07-26','10:15:25',0,4),(5,'malathy@gmail.com','10.20.100.4','2022-08-02','06:00:57',0,1),(6,'test@gmail.com','10.20.100.4','2022-08-01','06:33:35',1,0),(7,'anon@test.com','0:0:0:0:0:0:0:1','2021-12-20','12:10:40',0,0),(8,'fgh@dfg2367.com','0:0:0:0:0:0:0:1','2022-05-02','07:28:32',1,0),(9,'test@888gmail.com','0:0:0:0:0:0:0:1','2022-05-02','07:29:25',1,0),(10,'kogul9@gmail.com','10.20.100.4','2022-07-26','08:28:36',0,23),(11,'styloo@test.com','10.20.100.4','2022-08-02','06:24:30',1,0),(12,'ann@gmail.com','10.20.100.4','2022-07-29','06:17:17',0,2),(13,'romert@codelantic.com','10.20.100.4','2022-08-01','11:30:39',0,6),(14,'mitebif267@5k2u.com','10.20.100.4','2022-07-27','10:35:53',1,0),(15,'jorohif933@anlubi.com','10.20.100.4','2022-07-27','10:39:16',1,0),(16,'gijedo6441@anlubi.com','10.20.100.4','2022-07-28','08:55:37',1,0),(17,'tjdfgjijijh@gmail.com','10.20.100.4','2022-07-28','09:00:52',0,2),(18,'janu12@gmail.com','10.20.100.4','2022-07-28','09:01:34',0,3),(19,'nepifit852@5k2u.com','10.20.100.4','2022-07-28','10:12:13',1,0),(20,'yepota8286@chimpad.com','10.20.100.4','2022-07-28','15:10:14',1,0),(21,'yopoj11646@anlubi.com','10.20.100.4','2022-07-29','04:08:06',1,0),(22,'lacovo5660@altpano.com','10.20.100.4','2022-07-29','10:34:03',1,0),(23,'ann12345@gmail.com','10.20.100.4','2022-07-29','06:17:28',0,2),(24,'romertw@codelantic.com','10.20.100.4','2022-08-01','11:30:53',1,0),(25,'romertw@gmail.com','10.20.100.4','2022-07-29','07:22:00',0,1),(26,'xorohok732@5k2u.com','10.20.100.4','2022-08-01','05:36:16',1,0),(27,'nowile3657@anlubi.com','10.20.100.4','2022-08-01','09:13:04',1,0),(28,'meweta7025@altpano.com','10.20.100.4','2022-08-01','11:41:44',1,0),(29,'poyetet714@altpano.com','10.20.100.4','2022-08-02','06:02:08',1,0);

--
-- Table structure for table `user_login_details_h`
--

CREATE TABLE `user_login_details_h` (
  `user_login_details_h_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(250) DEFAULT NULL,
  `user_ip` varchar(100) DEFAULT NULL,
  `login_date` date DEFAULT NULL,
  `login_time` time DEFAULT NULL,
  `is_success` int(11) DEFAULT NULL,
  `user_login_details_id` int(11) NOT NULL,
  PRIMARY KEY (`user_login_details_h_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_login_details_h`
--


--
-- Table structure for table `user_type`
--

CREATE TABLE `user_type` (
  `user_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type_desc` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`user_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_type`
--

INSERT INTO `user_type` VALUES (1,'Customer'),(2,'Platform Admin'),(3,'Individual Admin');

--
-- Dumping events for database 'styloo_identity'
--

--
-- Dumping routines for database 'styloo_identity'
--


