[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_294":295,"_296":297},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":64,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",12,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components/App.tsx","latestPath","fileId","f58aae88-3f44-11f0-b05a-76b3cceeab13","name","App.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport JobBoard from \"./JobBoard.tsx\";\nimport JobForm from \"./JobForm.tsx\";\nimport ChatRoom from \"./ChatRoom.tsx\";\n\ntype Tab = 'jobs' | 'post-job' | 'chat';\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState('jobs');\n\n const tabs = [\n { id: 'jobs' as Tab, label: '💼 Job Board', icon: '📋' },\n { id: 'post-job' as Tab, label: '➕ Post Job', icon: '✏️' },\n { id: 'chat' as Tab, label: '💬 Chat Room', icon: '🗨️' }\n ];\n\n return (\n

\n {/* Header */}\n

🚀

Job Board & Chat

\n Connect • Share • Grow\n

\n\n {/* Navigation Tabs */}\n

\n {tabs.map((tab) => (\n setActiveTab(tab.id)}\n className={`py-4 px-1 border-b-2 font-medium text-sm transition-colors duration-200 ${\n activeTab === tab.id\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n \n {tab.icon}\n {tab.label}\n \n \n ))}\n

\n\n {/* Main Content */}\n

\n {activeTab === 'jobs' && }\n {activeTab === 'post-job' && setActiveTab('jobs')} />}\n {activeTab === 'chat' && }\n

\n\n {/* Footer */}\n \n

\n );\n}","createdAt",["D",1748822585812],"branchVersion","branchId","58bff28e-3f44-11f0-bde5-76b3cceeab13",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"frontend/components","6d88f213-be7d-47f8-ae4c-9eae0ae9fb74","components","directory",["D",1748822585812],"id","58bfaa7c-3f44-11f0-bde5-76b3cceeab13","JobMeg",["D",1748822322775],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","3d964670-3f44-11f0-b6e9-ab0b2f88b858","pinnedFileId","4000d316-3f45-11f0-8d53-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","fdce5ee7-3223-4972-9952-0bdcd5b87e74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Medix","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4dmN1bVlXQm1lSGVCSGRLc29uTWFPZnRHeiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":290,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":291,"_86":292,"_88":293,"_90":25},"tree",[185,193,197,199,200],"files",[185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200],"counts",{"_174":68,"_175":176,"_177":68,"_178":179,"_180":181},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":168,"_32":169,"_30":170,"_140":-5,"_41":42,"_40":171,"_142":64,"_38":172,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_27":173},{"_49":162,"_32":163,"_30":164,"_140":-5,"_41":42,"_40":165,"_142":64,"_38":166,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_27":167},{"_49":156,"_32":157,"_30":158,"_140":-5,"_41":42,"_40":159,"_142":64,"_38":160,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_27":161},{"_49":149,"_32":150,"_30":151,"_140":-5,"_41":42,"_40":152,"_142":64,"_38":153,"_13":68,"_34":21,"_36":154,"_24":25,"_147":-5,"_27":155},{"_49":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":25,"_38":143,"_13":144,"_34":145,"_36":146,"_24":25,"_147":-5,"_27":148},"69911390-3f44-11f0-800a-76b3cceeab13","main.tsx","58c206e6-3f44-11f0-bde5-76b3cceeab13","parentId",3,"latest",["D",1748822350984],2,"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","label",[138],"c11a10ee-3f44-11f0-9f24-76b3cceeab13","README.md","c11a11ca-3f44-11f0-9f24-76b3cceeab13",4,["D",1748822497845],"# Job Board & Chat App\n\nA full-stack application for posting job opportunities and discussing them in a public chat room.\n\n## Features\n\n- 📝 Post job listings with title, company, description, and requirements\n- 💬 Public chat room for discussing opportunities\n- 🔍 Browse and search job postings\n- 📱 Responsive design with TailwindCSS\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── jobs.ts # Job posting API routes\n│ │ └── chat.ts # Chat API routes\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── JobBoard.tsx # Job listings component\n│ │ ├── JobForm.tsx # Job posting form\n│ │ └── ChatRoom.tsx # Chat room component\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Database**: SQLite\n- **Frontend**: React 18.2.0 with TypeScript\n- **Styling**: TailwindCSS\n- **Real-time**: Polling for chat updates\n\n## API Endpoints\n\n### Jobs\n- `GET /api/jobs` - Get all job postings\n- `POST /api/jobs` - Create a new job posting\n- `GET /api/jobs/:id` - Get a specific job posting\n\n### Chat\n- `GET /api/chat/messages` - Get chat messages\n- `POST /api/chat/messages` - Send a chat message\n\n## Getting Started\n\nThe app is automatically deployed on Val Town. Visit the HTTP endpoint to start using the application.",[150],"c519d454-3f44-11f0-8f0d-76b3cceeab13","shared","5a1e1dfc-73bb-4356-ac94-a737ebf6231a",5,["D",1748822504554],[157],"ea7a1164-3f44-11f0-a557-76b3cceeab13","frontend","c55d2769-6e55-404c-92a8-2e9e8dd3d738",11,["D",1748822567257],[163],"c994d876-3f44-11f0-8f0d-76b3cceeab13","backend","6c022ab9-751b-40f7-931c-f3d3343641b5",6,["D",1748822512071],[169],"pulls","branches",1,"forks","envVars",{"_182":68,"_184":68},"connections",{"_182":68,"_183":68},"count","unfilledCount","emptyCount",{"_49":168,"_32":169,"_30":170,"_140":-5,"_41":42,"_40":171,"_142":64,"_38":287,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_202":288,"_27":289},{"_49":283,"_32":275,"_30":269,"_140":170,"_41":42,"_40":171,"_142":64,"_38":284,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_202":285,"_27":286},{"_49":276,"_32":277,"_30":278,"_140":269,"_41":42,"_40":171,"_142":64,"_38":279,"_13":68,"_34":35,"_36":280,"_24":25,"_147":-5,"_202":281,"_27":282},{"_49":266,"_32":267,"_30":268,"_140":269,"_41":42,"_40":270,"_142":64,"_38":271,"_13":68,"_34":35,"_36":272,"_24":25,"_147":-5,"_202":273,"_27":274},{"_49":262,"_32":253,"_30":247,"_140":170,"_41":42,"_40":248,"_142":64,"_38":263,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_202":264,"_27":265},{"_49":254,"_32":255,"_30":256,"_140":247,"_41":42,"_40":257,"_142":64,"_38":258,"_13":68,"_34":35,"_36":259,"_24":25,"_147":-5,"_202":260,"_27":261},{"_49":244,"_32":245,"_30":246,"_140":247,"_41":42,"_40":248,"_142":64,"_38":249,"_13":68,"_34":35,"_36":250,"_24":25,"_147":-5,"_202":251,"_27":252},{"_49":236,"_32":237,"_30":238,"_140":170,"_41":42,"_40":239,"_142":64,"_38":240,"_13":68,"_34":35,"_36":241,"_24":25,"_147":-5,"_202":242,"_27":243},{"_49":162,"_32":163,"_30":164,"_140":-5,"_41":42,"_40":165,"_142":64,"_38":233,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_202":234,"_27":235},{"_49":229,"_32":46,"_30":45,"_140":164,"_41":42,"_40":14,"_142":64,"_38":230,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_202":231,"_27":232},{"_49":225,"_32":33,"_30":31,"_140":45,"_41":42,"_40":14,"_142":64,"_38":226,"_13":68,"_34":35,"_36":37,"_24":25,"_147":-5,"_202":227,"_27":228},{"_49":218,"_32":219,"_30":220,"_140":164,"_41":42,"_40":165,"_142":64,"_38":221,"_13":68,"_34":21,"_36":222,"_24":25,"_147":-5,"_202":223,"_27":224},{"_49":156,"_32":157,"_30":158,"_140":-5,"_41":42,"_40":159,"_142":64,"_38":215,"_13":68,"_34":47,"_36":-5,"_24":25,"_147":-5,"_202":216,"_27":217},{"_49":208,"_32":209,"_30":210,"_140":158,"_41":42,"_40":159,"_142":64,"_38":211,"_13":68,"_34":35,"_36":212,"_24":25,"_147":-5,"_202":213,"_27":214},{"_49":149,"_32":150,"_30":151,"_140":-5,"_41":42,"_40":152,"_142":64,"_38":205,"_13":68,"_34":21,"_36":154,"_24":25,"_147":-5,"_202":206,"_27":207},{"_49":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":25,"_38":201,"_13":144,"_34":145,"_36":146,"_24":25,"_147":-5,"_202":203,"_27":204},["D",1748822350984],"children",[],[138],["D",1748822497845],[],[150],"c519cf7c-3f44-11f0-8f0d-76b3cceeab13","types.ts","c519d030-3f44-11f0-8f0d-76b3cceeab13",["D",1748822504554],"// Shared types for the job board and chat application\n\nexport interface Job {\n id: number;\n title: string;\n company: string;\n description: string;\n requirements: string;\n location: string;\n salary?: string;\n type: 'full-time' | 'part-time' | 'contract' | 'internship';\n remote: boolean;\n created_at: string;\n updated_at: string;\n}\n\nexport interface CreateJobRequest {\n title: string;\n company: string;\n description: string;\n requirements: string;\n location: string;\n salary?: string;\n type: 'full-time' | 'part-time' | 'contract' | 'internship';\n remote: boolean;\n}\n\nexport interface ChatMessage {\n id: number;\n username: string;\n message: string;\n created_at: string;\n}\n\nexport interface CreateChatMessageRequest {\n username: string;\n message: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[157,209],["D",1748822504554],[198],[157],"ea7a057a-3f44-11f0-a557-76b3cceeab13","index.html","ea7a07dc-3f44-11f0-a557-76b3cceeab13",["D",1748822567257],"\n\n\n \n \n Job Board & Chat\n \n \n \n\n\n

\n \n \n\n",[],[163,219],"f58aadb6-3f44-11f0-b05a-76b3cceeab13",["D",1748822585812],[],[163,46,33],"f58ac0e4-3f44-11f0-b05a-76b3cceeab13",["D",1748822585812],[195],[163,46],["D",1748822567257],[194,196],[163],"e536212a-3f44-11f0-a997-76b3cceeab13","index.ts","e53621e8-3f44-11f0-a997-76b3cceeab13",10,["D",1748822558425],"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 { runMigrations } from \"./database/migrations.ts\";\nimport jobsRouter from \"./routes/jobs.ts\";\nimport chatRouter from \"./routes/chat.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 runMigrations();\n\n// API routes\napp.route(\"/api/jobs\", jobsRouter);\napp.route(\"/api/chat\", chatRouter);\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\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Health check\napp.get(\"/health\", c => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\n// 404 handler\napp.notFound(c => {\n return c.json({ error: \"Not found\" }, 404);\n});\n\nexport default app;",[],[169,237],"d7bc8084-3f44-11f0-84d8-76b3cceeab13","jobs.ts","d7bc814c-3f44-11f0-84d8-76b3cceeab13","8f4986e5-0f6a-47fc-ae5e-60d1a61a69c5",8,["D",1748822535818],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, getJobById, createJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest, ApiResponse, Job } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs\njobs.get(\"/\", async (c) => {\n try {\n const jobList = await getAllJobs();\n const response: ApiResponse = {\n success: true,\n data: jobList\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch jobs'\n };\n return c.json(response, 500);\n }\n});\n\n// Get job by ID\njobs.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 job ID'\n };\n return c.json(response, 400);\n }\n\n const job = await getJobById(id);\n if (!job) {\n const response: ApiResponse = {\n success: false,\n error: 'Job not found'\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: job\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch job'\n };\n return c.json(response, 500);\n }\n});\n\n// Create new job\njobs.post(\"/\", async (c) => {\n try {\n const jobData: CreateJobRequest = await c.req.json();\n \n // Basic validation\n if (!jobData.title || !jobData.company || !jobData.description || !jobData.requirements || !jobData.location || !jobData.type) {\n const response: ApiResponse = {\n success: false,\n error: 'Missing required fields: title, company, description, requirements, location, type'\n };\n return c.json(response, 400);\n }\n\n const validTypes = ['full-time', 'part-time', 'contract', 'internship'];\n if (!validTypes.includes(jobData.type)) {\n const response: ApiResponse = {\n success: false,\n error: 'Invalid job type. Must be one of: ' + validTypes.join(', ')\n };\n return c.json(response, 400);\n }\n\n const newJob = await createJob(jobData);\n const response: ApiResponse = {\n success: true,\n data: newJob\n };\n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to create job'\n };\n return c.json(response, 500);\n }\n});\n\nexport default jobs;",[],[169,253,245],"routes","df448e64-3f44-11f0-828b-76b3cceeab13","chat.ts","df448f22-3f44-11f0-828b-76b3cceeab13",9,["D",1748822548456],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getChatMessages, createChatMessage } from \"../database/queries.ts\";\nimport type { CreateChatMessageRequest, ApiResponse, ChatMessage } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Get chat messages\nchat.get(\"/messages\", async (c) => {\n try {\n const limit = parseInt(c.req.query(\"limit\") || \"50\");\n const messages = await getChatMessages(limit);\n \n const response: ApiResponse = {\n success: true,\n data: messages\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch messages'\n };\n return c.json(response, 500);\n }\n});\n\n// Send chat message\nchat.post(\"/messages\", async (c) => {\n try {\n const messageData: CreateChatMessageRequest = await c.req.json();\n \n // Basic validation\n if (!messageData.username || !messageData.message) {\n const response: ApiResponse = {\n success: false,\n error: 'Missing required fields: username, message'\n };\n return c.json(response, 400);\n }\n\n // Trim and validate message length\n messageData.username = messageData.username.trim();\n messageData.message = messageData.message.trim();\n\n if (messageData.username.length === 0 || messageData.message.length === 0) {\n const response: ApiResponse = {\n success: false,\n error: 'Username and message cannot be empty'\n };\n return c.json(response, 400);\n }\n\n if (messageData.username.length > 50) {\n const response: ApiResponse = {\n success: false,\n error: 'Username must be 50 characters or less'\n };\n return c.json(response, 400);\n }\n\n if (messageData.message.length > 500) {\n const response: ApiResponse = {\n success: false,\n error: 'Message must be 500 characters or less'\n };\n return c.json(response, 400);\n }\n\n const newMessage = await createChatMessage(messageData);\n const response: ApiResponse = {\n success: true,\n data: newMessage\n };\n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to send message'\n };\n return c.json(response, 500);\n }\n});\n\nexport default chat;",[],[169,253,255],"d7bca0f0-3f44-11f0-84d8-76b3cceeab13",["D",1748822535818],[190,191],[169,253],"cfc692f2-3f44-11f0-8fb4-76b3cceeab13","queries.ts","cfc693ce-3f44-11f0-8fb4-76b3cceeab13","c476fcc3-f031-4c13-932f-1afa518525f3",7,["D",1748822522462],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_MESSAGES_TABLE } from \"./migrations.ts\";\nimport type { Job, CreateJobRequest, ChatMessage, CreateChatMessageRequest } from \"../../shared/types.ts\";\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} \n ORDER BY created_at DESC\n `);\n return result.rows as Job[];\n}\n\nexport async function getJobById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} \n WHERE id = ?\n `, [id]);\n \n return result.rows.length > 0 ? result.rows[0] as Job : null;\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${JOBS_TABLE} (\n title, company, description, requirements, location, salary, type, remote\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n jobData.title,\n jobData.company,\n jobData.description,\n jobData.requirements,\n jobData.location,\n jobData.salary || null,\n jobData.type,\n jobData.remote ? 1 : 0\n ]);\n\n const newJob = await getJobById(result.lastInsertRowId);\n if (!newJob) {\n throw new Error('Failed to create job');\n }\n \n return newJob;\n}\n\n// Chat queries\nexport async function getChatMessages(limit: number = 50): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${CHAT_MESSAGES_TABLE} \n ORDER BY created_at DESC \n LIMIT ?\n `, [limit]);\n \n // Reverse to show oldest first\n return (result.rows as ChatMessage[]).reverse();\n}\n\nexport async function createChatMessage(messageData: CreateChatMessageRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${CHAT_MESSAGES_TABLE} (username, message) \n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n const newMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_MESSAGES_TABLE} \n WHERE id = ?\n `, [result.lastInsertRowId]);\n\n if (newMessage.rows.length === 0) {\n throw new Error('Failed to create chat message');\n }\n\n return newMessage.rows[0] as ChatMessage;\n}",[],[169,275,267],"database","c994d25e-3f44-11f0-8f0d-76b3cceeab13","migrations.ts","c994d358-3f44-11f0-8f0d-76b3cceeab13",["D",1748822512071],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names with version numbers for easy schema updates\nexport const JOBS_TABLE = 'jobs_v1';\nexport const CHAT_MESSAGES_TABLE = 'chat_messages_v1';\n\nexport async function runMigrations() {\n // Create jobs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n requirements TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT,\n type TEXT NOT NULL CHECK (type IN ('full-time', 'part-time', 'contract', 'internship')),\n remote BOOLEAN NOT NULL DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed successfully');\n}",[],[169,275,277],"c994dae2-3f44-11f0-8f0d-76b3cceeab13",["D",1748822512071],[187,188],[169,275],["D",1748822512071],[186,189,192],[169],["D",1748822322775],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":327,"_328":329,"_330":331,"_332":25,"_333":25,"_334":25,"_335":64,"_336":-5,"_337":-7,"_338":-7,"_339":68,"_340":25,"_341":25,"_342":-5,"_343":25,"_344":25,"_345":25,"_346":-5},"ENV",{"_298":299,"_300":301,"_302":92,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v12