[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_319":320,"_321":322},"routes/_app.x.$handle.$name",{"_101":100,"_32":49,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_21":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":63,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",18,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","73021414-5f1c-4084-8d32-2442eaba72c6","name","fileType","directory","content","createdAt",["D",1748850573997],"branchVersion","branchId","96238d58-3f84-11f0-b0be-76b3cceeab13",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"frontend/index.html","1fcb9ff4-3f86-11f0-841e-76b3cceeab13","index.html","\n\n\n \n \n Lost Cars Finder - Help Reunite Stolen Vehicles\n \n \n \n\n\n

\n \n \n\n",["D",1748850573997],"id","962348fc-3f84-11f0-b0be-76b3cceeab13","FindMyCar",["D",1748849913559],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","VehiclesFinder","imageUrl","defccae0-3f83-11f0-ad5b-814c56c8abb0","pinnedFileId","2dc95f68-3f9c-11f0-9808-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d0808b00-181f-4bcb-ac9d-1d1a3c21ac29","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_47":40,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"isOwned",89,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Sarax201","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d1dOeGY5REVGZU1uNWZSang1R1hiaFBqVyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":315,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":316,"_85":317,"_87":318,"_89":25},"tree",[195,205,207,209,210,211,212],"files",[195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212],"counts",{"_185":67,"_186":160,"_187":160,"_188":189,"_190":191},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":179,"_32":180,"_30":181,"_141":-5,"_39":40,"_38":182,"_143":63,"_36":183,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_27":184},{"_47":176,"_32":28,"_30":31,"_141":-5,"_39":40,"_38":14,"_143":63,"_36":177,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_27":178},{"_47":170,"_32":171,"_30":172,"_141":-5,"_39":40,"_38":173,"_143":63,"_36":174,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_27":175},{"_47":163,"_32":164,"_30":165,"_141":-5,"_39":40,"_38":166,"_143":25,"_36":167,"_13":160,"_33":21,"_35":168,"_24":25,"_148":-5,"_27":169},{"_47":157,"_32":158,"_30":159,"_141":-5,"_39":40,"_38":160,"_143":25,"_36":161,"_13":67,"_33":155,"_35":110,"_24":25,"_148":-5,"_27":162},{"_47":150,"_32":151,"_30":152,"_141":-5,"_39":40,"_38":153,"_143":25,"_36":154,"_13":67,"_33":155,"_35":110,"_24":25,"_148":-5,"_27":156},{"_47":138,"_32":139,"_30":140,"_141":-5,"_39":40,"_38":142,"_143":25,"_36":144,"_13":145,"_33":146,"_35":147,"_24":25,"_148":-5,"_27":149},"fa874612-3f85-11f0-923d-76b3cceeab13","new-file-2641.tsx","f41e5aae-3f85-11f0-9da0-76b3cceeab13","parentId",14,"latest",["D",1748850511477],2,"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","label",[139],"f2f9e508-3f85-11f0-a786-76b3cceeab13","new-file-1680.tsx","f2f9e5c6-3f85-11f0-a786-76b3cceeab13",10,["D",1748850498809],"script",[151],"96252172-3f84-11f0-b0be-76b3cceeab13","main.tsx","96252226-3f84-11f0-b0be-76b3cceeab13",1,["D",1748849913568],[158],"5b8c154c-3f85-11f0-b83d-76b3cceeab13","README.md","eb5327ca-3f84-11f0-af7d-76b3cceeab13",5,["D",1748850244745],"# Lost Cars Finder App\n\nA comprehensive app to help reunite stolen vehicles with their owners.\n\n## Features\n\n### For Car Owners\n- Report stolen vehicles with detailed information\n- View reports of found cars that might match\n- Contact system when someone finds their car\n\n### For Good Samaritans\n- Report found/suspicious vehicles with photos\n- Add location, license plate, and vehicle details\n- Help reunite cars with owners\n\n### Core Functionality\n- Photo upload for found vehicles\n- Location tracking with maps\n- Search and filter system\n- Secure contact system\n- Mobile-responsive design\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server\n│ ├── database/\n│ │ ├── schema.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ ├── stolen.ts # Stolen car reports\n│ ├── found.ts # Found car reports\n│ └── matches.ts # Matching system\n├── frontend/\n│ ├── index.html # Main page\n│ ├── components/\n│ │ ├── App.tsx # Main React app\n│ │ ├── ReportStolen.tsx\n│ │ ├── ReportFound.tsx\n│ │ ├── CarList.tsx\n│ │ └── CarMap.tsx\n│ └── style.css\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The app runs on `/backend/index.ts` as an HTTP val\n2. Visit the main page to start reporting or searching for cars\n3. Use the map view to see locations of reported vehicles\n\n## Database\n\nUses SQLite with tables for:\n- `stolen_cars` - Reports from car owners\n- `found_cars` - Reports from people who found vehicles\n- `matches` - Potential matches between stolen and found cars",[164],"efb773d4-3f84-11f0-a1f4-76b3cceeab13","shared","d0f372b1-a8f7-4978-b98a-109430d74356",3,["D",1748850063838],[171],"1fcba7e2-3f86-11f0-841e-76b3cceeab13",["D",1748850573997],[28],"f4bc9b34-3f84-11f0-917f-76b3cceeab13","backend","af436097-5c4b-4ae1-9232-154369ce0aba",4,["D",1748850072260],[180],"pulls","branches","forks","envVars",{"_192":67,"_194":67},"connections",{"_192":67,"_193":67},"count","unfilledCount","emptyCount",{"_47":179,"_32":180,"_30":181,"_141":-5,"_39":40,"_38":182,"_143":63,"_36":312,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_214":313,"_27":314},{"_47":308,"_32":299,"_30":293,"_141":181,"_39":40,"_38":182,"_143":63,"_36":309,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_214":310,"_27":311},{"_47":300,"_32":301,"_30":302,"_141":293,"_39":40,"_38":303,"_143":25,"_36":304,"_13":160,"_33":155,"_35":305,"_24":25,"_148":-5,"_214":306,"_27":307},{"_47":290,"_32":291,"_30":292,"_141":293,"_39":40,"_38":294,"_143":25,"_36":295,"_13":67,"_33":155,"_35":296,"_24":25,"_148":-5,"_214":297,"_27":298},{"_47":286,"_32":261,"_30":255,"_141":181,"_39":40,"_38":256,"_143":63,"_36":287,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_214":288,"_27":289},{"_47":278,"_32":279,"_30":280,"_141":255,"_39":40,"_38":281,"_143":63,"_36":282,"_13":67,"_33":155,"_35":283,"_24":25,"_148":-5,"_214":284,"_27":285},{"_47":270,"_32":271,"_30":272,"_141":255,"_39":40,"_38":273,"_143":63,"_36":274,"_13":67,"_33":155,"_35":275,"_24":25,"_148":-5,"_214":276,"_27":277},{"_47":262,"_32":263,"_30":264,"_141":255,"_39":40,"_38":265,"_143":63,"_36":266,"_13":67,"_33":155,"_35":267,"_24":25,"_148":-5,"_214":268,"_27":269},{"_47":252,"_32":253,"_30":254,"_141":255,"_39":40,"_38":256,"_143":63,"_36":257,"_13":67,"_33":155,"_35":258,"_24":25,"_148":-5,"_214":259,"_27":260},{"_47":244,"_32":245,"_30":246,"_141":181,"_39":40,"_38":247,"_143":25,"_36":248,"_13":67,"_33":155,"_35":249,"_24":25,"_148":-5,"_214":250,"_27":251},{"_47":176,"_32":28,"_30":31,"_141":-5,"_39":40,"_38":14,"_143":63,"_36":241,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_214":242,"_27":243},{"_47":237,"_32":44,"_30":43,"_141":31,"_39":40,"_38":14,"_143":63,"_36":238,"_13":67,"_33":21,"_35":45,"_24":25,"_148":-5,"_214":239,"_27":240},{"_47":170,"_32":171,"_30":172,"_141":-5,"_39":40,"_38":173,"_143":63,"_36":234,"_13":67,"_33":34,"_35":-5,"_24":25,"_148":-5,"_214":235,"_27":236},{"_47":226,"_32":227,"_30":228,"_141":172,"_39":40,"_38":229,"_143":63,"_36":230,"_13":160,"_33":155,"_35":231,"_24":25,"_148":-5,"_214":232,"_27":233},{"_47":163,"_32":164,"_30":165,"_141":-5,"_39":40,"_38":166,"_143":25,"_36":223,"_13":160,"_33":21,"_35":168,"_24":25,"_148":-5,"_214":224,"_27":225},{"_47":157,"_32":158,"_30":159,"_141":-5,"_39":40,"_38":160,"_143":25,"_36":220,"_13":67,"_33":155,"_35":110,"_24":25,"_148":-5,"_214":221,"_27":222},{"_47":150,"_32":151,"_30":152,"_141":-5,"_39":40,"_38":153,"_143":25,"_36":217,"_13":67,"_33":155,"_35":110,"_24":25,"_148":-5,"_214":218,"_27":219},{"_47":138,"_32":139,"_30":140,"_141":-5,"_39":40,"_38":142,"_143":25,"_36":213,"_13":145,"_33":146,"_35":147,"_24":25,"_148":-5,"_214":215,"_27":216},["D",1748850511477],"children",[],[139],["D",1748850498809],[],[151],["D",1748849913568],[],[158],["D",1748850244745],[],[164],"765053ca-3f85-11f0-948f-76b3cceeab13","types.ts","efb76b82-3f84-11f0-a1f4-76b3cceeab13",6,["D",1748850289651],"// Shared types for the Lost Cars Finder app\n\nexport interface StolenCar {\n id?: number;\n make: string;\n model: string;\n year: number;\n color: string;\n license_plate: string;\n vin?: string;\n description?: string;\n stolen_date: string;\n stolen_location: string;\n stolen_lat?: number;\n stolen_lng?: number;\n owner_name: string;\n owner_phone: string;\n owner_email: string;\n police_report_number?: string;\n created_at?: string;\n status: 'active' | 'found' | 'resolved';\n}\n\nexport interface FoundCar {\n id?: number;\n make?: string;\n model?: string;\n year?: number;\n color: string;\n license_plate?: string;\n description: string;\n found_date: string;\n found_location: string;\n found_lat?: number;\n found_lng?: number;\n photo_url?: string;\n reporter_name: string;\n reporter_phone: string;\n reporter_email: string;\n created_at?: string;\n status: 'active' | 'matched' | 'resolved';\n}\n\nexport interface CarMatch {\n id?: number;\n stolen_car_id: number;\n found_car_id: number;\n match_score: number;\n match_reasons: string[];\n created_at?: string;\n status: 'pending' | 'confirmed' | 'rejected';\n}\n\nexport interface Location {\n lat: number;\n lng: number;\n address?: string;\n}\n\nexport interface SearchFilters {\n make?: string;\n model?: string;\n color?: string;\n license_plate?: string;\n location?: string;\n date_from?: string;\n date_to?: string;\n type?: 'stolen' | 'found' | 'all';\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n message?: string;\n}",[],[171,227],["D",1748850063838],[208],[171],"1fcb9e00-3f86-11f0-841e-76b3cceeab13",["D",1748850573997],[],[28,44],["D",1748850573997],[206],[28],"19ad4e7e-3f86-11f0-84dc-76b3cceeab13","index.ts","19ad4f96-3f86-11f0-84dc-76b3cceeab13",17,["D",1748850563737],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createTables } from \"./database/migrations.ts\";\n\n// Import route modules\nimport stolenRoutes from \"./routes/stolen.ts\";\nimport foundRoutes from \"./routes/found.ts\";\nimport matchRoutes from \"./routes/matches.ts\";\nimport searchRoutes from \"./routes/search.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait createTables();\n\n// API Routes\napp.route(\"/api/stolen\", stolenRoutes);\napp.route(\"/api/found\", foundRoutes);\napp.route(\"/api/matches\", matchRoutes);\napp.route(\"/api/search\", searchRoutes);\n\n// Health check endpoint\napp.get(\"/api/health\", (c) => {\n return c.json({ \n status: \"healthy\", \n timestamp: new Date().toISOString(),\n service: \"Lost Cars Finder API\"\n });\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial data to avoid extra round-trips\n const initialData = {\n timestamp: new Date().toISOString(),\n apiBase: \"/api\"\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.html(`\n \n \n \n Lost Cars Finder\n \n \n \n \n \n

🚗 Lost Cars Finder

Help reunite stolen vehicles with their owners

Frontend not found

The frontend files are being created. Please refresh in a moment.

\n API is running at /api - \n Check health\n

\n \n \n `);\n }\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({ \n success: false, \n error: \"Endpoint not found\",\n available_endpoints: [\n \"GET /api/health\",\n \"GET /api/stolen\",\n \"POST /api/stolen\",\n \"GET /api/found\", \n \"POST /api/found\",\n \"GET /api/matches\",\n \"GET /api/search\"\n ]\n }, 404);\n});\n\nexport default app;",[],[180,245],"e53b04f6-3f85-11f0-b014-76b3cceeab13","stolen.ts","e53b058c-3f85-11f0-b014-76b3cceeab13","3504feee-a91e-470b-a5ed-d57a41f7ab5c",9,["D",1748850475745],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { StolenCar, ApiResponse } from \"../../shared/types.ts\";\nimport { \n createStolenCarReport, \n getStolenCars, \n getStolenCarById, \n updateStolenCarStatus \n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all stolen cars with optional filters\napp.get(\"/\", async (c) => {\n try {\n const filters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n );\n\n const cars = await getStolenCars(Object.keys(cleanFilters).length > 0 ? cleanFilters : undefined);\n \n const response: ApiResponse = {\n success: true,\n data: cars\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get specific stolen car by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const car = await getStolenCarById(id);\n if (!car) {\n const response: ApiResponse = {\n success: false,\n error: \"Stolen car not found\"\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: car\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new stolen car report\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as StolenCar;\n \n // Validate required fields\n const requiredFields = ['make', 'model', 'year', 'color', 'license_plate', 'stolen_date', 'stolen_location', 'owner_name', 'owner_phone', 'owner_email'];\n const missingFields = requiredFields.filter(field => !body[field as keyof StolenCar]);\n \n if (missingFields.length > 0) {\n const response: ApiResponse = {\n success: false,\n error: `Missing required fields: ${missingFields.join(', ')}`\n };\n return c.json(response, 400);\n }\n\n // Set default status if not provided\n if (!body.status) {\n body.status = 'active';\n }\n\n const carId = await createStolenCarReport(body);\n const createdCar = await getStolenCarById(carId);\n \n const response: ApiResponse = {\n success: true,\n data: createdCar!,\n message: \"Stolen car report created successfully\"\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update stolen car status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['active', 'found', 'resolved'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'active', 'found', or 'resolved'\"\n };\n return c.json(response, 400);\n }\n\n // Check if car exists\n const existingCar = await getStolenCarById(id);\n if (!existingCar) {\n const response: ApiResponse = {\n success: false,\n error: \"Stolen car not found\"\n };\n return c.json(response, 404);\n }\n\n await updateStolenCarStatus(id, status);\n const updatedCar = await getStolenCarById(id);\n \n const response: ApiResponse = {\n success: true,\n data: updatedCar!,\n message: \"Status updated successfully\"\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[180,261,253],"routes","0edd9738-3f86-11f0-ad8b-76b3cceeab13","search.ts","0edd9814-3f86-11f0-ad8b-76b3cceeab13",16,["D",1748850545599],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { SearchFilters, ApiResponse } from \"../../shared/types.ts\";\nimport { searchAllCars } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Search across both stolen and found cars\napp.get(\"/\", async (c) => {\n try {\n const filters: SearchFilters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n location: c.req.query(\"location\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n type: c.req.query(\"type\") as 'stolen' | 'found' | 'all' | undefined,\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n ) as SearchFilters;\n\n const results = await searchAllCars(cleanFilters);\n \n const response: ApiResponse = {\n success: true,\n data: {\n ...results,\n total_stolen: results.stolen.length,\n total_found: results.found.length,\n total_results: results.stolen.length + results.found.length\n }\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get search suggestions based on existing data\napp.get(\"/suggestions\", async (c) => {\n try {\n const field = c.req.query(\"field\");\n const query = c.req.query(\"q\")?.toLowerCase() || \"\";\n\n if (!field || !['make', 'model', 'color'].includes(field)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid field. Must be 'make', 'model', or 'color'\"\n };\n return c.json(response, 400);\n }\n\n // This is a simplified suggestion system\n // In a real app, you'd query the database for unique values\n const suggestions: Record = {\n make: [\n 'Toyota', 'Honda', 'Ford', 'Chevrolet', 'Nissan', 'BMW', 'Mercedes-Benz',\n 'Audi', 'Volkswagen', 'Hyundai', 'Kia', 'Mazda', 'Subaru', 'Lexus',\n 'Acura', 'Infiniti', 'Cadillac', 'Lincoln', 'Buick', 'GMC'\n ],\n model: [\n 'Camry', 'Corolla', 'Civic', 'Accord', 'F-150', 'Silverado', 'Altima',\n 'Sentra', 'Malibu', 'Cruze', 'Elantra', 'Sonata', 'Optima', 'CX-5',\n 'Outback', 'Forester', 'ES', 'RX', 'TLX', 'Q50'\n ],\n color: [\n 'White', 'Black', 'Silver', 'Gray', 'Red', 'Blue', 'Green', 'Yellow',\n 'Orange', 'Purple', 'Brown', 'Gold', 'Beige', 'Maroon', 'Navy'\n ]\n };\n\n const filtered = suggestions[field].filter(item => \n item.toLowerCase().includes(query)\n ).slice(0, 10);\n \n const response: ApiResponse = {\n success: true,\n data: filtered\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[180,261,263],"0320cfc8-3f86-11f0-989c-76b3cceeab13","matches.ts","0320d068-3f86-11f0-989c-76b3cceeab13",15,["D",1748850525906],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { CarMatch, ApiResponse } from \"../../shared/types.ts\";\nimport { \n getMatches, \n updateMatchStatus,\n getStolenCarById,\n getFoundCarById,\n updateStolenCarStatus,\n updateFoundCarStatus\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all matches with optional filters\napp.get(\"/\", async (c) => {\n try {\n const stolenCarId = c.req.query(\"stolen_car_id\");\n const foundCarId = c.req.query(\"found_car_id\");\n\n const matches = await getMatches(\n stolenCarId ? parseInt(stolenCarId) : undefined,\n foundCarId ? parseInt(foundCarId) : undefined\n );\n \n // Enrich matches with car details\n const enrichedMatches = await Promise.all(\n matches.map(async (match) => {\n const [stolenCar, foundCar] = await Promise.all([\n getStolenCarById(match.stolen_car_id),\n getFoundCarById(match.found_car_id)\n ]);\n \n return {\n ...match,\n stolen_car: stolenCar,\n found_car: foundCar\n };\n })\n );\n \n const response: ApiResponse = {\n success: true,\n data: enrichedMatches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update match status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid match ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['pending', 'confirmed', 'rejected'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'pending', 'confirmed', or 'rejected'\"\n };\n return c.json(response, 400);\n }\n\n // Get the match to update related cars\n const matches = await getMatches();\n const match = matches.find(m => m.id === id);\n \n if (!match) {\n const response: ApiResponse = {\n success: false,\n error: \"Match not found\"\n };\n return c.json(response, 404);\n }\n\n await updateMatchStatus(id, status);\n \n // If confirmed, update both car statuses\n if (status === 'confirmed') {\n await updateStolenCarStatus(match.stolen_car_id, 'found');\n await updateFoundCarStatus(match.found_car_id, 'matched');\n }\n \n const response: ApiResponse = {\n success: true,\n message: `Match status updated to ${status}${status === 'confirmed' ? '. Car owners have been notified.' : ''}`\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get matches for a specific stolen car\napp.get(\"/stolen/:stolenCarId\", async (c) => {\n try {\n const stolenCarId = parseInt(c.req.param(\"stolenCarId\"));\n if (isNaN(stolenCarId)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid stolen car ID\"\n };\n return c.json(response, 400);\n }\n\n const matches = await getMatches(stolenCarId);\n \n // Enrich with found car details\n const enrichedMatches = await Promise.all(\n matches.map(async (match) => {\n const foundCar = await getFoundCarById(match.found_car_id);\n return {\n ...match,\n found_car: foundCar\n };\n })\n );\n \n const response: ApiResponse = {\n success: true,\n data: enrichedMatches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get matches for a specific found car\napp.get(\"/found/:foundCarId\", async (c) => {\n try {\n const foundCarId = parseInt(c.req.param(\"foundCarId\"));\n if (isNaN(foundCarId)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid found car ID\"\n };\n return c.json(response, 400);\n }\n\n const matches = await getMatches(undefined, foundCarId);\n \n // Enrich with stolen car details\n const enrichedMatches = await Promise.all(\n matches.map(async (match) => {\n const stolenCar = await getStolenCarById(match.stolen_car_id);\n return {\n ...match,\n stolen_car: stolenCar\n };\n })\n );\n \n const response: ApiResponse = {\n success: true,\n data: enrichedMatches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[180,261,271],"f555d956-3f85-11f0-958a-76b3cceeab13","found.ts","f555da00-3f85-11f0-958a-76b3cceeab13",12,["D",1748850502763],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { FoundCar, ApiResponse } from \"../../shared/types.ts\";\nimport { \n createFoundCarReport, \n getFoundCars, \n getFoundCarById, \n updateFoundCarStatus,\n findPotentialMatches,\n createMatch\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all found cars with optional filters\napp.get(\"/\", async (c) => {\n try {\n const filters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n );\n\n const cars = await getFoundCars(Object.keys(cleanFilters).length > 0 ? cleanFilters : undefined);\n \n const response: ApiResponse = {\n success: true,\n data: cars\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get specific found car by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const car = await getFoundCarById(id);\n if (!car) {\n const response: ApiResponse = {\n success: false,\n error: \"Found car not found\"\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: car\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new found car report\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as FoundCar;\n \n // Validate required fields\n const requiredFields = ['color', 'description', 'found_date', 'found_location', 'reporter_name', 'reporter_phone', 'reporter_email'];\n const missingFields = requiredFields.filter(field => !body[field as keyof FoundCar]);\n \n if (missingFields.length > 0) {\n const response: ApiResponse = {\n success: false,\n error: `Missing required fields: ${missingFields.join(', ')}`\n };\n return c.json(response, 400);\n }\n\n // Set default status if not provided\n if (!body.status) {\n body.status = 'active';\n }\n\n const carId = await createFoundCarReport(body);\n const createdCar = await getFoundCarById(carId);\n \n // Automatically check for potential matches\n const potentialMatches = await findPotentialMatches(carId);\n \n // Create match records for potential matches\n for (const match of potentialMatches) {\n const matchReasons: string[] = [];\n let matchScore = 0;\n\n // Calculate match score and reasons\n if (body.license_plate && body.license_plate.toLowerCase() === match.license_plate.toLowerCase()) {\n matchReasons.push(\"Exact license plate match\");\n matchScore += 100;\n }\n \n if (body.make && body.make.toLowerCase() === match.make.toLowerCase()) {\n matchReasons.push(\"Make matches\");\n matchScore += 20;\n }\n \n if (body.model && body.model.toLowerCase() === match.model.toLowerCase()) {\n matchReasons.push(\"Model matches\");\n matchScore += 20;\n }\n \n if (body.color && body.color.toLowerCase() === match.color.toLowerCase()) {\n matchReasons.push(\"Color matches\");\n matchScore += 15;\n }\n \n if (body.year && body.year === match.year) {\n matchReasons.push(\"Year matches\");\n matchScore += 10;\n }\n\n if (matchScore > 0) {\n await createMatch({\n stolen_car_id: match.id!,\n found_car_id: carId,\n match_score: matchScore,\n match_reasons: matchReasons,\n status: 'pending'\n });\n }\n }\n \n const response: ApiResponse = {\n success: true,\n data: createdCar!,\n message: `Found car report created successfully. ${potentialMatches.length} potential matches found.`\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update found car status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['active', 'matched', 'resolved'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'active', 'matched', or 'resolved'\"\n };\n return c.json(response, 400);\n }\n\n // Check if car exists\n const existingCar = await getFoundCarById(id);\n if (!existingCar) {\n const response: ApiResponse = {\n success: false,\n error: \"Found car not found\"\n };\n return c.json(response, 404);\n }\n\n await updateFoundCarStatus(id, status);\n const updatedCar = await getFoundCarById(id);\n \n const response: ApiResponse = {\n success: true,\n data: updatedCar!,\n message: \"Status updated successfully\"\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get potential matches for a found car\napp.get(\"/:id/matches\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const matches = await findPotentialMatches(id);\n \n const response: ApiResponse = {\n success: true,\n data: matches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[180,261,279],"e53b0f14-3f85-11f0-b014-76b3cceeab13",["D",1748850475745],[200,201,202,203],[180,261],"d93303ca-3f85-11f0-ad4a-76b3cceeab13","queries.ts","d9330492-3f85-11f0-ad4a-76b3cceeab13","15b4017d-7886-4af1-a52e-f6d95b64fdf9",8,["D",1748850455562],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { STOLEN_CARS_TABLE, FOUND_CARS_TABLE, MATCHES_TABLE } from \"./migrations.ts\";\nimport type { StolenCar, FoundCar, CarMatch, SearchFilters } from \"../../shared/types.ts\";\n\n// Stolen Cars Queries\nexport async function createStolenCarReport(car: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${STOLEN_CARS_TABLE} (\n make, model, year, color, license_plate, vin, description,\n stolen_date, stolen_location, stolen_lat, stolen_lng,\n owner_name, owner_phone, owner_email, police_report_number, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n car.make, car.model, car.year, car.color, car.license_plate, car.vin, car.description,\n car.stolen_date, car.stolen_location, car.stolen_lat, car.stolen_lng,\n car.owner_name, car.owner_phone, car.owner_email, car.police_report_number, car.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getStolenCars(filters?: SearchFilters): Promise {\n let query = `SELECT * FROM ${STOLEN_CARS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.make) {\n query += ` AND LOWER(make) LIKE LOWER(?)`;\n params.push(`%${filters.make}%`);\n }\n if (filters?.model) {\n query += ` AND LOWER(model) LIKE LOWER(?)`;\n params.push(`%${filters.model}%`);\n }\n if (filters?.color) {\n query += ` AND LOWER(color) LIKE LOWER(?)`;\n params.push(`%${filters.color}%`);\n }\n if (filters?.license_plate) {\n query += ` AND LOWER(license_plate) LIKE LOWER(?)`;\n params.push(`%${filters.license_plate}%`);\n }\n if (filters?.date_from) {\n query += ` AND stolen_date >= ?`;\n params.push(filters.date_from);\n }\n if (filters?.date_to) {\n query += ` AND stolen_date <= ?`;\n params.push(filters.date_to);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as StolenCar[];\n}\n\nexport async function getStolenCarById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${STOLEN_CARS_TABLE} WHERE id = ?`, [id]);\n return result.rows[0] as StolenCar || null;\n}\n\nexport async function updateStolenCarStatus(id: number, status: 'active' | 'found' | 'resolved'): Promise {\n await sqlite.execute(`UPDATE ${STOLEN_CARS_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Found Cars Queries\nexport async function createFoundCarReport(car: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${FOUND_CARS_TABLE} (\n make, model, year, color, license_plate, description,\n found_date, found_location, found_lat, found_lng, photo_url,\n reporter_name, reporter_phone, reporter_email, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n car.make, car.model, car.year, car.color, car.license_plate, car.description,\n car.found_date, car.found_location, car.found_lat, car.found_lng, car.photo_url,\n car.reporter_name, car.reporter_phone, car.reporter_email, car.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getFoundCars(filters?: SearchFilters): Promise {\n let query = `SELECT * FROM ${FOUND_CARS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.make) {\n query += ` AND LOWER(make) LIKE LOWER(?)`;\n params.push(`%${filters.make}%`);\n }\n if (filters?.model) {\n query += ` AND LOWER(model) LIKE LOWER(?)`;\n params.push(`%${filters.model}%`);\n }\n if (filters?.color) {\n query += ` AND LOWER(color) LIKE LOWER(?)`;\n params.push(`%${filters.color}%`);\n }\n if (filters?.license_plate) {\n query += ` AND LOWER(license_plate) LIKE LOWER(?)`;\n params.push(`%${filters.license_plate}%`);\n }\n if (filters?.date_from) {\n query += ` AND found_date >= ?`;\n params.push(filters.date_from);\n }\n if (filters?.date_to) {\n query += ` AND found_date <= ?`;\n params.push(filters.date_to);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as FoundCar[];\n}\n\nexport async function getFoundCarById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${FOUND_CARS_TABLE} WHERE id = ?`, [id]);\n return result.rows[0] as FoundCar || null;\n}\n\nexport async function updateFoundCarStatus(id: number, status: 'active' | 'matched' | 'resolved'): Promise {\n await sqlite.execute(`UPDATE ${FOUND_CARS_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Matching System\nexport async function findPotentialMatches(foundCarId: number): Promise {\n const foundCar = await getFoundCarById(foundCarId);\n if (!foundCar) return [];\n\n let query = `SELECT * FROM ${STOLEN_CARS_TABLE} WHERE status = 'active'`;\n const params: any[] = [];\n\n // Exact license plate match (highest priority)\n if (foundCar.license_plate) {\n query += ` AND license_plate = ?`;\n params.push(foundCar.license_plate);\n } else {\n // Match by make, model, color if no license plate\n const conditions: string[] = [];\n \n if (foundCar.make) {\n conditions.push(`LOWER(make) = LOWER(?)`);\n params.push(foundCar.make);\n }\n if (foundCar.model) {\n conditions.push(`LOWER(model) = LOWER(?)`);\n params.push(foundCar.model);\n }\n if (foundCar.color) {\n conditions.push(`LOWER(color) = LOWER(?)`);\n params.push(foundCar.color);\n }\n if (foundCar.year) {\n conditions.push(`year = ?`);\n params.push(foundCar.year);\n }\n\n if (conditions.length > 0) {\n query += ` AND (${conditions.join(' OR ')})`;\n }\n }\n\n const result = await sqlite.execute(query, params);\n return result.rows as StolenCar[];\n}\n\nexport async function createMatch(match: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${MATCHES_TABLE} (stolen_car_id, found_car_id, match_score, match_reasons, status)\n VALUES (?, ?, ?, ?, ?)\n `, [\n match.stolen_car_id, \n match.found_car_id, \n match.match_score, \n JSON.stringify(match.match_reasons), \n match.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getMatches(stolenCarId?: number, foundCarId?: number): Promise {\n let query = `SELECT * FROM ${MATCHES_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (stolenCarId) {\n query += ` AND stolen_car_id = ?`;\n params.push(stolenCarId);\n }\n if (foundCarId) {\n query += ` AND found_car_id = ?`;\n params.push(foundCarId);\n }\n\n query += ` ORDER BY match_score DESC, created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows.map(row => ({\n ...row,\n match_reasons: JSON.parse(row.match_reasons as string)\n })) as CarMatch[];\n}\n\nexport async function updateMatchStatus(id: number, status: 'pending' | 'confirmed' | 'rejected'): Promise {\n await sqlite.execute(`UPDATE ${MATCHES_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Search across both tables\nexport async function searchAllCars(filters: SearchFilters) {\n const results = {\n stolen: [] as StolenCar[],\n found: [] as FoundCar[]\n };\n\n if (filters.type === 'stolen' || filters.type === 'all' || !filters.type) {\n results.stolen = await getStolenCars(filters);\n }\n\n if (filters.type === 'found' || filters.type === 'all' || !filters.type) {\n results.found = await getFoundCars(filters);\n }\n\n return results;\n}",[],[180,299,291],"database","8443c4da-3f85-11f0-9a31-76b3cceeab13","migrations.ts","f4bc8c84-3f84-11f0-917f-76b3cceeab13",7,["D",1748850313057],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const STOLEN_CARS_TABLE = 'stolen_cars_v1';\nexport const FOUND_CARS_TABLE = 'found_cars_v1';\nexport const MATCHES_TABLE = 'car_matches_v1';\n\nexport async function createTables() {\n // Create stolen cars table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STOLEN_CARS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n make TEXT NOT NULL,\n model TEXT NOT NULL,\n year INTEGER NOT NULL,\n color TEXT NOT NULL,\n license_plate TEXT NOT NULL,\n vin TEXT,\n description TEXT,\n stolen_date TEXT NOT NULL,\n stolen_location TEXT NOT NULL,\n stolen_lat REAL,\n stolen_lng REAL,\n owner_name TEXT NOT NULL,\n owner_phone TEXT NOT NULL,\n owner_email TEXT NOT NULL,\n police_report_number TEXT,\n status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'found', 'resolved')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Create found cars table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FOUND_CARS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n make TEXT,\n model TEXT,\n year INTEGER,\n color TEXT NOT NULL,\n license_plate TEXT,\n description TEXT NOT NULL,\n found_date TEXT NOT NULL,\n found_location TEXT NOT NULL,\n found_lat REAL,\n found_lng REAL,\n photo_url TEXT,\n reporter_name TEXT NOT NULL,\n reporter_phone TEXT NOT NULL,\n reporter_email TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'matched', 'resolved')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Create matches table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MATCHES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n stolen_car_id INTEGER NOT NULL,\n found_car_id INTEGER NOT NULL,\n match_score REAL NOT NULL,\n match_reasons TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'rejected')),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (stolen_car_id) REFERENCES ${STOLEN_CARS_TABLE}(id),\n FOREIGN KEY (found_car_id) REFERENCES ${FOUND_CARS_TABLE}(id)\n )\n `);\n\n // Create indexes for better search performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_make ON ${STOLEN_CARS_TABLE}(make);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_model ON ${STOLEN_CARS_TABLE}(model);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_license ON ${STOLEN_CARS_TABLE}(license_plate);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_status ON ${STOLEN_CARS_TABLE}(status);`);\n \n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_color ON ${FOUND_CARS_TABLE}(color);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_license ON ${FOUND_CARS_TABLE}(license_plate);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_status ON ${FOUND_CARS_TABLE}(status);`);\n \n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_stolen ON ${MATCHES_TABLE}(stolen_car_id);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_found ON ${MATCHES_TABLE}(found_car_id);`);\n\n console.log('Database tables created successfully');\n}",[],[180,299,301],"f4bc9d14-3f84-11f0-917f-76b3cceeab13",["D",1748850072260],[197,198],[180,299],["D",1748850072260],[196,199,204],[180],["D",1748849913559],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},{"_13":90,"_32":91,"_47":40,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"ctx",{"_83":-5,"_128":352,"_353":354,"_355":356,"_357":25,"_358":25,"_359":25,"_360":63,"_361":-5,"_362":-7,"_363":-7,"_364":67,"_365":25,"_366":25,"_367":-5,"_368":25,"_369":25,"_370":25,"_371":-5},"ENV",{"_323":324,"_325":326,"_327":91,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351},"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 · v18