-- 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', '2017-12-28 05:09:18', 'Washer/Dryer In Unit', 'icon-washer', 1, 1, 6),
(2, '2017-12-06 09:55:08', '2017-12-21 05:37:17', 'Pool', 'icon-pool', 2, 1, 4),
(3, '2017-12-06 09:55:08', '2017-12-21 05:37:18', 'Gym', 'icon-gym', 3, 1, 3),
(4, '2017-12-06 09:55:08', '2017-12-28 05:09:18', 'Elevator', 'icon-elevator', 4, 1, 4),
(5, '2017-12-06 09:55:08', '2017-12-21 05:37:18', 'Parking Spot', 'icon-parking-spot', 5, 1, 2),
(6, '2017-12-06 09:55:08', '2017-12-14 03:16:06', 'Fireplace', 'icon-fireplace', 6, 1, 0),
(7, '2017-12-06 09:55:08', '2017-12-28 05:09:18', 'Air Conditioning', 'icon-air-conditioning', 7, 1, 1),
(8, '2017-12-06 09:55:08', '2017-12-14 03:16:06', 'Doorman', 'icon-doorman', 8, 1, 0),
(9, '2017-12-06 09:55:08', '2017-12-14 03:16:06', 'Dishwasher', 'icon-dishwasher', 9, 1, 0),
(10, '2017-12-06 09:55:08', '2017-12-28 05:09:19', 'Deck', 'icon-deck', 10, 1, 1),
(11, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'Storage', 'icon-storage', 11, 1, 0),
(12, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Wheelchair Accessible', 'icon-wheelchair', 12, 1, 0),
(13, '2017-12-06 09:55:08', '2017-12-28 05:09:19', 'Hardwood Floors', 'icon-hardwood', 13, 1, 1),
(14, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'Garden', 'icon-garden', 14, 1, 0),
(15, '2017-12-06 09:55:08', '2017-12-15 03:17:20', 'Balcony', 'icon-balcony', 15, 1, 1),
(16, '2017-12-06 09:55:08', '2017-12-28 05:09:19', 'Furnished', 'icon-furnished', 16, 1, 2),
(17, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'View', 'icon-view', 17, 1, 0),
(18, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'Student Friendly', 'icon-student', 18, 1, 0),
(19, '2017-12-06 09:55:08', '2017-12-28 05:09:19', 'High Rise', 'icon-high-rise', 19, 1, 1),
(20, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Utilities Included', 'icon-utilities', 20, 1, 0);

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

--
-- 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, '2017-12-14 09:42:10', '2017-12-14 09:42:10', 1, 1),
(2, '2017-12-14 09:42:10', '2017-12-14 09:42:10', 2, 1),
(3, '2017-12-14 09:42:10', '2017-12-14 09:42:10', 3, 1),
(4, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 3, 2),
(5, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 4, 2),
(6, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 15, 2),
(7, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 16, 2),
(8, '2017-12-15 05:46:32', '2017-12-15 05:46:32', 2, 3),
(9, '2017-12-15 05:51:48', '2017-12-15 05:51:48', 1, 4),
(10, '2017-12-15 05:51:48', '2017-12-15 05:51:48', 5, 4),
(11, '2017-12-15 06:06:58', '2017-12-15 06:06:58', 2, 5),
(12, '2017-12-19 04:26:19', '2017-12-19 04:26:19', 1, 6),
(13, '2017-12-19 04:26:19', '2017-12-19 04:26:19', 4, 6),
(14, '2017-12-19 08:35:54', '2017-12-19 08:35:54', 1, 7),
(15, '2017-12-21 05:37:17', '2017-12-21 05:37:17', 1, 8),
(16, '2017-12-21 05:37:17', '2017-12-21 05:37:17', 2, 8),
(17, '2017-12-21 05:37:17', '2017-12-21 05:37:17', 3, 8),
(18, '2017-12-21 05:37:18', '2017-12-21 05:37:18', 4, 8),
(19, '2017-12-21 05:37:18', '2017-12-21 05:37:18', 5, 8),
(20, '2017-12-28 05:09:18', '2017-12-28 05:09:18', 1, 9),
(21, '2017-12-28 05:09:18', '2017-12-28 05:09:18', 4, 9),
(22, '2017-12-28 05:09:18', '2017-12-28 05:09:18', 7, 9),
(23, '2017-12-28 05:09:18', '2017-12-28 05:09:18', 10, 9),
(24, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 13, 9),
(25, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 16, 9),
(26, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 19, 9);

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

--
-- 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 apartment door unlocked', 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, '0', 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),
(26, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 1, 5, '0', 1),
(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);

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

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

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

--
-- 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, '2017-12-14 10:12:12', '2017-12-14 10:24:13', 1, 2, '2000.00', '2018-01-15', 'Tenant Note', 37, 'Note1', 41, 54, 45, NULL, 1),
(2, '2017-12-14 10:13:01', '2017-12-14 10:23:53', 1, 3, '1900.00', '2018-01-12', 'Tenant note second', 40, 'Not2', 41, 49, 45, NULL, 0),
(3, '2017-12-19 08:48:04', '2017-12-19 08:48:15', 3, 3, '30.00', '2017-12-21', 'tyhr', 38, '', 0, 54, 45, NULL, 0),
(4, '2017-12-20 03:01:36', '2017-12-28 03:44:27', 4, 3, '4000.00', '2017-12-31', 'aqwdawdsa', 37, '', 0, 54, 45, NULL, 3),
(5, '2017-12-20 03:52:31', '2017-12-21 05:18:48', 5, 3, '60.00', '2017-12-20', 'dfgdfxg', 37, '', 0, 47, 45, NULL, 0),
(6, '2017-12-20 08:40:07', '2017-12-20 08:42:01', 6, 2, '500.00', '2017-12-30', 'dxfgdxfg', 38, '', 0, 54, 45, NULL, 2),
(7, '2017-12-21 05:17:53', '2017-12-21 05:18:48', 5, 2, '60.00', '2017-12-29', 'reet', 37, '', 0, 48, 45, NULL, 0),
(8, '2017-12-21 05:21:58', '2017-12-21 05:22:45', 7, 2, '900.00', '2017-12-28', '4wetert', 38, '', 0, 51, 45, NULL, 0),
(9, '2017-12-27 02:38:39', '2017-12-27 02:38:39', 2, 2, '1200.00', '2017-12-28', 'rtdfhbdzfcbgzdfg', 37, '', 0, 46, 45, NULL, 0),
(10, '2017-12-27 02:44:23', '2017-12-27 02:45:21', 8, 2, '5000.00', '2017-12-30', 'srdgvdfgbrdfgdfgdfg', 38, '', 0, 48, 45, NULL, 0),
(11, '2017-12-28 05:12:54', '2017-12-28 05:26:23', 9, 2, '2000.00', '2018-01-22', 'uyhyh8yhiuhnjihniu', 38, '', 0, 48, 45, NULL, 0),
(12, '2017-12-28 05:22:34', '2017-12-28 05:25:34', 9, 3, '1900.00', '2018-01-18', 'wsgfvdxfgbdcgbdfg', 37, '', 0, 55, 45, NULL, 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, '2017-12-14 10:24:13', '2017-12-14 10:24:13', 1, 1, 1, 2, 'media/contract/1/Image_23146.pdf'),
(2, '2017-12-20 08:42:01', '2017-12-20 08:42:01', 6, 1, 6, 2, 'media/contract/6/Image_24140.pdf'),
(3, '2017-12-28 03:44:27', '2017-12-28 03:44:27', 4, 1, 4, 3, 'media/contract/4/Image_2762.doc');

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

--
-- 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
(1, '2017-12-14 09:42:10', '2017-12-14 09:42:10', 1, 1, 'media/landlord/1/Image_20972.jpg'),
(2, '2017-12-14 09:42:10', '2017-12-14 09:42:10', 1, 1, 'media/landlord/1/Image_31157.jpg'),
(3, '2017-12-14 09:42:10', '2017-12-14 09:42:10', 1, 1, 'media/landlord/1/Image_10314.jpg'),
(4, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 1, 2, 'media/landlord/1/Image_21817.jpg'),
(5, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 1, 2, 'media/landlord/1/Image_22398.jpg'),
(6, '2017-12-15 03:17:20', '2017-12-15 03:17:20', 1, 2, 'media/landlord/1/Image_21727.jpg'),
(7, '2017-12-15 05:46:32', '2017-12-15 05:46:32', 1, 3, 'media/landlord/1/Image_21846.jpg'),
(8, '2017-12-15 05:51:48', '2017-12-15 05:51:48', 1, 4, 'media/landlord/1/Image_15336.jpg'),
(9, '2017-12-15 06:06:58', '2017-12-15 06:06:58', 1, 5, 'media/landlord/1/Image_17449.jpg'),
(10, '2017-12-19 04:26:19', '2017-12-19 04:26:19', 1, 6, 'media/landlord/1/Image_7261.png'),
(12, '2017-12-21 05:21:41', '2017-12-21 05:21:41', 1, 7, 'media/landlord/1/Image_32615.jpg'),
(13, '2017-12-21 05:21:41', '2017-12-21 05:21:41', 1, 7, 'media/landlord/1/Image_20756.jpg'),
(14, '2017-12-21 05:37:18', '2017-12-21 05:37:18', 1, 8, 'media/landlord/1/Image_26403.jpg'),
(15, '2017-12-21 05:37:18', '2017-12-21 05:37:18', 1, 8, 'media/landlord/1/Image_17440.jpg'),
(16, '2017-12-21 05:37:18', '2017-12-21 05:37:18', 1, 8, 'media/landlord/1/Image_29145.jpg'),
(17, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 1, 9, 'media/landlord/1/Image_23103.jpg'),
(18, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 1, 9, 'media/landlord/1/Image_20236.jpg'),
(19, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 1, 9, 'media/landlord/1/Image_85.jpg'),
(20, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 1, 9, 'media/landlord/1/Image_14954.jpg'),
(21, '2017-12-28 05:09:19', '2017-12-28 05:09:19', 1, 9, 'media/landlord/1/Image_23387.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);

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

--
-- 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
('1b37cffd-e8a3-426f-81f8-277bcbefcdad', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"11\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2017-12-28 05:22:47', '2017-12-28 05:22:47'),
('1c693c86-24a6-44ae-b278-53230e69f4ad', '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\"}', NULL, '2017-12-20 03:03:06', '2017-12-20 03:03:06'),
('2c8e596a-3854-4899-902d-f86f7f00dbd3', '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\"}', '2017-12-19 08:48:20', '2017-12-19 08:48:15', '2017-12-19 08:48:20'),
('2d49b861-84f3-48a5-9621-a92d2f899d81', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"9\",\"message\":\"Neo trinity made a bid against your property Estate Valley\"}', NULL, '2017-12-28 05:12:55', '2017-12-28 05:12:55'),
('2fa46786-1ee0-4008-bab0-cd081c7761b8', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"8\",\"message\":\"Neo trinity made a bid against your property Ganpati\"}', '2017-12-27 02:44:36', '2017-12-27 02:44:23', '2017-12-27 02:44:36'),
('3187258a-da22-40a7-b0e0-7b9af17364a5', 'App\\Notifications\\PostNewNotification', 3, 'App\\Models\\User', '{\"bid_id\":\"2\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2017-12-14 10:17:05', '2017-12-14 10:16:54', '2017-12-14 10:17:05'),
('36100eae-0529-45b4-8ffe-4e4429142e48', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":4,\"property_id\":4,\"message\":\"Bidder has paid the commision fees against property ert\"}', NULL, '2017-12-20 03:03:43', '2017-12-20 03:03:43'),
('3c0480e8-3eeb-4934-bab7-2d2db774a22f', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"1\",\"message\":\"Ema Watson made a bid against your property Antariksh\"}', NULL, '2017-12-14 10:13:02', '2017-12-14 10:13:02'),
('41416859-3c55-4ebf-a63c-d56b06271dd7', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"7\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2017-12-21 05:18:49', '2017-12-21 05:18:49'),
('4247dfb7-3c04-444c-af04-698fe942a749', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"10\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2017-12-27 02:45:35', '2017-12-27 02:45:21', '2017-12-27 02:45:35'),
('4c30831e-234e-41b1-84e5-1e036f38a48a', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"3\",\"message\":\"Neo trinity made a bid against your property trft\"}', '2017-12-19 08:48:12', '2017-12-19 08:48:05', '2017-12-19 08:48:12'),
('57f6ff43-9e1b-4e1a-8bb4-1342bed0fb4f', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"5\",\"message\":\"Neo trinity made a bid against your property 4545t\"}', '2017-12-21 05:18:32', '2017-12-21 05:17:53', '2017-12-21 05:18:32'),
('65fea284-4e9b-4e39-bcab-0750ee3494a0', '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\"}', '2017-12-14 10:23:18', '2017-12-14 10:22:27', '2017-12-14 10:23:18'),
('68e4d787-6447-4337-83cd-101686e0f875', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":6,\"property_id\":6,\"message\":\"Bidder has paid the commision fees against property er5y\"}', NULL, '2017-12-20 08:41:11', '2017-12-20 08:41:11'),
('753673d4-e77c-43ca-ad9c-a31c11a447cc', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"8\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2017-12-21 05:22:11', '2017-12-21 05:22:11'),
('787a7204-0fbe-45e8-924b-974fe8d24555', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":9,\"message\":\"Neo trinity has opt-out from the bid\"}', NULL, '2017-12-28 05:23:23', '2017-12-28 05:23:23'),
('84aad65e-41a3-4fd3-9bbf-230b60e5886c', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":1,\"property_id\":1,\"message\":\"Bidder has paid the commision fees against property Antariksh\"}', '2017-12-19 05:15:13', '2017-12-14 10:23:53', '2017-12-19 05:15:13'),
('858cda8d-4477-457a-b029-db30a88b36d3', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":9,\"message\":\"Ema Watson has opt-out from the bid\"}', '2017-12-28 06:02:59', '2017-12-28 05:25:34', '2017-12-28 06:02:59'),
('8c12bfa5-b4f5-451f-b428-45e046f67c68', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"9\",\"message\":\"Ema Watson made a bid against your property Estate Valley\"}', NULL, '2017-12-28 05:22:34', '2017-12-28 05:22:34'),
('9a2bd3e7-0e2a-4088-93af-a61008bf7aff', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"11\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2017-12-28 05:26:23', '2017-12-28 05:26:23'),
('a184eccd-e085-4801-bc56-86cb3af9e07e', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"6\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', '2017-12-20 08:40:24', '2017-12-20 08:40:18', '2017-12-20 08:40:24'),
('a2705e68-702a-4c37-8f18-b2234f2221f8', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":1,\"message\":\"Ema Watson has opt-out from the bid\"}', '2017-12-14 10:22:01', '2017-12-14 10:21:40', '2017-12-14 10:22:01'),
('c1c3f600-d484-4f12-8a59-60d3dad7cf18', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"5\",\"message\":\"Ema Watson made a bid against your property 4545t\"}', NULL, '2017-12-20 03:52:31', '2017-12-20 03:52:31'),
('cbb13c86-9996-4851-9f6a-447e2b76fbdd', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"4\",\"message\":\"Ema Watson made a bid against your property ert\"}', NULL, '2017-12-20 03:01:37', '2017-12-20 03:01:37'),
('e42ea76d-451e-4e21-94bd-edd2cdc7dc0d', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"1\",\"message\":\"Neo trinity made a bid against your property Antariksh\"}', '2017-12-14 10:15:58', '2017-12-14 10:12:12', '2017-12-14 10:15:58'),
('e6799c99-9b09-44bc-9f36-4a2d06ad25e8', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"6\",\"message\":\"Neo trinity made a bid against your property er5y\"}', '2017-12-20 08:40:15', '2017-12-20 08:40:07', '2017-12-20 08:40:15'),
('f62c4879-1844-48b4-96c6-9858274204c8', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"7\",\"message\":\"Neo trinity made a bid against your property dgvdxg\"}', '2017-12-21 05:22:07', '2017-12-21 05:21:58', '2017-12-21 05:22:07'),
('f84d5760-4fb0-4a13-8d7c-2e354ff1c9b4', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":8,\"property_id\":7,\"message\":\"Bidder has paid the commision fees against property dgvdxg\"}', NULL, '2017-12-21 05:22:45', '2017-12-21 05:22:45'),
('fbb5ecc3-928f-4f27-ba76-fb6c732295e1', 'App\\Notifications\\PostNewNotification', 3, 'App\\Models\\User', '{\"bid_id\":\"12\",\"property_id\":\"\",\"message\":\"Your bid has been selected by the Owner, Please confirm the same\"}', NULL, '2017-12-28 05:23:46', '2017-12-28 05:23:46'),
('ff81fc86-c803-49b1-940b-9367d4c17253', 'App\\Notifications\\PostNewNotification', 2, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"2\",\"message\":\"Neo trinity made a bid against your property Raheja Properties\"}', NULL, '2017-12-27 02:38:40', '2017-12-27 02:38:40');

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

--
-- 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` int(11) 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'
) 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`) VALUES
(1, '2017-12-14 09:42:10', '2017-12-19 05:13:19', 'Antariksh', 'Ras Al Khor - Dubai', 123, '2100', '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.18221', '55.31020369999999', 2100.00, 400.00, 2500.00, '', '2018-01-11', 3, 11, 14, 19, 29, 1, 3, 5, 1, 5),
(2, '2017-12-15 03:17:20', '2017-12-27 02:38:40', 'Raheja Properties', 'Saadiyat Island - Abu Dhabi', 789, '1300', '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', 1400.00, 600.00, 2000.00, '', '2018-01-01', 6, 12, 15, 16, 29, 2, 1, 1, 0, 5),
(3, '2017-12-15 05:46:32', '2017-12-28 05:06:51', 'trft', 'Qasba Canal - Sharjah', 656, '454', 'sdzff', '25.3211566', '55.37307780000003', 34.00, 3434.00, 3468.00, '', '2017-12-16', 1, 8, 14, 16, 27, 1, 1, 1, 1, 13),
(4, '2017-12-15 05:51:48', '2017-12-20 03:03:43', 'ert', 'Al Danah - Abu Dhabi', 3453535, '454', 'fghfdxh', '24.4706173', '54.35115689999998', 4545.00, 464656.00, 469201.00, '', '2017-12-22', 1, 12, 14, 18, 28, 1, 2, 5, 1, 4),
(5, '2017-12-15 06:06:58', '2017-12-28 05:07:01', '4545t', 'Sharjah', 4534, '455', 'fvhbcvh', '25.2359367', '55.3491818', 65.00, 656.00, 721.00, '', '2017-12-20', 6, 11, 13, 19, 29, 1, 0, 1, 1, 9),
(6, '2017-12-19 04:26:19', '2017-12-20 08:41:11', 'er5y', '46 Al Safa Street - Dubai', 464, '5656', 'rtfyr', '25.2061080197085', '55.26414396970847', 546.00, 5656.00, 6202.00, '', '2017-12-29', 3, 11, 13, 18, 30, 1, 2, 5, 1, 2),
(7, '2017-12-19 08:35:54', '2017-12-21 05:22:45', 'dgvdxg', 'GGR2 - Green Drive - Dubai', 345, '446', '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.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.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.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.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.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.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.0382607197085', '55.21605141970849', 1000.00, 1000.00, 2000.00, '', '2017-12-21', 3, 12, 13, 19, 29, 1, 2, 5, 1, 8),
(8, '2017-12-21 05:37:17', '2017-12-28 05:07:07', 'Ganpati', 'Deira City Centre Metro Station 2 - Deira - Dubai', 1234, '5666', '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.\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.\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.25287701970849', '55.32895701970847', 455464.00, 56436.00, 511900.00, '', '2017-12-28', 3, 12, 14, 18, 29, 1, 1, 1, 1, 4),
(9, '2017-12-28 05:09:18', '2017-12-28 05:26:23', 'Estate Valley', 'Fujairah Bus Station - Fujairah', 1103, '1500', '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.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.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.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.1212770197085', '56.30270601970847', 2100.00, 400.00, 2500.00, '', '2018-01-15', 4, 8, 14, 19, 29, 8, 2, 1, 1, 5);

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

--
-- 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', '2017-12-28 05:22:34', 'Active', 5),
(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-12-21 05:22:45', 'Closed', 4);

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

--
-- 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, '2017-12-27 04:24:15', '2017-12-27 04:24:15', 5, '971501234567', 'Please use 311349 as OTP for verifying your mobile number', 33453384),
(2, '2017-12-27 04:25:07', '2017-12-27 04:25:07', 6, '971501234567', 'Please use 202722 as OTP for verifying your mobile number', 33453393),
(3, '2017-12-27 09:50:15', '2017-12-27 09:50:15', 7, '971501234567', 'Please use 928781 as OTP for verifying your mobile number', 33470462),
(4, '2017-12-27 09:53:38', '2017-12-27 09:53:38', 8, '971501234567', 'Please use 605535 as OTP for verifying your mobile number', 33470690);

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

--
-- 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, '2017-12-20 08:24:12', '2017-12-20 08:24:12', 'dcbhfvbh', 'fgchfgch', 1, 1, 2, 0),
(2, NULL, NULL, 'sfgs', 'gdfxgzfdg', 5, 2, 2, 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, '2017-12-21 05:24:35', '2017-12-21 05:24:35', 2, 8, 2, 'Statisfy'),
(2, '2017-12-21 05:38:26', '2017-12-21 05:38:26', 1, 8, 1, 'Statisfy');

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

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

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

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

INSERT INTO `transactions` (`id`, `created_at`, `updated_at`, `model_id`, `amount`, `payment_method_code`, `payment_status_id`, `reference_id`, `user_id`, `parent_id`, `custom_1`, `custom_2`, `custom_3`) VALUES
(1, '2017-12-14 10:23:24', '2017-12-14 10:23:53', 2, '20.00', 'Telr', 3, '0', 2, 1, NULL, NULL, NULL),
(2, '2017-12-19 08:48:23', '2017-12-19 08:48:45', 2, '0.30', 'Telr', 2, '0', 2, 3, NULL, NULL, NULL),
(3, '2017-12-19 08:48:53', '2017-12-19 08:49:13', 2, '0.30', 'Telr', 2, '0', 2, 3, NULL, NULL, NULL),
(4, '2017-12-20 03:03:22', '2017-12-20 03:03:43', 2, '40.00', 'Telr', 3, '0', 3, 4, NULL, NULL, NULL),
(5, '2017-12-20 08:40:51', '2017-12-20 08:41:11', 2, '5.00', 'Telr', 3, '0', 2, 6, NULL, NULL, NULL),
(6, '2017-12-21 05:19:08', '2017-12-21 05:19:30', 2, '0.60', 'Telr', 2, '0', 2, 7, NULL, NULL, NULL),
(7, '2017-12-21 05:19:37', '2017-12-21 05:20:02', 2, '0.60', 'Telr', 2, '0', 2, 7, NULL, NULL, NULL),
(8, '2017-12-21 05:22:25', '2017-12-21 05:22:45', 2, '9.00', 'Telr', 3, '0', 2, 8, NULL, NULL, NULL),
(9, '2017-12-27 03:55:33', '2017-12-27 03:55:33', 2, '50.00', 'Telr', 1, '0', 2, 10, NULL, NULL, NULL),
(10, '2017-12-27 03:55:55', '2017-12-27 03:55:55', 2, '50.00', 'Telr', 1, '0', 2, 10, NULL, NULL, NULL),
(11, '2017-12-27 03:56:06', '2017-12-27 03:56:06', 2, '50.00', 'Telr', 1, '0', 2, 10, NULL, NULL, NULL),
(12, '2017-12-27 03:56:27', '2017-12-27 03:56:27', 2, '50.00', 'Telr', 1, '0', 2, 10, NULL, NULL, NULL),
(13, '2017-12-27 05:42:45', '2017-12-27 05:42:45', 2, '50.00', 'Telr', 1, '0', 2, 10, NULL, NULL, NULL),
(14, '2017-12-28 05:27:53', '2017-12-28 05:27:53', 2, '20.00', 'Telr', 1, '0', 2, 11, NULL, NULL, NULL),
(15, '2017-12-28 05:28:03', '2017-12-28 05:28:03', 2, '20.00', 'Telr', 1, '0', 2, 11, NULL, NULL, NULL);

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

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

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

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

INSERT INTO `user_logins` (`id`, `created_at`, `updated_at`, `user_id`, `login_time`, `logout_time`) VALUES
(1, NULL, NULL, 1, '2017-12-28 08:53:06', NULL),
(2, NULL, '2017-12-28 05:26:37', 2, '2017-12-28 10:56:37', '2017-12-28 10:53:32'),
(3, NULL, '2017-12-28 05:26:30', 3, '2017-12-28 10:53:37', '2017-12-28 10:56:30');

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

--
-- 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', '2017-11-27 03:26:11', 'Admin', 0),
(2, '2017-11-27 03:26:11', '2017-12-28 10:19:25', 'Property Owner', 2),
(3, '2017-11-27 03:26:11', '2017-12-26 03:45:07', 'Tenant', 2);

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

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  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 `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 `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=27;

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

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

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

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

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

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

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

--
-- 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 `sms_reports`
--
ALTER TABLE `sms_reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

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

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

