-- name: GetLegBrands :many
SELECT * FROM leg_brands ORDER BY id LIMIT $1 OFFSET $2;

-- name: GetLegBrandById :one
SELECT * FROM leg_brands WHERE id = $1 LIMIT 1;

-- name: CreateLegBrand :one
INSERT INTO leg_brands (name, brand, img_logo)
VALUES ($1, $2, $3)
RETURNING *;

-- name: UpdateLegBrand :one
UPDATE leg_brands SET name=$2, brand=$3, img_logo=$4 WHERE id=$1 RETURNING *;

-- name: DeleteLegBrand :one
DELETE FROM leg_brands WHERE id=$1 RETURNING id;