CREATE TEMP TABLE captureHostLocations (
    "captureHostId" uuid,
    "name" text,
    "clientId" uuid,
    "locationId" uuid
);

INSERT INTO captureHostLocations (
    "captureHostId",
    "name",
    "clientId",
    "locationId"
)
SELECT
    ch."captureHostId",
    ch."captureHostName",
    ch."clientId",
    uuid_generate_v4()
FROM "CaptureHosts" as ch
WHERE ch."locationId" IS NULL;

INSERT INTO "Locations" (
    "locationId",
    "clientId",
    "parentLocationId",
    "locationName",
    "locationSort",
    "locationActive"
)
SELECT
    "locationId",
    "clientId",
    NULL,
    "name",
  ROW_NUMBER() OVER(ORDER BY "locationId") + (
      SELECT MAX("locationSort")
      FROM "Locations"
    ) as "locationSort",
    TRUE
FROM captureHostLocations;

UPDATE "CaptureHosts" as ch
SET "locationId" = captureHostLocations."locationId"
FROM captureHostLocations
WHERE ch."captureHostId" = captureHostLocations."captureHostId";