baileytownsend.dev / stitch_counter
tangled.org trending bluesky account
fork atom
stitch_counter / bot / migrations / 20250914172800_create_posts_made.sql
at main 8 lines 310 B view raw
baileytownsend.dev wip
6e15add6
1-- Create the posts_made table 2CREATE TABLE IF NOT EXISTS posts_made ( 3 createdAt TEXT NOT NULL, -- ISO8601 timestamp string of when we recorded a post was made 4 subject TEXT NOT NULL 5); 6 7-- Index for faster lookup by subject 8CREATE INDEX IF NOT EXISTS idx_posts_made_subject ON posts_made(subject);