service guru

Error Error

Call to undefined function shell_exec()

GET servicegurunew.mydemotech.in

PHP 8.2.30 — Laravel 11.30.0

38 vendor frames collapsed

6 vendor frames collapsed

36 vendor frames collapsed

database/migrations/2024_11_13_031530_alter_helpdesk_notification_template_table.php :168

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :475

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :400

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :409

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :212

vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php :40

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :736

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :212

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :179

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :122

vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php :116

vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php :615

vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php :109

vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php :88

vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php :36

vendor/laravel/framework/src/Illuminate/Container/Util.php :43

vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php :95

vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php :35

vendor/laravel/framework/src/Illuminate/Container/Container.php :690

vendor/laravel/framework/src/Illuminate/Console/Command.php :213

vendor/symfony/console/Command/Command.php :279

vendor/laravel/framework/src/Illuminate/Console/Command.php :182

vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php :67

vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php :28

vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/FreshCommand.php :82

vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php :36

vendor/laravel/framework/src/Illuminate/Container/Util.php :43

vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php :95

vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php :35

vendor/laravel/framework/src/Illuminate/Container/Container.php :690

vendor/laravel/framework/src/Illuminate/Console/Command.php :213

vendor/symfony/console/Command/Command.php :279

vendor/laravel/framework/src/Illuminate/Console/Command.php :182

vendor/symfony/console/Application.php :1047

vendor/symfony/console/Application.php :316

vendor/symfony/console/Application.php :167

vendor/laravel/framework/src/Illuminate/Console/Application.php :163

vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php :426

vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php :358

app/Helper/Installer/DatabaseManager.php :54

app/Helper/Installer/DatabaseManager.php :24

app/Http/Controllers/Installer/DatabaseController.php :30

vendor/laravel/framework/src/Illuminate/Routing/Controller.php :54

vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php :43

vendor/laravel/framework/src/Illuminate/Routing/Route.php :264

vendor/laravel/framework/src/Illuminate/Routing/Route.php :210

vendor/laravel/framework/src/Illuminate/Routing/Router.php :808

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :144

app/Http/Middleware/LanguageTranslator.php :13

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php :51

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php :88

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php :49

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :121

vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :64

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php :37

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php :75

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :119

vendor/laravel/framework/src/Illuminate/Routing/Router.php :807

vendor/laravel/framework/src/Illuminate/Routing/Router.php :786

vendor/laravel/framework/src/Illuminate/Routing/Router.php :750

vendor/laravel/framework/src/Illuminate/Routing/Router.php :739

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :201

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :144

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php :31

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php :51

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php :27

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php :110

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php :58

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :119

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :176

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :145

public/index.php :51

server.php :21

Request

GET /install/database

Headers

host

servicegurunew.mydemotech.in

accept-encoding

gzip, br, zstd, deflate

user-agent

Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

*/*

Body

No body data

Application

Routing

controller

App\Http\Controllers\Installer\DatabaseController@database

route name

database

middleware

web

Database Queries only the first 100 queries are displayed

mysql (7.97 ms)

select exists (select 1 from information_schema.tables where table_schema = 'mydemotec_servicegurunew' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`

mysql (14.6 ms)

select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'mydemotec_servicegurunew' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name

mysql (0.98 ms)

SET FOREIGN_KEY_CHECKS=0;

mysql (300.03 ms)

drop table `app_downloads`,`app_settings`,`banks`,`blogs`,`bookings`,`booking_activities`,`booking_address_mappings`,`booking_coupon_mappings`,`booking_extra_charges`,`booking_handyman_mappings`,`booking_package_mappings`,`booking_ratings`,`booking_service_addon_mapping`,`booking_statuses`,`categories`,`cities`,`commission_earnings`,`constants`,`countries`,`coupons`,`coupon_service_mappings`,`documents`,`failed_jobs`,`frontend_settings`,`handyman_payouts`,`handyman_ratings`,`handyman_types`,`help_desk`,`help_desk_activity_mapping`,`live_locations`,`mail_templates`,`mail_template_content_mappings`,`media`,`migrations`,`model_has_permissions`,`model_has_roles`,`notifications`,`notification_templates`,`notification_template_content_mapping`,`package_service_mappings`,`password_resets`,`payments`,`payment_gateways`,`payment_histories`,`permissions`,`personal_access_tokens`,`plans`,`plan_limits`,`post_job_bids`,`post_job_requests`,`post_job_service_mappings`,`post_request_statuses`,`provider_address_mappings`,`provider_documents`,`provider_payouts`,`provider_service_address_mappings`,`provider_slot_mappings`,`provider_subscriptions`,`provider_taxes`,`provider_types`,`roles`,`role_has_permissions`,`services`,`service_addons`,`service_faqs`,`service_packages`,`service_proofs`,`settings`,`sliders`,`states`,`static_data`,`subscription_transactions`,`sub_categories`,`taxes`,`translations`,`users`,`user_favourite_providers`,`user_favourite_services`,`wallets`,`wallet_histories`,`withdraw_money`

mysql (1.39 ms)

SET FOREIGN_KEY_CHECKS=1;

mysql (1.1 ms)

select exists (select 1 from information_schema.tables where table_schema = 'mydemotec_servicegurunew' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`

mysql (10.45 ms)

create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(255) not null, `batch` int not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (1.36 ms)

select exists (select 1 from information_schema.tables where table_schema = 'mydemotec_servicegurunew' and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`

mysql (1.41 ms)

select `migration` from `migrations` order by `batch` asc, `migration` asc

mysql (1.01 ms)

select `migration` from `migrations` order by `batch` asc, `migration` asc

mysql (0.92 ms)

select max(`batch`) as aggregate from `migrations`

mysql (7.96 ms)

create table `users` (`id` bigint unsigned not null auto_increment primary key, `username` varchar(255) not null, `first_name` varchar(255) not null, `last_name` varchar(255) not null, `email` varchar(255) not null, `password` varchar(255) not null, `user_type` varchar(255) null, `contact_number` varchar(255) null, `country_id` bigint unsigned null, `state_id` bigint unsigned null, `city_id` bigint unsigned null, `provider_id` bigint unsigned null, `address` text null, `player_id` varchar(255) null, `status` tinyint null default '1', `display_name` varchar(255) null, `providertype_id` bigint unsigned null, `is_featured` tinyint null default '0', `time_zone` varchar(255) not null default 'UTC', `last_notification_seen` timestamp null, `email_verified_at` timestamp null, `remember_token` varchar(100) null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (13.24 ms)

alter table `users` add unique `users_username_unique`(`username`)

mysql (15.29 ms)

alter table `users` add unique `users_email_unique`(`email`)

mysql (2.07 ms)

insert into `migrations` (`migration`, `batch`) values ('2014_10_12_000000_create_users_table', 1)

mysql (5.98 ms)

create table `password_resets` (`email` varchar(255) not null, `token` varchar(255) not null, `created_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (13.03 ms)

alter table `password_resets` add index `password_resets_email_index`(`email`)

mysql (2.27 ms)

insert into `migrations` (`migration`, `batch`) values ('2014_10_12_100000_create_password_resets_table', 1)

mysql (8.8 ms)

create table `failed_jobs` (`id` bigint unsigned not null auto_increment primary key, `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) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (12.48 ms)

alter table `failed_jobs` add unique `failed_jobs_uuid_unique`(`uuid`)

mysql (1.23 ms)

insert into `migrations` (`migration`, `batch`) values ('2019_08_19_000000_create_failed_jobs_table', 1)

mysql (8.49 ms)

create table `personal_access_tokens` (`id` bigint unsigned not null auto_increment primary key, `tokenable_type` varchar(255) not null, `tokenable_id` bigint unsigned not null, `name` varchar(255) not null, `token` varchar(64) not null, `abilities` text null, `last_used_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (14.8 ms)

alter table `personal_access_tokens` add index `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type`, `tokenable_id`)

mysql (8.34 ms)

alter table `personal_access_tokens` add unique `personal_access_tokens_token_unique`(`token`)

mysql (1.12 ms)

insert into `migrations` (`migration`, `batch`) values ('2019_12_14_000001_create_personal_access_tokens_table', 1)

mysql (7.26 ms)

create table `categories` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(100) null, `description` text null, `color` varchar(100) null, `status` tinyint null default '1' comment '1- Active , 0- InActive', `is_featured` tinyint null default '0', `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2.04 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_29_065224_create_categories_table', 1)

mysql (6.29 ms)

create table `services` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) not null, `category_id` bigint unsigned not null, `provider_id` bigint unsigned not null, `price` double null default '0', `type` varchar(255) null default '1' comment 'fixed , hourly', `duration` varchar(255) null, `discount` double null comment 'in percentage', `status` tinyint null default '1', `description` text null, `is_featured` tinyint null default '0', `added_by` bigint null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (20.41 ms)

alter table `services` add constraint `services_provider_id_foreign` foreign key (`provider_id`) references `users` (`id`) on delete cascade

mysql (21.68 ms)

alter table `services` add constraint `services_category_id_foreign` foreign key (`category_id`) references `categories` (`id`) on delete cascade

mysql (1.45 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_29_070033_create_services_table', 1)

mysql (9.84 ms)

create table `bookings` (`id` bigint unsigned not null auto_increment primary key, `customer_id` bigint unsigned null, `service_id` bigint unsigned null, `provider_id` bigint unsigned null, `date` datetime null, `start_at` datetime null, `end_at` datetime null, `quantity` int null default '0', `amount` double null, `discount` double null, `total_amount` double null, `description` text null, `reason` text null, `coupon_id` bigint null, `status` varchar(255) null, `address` text null, `payment_id` bigint null, `duration_diff` varchar(255) null default '0', `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (18.18 ms)

alter table `bookings` add constraint `bookings_provider_id_foreign` foreign key (`provider_id`) references `users` (`id`) on delete cascade

mysql (21.78 ms)

alter table `bookings` add constraint `bookings_customer_id_foreign` foreign key (`customer_id`) references `users` (`id`) on delete cascade

mysql (33.23 ms)

alter table `bookings` add constraint `bookings_service_id_foreign` foreign key (`service_id`) references `services` (`id`) on delete cascade

mysql (2.67 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_29_112557_create_bookings_table', 1)

mysql (8.84 ms)

create table `media` (`id` bigint unsigned not null auto_increment primary key, `model_type` varchar(255) not null, `model_id` bigint unsigned not null, `uuid` char(36) null, `collection_name` varchar(255) not null, `name` varchar(255) not null, `file_name` varchar(255) not null, `mime_type` varchar(255) null, `disk` varchar(255) not null, `conversions_disk` varchar(255) null, `size` bigint unsigned not null, `manipulations` json not null, `custom_properties` json not null, `generated_conversions` json not null, `responsive_images` json not null, `order_column` int unsigned null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (16.23 ms)

alter table `media` add index `media_model_type_model_id_index`(`model_type`, `model_id`)

mysql (15.43 ms)

alter table `media` add unique `media_uuid_unique`(`uuid`)

mysql (1.88 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_30_055042_create_media_table', 1)

mysql (8.26 ms)

create table `countries` (`id` int unsigned not null auto_increment primary key, `code` varchar(3) not null, `name` varchar(150) not null, `dial_code` int not null, `currency_name` varchar(20) not null, `symbol` varchar(20) not null, `currency_code` varchar(20) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB

mysql (1.56 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_30_070712_create_countries_table', 1)

mysql (8.61 ms)

create table `states` (`id` int unsigned not null auto_increment primary key, `name` varchar(255) not null, `country_id` int not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB

mysql (1.43 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_30_070726_create_states_table', 1)

mysql (8.47 ms)

create table `cities` (`id` int unsigned not null auto_increment primary key, `name` varchar(255) null, `state_id` int null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB

mysql (2.16 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_30_070735_create_cities_table', 1)

mysql (8.02 ms)

create table `booking_handyman_mappings` (`id` bigint unsigned not null auto_increment primary key, `booking_id` bigint unsigned not null, `handyman_id` bigint unsigned not null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (23.81 ms)

alter table `booking_handyman_mappings` add constraint `booking_handyman_mappings_booking_id_foreign` foreign key (`booking_id`) references `bookings` (`id`) on delete cascade

mysql (24.84 ms)

alter table `booking_handyman_mappings` add constraint `booking_handyman_mappings_handyman_id_foreign` foreign key (`handyman_id`) references `users` (`id`) on delete cascade

mysql (3.28 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_05_30_095337_create_booking_handyman_mappings_table', 1)

mysql (7.7 ms)

create table `booking_ratings` (`id` bigint unsigned not null auto_increment primary key, `booking_id` bigint unsigned not null, `service_id` bigint unsigned not null, `customer_id` bigint unsigned not null, `rating` double null, `review` longtext null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (26.08 ms)

alter table `booking_ratings` add constraint `booking_ratings_service_id_foreign` foreign key (`service_id`) references `services` (`id`) on delete cascade

mysql (25.52 ms)

alter table `booking_ratings` add constraint `booking_ratings_booking_id_foreign` foreign key (`booking_id`) references `bookings` (`id`) on delete cascade

mysql (2.33 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_06_01_050736_create_booking_ratings_table', 1)

mysql (27.71 ms)

create table `permissions` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) not null, `guard_name` varchar(255) not null, `parent_id` bigint unsigned null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (17.56 ms)

create table `roles` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) not null, `guard_name` varchar(255) not null, `status` tinyint null default '1', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (15.16 ms)

create table `model_has_permissions` (`permission_id` bigint unsigned not null, `model_type` varchar(255) not null, `model_id` bigint unsigned not null, primary key (`permission_id`, `model_id`, `model_type`)) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (23.17 ms)

alter table `model_has_permissions` add index `model_has_permissions_model_id_model_type_index`(`model_id`, `model_type`)

mysql (29.39 ms)

alter table `model_has_permissions` add constraint `model_has_permissions_permission_id_foreign` foreign key (`permission_id`) references `permissions` (`id`) on delete cascade

mysql (17.13 ms)

create table `model_has_roles` (`role_id` bigint unsigned not null, `model_type` varchar(255) not null, `model_id` bigint unsigned not null, primary key (`role_id`, `model_id`, `model_type`)) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (23.78 ms)

alter table `model_has_roles` add index `model_has_roles_model_id_model_type_index`(`model_id`, `model_type`)

mysql (27.99 ms)

alter table `model_has_roles` add constraint `model_has_roles_role_id_foreign` foreign key (`role_id`) references `roles` (`id`) on delete cascade

mysql (19.4 ms)

create table `role_has_permissions` (`permission_id` bigint unsigned not null, `role_id` bigint unsigned not null, primary key (`permission_id`, `role_id`)) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (26.1 ms)

alter table `role_has_permissions` add constraint `role_has_permissions_permission_id_foreign` foreign key (`permission_id`) references `permissions` (`id`) on delete cascade

mysql (40.81 ms)

alter table `role_has_permissions` add constraint `role_has_permissions_role_id_foreign` foreign key (`role_id`) references `roles` (`id`) on delete cascade

mysql (2.17 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_06_03_052433_create_permission_tables', 1)

mysql (9.93 ms)

create table `provider_types` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) not null, `commission` double null default '0', `status` tinyint null default '1', `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2.53 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_06_10_102714_create_provider_types_table', 1)

mysql (17.08 ms)

create table `booking_coupon_mappings` (`id` bigint unsigned not null auto_increment primary key, `booking_id` bigint null, `code` varchar(255) null, `discount` double null, `discount_type` varchar(255) null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2.09 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_06_24_125715_create_booking_coupon_mappings_table', 1)

mysql (12.7 ms)

create table `booking_statuses` (`id` bigint unsigned not null auto_increment primary key, `value` varchar(255) null, `label` varchar(255) null, `status` tinyint null default '1' comment '0-inactive , 1 - active', `sequence` int null default '0', `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_06_055059_create_booking_statuses_table', 1)

mysql (8.14 ms)

create table `booking_activities` (`id` bigint unsigned not null auto_increment primary key, `booking_id` bigint null, `datetime` timestamp null, `activity_type` varchar(255) null, `activity_message` text null, `activity_data` text null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2.1 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_06_093626_create_booking_activities_table', 1)

mysql (8.94 ms)

create table `app_settings` (`id` bigint unsigned not null auto_increment primary key, `site_name` varchar(255) null, `site_email` varchar(255) null, `site_logo` varchar(255) null, `site_favicon` varchar(255) null, `site_description` longtext null, `site_copyright` varchar(255) null, `facebook_url` varchar(255) null, `instagram_url` varchar(255) null, `twitter_url` varchar(255) null, `linkedin_url` varchar(255) null, `remember_token` varchar(255) null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2.28 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_09_074735_create_app_settings_table', 1)

mysql (8.66 ms)

create table `settings` (`id` int unsigned not null auto_increment primary key, `type` varchar(255) null, `key` varchar(255) not null, `value` text null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (16.6 ms)

alter table `settings` add index `settings_key_index`(`key`)

mysql (1.71 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_09_074743_create_settings_table', 1)

mysql (7.23 ms)

create table `payments` (`id` bigint unsigned not null auto_increment primary key, `customer_id` bigint unsigned not null, `booking_id` bigint unsigned not null, `datetime` datetime null, `discount` double null default '0', `total_amount` double null default '0', `payment_type` varchar(100) not null, `txn_id` varchar(100) null, `payment_status` varchar(20) null comment 'pending, paid , failed', `other_transaction_detail` text null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (18.13 ms)

alter table `payments` add constraint `payments_customer_id_foreign` foreign key (`customer_id`) references `users` (`id`) on delete cascade

mysql (17.07 ms)

alter table `payments` add constraint `payments_booking_id_foreign` foreign key (`booking_id`) references `bookings` (`id`) on delete cascade

mysql (1.17 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_19_100454_create_payments_table', 1)

mysql (5.9 ms)

create table `notifications` (`id` char(36) not null, `type` varchar(255) not null, `notifiable_type` varchar(255) not null, `notifiable_id` bigint unsigned not null, `data` text not null, `read_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null, primary key (`id`)) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (12.92 ms)

alter table `notifications` add index `notifications_notifiable_type_notifiable_id_index`(`notifiable_type`, `notifiable_id`)

mysql (0.76 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_20_092824_create_notifications_table', 1)

mysql (5.28 ms)

create table `coupons` (`id` bigint unsigned not null auto_increment primary key, `code` varchar(255) null, `discount_type` varchar(255) null comment 'percentage,fixed', `discount` double null, `status` tinyint null, `expire_date` datetime null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (0.92 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_28_000004_create_coupons_table', 1)

mysql (8.1 ms)

create table `sliders` (`id` bigint unsigned not null auto_increment primary key, `title` varchar(255) null, `description` text null, `type` varchar(255) null comment 'service', `type_id` varchar(255) null comment 'service_id', `status` tinyint null default '1', `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (2.55 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_28_000013_create_sliders_table', 1)

mysql (7.64 ms)

create table `coupon_service_mappings` (`id` bigint unsigned not null auto_increment primary key, `coupon_id` bigint unsigned null, `service_id` bigint unsigned null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (12.91 ms)

alter table `coupon_service_mappings` add constraint `coupon_service_mappings_coupon_id_foreign` foreign key (`coupon_id`) references `coupons` (`id`) on delete cascade

mysql (13.36 ms)

alter table `coupon_service_mappings` add constraint `coupon_service_mappings_service_id_foreign` foreign key (`service_id`) references `services` (`id`) on delete cascade

mysql (0.95 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_07_28_000017_create_coupon_service_mappings_table', 1)

mysql (6.26 ms)

create table `user_favourite_services` (`id` bigint unsigned not null auto_increment primary key, `service_id` bigint unsigned not null, `user_id` bigint unsigned not null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'

mysql (11.86 ms)

alter table `user_favourite_services` add constraint `user_favourite_services_service_id_foreign` foreign key (`service_id`) references `services` (`id`) on delete cascade

mysql (15.77 ms)

alter table `user_favourite_services` add constraint `user_favourite_services_user_id_foreign` foreign key (`user_id`) references `users` (`id`) on delete cascade

mysql (1.55 ms)

insert into `migrations` (`migration`, `batch`) values ('2021_09_11_121648_create_user_favourite_services_table', 1)

mysql (6.48 ms)

alter table `app_settings` add `language_option` text null

mysql (0.99 ms)

select `id`, `language_option` from `app_settings`