mirror of
https://github.com/J3vb/OwnCord.git
synced 2026-09-03 03:50:00 +03:00
20 lines
629 B
SQL
20 lines
629 B
SQL
|
-- name: ListEmoji :many
|
||
|
|
SELECT id, shortcode, filename, mime_type, uploaded_by, created_at
|
||
|
|
FROM emoji ORDER BY shortcode ASC;
|
||
|
|
|
||
|
|
-- name: GetEmojiByID :one
|
||
|
|
SELECT id, shortcode, filename, mime_type, uploaded_by, created_at
|
||
|
|
FROM emoji WHERE id = ?;
|
||
|
|
|
||
|
|
-- name: GetEmojiByShortcode :one
|
||
|
|
SELECT id, shortcode, filename, mime_type, uploaded_by, created_at
|
||
|
|
FROM emoji WHERE shortcode = ?;
|
||
|
|
|
||
|
|
-- name: CreateEmoji :one
|
||
|
|
INSERT INTO emoji (shortcode, filename, mime_type, uploaded_by)
|
||
|
|
VALUES (?, ?, ?, ?)
|
||
|
|
RETURNING id, shortcode, filename, mime_type, uploaded_by, created_at;
|
||
|
|
|
||
|
|
-- name: DeleteEmoji :execresult
|
||
|
|
DELETE FROM emoji WHERE id = ?;
|