#12-08-2022
ALTER TABLE `users` ADD `is_import` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1= eligible for import new report, 0= not yet' AFTER `is_first_login`, ADD `last_import_date` DATETIME NULL DEFAULT NULL AFTER `is_import`;

#13-Sep-2022
ALTER TABLE `users` ADD `user_type` TINYINT(4) NOT NULL DEFAULT '0' AFTER `last_name`;

#15-sep-2022
ALTER TABLE `video_settings` ADD `section_id` INT(11) NOT NULL DEFAULT '0' AFTER `link`, ADD `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0-inaction, 1-active' AFTER `section_id`;
ALTER TABLE `video_settings` ADD UNIQUE(`section_id`);

#16-sep-2022
ALTER TABLE `users` ADD `status` TINYINT(4) NOT NULL DEFAULT '1' AFTER `user_type`;

#19-sep-2022
ALTER TABLE `video_settings` CHANGE `section_id` `section_name` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;

#23-sep-2022
ALTER TABLE `users` ADD `wave` TINYINT(10) NOT NULL DEFAULT '0' AFTER `last_import_date`;
=======================================
completed
=======================================

#29-sep-2022
ALTER TABLE `recurrings` ADD `transaction_status` TINYINT(4) NOT NULL AFTER `user_id`, ADD `email` VARCHAR(20) NOT NULL AFTER `transaction_status`, ADD `name` VARCHAR(100) NOT NULL AFTER `email`;

#30-sep-2022
ALTER TABLE `recurrings` CHANGE `email` `email` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `recurrings`DROP `ccnumber`,DROP `ccexp`;
ALTER TABLE `users` ADD `subscription_type` TINYINT(4) NOT NULL DEFAULT '0' AFTER `user_type`;
ALTER TABLE `users` CHANGE `subscription_type` `subscription_status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0=unsubcribed, 1= subscribed';

#14-nov-2022
ALTER TABLE `user_security_questions` CHANGE `question_id` `answer_id` INT(11) NOT NULL;

#21-dec-2022
ALTER TABLE `sales` ADD `cc_number` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'masking and last 4 digit card number' AFTER `order_id`;
ALTER TABLE `users` CHANGE `subscription_status` `subscription_status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT 'if payment success then(0=unsubcribed, 1= subscribed)';

==============================
deployed
===============================

#22-dec-2022
ALTER TABLE `users` ADD `last_payment_date` DATETIME NULL DEFAULT NULL AFTER `is_import`;
ALTER TABLE `users` CHANGE `user_type` `user_type` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '1=admin,0=client,2=employee';

#17-jan-2023
ALTER TABLE `users` ADD `account_cancel_datetime` DATETIME NULL DEFAULT NULL AFTER `last_import_date`;
ALTER TABLE `users` CHANGE `subscription_status` `subscription_status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT 'if payment success then(0=unsubscribed, 1= subscribed,2=cancel account)';

#19-jan-2023
ALTER TABLE `modules` ADD `status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT 'for employee 1 otherwise 0' AFTER `name`;

#20-jan-2023
UPDATE `modules` SET `name` = 'Employee Management' WHERE `modules`.`id` = 5;
DELETE FROM `modules` WHERE id = 6;

UPDATE `submodules` SET `name` = 'List' WHERE `submodules`.`id` = 10;
UPDATE `submodules` SET `key` = 'employee-list' WHERE `submodules`.`id` = 10;
====================
deployed
=====================

#27-jan-2023
=======================
ALTER TABLE `users` CHANGE `status` `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT 'active = 1, inactive = 2';

#30-jan-2023
======================
ALTER TABLE `recurrings` ADD `last_process_date` DATETIME NULL DEFAULT NULL AFTER `user_id`, ADD `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1=active,2= inactive' AFTER `last_process_date`;

#31-jan-2023
=====================
ALTER TABLE `recurrings` CHANGE `user_id` `user_id` BIGINT NOT NULL DEFAULT '0';
ALTER TABLE `recurrings` CHANGE `transaction_status` `transaction_status` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `recurrings` CHANGE `email` `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `recurrings` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `recurrings` CHANGE `subscription_id` `subscription_id` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `recurrings` CHANGE `transaction_id` `transaction_id` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `recurrings` CHANGE `recurring_type` `recurring_type` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `recurrings` CHANGE `plan_payments` `plan_payments` SMALLINT NOT NULL DEFAULT '0';
ALTER TABLE `recurrings` CHANGE `plan_amount` `plan_amount` DOUBLE(8,2) NOT NULL DEFAULT '0';
ALTER TABLE `recurrings` CHANGE `day_frequency` `day_frequency` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `recurrings` CHANGE `month_frequency` `month_frequency` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `recurrings` CHANGE `day_of_month` `day_of_month` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

#23-mar-2023
======================
INSERT INTO `creditreport_providers` (`id`, `company_type`, `link`, `created_at`, `updated_at`)
    VALUES (NULL, '1', 'https://member.identityiq.com/creditpreferred.aspx?offercode=431141CQ', '2023-03-15 10:53:30', '2023-03-23 06:15:04'),
           (NULL, '3', 'https://www.smartcredit.com/?PID=11885', '2023-03-23 04:24:33', '2023-03-23 05:06:09');

            ==============================
                      deployed
            ===============================

#28-mar-2023
========================
ALTER TABLE `sales` ADD `recurring_id` INT NOT NULL DEFAULT '0' AFTER `transaction_id`;

#30-mar-2023
========================
ALTER TABLE `sales` DROP INDEX `sales_order_id_unique`;
ALTER TABLE `sales` CHANGE `order_id` `order_id` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

#03-apr-2023
========================
update `recurrings` set plan_amount=24.97,day_of_month=30;

#05-apr-2023
=======================
ALTER TABLE `users` ADD `user_access_end_date` DATETIME NULL DEFAULT NULL AFTER `last_payment_date`;
