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

START TRANSACTION;



--
-- Database: `bid2rent`
--

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

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon_class` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL,
  `amenity_status_id` int(11) NOT NULL,
  `property_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` (`id`, `created_at`, `updated_at`, `name`, `icon_class`, `sort_order`, `amenity_status_id`, `property_count`) VALUES
(1, '2017-12-06 09:55:08', '2018-05-03 03:34:08', 'Washer/Dryer In Unit', 'icon-washer', 1, 1, 29),
(2, '2017-12-06 09:55:08', '2018-05-03 04:02:50', 'Pool', 'icon-pool', 2, 1, 27),
(3, '2017-12-06 09:55:08', '2018-03-09 03:13:32', 'Gym', 'icon-gym', 3, 1, 13),
(4, '2017-12-06 09:55:08', '2018-03-07 07:54:57', 'Elevator', 'icon-elevator', 4, 1, 17),
(5, '2017-12-06 09:55:08', '2018-05-03 04:02:50', 'Parking Spot', 'icon-parking-spot', 5, 1, 31),
(6, '2017-12-06 09:55:08', '2018-03-09 03:13:32', 'Fireplace', 'icon-fireplace', 6, 1, 8),
(7, '2017-12-06 09:55:08', '2018-03-05 14:56:37', 'Air Conditioning', 'icon-air-conditioning', 7, 1, 16),
(8, '2017-12-06 09:55:08', '2018-02-28 15:52:41', 'Doorman', 'icon-doorman', 8, 1, 15),
(9, '2017-12-06 09:55:08', '2018-03-09 03:13:32', 'Dishwasher', 'icon-dishwasher', 9, 1, 11),
(10, '2017-12-06 09:55:08', '2018-03-05 14:56:37', 'Deck', 'icon-deck', 10, 1, 9),
(11, '2017-12-06 09:55:08', '2018-02-27 20:27:18', 'Storage', 'icon-storage', 11, 1, 14),
(12, '2017-12-06 09:55:08', '2018-03-13 02:27:32', 'Wheelchair Accessible', 'icon-wheelchair', 12, 1, 7),
(13, '2017-12-06 09:55:08', '2018-03-05 14:56:37', 'Hardwood Floors', 'icon-hardwood', 13, 1, 7),
(14, '2017-12-06 09:55:08', '2018-02-27 20:08:50', 'Garden', 'icon-garden', 14, 1, 13),
(15, '2017-12-06 09:55:08', '2018-03-13 02:27:32', 'Balcony', 'icon-balcony', 15, 1, 6),
(16, '2017-12-06 09:55:08', '2018-02-27 20:08:50', 'Furnished', 'icon-furnished', 16, 1, 4),
(17, '2017-12-06 09:55:08', '2018-02-27 20:08:50', 'View', 'icon-view', 17, 1, 8),
(18, '2017-12-06 09:55:08', '2018-02-27 20:08:50', 'Student Friendly', 'icon-student', 18, 1, 5),
(19, '2017-12-06 09:55:08', '2018-02-27 20:08:50', 'High Rise', 'icon-high-rise', 19, 1, 3),
(20, '2017-12-06 09:55:08', '2018-02-27 20:08:50', 'Utilities Included', 'icon-utilities', 20, 1, 7);

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

--
-- Table structure for table `amenity_property`
--

CREATE TABLE `amenity_property` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `amenity_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenity_property`
--

INSERT INTO `amenity_property` (`id`, `created_at`, `updated_at`, `amenity_id`, `property_id`) VALUES
(1, '2018-02-02 15:29:21', '2018-02-02 15:29:21', 1, 1),
(2, '2018-02-02 15:29:21', '2018-02-02 15:29:21', 2, 1),
(3, '2018-02-02 15:29:21', '2018-02-02 15:29:21', 3, 1),
(4, '2018-02-02 15:29:21', '2018-02-02 15:29:21', 4, 1),
(5, '2018-02-02 15:29:21', '2018-02-02 15:29:21', 5, 1),
(6, '2018-02-02 15:29:21', '2018-02-02 15:29:21', 6, 1),
(7, '2018-02-02 15:34:19', '2018-02-02 15:34:19', 1, 2),
(8, '2018-02-02 15:34:19', '2018-02-02 15:34:19', 5, 2),
(9, '2018-02-02 15:34:19', '2018-02-02 15:34:19', 8, 2),
(10, '2018-02-02 15:34:19', '2018-02-02 15:34:19', 14, 2),
(11, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 1, 3),
(12, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 2, 3),
(13, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 3, 3),
(14, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 4, 3),
(15, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 5, 3),
(16, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 6, 3),
(17, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 7, 3),
(18, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 8, 3),
(19, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 10, 3),
(21, '2018-02-02 16:31:08', '2018-02-02 16:31:08', 1, 4),
(22, '2018-02-02 16:31:08', '2018-02-02 16:31:08', 4, 4),
(23, '2018-02-02 16:31:08', '2018-02-02 16:31:08', 5, 4),
(24, '2018-02-02 16:31:08', '2018-02-02 16:31:08', 8, 4),
(25, '2018-02-02 16:31:08', '2018-02-02 16:31:08', 9, 4),
(26, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 2, 5),
(27, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 3, 5),
(28, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 5, 5),
(29, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 7, 5),
(30, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 11, 5),
(31, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 14, 5),
(32, '2018-02-03 18:10:14', '2018-02-03 18:10:14', 2, 6),
(33, '2018-02-03 18:10:14', '2018-02-03 18:10:14', 3, 6),
(34, '2018-02-03 18:10:14', '2018-02-03 18:10:14', 5, 6),
(35, '2018-02-03 18:10:14', '2018-02-03 18:10:14', 7, 6),
(36, '2018-02-03 18:10:14', '2018-02-03 18:10:14', 11, 6),
(37, '2018-02-03 18:10:14', '2018-02-03 18:10:14', 14, 6),
(38, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 1, 7),
(39, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 2, 7),
(40, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 4, 7),
(41, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 5, 7),
(42, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 7, 7),
(43, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 8, 7),
(44, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 11, 7),
(45, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 1, 8),
(46, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 4, 8),
(47, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 7, 8),
(48, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 8, 8),
(49, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 14, 8),
(50, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 15, 8),
(51, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 17, 8),
(52, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 18, 8),
(53, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 20, 8),
(54, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 2, 9),
(55, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 4, 9),
(56, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 5, 9),
(57, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 7, 9),
(58, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 10, 9),
(59, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 11, 9),
(60, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 14, 9),
(61, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 18, 9),
(62, '2018-02-12 19:26:58', '2018-02-12 19:26:58', 1, 10),
(63, '2018-02-12 19:29:01', '2018-02-12 19:29:01', 4, 11),
(64, '2018-02-12 19:29:01', '2018-02-12 19:29:01', 5, 11),
(65, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 5, 12),
(66, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 6, 12),
(67, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 8, 12),
(68, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 9, 12),
(69, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 11, 12),
(70, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 12, 12),
(71, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 14, 12),
(72, '2018-02-12 19:58:28', '2018-02-12 19:58:28', 8, 13),
(73, '2018-02-12 19:58:28', '2018-02-12 19:58:28', 11, 13),
(74, '2018-02-12 19:58:28', '2018-02-12 19:58:28', 14, 13),
(75, '2018-02-12 19:58:28', '2018-02-12 19:58:28', 17, 13),
(76, '2018-02-15 15:00:56', '2018-02-15 15:00:56', 1, 14),
(77, '2018-02-15 15:00:56', '2018-02-15 15:00:56', 2, 14),
(78, '2018-02-15 15:00:56', '2018-02-15 15:00:56', 3, 14),
(79, '2018-02-15 15:00:56', '2018-02-15 15:00:56', 4, 14),
(80, '2018-02-15 15:00:56', '2018-02-15 15:00:56', 5, 14),
(81, '2018-02-15 15:00:56', '2018-02-15 15:00:56', 6, 14),
(82, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 2, 15),
(83, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 5, 15),
(84, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 8, 15),
(85, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 11, 15),
(86, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 14, 15),
(87, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 17, 15),
(88, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 1, 16),
(89, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 2, 16),
(90, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 3, 16),
(91, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 4, 16),
(92, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 5, 16),
(93, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 6, 16),
(94, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 7, 16),
(95, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 8, 16),
(96, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 9, 16),
(97, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 10, 16),
(98, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 11, 16),
(99, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 12, 16),
(100, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 13, 16),
(101, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 14, 16),
(102, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 15, 16),
(103, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 16, 16),
(104, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 17, 16),
(105, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 18, 16),
(106, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 19, 16),
(107, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 20, 16),
(108, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 1, 17),
(109, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 4, 17),
(110, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 7, 17),
(111, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 10, 17),
(112, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 13, 17),
(113, '2018-02-16 16:25:06', '2018-02-16 16:25:06', 1, 18),
(114, '2018-02-16 16:25:06', '2018-02-16 16:25:06', 5, 18),
(115, '2018-02-16 16:25:06', '2018-02-16 16:25:06', 9, 18),
(116, '2018-02-16 16:25:06', '2018-02-16 16:25:06', 11, 18),
(117, '2018-02-16 16:25:06', '2018-02-16 16:25:06', 13, 18),
(118, '2018-02-16 16:25:06', '2018-02-16 16:25:06', 17, 18),
(119, '2018-02-16 16:30:12', '2018-02-16 16:30:12', 20, 17),
(120, '2018-02-16 16:33:49', '2018-02-16 16:33:49', 8, 19),
(121, '2018-02-16 16:33:49', '2018-02-16 16:33:49', 17, 19),
(122, '2018-02-16 18:48:23', '2018-02-16 18:48:23', 2, 20),
(123, '2018-02-16 18:48:23', '2018-02-16 18:48:23', 3, 20),
(124, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 2, 21),
(125, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 4, 21),
(126, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 5, 21),
(127, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 7, 21),
(128, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 8, 21),
(129, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 13, 21),
(130, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 16, 21),
(131, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 20, 21),
(132, '2018-02-19 18:26:55', '2018-02-19 18:26:55', 12, 21),
(133, '2018-02-19 18:26:55', '2018-02-19 18:26:55', 14, 21),
(134, '2018-02-19 18:26:55', '2018-02-19 18:26:55', 15, 21),
(135, '2018-02-19 21:02:33', '2018-02-19 21:02:33', 5, 22),
(136, '2018-02-19 21:09:10', '2018-02-19 21:09:10', 1, 23),
(137, '2018-02-19 21:09:10', '2018-02-19 21:09:10', 5, 23),
(138, '2018-02-19 21:09:10', '2018-02-19 21:09:10', 9, 23),
(139, '2018-02-19 21:18:50', '2018-02-19 21:18:50', 1, 24),
(140, '2018-02-19 21:18:50', '2018-02-19 21:18:50', 5, 24),
(141, '2018-02-19 21:18:50', '2018-02-19 21:18:50', 9, 24),
(142, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 1, 25),
(143, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 2, 25),
(144, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 3, 25),
(145, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 4, 25),
(146, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 5, 25),
(147, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 7, 25),
(148, '2018-02-19 21:32:41', '2018-02-19 21:32:41', 1, 26),
(149, '2018-02-19 21:32:41', '2018-02-19 21:32:41', 5, 26),
(150, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 1, 27),
(151, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 2, 27),
(152, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 3, 27),
(153, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 4, 27),
(154, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 5, 27),
(155, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 6, 27),
(156, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 7, 27),
(157, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 8, 27),
(158, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 9, 27),
(159, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 10, 27),
(160, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 11, 27),
(161, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 12, 27),
(162, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 13, 27),
(163, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 14, 27),
(164, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 15, 27),
(165, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 16, 27),
(166, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 17, 27),
(167, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 18, 27),
(168, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 19, 27),
(169, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 20, 27),
(170, '2018-02-21 18:02:55', '2018-02-21 18:02:55', 7, 28),
(171, '2018-02-21 20:46:22', '2018-02-21 20:46:22', 20, 29),
(172, '2018-02-22 14:43:13', '2018-02-22 14:43:13', 8, 30),
(173, '2018-02-22 14:43:13', '2018-02-22 14:43:13', 11, 30),
(174, '2018-02-22 14:43:13', '2018-02-22 14:43:13', 14, 30),
(175, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 1, 34),
(176, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 2, 34),
(177, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 3, 34),
(178, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 4, 34),
(179, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 5, 34),
(180, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 6, 34),
(181, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 7, 34),
(182, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 8, 34),
(183, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 9, 34),
(184, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 10, 34),
(185, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 11, 34),
(186, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 12, 34),
(187, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 13, 34),
(188, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 14, 34),
(189, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 15, 34),
(190, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 16, 34),
(191, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 17, 34),
(192, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 18, 34),
(193, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 19, 34),
(194, '2018-02-27 20:08:50', '2018-02-27 20:08:50', 20, 34),
(195, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 1, 35),
(196, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 2, 35),
(197, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 3, 35),
(198, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 10, 35),
(199, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 11, 35),
(200, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 12, 35),
(201, '2018-02-27 21:29:05', '2018-02-27 21:29:05', 1, 36),
(202, '2018-02-27 21:29:05', '2018-02-27 21:29:05', 5, 36),
(203, '2018-02-27 21:29:05', '2018-02-27 21:29:05', 9, 36),
(204, '2018-02-28 14:39:09', '2018-02-28 14:39:09', 5, 37),
(205, '2018-02-28 14:47:20', '2018-02-28 14:47:20', 2, 38),
(206, '2018-02-28 14:47:20', '2018-02-28 14:47:20', 5, 38),
(207, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 5, 39),
(208, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 7, 39),
(209, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 8, 39),
(210, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 10, 39),
(211, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 1, 40),
(212, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 4, 40),
(213, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 7, 40),
(214, '2018-03-04 16:35:51', '2018-03-04 16:35:51', 1, 41),
(215, '2018-03-04 16:35:51', '2018-03-04 16:35:51', 5, 41),
(216, '2018-03-04 16:35:51', '2018-03-04 16:35:51', 9, 41),
(217, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 2, 42),
(218, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 4, 42),
(219, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 5, 42),
(220, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 7, 42),
(221, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 10, 42),
(222, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 13, 42),
(223, '2018-03-07 03:57:11', '2018-03-07 03:57:11', 2, 43),
(224, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 2, 44),
(225, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 3, 44),
(226, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 4, 44),
(227, '2018-03-07 07:57:39', '2018-03-07 07:57:39', 1, 45),
(228, '2018-03-07 07:57:39', '2018-03-07 07:57:39', 2, 45),
(229, '2018-03-07 07:58:17', '2018-03-07 07:58:17', 1, 46),
(230, '2018-03-07 07:58:17', '2018-03-07 07:58:17', 2, 46),
(231, '2018-03-07 07:58:24', '2018-03-07 07:58:24', 1, 47),
(232, '2018-03-07 07:58:24', '2018-03-07 07:58:24', 2, 47),
(233, '2018-03-08 07:31:24', '2018-03-08 07:31:24', 1, 48),
(234, '2018-03-08 08:29:20', '2018-03-08 08:29:20', 2, 49),
(235, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 3, 50),
(236, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 6, 50),
(237, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 9, 50),
(238, '2018-03-13 02:24:32', '2018-03-13 02:24:32', 1, 51),
(239, '2018-03-13 02:24:32', '2018-03-13 02:24:32', 2, 51),
(240, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 12, 52),
(241, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 15, 52),
(242, '2018-04-30 03:53:01', '2018-04-30 03:53:01', 1, 53),
(243, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 1, 54),
(244, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 1, 55),
(245, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 2, 56),
(246, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 5, 56),
(247, '2018-05-03 04:02:44', '2018-05-03 04:02:44', 2, 57),
(248, '2018-05-03 04:02:44', '2018-05-03 04:02:44', 5, 57),
(249, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 2, 58),
(250, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 5, 58);

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

--
-- Table structure for table `amenity_statuses`
--

CREATE TABLE `amenity_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amenity_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenity_statuses`
--

INSERT INTO `amenity_statuses` (`id`, `created_at`, `updated_at`, `name`, `amenity_count`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Active', 0),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Inactive', 0),
(3, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Suspended', 0),
(4, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Expired', 0),
(5, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Closed', 0);

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

--
-- Table structure for table `app_codes`
--

CREATE TABLE `app_codes` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `app_code_status_id` int(11) NOT NULL,
  `app_code_category_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_codes`
--

INSERT INTO `app_codes` (`id`, `created_at`, `updated_at`, `app_code_status_id`, `app_code_category_id`, `name`, `sort_order`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Abu Dhabi', 1),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Ajman', 2),
(3, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Dubai', 3),
(4, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Fujairah', 4),
(5, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Ras al-Khaimah', 5),
(6, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Sharjah', 6),
(7, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 1, 'Umm al-Quwain', 7),
(8, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 2, 'Apartment', 1),
(9, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 2, 'Villa', 2),
(10, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 2, 'Townhouse', 3),
(11, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 2, 'Penthouse', 4),
(12, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 2, 'Duplex', 5),
(13, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 3, 'Property is open for viewings', 1),
(14, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 3, 'Property keys with building reception', 2),
(15, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 3, 'No viewing available', 3),
(16, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, 'Studio', 1),
(17, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '1', 2),
(18, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '2', 3),
(19, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '3', 4),
(20, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '4', 5),
(21, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '5', 6),
(22, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '6', 7),
(23, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '7', 8),
(24, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '8', 9),
(25, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 4, '9+', 10),
(27, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '1', 2),
(28, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '2', 3),
(29, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '3', 4),
(30, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '4', 5),
(31, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '5', 6),
(32, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '6', 7),
(33, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '7', 8),
(34, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '8', 9),
(35, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '9+', 10),
(36, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 6, 'Student', 1),
(37, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 6, 'Employed', 2),
(38, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 6, 'Self-employed', 3),
(39, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 6, 'Unemployed', 4),
(40, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 6, 'Entrepreneur', 5),
(41, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 7, 'Public', 1),
(42, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 7, 'Private', 2),
(43, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 8, 'High', 1),
(44, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 8, 'Medium', 2),
(45, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 8, 'Low', 3),
(46, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'New', 1),
(47, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Hold', 2),
(48, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Selected', 3),
(49, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Rejected', 4),
(50, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Commission Pending', 5),
(51, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Commission Paid', 6),
(52, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Pending Documents', 7),
(53, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Contract inprogress', 8),
(54, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 9, 'Completed', 9),
(55, '2017-12-13 06:25:00', '2017-12-13 06:25:00', 1, 9, 'Opted-out', 10),
(56, '2017-12-13 06:25:00', '2017-12-13 06:25:00', 1, 9, 'Active', 11),
(57, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '1', 1),
(58, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '2', 2),
(59, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '4', 3),
(60, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '6', 4),
(61, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '8', 5),
(62, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '10', 6),
(63, '2018-02-15 02:31:38', '2018-02-15 02:31:38', 1, 10, '12', 7),
(64, '2018-03-06 08:20:07', '2018-03-06 08:20:07', 1, 9, 'Tenancy Contract Ongoing', 12),
(65, '2018-03-06 08:20:32', '2018-03-06 08:20:32', 1, 11, 'Pets not allowed', 12),
(66, '2018-03-06 08:20:32', '2018-03-06 08:20:32', 1, 11, 'Barbecue not allowed', 12),
(67, '2018-04-25 04:49:31', '2018-04-25 04:49:31', 1, 11, 'No Smoking', 3);

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

--
-- Table structure for table `app_code_categories`
--

CREATE TABLE `app_code_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL,
  `app_code_count` int(11) NOT NULL,
  `app_code_category_status_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_code_categories`
--

INSERT INTO `app_code_categories` (`id`, `created_at`, `updated_at`, `name`, `category_code`, `description`, `sort_order`, `app_code_count`, `app_code_category_status_id`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(3, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(4, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(5, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Wash Room Sizes', 'wash_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(6, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Employment Statuses', 'employment_status', 'Lorem ipsum dummy test', 1, 0, 1),
(7, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Landlord note vissibility statuses', 'landlord_note_vissibility_status', 'Lorem ipsum dummy test', 1, 0, 1),
(8, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Bid priority', 'bid_priority', 'Lorem ipsum dummy test', 1, 0, 1),
(9, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Bid Statuses', 'bid_status', 'Lorem ipsum dummy test', 1, 0, 1),
(10, '2018-02-15 02:28:36', '2018-02-15 02:28:36', 'Number of Payments', 'number_of_payments', 'It will store the number of cheque accepted', 1, 0, 1),
(11, '2018-02-27 04:27:51', '2018-02-27 04:27:51', 'Terms and conditions', 'property_terms_conditions', 'Lorem Ipsum dummy text', 1, 0, 1);

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

--
-- Table structure for table `app_code_categories_bkp`
--

CREATE TABLE `app_code_categories_bkp` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL,
  `app_code_count` int(11) NOT NULL,
  `app_code_category_status_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_code_categories_bkp`
--

INSERT INTO `app_code_categories_bkp` (`id`, `created_at`, `updated_at`, `name`, `category_code`, `description`, `sort_order`, `app_code_count`, `app_code_category_status_id`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(3, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(4, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(5, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Wash Room Sizes', 'wash_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(6, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Employment Statuses', 'employment_status', 'Lorem ipsum dummy test', 1, 0, 1),
(7, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Landlord note vissibility statuses', 'landlord_note_vissibility_status', 'Lorem ipsum dummy test', 1, 0, 1),
(8, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Bid priority', 'bid_priority', 'Lorem ipsum dummy test', 1, 0, 1),
(9, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Bid Statuses', 'bid_status', 'Lorem ipsum dummy test', 1, 0, 1),
(10, '2018-02-15 02:28:36', '2018-02-15 02:28:36', 'Number of Payments', 'number_of_payments', 'It will store the number of cheque accepted', 1, 0, 1);

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

--
-- Table structure for table `app_code_statuses`
--

CREATE TABLE `app_code_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_code_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_code_statuses`
--

INSERT INTO `app_code_statuses` (`id`, `created_at`, `updated_at`, `name`, `app_code_count`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Active', 0),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Inactive', 0);

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

--
-- Table structure for table `biddings`
--

CREATE TABLE `biddings` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `property_id` bigint(20) NOT NULL,
  `tenant_id` bigint(20) NOT NULL,
  `propose_rent` decimal(8,2) NOT NULL,
  `move_in_date` date NOT NULL,
  `tenant_note` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `employment_status_id` int(11) NOT NULL,
  `landlord_note` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `landlord_note_visibility_status_id` int(11) NOT NULL,
  `bid_status_id` int(11) NOT NULL,
  `bid_priority_id` int(11) NOT NULL,
  `bid_selection_time` datetime DEFAULT NULL,
  `contract_id` int(11) DEFAULT '0',
  `tenancy_contract_starting_date` date DEFAULT NULL COMMENT 'Tenancy Contract starting date',
  `tenancy_contract_end_date` date DEFAULT NULL COMMENT 'Tenancy Contract end date'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `biddings`
--

INSERT INTO `biddings` (`id`, `created_at`, `updated_at`, `property_id`, `tenant_id`, `propose_rent`, `move_in_date`, `tenant_note`, `employment_status_id`, `landlord_note`, `landlord_note_visibility_status_id`, `bid_status_id`, `bid_priority_id`, `bid_selection_time`, `contract_id`, `tenancy_contract_starting_date`, `tenancy_contract_end_date`) VALUES
(1, '2018-02-02 15:37:06', '2018-02-06 15:24:01', 1, 2, '2100.00', '2018-02-10', 'I want to shift asap', 37, 'You can shift from 9 feb', 41, 55, 45, NULL, 0, NULL, NULL),
(2, '2018-02-02 15:40:24', '2018-02-06 15:26:01', 1, 35, '2100.00', '2018-02-14', 'Interested', 38, 'Thanks for  you interest', 41, 55, 45, '2018-02-02 10:42:32', 0, NULL, NULL),
(3, '2018-02-02 16:11:40', '2018-02-06 15:26:01', 3, 29, '9700.00', '2018-02-19', 'I am ready to stay here.', 36, 'And now make the payment.', 41, 55, 45, '2018-02-02 11:14:13', 0, NULL, NULL),
(4, '2018-02-02 16:34:01', '2018-02-06 15:26:01', 4, 29, '9600.00', '2018-02-27', 'I can make the payment now..', 37, 'Payment will be made today', 42, 55, 45, '2018-02-02 11:35:41', 0, NULL, NULL),
(5, '2018-02-03 19:56:19', '2018-02-08 18:00:01', 5, 33, '6000.00', '2018-02-08', 'can I view the prop any time, how many cheques?', 37, '2 cheques possible only', 41, 55, 45, '2018-02-06 12:47:44', 0, NULL, NULL),
(6, '2018-02-03 19:57:45', '2018-02-06 17:46:29', 6, 33, '18000.00', '2018-02-10', 'can I see the villa', 37, 'door is open any time between 9 and 5pm', 42, 46, 45, NULL, 0, NULL, NULL),
(7, '2018-02-04 18:21:38', '2018-02-06 19:00:01', 7, 10, '6000.00', '2018-02-28', 'test message', 38, '', 0, 55, 45, '2018-02-04 13:22:39', 0, NULL, NULL),
(8, '2018-02-05 13:08:44', '2018-02-07 14:00:01', 2, 35, '4500.00', '2018-02-13', 'test', 37, '', 0, 55, 45, '2018-02-05 08:40:10', 0, NULL, NULL),
(9, '2018-02-06 13:36:16', '2018-02-08 14:00:01', 8, 29, '9200.00', '2018-02-28', 'Interested.', 37, 'Now you can make the payment', 41, 55, 45, '2018-02-06 08:37:43', 0, NULL, NULL),
(10, '2018-02-12 19:00:50', '2018-02-12 19:15:47', 9, 38, '4001.00', '2018-03-01', 'Interested', 37, '', 0, 55, 45, NULL, 0, NULL, NULL),
(11, '2018-02-12 19:28:15', '2018-03-13 07:29:16', 10, 35, '4544.00', '2018-02-21', 'Note 1', 37, '', 0, 64, 45, '2018-02-15 10:12:59', 3, '2018-03-13', '2019-03-12'),
(12, '2018-02-12 19:32:31', '2018-02-14 20:00:02', 11, 35, '500.00', '2018-02-21', 'fsdsf', 40, '', 0, 55, 45, '2018-02-12 14:39:20', 0, NULL, NULL),
(13, '2018-02-12 19:58:58', '2018-02-15 15:25:12', 10, 38, '4545.00', '2018-02-21', 'Interested', 36, '', 0, 49, 45, NULL, 0, NULL, NULL),
(14, '2018-02-12 20:12:33', '2018-02-12 22:00:01', 13, 38, '1100.00', '2018-03-01', 'Interested', 37, '', 0, 55, 45, '2018-02-10 15:12:56', 0, NULL, NULL),
(15, '2018-02-15 19:31:52', '2018-02-15 19:46:55', 12, 40, '3500.00', '2018-03-05', 'Interested on rent', 36, 'You have to pay 10 % of the amount Now.', 41, 46, 45, NULL, 0, NULL, NULL),
(16, '2018-02-15 20:21:34', '2018-02-18 16:00:01', 9, 40, '4500.00', '2018-03-01', 'Will 50% more', 37, 'You had take too time, If you are interested then do payment as soon as possible.   \r\n\r\nSending emails to your boss, your colleagues, potential customers, or anyone else you already do or potentially may do business with is fraught with many potential hazards making it a veritable minefield of professional decorum, with each inappropriate joke and incorrectly capitalized letter an invitation to disaster. Emailing is incredibly convenient and should not be seen as something that may anger someone or something to avoid but rather as an invaluable communication tool used to accomplish the goals of the company and its workers.\r\n\r\nBelow, we will discuss the various pitfalls people succumb to when emailing in a business environment and how to avoid them. From the subject line to the closing, after reading this article along with this email etiquette course, you should be ready to fire off email after email like it’s your job… because it is.', 41, 55, 45, '2018-02-16 10:57:48', 0, NULL, NULL),
(17, '2018-02-16 21:06:03', '2018-02-19 19:31:52', 19, 40, '11000.00', '2018-02-25', 'Interested', 36, '', 0, 46, 45, NULL, 0, NULL, NULL),
(18, '2018-02-16 21:07:59', '2018-02-16 21:07:59', 19, 29, '14000.00', '2018-02-28', 'Very much interested', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(19, '2018-02-19 20:47:33', '2018-02-20 20:35:35', 17, 40, '30020.00', '2018-03-01', 'Intested', 40, 'complete as soon as possible and ready your document', 41, 54, 45, '2018-02-19 15:49:19', 1, NULL, NULL),
(20, '2018-02-19 21:20:58', '2018-03-13 07:45:00', 16, 35, '13000.00', '2018-02-23', 'Note', 37, '', 0, 64, 45, '2018-02-19 16:21:19', 2, '2018-03-13', '2019-03-12'),
(21, '2018-02-19 21:50:39', '2018-02-19 22:05:50', 25, 33, '502001.00', '2018-02-27', 'please vall nowifnowie', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(22, '2018-02-19 21:57:45', '2018-02-23 18:00:01', 23, 10, '21000.00', '2018-02-28', 'Tenant Note', 36, '', 0, 55, 45, '2018-02-21 12:47:21', 0, NULL, NULL),
(23, '2018-02-20 17:25:38', '2018-02-20 21:11:13', 27, 40, '60100.00', '2018-03-05', 'Interested', 40, '', 0, 54, 45, '2018-02-20 12:26:11', 2, NULL, NULL),
(24, '2018-02-21 14:07:52', '2018-02-21 14:41:25', 21, 40, '25002.00', '2018-03-20', 'Interested', 36, '', 0, 47, 45, NULL, 0, NULL, NULL),
(25, '2018-02-21 14:08:36', '2018-02-21 14:41:25', 21, 29, '25100.00', '2018-04-01', 'Interested', 37, '', 0, 47, 45, NULL, 0, NULL, NULL),
(26, '2018-02-21 14:11:43', '2018-02-21 14:41:25', 21, 42, '25200.00', '2018-03-31', 'Interested', 38, '', 0, 47, 45, NULL, 0, NULL, NULL),
(27, '2018-02-21 14:40:53', '2018-02-23 15:00:02', 21, 43, '25500.00', '2018-04-30', 'Interested', 40, '', 0, 55, 45, '2018-02-21 09:41:25', 0, NULL, NULL),
(28, '2018-02-26 17:29:03', '2018-02-26 17:29:03', 25, 37, '501500.00', '2018-02-27', 'Note', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(29, '2018-02-26 20:26:57', '2018-02-26 20:26:57', 12, 45, '45000.00', '2018-03-31', 'rrrrrrr', 36, '', 0, 46, 45, NULL, 0, NULL, NULL),
(30, '2018-02-27 20:57:19', '2018-02-27 21:00:11', 34, 35, '36000.00', '2018-03-15', 'First note', 37, '', 0, 54, 45, '2018-02-27 15:58:00', 3, NULL, NULL),
(31, '2018-02-27 22:50:12', '2018-03-07 10:19:03', 36, 10, '6000.00', '2018-03-15', 'Tenant Note', 40, 'test', 41, 55, 45, '2018-03-04 11:30:17', 0, NULL, NULL),
(32, '2018-02-28 14:36:26', '2018-02-28 14:36:26', 30, 40, '60010.00', '2018-03-15', 'Interested to buy property', 40, '', 0, 46, 45, NULL, 0, NULL, NULL),
(33, '2018-03-01 19:24:09', '2018-03-01 19:24:09', 30, 29, '60500.00', '2018-04-01', 'Please Test Coach survey module which was added to field marketing module this will be enabled/disbaled using flag CSURVEY, the login popover will be validated locally using tbl_user_all where is_coach =‘Y’, once coach is logged in ,survey groups will be displayed which will be fetched from TBL_Survey_Question_Groups here if parent_group_id is 0 that will be treated as a parent group and it will have sub groups, each sub group has question which will be fetched from TBL_Survey_Questions  all this functionality is same as our existing survey module, just grouping is added to it, if user has tapped next the confirmation screen will be displayed which will have comments boxes and signature capture panel of fsr and coach. the captured data is saved in TBL_Survey_Audit_Responses  and images are synced to server with name Signature Images.', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(34, '2018-03-01 19:53:34', '2018-03-01 19:53:34', 12, 29, '42000.00', '2018-05-24', 'Interested', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(35, '2018-03-04 16:45:34', '2018-03-06 17:00:01', 41, 10, '6000.00', '2018-04-15', 'Tenant Note', 37, '', 0, 55, 45, '2018-03-04 11:45:55', 0, NULL, NULL),
(36, '2018-03-06 13:46:01', '2018-03-09 04:55:20', 6, 35, '61000.00', '2018-03-07', 'test note', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(37, '2018-03-06 14:15:00', '2018-03-06 14:15:00', 18, 35, '25000.00', '2018-03-07', 'note', 37, '', 0, 46, 45, NULL, 0, NULL, NULL),
(38, '2018-03-09 03:15:09', '2018-03-09 09:04:14', 50, 35, '356343.00', '2018-03-16', 'test', 37, '', 0, 55, 45, '2018-03-06 14:22:07', 0, NULL, NULL),
(39, '2018-03-13 08:01:00', '2018-04-30 02:13:10', 51, 35, '2823.00', '2018-03-16', 'dasdasd', 37, '', 0, 50, 45, '2018-03-13 13:33:31', 0, NULL, NULL),
(40, '2018-04-30 04:54:21', '2018-04-30 04:56:55', 53, 35, '12500.00', '2018-06-14', '', 38, '', 0, 50, 45, '2018-04-30 10:26:43', 0, NULL, NULL);

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

--
-- Table structure for table `contact_queries`
--

CREATE TABLE `contact_queries` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fullname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` int(11) NOT NULL,
  `mobile` bigint(20) NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_queries`
--

INSERT INTO `contact_queries` (`id`, `created_at`, `updated_at`, `fullname`, `email`, `country_code`, `mobile`, `message`) VALUES
(1, '2018-03-01 14:47:10', '2018-03-01 14:47:10', 'Honey Thakur', 'honey.ushyaku@gmail.com', 971, 561872072, 'I have added the functionality to contact us.\r\n\r\nAll queries will be listed in database & visible on the admin side, also an email will be sent to admin email id. Currently, we are using Anashwar email id as admin email.'),
(2, '2018-03-01 14:49:56', '2018-03-01 14:49:56', 'David Morey', 'davidmorey03@yahoo.com', 971, 561872072, 'I have added the functionality to contact us. All queries will be listed in database & visible on the admin side, also an email will be sent to admin email id. Currently, we are using Anashwar email id as admin email.');

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

--
-- Table structure for table `contracts`
--

CREATE TABLE `contracts` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `property_id` int(11) NOT NULL,
  `landlord_id` int(11) NOT NULL,
  `bid_id` int(11) NOT NULL,
  `tenant_id` int(11) NOT NULL,
  `path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contracts`
--

INSERT INTO `contracts` (`id`, `created_at`, `updated_at`, `property_id`, `landlord_id`, `bid_id`, `tenant_id`, `path`) VALUES
(1, '2018-02-20 20:35:35', '2017-03-15 19:35:35', 17, 39, 19, 40, 'media/contract/19/Image_129569386.pdf'),
(2, '2018-02-20 21:11:13', '2018-02-20 21:11:13', 27, 39, 23, 40, 'media/contract/23/Image_516562248.docx'),
(3, '2018-02-27 21:00:11', '2018-02-27 21:00:11', 34, 22, 30, 35, 'media/contract/30/Image_1182991319.pdf');

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

--
-- Table structure for table `kryptonit3_counter_page`
--

CREATE TABLE `kryptonit3_counter_page` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kryptonit3_counter_page`
--

INSERT INTO `kryptonit3_counter_page` (`id`, `page`) VALUES
(1, '83d2bf80-e87f-5262-a71e-7bdb31a971bb');

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

--
-- Table structure for table `kryptonit3_counter_page_visitor`
--

CREATE TABLE `kryptonit3_counter_page_visitor` (
  `page_id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kryptonit3_counter_page_visitor`
--

INSERT INTO `kryptonit3_counter_page_visitor` (`page_id`, `visitor_id`, `created_at`) VALUES
(1, 1, '2018-02-08 21:20:38'),
(1, 2, '2018-02-13 22:42:31'),
(1, 3, '2018-02-08 18:22:55'),
(1, 4, '2018-02-13 14:22:04'),
(1, 5, '2018-02-08 15:57:25'),
(1, 6, '2018-02-19 16:38:40'),
(1, 7, '2018-03-05 23:43:02'),
(1, 8, '2018-03-12 02:35:14'),
(1, 9, '2018-02-11 23:54:45'),
(1, 10, '2018-02-09 21:52:57'),
(1, 11, '2018-02-21 21:32:05'),
(1, 12, '2018-02-26 03:12:37'),
(1, 13, '2018-02-12 15:36:29'),
(1, 14, '2018-03-05 18:20:45'),
(1, 15, '2018-02-13 14:36:36'),
(1, 16, '2018-02-12 16:14:04'),
(1, 17, '2018-02-12 17:52:24'),
(1, 18, '2018-02-12 22:06:15'),
(1, 19, '2018-02-12 19:29:05'),
(1, 20, '2018-02-12 22:21:31'),
(1, 21, '2018-02-13 13:47:56'),
(1, 22, '2018-03-05 20:06:50'),
(1, 23, '2018-02-26 19:41:28'),
(1, 24, '2018-02-21 15:55:42'),
(1, 25, '2018-02-15 21:55:52'),
(1, 26, '2018-02-22 21:03:02'),
(1, 27, '2018-02-15 21:27:34'),
(1, 28, '2018-02-15 22:10:18'),
(1, 29, '2018-02-16 21:06:09'),
(1, 30, '2018-02-19 21:07:11'),
(1, 31, '2018-02-16 19:15:13'),
(1, 32, '2018-02-19 20:47:44'),
(1, 33, '2018-03-06 14:50:16'),
(1, 34, '2018-02-19 18:12:52'),
(1, 35, '2018-02-19 21:31:26'),
(1, 36, '2018-02-19 22:22:28'),
(1, 37, '2018-02-19 22:28:27'),
(1, 38, '2018-02-20 21:32:21'),
(1, 39, '2018-02-20 20:14:46'),
(1, 40, '2018-02-20 15:53:32'),
(1, 41, '2018-02-20 20:29:46'),
(1, 42, '2018-02-20 15:56:09'),
(1, 43, '2018-02-20 16:02:46'),
(1, 44, '2018-02-21 13:56:33'),
(1, 45, '2018-02-21 21:30:33'),
(1, 46, '2018-02-21 21:07:16'),
(1, 47, '2018-03-05 14:28:20'),
(1, 48, '2018-02-21 17:47:29'),
(1, 49, '2018-02-21 19:14:12'),
(1, 50, '2018-02-22 20:25:25'),
(1, 51, '2018-02-22 17:19:03'),
(1, 52, '2018-02-22 21:22:59'),
(1, 53, '2018-02-27 18:40:24'),
(1, 54, '2018-02-23 14:19:18'),
(1, 55, '2018-02-23 19:11:51'),
(1, 56, '2018-02-27 01:29:05'),
(1, 57, '2018-02-27 18:32:26'),
(1, 58, '2018-02-27 21:10:03'),
(1, 59, '2018-02-27 18:40:46'),
(1, 60, '2018-02-27 21:09:49'),
(1, 61, '2018-03-01 16:21:15'),
(1, 62, '2018-03-01 16:47:49'),
(1, 63, '2018-03-05 19:04:59'),
(1, 64, '2018-02-28 20:18:45'),
(1, 65, '2018-02-28 19:26:01'),
(1, 66, '2018-03-06 17:43:02'),
(1, 67, '2018-03-01 19:51:17'),
(1, 68, '2018-03-04 17:57:13'),
(1, 69, '2018-03-05 16:56:07'),
(1, 70, '2018-03-06 16:29:26'),
(1, 71, '2018-03-06 15:23:54'),
(1, 72, '2018-03-09 10:08:13'),
(1, 73, '2018-03-16 05:43:52'),
(1, 74, '2018-03-13 08:03:29'),
(1, 75, '2018-03-12 07:49:36');

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

--
-- Table structure for table `kryptonit3_counter_visitor`
--

CREATE TABLE `kryptonit3_counter_visitor` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `visitor` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kryptonit3_counter_visitor`
--

INSERT INTO `kryptonit3_counter_visitor` (`id`, `visitor`) VALUES
(38, '0b038af67a096255c647647c20513aba7c8a76a230ac181be2fe0379eca974bc'),
(41, '0c0331457152b5a6063d357edf449a4dc10d888e1133194570ab485a58a48f52'),
(43, '125681924fa3811c1c512932f0e3b86c8e5c574d896b38c15c88f9de77534504'),
(36, '131144e55f94556a572cae5aa150b58e6b3540ab4a7dd5746d60c20118d6e58f'),
(15, '14ec2711e87f54aa6ebe28e35db2964132de3f6dfa6e60e6833df56cd052777f'),
(50, '1647acfa96e130babe9b952a4eee21b50e29ec8407950b5d04fd4f2a092fb023'),
(46, '181623598b89e09740b706b12c864a4dc5283d3fbac1c7476da2c888813a74e8'),
(9, '1f43a5b0b7b59e19d8518d404ad0878f6cedd9a73ec5551e0b140075122c3fb2'),
(60, '20f26041e92949f3f8ddec9635b28d3bc8bd6efebee56b56610ead6908717df9'),
(4, '250f0f084581b229553b6ef9a213b0cad2e581aed69f1390ca4c6f383e5c3e8a'),
(59, '28051962b067b87db2cef3bb1b1bb2ca0ae1ee7a502ac8c44a8db83ba9e24f55'),
(45, '29bdd002933c542970344dc5345eea0537e6ff2523417f15bf26c0003c05f5d2'),
(75, '2bb1db3f6677b7f5f78bb56f643b34069906b531ab1c4dbe20db137d7e57b5bd'),
(68, '320df47088747a3ac069b9c5955ed127d0e031119cbdac88bec87ac2f998a28e'),
(14, '32600662844aca53bcf6a3f563d9d7d8a59f4c72a7dd6ddb5cb32fc5d7d3efea'),
(48, '3363bc0af0ff62bff654bd6fccc1c25860340d43fc9c1736e5ce53e5d7612958'),
(62, '35eb51ff171d9e42093bb5722f98ecfbbd9bfffbe378dbf571515fa73985d4de'),
(23, '3a0b3498c72c64345e04dc79dd65b19688fa6924c384ca2c91f172b1e7d6c756'),
(64, '3b72d6bccb0cb8dc16d4f70f47e6c25be7b5a1b4fae4c2f407b3d53a7faccf58'),
(21, '3bf6ffff9c5844745bd5a50a32489d7660501ee63edc75eef952b2af5534871e'),
(2, '3daf5646617e309d9b57021577a9142826b72b908db3eee0efa7b574aec98a1a'),
(56, '42609820ff339f5834a78893b052ec94a9b5a54dd81a61d56344b105a578c0a0'),
(27, '47f7fa4923ed4f322f1ae761c30c8c283784d4afe4de5142a5b9b946b5dde4d3'),
(28, '4892f640f45136d05b0dd44431327c56119a212f3fb80df39a1dfafced79ee35'),
(32, '49551a58efb48d63027e803cf5026c3d9d70eccd687ed8bb8e1ded0154b352ae'),
(63, '4bf7644a33671c82e22c935349e32b12af290383030d23172588f83ae1ec5ebf'),
(12, '4cbb21ade80b2ced63dbffc228965cf4fafef03317e5b4cfc44779e25d4d467b'),
(25, '5115671197b747418264e047ea853b810601164417303d2046f9febb4b60e069'),
(65, '56f62f2ed64840b5f1c2c0ce0c5aff148c254fe23191aa68c92957a5d650dd82'),
(5, '5e2df509954d07961af0415b29f6e2611044c594df4217562b0aa02be38132b1'),
(42, '62c448f3bdce629c4aa512cd7e606bd3020246baf5ee0e68e31424c1d1c51fe3'),
(34, '666edd8b7466f1f3be22576f7a066033fd3cc338ad78dc0eea0c229be443a1cb'),
(26, '696a8797e059c5ee92b5f815cf258a37170c9e475663b2a333a67602ce2d1ed6'),
(54, '7091ef96ebb3aa0d7b24fa4cabb07e40a69f0ae7dc62eb835411e4a4349c4400'),
(74, '718c69955ac9be2b3cd4b0543c82ad818691c627f324e7e8b8170079c1e4375d'),
(20, '7766205bf4854ee7a8b3afa1df5a9926c63f6f6dceee3e80cafc9d143792f12b'),
(55, '797533681c6ac3bff704700bdeec55e05283a3db8e25f0bd6569c6974a398595'),
(61, '7f836eac88acc26e74680924ba82d9a28864160162832731a8bc200492c6661f'),
(37, '8949ee2163d49c773f251613b092317460122a685347384f707c921491b24df8'),
(30, '8c1a998ec209a7bed7b57c9636956abc149242f1a169ab09a16e2957bc131cfc'),
(29, '99b81d146aa4a087840d0770dd375619707ed64e4c0429df21c8e8969978a069'),
(24, '9ffbe2d8d23f290b625201cc6e7c76811cc975eb1ec0b47b22063fb0c44a5875'),
(1, 'a08ee027a24a2e819c673f5467ac1abea33340739982923b03f3c56640a73c94'),
(17, 'a58b5b4308dfe39666451585cce9755272879d8676785732b0509500412d9564'),
(31, 'a922667ac91590c009e966990f6b6fd2177bae037b4d28d7b336630bdb7114a1'),
(11, 'ad13f4918d817b6af714cd3a454753036eff0323ab71c0384ee417f22cf37905'),
(66, 'aebcf6ee104bc6bc8d45591b184dbd54778e2780827616f327f3482dd8e62984'),
(18, 'b60f4a9392c9c1b904728dc0e2002bf8ddedcfd3a4438c8918508cfbe3e7c330'),
(51, 'b624afb285a1fe1dabde809f611f42192a18ef0aef615d85a82d5d40c995bd1a'),
(22, 'b7deb46c0c678a687931947adf9a53d3f73c568ab31715b7dca68ba8f5ae2b48'),
(70, 'b96fde05421f0ebf1412949ff44d2a7c4b9bc28dad16f6e73b02c1f31a3a2b59'),
(6, 'b9ebc06c41e5430ddc1c1f1c58a933f41ca2ccd97287f1df3ed7380427892fb1'),
(49, 'bc120fdd9d14075aa7582e06a60bce0531da362f36befa5823181af1ee8b3ef4'),
(40, 'bc93c4f1a95ab489e334a700ad789f9df5f8b086b45193701f2b1493840262e6'),
(3, 'bce9269f1ea5c20e19322d93fa9478db3ab19b10f1a4460529228589a3650364'),
(16, 'be82d6850262a13a74becb93a1abcf0e98cd89928e728f9aab2328101b263adf'),
(13, 'c2f8c4a30b9d7ce7f7853473abdd71f9467909d701702ac55f11ab8e316c6a2e'),
(39, 'c42859627252eae903819f980d92fdcb20f9ccc44c2a0d617d714c5956fe865e'),
(7, 'c65fb8b02774d389e09654c6dd9fc9db6f73c44722fafa1266d6bd5ff7b41105'),
(71, 'cddc25a7355f415d7369ee3800cb7e98592b7db2c8589994948bb1200cca90a8'),
(19, 'd26712c05ccfcccc8272f15572c58a9235b2489d0681bb53db1cc5eb1eda12e5'),
(8, 'd30cb287159c689bf6a5edbe62121d26f28cb69ddad0a88a8139b4138e3716c0'),
(47, 'd63225fa0adbd75dc37957fff4ef2c206cd3b6cb0037670c8143fa95ce328db1'),
(67, 'd7f9f252f9f707bc48808dda5cc03a0b30374edcc73ffdb9da1b348d7916877c'),
(52, 'd8e663282fe9cd9d49c9158b2a5278296031e0fa53600958fefd83ebf136742c'),
(33, 'd9de67b8c02883f9dd4eab1dd1910332711aba1781ff94e7737c38a67e893e52'),
(44, 'd9ec779fc35a5d7a36426afa239d1e1fdc293f7fba9de90e69ed7696f73f38f8'),
(69, 'da8ff8af3340b0ade81ee9eccda20fc690aaebd15d440d5343738973cb43ef22'),
(10, 'e26dd77fd25676dae0f9407cb8eea611eb8e6242aeb6cc29302b70840355b1fe'),
(57, 'e6f9d326b1cd6aba364bbfdc9046222db87fc875ce50eb85c82679d90aae7590'),
(73, 'ecdc3feb52973f1c1e6c7ee913ce05cf7ecc98e93c4c9dc4bf296fc3168898c3'),
(35, 'f0f790a97c8633db808537479b4dca13044e66ad0965534b827e9e5d1f825a6c'),
(72, 'f0f8b0c9d7e1410138c7aeb318c7e01e018203b698106eea8b4c721ff882e119'),
(58, 'f371dadd994023bacea8610ea8bd0c8bb09f1cee764a1820c682c5cd0913a677'),
(53, 'fdf1cdb2e7081b1b4711ec0e4722eaf855f714a338163681d49ca11c713d45e4');

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

--
-- Table structure for table `medias`
--

CREATE TABLE `medias` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `medias`
--

INSERT INTO `medias` (`id`, `created_at`, `updated_at`, `model_id`, `parent_id`, `path`) VALUES
(3, '2018-02-02 15:34:19', '2018-02-02 15:34:19', 1, 2, 'media/landlord/22/Image_586492600.jpg'),
(4, '2018-02-02 15:49:39', '2018-02-02 15:49:39', 1, 3, 'media/landlord/25/Image_821481040.png'),
(5, '2018-02-02 16:02:30', '2018-02-02 16:02:30', 1, 3, 'media/landlord/25/Image_1497839077.jpg'),
(6, '2018-02-03 18:07:56', '2018-02-03 18:07:56', 1, 5, 'media/landlord/32/Image_2075441399.jpg'),
(7, '2018-02-04 18:20:43', '2018-02-04 18:20:43', 1, 7, 'media/landlord/9/Image_1786791008.jpeg'),
(8, '2018-02-06 13:33:47', '2018-02-06 13:33:47', 1, 8, 'media/landlord/25/Image_357208481.jpg'),
(9, '2018-02-12 18:14:30', '2018-02-12 18:14:30', 1, 9, 'media/landlord/25/Image_359218121.PNG'),
(10, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 1, 12, 'media/landlord/25/Image_688099999.jpg'),
(11, '2018-02-12 19:48:30', '2018-02-12 19:48:30', 1, 12, 'media/landlord/25/Image_247091590.jpg'),
(12, '2018-02-12 19:58:28', '2018-02-12 19:58:28', 1, 13, 'media/landlord/22/Image_391701107.jpg'),
(13, '2018-02-12 19:58:28', '2018-02-12 19:58:28', 1, 13, 'media/landlord/22/Image_97748326.jpg'),
(14, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 1, 15, 'media/landlord/39/Image_528159006.jpg'),
(15, '2018-02-15 18:46:51', '2018-02-15 18:46:51', 1, 15, 'media/landlord/39/Image_833628453.jpg'),
(16, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 1, 16, 'media/landlord/22/Image_1884257589.jpg'),
(17, '2018-02-15 20:58:16', '2018-02-15 20:58:16', 1, 16, 'media/landlord/22/Image_325716980.jpg'),
(18, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 1, 17, 'media/landlord/39/Image_1007169008.jpg'),
(19, '2018-02-16 14:55:34', '2018-02-16 14:55:34', 1, 17, 'media/landlord/39/Image_250364671.jpg'),
(20, '2018-02-16 16:30:12', '2018-02-16 16:30:12', 1, 17, 'media/landlord/39/Image_696039690.jpg'),
(21, '2018-02-16 16:30:12', '2018-02-16 16:30:12', 1, 17, 'media/landlord/39/Image_1306005012.jpg'),
(22, '2018-02-16 16:33:49', '2018-02-16 16:33:49', 1, 19, 'media/landlord/39/Image_739434340.jpg'),
(23, '2018-02-16 16:33:49', '2018-02-16 16:33:49', 1, 19, 'media/landlord/39/Image_1861847851.jpg'),
(24, '2018-02-16 18:48:23', '2018-02-16 18:48:23', 1, 20, 'media/landlord/22/Image_1922291074.jpg'),
(25, '2018-02-16 18:48:23', '2018-02-16 18:48:23', 1, 20, 'media/landlord/22/Image_1828710533.jpg'),
(26, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 1, 21, 'media/landlord/39/Image_70042251.jpg'),
(27, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 1, 21, 'media/landlord/39/Image_591593204.jpg'),
(28, '2018-02-16 20:15:23', '2018-02-16 20:15:23', 1, 21, 'media/landlord/39/Image_1378308587.jpg'),
(29, '2018-02-19 21:02:33', '2018-02-19 21:02:33', 1, 22, 'media/landlord/22/Image_1436030795.png'),
(30, '2018-02-19 21:02:33', '2018-02-19 21:02:33', 1, 22, 'media/landlord/22/Image_891414503.png'),
(31, '2018-02-19 21:02:33', '2018-02-19 21:02:33', 1, 22, 'media/landlord/22/Image_1992433594.png'),
(32, '2018-02-19 21:09:10', '2018-02-19 21:09:10', 1, 23, 'media/landlord/9/Image_1513012873.jpg'),
(33, '2018-02-19 21:09:10', '2018-02-19 21:09:10', 1, 23, 'media/landlord/9/Image_608112432.jpg'),
(34, '2018-02-19 21:09:10', '2018-02-19 21:09:10', 1, 23, 'media/landlord/9/Image_1660066884.jpg'),
(35, '2018-02-19 21:18:50', '2018-02-19 21:18:50', 1, 24, 'media/landlord/9/Image_571813889.jpg'),
(36, '2018-02-19 21:18:50', '2018-02-19 21:18:50', 1, 24, 'media/landlord/9/Image_1759873704.jpg'),
(37, '2018-02-19 21:18:50', '2018-02-19 21:18:50', 1, 24, 'media/landlord/9/Image_448451057.jpg'),
(38, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 1, 25, 'media/landlord/22/Image_373198853.jpg'),
(39, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 1, 25, 'media/landlord/22/Image_1270314240.jpg'),
(40, '2018-02-19 21:31:13', '2018-02-19 21:31:13', 1, 25, 'media/landlord/22/Image_1769974213.jpg'),
(41, '2018-02-19 21:32:41', '2018-02-19 21:32:41', 1, 26, 'media/landlord/9/Image_1098013291.jpg'),
(42, '2018-02-19 21:32:41', '2018-02-19 21:32:41', 1, 26, 'media/landlord/9/Image_1604804917.jpg'),
(43, '2018-02-19 21:32:41', '2018-02-19 21:32:41', 1, 26, 'media/landlord/9/Image_428285599.jpg'),
(44, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 1, 27, 'media/landlord/39/Image_1466984339.jpg'),
(45, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 1, 27, 'media/landlord/39/Image_923419242.jpg'),
(46, '2018-02-20 15:27:05', '2018-02-20 15:27:05', 1, 27, 'media/landlord/39/Image_888885856.jpg'),
(47, '2018-02-21 18:02:55', '2018-02-21 18:02:55', 1, 28, 'media/landlord/44/Image_180213060.jpg'),
(48, '2018-02-21 18:02:55', '2018-02-21 18:02:55', 1, 28, 'media/landlord/44/Image_934042561.jpg'),
(49, '2018-02-21 18:02:55', '2018-02-21 18:02:55', 1, 28, 'media/landlord/44/Image_133144649.jpg'),
(50, '2018-02-21 20:46:22', '2018-02-21 20:46:22', 1, 29, 'media/landlord/39/Image_1061908119.jpg'),
(51, '2018-02-21 20:46:22', '2018-02-21 20:46:22', 1, 29, 'media/landlord/39/Image_1233816805.jpg'),
(52, '2018-02-21 20:46:22', '2018-02-21 20:46:22', 1, 29, 'media/landlord/39/Image_106829218.jpg'),
(53, '2018-02-22 14:43:13', '2018-02-22 14:43:13', 1, 30, 'media/landlord/39/Image_1254472867.jpg'),
(54, '2018-02-22 14:43:13', '2018-02-22 14:43:13', 1, 30, 'media/landlord/39/Image_1164455508.jpg'),
(55, '2018-02-22 14:43:13', '2018-02-22 14:43:13', 1, 30, 'media/landlord/39/Image_740119377.jpg'),
(56, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 1, 35, 'media/landlord/39/Image_1353298215.jpg'),
(57, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 1, 35, 'media/landlord/39/Image_1899675512.jpg'),
(58, '2018-02-27 20:27:18', '2018-02-27 20:27:18', 1, 35, 'media/landlord/39/Image_540085942.jpg'),
(59, '2018-02-27 21:29:05', '2018-02-27 21:29:05', 1, 36, 'media/landlord/9/Image_32655010.jpg'),
(60, '2018-02-27 21:29:05', '2018-02-27 21:29:05', 1, 36, 'media/landlord/9/Image_1913882586.jpg'),
(61, '2018-02-27 21:29:05', '2018-02-27 21:29:05', 1, 36, 'media/landlord/9/Image_883334142.jpg'),
(62, '2018-02-28 14:39:09', '2018-02-28 14:39:09', 1, 37, 'media/landlord/39/Image_1436359702.jpg'),
(63, '2018-02-28 14:39:09', '2018-02-28 14:39:09', 1, 37, 'media/landlord/39/Image_1823919119.jpg'),
(64, '2018-02-28 14:39:09', '2018-02-28 14:39:09', 1, 37, 'media/landlord/39/Image_733106453.jpg'),
(65, '2018-02-28 14:47:20', '2018-02-28 14:47:20', 1, 38, 'media/landlord/39/Image_41136582.jpg'),
(66, '2018-02-28 14:47:20', '2018-02-28 14:47:20', 1, 38, 'media/landlord/39/Image_930014621.jpg'),
(67, '2018-02-28 14:47:20', '2018-02-28 14:47:20', 1, 38, 'media/landlord/39/Image_631523864.jpg'),
(68, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 1, 39, 'media/landlord/25/Image_822336899.jpg'),
(69, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 1, 39, 'media/landlord/25/Image_566262436.jpg'),
(70, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 1, 39, 'media/landlord/25/Image_1343756746.jpg'),
(71, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 1, 40, 'media/landlord/47/Image_609124474.jpg'),
(72, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 1, 40, 'media/landlord/47/Image_16015886.jpg'),
(73, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 1, 40, 'media/landlord/47/Image_1485196544.jpg'),
(74, '2018-03-04 16:35:51', '2018-03-04 16:35:51', 1, 41, 'media/landlord/9/Image_2073488048.jpg'),
(75, '2018-03-04 16:35:51', '2018-03-04 16:35:51', 1, 41, 'media/landlord/9/Image_1362284236.jpg'),
(76, '2018-03-04 16:35:51', '2018-03-04 16:35:51', 1, 41, 'media/landlord/9/Image_1181105113.jpg'),
(77, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 1, 42, 'media/landlord/39/Image_12394826.jpg'),
(78, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 1, 42, 'media/landlord/39/Image_1379905803.jpg'),
(79, '2018-03-05 14:56:37', '2018-03-05 14:56:37', 1, 42, 'media/landlord/39/Image_238662849.jpg'),
(80, '2018-03-07 03:57:11', '2018-03-07 03:57:11', 1, 43, 'media/landlord/22/Image_1394312377.jpg'),
(81, '2018-03-07 03:57:11', '2018-03-07 03:57:11', 1, 43, 'media/landlord/22/Image_1276374176.jpg'),
(82, '2018-03-07 03:57:11', '2018-03-07 03:57:11', 1, 43, 'media/landlord/22/Image_577944050.jpg'),
(83, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 1, 44, 'media/landlord/22/Image_1542323551.jpg'),
(84, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 1, 44, 'media/landlord/22/Image_1579086381.jpg'),
(85, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 1, 44, 'media/landlord/22/Image_1410289829.jpg'),
(86, '2018-03-07 07:57:39', '2018-03-07 07:57:39', 1, 45, 'media/landlord/22/Image_251808572.jpg'),
(87, '2018-03-07 07:57:39', '2018-03-07 07:57:39', 1, 45, 'media/landlord/22/Image_719393983.jpg'),
(88, '2018-03-07 07:57:39', '2018-03-07 07:57:39', 1, 45, 'media/landlord/22/Image_1076716521.jpg'),
(89, '2018-03-07 07:58:17', '2018-03-07 07:58:17', 1, 46, 'media/landlord/22/Image_1026959639.jpg'),
(90, '2018-03-07 07:58:17', '2018-03-07 07:58:17', 1, 46, 'media/landlord/22/Image_568955912.jpg'),
(91, '2018-03-07 07:58:17', '2018-03-07 07:58:17', 1, 46, 'media/landlord/22/Image_1891400015.jpg'),
(92, '2018-03-07 07:58:24', '2018-03-07 07:58:24', 1, 47, 'media/landlord/22/Image_1155098267.jpg'),
(93, '2018-03-07 07:58:24', '2018-03-07 07:58:24', 1, 47, 'media/landlord/22/Image_28732106.jpg'),
(94, '2018-03-07 07:58:24', '2018-03-07 07:58:24', 1, 47, 'media/landlord/22/Image_1879239901.jpg'),
(97, '2018-03-08 07:31:24', '2018-03-08 07:31:24', 1, 48, 'media/landlord/22/Image_1116951520.jpg'),
(98, '2018-03-08 07:31:24', '2018-03-08 07:31:24', 1, 48, 'media/landlord/22/Image_1315028149.jpg'),
(99, '2018-03-08 07:31:24', '2018-03-08 07:31:24', 1, 48, 'media/landlord/22/Image_1718254865.jpg'),
(100, '2018-03-08 08:29:20', '2018-03-08 08:29:20', 1, 49, 'media/landlord/22/Image_1115484931.jpg'),
(101, '2018-03-08 08:29:20', '2018-03-08 08:29:20', 1, 49, 'media/landlord/22/Image_1924902314.jpg'),
(102, '2018-03-08 08:29:20', '2018-03-08 08:29:20', 1, 49, 'media/landlord/22/Image_481545518.jpg'),
(103, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 1, 50, 'media/landlord/22/Image_1059828134.jpg'),
(104, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 1, 50, 'media/landlord/22/Image_1545144153.jpg'),
(105, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 1, 50, 'media/landlord/22/Image_1813097270.jpg'),
(115, '2018-03-12 06:28:46', '2018-03-12 06:28:46', 0, 11, 'media/landlord/22/Image_58188800.jpg'),
(120, '2018-03-12 06:32:51', '2018-03-12 06:32:51', 1, 11, 'media/landlord/22/Image_2023506364.jpg'),
(125, '2018-03-12 07:38:06', '2018-03-12 07:38:06', 1, 11, 'media/landlord/22/Image_1616474505.jpg'),
(126, '2018-03-12 07:38:06', '2018-03-12 07:38:06', 1, 11, 'media/landlord/22/Image_1565580094.jpg'),
(177, '2018-03-13 02:24:32', '2018-03-13 02:24:32', 1, 51, 'media/landlord/22/51/Image_674434475.jpg'),
(178, '2018-03-13 02:24:32', '2018-03-13 02:24:32', 1, 51, 'media/landlord/22/51/Image_1850925666.jpg'),
(180, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 1, 52, 'media/landlord/22/52/Image_176677691.jpg'),
(181, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 1, 52, 'media/landlord/22/52/Image_1914731121.jpg'),
(182, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 1, 52, 'media/landlord/22/52/Image_828225238.jpg'),
(183, '2018-03-13 02:27:58', '2018-03-13 02:27:58', 1, 52, 'media/landlord/22/52/Image_2078313180.jpg'),
(184, '2018-04-30 03:53:01', '2018-04-30 03:53:01', 1, 53, 'media/landlord/22/53/Image_1530988446.jpg'),
(185, '2018-04-30 03:53:01', '2018-04-30 03:53:01', 1, 53, 'media/landlord/22/53/Image_1208362616.jpg'),
(186, '2018-04-30 03:53:01', '2018-04-30 03:53:01', 1, 53, 'media/landlord/22/53/Image_906050436.jpg'),
(187, '2018-04-30 04:46:54', '2018-04-30 04:46:54', 1, 53, 'media/landlord/22/53/Image_1754702405.jpg'),
(188, '2018-04-30 04:46:54', '2018-04-30 04:46:54', 1, 53, 'media/landlord/22/53/Image_2024845161.jpg'),
(189, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 1, 54, 'media/landlord/22/54/Image_839590638.jpg'),
(190, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 1, 54, 'media/landlord/22/54/Image_1439480855.jpg'),
(191, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 1, 54, 'media/landlord/22/54/Image_1495768171.jpg'),
(192, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 1, 55, 'media/landlord/22/55/Image_1946057941.jpg'),
(193, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 1, 55, 'media/landlord/22/55/Image_117517678.jpg'),
(194, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 1, 55, 'media/landlord/22/55/Image_1275653368.jpg'),
(195, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 1, 56, 'media/landlord/22/56/Image_1852419309.jpg'),
(196, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 1, 56, 'media/landlord/22/56/Image_761621941.jpg'),
(197, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 1, 56, 'media/landlord/22/56/Image_642094541.jpg'),
(198, '2018-05-03 04:02:45', '2018-05-03 04:02:45', 1, 57, 'media/landlord/22/57/Image_431805508.jpg'),
(199, '2018-05-03 04:02:45', '2018-05-03 04:02:45', 1, 57, 'media/landlord/22/57/Image_1634282243.jpg'),
(200, '2018-05-03 04:02:45', '2018-05-03 04:02:45', 1, 57, 'media/landlord/22/57/Image_1333600784.jpg'),
(201, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 1, 58, 'media/landlord/22/58/Image_1274062199.jpg'),
(202, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 1, 58, 'media/landlord/22/58/Image_926457357.jpg'),
(203, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 1, 58, 'media/landlord/22/58/Image_1163825310.jpg');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(67, '2017_11_18_112919_create_property_table', 1),
(68, '2017_11_18_113013_create_amenities_table', 1),
(69, '2017_11_18_115541_create_amenity_property_table', 1),
(70, '2017_11_18_115701_create_amenity_status_table', 1),
(71, '2017_11_18_121357_create_property_status_table', 1),
(72, '2017_11_18_145903_create_policy_types', 1),
(73, '2017_11_18_145925_create_policies', 1),
(74, '2017_11_19_175409_create_app_code_categories', 1),
(75, '2017_11_19_181338_create_app_codes', 1),
(76, '2017_11_19_181612_create_app_code_statuses', 1),
(77, '2017_11_20_085637_create_users_table', 1),
(78, '2017_11_20_091213_create_user_types_table', 1),
(79, '2017_11_21_092831_create_medias_table', 1),
(80, '2017_11_24_140631_create_bidding_table', 1),
(81, '2017_11_25_122451_update_bidding_table', 1),
(82, '2017_11_25_130941_update_bidding_priority_id_table', 1),
(83, '2017_12_06_083143_create_transactions_table', 2),
(84, '2017_12_06_084927_create_payment_statuses_table', 3),
(85, '2017_12_07_085043_create_sms_reports_table', 4),
(87, '2017_12_07_131727_update_users_table', 5),
(88, '2017_12_08_143740_create_notifications_table', 6),
(89, '2017_12_11_110128_update_properties_table', 7),
(90, '2017_12_11_134113_update_users_table', 8),
(91, '2017_12_11_134646_alter_users_table', 9),
(92, '2017_12_11_140501_update_bidding_table', 10),
(93, '2017_12_12_151447_update_users_table', 11),
(94, '2017_12_13_160420_create_supports_table', 12),
(95, '2017_12_13_161028_update_supports_table', 13),
(96, '2017_12_14_100521_create_contracts_table', 14),
(97, '2017_12_14_135547_alter_biddings_table', 15),
(98, '2017_12_19_100433_alter_properties_table', 16),
(99, '2017_12_21_092501_create_surveys_table', 17),
(100, '2017_12_27_093027_alter_transactions_table', 18),
(101, '2017_12_27_150249_create_user_logins_table', 19),
(102, '2018_03_06_143129_update_tenancy_contracts_table', 20),
(103, '2018_03_06_145621_update_biddings_table', 21),
(104, '2018_03_07_100212_update_biddings_table', 22),
(105, '2018_03_09_093415_update_table_tenancy_contract', 23),
(106, '2018_03_12_155646_create_notifications_table', 24),
(107, '2018_03_13_125132_update_notifications_table', 25),
(108, '2018_04_30_075603_alter_properties_table', 26);

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bid_id` int(11) NOT NULL,
  `landlord_id` int(11) NOT NULL,
  `visibility_id` int(11) NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notes`
--

INSERT INTO `notes` (`id`, `created_at`, `updated_at`, `bid_id`, `landlord_id`, `visibility_id`, `content`) VALUES
(1, '2018-02-02 15:41:19', '2018-02-02 15:41:19', 1, 22, 41, 'You can shift from 9 feb'),
(2, '2018-02-02 15:41:38', '2018-02-02 15:41:38', 2, 22, 41, 'Thanks for  you interest'),
(3, '2018-02-02 16:14:02', '2018-02-02 16:14:02', 3, 25, 41, 'You can proceed further.'),
(4, '2018-02-02 16:14:27', '2018-02-02 16:14:27', 3, 25, 41, 'And now make the payment.'),
(5, '2018-02-02 16:35:33', '2018-02-02 16:35:33', 4, 25, 41, 'Make the payment as early as possible.'),
(6, '2018-02-02 16:35:55', '2018-02-02 16:35:55', 4, 25, 41, 'Your property is selected now.'),
(7, '2018-02-02 16:36:38', '2018-02-02 16:36:38', 4, 25, 42, 'Payment will be made today'),
(8, '2018-02-03 20:19:42', '2018-02-03 20:19:42', 6, 32, 41, 'door is open so anytime is possible'),
(9, '2018-02-03 20:20:18', '2018-02-03 20:20:18', 6, 32, 42, 'anytime is possible'),
(10, '2018-02-03 20:24:31', '2018-02-03 20:24:31', 5, 32, 41, '2 cheques possible only'),
(11, '2018-02-03 20:24:33', '2018-02-03 20:24:33', 5, 32, 41, '2 cheques possible only'),
(12, '2018-02-06 13:37:34', '2018-02-06 13:37:34', 9, 25, 41, 'I am selecting the property for payment'),
(13, '2018-02-06 13:37:55', '2018-02-06 13:37:55', 9, 25, 41, 'Now you can make the payment'),
(14, '2018-02-06 17:46:29', '2018-02-06 17:46:29', 6, 32, 42, 'door is open any time between 9 and 5pm'),
(15, '2018-02-15 19:46:56', '2018-02-15 19:46:56', 15, 25, 41, 'You have to pay 10 % of the amount Now.'),
(16, '2018-02-16 15:57:40', '2018-02-16 15:57:40', 16, 25, 41, 'Please do Payment asap'),
(17, '2018-02-16 16:00:23', '2018-02-16 16:00:23', 16, 25, 41, 'You had take too time, If you are interested then do payment as soon as possible.   \r\n\r\nSending emails to your boss, your colleagues, potential customers, or anyone else you already do or potentially may do business with is fraught with many potential hazards making it a veritable minefield of professional decorum, with each inappropriate joke and incorrectly capitalized letter an invitation to disaster. Emailing is incredibly convenient and should not be seen as something that may anger someone or something to avoid but rather as an invaluable communication tool used to accomplish the goals of the company and its workers.\r\n\r\nBelow, we will discuss the various pitfalls people succumb to when emailing in a business environment and how to avoid them. From the subject line to the closing, after reading this article along with this email etiquette course, you should be ready to fire off email after email like it’s your job… because it is.'),
(18, '2018-02-19 20:49:05', '2018-02-19 20:49:05', 19, 39, 41, 'complete as soon as possible and ready your document'),
(19, '2018-03-04 16:31:36', '2018-03-04 16:31:36', 31, 9, 41, 'test'),
(20, '2018-03-04 16:31:37', '2018-03-04 16:31:37', 31, 9, 41, 'test');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` int(10) UNSIGNED NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type_id` int(11) DEFAULT NULL COMMENT '1=>Bid, 2=>Contract, 3=>Property'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_id`, `notifiable_type`, `data`, `read_at`, `created_at`, `updated_at`, `type_id`) VALUES
('083e2486-2bcd-4dd1-8cf5-6181b28d40ca', 'App\\Notifications\\PostNewNotification', 35, 'App\\Models\\User', '{\"bid_id\":\"39\",\"property_id\":\"\",\"contract_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\",\"type_id\":\"1\"}', NULL, '2018-04-30 02:13:11', '2018-04-30 02:13:11', 1),
('1c055b60-7679-4932-b6d4-573ba6378181', 'App\\Notifications\\PostNewNotification', 35, 'App\\Models\\User', '{\"bid_id\":\"39\",\"property_id\":\"\",\"contract_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\",\"type_id\":\"1\"}', '2018-04-30 02:13:02', '2018-03-13 08:03:31', '2018-04-30 02:13:02', 3),
('53c4cf0a-886c-4f50-9344-c8b70865910e', 'App\\Notifications\\PostNewNotification', 35, 'App\\Models\\User', '{\"bid_id\":\"40\",\"property_id\":\"\",\"contract_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\",\"type_id\":\"1\"}', NULL, '2018-04-30 04:56:43', '2018-04-30 04:56:43', 1),
('c52d2866-8d92-4b5a-ab86-6a5e37491598', 'App\\Notifications\\PostNewNotification', 35, 'App\\Models\\User', '{\"bid_id\":\"40\",\"property_id\":\"\",\"contract_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\",\"type_id\":\"1\"}', NULL, '2018-04-30 04:56:55', '2018-04-30 04:56:55', 1),
('d12c6363-2dd7-463b-bb5b-90fda685b330', 'App\\Notifications\\PostNewNotification', 22, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"53\",\"contract_id\":\"\",\"message\":\"Nikita Tenant made a bid against your property Property Term Property\",\"type_id\":\"3\"}', NULL, '2018-04-30 04:54:21', '2018-04-30 04:54:21', 3),
('db390d74-954d-408f-b3ef-b27cd966c407', 'App\\Notifications\\PostNewNotification', 22, 'App\\Models\\User', '{\"bid_id\":\"40\",\"property_id\":\"53\",\"contract_id\":\"\",\"message\":\"Nikita Tenant updated a bid against your property Property Term Property\",\"type_id\":\"1\"}', '2018-04-30 04:56:21', '2018-04-30 04:56:02', '2018-04-30 04:56:21', 1),
('ebbfc49d-b8c6-4fa6-9ea3-6abeaeb31af4', 'App\\Notifications\\PostNewNotification', 22, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"51\",\"contract_id\":\"\",\"message\":\"Nikita Tenant made a bid against your property Test image\",\"type_id\":\"3\"}', '2018-03-13 08:03:28', '2018-03-13 08:01:00', '2018-03-13 08:03:28', 1);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `sort_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `title`, `url_key`, `content`, `status`, `sort_order`) VALUES
(1, '2018-02-21 18:30:00', '2018-02-21 18:30:00', 'terms', 'terms', '<p>&nbsp;</p>\r\n    <div class=\"page-title\"><h2><strong>Terms & Conditions</strong></h2></div>\r\n    <h4 class=\"text-center\">WELCOME TO BID2RENT.AE!</h4>\r\n    <h4 class=\"text-center\">PLEASE READ THIS IMPORTANT LEGAL INFORMATION THAT GOVERNS YOUR USE OF THE BID2RENT.AE WEBSITE AND THE SERVICES.</h4>\r\n    <p class=\"text-muted text-center\">Last modified: 30 November 2017</p>\r\n    <p>&nbsp;</p>\r\n\r\n<h4>Introduction</h4>\r\n<p>Bid2Rent.ae FZ LLC (“Bid2Rent.ae”), located in the Fujairah Freezone????????? And operates an online platform for rental properties. (collectively the “Services”) on the Bid2Rent.ae website at www.Bid2Rent.ae and the mobile application of the online platform (collectively the “Website”). Your use of the Website and the Services is governed by these Terms of Service. </p>\r\n\r\n<p>These Terms of Service provide you with information about the terms upon which we agree to provide, permit and allow you to access and use the Website. Please print a copy of these Terms of Service and refer to it as you use our Systems and Services. You agree to be bound by these Terms of Service if you continue using the Website. If you do not agree to these Terms of Service, you must immediately refrain from using the Website and the Services.</p>\r\n\r\n<p>We may make changes to the Terms of Service and will notify you of these changes by changing the date “last modified” above. IF ANY FUTURE CHANGES ARE UNACCEPTABLE TO YOU, YOU SHOULD DISCONTINUE USING THE SYSTEMS AND SERVICES. YOU’RE CONTINUED USE OF THE SYSTEMS AND SERVICES NOW OR FOLLOWING THE POSTING OF ANY SUCH CHANGES WILL INDICATE YOUR ACCEPTANCE OF THESE TERMS AND ANY CHANGES.</p>\r\n\r\n<p>If you are advertising in our Property category, you will be required to enter additional terms and conditions set out in our Advertising Order Form, however, please note that these Terms of Service will still apply and must be read in conjunction with any other agreement you enter with Bid2Rent.ae.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ol class=\"list-of-numbers\">\r\n<li class=\"strong\"><p>Acceptance of these Term of Service</p>\r\n<ol>\r\n<li>The Website and the Service are provided to you subject to these Terms of Service (these \"Terms\"). By accessing the Website or using the Service, you agree that you have read, understood and agree to be bound by these Terms. For the purpose of the Terms and wherever the context so requires, the terms \'you\' and “your” shall mean any person who uses the Website or the Service in any manner whatsoever including persons browsing the Website and its content, posting comments or any content or responding to any advertisements or content on the Website.</li>\r\n<li>By accessing and/or using the Website and/or the Service, you agree to comply with these Terms. Additionally, when using a portion of the Service, you agree to conform to any applicable posted guidelines for such Service, which may change or be updated from time to time at Bid2Rent.ae’s sole discretion.</li>\r\n<li>You are solely responsible for reviewing these Terms from time to time. Should you object to any term or condition of these Terms, any guideline, or any subsequent changes thereto or become unhappy with Bid2Rent.ae or the Service in any way, you must immediately discontinue use of the Website and the Service.</li>\r\n<li>These Terms may be updated by Bid2Rent.ae at any time at its sole discretion. It is your responsibility to keep a copy of these Terms and check the date “last modified” at the top of this page.</li>\r\n<li>Bid2Rent.ae may provide a translation of the English version of the Terms into other languages. Any translation of the Terms into other languages is for your convenience only and the English version governs the terms of your relationship with Bid2Rent.ae. Furthermore, if there are any inconsistencies between the English version of the Terms and any translation, the English version of the Terms shall prevail.</li>\r\n<li>The term \"affiliates\" as referred to in Sections 10 and 20 of these Terms means: any company controlled or owned by Bid2Rent.ae; any company commonly controlled or owned with Bid2Rent.ae; or any group entity jointly offering the Service.</li>\r\n</ol>\r\n</li>\r\n<li class=\"strong\"><p>Description of Service and Content Policy</p>\r\n<ol>\r\n<li>This Section 2 has important legal consequences for you. In this section: - the legal responsibilities and liabilities of Bid2Rent.ae are excluded or limited; - you take on risk, responsibilities and liability; and - any rights you have against Bid2Rent.ae are limited or excluded. The statements made in this section constitute acknowledgements of fact by you. You must read these statements carefully and ensure they are correct, as you will not be able to deny the truth of the statements. Bid2Rent.ae and/or other persons may have claims and other rights against you as a result of these statements.</li>\r\n<li>Bid2Rent.ae is a platform to allow our users who comply with these Terms to offer, bid on and enter into agreements for properties listed on the Website. Although you may be able to conduct payment and other transactions through the Website, using third-party vendors, Bid2Rent.ae is not in any way involved in such transactions. As a result, and as discussed in more detail in these Terms, you hereby acknowledge and agree that Bid2Rent.ae is not a party to such transactions, has no control over any element of such transactions, and, as far as the law allows, shall have no liability towards any party in connection with such transactions. As far as the law allows, you use the Service and the Website at your sole risk and responsibility.</li>\r\n<li>You understand that Bid2Rent.ae is not responsible for ads, directory information, business listings/information, messages between users, including without limitation e-mails or chats or other means of electronic communication, whether through the Website or another Third Party Website (defined below) or offerings, comments, user postings, files, images, photos, video, sounds, business listings/information and directory information or any other material made available through the Website and the Service (\"Content\"), and that by using the Website and the Service, you may be exposed to Content that is offensive, indecent, inaccurate, misleading, or otherwise objectionable. As far as the law allows, you are responsible for and must evaluate, and bear all risks associated with, the use of any Content. You may not rely on said Content, and under no circumstances will Bid2Rent.ae be liable in any way for the Content or for any loss or damage of any kind incurred as a result of the browsing, using or reading any Content listed, e-mailed or otherwise made available via the Service. Bid2Rent.ae is not obliged to pre-screen or approve any Content, but Bid2Rent.ae has the right, in its sole and absolute discretion, to refuse, delete or move any Content that is or may be available through the Service, for violating these Terms and such violation being brought to Bid2Rent.ae’s knowledge or for any other reason or no reason at all. Furthermore, the Website and Content available through the Website may contain links to other third party websites (\"Third Party Websites\"), which are completely unrelated to Bid2Rent.ae. If you link to Third Party Websites, you may be subject to those Third Party Websites’ terms and conditions and other policies. As far as the law allows, Bid2Rent.ae makes no representation or guarantee as to the accuracy or authenticity of the information contained in any such Third Party Websites, and your linking to any other websites is, as far as the law allows, completely at your own risk and Bid2Rent.ae disclaims all liability thereto.</li>\r\n<li>You are solely responsible for your own Content posted on, transmitted through, or linked from the Service and the consequences of posting, transmitting, linking or publishing it. More specifically, you are solely responsible for all Content that you upload, email or otherwise make available via the Service. In connection with such Content posted on, transmitted through, or linked from the Service by you, you affirm, acknowledge, represent, warrant and covenant that:<br/><br/> \r\n(i) you own or have and shall continue to, for such time the Content is available on the Website, have the necessary licenses, rights, consents, and permissions to use such Content on the Service and Website (including without limitation all patent, trademark, trade secret, copyright or other proprietary rights in and to any and all such Content) and authorize Bid2Rent.ae to use such Content to enable inclusion and use of the Content in the manner contemplated by the Service, the Website and these Terms; and <br/><br/>\r\n(ii) you have the written consent, release, and/or permission of each and every identifiable individual person or business in the Content to use the name or likeness of each and every such identifiable individual person or business to enable inclusion and use of the Content in the manner contemplated by the Service, the Website and these Terms. For clarity, you retain all of your ownership rights in your Content; however, by submitting any Content on the Website, you hereby grant to Bid2Rent.ae an irrevocable, non-cancellable, perpetual, worldwide, non-exclusive, royalty-free, sub-licensable, transferable license to use, reproduce, distribute, prepare derivative works of, display, and perform the Content in connection with the Website and Bid2Rent.ae\'s (and its successors\') business, including without limitation for the purpose of promoting and redistributing part or all of the Website and Content therein (and derivative works thereof) in any media formats and through any media channels now or hereafter known. These rights are required by Bid2Rent.ae in order to host and display your Content. Furthermore, by you posting Content to any public area of the Service, you agree to and do hereby grant to Bid2Rent.ae all rights necessary to prohibit or allow any subsequent aggregation, display, copying, duplication, reproduction, or exploitation of the Content on the Service or Website by any party for any purpose which contravenes these Terms. These rights are perpetual and cannot be revoked by you and will apply and can be exercised throughout the world. You also hereby grant each user of the Website a non-exclusive license to access your Content through the Website (this license excludes automated data collection/scraping cases and any other possible use with commercial purposes). The foregoing license to each user granted by you terminates once you or Bid2Rent.ae remove or delete such Content from the Website.</li>\r\n<li>Bid2Rent.ae does not endorse any Content or any opinion, statement, recommendation, or advice expressed therein, and, as far as the law allows, Bid2Rent.ae expressly disclaims any and all liability in connection with user Content. Bid2Rent.ae does not permit copyright infringing activities and infringement of intellectual property rights on the Website, and Bid2Rent.ae may, at its sole discretion, remove any infringing Content. Bid2Rent.ae reserves the right to remove any Content without prior notice. Bid2Rent.ae may also terminate a user\'s access to the Website. Further, at its sole discretion, Bid2Rent.ae reserves the right to decide whether any Content is appropriate and complies with these Terms.</li>\r\n</ol>\r\n</li>\r\n<li class=\"strong\"><p>Featured Ads</p>\r\n<ol>\r\n<li>Bid2Rent.ae offers a service known as \"Featured Ads\" where users may pay a non-refundable fee to have their ads posted in selected locations on the Website, thus potentially increasing an ads\' visibility. In order to purchase a Featured Ad, you may be required to transmit certain information through a third party service provider, Click & Buy, a Third Party Website, that may be governed by its own terms of use and other policies. Bid2Rent.ae makes no representation or guarantee as to the safety or security of the information transmitted to any Third Party Website, and your linking to any Third Party Website is completely at your own risk, and Bid2Rent.ae disclaims all liability related thereto.</li>\r\n</ol>\r\n</li>\r\n</li>\r\n<li class=\"strong\"><p>Conduct</p>\r\n<p class=\"nostrong\">You agree not to post, email, host, display, upload, modify, publish, transmit, update or share any information on the Site, or otherwise make available Content:</p>\r\n<ol>\r\n<li>that violates any law or regulation;</li>\r\n<li>that is copyrighted or patented, protected by trade secret or trademark, or otherwise subject to third party proprietary rights, including privacy and publicity rights, unless you are the owner of such rights or have permission or a license from their rightful owner to post the material and to grant Bid2Rent.ae all of the license rights granted herein;</li>\r\n<li>that infringes any of the foregoing intellectual property rights of any party, or is Content that you do not have a right to make available under any law, regulation, contractual or fiduciary relationship(s);</li>\r\n<li>that is harmful, abusive, unlawful, threatening, harassing, blasphemous, defamatory, obscene, pornographic, paedophilic, libellous, invasive of another\'s privacy or other rights, hateful, or racially, ethnically objectionable, disparaging, relating or encouraging money laundering or illegal gambling or harms or could harm minors in any way or otherwise unlawful in any manner whatsoever;</li>\r\n<li>that harasses, degrades, intimidates or is hateful towards any individual or group of individuals on the basis of religion, gender, sexual orientation, race, ethnicity, age, or disability;</li>\r\n<li>that violates any (local) equal employment laws, including but not limited to those prohibiting the stating, in any advertisement for employment, a preference or requirement based on race, color, religion, sex, national origin, age, or disability of the applicant;</li>\r\n<li>that includes personal or identifying information about another person without that person\'s explicit consent;</li>\r\n<li>that impersonates any person or entity, including, but not limited to, a Bid2Rent.ae employee, or falsely states or otherwise misrepresents an affiliation with a person or entity;</li>\r\n<li>deceives or misleads the addressee about the origin of such messages or communicates any information which is grossly offensive or menacing in nature;</li>\r\n<li>that is false, deceptive, misleading, deceitful, misinformative, or constitutes \"bait and switch\" offer;</li>\r\n<li>that constitutes or contains \"pyramid schemes\", “jokes”, \"affiliate marketing,\" \"link referral code,\" \"junk mail,\" \"spam,\" \"chain letters,\" \"bait marketing\", \"negative option marketing\", \"referral selling\" or unsolicited advertisements of a commercial nature;</li>\r\n<li>that constitutes or contains any form of advertising or solicitation if (i) posted in areas or categories of the Website which are not designated for such purposes; or (ii) e-mailed to Bid2Rent.ae users who have requested not to be contacted about other services, products or commercial interests;</li>\r\n<li>that includes links to commercial services or Third Party Websites, except as specifically allowed by Bid2Rent.ae;</li>\r\n<li>that advertises any illegal services or the sale of any items the sale of which is prohibited or restricted by applicable law, including without limitation items the sale of which is prohibited or regulated by applicable law;</li>\r\n<li>that contains software viruses or any other computer code, files or programs designed to interrupt, destroy or limit the functionality of any computer software or hardware or telecommunications equipment or any other computer resource;</li>\r\n<li>that disrupts the normal flow of dialogue with an excessive number of messages (flooding attack) to the Service, or that otherwise negatively affects other users\' ability to use the Service; or</li>\r\n<li>that employs misleading email addresses, or forged headers or otherwise manipulated identifiers in order to disguise the origin of Content transmitted through the Service.</li>\r\n<p class=\"strong\">Additionally, you agree not to:</p>\r\n<li>contact anyone who has asked not to be contacted, or make unsolicited contact with anyone for any commercial purpose, specifically, contact any user to post advertisement on a third party Website or post any advertisement on behalf of such user; or to \"stalk\" or otherwise harass anyone;</li>\r\n<li>make any libelous or defamatory comments or postings to or against anyone;</li>\r\n<li>collect personal data about other users or entities for commercial or unlawful purposes;</li>\r\n<li>use automated means, including spiders, robots, crawlers, data mining tools, or the like to download or scrape data from the Service, except for internet search engines (e.g,. Google) and non-commercial public archives (e.g. archive.org) that comply with our robots.txt file;</li>\r\n<li>post Content that is outside the local area or not relevant to the local area, repeatedly post the same or similar Content, or otherwise impose unreasonable or disproportionately large loads on our servers and other infrastructure;</li>\r\n<li>post the same item or service in multiple classified categories or forums, or in multiple metropolitan areas;</li>\r\n<li>attempt to gain unauthorized access to computer systems owned or controlled by Bid2Rent.ae or engage in any activity that disrupts, diminishes the quality of, interferes with the performance of, or impairs the functionality of, the Service or the Website;</li>\r\n<li>use any form of automated device or computer program (sometimes referred to as \"flagging tools\") that enables the use of Bid2Rent.ae\'s \"flagging system\" or other community control systems without each flag being manually entered by a human that initiates the flag (an \"automated flagging device\"), or use any such flagging tool to remove posts of competitors, other third parties or to remove posts without a reasonable good faith belief that the post being flagged violates these Terms or any applicable law or regulation; or</li>\r\n<li>use any automated device or software that enables the submission of automatic postings on Bid2Rent.ae without human intervention or authorship (an \"automated posting device\"), including without limitation, the use of any such automated posting device in connection with bulk postings, or for automatic submission of postings at certain times or intervals.</li>\r\n<li>Any Content uploaded by you shall be subject to relevant laws and may disabled, or and may be subject to investigation under appropriate laws. Furthermore, if you are found to be in non-compliance with the laws and regulations, these terms, or the privacy policy of the Site, we may terminate your account/block your access to the Site and we reserve the right to remove any non-compliant Content uploaded by you.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Paid Postings</p>\r\n<ol>\r\n<li>Bid2Rent.ae may charge a fee to post Content in some specific areas of the Service (Paid Content). The fee permits Paid Content to be posted in a designated area of the Website. Each party posting Paid Content to the Service is responsible for the Content and compliance with the Terms. Any such fees paid hereunder are non-refundable in the event any Content is removed from the Service for violating these Terms. Additional terms regarding Paid Content will be fully stated in the applicable section(s).</li>\r\n<li>All property ads that announce several properties in one ad will be deleted after 24h of their posting and no refund will be given. Within the first 24h of the posting, the user can edit the multiple-property ad to reduce it to one property. If the ad does not get edited to fulfill Bid2Rent.ae\'s requirements, the ad will be deleted and no refund given.</li>\r\n</ol>\r\n</li>\r\n<li class=\"strong\"><p>Posting Agents</p>\r\n<ol>\r\n<li>As used herein, the term \"Posting Agent\" refers to a third-party agent, service or intermediary that offers to post Content to the Service on behalf of others. Bid2Rent.ae prohibits the use of Posting Agents, directly or indirectly, without the express written permission of Bid2Rent.ae. In addition, Posting Agents are not permitted to post Content on behalf of others, directly or indirectly, or otherwise access the Service in order to post Content on behalf of others, except with express written permission or license from Bid2Rent.ae.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Access to the Service</p>\r\n<ol>\r\n<li>Bid2Rent.ae grants you a limited, revocable, non-exclusive license to access and use the Service for personal use. This license granted herein does not include any of the following: (a) access to or use of the Service by Posting Agents; or (b) any collection, aggregation, copying, duplication, display or derivative use of the Service nor any use of data mining, robots, spiders, or similar data gathering and extraction tools for any purpose unless expressly permitted by Bid2Rent.ae or as otherwise set forth in these Terms. Notwithstanding the foregoing, general purpose internet search engines and non-commercial public archives that gather information for the sole purpose of displaying hyperlinks to the Service, provided they each do so from a stable IP address or range of IP addresses using an easily identifiable agent and comply with our robots.txt file, may engage in the activities set forth in (b). For purposes of this exception, a \"general purpose internet search engine\" does not include a website or search engine or other service that specializes in classified listings including any subset of classifieds listings such as housing, for sale, jobs, services, or personals, or which otherwise provides classified ad listing services. The license set forth in this Section permits you to display on your website, or create a hyperlink thereto, individual postings on the Service so long as such use is for non-commercial and/or news reporting purposes only (e.g., for use in personal blogs or other personal online media). Bid2Rent.ae may limit the amount of postings displayed on or linked to your website. Use of the Service beyond the scope of authorized access as set forth in these Terms immediately terminates any permission or license granted herein. In order to collect, aggregate, copy, duplicate, display or make derivative use of the Service or any Content made available via the Service for other purposes (including commercial purposes) not stated herein, you must first obtain a license from Bid2Rent.ae.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Notification of Claims of Infringements</p>\r\n<ol>\r\n<li><p>If you are an owner of intellectual property rights or an agent who is fully authorised to act on behalf of the owner of intellectual property rights and believe that any Content or other content infringes upon your intellectual property right or intellectual property right of the owner on whose behalf you are authorised to act, you may submit a notification to Bid2Rent.ae together with a request to Bid2Rent.ae to delete the relevant Content in good faith. The notification and the request must contain the following information:</p>\r\n<ol>\r\n<li>A physical or electronic signature of a person authorized to act on behalf of the owner of an exclusive right that is allegedly infringed;</li>\r\n<li>Identification of the intellectual property rights claimed to have been infringed, or, if multiple intellectual property rights at a single online site are covered by a single notification, a representative list of such works at that site;</li>\r\n<li>Identification of the Content (by means of data or communication link, etc.) that is claimed to be infringing or to be the subject of infringing activity and that is to be removed or access to which is to be disabled and information reasonably sufficient to permit Bid2Rent.ae to locate the material;</li>\r\n<li>Information reasonably sufficient to permit Bid2Rent.ae to contact you, such as an address, telephone number, and an electronic mail address;</li>\r\n<li>A signed statement that you have a good faith belief that use of the material in the manner complained of is not authorized by the intellectual property right-owner, its agent, or the law;</li>\r\n<li>A signed statement that the intellectual property-owner hold Bid2Rent.ae harmless from any claim of any third party in connection with the removing by Bid2Rent.ae of the relevant content; and</li>\r\n<li>A signed statement that the information in the notification is accurate and under penalty of perjury that you are authorized to act on behalf of the owner of an exclusive right that is allegedly infringed.</li>\r\n<p>Notifications must be sent to: legal@Bid2Rent.ae </p>\r\n</ol>\r\n</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Intellectual Property Rights</p>\r\n<ol>\r\n<li>The materials on the Website, other than the user Content that you licensed under these Terms, including without limitation, the text, software, scripts, graphics, photos, sounds, music, videos, interactive features and the like (\"Materials\") and the trademarks, service marks and logos contained therein (\"Marks\"), are owned by or licensed to Bid2Rent.ae, and are subject to copyright and other intellectual property rights under United Arab Emirates and foreign laws and international conventions. In connection with the Services, the Website may display certain intellectual property goods belonging to third parties. Use of these goods may be subject to license granted by third parties to Bid2Rent.ae. You shall, in no event, reverse engineer, decompile, or disassemble such goods and nothing herein shall be construed to grant you any right in relation to such goods. Materials on the Website are provided to you AS IS for your information and personal use only and may not be used, copied, reproduced, distributed, transmitted, broadcast, displayed, sold, licensed, or otherwise exploited for any other purposes whatsoever without the prior written consent of the respective owners. Bid2Rent.ae reserves all rights not expressly granted herein to the Website and the Materials. You agree to not engage in the use, copying, or distribution of any of the Materials other than as expressly permitted herein, including any use, copying, or distribution of Materials of third parties obtained through the Website for any commercial purposes. . You agree not to circumvent, disable or otherwise interfere with security related features of the Website or features that prevent or restrict use or copying of any Materials or enforce limitations on use of the Website or the Materials therein. Content displayed on or through the Service is protected by copyright as a collective work and/or compilation, pursuant to copyrights laws, other laws, and international conventions. Any reproduction, modification, creation of derivative works from or redistribution of the Website, the Materials, or the collective work or compilation is expressly prohibited. Copying or reproducing the Website, the Materials, or any portion thereof for further reproduction or redistribution is expressly prohibited.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>User Submissions</p>\r\n<ol>\r\n<li>This Section 10 has important legal consequences for you. In this section: - the legal responsibilities and liability of Bid2Rent.ae are limited or excluded; - the rights or remedies you may have against Bid2Rent.ae are limited or excluded; and - you take on risk, responsibilities and liability. You accept that various things can go wrong when using the Website and/or the Service, and/or when viewing and/or using the Content. You take on the responsibility and liability of these events happening and will have no claim against Bid2Rent.ae if they happen. When using the Website, you will be exposed to Content from a variety of sources, and that, as far as the law allows, Bid2Rent.ae is not responsible for the accuracy, usefulness, safety, or intellectual property rights of or relating to such Content, and you agree and assume all liability for your use. You further may be exposed to Content that is inaccurate, offensive, indecent, objectionable, defamatory or libelous and, as far as the law allows, and subject to Section 19, you agree to waive, and hereby do waive, any legal or equitable rights or remedies you have or may have against Bid2Rent.ae with respect thereto.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Indemnity</p>\r\n<ol>\r\n<li>This Section 11 has important legal consequences for you. In this section: - the legal responsibilities and liability of Bid2Rent.ae are limited or excluded; - the rights or remedies you may have against Bid2Rent.ae are limited or excluded; and - you take on risk, responsibilities and liability. - you indemnify Bid2Rent.ae and other persons against liability and claims.As far as the law allows, and subject to Section 19, you agree to defend, indemnify and hold harmless Bid2Rent.ae, its officers, subsidiaries, affiliates, successors, assigns, directors, officers, agents, service providers, suppliers and employees, from and against any and all claims, damages, obligations, losses (whether direct, indirect or consequential),, liabilities, costs or debt, and expenses (including but not limited to attorneys\' fees) arising from: (i) your violation of any provision of these Terms; (ii) your violation of any third party right, including without limitation any copyright, trademark, trade secret or other property, or privacy right; or (iii) any claim that your Content caused damage to a third party. As far as the law allows, and subject to Section 19, this defence and indemnification obligation will survive termination, modification or expiration of these Terms and your use of the Service and the Website.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>No Spam Policy</p>\r\n<ol>\r\n<li>This Section 12 has important legal consequences for you. In this section you take on risk, responsibilities and liability. This may result in you being punished under applicable criminal laws, and/or you becoming financially liable to Bid2Rent.ae and/or other persons for additional amounts. You understand and agree that sending unsolicited email advertisements or other unsolicited communications to Bid2Rent.ae email addresses or through Bid2Rent.ae computer systems are expressly prohibited by these Terms. You acknowledge and agree that from time to time Bid2Rent.ae may monitor email usage using human monitors or automated software to flag certain words associated with spam or scams in emails that are sent between one users to another in the Bid2Rent.ae e-mail system. Any communication between yourself and any other user utilizing the communication features available on the Service and the Website may be used only in accordance with the Terms. Any unauthorized use of Bid2Rent.ae computer systems is a violation of these Terms and certain applicable laws, in particular the UAE Cybercrimes legislation. Such violations may subject the sender and his or her agents to civil and criminal penalties. Please note that the UAE Cybercrimes legislation carries significant penalties including imprisonment. In case you intend to solicit, or contact our users by obtaining their email or phone numbers from our Website, we may report this behavior to the relevant authorities, who then may decide to prosecute you under the relevant UAE laws.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Dealings with Organizations and Individuals</p>\r\n<ol>\r\n<li>This Section 13 has important legal consequences for you. In this section: - the legal responsibilities and liability of Bid2Rent.ae are limited or excluded; - the rights or remedies you may have against Bid2Rent.ae are limited or excluded; and - you take on risk, responsibilities and liability. As far as the law allows, and subject to Section 19, Bid2Rent.ae shall not be liable for your interactions with any organizations and/or individuals on the Website or through the Service. This includes, but is not limited to, payment and delivery of goods and services, and any other terms, conditions, warranties or representations associated with any interaction you may have with other organizations and/or individuals. These dealings are solely between you and such organizations and/or individuals. As far as the law allows, and subject to Section 19, Bid2Rent.ae shall not be responsible or liable for any loss or damage of any sort incurred as the result of any such dealings or interactions. In the event that you have a dispute with one or more other users, as far as the law allows, and subject to Section 19, you hereby release Duizzle, its officers, employees, agents and successors from any and all claims, demands and damages (actual and consequential) of every kind or nature, known or unknown, suspected and unsuspected, disclosed and undisclosed, arising out of or in any way related to such disputes and/or our Service.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Limitation and Termination of Service</p>\r\n<ol>\r\n<li>This Section 14 has important legal consequences for you. In this section: - the legal responsibilities and liability of Bid2Rent.ae are limited or excluded; - the rights or remedies you may have against Bid2Rent.ae are limited or excluded; and - you take on risk, responsibilities and liability. Bid2Rent.ae may establish limits from time to time concerning use of the Service, including among others, the maximum number of days that Content will be maintained or retained by the Service, the maximum number and size of postings, e-mail messages, or other Content that may be transmitted or stored by the Service, and the frequency with which you may access the Service or the Website. As far as the law allows and subject to Section 19, Bid2Rent.ae has no responsibility or liability for the deletion or failure to store any Content maintained or transmitted by the Website or the Service. Bid2Rent.ae reserves the right at any time to modify or discontinue the Service (or any part thereof) with or without notice, and that Bid2Rent.ae shall not be liable to you or to any third party for any such modification, suspension or discontinuance of the Service. You acknowledge and agree that Bid2Rent.ae, in its sole and absolute discretion, has the right (but not the obligation) to delete or deactivate your account, block your e-mail or IP address, or otherwise terminate your access to or use of the Service (or any part thereof), immediately and without notice, and remove and discard any Content within the Service, for any reason or no reason at all. Further, as far as the law allows, and subject to Section 19, you agree that Bid2Rent.ae shall not be liable to you or any third-party for any termination of your access to the Website or the Services.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Assignment</p>\r\n<ol>\r\n<li>These Terms, and any rights and licenses granted hereunder, may not be transferred or assigned by you, but may be assigned by Bid2Rent.ae without restriction. Any assignment or transfer by you shall be null and void.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Ability to Accept Terms of Service</p>\r\n<ol>\r\n<li>This Website is intended only for adults and you warrant that you are eligible to contract as per applicable laws. If you are using/accessing this Website as a representative of any person/entity, you acknowledge that you are legally authorized to represent that person/entity. Minors are only allowed to access the Website and use the Service, in the event of approval of their legal representatives or in the event that it concerns an act or a transaction that is usual and acceptable standard in civil life and practice. You affirm that you are either at least 18 years of age, or an emancipated minor, or possess legal parental or guardian consent, and are fully able and competent to enter into the terms, conditions, obligations, affirmations, representations, and warranties set forth in these Terms, and to abide by and comply with these Terms.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>General Information</p>\r\n<ol>\r\n<li>These Terms and the other policies posted on the Website constitute the complete and exclusive understanding and agreement between you and Bid2Rent.ae and govern your use of the Service and the Website superseding all prior understandings, proposals, agreements, negotiations, and discussions between the parties, whether written or oral. The Terms and the relationship between you and Bid2Rent.ae shall be governed by the laws of the United Arab Emirates without regard to its conflict of law principles. We encourage you to contact Bid2Rent.ae to try and settle any claim you may have, however, if we cannot settle the dispute amicably through human negotiation, then the claim or dispute must be submitted to the exclusive jurisdiction of the courts located within the United Arab Emirates. The failure of Bid2Rent.ae to exercise or enforce any right or provision of the Terms shall not constitute a waiver of such right or provision. If any provision of the Terms is found by a court of competent jurisdiction to be invalid (including, without limitation, because such provision is inconsistent with the laws of another jurisdiction) or inapplicable, the parties nevertheless agree that the court should endeavour to give effect to the parties\' intentions as reflected in the provision. If any provision or provisions of these Terms is held to be invalid, illegal or unenforceable, the validity, legality and enforceability of the remaining provisions of the Terms shall not in any way be affected or be impaired. YOU AGREE THAT ANY CAUSE OF ACTION BROUGHT BY YOU AND ARISING OUT OF OR RELATED TO YOUR USE OF THE SERVICE AND/OR THE WEBSITE MUST COMMENCE WITHIN A REASONABLE TIME AND IN ANY EVENT WITHIN ONE (1) YEAR AFTER THE CAUSE OF ACTION ACCRUES. These Terms shall inure to the benefit of and be binding upon each party\'s successors.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Violation of Terms and Liquidated Damages</p>\r\n<ol>\r\n<li>This Section 18 has important legal consequences for you. In this section: - the legal responsibilities and liability of Bid2Rent.ae are limited or excluded; - the rights or remedies you may have against Bid2Rent.ae are limited or excluded; and - you take on risk, responsibilities and liability. This may result in you becoming financially liable to Bid2Rent.ae for additional amounts. The statements made in this section also constitute acknowledgements of fact by you. You must read these statements carefully and ensure they are correct, as you will not be able to deny the truth of the statements. Bid2Rent.ae and/or other persons may have claims and other rights against you as a result of these statements. Please report any violations of the Terms that you become aware of by contacting us using the link at the bottom of the Website\'s homepage at www.Bid2Rent.ae. Any failure to act by Bid2Rent.ae with respect to a breach by you or others does not waive our right to act with respect to subsequent or similar breaches by you or others. </li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Privacy Policy</p>\r\n<ol>\r\n<li>We respect your privacy and have developed a detailed Privacy Policy that is incorporated into these Terms. Please take the time to read our Privacy Policy. By agreeing to these Terms, you are also accepting the terms of our Privacy Policy. You should be aware that when you click certain links on our website or within our app you could be directed to other companies’ properties outside of our hosted environment where the information collected is outside of our direct control. The privacy policy of the third parties’ properties or applications will govern the information obtained from you by these third parties in those contexts.</li>\r\n<p>A. INFORMATION WE COLLECT, RECEIVE AND HOST Account and Profile Information: When you use our Services we may require and use certain information such as a valid email address and password. In addition, users may create a profile that includes information such as their geography, first and last name, gender, phone number, interests and associated information, including photos they may wish to upload. Any information users share in publicly-available profiles is their own responsibility. You should carefully consider the risks of making certain personal information—particularly information such as address or precise location information—publicly available. Where a user has decided to login to our site using a third-party authentication service such as Facebook Connect, we may also receive additional profile or other information authorized by that provider. Listings and Transactions: We may host the information, including personal information and contact information, valid contact information and password necessary to provide our Services. Much of the same information used to create an account or profile may be required to post a listing. Any information users share in listings is their own responsibility. Like with profiles, users should carefully consider the risks of making certain personal information—particularly information such as address or precise location information—publicly available in a listing. Games, Advertising and Promotions: We may collect personal information such as your name and contact information when you participate in games, quizzes or other marketing promotions we sponsor on our site or on third-party sites. We may also process information related to the effectiveness of our advertising campaigns, including what ads are viewed and clicked either on our network or on third-party sites. Customer Care: When you contact our customer care department, we may collect the personal information necessary to fulfil your request and to contact you for follow up as needed. We may also contact you using existing account contact information you provide to us for this purpose. We may also collect other information about our communications with our users, for example any user support requests that our users make or any feedback that our users provide to us. Website and Mobile Data: We may automatically receive and log information on our servers from your browser or device including your IP address, software and hardware attributes, pages that you request, mobile identifiers, information about app usage, and other device or systems-level information. This can occur on our website or mobile app, or on third parties’ services. Appended Information: We may also append information we lawfully obtain from business partners or third parties to existing data we hold about our users. Lead Tracking Services for Bid2Rent.ae real estate brokers: We may monitor and record phone calls regarding users who phone our dedicated du land line numbers in relation to property advertisements on our Website, for the purposes of quality and training for real estate brokers and for verifying to real estate brokers where leads are being generated from. By using the Website you consent and grant permission to Bid2Rent.ae to record telephone calls to real estate brokers advertising on the Website.</p>\r\n<p>B. IP ADDRESS, COOKIES & MOBILE IDENTIFIERS We may collect certain information through technology like cookies, pixels and local storage (like on your browser or device). Cookies are small text files that store information on your computer, mobile phone or other device locally. Pixels are small images that are part of codes on webpages that do things like allow another server to measure viewing of a webpage and often are used in connection with cookies. The code trackers if and when (and on which page) a pixel is loaded to indicate that a user has engaged with a specific screen or portion of a screen. With the help of cookies, the web server can save, for instance, preferences and settings on the user’s computer, mobile phone or other device which are then automatically restored on the next visit. Or to put it another way, the cookies are used, among other things, to make the use of the site more user-friendly so that, for instance, you do not have to repeat the log-in process when you visit again. We use both persistent cookies and session cookies. Whereas persistent cookies remain on your computer for a longer period of time, session cookies are automatically deleted when the browser window is closed. We may allow third parties such as advertising or analytics providers to collect information using these types of technologies directly on our website or from our mobile application. The data that they collect is subject to the applicable privacy policy of those third parties.</p>\r\n<p>C. USE OF THIS INFORMATION To provide our service we may use the information we collect and host for the following general purposes: (i) to provide customer services, including to create and manage user accounts, to resolve technical difficulties and to enable features; (ii) to customize offers and experiences, including advertising on our properties or third parties’ properties; (iii) to monitor general and individual user activity, such as keyword searches, postings and transactional activity, and to manage traffic on the Website; (iv) to contact our users, including for service matters, customer care or permitted marketing communications via any available communications channels; (v) to undertake research initiatives and to perform analytics to improve our services; and (vi) to enforce our Terms of Use including to combat fraud and abuse. We may retain information that we collect and observe on our network only for as long as is required to fulfil the above business objectives.</p>\r\n<p>D. INFORMATION SHARING We may share information we collect with our affiliates (companies under common ownership and control), located in any third country. These companies may only process and use this information to assist us for purposes described above and are bound to honor this Privacy Policy. We do not share personal information about our users with non-affiliated third parties unless we have our users’ specific permission to do so, or in the following circumstances: We may use third-party service providers to assist in offering aspects of our services, in which case they shall have no authority to independently use any personal information they process on our behalf, and shall be subject to the terms of this Privacy Policy. We reserve the right to share information with private or public authorities that will enable us to fight fraud and abuse on our network, to investigate suspected violations of law, or to fight any other suspected breach of our terms of service. We may share personal information with government authorities as required by applicable law. As a matter of policy we do not rent or sell personal information about our users with non-affiliated third parties unless we have our users’ specific permission to do so. In the event that our business or a division of our business is reorganized or sold and we transfer all or substantially all of our assets to a new owner, your personal information may be transferred to the buyer to enable continuity of service. We may share certain non-personal information (data that does not identify our users individually) with third-party service providers, trusted partners or approved researchers in order to better understand what advertisements or services may interest you, to improve the overall quality and effectiveness of our services or their services, or to contribute to academic research that we believe is of broader social benefit.</p>\r\n<p>E. USER CONTROLS Access, Correction and Deletion: For users that have created an account or listing with us, you can access, correct or delete your personal information by writing to us at the following address: legal@Bid2Rent.ae. You are responsible for keeping the data you provide or post on our network accurate. If your account was created through an identity provider (e.g. Facebook Connect) you may also disable or change the account information through the settings offered by the identity provider (e.g. on Facebook.com). Third Party Choice: Certain third parties active on our site, e.g. Google Adwords, give you the ability to opt out of their collection and use of information for interest-based advertising. You can visit http://www.youronlinechoices.com. or http://www.networkadvertising.org to learn more about this practice and to exercise choices over how this type of information may be collected and used. Cookies: Most major desktop and mobile web browsers (e.g Safari, Firefox, Internet Explorer, Chrome, Opera) provide controls that allow you to limit or block the setting of cookies on your systems. Note that disabling cookies in your browser for either first-party domains (the sites you actively visit) or third-party domains (companies other than those you directly visit on the Web) may result in decreased functionality in certain instances. </p>\r\n<p>F. SECURITY All information we collect is protected by reasonable technical means and reasonable security procedures in order to prevent unauthorized access or use of data. Our affiliates, trusted partners and third-party service providers have committed to manage the information in accordance with our requirements for security and privacy. </p>\r\n<p>G. CHANGES TO THIS POLICY This Privacy Policy was last updated in November, 2017. We may update this Policy from time to time, in which case we will post a prominent announcement on our properties’ home page for 30 days. By continuing to use our services after that period our users confirm their continuing acceptance of any updates to this Privacy Policy. </p>\r\n<p>H. CONTACT INFORMATION Questions about this privacy policy and/or these Terms can be directed to: legal@Bid2Rent.ae. </p>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Disclaimer of Warranties</p>\r\n<ol>\r\n<li>This Section 20 has important legal consequences for you. In this section: - the legal responsibilities and liability of Bid2Rent.ae are limited or excluded; - the rights or remedies you may have against Bid2Rent.ae are limited or excluded; and - you take on risk, responsibilities and liability. There are things that may go wrong when using the Website and/or the Service, including what is listed in this Section 20. Bid2Rent.ae is not responsible (liable) for anything that goes wrong, including what is listed in this Section 20. You use the Website and the Service knowing and accepting that these things can go wrong and that there are risks. AS FAR AS THE LAW ALLOWS, AND SUBJECT TO SECTION 19, YOU EXPRESSLY ACKNOWLEDGE AND AGREE THAT USE OF THE WEBSITE AND THE SERVICE IS ENTIRELY AT YOUR OWN RISK AND THAT THE WEBSITE AND THE SERVICE ARE PROVIDED ON AN \"AS IS\" OR \"AS AVAILABLE\" BASIS, WITHOUT ANY WARRANTIES OF ANY KIND. ALL EXPRESS AND IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT OF PROPRIETARY RIGHTS ARE EXPRESSLY DISCLAIMED TO THE FULLEST EXTENT PERMITTED BY LAW. TO THE FULLEST EXTENT PERMITTED BY LAW, BID2RENT.AE, ITS OFFICERS, DIRECTORS, EMPLOYEES, AND AGENTS DISCLAIM ALL WARRANTIES, EXPRESS OR IMPLIED, IN CONNECTION WITH THE WEBSITE AND YOUR USE THEREOF. BID2RENT.AE MAKES NO WARRANTIES OR REPRESENTATIONS ABOUT THE ACCURACY OR COMPLETENESS OF THE WEBSITE\'S CONTENT OR THE CONTENT OF ANY THIRD PARTY WEBSITES LINKED TO THE WEBSITE AND ASSUMES NO LIABILITY OR RESPONSIBILITY FOR ANY (I) ERRORS, MISTAKES, OR INACCURACIES OF CONTENT, (II)PERSONAL INJURY OR PROPERTY DAMAGE, OF ANY NATURE WHATSOEVER, RESULTING FROM YOUR ACCESS TO AND USE OF THE WEBSITE AND SERVICE, (III) ANY UNAUTHORIZED ACCESS TO OR USE OF OUR SERVERS AND/OR ANY AND ALL PERSONAL INFORMATION AND/OR FINANCIAL INFORMATION STORED THEREIN, (IV) ANY INTERRUPTION OR CESSATION OF TRANSMISSION TO OR FROM THE WEBSITE, (IV) ANY BUGS, VIRUSES, TROJAN HORSES, OR THE LIKE WHICH MAY BE TRANSMITTED TO OR THROUGH THE WEBSITE BY ANY THIRD PARTY, AND/OR (V) ANY ERRORS OR OMISSIONS IN ANY CONTENT OR FOR ANY LOSS OR DAMAGE OF ANY KIND INCURRED AS A RESULT OF THE USE OF ANY CONTENT POSTED, EMAILED, COMMUNICATED, TRANSMITTED, OR OTHERWISE MADE AVAILABLE VIA THE WEBSITE OR THE SERVICE. BID2RENT.AE DOES NOT WARRANT, ENDORSE, GUARANTEE, OR ASSUME RESPONSIBILITY FOR ANY PRODUCT OR SERVICE ADVERTISED OR OFFERED BY A THIRD PARTY THROUGH THE WEBSITE OR ANY HYPERLINKED WEBSITE OR FEATURED IN ANY BANNER OR OTHER ADVERTISING, AND BID2RENT.AE WILL NOT BE A PARTY TO OR IN ANY WAY BE RESPONSIBLE FOR MONITORING ANY TRANSACTION BETWEEN YOU AND/OR OTHER USERS AND/OR THIRD-PARTY PROVIDERS OF PRODUCTS OR SERVICES. AS WITH THE PURCHASE OF A PRODUCT OR SERVICE THROUGH ANY MEDIUM OR IN ANY ENVIRONMENT, YOU SHOULD USE YOUR BEST JUDGMENT AND EXERCISE CAUTION WHERE APPROPRIATE. AS FAR AS THE LAW ALLOWS, AND SUBJECT TO SECTION 19, IN NO EVENT SHALL BID2RENT.AE, ITS OFFICERS, DIRECTORS, EMPLOYEES, OR AGENTS, BE LIABLE FOR DIRECT, INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL OR EXEMPLARY DAMAGES (EVEN IF BID2RENT.AE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES), RESULTING FROM ANY ASPECT OF YOUR USE OF THE WEBSITE OR THE SERVICE, INCLUDING WITHOUT LIMITATION WHETHER THE DAMAGES ARISE FROM USE OR MISUSE OF THE WEBSITE OR THE SERVICE, FROM INABILITY TO USE THE WEBSITE OR THE SERVICE, OR THE INTERRUPTION, SUSPENSION, MODIFICATION, ALTERATION, OR TERMINATION OF THE WEBSITE OR THE SERVICE, (iv) ERRORS, MISTAKES, OR INACCURACIES OF CONTENT, (v) PERSONAL INJURY OR PROPERTY DAMAGE RESULTING FROM YOUR ACCESS TO AND USE OF THE WEBSITE AND SERVICE, (vi) ANY UNAUTHORIZED ACCESS TO OR USE OF OUR SERVERS AND/OR ANY AND ALL PERSONAL INFORMATION AND/OR FINANCIAL INFORMATION STORED THEREIN, (vii) ANY INTERRUPTION OR CESSATION OF TRANSMISSION TO OR FROM THE WEBSITE, (viii) ANY BUGS, VIRUSES, TROJAN HORSES, OR THE LIKE WHICH MAY BE TRANSMITTED TO OR THROUGH THE WEBSITE BY ANY THIRD PARTY, (ix) ANY ERRORS OR OMISSIONS IN ANY CONTENT, (x) ANY LOSS OR DAMAGE OF ANY KIND INCURRED AS A RESULT OF THE USE OF ANY CONTENT POSTED, EMAILED, COMMUNICATED, TRANSMITTED, OR OTHERWISE MADE AVAILABLE VIA THE WEBSITE OR THE SERVICE. SUCH LIMITATION OF LIABILITY SHALL ALSO APPLY WITH RESPECT TO DAMAGES INCURRED BY REASON OF OTHER SERVICES OR PRODUCTS RECEIVED THROUGH OR ADVERTISED IN CONNECTION WITH THE WEBSITE OR THE SERVICE OR ANY LINKS ON THE WEBSITE, AS WELL AS BY REASON OF ANY INFORMATION, OPINIONS OR ADVICE RECEIVED THROUGH OR ADVERTISED IN CONNECTION WITH THE WEBSITE OR THE SERVICE OR ANY LINKS ON THE BID2RENT.AE SITE. THESE LIMITATIONS SHALL APPLY TO THE FULLEST EXTENT PERMITTED BY LAW. AS FAR AS THE LAW ALLOWS, AND SUBJECT TO SECTION 19, YOU SPECIFICALLY ACKNOWLEDGE AND AGREE THAT BID2RENT.AE SHALL NOT BE LIABLE FOR USER SUBMISSIONS OR THE DEFAMATORY, OFFENSIVE, OR ILLEGAL CONDUCT OF ANY USER OR THIRD PARTY AND THAT THE RISK OF HARM OR DAMAGE FROM THE FOREGOING RESTS ENTIRELY WITH YOU. BID2RENT.AE MAKES NO REPRESENTATIONS OR WARRANTIES THAT THE WEBSITE IS APPROPRIATE FOR USE IN OTHER LOCATIONS. THOSE WHO ACCESS OR USE THE WEBSITE FROM OTHER JURISDICTIONS DO SO AT THEIR OWN VOLITION AND RISK AND ARE RESPONSIBLE FOR COMPLIANCE WITH LOCAL LAW.</li>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Limitations of Liability</p>\r\n<ol>\r\n<li>IN NO EVENT SHALL BID2RENT.AE, ITS OFFICERS, DIRECTORS, EMPLOYEES, OR AGENTS, BE LIABLE FOR DIRECT, INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL OR EXEMPLARY DAMAGES (EVEN IF DUBZZLE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES), RESULTING FROM ANY ASPECT OF YOUR USE OF THE WEBSITE OR THE SERVICE, INCLUDING WITHOUT LIMITATION WHETHER THE DAMAGES ARISE FROM USE OR MISUSE OF THE WEBSITE OR THE SERVICE, FROM INABILITY TO USE THE WEBSITE OR THE SERVICE, OR THE INTERRUPTION, SUSPENSION, MODIFICATION, ALTERATION, OR TERMINATION OF THE WEBSITE OR THE SERVICE. SUCH LIMITATION OF LIABILITY SHALL ALSO APPLY WITH RESPECT TO DAMAGES INCURRED BY REASON OF OTHER SERVICES OR PRODUCTS RECEIVED THROUGH OR ADVERTISED IN CONNECTION WITH THE WEBSITE OR THE SERVICE OR ANY LINKS ON THE WEBSITE, AS WELL AS BY REASON OF ANY INFORMATION, OPINIONS OR ADVICE RECEIVED THROUGH OR ADVERTISED IN CONNECTION WITH THE WEBSITE OR THE SERVICE OR ANY LINKS ON THE BID2RENT.AE SITE. THESE LIMITATIONS SHALL APPLY TO THE FULLEST EXTENT PERMITTED BY LAW. YOU SPECIFICALLY ACKNOWLEDGE AND AGREE THAT BID2RENT.AE SHALL NOT BE LIABLE FOR USER SUBMISSIONS OR THE DEFAMATORY, OFFENSIVE, OR ILLEGAL CONDUCT OF ANY USER OR THIRD PARTY AND THAT THE RISK OF HARM OR DAMAGE FROM THE FOREGOING RESTS ENTIRELY WITH YOU.</li>\r\n<p>The Website is controlled and offered by Bid2Rent.ae from its facilities in the Dubai, United Arab Emirates. Bid2Rent.ae makes no representations or warranties that the Website is appropriate for use in other locations. Those who access or use the Website from other jurisdictions do so at their own volition and risk and are responsible for compliance with local law.</p>\r\n</ol>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Property for Rent Categories on Bid2Rent.ae</p>\r\n<div class=\"nostrong\">\r\n<p>If you are listing a property on this Website, your obligations are as follows:</p>\r\n<p><strong>Brokers</strong></p>\r\n<p>i. You warrant that you possess a valid license from the Real Estate Regulatory Authority (RERA), or its equivalent in the Emirate in which you are advertising;</p>\r\n<p>ii. If a project is off plan (under construction), you warrant that the project is registered with RERA;</p>\r\n<p>iii. If you are engaging in subleasing activities, you warrant that you possess a license for the activity of “Leasing and Management of Other People’s Property” from both Dubai Department of Economic Development (DED and RERA);</p>\r\n<p>iv. If you are engaging in short-term or Holiday Home leasing, you warrant that you possess a license for the activity from Dubai Tourism and Commerce Marketing (DTCM);</p>\r\n<p>v. As per the RERA regulations, you must obtain approval for every leasing advertisement (located within or outside of Dubai) and display the RERA Permit Number, Office Registration Number and Broker Registration Number on all advertisements.</p>\r\n\r\n<p><strong>Owners and Landlords</strong></p>\r\n<p>i. You warrant that you are the Owner/Landlord of the property, or otherwise possess valid authorization to list the property on this Website;</p>\r\n<p>ii. If you are engaging in short-term or Holiday Home Leasing, you warrant that you possess a license for the activity from Dubai Tourism and Commerce Marketing (DTCM).</p>\r\n<p><strong>Tenants</strong></p>\r\n<p>i. You warrant that you possess valid, written consent from your Landlord before advertising on this Website, and that you are legally entitled to publish such advertisement.</p>\r\n<p><strong>All Advertisers</strong></p>\r\n<p>i. You may only advertise properties that are currently available for lease. It is at our discretion to remove any listings</p>\r\n<p>ii. You warrant that the advertisement does not contain unlawful language or use of the premises, including:</p>\r\n<p>a. defamatory, misleading or deceptive statements;</p>\r\n<p>b. sharing of a property that exceeds lawful occupancy limits (including, but not limited to, bachelor accommodations and multi-family use);</p>\r\n<p>c. sharing of a property between unrelated members of the opposite sex;</p>\r\n<p>d. sharing of a property in any way that is deemed unlawful;</p>\r\n<p>e. any other language that promotes illegal or immoral activities under the laws of the UAE.</p>\r\n\r\n<p>If you are listing a property on this Website, your obligations are as follows:</p>\r\n<p>i. Bid2Rent.ae advertisements include real properties for rent. Bid2Rent.ae is not a real estate brokerage and the details of the properties available on this Website are provided to us by third party brokers, landlords, owners or developers.</p>\r\n<p>ii. Bid2Rent.ae does not verify the property listing details provided to us by third parties, and makes no warranties or representations as to their accuracy or completeness.</p>\r\n<p>iii. You the User of this Website must conduct your own due diligence and must not rely on the details in the advertisements.</p>\r\n<p>iv. Bid2Rent.ae does verify the RERA license number of all property broker companies prior to allowing them to advertise on the Website.</p>\r\n</div>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Automated data collection </p>\r\n<ol>\r\n<li>As a user of the Website, you expressly agree not to use any form of automated data collection such as harvesting bots, robots, spiders, or scrapers, as well as your use of that data.</li>\r\n<li>You agree not to use automated data collection methods to obtain the mobile phone numbers and email addresses of our users, and you acknowledge that you if you contact our users for the purpose of directing them to your business or website without their express permission to contact them, then you may be prosecuted under United Arab Emirates laws.</li>\r\n</ol>\r\n</li>\r\n</ol>\r\n<p>&nbsp;</p><p>&nbsp;</p>', 1, 0);
INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `title`, `url_key`, `content`, `status`, `sort_order`) VALUES
(2, '2018-02-26 18:30:00', '2018-02-26 18:30:00', 'Privacy Policy', 'privacy', '<div class=\"page-title\"><h2><strong>Privacy Policy</strong></h2></div>\r\n<ol class=\"list-of-numbers\">\r\n<li class=\"strong\"><p>Introduction</p>\r\n<p class=\"nostrong\">This privacy policy is designed to inform users of the Bid2Rent FZ LLC website and any related smartphone or mobile application (collectively, the \"Website\"), about how Bid2Rent.ae (\"Bid2Rent\", \"we\" or \"us\") gathers and uses personal information submitted to Bid2Rent through the Website. Bid2Rent will take reasonable steps to protect user privacy consistent with the guidelines set forth in this policy and with applicable U.S. laws. In this policy, \"user\" or \"you\" means any person viewing the Website or submitting any personal information to Bid2Rent.ae in connection with using the Website. By using the Website, you are indicating your consent to this Privacy Policy. IF YOU DO NOT AGREE WITH THIS PRIVACY POLICY, YOU SHOULD NOT USE THE WEBSITE.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>What Information Do We Collect?</p>\r\n<p>Personal Information:</p>\r\n<p>Renters:</p>\r\n<p class=\"nostrong\">If you sign up to use services offered through the Website, Bid2Rent.ae and/or certain third party service providers that we engage to provide services to us (\"Contractors\") may collect certain personal information, including your name, email address, home address, employment information, phone number, educational background, credit score, criminal and eviction history, financial information and income and tenancy history (collectively, the \"Personal Information\"). The collection of such Personal Information is consistent with our provision of services to you, including the facilitation of determinations by landlords, landlord representatives, brokers, property and managers of your suitability as a potential tenant. In addition, if you contact Bid2Rent.ae and disclose additional personal information, we may store that Personal Information.</p>\r\n<p class=\"nostrong\">Information that we collect when you register (including Personal Information) may be provided to our third-party service providers through certain features of the Website. This information is used in order to fulfill your request to provide certain other users of the Website with your credit report and credit score and/or with the results of background checks in regard to your criminal and/or eviction history. BID2RENT.AE IS NOT A RESELLER OF SERVICES PROVIDED BY THIRD-PARTY SERVICE PROVIDERS WITH WHOM WE COOPERATE.</p>\r\n<p>Landlords and Brokers:</p>\r\n<p class=\"nostrong\">When landlords, landlord representatives, brokers and property managers list properties for rent on the Website, we collect the name, telephone number and email address of a contact person for such landlord, landlord representative, broker or property manager . We also collect bank details if required to deposit monthly rental to you (if this service is required) </p>\r\nWeb Tracking Information:\r\n<p class=\"nostrong\">We and our Contractors, may use web tracking technologies such as cookies, web beacons, pixel tags and clear GIFs in order to operate the Website efficiently and to collect data related to usage of the Website. Such collected data (\"Web Tracking Information\") may include the address of the websites you visited before and after you visited the Website, the type of browser you are using, your Internet Protocol (IP) address, what pages in the Website you visit and what links you clicked on, and whether you opened email communications we send to you. In order to collect Web Tracking Information and to make your use of the Website more efficient, we may store cookies on your computer. We may also use web tracking technologies that are placed in web pages on the Website or in email communications to collect information about actions that users take when they interact with the Website or such email communications, and our Contractors may also do so. We do not correlate Web Tracking Information to individual user Personal Information. Some Web Tracking Information may include data, such as IP address data, that is unique to you. You may be able to modify your browser settings to alter which web tracking technologies are permitted when you use the Website, but this may affect the performance of the Website.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>How Do We Use the Information We Collect?</p>\r\n<p>Landlords and Brokers:</p>\r\n<p class=\"nostrong\">We will use and store Personal Information for the purpose of delivering the Website and our services to you, and to analyze and enhance the operation of the Website. We may also use Personal Information for the internal operational and administrative purposes of the Website. We may enter Personal Information into our contact management database, and may use such database to send you marketing materials and to contact you regarding your interest in Bid2Rent.ae products and services.</p>\r\n<p>Aggregate Information:</p>\r\n<p class=\"nostrong\">We will also create statistical, aggregated data relating to our users and the Website for analytical purposes. Aggregated data is derived from Personal Information and Web Tracking Information but in its aggregated form it does not relate to or identify any individual. This data is used to understand our customer base and to develop, improve and market our services.</p>\r\n<p>Web Tracking Information:</p>\r\n<p class=\"nostrong\">We use Web Tracking Information to administer the Website and to understand how well our Website is working, to store your user preferences, and to develop statistical information on usage of the Website. This allows us to determine which features visitors like best to help us improve the Website, to personalize your user experience, and to measure overall effectiveness.</p>\r\n<p>Legal Exception:</p>\r\n<p class=\"nostrong\">Notwithstanding the above, Bid2Rent.ae may use Personal Information to the extent required by law or legal process, or if in Bid2Rent.ae\'s reasonable discretion use is necessary to investigate fraud or any threat to the safety of any individual, to protect Bid2Rent.ae\'s legal rights or to protect the rights of third parties.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>What Information Do We Disclose to Third Parties?</p>\r\n<p>Bid2Rent.ae\'s Disclosure of Personal Information:</p>\r\n<p class=\"nostrong\">We will use the Personal Information you give us to fulfill the services you request from us. This may include sharing such Personal Information with any of our Contractors, or with any landlord, landlord representative, broker, property manager or sub-lessor with whom you may wish to enter into a rental contract. Except as set forth in the previous sentence, as described under \"Permitted Disclosures\" below, and as otherwise authorized by you, Bid2Rent.ae will not disclose Personal Information to any third party. Bid2Rent.ae shall in no event be liable to you for any use or misuse of Personal Information by any third party with whom your Personal Information has been shared in accordance with the terms of this paragraph.</p>\r\n<p>Web Tracking Information:</p>\r\n<p class=\"nostrong\">We may disclose Web Tracking Information to Contractors in order to analyze the performance of the Website and the behavior of users, and to operate and improve the Website. Certain Web Tracking information, such as the popularity ranking of certain pages of the Website, may be published on the Website and so disclosed to all users of the Website.</p>\r\n<p>Aggregate Information:</p>\r\n<p class=\"nostrong\">We may disclose aggregated data that does not contain Personal Information to any third parties, such as potential customers, business partners, advertisers, and funding sources, in order to describe our business and operations.</p>\r\n<p>Permitted Disclosures:</p>\r\n<p class=\"nostrong\">Notwithstanding the foregoing, Bid2Rent.ae reserves the right to disclose any information we collect in connection with the Website, without further notice to you to any successor to Bid2Rent.ae\'s business as a result of any merger, acquisition or similar transaction; and to any law enforcement or regulatory authority to the extent required by law or if, in Bid2Rent.ae\'s reasonable discretion, disclosure is necessary to investigate fraud or any threat to the safety of any individual, to protect Bid2Rent.ae\'s legal rights or to protect the rights of third parties.</p>\r\n<p>Third Party Ad Servers:</p>\r\n<p class=\"nostrong\">We may allow other companies, called third-party ad servers or ad networks, to serve advertisements on the Website. These third-party ad servers or ad networks use technology to send, directly to your browser, the advertisements and links that appear on the Website. They automatically receive your IP Address when this happens. They may also use other technologies (such as cookies, JavaScript, or web beacons) to measure the effectiveness of their advertisements and to personalize their advertising content. Further, these advertisers may also serve ads to you on other websites (including ads for our products and services) based on information collected from you while using the services available through the Website. For example, we use Google’s “remarketing” service to target Bid2Rent.ae ads to you based on your prior use of the Website when you visit other sites in Google’s content network.</p>\r\n<p class=\"nostrong\">You should consult the respective privacy policies of these third-party ad servers or ad networks. This Privacy Policy does not apply to, and we cannot control the activities of, such advertisers or other websites. You can opt out of the use by third-party ad servers of cookies by contacting us at support@Bid2Rent.ae.com.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>How Can You Opt Out of Use and Disclosure of Your Information?</p>\r\n<p class=\"nostrong\">If you would like your Personal Information removed from our mailing list or database, please contact us at support@Bid2Rent.ae.com. In the event of any such removal, Bid2Rent.ae may retain copies of information for its archives.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Accessing, Updating or Deleting Your Personal Information</p>\r\n<p class=\"nostrong\">You can access, review, update, correct and/or delete your Personal Information by using the profile editing tools on the Website or by contacting us at support@Bid2Rent.ae.com. Bid2Rent.ae reserves the right to verify your identity in order to provide such access.</p>\r\n<p class=\"nostrong\">Even after you remove information from your profile or delete your account, copies of that information may remain viewable elsewhere to the extent it has been shared with others. However, your name will no longer be associated with that information on the Website. Additionally, we may retain certain information to prevent identity theft and other misconduct even if deletion has been requested. Removed and deleted information may persist in backup copies indefinitely, but will not be available to others.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Security</p>\r\n<p class=\"nostrong\">We use reasonable security precautions to protect the security and integrity of your Personal Information, both during transmission and once we receive it, in accordance with this policy and applicable law. We encrypt transmissions of Personal Information through the Website using secure socket layer technology (SSL). However, no method of electronic storage or Internet transmission is completely secure, and we cannot guarantee that security breaches will not occur. Without limitation of the foregoing, we are not responsible for the actions of hackers and other unauthorized third parties that breach our reasonable security procedures.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Links</p>\r\n<p class=\"nostrong\">The Website may contain links to other websites. Bid2Rent.ae is not responsible for the privacy practices or the content of those websites. Users should be aware of this when they leave our site and review the privacy statements of each website they visit that collects information. This Privacy Policy applies solely to personal information collected by Bid2Rent.ae.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Amendments</p>\r\n<p class=\"nostrong\">Bid2Rent.ae may modify or amend this policy from time to time. If we make any material changes, as determined by Bid2Rent.ae, to this Privacy Policy, including in the way in which Personal Information is collected, used or transferred, we will notify you by e-mail to the address specified in your Bid2Rent.ae profile or by means of a notice on the Website prior to the change becoming effective.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Website Visitors from outside the United Arab Emirates</p>\r\n<p class=\"nostrong\">Bid2Rent.ae and its servers are located in the United Arab Emirates and are subject to the applicable state and federal laws of the United Arab Emirates. If you choose to access the Website, you consent to the use and disclosure of information in accordance with this privacy policy and subject to such laws.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Users under 13 years of age</p>\r\n<p class=\"nostrong\">The Website does not knowingly collect personal information from users under the age of 13. If you are under the age of 13, you are not permitted to use the Website.</p>\r\n</li>\r\n\r\n<li class=\"strong\"><p>Terms of Use</p>\r\n<p class=\"nostrong\">This policy forms part of, and is subject to, the provisions of Bid2Rent.ae\'s Terms of Use.</p>\r\n</li>\r\n\r\n</ol>\r\n<p>&nbsp;</p>', 1, 0);

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

--
-- Table structure for table `payment_statuses`
--

CREATE TABLE `payment_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_statuses`
--

INSERT INTO `payment_statuses` (`id`, `created_at`, `updated_at`, `status`, `code`) VALUES
(1, '2017-12-06 03:30:15', '2017-12-06 03:30:15', 'Payment Pending', 'payment_pending'),
(2, '2017-12-06 03:30:15', '2017-12-06 03:30:15', 'Payment Failed', 'payment_failed'),
(3, '2017-12-06 03:30:15', '2017-12-06 03:30:15', 'Payment Completed', 'payment_completed'),
(4, '2017-12-06 03:30:15', '2017-12-06 03:30:15', 'Expired', 'expired'),
(5, '2017-12-06 03:30:15', '2017-12-06 03:30:15', 'Payment Cancelled', 'payment_cancelled'),
(6, '2017-12-27 01:30:00', NULL, 'Hold', 'hold');

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

--
-- Table structure for table `policies`
--

CREATE TABLE `policies` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci COMMENT 'Helper Text',
  `policy_type_id` int(11) NOT NULL,
  `policy_status_id` int(11) NOT NULL COMMENT '1=Active;0=Inactive',
  `property_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `policies`
--

INSERT INTO `policies` (`id`, `created_at`, `updated_at`, `name`, `description`, `policy_type_id`, `policy_status_id`, `property_count`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'No dogs', NULL, 1, 1, 0),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'No cats', NULL, 1, 1, 0),
(3, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Cleaning at tenants risk', NULL, 1, 1, 0),
(4, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'No more drilling on walls', NULL, 2, 1, 0),
(5, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'No wall papers allowed', NULL, 2, 1, 0);

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

--
-- Table structure for table `policy_types`
--

CREATE TABLE `policy_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Helper Text',
  `is_additional_deposit_required` tinyint(4) NOT NULL COMMENT '1=Additional deposit required; 0=Deposit Not required'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `policy_types`
--

INSERT INTO `policy_types` (`id`, `created_at`, `updated_at`, `name`, `description`, `is_additional_deposit_required`) VALUES
(1, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Pet policy', 'Something about pet animals', 0),
(2, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Maintenence policy', 'Something about Maintenence policy', 0),
(3, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Renovation policy', 'Something about pet policy', 0);

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

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Property Name',
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `area` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `monthly_rent` double(10,2) NOT NULL COMMENT 'Monthly Rent',
  `security_deposit` double(10,2) NOT NULL COMMENT 'One time deposit',
  `total_price` double(10,2) NOT NULL COMMENT 'Sum of monthly rent, Security Deposit and additional deposit if any',
  `other_policies` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `available_from` date NOT NULL,
  `emirate_id` bigint(20) NOT NULL,
  `property_type_id` bigint(20) NOT NULL,
  `vieweing_option_id` bigint(20) NOT NULL,
  `bedroom_size_id` bigint(20) NOT NULL,
  `washroom_size_id` bigint(20) NOT NULL,
  `landlord_id` bigint(20) NOT NULL,
  `bid_count` int(11) NOT NULL,
  `property_status_id` int(11) NOT NULL,
  `bid_selected` int(11) NOT NULL DEFAULT '0' COMMENT '1=>yes, 0=>No',
  `view_count` int(11) DEFAULT '0',
  `property_term_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1=>Short Term, 2=>Long Term',
  `bid_closure_date` date DEFAULT NULL,
  `number_of_payments_id` int(11) DEFAULT NULL,
  `yearly_price` double(10,2) NOT NULL COMMENT 'Yearly Price',
  `title_deed` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_number` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_term_period` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 yearfor long term property, 1-11 months for short term property'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `properties`
--

INSERT INTO `properties` (`id`, `created_at`, `updated_at`, `name`, `address`, `unit`, `area`, `description`, `latitude`, `longitude`, `monthly_rent`, `security_deposit`, `total_price`, `other_policies`, `available_from`, `emirate_id`, `property_type_id`, `vieweing_option_id`, `bedroom_size_id`, `washroom_size_id`, `landlord_id`, `bid_count`, `property_status_id`, `bid_selected`, `view_count`, `property_term_id`, `bid_closure_date`, `number_of_payments_id`, `yearly_price`, `title_deed`, `reference_number`, `property_term_period`) VALUES
(1, '2018-02-02 15:29:21', '2018-03-07 03:55:14', 'Clark Inn', 'Downtown Dubai - Dubai', '1201', '1600', 'Best property in downtown area. All facilities are there', '25.1853112', '55.26743160000001', 2100.00, 1000.00, 3100.00, '', '2018-03-29', 3, 8, 14, 19, 29, 22, 2, 6, 1, 7, '1', '2018-03-31', 58, 25200.00, NULL, 'BR18000001', ''),
(2, '2018-02-02 15:34:19', '2018-02-20 14:10:35', 'Estate Valley', 'Sharqan - Al Heerah Suburb - Sharjah', '123', '2100', 'No description', '25.3736541', '55.402550700000006', 4500.00, 500.00, 5000.00, '', '2018-02-28', 6, 9, 13, 19, 29, 22, 1, 6, 1, 3, '2', '2018-03-31', 62, 54000.00, NULL, 'BR18000002', ''),
(3, '2018-02-02 15:49:39', '2018-02-26 20:24:35', 'Aqualily', 'World Trade Centre - Dubai', '28AB', '85', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.2233933', '55.285422100000005', 8600.00, 1600.00, 10200.00, '', '2018-02-11', 3, 12, 15, 18, 27, 25, 1, 1, 1, 13, NULL, '2018-03-31', NULL, 103200.00, NULL, 'BR18000003', ''),
(4, '2018-02-02 16:31:08', '2018-02-26 02:22:42', 'Silven country', 'Princess Tower - Dubai', '8941', '80', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.0872760197085', '55.14550901970847', 8600.00, 1500.00, 10100.00, '', '2018-02-27', 3, 11, 13, 18, 27, 25, 1, 1, 1, 6, NULL, '2018-03-31', NULL, 103200.00, NULL, 'BR18000004', ''),
(5, '2018-02-03 18:07:56', '2018-03-23 02:30:18', 'best villa in al furjan', 'Al Furjan - Jebel Ali Village - Dubai', '473', '2800', 'nice villa close to all amenities and shops,', '25.024834251613097', '55.15693012923589', 7000.00, 7000.00, 14000.00, '', '2018-02-12', 3, 9, 15, 19, 29, 32, 1, 1, 1, 19, NULL, '2018-03-31', NULL, 84000.00, NULL, 'BR18000005', ''),
(6, '2018-02-03 18:10:14', '2018-03-23 02:30:19', 'al furjan', 'Al Furjan - Jebel Ali Village - Dubai', '472', '2800', 'all great come see it', '25.02460093151652', '55.15669409484258', 5000.00, 5000.00, 10000.00, '', '2018-02-04', 3, 9, 13, 19, 30, 32, 2, 1, 0, 9, NULL, '2018-03-31', NULL, 60000.00, NULL, 'BR18000006', ''),
(7, '2018-02-04 18:20:43', '2018-03-05 20:05:14', 'UCS', 'BM Towers - Sharjah', '2304', '1000', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.303958893489593', '55.3714790263308', 5000.00, 2500.00, 7500.00, '', '2018-02-14', 6, 8, 14, 17, 28, 9, 1, 1, 1, 7, NULL, '2018-03-31', NULL, 60000.00, NULL, 'BR18000007', ''),
(8, '2018-02-06 13:33:47', '2018-02-08 14:00:01', 'Springfield', 'Opal Tower - Dubai', '8943', '80', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.1842170697085', '55.274438569708536', 8700.00, 1500.00, 10200.00, '', '2018-02-22', 3, 11, 14, 18, 27, 25, 1, 4, 1, 0, NULL, '2018-03-31', NULL, 104400.00, NULL, 'BR18000008', ''),
(9, '2018-02-12 18:14:30', '2018-02-18 16:00:01', '5BHK', 'Sector 10 - Abu Dhabi', '89A', '8500', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.  Test', '24.3341543', '54.64445120000005', 4000.00, 8000.00, 12000.00, '', '2018-02-28', 1, 12, 13, 21, 32, 25, 2, 6, 1, 5, NULL, '2018-03-31', NULL, 48000.00, NULL, 'BR18000009', ''),
(10, '2018-02-12 19:26:58', '2018-02-15 15:25:12', 'Raheja Property', 'Downtown Dubai - Dubai', '123', '2324', 'Good one', '25.1853112', '55.26743160000001', 4544.00, 100.00, 4644.00, '', '2018-02-20', 3, 12, 13, 18, 29, 22, 19, 5, 1, 4, NULL, '2018-03-31', NULL, 54528.00, NULL, 'BR18000010', ''),
(11, '2018-02-12 19:29:01', '2018-03-12 05:50:59', 'Vatika', 'Sheikh Zayed Road - Dubai', '34', '3224', 'Good', '25.0595756197085', '55.12763051970853', 500.00, 100.00, 600.00, '', '2018-03-27', 3, 8, 15, 19, 29, 22, 1, 6, 1, 4, '2', '2018-03-31', 58, 6000.00, 'media/landlord/22/22_1520839259.pdf', 'BR18000011', ''),
(12, '2018-02-12 19:48:30', '2018-04-25 04:21:01', 'Pent House', 'Executive Towers - Dubai', '52', '2000', 'Upload pictures to give a great impression of your property. We recommend including sitting room, kitchen, bedroom and balcony/garden.\r\n\r\nLet the tenants know if they can view the property choose either, open house, keys at reception or no viewings', '25.1894680197085', '55.264445019708546', 3500.00, 6000.00, 9500.00, '', '2018-03-01', 3, 11, 14, 21, 30, 25, 3, 1, 0, 9, NULL, '2018-03-31', NULL, 42000.00, NULL, 'BR18000012', ''),
(13, '2018-02-12 19:58:28', '2018-03-14 02:37:47', 'Ushyaku', 'Etisalat Metro Station - Dubai', '249', '1555', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.2534304197085', '55.399694119708556', 1000.00, 1500.00, 2500.00, '', '2018-03-01', 3, 8, 14, 19, 29, 22, 1, 1, 1, 6, NULL, '2018-03-31', NULL, 12000.00, NULL, 'BR18000013', ''),
(14, '2018-02-15 15:00:56', '2018-04-25 04:29:50', 'Reet Apartments', 'Churchill Tower - Dubai', '1203', '1600', 'Good one', '25.1795805197085', '55.26134831970853', 5000.00, 1000.00, 6000.00, '', '2018-02-16', 3, 8, 13, 19, 28, 22, 0, 1, 0, 3, '2', '2018-03-31', NULL, 60000.00, NULL, 'BR18000014', ''),
(15, '2018-02-15 18:46:51', '2018-03-01 05:00:02', 'Spaze ITech park', 'Sector 10 - Abu Dhabi', '249', '1800', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '24.3341543', '54.64445120000005', 2083.33, 5000.00, 7083.33, '', '2018-02-22', 1, 12, 14, 18, 29, 39, 0, 4, 0, 5, '1', '2018-02-25', 60, 24999.96, NULL, 'BR18000015', ''),
(16, '2018-02-15 20:58:16', '2018-02-19 21:22:06', 'Sunshine Villa', 'Al Quoz - Dubai', '1105', '1600', 'Good one', '25.1016993', '55.20468370000003', 1000.00, 5000.00, 6000.00, '', '2018-02-21', 3, 8, 13, 19, 29, 22, 2, 5, 1, 2, '1', '2018-03-25', 59, 12000.00, NULL, 'BR18000016', ''),
(17, '2018-02-16 14:55:34', '2018-02-20 20:26:34', 'Test Property', 'Second Industrial Street - Sharjah', '447', '2345', 'Please select from the below options what is available on your property, a simple click can add appeal to your property.  Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so prospective tenants have a clear idea of the property.', '25.3128635197085', '55.40847091970852', 2500.00, 5000.00, 7500.00, '', '2018-02-28', 6, 9, 13, 21, 31, 39, 2, 5, 1, 4, '2', '2018-02-21', 60, 30000.00, NULL, 'BR18000017', ''),
(18, '2018-02-16 16:25:06', '2018-03-06 14:15:00', 'JMD Megapolis', 'Sector 10 - Abu Dhabi', '123', '1354', 'good', '24.3341543', '54.64445120000005', 2083.33, 5000.00, 7083.33, '', '2018-02-23', 1, 8, 13, 18, 28, 22, 1, 1, 0, 5, '1', '2018-03-20', 60, 25000.00, NULL, 'BR18000018', ''),
(19, '2018-02-15 16:33:49', '2018-02-27 21:04:53', 'rejected property', 'Etisalat Metro Station - Dubai', '75', '333', 'Please select from the below options what is available at your property, a simple click can add appeal to your property.', '25.2534304197085', '55.399694119708556', 1000.00, 2000.00, 3000.00, '', '2018-03-01', 3, 8, 13, 17, 28, 39, 2, 1, 0, 8, '1', '2018-02-27', 63, 12000.00, NULL, 'BR18000019', ''),
(20, '2018-02-16 18:48:23', '2018-03-01 05:00:02', 'Iris Tower', 'Sector 6 - Abu Dhabi', '1605', '1650', 'good', '24.3280542', '54.633078599999976', 1000.00, 5000.00, 6000.00, '', '2018-02-28', 1, 8, 14, 19, 28, 22, 0, 4, 0, 0, '2', '2018-02-28', 60, 12000.00, NULL, 'BR18000020', ''),
(21, '2018-02-16 20:15:23', '2018-03-23 02:28:16', 'test', 'Capital Centre - Abu Dhabi', '256', '2000', 'The Villa has two floors, with four bedrooms (2 master suites and 2 guest rooms) and four bathrooms, as well as a 4000 square meter (43,000 sq. ft) garden. Exotic Ipé hardwood flooring is laid throughout the house. The Villa is set behind an automatic wide gate with plenty of covered parking spaces.', '24.415872', '54.43388700000003', 2083.33, 3500.00, 5583.33, '', '2018-03-15', 1, 11, 15, 20, 31, 39, 4, 1, 1, 7, '1', '2018-02-28', 60, 25000.00, NULL, 'BR18000021', ''),
(22, '2018-02-19 21:02:33', '2018-03-01 05:00:02', 'test', 'TT Middle East Fze - Dubai', '1111', '444', '44', '24.98382836970849', '55.08423256970855', 370.33, 44.00, 414.33, '', '2018-02-20', 6, 9, 15, 24, 33, 22, 0, 4, 0, 1, '1', '2018-02-27', 60, 4444.00, NULL, 'BR18000022', ''),
(23, '2018-02-19 21:09:10', '2018-02-23 18:00:01', 'Anashwars Towers', 'International City - Dubai', '2306', '2500', 'Description', '25.149582', '55.39313070000003', 1666.67, 2000.00, 3666.67, '', '2018-02-20', 3, 8, 13, 18, 29, 9, 1, 1, 1, 4, '2', '2018-02-24', 60, 20000.00, NULL, 'BR18000023', ''),
(24, '2018-02-19 21:18:50', '2018-03-01 05:00:02', 'Demo 2 Towers', 'Novotel Hotel - Dubai', '2302', '2500', 'Description', '25.220925316961434', '55.28815785039694', 2500.00, 2000.00, 4500.00, '', '2018-02-21', 3, 8, 13, 18, 28, 9, 0, 4, 0, 0, '2', '2018-02-28', 63, 30000.00, NULL, 'BR18000024', ''),
(25, '2018-02-19 21:31:13', '2018-04-25 04:27:30', 'bm tower', 'Etihad Building - Dubai', '123', '1000', 'Appartments', '25.2508023697085', '55.334012619708574', 41666.67, 4000.00, 45666.67, '', '2018-02-27', 6, 8, 14, 18, 29, 22, 2, 1, 0, 6, '2', '2018-02-26', 60, 500000.00, NULL, 'BR18000025', ''),
(26, '2018-02-19 21:32:41', '2018-03-01 05:00:02', 'Demo 3 Towers', 'International City - Dubai', '1200', '2500', 'Description', '25.149582', '55.39313070000003', 5000.00, 2000.00, 7000.00, '', '2018-02-20', 3, 8, 13, 18, 28, 9, 0, 4, 0, 0, '1', '2018-02-28', 60, 60000.00, NULL, 'BR18000026', ''),
(27, '2018-02-20 15:27:05', '2018-02-20 21:03:18', 'Recent Property', 'University City - Sharjah', '249', '5000', 'swqdqwdwq', '25.2758013', '55.46331889999999', 5000.00, 10000.00, 15000.00, '', '2018-03-01', 6, 9, 14, 23, 31, 39, 2, 5, 1, 2, '1', '2018-02-27', 63, 60000.00, NULL, 'BR18000027', ''),
(30, '2018-02-22 14:43:13', '2018-03-09 04:44:07', 'Sector 56', 'Ras Al Khor - Dubai', '897', '1500', 'xdewedw', '25.18221', '55.31020369999999', 5000.00, 5000.00, 10000.00, '', '2018-02-28', 3, 12, 13, 21, 28, 39, 2, 1, 0, 6, '2', '2018-03-15', 60, 60000.00, 'media/landlord/39/39_1519278193.pdf', 'BR18000030', ''),
(32, '2018-02-27 20:01:00', '2018-02-27 20:01:00', 'AXIS Hills', 'Emirates Towers - Dubai', '1602', '1700', 'Good', '25.21588041970849', '55.27852501970847', 2000.00, 5000.00, 7000.00, '', '2018-02-28', 3, 8, 15, 20, 30, 22, 0, 6, 0, 0, '2', '2018-04-25', 60, 24000.00, 'media/landlord/22/22_1519729260.pdf', 'BR18000032', ''),
(33, '2018-02-27 20:03:32', '2018-03-23 02:27:42', 'AXIS Hills', 'Emirates Hills - Dubai', '1602', '1700', 'good', '25.0606436', '55.15707480000003', 2000.00, 5000.00, 7000.00, '', '2018-02-28', 3, 8, 13, 20, 30, 22, 0, 1, 0, 2, '2', '2018-03-19', 60, 24000.00, 'media/landlord/22/22_1519729412.pdf', 'BR18000033', ''),
(34, '2018-02-27 20:08:50', '2018-02-27 20:58:50', 'Antariksh', 'Emirates City - Ajman', '1506', '1800', 'Good one', '25.3884849', '55.57082170000001', 3000.00, 4000.00, 7000.00, '', '2018-02-28', 2, 8, 14, 21, 31, 22, 2, 5, 1, 2, '2', '2018-03-21', 61, 36000.00, 'media/landlord/22/22_1519729730.pdf', 'BR18000034', ''),
(35, '2018-02-27 20:27:18', '2018-02-28 14:11:05', 'Vertika Business Park', 'Dubai', '13 B', '3000', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property', '24.7921359', '54.89045429999999', 2050.00, 2500.00, 4550.00, '', '2018-03-01', 3, 8, 13, 21, 31, 39, 0, 1, 0, 1, '1', '2018-03-07', 60, 24600.00, 'media/landlord/39/39_1519730838.pdf', 'BR18000035', ''),
(36, '2018-02-27 21:29:05', '2018-03-23 02:27:43', 'Sun raise', 'Al Ittihad', '2306', '1000', 'Description', '25.07158562272449', '55.137301485180615', 500.00, 2000.00, 2500.00, '', '2018-03-10', 6, 8, 13, 19, 29, 9, 1, 1, 0, 4, '2', '2018-03-14', 61, 6000.00, 'media/landlord/9/9_1519734545.pdf', 'BR18000036', ''),
(39, '2018-02-28 15:52:41', '2018-02-28 15:52:41', 'DLF business Tower', 'Sharjah - North Ras Al Khaimah', '245', '1750', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.540431', '55.86379439999996', 655.00, 500.00, 1155.00, '', '2018-03-21', 6, 12, 15, 18, 28, 25, 0, 2, 0, 0, '2', '2018-03-15', 59, 7860.00, 'media/landlord/25/25_1519800761.pdf', 'BR18000039', ''),
(40, '2018-03-04 15:44:26', '2018-03-04 15:44:26', 'Lunar', 'Al Ittihad Street - Ajman', '2306', '2000', 'Description', '25.4302180197085', '55.501869419708555', 500.00, 2000.00, 2500.00, '', '2018-03-05', 6, 12, 13, 18, 28, 47, 0, 2, 0, 0, '1', '2018-03-15', 60, 6000.00, 'media/landlord/47/47_1520145866.docx', 'BR18000040', ''),
(41, '2018-03-04 16:35:51', '2018-03-06 17:00:01', 'Super Moon', 'Al Ittihad Square - Sharjah', '2306', '2500', 'Description', '25.3440436197085', '55.38463116970843', 500.00, 2000.00, 2500.00, '', '2018-04-01', 6, 8, 13, 18, 28, 9, 1, 1, 1, 2, '1', '2018-03-15', 58, 6000.00, 'media/landlord/9/9_1520148951.docx', 'BR18000041', ''),
(42, '2018-03-05 14:56:37', '2018-03-23 02:27:44', '5BHK', 'Al Barsha - Dubai', '25B', '4000', 'Lets us know about your property. SQ FT, locality, what’s close by, any upgrades or special features. Please be as accurate as possible so perspective tenants have a clear idea of the property.', '25.0526682', '55.177982499999985', 10000.00, 10000.00, 20000.00, '', '2018-03-15', 3, 8, 14, 21, 31, 39, 0, 1, 0, 2, '1', '2018-03-15', 60, 120000.00, 'media/landlord/39/39_1520229397.pdf', 'BR18000042', ''),
(43, '2018-03-07 03:57:10', '2018-03-07 03:57:10', 'ty', 'Garhoud - Dubai', '352', '3245', '4erwtgg', '25.2301056', '55.33585029999995', 1960.42, 4545.00, 6505.42, '', '2018-03-12', 1, 12, 13, 20, 30, 22, 0, 6, 0, 0, '1', '2018-03-29', 59, 23525.00, 'media/landlord/22/22_1520400430.pdf', 'BR18000043', ''),
(44, '2018-03-07 07:54:57', '2018-03-07 07:54:57', 'er', 'Freight Works bldg 54th Street - Dubai', 're', '325235', 'dfgdfgdfg', '25.2368223197085', '55.3570526197085', 2678.58, 434.00, 3112.58, '', '2018-03-22', 3, 11, 14, 19, 30, 22, 0, 6, 0, 0, '2', '2018-03-29', 61, 32143.00, 'media/landlord/22/22_1520414697.pdf', 'BR18000044', ''),
(45, '2018-03-07 07:57:39', '2018-03-07 07:57:39', 'terms', 'Street 1 D591 - Dubai', '123', '123', 'afafadsf', '25.04616121970849', '55.1297648197085', 1934.42, 33.00, 1967.42, '', '2018-03-16', 3, 10, 13, 19, 30, 22, 0, 6, 0, 0, '1', '2018-03-22', 59, 23213.00, 'media/landlord/22/22_1520414859.pdf', 'BR18000045', ''),
(46, '2018-03-07 07:58:16', '2018-03-07 07:58:16', 'terms', 'Street 1 D591 - Dubai', '123', '123', 'afafadsf', '25.04616121970849', '55.1297648197085', 1934.42, 33.00, 1967.42, '', '2018-03-16', 3, 10, 13, 19, 30, 22, 0, 6, 0, 0, '1', '2018-03-22', 59, 23213.00, 'media/landlord/22/22_1520414896.pdf', 'BR18000046', ''),
(47, '2018-03-07 07:58:24', '2018-03-07 07:58:24', 'terms', 'Street 1 D591 - Dubai', '123', '123', 'afafadsf', '25.04616121970849', '55.1297648197085', 1934.42, 33.00, 1967.42, '', '2018-03-16', 3, 10, 13, 19, 30, 22, 0, 6, 0, 0, '1', '2018-03-22', 59, 23213.00, 'media/landlord/22/22_1520414904.pdf', 'BR18000047', ''),
(48, '2018-03-08 07:31:24', '2018-03-08 07:41:42', 'ghghfhg', 'Remraam - Dubai', '121', '32323', 'sdfsdf', '24.9912704', '55.234837500000026', 1943.58, 2323.00, 4266.58, '', '2018-03-14', 3, 11, 14, 18, 31, 22, 0, 6, 0, 1, '1', '2018-03-30', 59, 23323.00, 'media/landlord/22/22_1520499684.pdf', 'BR18000048', ''),
(49, '2018-03-08 08:29:20', '2018-03-08 08:32:22', 'sdf', 'Remraam - Dubai', 'sdf', '3434', 'dfgdfg', '24.9912704', '55.32939980000003', 1767.67, 13123.00, 14890.67, '', '2018-03-09', 3, 11, 14, 18, 29, 22, 0, 1, 0, 2, '2', '2018-05-22', 59, 21212.00, 'media/landlord/22/22_1520503160.pdf', 'BR18000049', ''),
(50, '2018-03-09 03:13:32', '2018-03-09 09:04:14', 'Bid Edit Test', 'Downtown Dubai - Dubai', '133', '12424', 'sgtsdgdfg', '25.1853112', '55.26743160000001', 28528.58, 343.00, 28871.58, '', '2018-03-10', 3, 11, 13, 17, 29, 22, 1, 1, 0, 4, '1', '2018-03-31', 59, 342343.00, 'media/landlord/22/22_1520570612.pdf', 'BR18000050', ''),
(51, '2018-03-13 02:24:32', '2018-03-13 08:06:13', 'Test image', 'Downtown Dubai - Dubai', '34', '1212', 'sgsgdfgdfgdfgdfgdfg', '25.1949849', '55.278414099999964', 193.58, 233.00, 426.58, '', '2018-03-14', 3, 12, 13, 18, 29, 22, 1, 1, 1, 2, '1', '2018-03-31', 58, 2323.00, 'media/landlord/22/22_1520913272.pdf', 'BR18000051', ''),
(52, '2018-03-13 02:27:32', '2018-03-13 02:27:58', 'rerer', 'Dubai Festival City - Dubai', '4232', '3423423', 'dfgbdfgdf', '25.2171003', '55.36136350000004', 28603.58, 3434.00, 32037.58, '', '2018-03-14', 3, 12, 13, 20, 29, 22, 0, 6, 0, 0, '1', '2018-03-30', 59, 343243.00, 'media/landlord/22/22_1520913452.pdf', 'BR18000052', ''),
(53, '2018-04-30 03:53:00', '2018-04-30 04:56:43', 'Property Term Property', 'Downtown Dubai - Dubai', '123', '123', 'sdfsdf', '25.1949849', '55.278414099999964', 1000.00, 600.00, 1600.00, '', '2018-04-30', 3, 8, 15, 19, 29, 22, 1, 1, 1, 2, '2', '2018-08-15', 59, 12000.00, 'media/landlord/22/22_1525065780.pdf', 'BR18000053', '1 year'),
(54, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 'test', 'Downtown Dubai - Dubai', '123', '123', 'asdasd', '25.1949849', '55.278414099999964', 1250.00, 750.00, 2000.00, '', '2018-05-11', 3, 12, 13, 18, 28, 22, 0, 2, 0, 0, '1', '2018-05-24', 59, 15000.00, 'media/landlord/22/22_1525323846.pdf', 'BR18000054', '1 Month'),
(55, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 'test', 'Downtown Dubai - Dubai', '123', '123', 'asdasd', '25.1949849', '55.278414099999964', 1250.00, 750.00, 2000.00, '', '2018-05-11', 3, 12, 13, 18, 28, 22, 0, 2, 0, 0, '1', '2018-05-24', 59, 15000.00, 'media/landlord/22/22_1525323848.pdf', 'BR18000055', '1 Month'),
(56, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 'avc', 'Deira - Dubai', '123', '123', 'fchyyfgh', '25.2788468', '55.3309395', 13750.00, 8250.00, 22000.00, '', '2018-05-11', 3, 11, 13, 23, 32, 22, 0, 2, 0, 0, '2', '2018-12-24', 61, 165000.00, 'media/landlord/22/22_1525325563.pdf', 'BR18000056', '1 year'),
(57, '2018-05-03 04:02:44', '2018-05-03 04:02:44', 'avc', 'Deira - Dubai', '123', '123', 'fchyyfgh', '25.2788468', '55.3309395', 13750.00, 8250.00, 22000.00, '', '2018-05-11', 3, 11, 13, 23, 32, 22, 0, 2, 0, 0, '2', '2018-12-24', 61, 165000.00, 'media/landlord/22/22_1525325564.pdf', 'BR18000057', '1 year'),
(58, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 'avc', 'Deira - Dubai', '123', '123', 'fchyyfgh', '25.2788468', '55.3309395', 13750.00, 8250.00, 22000.00, '', '2018-05-11', 3, 11, 13, 23, 32, 22, 0, 2, 0, 0, '2', '2018-12-24', 61, 165000.00, 'media/landlord/22/22_1525325570.pdf', 'BR18000058', '1 year');

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

--
-- Table structure for table `property_statuses`
--

CREATE TABLE `property_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_statuses`
--

INSERT INTO `property_statuses` (`id`, `created_at`, `updated_at`, `name`, `property_count`) VALUES
(1, '2017-11-27 03:26:11', '2018-04-30 04:52:39', 'Active', 23),
(2, '2017-11-27 03:26:11', '2018-05-03 04:02:50', 'Inactive', 9),
(3, '2017-11-27 03:26:11', '2018-02-27 20:28:26', 'Suspended', 1),
(4, '2017-11-27 03:26:11', '2018-03-06 05:00:02', 'Expired', 6),
(5, '2017-11-27 03:26:11', '2018-03-01 05:00:02', 'Closed', 5),
(6, '2018-02-15 19:04:02', '2018-03-13 07:59:13', 'Approval Pending', 14);

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

--
-- Table structure for table `property_term`
--

CREATE TABLE `property_term` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `term_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_term`
--

INSERT INTO `property_term` (`id`, `created_at`, `updated_at`, `term_id`, `property_id`) VALUES
(7, '2018-03-08 07:41:13', '2018-03-08 07:41:13', 66, 48),
(8, '2018-03-08 07:41:42', '2018-03-08 07:41:42', 65, 48),
(9, '2018-03-08 08:02:43', '2018-03-08 08:02:43', 65, 11),
(10, '2018-03-08 08:02:43', '2018-03-08 08:02:43', 66, 11),
(11, '2018-03-08 08:29:20', '2018-03-08 08:29:20', 65, 49),
(12, '2018-03-08 08:29:20', '2018-03-08 08:29:20', 66, 49),
(13, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 65, 50),
(14, '2018-03-09 03:13:32', '2018-03-09 03:13:32', 66, 50),
(15, '2018-03-12 08:46:31', '2018-03-12 08:46:31', 65, 1),
(16, '2018-03-12 08:46:31', '2018-03-12 08:46:31', 66, 1),
(17, '2018-03-13 02:24:32', '2018-03-13 02:24:32', 65, 51),
(18, '2018-03-13 02:24:32', '2018-03-13 02:24:32', 66, 51),
(19, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 65, 52),
(20, '2018-03-13 02:27:32', '2018-03-13 02:27:32', 66, 52),
(21, '2018-04-30 03:53:01', '2018-04-30 03:53:01', 67, 53),
(22, '2018-04-30 03:53:01', '2018-04-30 03:53:01', 66, 53),
(23, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 67, 54),
(24, '2018-05-03 03:34:06', '2018-05-03 03:34:06', 66, 54),
(25, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 67, 55),
(26, '2018-05-03 03:34:08', '2018-05-03 03:34:08', 66, 55),
(27, '2018-05-03 04:02:43', '2018-05-03 04:02:43', 67, 56),
(28, '2018-05-03 04:02:45', '2018-05-03 04:02:45', 67, 57),
(29, '2018-05-03 04:02:50', '2018-05-03 04:02:50', 67, 58);

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

--
-- Table structure for table `property_views`
--

CREATE TABLE `property_views` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `property_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_views`
--

INSERT INTO `property_views` (`id`, `created_at`, `updated_at`, `property_id`, `user_id`, `ip_address`) VALUES
(1, '2018-02-06 20:10:48', '2018-02-06 20:10:48', 5, NULL, '182.68.224.74'),
(2, '2018-02-06 20:11:26', '2018-02-06 20:11:26', 5, 1, '182.68.224.74'),
(3, '2018-02-06 20:11:56', '2018-02-06 20:11:56', 5, 35, '182.68.224.74'),
(4, '2018-02-07 00:12:44', '2018-02-07 00:12:44', 5, NULL, '212.12.170.69'),
(5, '2018-02-07 00:15:14', '2018-02-07 00:15:14', 5, 32, '212.12.170.69'),
(6, '2018-02-07 14:32:46', '2018-02-07 14:32:46', 3, 25, '182.68.226.249'),
(7, '2018-02-07 14:33:02', '2018-02-07 14:33:02', 3, NULL, '182.68.226.249'),
(8, '2018-02-07 14:33:24', '2018-02-07 14:33:24', 3, NULL, '159.203.196.79'),
(9, '2018-02-07 14:34:42', '2018-02-07 14:34:42', 3, 22, '182.68.226.249'),
(10, '2018-02-07 14:35:08', '2018-02-07 14:35:08', 3, 29, '182.68.226.249'),
(11, '2018-02-07 14:35:54', '2018-02-07 14:35:54', 3, 35, '182.68.226.249'),
(12, '2018-02-07 14:37:17', '2018-02-07 14:37:17', 1, NULL, '182.68.226.249'),
(13, '2018-02-07 14:39:00', '2018-02-07 14:39:00', 1, 35, '182.68.226.249'),
(14, '2018-02-07 17:56:46', '2018-02-07 17:56:46', 2, 22, '182.68.226.249'),
(15, '2018-02-07 18:03:25', '2018-02-07 18:03:25', 1, 22, '182.68.226.249'),
(16, '2018-02-07 18:06:27', '2018-02-07 18:06:27', 6, 35, '182.68.226.249'),
(17, '2018-02-07 20:43:54', '2018-02-07 20:43:54', 1, 29, '83.110.102.73'),
(18, '2018-02-07 20:44:53', '2018-02-07 20:44:53', 5, 29, '83.110.102.73'),
(19, '2018-02-07 20:48:42', '2018-02-07 20:48:42', 4, 29, '83.110.102.73'),
(20, '2018-02-07 21:53:32', '2018-02-07 21:53:32', 6, NULL, '83.110.102.73'),
(21, '2018-02-07 22:28:06', '2018-02-07 22:28:06', 5, 10, '83.110.102.73'),
(22, '2018-02-08 13:52:39', '2018-02-08 13:52:39', 5, NULL, '182.68.136.101'),
(23, '2018-02-08 13:52:47', '2018-02-08 13:52:47', 5, NULL, '54.173.160.80'),
(24, '2018-02-08 13:52:58', '2018-02-08 13:52:58', 5, NULL, '83.110.102.73'),
(25, '2018-02-08 14:49:39', '2018-02-08 14:49:39', 5, 34, '83.110.102.73'),
(26, '2018-02-08 15:59:20', '2018-02-08 15:59:20', 1, NULL, '83.110.102.73'),
(27, '2018-02-09 16:26:30', '2018-02-09 16:26:30', 6, NULL, '31.219.51.225'),
(30, '2018-02-09 23:51:42', '2018-02-09 23:51:42', 5, NULL, '5.32.28.162'),
(31, '2018-02-10 21:06:08', '2018-02-10 21:06:08', 5, 33, '94.205.11.163'),
(32, '2018-02-11 21:18:35', '2018-02-11 21:18:35', 6, 32, '83.110.102.73'),
(33, '2018-02-11 21:35:39', '2018-02-11 21:35:39', 3, NULL, '83.110.102.73'),
(34, '2018-02-12 18:59:21', '2018-02-12 18:59:21', 9, 25, '182.68.185.224'),
(35, '2018-02-12 18:59:37', '2018-02-12 18:59:37', 9, 38, '182.68.185.224'),
(36, '2018-02-12 19:12:34', '2018-02-12 19:12:34', 7, 35, '182.68.185.224'),
(37, '2018-02-12 19:16:36', '2018-02-12 19:16:36', 6, NULL, '31.218.190.14'),
(38, '2018-02-12 19:17:39', '2018-02-12 19:17:39', 9, NULL, '138.197.202.197'),
(39, '2018-02-12 19:18:00', '2018-02-12 19:18:00', 3, 38, '182.68.185.224'),
(40, '2018-02-12 19:22:13', '2018-02-12 19:22:13', 4, 38, '182.68.185.224'),
(41, '2018-02-12 19:22:24', '2018-02-12 19:22:24', 4, 25, '182.68.185.224'),
(42, '2018-02-12 19:22:34', '2018-02-12 19:22:34', 4, NULL, '159.203.42.143'),
(43, '2018-02-12 19:27:51', '2018-02-12 19:27:51', 10, 35, '182.68.185.224'),
(44, '2018-02-12 19:29:15', '2018-02-12 19:29:15', 11, 35, '182.68.185.224'),
(45, '2018-02-12 19:38:51', '2018-02-12 19:38:51', 10, 22, '182.68.185.224'),
(46, '2018-02-12 19:39:14', '2018-02-12 19:39:14', 11, 22, '182.68.185.224'),
(47, '2018-02-12 19:49:12', '2018-02-12 19:49:12', 12, 38, '182.68.185.224'),
(48, '2018-02-12 19:51:19', '2018-02-12 19:51:19', 1, 38, '182.68.185.224'),
(49, '2018-02-12 19:51:40', '2018-02-12 19:51:40', 10, 38, '182.68.185.224'),
(50, '2018-02-12 20:00:05', '2018-02-12 20:00:05', 13, 38, '182.68.185.224'),
(51, '2018-02-12 20:20:12', '2018-02-12 20:20:12', 13, 22, '182.68.185.224'),
(52, '2018-02-12 20:31:01', '2018-02-12 20:31:01', 13, NULL, '182.68.185.224'),
(53, '2018-02-14 16:51:34', '2018-02-14 16:51:34', 7, NULL, '83.110.102.73'),
(54, '2018-02-14 20:22:17', '2018-02-14 20:22:17', 5, 36, '83.110.102.73'),
(55, '2018-02-14 20:24:24', '2018-02-14 20:24:24', 1, NULL, '182.68.240.124'),
(56, '2018-02-15 15:12:23', '2018-02-15 15:12:23', 12, NULL, '182.68.240.124'),
(57, '2018-02-15 15:12:32', '2018-02-15 15:12:32', 10, NULL, '182.68.240.124'),
(58, '2018-02-15 19:28:19', '2018-02-15 19:28:19', 3, 40, '182.68.240.124'),
(59, '2018-02-15 19:29:56', '2018-02-15 19:29:56', 12, 25, '182.68.240.124'),
(60, '2018-02-15 19:30:20', '2018-02-15 19:30:20', 12, 40, '182.68.240.124'),
(61, '2018-02-15 20:19:20', '2018-02-15 20:19:20', 9, NULL, '182.68.240.124'),
(62, '2018-02-15 20:20:36', '2018-02-15 20:20:36', 9, 40, '182.68.240.124'),
(63, '2018-02-15 20:33:27', '2018-02-15 20:33:27', 3, NULL, '182.68.240.124'),
(64, '2018-02-15 21:04:12', '2018-02-15 21:04:12', 15, NULL, '182.68.240.124'),
(65, '2018-02-15 21:05:34', '2018-02-15 21:05:34', 15, 40, '182.68.240.124'),
(66, '2018-02-15 21:33:54', '2018-02-15 21:33:54', 15, 39, '182.68.240.124'),
(67, '2018-02-16 16:11:00', '2018-02-16 16:11:00', 15, NULL, '182.68.243.87'),
(68, '2018-02-16 16:25:45', '2018-02-16 16:25:45', 18, NULL, '182.68.243.87'),
(69, '2018-02-16 16:30:33', '2018-02-16 16:30:33', 17, 39, '182.68.243.87'),
(70, '2018-02-16 16:41:15', '2018-02-16 16:41:15', 18, 39, '182.68.243.87'),
(71, '2018-02-16 18:19:40', '2018-02-16 18:19:40', 16, 22, '182.68.243.87'),
(72, '2018-02-16 18:19:50', '2018-02-16 18:19:50', 18, 22, '182.68.243.87'),
(73, '2018-02-16 19:15:05', '2018-02-16 19:15:05', 19, 39, '182.68.243.87'),
(74, '2018-02-16 19:20:18', '2018-02-16 19:20:18', 19, NULL, '182.68.243.87'),
(75, '2018-02-16 19:20:43', '2018-02-16 19:20:43', 19, 40, '182.68.243.87'),
(76, '2018-02-16 20:20:07', '2018-02-16 20:20:07', 21, 39, '182.68.243.87'),
(77, '2018-02-16 20:21:26', '2018-02-16 20:21:26', 21, 40, '182.68.243.87'),
(78, '2018-02-16 21:06:04', '2018-02-16 21:06:04', 19, NULL, '159.203.42.143'),
(79, '2018-02-16 21:07:16', '2018-02-16 21:07:16', 19, 29, '182.68.243.87'),
(80, '2018-02-18 14:00:44', '2018-02-18 14:00:44', 19, NULL, '83.110.102.73'),
(81, '2018-02-18 17:16:55', '2018-02-18 17:16:55', 12, NULL, '83.110.102.73'),
(82, '2018-02-18 18:53:46', '2018-02-18 18:53:46', 5, NULL, '151.253.81.18'),
(83, '2018-02-19 16:05:26', '2018-02-19 16:05:26', 19, NULL, '182.68.72.182'),
(84, '2018-02-19 16:39:18', '2018-02-19 16:39:18', 6, NULL, '151.253.81.18'),
(85, '2018-02-19 16:39:55', '2018-02-19 16:39:55', 4, NULL, '151.253.81.18'),
(86, '2018-02-19 16:50:19', '2018-02-19 16:50:19', 15, NULL, '182.68.72.182'),
(87, '2018-02-19 19:56:00', '2018-02-19 19:56:00', 2, NULL, '83.110.102.73'),
(88, '2018-02-19 20:45:05', '2018-02-19 20:45:05', 7, 10, '83.110.102.73'),
(89, '2018-02-19 20:45:36', '2018-02-19 20:45:36', 17, 40, '182.68.72.182'),
(90, '2018-02-19 21:03:14', '2018-02-19 21:03:14', 22, 22, '83.110.102.73'),
(91, '2018-02-19 21:18:56', '2018-02-19 21:18:56', 2, 35, '182.68.72.182'),
(92, '2018-02-19 21:20:27', '2018-02-19 21:20:27', 16, 35, '182.68.72.182'),
(93, '2018-02-19 21:35:47', '2018-02-19 21:35:47', 25, 22, '83.110.102.73'),
(94, '2018-02-19 21:36:28', '2018-02-19 21:36:28', 25, NULL, '83.110.102.73'),
(95, '2018-02-19 21:48:47', '2018-02-19 21:48:47', 7, 33, '83.110.102.73'),
(96, '2018-02-19 21:49:28', '2018-02-19 21:49:28', 25, 33, '83.110.102.73'),
(97, '2018-02-19 21:55:33', '2018-02-19 21:55:33', 17, NULL, '83.110.102.73'),
(98, '2018-02-19 21:56:48', '2018-02-19 21:56:48', 23, 10, '83.110.102.73'),
(99, '2018-02-19 21:59:27', '2018-02-19 21:59:27', 23, NULL, '52.87.255.118'),
(100, '2018-02-19 21:59:34', '2018-02-19 21:59:34', 23, NULL, '83.110.102.73'),
(101, '2018-02-19 22:16:04', '2018-02-19 22:16:04', 17, 35, '83.110.102.73'),
(102, '2018-02-20 15:38:00', '2018-02-20 15:38:00', 7, 40, '182.68.179.115'),
(103, '2018-02-20 15:47:45', '2018-02-20 15:47:45', 27, 39, '182.68.179.115'),
(104, '2018-02-20 17:24:52', '2018-02-20 17:24:52', 27, 40, '182.68.179.115'),
(105, '2018-02-21 14:08:12', '2018-02-21 14:08:12', 21, 29, '182.68.198.114'),
(106, '2018-02-21 14:11:15', '2018-02-21 14:11:15', 21, 42, '182.68.198.114'),
(107, '2018-02-21 14:40:33', '2018-02-21 14:40:33', 21, 43, '182.68.198.114'),
(108, '2018-02-21 16:39:19', '2018-02-21 16:39:19', 13, 10, '83.110.102.73'),
(109, '2018-02-21 17:47:12', '2018-02-21 17:47:12', 23, 9, '83.110.102.73'),
(110, '2018-02-21 21:32:49', '2018-02-21 21:32:49', 12, 35, '83.110.102.73'),
(111, '2018-02-22 19:14:28', '2018-02-22 19:14:28', 30, 43, '182.68.185.0'),
(112, '2018-02-22 19:51:59', '2018-02-22 19:51:59', 30, 39, '182.68.185.0'),
(113, '2018-02-23 14:13:42', '2018-02-23 14:13:42', 3, NULL, '182.68.237.154'),
(114, '2018-02-25 16:16:19', '2018-02-25 16:16:19', 7, NULL, '83.110.194.114'),
(115, '2018-02-26 02:22:42', '2018-02-26 02:22:42', 4, NULL, '31.218.140.30'),
(116, '2018-02-26 03:11:19', '2018-02-26 03:11:19', 5, NULL, '41.212.188.67'),
(117, '2018-02-26 17:24:08', '2018-02-26 17:24:08', 25, NULL, '83.110.193.106'),
(118, '2018-02-26 17:25:21', '2018-02-26 17:25:21', 25, 37, '83.110.193.106'),
(119, '2018-02-26 17:35:59', '2018-02-26 17:35:59', 5, NULL, '83.110.193.106'),
(120, '2018-02-26 17:36:32', '2018-02-26 17:36:32', 3, NULL, '83.110.193.106'),
(121, '2018-02-26 19:44:10', '2018-02-26 19:44:10', 11, NULL, '83.110.193.106'),
(122, '2018-02-26 20:24:35', '2018-02-26 20:24:35', 3, 45, '83.110.193.106'),
(123, '2018-02-26 20:24:48', '2018-02-26 20:24:48', 12, 45, '83.110.193.106'),
(124, '2018-02-26 20:27:49', '2018-02-26 20:27:49', 11, 45, '83.110.193.106'),
(125, '2018-02-27 18:33:28', '2018-02-27 18:33:28', 14, 22, '182.68.173.212'),
(126, '2018-02-27 18:42:11', '2018-02-27 18:42:11', 5, 40, '182.68.173.212'),
(127, '2018-02-27 20:36:44', '2018-02-27 20:36:44', 29, 9, '83.110.193.106'),
(128, '2018-02-27 20:38:06', '2018-02-27 20:38:06', 34, 22, '182.68.173.212'),
(129, '2018-02-27 20:51:48', '2018-02-27 20:51:48', 34, 35, '182.68.173.212'),
(130, '2018-02-27 21:04:49', '2018-02-27 21:04:49', 13, 35, '182.68.173.212'),
(131, '2018-02-27 21:04:53', '2018-02-27 21:04:53', 19, 35, '182.68.173.212'),
(132, '2018-02-27 22:05:32', '2018-02-27 22:05:32', 36, 9, '83.110.193.106'),
(133, '2018-02-27 22:06:52', '2018-02-27 22:06:52', 29, 10, '83.110.193.106'),
(134, '2018-02-27 22:09:03', '2018-02-27 22:09:03', 36, 10, '83.110.193.106'),
(135, '2018-02-28 14:11:05', '2018-02-28 14:11:05', 35, 39, '182.68.249.173'),
(136, '2018-02-28 14:28:07', '2018-02-28 14:28:07', 29, 39, '182.68.249.173'),
(137, '2018-02-28 14:35:36', '2018-02-28 14:35:36', 30, 40, '182.68.249.173'),
(138, '2018-02-28 14:40:58', '2018-02-28 14:40:58', 37, 39, '182.68.249.173'),
(139, '2018-03-01 19:20:26', '2018-03-01 19:20:26', 30, NULL, '182.68.223.148'),
(140, '2018-03-01 19:23:02', '2018-03-01 19:23:02', 30, 29, '182.68.223.148'),
(141, '2018-03-01 19:53:16', '2018-03-01 19:53:16', 12, 29, '182.68.223.148'),
(142, '2018-03-04 16:41:52', '2018-03-04 16:41:52', 41, 10, '83.110.193.106'),
(143, '2018-03-04 16:45:48', '2018-03-04 16:45:48', 41, 9, '83.110.193.106'),
(144, '2018-03-05 20:05:14', '2018-03-05 20:05:14', 7, 9, '83.110.193.106'),
(145, '2018-03-06 14:14:17', '2018-03-06 14:14:17', 18, NULL, '182.68.142.210'),
(146, '2018-03-06 14:14:26', '2018-03-06 14:14:26', 18, 35, '182.68.142.210'),
(147, '2018-03-06 14:17:25', '2018-03-06 14:17:25', 21, 35, '182.68.142.210'),
(148, '2018-03-06 16:34:49', '2018-03-06 16:34:49', 36, 40, '182.68.142.210'),
(149, '2018-03-08 07:41:16', '2018-03-08 07:41:16', 48, 22, '::1'),
(150, '2018-03-08 08:32:14', '2018-03-08 08:32:14', 49, NULL, '::1'),
(151, '2018-03-08 08:32:22', '2018-03-08 08:32:22', 49, 35, '::1'),
(152, '2018-03-09 03:14:43', '2018-03-09 03:14:43', 50, 35, '::1'),
(153, '2018-03-09 04:44:07', '2018-03-09 04:44:07', 30, 35, '::1'),
(154, '2018-03-09 08:51:59', '2018-03-09 08:51:59', 50, 22, '::1'),
(155, '2018-03-09 08:52:49', '2018-03-09 08:52:49', 50, NULL, '::1'),
(156, '2018-03-09 08:53:57', '2018-03-09 08:53:57', 50, 40, '::1'),
(157, '2018-03-09 10:11:09', '2018-03-09 10:11:09', 42, 35, '::1'),
(158, '2018-03-09 10:12:30', '2018-03-09 10:12:30', 33, 22, '::1'),
(159, '2018-03-13 08:00:42', '2018-03-13 08:00:42', 51, 35, '::1'),
(160, '2018-03-13 08:06:13', '2018-03-13 08:06:13', 51, 22, '::1'),
(161, '2018-03-14 02:37:47', '2018-03-14 02:37:47', 13, NULL, '::1'),
(162, '2018-03-23 02:27:42', '2018-03-23 02:27:42', 33, NULL, '::1'),
(163, '2018-03-23 02:27:43', '2018-03-23 02:27:43', 36, NULL, '::1'),
(164, '2018-03-23 02:27:44', '2018-03-23 02:27:44', 42, NULL, '::1'),
(165, '2018-03-23 02:28:01', '2018-03-23 02:28:01', 14, NULL, '::1'),
(166, '2018-03-23 02:28:16', '2018-03-23 02:28:16', 21, NULL, '::1'),
(167, '2018-03-23 02:30:18', '2018-03-23 02:30:18', 5, NULL, '::1'),
(168, '2018-03-23 02:30:19', '2018-03-23 02:30:19', 6, NULL, '::1'),
(169, '2018-04-25 04:21:01', '2018-04-25 04:21:01', 12, NULL, '::1'),
(170, '2018-04-25 04:27:30', '2018-04-25 04:27:30', 25, NULL, '::1'),
(171, '2018-04-25 04:29:50', '2018-04-25 04:29:50', 14, 35, '::1'),
(172, '2018-04-30 03:53:19', '2018-04-30 03:53:19', 53, 22, '::1'),
(173, '2018-04-30 04:52:39', '2018-04-30 04:52:39', 53, 35, '::1');

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

--
-- Table structure for table `sms_reports`
--

CREATE TABLE `sms_reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `recipient` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_reports`
--

INSERT INTO `sms_reports` (`id`, `created_at`, `updated_at`, `user_id`, `recipient`, `message`, `message_id`) VALUES
(1, '2018-02-02 15:38:54', '2018-02-02 15:38:54', 35, '971509164082', 'Please use 921884 as OTP for verifying your mobile number', 34926616),
(2, '2018-02-02 16:11:40', '2018-02-02 16:11:40', 25, '971544546870', 'Shreya made a bid and proposed rent is 10 percent more than the set price', 34926961),
(3, '2018-02-02 16:34:01', '2018-02-02 16:34:01', 25, '971544546870', 'Shreya made a bid and proposed rent is 10 percent more than the set price', 34927310),
(4, '2018-02-03 19:57:45', '2018-02-03 19:57:45', 32, '971505036520', 'Ciara made a bid and proposed rent is 10 percent more than the set price', 34956285),
(5, '2018-02-04 16:00:22', '2018-02-04 16:00:22', 36, '971544546870', 'Please use 580362 as OTP for verifying your mobile number', 34974885),
(6, '2018-02-04 16:06:28', '2018-02-04 16:06:28', 37, '971544546870', 'Please use 207277 as OTP for verifying your mobile number', 34975017),
(7, '2018-02-04 18:21:38', '2018-02-04 18:21:38', 9, '971509164082', 'Anto made a bid and proposed rent is 10 percent more than the set price', 34978490),
(8, '2018-02-12 18:46:24', '2018-02-12 18:46:24', 38, '971561872072', 'Please use 273533 as OTP for verifying your mobile number', 35245199),
(9, '2018-02-12 18:49:57', '2018-02-12 18:49:57', 38, '971561872072', 'Please use 328976 as OTP for verifying your mobile number', 35245845),
(10, '2018-02-12 18:52:56', '2018-02-12 18:52:56', 38, '971561872072', 'Please use 851486 as OTP for verifying your mobile number', 35246543),
(11, '2018-02-15 18:05:23', '2018-02-15 18:05:23', 39, '971558475221', 'Please use 896052 as OTP for verifying your mobile number', 35327234),
(12, '2018-02-15 19:14:19', '2018-02-15 19:14:19', 40, '971561872072', 'Please use 374773 as OTP for verifying your mobile number', 35327952),
(13, '2018-02-15 20:21:34', '2018-02-15 20:21:34', 25, '971544546870', 'honey made a bid and proposed rent is 10 percent more than the set price', 35328564),
(14, '2018-02-16 21:07:59', '2018-02-16 21:07:59', 39, '971558475221', 'Shreya made a bid and proposed rent is 10 percent more than the set price', 35342431),
(15, '2018-02-21 14:10:07', '2018-02-21 14:10:07', 42, '971581234567', 'Please use 248719 as OTP for verifying your mobile number', 35471737),
(16, '2018-02-21 14:18:04', '2018-02-21 14:18:04', 43, '971561872072', 'Please use 238121 as OTP for verifying your mobile number', 35471813),
(17, '2018-02-21 14:18:50', '2018-02-21 14:18:50', 43, '971561872072', 'Please use 363586 as OTP for verifying your mobile number', 35473519),
(18, '2018-02-21 14:19:29', '2018-02-21 14:19:29', 43, '971561872072', 'Please use 242342 as OTP for verifying your mobile number', 35473521),
(19, '2018-02-21 17:58:30', '2018-02-21 17:58:30', 44, '971581234567', 'Please use 566482 as OTP for verifying your mobile number', 35486696),
(20, '2018-02-26 19:39:25', '2018-02-26 19:39:25', 45, '9716 525 4491', 'Please use 606188 as OTP for verifying your mobile number', 35638369),
(21, '2018-02-26 20:36:05', '2018-02-26 20:36:05', 46, '97165254491', 'Please use 905359 as OTP for verifying your mobile number', 35642663),
(22, '2018-03-04 15:42:35', '2018-03-04 15:42:35', 47, '971563767401', 'Please use 227029 as OTP for verifying your mobile number', 35872267),
(23, '2018-03-13 08:01:00', '2018-03-13 08:01:00', 22, '971501236548', 'Nikita made a bid and proposed rent is 10 percent more than the set price', 36158829);

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

--
-- Table structure for table `supports`
--

CREATE TABLE `supports` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bid_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supports`
--

INSERT INTO `supports` (`id`, `created_at`, `updated_at`, `subject`, `description`, `bid_id`, `property_id`, `user_id`, `status`) VALUES
(1, '2018-02-20 21:19:06', '2018-02-20 21:19:06', 'Place is not look good', 'Apartment is looking as per description mentioned on portal So I need your help to return my money and I am leaving this place.', 23, 27, 40, 0);

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

--
-- Table structure for table `surveys`
--

CREATE TABLE `surveys` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `model_id` int(11) NOT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `surveys`
--

INSERT INTO `surveys` (`id`, `created_at`, `updated_at`, `user_id`, `parent_id`, `model_id`, `result`) VALUES
(1, '2018-02-12 19:14:08', '2018-02-12 19:14:08', 38, 10, 2, 'Neutral'),
(2, '2018-02-15 15:25:17', '2018-02-15 15:25:17', 35, 11, 2, 'Satisfied'),
(3, '2018-02-16 16:02:49', '2018-02-16 16:02:49', 40, 16, 2, 'Unsatisfied'),
(4, '2018-02-19 20:50:25', '2018-02-19 20:50:25', 40, 19, 2, 'Unsatisfied'),
(5, '2018-02-19 20:53:28', '2018-02-19 20:53:28', 40, 19, 2, 'Unsatisfied'),
(6, '2018-02-19 21:22:10', '2018-02-19 21:22:10', 35, 20, 2, 'Satisfied'),
(7, '2018-02-20 15:45:09', '2018-02-20 15:45:09', 40, 19, 2, 'Unsatisfied'),
(8, '2018-02-20 15:46:35', '2018-02-20 15:46:35', 40, 19, 2, 'Unsatisfied'),
(9, '2018-02-20 17:27:06', '2018-02-20 17:27:06', 40, 23, 2, 'Unsatisfied'),
(10, '2018-02-20 20:26:40', '2018-02-20 20:26:40', 40, 19, 2, 'Neutral'),
(11, '2018-02-20 21:03:22', '2018-02-20 21:03:22', 40, 23, 2, 'Satisfied'),
(12, '2018-02-27 20:58:54', '2018-02-27 20:58:54', 35, 30, 2, 'Satisfied'),
(13, '2018-03-04 16:50:28', '2018-03-04 16:50:28', 10, 31, 2, 'Unsatisfied');

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

--
-- Table structure for table `tenancy_contracts`
--

CREATE TABLE `tenancy_contracts` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bid_id` int(11) NOT NULL,
  `landlord_id` int(11) NOT NULL,
  `tenant_id` int(11) NOT NULL,
  `contract_date` int(11) NOT NULL,
  `contract_month` int(11) NOT NULL,
  `contract_year` int(11) NOT NULL,
  `contract_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_usage` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `landlord_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `landlord_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `landlord_phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `building_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `building_location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `premises_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plot_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_period_from` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_period_to` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `annual_rent` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `security_deposit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_signature_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_approve_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1=>Approve',
  `landlord_accept_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1=>Accept',
  `pdf_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Pdf name with path will store here'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenancy_contracts`
--

INSERT INTO `tenancy_contracts` (`id`, `created_at`, `updated_at`, `bid_id`, `landlord_id`, `tenant_id`, `contract_date`, `contract_month`, `contract_year`, `contract_number`, `property_usage`, `owner_name`, `landlord_name`, `tenant_name`, `landlord_email`, `tenant_email`, `tenant_phone`, `landlord_phone`, `building_name`, `building_location`, `property_size`, `property_type`, `property_number`, `premises_number`, `plot_number`, `contract_period_from`, `contract_period_to`, `annual_rent`, `contract_value`, `security_deposit`, `payment_mode`, `tenant_signature_date`, `tenant_approve_status`, `landlord_accept_status`, `pdf_path`) VALUES
(2, '2018-03-06 09:50:33', '2018-03-13 07:45:01', 20, 22, 35, 7, 3, 18, '12', '2', 'John Milton', 'John Milton', 'Neo trinity', 'john@bid2rent.ae', 'neo@bid2rent.ae', '501234567', '0501234567', 'Emirtaes Towerfsdf', 'Dubaisfsdf', '123', 'Villa', '123', '123', '123', '06-03-2018', '05-03-2019', '12000', '123', '6000', 'Cash', '06-03-2018', '1', '1', 'C:\\xampp\\htdocs\\bid2rent\\public\\/media/contract/22/2_1520932500.pdf'),
(3, '2018-03-06 10:34:51', '2018-03-13 07:29:17', 11, 22, 35, 6, 3, 18, '123', '1', 'John Milton', 'John Milton', 'Neo trinity', 'john@bid2rent.ae', 'neo@bid2rent.ae', '501234567', '0501234567', 'Emirtaes Tower', 'Dubai', '123', 'Villa', '123', '123', '123', '06-03-2018', '05-03-2019', '12000', '123', '6000', 'Cash', '06-03-2018', '1', '0', 'C:\\xampp\\htdocs\\bid2rent\\public\\/media/contract/22/3_1520931556.pdf');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `payment_method_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status_id` int(11) NOT NULL,
  `reference_id` text COLLATE utf8mb4_unicode_ci,
  `user_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `custom_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `created_at`, `updated_at`, `model_id`, `amount`, `payment_method_code`, `payment_status_id`, `reference_id`, `user_id`, `parent_id`, `custom_1`, `custom_2`, `custom_3`) VALUES
(1, '2018-02-02 15:43:00', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(2, '2018-02-02 15:43:07', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(3, '2018-02-02 15:43:11', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(4, '2018-02-02 15:43:15', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(5, '2018-02-02 15:43:19', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(6, '2018-02-02 15:43:23', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(7, '2018-02-02 15:43:27', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(8, '2018-02-02 15:43:31', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(9, '2018-02-02 15:43:35', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(10, '2018-02-02 16:17:09', '2018-02-06 15:26:01', 2, '97.00', 'Telr', 4, '0', 29, 3, NULL, NULL, NULL),
(11, '2018-02-02 16:37:47', '2018-02-06 15:26:01', 2, '96.00', 'Telr', 4, '0', 29, 4, NULL, NULL, NULL),
(12, '2018-02-02 16:37:57', '2018-02-06 15:26:01', 2, '96.00', 'Telr', 4, '0', 29, 4, NULL, NULL, NULL),
(13, '2018-02-02 19:44:54', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(14, '2018-02-02 19:45:02', '2018-02-06 15:26:01', 2, '21.00', 'Telr', 4, '0', 35, 2, NULL, NULL, NULL),
(15, '2018-02-02 20:57:56', '2018-02-06 15:26:01', 2, '96.00', 'Telr', 4, '0', 29, 4, NULL, NULL, NULL),
(16, '2018-02-04 18:22:56', '2018-02-06 19:00:01', 2, '60.00', 'Telr', 4, '0', 10, 7, NULL, NULL, NULL),
(17, '2018-02-04 18:23:47', '2018-02-06 19:00:01', 2, '60.00', 'Telr', 4, '0', 10, 7, NULL, NULL, NULL),
(18, '2018-02-04 18:24:00', '2018-02-06 19:00:01', 2, '60.00', 'Telr', 4, '0', 10, 7, NULL, NULL, NULL),
(19, '2018-02-04 18:56:34', '2018-02-06 19:00:01', 2, '60.00', 'Telr', 4, '0', 10, 7, NULL, NULL, NULL),
(20, '2018-02-04 18:56:43', '2018-02-06 19:00:01', 2, '60.00', 'Telr', 4, '0', 10, 7, NULL, NULL, NULL),
(21, '2018-02-05 13:40:30', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(22, '2018-02-05 13:40:36', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(23, '2018-02-05 13:45:31', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(24, '2018-02-05 17:59:57', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(25, '2018-02-05 19:21:41', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(26, '2018-02-06 13:47:05', '2018-02-08 14:00:01', 2, '92.00', 'Telr', 4, '0', 29, 9, NULL, NULL, NULL),
(27, '2018-02-06 15:05:00', '2018-02-08 14:00:01', 2, '92.00', 'Telr', 4, '0', 29, 9, NULL, NULL, NULL),
(28, '2018-02-06 15:09:55', '2018-02-08 14:00:01', 2, '92.00', 'Telr', 4, '0', 29, 9, NULL, NULL, NULL),
(29, '2018-02-06 15:46:18', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(30, '2018-02-06 15:47:14', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(31, '2018-02-06 15:49:38', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(32, '2018-02-06 16:18:54', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(33, '2018-02-06 16:27:52', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(34, '2018-02-06 16:29:02', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(35, '2018-02-06 16:30:10', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(36, '2018-02-06 16:34:55', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(37, '2018-02-06 16:35:15', '2018-02-07 14:00:01', 2, '45.00', 'Telr', 4, '0', 35, 8, NULL, NULL, NULL),
(38, '2018-02-06 16:41:19', '2018-02-08 14:00:01', 2, '92.00', 'Telr', 4, '0', 29, 9, NULL, NULL, NULL),
(39, '2018-02-06 16:41:44', '2018-02-08 14:00:01', 2, '92.00', 'Telr', 4, '0', 29, 9, NULL, NULL, NULL),
(40, '2018-02-06 17:46:36', '2018-02-08 14:00:01', 2, '92.00', 'Telr', 4, '0', 29, 9, NULL, NULL, NULL),
(41, '2018-02-06 17:50:21', '2018-02-08 18:00:01', 2, '60.00', 'Telr', 4, '0', 33, 5, NULL, NULL, NULL),
(42, '2018-02-06 17:50:40', '2018-02-08 18:00:01', 2, '60.00', 'Telr', 4, 'B4C9D2AEE2B6F865165EE4BC628D2FE4E37C625FBDE90E65F1A13BBFEEC4E2E9', 33, 5, NULL, NULL, NULL),
(43, '2018-02-06 17:55:46', '2018-02-08 18:00:01', 2, '60.00', 'Telr', 4, '0', 33, 5, NULL, NULL, NULL),
(44, '2018-02-06 17:55:52', '2018-02-08 18:00:01', 2, '60.00', 'Telr', 4, '0', 33, 5, NULL, NULL, NULL),
(45, '2018-02-06 17:56:14', '2018-02-08 18:00:01', 2, '60.00', 'Telr', 4, '0', 33, 5, NULL, NULL, NULL),
(1000, '2018-02-15 15:13:10', '2018-02-15 15:13:46', 2, '45.44', 'Telr', 3, 'DE54012684AE4E9EDF99E639D4B0303109466088B47F86C042C05D2A2D8F1E6E', 35, 11, NULL, NULL, NULL),
(1001, '2018-02-16 16:01:38', '2018-02-18 16:00:01', 2, '45.00', 'Telr', 4, '80BBBD16EA351F07796028751B26894C21ACE0851EFE753CFA6138AEAB1B4044', 40, 16, NULL, NULL, NULL),
(1002, '2018-02-19 20:49:45', '2018-02-19 20:50:20', 2, '300.20', 'Telr', 2, '82CA39859F82C9DB339DC6236662C707847519F1EDD6073DB63AB23525BD9DF9', 40, 19, NULL, NULL, NULL),
(1003, '2018-02-19 20:50:35', '2018-02-19 20:50:43', 2, '300.20', 'Telr', 5, 'C0260A3E3986BE4E6C4612649B334B3825F0BD7F441F7CDA489E62ED0D19D758', 40, 19, NULL, NULL, NULL),
(1004, '2018-02-19 20:52:55', '2018-02-19 20:53:24', 2, '300.20', 'Telr', 2, '18405EDCDDD036CB6A4F59FBBAD6D108189F3059FDC6079707B115D7AE269B91', 40, 19, NULL, NULL, NULL),
(1005, '2018-02-19 21:21:28', '2018-02-19 21:22:06', 2, '130.00', 'Telr', 3, '5DC5EAC55C1FF9E4E31BC20795A6D7D5CBB8FE749098C3F433BDFABD353892EF', 35, 20, NULL, NULL, NULL),
(1006, '2018-02-20 15:44:31', '2018-02-20 15:45:04', 2, '300.20', 'Telr', 2, 'B0DF6071B7BDD0BE354B22C15270E01EA474B599A8AE1AE3349C0940E2392AEA', 40, 19, NULL, NULL, NULL),
(1007, '2018-02-20 15:45:38', '2018-02-20 15:46:31', 2, '300.20', 'Telr', 2, 'B97F3331C84008E2DD442E7388CB06B3B4D3F106A5312C34DBC25CBEC91BC6A9', 40, 19, NULL, NULL, NULL),
(1008, '2018-02-20 17:26:25', '2018-02-20 17:26:56', 2, '601.00', 'Telr', 2, '8C93E78AB981472F80BF23F8D454E47495D8E6444EB0FAC26B05C2D14E31CE1F', 40, 23, NULL, NULL, NULL),
(1009, '2018-02-20 19:20:29', '2018-02-20 19:21:27', 2, '601.00', 'Telr', 2, 'FD294C57189CCCA82A114B738188CE89A60AB5770941CE3FF48D0732701A9747', 40, 23, NULL, NULL, NULL),
(1010, '2018-02-20 20:22:35', '2018-02-20 20:25:44', 2, '601.00', 'Telr', 2, 'EFDF70DB67C851F2F6325437BE3EA3886C19F837EF3BA8DB2F7A973930168C24', 40, 23, NULL, NULL, NULL),
(1011, '2018-02-20 20:26:08', '2018-02-20 20:26:34', 2, '300.20', 'Telr', 3, '148CD332524247DC78FB1CB1BCB953B7AB778B937DA6DCE0BDC4211C4EC1D598', 40, 19, NULL, NULL, NULL),
(1012, '2018-02-20 20:42:41', '2018-02-20 20:42:44', 2, '601.00', 'Telr', 1, '069A45C595B0A358239960C19E7C15151A8DB2A100A56310B94380DBA965768F', 40, 23, NULL, NULL, NULL),
(1013, '2018-02-20 21:02:51', '2018-02-20 21:03:18', 2, '601.00', 'Telr', 3, 'AC683B7550DF41C0EB651A131947E8EB35F4ECA834A45110DF08103CB9246A35', 40, 23, NULL, NULL, NULL),
(1014, '2018-02-27 20:58:15', '2018-02-27 20:58:50', 2, '360.00', 'Telr', 3, '6BEE710F621BDC25C4E9B55ECFD2DC1E31D74EB8320B0BCF7DC12C2A6630D1C3', 35, 30, NULL, NULL, NULL),
(1015, '2018-03-04 16:46:53', '2018-03-06 17:00:01', 2, '60.00', 'Telr', 4, '449DC401D34EC9D88F9BB613DD9D2D26DA3BE31AE9AEAE018C3A2B3AEDE141C7', 10, 35, NULL, NULL, NULL),
(1016, '2018-03-04 16:47:52', '2018-03-06 17:00:01', 2, '60.00', 'Telr', 4, '2A31CF6145601047F294B6A578DFBED1B11810F68B2C8F1C6A68D761E5141ADA', 10, 35, NULL, NULL, NULL),
(1017, '2018-03-04 16:49:32', '2018-03-06 17:00:01', 2, '60.00', 'Telr', 4, '6D88CE25CB7B200D7641A42DC2E7BC868D8B2FE196E3DC89548D3A2A4C04F669', 10, 31, NULL, NULL, NULL),
(1018, '2018-04-30 02:13:11', '2018-04-30 02:13:11', 2, '28.23', 'Telr', 1, '0', 35, 39, NULL, NULL, NULL),
(1019, '2018-04-30 04:56:55', '2018-04-30 04:56:55', 2, '125.00', 'Telr', 1, '0', 35, 40, NULL, NULL, NULL);

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

--
-- 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,
  `emirates_id_expiration_date` date DEFAULT NULL,
  `passport` varchar(500) 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`, `remember_token`, `emirates_id_expiration_date`, `passport`) VALUES
(1, '2018-01-23 02:27:26', '2018-01-23 03:11:20', 'John', 'Milton', 'john@bid2rent.ae', '$2y$10$5vas2ADpn7N2uPhZTuxTGuTcS7lV9LkpliiD6mNM8Mq/rIp6a/Zaa', 971, 501234567, 1, 2, 1, 954576, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'rs9KjpqrVaL3tGldBoUwFn0h5L30ANYbSWAIcggmbqf2KIDk6Hk1dimbG8Uq', NULL, NULL),
(2, '2018-01-23 03:32:07', '2018-01-23 03:32:24', 'Neo', 'Trinity', 'neo@bid2rent.ae', '$2y$10$b2mM5NXBFr0gJwwQxPu8ReYbhCESwPdHx3RqdJgB9bOpdUOWF9mci', 971, 501234568, 1, 3, 1, 941403, 'media/tenant/2/501234568_1516645927.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GDKxhgYObXZo3ksAKcTTVI5n1FNfC24fek23vEyPhr3hWjC7Dnrki1leIXqY', NULL, NULL),
(9, '2018-01-23 21:14:00', '2018-02-27 21:30:35', 'Anto', 'Nishanth', 'anishanth-owner@ucssolutions.com', '$2y$10$spiX4A61FxKfRPBd3xPrXu7//g.pZYEjZt139cgBUxRB0hu6AAlBW', 971, 509164082, 1, 2, 1, 798771, 'media/tenant/9/509164082_1519734635.jpg', NULL, NULL, NULL, NULL, NULL, 'dubai', 'dubai', 'OjKiKJFF7CNG2S9z4hgzd3zkI1UZWc5OTAFj8L2j4niMq1OYrenyChkmk6mC', '2018-05-31', 'media/landlord/9/509164082_1519734635.jpg'),
(10, '2018-01-23 21:36:40', '2018-01-24 14:57:33', 'Anto', 'Nishanth', 'anishanth-tenant@ucssolutions.com', '$2y$10$MQPrmRaF.Hv5hVphz20pQuboO8G0v2.WEiN3Pewuafu.6pxvHALLm', 971, 509164082, 1, 3, 1, 599932, 'media/tenant/10/509164082_1516711000.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Qkk8aQKHYQOvwUIUshDj8CUi5uQJrwZnhtaettoT80UC7QAUDTfCGMZ3N71R', NULL, NULL),
(11, '2018-01-23 21:59:49', '2018-02-13 13:51:41', 'Antoo', 'Nishanth', 'anishanth-admin@ucssolutions.com', '$2y$10$7Pj8cXP8JNuKzAdz073R1uHEBVrBYXpN0PQFG4FZAydylpDIomYxe', 971, 509164082, 1, 1, 0, 847730, '', '2018-02-01', NULL, NULL, NULL, NULL, 'abu dhabi', 'abu dhabi', 'ikFnue4P5swVMKAapl6y5hqownfuNiBj57pyFu8c8BXWgEczuQ1EI5d055nP', NULL, NULL),
(12, '2018-01-24 14:09:21', '2018-01-24 14:09:36', 'xavier', 'vinoth', 'xavier@ucssolutions.com', '$2y$10$w3HcVIFxfUs2LdvAWAtbKOaJrAi74nznruvisEVBEY75O.hIisdNK', 971, 561435149, 1, 2, 1, 890409, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'arWqPjzenbEpiKhGcFIs6ATvu9FSpSKctOPOzVBQnwpP4GWjAY6QDkAqAMkR', NULL, NULL),
(19, '2018-01-31 14:24:20', '2018-02-01 16:50:21', 'Anashwar', 'Punnakkal', 'apunnakkal@ucssolutions.com', '$2y$10$X0P1ZYi/xtmSroeomIan2.VuOy84riX/msmwSLXqnCct0f6KHwG7m', 971, 544546870, 1, 2, 1, 564196, '', NULL, NULL, NULL, NULL, NULL, 'dubai', 'dubai', NULL, NULL, NULL),
(22, '2018-01-31 19:50:50', '2018-03-08 08:54:10', 'Nikita', 'Gupta', 'nikita-owner@bid2rent.ae', '$2y$10$ojq8MFJj.O7atiEbUq3eBOSwdRwMGudD2ZyyR85QmTT7f6YtnBX2S', 971, 501236548, 1, 2, 1, 220364, 'media/tenant/22/501236548_1518674405.pdf', NULL, NULL, NULL, 'sfsdfsdf', 'dszfcsdfsdf', 'Address', 'City', 'n19M1eGiy5c1h0Sem8P8bj3QLpYTDQioQJij6KN3Nls2vmqvFEEvMzfJHlpX', '2018-03-28', 'media/landlord/22/501236548_1519293985.jpg'),
(25, '2018-01-31 20:57:47', '2018-02-02 16:51:33', 'owner', 'shreya', 'ownershreya@bid2rent.ae', '$2y$10$DwqXxW4X89JChjuD7RKDKOb3NnNXfeodbDicqXhFXOq9XS4YB/YEO', 971, 544546870, 1, 2, 1, 413230, '', '2018-01-23', NULL, NULL, NULL, NULL, 'Dubai', 'Dubai', 'XqwsdwNchhVpjWdDLJUbftYdoLQtNe9iEUW9QZxkjCZLthCZpxvPlrsKbilB', NULL, NULL),
(29, '2018-02-01 13:45:27', '2018-02-02 16:52:29', 'Shreya', 'Jain', 'jainshreya2206@gmail.com', '$2y$10$zmAUN3iNd3cTr670ARcKfeeiSanegOTw1o/4MIB8WV2TFQ2EqYv.y', 971, 544546870, 1, 3, 1, 175764, 'media/tenant/29/544546870_1517460327.pdf', '2018-01-24', NULL, NULL, NULL, NULL, 'Abu dhabi', 'Abu dhabi', 'TPx5lE93CndCCdPcSOB9iHmaH8I6SYMWlgM3SwOzRRpwFbjpjUKn0i5MG9sX', NULL, NULL),
(30, '2018-02-01 23:06:12', '2018-02-01 23:06:12', 'anto', 'nishanth', 'anishanth@ucssolutions.com', '$2y$10$SpXiTsE4Bs1GifT0BgMVUuZTU3ROI88T.9Wtfnpc/PKtZtBq/BYj6', 971, 509164082, 0, 1, 1, 370156, '', NULL, NULL, NULL, NULL, NULL, 'test', 'Sharjah', NULL, NULL, NULL),
(31, '2018-02-01 23:45:49', '2018-02-01 23:45:49', 'Robert', 'Sterry', 'r_sterry@hotmail.com', '$2y$10$XJSDlrdq.dHyhmvrb2k76OorOdD0wh/PEc.fha.Yjf/AeFRqvSbaa', 971, 544546870, 0, 1, 1, 491033, '', NULL, NULL, NULL, NULL, NULL, 'Dubai', 'Dubai', 'YrYoqr8zUcdo01uNUIrFaEjW6IonvIuPniRnlmDUxuWsB35NHbXr1WsCXjyg', NULL, NULL),
(32, '2018-02-02 02:01:48', '2018-02-02 02:02:09', 'rob', 'sterry', 'eurogse@gmail.com', '$2y$10$Yb3dr3kDJ.LYe5KTcRDYzOxisf6TmWiY4.CbYZ9Iue81cpKV4B546', 971, 505036520, 1, 2, 1, 188883, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Kzkx5t0sMGzs4bBcUy2hnO5AMBL3urKsSMoiny6YdEXysx0ARUKOQrghQlKd', NULL, NULL),
(33, '2018-02-02 02:07:12', '2018-02-02 02:07:55', 'Ciara', 'Dunne', 'ciara.dunne@gmail.com', '$2y$10$B8e9ZFXgC6lh6TJeAg5CTu3UTnFAS0rj0UarfYRwXxeZCUF5Ro9su', 971, 504367391, 1, 3, 1, 226761, 'media/tenant/33/504367391_1517504832.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5ooBU8Fiq2BARJlxsttk9nj4fG86fddkXRounn3EaokqXhHL1U5NZUFbYfH0', NULL, NULL),
(34, NULL, NULL, 'Administrator', '', 'admin@bid2rent.ae', '$2y$10$ojq8MFJj.O7atiEbUq3eBOSwdRwMGudD2ZyyR85QmTT7f6YtnBX2S', 0, 0, 1, 1, 1, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'DMOCfik8x0Pq6qcr5ev0KaqMuPMZHg925bYnOb63iwXzWRZDOf2UdiNyHJiE', NULL, NULL),
(35, '2018-02-02 15:38:53', '2018-02-02 15:39:40', 'Nikita', 'Tenant', 'nikita-tenant@bid2rent.ae', '$2y$10$nmLvwm4gCsVHhcJjQv6m0OKdnJ8bzymVa8GxrObaDUPjMSfKfvju.', 971, 509164082, 1, 3, 1, 921884, 'media/tenant/35/509164082_1517553533.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yYvYsDFEtnqzXDBdJecm1UnSXZnoCe87x03jcjUOlOEpDkFTHrPql3Rnbmx0', NULL, NULL),
(36, '2018-02-04 16:00:20', '2018-02-04 16:00:38', 'Anashwar', 'Punnakkal', 'owner@ucssolutions.com', '$2y$10$TFlMeurnb6zbwOgGxsISRu0fGlnbWhsGzFGdXKaIXDVnQPJD1pc9m', 971, 544546870, 1, 2, 1, 580362, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'TV3k258uRyCfOU6PrJCxMU43wHFya68k2KyYWM6PWxv7ptpc7yzcgzAC95Nn', NULL, NULL),
(37, '2018-02-04 16:06:27', '2018-02-04 16:06:44', 'Anashwar', 'Punnakkal', 'tenant@ucssolutions.com', '$2y$10$FTfulsSJcosKklMFaP6.OOmg4LqqVJQbBkXv6N71IJAuTAjr.hDrK', 971, 544546870, 1, 3, 1, 207277, 'media/tenant/37/544546870_1517727987.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'hkHgPeANqvXigVvZP12ZsMczJncaRIq2GhprGc9zJ8Hos639muxSTeD3xOZ7', NULL, NULL),
(39, '2018-02-15 18:05:22', '2018-02-21 20:11:52', 'Testhoney', 'owner', 'davidmorey03@yahoo.com', '$2y$10$pG9oDP5Hh5gXQO9qwus3NeGFbwvDtphtFg90ATgVeOFUqEIc9AAja', 971, 558475221, 1, 2, 1, 896052, 'media/tenant/39/558475221_1518687840.pdf', '1989-12-01', NULL, NULL, NULL, NULL, 'Dubai city', 'Dubai', 'QN7PICcrIB40EU1VQHYNkKvhuTWAWZKqCLDbSVPsW5SVEGs6lXmwBlXjRnZ3', '2018-03-31', NULL),
(40, '2018-02-15 19:14:18', '2018-03-01 14:34:38', 'honey', 'thakur', 'honey.ushyaku@gmail.com', '$2y$10$.ST7YBQqylhTerv8wFELIOVRgT.24HTnUrIw1B/sGJCX6vJmJU3R.', 971, 561872072, 1, 3, 1, 374773, 'media/tenant/40/561872072_1518764721.pdf', NULL, NULL, 'dnt know..............its better u should ask from ma friends.......;\r\n\r\nI\'m so random, I\'m always growing, learning, improving, changing, But one thing you can be sure of about me; is I will always do', 'https://www.facebook.com/profile.php?id=100010657755854', 'https://www.linkedin.com/in/ushyaku-software-solutions-60269a145/', 'Sector 10', 'Dubai', 'AUVQU8cHvjS8dhTmY8iJiinLKe6hjpUkjjdVHWVO3GkXszLCZ5OO9m46as5X', '2018-06-07', NULL),
(45, '2018-02-26 19:39:24', '2018-02-26 19:54:47', 'Gayini', 'Peiris', 'gayinipeiris@gmail.com', '$2y$10$a.x5qWDFlT2A8Hq3VjeTBeKib1Latv5sS0lU037dt22c55DFJ4ATy', 971, 6, 1, 3, 1, 606188, 'media/tenant/45/6 525 4491_1519641564.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y4Dcu5NhNtv1L5mv0Rn7Nrfb8GVYh9Uvx9NlIJCfJyCFae30yH3IDHgOxrfE', NULL, NULL),
(46, '2018-02-26 20:36:04', '2018-02-26 20:37:24', 'gayani', 'Peiris', 'gayanipeiris@gmail.com', '$2y$10$tPCKvOQ9JIv1sJtl7rtIIusNwvkHec5WGBehe9CKt.u.01ZesEflW', 971, 65254491, 1, 2, 1, 905359, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, '2018-03-04 15:42:34', '2018-03-04 15:42:47', 'owner', 'nishanth', 'anishanth-owner1@ucssolutions.com', '$2y$10$M7K7oQ1GO8LrJOslitBWO.HtN5d75Mls779Nk.UIhVS3xWJEtfi1G', 971, 563767401, 1, 2, 1, 227029, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'rHgY4pCqnoALla3pa52GtMmFzIMenfcLc0apMA460UYe5e97DomQhvy5EXc1', NULL, NULL);

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

--
-- Table structure for table `user_logins`
--

CREATE TABLE `user_logins` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `login_time` datetime DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_logins`
--

INSERT INTO `user_logins` (`id`, `created_at`, `updated_at`, `user_id`, `login_time`, `logout_time`) VALUES
(1, NULL, '2018-02-02 15:42:14', 2, '2018-02-02 10:42:00', '2018-02-02 10:42:14'),
(2, NULL, '2018-02-28 15:49:04', 25, '2018-02-28 10:49:04', '2018-02-20 15:29:04'),
(3, NULL, '2018-05-03 03:33:07', 22, '2018-05-03 09:03:07', '2018-04-30 10:28:43'),
(4, NULL, '2018-04-30 04:50:47', 35, '2018-04-30 10:20:47', '2018-04-25 10:53:05'),
(5, NULL, '2018-03-01 19:22:38', 29, '2018-03-01 14:22:38', '2018-02-28 10:48:45'),
(6, NULL, '2018-02-26 02:24:19', 32, '2018-02-25 21:24:19', '2018-02-19 16:47:56'),
(7, NULL, '2018-02-26 03:12:37', 33, '2018-02-25 22:11:48', '2018-02-25 22:12:37'),
(8, NULL, '2018-02-21 21:10:25', 36, '2018-02-21 16:09:45', '2018-02-21 16:10:25'),
(9, NULL, '2018-02-26 17:33:48', 37, '2018-02-26 12:25:21', '2018-02-26 12:33:48'),
(10, NULL, '2018-03-04 16:38:28', 10, '2018-03-04 11:38:28', NULL),
(11, NULL, '2018-03-05 20:05:00', 9, '2018-03-05 15:05:00', '2018-03-04 11:36:04'),
(12, NULL, '2018-02-07 15:16:05', 1, '2018-02-07 10:15:41', '2018-02-07 10:16:05'),
(13, NULL, '2018-02-13 14:36:35', 38, '2018-02-13 08:37:43', '2018-02-13 09:36:35'),
(14, NULL, '2018-03-08 03:22:06', 39, '2018-03-08 08:30:09', '2018-03-08 08:52:06'),
(15, NULL, '2018-03-09 09:22:10', 40, '2018-03-09 14:23:46', '2018-03-09 14:52:10'),
(16, NULL, '2018-02-21 14:16:08', 42, '2018-02-21 09:11:03', '2018-02-21 09:16:08'),
(17, NULL, '2018-02-22 19:11:44', 43, '2018-02-22 14:11:44', '2018-02-21 12:45:48'),
(18, NULL, '2018-02-21 20:09:59', 44, '2018-02-21 12:59:15', '2018-02-21 15:09:59'),
(19, NULL, '2018-02-26 20:28:05', 45, '2018-02-26 14:55:10', '2018-02-26 15:28:05'),
(20, NULL, NULL, 46, '2018-02-26 16:24:42', NULL),
(21, NULL, '2018-03-04 15:58:38', 47, '2018-03-04 10:43:07', '2018-03-04 10:58:38');

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

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name',
  `user_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `created_at`, `updated_at`, `name`, `user_count`) VALUES
(1, '2017-11-27 03:26:11', '2018-03-04 16:36:19', 'Admin', 11),
(2, '2017-11-27 03:26:11', '2018-04-30 04:58:43', 'Property Owner', 99),
(3, '2017-11-27 03:26:11', '2018-04-25 05:23:05', 'Tenant', 61);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `kryptonit3_counter_page`
--
ALTER TABLE `kryptonit3_counter_page`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kryptonit3_counter_page_page_unique` (`page`);

--
-- Indexes for table `kryptonit3_counter_page_visitor`
--
ALTER TABLE `kryptonit3_counter_page_visitor`
  ADD KEY `kryptonit3_counter_page_visitor_page_id_index` (`page_id`),
  ADD KEY `kryptonit3_counter_page_visitor_visitor_id_index` (`visitor_id`);

--
-- Indexes for table `kryptonit3_counter_visitor`
--
ALTER TABLE `kryptonit3_counter_visitor`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kryptonit3_counter_visitor_visitor_unique` (`visitor`);

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

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_id_index` (`notifiable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `amenity_property`
--
ALTER TABLE `amenity_property`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- AUTO_INCREMENT for table `amenity_statuses`
--
ALTER TABLE `amenity_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `app_codes`
--
ALTER TABLE `app_codes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `app_code_categories`
--
ALTER TABLE `app_code_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `app_code_categories_bkp`
--
ALTER TABLE `app_code_categories_bkp`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `app_code_statuses`
--
ALTER TABLE `app_code_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `biddings`
--
ALTER TABLE `biddings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `contact_queries`
--
ALTER TABLE `contact_queries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contracts`
--
ALTER TABLE `contracts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `kryptonit3_counter_page`
--
ALTER TABLE `kryptonit3_counter_page`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kryptonit3_counter_visitor`
--
ALTER TABLE `kryptonit3_counter_visitor`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `medias`
--
ALTER TABLE `medias`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=204;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `payment_statuses`
--
ALTER TABLE `payment_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `policies`
--
ALTER TABLE `policies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `policy_types`
--
ALTER TABLE `policy_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `properties`
--
ALTER TABLE `properties`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT for table `property_statuses`
--
ALTER TABLE `property_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `property_term`
--
ALTER TABLE `property_term`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `property_views`
--
ALTER TABLE `property_views`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=174;

--
-- AUTO_INCREMENT for table `sms_reports`
--
ALTER TABLE `sms_reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `supports`
--
ALTER TABLE `supports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `surveys`
--
ALTER TABLE `surveys`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tenancy_contracts`
--
ALTER TABLE `tenancy_contracts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1020;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `user_types`
--
ALTER TABLE `user_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

