[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","c82af890-8e94-11f0-8b25-0224a6c84d84","name","queries.ts","fileType","script","content","// Database query functions\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport type { Game, PieceType, Player, Piece, Turn, Move } from \"../../shared/types.ts\";\n\n// Game queries\nexport async function createGame(game: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO games (id, name, rules, manager_id, include_previous_move) \n VALUES (?, ?, ?, ?, ?)`,\n [game.id, game.name, game.rules, game.manager_id, game.include_previous_move]\n );\n}\n\nexport async function getGame(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM games WHERE id = ?`,\n [gameId]\n );\n return result.length > 0 ? result[0] as Game : null;\n}\n\nexport async function updateGameSettings(gameId: string, includePreviousMove: boolean): Promise {\n await sqlite.execute(\n `UPDATE games SET include_previous_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [includePreviousMove, gameId]\n );\n}\n\nexport async function gameExists(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM games WHERE id = ? LIMIT 1`,\n [gameId]\n );\n return result.length > 0;\n}\n\n// Piece type queries\nexport async function createPieceType(pieceType: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO piece_types (game_id, name, description) VALUES (?, ?, ?) RETURNING id`,\n [pieceType.game_id, pieceType.name, pieceType.description]\n );\n return result[0].id as number;\n}\n\nexport async function getPieceTypes(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result as PieceType[];\n}\n\nexport async function getPieceType(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types WHERE id = ?`,\n [id]\n );\n return result.length > 0 ? result[0] as PieceType : null;\n}\n\n// Player queries\nexport async function createPlayer(player: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO players (game_id, username) VALUES (?, ?)`,\n [player.game_id, player.username]\n );\n}\n\nexport async function getPlayers(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM players WHERE game_id = ? ORDER BY joined_at`,\n [gameId]\n );\n return result as Player[];\n}\n\nexport async function playerExists(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM players WHERE game_id = ? AND username = ? LIMIT 1`,\n [gameId, username]\n );\n return result.length > 0;\n}\n\n// Piece queries\nexport async function createPiece(piece: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO pieces (game_id, player_username, piece_type_id, instructions, last_move) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [piece.game_id, piece.player_username, piece.piece_type_id, piece.instructions, piece.last_move]\n );\n return result[0].id as number;\n}\n\nexport async function getPieces(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM pieces WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result as Piece[];\n}\n\nexport async function getPlayerPieces(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM pieces WHERE game_id = ? AND player_username = ? ORDER BY created_at`,\n [gameId, username]\n );\n return result as Piece[];\n}\n\nexport async function updatePieceInstructions(pieceId: number, instructions: string): Promise {\n await sqlite.execute(\n `UPDATE pieces SET instructions = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [instructions, pieceId]\n );\n}\n\nexport async function updatePieceLastMove(pieceId: number, lastMove: string): Promise {\n await sqlite.execute(\n `UPDATE pieces SET last_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [lastMove, pieceId]\n );\n}\n\n// Turn queries\nexport async function createTurn(turn: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO turns (game_id, initiated_by, photo_url, snapshot_data, status) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [turn.game_id, turn.initiated_by, turn.photo_url, turn.snapshot_data, turn.status]\n );\n return result[0].id as number;\n}\n\nexport async function updateTurnStatus(turnId: number, status: string): Promise {\n const completedAt = status === 'completed' ? 'CURRENT_TIMESTAMP' : 'NULL';\n await sqlite.execute(\n `UPDATE turns SET status = ?, completed_at = ${completedAt} WHERE id = ?`,\n [status, turnId]\n );\n}\n\nexport async function getLatestTurn(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM turns WHERE game_id = ? ORDER BY created_at DESC LIMIT 1`,\n [gameId]\n );\n return result.length > 0 ? result[0] as Turn : null;\n}\n\n// Move queries\nexport async function createMove(move: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO moves (turn_id, piece_id, thinking_process, final_move, status, error_message) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING id`,\n [move.turn_id, move.piece_id, move.thinking_process, move.final_move, move.status, move.error_message]\n );\n return result[0].id as number;\n}\n\nexport async function updateMove(moveId: number, thinkingProcess: string, finalMove: string, status: string, errorMessage?: string): Promise {\n await sqlite.execute(\n `UPDATE moves SET thinking_process = ?, final_move = ?, status = ?, error_message = ?, completed_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [thinkingProcess, finalMove, status, errorMessage || null, moveId]\n );\n}\n\nexport async function getTurnMoves(turnId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM moves WHERE turn_id = ? ORDER BY created_at`,\n [turnId]\n );\n return result as Move[];\n}\n\n// Complex queries for game state\nexport async function getGameSnapshot(gameId: string): Promise {\n const game = await getGame(gameId);\n const pieceTypes = await getPieceTypes(gameId);\n const pieces = await getPieces(gameId);\n \n return {\n game,\n pieceTypes,\n pieces\n };\n}\n\nexport async function getPieceWithTypeInfo(pieceId: number): Promise {\n const result = await sqlite.execute(`\n SELECT \n p.*,\n pt.name as piece_type_name,\n pt.description as piece_type_description\n FROM pieces p\n JOIN piece_types pt ON p.piece_type_id = pt.id\n WHERE p.id = ?\n `, [pieceId]);\n \n return result.length > 0 ? result[0] : null;\n}","createdAt",["D",1757543011284],"branchVersion","branchId","968f510e-8e8b-11f0-ac0b-0224a6c84d84","id","968ee85e-8e8b-11f0-ac0b-0224a6c84d84","cogs-clippies-1",["D",1757539062598],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","53f045b0-fcaa-11ef-9928-c9aafb5d50fa","pinnedFileId","ce62fa3c-8e94-11f0-867f-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","658b7c0d-aded-45be-b139-8952d52d1479","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",44,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","malcolmocean","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydTRFSlhQcUNYWnZFTjJHNURLendoUzgwbGwifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":222,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":223,"_79":224,"_81":225,"_83":24},"tree",[168,172,175,176],"files",[168,169,170,171,172,173,174,175,176],"counts",{"_158":61,"_159":133,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_26":157},{"_42":145,"_31":146,"_29":147,"_132":-5,"_40":41,"_39":148,"_134":57,"_37":149,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_26":151},{"_42":138,"_31":139,"_29":140,"_132":-5,"_40":41,"_39":141,"_134":57,"_37":142,"_13":61,"_33":20,"_35":143,"_23":24,"_136":-5,"_26":144},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":135,"_13":61,"_33":34,"_35":104,"_23":24,"_136":-5,"_26":137},"9691d6e0-8e8b-11f0-ac0b-0224a6c84d84","main.ts","9691d78a-8e8b-11f0-ac0b-0224a6c84d84","parentId",1,"latest",["D",1757539062614],"label",[130],"9d5d00e0-8e94-11f0-938c-0224a6c84d84","README.md","9d5d018a-8e94-11f0-938c-0224a6c84d84",2,["D",1757542939483],"# LLM Board Game Server\n\nA game-agnostic server that enables LLM-controlled pieces to play physical board games based on photos of the game state.\n\n## Features\n\n- **Game Management**: Create games with custom rules and piece types\n- **Multi-Player Support**: Multiple human players can join and control pieces\n- **LLM Integration**: Each piece is controlled by an independent LLM call\n- **Real-time Updates**: WebSocket-based live updates as moves are generated\n- **Photo-based State**: Uses multimodal LLMs to analyze board photos\n- **Human Arbitration**: No rule enforcement - humans resolve conflicts\n\n## Architecture\n\n### Backend (`/backend/`)\n- **Hono API server** with WebSocket support\n- **SQLite database** for game state persistence\n- **OpenAI Vision API** integration for board analysis\n- **Parallel LLM processing** for simultaneous piece moves\n\n### Frontend (`/frontend/`)\n- **Game creation and management** interface\n- **Player join and piece control** pages\n- **Real-time move display** with WebSocket updates\n- **Photo upload and turn processing**\n\n### Shared (`/shared/`)\n- **TypeScript types** for game data structures\n- **Utility functions** for ID generation and validation\n\n## URL Structure\n\n- `/` - Homepage with game creation\n- `/game/:gameid` - Join game page\n- `/game/:gameid/manage/:managerid` - Game management interface\n- `/game/:gameid/play/:username` - Player interface\n- `/game/:gameid/clone` - Clone game with same rules\n\n## Game Flow\n\n1. **Game Creation**: Manager sets up game rules and piece types\n2. **Player Join**: Players join with unique usernames\n3. **Piece Assignment**: Players create and configure their pieces\n4. **Turn Processing**: Photo upload triggers parallel LLM calls\n5. **Move Display**: Results stream in real-time via WebSockets\n6. **Human Arbitration**: Players interpret and apply moves manually\n\n## Technical Details\n\n- **Game IDs**: 5-character case-insensitive unique identifiers\n- **No Authentication**: Designed for small playtesting events\n- **Stateless LLMs**: Each turn uses only current board photo\n- **Conflict Resolution**: Handled entirely by human players\n- **Real-time Updates**: WebSocket-based live move streaming",[139],"a7c9feac-8e94-11f0-b86b-0224a6c84d84","shared","69da698d-0574-4adb-baa5-14fa8661c4d4",3,["D",1757542956972],"directory",[146],"b601e0de-8e94-11f0-9139-0224a6c84d84","backend","7eff5c05-c3d1-4053-9fd9-4417307376da",5,["D",1757542980823],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":219,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_178":220,"_26":221},{"_42":215,"_31":207,"_29":203,"_132":154,"_40":41,"_39":155,"_134":57,"_37":216,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_178":217,"_26":218},{"_42":208,"_31":209,"_29":210,"_132":203,"_40":41,"_39":155,"_134":57,"_37":211,"_13":61,"_33":34,"_35":212,"_23":24,"_136":-5,"_178":213,"_26":214},{"_42":202,"_31":32,"_29":30,"_132":203,"_40":41,"_39":14,"_134":24,"_37":204,"_13":61,"_33":34,"_35":36,"_23":24,"_136":-5,"_178":205,"_26":206},{"_42":145,"_31":146,"_29":147,"_132":-5,"_40":41,"_39":148,"_134":57,"_37":199,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_178":200,"_26":201},{"_42":192,"_31":193,"_29":194,"_132":147,"_40":41,"_39":148,"_134":57,"_37":195,"_13":61,"_33":34,"_35":196,"_23":24,"_136":-5,"_178":197,"_26":198},{"_42":184,"_31":185,"_29":186,"_132":147,"_40":41,"_39":187,"_134":57,"_37":188,"_13":61,"_33":34,"_35":189,"_23":24,"_136":-5,"_178":190,"_26":191},{"_42":138,"_31":139,"_29":140,"_132":-5,"_40":41,"_39":141,"_134":57,"_37":181,"_13":61,"_33":20,"_35":143,"_23":24,"_136":-5,"_178":182,"_26":183},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":177,"_13":61,"_33":34,"_35":104,"_23":24,"_136":-5,"_178":179,"_26":180},["D",1757539062614],"children",[],[130],["D",1757542939483],[],[139],"ae080e58-8e94-11f0-ae4a-0224a6c84d84","utils.ts","ae080f16-8e94-11f0-ae4a-0224a6c84d84",4,["D",1757542967448],"// Shared utility functions\n\n/**\n * Generate a random 5-character case-insensitive ID\n */\nexport function generateGameId(): string {\n const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';\n let result = '';\n for (let i = 0; i < 5; i++) {\n result += chars.charAt(Math.floor(Math.random() * chars.length));\n }\n return result;\n}\n\n/**\n * Validate username format (alphanumeric, no spaces)\n */\nexport function isValidUsername(username: string): boolean {\n return /^[a-zA-Z0-9]+$/.test(username) && username.length > 0 && username.length <= 20;\n}\n\n/**\n * Validate game ID format (5 characters, alphanumeric)\n */\nexport function isValidGameId(gameId: string): boolean {\n return /^[A-Z0-9]{5}$/i.test(gameId);\n}\n\n/**\n * Normalize game ID to uppercase\n */\nexport function normalizeGameId(gameId: string): string {\n return gameId.toUpperCase();\n}\n\n/**\n * Extract move description from LLM response\n */\nexport function extractMoveFromResponse(response: string): { thinking: string; move: string } {\n const moveMatch = response.match(/MOVE:\\s*(.+?)(?:\\n|$)/i);\n \n if (moveMatch) {\n const moveIndex = response.toLowerCase().indexOf('move:');\n const thinking = response.substring(0, moveIndex).trim();\n const move = moveMatch[1].trim();\n return { thinking, move };\n }\n \n // Fallback if no MOVE: found\n return {\n thinking: response,\n move: \"No specific move described\"\n };\n}\n\n/**\n * Create LLM prompt from context\n */\nexport function createLLMPrompt(context: any): string {\n let prompt = `You are playing as an autonomous piece in a board game. The rules of the board game are:\n> ${context.game_rules}\n\nYour piece is ${context.piece_name} and the description of your piece is:\n> ${context.piece_description}`;\n\n if (context.player_instructions) {\n prompt += `\\n\\nYour human player has given you these instructions:\n> ${context.player_instructions}`;\n }\n\n if (context.previous_move) {\n prompt += `\\n\\nYour previous move was:\n> ${context.previous_move}`;\n }\n\n prompt += `\\n\\nAttached is a photo of the board state.\n\nThink out loud as much as you want, then output MOVE: [description of all behavior your piece will perform this turn]`;\n\n return prompt;\n}",[],[146,185],"a7c9eff2-8e94-11f0-b86b-0224a6c84d84","types.ts","a7c9f0ba-8e94-11f0-b86b-0224a6c84d84",["D",1757542956972],"// Shared TypeScript types for the LLM Board Game Server\n\nexport interface Game {\n id: string; // 5-character case-insensitive ID\n name: string;\n rules: string;\n manager_id: string; // 5-character manager ID for /manage/ access\n include_previous_move: boolean; // Setting for piece memory\n created_at: string;\n updated_at: string;\n}\n\nexport interface PieceType {\n id: number;\n game_id: string;\n name: string; // e.g., \"red pawn\", \"black disc\"\n description: string; // Natural language description of abilities/personality\n created_at: string;\n}\n\nexport interface Player {\n id: number;\n game_id: string;\n username: string; // Alphanumeric, no spaces, unique per game\n joined_at: string;\n}\n\nexport interface Piece {\n id: number;\n game_id: string;\n player_username: string;\n piece_type_id: number;\n instructions: string; // Player's persistent instructions for this piece\n last_move: string | null; // Last successfully executed move (for memory)\n created_at: string;\n updated_at: string;\n}\n\nexport interface Turn {\n id: number;\n game_id: string;\n initiated_by: string; // Username who started the turn\n photo_url: string; // URL to uploaded photo\n snapshot_data: string; // JSON snapshot of game state at turn start\n status: 'processing' | 'completed' | 'error';\n created_at: string;\n completed_at: string | null;\n}\n\nexport interface Move {\n id: number;\n turn_id: number;\n piece_id: number;\n thinking_process: string; // LLM's \"think out loud\" portion\n final_move: string; // The MOVE: description\n status: 'pending' | 'completed' | 'error';\n error_message: string | null;\n created_at: string;\n completed_at: string | null;\n}\n\n// WebSocket message types\nexport interface WSMessage {\n type: 'move_update' | 'turn_started' | 'turn_completed' | 'error';\n data: any;\n}\n\nexport interface MoveUpdate {\n piece_id: number;\n piece_name: string;\n player_username: string;\n thinking_process: string;\n final_move: string;\n status: 'completed' | 'error';\n error_message?: string;\n}\n\n// API request/response types\nexport interface CreateGameRequest {\n game_name: string;\n game_rules: string;\n}\n\nexport interface CreateGameResponse {\n game_id: string;\n manager_id: string;\n game_url: string;\n manage_url: string;\n}\n\nexport interface CreatePieceTypeRequest {\n piece_name: string;\n piece_description: string;\n}\n\nexport interface JoinGameRequest {\n username: string;\n}\n\nexport interface CreatePieceRequest {\n piece_type_id: number;\n instructions: string;\n}\n\nexport interface UpdateInstructionsRequest {\n piece_id: number;\n instructions: string;\n}\n\nexport interface StartTurnRequest {\n photo: File | string; // File upload or base64 string\n}\n\n// LLM prompt context\nexport interface LLMPromptContext {\n game_rules: string;\n piece_name: string;\n piece_description: string;\n player_instructions: string;\n previous_move?: string; // Only included if include_previous_move is true\n photo_url: string;\n}",[],[146,193],["D",1757542956972],[173,174],[146],"c82af700-8e94-11f0-8b25-0224a6c84d84","f9e21dfc-0457-4939-8ae2-29354305b557",["D",1757543011284],[],[153,207,32],"database","b601d526-8e94-11f0-9139-0224a6c84d84","migrations.ts","b601d5da-8e94-11f0-9139-0224a6c84d84",["D",1757542980823],"// Database schema migrations for LLM Board Game Server\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nexport async function runMigrations() {\n // Games table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS games (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n rules TEXT NOT NULL,\n manager_id TEXT NOT NULL,\n include_previous_move BOOLEAN DEFAULT FALSE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Piece types table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS piece_types (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE\n )\n `);\n\n // Players table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS players (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n username TEXT NOT NULL,\n joined_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE,\n UNIQUE (game_id, username)\n )\n `);\n\n // Pieces table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS pieces (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n player_username TEXT NOT NULL,\n piece_type_id INTEGER NOT NULL,\n instructions TEXT DEFAULT '',\n last_move TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE,\n FOREIGN KEY (piece_type_id) REFERENCES piece_types (id) ON DELETE CASCADE,\n FOREIGN KEY (game_id, player_username) REFERENCES players (game_id, username) ON DELETE CASCADE\n )\n `);\n\n // Turns table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS turns (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n game_id TEXT NOT NULL,\n initiated_by TEXT NOT NULL,\n photo_url TEXT NOT NULL,\n snapshot_data TEXT NOT NULL,\n status TEXT DEFAULT 'processing',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (game_id) REFERENCES games (id) ON DELETE CASCADE\n )\n `);\n\n // Moves table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS moves (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n turn_id INTEGER NOT NULL,\n piece_id INTEGER NOT NULL,\n thinking_process TEXT DEFAULT '',\n final_move TEXT DEFAULT '',\n status TEXT DEFAULT 'pending',\n error_message TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (turn_id) REFERENCES turns (id) ON DELETE CASCADE,\n FOREIGN KEY (piece_id) REFERENCES pieces (id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_games_id ON games (id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_piece_types_game_id ON piece_types (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_players_game_id ON players (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_pieces_game_id ON pieces (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_pieces_player ON pieces (game_id, player_username)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_turns_game_id ON turns (game_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_moves_turn_id ON moves (turn_id)`);\n\n console.log(\"Database migrations completed successfully\");\n}",[],[153,207,209],"b601e264-8e94-11f0-9139-0224a6c84d84",["D",1757542980823],[170,171],[153,207],["D",1757542980823],[169],[153],["D",1757539062598],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":259,"_260":261,"_262":263,"_264":24,"_265":24,"_266":24,"_267":57,"_268":-5,"_269":-7,"_270":-7,"_271":61,"_272":24,"_273":24,"_274":-5,"_275":24,"_276":24,"_277":24,"_278":-5},"ENV",{"_230":231,"_232":233,"_234":85,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6