A community based topic aggregation platform built on atproto
bretton.dev
1-- +goose Up
2CREATE TABLE users (
3 id SERIAL PRIMARY KEY,
4 email VARCHAR(255) UNIQUE NOT NULL,
5 username VARCHAR(50) UNIQUE NOT NULL,
6 created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
7 updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
8);
9
10CREATE INDEX idx_users_email ON users(email);
11CREATE INDEX idx_users_username ON users(username);
12
13-- +goose Down
14DROP TABLE users;