Something went wrong. Try again.
An ATProto Powered Reputation Network
Something went wrong. Try again.
2.2 kB · 60 lines
SQL
at master
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061CREATE TABLE IF NOT EXISTS soft_accounts ( did TEXT PRIMARY KEY, active INTEGER NOT NULL DEFAULT 1, account_us INTEGER NOT NULL DEFAULT 0, bootstrap_us INTEGER NOT NULL DEFAULT 0);CREATE TABLE IF NOT EXISTS soft_vouches ( author TEXT NOT NULL REFERENCES soft_accounts(did) ON DELETE CASCADE, subject TEXT NOT NULL, source TEXT NOT NULL, record_key TEXT NOT NULL, score REAL NOT NULL, created_at TEXT NOT NULL, PRIMARY KEY(author, source, record_key)) WITHOUT ROWID;CREATE TABLE IF NOT EXISTS soft_versions ( author TEXT NOT NULL REFERENCES soft_accounts(did) ON DELETE CASCADE, source TEXT NOT NULL, record_key TEXT NOT NULL, time_us INTEGER NOT NULL, PRIMARY KEY(author, source, record_key)) WITHOUT ROWID;CREATE TABLE IF NOT EXISTS list_records ( author TEXT NOT NULL REFERENCES soft_accounts(did) ON DELETE CASCADE, source TEXT NOT NULL, record_key TEXT NOT NULL, list_uri TEXT NOT NULL, subject TEXT NOT NULL DEFAULT '', purpose TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL, PRIMARY KEY(author, source, record_key)) WITHOUT ROWID;CREATE TABLE IF NOT EXISTS list_versions ( author TEXT NOT NULL REFERENCES soft_accounts(did) ON DELETE CASCADE, source TEXT NOT NULL, record_key TEXT NOT NULL, time_us INTEGER NOT NULL, PRIMARY KEY(author, source, record_key)) WITHOUT ROWID;CREATE TABLE IF NOT EXISTS list_snapshots ( list_uri TEXT PRIMARY KEY, owner TEXT NOT NULL REFERENCES soft_accounts(did) ON DELETE CASCADE, bootstrap_us INTEGER NOT NULL);CREATE TABLE IF NOT EXISTS list_bootstraps ( author TEXT PRIMARY KEY REFERENCES soft_accounts(did) ON DELETE CASCADE, bootstrap_us INTEGER NOT NULL);CREATE TABLE IF NOT EXISTS trust_cache ( cache_key TEXT PRIMARY KEY, result TEXT NOT NULL, expires_us INTEGER NOT NULL);CREATE TABLE IF NOT EXISTS trust_dependencies ( cache_key TEXT NOT NULL REFERENCES trust_cache(cache_key) ON DELETE CASCADE, author TEXT NOT NULL, record_key TEXT NOT NULL, source TEXT NOT NULL DEFAULT 'computer.ngp.provenance.vouch', PRIMARY KEY(cache_key, author, source, record_key));