forked from mtusi2026/mtusi2026lab5
12 lines
368 B
SQL
12 lines
368 B
SQL
-- name: CreateAttachmentVariant :exec
|
|
INSERT INTO attachment_variants (
|
|
attachment_id, pipeline_version, name, object_key, content_type, size_bytes, width, height, sha256
|
|
) VALUES (
|
|
$1, $2, $3, $4, $5, $6, $7, $8, $9
|
|
);
|
|
|
|
-- name: ListAttachmentVariants :many
|
|
SELECT * FROM attachment_variants
|
|
WHERE attachment_id = $1 AND pipeline_version = $2
|
|
ORDER BY name;
|