\n \n\n",[],[134,198],"13bbe776-3fa1-11f0-bc5a-76b3cceeab13","JobForm.tsx","13bbe816-3fa1-11f0-bc5a-76b3cceeab13","d40e41bb-ab49-45a2-afa0-ef9873b5c9f1",12,["D",1748862150178],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Job, CreateJobRequest } from \"../../shared/types.ts\";\n\ninterface JobFormProps {\n onJobCreated: (job: Job) => void;\n}\n\nexport default function JobForm({ onJobCreated }: JobFormProps) {\n const [formData, setFormData] = useState({\n title: '',\n company: '',\n location: '',\n description: '',\n salary: '',\n type: 'full-time',\n remote: false,\n contact_email: ''\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(null);\n const [success, setSuccess] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(null);\n\n try {\n const submitData = {\n ...formData,\n salary: formData.salary || undefined // Convert empty string to undefined\n };\n\n const response = await fetch('/api/jobs', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(submitData),\n });\n\n if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || 'Failed to create job posting');\n }\n\n const newJob = await response.json();\n onJobCreated(newJob);\n \n // Reset form\n setFormData({\n title: '',\n company: '',\n location: '',\n description: '',\n salary: '',\n type: 'full-time',\n remote: false,\n contact_email: ''\n });\n \n setSuccess(true);\n setTimeout(() => setSuccess(false), 3000);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'An error occurred');\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value, type } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: type === 'checkbox' ? (e.target as HTMLInputElement).checked : value\n }));\n };\n\n return (\n

Post a Job

\n Share your job opportunity with the community. All fields marked with * are required.\n

\n\n {error && (\n

\n ❌\n {error}\n

\n )}\n\n {success && (\n

\n ✅\n Job posted successfully!\n

\n )}\n\n

\n \n Job Title *\n \n \n

\n\n

\n \n Company *\n \n \n

\n\n

\n \n Job Type *\n \n \n \n \n \n \n \n

\n\n

\n \n Salary (Optional)\n \n \n

\n\n

\n \n Location *\n \n \n

\n\n

\n \n \n This is a remote position\n \n

\n\n

\n \n Contact Email *\n \n \n

\n\n

\n \n Job Description *\n \n \n

\n\n

\n \n {isSubmitting ? 'Posting...' : 'Post Job'}\n \n

\n );\n}",[],[134,213,205],"components","009ca220-3fa1-11f0-8fe6-76b3cceeab13","JobBoard.tsx","009ca2de-3fa1-11f0-8fe6-76b3cceeab13",11,["D",1748862118096],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Job } from \"../../shared/types.ts\";\n\ninterface JobBoardProps {\n jobs: Job[];\n}\n\nexport default function JobBoard({ jobs }: JobBoardProps) {\n const [searchTerm, setSearchTerm] = useState('');\n const [filterType, setFilterType] = useState('all');\n const [filterRemote, setFilterRemote] = useState('all');\n\n const filteredJobs = jobs.filter(job => {\n const matchesSearch = \n job.title.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.company.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.location.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.description.toLowerCase().includes(searchTerm.toLowerCase());\n \n const matchesType = filterType === 'all' || job.type === filterType;\n const matchesRemote = \n filterRemote === 'all' || \n (filterRemote === 'remote' && job.remote) ||\n (filterRemote === 'onsite' && !job.remote);\n\n return matchesSearch && matchesType && matchesRemote;\n });\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n const getJobTypeColor = (type: string) => {\n const colors = {\n 'full-time': 'bg-green-100 text-green-800',\n 'part-time': 'bg-blue-100 text-blue-800',\n 'contract': 'bg-purple-100 text-purple-800',\n 'internship': 'bg-orange-100 text-orange-800'\n };\n return colors[type as keyof typeof colors] || 'bg-gray-100 text-gray-800';\n };\n\n return (\n

\n {/* Search and Filters */}\n

\n \n Search Jobs\n \n setSearchTerm(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n />\n

\n \n Job Type\n \n setFilterType(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n >\n \n \n \n \n \n \n

\n \n Location\n \n setFilterRemote(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n >\n \n \n \n \n

\n\n {/* Results Summary */}\n

\n Showing {filteredJobs.length} of {jobs.length} jobs\n

\n\n {/* Job Listings */}\n

\n {filteredJobs.length === 0 ? (\n

🔍

No jobs found

\n {jobs.length === 0 \n ? \"No jobs have been posted yet. Be the first to post a job!\"\n : \"Try adjusting your search criteria or filters.\"\n }\n

\n ) : (\n filteredJobs.map((job) => (\n

{job.title}

\n \n 🏢\n {job.company}\n \n \n {job.remote ? '🌐' : '📍'}\n {job.remote ? 'Remote' : job.location}\n \n {job.salary && (\n \n 💰\n {job.salary}\n \n )}\n

\n \n {job.type}\n \n \n Posted {formatDate(job.posted_at)}\n \n

\n \n

\n {job.description}\n

\n \n

\n Contact: {job.contact_email}\n

\n \n Apply Now\n \n

\n ))\n )}\n

\n );\n}",[],[134,213,215],"27bfcda0-3fa1-11f0-b352-76b3cceeab13","Chatroom.tsx","27bfce54-3fa1-11f0-b352-76b3cceeab13",13,["D",1748862183760],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { ChatMessage, CreateMessageRequest } from \"../../shared/types.ts\";\n\ninterface ChatroomProps {\n messages: ChatMessage[];\n onMessageReceived: (message: ChatMessage) => void;\n}\n\nexport default function Chatroom({ messages, onMessageReceived }: ChatroomProps) {\n const [newMessage, setNewMessage] = useState('');\n const [username, setUsername] = useState('');\n const [isConnected, setIsConnected] = useState(false);\n const [isSending, setIsSending] = useState(false);\n const messagesEndRef = useRef(null);\n const eventSourceRef = useRef(null);\n\n // Load username from localStorage\n useEffect(() => {\n const savedUsername = localStorage.getItem('chat-username');\n if (savedUsername) {\n setUsername(savedUsername);\n }\n }, []);\n\n // Save username to localStorage\n useEffect(() => {\n if (username) {\n localStorage.setItem('chat-username', username);\n }\n }, [username]);\n\n // Setup SSE connection for real-time messages\n useEffect(() => {\n const eventSource = new EventSource('/api/chat/stream');\n eventSourceRef.current = eventSource;\n\n eventSource.onopen = () => {\n setIsConnected(true);\n };\n\n eventSource.onmessage = (event) => {\n try {\n const data = JSON.parse(event.data);\n if (data.type === 'connected') {\n console.log('Connected to chat stream');\n } else if (data.id) {\n // This is a new message\n onMessageReceived(data);\n }\n } catch (error) {\n console.error('Error parsing SSE message:', error);\n }\n };\n\n eventSource.onerror = () => {\n setIsConnected(false);\n };\n\n return () => {\n eventSource.close();\n };\n }, [onMessageReceived]);\n\n // Auto-scroll to bottom when new messages arrive\n useEffect(() => {\n messagesEndRef.current?.scrollIntoView({ behavior: 'smooth' });\n }, [messages]);\n\n const handleSendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!newMessage.trim() || !username.trim() || isSending) {\n return;\n }\n\n setIsSending(true);\n\n try {\n const messageData: CreateMessageRequest = {\n username: username.trim(),\n message: newMessage.trim()\n };\n\n const response = await fetch('/api/chat/messages', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(messageData),\n });\n\n if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || 'Failed to send message');\n }\n\n setNewMessage('');\n } catch (error) {\n console.error('Error sending message:', error);\n alert('Failed to send message. Please try again.');\n } finally {\n setIsSending(false);\n }\n };\n\n const formatTime = (timestamp: string) => {\n return new Date(timestamp).toLocaleTimeString('en-US', {\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const getMessageColor = (messageUsername: string) => {\n // Generate a consistent color based on username\n let hash = 0;\n for (let i = 0; i < messageUsername.length; i++) {\n hash = messageUsername.charCodeAt(i) + ((hash << 5) - hash);\n }\n const colors = [\n 'text-blue-600', 'text-green-600', 'text-purple-600', \n 'text-red-600', 'text-indigo-600', 'text-pink-600'\n ];\n return colors[Math.abs(hash) % colors.length];\n };\n\n return (\n

\n {/* Chat Header */}\n

💬 Public Chatroom

\n Discuss job opportunities and connect with others\n

\n \n {isConnected ? 'Connected' : 'Disconnected'}\n \n

\n\n {/* Username Input */}\n {!username && (\n

\n \n Choose a username to start chatting:\n \n setUsername(e.target.value)}\n placeholder=\"Enter your username\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n maxLength={50}\n />\n

\n )}\n\n {/* Messages */}\n

\n {messages.length === 0 ? (\n

💬

No messages yet. Start the conversation!

\n ) : (\n messages.map((message) => (\n

\n \n {message.username.charAt(0).toUpperCase()}\n \n

\n \n {message.username}\n \n \n {formatTime(message.timestamp)}\n \n

{message.message}

\n ))\n )}\n

\n\n {/* Message Input */}\n {username && (\n

\n )}\n

\n );\n}",[],[134,213,223],"efced8be-3fa0-11f0-8f0c-76b3cceeab13","App.tsx","efced990-3fa0-11f0-8f0c-76b3cceeab13",10,["D",1748862089902],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport JobBoard from \"./JobBoard.tsx\";\nimport JobForm from \"./JobForm.tsx\";\nimport Chatroom from \"./Chatroom.tsx\";\nimport type { Job, ChatMessage } from \"../../shared/types.ts\";\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__?: {\n jobs: Job[];\n messages: ChatMessage[];\n };\n }\n}\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState<'jobs' | 'post' | 'chat'>('jobs');\n const [jobs, setJobs] = useState([]);\n const [messages, setMessages] = useState([]);\n\n useEffect(() => {\n // Load initial data from server-side injection\n if (window.__INITIAL_DATA__) {\n setJobs(window.__INITIAL_DATA__.jobs);\n setMessages(window.__INITIAL_DATA__.messages);\n } else {\n // Fallback: fetch data if not injected\n fetchJobs();\n fetchMessages();\n }\n }, []);\n\n const fetchJobs = async () => {\n try {\n const response = await fetch('/api/jobs');\n if (response.ok) {\n const jobsData = await response.json();\n setJobs(jobsData);\n }\n } catch (error) {\n console.error('Error fetching jobs:', error);\n }\n };\n\n const fetchMessages = async () => {\n try {\n const response = await fetch('/api/chat/messages');\n if (response.ok) {\n const messagesData = await response.json();\n setMessages(messagesData);\n }\n } catch (error) {\n console.error('Error fetching messages:', error);\n }\n };\n\n const handleJobCreated = (newJob: Job) => {\n setJobs(prev => [newJob, ...prev]);\n setActiveTab('jobs'); // Switch to jobs tab after posting\n };\n\n const handleMessageReceived = (newMessage: ChatMessage) => {\n setMessages(prev => [...prev, newMessage]);\n };\n\n return (\n

\n {/* Header */}\n

\n 💼\n

Job Board

\n {jobs.length} jobs • {messages.length} messages\n

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

\n setActiveTab('jobs')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'jobs'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Browse Jobs ({jobs.length})\n \n setActiveTab('post')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'post'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Post a Job\n \n setActiveTab('chat')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'chat'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n 💬 Chat ({messages.length})\n \n

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

\n {activeTab === 'jobs' && }\n {activeTab === 'post' && }\n {activeTab === 'chat' && (\n \n )}\n

\n );\n}",[],[134,213,231],"efcee624-3fa0-11f0-8f0c-76b3cceeab13",["D",1748862089902],[165,166,167,168],[134,213],["D",1748862065953],[164,169,170],[134],"30dd7c3e-3fa1-11f0-97fa-76b3cceeab13","index.ts",["D",1748862199041],"http","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 { getAllJobs, getChatMessages } from \"./database/queries.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\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 with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial data to avoid extra round-trips\n try {\n const [jobs, messages] = await Promise.all([\n getAllJobs(),\n getChatMessages(20) // Get last 20 messages\n ]);\n\n const initialData = { jobs, messages };\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n // Continue without initial data\n }\n\n return c.html(html);\n});\n\n// Health check\napp.get(\"/health\", c => c.json({ status: \"ok\" }));\n\n// Export the fetch handler for Val Town\nexport default app.fetch;",[],[140,246],"d05aaa12-3fa0-11f0-a99e-76b3cceeab13","jobs.ts","d05aaabc-3fa0-11f0-a99e-76b3cceeab13","80d12d3e-c9a9-4acb-a329-3a6e99a1c7dc",5,["D",1748862037127],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, createJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest } 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 return c.json(jobList);\n } catch (error) {\n console.error(\"Error fetching jobs:\", error);\n return c.json({ error: \"Failed to fetch jobs\" }, 500);\n }\n});\n\n// Create a new job\njobs.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as CreateJobRequest;\n \n // Basic validation\n if (!body.title || !body.company || !body.location || !body.description || !body.contact_email || !body.type) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.contact_email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n // Validate job type\n const validTypes = ['full-time', 'part-time', 'contract', 'internship'];\n if (!validTypes.includes(body.type)) {\n return c.json({ error: \"Invalid job type\" }, 400);\n }\n\n const newJob = await createJob(body);\n return c.json(newJob, 201);\n } catch (error) {\n console.error(\"Error creating job:\", error);\n return c.json({ error: \"Failed to create job\" }, 500);\n }\n});\n\nexport default jobs;",[],[140,261,253],"routes","d71c9d42-3fa0-11f0-95ff-76b3cceeab13","chat.ts","d71c9dec-3fa0-11f0-95ff-76b3cceeab13",6,["D",1748862048470],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getChatMessages, createChatMessage } from \"../database/queries.ts\";\nimport type { CreateMessageRequest } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Store SSE connections for real-time updates\nconst connections = new Set();\n\n// Get chat messages\nchat.get(\"/messages\", async (c) => {\n try {\n const messages = await getChatMessages();\n return c.json(messages);\n } catch (error) {\n console.error(\"Error fetching messages:\", error);\n return c.json({ error: \"Failed to fetch messages\" }, 500);\n }\n});\n\n// Create a new chat message\nchat.post(\"/messages\", async (c) => {\n try {\n const body = await c.req.json() as CreateMessageRequest;\n \n // Basic validation\n if (!body.username || !body.message) {\n return c.json({ error: \"Username and message are required\" }, 400);\n }\n\n // Sanitize input\n const sanitizedMessage = {\n username: body.username.trim().slice(0, 50), // Limit username length\n message: body.message.trim().slice(0, 500), // Limit message length\n };\n\n if (!sanitizedMessage.username || !sanitizedMessage.message) {\n return c.json({ error: \"Username and message cannot be empty\" }, 400);\n }\n\n const newMessage = await createChatMessage(sanitizedMessage);\n \n // Broadcast to all connected clients\n const messageData = `data: ${JSON.stringify(newMessage)}\\n\\n`;\n connections.forEach(controller => {\n try {\n controller.enqueue(new TextEncoder().encode(messageData));\n } catch (error) {\n // Remove dead connections\n connections.delete(controller);\n }\n });\n\n return c.json(newMessage, 201);\n } catch (error) {\n console.error(\"Error creating message:\", error);\n return c.json({ error: \"Failed to create message\" }, 500);\n }\n});\n\n// Server-sent events for real-time chat\nchat.get(\"/stream\", (c) => {\n const stream = new ReadableStream({\n start(controller) {\n connections.add(controller);\n \n // Send initial connection message\n const welcomeMessage = `data: ${JSON.stringify({ type: 'connected' })}\\n\\n`;\n controller.enqueue(new TextEncoder().encode(welcomeMessage));\n },\n cancel() {\n connections.delete(controller);\n }\n });\n\n return new Response(stream, {\n headers: {\n 'Content-Type': 'text/event-stream',\n 'Cache-Control': 'no-cache',\n 'Connection': 'keep-alive',\n },\n });\n});\n\nexport default chat;",[],[140,261,263],"d05ab35e-3fa0-11f0-a99e-76b3cceeab13",["D",1748862037127],[160,161],[140,261],"cb466af2-3fa0-11f0-9f27-76b3cceeab13","queries.ts","cb466bd8-3fa0-11f0-9f27-76b3cceeab13","2abc9854-14e4-413d-b39a-23a25419133e",4,["D",1748862028577],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_TABLE } from \"./migrations.ts\";\nimport type { Job, CreateJobRequest, ChatMessage, CreateMessageRequest } 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 posted_at DESC\n `);\n \n return result.rows.map(row => ({\n id: row[0] as number,\n title: row[1] as string,\n company: row[2] as string,\n location: row[3] as string,\n description: row[4] as string,\n salary: row[5] as string || undefined,\n type: row[6] as Job['type'],\n remote: Boolean(row[7]),\n contact_email: row[8] as string,\n posted_at: row[9] as string,\n }));\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${JOBS_TABLE} (title, company, location, description, salary, type, remote, contact_email)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n jobData.title,\n jobData.company,\n jobData.location,\n jobData.description,\n jobData.salary || null,\n jobData.type,\n jobData.remote ? 1 : 0,\n jobData.contact_email\n ]);\n\n // Get the created job\n const createdJob = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} WHERE id = ?\n `, [result.lastInsertRowId]);\n\n const row = createdJob.rows[0];\n return {\n id: row[0] as number,\n title: row[1] as string,\n company: row[2] as string,\n location: row[3] as string,\n description: row[4] as string,\n salary: row[5] as string || undefined,\n type: row[6] as Job['type'],\n remote: Boolean(row[7]),\n contact_email: row[8] as string,\n posted_at: row[9] as string,\n };\n}\n\n// Chat queries\nexport async function getChatMessages(limit: number = 50): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} \n ORDER BY timestamp DESC \n LIMIT ?\n `, [limit]);\n \n return result.rows.map(row => ({\n id: row[0] as number,\n username: row[1] as string,\n message: row[2] as string,\n timestamp: row[3] as string,\n })).reverse(); // Reverse to show oldest first\n}\n\nexport async function createChatMessage(messageData: CreateMessageRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${CHAT_TABLE} (username, message)\n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n // Get the created message\n const createdMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} WHERE id = ?\n `, [result.lastInsertRowId]);\n\n const row = createdMessage.rows[0];\n return {\n id: row[0] as number,\n username: row[1] as string,\n message: row[2] as string,\n timestamp: row[3] as string,\n };\n}",[],[140,283,275],"database","c3181826-3fa0-11f0-ab4f-76b3cceeab13","migrations.ts","c31818da-3fa0-11f0-ab4f-76b3cceeab13",["D",1748862014882],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst JOBS_TABLE = 'job_postings_v1';\nconst CHAT_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 location TEXT NOT NULL,\n description 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 contact_email TEXT NOT NULL,\n posted_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed');\n}\n\nexport { JOBS_TABLE, CHAT_TABLE };",[],[140,283,285],"c318200a-3fa0-11f0-ab4f-76b3cceeab13",["D",1748862014882],[157,158],[140,283],["D",1748862014882],[156,159,162],[140],["D",1748861711553],{"_16":17,"_82":78},{"_16":17,"_76":-5,"_77":78,"_32":33,"_79":80,"_81":26},{"_64":65,"_20":66,"_18":67,"_68":19,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":21,"_75":17},"ctx",{"_57":-5,"_103":335,"_336":337,"_338":339,"_340":26,"_341":26,"_342":26,"_343":37,"_344":-5,"_345":-7,"_346":-7,"_347":41,"_348":26,"_349":26,"_350":-5,"_351":26,"_352":26,"_353":26,"_354":-5},"ENV",{"_306":307,"_308":309,"_310":66,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334},"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"]