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.
Something went wrong. Try again.
694 B · 21 lines
SQL
at master
12345678910111213141516171819202122CREATE TABLE games ( id TEXT PRIMARY KEY, rkey TEXT NOT NULL, creator_did TEXT NOT NULL, player_one TEXT NOT NULL, player_two TEXT, board_size INTEGER NOT NULL DEFAULT 19, status TEXT NOT NULL CHECK(status IN ('waiting', 'active', 'completed')), action_count INTEGER NOT NULL DEFAULT 0, last_action_type TEXT, winner TEXT, handicap INTEGER DEFAULT 0, created_at TEXT NOT NULL, updated_at TEXT NOT NULL);
CREATE INDEX idx_games_status ON games(status);CREATE INDEX idx_games_player_one ON games(player_one);CREATE INDEX idx_games_player_two ON games(player_two);CREATE INDEX idx_games_rkey ON games(rkey);CREATE INDEX idx_games_creator_did ON games(creator_did);