max / makenotwork

343 B · 7 lines History Blame Raw

1	-- Generation counters for ETag-based HTTP caching.
2	-- Bumped on any write that changes user-visible data.
3	-- Tab handlers check generation before rendering; clients get 304 on unchanged data.
4
5	ALTER TABLE users ADD COLUMN cache_generation BIGINT NOT NULL DEFAULT 0;
6	ALTER TABLE projects ADD COLUMN cache_generation BIGINT NOT NULL DEFAULT 0;
7