INSERT INTO `users` (`id`, `first_name`, `last_name`, `user_type`, `subscription_status`, `status`, `credit_report_company_type`, `is_first_login`, `is_import`, `last_payment_date`, `user_access_end_date`, `last_import_date`, `account_cancel_datetime`, `wave`, `email`, `password`, `street_no`, `street_name`, `city`, `state`, `birth_date`, `phone`, `zip_code`, `ssn`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'Jesse', 'Miller', '1', '1', '1', '3', '0', '1', NULL, NULL, '2022-10-06 10:35:10', NULL, '1', 'jesse@clickletters.com', 'YTZLd2xBTTM4K0prVGc1bE5sODlIQT09', '3555', 'Roosevelt Street', 'San Francisco', 'IL', '10/05/2000', '415-374-2261', '94108', '5555', NULL, NULL, '2022-10-06 16:27:05', '2022-12-22 22:18:22', NULL)

#28-08-2023
ALTER TABLE `video_settings` ADD `is_welcome_video` TINYINT NOT NULL DEFAULT '0' AFTER `status`;

INSERT INTO `users` (`id`, `first_name`, `last_name`, `user_type`, `subscription_status`, `status`, `credit_report_company_type`, `is_first_login`, `is_import`, `last_payment_date`, `user_access_end_date`, `last_import_date`, `account_cancel_datetime`, `wave`, `email`, `password`, `street_no`, `street_name`, `city`, `state`, `birth_date`, `phone`, `zip_code`, `ssn`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'Jesse', 'Miller', '3', '1', '1', '1', '1', '0', '2023-08-28 16:08:24', '2023-09-28 16:08:24', NULL, NULL, '1', 'test_cce@gmail.com', 'YTZLd2xBTTM4K0prVGc1bE5sODlIQT09', 'test', 'test', 'test', 'test', '10/05/1990', '456-987-1234', '12345', '1234', NULL, NULL, NULL, NULL, NULL)

#24-09-2023

CREATE TABLE `supports` (
  `id` bigint UNSIGNED NOT NULL,
  `sender_id` int NOT NULL,
  `assigned_id` int NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` tinyint NOT NULL DEFAULT '1' COMMENT '1=normal,2=high, 3= Very High, 4=urgent',
  `is_read` tinyint NOT NULL DEFAULT '0' COMMENT '1=normal,2=high, 3= Very High, 4=urgent',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0 = Pending, 1 = In progress, 2 = closed, 3 = replied',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `support_replies` (
  `id` bigint UNSIGNED NOT NULL,
  `support_id` int NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment_path` varchar(100) 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 `supports`
  ADD PRIMARY KEY (`id`);

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

ALTER TABLE `supports`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;


ALTER TABLE `support_replies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

  ALTER TABLE `support_replies` ADD `sender_id` INT NOT NULL AFTER `id`;

  #05-10-2023
  ALTER TABLE `support_replies` ADD `is_read` TINYINT NOT NULL DEFAULT '0' COMMENT '0=no read,1=read' AFTER `support_id`;
