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

START TRANSACTION;



--
-- Database: `ntrust_portal`
--

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

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

CREATE TABLE `users` (
  `id` bigint(110) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mid_name` varchar(11) NOT NULL,
  `last_name` varchar(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `profile_image` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `gender` varchar(11) NOT NULL COMMENT '1= male, 2= female\r\n',
  `address` text NOT NULL,
  `street_num` varchar(11) NOT NULL,
  `unit_num` varchar(11) NOT NULL,
  `type` tinyint(2) NOT NULL COMMENT '1= Admin, 2= PA, 3= Doctor, 4= Lawofficer',
  `npi_number` varchar(255) NOT NULL,
  `fax_number` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `office_ful_name` varchar(255) NOT NULL,
  `office_contact_number` varchar(255) NOT NULL,
  `approval_status` tinyint(2) NOT NULL COMMENT '4= waiting status,1= Approve, 0= pending, 2=reject, 3=suspend, 5 = delete\r\n ',
  `reason_for_suspension` int(2) NOT NULL,
  `confirmation_code` text NOT NULL,
  `is_active` tinyint(2) NOT NULL,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `users` (`id`, `name`, `mid_name`, `last_name`, `email`, `profile_image`, `username`, `password`, `gender`, `address`, `street_num`, `unit_num`, `type`, `npi_number`, `fax_number`, `phone_number`, `office_ful_name`, `office_contact_number`, `approval_status`, `reason_for_suspension`, `confirmation_code`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Admin', '', '', 'admin@email.com', '', 'admin', 'ZX90gJRv', '1', 'Lahore', '', '', 1, '123456', '123456', '03024688336', 'Umer', '03024688336', 0, 0, '01os', 1, 1646822706, 0),
(2, 'Umer Rehman', '', '', 'umer.rehman996@gmail.com', '', 'umer', 'ZX90gJRv', '1', 'Lahore', '', '', 2, '123456', '123456', '03024688336', 'Umerr', '03024688336', 5, 0, '01os', 1, 1646822706, 1655708884),
(4, 'Doctor 1', '', '', 'abc@gmail.com', '', 'zack', 'ZX90gJRv', '1', 'Lahore', '', '', 3, '123456', '123456', '03024688336', 'Umer', '03024688336', 3, 0, 'c9Js', 1, 1647323935, 1655714720),
(5, 'zack snyder', '', '', 'lo@gmail.com', '', 'zack', 'ZX90gJRv', '1', 'Lahore', '', '', 4, '123456', '123456', '03024688336', 'Umer', '03024688336', 1, 0, 'c9Js', 1, 1647323935, 1647330851),
(6, 'Pharmacist', '', '', 'pa@gmail.com', '', 'zack', 'ZX90gJRv', '1', 'Lahore', '', '', 2, '123456', '123456', '03024688336', 'Umer', '03024688336', 1, 0, 'c9Js', 1, 1647323935, 1647330851),
(7, 'Doctor 2', '', '', 'dr@gmail.com', '', 'zack', 'ZX90gJRv', '1', 'Lahore', '', '', 3, '123456', '123456', '03024688336', 'Umer', '03024688336', 1, 0, 'c9Js', 1, 1647323935, 1647330851),
(8, 'Doctor 3', '', '', 'dr3@gmfail.com', '', 'zack', 'ZX90gJRv', '1', 'Lahore', '', '', 3, '123456', '123456', '03024688336', 'Umer', '03024688336', 1, 0, 'c9Js', 1, 1647323935, 1655708292),
(50, 'John', 'aka', 'doe', 'john@d.com', '', '', 'ZX90gJRv', 'm', 'ghi', 'abc', 'def', 3, '123', '', '123456', 'Lahore', '', 1, 0, '', 1, 0, 1655805742),
(51, 'John', 'snow', 'Doe', 'john@gmail.com', '', '', 'ZX90gJRv', 'm', 'NY 5400', 'GVN 3 ', '48', 3, '', '', '923024688336', 'Ntrust', '', 1, 0, '', 1, 1655813260, 0),
(52, 'John', 'snow', 'Doe', 'a@g.com1', '', '', 'ZX90gJRv', 'm', 'NY 5400', 'GVN 3 ', '48', 3, '', '', '923024688336', 'Ntrust', '', 1, 0, '', 1, 1655813260, 0),
(53, 'John', 'snow', 'Doe', 'a@g.com2', '', '', 'ZX90gJRv', 'm', 'NY 5400', 'GVN 3 ', '48', 3, '', '', '923024688336', 'Ntrust', '', 1, 0, '', 1, 1655813368, 0);

--
-- 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` bigint(110) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
COMMIT;

