Linux localhost 5.4.0-198-generic #218-Ubuntu SMP Fri Sep 27 20:18:53 UTC 2024 x86_64
Apache/2.4.41 (Ubuntu)
: 23.92.16.63 | : 162.158.154.156
Cant Read [ /etc/named.conf ]
8.1.5
www-data
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
var /
www /
realestate /
[ HOME SHELL ]
Name
Size
Permission
Action
.git
[ DIR ]
drwxr-xr-x
source
[ DIR ]
drwxr-xr-x
.gitignore
624
B
-rwxr-xr-x
.htaccess
10.47
KB
-rwxr-xr-x
index.php
7.53
KB
-rwxr-xr-x
laravel.sql
22.36
KB
-rwxr-xr-x
realestate.sql
65.24
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : realestate.sql
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 25, 2025 at 12:14 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `realestate` -- -- -------------------------------------------------------- -- -- Table structure for table `alert_methods` -- CREATE TABLE `alert_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `phone` tinyint(1) NOT NULL DEFAULT 0, `email` tinyint(1) NOT NULL DEFAULT 0, `sms` tinyint(1) NOT NULL DEFAULT 0, `post` tinyint(1) NOT NULL DEFAULT 0, `directory_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `applicants` -- CREATE TABLE `applicants` ( `id` bigint(20) UNSIGNED NOT NULL, `guarantor_name` varchar(255) DEFAULT NULL, `guarantor_contact` varchar(255) DEFAULT NULL, `guarantor_email` varchar(255) DEFAULT NULL, `guarantor_fax` varchar(255) DEFAULT NULL, `guarantor_dob` date DEFAULT NULL, `guarantor_website` varchar(255) DEFAULT NULL, `guarantor_pager` varchar(255) DEFAULT NULL, `guarantor_birth_place` varchar(255) DEFAULT NULL, `guarantor_nationality` varchar(255) DEFAULT NULL, `guarantor_passport_no` varchar(255) DEFAULT NULL, `guarantor_gender` varchar(255) DEFAULT NULL, `lettingswp` varchar(255) DEFAULT NULL, `lettingpw_minimum` varchar(10) DEFAULT NULL, `lettingpw_maximum` varchar(10) DEFAULT NULL, `lettingpw_threshold` varchar(10) DEFAULT NULL, `furniture` varchar(255) DEFAULT NULL, `lha_dwp` varchar(255) DEFAULT NULL, `tenancy_period` varchar(255) DEFAULT NULL, `employment_status` varchar(255) DEFAULT NULL, `employment_type` varchar(255) DEFAULT NULL, `income` varchar(10) DEFAULT NULL, `income_frequency` varchar(255) DEFAULT NULL, `smoking` tinyint(1) DEFAULT NULL, `pets` tinyint(1) DEFAULT NULL, `occupiertype` varchar(255) DEFAULT NULL, `sales_check` tinyint(1) DEFAULT NULL, `sales_minimum` varchar(10) DEFAULT NULL, `sales_maximum` varchar(10) DEFAULT NULL, `sales_threshold` varchar(10) DEFAULT NULL, `mortgage` tinyint(1) DEFAULT NULL, `mortgage_status` varchar(255) DEFAULT NULL, `lander` varchar(255) DEFAULT NULL, `deposit_amount` varchar(10) DEFAULT NULL, `able_dependant_on_sale` tinyint(1) DEFAULT NULL, `first_time_buyer` tinyint(1) DEFAULT NULL, `lease_expiry_date` date DEFAULT NULL, `nothing_to_sell` tinyint(1) DEFAULT NULL, `investor` tinyint(1) DEFAULT NULL, `additional_investment` tinyint(1) DEFAULT NULL, `underoffer` tinyint(1) DEFAULT NULL, `under_offer_price` varchar(10) DEFAULT NULL, `chain` tinyint(1) DEFAULT NULL, `chain_note` text DEFAULT NULL, `property_to_sell` tinyint(1) DEFAULT NULL, `property_type` varchar(255) DEFAULT NULL, `anticipated_sale_price` varchar(10) DEFAULT NULL, `any_advice` text DEFAULT NULL, `property_to_market` tinyint(1) DEFAULT NULL, `property_markeat_type` varchar(255) DEFAULT NULL, `how_long` varchar(255) DEFAULT NULL, `price_on_market` varchar(10) DEFAULT NULL, `interest` varchar(255) DEFAULT NULL, `agent` varchar(255) DEFAULT NULL, `contract_term` varchar(255) DEFAULT NULL, `why_choose` text DEFAULT NULL, `buyertype` varchar(255) DEFAULT NULL, `property_types` varchar(255) DEFAULT NULL, `min_beds` varchar(255) DEFAULT NULL, `max_beds` varchar(255) DEFAULT NULL, `min_baths` varchar(255) DEFAULT NULL, `max_baths` varchar(255) DEFAULT NULL, `parking` varchar(255) DEFAULT NULL, `min_space` varchar(255) DEFAULT NULL, `max_space` varchar(255) DEFAULT NULL, `min_land` varchar(255) DEFAULT NULL, `max_land` varchar(255) DEFAULT NULL, `build_year_start` varchar(255) DEFAULT NULL, `build_year_end` varchar(255) DEFAULT NULL, `special_feature` text DEFAULT NULL, `property_required_by` date DEFAULT NULL, `bym_status` varchar(255) DEFAULT NULL, `notify_property_alerts` tinyint(1) DEFAULT NULL, `notify_general_news` tinyint(1) DEFAULT NULL, `notify_special_offers` tinyint(1) DEFAULT NULL, `notify_phone` tinyint(1) DEFAULT NULL, `notify_email` tinyint(1) DEFAULT NULL, `notify_sms` tinyint(1) DEFAULT NULL, `notify_post` tinyint(1) DEFAULT NULL, `solicitor` varchar(255) DEFAULT NULL, `label` varchar(255) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `branch_id` bigint(20) UNSIGNED DEFAULT NULL, `negotiator_id` bigint(20) UNSIGNED DEFAULT NULL, `assigned_to` bigint(20) UNSIGNED DEFAULT NULL, `lead_source` varchar(255) DEFAULT NULL, `comments` text DEFAULT NULL, `other_info` text DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `category_ids` varchar(255) DEFAULT NULL, `area` text DEFAULT NULL, `user_account_type` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `applicants` -- INSERT INTO `applicants` (`id`, `guarantor_name`, `guarantor_contact`, `guarantor_email`, `guarantor_fax`, `guarantor_dob`, `guarantor_website`, `guarantor_pager`, `guarantor_birth_place`, `guarantor_nationality`, `guarantor_passport_no`, `guarantor_gender`, `lettingswp`, `lettingpw_minimum`, `lettingpw_maximum`, `lettingpw_threshold`, `furniture`, `lha_dwp`, `tenancy_period`, `employment_status`, `employment_type`, `income`, `income_frequency`, `smoking`, `pets`, `occupiertype`, `sales_check`, `sales_minimum`, `sales_maximum`, `sales_threshold`, `mortgage`, `mortgage_status`, `lander`, `deposit_amount`, `able_dependant_on_sale`, `first_time_buyer`, `lease_expiry_date`, `nothing_to_sell`, `investor`, `additional_investment`, `underoffer`, `under_offer_price`, `chain`, `chain_note`, `property_to_sell`, `property_type`, `anticipated_sale_price`, `any_advice`, `property_to_market`, `property_markeat_type`, `how_long`, `price_on_market`, `interest`, `agent`, `contract_term`, `why_choose`, `buyertype`, `property_types`, `min_beds`, `max_beds`, `min_baths`, `max_baths`, `parking`, `min_space`, `max_space`, `min_land`, `max_land`, `build_year_start`, `build_year_end`, `special_feature`, `property_required_by`, `bym_status`, `notify_property_alerts`, `notify_general_news`, `notify_special_offers`, `notify_phone`, `notify_email`, `notify_sms`, `notify_post`, `solicitor`, `label`, `status`, `branch_id`, `negotiator_id`, `assigned_to`, `lead_source`, `comments`, `other_info`, `username`, `password`, `created_at`, `updated_at`, `category_ids`, `area`, `user_account_type`) VALUES (16, 'Guarantor name', '42343', 'talhwa@oxo.com', '333333', '2025-02-26', NULL, 'Pager', NULL, 'Nationality', 'Passport no', '1', 'on', '1', '2', '2', '3', '2', NULL, '1', '1', '33', '1', 1, 1, NULL, 1, '3', '4', '3', 1, '1', 'Talha', '223', 2, 1, '2025-02-27', 1, 1, 1, 1, '32', 1, 'Enter Chain Details', 1, 'Property type', '3333', 'dasdsadsadsad', 1, 'Property type', '1', '333', '2e32', 'sdasd', 'dasdsa', NULL, NULL, '1', '1', '2', '4', '20', '9', '300', '950', '500', '2022', '1111', '222', '2,3', '2025-02-27', '2', NULL, 1, 1, 1, 1, 1, 1, 'Usman', '1', '1', 1, 1, 1, '4', 'Comments', 'Other Info', NULL, '123', '2025-02-25 04:59:18', '2025-02-25 06:01:03', '2,3', 'Enter the areas applicant is interested in, you can enter multiple areas separated by commas. Leave blank for all areas.', 'new_account'); -- -------------------------------------------------------- -- -- Table structure for table `applicant_files` -- CREATE TABLE `applicant_files` ( `id` bigint(20) UNSIGNED NOT NULL, `file_name` varchar(255) NOT NULL, `applicant_id` bigint(20) UNSIGNED NOT 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 `applicant_files` -- INSERT INTO `applicant_files` (`id`, `file_name`, `applicant_id`, `created_at`, `updated_at`) VALUES (3, '1740481263_washington_birthday.webp', 16, '2025-02-25 06:01:03', '2025-02-25 06:01:03'); -- -------------------------------------------------------- -- -- Table structure for table `applicant_user_details` -- CREATE TABLE `applicant_user_details` ( `id` bigint(20) UNSIGNED NOT NULL, `last_name` varchar(255) DEFAULT NULL, `salutation` varchar(255) DEFAULT NULL, `postcode` varchar(255) DEFAULT NULL, `addresslineone` varchar(255) DEFAULT NULL, `addresslinetwo` varchar(255) DEFAULT NULL, `town` varchar(255) DEFAULT NULL, `county` varchar(255) DEFAULT NULL, `country` varchar(255) DEFAULT NULL, `phonehome` varchar(255) DEFAULT NULL, `phonework` varchar(255) DEFAULT NULL, `phonemobile` varchar(255) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `company` varchar(255) DEFAULT NULL, `applicant_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `first_name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `applicant_user_details` -- INSERT INTO `applicant_user_details` (`id`, `last_name`, `salutation`, `postcode`, `addresslineone`, `addresslinetwo`, `town`, `county`, `country`, `phonehome`, `phonework`, `phonemobile`, `fax`, `email`, `company`, `applicant_id`, `created_at`, `updated_at`, `first_name`, `title`) VALUES (9, 'Talha', '3', '54000', 'old anarkali', 'Address Line 2', 'Lahore', 'County', '81', '5485787645', '343432', '343434', '32432', 'talhacr5ww47@gmail.com', 'e', 16, '2025-02-25 04:59:18', '2025-02-25 04:59:18', 'Muhammad', '3'), (10, 'Last Name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '23321', '43223', '2423423', '234324', 'aqqvc@oxo.com', 'e', 16, '2025-02-25 04:59:18', '2025-02-25 06:01:03', 'First Name', '2'); -- -------------------------------------------------------- -- -- Table structure for table `branches` -- CREATE TABLE `branches` ( `id` bigint(20) UNSIGNED NOT NULL, `dashboard_notice` varchar(255) DEFAULT NULL, `company_name` varchar(255) NOT NULL, `trading_name` varchar(255) DEFAULT NULL, `branch_code` varchar(255) DEFAULT NULL, `branch_address` text NOT NULL, `branch_manager` varchar(255) DEFAULT NULL, `telephone` varchar(255) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `website` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `branch` varchar(255) DEFAULT NULL, `color` varchar(255) DEFAULT NULL, `reg_no` varchar(255) DEFAULT NULL, `vat_no` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `header` varchar(255) DEFAULT NULL, `header_continuation` varchar(255) DEFAULT NULL, `footer` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `account_title` varchar(255) DEFAULT NULL, `sortcode` varchar(255) DEFAULT NULL, `account_number` varchar(255) DEFAULT NULL, `new_property_alert` varchar(255) DEFAULT NULL, `property_price_change_alert` varchar(255) DEFAULT NULL, `property_rent_change_alert` varchar(255) DEFAULT NULL, `property_status_change_alert` varchar(255) DEFAULT NULL, `property_let_alert` varchar(255) DEFAULT NULL, `property_sale_alert` varchar(255) DEFAULT NULL, `receive_website_property_enquiries` varchar(255) DEFAULT NULL, `landlords_bank_details` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `tenant_user` varchar(255) DEFAULT NULL, `tenant_password` varchar(255) DEFAULT NULL, `tenant_branch` varchar(255) DEFAULT NULL, `affiliate_id` varchar(255) DEFAULT NULL, `mysql_id` varchar(255) DEFAULT NULL, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `client_email` varchar(255) DEFAULT NULL, `let_alliance_url` varchar(255) DEFAULT NULL, `let_alliance_agent_code` varchar(255) DEFAULT NULL, `let_alliance_user_id` varchar(255) DEFAULT NULL, `client_integration_key` varchar(255) DEFAULT NULL, `veri_check_url` varchar(255) DEFAULT NULL, `veri_check_guid` varchar(255) DEFAULT NULL, `veri_check_password` varchar(255) DEFAULT NULL, `veri_check_branch_id` varchar(255) DEFAULT NULL, `veri_check_tenancy_branch_phone` varchar(255) DEFAULT NULL, `vorensys_user` varchar(255) DEFAULT NULL, `vorensys_password` varchar(255) DEFAULT NULL, `vorensys_customer_id` varchar(255) DEFAULT NULL, `integrator_public_key` varchar(255) DEFAULT NULL, `integrator_private_key` varchar(255) DEFAULT NULL, `tenant_shop_key` varchar(255) DEFAULT NULL, `tenant_shop_password` varchar(255) DEFAULT NULL, `home_shift_key` varchar(255) DEFAULT NULL, `home_shift_password` varchar(255) DEFAULT NULL, `subdomain` varchar(255) DEFAULT NULL, `fixflo_token` varchar(255) DEFAULT NULL, `fixflo_last_update` timestamp NULL DEFAULT NULL, `brief_your_market_username` varchar(255) DEFAULT NULL, `brief_your_market_password` varchar(255) DEFAULT NULL, `listing_and_selling_commission_split` varchar(8) 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 `branches` -- INSERT INTO `branches` (`id`, `dashboard_notice`, `company_name`, `trading_name`, `branch_code`, `branch_address`, `branch_manager`, `telephone`, `fax`, `website`, `email`, `branch`, `color`, `reg_no`, `vat_no`, `logo`, `header`, `header_continuation`, `footer`, `bank_name`, `account_title`, `sortcode`, `account_number`, `new_property_alert`, `property_price_change_alert`, `property_rent_change_alert`, `property_status_change_alert`, `property_let_alert`, `property_sale_alert`, `receive_website_property_enquiries`, `landlords_bank_details`, `url`, `tenant_user`, `tenant_password`, `tenant_branch`, `affiliate_id`, `mysql_id`, `first_name`, `last_name`, `phone`, `client_email`, `let_alliance_url`, `let_alliance_agent_code`, `let_alliance_user_id`, `client_integration_key`, `veri_check_url`, `veri_check_guid`, `veri_check_password`, `veri_check_branch_id`, `veri_check_tenancy_branch_phone`, `vorensys_user`, `vorensys_password`, `vorensys_customer_id`, `integrator_public_key`, `integrator_private_key`, `tenant_shop_key`, `tenant_shop_password`, `home_shift_key`, `home_shift_password`, `subdomain`, `fixflo_token`, `fixflo_last_update`, `brief_your_market_username`, `brief_your_market_password`, `listing_and_selling_commission_split`, `created_at`, `updated_at`) VALUES (1, 'Dashboard Notice', 'Company Name', 'Trading Name', 'Branch Code', 'old anarkali', 'Branch Manager', '5485787645', 'Fax', 'http://localhost/realestate/admin/branches/create', 'talhacr547@gmail.com', 'Branch', 'Branch Color', 'Branch Registration No', 'Branch VAT No', 'branch_logos/1739863735_washington_birthday.webp', 'Branch Header', 'Header Continuation', 'Footer', 'Bank Name', 'Account Title', 'Sortcode', 'Account Number', 'New Property Alert', 'Property Price Change Alert', 'Property Rent Change Alert', 'Property Status Change Alert', 'Property Let Alert', 'Property Sale Alert', 'Receive Website Property Enquiries', 'Landlords Bank Details', 'https://oxopackaging.com/', 'Tenant User', 'Tenant Password', 'Tenant User', 'Affiliate ID', 'MySQL ID', 'Muhammad', 'Talha', '321566888', 'avc@oxo.com', 'Let Alliance URL', 'Let Alliance Agent Code', 'Let Alliance User ID', 'Client Integration Key', 'Veri-Check URL', 'Veri-Check GUID', 'Veri-Check Password', 'Veri-Check Branch ID', '5485787645', 'Vorensys User', 'Vorensys Password', 'Vorensys Customer ID', 'Integrator Public Key', 'Integrator Private Key', 'Tenant Shop Key', 'Tenant Shop Password', 'Home Shift Key', 'Home Shift Password', 'Subdomain', 'Fixflo Token', '2025-02-18 07:28:00', 'Brief Your Market Username', 'Brief Your Market Password', '12321', '2025-02-18 02:28:55', '2025-02-18 02:28:55'); -- -------------------------------------------------------- -- -- Table structure for table `buy_types` -- CREATE TABLE `buy_types` ( `id` bigint(20) UNSIGNED NOT NULL, `type` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `order_no` int(11) 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 `buy_types` -- INSERT INTO `buy_types` (`id`, `type`, `status`, `order_no`, `created_at`, `updated_at`) VALUES (1, 'National House Builder', 1, 1, '2025-02-20 03:20:54', '2025-02-20 03:20:54'), (2, 'Commercial developer', 1, 2, '2025-02-20 03:21:14', '2025-02-20 03:21:14'), (3, 'Residential developer', 1, 3, '2025-02-20 03:21:27', '2025-02-20 03:21:27'), (4, 'Ground rent buyer', 1, 3, '2025-02-20 03:21:39', '2025-02-20 03:21:39'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `status` enum('1','2') NOT NULL DEFAULT '1', `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 `categories` -- INSERT INTO `categories` (`id`, `name`, `type`, `status`, `created_at`, `updated_at`) VALUES (1, 'Lander', '2', '1', '2025-02-18 02:22:03', '2025-02-18 02:22:03'), (2, 'Commercial', '1', '1', '2025-02-18 02:22:03', '2025-02-18 02:22:03'), (3, 'New Build', '1', '1', '2025-02-18 02:22:03', '2025-02-18 02:22:03'), (4, 'Solicitor', '2', '1', '2025-02-18 02:22:03', '2025-02-18 02:22:03'); -- -------------------------------------------------------- -- -- Table structure for table `category_property_type` -- CREATE TABLE `category_property_type` ( `id` bigint(20) UNSIGNED NOT NULL, `property_type_id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category_property_type` -- INSERT INTO `category_property_type` (`id`, `property_type_id`, `category_id`) VALUES (1, 1, 2), (2, 1, 3), (3, 2, 2); -- -------------------------------------------------------- -- -- Table structure for table `countries` -- CREATE TABLE `countries` ( `id` int(11) NOT NULL, `country_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `countries` -- INSERT INTO `countries` (`id`, `country_name`) VALUES (1, 'Zimbabwe'), (2, 'Zambia'), (3, 'Yugoslavia'), (4, 'Yemen'), (5, 'Western Sahara'), (6, 'Wallis And Futuna Islands'), (7, 'Virgin Islands (US)'), (8, 'Virgin Islands (British)'), (9, 'Vietnam'), (10, 'Venezuela'), (11, 'Vatican City State (Holy See)'), (12, 'Vanuatu'), (13, 'Uzbekistan'), (14, 'Uruguay'), (15, 'United States Minor Outlying Islands'), (16, 'United States'), (17, 'United Kingdom'), (18, 'United Arab Emirates'), (19, 'Ukraine'), (20, 'Uganda'), (21, 'Tuvalu'), (22, 'Turks And Caicos Islands'), (23, 'Turkmenistan'), (24, 'Turkey'), (25, 'Tunisia'), (26, 'Trinidad And Tobago'), (27, 'Tonga'), (28, 'Tokelau'), (29, 'Togo'), (30, 'Thailand'), (31, 'Tanzania'), (32, 'Tajikistan'), (33, 'Taiwan'), (34, 'Syria'), (35, 'Switzerland'), (36, 'Sweden'), (37, 'Swaziland'), (38, 'Svalbard And Jan Mayen Islands'), (39, 'Suriname'), (40, 'Sudan'), (41, 'Sri Lanka'), (42, 'Spain'), (43, 'South Sudan'), (44, 'South Georgia'), (45, 'South Africa'), (46, 'Somalia'), (47, 'Solomon Islands'), (48, 'Smaller Territories of the UK'), (49, 'Slovenia'), (50, 'Slovakia'), (51, 'Singapore'), (52, 'Sierra Leone'), (53, 'Seychelles'), (54, 'Serbia'), (55, 'Senegal'), (56, 'Saudi Arabia'), (57, 'Sao Tome and Principe'), (58, 'San Marino'), (59, 'Samoa'), (60, 'Saint Vincent And The Grenadines'), (61, 'Saint Pierre and Miquelon'), (62, 'Saint Lucia'), (63, 'Saint Kitts And Nevis'), (64, 'Saint Helena'), (65, 'Rwanda'), (66, 'Russia'), (67, 'Romania'), (68, 'Reunion'), (69, 'Qatar'), (70, 'Puerto Rico'), (71, 'Portugal'), (72, 'Poland'), (73, 'Pitcairn Island'), (74, 'Philippines'), (75, 'Peru'), (76, 'Paraguay'), (77, 'Papua new Guinea'), (78, 'Panama'), (79, 'Palestinian Territory Occupied'), (80, 'Palau'), (81, 'Pakistan'), (82, 'Oman'), (83, 'Norway'), (84, 'Northern Mariana Islands'), (85, 'Norfolk Island'), (86, 'Niue'), (87, 'Nigeria'), (88, 'Niger'), (89, 'Nicaragua'), (90, 'New Zealand'), (91, 'New Caledonia'), (92, 'Netherlands The'), (93, 'Netherlands Antilles'), (94, 'Nepal'), (95, 'Nauru'), (96, 'Namibia'), (97, 'Myanmar'), (98, 'Mozambique'), (99, 'Morocco'), (100, 'Montserrat'), (101, 'Mongolia'), (102, 'Monaco'), (103, 'Moldova'), (104, 'Micronesia'), (105, 'Mexico'), (106, 'Mayotte'), (107, 'Mauritius'), (108, 'Mauritania'), (109, 'Martinique'), (110, 'Marshall Islands'), (111, 'Man (Isle of)'), (112, 'Malta'), (113, 'Mali'), (114, 'Maldives'), (115, 'Malaysia'), (116, 'Malawi'), (117, 'Madagascar'), (118, 'Macedonia'), (119, 'Macau S.A.R.'), (120, 'Luxembourg'), (121, 'Lithuania'), (122, 'Liechtenstein'), (123, 'Libya'), (124, 'Liberia'), (125, 'Lesotho'), (126, 'Lebanon'), (127, 'Latvia'), (128, 'Laos'), (129, 'Kyrgyzstan'), (130, 'Kuwait'), (131, 'Korea South'), (132, 'Korea North'), (133, 'Kiribati'), (134, 'Kenya'), (135, 'Kazakhstan'), (136, 'Jordan'), (137, 'Jersey'), (138, 'Japan'), (139, 'Jamaica'), (140, 'Italy'), (141, 'Israel'), (142, 'Ireland'), (143, 'Iraq'), (144, 'Iran'), (145, 'Indonesia'), (146, 'India'), (147, 'Iceland'), (148, 'Hungary'), (149, 'Hong Kong S.A.R.'), (150, 'Honduras'), (151, 'Heard and McDonald Islands'), (152, 'Haiti'), (153, 'Guyana'), (154, 'Guinea-Bissau'), (155, 'Guinea'), (156, 'Guernsey and Alderney'), (157, 'Guatemala'), (158, 'Guam'), (159, 'Guadeloupe'), (160, 'Grenada'), (161, 'Greenland'), (162, 'Greece'), (163, 'Gibraltar'), (164, 'Ghana'), (165, 'Germany'), (166, 'Georgia'), (167, 'Gambia The'), (168, 'Gabon'), (169, 'French Southern Territories'), (170, 'French Polynesia'), (171, 'French Guiana'), (172, 'France'), (173, 'Finland'), (174, 'Fiji Islands'), (175, 'Faroe Islands'), (176, 'Falkland Islands'), (177, 'External Territories of Australia'), (178, 'Ethiopia'), (179, 'Estonia'), (180, 'Eritrea'), (181, 'Equatorial Guinea'), (182, 'El Salvador'), (183, 'Egypt'), (184, 'Ecuador'), (185, 'East Timor'), (186, 'Dominican Republic'), (187, 'Dominica'), (188, 'Djibouti'), (189, 'Denmark'), (190, 'Czech Republic'), (191, 'Cyprus'), (192, 'Cuba'), (193, 'Croatia (Hrvatska)'), (194, 'Cote DIvoire (Ivory Coast)'), (195, 'Costa Rica'), (196, 'Cook Islands'), (197, 'Congo The Democratic Republic Of The'), (198, 'Congo'), (199, 'Comoros'), (200, 'Colombia'), (201, 'Cocos (Keeling) Islands'), (202, 'Christmas Island'), (203, 'China'), (204, 'Chile'), (205, 'Chad'), (206, 'Central African Republic'), (207, 'Cayman Islands'), (208, 'Cape Verde'), (209, 'Canada'), (210, 'Cameroon'), (211, 'Cambodia'), (212, 'Burundi'), (213, 'Burkina Faso'), (214, 'Bulgaria'), (215, 'Brunei'), (216, 'British Indian Ocean Territory'), (217, 'Brazil'), (218, 'Bouvet Island'), (219, 'Botswana'), (220, 'Bosnia and Herzegovina'), (221, 'Bolivia'), (222, 'Bhutan'), (223, 'Bermuda'), (224, 'Benin'), (225, 'Belize'), (226, 'Belgium'), (227, 'Belarus'), (228, 'Barbados'), (229, 'Bangladesh'), (230, 'Bahrain'), (231, 'Bahamas The'), (232, 'Azerbaijan'), (233, 'Austria'), (234, 'Australia'), (235, 'Aruba'), (236, 'Armenia'), (237, 'Argentina'), (238, 'Antigua And Barbuda'), (239, 'Antarctica'), (240, 'Anguilla'), (241, 'Angola'), (242, 'Andorra'), (243, 'American Samoa'), (244, 'Algeria'), (245, 'Albania'), (246, 'Afghanistan'); -- -------------------------------------------------------- -- -- Table structure for table `directories` -- CREATE TABLE `directories` ( `id` bigint(20) UNSIGNED NOT NULL, `category` varchar(255) DEFAULT NULL, `company` varchar(255) DEFAULT NULL, `telephone` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `web_address` varchar(255) DEFAULT NULL, `dx` varchar(255) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `branch` varchar(255) DEFAULT NULL, `comments` text DEFAULT NULL, `other_info` text DEFAULT NULL, `subscription` tinyint(1) NOT NULL DEFAULT 0, `bank_body` varchar(255) DEFAULT NULL, `account_no` varchar(255) DEFAULT NULL, `sort_code` varchar(255) DEFAULT NULL, `account_name` varchar(255) DEFAULT NULL, `beneficiary_reference` varchar(255) DEFAULT NULL, `address_line_1` varchar(255) DEFAULT NULL, `address_line_2` varchar(255) DEFAULT NULL, `town` varchar(255) DEFAULT NULL, `county` varchar(255) DEFAULT NULL, `postcode` varchar(255) DEFAULT NULL, `country` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `bank_branch_address_line_1` varchar(255) DEFAULT NULL, `bank_branch_address_line_2` varchar(255) DEFAULT NULL, `bank_town` varchar(255) DEFAULT NULL, `bank_county` varchar(255) DEFAULT NULL, `bank_country` varchar(255) DEFAULT NULL, `notify_post` tinyint(1) NOT NULL DEFAULT 0, `notify_phone` tinyint(1) NOT NULL DEFAULT 0, `notify_sms` tinyint(1) NOT NULL DEFAULT 0, `notify_email` tinyint(1) NOT NULL DEFAULT 0, `notify_property_alerts` tinyint(1) NOT NULL DEFAULT 0, `notify_general_news` tinyint(1) NOT NULL DEFAULT 0, `notify_special_offers` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `directories` -- INSERT INTO `directories` (`id`, `category`, `company`, `telephone`, `mobile`, `email`, `web_address`, `dx`, `fax`, `branch`, `comments`, `other_info`, `subscription`, `bank_body`, `account_no`, `sort_code`, `account_name`, `beneficiary_reference`, `address_line_1`, `address_line_2`, `town`, `county`, `postcode`, `country`, `created_at`, `updated_at`, `bank_branch_address_line_1`, `bank_branch_address_line_2`, `bank_town`, `bank_county`, `bank_country`, `notify_post`, `notify_phone`, `notify_sms`, `notify_email`, `notify_property_alerts`, `notify_general_news`, `notify_special_offers`) VALUES (9, '1', 'Noah', '12321300', '2423423000', 'talha00@oxo.com', 'old anarkali000', '2321323000', '00000', '1', 'Comments', 'Other Info', 0, 'Bank body', 'Account no', 'Sort code', 'Account name', 'Beneficiary reference', '000old anarkali', '00Address line 2', 'Town000', 'County', '540000000', '15', '2025-02-18 08:20:53', '2025-02-19 05:08:20', 'bank Address Line 1', 'bank Address Line 2', 'Bank Town', 'bank county', '1', 0, 0, 0, 0, 0, 0, 0), (10, '4', 'OXO', '12321300', '2423423000', 'talha00@oxo.com', 'old anarkali000', '2321323000', '00000', '1', 'Comments', 'Other Info', 0, 'Bank body', 'Account no', 'Sort code', 'Account name', 'Beneficiary reference', '000old anarkali', '00Address line 2', 'Town000', 'County', '540000000', '15', '2025-02-18 08:20:53', '2025-02-19 05:08:20', 'bank Address Line 1', 'bank Address Line 2', 'Bank Town', 'bank county', '1', 0, 0, 0, 0, 0, 0, 0), (11, '4', 'OXO', '5485787645', '5485787645', 'talhacr547@gmail.com', 'old anarkali', '234324', '234324', '1', 'rerewr', 'rewrewr', 0, 'sd', '2344324', '22', 'sfsdfsd', 'fdsfsdf', 'old anarkali', '23423432', '234324', '34324', '54000', '14', '2025-02-21 05:50:51', '2025-02-21 05:50:51', 'sdfdsfa', 'dsfdsf', 'Lahore', 'Punjab', '81', 0, 0, 0, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `directory_addresses` -- CREATE TABLE `directory_addresses` ( `id` bigint(20) UNSIGNED NOT NULL, `full_name` varchar(255) DEFAULT NULL, `phone_work` varchar(255) DEFAULT NULL, `phone_mobile` varchar(255) DEFAULT NULL, `phone_home` varchar(255) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `directory_id` bigint(20) UNSIGNED NOT 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 `directory_addresses` -- INSERT INTO `directory_addresses` (`id`, `full_name`, `phone_work`, `phone_mobile`, `phone_home`, `fax`, `email`, `directory_id`, `created_at`, `updated_at`) VALUES (37, 'Talha', '5485787645', '321566888', '321566888', '45435435', 't', 9, '2025-02-19 05:32:30', '2025-02-19 05:32:30'), (38, 'Ali', '5485787645', '321566888', '321566888', '45435435', 'a', 9, '2025-02-19 05:32:30', '2025-02-19 05:32:30'), (39, 'Umer', '5485787645', '321566888', '321566888', '45435435', 'l', 9, '2025-02-19 05:32:30', '2025-02-19 05:32:30'), (40, 'Usman', '434324', '23434', '234324', '324324', 't', 11, '2025-02-21 05:50:51', '2025-02-21 05:50:51'), (41, 'Kashif', '434324', '23434', '234324', '324324', 'a', 11, '2025-02-21 05:50:51', '2025-02-21 05:50:51'); -- -------------------------------------------------------- -- -- Table structure for table `directory_attachments` -- CREATE TABLE `directory_attachments` ( `id` bigint(20) UNSIGNED NOT NULL, `directory_attachment` varchar(255) NOT NULL, `directory_id` bigint(20) UNSIGNED NOT 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 `directory_attachments` -- INSERT INTO `directory_attachments` (`id`, `directory_attachment`, `directory_id`, `created_at`, `updated_at`) VALUES (25, '1739961150_TCB-Banner.webp', 9, '2025-02-19 05:32:30', '2025-02-19 05:32:30'), (26, '1739961150_banner.webp', 9, '2025-02-19 05:32:30', '2025-02-19 05:32:30'), (27, '1739961150_banner-122.webp.webp', 9, '2025-02-19 05:32:30', '2025-02-19 05:32:30'), (28, '1740135051_washington_birthday.webp', 11, '2025-02-21 05:50:51', '2025-02-21 05:50:51'); -- -------------------------------------------------------- -- -- Table structure for table `directory_custom_fields` -- CREATE TABLE `directory_custom_fields` ( `id` bigint(20) UNSIGNED NOT NULL, `field_name` varchar(255) NOT NULL, `field_value` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `labels` -- CREATE TABLE `labels` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `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 `labels` -- INSERT INTO `labels` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 'None', 1, '2025-02-21 08:28:35', '2025-02-21 08:28:35'), (2, 'Nill', 1, '2025-02-21 08:29:24', '2025-02-24 00:31:26'); -- -------------------------------------------------------- -- -- Table structure for table `lettingspw` -- CREATE TABLE `lettingspw` ( `id` bigint(20) UNSIGNED NOT NULL, `amount` varchar(255) DEFAULT NULL, `threshold` varchar(255) DEFAULT NULL, `type` varchar(255) 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 `lettingspw` -- INSERT INTO `lettingspw` (`id`, `amount`, `threshold`, `type`, `created_at`, `updated_at`) VALUES (1, '50000', '10%', '1', '2025-02-24 03:05:27', '2025-02-24 03:05:27'), (2, '184000', '10%', '1', '2025-02-24 03:05:32', '2025-02-24 03:05:32'), (3, '50000', '10%', '2', '2025-02-24 03:05:27', '2025-02-24 03:05:27'), (4, '184000', '10%', '2', '2025-02-24 03:05:32', '2025-02-24 03:05:32'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) 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 (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_reset_tokens_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2024_12_23_100203_create_permission_tables', 1), (6, '2024_12_31_061725_first_name_last_name_password_to_users', 2), (7, '2024_12_31_085634_add_deleted_at_to_users_table', 3), (8, '2024_12_31_100140_create_modules_table', 4), (9, '2025_01_07_083133_create_countries_table', 5), (10, '2025_01_08_102330_create_lettingspw_table', 6), (11, '2025_01_13_103603_create_occupier_types_table', 6), (12, '2025_01_13_121529_create_buy_types_table', 6), (13, '2025_01_14_100039_add_type_to_table_name', 6), (14, '2025_01_15_054644_create_categories_table', 6), (15, '2025_01_15_074718_create_branches_table', 6), (16, '2025_01_16_063647_create_directories_table', 6), (17, '2025_01_16_064513_create_directory_addresses_table', 6), (18, '2025_01_16_065245_create_property_alerts_table', 6), (19, '2025_01_16_065543_create_alert_methods_table', 6), (20, '2025_01_16_065858_create_directory_attachments_table', 6), (21, '2025_01_16_101710_create_directory_custom_fields_table', 6), (22, '2025_01_16_120021_add_branch_address_to_branches_table', 6), (23, '2025_02_18_104826_add_notify_post_notify_email_notify_phone_notify_sms_notify_special_offers_notify_general_news_notify_property_alerts_to_directories_table', 7), (26, '2025_02_20_105210_create_property_types_table', 8), (27, '2025_02_20_105244_create_category_property_type_table', 8), (28, '2025_02_21_063006_create_special_features_table', 9), (29, '2025_02_21_125824_create_labels_table', 10), (30, '2025_02_24_073634_create_applicants_table', 11), (31, '2025_02_24_074439_create_applicant_user_details_table', 11), (32, '2025_02_24_074801_create_applicant_files_table', 11), (33, '2025_02_24_094819_add_notify_post_notify_email_notify_phone_notify_sms_notify_special_offers_notify_general_news_notify_property_alerts_to_applicant_table', 12), (34, '2025_02_24_123622_add_notify_post_notify_email_notify_phone_notify_sms_notify_special_offers_notify_general_news_notify_property_alerts_to_applicant_user_details_table', 13), (35, '2025_02_24_125926_add_notify_post_notify_email_notify_phone_notify_sms_notify_special_offers_notify_general_news_notify_lettingswp_check_property_alerts_to_applicant_table', 14), (39, '2025_02_25_072347_add_area_add_account_type_user_to_applicant_table', 15); -- -------------------------------------------------------- -- -- Table structure for table `model_has_permissions` -- CREATE TABLE `model_has_permissions` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `model_has_roles` -- CREATE TABLE `model_has_roles` ( `role_id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `model_has_roles` -- INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1, 'App\\Models\\User', 8), (2, 'App\\Models\\User', 4), (2, 'App\\Models\\User', 5), (2, 'App\\Models\\User', 6), (2, 'App\\Models\\User', 7), (2, 'App\\Models\\User', 9), (2, 'App\\Models\\User', 10), (3, 'App\\Models\\User', 1), (3, 'App\\Models\\User', 3); -- -------------------------------------------------------- -- -- Table structure for table `modules` -- CREATE TABLE `modules` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `unique_name` varchar(191) DEFAULT NULL, `order_no` int(11) DEFAULT NULL, `view` enum('yes','no') NOT NULL DEFAULT 'no', `create` enum('yes','no') NOT NULL DEFAULT 'no', `edit` enum('yes','no') NOT NULL DEFAULT 'no', `delete` enum('yes','no') NOT NULL DEFAULT 'no', `view_owned` enum('yes','no') NOT NULL DEFAULT 'no', `edit_owned` enum('yes','no') NOT NULL DEFAULT 'no', `delete_owned` enum('yes','no') NOT NULL DEFAULT 'no', `import` enum('yes','no') NOT NULL DEFAULT 'no', `export` enum('yes','no') NOT NULL DEFAULT 'no', `status` enum('active','in-active') NOT NULL DEFAULT 'in-active', `default` enum('yes','no') NOT NULL DEFAULT 'no', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `modules` -- INSERT INTO `modules` (`id`, `name`, `unique_name`, `order_no`, `view`, `create`, `edit`, `delete`, `view_owned`, `edit_owned`, `delete_owned`, `import`, `export`, `status`, `default`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Dashboard', 'admin-dashboard', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2024-12-31 05:35:57', '2024-12-31 05:35:57', NULL), (3, 'User', 'users', 2, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2024-12-31 08:08:11', '2024-12-31 08:08:11', NULL), (4, 'Roles', 'roles', 3, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2024-12-31 08:08:34', '2024-12-31 08:08:34', NULL), (5, 'Modules', 'modules', 4, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2024-12-31 08:21:03', '2024-12-31 08:21:03', NULL), (6, 'Applicants', 'applicants', 5, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-01-06 01:37:44', '2025-01-06 01:37:44', NULL), (7, 'lettingspw', 'lettingspw', 7, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-17 02:32:24', '2025-02-17 02:32:24', NULL), (8, 'Occupier Type', 'occupier_type', 6, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-17 02:33:19', '2025-02-17 02:33:19', NULL), (9, 'Buy Types', 'buy_types', 8, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-17 02:33:57', '2025-02-17 02:33:57', NULL), (10, 'Category', 'category', 9, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-17 02:34:25', '2025-02-17 02:34:25', NULL), (11, 'Branch', 'branch', 10, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-17 02:35:15', '2025-02-17 02:35:15', NULL), (12, 'Directory', 'directory', 11, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-17 02:40:02', '2025-02-17 02:40:02', NULL), (13, 'Property Type', 'property_type', 13, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-20 06:39:51', '2025-02-20 06:39:51', NULL), (14, 'Special Feature', 'special_feature', 14, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-21 01:50:29', '2025-02-21 01:50:29', NULL), (15, 'Label', 'label', 15, 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'active', 'no', '2025-02-21 08:11:55', '2025-02-21 08:11:55', NULL); -- -------------------------------------------------------- -- -- Table structure for table `occupier_types` -- CREATE TABLE `occupier_types` ( `id` bigint(20) UNSIGNED NOT NULL, `type` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `order_no` int(11) 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 `occupier_types` -- INSERT INTO `occupier_types` (`id`, `type`, `status`, `order_no`, `created_at`, `updated_at`) VALUES (1, '1', 1, 1, '2025-02-21 02:38:08', '2025-02-21 02:38:44'); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `guard_name` varchar(255) NOT 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 `permissions` -- INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1, 'view users', 'web', '2024-12-23 05:18:01', '2024-12-23 05:18:01'), (2, 'edit users', 'web', '2024-12-23 05:18:01', '2024-12-23 05:18:01'), (3, 'delete users', 'web', '2024-12-23 05:18:01', '2024-12-23 05:18:01'), (4, 'manage roles', 'web', '2024-12-23 05:18:01', '2024-12-23 05:18:01'), (5, 'enable_admin-dashboard', 'web', '2024-12-31 07:31:51', '2024-12-31 07:31:51'), (6, 'view_admin-dashboard', 'web', '2024-12-31 07:31:51', '2024-12-31 07:31:51'), (7, 'enable_users', 'web', '2024-12-31 08:23:03', '2024-12-31 08:23:03'), (8, 'delete_users', 'web', '2024-12-31 08:23:03', '2024-12-31 08:23:03'), (9, 'enable_roles', 'web', '2024-12-31 08:23:03', '2024-12-31 08:23:03'), (10, 'delete_roles', 'web', '2024-12-31 08:23:03', '2024-12-31 08:23:03'), (11, 'enable_modules', 'web', '2024-12-31 08:23:03', '2024-12-31 08:23:03'), (12, 'delete_modules', 'web', '2024-12-31 08:23:03', '2024-12-31 08:23:03'), (13, 'create_users', 'web', '2024-12-31 08:24:36', '2024-12-31 08:24:36'), (14, 'edit_users', 'web', '2024-12-31 08:24:36', '2024-12-31 08:24:36'), (15, 'create_roles', 'web', '2024-12-31 08:24:36', '2024-12-31 08:24:36'), (16, 'edit_roles', 'web', '2024-12-31 08:24:36', '2024-12-31 08:24:36'), (17, 'create_modules', 'web', '2024-12-31 08:24:36', '2024-12-31 08:24:36'), (18, 'edit_modules', 'web', '2024-12-31 08:24:36', '2024-12-31 08:24:36'), (19, 'view_users', 'web', '2024-12-31 08:28:57', '2024-12-31 08:28:57'), (20, 'view_roles', 'web', '2024-12-31 08:28:57', '2024-12-31 08:28:57'), (21, 'view_modules', 'web', '2024-12-31 08:28:57', '2024-12-31 08:28:57'), (22, 'enable_applicants', 'web', '2025-01-06 01:38:16', '2025-01-06 01:38:16'), (23, 'view_applicants', 'web', '2025-01-06 01:38:16', '2025-01-06 01:38:16'), (24, 'create_applicants', 'web', '2025-01-06 01:38:16', '2025-01-06 01:38:16'), (25, 'edit_applicants', 'web', '2025-01-06 01:38:16', '2025-01-06 01:38:16'), (26, 'delete_applicants', 'web', '2025-01-06 01:38:16', '2025-01-06 01:38:16'), (27, 'enable_lettingspw', 'web', '2025-02-17 02:36:23', '2025-02-17 02:36:23'), (28, 'view_lettingspw', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (29, 'create_lettingspw', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (30, 'edit_lettingspw', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (31, 'delete_lettingspw', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (32, 'enable_occupier_type', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (33, 'view_occupier_type', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (34, 'create_occupier_type', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (35, 'edit_occupier_type', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (36, 'delete_occupier_type', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (37, 'enable_buy_types', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (38, 'view_buy_types', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (39, 'create_buy_types', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (40, 'edit_buy_types', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (41, 'delete_buy_types', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (42, 'enable_category', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (43, 'view_category', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (44, 'create_category', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (45, 'edit_category', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (46, 'delete_category', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (47, 'enable_branch', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (48, 'view_branch', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (49, 'create_branch', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (50, 'edit_branch', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (51, 'delete_branch', 'web', '2025-02-17 02:36:24', '2025-02-17 02:36:24'), (52, 'enable_directory', 'web', '2025-02-17 02:42:03', '2025-02-17 02:42:03'), (53, 'view_directory', 'web', '2025-02-17 02:42:03', '2025-02-17 02:42:03'), (54, 'create_directory', 'web', '2025-02-17 02:42:03', '2025-02-17 02:42:03'), (55, 'edit_directory', 'web', '2025-02-17 02:42:03', '2025-02-17 02:42:03'), (56, 'delete_directory', 'web', '2025-02-17 02:42:03', '2025-02-17 02:42:03'), (57, 'enable_property_type', 'web', '2025-02-20 06:40:15', '2025-02-20 06:40:15'), (58, 'view_property_type', 'web', '2025-02-20 06:40:15', '2025-02-20 06:40:15'), (59, 'create_property_type', 'web', '2025-02-20 06:40:15', '2025-02-20 06:40:15'), (60, 'edit_property_type', 'web', '2025-02-20 06:40:15', '2025-02-20 06:40:15'), (61, 'delete_property_type', 'web', '2025-02-20 06:40:15', '2025-02-20 06:40:15'), (62, 'enable_special_feature', 'web', '2025-02-21 01:54:27', '2025-02-21 01:54:27'), (63, 'view_special_feature', 'web', '2025-02-21 01:54:27', '2025-02-21 01:54:27'), (64, 'create_special_feature', 'web', '2025-02-21 01:54:27', '2025-02-21 01:54:27'), (65, 'edit_special_feature', 'web', '2025-02-21 01:54:27', '2025-02-21 01:54:27'), (66, 'delete_special_feature', 'web', '2025-02-21 01:54:27', '2025-02-21 01:54:27'), (67, 'enable_label', 'web', '2025-02-21 08:14:40', '2025-02-21 08:14:40'), (68, 'view_label', 'web', '2025-02-21 08:14:40', '2025-02-21 08:14:40'), (69, 'create_label', 'web', '2025-02-21 08:14:40', '2025-02-21 08:14:40'), (70, 'edit_label', 'web', '2025-02-21 08:14:40', '2025-02-21 08:14:40'), (71, 'delete_label', 'web', '2025-02-21 08:14:40', '2025-02-21 08:14:40'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_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; -- -------------------------------------------------------- -- -- Table structure for table `property_alerts` -- CREATE TABLE `property_alerts` ( `id` bigint(20) UNSIGNED NOT NULL, `property_alerts` tinyint(1) NOT NULL DEFAULT 0, `general_news` tinyint(1) NOT NULL DEFAULT 0, `special_offers` tinyint(1) NOT NULL DEFAULT 0, `directory_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `property_types` -- CREATE TABLE `property_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT 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 `property_types` -- INSERT INTO `property_types` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'Detached', '2025-02-20 07:26:02', '2025-02-20 07:26:02'), (2, 'House', '2025-02-20 07:37:35', '2025-02-20 07:37:35'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `guard_name` varchar(255) NOT 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 `roles` -- INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'web', '2024-12-23 05:18:01', '2024-12-23 05:18:01'), (2, 'Editor', 'web', '2024-12-23 05:18:01', '2024-12-23 05:18:01'), (3, 'superadmin', 'web', '2024-12-23 05:41:29', '2024-12-23 05:41:29'); -- -------------------------------------------------------- -- -- Table structure for table `role_has_permissions` -- CREATE TABLE `role_has_permissions` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `role_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `role_has_permissions` -- INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES (1, 1), (1, 2), (2, 1), (3, 1), (4, 1), (5, 3), (6, 3), (7, 3), (8, 3), (9, 3), (10, 3), (11, 3), (12, 3), (13, 3), (14, 3), (15, 3), (16, 3), (17, 3), (18, 3), (19, 3), (20, 3), (21, 3), (22, 3), (23, 3), (24, 3), (25, 3), (26, 3), (27, 3), (28, 3), (29, 3), (30, 3), (31, 3), (32, 3), (33, 3), (34, 3), (35, 3), (36, 3), (37, 3), (38, 3), (39, 3), (40, 3), (41, 3), (42, 3), (43, 3), (44, 3), (45, 3), (46, 3), (47, 3), (48, 3), (49, 3), (50, 3), (51, 3), (52, 3), (53, 3), (54, 3), (55, 3), (56, 3), (57, 3), (58, 3), (59, 3), (60, 3), (61, 3), (62, 3), (63, 3), (64, 3), (65, 3), (66, 3), (67, 3), (68, 3), (69, 3), (70, 3), (71, 3); -- -------------------------------------------------------- -- -- Table structure for table `special_features` -- CREATE TABLE `special_features` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `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 `special_features` -- INSERT INTO `special_features` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 'Driveway', 1, '2025-02-21 02:16:11', '2025-02-21 02:16:11'), (2, 'Drivewayss', 1, '2025-02-21 02:16:43', '2025-02-21 02:16:43'), (3, 'Driveway', 1, '2025-02-21 02:17:27', '2025-02-21 02:17:27'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `first_name`, `last_name`, `phone`, `deleted_at`) VALUES (1, 'Tobin Sanford', 'admin@gmail.com', '2024-12-23 05:28:28', '$2y$12$w.FujVOosryXX1tT3KiJEe36OSfCzs.H3Sunk8PFB0PfFlvKCYmXW', 'GllNg5Wi29KpThIJtc2AAc22uiZRF530iEvmfpUnIBs1l7f7A7NmtJIc9EPI', '2024-12-23 05:28:28', '2024-12-31 08:27:34', 'User', 'One', '1234567890', NULL), (2, 'Prof. Ethan Stanton PhD', 'ojast@example.org', '2024-12-23 05:55:45', '$2y$12$w.FujVOosryXX1tT3KiJEe36OSfCzs.H3Sunk8PFB0PfFlvKCYmXW', 'hYDjorYO3N', '2024-12-23 05:55:45', '2024-12-31 03:58:38', NULL, NULL, NULL, '2024-12-31 03:58:38'), (3, 'Muhammad Talha', 'talha@gmail.com', NULL, '$2y$12$Q.GMx0j0x/cnBc0Ub679cuM2OdCG1PCksTOs29YYrKMw4K58fpiCe', NULL, '2024-12-31 01:52:39', '2024-12-31 03:59:30', 'Muhammad', 'Talha', '5485787645', NULL), (4, 'Muhammad Talha', 'admins@gmail.com', NULL, '$2y$12$p/jNMfs63kn1Z.kgzEeLFeMATZ3iesRyv5SvYsK65Zo3cUworKWLW', NULL, '2024-12-31 01:53:57', '2024-12-31 03:59:33', 'Muhammad', 'Talha', '54857876453', '2024-12-31 03:59:33'), (5, 'Talha Talha', 'adwmin@gmail.com', NULL, '$2y$12$LwlmWDQN5NvmdWJ8DBex1.J3t2EP6FCrlu5NHctbl1fNhhe1EaNcC', NULL, '2024-12-31 02:09:46', '2024-12-31 03:59:36', 'Muhammad', 'Talha', '324324324334', '2024-12-31 03:59:36'), (6, 'Talha Talha', 'admewin@gmail.com', NULL, '$2y$12$tXTahiyB4wQgg/M6vGM2fuQlNPqs5ma3MehIlL2GJdxLgXYDDJwWq', NULL, '2024-12-31 02:10:56', '2024-12-31 03:59:41', 'Muhammad', 'Talha', '54853376453', '2024-12-31 03:59:41'), (7, 'Talha Talha', 'admin21@gmail.com', NULL, '$2y$12$n9kOxjZGzgIJJcpTmI/DwuTmz/lSSradhEHTotYvxG3LQlUWZQFYi', NULL, '2024-12-31 02:12:06', '2024-12-31 03:59:43', 'Muhammad', 'Talha', '5412787645', '2024-12-31 03:59:43'), (8, 'Talha Talha', 'admi2n@gmail.com', NULL, '$2y$12$J/pE4zGRnaTqcK2fO2DZeOvj1hY/D.a.Jq.Urpb8fOlXI6DEUjcFa', NULL, '2024-12-31 02:12:59', '2024-12-31 03:59:46', 'Muhammad', 'Talha', '54857872412', '2024-12-31 03:59:46'), (9, 'Talha Talha', 'wadmin@gmail.com', NULL, '$2y$12$6DUa5E/oYV844LbFu3kC1uRmoy.VynZXWZVgTWSYajopP5cibGmAq', NULL, '2024-12-31 02:13:39', '2024-12-31 03:59:48', 'Muhammad', 'Talha', '3232787645', '2024-12-31 03:59:48'), (10, 'Talha Talha', 'adminSS@gmail.com', NULL, '$2y$12$/hbFbw4YI6WDBWcB/C2EXuWaAYuPgyY.WLJdb7TCpjOS4jRRauHhy', NULL, '2024-12-31 02:18:25', '2024-12-31 03:59:50', 'Muhammad', 'Talha', '5485787123', '2024-12-31 03:59:50'); -- -- Indexes for dumped tables -- -- -- Indexes for table `alert_methods` -- ALTER TABLE `alert_methods` ADD PRIMARY KEY (`id`), ADD KEY `alert_methods_directory_id_foreign` (`directory_id`); -- -- Indexes for table `applicants` -- ALTER TABLE `applicants` ADD PRIMARY KEY (`id`), ADD KEY `applicants_branch_id_foreign` (`branch_id`), ADD KEY `applicants_negotiator_id_foreign` (`negotiator_id`), ADD KEY `applicants_assigned_to_foreign` (`assigned_to`); -- -- Indexes for table `applicant_files` -- ALTER TABLE `applicant_files` ADD PRIMARY KEY (`id`), ADD KEY `applicant_files_applicant_id_foreign` (`applicant_id`); -- -- Indexes for table `applicant_user_details` -- ALTER TABLE `applicant_user_details` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `applicant_user_details_email_unique` (`email`), ADD KEY `applicant_user_details_applicant_id_foreign` (`applicant_id`); -- -- Indexes for table `branches` -- ALTER TABLE `branches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `buy_types` -- ALTER TABLE `buy_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category_property_type` -- ALTER TABLE `category_property_type` ADD PRIMARY KEY (`id`), ADD KEY `category_property_type_property_type_id_foreign` (`property_type_id`), ADD KEY `category_property_type_category_id_foreign` (`category_id`); -- -- Indexes for table `countries` -- ALTER TABLE `countries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `directories` -- ALTER TABLE `directories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `directory_addresses` -- ALTER TABLE `directory_addresses` ADD PRIMARY KEY (`id`), ADD KEY `directory_addresses_directory_id_foreign` (`directory_id`); -- -- Indexes for table `directory_attachments` -- ALTER TABLE `directory_attachments` ADD PRIMARY KEY (`id`), ADD KEY `directory_attachments_directory_id_foreign` (`directory_id`); -- -- Indexes for table `directory_custom_fields` -- ALTER TABLE `directory_custom_fields` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `labels` -- ALTER TABLE `labels` ADD PRIMARY KEY (`id`); -- -- Indexes for table `lettingspw` -- ALTER TABLE `lettingspw` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`), ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`), ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `modules` -- ALTER TABLE `modules` ADD PRIMARY KEY (`id`); -- -- Indexes for table `occupier_types` -- ALTER TABLE `occupier_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `property_alerts` -- ALTER TABLE `property_alerts` ADD PRIMARY KEY (`id`), ADD KEY `property_alerts_directory_id_foreign` (`directory_id`); -- -- Indexes for table `property_types` -- ALTER TABLE `property_types` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `property_types_name_unique` (`name`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `role_has_permissions_role_id_foreign` (`role_id`); -- -- Indexes for table `special_features` -- ALTER TABLE `special_features` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `alert_methods` -- ALTER TABLE `alert_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `applicants` -- ALTER TABLE `applicants` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `applicant_files` -- ALTER TABLE `applicant_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `applicant_user_details` -- ALTER TABLE `applicant_user_details` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `branches` -- ALTER TABLE `branches` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `buy_types` -- ALTER TABLE `buy_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `category_property_type` -- ALTER TABLE `category_property_type` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `countries` -- ALTER TABLE `countries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247; -- -- AUTO_INCREMENT for table `directories` -- ALTER TABLE `directories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `directory_addresses` -- ALTER TABLE `directory_addresses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT for table `directory_attachments` -- ALTER TABLE `directory_attachments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `directory_custom_fields` -- ALTER TABLE `directory_custom_fields` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `labels` -- ALTER TABLE `labels` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `lettingspw` -- ALTER TABLE `lettingspw` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40; -- -- AUTO_INCREMENT for table `modules` -- ALTER TABLE `modules` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `occupier_types` -- ALTER TABLE `occupier_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `property_alerts` -- ALTER TABLE `property_alerts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `property_types` -- ALTER TABLE `property_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `special_features` -- ALTER TABLE `special_features` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- Constraints for dumped tables -- -- -- Constraints for table `alert_methods` -- ALTER TABLE `alert_methods` ADD CONSTRAINT `alert_methods_directory_id_foreign` FOREIGN KEY (`directory_id`) REFERENCES `directories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `applicants` -- ALTER TABLE `applicants` ADD CONSTRAINT `applicants_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `applicants_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `applicants_negotiator_id_foreign` FOREIGN KEY (`negotiator_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `applicant_files` -- ALTER TABLE `applicant_files` ADD CONSTRAINT `applicant_files_applicant_id_foreign` FOREIGN KEY (`applicant_id`) REFERENCES `applicants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `applicant_user_details` -- ALTER TABLE `applicant_user_details` ADD CONSTRAINT `applicant_user_details_applicant_id_foreign` FOREIGN KEY (`applicant_id`) REFERENCES `applicants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `category_property_type` -- ALTER TABLE `category_property_type` ADD CONSTRAINT `category_property_type_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `category_property_type_property_type_id_foreign` FOREIGN KEY (`property_type_id`) REFERENCES `property_types` (`id`) ON DELETE CASCADE; -- -- Constraints for table `directory_addresses` -- ALTER TABLE `directory_addresses` ADD CONSTRAINT `directory_addresses_directory_id_foreign` FOREIGN KEY (`directory_id`) REFERENCES `directories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `directory_attachments` -- ALTER TABLE `directory_attachments` ADD CONSTRAINT `directory_attachments_directory_id_foreign` FOREIGN KEY (`directory_id`) REFERENCES `directories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `property_alerts` -- ALTER TABLE `property_alerts` ADD CONSTRAINT `property_alerts_directory_id_foreign` FOREIGN KEY (`directory_id`) REFERENCES `directories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Close
