Build Container / build (push) Successful in 6s
Micropub like-of/repost-of with optional comment; likes on /likes, off the home page and feeds; reposts in the stream. Native favourites/boosts on GoToSocial and likes/reposts/quotes on Bluesky when the target is on that network, link posts for other reposts. Fix double slash in outgoing webmention source URLs. ADR-068. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
9 lines
321 B
SQL
9 lines
321 B
SQL
-- Migration 013: Likes and reposts (v2.5.0, ADR-068)
|
|
-- A note with like_of is a like; with repost_of, a repost. Content is the
|
|
-- optional comment and may be empty.
|
|
|
|
ALTER TABLE notes ADD COLUMN like_of TEXT;
|
|
ALTER TABLE notes ADD COLUMN repost_of TEXT;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_notes_like_of ON notes(like_of);
|