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




--
-- Database: `bid2rent`
--

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

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

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `firstname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'First Name',
  `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Last Name',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Email',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` int(11) NOT NULL,
  `mobile` bigint(20) NOT NULL,
  `is_mobile_verified` int(11) NOT NULL,
  `user_type_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `otp` int(11) NOT NULL,
  `document` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Uploaded Document Name',
  `dob` date DEFAULT NULL,
  `profile_pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_bio` text COLLATE utf8mb4_unicode_ci,
  `facebook_profile` text COLLATE utf8mb4_unicode_ci,
  `linkedin_profile` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `created_at`, `updated_at`, `firstname`, `lastname`, `email`, `password`, `country_code`, `mobile`, `is_mobile_verified`, `user_type_id`, `status`, `otp`, `document`, `dob`, `profile_pic`, `short_bio`, `facebook_profile`, `linkedin_profile`, `address`, `city`) VALUES
(1, '2017-11-27 04:13:47', '2017-12-07 09:07:30', 'John', 'Smith', 'john@bid2rent.ae', '$2y$10$VRGRXeYnHkrATJGDZ3d1YOZjUWaGY.34XXEjv.YakJgiFpfo1jSbW', 971, 501234567, 1, 2, 1, 447991, '', '0000-00-00', '', '', '', '', NULL, NULL),
(3, '2017-11-27 04:16:35', '2017-11-27 04:16:37', 'Neo', 'Matrix', 'neo@bid2rent.ae', '$2y$10$CXmGqPB6KhXytAP.ByPVbOtjRxxWfERWvxtW44UF1ZKA.sl8HNy12', 971, 501234567, 1, 3, 1, 431677, 'media/tenant/6/501234567_1511764088.pdf', '0000-00-00', '', '', '', '', NULL, NULL),
(7, '2017-11-27 04:59:22', '2017-12-08 03:06:04', 'Jessica', 'Babajan', 'jes@bid2rent.ae', '$2y$10$fPn8rLCK9o0HudB5MZpPxe8oRHNyXRmJqrHVB7/fqrof0cbExBShS', 971, 501234567, 1, 2, 1, 676947, 'media/tenant/7/501234567_1511764162.pdf', '0000-00-00', '', '', '', '', NULL, NULL),
(8, '2017-11-27 08:03:56', '2017-11-27 08:03:57', 'Vicky', 'Romson', 'vicky@bid2rent.ae', '$2y$10$hQNVtjU2URI8V6DyMlx8quDpwfcdSNfiBKK999jQ3brpHwzsXnTrW', 971, 501234567, 1, 3, 1, 914004, 'media/tenant/8/501234567_1511775236.pdf', '0000-00-00', '', '', '', '', NULL, NULL),
(9, '2017-11-27 08:27:04', '2017-11-27 08:27:06', 'Prashant', 'Saini', 'prashant@bid2rent.ae', '$2y$10$S22QqdvjJBrRx/cwP8/d5.Lp14TAgOe7M6De049WGszPryJLTnqUC', 971, 523654123, 1, 3, 1, 763024, 'media/tenant/9/523654123_1511776624.pdf', '0000-00-00', '', '', '', '', NULL, NULL),
(10, '2017-11-27 09:32:20', '2017-11-27 09:32:21', 'Alex', 'Smith', 'alex@bid2rent.ae', '$2y$10$KyiY2dg7bJ6tCyXl6Jx.aO6o9OJSD6nBW89aEPyoyO5wZfviN2ujm', 971, 563214567, 1, 3, 1, 194674, 'media/tenant/10/563214567_1511780540.jpg', '0000-00-00', '', '', '', '', NULL, NULL),
(14, '2017-11-28 03:58:14', '2017-11-28 03:58:14', 'sdf', 'rt', 'trt@we.ik', '$2y$10$47H/FAjy9JOQygf47Uecy.po6E0XeSBZAvi8U2fSlXbhyA64kl1qG', 971, 501234567, 0, 2, 1, 780328, '', '0000-00-00', '', '', '', '', NULL, NULL),
(15, '2017-11-28 04:00:55', '2017-11-28 04:00:57', 'er', 're', 'q@q.uk', '$2y$10$HNJlfEPuAOsnmWF.kRpIfOJ7goEvxvtVlzrcq3rx6OzMoyGqV2lmq', 971, 501234567, 1, 2, 1, 823806, '', '0000-00-00', '', '', '', '', NULL, NULL),
(16, '2017-11-28 07:31:49', '2017-11-28 07:31:54', 'a', 'a', 'a@a.no', '$2y$10$0OZ/mMGGhFw3rwtiNe8GVeSfX5oX4EHaH2wg9mL/cDFO896LXeNf.', 971, 501234567, 1, 2, 1, 886703, '', '0000-00-00', '', '', '', '', NULL, NULL),
(17, '2017-11-28 07:57:41', '2017-11-28 07:57:42', 'hjh', 'dsd', 's@s.com', '$2y$10$8cl1UY/.DV/YtF9vZ9iuCOTDxiNVYn1xIfKi99r2mCxBvK7mTa5Xu', 971, 501234567, 1, 3, 1, 465185, 'media/tenant/17/501234567_1511861261.pdf', '0000-00-00', '', '', '', '', NULL, NULL),
(18, '2017-11-28 08:08:12', '2017-11-28 08:08:18', 'as', 'sas', 'r@r.no', '$2y$10$pH3ptjVkQpXaPlYJmJcbZu1dgBHHQt.O1WkIAo60KPnI1huj9ytm.', 971, 501234567, 1, 2, 1, 869290, '', '0000-00-00', '', '', '', '', NULL, NULL),
(19, '2017-11-28 09:48:54', '2017-11-28 09:51:36', 'Edison', 'Ronz', 'edison@bid2rent.ae', '$2y$10$XyGFUczUVWwh6NPB8dBCcuY1.7qsgXfB/DP.WgG3bp7RHVs3CeDzK', 971, 563214568, 1, 2, 1, 242163, '', '0000-00-00', '', '', '', '', NULL, NULL),
(21, '2017-12-01 02:50:08', '2017-12-01 02:50:08', 'fh', 'fgh', 'fdgd@dgd.ok', '$2y$10$QLLITogch6OC0HnrP/AwzukZHP8fqWA3rVhEcxzHjYQgoS14jyW4O', 971, 509164082, 0, 2, 1, 124087, '', '0000-00-00', '', '', '', '', NULL, NULL),
(26, '2017-12-01 02:59:41', '2017-12-01 02:59:41', 'fd', 'dsf', 'sfd@dfgdfg.ok', '$2y$10$9fuG60cSCUpv/bmox1o3Iu438sTlvhjIXQhyTeAdo0pw4QFO8g3W6', 971, 509164082, 0, 2, 1, 953610, '', '0000-00-00', '', '', '', '', NULL, NULL),
(27, '2017-12-01 04:18:39', '2017-12-01 04:18:45', 'James', 'Watson', 'james@bid2rent.ae', '$2y$10$TcKHqIH70gMYz7Epk2Rm9.BZOLfGdSFWwT/llo4nWbwUUAd78LdrG', 971, 501234567, 1, 3, 1, 428875, 'media/tenant/27/501234567_1512107319.pdf', '0000-00-00', '', '', '', '', NULL, NULL),
(28, '2017-12-01 04:20:59', '2017-12-01 04:21:01', 'Ron', 'Wisley', 'ron@bid2rent.ae', '$2y$10$p4Ke8bYHJ1v3IUIIBFWR1.wprB.ixws8jHJb2l72rJZdqxVF0FEhm', 971, 501234567, 1, 2, 1, 985360, '', '0000-00-00', '', '', '', '', NULL, NULL),
(30, '2017-12-07 03:41:12', '2017-12-07 03:41:12', 'Daisy', 'Nagpal', 'daisy@bid2rent.ae', '$2y$10$.mkW12Heaqdyr1X0AZmkjuSRYgyvxzzG2QfU1QObCHk1/mxfqKR8e', 971, 565920474, 0, 2, 1, 148669, '', '0000-00-00', '', '', '', '', NULL, NULL),
(46, '2017-12-07 04:03:55', '2017-12-07 04:06:38', 'wt', 'wte', 'd@d.ok', '$2y$10$79zL.8S.XfroeVlMtKouWOJc.KE4ZN0hduFLmTQSO1br3Ee0RX556', 971, 565920474, 0, 2, 1, 865417, '', '0000-00-00', '', '', '', '', NULL, NULL),
(51, '2017-12-07 04:21:04', '2017-12-07 04:21:04', 'w4et', 'te', 'er@g.ok', '$2y$10$a62o0cSsxXFBnP96ZeXShuVy7PJlJ8zlVS8y0NZwUiVyzPeCExety', 971, 501234567, 0, 2, 1, 832980, '', '0000-00-00', '', '', '', '', NULL, NULL),
(52, '2017-12-07 04:21:41', '2017-12-07 04:30:35', 'er', 'ewr', 'arswer@weraf.ok', '$2y$10$QpR2H/ykXhtrrzSVZ6TcZO5ZaQaPKp7d6EObrsfVZIB.nxgX3nWo2', 971, 501234567, 1, 2, 1, 585485, '', '0000-00-00', '', '', '', '', NULL, NULL),
(53, '2017-12-07 05:49:42', '2017-12-07 05:57:27', 'Nikita', 'Gupta', 'earth.nikita149@gmail.com', '$2y$10$kYqxw5n2hyn4mlMdpNvflOJGPsP6aWjqdPQmMnYQRMcBgW4l7hlgq', 971, 501234567, 1, 2, 1, 318957, '', '0000-00-00', '', '', '', '', NULL, NULL),
(54, '2017-12-07 09:27:09', '2017-12-07 09:32:27', 'ffdg', 'fdg', 'dsf@f.ok', '$2y$10$8sfK3bQaw5HFB19dIi6FqO2AMWRLHTpBL8XfzXR1pWvnLIJsP9DFe', 971, 501234567, 1, 2, 1, 816473, '', '0000-00-00', '', '', '', '', NULL, NULL),
(55, '2017-12-07 10:04:13', '2017-12-07 10:04:13', 'dsf', 'dsf', 'dfsdf@sdfsdf.ok', '$2y$10$mGw3Hh19PJVu3s148XIImOfZFZ.i0F1fPe8yk9O/SOfk3PJmY87pu', 971, 501234567, 0, 2, 1, 615780, '', '0000-00-00', '', '', '', '', NULL, NULL),
(56, '2017-12-07 10:09:11', '2017-12-07 10:09:48', 'fgfdg', 'fdgfdg', 'sdfd@dfsf.ik', '$2y$10$ziJ1TpQOk.YUYgnH3BSshOsy4Mg9wRNCRSZQ0C10dHo6ebkdqRnVK', 971, 501234567, 0, 2, 1, 727264, '', '0000-00-00', '', '', '', '', NULL, NULL);

--
-- 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(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
