mirror of
https://github.com/Kyren223/eko.git
synced 2026-01-10 14:54:43 +00:00
16 lines
236 B
SQL
16 lines
236 B
SQL
-- name: ListNetworks :many
|
|
SELECT * FROM networks
|
|
ORDER BY id;
|
|
|
|
-- name: GetNetwork :one
|
|
SELECT * FROM networks
|
|
WHERE id = ?;
|
|
|
|
-- name: CreateNetwork :one
|
|
INSERT INTO networks (
|
|
id, name, owner_id
|
|
) VALUES (
|
|
?, ?, ?
|
|
)
|
|
RETURNING *;
|