Tahinli/forge

public

0 watching

★ 0

589 bytes

1	-- Profile: about text, IANA timezone, and avatars stored in the database. Applied by
2	-- store/migrate.rs. Existing users get about = '' and timezone = 'UTC'.
3
4	ALTER TABLE users ADD COLUMN about TEXT NOT NULL DEFAULT '';
5	ALTER TABLE users ADD COLUMN timezone TEXT NOT NULL DEFAULT 'UTC';
6
7	CREATE TABLE avatars (
8	user_id TEXT PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
9	data BLOB NOT NULL, -- re-encoded PNG, 256x256
10	hash TEXT NOT NULL, -- hex sha256 of data (first 16 chars), used as ETag and as ?v=
11	updated_at TEXT NOT NULL
12	);