17 lines
490 B
SQL
17 lines
490 B
SQL
DO $$
|
|
BEGIN
|
|
IF to_regclass('public.launcher_notices') IS NOT NULL THEN
|
|
ALTER TABLE "launcher_notices"
|
|
ADD COLUMN IF NOT EXISTS "created_by_id" UUID,
|
|
ADD COLUMN IF NOT EXISTS "created_by_name" TEXT,
|
|
ADD COLUMN IF NOT EXISTS "created_by_email" TEXT;
|
|
END IF;
|
|
END $$;
|
|
|
|
DO $$
|
|
BEGIN
|
|
IF to_regclass('public.launcher_notices') IS NOT NULL THEN
|
|
CREATE INDEX IF NOT EXISTS "launcher_notices_created_by_email_idx" ON "launcher_notices"("created_by_email");
|
|
END IF;
|
|
END $$;
|