Something went wrong. Try again.
An ATProto Powered Reputation Network
Something went wrong. Try again.
758 B · 15 lines
SQL
at master
12345678910111213141516ALTER TABLE vouches ADD COLUMN source TEXT NOT NULL DEFAULT 'computer.ngp.provenance.vouch';DROP TRIGGER IF EXISTS trust_vouch_delete;DROP TRIGGER IF EXISTS trust_vouch_update;DROP INDEX IF EXISTS trust_dependencies_vouch;ALTER TABLE trust_dependencies RENAME TO legacy_trust_dependencies;CREATE TABLE 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));INSERT INTO trust_dependencies(cache_key, author, record_key)SELECT cache_key, author, record_key FROM legacy_trust_dependencies;DROP TABLE legacy_trust_dependencies;