DO $$
BEGIN
  IF to_regclass('public.licenses') IS NOT NULL THEN
    CREATE TABLE IF NOT EXISTS "license_app_permissions" (
      "id" UUID NOT NULL,
      "license_id" UUID NOT NULL,
      "app_key" TEXT NOT NULL,
      "can_launch" BOOLEAN NOT NULL DEFAULT true,
      "created_at" TIMESTAMPTZ(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
      "updated_at" TIMESTAMPTZ(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,

      CONSTRAINT "license_app_permissions_pkey" PRIMARY KEY ("id"),
      CONSTRAINT "license_app_permissions_license_id_fkey" FOREIGN KEY ("license_id") REFERENCES "licenses"("id") ON DELETE CASCADE ON UPDATE CASCADE
    );

    CREATE UNIQUE INDEX IF NOT EXISTS "license_app_permissions_license_id_app_key_key" ON "license_app_permissions"("license_id", "app_key");
    CREATE INDEX IF NOT EXISTS "license_app_permissions_app_key_idx" ON "license_app_permissions"("app_key");
  END IF;
END $$;