foxwitch.net
forked from
tranquil.farm/tranquil-pds
Our Personal Data Server from scratch!
578 B
15 lines
1ALTER TABLE users ADD COLUMN backup_enabled BOOLEAN NOT NULL DEFAULT TRUE;
2
3CREATE TABLE account_backups (
4 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
5 user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
6 storage_key TEXT NOT NULL,
7 repo_root_cid TEXT NOT NULL,
8 repo_rev TEXT NOT NULL,
9 block_count INT NOT NULL,
10 size_bytes BIGINT NOT NULL,
11 created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
12);
13
14CREATE INDEX idx_account_backups_user_id ON account_backups(user_id);
15CREATE INDEX idx_account_backups_created_at ON account_backups(created_at);