-- name: CreateSignalsAndReturnUuid :copyfrom
INSERT INTO metadata.signals (slug, name, description)
VALUES ($1, $2, $3) RETURNING uuid;

-- object: metadata.signals | type: TABLE --
-- DROP TABLE IF EXISTS metadata.signals CASCADE;
CREATE TABLE metadata.signals
(
    uuid                uuid          NOT NULL DEFAULT uuidv7(),
    slug                metadata.slug NOT NULL,
    name                text          NOT NULL,
    description         text          NOT NULL DEFAULT '',
);