ambee/giterated

Base protocol refactor complete

View files Patch

Amber - ⁨2⁩ years ago

parent: tbd commit: ⁨079d544⁩

⁨giterated-daemon/migrations/20230913232625_user_metadata.sql⁩ - ⁨470⁩ bytes

Raw

1	CREATE TABLE IF NOT EXISTS user_metadata
2	(
3	username TEXT NOT NULL,
4	name TEXT NOT NULL,
5	value TEXT NOT NULL
6	);
7
8	CREATE UNIQUE INDEX unique_per_user_metadata ON user_metadata (username, name);
9
10	CREATE TABLE IF NOT EXISTS user_settings
11	(
12	username TEXT NOT NULL,
13	name TEXT NOT NULL,
14	value TEXT NOT NULL
15	);
16
17	CREATE UNIQUE INDEX unique_per_user_settings ON user_settings (username, name);