--
-- 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`
--

CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type_id` int(11) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `username` varchar(45) DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `locked_date_time` datetime DEFAULT NULL,
  `failed_attempt` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `is_tfa_enabled` int(11) DEFAULT NULL,
  `tfa_code` varchar(45) DEFAULT NULL,
  `tfa_exp_time` double DEFAULT NULL,
  `tfa_default_type` varchar(45) DEFAULT NULL,
  `is_approved` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `is_verified` int(1) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `user_type_id_idx` (`user_type_id`),
  KEY `client_id_idx` (`client_id`),
  CONSTRAINT `client_id` FOREIGN KEY (`client_id`) REFERENCES `client` (`client_id`),
  CONSTRAINT `user_type_id` FOREIGN KEY (`user_type_id`) REFERENCES `user_type` (`user_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,2,'$2a$10$iwgOLdzaTiIe9wpjJCKrXuBOsx0A25FO8AhQCc3EFBKXIKAB2AEZK','malathy@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(2,2,'$2a$10$iwgOLdzaTiIe9wpjJCKrXuBOsx0A25FO8AhQCc3EFBKXIKAB2AEZK','test@gmail.com',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1,1,1),(4,1,'$2a$10$F6tEZH4Hehly2q3eMDKlyu.mPW3rNT5RKKW7vOtbxghm9cItxaUfq','anon@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(5,1,'$2a$10$Q3Vs3wju56rdWNWaw9NAfOAJbDYqZXrK0C46XZOoprbbRn4wBEqs.','anon@test2.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(6,3,'$2a$10$iwgOLdzaTiIe9wpjJCKrXuBOsx0A25FO8AhQCc3EFBKXIKAB2AEZK','styloo@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(7,1,'$2a$10$iztf06ybTVv8iI74NvjNru2424vzSC.GOITbFBXKrHd2VQ57Bw9U.','styloo3@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(8,1,'$2a$10$XEuZwF1CCpPoQWt6e85GqOQ.fv9nl6S0j1i/ssnL1fuSjHg3xjIoy','styloo3@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(9,1,'$2a$10$7W43LMaXORmh.NQ87eHzX.PJA.6YoI09xyzOrKwxVJnUgZ09UG3Li','styloo5@test.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(10,1,'$2a$10$GnueXBwWfMsPVGZzWfbVF.HLbDckqMwztH/kx/bPmNAwtJXPVpfnK','fgh@dfg2367.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(11,1,'$2a$10$KLAyqPLior.Iumwjc59jwOSTh1v5KJMUkfwJXwPrADE1dF.iPEGfG','test@888gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(12,1,'$2a$10$fSUlMjydmdEmYCGV3pMpWO.bxNnR3qrT/f.S.O6qIyXVnbegmoJ.C','test@8883gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(13,1,'$2a$10$rUzatp6k76Waid4dlV0LJu2/K1HXjR8r9c0CnX7E/XkyxPJBNP/Zy','ragu@gmail.com',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(14,1,'$2a$10$mmFJbhTaKCaR4dVDyzW3QeLe2Q8vWH.AdsOKO/BNuzaf8SBqLaV5u','shiya@gmail.com',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(15,1,'$2a$10$YiT3fEH6m4nnHq1k1dSOouQ3DF1pDlko3NpfBxiksty9MHIZAUjBS','satha@gmail.com',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(16,1,'$2a$10$udG/r4ReE9fuuxLgzJNKhu/b4dJ3jBI7VErlkByUK7.zA1pBlTk.m','sathu@gmail.com',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(17,1,'$2a$10$5iAgw1axnoE1xPQKJOi3R.ms6ASaaxcp5ZtoWPJO.IJ5e9wUk.m5u','dssads@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(18,1,'$2a$10$Qd8p.HjPmbGvClMqAwX/ZOWLO.4.PghBVoO2p8ioE2RxyakcMj3f6','dssad99@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(19,1,'$2a$10$UZIxAhmnQ4oSzLfNJALfvOn8dP0SRCvOaMgrxGOd2bfpqw1Uc/dzq','sdsd@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(20,1,'$2a$10$lXtNzvQ12em4sa0kTZtaqumk1y6hN9ja0a4PBRgq7HaHSoBA3OZ2K','sdsddfdfd@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(21,1,'$2a$10$KysoOYKcXJVZQY0VV2sPCep8G1VguQA9lNJraPiw.AXY.YN2QJ5HO','erwerwrew@gamil.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(22,1,'$2a$10$/aeSzBs6B1p7zO9TNlrh3OzKnfG7xmME/kW1b6011abxO9A/ubMf.','mitebif267@5k2u.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(23,1,'$2a$10$vbo9uzHi9aQ2X7e3tafbp..8bXDoXXg6GHQLVW5/q5Qn5n.yHF2P.','jorohif933@anlubi.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(24,1,'$2a$10$1t0DlQC9paKBBl3W69hECO4ldp15GeJEFKM5rXgqBmcMPaekSsktW','bekaw80157@5k2u.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(25,1,'$2a$10$wAHQaDAqrR35dQl1QWorfu4C2SpA7oDL5KlgmHLEULAnbvZTLW6GS','mapafic936@altpano.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(26,1,'$2a$10$QZZB8b677I3/64fO9JYMael0TNZOOjkM6iQc/CpiWGhUPHbeKFXge','jejaf41539@5k2u.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(27,1,'$2a$10$VAibb0AQ9tSR2acvBu/NwOsjq7AOb931816VLZkLVgUc5XRtLVF4K','lejafa4136@anlubi.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(28,1,'$2a$10$Zyts1FXsungUrx/bNDo.PuyAUDCX4xSE7oucqXzsRqHWyprLEOKNG','gijedo6441@anlubi.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(29,1,'$2a$10$TgF3pm/zIipczbkQH9GEQeDLrD8zpfs8YDT3XVXlL17lOlaN.q4Lu','nepifit852@5k2u.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(30,1,'$2a$10$9O8xFBLS0s2gGqCqO2JL9.6djjkhK.G58hLNBwEg7DLdJ6n4my9Ga','yepota8286@chimpad.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(31,1,'$2a$10$PrDTllLfaL1hkyR.0aFvLu1ujDjtr33yb6hdXfLI8tgoFEGFgWZq2','litafa8719@agrolivana.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(32,1,'$2a$10$qhBmcQA6ITy0/fa1ak0g9.rO.dfYPIo7xuwFQhgZfns4ChCRjD2aC','yopoj11646@anlubi.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(33,1,'$2a$10$NOTKaa31.rb36LB/NxgUzeZuLDSOxto6D9dbNaPrJKnJTMeRzQpDu','lacovo5660@altpano.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(34,1,'$2a$10$PI0V3FcfenHa9Elfp0aY2einP/SQBC4F8qQQCTmeEP42kIc2NvVvO','romertw@codelantic.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(35,1,'$2a$10$BA8b9zbq8d4zG.IOAshsQOAGqRKnHOWqDZtJjyCwWx/LtyKU.qqdC','ksdjfks@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(36,1,'$2a$10$pKAX84x2mvg277hE4R0sQui.oCUurMpsxpydoiPjOEMYDqNC2VRBW','bobaba5608@altpano.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(37,1,'$2a$10$Vrjjhwii6z20/pDTZycYnu9nCJ5ZlMPiCZoCzEoOgZN6gCTVtSypi','xorohok732@5k2u.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(38,1,'$2a$10$gm.YyvMEXd4ATf14owNLrO0L2ADDrcuS0oTh0cW.rw4rfAqCRdgCe','ruwu@mailinator.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(39,1,'$2a$10$2PK7RZxd5I0W/KsqTZ1OAeMh1Vr.9FVJJs/GKBIqjq9oOygvVKOsK','xakiw26408@anlubi.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(40,1,'$2a$10$hiweSVUvjcVRoYTILbxmSuN/xAHi8lboqYotpa0TNxz21pQtczqTu','xafafe9468@logodez.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(41,1,'$2a$10$o7eklywRStHi.MX060Vv8.b/1SqG4IyCuD6siKv1eMeu1SyqplVyi','nowile3657@anlubi.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(42,1,'$2a$10$xJjdOsDncPJpgq63n1EIZ.1I17qJPDGwxWlTFZ8iaf5JoAojqyzOS','meweta7025@altpano.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1),(43,1,'$2a$10$iCgBxoBG/RZsz7q8Gl7BjeggNq2Irdidbxylt3qJsZm6A1FGxBmi2','poyetet714@altpano.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1);

--
-- 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'
--


