-- CreateEnum
DO $$
BEGIN
  IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'EmployeeRole') THEN
    CREATE TYPE "EmployeeRole" AS ENUM ('TL', 'ATL', 'Dev');
  END IF;
END$$;

-- AlterTable
ALTER TABLE "users" ADD COLUMN     "employeeRole" "EmployeeRole";

-- CreateTable
CREATE TABLE "role_daily_hours" (
    "id" TEXT NOT NULL,
    "role" "EmployeeRole" NOT NULL,
    "dailyHours" DOUBLE PRECISION NOT NULL,

    CONSTRAINT "role_daily_hours_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE UNIQUE INDEX "role_daily_hours_role_key" ON "role_daily_hours"("role");
