goose.art
extremely claude-assisted go game based on atproto! working on cleaning up and giving a more unique design, still has a bit of a slop vibe to it.
1CREATE TABLE games (
2 id TEXT PRIMARY KEY,
3 rkey TEXT NOT NULL,
4 creator_did TEXT NOT NULL,
5 player_one TEXT NOT NULL,
6 player_two TEXT,
7 board_size INTEGER NOT NULL DEFAULT 19,
8 status TEXT NOT NULL CHECK(status IN ('waiting', 'active', 'completed')),
9 action_count INTEGER NOT NULL DEFAULT 0,
10 last_action_type TEXT,
11 winner TEXT,
12 handicap INTEGER DEFAULT 0,
13 created_at TEXT NOT NULL,
14 updated_at TEXT NOT NULL
15);
16
17CREATE INDEX idx_games_status ON games(status);
18CREATE INDEX idx_games_player_one ON games(player_one);
19CREATE INDEX idx_games_player_two ON games(player_two);
20CREATE INDEX idx_games_rkey ON games(rkey);
21CREATE INDEX idx_games_creator_did ON games(creator_did);