16 lines
491 B
SQL
16 lines
491 B
SQL
CREATE EXTENSION IF NOT EXISTS "pgcrypto";
|
|
|
|
UPDATE "users"
|
|
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 "lms_notifications"
|
|
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 "users"
|
|
ALTER COLUMN "id" TYPE uuid USING "id"::uuid;
|
|
|
|
ALTER TABLE "lms_notifications"
|
|
ALTER COLUMN "id" TYPE uuid USING "id"::uuid;
|