[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_205":206,"_207":208},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","4b181376-3fa5-11f0-ad43-76b3cceeab13","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Skill, SkillMatch, Session, Progress, CommunityPost, CommunityComment } from \"../../shared/types.ts\";\n\n// User operations\nexport async function createUser(userData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO users_v1 (name, email, bio, avatar_url, timezone) \n VALUES (?, ?, ?, ?, ?) RETURNING *`,\n [userData.name, userData.email, userData.bio, userData.avatar_url || null, userData.timezone]\n );\n return result[0] as User;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM users_v1 WHERE id = ?`, [id]);\n return result[0] as User || null;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM users_v1 WHERE email = ?`, [email]);\n return result[0] as User || null;\n}\n\nexport async function updateUser(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => key !== 'id' && key !== 'created_at');\n const values = fields.map(field => updates[field as keyof User]);\n const setClause = fields.map(field => `${field} = ?`).join(', ');\n \n const result = await sqlite.execute(\n `UPDATE users_v1 SET ${setClause} WHERE id = ? RETURNING *`,\n [...values, id]\n );\n return result[0] as User || null;\n}\n\n// Skill operations\nexport async function createSkill(skillData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO skills_v1 (user_id, name, category, type, proficiency_level, description) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING *`,\n [skillData.user_id, skillData.name, skillData.category, skillData.type, \n skillData.proficiency_level || null, skillData.description]\n );\n return result[0] as Skill;\n}\n\nexport async function getUserSkills(userId: number, type?: 'teach' | 'learn'): Promise {\n const query = type \n ? `SELECT * FROM skills_v1 WHERE user_id = ? AND type = ? ORDER BY created_at DESC`\n : `SELECT * FROM skills_v1 WHERE user_id = ? ORDER BY created_at DESC`;\n const params = type ? [userId, type] : [userId];\n \n const result = await sqlite.execute(query, params);\n return result as Skill[];\n}\n\nexport async function getSkillsByName(skillName: string, type: 'teach' | 'learn'): Promise {\n const result = await sqlite.execute(\n `SELECT s.*, u.name as user_name, u.rating as user_rating \n FROM skills_v1 s \n JOIN users_v1 u ON s.user_id = u.id \n WHERE s.name LIKE ? AND s.type = ? \n ORDER BY u.rating DESC`,\n [`%${skillName}%`, type]\n );\n return result as Skill[];\n}\n\nexport async function deleteSkill(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM skills_v1 WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n return result.changes > 0;\n}\n\n// Skill match operations\nexport async function createSkillMatch(matchData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO skill_matches_v1 (learner_id, teacher_id, skill_name, compatibility_score, ai_reasoning, status) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING *`,\n [matchData.learner_id, matchData.teacher_id, matchData.skill_name, \n matchData.compatibility_score, matchData.ai_reasoning, matchData.status]\n );\n return result[0] as SkillMatch;\n}\n\nexport async function getMatchesForUser(userId: number, status?: string): Promise {\n const query = status\n ? `SELECT m.*, \n l.name as learner_name, l.email as learner_email,\n t.name as teacher_name, t.email as teacher_email\n FROM skill_matches_v1 m\n JOIN users_v1 l ON m.learner_id = l.id\n JOIN users_v1 t ON m.teacher_id = t.id\n WHERE (m.learner_id = ? OR m.teacher_id = ?) AND m.status = ?\n ORDER BY m.created_at DESC`\n : `SELECT m.*, \n l.name as learner_name, l.email as learner_email,\n t.name as teacher_name, t.email as teacher_email\n FROM skill_matches_v1 m\n JOIN users_v1 l ON m.learner_id = l.id\n JOIN users_v1 t ON m.teacher_id = t.id\n WHERE m.learner_id = ? OR m.teacher_id = ?\n ORDER BY m.created_at DESC`;\n \n const params = status ? [userId, userId, status] : [userId, userId];\n const result = await sqlite.execute(query, params);\n return result as SkillMatch[];\n}\n\nexport async function updateMatchStatus(id: number, status: string): Promise {\n const result = await sqlite.execute(\n `UPDATE skill_matches_v1 SET status = ? WHERE id = ? RETURNING *`,\n [status, id]\n );\n return result[0] as SkillMatch || null;\n}\n\n// Session operations\nexport async function createSession(sessionData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO sessions_v1 (match_id, learner_id, teacher_id, skill_name, scheduled_at, duration_minutes, meeting_link, notes) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [sessionData.match_id, sessionData.learner_id, sessionData.teacher_id, sessionData.skill_name,\n sessionData.scheduled_at, sessionData.duration_minutes, sessionData.meeting_link || null, sessionData.notes || null]\n );\n return result[0] as Session;\n}\n\nexport async function getUserSessions(userId: number, status?: string): Promise {\n const query = status\n ? `SELECT s.*, \n l.name as learner_name, t.name as teacher_name\n FROM sessions_v1 s\n JOIN users_v1 l ON s.learner_id = l.id\n JOIN users_v1 t ON s.teacher_id = t.id\n WHERE (s.learner_id = ? OR s.teacher_id = ?) AND s.status = ?\n ORDER BY s.scheduled_at ASC`\n : `SELECT s.*, \n l.name as learner_name, t.name as teacher_name\n FROM sessions_v1 s\n JOIN users_v1 l ON s.learner_id = l.id\n JOIN users_v1 t ON s.teacher_id = t.id\n WHERE s.learner_id = ? OR s.teacher_id = ?\n ORDER BY s.scheduled_at ASC`;\n \n const params = status ? [userId, userId, status] : [userId, userId];\n const result = await sqlite.execute(query, params);\n return result as Session[];\n}\n\nexport async function updateSession(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => key !== 'id' && key !== 'created_at');\n const values = fields.map(field => updates[field as keyof Session]);\n const setClause = fields.map(field => `${field} = ?`).join(', ');\n \n const result = await sqlite.execute(\n `UPDATE sessions_v1 SET ${setClause} WHERE id = ? RETURNING *`,\n [...values, id]\n );\n return result[0] as Session || null;\n}\n\n// Progress operations\nexport async function upsertProgress(progressData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO progress_v1 (user_id, skill_name, current_level, sessions_completed, milestones_achieved, notes)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(user_id, skill_name) DO UPDATE SET\n current_level = excluded.current_level,\n sessions_completed = excluded.sessions_completed,\n milestones_achieved = excluded.milestones_achieved,\n notes = excluded.notes,\n updated_at = CURRENT_TIMESTAMP\n RETURNING *`,\n [progressData.user_id, progressData.skill_name, progressData.current_level,\n progressData.sessions_completed, JSON.stringify(progressData.milestones_achieved), progressData.notes]\n );\n return result[0] as Progress;\n}\n\nexport async function getUserProgress(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM progress_v1 WHERE user_id = ? ORDER BY updated_at DESC`,\n [userId]\n );\n return result.map(row => ({\n ...row,\n milestones_achieved: JSON.parse(row.milestones_achieved)\n })) as Progress[];\n}\n\n// Community operations\nexport async function createCommunityPost(postData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO community_posts_v1 (user_id, user_name, title, content, type, skill_tags) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING *`,\n [postData.user_id, postData.user_name, postData.title, postData.content, \n postData.type, JSON.stringify(postData.skill_tags)]\n );\n return {\n ...result[0],\n skill_tags: JSON.parse(result[0].skill_tags)\n } as CommunityPost;\n}\n\nexport async function getCommunityPosts(type?: string, limit: number = 20, offset: number = 0): Promise {\n const query = type\n ? `SELECT * FROM community_posts_v1 WHERE type = ? ORDER BY created_at DESC LIMIT ? OFFSET ?`\n : `SELECT * FROM community_posts_v1 ORDER BY created_at DESC LIMIT ? OFFSET ?`;\n \n const params = type ? [type, limit, offset] : [limit, offset];\n const result = await sqlite.execute(query, params);\n \n return result.map(row => ({\n ...row,\n skill_tags: JSON.parse(row.skill_tags)\n })) as CommunityPost[];\n}\n\nexport async function createCommunityComment(commentData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO community_comments_v1 (post_id, user_id, user_name, content) \n VALUES (?, ?, ?, ?) RETURNING *`,\n [commentData.post_id, commentData.user_id, commentData.user_name, commentData.content]\n );\n return result[0] as CommunityComment;\n}\n\nexport async function getPostComments(postId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM community_comments_v1 WHERE post_id = ? ORDER BY created_at ASC`,\n [postId]\n );\n return result as CommunityComment[];\n}\n\nexport async function likePost(postId: number): Promise {\n const result = await sqlite.execute(\n `UPDATE community_posts_v1 SET likes = likes + 1 WHERE id = ?`,\n [postId]\n );\n return result.changes > 0;\n}","createdAt",["D",1748863961043],"branchVersion","branchId","f5948dd0-3fa4-11f0-aa05-76b3cceeab13","id","f5940a7c-3fa4-11f0-aa05-76b3cceeab13","skillswapapappforcommunityskillexchange",["D",1748863817576],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","a37c0b00-3fa3-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","aa51fa98-a743-4468-8b23-b215c685353a","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Cess","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd5MjRkTHcyazFycGoycnREVHZIWXlnZGkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":201,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":202,"_78":203,"_80":204,"_82":24},"tree",[160,164,166],"files",[160,161,162,163,164,165,166],"counts",{"_150":133,"_151":60,"_152":133,"_153":154,"_155":156},"contents",[124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":144,"_31":145,"_29":146,"_130":-5,"_40":41,"_39":147,"_131":56,"_37":148,"_13":133,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":149},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_131":56,"_37":141,"_13":133,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":143},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":60,"_131":56,"_37":132,"_13":133,"_33":20,"_35":134,"_23":24,"_135":-5,"_26":136},"1e54aa5c-3fa5-11f0-b6a3-76b3cceeab13","README.md","1e54aaf2-3fa5-11f0-b6a3-76b3cceeab13","parentId","latest",["D",1748863885941],0,"# SkillSwap AI\n\nA community-driven skill-sharing platform that uses AI to match learners with teachers, featuring intelligent matching, scheduling, progress tracking, and community engagement.\n\n## Features\n\n- **AI-Powered Matching**: Uses TonyAI to intelligently match learners with compatible teachers based on skills, availability, and learning preferences\n- **Skill Management**: Users can list skills they want to learn and skills they can teach\n- **Smart Scheduling**: Integrated calendar system for booking and managing learning sessions\n- **Progress Tracking**: Track learning milestones and achievements\n- **Community Board**: Share experiences, ask questions, and celebrate successes\n- **User Profiles**: Comprehensive profiles with skills, ratings, and availability\n\n## Tech Stack\n\n- **Backend**: Hono.js API with SQLite database\n- **Frontend**: React with TypeScript and TailwindCSS\n- **AI**: TonyAI for intelligent matching\n- **Storage**: Val Town SQLite for data persistence\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── users.ts # User management\n│ │ ├── skills.ts # Skill operations\n│ │ ├── matching.ts # AI matching logic\n│ │ ├── sessions.ts # Session scheduling\n│ │ ├── community.ts # Community board\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application\n│ │ ├── UserProfile.tsx # User profile management\n│ │ ├── SkillMatcher.tsx # AI matching interface\n│ │ ├── Scheduler.tsx # Session scheduling\n│ │ ├── ProgressTracker.tsx # Progress tracking\n│ │ └── CommunityBoard.tsx # Community features\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The app runs on Val Town with HTTP trigger\n2. Visit the main URL to access the platform\n3. Create a profile and add your skills\n4. Use AI matching to find learning partners\n5. Schedule sessions and track your progress\n6. Engage with the community board\n\n## Environment Variables\n\n- `OPENAI_API_KEY`: Required for AI matching functionality","label",[128],"263c1ebc-3fa5-11f0-b424-76b3cceeab13","shared","40719501-6aa0-4845-938d-a4f0777f0cad",2,["D",1748863899196],"directory",[138],"32eeced4-3fa5-11f0-8de5-76b3cceeab13","backend","58ca6478-e48f-4149-9238-705f9b02a9af",3,["D",1748863920489],[145],"pulls","branches","forks","envVars",{"_157":133,"_159":133},"connections",{"_157":133,"_158":133},"count","unfilledCount","emptyCount",{"_42":144,"_31":145,"_29":146,"_130":-5,"_40":41,"_39":147,"_131":56,"_37":198,"_13":133,"_33":142,"_35":-5,"_23":24,"_135":-5,"_168":199,"_26":200},{"_42":194,"_31":186,"_29":182,"_130":146,"_40":41,"_39":147,"_131":56,"_37":195,"_13":133,"_33":142,"_35":-5,"_23":24,"_135":-5,"_168":196,"_26":197},{"_42":187,"_31":188,"_29":189,"_130":182,"_40":41,"_39":147,"_131":56,"_37":190,"_13":133,"_33":34,"_35":191,"_23":24,"_135":-5,"_168":192,"_26":193},{"_42":181,"_31":32,"_29":30,"_130":182,"_40":41,"_39":14,"_131":24,"_37":183,"_13":133,"_33":34,"_35":36,"_23":24,"_135":-5,"_168":184,"_26":185},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_131":56,"_37":178,"_13":133,"_33":142,"_35":-5,"_23":24,"_135":-5,"_168":179,"_26":180},{"_42":171,"_31":172,"_29":173,"_130":139,"_40":41,"_39":140,"_131":24,"_37":174,"_13":133,"_33":34,"_35":175,"_23":24,"_135":-5,"_168":176,"_26":177},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":60,"_131":56,"_37":167,"_13":133,"_33":20,"_35":134,"_23":24,"_135":-5,"_168":169,"_26":170},["D",1748863885941],"children",[],[128],"263c1282-3fa5-11f0-b424-76b3cceeab13","types.ts","263c1368-3fa5-11f0-b424-76b3cceeab13",["D",1748863899196],"// Shared types for SkillSwap AI\n\nexport interface User {\n id: number;\n name: string;\n email: string;\n bio: string;\n avatar_url?: string;\n timezone: string;\n created_at: string;\n rating: number;\n total_sessions: number;\n}\n\nexport interface Skill {\n id: number;\n user_id: number;\n name: string;\n category: string;\n type: 'teach' | 'learn';\n proficiency_level?: 'beginner' | 'intermediate' | 'advanced' | 'expert';\n description: string;\n created_at: string;\n}\n\nexport interface SkillMatch {\n id: number;\n learner_id: number;\n teacher_id: number;\n skill_name: string;\n compatibility_score: number;\n ai_reasoning: string;\n status: 'pending' | 'accepted' | 'declined' | 'completed';\n created_at: string;\n}\n\nexport interface Session {\n id: number;\n match_id: number;\n learner_id: number;\n teacher_id: number;\n skill_name: string;\n scheduled_at: string;\n duration_minutes: number;\n status: 'scheduled' | 'completed' | 'cancelled' | 'no_show';\n meeting_link?: string;\n notes?: string;\n learner_rating?: number;\n teacher_rating?: number;\n created_at: string;\n}\n\nexport interface Progress {\n id: number;\n user_id: number;\n skill_name: string;\n current_level: 'beginner' | 'intermediate' | 'advanced' | 'expert';\n sessions_completed: number;\n milestones_achieved: string[];\n notes: string;\n updated_at: string;\n}\n\nexport interface CommunityPost {\n id: number;\n user_id: number;\n user_name: string;\n title: string;\n content: string;\n type: 'question' | 'success_story' | 'tip' | 'general';\n skill_tags: string[];\n likes: number;\n created_at: string;\n}\n\nexport interface CommunityComment {\n id: number;\n post_id: number;\n user_id: number;\n user_name: string;\n content: string;\n created_at: string;\n}\n\nexport interface MatchingRequest {\n userId: number;\n skillsToLearn: string[];\n preferredTeachingStyle?: string;\n availability?: string[];\n maxDistance?: number;\n}\n\nexport interface MatchingResponse {\n matches: Array<{\n teacher: User;\n skill: Skill;\n compatibilityScore: number;\n reasoning: string;\n }>;\n}\n\nexport interface SchedulingRequest {\n matchId: number;\n preferredTimes: string[];\n duration: number;\n notes?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[138,172],["D",1748863899196],[165],[138],"4b1812a4-3fa5-11f0-ad43-76b3cceeab13","9569732a-62bc-445b-9421-9ed3e3701759",["D",1748863961043],[],[145,186,32],"database","32eebf98-3fa5-11f0-8de5-76b3cceeab13","migrations.ts","32eec06a-3fa5-11f0-8de5-76b3cceeab13",["D",1748863920489],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database schema for SkillSwap AI\n// Change table names when modifying schemas (add _2, _3, etc.)\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n bio TEXT DEFAULT '',\n avatar_url TEXT,\n timezone TEXT DEFAULT 'UTC',\n rating REAL DEFAULT 0.0,\n total_sessions INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Skills table - tracks both skills users can teach and want to learn\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS skills_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n category TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('teach', 'learn')),\n proficiency_level TEXT CHECK (proficiency_level IN ('beginner', 'intermediate', 'advanced', 'expert')),\n description TEXT DEFAULT '',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Skill matches - AI-generated matches between learners and teachers\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS skill_matches_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n learner_id INTEGER NOT NULL,\n teacher_id INTEGER NOT NULL,\n skill_name TEXT NOT NULL,\n compatibility_score REAL NOT NULL,\n ai_reasoning TEXT NOT NULL,\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'accepted', 'declined', 'completed')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (learner_id) REFERENCES users_v1 (id),\n FOREIGN KEY (teacher_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Sessions - scheduled learning sessions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n match_id INTEGER NOT NULL,\n learner_id INTEGER NOT NULL,\n teacher_id INTEGER NOT NULL,\n skill_name TEXT NOT NULL,\n scheduled_at DATETIME NOT NULL,\n duration_minutes INTEGER DEFAULT 60,\n status TEXT DEFAULT 'scheduled' CHECK (status IN ('scheduled', 'completed', 'cancelled', 'no_show')),\n meeting_link TEXT,\n notes TEXT,\n learner_rating INTEGER CHECK (learner_rating BETWEEN 1 AND 5),\n teacher_rating INTEGER CHECK (teacher_rating BETWEEN 1 AND 5),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (match_id) REFERENCES skill_matches_v1 (id),\n FOREIGN KEY (learner_id) REFERENCES users_v1 (id),\n FOREIGN KEY (teacher_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Progress tracking\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS progress_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n skill_name TEXT NOT NULL,\n current_level TEXT DEFAULT 'beginner' CHECK (current_level IN ('beginner', 'intermediate', 'advanced', 'expert')),\n sessions_completed INTEGER DEFAULT 0,\n milestones_achieved TEXT DEFAULT '[]', -- JSON array of milestone strings\n notes TEXT DEFAULT '',\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id),\n UNIQUE(user_id, skill_name)\n )\n `);\n\n // Community posts\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS community_posts_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n user_name TEXT NOT NULL,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n type TEXT DEFAULT 'general' CHECK (type IN ('question', 'success_story', 'tip', 'general')),\n skill_tags TEXT DEFAULT '[]', -- JSON array of skill tags\n likes INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Community comments\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS community_comments_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n user_name TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (post_id) REFERENCES community_posts_v1 (id),\n FOREIGN KEY (user_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_user_type ON skills_v1 (user_id, type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_name_type ON skills_v1 (name, type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_status ON skill_matches_v1 (status)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_sessions_scheduled ON sessions_v1 (scheduled_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_posts_type ON community_posts_v1 (type, created_at DESC)`);\n\n console.log(\"Database migrations completed successfully\");\n}",[],[145,186,188],"32eed5a0-3fa5-11f0-8de5-76b3cceeab13",["D",1748863920489],[162,163],[145,186],["D",1748863920489],[161],[145],["D",1748863817576],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":238,"_239":240,"_241":242,"_243":24,"_244":24,"_245":24,"_246":56,"_247":-5,"_248":-7,"_249":-7,"_250":133,"_251":24,"_252":24,"_253":-5,"_254":24,"_255":24,"_256":24,"_257":-5},"ENV",{"_209":210,"_211":212,"_213":84,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237},"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 · v4