Files
2026-10-30 12:32:42 +03:00

29 lines
1.0 KiB
PL/PgSQL

\set ON_ERROR_STOP on
DO $$ BEGIN
IF current_database() <> 'track' THEN
RAISE EXCEPTION 'track-setup.sql выполняется только в базе track';
END IF;
END $$;
CREATE EXTENSION IF NOT EXISTS pg_buffercache;
CREATE OR REPLACE FUNCTION track_uuid7() RETURNS uuid LANGUAGE sql VOLATILE AS $$
SELECT encode(
set_bit(set_bit(overlay(uuid_send(gen_random_uuid())
PLACING substring(int8send((extract(epoch FROM clock_timestamp()) * 1000)::bigint) FROM 3)
FROM 1 FOR 6), 52, 1), 53, 1),
'hex')::uuid
$$;
CREATE OR REPLACE FUNCTION track_chat(k int) RETURNS uuid LANGUAGE sql IMMUTABLE AS $$
SELECT ('00000000-0000-7000-8000-' || lpad(to_hex(k), 12, '0'))::uuid
$$;
CREATE OR REPLACE FUNCTION track_user(u int) RETURNS uuid LANGUAGE sql IMMUTABLE AS $$
SELECT ('00000000-0000-7000-8001-' || lpad(to_hex(u), 12, '0'))::uuid
$$;
CREATE OR REPLACE FUNCTION track_message(k int, i int) RETURNS uuid LANGUAGE sql IMMUTABLE AS $$
SELECT (lpad(to_hex(k), 8, '0') || '-0000-7000-8002-' || lpad(to_hex(i), 12, '0'))::uuid
$$;