1#@!#!123s

: / opt / psa / admin / plib / modules / laravel / resources / db / Migrations /

Filename : 202201311809_AddUuidColumn.sql

back

-- Copyright 1999-2024. WebPros International GmbH. All rights reserved.
ALTER TABLE `applications`
ADD `uuid` char(36) NOT NULL DEFAULT '';

UPDATE `applications`
SET `uuid` = lower(hex(randomblob(4))) || '-' || lower(hex(randomblob(2))) || '-4' || substr(lower(hex(randomblob(2))), 2) || '-' ||
             substr('89ab', abs(random()) % 4 + 1, 1) || substr(lower(hex(randomblob(2))), 2) || '-' || lower(hex(randomblob(6)));

CREATE UNIQUE INDEX `idx_applications_uuid` ON `applications`(`uuid`);