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

START TRANSACTION;



--
-- 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,
  `remember_token` text COLLATE utf8mb4_unicode_ci
) 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`, `remember_token`) VALUES
(1, '2017-12-13 08:51:35', '2018-01-04 04:44:35', 'John', 'Milton', 'john@bid2rent.ae', '$2y$10$kNVnazKMxY.RGl9JUprPVO0lqFBjMBzHwzuSOAdG5CfS5c7ho/nzu', 971, 501234567, 1, 2, 1, 188439, '', '2018-01-17', 'media/landlord/1/501234567_1513249697.jpg', 'fgvdfxgdfxgvdfxvbgdxfbfxg576y457y45e7y', 'fgdfg', 'dfgdfg', 'addressdhb', 'citydhdfhg', 'CexEYYi0kwzue9Ih528MrvDthpfLz2S1MogQVP1hdhtRjQCCfL2UDNjmxRuE'),
(2, '2017-12-13 08:58:14', '2018-01-01 04:08:03', 'Neo', 'trinity', 'neo@bid2rent.ae', '$2y$10$lRAzMbw3va2EFZa41nVjrejrvKW5MJTpuyP2MSMYKVjlvyNzLD4BS', 971, 501234567, 1, 3, 1, 316677, 'media/tenant/2/501234567_1514265307.pdf', NULL, 'media/tenant/2/501234567_21514265307.jpg', 'dfgfdgfdgdfgdfgdfg', NULL, NULL, NULL, NULL, NULL),
(3, '2017-12-13 08:59:10', '2017-12-18 10:18:46', 'Ema', 'Watson', 'ema@bid2rent.ae', '$2y$10$2nFxr66zARniG1okIj6qIeHQmD9DbZkTkkdPK6qKo0QZ/zO/3G9Ma', 971, 501234567, 1, 3, 1, 463427, 'media/tenant/3/501234567_1513160950.pdf', NULL, NULL, NULL, NULL, NULL, 'fchb', 'ghxfcg', NULL),
(4, NULL, '2018-01-04 08:08:31', 'Admin', '', 'admin@bid2rent.ae', '$2y$10$lRAzMbw3va2EFZa41nVjrejrvKW5MJTpuyP2MSMYKVjlvyNzLD4BS', 0, 0, 1, 1, 1, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZEdlAP3mfATHlSbgT0BzqOIpB6EeaB4i8IA6MqaR4H3cYmLoQMs12HUKd8QM'),
(5, '2017-12-27 04:24:13', '2017-12-27 04:24:13', 'xcg', 'dfg', 'a@a.in', '$2y$10$7brbaaRHj5ncYCH4oIaJlOwu8EoKyFIX5zu9og9tyJutUxdLlTqs6', 971, 501234567, 0, 2, 1, 311349, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '2017-12-27 04:25:06', '2017-12-27 04:25:06', 'fsd', 'sfd', 's@s.in', '$2y$10$6kr0rxmLn2CNlUmqN7220.akRpM8.4jifiQBy2IISMUqD5.ivZEUC', 971, 501234567, 0, 2, 1, 202722, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '2017-12-27 09:50:14', '2017-12-27 09:50:14', 'dfxg', 'dfg', 'dfgbvdfxg@asdsaf.on', '$2y$10$TOUqcGKO7oK.ph4Qw00Qb.GzG2B8gZGB.CR6mXc8r3BvNdC/KolDe', 971, 501234567, 0, 2, 1, 928781, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '2017-12-27 09:53:37', '2017-12-27 09:53:37', 'Test', 'rutyu', 'tyutyutyu@dsrgdfg.on', '$2y$10$./twzqXiyEydS1e0ZuKsXewB1z/P0SgiYZCfQZTCRSVCSUqegnqUS', 971, 501234567, 0, 2, 1, 605535, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, NULL, NULL, 'yhjng', '', '', '', 0, 0, 0, 2, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, NULL, NULL, 'tyerherhedyg', '', '', '', 0, 0, 0, 2, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, '2018-01-01 04:43:28', '2018-01-01 04:43:28', 'h', 'gh', 'gh@df.ok', 'yVtzKmfgrV', 971, 501234567, 0, 3, 1, 227001, '', NULL, NULL, NULL, NULL, NULL, 'dfg', 'gd', NULL),
(14, '2018-01-01 04:46:02', '2018-01-01 04:46:02', 'dg', 'gdfg', 'dfg@sf.ol', 'jhUDt4GnHs', 971, 501234567, 0, 3, 1, 851876, '', NULL, NULL, NULL, NULL, NULL, 'fdg', 'dfg', NULL),
(15, '2018-01-01 04:47:59', '2018-01-01 04:47:59', 'Nik', 'Gu', 'nikita.ushyaku@gmail.com', '4ryyzGVzdT', 971, 501234567, 0, 2, 1, 713092, '', NULL, NULL, NULL, NULL, NULL, 'sdf', 'fsd', NULL),
(17, '2018-01-02 05:20:59', '2018-01-02 05:20:59', 'sdf', 'df', 'nikita.gupta@ushyaku.com', '$2y$10$YcPxVdeQ75l./ZC9iPaddO1Z9tC2m35zzQme4ZIWcIG6AlRtAdSt6', 971, 501234567, 0, 2, 1, 641323, '', NULL, NULL, NULL, NULL, NULL, 'asd', 'hgkj', NULL),
(18, '2018-01-02 08:24:13', '2018-01-02 08:24:13', 'dh', 'dh', 's@s.fgh', '$2y$10$WqANYnhG044i/Oay58QxuegdGBSJCYx5jQUaAlsoSiccY5OO1jl2i', 971, 501234567, 0, 3, 1, 757531, '', NULL, NULL, NULL, NULL, NULL, 'fdg', 'dfg', NULL),
(19, '2018-01-02 08:25:35', '2018-01-02 08:25:35', 'w', 'w', 'w@w.uk', '$2y$10$C9wQOjFEVz0e5Ptq2oRrReIDdEVUks2x/9Kkqg7qNdbHauVKI5uUK', 971, 501234567, 0, 3, 1, 498446, '', NULL, NULL, NULL, NULL, NULL, 'ertgr', 'dfgfg', NULL),
(24, '2018-01-04 07:51:40', '2018-01-04 07:55:53', 'fs', 'sfsdf', 'e@e.ok', '$2y$10$ok3l1UizzBDPz9eoNN4kZOtC/WxQ80.SwZ4DdKOilFnPn0mfHZoHG', 971, 501234567, 1, 2, 1, 665603, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, '2018-01-04 09:02:28', '2018-01-04 09:18:34', 'Auth Test', 'Owner', 'owner@bid2rent.ae', '$2y$10$LqaSmPeGA14cbzAFaOeUM.jvnEFpVKrrUPREhjY71RBoc33mzVfoy', 971, 501234567, 1, 2, 1, 926007, '', NULL, 'media/landlord/25/501234567_251515062914.jpg', NULL, NULL, NULL, 'auth address', 'auth city', 'wFnSvP1e7vIy3ehSsx8udGEw62cuD4mFsaMBJqoE0R0Hq718RQoRi7AQCHqT'),
(26, '2018-01-04 09:03:56', '2018-01-04 09:22:47', 'Tenant Test', 'Tennat', 'tenant@bid2rent.ae', '$2y$10$Vj.hhwf7DKzRx9u9fjmVL.xuOlq0tcrGXd4XlK1bCAJjIYEYFO.FG', 971, 501234568, 1, 3, 1, 882391, 'media/tenant/26/501234568_1515062036.pdf', NULL, 'media/tenant/26/501234568_261515063149.jpg', NULL, NULL, NULL, 'Tenant Address', 'Tenant City', 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=27;
COMMIT;

