-- 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-12-06 09:55:08', '2017-12-13 09:28:39', 'Washer/Dryer In Unit', 'icon-washer', 1, 1, 2),
(2, '2017-12-06 09:55:08', '2017-12-08 02:45:03', 'Pool', 'icon-pool', 2, 1, 0),
(3, '2017-12-06 09:55:08', '2017-12-13 09:28:39', 'Gym', 'icon-gym', 3, 1, 1),
(4, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'Elevator', 'icon-elevator', 4, 1, 1),
(5, '2017-12-06 09:55:08', '2017-12-13 09:28:39', 'Parking Spot', 'icon-parking-spot', 5, 1, 1),
(6, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Fireplace', 'icon-fireplace', 6, 1, 0),
(7, '2017-12-06 09:55:08', '2017-12-13 09:28:39', 'Air Conditioning', 'icon-air-conditioning', 7, 1, 2),
(8, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Doorman', 'icon-doorman', 8, 1, 0),
(9, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Dishwasher', 'icon-dishwasher', 9, 1, 0),
(10, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Deck', 'icon-deck', 10, 1, 0),
(11, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'Storage', 'icon-storage', 11, 1, 1),
(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-13 09:28:39', '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, 1),
(15, '2017-12-06 09:55:08', '2017-12-13 09:28:39', 'Balcony', 'icon-balcony', 15, 1, 1),
(16, '2017-12-06 09:55:08', '2017-12-06 09:55:08', 'Furnished', 'icon-furnished', 16, 1, 0),
(17, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'View', 'icon-view', 17, 1, 1),
(18, '2017-12-06 09:55:08', '2017-12-13 08:54:14', 'Student Friendly', 'icon-student', 18, 1, 1),
(19, '2017-12-06 09:55:08', '2017-12-13 09:28:39', '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
(4, '2017-12-13 08:54:14', '2017-12-13 08:54:14', 11, 1),
(7, '2017-12-13 08:54:14', '2017-12-13 08:54:14', 18, 1),
(8, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 1, 2),
(9, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 3, 2),
(10, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 5, 2),
(11, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 7, 2),
(12, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 13, 2),
(13, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 15, 2),
(14, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 19, 2);

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

--
-- 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
) 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`) VALUES
(1, '2017-12-13 09:06:20', '2017-12-13 09:09:17', 1, 2, '1300.00', '2018-05-01', 'Neo Note', 36, '', 0, 55, 45, NULL),
(2, '2017-12-13 09:07:49', '2017-12-13 09:09:17', 1, 3, '1400.00', '2018-01-03', 'Ema note', 38, 'Lanlord Ema Note', 42, 50, 45, NULL),
(3, '2017-12-13 09:33:31', '2017-12-13 09:38:44', 2, 2, '18000.00', '2017-12-31', 'First Note', 38, '', 0, 49, 45, NULL),
(4, '2017-12-13 09:36:48', '2017-12-13 09:38:44', 2, 3, '19000.00', '2018-01-03', 'Second Note', 40, '', 0, 51, 45, NULL);

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

--
-- 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-13 08:54:14', '2017-12-13 08:54:14', 1, 1, 'media/landlord/1/Image_31762.jpg'),
(2, '2017-12-13 08:54:14', '2017-12-13 08:54:14', 1, 1, 'media/landlord/1/Image_32739.jpg'),
(3, '2017-12-13 08:54:14', '2017-12-13 08:54:14', 1, 1, 'media/landlord/1/Image_19936.jpg'),
(4, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 1, 2, 'media/landlord/1/Image_16518.jpg'),
(5, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 1, 2, 'media/landlord/1/Image_32071.jpg'),
(6, '2017-12-13 09:28:39', '2017-12-13 09:28:39', 1, 2, 'media/landlord/1/Image_10612.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);

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

--
-- 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
('34dd9601-0206-4524-a82f-d4cdee7b9495', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"2\",\"message\":\"Someone made a bid against your property Vatika\"}', NULL, '2017-12-13 09:36:48', '2017-12-13 09:36:48'),
('50f6d2f4-bd5d-4bbe-b446-cd6b84375adf', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"2\",\"message\":\"Someone made a bid against your property Vatika\"}', NULL, '2017-12-13 09:33:31', '2017-12-13 09:33:31'),
('7cdfd9fd-0c51-4905-9805-b20834009620', '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-13 09:37:12', '2017-12-13 09:37:12'),
('938ee2b7-ae2f-42a3-a2a0-0c37e5581580', '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\"}', NULL, '2017-12-13 09:09:17', '2017-12-13 09:09:17'),
('9795eb43-f0a4-484e-b6bb-37867b3a20a0', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":1,\"message\":\"The tenant has opt-out from the bid\"}', NULL, '2017-12-13 09:12:05', '2017-12-13 09:12:05'),
('a725699b-19c6-4913-abde-e5fc44aaec04', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":4,\"property_id\":2,\"message\":\"Bidder has paid the commision fees against property Vatika\"}', NULL, '2017-12-13 09:38:44', '2017-12-13 09:38:44'),
('c7bbbfd5-f9f0-4719-965c-06d50ed6ff40', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"1\",\"message\":\"Someone made a bid against your property Estate Valley\"}', NULL, '2017-12-13 09:06:20', '2017-12-13 09:06:20'),
('eb11b36b-517f-4323-a6b2-9ca02b03fa27', 'App\\Notifications\\PostNewNotification', 1, 'App\\Models\\User', '{\"bid_id\":\"\",\"property_id\":\"1\",\"message\":\"Someone made a bid against your property Estate Valley\"}', NULL, '2017-12-13 09:07:49', '2017-12-13 09:07:49');

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

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

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

--
-- 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'
) 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`) VALUES
(1, '2017-12-13 08:54:14', '2017-12-13 09:12:04', 'Estate Valley', 'Emirates Towers - Trade Centre - Dubai', 1101, '1600', '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 propert.', '25.21588041970849', '55.27852501970847', 1500.00, 500.00, 2000.00, '', '2018-01-01', 3, 8, 13, 20, 30, 1, 2, 1, 0),
(2, '2017-12-13 09:28:39', '2017-12-13 09:38:44', 'Vatika', 'Maliha Road - Sharjah', 123, '2200', '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\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam dictum vitae quam at laoreet. Donec metus magna imperdiet nec enim.', '25.2691086197085', '55.48052571970857', 20000.00, 5000.00, 25000.00, '', '2017-12-25', 6, 11, 13, 20, 30, 1, 4, 5, 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-12-13 09:38:22', 'Active', 11),
(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-13 09:38:44', 'Closed', 2);

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

--
-- 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-13 08:51:38', '2017-12-13 08:51:38', 1, '971501234567', 'Please use 601718 as OTP for verifying your mobile number', 32911205),
(2, '2017-12-13 08:58:15', '2017-12-13 08:58:15', 2, '971501234567', 'Please use 316677 as OTP for verifying your mobile number', 32911386),
(3, '2017-12-13 08:59:12', '2017-12-13 08:59:12', 3, '971501234567', 'Please use 463427 as OTP for verifying your mobile number', 32911411);

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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` bigint(20) NOT NULL,
  `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-13 09:37:42', '2017-12-13 09:38:22', 2, '190.00', 'Telr', 3, 0, 3, 4, NULL, NULL, NULL);

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

--
-- 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-12-13 15:52:08', '2017-12-13 14:38:34', 1, '2017-12-13 14:38:34', '2017-12-13 14:26:09'),
(2, '2017-12-13 15:59:35', '2017-12-13 15:09:49', 2, '2017-12-13 15:09:49', '2017-12-13 15:03:39'),
(3, '2017-12-13 16:07:02', '2017-12-13 15:09:37', 3, '2017-12-13 15:03:53', '2017-12-13 15:09:37');

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

--
-- 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-13 08:52:41', 'Property Owner', 1),
(3, '2017-11-27 03:26:11', '2017-12-13 08:59:11', '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 `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 `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=15;
--
-- 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=5;
--
-- 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=95;
--
-- AUTO_INCREMENT for table `payment_statuses`
--
ALTER TABLE `payment_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 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=3;
--
-- 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=4;
--
-- AUTO_INCREMENT for table `supports`
--
ALTER TABLE `supports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 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;
