A community based topic aggregation platform built on atproto
bretton.dev
1-- +goose Up
2-- Create main users table for Coves (all users are atProto users)
3CREATE TABLE users (
4 did TEXT PRIMARY KEY,
5 handle TEXT UNIQUE NOT NULL,
6 pds_url TEXT NOT NULL CHECK (pds_url <> ''), -- User's PDS host (supports federation)
7 created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
8 updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
9);
10
11-- Indexes for efficient lookups
12CREATE INDEX idx_users_handle ON users(handle);
13CREATE INDEX idx_users_created_at ON users(created_at);
14
15-- +goose Down
16DROP INDEX IF EXISTS idx_users_created_at;
17DROP INDEX IF EXISTS idx_users_handle;
18DROP TABLE IF EXISTS users;