Val Town Code SearchReturn to Val Town

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema setup
19│   │   └── queries.ts       # Database query functions
20│   ├── routes/
21│   │   └── businesses.ts    # Business-related API endpoints

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getRecentMessages, createMessage } from "../database/queries.ts";
3import type { ChatMessage, ApiResponse } from "../../shared/types.ts";
4

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

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllBuses, createBus, deleteBus } from "../database/queries.ts";
3import type { CreateBusRequest, ApiResponse } from "../../shared/types.ts";
4

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

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 { createTables } from "./database/migrations.ts";
4import reviewsRouter from "./routes/reviews.ts";
5
11});
12
13// Initialize database on startup
14await createTables();
15

15```
16├── backend/
17│   ├── database/
18│   │   ├── blob-storage.ts    # Blob storage functions
19│   │   ├── migrations.ts      # SQLite schema (backup)
56- Counter: `workgroup_message_counter`
57
58## Database Schema
59
60### User Object

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { createUser, getUserByUsername } from "../database/blob-storage.ts";
3import type { AuthRequest, AuthResponse } from "../../shared/types.ts";
4

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 { initializeStorage } from "./database/blob-storage.ts";
4import auth from "./routes/auth.ts";
5import messages from "./routes/messages.ts";