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




--
-- 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-11-27 03:26:11', '2017-11-29 07:50:31', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 3),
(2, '2017-11-27 03:26:11', '2017-11-28 05:12:48', 'Pool', 'parking-spot', 2, 1, 2),
(3, '2017-11-27 03:26:11', '2017-11-28 05:12:48', 'Gym', 'parking-spot', 3, 1, 2),
(4, '2017-11-27 03:26:11', '2017-11-28 05:12:48', 'Elevator', 'parking-spot', 4, 1, 2),
(5, '2017-11-27 03:26:11', '2017-11-28 05:12:48', 'Parking Spot', 'parking-spot', 5, 1, 2),
(6, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Fireplace', 'parking-spot', 6, 1, 0),
(7, '2017-11-27 03:26:11', '2017-11-28 04:57:00', 'Air Conditioning', 'parking-spot', 7, 1, 1),
(8, '2017-11-27 03:26:11', '2017-11-28 05:12:48', 'Doorman', 'parking-spot', 8, 1, 2),
(9, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Dishwasher', 'parking-spot', 9, 1, 0),
(10, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Deck', 'parking-spot', 10, 1, 0),
(11, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Storage', 'parking-spot', 11, 1, 0),
(12, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(13, '2017-11-27 03:26:11', '2017-11-28 04:57:00', 'Hardwood Floors', 'parking-spot', 13, 1, 1),
(14, '2017-11-27 03:26:11', '2017-11-28 04:57:00', 'Garden', 'parking-spot', 14, 1, 1),
(15, '2017-11-27 03:26:11', '2017-11-28 04:57:00', 'Balcony', 'parking-spot', 15, 1, 1),
(16, '2017-11-27 03:26:11', '2017-11-28 04:57:00', 'Furnished', 'parking-spot', 16, 1, 1),
(17, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'View', 'parking-spot', 17, 1, 0),
(18, '2017-11-27 03:26:11', '2017-11-28 04:57:00', 'Student Friendly', 'parking-spot', 18, 1, 1),
(19, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'High Rise', 'parking-spot', 19, 1, 0),
(20, '2017-11-27 03:26:11', '2017-11-27 03:26:11', 'Utilities Included', 'parking-spot', 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-11-27 04:32:35', '2017-11-27 04:32:35', 2, 1),
(2, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 3, 1),
(3, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 4, 1),
(4, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 5, 1),
(5, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 7, 1),
(6, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 14, 1),
(7, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 16, 1),
(8, '2017-11-28 04:57:00', '2017-11-28 04:57:00', 18, 5),
(9, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 1, 6),
(10, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 2, 6),
(11, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 3, 6),
(12, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 4, 6),
(13, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 5, 6),
(14, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 8, 6),
(15, '2017-11-29 07:50:31', '2017-11-29 07:50:31', 1, 7);

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

--
-- 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, 'Active', 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);

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

--
-- 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
) 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`) VALUES
(1, '2017-11-27 06:35:56', '2017-11-27 06:35:56', 1, 7, '22000.00', '2018-01-05', 'Test note', 37, '', 0, 46, 45),
(2, '2017-11-27 08:23:58', '2017-11-27 08:23:58', 1, 8, '24000.00', '2018-01-02', 'Second Bid', 38, '', 0, 46, 45),
(3, '2017-11-27 08:35:28', '2017-11-27 08:35:28', 1, 9, '23000.00', '2018-01-10', 'Third Bid', 39, '', 0, 46, 45),
(4, '2017-11-28 05:20:43', '2017-11-28 05:20:43', 6, 3, '16000.00', '2017-12-25', 'First Bote', 37, '', 0, 46, 45);

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

--
-- 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-11-27 04:32:35', '2017-11-27 04:32:35', 1, 1, 'media/tenant/1/Image_980.jpg'),
(2, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 1, 1, 'media/tenant/1/Image_27005.jpg'),
(3, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 1, 1, 'media/tenant/1/Image_12402.jpg'),
(4, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 1, 1, 'media/tenant/1/Image_3267.jpg'),
(5, '2017-11-28 04:57:00', '2017-11-28 04:57:00', 1, 5, 'media/tenant/1/Image_31248.jpg'),
(6, '2017-11-28 04:57:00', '2017-11-28 04:57:00', 1, 5, 'media/tenant/1/Image_2313.jpg'),
(7, '2017-11-28 04:57:00', '2017-11-28 04:57:00', 1, 5, 'media/tenant/1/Image_18190.jpg'),
(8, '2017-11-28 04:57:00', '2017-11-28 04:57:00', 1, 5, 'media/tenant/1/Image_13615.jpg'),
(9, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 1, 6, 'media/tenant/1/Image_10044.jpg'),
(10, '2017-11-28 05:12:48', '2017-11-28 05:12:48', 1, 6, 'media/tenant/1/Image_11461.jpg'),
(11, '2017-11-29 07:50:31', '2017-11-29 07:50:31', 1, 7, 'media/tenant/1/Image_31822.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);

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

--
-- 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
) 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`) VALUES
(1, '2017-11-27 04:32:35', '2017-11-27 04:32:35', 'Estate Valley', 'Marina Mall - Dubai', 1105, '1500', 'Best view property', '25.07652224437482', '55.140563051342724', 25000.00, 5000.00, 30000.00, '', '2018-01-01', 3, 8, 14, 19, 29, 1, 0, 1),
(5, '2017-11-28 04:57:00', '2017-11-28 04:57:00', 'Raheja Property', 'Mall of the Emirates - Al Barsha - Dubai', 1123, '1800', 'All facilities are there', '25.11880577334609', '55.197983781933544', 35000.00, 10000.00, 45000.00, '', '2017-12-01', 3, 12, 13, 19, 30, 1, 0, 1),
(6, '2017-11-28 05:12:47', '2017-11-28 05:20:43', 'Antariksh', 'Trade Centre - Dubai', 1234, '1600', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '25.118572632206913', '55.20150284016108', 18000.00, 12000.00, 30000.00, '', '2017-12-15', 3, 9, 15, 21, 32, 1, 1, 1),
(7, '2017-11-29 07:50:31', '2017-11-29 07:50:31', 'abc', '334 Al Wahda Street - Sharjah', 23, '12', 'dfddff', '25.071469007208666', '55.14073471271968', 212.00, 1212.00, 1424.00, '', '2017-11-30', 2, 11, 13, 18, 28, 1, 0, 1);

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

--
-- 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-11-29 07:50:31', 'Active', 7),
(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 `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'
) 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`) VALUES
(1, '2017-11-27 04:13:47', '2017-11-27 04:14:44', 'John', 'Smith', 'john@bid2rent.ae', '$2y$10$MEiLueasgXHK9PS1vnGvzOk433229a7MRxMPMnfVoVFOLkvcJBV6G', 971, 501234567, 1, 2, 1, 447991, ''),
(3, '2017-11-27 04:16:35', '2017-11-27 04:16:37', 'Neo', 'Matrix', 'neo@bid2rent.ae', '$2y$10$CXmGqPB6KhXytAP.ByPVbOtjRxxWfERWvxtW44UF1ZKA.sl8HNy12', 971, 501234567, 1, 3, 1, 431677, 'media/tenant/6/501234567_1511764088.pdf'),
(7, '2017-11-27 04:59:22', '2017-11-27 04:59:39', 'Jessica', 'Babajan', 'jes@bid2rent.ae', '$2y$10$fPn8rLCK9o0HudB5MZpPxe8oRHNyXRmJqrHVB7/fqrof0cbExBShS', 971, 501234567, 1, 3, 1, 676947, 'media/tenant/7/501234567_1511764162.pdf'),
(8, '2017-11-27 08:03:56', '2017-11-27 08:03:57', 'Vicky', 'Romson', 'vicky@bid2rent.ae', '$2y$10$hQNVtjU2URI8V6DyMlx8quDpwfcdSNfiBKK999jQ3brpHwzsXnTrW', 971, 501234567, 1, 3, 1, 914004, 'media/tenant/8/501234567_1511775236.pdf'),
(9, '2017-11-27 08:27:04', '2017-11-27 08:27:06', 'Prashant', 'Saini', 'prashant@bid2rent.ae', '$2y$10$S22QqdvjJBrRx/cwP8/d5.Lp14TAgOe7M6De049WGszPryJLTnqUC', 971, 523654123, 1, 3, 1, 763024, 'media/tenant/9/523654123_1511776624.pdf'),
(10, '2017-11-27 09:32:20', '2017-11-27 09:32:21', 'Alex', 'Smith', 'alex@bid2rent.ae', '$2y$10$KyiY2dg7bJ6tCyXl6Jx.aO6o9OJSD6nBW89aEPyoyO5wZfviN2ujm', 971, 563214567, 1, 3, 1, 194674, 'media/tenant/10/563214567_1511780540.jpg'),
(14, '2017-11-28 03:58:14', '2017-11-28 03:58:14', 'sdf', 'rt', 'trt@we.ik', '$2y$10$47H/FAjy9JOQygf47Uecy.po6E0XeSBZAvi8U2fSlXbhyA64kl1qG', 971, 501234567, 0, 2, 1, 780328, ''),
(15, '2017-11-28 04:00:55', '2017-11-28 04:00:57', 'er', 're', 'q@q.uk', '$2y$10$HNJlfEPuAOsnmWF.kRpIfOJ7goEvxvtVlzrcq3rx6OzMoyGqV2lmq', 971, 501234567, 1, 2, 1, 823806, ''),
(16, '2017-11-28 07:31:49', '2017-11-28 07:31:54', 'a', 'a', 'a@a.no', '$2y$10$0OZ/mMGGhFw3rwtiNe8GVeSfX5oX4EHaH2wg9mL/cDFO896LXeNf.', 971, 501234567, 1, 2, 1, 886703, ''),
(17, '2017-11-28 07:57:41', '2017-11-28 07:57:42', 'hjh', 'dsd', 's@s.com', '$2y$10$8cl1UY/.DV/YtF9vZ9iuCOTDxiNVYn1xIfKi99r2mCxBvK7mTa5Xu', 971, 501234567, 1, 3, 1, 465185, 'media/tenant/17/501234567_1511861261.pdf'),
(18, '2017-11-28 08:08:12', '2017-11-28 08:08:18', 'as', 'sas', 'r@r.no', '$2y$10$pH3ptjVkQpXaPlYJmJcbZu1dgBHHQt.O1WkIAo60KPnI1huj9ytm.', 971, 501234567, 1, 2, 1, 869290, ''),
(19, '2017-11-28 09:48:54', '2017-11-28 09:51:36', 'Edison', 'Ronz', 'edison@bid2rent.ae', '$2y$10$XyGFUczUVWwh6NPB8dBCcuY1.7qsgXfB/DP.WgG3bp7RHVs3CeDzK', 971, 563214568, 1, 2, 1, 242163, '');

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

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

CREATE TABLE `user_logins` (
  `id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` bigint(11) NOT NULL,
  `login_time` datetime NOT NULL,
  `logout_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `user_logins` (`id`, `created_at`, `modified_at`, `user_id`, `login_time`, `logout_time`) VALUES
(1, '2017-11-10 12:41:02', '2017-11-13 04:11:11', 37, '2017-11-13 04:11:11', NULL),
(2, '2017-11-21 12:56:51', '2017-11-29 08:14:04', 1, '2017-11-29 08:14:04', '2017-11-28 15:18:02'),
(3, '2017-11-21 15:58:29', '2017-11-24 11:53:07', 2, '2017-11-24 11:53:07', NULL),
(4, '2017-11-23 17:28:14', '2017-11-29 08:25:09', 3, '2017-11-29 08:25:09', '2017-11-28 13:01:28'),
(5, '2017-11-27 12:00:01', '2017-11-27 13:59:19', 7, '2017-11-27 13:59:19', NULL),
(6, '2017-11-27 15:04:40', '2017-11-27 15:04:40', 8, '2017-11-27 13:34:40', NULL),
(7, '2017-11-27 15:27:18', '2017-11-28 09:43:32', 9, '2017-11-28 09:43:19', '2017-11-28 09:43:32'),
(8, '2017-11-28 14:32:06', '2017-11-28 13:26:28', 16, '2017-11-28 13:02:06', '2017-11-28 13:26:28'),
(9, '2017-11-28 16:52:15', '2017-11-28 16:52:15', 19, '2017-11-28 15:22:15', NULL);

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

--
-- 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-11-28 09:48:54', 'Property Owner', 9),
(3, '2017-11-27 03:26:11', '2017-11-28 07:57:41', '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 `medias`
--
ALTER TABLE `medias`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  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 `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=16;
--
-- 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=55;
--
-- 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=5;
--
-- AUTO_INCREMENT for table `medias`
--
ALTER TABLE `medias`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;
--
-- 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=8;
--
-- 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 `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `user_types`
--
ALTER TABLE `user_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
