/* 12-10-2020 */
ALTER TABLE `game_category`
ADD `price` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `slug`;

ALTER TABLE `game_category`
CHANGE `price` `price` decimal(10,2) NULL AFTER `slug`;

/* 12-10-2020 */
INSERT INTO settings (name, value)
VALUES ('admin_email', 'ritish.vermani@globiztechnology.com');
INSERT INTO settings (name, value)
VALUES ('ticket_prefix', '4123');



/* 18-10-2020 */
ALTER TABLE `users_tokens`
ADD `admin_id` int(11) NULL AFTER `user_id`,
ADD FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

ALTER TABLE `support_comments`
ADD `by` varchar(10) NOT NULL AFTER `admin_id`;

ALTER TABLE `users_tokens`
CHANGE `user_id` `user_id` int(11) NULL AFTER `id`;


-------------- 31-10-2021 ---------------------------
INSERT INTO `permissions` (`title`, `type`)
SELECT 'Chat', 'chat'
FROM `permissions`
WHERE ((`id` = '24'));

-------------- 01-11-2021 ---------------------------
ALTER TABLE `users`
ADD `basis_user_id` int(11) NULL AFTER `basisid_status`,
ADD `basis_user_hash` text NULL AFTER `basis_user_id`;

ALTER TABLE `users`
ADD `basisid_applied_at` datetime NULL AFTER `basisid_verified_at`;

ALTER TABLE users
ADD session_id varchar(255) COLLATE 'utf8_general_ci' NULL AFTER bio;

INSERT INTO `settings` (`name`, `value`)
VALUES ('basisid_key', 'prod-OPaPtaBVvDHoUkggjjsZvGgiWJYhXGOV');

INSERT INTO `settings` (`name`, `value`)
VALUES ('basisid_url', 'https://api.basisid.com/');

INSERT INTO `settings` (`name`, `value`)
VALUES ('basisid_container_id', 'bas-widget-container');

ALTER TABLE `users`
ADD `basisid_verified_at` datetime NULL AFTER `verified_at`,
ADD `basisid_applied_at` datetime NULL AFTER `basisid_verified_at`,
ADD `basisid_status` tinyint(4) NULL AFTER `basisid_applied_at`,
ADD `basis_user_id` int(11) NULL AFTER `basisid_status`,
ADD `basis_user_hash` text NULL AFTER `basis_user_id`;

ALTER TABLE `admins`
ADD `session_id` varchar(255) NULL AFTER `last_login`,
CHANGE `modified` `modified` timestamp NOT NULL AFTER `address`;

---Tables to upload




-- 15-11-2021 By Jatin

INSERT INTO `permissions` (`title`, `type`)
SELECT 'Plan Dividation', 'plan_dividation'
FROM `permissions`
WHERE ((`id` = '25'));

-- 15-11-2021 By Jatin



-- 16-11-2021 By Jatin

INSERT INTO `permissions` (`title`, `type`)
SELECT 'Notification', 'plan_dividation'
FROM `permissions`
WHERE ((`id` = '26'));

UPDATE `permissions` SET `title` = 'Notifications', `type` = 'notifications' WHERE `id` = '27';

DELETE FROM `permissions`
WHERE ((`id` = '8') OR (`id` = '10') OR (`id` = '13') OR (`id` = '14') OR (`id` = '15') OR (`id` = '16') OR (`id` = '17') OR (`id` = '19') OR (`id` = '23') OR (`id` = '24') OR (`id` = '25') OR (`id` = '26'));


INSERT INTO `permissions` (`title`, `type`)
SELECT 'Announcements', 'announcements'
FROM `permissions`
WHERE ((`id` = '22'));


INSERT INTO `settings` (`name`, `value`)
VALUES ('age_limti', '18');

-- 16-11-2021 By Jatin


-- 24-11-2021 By Jatin

CREATE TABLE `contact_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `title` varchar(255) NOT NULL,
  `subject` varchar(255) NULL,
  `email` varchar(255) NOT NULL,
  `phonenumber` varchar(255) NULL,
  `message` text NULL,
  `created` datetime NOT NULL
);

ALTER TABLE `contact_requests`
CHANGE `title` `name` varchar(255) COLLATE 'utf8mb4_general_ci' NOT NULL AFTER `id`;


ALTER TABLE `contact_requests`
CHANGE `created` `created` datetime NULL AFTER `message`,
ADD `deleted_at` datetime NULL;
-- 24-11-2021 By Jatin


admins field token

user_matchtes table
messages table
suport_comment

settings session_web_expires_in_minutes entry




---
Admin middle ware setup with token
Support comment apis
Chat boxes setup
Back button on ticket detail page