20 lines
686 B
SQL
20 lines
686 B
SQL
-- CreateEnum
|
|
CREATE TYPE "public"."DepartmentKey" AS ENUM ('marketing', 'administracion', 'capital_humano', 'operaciones');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "public"."User"
|
|
ADD COLUMN "department" "public"."DepartmentKey",
|
|
ADD COLUMN "departmentRole" TEXT;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "public"."Invitation"
|
|
ADD COLUMN "inviteeName" TEXT NOT NULL DEFAULT 'Usuario invitado',
|
|
ADD COLUMN "department" "public"."DepartmentKey" NOT NULL DEFAULT 'marketing',
|
|
ADD COLUMN "departmentRole" TEXT NOT NULL DEFAULT 'Miembro';
|
|
|
|
-- RemoveDefaults
|
|
ALTER TABLE "public"."Invitation"
|
|
ALTER COLUMN "inviteeName" DROP DEFAULT,
|
|
ALTER COLUMN "department" DROP DEFAULT,
|
|
ALTER COLUMN "departmentRole" DROP DEFAULT;
|