23 lines
749 B
SQL
23 lines
749 B
SQL
CREATE EXTENSION IF NOT EXISTS "pgcrypto";
|
|
|
|
UPDATE "launcher_notices"
|
|
SET "id" = gen_random_uuid()::text
|
|
WHERE "id" !~* '^[0-9a-f]{8}-[0-9a-f]{4}-[1-5][0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}$';
|
|
|
|
UPDATE "launcher_app_versions"
|
|
SET "id" = gen_random_uuid()::text
|
|
WHERE "id" !~* '^[0-9a-f]{8}-[0-9a-f]{4}-[1-5][0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}$';
|
|
|
|
UPDATE "launcher_apps"
|
|
SET "id" = gen_random_uuid()::text
|
|
WHERE "id" !~* '^[0-9a-f]{8}-[0-9a-f]{4}-[1-5][0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}$';
|
|
|
|
ALTER TABLE "launcher_notices"
|
|
ALTER COLUMN "id" TYPE uuid USING "id"::uuid;
|
|
|
|
ALTER TABLE "launcher_app_versions"
|
|
ALTER COLUMN "id" TYPE uuid USING "id"::uuid;
|
|
|
|
ALTER TABLE "launcher_apps"
|
|
ALTER COLUMN "id" TYPE uuid USING "id"::uuid;
|