ALTER TABLE `admins` DROP `access`;



ALTER TABLE `admins` CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `username` `username` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `admin_notifications` CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `read_status` `read_status` TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE `admin_password_resets` CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `token` `token` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `commission_logs` CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `who` `who` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `level` `level` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `amount` `amount` DECIMAL(28,8) NULL DEFAULT NULL, CHANGE `main_amo` `main_amo` DECIMAL(28,8) NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `trx` `trx` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `deposits` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `method_code` `method_code` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `method_currency` `method_currency` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, CHANGE `btc_amo` `btc_amo` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `btc_wallet` `btc_wallet` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `trx` `trx` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `try` `try` INT(10) NOT NULL DEFAULT '0', CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '1=>success, 2=>pending, 3=>cancel', CHANGE `from_api` `from_api` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `admin_feedback` `admin_feedback` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; 

DROP TABLE `email_logs`, `email_sms_templates`;

ALTER TABLE `extensions` DROP `deleted_at`;

ALTER TABLE `extensions` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `act` `act` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;


CREATE TABLE `forms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `act` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `forms`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `forms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

INSERT INTO `forms` (`act`, `form_data`, `created_at`, `updated_at`) VALUES
('kyc', '{\"full_name\":{\"name\":\"Full Name\",\"label\":\"full_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"gender\":{\"name\":\"Gender\",\"label\":\"gender\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Male\",\"Female\",\"Others\"],\"type\":\"select\"},\"you_hobby\":{\"name\":\"You Hobby\",\"label\":\"you_hobby\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Programming\",\"Gardening\",\"Traveling\",\"Others\"],\"type\":\"checkbox\"},\"nid_photo\":{\"name\":\"NID Photo\",\"label\":\"nid_photo\",\"is_required\":\"required\",\"extensions\":\"jpg,png\",\"options\":[],\"type\":\"file\"}}', '2022-03-17 02:56:14', '2022-04-11 03:23:40');


ALTER TABLE `frontends` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `data_keys` `data_keys` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `views` `views` INT(10) NOT NULL DEFAULT '0';

ALTER TABLE `games` CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `alias` `alias` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '1', CHANGE `win` `win` DECIMAL(28,8) NULL DEFAULT '0' COMMENT 'Win Bonus', CHANGE `max_limit` `max_limit` DECIMAL(28,8) NOT NULL DEFAULT '0', CHANGE `min_limit` `min_limit` DECIMAL(28,8) NOT NULL DEFAULT '0', CHANGE `invest_back` `invest_back` TINYINT(1) NULL DEFAULT '0', CHANGE `probable_win` `probable_win` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `type` `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `level` `level` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `game_logs` CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `game_id` `game_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `user_select` `user_select` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `result` `result` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `invest` `invest` DECIMAL(28,8) NOT NULL DEFAULT '0', CHANGE `win_amo` `win_amo` DECIMAL(28,8) NOT NULL DEFAULT '0.00000000', CHANGE `try` `try` INT(11) NULL DEFAULT '0', CHANGE `win_status` `win_status` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `game_name` `game_name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `gateways` DROP `image`;

ALTER TABLE `gateways` DROP `input_form`;

ALTER TABLE `gateways` ADD `form_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `id`;

ALTER TABLE `gateways` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `code` `code` INT(10) UNSIGNED NULL DEFAULT '0', CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `alias` `alias` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NULL', CHANGE `parameters` `gateway_parameters` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `gateway_currencies` DROP `image`;

ALTER TABLE `gateway_currencies` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `currency` `currency` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `symbol` `symbol` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `method_code` `method_code` INT(10) UNSIGNED NULL DEFAULT NULL, CHANGE `gateway_alias` `gateway_alias` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `general_settings`
  DROP `sms_api`,
  DROP `secondary_color`,
  DROP `sys_version`;


ALTER TABLE `general_settings` ADD `sms_body` VARCHAR(255) NULL DEFAULT NULL AFTER `agree`, ADD `sms_from` VARCHAR(255) NULL DEFAULT NULL AFTER `sms_body`, ADD `global_shortcodes` TEXT NULL DEFAULT NULL AFTER `sms_from`, ADD `kv` TINYINT(1) NOT NULL DEFAULT '0' AFTER `global_shortcodes`, ADD `maintenance_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `kv`, ADD `rb` TINYINT(1) NOT NULL DEFAULT '0' AFTER `maintenance_mode`, ADD `system_info` TEXT NULL DEFAULT NULL AFTER `rb`, ADD `register_bonus` DECIMAL(28,8) NOT NULL DEFAULT '0' AFTER `system_info`, ADD `language` TINYINT(1) NOT NULL DEFAULT '1' AFTER `register_bonus`;



ALTER TABLE `general_settings` CHANGE `sitename` `site_name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `cur_text` `cur_text` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'currency text', CHANGE `cur_sym` `cur_sym` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'currency symbol', CHANGE `email_from` `email_from` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `base_color` `base_color` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `force_ssl` `force_ssl` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `secure_password` `secure_password` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `agree` `agree` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `active_template` `active_template` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `guesse_bonuses` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `chance` `chance` INT(11) NOT NULL DEFAULT '0', CHANGE `percent` `percent` DECIMAL(5,2) NOT NULL DEFAULT '0', CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '1';


ALTER TABLE `languages`
  DROP `icon`,
  DROP `text_align`;

ALTER TABLE `languages` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `code` `code` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `is_default` `is_default` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0: not default language, 1: default language';

DROP TABLE `migrations`;



-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `cc_xaxino`
--

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

--
-- Table structure for table `notification_logs`
--

CREATE TABLE `notification_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `sender` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sent_from` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sent_to` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification_type` varchar(40) COLLATE utf8mb4_unicode_ci 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 `notification_logs`
--


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

--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `act` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subj` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_body` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sms_body` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shortcodes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_status` tinyint(1) NOT NULL DEFAULT 1,
  `sms_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;




ALTER TABLE `notification_logs`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `notification_templates`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `notification_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160;


ALTER TABLE `notification_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
COMMIT;


ALTER TABLE `pages` CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `slug` `slug` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `tempname` `tempname` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'template name', CHANGE `is_default` `is_default` TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE `password_resets` CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `token` `token` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `referrals` CHANGE `level` `level` INT(11) NOT NULL DEFAULT '0', CHANGE `percent` `percent` DECIMAL(5,2) NOT NULL DEFAULT '0', CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '1';


ALTER TABLE `subscribers` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `support_attachments` CHANGE `support_message_id` `support_message_id` INT(10) UNSIGNED NOT NULL, CHANGE `attachment` `attachment` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `support_messages` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `supportticket_id` `supportticket_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `admin_id` `admin_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE `support_tickets` CHANGE `user_id` `user_id` INT(10) UNSIGNED NULL DEFAULT '0', CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `ticket` `ticket` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `subject` `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0: Open, 1: Answered, 2: Replied, 3: Closed', CHANGE `priority` `priority` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '1 = Low, 2 = medium, 3 = heigh';

ALTER TABLE `transactions` CHANGE `user_id` `user_id` INT(10) UNSIGNED NULL DEFAULT '0', CHANGE `trx_type` `trx_type` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `trx` `trx` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `remark` `remark` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `users` ADD `kyc_data` TEXT NULL DEFAULT NULL AFTER `remember_token`, ADD `kv` TINYINT(1) NOT NULL DEFAULT '0' AFTER `kyc_data`, ADD `profile_complete` TINYINT(1) NOT NULL DEFAULT '0' AFTER `kv`, ADD `ban_reason` VARCHAR(255) NULL DEFAULT NULL AFTER `profile_complete`;





ALTER TABLE `user_logins` CHANGE `user_ip` `user_ip` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `city` `city` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `country` `country` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `country_code` `country_code` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `longitude` `longitude` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `latitude` `latitude` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `browser` `browser` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `os` `os` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `user_logins` CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL;

ALTER TABLE `withdrawals` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '1=>success, 2=>pending, 3=>cancel, ';

ALTER TABLE `withdraw_methods` ADD `form_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `id`;

ALTER TABLE `withdraw_methods`
  DROP `image`,
  DROP `delay`,
  DROP `user_data`;

ALTER TABLE `withdraw_methods` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `currency` `currency` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `support_messages` CHANGE `supportticket_id` `support_ticket_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';


UPDATE `general_settings` SET `global_shortcodes` = '{\n    \"site_name\":\"Name of your site\",\n    \"site_currency\":\"Currency of your site\",\n    \"currency_symbol\":\"Symbol of currency\"\n}' WHERE `general_settings`.`id` = 1;


UPDATE `general_settings` SET `sms_config` = '{\"name\":\"nexmo\",\"clickatell\":{\"api_key\":\"----------------\"},\"infobip\":{\"username\":\"------------8888888\",\"password\":\"-----------------\"},\"message_bird\":{\"api_key\":\"-------------------\"},\"nexmo\":{\"api_key\":\"----------------------\",\"api_secret\":\"----------------------\"},\"sms_broadcast\":{\"username\":\"----------------------\",\"password\":\"-----------------------------\"},\"twilio\":{\"account_sid\":\"-----------------------\",\"auth_token\":\"---------------------------\",\"from\":\"----------------------\"},\"text_magic\":{\"username\":\"-----------------------\",\"apiv2_key\":\"-------------------------------\"},\"custom\":{\"method\":\"get\",\"url\":\"https:\\/\\/hostname\\/demo-api-v1\",\"headers\":{\"name\":[\"api_key\"],\"value\":[\"test_api 555\"]},\"body\":{\"name\":[\"from_number\"],\"value\":[\"5657545757\"]}}}' WHERE `general_settings`.`id` = 1;


DROP TABLE ` pages `;


CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempname` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'template name',
  `secs` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `pages` (`id`, `name`, `slug`, `tempname`, `secs`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'HOME', '/', 'templates.basic.', '[\"statistics\",\"game\",\"about\",\"trx_win\",\"why_choose_us\",\"how_work\",\"faq\",\"cta\",\"referral\",\"testimonial\",\"blog\"]', 1, '2020-07-11 06:23:58', '2022-10-15 06:08:45'),
(4, 'Blog', 'blog', 'templates.basic.', NULL, 1, '2020-10-22 01:14:43', '2022-08-31 07:46:38'),
(5, 'Contact', 'contact', 'templates.basic.', NULL, 1, '2020-10-22 01:14:53', '2022-08-31 07:48:18'),
(19, 'About Us', 'about-us', 'templates.basic.', '[\"about\",\"why_choose_us\",\"faq\",\"testimonial\"]', 0, '2022-08-24 09:25:39', '2022-08-24 09:26:12'),
(20, 'Games', 'games', 'templates.basic.', '[\"game\"]', 1, '2022-08-24 09:26:42', '2022-08-31 07:45:42');

ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;


UPDATE `users` SET `kv` = 1;
UPDATE `users` SET `profile_complete` = 1;

INSERT INTO `frontends` (`data_keys`, `data_values`, `views`, `created_at`, `updated_at`) VALUES
('maintenance.data', '{\"heading\":\"THE SITE IS UNDER MAINTENANCE\",\"description\":\"<div class=\\\"mb-5\\\" style=\\\"color: rgb(111, 111, 111); font-family: Nunito, sans-serif; margin-bottom: 3rem !important;\\\"><h3 class=\\\"mb-3\\\" style=\\\"font-weight: 600; line-height: 1.3; font-size: 24px; text-align: center; font-family: Exo, sans-serif;\\\"><font color=\\\"#FFFFFF\\\">We\'ll Be Right Back!<\\/font><\\/h3><h3 class=\\\"mb-3\\\" style=\\\"text-align: center; font-weight: 600; line-height: 1.3; font-size: 24px; font-family: Exo, sans-serif; color: rgb(54, 54, 54);\\\"><p class=\\\"font-18\\\" style=\\\"margin-right: 0px; margin-left: 0px; font-family: Nunito, sans-serif; font-size: 18px !important;\\\"><font color=\\\"#FFFFFF\\\">Sorry, we are down for maintenance but we will be back as soon as possible.<\\/font><\\/p><\\/h3><\\/div>\"}', 0, '2020-07-04 23:42:52', '2022-08-31 05:52:05');



