UPDATE lc_bookmarks SET parent_id=0 WHERE tag_name='Effective_Date';

INSERT INTO `lc_categories` (`category_name`, `parent_id`, `cid`, `status`, `created_at`, `updated_at`, `type`, `letter_type_short_code`) 
VALUES ('Authority Letter', 5, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Contract Extension Letter', 1, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Contract Letter', 1, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Degree Acknowledgement Letter', 5, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Exit Document Letter', 4, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Internship Extension Letter', 1, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Mid Year Increment Letter', 3, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Promotion Letter', 3, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Recovery Letter', 5, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Redesignation Letter', 5, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL),
        ('Service Bond NDA - People', 1, 48, 1, '2021-07-08 10:03:23', '2021-07-08 10:03:23', 'category', NULL);

UPDATE department_hierarchy SET color_code=(SELECT Id FROM proll_colors ORDER BY RAND() LIMIT 1);

INSERT INTO `lc_bookmarks` (`id`, `bookmark_name`, `tag_name`, `parent_id`, `query`, `dumy_data`, `status`, `created_at`, `updated_at`, `serial_number`) 
VALUES (124, 'Bank Name', 'Bank_Name', 0,null, 'Dumy_Bank_Name', 1, '2023-05-23 11:54:48', '2023-05-23 11:54:48', '000000'),
        (125,'Empty Tag', 'Empty_Tag', 74, 'select " "', '', 1, '2021-07-12 14:47:10', '2021-07-12 14:47:10', '000000'),
        (122, 'Band', 'Band', 29, "SELECT unified_band FROM employee_bands eb INNER JOIN proll_employee pe ON pe.emp_band=eb.id WHERE pe.id='{id}' LIMIT 1",'Dumy_Employee_Band', 1, '2023-05-23 11:54:48', '2023-05-23 11:54:48', '000000'),
        (123, 'Company Name', 'Company_Name', 91,"SELECT companyname from proll_client pc inner join proll_employee pe on pe.cid=pc.id where pe.id='{id}' LIMIT 1", 'Dumy_Company_Name', 1, '2023-05-23 11:54:48', '2023-05-23 11:54:48', '000000');