-- 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-02-15 03:08:52', 'Washer/Dryer In Unit', 'icon-washer', 1, 1, 39),
(2, '2017-12-06 09:55:08', '2018-02-14 03:52:55', 'Pool', 'icon-pool', 2, 1, 42),
(3, '2017-12-06 09:55:08', '2018-02-14 03:22:03', 'Gym', 'icon-gym', 3, 1, 13),
(4, '2017-12-06 09:55:08', '2018-01-29 17:38:06', 'Elevator', 'icon-elevator', 4, 1, 5),
(5, '2017-12-06 09:55:08', '2018-01-25 19:35:58', 'Parking Spot', 'icon-parking-spot', 5, 1, 13),
(6, '2017-12-06 09:55:08', '2018-02-12 09:44:05', 'Fireplace', 'icon-fireplace', 6, 1, 4),
(7, '2017-12-06 09:55:08', '2018-01-29 17:38:06', 'Air Conditioning', 'icon-air-conditioning', 7, 1, 6),
(8, '2017-12-06 09:55:08', '2018-01-30 05:11:15', 'Doorman', 'icon-doorman', 8, 1, 5),
(9, '2017-12-06 09:55:08', '2018-01-24 15:38:57', 'Dishwasher', 'icon-dishwasher', 9, 1, 2),
(10, '2017-12-06 09:55:08', '2018-01-25 19:41:29', 'Deck', 'icon-deck', 10, 1, 1),
(11, '2017-12-06 09:55:08', '2018-02-12 03:31:58', 'Storage', 'icon-storage', 11, 1, 2),
(12, '2017-12-06 09:55:08', '2018-01-23 16:26:19', 'Wheelchair Accessible', 'icon-wheelchair', 12, 1, 1),
(13, '2017-12-06 09:55:08', '2018-01-25 19:41:29', 'Hardwood Floors', 'icon-hardwood', 13, 1, 2),
(14, '2017-12-06 09:55:08', '2018-01-23 16:26:19', 'Garden', 'icon-garden', 14, 1, 1),
(15, '2017-12-06 09:55:08', '2018-01-23 16:26:19', 'Balcony', 'icon-balcony', 15, 1, 1),
(16, '2017-12-06 09:55:08', '2018-01-22 16:23:27', 'Furnished', 'icon-furnished', 16, 1, 0),
(17, '2017-12-06 09:55:08', '2018-01-24 15:38:57', 'View', 'icon-view', 17, 1, 2),
(18, '2017-12-06 09:55:08', '2018-01-23 16:26:19', 'Student Friendly', 'icon-student', 18, 1, 1),
(19, '2017-12-06 09:55:08', '2018-01-22 16:23:27', 'High Rise', 'icon-high-rise', 19, 1, 0),
(20, '2017-12-06 09:55:08', '2018-01-23 16:26:19', 'Utilities Included', 'icon-utilities', 20, 1, 1);

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

--
-- 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-01-23 03:12:51', '2018-01-23 03:12:51', 1, 1),
(2, '2018-01-23 03:12:51', '2018-01-23 03:12:51', 2, 1),
(3, '2018-01-23 03:12:51', '2018-01-23 03:12:51', 3, 1),
(4, '2018-01-23 13:13:46', '2018-01-23 13:13:46', 1, 2),
(5, '2018-01-23 13:13:46', '2018-01-23 13:13:46', 2, 2),
(6, '2018-01-23 13:13:46', '2018-01-23 13:13:46', 3, 2),
(7, '2018-01-23 13:26:29', '2018-01-23 13:26:29', 1, 3),
(8, '2018-01-23 13:26:29', '2018-01-23 13:26:29', 2, 3),
(9, '2018-01-23 13:26:29', '2018-01-23 13:26:29', 3, 3),
(10, '2018-01-23 15:30:34', '2018-01-23 15:30:34', 1, 4),
(11, '2018-01-23 15:30:34', '2018-01-23 15:30:34', 4, 4),
(12, '2018-01-23 15:30:34', '2018-01-23 15:30:34', 7, 4),
(13, '2018-01-23 15:54:00', '2018-01-23 15:54:00', 1, 5),
(14, '2018-01-23 15:54:00', '2018-01-23 15:54:00', 3, 5),
(15, '2018-01-23 15:54:00', '2018-01-23 15:54:00', 5, 5),
(16, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 1, 6),
(17, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 4, 6),
(18, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 12, 6),
(19, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 14, 6),
(20, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 15, 6),
(21, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 17, 6),
(22, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 18, 6),
(23, '2018-01-23 16:26:19', '2018-01-23 16:26:19', 20, 6),
(24, '2018-01-23 16:28:03', '2018-01-23 16:28:03', 2, 7),
(25, '2018-01-23 16:28:03', '2018-01-23 16:28:03', 5, 7),
(26, '2018-01-23 16:28:03', '2018-01-23 16:28:03', 8, 7),
(27, '2018-01-23 20:22:30', '2018-01-23 20:22:30', 2, 8),
(28, '2018-01-23 20:22:30', '2018-01-23 20:22:30', 3, 8),
(29, '2018-01-23 20:28:33', '2018-01-23 20:28:33', 1, 9),
(30, '2018-01-23 20:28:33', '2018-01-23 20:28:33', 2, 9),
(31, '2018-01-23 20:28:33', '2018-01-23 20:28:33', 3, 9),
(32, '2018-01-23 20:47:59', '2018-01-23 20:47:59', 1, 10),
(33, '2018-01-23 20:48:00', '2018-01-23 20:48:00', 5, 10),
(34, '2018-01-23 20:48:00', '2018-01-23 20:48:00', 6, 10),
(35, '2018-01-23 20:48:00', '2018-01-23 20:48:00', 8, 10),
(36, '2018-01-23 20:48:00', '2018-01-23 20:48:00', 9, 10),
(37, '2018-01-23 21:04:19', '2018-01-23 21:04:19', 1, 11),
(38, '2018-01-23 21:04:19', '2018-01-23 21:04:19', 3, 11),
(39, '2018-01-23 21:04:19', '2018-01-23 21:04:19', 5, 11),
(40, '2018-01-23 21:04:19', '2018-01-23 21:04:19', 7, 11),
(41, '2018-01-23 21:15:25', '2018-01-23 21:15:25', 1, 12),
(42, '2018-01-23 21:15:25', '2018-01-23 21:15:25', 2, 12),
(43, '2018-01-23 21:15:25', '2018-01-23 21:15:25', 3, 12),
(44, '2018-01-23 21:25:06', '2018-01-23 21:25:06', 2, 13),
(45, '2018-01-23 21:25:06', '2018-01-23 21:25:06', 5, 13),
(46, '2018-01-23 21:25:06', '2018-01-23 21:25:06', 8, 13),
(47, '2018-01-23 21:41:47', '2018-01-23 21:41:47', 1, 14),
(48, '2018-01-23 21:41:47', '2018-01-23 21:41:47', 5, 14),
(49, '2018-01-24 15:02:50', '2018-01-24 15:02:50', 2, 15),
(50, '2018-01-24 15:02:50', '2018-01-24 15:02:50', 3, 15),
(51, '2018-01-24 15:02:50', '2018-01-24 15:02:50', 5, 15),
(52, '2018-01-24 15:02:50', '2018-01-24 15:02:50', 6, 15),
(53, '2018-01-24 15:38:57', '2018-01-24 15:38:57', 1, 16),
(54, '2018-01-24 15:38:57', '2018-01-24 15:38:57', 5, 16),
(55, '2018-01-24 15:38:57', '2018-01-24 15:38:57', 9, 16),
(56, '2018-01-24 15:38:57', '2018-01-24 15:38:57', 11, 16),
(57, '2018-01-24 15:38:57', '2018-01-24 15:38:57', 13, 16),
(58, '2018-01-24 15:38:57', '2018-01-24 15:38:57', 17, 16),
(59, '2018-01-24 17:00:21', '2018-01-24 17:00:21', 1, 17),
(60, '2018-01-24 17:00:21', '2018-01-24 17:00:21', 2, 17),
(61, '2018-01-24 17:00:21', '2018-01-24 17:00:21', 5, 17),
(62, '2018-01-24 18:55:08', '2018-01-24 18:55:08', 1, 18),
(63, '2018-01-24 18:55:08', '2018-01-24 18:55:08', 2, 18),
(64, '2018-01-24 18:55:08', '2018-01-24 18:55:08', 5, 18),
(65, '2018-01-24 18:55:08', '2018-01-24 18:55:08', 6, 18),
(66, '2018-01-24 19:35:19', '2018-01-24 19:35:19', 4, 19),
(67, '2018-01-24 19:35:19', '2018-01-24 19:35:19', 7, 19),
(68, '2018-01-25 13:50:39', '2018-01-25 13:50:39', 1, 20),
(69, '2018-01-25 13:50:39', '2018-01-25 13:50:39', 4, 20),
(70, '2018-01-25 13:50:39', '2018-01-25 13:50:39', 7, 20),
(71, '2018-01-25 16:00:39', '2018-01-25 16:00:39', 2, 21),
(72, '2018-01-25 16:00:39', '2018-01-25 16:00:39', 5, 21),
(73, '2018-01-25 16:51:49', '2018-01-25 16:51:49', 1, 22),
(74, '2018-01-25 16:51:49', '2018-01-25 16:51:49', 5, 22),
(75, '2018-01-25 19:05:44', '2018-01-25 19:05:44', 7, 23),
(76, '2018-01-25 19:35:58', '2018-01-25 19:35:58', 2, 24),
(77, '2018-01-25 19:35:58', '2018-01-25 19:35:58', 5, 24),
(78, '2018-01-25 19:35:58', '2018-01-25 19:35:58', 8, 24),
(79, '2018-01-25 19:41:29', '2018-01-25 19:41:29', 10, 25),
(80, '2018-01-25 19:41:29', '2018-01-25 19:41:29', 13, 25),
(81, '2018-01-29 15:34:59', '2018-01-29 15:34:59', 1, 26),
(82, '2018-01-29 15:34:59', '2018-01-29 15:34:59', 2, 26),
(83, '2018-01-29 15:34:59', '2018-01-29 15:34:59', 3, 26),
(84, '2018-01-29 17:38:06', '2018-01-29 17:38:06', 1, 27),
(85, '2018-01-29 17:38:06', '2018-01-29 17:38:06', 4, 27),
(86, '2018-01-29 17:38:06', '2018-01-29 17:38:06', 7, 27),
(87, '2018-01-30 03:58:43', '2018-01-30 03:58:43', 1, 28),
(88, '2018-01-30 03:58:43', '2018-01-30 03:58:43', 2, 28),
(89, '2018-01-30 05:11:15', '2018-01-30 05:11:15', 8, 29),
(90, '2018-02-01 05:29:35', '2018-02-01 05:29:35', 1, 30),
(91, '2018-02-01 05:29:35', '2018-02-01 05:29:35', 2, 30),
(92, '2018-02-01 05:29:35', '2018-02-01 05:29:35', 3, 30),
(93, '2018-02-02 05:45:44', '2018-02-02 05:45:44', 2, 31),
(94, '2018-02-02 05:45:44', '2018-02-02 05:45:44', 3, 31),
(95, '2018-02-09 03:51:11', '2018-02-09 03:51:11', 1, 32),
(96, '2018-02-09 03:54:20', '2018-02-09 03:54:20', 2, 33),
(97, '2018-02-09 03:54:45', '2018-02-09 03:54:45', 2, 34),
(98, '2018-02-09 03:55:26', '2018-02-09 03:55:26', 2, 35),
(99, '2018-02-09 03:55:57', '2018-02-09 03:55:57', 2, 36),
(100, '2018-02-09 03:57:59', '2018-02-09 03:57:59', 2, 37),
(101, '2018-02-09 04:03:15', '2018-02-09 04:03:15', 2, 38),
(102, '2018-02-09 04:03:23', '2018-02-09 04:03:23', 2, 39),
(103, '2018-02-09 04:05:54', '2018-02-09 04:05:54', 1, 40),
(104, '2018-02-09 04:05:54', '2018-02-09 04:05:54', 2, 40),
(105, '2018-02-09 04:08:11', '2018-02-09 04:08:11', 1, 41),
(106, '2018-02-09 04:08:12', '2018-02-09 04:08:12', 2, 41),
(107, '2018-02-09 04:08:54', '2018-02-09 04:08:54', 1, 42),
(108, '2018-02-09 04:08:54', '2018-02-09 04:08:54', 2, 42),
(109, '2018-02-09 04:12:06', '2018-02-09 04:12:06', 1, 43),
(110, '2018-02-09 04:12:06', '2018-02-09 04:12:06', 2, 43),
(111, '2018-02-09 04:12:17', '2018-02-09 04:12:17', 1, 44),
(112, '2018-02-09 04:12:17', '2018-02-09 04:12:17', 2, 44),
(113, '2018-02-09 04:12:44', '2018-02-09 04:12:44', 1, 45),
(114, '2018-02-09 04:12:44', '2018-02-09 04:12:44', 2, 45),
(115, '2018-02-09 04:13:04', '2018-02-09 04:13:04', 1, 46),
(116, '2018-02-09 04:13:04', '2018-02-09 04:13:04', 2, 46),
(117, '2018-02-09 04:13:43', '2018-02-09 04:13:43', 1, 47),
(118, '2018-02-09 04:13:43', '2018-02-09 04:13:43', 2, 47),
(119, '2018-02-09 04:14:37', '2018-02-09 04:14:37', 1, 48),
(120, '2018-02-09 04:14:37', '2018-02-09 04:14:37', 2, 48),
(121, '2018-02-09 04:16:56', '2018-02-09 04:16:56', 1, 49),
(122, '2018-02-09 04:16:56', '2018-02-09 04:16:56', 2, 49),
(123, '2018-02-09 04:17:07', '2018-02-09 04:17:07', 1, 50),
(124, '2018-02-09 04:17:07', '2018-02-09 04:17:07', 2, 50),
(125, '2018-02-09 04:17:35', '2018-02-09 04:17:35', 1, 51),
(126, '2018-02-09 04:17:36', '2018-02-09 04:17:36', 2, 51),
(127, '2018-02-09 04:18:14', '2018-02-09 04:18:14', 1, 52),
(128, '2018-02-09 04:18:14', '2018-02-09 04:18:14', 2, 52),
(129, '2018-02-09 04:19:19', '2018-02-09 04:19:19', 1, 53),
(130, '2018-02-09 04:19:19', '2018-02-09 04:19:19', 2, 53),
(131, '2018-02-09 04:20:11', '2018-02-09 04:20:11', 1, 54),
(132, '2018-02-09 04:20:11', '2018-02-09 04:20:11', 2, 54),
(133, '2018-02-12 03:31:58', '2018-02-12 03:31:58', 11, 55),
(134, '2018-02-12 09:44:05', '2018-02-12 09:44:05', 2, 56),
(135, '2018-02-12 09:44:05', '2018-02-12 09:44:05', 6, 56),
(136, '2018-02-14 03:22:03', '2018-02-14 03:22:03', 1, 57),
(137, '2018-02-14 03:22:03', '2018-02-14 03:22:03', 2, 57),
(138, '2018-02-14 03:22:03', '2018-02-14 03:22:03', 3, 57),
(139, '2018-02-14 03:52:55', '2018-02-14 03:52:55', 1, 58),
(140, '2018-02-14 03:52:55', '2018-02-14 03:52:55', 2, 58),
(141, '2018-02-15 03:08:52', '2018-02-15 03:08:52', 1, 59);

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

--
-- 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, 'Leave the keys with the building security', 1),
(14, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 3, 'Leave the property open', 2),
(15, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 3, 'Not provide an option to view the property', 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, 'Retired', 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);

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

--
-- 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);

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

--
-- 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'
) 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`) VALUES
(1, '2018-01-23 13:16:20', '2018-02-09 04:43:33', 2, 2, '1600.00', '2018-02-05', 'Tenant note', 37, 'Note 3 private', 42, 55, 45, '2018-02-03 00:00:00', 0),
(2, '2018-01-23 13:21:50', '2018-02-06 05:45:31', 1, 2, '1500.00', '2018-02-02', 'test note', 38, 'gfhgfchfghfghghgh', 41, 55, 45, '2018-02-02 00:00:00', 0),
(3, '2018-01-23 13:33:30', '2018-02-06 04:23:07', 3, 2, '2100.00', '2018-02-02', 'test temnant note', 36, 'tets', 42, 55, 45, '2018-01-23 08:33:43', 0),
(4, '2018-01-23 13:48:46', '2018-02-06 04:23:07', 1, 3, '1500.00', '2018-02-04', 'testing', 38, 'dfgbdfgdf', 42, 55, 45, '2018-01-23 09:23:58', 0),
(5, '2018-01-23 15:50:06', '2018-01-24 14:38:33', 4, 6, '7800.00', '2018-01-30', 'Interested.', 37, 'Make the payment.', 41, 55, 45, NULL, 0),
(6, '2018-01-23 15:55:16', '2018-01-23 19:24:44', 5, 6, '8800.00', '2018-01-31', 'ddd', 36, 'added the note.', 41, 54, 45, '2018-01-23 10:56:42', 1),
(7, '2018-01-23 20:49:01', '2018-01-24 14:29:17', 10, 6, '7200.00', '2018-02-14', 'Interested in staying.', 39, 'You can make the payment whenever possible', 41, 54, 45, '2018-01-23 15:50:45', 2),
(8, '2018-01-23 21:16:27', '2018-01-24 14:28:02', 11, 6, '7800.00', '2018-02-28', 'Interested..', 36, 'Payment made.', 41, 54, 45, '2018-01-23 16:17:01', 3),
(9, '2018-01-23 21:30:08', '2018-02-06 04:23:08', 13, 6, '9300.00', '2018-02-28', 'dfdd', 36, 'Updated the note', 42, 55, 45, '2018-01-23 16:30:39', 0),
(10, '2018-01-24 15:23:53', '2018-02-06 04:23:08', 15, 6, '8300.00', '2018-02-27', 'Interested..', 39, 'Selected your property.', 41, 55, 45, '2018-01-24 10:24:34', 0),
(11, '2018-01-24 15:45:17', '2018-01-24 15:47:36', 16, 10, '3000.00', '2018-02-02', 'Test rent', 39, '', 0, 55, 45, NULL, 0),
(12, '2018-01-24 15:48:49', '2018-01-24 15:48:49', 16, 10, '2500.00', '2018-01-31', 'Tenant Note', 36, '', 0, 46, 45, NULL, 0),
(13, '2018-01-24 17:13:07', '2018-01-24 19:31:10', 17, 8, '9200.00', '2018-02-22', 'Interested in staying', 38, 'That\'s great', 41, 51, 45, '2018-01-24 12:14:50', 0),
(14, '2018-01-24 18:38:32', '2018-02-09 04:46:16', 7, 13, '7100.00', '2018-01-30', 'Interested in making payment..', 38, 'Make the payment asap.', 41, 55, 45, '2018-01-24 13:39:23', 0),
(15, '2018-01-24 18:57:36', '2018-01-24 19:12:42', 18, 8, '8000.00', '2018-02-20', 'Interested with the property.', 37, 'Ok make the payment.', 41, 54, 45, '2018-01-24 13:58:04', 4),
(16, '2018-01-24 19:50:47', '2018-01-24 20:20:57', 19, 8, '9000.00', '2018-02-28', 'Interested..', 36, 'Ready for the payment', 41, 54, 45, '2018-01-24 14:51:22', 5),
(17, '2018-01-25 13:52:26', '2018-01-25 13:58:35', 20, 8, '9300.00', '2018-02-22', 'Interested on the same date.', 38, 'Grt.. Make the payment', 41, 54, 45, '2018-01-25 08:54:43', 6),
(18, '2018-01-25 16:01:36', '2018-01-25 16:04:35', 21, 8, '7600.00', '2018-02-15', 'Interested.', 38, 'Fine with the payment.', 41, 55, 45, NULL, 0),
(19, '2018-01-25 16:53:01', '2018-01-25 17:04:19', 22, 8, '8200.00', '2018-02-21', 'dd', 36, '', 0, 55, 45, NULL, 0),
(20, '2018-01-25 20:26:07', '2018-01-25 21:01:32', 24, 8, '8800.00', '2018-02-22', 'Interested', 36, '', 0, 49, 45, NULL, 0),
(21, '2018-01-25 20:30:13', '2018-01-25 20:34:36', 12, 10, '1500.00', '2018-02-01', 'Noye', 36, '', 0, 55, 45, NULL, 0),
(22, '2018-01-25 20:57:18', '2018-01-25 21:04:39', 24, 15, '8800.00', '2018-02-23', 'Interested..', 36, '', 0, 54, 45, '2018-01-25 15:59:00', 7),
(23, '2018-01-25 21:36:51', '2018-01-25 21:36:51', 12, 10, '1000.00', '2018-01-31', 'test', 36, '', 0, 46, 45, NULL, 0),
(24, '2018-01-25 21:38:32', '2018-01-25 21:38:32', 12, 10, '1000.00', '2018-01-31', 'test', 36, '', 0, 46, 45, NULL, 0),
(25, '2018-01-29 13:03:14', '2018-01-29 13:03:35', 25, 3, '8889.00', '2018-02-11', 'Tenant note', 36, 'note', 41, 46, 45, NULL, 0),
(26, '2018-01-29 15:37:06', '2018-01-29 15:40:23', 26, 2, '2000.00', '2018-02-05', 'Nitefgh', 36, '', 0, 54, 45, '2018-01-29 10:38:22', 8),
(27, '2018-01-29 17:47:12', '2018-01-29 17:47:12', 27, 13, '8800.00', '2018-02-21', 'Interested', 37, '', 0, 46, 45, NULL, 0),
(28, '2018-01-30 04:00:17', '2018-02-06 04:23:08', 28, 2, '1500.00', '2018-02-02', 'aserfasfsdf', 40, '', 0, 55, 45, '2018-01-30 09:30:29', 0),
(29, '2018-02-01 05:30:21', '2018-02-01 05:30:21', 30, 3, '3100.00', '2018-02-28', 'adasdcasasf', 40, '', 0, 46, 45, NULL, 0),
(30, '2018-02-02 05:46:41', '2018-02-02 05:57:20', 31, 2, '324234.00', '2018-02-28', 'sdfsdfc', 38, '', 0, 46, 45, NULL, 0),
(31, '2018-02-09 04:30:25', '2018-02-09 04:30:25', 39, 2, '6456.00', '2018-03-01', 'sdfsgf', 37, '', 0, 46, 45, NULL, 0),
(32, '2018-02-09 04:30:59', '2018-02-09 04:30:59', 34, 2, '6456.00', '2018-03-22', 'wefsdvg', 40, '', 0, 46, 45, NULL, 0),
(33, '2018-02-09 04:45:10', '2018-02-09 04:45:10', 40, 13, '546.00', '2018-02-28', 'tyjnfgj', 36, '', 0, 46, 45, NULL, 0),
(34, '2018-02-12 03:43:15', '2018-02-12 03:43:15', 42, 2, '546.00', '2018-02-22', 'hfghfgh', 36, '', 0, 46, 45, NULL, 0),
(35, '2018-02-14 03:24:30', '2018-02-14 03:35:28', 57, 2, '2345.00', '2018-02-28', 'sdcscdasd', 36, '', 0, 48, 45, '2018-02-14 09:05:28', 0);

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

--
-- 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-01-23 19:24:44', '2018-01-23 19:24:44', 5, 5, 6, 6, 'media/contract/6/Image_1149716421.doc'),
(2, '2018-01-23 20:53:02', '2018-01-23 20:53:02', 10, 5, 7, 6, 'media/contract/7/Image_22838900.docx'),
(3, '2018-01-23 21:19:50', '2018-01-23 21:19:50', 11, 5, 8, 6, 'media/contract/8/Image_2004014173.docx'),
(5, '2018-01-24 20:20:57', '2018-01-24 20:20:57', 19, 4, 16, 8, 'media/contract/16/Image_945508052.pdf'),
(6, '2018-01-25 13:58:35', '2018-01-25 13:58:35', 20, 4, 17, 8, 'media/contract/17/Image_1161810360.pdf'),
(7, '2018-01-25 21:04:39', '2018-01-25 21:04:39', 24, 14, 22, 15, 'media/contract/22/Image_662787170.pdf'),
(8, '2018-01-29 15:40:23', '2018-01-29 15:40:23', 26, 16, 26, 2, 'media/contract/26/Image_1135579017.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-05 04:34:08'),
(1, 2, '2018-02-02 05:28:32'),
(1, 3, '2018-02-13 21:37:01'),
(1, 4, '2018-02-02 05:31:22'),
(1, 5, '2018-02-05 09:50:28'),
(1, 6, '2018-02-09 04:44:56'),
(1, 7, '2018-02-06 09:31:14'),
(1, 8, '2018-02-09 04:45:35'),
(1, 9, '2018-02-15 04:32:53'),
(1, 10, '2018-02-12 08:54:40'),
(1, 11, '2018-02-15 04:02:37');

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

--
-- 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
(11, '09e7509882e1417f1bb5a169100bacb1327cf425263685ffc660864d04467b93'),
(7, '2dbeed9058681edcc4a9f9402e56c3c3a6f9d46f7e6978358e15d95df7e2762f'),
(2, '33f0add49078159c31b20aa4051cbf4cb3e1dc83c58b712a77b4996fcde3e98c'),
(4, '402f8e48c1c875f7a965cb09b798f712156d539589be2103b7562b68a4ece2cb'),
(6, '611bab66301e340f7863e93917db24a87008c701ec30b3262900788d86fce3cf'),
(5, '68d89fc71cd100993418ffe930d89b8fdea4b54bb077c1155d5e4daa124645c6'),
(1, '724106d5c7455d566f53e6fc407661f4044b363d640e915cfe7f94b991c6e027'),
(8, '9db894d2136b40024ee7b0288da07970cf53c6172116ab53c2399a042c4f1fee'),
(10, '9f16a0006fee22166f2be7a9d95830cc67f82c4317c77d451313fd7d5fda36c2'),
(3, 'd30cb287159c689bf6a5edbe62121d26f28cb69ddad0a88a8139b4138e3716c0'),
(9, 'ecdc3feb52973f1c1e6c7ee913ce05cf7ecc98e93c4c9dc4bf296fc3168898c3');

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

--
-- 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
(2, '2018-01-23 03:14:28', '2018-01-23 03:14:28', 1, 1, 'media/landlord/1/Image_211836532.jpg'),
(5, '2018-01-23 16:28:03', '2018-01-23 16:28:03', 1, 7, 'media/landlord/5/Image_1036742122.jpg'),
(6, '2018-01-23 20:28:33', '2018-01-23 20:28:33', 1, 9, 'media/landlord/5/Image_961230507.jpg'),
(7, '2018-01-23 20:28:33', '2018-01-23 20:28:33', 1, 9, 'media/landlord/5/Image_245952290.jpg'),
(8, '2018-01-23 20:28:33', '2018-01-23 20:28:33', 1, 9, 'media/landlord/5/Image_1509613763.jpeg'),
(9, '2018-01-23 20:48:00', '2018-01-23 20:48:00', 1, 10, 'media/landlord/5/Image_708612802.jpg'),
(10, '2018-01-23 20:48:00', '2018-01-23 20:48:00', 1, 10, 'media/landlord/5/Image_1264601858.jpeg'),
(11, '2018-01-23 21:04:19', '2018-01-23 21:04:19', 1, 11, 'media/landlord/5/Image_191773890.jpeg'),
(12, '2018-01-23 21:04:19', '2018-01-23 21:04:19', 1, 11, 'media/landlord/5/Image_1509878402.png'),
(14, '2018-01-23 21:25:06', '2018-01-23 21:25:06', 1, 13, 'media/landlord/5/Image_1716135486.jpeg'),
(15, '2018-01-24 15:02:50', '2018-01-24 15:02:50', 1, 15, 'media/landlord/5/Image_1490357325.jpg'),
(16, '2018-01-24 15:02:50', '2018-01-24 15:02:50', 1, 15, 'media/landlord/5/Image_438030494.png'),
(17, '2018-01-24 18:55:08', '2018-01-24 18:55:08', 1, 18, 'media/landlord/4/Image_878874786.jpg'),
(18, '2018-01-24 18:55:08', '2018-01-24 18:55:08', 1, 18, 'media/landlord/4/Image_823795291.jpg'),
(19, '2018-01-25 16:00:39', '2018-01-25 16:00:39', 1, 21, 'media/landlord/4/Image_1666966782.jpg'),
(20, '2018-01-25 21:55:13', '2018-01-25 21:55:13', 1, 12, 'media/landlord/9/Image_976206409.jpg'),
(21, '2018-01-25 21:56:05', '2018-01-25 21:56:05', 1, 12, 'media/landlord/9/Image_1751444730.jpg'),
(22, '2018-01-25 21:57:35', '2018-01-25 21:57:35', 1, 16, 'media/landlord/9/Image_1661794124.jpg'),
(23, '2018-02-01 05:29:35', '2018-02-01 05:29:35', 1, 30, 'media/landlord/14/Image_445118221.jpg'),
(24, '2018-02-01 05:29:35', '2018-02-01 05:29:35', 1, 30, 'media/landlord/14/Image_112986541.jpg'),
(25, '2018-02-02 05:45:44', '2018-02-02 05:45:44', 1, 31, 'media/landlord/1/Image_1383523873.jpg'),
(26, '2018-02-09 03:54:20', '2018-02-09 03:54:20', 1, 33, 'media/landlord/18/Image_99641435.jpg'),
(27, '2018-02-09 03:54:45', '2018-02-09 03:54:45', 1, 34, 'media/landlord/18/Image_1133535356.jpg'),
(28, '2018-02-09 03:55:26', '2018-02-09 03:55:26', 1, 35, 'media/landlord/18/Image_333698674.jpg'),
(29, '2018-02-09 03:55:57', '2018-02-09 03:55:57', 1, 36, 'media/landlord/18/Image_1490016035.jpg'),
(30, '2018-02-09 03:57:59', '2018-02-09 03:57:59', 1, 37, 'media/landlord/18/Image_1561833529.jpg'),
(31, '2018-02-09 04:03:15', '2018-02-09 04:03:15', 1, 38, 'media/landlord/18/Image_1972251000.jpg'),
(32, '2018-02-09 04:03:23', '2018-02-09 04:03:23', 1, 39, 'media/landlord/18/Image_1722597459.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, '2015_06_21_181359_create_kryptonit3_counter_page_table', 20),
(103, '2015_06_21_193003_create_kryptonit3_counter_visitor_table', 20),
(104, '2015_06_21_193059_create_kryptonit3_counter_page_visitor_table', 20),
(105, '2018_01_04_142751_alter_users_tabel', 21),
(106, '2018_01_16_080320_alter_properties_table', 21),
(107, '2018_02_01_081100_create_notes_table', 21),
(108, '2018_02_06_133204_create_property_views_table', 22),
(109, '2018_02_13_132614_update_properties_table', 23),
(110, '2018_02_15_080534_update_properties_table', 24),
(111, '2018_02_15_082705_update_properties_table', 25);

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

--
-- 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
(2, '2018-02-01 03:29:07', '2018-02-01 03:29:07', 4, 1, 42, 'Test2'),
(3, '2018-02-01 03:41:21', '2018-02-01 03:41:21', 4, 1, 41, 'Test note 2'),
(4, '2018-02-01 04:16:32', '2018-02-01 04:16:32', 4, 1, 42, 'Test note 3'),
(5, '2018-02-01 04:22:12', '2018-02-01 04:22:12', 4, 1, 42, 'dfgbdfgdf'),
(6, '2018-02-01 04:24:59', '2018-02-01 04:24:59', 1, 1, 41, 'note1'),
(7, '2018-02-01 04:35:53', '2018-02-01 04:35:53', 1, 1, 41, 'note2'),
(8, '2018-02-01 04:39:01', '2018-02-01 04:39:01', 1, 1, 42, 'Note 3 private'),
(9, '2018-02-01 08:41:46', '2018-02-01 08:41:46', 3, 1, 41, 'khghjghj'),
(10, '2018-02-01 08:42:17', '2018-02-01 08:42:17', 3, 1, 41, '65765765'),
(11, '2018-02-01 08:43:50', '2018-02-01 08:43:50', 3, 1, 41, 'fdgfdgdfg'),
(12, '2018-02-01 08:45:17', '2018-02-01 08:45:17', 3, 1, 41, 'fgdfxgdfg'),
(13, '2018-02-01 08:45:48', '2018-02-01 08:45:48', 3, 1, 42, 'dfsdf'),
(14, '2018-02-01 09:11:13', '2018-02-01 09:11:13', 3, 1, 41, 'hgjnghjghj'),
(15, '2018-02-01 09:37:27', '2018-02-01 09:37:27', 3, 1, 42, 'tets');

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

--
-- 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
) 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`) VALUES
('04553792-0e01-45be-93f0-477c402fcab8', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"18\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-25 16:01:57', '2018-01-25 16:01:57'),
('0466817b-e337-4ac1-830e-1e6cdfec199a', 'App\\Notifications\\PostNewNotification', 18, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"42\",\"message\":\"Neo Trinity made a bid against your property wert\"}', NULL, '2018-02-12 03:43:15', '2018-02-12 03:43:15'),
('05371d48-13d2-48bf-a4ee-2c426357a21e', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"3\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-23 13:33:51', '2018-01-23 13:33:43', '2018-01-23 13:33:51'),
('067191b2-f3b8-4a17-9824-4fd4db80e3b1', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:17:47', '2018-01-24 17:17:47'),
('0831d6cc-c8e5-4cb8-b3ef-6c7e62c56334', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-23 15:57:09', '2018-01-23 15:56:42', '2018-01-23 15:57:09'),
('0cb9d3d7-a4f6-459f-8cc6-bdbb1853306f', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"15\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-24 18:58:04', '2018-01-24 18:58:04'),
('0d035318-ec66-4eaa-b404-41b45a9f094a', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"2\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 13:22:17', '2018-01-23 13:22:17'),
('0f3281b6-161d-4f1f-8afa-915d8cbd4c5b', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"11\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-24 18:09:16', '2018-01-24 15:47:04', '2018-01-24 18:09:16'),
('13e0a68d-6af6-4ca3-af5f-7c51f667c9d2', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"7\",\"message\":\"shreya jain made a bid against your property test\"}', NULL, '2018-01-24 18:38:32', '2018-01-24 18:38:32'),
('14d1157a-d0d7-4cfa-aa4f-55907d8d0644', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"16\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-24 19:52:16', '2018-01-24 19:51:34', '2018-01-24 19:52:16'),
('161d1ef1-ef08-479f-a774-8799b748e6bc', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"7\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-23 20:50:45', '2018-01-23 20:50:45'),
('18f5b123-2e7a-4e43-b21f-fea69219968b', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"1\",\"message\":\"Neo Trinity made a bid against your property Estate Valley\"}', '2018-02-01 08:16:24', '2018-01-23 13:21:50', '2018-02-01 08:16:24'),
('19a44e0b-fef1-4c65-9f07-450579b19639', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 19:18:53', '2018-01-24 19:18:53'),
('1b1aedc4-a92b-4c0b-a56d-bdd865e13b2c', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"16\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-24 19:51:22', '2018-01-24 19:51:22'),
('1e18439e-e558-4054-9302-cbf47fe51d1a', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-24 17:15:24', '2018-01-24 17:14:50', '2018-01-24 17:15:24'),
('1ff8253e-4617-4801-b0e4-0a8c9b4bda78', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:31:24', '2018-01-23 21:31:24'),
('212196d9-66d6-4fe7-899b-a61d2621fa07', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"15\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 18:58:23', '2018-01-24 18:58:23'),
('2139ba22-3e00-4511-979f-5f38457d3385', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"3\",\"message\":\"Neo Trinity made a bid against your property Raheja Property\"}', '2018-01-23 13:33:38', '2018-01-23 13:33:30', '2018-01-23 13:33:38'),
('2288229e-80ea-4e03-bec3-9d9ee70f93ef', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"11\",\"message\":\"Shreya Sharma made a bid against your property Silvery\"}', '2018-01-24 14:24:57', '2018-01-23 21:16:27', '2018-01-24 14:24:57'),
('2444da2a-7a5b-4372-91ac-eceb6526ed15', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 16:11:40', '2018-01-23 16:11:40'),
('24a237c0-bf25-485a-aa7e-4f26d3cd5e8c', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":15,\"property_id\":18,\"message\":\"Bidder has paid the commision fees against property hggg\"}', '2018-01-24 18:59:52', '2018-01-24 18:59:33', '2018-01-24 18:59:52'),
('266a64e6-8ec8-4ea6-8ae1-02222345c785', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"18\",\"message\":\"cc cc made a bid against your property hggg\"}', '2018-01-24 18:57:48', '2018-01-24 18:57:36', '2018-01-24 18:57:48'),
('29928d3e-1183-495b-a67e-c7c4cdbce3e6', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 19:20:06', '2018-01-24 19:20:06'),
('2ca6abb3-13e5-4584-b2f9-37211b356482', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":13,\"property_id\":17,\"message\":\"Bidder has paid the commision fees against property counter property\"}', NULL, '2018-01-24 19:31:10', '2018-01-24 19:31:10'),
('2ca77304-bdd8-4e28-9c2c-7f532b84c744', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:17:43', '2018-01-24 17:17:43'),
('2daf5082-7879-4166-9f01-c2a345370284', 'App\\Notifications\\PostNewNotification', 3, 'App\\Models\\User', '{\"bid_id\":\"4\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-23 14:25:27', '2018-01-23 14:23:58', '2018-01-23 14:25:27'),
('2e0d855f-8c35-4866-a6e1-ae45293877b0', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":16,\"property_id\":19,\"message\":\"Bidder has paid the commision fees against property Testing\"}', '2018-01-24 20:12:19', '2018-01-24 19:52:51', '2018-01-24 20:12:19'),
('2e8178ad-e690-4dcc-a7c7-44be16986498', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":21,\"message\":\"cc ccss has opt-out from the bid\"}', NULL, '2018-01-25 16:04:35', '2018-01-25 16:04:35'),
('30e42836-76d9-441f-8af9-deceabd06985', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"1\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-23 13:17:20', '2018-01-23 13:17:10', '2018-01-23 13:17:20'),
('31091968-5392-4a64-9bfa-0a2dc5feabc3', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"2\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 13:23:03', '2018-01-23 13:23:03'),
('33b7f685-0420-4962-b005-8a78e1a6c6c0', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"57\",\"message\":\"Neo Trinity made a bid against your property gbdfgdfg\"}', '2018-02-14 03:24:47', '2018-02-14 03:24:30', '2018-02-14 03:24:47'),
('3467cb58-4115-42a8-b0c0-71f6b10f2c13', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"28\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-02-01 08:15:59', '2018-01-30 04:00:54', '2018-02-01 08:15:59'),
('34cb1701-f6d5-4efe-ab6a-c31e1bf4e558', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-25 20:08:18', '2018-01-24 19:18:59', '2018-01-25 20:08:18'),
('36982d55-c2c2-4fcb-bee6-e83f653b1286', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"8\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:17:28', '2018-01-23 21:17:28'),
('390229e3-724c-466c-8782-de0e71d20432', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"12\",\"message\":\"Anto Nishanth made a bid against your property Property Owner Oops test\"}', NULL, '2018-01-25 20:30:13', '2018-01-25 20:30:13'),
('39b967ca-3a70-4457-b2eb-3c9d35061e70', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"11\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-24 15:46:03', '2018-01-24 15:45:40', '2018-01-24 15:46:03'),
('3a2c7348-7bba-4c60-9eb7-f13db478de3b', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 19:24:11', '2018-01-24 19:24:11'),
('3ba5a255-4893-4a38-bf0a-560c21504624', 'App\\Notifications\\PostNewNotification', 9, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"16\",\"message\":\"Anto Nishanth made a bid against your property Anto nishanth Oops\"}', '2018-01-25 18:06:11', '2018-01-24 15:45:18', '2018-01-25 18:06:11'),
('3c0e601c-60ed-418b-8c66-18a1351647a3', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":22,\"message\":\"cc ccss has opt-out from the bid\"}', NULL, '2018-01-25 17:04:19', '2018-01-25 17:04:19'),
('408baaaf-2ba5-49d6-b507-3c71a8718ecb', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 16:38:23', '2018-01-23 16:38:23'),
('430e9b87-9691-479c-a8c8-1709aa7cd2f8', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"28\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-02-01 08:16:11', '2018-01-30 04:00:38', '2018-02-01 08:16:11'),
('43105895-112f-4d5f-8214-151ce72abaae', 'App\\Notifications\\PostNewNotification', 9, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":16,\"message\":\"Anto Nishanth has opt-out from the bid\"}', NULL, '2018-01-24 15:47:36', '2018-01-24 15:47:36'),
('44a1e46a-084a-4222-a37c-8cb3b2519115', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"21\",\"message\":\"cc ccss made a bid against your property Silven\"}', NULL, '2018-01-25 16:01:36', '2018-01-25 16:01:36'),
('44fad841-93f9-4204-8d9a-47a6c977343a', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:31:30', '2018-01-23 21:31:30'),
('45043393-ab2f-44d5-ba17-ef0c9bc0df98', 'App\\Notifications\\PostNewNotification', 15, 'App\\Models\\User', '{\"bid_id\":\"22\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-25 20:59:13', '2018-01-25 20:59:13'),
('46bb87ed-79d0-470f-b5ef-3b7423c01c78', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-24 15:24:34', '2018-01-24 15:24:34'),
('48d94480-ed14-49a9-a65e-6e51bc159965', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"4\",\"message\":\"Shreya Sharma made a bid against your property Aqualily\"}', NULL, '2018-01-23 15:50:06', '2018-01-23 15:50:06'),
('4949dec6-ed2f-43d4-b8a2-b1889ce5bbf2', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:30:53', '2018-01-23 21:30:53'),
('495faf4a-2e95-47b1-86ff-306f48c397ff', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:25:32', '2018-01-24 15:25:32'),
('4a1cee2e-33e3-4800-b561-992219d65dcd', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:32:10', '2018-01-23 21:32:10'),
('4e84e165-78e8-42c6-85fd-923e828865f5', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"28\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-30 04:00:47', '2018-01-30 04:00:47'),
('4fc47bf1-dbca-4fa6-b649-55e014928fa2', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"5\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-23 15:51:30', '2018-01-23 15:51:30'),
('50585eb4-3898-463b-b1c0-0a62b158685c', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 16:00:46', '2018-01-23 16:00:46'),
('50de1b0e-cc00-4009-9238-3b6cd63d23dc', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"7\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 20:51:19', '2018-01-23 20:51:19'),
('53d4905d-04ee-4445-960b-017ffc8f9aeb', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"28\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-30 04:00:43', '2018-01-30 04:00:43'),
('54d0b54a-c196-49e6-aff2-8618b4c28bfa', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:39:32', '2018-01-24 15:39:32'),
('588a1e28-26f0-4a99-924b-cc34abcfd02a', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:17:51', '2018-01-24 17:17:51'),
('5d2d5a13-5270-4dfe-b3ba-519999781085', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"31\",\"message\":\"Neo Trinity made a bid against your property Bid test\"}', NULL, '2018-02-02 05:46:41', '2018-02-02 05:46:41'),
('5e872450-cbb2-4993-af95-0c7ebba724a5', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:27:43', '2018-01-24 17:27:43'),
('61db5f9e-984a-42a2-a298-ae3377745d9e', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"28\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-30 04:00:34', '2018-01-30 04:00:29', '2018-01-30 04:00:34'),
('62d4a1e5-25e1-4624-97f4-86cdd357707c', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"16\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 19:52:19', '2018-01-24 19:52:19'),
('638c533e-b4f0-408d-a314-bff247225be2', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 19:19:22', '2018-01-24 19:19:22'),
('643f7a4a-5730-4216-8364-8ca6dd881b5e', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"15\",\"message\":\"Shreya Sharma made a bid against your property Aquality\"}', NULL, '2018-01-24 15:23:53', '2018-01-24 15:23:53'),
('660104d2-07f6-4698-9427-ec40c8d79325', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-25 20:33:02', '2018-01-24 17:15:50', '2018-01-25 20:33:02'),
('676bdc25-0a22-47c3-890e-c8209e0648f4', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"7\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 20:51:29', '2018-01-23 20:51:29'),
('6d73c624-ea14-4a98-9d46-0186b86e53fa', 'App\\Notifications\\PostNewNotification', 14, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"24\",\"message\":\"cc ccss made a bid against your property ghg\"}', '2018-01-25 20:59:56', '2018-01-25 20:26:07', '2018-01-25 20:59:56'),
('6ed9a97b-67d3-4cc7-84c0-aa65aacc98ac', 'App\\Notifications\\PostNewNotification', 3, 'App\\Models\\User', '{\"bid_id\":\"4\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-23 14:30:08', '2018-01-23 14:25:32', '2018-01-23 14:30:08'),
('70d08943-2acd-4357-bc16-cb3e2217affd', 'App\\Notifications\\PostNewNotification', 18, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"39\",\"message\":\"Neo Trinity made a bid against your property dg\"}', NULL, '2018-02-09 04:30:25', '2018-02-09 04:30:25'),
('725c3926-d5bb-49a1-a7a6-a3e12df67965', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:17:55', '2018-01-24 17:17:55'),
('7364095a-653a-4f57-8e89-5841c5cfc4b0', 'App\\Notifications\\PostNewNotification', 18, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"40\",\"message\":\"shreya jain made a bid against your property wert\"}', NULL, '2018-02-09 04:45:10', '2018-02-09 04:45:10'),
('759a2498-aebb-461f-9568-affc437c3a48', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:32:04', '2018-01-23 21:32:04'),
('787a1864-5144-49d3-aa1b-aded631d97a7', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"5\",\"message\":\"Shreya Sharma made a bid against your property sss\"}', '2018-01-23 15:56:37', '2018-01-23 15:55:16', '2018-01-23 15:56:37'),
('7a1f6a02-9fe8-4f6c-88df-4574f7b85be7', 'App\\Notifications\\PostNewNotification', 16, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"26\",\"message\":\"Neo Trinity made a bid against your property Clark Inn\"}', '2018-01-29 15:38:16', '2018-01-29 15:37:06', '2018-01-29 15:38:16'),
('7ace8b92-8e3b-4a58-8d56-0d172b54cb39', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:31:01', '2018-01-23 21:31:01'),
('7cbb0265-c234-4b3c-b3ef-ad5f845f9998', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-25 20:33:33', '2018-01-24 19:19:18', '2018-01-25 20:33:33'),
('7d0f0d08-1121-48a8-863a-b95cd1080f46', 'App\\Notifications\\PostNewNotification', 13, 'App\\Models\\User', '{\"bid_id\":\"14\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 18:39:40', '2018-01-24 18:39:40'),
('7d76318b-2856-4054-9547-c0c92b402aee', 'App\\Notifications\\PostNewNotification', 15, 'App\\Models\\User', '{\"bid_id\":\"22\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-25 21:00:50', '2018-01-25 21:00:50'),
('7fc65a2e-0740-4e11-9eac-cae4dfe02a92', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":20,\"property_id\":24,\"message\":\"Your bid has been rejected \"}', NULL, '2018-01-25 21:01:32', '2018-01-25 21:01:32'),
('80ffbdc7-bd05-4ae0-bb9c-2acdf4f181e7', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:28:39', '2018-01-24 15:28:39'),
('8286a88c-cfc1-4a3d-9c78-3194e95cf72b', 'App\\Notifications\\PostNewNotification', 14, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"30\",\"message\":\"Test tenant made a bid against your property Owner Property\"}', NULL, '2018-02-01 05:30:22', '2018-02-01 05:30:22'),
('866698b5-1cce-4a75-a491-5ee2093e170f', 'App\\Notifications\\PostNewNotification', 14, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"25\",\"message\":\"Test tenant made a bid against your property ree\"}', NULL, '2018-01-29 13:03:14', '2018-01-29 13:03:14'),
('8692664b-9ae6-41fb-aca4-cdaf562ce3b3', 'App\\Notifications\\PostNewNotification', 14, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"28\",\"message\":\"Neo Trinity made a bid against your property Ganpati\"}', '2018-01-30 04:00:25', '2018-01-30 04:00:18', '2018-01-30 04:00:25'),
('86974770-cf34-4fca-a428-2ab77bc68a61', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 16:00:55', '2018-01-23 16:00:55'),
('888661cf-053e-49f2-84c5-80b8e9a8f482', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":8,\"property_id\":11,\"message\":\"Bidder has paid the commision fees against property Silvery\"}', '2018-01-24 14:16:17', '2018-01-23 21:17:59', '2018-01-24 14:16:17'),
('8924205f-42a4-4eae-a089-10b7f5493656', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-23 21:30:39', '2018-01-23 21:30:39'),
('89a48d65-d1c7-495e-9ca7-84041d10dd41', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"8\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-23 21:17:01', '2018-01-23 21:17:01'),
('8b1debba-720a-46ae-a683-ecc7b47fc969', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":14,\"property_id\":7,\"message\":\"Bidder has paid the commision fees against property test\"}', NULL, '2018-01-24 18:41:25', '2018-01-24 18:41:25'),
('8f6b6472-4328-492a-bad2-a52681862bfa', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:15:37', '2018-01-24 17:15:37'),
('90ef87cd-9576-48ca-bd47-99d757c0ad5f', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:27:51', '2018-01-24 15:27:51'),
('94ea5a0b-e7eb-4246-a470-38f47519bc0f', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"26\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-29 15:38:39', '2018-01-29 15:38:39'),
('9a3d2980-95b3-4170-b13b-3a9d50375c97', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"28\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-30 04:00:50', '2018-01-30 04:00:50'),
('9ac55783-0230-41cc-adc9-6121e4ff6ef2', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"1\",\"message\":\"Test tenant made a bid against your property Estate Valley\"}', '2018-01-23 14:23:50', '2018-01-23 13:48:46', '2018-01-23 14:23:50'),
('9b38aae6-6ea9-4f53-b1ee-216c06ee9802', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"2\",\"message\":\"Neo Trinity made a bid against your property Vatika\"}', '2018-02-01 08:16:38', '2018-01-23 13:16:20', '2018-02-01 08:16:38'),
('9b480ddf-3e65-4812-b846-d4ddd112a927', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"12\",\"message\":\"Anto Nishanth made a bid against your property Property Owner Oops test\"}', NULL, '2018-01-25 21:38:32', '2018-01-25 21:38:32'),
('9cdb7f4a-63ed-488f-95b0-fbdde471cb88', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":2,\"message\":\"Neo Trinity has opt-out from the bid\"}', '2018-02-01 08:16:49', '2018-01-23 13:20:44', '2018-02-01 08:16:49'),
('9d6187e6-768b-4ed9-86db-1be97baaeb5d', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"18\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-25 16:02:39', '2018-01-25 16:02:39'),
('9efc92cf-a489-43d8-996c-ece52bb8260c', 'App\\Notifications\\PostNewNotification', 14, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"24\",\"message\":\"Tenant Tester made a bid against your property ghg\"}', '2018-01-25 20:58:50', '2018-01-25 20:57:18', '2018-01-25 20:58:50'),
('a13721c9-42f4-42da-8676-45165a01a678', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"17\",\"message\":\"cc cc made a bid against your property counter property\"}', '2018-01-24 17:14:45', '2018-01-24 17:13:07', '2018-01-24 17:14:45'),
('a13b275a-ddc4-4e87-b135-9c977e13143a', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"26\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-29 15:38:29', '2018-01-29 15:38:22', '2018-01-29 15:38:29'),
('a40abc7d-fa0e-4cf5-b7b2-dd42b1311cad', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:31:08', '2018-01-23 21:31:08'),
('a7c9d649-aa77-451b-bd14-4329f202ec84', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"17\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-25 13:55:00', '2018-01-25 13:54:43', '2018-01-25 13:55:00'),
('a828273f-9307-4189-b03c-c493eb59cc2b', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-24 17:16:58', '2018-01-24 17:15:54', '2018-01-24 17:16:58'),
('a9302ae1-9813-4f51-9daa-ce547b5dcfc4', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-25 20:32:50', '2018-01-24 19:19:11', '2018-01-25 20:32:50'),
('aa84e2d3-a143-4002-9aa3-06b1923fe40f', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 19:30:30', '2018-01-24 19:30:30'),
('ac202e7b-0982-4bc7-a3d1-7dd21f3c917a', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":12,\"message\":\"Anto Nishanth has opt-out from the bid\"}', NULL, '2018-01-25 20:32:28', '2018-01-25 20:32:28'),
('ac62bada-c228-4dcc-8cc3-fbcdc503801f', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"1\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 13:18:18', '2018-01-23 13:18:18'),
('ae0efe8d-2170-4370-9ab8-4ff303cdc65d', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":7,\"property_id\":10,\"message\":\"Bidder has paid the commision fees against property ss\"}', '2018-01-23 20:52:15', '2018-01-23 20:51:56', '2018-01-23 20:52:15'),
('b0d38c55-da86-46a4-b930-1c99a398afe4', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:27:43', '2018-01-24 15:27:43'),
('b27ddd9c-041f-4f85-a292-b716663d9b4d', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"10\",\"message\":\"Shreya Sharma made a bid against your property ss\"}', '2018-01-24 14:28:29', '2018-01-23 20:49:01', '2018-01-24 14:28:29'),
('b32483df-9ff5-47b4-a2c8-9be42e868725', 'App\\Notifications\\PostNewNotification', 9, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"16\",\"message\":\"Anto Nishanth made a bid against your property Anto nishanth\"}', '2018-01-25 18:05:36', '2018-01-24 15:48:49', '2018-01-25 18:05:36'),
('b4131c97-ee9f-4d89-abfe-8638aec897ac', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"13\",\"message\":\"Shreya Sharma made a bid against your property gg\"}', '2018-01-24 14:14:48', '2018-01-23 21:30:08', '2018-01-24 14:14:48'),
('b578abba-563f-4775-8042-e9cdf238bffd', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"12\",\"message\":\"Anto Nishanth made a bid against your property Property Owner Oops test\"}', NULL, '2018-01-25 21:36:51', '2018-01-25 21:36:51'),
('b6c72df6-3566-4305-9f5c-3853cc64e1ef', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":17,\"property_id\":20,\"message\":\"Bidder has paid the commision fees against property Raj property\"}', '2018-01-25 15:58:33', '2018-01-25 13:55:35', '2018-01-25 15:58:33'),
('b7682a28-6d5f-45b0-9389-4e924ddb59d7', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 18:11:40', '2018-01-23 18:11:40'),
('bb4103ee-ccbf-479b-a224-919c775aa11b', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"17\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-25 13:55:05', '2018-01-25 13:55:05'),
('bb51dea6-bd20-4657-bb40-cce963230507', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:28:16', '2018-01-24 15:28:16'),
('bc76573d-3845-4e2a-bc81-ce4139b783f7', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:28:42', '2018-01-24 17:28:42'),
('c021bcb6-7d62-4039-a1e6-47470bd4061c', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"1\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 13:18:08', '2018-01-23 13:18:08'),
('c032b2f9-031b-4fe2-8828-05ef0ab815a9', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 16:02:15', '2018-01-23 16:02:15'),
('c15292af-0017-416c-a35b-6875c7e34261', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"13\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-24 17:17:39', '2018-01-24 17:15:45', '2018-01-24 17:17:39'),
('c55d7378-6c66-4ae5-b1bd-990f54c69491', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":1,\"message\":\"Neo Trinity has opt-out from the bid\"}', '2018-01-23 13:48:06', '2018-01-23 13:45:16', '2018-01-23 13:48:06'),
('c5a6f97f-55fd-437b-a90a-10a57d61c970', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 18:10:49', '2018-01-23 18:10:49'),
('c9090807-eb92-4eea-93c9-0df855cfaa64', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"21\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-25 20:31:51', '2018-01-25 20:31:51'),
('c9fb9d02-2dee-4f4d-b656-2ad0b6e2c8f6', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":6,\"property_id\":5,\"message\":\"Bidder has paid the commision fees against property sss\"}', NULL, '2018-01-23 18:12:25', '2018-01-23 18:12:25'),
('cb4f3b89-a1ac-4143-ac15-42571fbaec85', 'App\\Notifications\\PostNewNotification', 16, 'App\\Models\\User', '{\"bid_id\":26,\"property_id\":26,\"message\":\"Bidder has paid the commision fees against property Clark Inn\"}', NULL, '2018-01-29 15:39:32', '2018-01-29 15:39:32'),
('cbaf25d9-3767-467c-a23f-376ccd10651d', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:31:14', '2018-01-23 21:31:14'),
('cd74d078-99dc-4844-bcb1-be793c074437', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"2\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 13:22:50', '2018-01-23 13:22:50'),
('cedfdbd7-cf9b-4bfd-9e21-c7dcde2eee9b', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"20\",\"message\":\"cc ccss made a bid against your property Raj property\"}', '2018-01-25 13:54:17', '2018-01-25 13:52:26', '2018-01-25 13:54:17'),
('cfad4de8-5a4c-4dbd-aef6-37a9c15ed76e', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:28:27', '2018-01-24 15:28:27'),
('d030ac0f-6e96-457a-828c-5e178de2c51d', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"11\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-01-24 18:09:28', '2018-01-24 15:46:13', '2018-01-24 18:09:28'),
('d8028719-9109-4635-a26a-c147b42ca7fe', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"27\",\"message\":\"shreya jain made a bid against your property Test\"}', NULL, '2018-01-29 17:47:12', '2018-01-29 17:47:12'),
('d9c200af-f6c6-486c-bb08-d279b75c9c2a', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 15:57:15', '2018-01-23 15:57:15'),
('de3f59fc-5276-4934-aea9-4bf3e8e72767', 'App\\Notifications\\PostNewNotification', 14, 'App\\Models\\User', '{\"bid_id\":22,\"property_id\":24,\"message\":\"Bidder has paid the commision fees against property ghg\"}', '2018-01-25 21:13:23', '2018-01-25 21:01:32', '2018-01-25 21:13:23'),
('ecb57f00-2443-4ce6-956d-8ecaa682b0c2', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"2\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-23 13:22:13', '2018-01-23 13:22:03', '2018-01-23 13:22:13'),
('ed981de9-dbd4-4f8b-b460-697b6fae053b', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"19\",\"message\":\"cc cc made a bid against your property Testing\"}', '2018-01-24 19:51:03', '2018-01-24 19:50:47', '2018-01-24 19:51:03'),
('f35e36df-5ae6-4ad5-b772-213b948a6b8c', 'App\\Notifications\\PostNewNotification', 8, 'App\\Models\\User', '{\"bid_id\":\"19\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-25 20:04:51', '2018-01-25 17:04:07', '2018-01-25 20:04:51'),
('f3e4d182-231e-4283-8312-eb5fab15c44b', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"9\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 21:31:19', '2018-01-23 21:31:19'),
('f4677c98-a471-4eb0-b5eb-3fcba564ea23', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 17:28:36', '2018-01-24 17:28:36'),
('f5473818-f5da-4e54-876a-29a541c78d37', 'App\\Notifications\\PostNewNotification', 18, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"34\",\"message\":\"Neo Trinity made a bid against your property dg\"}', NULL, '2018-02-09 04:30:59', '2018-02-09 04:30:59'),
('f78d5bdc-1d2e-472b-9338-93d668dd1fa2', 'App\\Notifications\\PostNewNotification', 10, 'App\\Models\\User', '{\"bid_id\":\"11\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-24 15:46:22', '2018-01-24 15:46:22'),
('fa2be83d-732b-4c30-b4ca-19ff9b01fdb3', 'App\\Notifications\\PostNewNotification', 4, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"22\",\"message\":\"cc ccss made a bid against your property dd\"}', '2018-01-25 20:24:49', '2018-01-25 16:53:01', '2018-01-25 20:24:49'),
('fc60b638-b081-4b95-98e0-d75c1e8cb1b5', 'App\\Notifications\\PostNewNotification', 15, 'App\\Models\\User', '{\"bid_id\":\"22\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2018-01-25 20:59:08', '2018-01-25 20:59:00', '2018-01-25 20:59:08'),
('fc9773ce-5a2c-44a6-acbe-2cf6158b2217', 'App\\Notifications\\PostNewNotification', 13, 'App\\Models\\User', '{\"bid_id\":\"14\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-01-24 18:39:23', '2018-01-24 18:39:23'),
('fcd1291d-974a-4fbe-86f9-f7b686ecf355', 'App\\Notifications\\PostNewNotification', 6, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', NULL, '2018-01-23 18:10:25', '2018-01-23 18:10:25'),
('fe80d5dd-bd9d-4024-8c63-3871e9ff6983', 'App\\Notifications\\PostNewNotification', 5, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":4,\"message\":\"Shreya Sharma has opt-out from the bid\"}', NULL, '2018-01-23 15:57:42', '2018-01-23 15:57:42'),
('ff324e23-b3bb-427e-a81d-0b8d3c325479', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"35\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2018-02-14 03:35:28', '2018-02-14 03:35:28'),
('ff9adbd8-f16b-48ae-b73d-db92d53d54ac', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"3\",\"property_id\":\"\",\"message\":\"Your bid status against property  has been updated to Commission Pending\"}', '2018-02-01 08:19:19', '2018-01-23 13:34:07', '2018-02-01 08:19:19');

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

--
-- 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(191) 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` varchar(191) 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'
) 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`, `bid_closure_date`, `number_of_payments_id`, `yearly_price`) VALUES
(1, '2018-01-23 03:12:51', '2018-02-12 03:36:19', 'Estate Valley', 'JLT, Red Diamond - Jumeirah Lakes Towers - Dubai', '1101', '1300', 'Good', '25.0766564197085', '55.15340721970847', 1500.00, 600.00, 2100.00, '', '2018-01-30', 3, 8, 13, 18, 28, 1, 2, 1, 1, 1, NULL, '2018-03-15', 59, 0.00),
(2, '2018-01-23 13:13:46', '2018-02-09 04:43:33', 'Vatika', 'Wasit suburb - Sharjah', '1101', '1400', 'sdgsvdsgvdxg', '25.3338199', '55.43496219999997', 1600.00, 500.00, 2100.00, '', '2018-01-31', 6, 8, 14, 19, 29, 1, 1, 2, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(3, '2018-01-23 13:26:29', '2018-02-06 04:23:07', 'Raheja Property', 'Downtown Dubai - Dubai', '1205', '1600', 'sdfvxfvsd', '25.1853112', '55.26743160000001', 2100.00, 400.00, 2500.00, '', '2018-01-31', 3, 12, 14, 19, 29, 1, 1, 2, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(4, '2018-01-23 15:30:34', '2018-02-05 08:34:28', 'Aqualily', 'International City - Dubai', '4555', '88', 'Well furnished place to stay..\r\nLets 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.149582', '55.39313070000003', 7800.00, 1200.00, 9000.00, '', '2018-01-27', 3, 8, 14, 19, 27, 5, 1, 2, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(5, '2018-01-23 15:54:00', '2018-01-24 15:45:36', 'sss', 'Umm Suqeim - Dubai', '7993', '70', 'gfff', '25.1278105', '55.1869011', 8800.00, 1200.00, 10000.00, '', '2018-01-27', 3, 12, 13, 18, 27, 5, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(6, '2018-01-23 16:26:19', '2018-01-24 15:55:33', 'ddfggg', 'IMPZ - Dubai', 'fdf2233', '667', '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.01740655901085', '55.16809327141118', 9998.00, 1200.00, 11198.00, '', '2018-01-27', 3, 12, 14, 19, 27, 6, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(7, '2018-01-23 16:28:03', '2018-02-09 04:46:16', 'test', 'Saadiyat Island - Abu Dhabi', '5651', '69', '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.4929286', '54.392709800000034', 6600.00, 1500.00, 8100.00, '', '2018-01-26', 1, 11, 14, 18, 27, 5, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(8, '2018-01-23 20:22:30', '2018-01-30 03:57:34', 'Gh', 'Halwan Suburb - Sharjah', '24566', '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.3323933', '55.39788939999994', 8800.00, 1500.00, 10300.00, '', '2018-01-25', 6, 12, 14, 19, 27, 5, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(9, '2018-01-23 20:28:33', '2018-02-09 03:10:29', 'Fgg', 'The Dubai Mall', '4667', '67', '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.19834291970849', '55.27821711970853', 8800.00, 1300.00, 10100.00, '', '2018-02-07', 3, 11, 15, 18, 28, 5, 0, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(10, '2018-01-23 20:47:59', '2018-01-24 14:29:17', 'ss', 'IMPZ - Dubai', '6667', '67', '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.0219176', '55.17041070000005', 6700.00, 1200.00, 7900.00, '', '2018-01-31', 3, 11, 15, 18, 27, 5, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(11, '2018-01-23 21:04:19', '2018-01-25 20:15:04', 'Silvery', 'Oman - The World Islands - Dubai', '6777', '80', 'Well furnished..', '25.22666921970849', '55.17516111970849', 7800.00, 1200.00, 9000.00, '', '2018-02-22', 3, 10, 13, 18, 27, 5, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(12, '2018-01-23 21:15:25', '2018-01-25 21:55:13', 'Property Owners', 'Al Ittihad Square - Sharjah', '20005', '1000', 'Description', '25.3440436197085', '55.38463116970843', 1000.00, 1000.00, 2000.00, '', '2018-01-30', 2, 8, 14, 18, 28, 9, 3, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(13, '2018-01-23 21:25:06', '2018-02-06 04:23:08', 'gg', '76 Al Rigga Road - Dubai', '6677', '88', '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.2603914697085', '55.32545186970856', 8800.00, 1600.00, 10400.00, '', '2018-02-14', 3, 10, 15, 19, 27, 5, 1, 1, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(14, '2018-01-23 21:41:47', '2018-01-25 14:28:24', 'df', '87 Hessa Street - Dubai', '787', '89', 'gfgfg', '25.08565691970849', '55.195429519708455', 9898.00, 2344.00, 12242.00, '', '2018-01-25', 3, 11, 13, 21, 28, 5, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(15, '2018-01-24 15:02:49', '2018-02-06 04:23:08', 'Aquality', 'Industrial Area - Sharjah', '7822', '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.2750115', '55.37688779999996', 7800.00, 1500.00, 9300.00, '', '2018-02-22', 6, 10, 13, 19, 27, 5, 1, 1, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(16, '2018-01-24 15:38:57', '2018-02-05 08:34:16', 'Anto nishanth', 'Al Ittihad Square - Sharjah', '2306', '2500', 'Description', '25.070808183854975', '55.140563051342724', 2500.00, 1.00, 2501.00, '', '2018-01-30', 6, 9, 14, 18, 27, 9, 2, 2, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(17, '2018-01-24 17:00:21', '2018-01-24 19:31:10', 'counter property', 'Free Zone - Ajman', '6788', '70', 'well furnished place.', '25.3939318', '55.45096990000002', 8700.00, 1200.00, 9900.00, '', '2018-02-14', 2, 12, 13, 18, 27, 5, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(18, '2018-01-24 18:55:08', '2018-01-24 18:59:33', 'hggg', 'Oman - The World Islands - Dubai', '4455', '75', '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.22666921970849', '55.17516111970849', 7500.00, 1500.00, 9000.00, '', '2018-01-29', 3, 11, 14, 18, 27, 4, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(19, '2018-01-24 19:35:19', '2018-01-24 19:52:51', 'Testing', 'Vista Tower - Dubai', 's334', '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.0952294697085', '55.174612769708574', 8500.00, 1600.00, 10100.00, '', '2018-02-15', 3, 8, 14, 19, 27, 4, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(20, '2018-01-25 13:50:39', '2018-01-25 13:55:35', 'Raj property', 'Ferrari World - Abu Dhabi', '5252', '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.', '24.4799682', '54.60385240000005', 8800.00, 1600.00, 10400.00, '', '2018-02-22', 1, 11, 15, 19, 27, 4, 2, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(21, '2018-01-25 16:00:39', '2018-01-25 16:47:48', 'Silven', 'IBN Battuta Bus Station - Jebel Ali Village - Dubai', '4575', '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.0449930197085', '55.11647141970843', 7600.00, 1200.00, 8800.00, '', '2018-01-27', 3, 11, 15, 18, 27, 4, 1, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(22, '2018-01-25 16:51:49', '2018-01-25 17:12:36', 'dd', 'Oman - The World Islands - Dubai', '77877', '90', 'hhj', '25.22666921970849', '55.17516111970849', 8200.00, 1500.00, 9700.00, '', '2018-02-16', 3, 10, 14, 17, 28, 4, 1, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(23, '2018-01-25 19:05:44', '2018-02-08 03:31:26', 'gg', 'Index Tower - 312th Road - Dubai', '76767', '80', 'ukk', '25.2063878197085', '55.276918919708464', 77656.00, 788.00, 78444.00, '', '2018-01-27', 3, 12, 14, 18, 27, 4, 0, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(24, '2018-01-25 19:35:58', '2018-01-25 21:01:32', 'ghg', 'Oman - The World Islands - Dubai', '6666', '78', '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.22666921970849', '55.17516111970849', 8800.00, 3000.00, 11800.00, '', '2018-02-15', 3, 12, 13, 17, 28, 14, 3, 5, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(25, '2018-01-25 19:41:29', '2018-02-15 03:21:13', 'reest', 'Jumeirah Beach Residence - Dubai', '7666', '88', 'oll', '25.0721111584207', '55.14107825353392', 8889.00, 1200.00, 10089.00, '', '2018-02-09', 3, 10, 13, 19, 27, 14, 1, 1, 0, 2, NULL, '2018-03-15', NULL, 0.00),
(26, '2018-01-29 15:34:59', '2018-02-05 08:37:09', 'Clark Inn', 'Dubai Silicon Oasis - Dubai', '1203', '1500', 'Test', '25.1055752', '55.36731710000004', 2000.00, 500.00, 2500.00, '', '2018-02-01', 3, 8, 13, 19, 28, 16, 2, 4, 1, 0, NULL, '2018-03-15', NULL, 0.00),
(27, '2018-01-29 17:38:06', '2018-01-29 10:22:02', 'Test', 'Index Tower - 312th Road - Dubai', '6666', '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.2063878197085', '55.276918919708464', 8800.00, 1500.00, 10300.00, '', '2018-02-07', 3, 11, 13, 18, 27, 5, 1, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(28, '2018-01-30 03:58:43', '2018-02-06 09:32:10', 'Ganpati', 'Aspect Tower - Dubai', '1201', '4334', 'dsrgfvsdgvdfg', '25.19072981970849', '55.26500741970847', 1500.00, 300.00, 1800.00, '', '2018-01-31', 3, 8, 13, 18, 28, 14, 1, 1, 1, 3, NULL, '2018-03-15', NULL, 0.00),
(29, '2018-01-30 05:11:15', '2018-02-05 08:46:46', 'Test Downtown', 'Downtown Dubai - Dubai', '212', '3434', 'wsrfef', '25.1853112', '55.26743160000001', 3423.00, 34234.00, 37657.00, '', '2018-01-31', 3, 12, 14, 23, 32, 14, 0, 3, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(30, '2018-02-01 05:29:35', '2018-02-01 05:30:22', 'Owner Property', 'Downtown Jabel Ali - Dubai', '1502', '1200', 'zsdcasfcsdf', '24.9219358', '55.01275050000004', 3100.00, 400.00, 3500.00, '', '2018-02-28', 3, 8, 13, 18, 30, 14, 1, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(31, '2018-02-02 05:45:44', '2018-02-12 04:22:54', 'Bid test', 'Ajman Gate Tower - Ajman', '5r45', '243', 'sdfcsdfcsdf', '25.3752034697085', '55.45744226970851', 324234.00, 324234.00, 648468.00, '', '2018-02-28', 2, 12, 13, 18, 29, 1, 1, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(32, '2018-02-09 03:51:11', '2018-02-09 03:51:11', 'Tesjfksjf', 'Street 1 D591 - Dubai', '456Fghb', '34234', 'fdgdsg', '25.04616121970849', '55.1297648197085', 23424.00, 235345.00, 258769.00, '', '2018-02-11', 3, 12, 13, 19, 30, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(33, '2018-02-09 03:54:19', '2018-02-12 04:52:31', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 0, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(34, '2018-02-09 03:54:45', '2018-02-09 04:30:59', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 1, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(35, '2018-02-09 03:55:25', '2018-02-09 03:55:25', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(36, '2018-02-09 03:55:57', '2018-02-12 08:54:50', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 0, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(37, '2018-02-09 03:57:59', '2018-02-09 03:57:59', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(38, '2018-02-09 04:03:15', '2018-02-12 08:54:52', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 0, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(39, '2018-02-09 04:03:23', '2018-02-12 08:54:52', 'dg', 'Capital Gate - Abu Dhabi', 'e56y', '56', 'ngbnjfgj', '24.41724131970849', '54.43328241970846', 6456.00, 546.00, 7002.00, '', '2018-02-28', 1, 12, 13, 18, 32, 18, 1, 1, 0, 2, NULL, '2018-03-15', NULL, 0.00),
(40, '2018-02-09 04:05:54', '2018-02-15 02:17:11', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 1, 1, 0, 2, NULL, '2018-03-15', NULL, 0.00),
(41, '2018-02-09 04:08:11', '2018-02-09 04:08:11', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(42, '2018-02-09 04:08:54', '2018-02-12 03:43:15', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 1, 1, 0, 1, NULL, '2018-03-15', NULL, 0.00),
(43, '2018-02-09 04:12:05', '2018-02-09 04:12:05', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(44, '2018-02-09 04:12:17', '2018-02-09 04:12:17', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(45, '2018-02-09 04:12:44', '2018-02-09 04:12:44', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(46, '2018-02-09 04:13:04', '2018-02-09 04:13:04', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(47, '2018-02-09 04:13:43', '2018-02-09 04:13:43', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(48, '2018-02-09 04:14:37', '2018-02-09 04:14:37', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(49, '2018-02-09 04:16:56', '2018-02-09 04:16:56', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(50, '2018-02-09 04:17:07', '2018-02-09 04:17:07', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(51, '2018-02-09 04:17:35', '2018-02-09 04:17:35', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(52, '2018-02-09 04:18:13', '2018-02-09 04:18:13', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(53, '2018-02-09 04:19:19', '2018-02-09 04:19:19', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(54, '2018-02-09 04:20:11', '2018-02-09 04:20:11', 'wert', 'GTI - Gemini Technical Industries - Abu Dhabi', 'rst', '56', 'ssdgvsd', '24.72993551970849', '54.7518818197085', 546.00, 45656.00, 46202.00, '', '2018-02-21', 1, 8, 15, 18, 29, 18, 0, 1, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(55, '2018-02-12 03:31:58', '2018-02-15 04:08:31', 'xyz', 'Trade Centre - Dubai', '456tfgh', '5654', 'sdfvsfvsdf', '25.2018929', '55.26928769999995', 416.67, 500.00, 916.67, '', '2018-02-27', 2, 9, 14, 22, 30, 1, 0, 1, 0, 1, '2', '2018-03-15', 61, 5000.00),
(56, '2018-02-12 09:44:05', '2018-02-12 09:44:05', 'Inactive Property', 'Warsan - Dubai', '1234', '344', 'dfdsfs', '25.1387917', '55.417416900000035', 1200.00, 200.00, 1400.00, '', '2018-02-13', 3, 8, 14, 19, 29, 14, 0, 2, 0, 0, NULL, '2018-03-15', NULL, 0.00),
(57, '2018-02-14 03:22:03', '2018-02-15 03:15:24', 'gbdfgdfg', 'Downtown Dubai - Dubai', '434', '234', 'fgdfgbdfgfdg', '25.1853112', '55.26743160000001', 2345.00, 456.00, 2801.00, '', '2018-02-22', 3, 12, 14, 19, 29, 1, 1, 1, 1, 3, '2', '2018-03-15', NULL, 0.00),
(58, '2018-02-14 03:52:55', '2018-02-14 03:52:55', 'dgh', '566 566 - Dubai', 'ery', '656', 'dhdfhb', '25.1736295197085', '55.218399719708486', 5646.00, 456456.00, 462102.00, '', '2018-02-15', 3, 10, 13, 18, 30, 1, 0, 2, 0, 0, '1', '2018-03-15', NULL, 0.00),
(59, '2018-02-15 03:08:52', '2018-02-15 03:08:52', 'fgdfdg', 'Downtown Dubai - Dubai', '465', '344', 'dgvdfgvdfg', '25.1853112', '55.26743160000001', 203.67, 434.00, 637.67, '', '2018-02-21', 2, 8, 13, 18, 28, 1, 0, 2, 0, 0, '2', '2018-02-22', 58, 2444.00);

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

--
-- 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-02-15 04:08:31', 'Active', 37),
(2, '2017-11-27 03:26:11', '2018-02-15 03:08:52', 'Inactive', 7),
(3, '2017-11-27 03:26:11', '2018-02-05 08:46:46', 'Suspended', 1),
(4, '2017-11-27 03:26:11', '2018-02-05 08:37:09', 'Expired', 1),
(5, '2017-11-27 03:26:11', '2018-02-05 08:27:48', 'Closed', 9);

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

--
-- 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 09:30:31', '2018-02-06 09:30:31', 28, NULL, '::1'),
(2, '2018-02-06 09:30:56', '2018-02-06 09:30:56', 28, 1, '::1'),
(3, '2018-02-06 09:32:10', '2018-02-06 09:32:10', 28, 2, '::1'),
(4, '2018-02-08 03:31:26', '2018-02-08 03:31:26', 23, NULL, '::1'),
(5, '2018-02-09 03:10:29', '2018-02-09 03:10:29', 9, NULL, '::1'),
(6, '2018-02-09 04:30:15', '2018-02-09 04:30:15', 39, 2, '::1'),
(7, '2018-02-09 04:30:52', '2018-02-09 04:30:52', 34, 2, '::1'),
(8, '2018-02-09 04:45:03', '2018-02-09 04:45:03', 40, 13, '::1'),
(9, '2018-02-12 03:36:19', '2018-02-12 03:36:19', 1, 1, '::1'),
(10, '2018-02-12 03:41:07', '2018-02-12 03:41:07', 42, 2, '::1'),
(11, '2018-02-12 04:22:54', '2018-02-12 04:22:54', 31, 1, '::1'),
(12, '2018-02-12 04:52:31', '2018-02-12 04:52:31', 33, NULL, '::1'),
(13, '2018-02-12 08:54:50', '2018-02-12 08:54:50', 36, NULL, '::1'),
(14, '2018-02-12 08:54:52', '2018-02-12 08:54:52', 38, NULL, '::1'),
(15, '2018-02-12 08:54:52', '2018-02-12 08:54:52', 39, NULL, '::1'),
(16, '2018-02-14 03:24:03', '2018-02-14 03:24:03', 57, NULL, '::1'),
(17, '2018-02-14 03:24:15', '2018-02-14 03:24:15', 57, 2, '::1'),
(18, '2018-02-15 02:17:11', '2018-02-15 02:17:11', 40, NULL, '::1'),
(19, '2018-02-15 03:15:24', '2018-02-15 03:15:24', 57, 1, '::1'),
(20, '2018-02-15 03:19:35', '2018-02-15 03:19:35', 25, NULL, '::1'),
(21, '2018-02-15 03:21:12', '2018-02-15 03:21:12', 25, 2, '::1'),
(22, '2018-02-15 04:08:31', '2018-02-15 04:08:31', 55, 1, '::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-01-23 02:27:27', '2018-01-23 02:27:27', 1, '971501234567', 'Please use 954576 as OTP for verifying your mobile number', 34445512),
(2, '2018-01-23 02:29:54', '2018-01-23 02:29:54', 1, '971501234567', 'Please use 954576 as OTP for verifying your mobile number', 34445612),
(3, '2018-01-23 02:31:30', '2018-01-23 02:31:30', 1, '971501234567', 'Please use 954576 as OTP for verifying your mobile number', 34445685),
(4, '2018-01-23 02:32:19', '2018-01-23 02:32:19', 1, '971501234567', 'Please use 954576 as OTP for verifying your mobile number', 34445724),
(5, '2018-01-23 03:05:19', '2018-01-23 03:05:19', 1, '971501234567', 'Please use 954576 as OTP for verifying your mobile number', 34447204),
(6, '2018-01-23 03:32:08', '2018-01-23 03:32:08', 2, '971501234568', 'Please use 941403 as OTP for verifying your mobile number', 34448041),
(7, '2018-01-23 13:46:12', '2018-01-23 13:46:12', 3, '971501234569', 'Please use 225232 as OTP for verifying your mobile number', 34451212),
(8, '2018-01-23 14:11:37', '2018-01-23 14:11:37', 4, '971566012022', 'Please use 129631 as OTP for verifying your mobile number', 34451712),
(9, '2018-01-23 14:54:45', '2018-01-23 14:54:45', 5, '971569900022', 'Please use 628615 as OTP for verifying your mobile number', 34452169),
(10, '2018-01-23 14:56:26', '2018-01-23 14:56:26', 5, '971569900022', 'Please use 324273 as OTP for verifying your mobile number', 34452204),
(11, '2018-01-23 15:00:14', '2018-01-23 15:00:14', 6, '971521232212', 'Please use 396864 as OTP for verifying your mobile number', 34452320),
(12, '2018-01-23 15:00:46', '2018-01-23 15:00:46', 6, '971521232212', 'Please use 711399 as OTP for verifying your mobile number', 34452486),
(13, '2018-01-23 19:42:04', '2018-01-23 19:42:04', 7, '971502718828', 'Please use 682040 as OTP for verifying your mobile number', 34477504),
(14, '2018-01-23 19:47:58', '2018-01-23 19:47:58', 8, '971583903336', 'Please use 829034 as OTP for verifying your mobile number', 34477817),
(15, '2018-01-23 21:14:01', '2018-01-23 21:14:01', 9, '971509164082', 'Please use 133940 as OTP for verifying your mobile number', 34482918),
(16, '2018-01-23 21:36:41', '2018-01-23 21:36:41', 10, '971509164082', 'Please use 599932 as OTP for verifying your mobile number', 34484374),
(17, '2018-01-23 21:59:51', '2018-01-23 21:59:51', 11, '971509164082', 'Please use 847730 as OTP for verifying your mobile number', 34486562),
(18, '2018-01-24 14:09:22', '2018-01-24 14:09:22', 12, '971561435149', 'Please use 890409 as OTP for verifying your mobile number', 34512484),
(19, '2018-01-24 17:34:58', '2018-01-24 17:34:58', 13, '971501234566', 'Please use 581498 as OTP for verifying your mobile number', 34519115),
(20, '2018-01-25 19:15:38', '2018-01-25 19:15:38', 14, '971562222220', 'Please use 238449 as OTP for verifying your mobile number', 34593463),
(21, '2018-01-25 20:53:08', '2018-01-25 20:53:08', 15, '971562225522', 'Please use 960225 as OTP for verifying your mobile number', 34608341),
(22, '2018-01-29 15:30:39', '2018-01-29 15:30:39', 16, '971509164082', 'Please use 197328 as OTP for verifying your mobile number', 34806340),
(23, '2018-01-30 08:45:09', '2018-01-30 08:45:09', 1, '971501234568', 'Please use 203418 as OTP for verifying your mobile number', 34833994),
(24, '2018-02-01 02:23:46', '2018-02-01 02:23:46', 17, '971501234567', 'Please use 297886 as OTP for verifying your mobile number', 34895491),
(25, '2018-02-09 03:49:35', '2018-02-09 03:49:35', 18, '971504566878', 'Please use 372825 as OTP for verifying your mobile number', 35123868);

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

--
-- 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-11 18:30:00', NULL, 'dfg', 'fdg', 1, 1, 1, 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-01-23 18:12:29', '2018-01-23 18:12:29', 6, 6, 2, 'Satisfied'),
(2, '2018-01-23 20:51:59', '2018-01-23 20:51:59', 6, 7, 2, 'Satisfied'),
(3, '2018-01-23 21:18:03', '2018-01-23 21:18:03', 6, 8, 2, 'Satisfied'),
(4, '2018-01-24 17:26:14', '2018-01-24 17:26:14', 8, 13, 2, 'Unsatisfied'),
(5, '2018-01-24 18:41:28', '2018-01-24 18:41:28', 13, 14, 2, 'Satisfied'),
(6, '2018-01-24 18:59:38', '2018-01-24 18:59:38', 8, 15, 2, 'Satisfied'),
(7, '2018-01-24 19:19:33', '2018-01-24 19:19:33', 8, 13, 2, 'Unsatisfied'),
(8, '2018-01-24 19:20:45', '2018-01-24 19:20:45', 8, 13, 2, 'Neutral'),
(9, '2018-01-24 19:24:23', '2018-01-24 19:24:23', 8, 13, 2, 'Neutral'),
(10, '2018-01-24 19:31:13', '2018-01-24 19:31:13', 8, 13, 2, 'Satisfied'),
(11, '2018-01-24 19:52:57', '2018-01-24 19:52:57', 8, 16, 2, 'Satisfied'),
(12, '2018-01-25 13:55:40', '2018-01-25 13:55:40', 8, 17, 2, 'Satisfied'),
(13, '2018-01-25 20:59:23', '2018-01-25 20:59:23', 15, 22, 2, 'Unsatisfied'),
(14, '2018-01-25 21:01:38', '2018-01-25 21:01:38', 15, 22, 2, 'Satisfied'),
(15, '2018-01-29 15:39:38', '2018-01-29 15:39:38', 2, 26, 2, 'Satisfied');

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

--
-- 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
(2, '2018-01-23 13:18:18', '2018-02-06 05:45:31', 2, '16.00', 'Telr', 4, '0', 2, 1, NULL, NULL, NULL),
(3, '2018-01-23 13:22:17', '2018-02-06 03:58:28', 2, '15.00', 'Telr', 4, '0', 2, 2, NULL, NULL, NULL),
(4, '2018-01-23 13:22:50', '2018-02-06 03:58:28', 2, '15.00', 'Telr', 4, '0', 2, 2, NULL, NULL, NULL),
(5, '2018-01-23 13:23:03', '2018-02-06 03:58:28', 2, '15.00', 'Telr', 4, '0', 2, 2, NULL, NULL, NULL),
(6, '2018-01-23 13:34:07', '2018-02-06 04:23:07', 2, '21.00', 'Telr', 4, '0', 2, 3, NULL, NULL, NULL),
(7, '2018-01-23 14:25:32', '2018-02-06 04:23:07', 2, '15.00', 'Telr', 4, '0', 3, 4, NULL, NULL, NULL),
(8, '2018-01-23 15:57:15', '2018-01-23 15:57:15', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(9, '2018-01-23 16:00:46', '2018-01-23 16:00:46', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(10, '2018-01-23 16:00:55', '2018-01-23 16:00:55', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(11, '2018-01-23 16:02:15', '2018-01-23 16:02:15', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(12, '2018-01-23 16:11:40', '2018-01-23 16:11:40', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(13, '2018-01-23 16:38:23', '2018-01-23 16:38:23', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(14, '2018-01-23 18:10:25', '2018-01-23 18:10:25', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(15, '2018-01-23 18:10:49', '2018-01-23 18:10:49', 2, '88.00', 'Telr', 1, '0', 6, 6, NULL, NULL, NULL),
(16, '2018-01-23 18:11:40', '2018-01-23 18:12:25', 2, '88.00', 'Telr', 3, '9492D2DEBA51ACAAD1D2C77D8357375594D70A7EE87C11A637A579F4352CC5AE', 6, 6, NULL, NULL, NULL),
(17, '2018-01-23 20:51:19', '2018-01-23 20:51:19', 2, '72.00', 'Telr', 1, '0', 6, 7, NULL, NULL, NULL),
(18, '2018-01-23 20:51:29', '2018-01-23 20:51:55', 2, '72.00', 'Telr', 3, '797A969F98239686B439FE4065B2DC589DB5F8F8481854CFDB1ED93E16AECC82', 6, 7, NULL, NULL, NULL),
(19, '2018-01-23 21:17:28', '2018-01-23 21:17:59', 2, '78.00', 'Telr', 3, '9C0924ADE6DF1B48524D1441136231F3A536F6680ED26C26C1DB101BEAB4E1DB', 6, 8, NULL, NULL, NULL),
(20, '2018-01-23 21:30:53', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(21, '2018-01-23 21:31:01', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(22, '2018-01-23 21:31:08', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(23, '2018-01-23 21:31:14', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(24, '2018-01-23 21:31:19', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(25, '2018-01-23 21:31:24', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(26, '2018-01-23 21:31:30', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(27, '2018-01-23 21:32:04', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(28, '2018-01-23 21:32:10', '2018-02-06 04:23:08', 2, '93.00', 'Telr', 4, '0', 6, 9, NULL, NULL, NULL),
(29, '2018-01-24 15:25:32', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(30, '2018-01-24 15:27:43', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(31, '2018-01-24 15:27:51', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(32, '2018-01-24 15:28:16', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(33, '2018-01-24 15:28:27', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(34, '2018-01-24 15:28:39', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(35, '2018-01-24 15:39:32', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(36, '2018-01-24 15:46:13', '2018-01-24 15:46:13', 2, '30.00', 'Telr', 1, '0', 10, 11, NULL, NULL, NULL),
(37, '2018-01-24 15:46:22', '2018-01-24 15:46:22', 2, '30.00', 'Telr', 1, '0', 10, 11, NULL, NULL, NULL),
(38, '2018-01-24 15:47:04', '2018-01-24 15:47:04', 2, '30.00', 'Telr', 1, '0', 10, 11, NULL, NULL, NULL),
(39, '2018-01-24 17:15:37', '2018-01-24 17:15:37', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(40, '2018-01-24 17:15:45', '2018-01-24 17:15:45', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(41, '2018-01-24 17:15:50', '2018-01-24 17:15:50', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(42, '2018-01-24 17:15:54', '2018-01-24 17:15:55', 2, '92.00', 'Telr', 1, 'B3792313D082E79EC08A02B30FD03F4296066F13065A0388405D5D3DBD009DB9', 8, 13, NULL, NULL, NULL),
(43, '2018-01-24 17:17:43', '2018-01-24 17:17:43', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(44, '2018-01-24 17:17:47', '2018-01-24 17:17:47', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(45, '2018-01-24 17:17:51', '2018-01-24 17:17:51', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(46, '2018-01-24 17:17:55', '2018-01-24 17:25:27', 2, '92.00', 'Telr', 2, '904B04ADA2267DCA4C06259CA5CF0DB7A7CE9FF17EB163E51B3A953164F801CF', 8, 13, NULL, NULL, NULL),
(47, '2018-01-24 17:27:43', '2018-01-24 17:27:43', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(48, '2018-01-24 17:28:36', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, '0', 6, 10, NULL, NULL, NULL),
(49, '2018-01-24 17:28:42', '2018-02-06 04:23:08', 2, '83.00', 'Telr', 4, 'BC9878E727F9D63042DB08411E9541B519E6BD72FFAA8187137C2D9577065C10', 6, 10, NULL, NULL, NULL),
(50, '2018-01-24 18:39:40', '2018-02-09 04:46:16', 2, '71.00', 'Telr', 4, '5669779A8CCD6EC86175EDF58CAB09800EAE4F2B4C8329C39ACCA02D6B691362', 13, 14, NULL, NULL, NULL),
(51, '2018-01-24 18:58:23', '2018-01-24 18:59:33', 2, '80.00', 'Telr', 3, '89EE536A4D3C13CC80AA47EA9394AF16A172DDECDAE468407D001584E739D46E', 8, 15, NULL, NULL, NULL),
(52, '2018-01-24 19:18:53', '2018-01-24 19:18:53', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(53, '2018-01-24 19:18:59', '2018-01-24 19:18:59', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(54, '2018-01-24 19:19:11', '2018-01-24 19:19:11', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(55, '2018-01-24 19:19:18', '2018-01-24 19:19:18', 2, '92.00', 'Telr', 1, '0', 8, 13, NULL, NULL, NULL),
(56, '2018-01-24 19:19:22', '2018-01-24 19:19:29', 2, '92.00', 'Telr', 5, 'C1E85EF7FA4B5F8E1EA9712D665C52816CEA932225DE0EBCB3AD3BAAED0CFD73', 8, 13, NULL, NULL, NULL),
(57, '2018-01-24 19:20:06', '2018-01-24 19:20:39', 2, '92.00', 'Telr', 5, '047949A769A78514EB4143A8D28C3DBE55D5866A9E285276354E4FE53D628423', 8, 13, NULL, NULL, NULL),
(58, '2018-01-24 19:24:11', '2018-01-24 19:24:20', 2, '92.00', 'Telr', 5, '9A21520229C861A4C1C481726E3DF46E30B7150F2E2FB026145A569802905039', 8, 13, NULL, NULL, NULL),
(59, '2018-01-24 19:30:30', '2018-01-24 19:31:10', 2, '92.00', 'Telr', 3, 'CF91B072A074FF02ECD09AF13D887DC4B93B0B9767F1EA9826D9FB9C6B95508A', 8, 13, NULL, NULL, NULL),
(60, '2018-01-24 19:51:34', '2018-01-24 19:51:36', 2, '90.00', 'Telr', 1, '7F3525C11A716EA68C052501476A136C020A054F0AA68C9142FB4917263BE72C', 8, 16, NULL, NULL, NULL),
(61, '2018-01-24 19:52:19', '2018-01-24 19:52:51', 2, '90.00', 'Telr', 3, 'DB6BF4C65C66F1132BBCB6A1F37723C3A76C9FB8D61863786276E3E31BDF91F0', 8, 16, NULL, NULL, NULL),
(62, '2018-01-25 13:55:05', '2018-01-25 13:55:35', 2, '93.00', 'Telr', 3, '794FD3F934EC4C3E8D7992BB1B63AE381C7FD7095E5A5DD2AFD5CC14790F980D', 8, 17, NULL, NULL, NULL),
(63, '2018-01-25 16:02:39', '2018-01-25 16:02:43', 2, '76.00', 'Telr', 1, '9C92581FE6CA08691473A8E15E500654F9A2A36FB9D3E764A4086260BEB43D17', 8, 18, NULL, NULL, NULL),
(64, '2018-01-25 20:59:13', '2018-01-25 20:59:19', 2, '88.00', 'Telr', 5, '8E05323C7EB12A27B69F050FE8ACBD24835181BC94201976D7587754C098C1BB', 15, 22, NULL, NULL, NULL),
(65, '2018-01-25 21:00:50', '2018-01-25 21:01:32', 2, '88.00', 'Telr', 3, 'BDD09C52D19C78650E396860CC3082F8CD93B39B6035E6D1E4FE77BFDB3BD993', 15, 22, NULL, NULL, NULL),
(66, '2018-01-29 15:38:39', '2018-01-29 15:39:32', 2, '20.00', 'Telr', 3, 'C5744BF5E119A5BC544CFF058CEE71FCEC5B1D388F05339603E33310DF7B1573', 2, 26, NULL, NULL, NULL),
(67, '2018-01-30 04:00:38', '2018-02-06 04:23:08', 2, '15.00', 'Telr', 4, '0', 2, 28, NULL, NULL, NULL),
(68, '2018-01-30 04:00:43', '2018-02-06 04:23:08', 2, '15.00', 'Telr', 4, '0', 2, 28, NULL, NULL, NULL),
(69, '2018-01-30 04:00:47', '2018-02-06 04:23:08', 2, '15.00', 'Telr', 4, '0', 2, 28, NULL, NULL, NULL),
(70, '2018-01-30 04:00:50', '2018-02-06 04:23:08', 2, '15.00', 'Telr', 4, '0', 2, 28, NULL, NULL, NULL),
(71, '2018-01-30 04:00:54', '2018-02-06 04:23:08', 2, '15.00', 'Telr', 4, '3DA3D6173497D72177DB41724D550D0E220B5621C082703925E184E886660029', 2, 28, 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `created_at`, `updated_at`, `firstname`, `lastname`, `email`, `password`, `country_code`, `mobile`, `is_mobile_verified`, `user_type_id`, `status`, `otp`, `document`, `dob`, `profile_pic`, `short_bio`, `facebook_profile`, `linkedin_profile`, `address`, `city`, `remember_token`) VALUES
(1, '2018-01-23 02:27:26', '2018-02-14 03:18:24', 'John', 'Milton', 'john@bid2rent.ae', '$2y$10$pEe4370M4imS1U63L1Z4nOatFMckvfYQicB/m1OEHLrhE/UnGp1Y6', 971, 501234568, 1, 2, 1, 203418, 'media/tenant/1/501234568_1518583704.pdf', '1993-05-12', NULL, 'Biomdxznfkjsdffghfgh', 'drydfgvdxfgdfg', 'fghdgdsgghfgh', 'Nehru Nagar', 'Delhi', 'xiplkxBkRx5yekUL4RavNO7A2YduH0tVceuisxNtCRwCLC6cH7oJZBkxxe1b'),
(2, '2018-01-23 03:32:07', '2018-02-14 05:50:00', 'Neo', 'Trinity', 'neo@bid2rent.ae', '$2y$10$b2mM5NXBFr0gJwwQxPu8ReYbhCESwPdHx3RqdJgB9bOpdUOWF9mci', 971, 501234568, 1, 3, 1, 941403, 'media/tenant/2/501234568_1518592800.jpg', NULL, NULL, NULL, 'dfgdfg', 'dfgdfgfgf', 'Saket', 'Delhi', '3QWXmubmM7JG8nfzoByNiki6VE03jhTckD5UTJ1liWapb2VibBXV980foifl'),
(3, '2018-01-23 13:46:11', '2018-01-23 13:47:22', 'Test', 'tenant', 'tenant@bid2rent.ae', '$2y$10$mb8XhMiRu3lipdveh7jqAuCzk0nYDbwb/ajcMnFsq0X9Qckao./iO', 971, 501234569, 1, 3, 1, 225232, 'media/tenant/3/501234569_1516682771.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '2018-01-23 14:11:36', '2018-01-23 14:22:10', 'ss', 'ss', 'ss@bid2rent.ae', '$2y$10$dVwL4XcOifZOOVlkS4GXueWozWiYBj5WI7f3WX7Pantu6op5slxVC', 971, 566012022, 1, 2, 1, 129631, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '2018-01-23 14:54:43', '2018-01-23 15:37:40', 'Shreya', 'Jain', 'shreya.ushyaku@gmail.com', '$2y$10$KyDz0M8VxzcqBuEiPCpjYuH3Gt.SZqEImaqQQtJP1W..HzjLOQdJ.', 971, 569900022, 1, 2, 1, 324273, '', '2018-01-23', 'media/landlord/5/569900022_51516689460.jpeg', 'dd...uuuiuiu', 'hh', 'k;lkl;plp', 'dubai', 'dubai', NULL),
(7, '2018-01-23 19:42:02', '2018-01-23 19:43:15', 'ss', 'aa', 'aa@bid2rent.ae', '$2y$10$FKgxOrW5pYzb2IVnTTLsC.Buy9WcgngZ5u/ieTZCPlc6LW8gBu3bW', 971, 502718828, 1, 2, 1, 682040, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '2018-01-23 19:47:57', '2018-01-24 19:52:08', 'cc', 'ccss', 'cc@bid2rent.ae', '$2y$10$s7v6BkTapUykrEMiddoUfu4glDTftSYMzUjC8/JbjvTggMvTyQjqK', 971, 583903336, 1, 3, 1, 829034, 'media/tenant/8/583903336_1516704477.pdf', NULL, NULL, NULL, NULL, NULL, 'Dubai', 'Dubai', NULL),
(9, '2018-01-23 21:14:00', '2018-01-23 21:14:13', 'Anto', 'Nishanth', 'anishanth-owner@ucssolutions.com', '$2y$10$spiX4A61FxKfRPBd3xPrXu7//g.pZYEjZt139cgBUxRB0hu6AAlBW', 971, 509164082, 1, 2, 1, 133940, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(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, NULL),
(11, '2018-01-23 21:59:49', '2018-01-23 22:00:07', 'Anto', 'Nishanth', 'anishanth-admin@ucssolutions.com', '$2y$10$h2ySeLjP3mPU4NwZwb3KP.Q7h8BO83CEAw5w208pUom/2W1Sen6Za', 971, 509164082, 1, 1, 1, 847730, '', NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL),
(13, '2018-01-24 17:34:56', '2018-01-24 20:58:07', 'shreya', 'jain', 'jainshreya2206@gmail.com', '$2y$10$TqLimvmOLo07aBW/h9WXtOaz5JLylbZgXCDbRp1sNtU3eLq/XlDhG', 971, 501234566, 1, 3, 1, 581498, 'media/tenant/13/501234566_1516795087.pdf', NULL, NULL, NULL, NULL, NULL, 'Gh', 'Ggh', NULL),
(14, '2018-01-25 19:15:36', '2018-02-12 09:41:26', 'owner', 'tester', 'owner@bid2rent.ae', '$2y$10$Y0XFFacyia1rYtjq3JaiBOXrEzS./AHEZh7FMEd3xYYaSyvqE4SEC', 971, 562222220, 1, 2, 1, 238449, 'media/tenant/14/562222220_1518433886.pdf', NULL, NULL, NULL, NULL, NULL, 'Address', 'City', 'GvW2fnvAqFzVlb10BNoHfukFVNcaJE5jqdBcoYOoau39ThkHzx4mNRvGZpAh'),
(15, '2018-01-25 20:53:07', '2018-01-25 20:53:36', 'Tenant', 'Tester', 'tester@bid2rent.ae', '$2y$10$KckoQjrJmZRAKzyaPwC8C.kt7Il2OO5G3mAECGSybsdqVJRpQ/ljS', 971, 562225522, 1, 3, 1, 960225, 'media/tenant/15/562225522_1516881187.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, '2018-01-29 15:30:38', '2018-01-29 15:33:21', 'Neo', 'Trinity', 'Neo-owner@bid2rent.ae', '$2y$10$9skWROwZ5WKliZks20KQHu87/RHxPFB7RuX3hpjCGXWRNmgqimc0G', 971, 509164082, 1, 2, 1, 197328, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, '2018-02-01 02:23:43', '2018-02-01 02:23:43', 'dr', 'eddgbdfg', 's@s.uk', '$2y$10$6hf6vDhCXzFNy1R0QUMx2ORh/XI6vF3rbptM0.jUiA28f47vziQl2', 971, 501234567, 0, 2, 1, 297886, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, '2018-02-09 03:49:34', '2018-02-09 03:49:58', 'Nikita', 'Gupta', 'nikita.ushyaku@gmail.com', '$2y$10$MLwYIlNj19ixWkEbTYTZCur9Mk9ytC1G0fSDo4AuWzyJLm1jxoz1W', 971, 504566878, 1, 2, 1, 372825, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BBxY0QnF7RyfONVQpCjxPH2IU1vPY4IXsTWkfrWRLV29Xqh4ncBeIYBo7ne3'),
(20, NULL, NULL, 'dfxgbdfgdfg', 'fdgdfgdfg', '', '', 0, 0, 0, 2, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, '2018-02-14 05:23:13', '2018-02-14 05:23:13', 'frty', 'tryry', 'fgd@s.ok', '$2y$10$1kv1wXO4nONKozT5bD9kde/V38/aWZXRHfr7PzWtvA71CFg5Aregi', 971, 546456, 0, 2, 1, 588677, '', NULL, NULL, NULL, NULL, NULL, 'fh', 'fgh', 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-15 02:40:21', 1, '2018-02-15 08:10:21', '2018-02-14 09:23:20'),
(2, NULL, '2018-02-15 03:21:12', 2, '2018-02-15 08:51:12', '2018-02-14 11:19:19'),
(3, NULL, '2018-02-01 05:18:43', 3, '2018-02-01 10:48:43', NULL),
(4, NULL, '2018-01-29 09:01:49', 5, '2018-01-29 13:37:41', '2018-01-29 14:31:49'),
(5, NULL, '2018-01-24 17:29:26', 6, '2018-01-24 12:28:20', '2018-01-24 12:29:26'),
(6, NULL, '2018-01-29 18:00:40', 4, '2018-01-29 12:58:10', '2018-01-29 13:00:40'),
(7, NULL, '2018-01-23 19:46:58', 7, '2018-01-23 14:43:36', '2018-01-23 14:46:58'),
(8, NULL, '2018-01-29 15:58:10', 8, '2018-01-29 10:58:10', '2018-01-25 15:57:34'),
(9, NULL, '2018-01-29 18:18:48', 9, '2018-01-29 13:06:30', '2018-01-29 13:18:48'),
(10, NULL, '2018-01-29 18:18:29', 10, '2018-01-29 13:02:52', '2018-01-29 13:18:29'),
(11, NULL, '2018-01-24 14:35:54', 12, '2018-01-24 09:09:50', '2018-01-24 09:35:54'),
(12, NULL, '2018-02-09 04:44:38', 13, '2018-02-09 10:14:38', '2018-01-29 13:01:10'),
(13, NULL, '2018-02-12 09:40:50', 14, '2018-02-12 15:10:50', '2018-02-01 11:52:19'),
(14, NULL, '2018-01-25 21:15:51', 15, '2018-01-25 16:15:51', NULL),
(15, NULL, '2018-01-29 15:37:41', 16, '2018-01-29 10:37:41', '2018-01-29 10:35:12'),
(16, NULL, '2018-02-09 04:29:32', 18, '2018-02-09 09:20:10', '2018-02-09 09:59:32');

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

--
-- 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-01-30 08:38:38', 'Admin', 3),
(2, '2017-11-27 03:26:11', '2018-02-14 05:23:14', 'Property Owner', 103),
(3, '2017-11-27 03:26:11', '2018-02-14 05:50:00', 'Tenant', 79);

--
-- 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_statuses`
--
ALTER TABLE `app_code_statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `biddings`
--
ALTER TABLE `biddings`
  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 `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_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 `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=142;

--
-- 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=64;

--
-- AUTO_INCREMENT for table `app_code_categories`
--
ALTER TABLE `app_code_categories`
  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=36;

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

--
-- 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=12;

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

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

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

--
-- 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=60;

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

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

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

--
-- 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=16;

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `kryptonit3_counter_page_visitor`
--
ALTER TABLE `kryptonit3_counter_page_visitor`
  ADD CONSTRAINT `kryptonit3_counter_page_visitor_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `kryptonit3_counter_page` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kryptonit3_counter_page_visitor_visitor_id_foreign` FOREIGN KEY (`visitor_id`) REFERENCES `kryptonit3_counter_visitor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

