migrations/002_add_indexes.sql at cc2ac65d6b9577035d6c02d7bc3c63333042c3f1 · zenfyr.dev/xpost

zenfyr.dev / xpost

social media crossposting tool. 3rd time's the charm

mastodon misskey crossposting bluesky

xpost / migrations / 002_add_indexes.sql

at cc2ac65d6b9577035d6c02d7bc3c63333042c3f1 194 B view raw

1CREATE INDEX IF NOT EXISTS idx_posts_service_user_identifier
2ON posts (service, user, identifier);
3
4CREATE UNIQUE INDEX IF NOT EXISTS ux_mappings_original_mapped
5ON mappings (original, mapped);