max / makenotwork

314 B · 7 lines History Blame Raw

1	-- When a creator with purchased content deletes their account, we keep
2	-- their items accessible for 90 days so buyers can download their files.
3	-- After content_removal_at passes, the scheduler removes S3 objects and
4	-- CASCADE-deletes the user row.
5
6	ALTER TABLE users ADD COLUMN content_removal_at TIMESTAMPTZ;
7