CREATE TABLE `lc_uploader_tags_data` (
        `emp_id` INT(10) NOT NULL,
        `bookmark_id` INT(10) NOT NULL DEFAULT '0',
        `tag_data` LONGTEXT NOT NULL COLLATE 'utf8mb4_0900_ai_ci',
        `id` INT(10) NOT NULL AUTO_INCREMENT,
`is_archeive` TINYINT(3) NOT NULL DEFAULT '0',
        PRIMARY KEY (`id`) USING BTREE,
        INDEX `bookmark_id` (`bookmark_id`) USING BTREE,
        INDEX `emp_id` (`emp_id`) USING BTREE,
        CONSTRAINT `bookmark_id` FOREIGN KEY (`bookmark_id`) REFERENCES `peoplei_300_people_qa_20230321`.`lc_bookmarks` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT
)
;

ALTER TABLE lc_requests ADD candidate_email VARCHAR(50) NULL DEFAULT NULL;
ALTER TABLE lc_requests ADD candidate_cell_no VARCHAR(50) NOT NULL DEFAULT '0';
ALTER TABLE lc_requests ADD candidate_full_name VARCHAR(50) NULL DEFAULT NULL;
ALTER TABLE lc_requests ADD non_employee_single_letter TINYINT(3) NOT NULL DEFAULT '0';
ALTER TABLE lc_requests ADD letter_reference_number VARCHAR(70) NOT NULL;

ALTER TABLE lc_sent_letters_detail MODIFY emp_id INT(10) UNSIGNED NULL DEFAULT '0';

ALTER TABLE lc_categories modify created_at DATETIME NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE lc_categories modify updated_at DATETIME NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE lc_bookmarks ADD type ENUM('date','string','number','file') NOT NULL DEFAULT 'string';