max / makenotwork

420 B · 12 lines History Blame Raw

1	CREATE TABLE IF NOT EXISTS pending_s3_deletions (
2	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
3	s3_key TEXT NOT NULL,
4	bucket TEXT NOT NULL DEFAULT 'main',
5	source TEXT NOT NULL,
6	created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
7	attempts INT NOT NULL DEFAULT 0,
8	last_attempted_at TIMESTAMPTZ
9	);
10
11	CREATE INDEX IF NOT EXISTS idx_pending_s3_deletions_created_at ON pending_s3_deletions(created_at);
12