// Orders Table Fields
ALTER TABLE `orders` ADD `current_currency_sub_total` INT(11) NOT NULL AFTER `total`;
ALTER TABLE `orders` ADD `current_currency_shipping_price` INT(11) NOT NULL AFTER `current_currency_sub_total`;
ALTER TABLE `orders` ADD `current_currency_value` INT(11) NOT NULL AFTER `current_currency_shipping_price`;


ALTER TABLE `orders` ADD `is_coupon_applied` INT(2) NULL AFTER `shipping_price`, ADD `coupon_code` VARCHAR(191) NULL AFTER `is_coupon_applied`, ADD `coupon_amount` INT(11) NULL AFTER `coupon_code`, ADD `coupon_id` INT(11) NULL AFTER `coupon_amount`;

ALTER TABLE `addresses` ADD `phone` VARCHAR(30) NULL AFTER `customer_id`;
ALTER TABLE `riders` ADD `user_id` INT(11) NULL AFTER `vendor_id`;
ALTER TABLE `order_statuses` CHANGE `updated_at` `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE `order_statuses` ADD `status_code` INT(11) NULL AFTER `description`;
ALTER TABLE `orders` ADD `rider_id` INT(11) NULL AFTER `coupon_id`;

ALTER TABLE `reviews` CHANGE `review_status_id` `review_status_id` BIGINT(20) NULL;

DROP TABLE IF EXISTS `wallets`;
CREATE TABLE IF NOT EXISTS `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_table_id` bigint(20) UNSIGNED NOT NULL,
  `balance` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `wallets_id_unique` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `wallet_transactions`;
CREATE TABLE IF NOT EXISTS `wallet_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(11) NOT NULL,
  `transaction_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `credit_amount` int(11) DEFAULT NULL,
  `debit_amount` int(11) DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `wallet_transactions_id_unique` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `fcm_tokens`;
CREATE TABLE IF NOT EXISTS `fcm_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `device_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_fcm_tokens_user_id_foreign` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=831 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `fcm_tokens` ADD `user_type` VARCHAR(191) NOT NULL AFTER `user_id`;
ALTER TABLE `wallet_transactions` CHANGE `transaction_id` `transaction_id` VARCHAR(100) NOT NULL;

ALTER TABLE `wallet_transactions` CHANGE `credit_amount` `deposit_amount` INT(11) NULL DEFAULT NULL;
ALTER TABLE `wallet_transactions` CHANGE `debit_amount` `withdraw_amount` INT(11) NULL DEFAULT NULL;

ALTER TABLE `orders` CHANGE `transaction_id` `transaction_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
INSERT INTO `payment_methods` (`id`, `name`, `description`, `image_id`, `is_active`, `is_default`, `code`, `created_at`, `updated_at`) VALUES ('8', '{\"en\":\"Wallet\",\"es\":\"Wallet\",\"sr\":\"Wallet\"}', '{\"en\":\"<p>Wallet<\\/p>\",\"es\":\"<p>Wallet<\\/p>\",\"sr\":\"<p>Wallet<\\/p>\"}', '55', '1', '0', 'payment_wallet', '2021-07-09 18:22:50', '2021-07-09 21:22:50')
ALTER TABLE `riders` CHANGE `image_id` `profile_image_path` VARCHAR(191) NULL DEFAULT NULL;
ALTER TABLE `riders` CHANGE `profile_image_path` `profile_image_path` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `customers` ADD `google_id` VARCHAR(100) NULL AFTER `is_active`;
ALTER TABLE `customers` ADD `facebook_id` VARCHAR(100) NULL AFTER `google_id`;
ALTER TABLE `vendors` ADD `google_id` VARCHAR(100) NULL AFTER `is_active`, ADD `facebook_id` VARCHAR(100) NULL AFTER `google_id`;
ALTER TABLE `wallet_transactions` CHANGE `deposit_amount` `cash_in` INT(11) NULL DEFAULT NULL, CHANGE `withdraw_amount` `cash_out` INT(11) NULL DEFAULT NULL;
ALTER TABLE `riders` ADD `store_type` VARCHAR(191) NOT NULL AFTER `is_active`;
ALTER TABLE `wallet_transactions` ADD `order_number` VARCHAR(191) NOT NULL AFTER `wallet_id`;
ALTER TABLE `reviews` ADD `order_id` INT(11) NOT NULL AFTER `product_id`;
ALTER TABLE `reviews` CHANGE `order_id` `order_id` INT(11) NULL;
ALTER TABLE `wallet_transactions` CHANGE `order_number` `order_number` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
ALTER TABLE `customers` CHANGE `first_name` `first_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, CHANGE `last_name` `last_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
ALTER TABLE `orders` ADD `order_status_reason` VARCHAR(191) NULL AFTER `order_status_id`;
DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receiver_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `messages_id_unique` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `messages` (`id`, `message`, `sender_id`, `receiver_id`, `user_type`, `created_at`, `updated_at`) VALUES
(1, 'hhbhbh', '1', '1', 'kmsmxk', '2022-04-19 11:19:16', '2022-04-19 11:19:16'),
(2, 'hhbhbh', '1', '1', 'kmsmxk', '2022-04-19 11:19:58', '2022-04-19 11:19:58');
COMMIT;
INSERT INTO `settings` (`id`, `name`, `value`, `is_specific`, `created_at`, `updated_at`) VALUES (NULL, 'is_chat_enabled', '1', '0', '2022-04-25 14:56:55', '2022-04-25 14:56:55')
ALTER TABLE `messages` ADD `order_id` VARCHAR(255) NULL AFTER `user_type`;
ALTER TABLE `messages` CHANGE `order_id` `order_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `order_addresses` ADD `latitude` VARCHAR(255) NULL AFTER `address`, ADD `longitude` VARCHAR(255) NULL AFTER `latitude`;
ALTER TABLE `addresses` ADD `latitude` VARCHAR(255) NULL AFTER `address`, ADD `longitude` VARCHAR(255) NULL AFTER `latitude`;
ALTER TABLE `media`  ADD `user_type` VARCHAR(20) NULL  AFTER `mime_type`,  ADD `user_id` INT(191) NULL  AFTER `user_type`;
ALTER TABLE `orders` ADD `order_status_reason` VARCHAR(255) NULL AFTER `order_status_id`;
INSERT INTO `order_statuses` (`id`, `name`, `description`, `status_code`, `is_active`, `is_default`, `created_at`, `updated_at`) VALUES (NULL, '{\"en\":\"Return to Store \"}', '{\"en\":\"<p>Return to Store<\\/p>\"}', '24', '1', '0', '2022-05-19 10:50:14', '2022-05-19 10:50:14');
ALTER TABLE `riders` ADD `latitude` VARCHAR(255) NULL AFTER `address`, ADD `longitude` VARCHAR(255) NULL AFTER `latitude`;
ALTER TABLE `vendor_stores` ADD `latitude` VARCHAR(255) NULL AFTER `address`, ADD `longitude` VARCHAR(255) NULL AFTER `latitude`;
ALTER TABLE `vendor_category` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT, add PRIMARY KEY (`id`);
ALTER TABLE `vendor_category` CHANGE `created_at` `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `updated_at` `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
INSERT INTO `settings` (`id`, `name`, `value`, `is_specific`, `created_at`, `updated_at`) VALUES (NULL, 'is_web_chat_enabled', '1', '0', '2022-05-28 09:42:35', '2022-05-28 09:42:35')
INSERT INTO `settings` (`id`, `name`, `value`, `is_specific`, `created_at`, `updated_at`) VALUES (NULL, 'zendesk_api_key', 'dkjkKGSKwhkHedUIhuioDHUIOWhIU', '0', '2022-05-28 09:46:44', '2022-05-28 09:46:44')


INSERT INTO `payment_methods` (`id`, `name`, `description`, `image_id`, `is_active`, `is_default`, `code`, `created_at`, `updated_at`) VALUES (NULL, '{\"en\":\"Paystack\",\"es\":\"Paystack\",\"sr\":\"Paystack\"}', '{\"en\":\"<p>Paystack<\\/p>\",\"es\":\"<p>Paystack<\\/p>\",\"sr\":\"<p>Paystack<\\/p>\"}', '55', '1', '0', 'paystack', '2022-06-17 18:04:03', '2021-07-10 03:22:50');
INSERT INTO `payment_method_settings` (`id`, `name`, `value`, `payment_method_id`, `created_at`, `updated_at`) VALUES (NULL, 'public_key', 'dsdsddsadsdsad', '11', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `payment_method_settings` (`id`, `name`, `value`, `payment_method_id`, `created_at`, `updated_at`) VALUES (NULL, 'secret_key', 'sdsdsadsad', '11', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

Add Theme Setting Table
-------------Starting-------------
----------[updated on all theme websites -----------


Above all queries are updated.
Dated: 19-10-2022

INSERT INTO `payment_methods` (`id`, `name`, `description`, `image_id`, `is_active`, `is_default`, `code`, `created_at`, `updated_at`) VALUES (NULL, '{\"en\":\"Mollie\",\"es\":\"Mollie\",\"sr\":\"Mollie\"}', '{\"en\":\"<p>Mollie<\\/p>\",\"es\":\"<p>Mollie<\\/p>\",\"sr\":\"<p>Mollie<\\/p>\"}', '978', '1', '0', 'mollie', '2022-10-06 18:27:39', '2022-10-06 18:27:39');


INSERT INTO `payment_method_settings` (`id`, `name`, `value`, `payment_method_id`, `created_at`, `updated_at`) VALUES (NULL, 'api_key', 'test_BARsnpdaJsSzfVnpCHVU4ASR3sV8Sn', '12', '2022-10-18 16:37:49', '2022-10-18 16:37:49');

INSERT INTO `payment_methods` (`id`, `name`, `description`, `image_id`, `is_active`, `is_default`, `code`, `created_at`, `updated_at`) VALUES (NULL, '{\"en\":\"Instamojo\",\"es\":\"Instamojo\",\"sr\":\"Instamojo\"}', '{\"en\":\"<p>Instamojo<\\/p>\",\"es\":\"<p>Instamojo<\\/p>\",\"sr\":\"<p>Instamojo<\\/p>\"}', '976', '1', '0', 'instamojo', '2022-10-19 12:04:54', '2022-10-19 12:04:54');

INSERT INTO `payment_method_settings` (`id`, `name`, `value`, `payment_method_id`, `created_at`, `updated_at`) VALUES (NULL, 'client_id', '0mapUGpEdsBHDwOuQnX6IFM6VTB3V77BLieG7SlP', '13', '2022-10-19 12:40:33', '2022-10-19 12:04:54');
INSERT INTO `payment_method_settings` (`id`, `name`, `value`, `payment_method_id`, `created_at`, `updated_at`) VALUES (NULL, 'client_secret', 'c7TAILMeck6HxRqigzGO39lsXPqcLfr4b3at6t0bTd00wtf3zxNSFx8sg6Q3vHvITvtJlFI8Rd8zQzDdYjyedzuLt88xrQHD84VryYG5gZMTgWpzT44W0pqgdn4tJ0GU', '13', '2022-10-19 12:40:33', '2022-10-19 12:04:54');


*********************All above queries are lived*****************************

Dated: 16-12-2022 Not Live yet
Craete a new 4 tables.
-> about_us
-> refund_policy
-> privacy_policy
-> term_conditions

INSERT INTO `settings` (`id`, `name`, `value`, `is_specific`, `created_at`, `updated_at`) VALUES (NULL, 'web_loader_image_id', '514', '1', '2022-12-16 11:12:47', '2022-12-16 11:12:47');
Dated : 22-12-2022
INSERT INTO `settings` (`id`, `name`, `value`, `is_specific`, `created_at`, `updated_at`) VALUES (NULL, 'product_three_steps', '1', '0', '2022-04-25 17:56:55', '2022-04-25 17:56:55');