-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `network_theraphy_new`
--

-- --------------------------------------------------------

--
-- Table structure for table `users_secure`
--

CREATE TABLE IF NOT EXISTS `users_secure` (
  `id` bigint(20) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `last_update_password` datetime DEFAULT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `password_history1` varchar(255) DEFAULT NULL,
  `password_history2` varchar(255) DEFAULT NULL,
  `password_history3` varchar(255) DEFAULT NULL,
  `password_history4` varchar(255) DEFAULT NULL,
  `last_challenge_response` datetime DEFAULT NULL,
  `login_work_area` text,
  `login_fail_counter` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `USERNAME_ID` (`id`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users_secure`
--

INSERT INTO `users_secure` (`id`, `username`, `password`, `last_update_password`, `last_update`, `password_history1`, `password_history2`, `password_history3`, `password_history4`, `last_challenge_response`, `login_work_area`, `login_fail_counter`) VALUES
(1, 'admin', '$2y$10$N1V30LaGAM23ez9.o0tydOTY5pEd355LVxYgvuuK/mj.Nn2cUjOQe', '2022-10-18 13:15:46', '2023-06-22 13:11:42', '$2y$10$y0CoXERa2YpLAj2jRMC8buOo5AsphIqCG6CJBDgGcWW6yH6Gs3adS', NULL, NULL, NULL, NULL, NULL, 2),
(4, 'sandy', '$2y$10$TQQQEXAp0tVG3tNIWOPNjusPOM3tcOqP0YSukwj6zxs2Vd2VU.Poa', '2022-04-21 14:18:09', '2022-04-22 21:41:18', NULL, NULL, NULL, NULL, NULL, NULL, 0),
(7, 'rina', '$2y$10$i81nMqR2bpA7zoBjcZzyDeUeKxNXtLKO2eTmSjhUxUOC.qDwv2JxW', '2022-05-19 11:49:18', '2022-05-19 06:19:18', NULL, NULL, NULL, NULL, NULL, NULL, 0),
(8, 'Gonzalez', '$2y$10$1K1HtE8rdLazt1gLZeSuzea3aS.dgLNTizMbxBzBunRjEcyDPqOqa', '2022-05-19 11:50:06', '2022-05-19 06:20:06', NULL, NULL, NULL, NULL, NULL, NULL, 0),
(9, 'Jose', '$2y$10$vcHqVwtwWfWljrrjCdbAMu8tyQ2QEb1f.pv.BzuibqmlEoLfV//CS', '2022-05-19 11:50:41', '2022-05-19 06:20:41', NULL, NULL, NULL, NULL, NULL, NULL, 0),
(10, 'Elizabeth', '$2y$10$.3ZsbQ5.PcwRSwDtmKwEJOkuImlxKh4TdnZFunNsht5.TGgIpp6me', '2022-05-19 11:51:06', '2022-05-19 06:21:06', NULL, NULL, NULL, NULL, NULL, NULL, 0),
(11, 'test', '$2y$10$IeGuQI2f2MROkmI/FZnrauDTkH1cdrj5Tyr7ULC5yO93LOzGoyzhe', '2022-08-23 07:43:29', '2022-08-23 11:43:29', NULL, NULL, NULL, NULL, NULL, NULL, 0);
COMMIT;

