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

START TRANSACTION;



--
-- Database: `admin_endurakit`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `first_name` varchar(150) DEFAULT NULL,
  `last_name` varchar(150) DEFAULT NULL,
  `facility_name` varchar(255) DEFAULT NULL,
  `user_type` enum('user','admin') DEFAULT 'user',
  `email` varchar(150) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL,
  `status` enum('new','active','inactive') DEFAULT 'new',
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `first_name`, `last_name`, `facility_name`, `user_type`, `email`, `password`, `phone_number`, `status`, `create_at`) VALUES
(1, 'Jaypal Singh', 'Jaypal', 'Singh', 'Jaypal Singh', 'admin', 'admin@gmail.com', '21232f297a57a5a743894a0e4a801fc3', '9058091862', 'active', '2021-10-11 07:58:17'),
(5, 'tim patrick', 'tim', 'patrick', 'Zenith Ortho', 'user', 'jollytmp@gmail.com', '2c0349c34c7677aab0260b3ad7e61878', '9493039143', 'new', '2021-11-04 10:41:22'),
(7, 'f l', 'f', 'l', 'fn@gmail.com', 'user', 'fn@gmail.com', '3c0175286226bbb69cc64319055ef8af', '34567890', 'new', '2021-11-08 17:33:06'),
(8, 'f f', 'f', 'f', 'f', 'user', 'fn@gmail.com', '3c0175286226bbb69cc64319055ef8af', '34234234', 'new', '2021-11-08 17:36:22'),
(9, 'Suri Shergill', 'Suri', 'Shergill', 'Uveous', 'user', 'suri@uveoustech.com', 'd07656af90eed44f20c5d4a27e376d00', '9026042939', 'active', '2021-11-08 19:40:08'),
(10, 'John Garbino', 'John', 'Garbino', 'DP Creek', 'user', 'jg@a-zmedicalbillingandconsulting.com', '6b99fc04045eae98af76b6eb6a259cef', '949-599-4373', 'active', '2021-11-09 01:28:25'),
(18, 'STEVEN AUNGST', 'STEVEN', 'AUNGST', 'TMP HEALTH ', 'user', 'saungst@tmphealthsystems.com', 'f2230e4f840f33f29b2f3d3f4764f6a3', '3107796841', 'active', '2021-11-11 00:47:38'),
(22, 'Sean White', 'Sean', 'White', 'Sean\'s Pharmacy ', 'user', 'Sean.whitelead@gmail.com', 'a4a9e721849e8c8527aa1cfcfc8d0eb7', '07800250001', 'active', '2021-11-11 23:07:38');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
COMMIT;

