CREATE TABLE `role_colors` (
  `id` varchar(36) NOT NULL,
  `role` varchar(50) NOT NULL,
  `private_normal` varchar(7) NOT NULL,
  `private_high` varchar(7) NOT NULL,
  `public_normal` varchar(7) NOT NULL,
  `public_high` varchar(7) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  CONSTRAINT `role_colors_id` PRIMARY KEY(`id`),
  CONSTRAINT `role_colors_role_unique` UNIQUE(`role`)
);

CREATE UNIQUE INDEX `unique_role_colors_role` ON `role_colors` (`role`);

