\n \n \n \n\n",[],[110,128],"b556826e-3635-11f0-9e0c-9e149126039e","components","cb32ae7f-d51c-4f6d-bff0-348555ad61ea",10,["D",1747826475193],[141,142,143,144,145],[110,135],{"_36":178,"_13":179,"_39":180,"_41":136,"_43":44,"_45":137,"_47":48,"_49":181,"_17":51,"_52":53,"_54":182,"_56":57,"_58":-5,"_91":183,"_18":184},{"_36":170,"_13":171,"_39":172,"_41":136,"_43":44,"_45":173,"_47":48,"_49":174,"_17":51,"_52":53,"_54":175,"_56":57,"_58":-5,"_91":176,"_18":177},{"_36":162,"_13":163,"_39":164,"_41":136,"_43":44,"_45":165,"_47":48,"_49":166,"_17":51,"_52":53,"_54":167,"_56":57,"_58":-5,"_91":168,"_18":169},{"_36":154,"_13":155,"_39":156,"_41":136,"_43":44,"_45":157,"_47":48,"_49":158,"_17":51,"_52":53,"_54":159,"_56":57,"_58":-5,"_91":160,"_18":161},{"_36":146,"_13":147,"_39":148,"_41":136,"_43":44,"_45":149,"_47":48,"_49":150,"_17":51,"_52":53,"_54":151,"_56":57,"_58":-5,"_91":152,"_18":153},"eb8433b8-3635-11f0-bd45-9e149126039e","TaskList.tsx","eb843494-3635-11f0-bd45-9e149126039e",14,["D",1747826566092],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Task } from \"../../shared/types.ts\";\nimport TaskForm from \"./TaskForm.tsx\";\n\ninterface TaskListProps {\n token: string;\n}\n\nconst TaskList: React.FC = ({ token }) => {\n const [tasks, setTasks] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(null);\n const [editingTask, setEditingTask] = useState(null);\n \n // Fetch tasks from the API\n const fetchTasks = async () => {\n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/tasks\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to fetch tasks\");\n return;\n }\n \n setTasks(data.data);\n } catch (err) {\n console.error(\"Error fetching tasks:\", err);\n setError(\"An error occurred while fetching tasks\");\n } finally {\n setIsLoading(false);\n }\n };\n \n // Load tasks on component mount\n useEffect(() => {\n fetchTasks();\n }, [token]);\n \n // Toggle task completion status\n const toggleTaskCompletion = async (task: Task) => {\n try {\n const response = await fetch(`/api/tasks/${task.id}`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`\n },\n body: JSON.stringify({\n completed: !task.completed\n }),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to update task\");\n return;\n }\n \n // Update the task in the local state\n setTasks(tasks.map(t => t.id === task.id ? data.data : t));\n } catch (err) {\n console.error(\"Error updating task:\", err);\n setError(\"An error occurred while updating the task\");\n }\n };\n \n // Delete a task\n const deleteTask = async (taskId: number) => {\n if (!confirm(\"Are you sure you want to delete this task?\")) {\n return;\n }\n \n try {\n const response = await fetch(`/api/tasks/${taskId}`, {\n method: \"DELETE\",\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to delete task\");\n return;\n }\n \n // Remove the task from the local state\n setTasks(tasks.filter(t => t.id !== taskId));\n } catch (err) {\n console.error(\"Error deleting task:\", err);\n setError(\"An error occurred while deleting the task\");\n }\n };\n \n // Start editing a task\n const startEditingTask = (task: Task) => {\n setEditingTask(task);\n };\n \n // Cancel editing\n const cancelEditing = () => {\n setEditingTask(null);\n };\n \n // Render loading state\n if (isLoading && tasks.length === 0) {\n return (\n

\n );\n }\n \n return (\n

\n {/* Error message */}\n {error && (\n

\n {error}\n \n

\n )}\n \n {/* Task editing form */}\n {editingTask && (\n \n )}\n \n {/* Task list */}\n

\n Your Tasks {tasks.length > 0 && `(${tasks.length})`}\n

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

You don't have any tasks yet. Create one above!

\n ) : (\n tasks.map(task => (\n

\n toggleTaskCompletion(task)}\n className=\"mt-1 h-5 w-5 text-blue-600 focus:ring-blue-500 border-gray-300 rounded\"\n />\n

\n {task.title}\n

\n {task.description && (\n

\n {task.description}\n

\n )}\n

\n Created: {new Date(task.createdAt).toLocaleString()}\n

\n \n

\n startEditingTask(task)}\n className=\"text-blue-500 hover:text-blue-700\"\n title=\"Edit task\"\n >\n \n \n deleteTask(task.id)}\n className=\"text-red-500 hover:text-red-700\"\n title=\"Delete task\"\n >\n \n \n

\n ))\n )}\n

\n );\n};\n\nexport default TaskList;",[],[110,135,147],"d98c73e6-3635-11f0-ad4d-9e149126039e","TaskForm.tsx","d98c74d6-3635-11f0-ad4d-9e149126039e",13,["D",1747826535948],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { CreateTaskRequest } from \"../../shared/types.ts\";\n\ninterface TaskFormProps {\n token: string;\n taskToEdit?: {\n id: number;\n title: string;\n description: string;\n };\n onTaskCreated?: () => void;\n onTaskUpdated?: () => void;\n onCancel?: () => void;\n}\n\nconst TaskForm: React.FC = ({ \n token, \n taskToEdit, \n onTaskCreated, \n onTaskUpdated,\n onCancel \n}) => {\n const [title, setTitle] = useState(taskToEdit?.title || \"\");\n const [description, setDescription] = useState(taskToEdit?.description || \"\");\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n \n const isEditMode = !!taskToEdit;\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!title.trim()) {\n setError(\"Title is required\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n const taskData: CreateTaskRequest = {\n title: title.trim(),\n description: description.trim()\n };\n \n let url = \"/api/tasks\";\n let method = \"POST\";\n \n if (isEditMode) {\n url = `/api/tasks/${taskToEdit.id}`;\n method = \"PUT\";\n }\n \n const response = await fetch(url, {\n method,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`\n },\n body: JSON.stringify(taskData),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Failed to save task\");\n return;\n }\n \n // Reset form after successful creation\n if (!isEditMode) {\n setTitle(\"\");\n setDescription(\"\");\n if (onTaskCreated) onTaskCreated();\n } else {\n if (onTaskUpdated) onTaskUpdated();\n if (onCancel) onCancel();\n }\n } catch (err) {\n console.error(\"Task save error:\", err);\n setError(\"An error occurred while saving the task\");\n } finally {\n setIsLoading(false);\n }\n };\n \n return (\n

\n {isEditMode ? \"Edit Task\" : \"Create New Task\"}\n

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Title\n \n setTitle(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Task title\"\n />\n

\n \n

\n \n Description\n \n setDescription(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Task description (optional)\"\n rows={3}\n />\n

\n \n

\n \n {isLoading ? (\n \n \n Saving...\n \n ) : (\n isEditMode ? \"Update Task\" : \"Create Task\"\n )}\n \n \n {isEditMode && onCancel && (\n \n Cancel\n \n )}\n

\n );\n};\n\nexport default TaskForm;",[],[110,135,155],"cd20cf76-3635-11f0-804c-9e149126039e","Register.tsx","cd20d034-3635-11f0-804c-9e149126039e",12,["D",1747826515105],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse } from \"../../shared/types.ts\";\n\ninterface RegisterProps {\n onRegisterSuccess: (authResponse: AuthResponse) => void;\n onSwitchToLogin: () => void;\n}\n\nconst Register: React.FC = ({ onRegisterSuccess, onSwitchToLogin }) => {\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [confirmPassword, setConfirmPassword] = useState(\"\");\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!username || !password || !confirmPassword) {\n setError(\"All fields are required\");\n return;\n }\n \n if (password !== confirmPassword) {\n setError(\"Passwords do not match\");\n return;\n }\n \n if (password.length < 6) {\n setError(\"Password must be at least 6 characters long\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/auth/register\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ username, password }),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Registration failed\");\n return;\n }\n \n onRegisterSuccess(data.data);\n } catch (err) {\n console.error(\"Registration error:\", err);\n setError(\"An error occurred during registration\");\n } finally {\n setIsLoading(false);\n }\n };\n \n return (\n

Register

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Username\n \n setUsername(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Choose a username\"\n />\n

\n \n

\n \n Password\n \n setPassword(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Choose a password\"\n />\n

\n \n

\n \n Confirm Password\n \n setConfirmPassword(e.target.value)}\n className=\"shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline\"\n placeholder=\"Confirm your password\"\n />\n

\n \n

\n \n {isLoading ? (\n \n \n Registering...\n \n ) : (\n \"Register\"\n )}\n \n

\n \n

\n Already have an account?{\" \"}\n \n Login\n \n

\n );\n};\n\nexport default Register;",[],[110,135,163],"c13e2ac8-3635-11f0-ac02-9e149126039e","Login.tsx","c13e2b72-3635-11f0-ac02-9e149126039e",11,["D",1747826495169],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse } from \"../../shared/types.ts\";\n\ninterface LoginProps {\n onLoginSuccess: (authResponse: AuthResponse) => void;\n onSwitchToRegister: () => void;\n}\n\nconst Login: React.FC = ({ onLoginSuccess, onSwitchToRegister }) => {\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(null);\n const [isLoading, setIsLoading] = useState(false);\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!username || !password) {\n setError(\"Username and password are required\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/auth/login\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ username, password }),\n });\n \n const data = await response.json();\n \n if (!data.success) {\n setError(data.error || \"Login failed\");\n return;\n }\n \n onLoginSuccess(data.data);\n } catch (err) {\n console.error(\"Login error:\", err);\n setError(\"An error occurred during login\");\n } finally {\n setIsLoading(false);\n }\n };\n \n return (\n

Login

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n

\n \n {isLoading ? (\n \n \n Logging in...\n \n ) : (\n \"Login\"\n )}\n \n

\n \n

\n Don't have an account?{\" \"}\n \n Register\n \n

\n );\n};\n\nexport default Login;",[],[110,135,171],"b55643c6-3635-11f0-9e0c-9e149126039e","App.tsx","b5564466-3635-11f0-9e0c-9e149126039e",["D",1747826475193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse, User } from \"../../shared/types.ts\";\nimport Login from \"./Login.tsx\";\nimport Register from \"./Register.tsx\";\nimport TaskList from \"./TaskList.tsx\";\nimport TaskForm from \"./TaskForm.tsx\";\n\nconst App: React.FC = () => {\n const [user, setUser] = useState | null>(null);\n const [token, setToken] = useState(null);\n const [isLoading, setIsLoading] = useState(true);\n const [view, setView] = useState<\"login\" | \"register\" | \"tasks\">(\"login\");\n \n // Check for existing token on load\n useEffect(() => {\n const storedToken = localStorage.getItem(\"token\");\n const storedUser = localStorage.getItem(\"user\");\n \n if (storedToken && storedUser) {\n setToken(storedToken);\n setUser(JSON.parse(storedUser));\n setView(\"tasks\");\n }\n \n setIsLoading(false);\n }, []);\n \n // Handle successful authentication\n const handleAuthSuccess = (authResponse: AuthResponse) => {\n setToken(authResponse.token);\n setUser(authResponse.user);\n localStorage.setItem(\"token\", authResponse.token);\n localStorage.setItem(\"user\", JSON.stringify(authResponse.user));\n setView(\"tasks\");\n };\n \n // Handle logout\n const handleLogout = () => {\n setToken(null);\n setUser(null);\n localStorage.removeItem(\"token\");\n localStorage.removeItem(\"user\");\n setView(\"login\");\n };\n \n // Switch between login and register views\n const toggleAuthView = () => {\n setView(view === \"login\" ? \"register\" : \"login\");\n };\n \n if (isLoading) {\n return (\n

\n );\n }\n \n return (\n

\n {/* Header */}\n

Personal Task Manager

\n {user && (\n

Welcome, {user.username}

\n \n

\n )}\n

\n \n {/* Main content */}\n

\n {view === \"login\" && (\n \n )}\n \n {view === \"register\" && (\n \n )}\n \n {view === \"tasks\" && token && (\n

\n \n \n

\n )}\n

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

\n );\n};\n\nexport default App;",[],[110,135,179],"7e5a3cf6-3635-11f0-8ce9-9e149126039e",3,["D",1747826382944],[190,191,192],[60],{"_36":217,"_13":218,"_39":219,"_41":77,"_43":44,"_45":186,"_47":48,"_49":220,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":221,"_18":222},{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":202,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":203,"_18":204},{"_36":193,"_13":194,"_39":195,"_41":77,"_43":44,"_45":196,"_47":48,"_49":197,"_17":88,"_52":198,"_54":199,"_56":57,"_58":-5,"_91":200,"_18":201},"f1c0296c-3635-11f0-b686-9e149126039e","index.ts","a6c6e536-3635-11f0-b9f4-9e149126039e",16,["D",1747826576549],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/cors\";\nimport { logger } from \"https://esm.sh/hono@3.11.7/logger\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport authRoutes from \"./routes/auth.ts\";\nimport taskRoutes from \"./routes/tasks.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\n// Initialize the database\nawait initializeDatabase();\n\n// Create the main Hono app\nconst app = new Hono();\n\n// Middleware\napp.use(\"*\", logger());\napp.use(\"*\", cors());\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Application error:\", err);\n throw err;\n});\n\n// Mount routes\napp.route(\"/api/auth\", authRoutes);\napp.route(\"/api/tasks\", taskRoutes);\napp.route(\"/\", staticRoutes);\n\n// Export the fetch handler for HTTP val\nexport default app.fetch;",[],[60,194],["D",1747826415819],[205,206,207],[60,61],{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":214,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_91":215,"_18":216},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":211,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_91":212,"_18":213},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":208,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_91":209,"_18":210},["D",1747826433839],[],[60,61,38],["D",1747826442560],[],[60,61,63],["D",1747826415819],[],[60,61,70],"7e5a4016-3635-11f0-8ce9-9e149126039e","database","49ef072b-0345-4d68-9782-fc13ecfcc6c6",["D",1747826382944],[223,224],[60,218],{"_36":233,"_13":234,"_39":235,"_41":219,"_43":44,"_45":186,"_47":48,"_49":236,"_17":51,"_52":53,"_54":237,"_56":57,"_58":-5,"_91":238,"_18":239},{"_36":225,"_13":226,"_39":227,"_41":219,"_43":44,"_45":228,"_47":48,"_49":229,"_17":51,"_52":53,"_54":230,"_56":57,"_58":-5,"_91":231,"_18":232},"89e36e1c-3635-11f0-8ce9-9e149126039e","queries.ts","89e36eee-3635-11f0-8ce9-9e149126039e",4,["D",1747826402299],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, TASKS_TABLE } from \"./migrations.ts\";\nimport { User, Task, CreateTaskRequest, UpdateTaskRequest } from \"../../shared/types.ts\";\nimport bcrypt from \"https://esm.sh/bcryptjs@2.4.3\";\n\n// User-related queries\nexport async function findUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE username = ?`,\n [username]\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n username: result[0].username,\n password: result[0].password\n };\n}\n\nexport async function findUserById(id: number): Promise | null> {\n const result = await sqlite.execute(\n `SELECT id, username FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n username: result[0].username\n };\n}\n\nexport async function createUser(username: string, password: string): Promise> {\n // Hash the password\n const hashedPassword = await bcrypt.hash(password, 10);\n \n // Insert the user\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (username, password) VALUES (?, ?) RETURNING id, username`,\n [username, hashedPassword]\n );\n \n return {\n id: result[0].id,\n username: result[0].username\n };\n}\n\nexport async function validatePassword(user: User, password: string): Promise {\n return bcrypt.compare(password, user.password!);\n}\n\n// Task-related queries\nexport async function getTasks(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TASKS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n title: row.title,\n description: row.description || \"\",\n completed: Boolean(row.completed),\n createdAt: row.created_at\n }));\n}\n\nexport async function getTaskById(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TASKS_TABLE} WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n userId: result[0].user_id,\n title: result[0].title,\n description: result[0].description || \"\",\n completed: Boolean(result[0].completed),\n createdAt: result[0].created_at\n };\n}\n\nexport async function createTask(userId: number, task: CreateTaskRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TASKS_TABLE} (user_id, title, description) \n VALUES (?, ?, ?) \n RETURNING id, user_id, title, description, completed, created_at`,\n [userId, task.title, task.description || \"\"]\n );\n \n return {\n id: result[0].id,\n userId: result[0].user_id,\n title: result[0].title,\n description: result[0].description || \"\",\n completed: Boolean(result[0].completed),\n createdAt: result[0].created_at\n };\n}\n\nexport async function updateTask(id: number, userId: number, updates: UpdateTaskRequest): Promise {\n // Build the SET clause dynamically based on provided updates\n const setClauses = [];\n const params = [];\n \n if (updates.title !== undefined) {\n setClauses.push(\"title = ?\");\n params.push(updates.title);\n }\n \n if (updates.description !== undefined) {\n setClauses.push(\"description = ?\");\n params.push(updates.description);\n }\n \n if (updates.completed !== undefined) {\n setClauses.push(\"completed = ?\");\n params.push(updates.completed ? 1 : 0);\n }\n \n if (setClauses.length === 0) {\n return await getTaskById(id, userId);\n }\n \n // Add id and userId to params\n params.push(id);\n params.push(userId);\n \n const result = await sqlite.execute(\n `UPDATE ${TASKS_TABLE} \n SET ${setClauses.join(\", \")} \n WHERE id = ? AND user_id = ? \n RETURNING id, user_id, title, description, completed, created_at`,\n params\n );\n \n if (result.length === 0) {\n return null;\n }\n \n return {\n id: result[0].id,\n userId: result[0].user_id,\n title: result[0].title,\n description: result[0].description || \"\",\n completed: Boolean(result[0].completed),\n createdAt: result[0].created_at\n };\n}\n\nexport async function deleteTask(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TASKS_TABLE} WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n return result.rowsAffected > 0;\n}",[],[60,218,226],"7e5a2086-3635-11f0-8ce9-9e149126039e","migrations.ts","7e5a2162-3635-11f0-8ce9-9e149126039e",["D",1747826382944],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - change these when modifying schema\nexport const USERS_TABLE = \"task_manager_users\";\nexport const TASKS_TABLE = \"task_manager_tasks\";\n\n/**\n * Initialize the database schema\n */\nexport async function initializeDatabase() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create tasks table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TASKS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n description TEXT,\n completed BOOLEAN DEFAULT 0,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n\n console.log(\"Database initialized successfully\");\n}",[],[60,218,234],"53573c34-3635-11f0-a945-9e149126039e",["D",1747826310786],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","f4675420-1ee2-11f0-82e6-37b0a309c55b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","a5e2ec27-9915-4b8a-beed-e3bf61329958","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_292":288},"org",{"_11":12,"_286":-5,"_287":288,"_249":250,"_289":290,"_291":57},"branch",{"_17":196,"_13":16,"_36":44,"_278":240,"_279":-5,"_280":-5,"_281":-5,"_282":-5,"_283":-5,"_284":14,"_285":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3M0VmNlpLdXZSNGJ6SGR0TWxSYUFjeEdFcyJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":240,"_13":14,"_49":391,"_242":-5,"_243":57,"_244":245,"_246":245,"_247":-5,"_248":-5,"_249":250,"_251":195,"_252":48,"_253":48,"_254":-5,"_255":51,"_256":257,"_258":-5,"_259":-5,"_260":-5,"_261":-5,"_262":263,"_264":263,"_265":266,"_267":266,"_268":266,"_269":263,"_270":263,"_271":392,"_273":393,"_275":394,"_277":57},[328,337,346,348],"files",[328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348],"counts",{"_319":51,"_320":88,"_321":51,"_32":322,"_323":324},[313,314,315],{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":78,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_18":312},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[60,61],{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":73,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_18":318},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":66,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_18":317},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":316},[60,61,38],[60,61,63],[60,61,70],"pulls","branches","forks",{"_325":51,"_327":51},"connections",{"_325":51,"_326":51},"count","unfilledCount","emptyCount",{"_36":185,"_13":60,"_39":77,"_41":-5,"_43":44,"_45":186,"_47":48,"_49":187,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":389,"_18":390},{"_36":217,"_13":218,"_39":219,"_41":77,"_43":44,"_45":186,"_47":48,"_49":220,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":387,"_18":388},{"_36":233,"_13":234,"_39":235,"_41":219,"_43":44,"_45":186,"_47":48,"_49":236,"_17":51,"_52":53,"_54":237,"_56":57,"_58":-5,"_91":385,"_18":386},{"_36":225,"_13":226,"_39":227,"_41":219,"_43":44,"_45":228,"_47":48,"_49":229,"_17":51,"_52":53,"_54":230,"_56":57,"_58":-5,"_91":383,"_18":384},{"_36":76,"_13":61,"_39":42,"_41":77,"_43":44,"_45":72,"_47":48,"_49":202,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":381,"_18":382},{"_36":69,"_13":70,"_39":71,"_41":42,"_43":44,"_45":72,"_47":48,"_49":214,"_17":51,"_52":53,"_54":74,"_56":57,"_58":-5,"_91":379,"_18":380},{"_36":62,"_13":63,"_39":64,"_41":42,"_43":44,"_45":65,"_47":48,"_49":211,"_17":51,"_52":53,"_54":67,"_56":57,"_58":-5,"_91":377,"_18":378},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":208,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_91":375,"_18":376},{"_36":193,"_13":194,"_39":195,"_41":77,"_43":44,"_45":196,"_47":48,"_49":197,"_17":88,"_52":198,"_54":199,"_56":57,"_58":-5,"_91":373,"_18":374},{"_36":109,"_13":110,"_39":111,"_41":-5,"_43":44,"_45":112,"_47":48,"_49":113,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":371,"_18":372},{"_36":134,"_13":135,"_39":136,"_41":111,"_43":44,"_45":137,"_47":48,"_49":138,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":369,"_18":370},{"_36":178,"_13":179,"_39":180,"_41":136,"_43":44,"_45":137,"_47":48,"_49":181,"_17":51,"_52":53,"_54":182,"_56":57,"_58":-5,"_91":367,"_18":368},{"_36":170,"_13":171,"_39":172,"_41":136,"_43":44,"_45":173,"_47":48,"_49":174,"_17":51,"_52":53,"_54":175,"_56":57,"_58":-5,"_91":365,"_18":366},{"_36":162,"_13":163,"_39":164,"_41":136,"_43":44,"_45":165,"_47":48,"_49":166,"_17":51,"_52":53,"_54":167,"_56":57,"_58":-5,"_91":363,"_18":364},{"_36":154,"_13":155,"_39":156,"_41":136,"_43":44,"_45":157,"_47":48,"_49":158,"_17":51,"_52":53,"_54":159,"_56":57,"_58":-5,"_91":361,"_18":362},{"_36":146,"_13":147,"_39":148,"_41":136,"_43":44,"_45":149,"_47":48,"_49":150,"_17":51,"_52":53,"_54":151,"_56":57,"_58":-5,"_91":359,"_18":360},{"_36":127,"_13":128,"_39":129,"_41":111,"_43":44,"_45":112,"_47":48,"_49":130,"_17":51,"_52":24,"_54":131,"_56":57,"_58":-5,"_91":357,"_18":358},{"_36":119,"_13":120,"_39":121,"_41":111,"_43":44,"_45":122,"_47":48,"_49":123,"_17":51,"_52":53,"_54":124,"_56":57,"_58":-5,"_91":355,"_18":356},{"_36":94,"_13":95,"_39":96,"_41":-5,"_43":44,"_45":97,"_47":48,"_49":98,"_17":51,"_52":79,"_54":-5,"_56":57,"_58":-5,"_91":353,"_18":354},{"_36":102,"_13":103,"_39":104,"_41":96,"_43":44,"_45":97,"_47":48,"_49":105,"_17":51,"_52":53,"_54":106,"_56":57,"_58":-5,"_91":351,"_18":352},{"_36":85,"_13":86,"_39":87,"_41":-5,"_43":44,"_45":88,"_47":48,"_49":89,"_17":51,"_52":24,"_54":90,"_56":57,"_58":-5,"_91":349,"_18":350},[],[86],[],[95,103],[347],[95],[],[110,120],[],[110,128],[],[110,135,147],[],[110,135,155],[],[110,135,163],[],[110,135,171],[],[110,135,179],[339,340,341,342,343],[110,135],[338,344,345],[110],[],[60,194],[],[60,61,38],[],[60,61,63],[],[60,61,70],[333,334,335],[60,61],[],[60,218,226],[],[60,218,234],[330,331],[60,218],[329,332,336],[60],["D",1747826310786],{"_11":12,"_292":288},{"_11":12,"_286":-5,"_287":288,"_249":250,"_289":290,"_291":57},{"_17":196,"_13":16,"_36":44,"_278":240,"_279":-5,"_280":-5,"_281":-5,"_282":-5,"_283":-5,"_284":14,"_285":12},"ctx",{"_271":-5,"_309":428,"_429":430,"_431":432,"_433":57,"_434":57,"_435":57,"_436":48,"_437":-5,"_438":-7,"_439":-7,"_440":51,"_441":57,"_442":57,"_443":-5,"_444":57,"_445":57,"_446":57,"_447":-5},"ENV",{"_399":400,"_401":402,"_403":16,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419,"_420":421,"_422":423,"_424":425,"_426":427},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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"]