davidwindham.com
forked from
pds.dad/pds-moover
Client side atproto account migrator in your web browser, along with services for backups and adversarial migrations.
pds.dad
1-- Create demo_items table for example reader/writer
2CREATE TABLE IF NOT EXISTS accounts
3(
4 id BIGSERIAL PRIMARY KEY,
5 did TEXT NOT NULL UNIQUE,
6 pds_host TEXT NOT NULL,
7 active BOOLEAN NOT NULL DEFAULT true,
8 repo_rev TEXT,
9 pds_sign_up BOOLEAN NOT NULL DEFAULT false,
10 last_backup TIMESTAMPTZ,
11 created_at TIMESTAMPTZ NOT NULL DEFAULT now()
12);
13-- Add up migration script here
14
15CREATE INDEX idx_accounts_did ON accounts (did);
16CREATE INDEX idx_accounts_pds_host ON accounts (pds_host);