-- name: GetState :one
SELECT * FROM states
WHERE id = ? LIMIT 1;

-- name: ListStates :many
SELECT * FROM states
ORDER BY name
LIMIT ? OFFSET ?;

-- name: CreateState :execresult
INSERT INTO states (
    name, shortform, enqform
) VALUES (
    ?, ?, ?
);

-- name: UpdateState :exec
UPDATE states
SET name = ?,
    shortform = ?,
    enqform = ?
WHERE id = ?;

-- name: DeleteState :exec
DELETE FROM states
WHERE id = ?;