-- 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-20 11:51:48', '2017-11-20 11:51:48', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(2, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Pool', 'parking-spot', 2, 1, 0),
(3, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Gym', 'parking-spot', 3, 1, 0),
(4, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Elevator', 'parking-spot', 4, 1, 0),
(5, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Parking Spot', 'parking-spot', 5, 1, 0),
(6, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Fireplace', 'parking-spot', 6, 1, 0),
(7, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(8, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Doorman', 'parking-spot', 8, 1, 0),
(9, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Dishwasher', 'parking-spot', 9, 1, 0),
(10, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Deck', 'parking-spot', 10, 1, 0),
(11, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Storage', 'parking-spot', 11, 1, 0),
(12, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(13, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(14, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Garden', 'parking-spot', 14, 1, 0),
(15, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Balcony', 'parking-spot', 15, 1, 0),
(16, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Furnished', 'parking-spot', 16, 1, 0),
(17, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'View', 'parking-spot', 17, 1, 0),
(18, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'Student Friendly', 'parking-spot', 18, 1, 0),
(19, '2017-11-20 11:51:48', '2017-11-20 11:51:48', 'High Rise', 'parking-spot', 19, 1, 0),
(20, '2017-11-20 11:51:48', '2017-11-20 11:51:48', '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-21 03:29:45', '2017-11-21 03:29:45', 1, 3),
(2, '2017-11-21 03:29:45', '2017-11-21 03:29:45', 2, 3),
(3, '2017-11-21 03:29:45', '2017-11-21 03:29:45', 3, 3),
(4, '2017-11-21 03:29:45', '2017-11-21 03:29:45', 4, 3),
(5, '2017-11-21 03:29:45', '2017-11-21 03:29:45', 5, 3),
(6, '2017-11-21 03:29:45', '2017-11-21 03:29:45', 6, 3),
(7, '2017-11-21 03:33:53', '2017-11-21 03:33:53', 1, 4),
(8, '2017-11-21 03:33:53', '2017-11-21 03:33:53', 10, 4),
(9, '2017-11-21 03:33:53', '2017-11-21 03:33:53', 11, 4),
(10, '2017-11-21 03:33:53', '2017-11-21 03:33:53', 18, 4),
(11, '2017-11-21 03:33:54', '2017-11-21 03:33:54', 20, 4),
(12, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 2, 6),
(13, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 3, 6),
(14, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 4, 6),
(15, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 9, 6),
(16, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 10, 6),
(17, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 14, 6),
(18, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 16, 6),
(19, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 2, 7),
(20, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 3, 7),
(21, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 4, 7),
(22, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 9, 7),
(23, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 10, 7),
(24, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 14, 7),
(25, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 16, 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-20 11:51:49', '2017-11-20 11:51:49', 'Active', 0),
(2, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Inactive', 0),
(3, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Suspended', 0),
(4, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Expired', 0),
(5, '2017-11-20 11:51:49', '2017-11-20 11:51:49', '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-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Abu Dhabi', 1),
(2, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Ajman', 2),
(3, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Dubai', 3),
(4, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Fujairah', 1),
(5, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Ras al-Khaimah', 1),
(6, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Sharjah', 1),
(7, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 1, 'Umm al-Quwain', 1),
(8, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 2, 'Apartment', 1),
(9, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 2, 'Villa', 1),
(10, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 2, 'Townhouse', 1),
(11, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 2, 'Penthouse', 1),
(12, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 2, 'Duplex', 1),
(13, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 3, 'Leave the keys with the building security', 1),
(14, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 3, 'Leave the apartment door unlocked', 1),
(15, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 3, 'Not provide an option to view the property', 1),
(16, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '0', 1),
(17, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '1', 1),
(18, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '2', 1),
(19, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '3', 1),
(20, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '4', 1),
(21, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '5', 1),
(22, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '6', 1),
(23, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '7', 1),
(24, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '8', 1),
(25, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 4, '9+', 1),
(26, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '0', 1),
(27, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '1', 1),
(28, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '2', 1),
(29, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '3', 1),
(30, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '4', 1),
(31, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '5', 1),
(32, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '6', 1),
(33, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '7', 1),
(34, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '8', 1),
(35, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 1, 5, '9+', 1);

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

--
-- 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-20 11:51:49', '2017-11-20 11:51:49', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(2, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(3, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(4, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(5, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Wash Room Sizes', 'wash_room_size', '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-20 11:51:49', '2017-11-20 11:51:49', 'Active', 0),
(2, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Inactive', 0);

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

--
-- 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-21 05:34:03', '2017-11-21 05:34:03', 1, 5, 'media/tenant/1/Image_1511247843.jpg'),
(2, '2017-11-21 05:34:03', '2017-11-21 05:34:03', 1, 5, 'media/tenant/1/Image_1511247844.jpg'),
(3, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 1, 7, 'media/tenant/2/Image_1511260504.jpg'),
(4, '2017-11-21 09:05:04', '2017-11-21 09:05:04', 1, 7, 'media/tenant/2/Image_1511260504.jpg'),
(5, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 1, 7, 'media/tenant/2/Image_1511260561.jpg'),
(6, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 1, 7, 'media/tenant/2/Image_1511260561.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
(49, '2017_11_18_112919_create_property_table', 1),
(50, '2017_11_18_113013_create_amenities_table', 1),
(51, '2017_11_18_115541_create_amenity_property_table', 1),
(52, '2017_11_18_115701_create_amenity_status_table', 1),
(53, '2017_11_18_121357_create_property_status_table', 1),
(54, '2017_11_18_145903_create_policy_types', 1),
(55, '2017_11_18_145925_create_policies', 1),
(56, '2017_11_19_175409_create_app_code_categories', 1),
(57, '2017_11_19_181338_create_app_codes', 1),
(58, '2017_11_19_181612_create_app_code_statuses', 1),
(59, '2017_11_20_085637_create_users_table', 1),
(60, '2017_11_20_091213_create_user_types_table', 1),
(63, '2017_11_21_092831_create_medias_table', 2);

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

--
-- 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-20 11:51:49', '2017-11-20 11:51:49', 'No dogs', NULL, 1, 1, 0),
(2, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'No cats', NULL, 1, 1, 0),
(3, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Cleaning at tenants risk', NULL, 1, 1, 0),
(4, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'No more drilling on walls', NULL, 2, 1, 0),
(5, '2017-11-20 11:51:49', '2017-11-20 11:51:49', '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-20 11:51:49', '2017-11-20 11:51:49', 'Pet policy', 'Something about pet animals', 0),
(2, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Maintenence policy', 'Something about Maintenence policy', 0),
(3, '2017-11-20 11:51:49', '2017-11-20 11:51:49', '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
(3, '2017-11-21 03:14:26', '2017-11-21 03:14:26', 'retgdf', 'Garhoud - Dubai', 123, '121212', 'fdgdfgdfgfdgv', '', '', 100.00, 200.00, 300.00, '', '2017-11-21', 1, 8, 13, 17, 28, 1, 0, 1),
(4, '2017-11-21 03:33:53', '2017-11-21 03:33:53', 'rt', 'RTA Parking - Al Maktoum Road - Dubai', 34, '343434', 'rfgdfgdfgdfg', '', '', 3434.00, 3434.00, 6868.00, '', '2017-11-21', 3, 9, 15, 21, 32, 1, 0, 1),
(5, '2017-11-21 04:48:39', '2017-11-21 04:48:39', 'ert', 'Trade Centre - Dubai', 454545, '4545', 'gfhngfhnvghbvgbh', '', '', 4545.00, 5454.00, 9999.00, '', '2017-11-21', 6, 10, 14, 20, 30, 1, 0, 1),
(7, '2017-11-21 09:06:01', '2017-11-21 09:06:01', 'John First Property', 'Dafza - Dubai', 1234, '1500', 'This is the best property', '', '', 1000.00, 1000.00, 2000.00, '', '2017-11-25', 3, 9, 15, 19, 29, 2, 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-20 11:51:49', '2017-11-20 11:51:49', 'Active', 0),
(2, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Inactive', 0),
(3, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Suspended', 0),
(4, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Expired', 0),
(5, '2017-11-20 11:51:49', '2017-11-20 11:51:49', 'Closed', 0);

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

--
-- 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-21 12:56:51', 1, '2017-11-21 11:26:51', NULL),
(3, '2017-11-21 15:58:29', '2017-11-21 15:58:29', 2, '2017-11-21 14:28:29', 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-20 11:51:50', '2017-11-20 11:51:50', 'Admin', 0),
(2, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 'Property Owner', 2),
(3, '2017-11-20 11:51:50', '2017-11-20 11:51:50', 'Tenant', 0);

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

--
-- Table structure for table `user_types_old`
--

CREATE TABLE `user_types_old` (
  `id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(50) NOT NULL,
  `user_count` bigint(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `user_types_old`
--

INSERT INTO `user_types_old` (`id`, `created_at`, `modified_at`, `name`, `user_count`) VALUES
(1, '2017-11-02 16:24:55', '2017-11-02 16:24:55', 'Admin', 1),
(2, '2017-11-02 16:24:55', '2017-11-02 16:24:55', 'Property Owner', 2),
(3, '2017-11-02 16:25:05', '2017-11-02 16:25:05', '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 `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 `user_logins`
--
ALTER TABLE `user_logins`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `user_types_old`
--
ALTER TABLE `user_types_old`
  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=26;
--
-- 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=36;
--
-- AUTO_INCREMENT for table `app_code_categories`
--
ALTER TABLE `app_code_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 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 `medias`
--
ALTER TABLE `medias`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- 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 `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` int(11) 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;
--
-- AUTO_INCREMENT for table `user_types_old`
--
ALTER TABLE `user_types_old`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
