-- ------------------------------------------
-- UPDATE FOR differenciating between ü and u
-- ------------------------------------------
ALTER TABLE `cehior_auth_proj_test_user` 
CHARACTER SET = 'utf8mb4', COLLATE = 'utf8mb4_unicode_ci',
CHANGE COLUMN `test_user` `test_user` VARCHAR(12) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL ;

ALTER TABLE `prd_trace_view` 
CHARACTER SET = 'utf8mb4', COLLATE = 'utf8mb4_unicode_ci',
CHANGE COLUMN `user` `user` VARCHAR(12) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL ;

ALTER TABLE `prd_trace_view_hits` 
CHARACTER SET = 'utf8mb4', COLLATE = 'utf8mb4_unicode_ci',
CHANGE COLUMN `user` `user` VARCHAR(12) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL ;

-- --------------------------------------------
-- UPDATE FOR saving both tcode and dynpro hits
-- --------------------------------------------
ALTER TABLE `prd_trace_view_hits` 
ADD COLUMN `dynpro` INT(11) NULL DEFAULT '0' AFTER `hits`;