Val Town Code SearchReturn to Val Town

13```
14├── backend/
15│   ├── database/
16│   │   ├── migrations.ts    # Database schema setup
17│   │   └── queries.ts       # Database query functions
18│   ├── routes/
19│   │   ├── jobs.ts         # Job posting API routes
43- `POST /api/chat/messages` - Send a new chat message
44
45## Database Schema
46
47### Jobs Table

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations } from "./database/migrations.ts";
4import jobsRouter from "./routes/jobs.ts";
5import chatRouter from "./routes/chat.ts";
12});
13
14// Initialize database
15await runMigrations();
16

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations } from "./database/migrations.ts";
4import { getAllProducts, getChatMessages } from "./database/queries.ts";
5import products from "./routes/products.ts";
6import chat from "./routes/chat.ts";
13});
14
15// Initialize database on startup
16await runMigrations();
17

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { NewChatMessage } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllJobs, createJob } from "../database/queries.ts";
3import type { NewJob } from "../../shared/types.ts";
4

31  `);
32
33  console.log('Database migrations completed');
34}

13```
14├── backend/
15│   ├── database/
16│   │   ├── migrations.ts    # Database schema setup
17│   │   └── queries.ts       # Database query functions
18│   ├── routes/
19│   │   ├── jobs.ts         # Job posting API routes

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { CreateChatMessageRequest } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllProducts, createProduct } from "../database/queries.ts";
3import type { CreateProductRequest } from "../../shared/types.ts";
4

23  )`);
24
25  console.log('Database migrations completed');
26}
27