11 lines
382 B
SQL
11 lines
382 B
SQL
-- name: AddCustomRecord :exec
|
|
INSERT INTO domain_custom_records (domain_id, record_key)
|
|
VALUES ($1, $2)
|
|
ON CONFLICT (domain_id, record_key) DO NOTHING;
|
|
|
|
-- name: DeleteCustomRecord :exec
|
|
DELETE FROM domain_custom_records WHERE domain_id = $1 AND record_key = $2;
|
|
|
|
-- name: ListCustomKeys :many
|
|
SELECT record_key FROM domain_custom_records WHERE domain_id = $1 ORDER BY record_key;
|