Tahinli/forge

public

0 watching

★ 0

666 bytes

1	-- Emoji reactions on issues (and pull requests, which are issue rows) and on their comments.
2	-- Applied by store/migrate.rs. target_kind is 'issue' or 'comment'. reaction is the short name of
3	-- a forge_core::Reaction (for example '+1' or 'heart'). One row per user, target and emoji, so a
4	-- second toggle removes the row again.
5
6	CREATE TABLE reactions (
7	target_kind TEXT NOT NULL,
8	target_id TEXT NOT NULL,
9	user_id TEXT NOT NULL REFERENCES users(id),
10	emoji TEXT NOT NULL,
11	created_at TEXT NOT NULL,
12	PRIMARY KEY (target_kind, target_id, user_id, emoji)
13	);
14	CREATE INDEX reactions_target ON reactions(target_kind, target_id);