diff options
Diffstat (limited to 'db/query.sql')
-rw-r--r-- | db/query.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/db/query.sql b/db/query.sql index f4b17dd..624442f 100644 --- a/db/query.sql +++ b/db/query.sql @@ -21,3 +21,17 @@ WHERE Name = $1; -- name: GetDnsBlackList :many SELECT * FROM DnsBlackList; + +-- name: EnterMacBlackList :exec +INSERT INTO MacBlackList ( + HardwareAddr +) VALUES ( + $1 +); + +-- name: DeleteMacBlackList :exec +DELETE FROM MacBlackList +WHERE HardwareAddr = $1; + +-- name: GetMacBlackList :many +SELECT * FROM MacBlackList; |