ALTER TABLE `users` ADD `title` VARCHAR(255) NULL AFTER `trader_order_type_primary`, ADD `tags` JSON NULL AFTER `title`, ADD `additional_emails` TEXT NULL AFTER `tags`, ADD `additional_emails_label` TEXT NULL AFTER `additional_emails`, ADD `additional_phone_numbers` TEXT NULL AFTER `additional_emails_label`, ADD `additional_phone_numbers_label` TEXT NULL AFTER `additional_phone_numbers`, ADD `additional_shipping_emails` TEXT NULL AFTER `additional_phone_numbers_label`;
ALTER TABLE `users` ADD `additional_shipping_emails_label` TEXT NULL AFTER `additional_shipping_emails`, ADD `additional_shipping_phones` TEXT NULL AFTER `additional_shipping_emails_label`, ADD `additional_shipping_phones_label` TEXT NULL AFTER `additional_shipping_phones`;
ALTER TABLE `users` ADD `email_label` VARCHAR(55) NULL AFTER `additional_shipping_phones_label`, ADD `shipping_email_label` VARCHAR(55) NULL AFTER `email_label`;
ALTER TABLE `users` ADD `contact_number_label` VARCHAR(55) NULL AFTER `shipping_email_label`, ADD `shipping_phone_label` VARCHAR(55) NULL AFTER `contact_number_label`;
ALTER TABLE `users` CHANGE `tags` `tags` TEXT NULL DEFAULT NULL;
ALTER TABLE `users` ADD `email_signature` TEXT NULL AFTER `shipping_phone_label`;
ALTER TABLE `order_details` ADD `email_thread_ids` JSON NULL AFTER `product_group_id`;
	


ALTER TABLE `users` ADD `twilio_phone_number` VARCHAR(55) NULL AFTER `email_signature`;
CREATE TABLE active_sms_conversations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(20) NOT NULL UNIQUE,
    conversation_sid VARCHAR(34) NOT NULL,
    last_activity_at TIMESTAMP NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
ALTER TABLE `active_sms_conversations` DROP INDEX `phone_number`;
ALTER TABLE `active_sms_conversations` ADD `user_id` INT(11) NULL AFTER `phone_number`;
ALTER TABLE `active_sms_conversations` ADD UNIQUE(`phone_number`, `user_id`);


CREATE TABLE `user_interactions` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `phone` VARCHAR(255) NULL,
    `email` VARCHAR(255) NULL,
    `user_id` BIGINT UNSIGNED NULL,
    `order_id` BIGINT UNSIGNED NULL,
    `thread_id` VARCHAR(255) NULL,
    `conversation_id` VARCHAR(255) NULL,
    `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX `conversations_data_phone_email_user_id_index` (`phone`, `email`, `user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `user_interactions` ADD `origin_type` ENUM('nylas_webhook','start_new_sms','order_list','twilio_webhook','chat_request') NULL AFTER `conversation_id`;

ALTER TABLE `order_details`  
ADD COLUMN `dtf_image_1` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_1` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_1` INT DEFAULT NULL,
ADD COLUMN `dtf_image_2` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_2` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_2` INT DEFAULT NULL,
ADD COLUMN `dtf_image_3` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_3` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_3` INT DEFAULT NULL,
ADD COLUMN `dtf_image_4` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_4` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_4` INT DEFAULT NULL,
ADD COLUMN `dtf_image_5` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_5` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_5` INT DEFAULT NULL,
ADD COLUMN `dtf_image_6` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_6` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_6` INT DEFAULT NULL,
ADD COLUMN `dtf_image_7` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_7` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_7` INT DEFAULT NULL,
ADD COLUMN `dtf_image_8` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_8` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_8` INT DEFAULT NULL,
ADD COLUMN `dtf_image_9` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_9` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_9` INT DEFAULT NULL,
ADD COLUMN `dtf_image_10` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `dtf_dimensions_10` VARCHAR(50) DEFAULT NULL,
ADD COLUMN `dtf_quantity_10` INT DEFAULT NULL;

ALTER TABLE `users` ADD `square_app_id` VARCHAR(255) NULL AFTER `twilio_phone_number`, ADD `square_app_token` VARCHAR(255) NULL AFTER `square_app_id`, ADD `square_location_id` VARCHAR(255) NULL AFTER `square_app_token`, ADD `square_signature` VARCHAR(255) NULL AFTER `square_location_id`;