[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_215":216,"_217":218},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"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":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",5,"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","74e24d6a-3f97-11f0-bcad-76b3cceeab13","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { User, Property, Payment, Booking, ChatMessage } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (id, name, email, phone) VALUES (?, ?, ?, ?)`,\n [user.id, user.name, user.email, user.phone]\n );\n \n return {\n ...user,\n interests: [],\n payments: [],\n bookings: []\n };\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n const interests = await getUserInterests(id);\n const payments = await getUserPayments(id);\n const bookings = await getUserBookings(id);\n \n return {\n id: user.id,\n name: user.name,\n email: user.email,\n phone: user.phone,\n interests,\n payments,\n bookings\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE email = ?`,\n [email]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n return getUserById(user.id);\n}\n\n// Property queries\nexport async function createProperty(property: Property): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.PROPERTIES} \n (id, garden_id, plot_number, size, price, status, description, coordinates_lat, coordinates_lng) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n property.id,\n property.gardenId,\n property.plotNumber,\n property.size,\n property.price,\n property.status,\n property.description,\n property.coordinates?.lat || null,\n property.coordinates?.lng || null\n ]\n );\n \n return property;\n}\n\nexport async function getPropertiesByGarden(gardenId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PROPERTIES} WHERE garden_id = ? ORDER BY plot_number`,\n [gardenId]\n );\n \n return result.map(row => ({\n id: row.id,\n gardenId: row.garden_id,\n plotNumber: row.plot_number,\n size: row.size,\n price: row.price,\n status: row.status as Property['status'],\n description: row.description,\n coordinates: row.coordinates_lat && row.coordinates_lng ? {\n lat: row.coordinates_lat,\n lng: row.coordinates_lng\n } : undefined\n }));\n}\n\nexport async function getAvailableProperties(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PROPERTIES} WHERE status = 'available' ORDER BY garden_id, plot_number`\n );\n \n return result.map(row => ({\n id: row.id,\n gardenId: row.garden_id,\n plotNumber: row.plot_number,\n size: row.size,\n price: row.price,\n status: row.status as Property['status'],\n description: row.description,\n coordinates: row.coordinates_lat && row.coordinates_lng ? {\n lat: row.coordinates_lat,\n lng: row.coordinates_lng\n } : undefined\n }));\n}\n\n// Payment queries\nexport async function createPayment(payment: Payment): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.PAYMENTS} \n (id, user_id, property_id, amount, currency, status, payment_method, reference) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n payment.id,\n payment.userId,\n payment.propertyId,\n payment.amount,\n payment.currency,\n payment.status,\n payment.paymentMethod,\n payment.id // Using payment ID as reference for now\n ]\n );\n \n return payment;\n}\n\nexport async function updatePaymentStatus(paymentId: string, status: Payment['status']): Promise {\n const completedAt = status === 'completed' ? new Date().toISOString() : null;\n \n await sqlite.execute(\n `UPDATE ${TABLES.PAYMENTS} SET status = ?, completed_at = ? WHERE id = ?`,\n [status, completedAt, paymentId]\n );\n}\n\nexport async function getUserPayments(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PAYMENTS} 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 propertyId: row.property_id,\n amount: row.amount,\n currency: row.currency,\n status: row.status as Payment['status'],\n paymentMethod: row.payment_method,\n createdAt: row.created_at,\n completedAt: row.completed_at\n }));\n}\n\n// Booking queries\nexport async function createBooking(booking: Booking): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.BOOKINGS} (id, user_id, property_id, status, notes) \n VALUES (?, ?, ?, ?, ?)`,\n [booking.id, booking.userId, booking.propertyId, booking.status, booking.notes]\n );\n \n return booking;\n}\n\nexport async function getUserBookings(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.BOOKINGS} 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 propertyId: row.property_id,\n status: row.status as Booking['status'],\n createdAt: row.created_at,\n notes: row.notes\n }));\n}\n\n// Interest queries\nexport async function addUserInterest(userId: string, gardenId: string): Promise {\n const interestId = Math.random().toString(36).substr(2, 9);\n \n await sqlite.execute(\n `INSERT OR IGNORE INTO ${TABLES.INTERESTS} (id, user_id, garden_id) VALUES (?, ?, ?)`,\n [interestId, userId, gardenId]\n );\n}\n\nexport async function removeUserInterest(userId: string, gardenId: string): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLES.INTERESTS} WHERE user_id = ? AND garden_id = ?`,\n [userId, gardenId]\n );\n}\n\nexport async function getUserInterests(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT garden_id FROM ${TABLES.INTERESTS} WHERE user_id = ?`,\n [userId]\n );\n \n return result.map(row => row.garden_id);\n}\n\n// Chat queries\nexport async function saveChatMessage(message: Omit): Promise {\n const id = Math.random().toString(36).substr(2, 9);\n \n await sqlite.execute(\n `INSERT INTO ${TABLES.CHAT_MESSAGES} (id, session_id, message, sender) VALUES (?, ?, ?, ?)`,\n [id, message.timestamp, message.message, message.sender] // Using timestamp as session_id for simplicity\n );\n \n return { ...message, id };\n}\n\nexport async function getChatMessages(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.CHAT_MESSAGES} WHERE session_id = ? ORDER BY created_at ASC`,\n [sessionId]\n );\n \n return result.map(row => ({\n id: row.id,\n message: row.message,\n sender: row.sender as ChatMessage['sender'],\n timestamp: row.created_at\n }));\n}","createdAt",["D",1748858018202],"branchVersion","branchId","152faf2c-3f95-11f0-b173-76b3cceeab13","id","152f65bc-3f95-11f0-b173-76b3cceeab13","Eaglemajdes",["D",1748856998657],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","872916a2-3f97-11f0-a526-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","180d29bb-29b4-41f4-a984-6297ecbf663d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",27,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","godinoarts","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":211,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":212,"_79":213,"_81":214,"_83":24},"tree",[161,165,168],"files",[161,162,163,164,165,166,167,168],"counts",{"_151":61,"_152":141,"_153":61,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":149,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":142,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":24,"_37":134,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"48fd236e-3f97-11f0-bcf9-76b3cceeab13","README.md","48fd2418-3f97-11f0-bcf9-76b3cceeab13","parentId",1,"latest",["D",1748857944556],"# Eagle Majdes Homes and Services Website\n\nA professional real estate website for Eagle Majdes Homes and Services, specializing in estate development and land sales.\n\n## Project Structure\n\n### Backend (`/backend/`)\n- `index.ts` - Main Hono server with API routes\n- `database/` - SQLite database setup and queries\n- `routes/` - API route handlers\n\n### Frontend (`/frontend/`)\n- `index.html` - Main HTML template\n- `index.tsx` - React application entry point\n- `components/` - React components\n- `style.css` - Custom styles\n\n### Shared (`/shared/`)\n- `types.ts` - TypeScript interfaces and types\n- `utils.ts` - Shared utility functions\n\n## Features\n\n- 🏡 Multiple estate \"Gardens\" showcase\n- 💰 Payment system with Naira (₦) support\n- 👤 User dashboard for tracking interests and payments\n- 💬 Live chat support\n- 📱 Responsive design\n- 🎨 Modern UI with icons and clean design\n\n## Gardens/Estates\n\n1. Jason's Garden\n2. Eagle's Garden\n3. Victoria's Garden\n4. Samuel's Garden\n5. Grace's Garden\n6. David's Garden\n7. Faith's Garden\n\n## Locations\n\n- Most gardens: Ogbeke Nike, Ama-Awji Nike, Agbogazi Nike\n- One estate: Centenary City, Enugu\n\n## Contact Information\n\n**Phone:** 08164878281, 09031232662, 09029217460\n**Address:** Suite C15 Elim Plaza, Ebeano Tunnel, Ogui Enugu, Enugu State\n**Social Media:** Facebook: Eagle_Majdes, Instagram: EagleMajdes, TikTok: Eagle_Majdesltd","label",[129],"564c512a-3f97-11f0-9d7b-76b3cceeab13","shared","0b2e8428-772a-40b5-94ae-735ce56fc29e",2,["D",1748857966884],"directory",[139],"644f5e98-3f97-11f0-9634-76b3cceeab13","backend","4eb8dc60-c7e4-46b4-b604-701b790434da",4,["D",1748857990392],[146],"pulls","branches","forks","envVars",{"_158":61,"_160":61},"connections",{"_158":61,"_159":61},"count","unfilledCount","emptyCount",{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":57,"_37":208,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_170":209,"_26":210},{"_42":204,"_31":196,"_29":192,"_131":147,"_40":41,"_39":148,"_133":57,"_37":205,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_170":206,"_26":207},{"_42":197,"_31":198,"_29":199,"_131":192,"_40":41,"_39":148,"_133":57,"_37":200,"_13":61,"_33":34,"_35":201,"_23":24,"_136":-5,"_170":202,"_26":203},{"_42":191,"_31":32,"_29":30,"_131":192,"_40":41,"_39":14,"_133":57,"_37":193,"_13":61,"_33":34,"_35":36,"_23":24,"_136":-5,"_170":194,"_26":195},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":57,"_37":188,"_13":61,"_33":143,"_35":-5,"_23":24,"_136":-5,"_170":189,"_26":190},{"_42":181,"_31":182,"_29":183,"_131":140,"_40":41,"_39":141,"_133":57,"_37":184,"_13":61,"_33":34,"_35":185,"_23":24,"_136":-5,"_170":186,"_26":187},{"_42":173,"_31":174,"_29":175,"_131":140,"_40":41,"_39":176,"_133":57,"_37":177,"_13":61,"_33":34,"_35":178,"_23":24,"_136":-5,"_170":179,"_26":180},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":24,"_37":169,"_13":61,"_33":20,"_35":135,"_23":24,"_136":-5,"_170":171,"_26":172},["D",1748857944556],"children",[],[129],"5be10aae-3f97-11f0-a968-76b3cceeab13","utils.ts","5be10b44-3f97-11f0-a968-76b3cceeab13",3,["D",1748857976252],"// Shared utility functions\n\nexport function formatCurrency(amount: number, currency: string = 'NGN'): string {\n if (currency === 'NGN') {\n return `₦${amount.toLocaleString()}`;\n }\n return `${currency} ${amount.toLocaleString()}`;\n}\n\nexport function formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n}\n\nexport function generateId(): string {\n return Math.random().toString(36).substr(2, 9);\n}\n\nexport function slugify(text: string): string {\n return text\n .toLowerCase()\n .replace(/[^\\w\\s-]/g, '')\n .replace(/[\\s_-]+/g, '-')\n .replace(/^-+|-+$/g, '');\n}\n\nexport function validateEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\nexport function validatePhone(phone: string): boolean {\n const phoneRegex = /^[\\+]?[0-9\\s\\-\$\$]{10,}$/;\n return phoneRegex.test(phone);\n}\n\nexport function truncateText(text: string, maxLength: number): string {\n if (text.length <= maxLength) return text;\n return text.substr(0, maxLength) + '...';\n}\n\nexport function getInitials(name: string): string {\n return name\n .split(' ')\n .map(word => word.charAt(0).toUpperCase())\n .join('')\n .substr(0, 2);\n}",[],[139,174],"564c41c6-3f97-11f0-9d7b-76b3cceeab13","types.ts","564c427a-3f97-11f0-9d7b-76b3cceeab13",["D",1748857966884],"// Shared TypeScript types and interfaces\n\nexport interface Garden {\n id: string;\n name: string;\n location: string;\n description: string;\n priceRange: string;\n availablePlots: number;\n totalPlots: number;\n amenities: string[];\n images: string[];\n featured: boolean;\n}\n\nexport interface Property {\n id: string;\n gardenId: string;\n plotNumber: string;\n size: string;\n price: number;\n status: 'available' | 'reserved' | 'sold';\n description: string;\n coordinates?: {\n lat: number;\n lng: number;\n };\n}\n\nexport interface User {\n id: string;\n name: string;\n email: string;\n phone: string;\n interests: string[]; // Garden IDs\n payments: Payment[];\n bookings: Booking[];\n}\n\nexport interface Payment {\n id: string;\n userId: string;\n propertyId: string;\n amount: number;\n currency: 'NGN';\n status: 'pending' | 'completed' | 'failed';\n paymentMethod: string;\n createdAt: string;\n completedAt?: string;\n}\n\nexport interface Booking {\n id: string;\n userId: string;\n propertyId: string;\n status: 'pending' | 'confirmed' | 'cancelled';\n createdAt: string;\n notes?: string;\n}\n\nexport interface ChatMessage {\n id: string;\n message: string;\n sender: 'user' | 'support';\n timestamp: string;\n}\n\nexport interface ContactInfo {\n phones: string[];\n address: string;\n social: {\n facebook: string;\n instagram: string;\n tiktok: string;\n };\n}\n\nexport const CONTACT_INFO: ContactInfo = {\n phones: ['08164878281', '09031232662', '09029217460'],\n address: 'Suite C15 Elim Plaza, Ebeano Tunnel, Ogui Enugu, Enugu State',\n social: {\n facebook: 'Eagle_Majdes',\n instagram: 'EagleMajdes',\n tiktok: 'Eagle_Majdesltd'\n }\n};\n\nexport const GARDENS_DATA: Garden[] = [\n {\n id: 'jasons-garden',\n name: \"Jason's Garden\",\n location: 'Ogbeke Nike',\n description: 'A premium residential estate with modern amenities and excellent infrastructure.',\n priceRange: '₦2.5M - ₦5M',\n availablePlots: 45,\n totalPlots: 100,\n amenities: ['24/7 Security', 'Good Road Network', 'Electricity', 'Water Supply', 'Drainage System'],\n images: [],\n featured: true\n },\n {\n id: 'eagles-garden',\n name: \"Eagle's Garden\",\n location: 'Ama-Awji Nike',\n description: 'Our flagship estate offering luxury living with comprehensive facilities.',\n priceRange: '₦3M - ₦7M',\n availablePlots: 32,\n totalPlots: 80,\n amenities: ['Gated Community', 'Recreation Center', 'Shopping Complex', 'School', 'Hospital'],\n images: [],\n featured: true\n },\n {\n id: 'victorias-garden',\n name: \"Victoria's Garden\",\n location: 'Agbogazi Nike',\n description: 'Affordable housing solution with quality infrastructure and peaceful environment.',\n priceRange: '₦1.8M - ₦4M',\n availablePlots: 67,\n totalPlots: 120,\n amenities: ['Security', 'Road Network', 'Electricity', 'Water'],\n images: [],\n featured: false\n },\n {\n id: 'samuels-garden',\n name: \"Samuel's Garden\",\n location: 'Ogbeke Nike',\n description: 'Family-oriented estate with excellent connectivity and modern amenities.',\n priceRange: '₦2.2M - ₦4.5M',\n availablePlots: 28,\n totalPlots: 90,\n amenities: ['Playground', 'Security', 'Good Roads', 'Power Supply'],\n images: [],\n featured: false\n },\n {\n id: 'graces-garden',\n name: \"Grace's Garden\",\n location: 'Centenary City, Enugu',\n description: 'Premium estate in the heart of Enugu with luxury amenities and prime location.',\n priceRange: '₦4M - ₦8M',\n availablePlots: 15,\n totalPlots: 50,\n amenities: ['Luxury Clubhouse', 'Swimming Pool', 'Gym', 'Security', 'Parking'],\n images: [],\n featured: true\n },\n {\n id: 'davids-garden',\n name: \"David's Garden\",\n location: 'Ama-Awji Nike',\n description: 'Serene residential estate perfect for young families and professionals.',\n priceRange: '₦2M - ₦4.2M',\n availablePlots: 41,\n totalPlots: 85,\n amenities: ['Security', 'Good Roads', 'Electricity', 'Water Supply'],\n images: [],\n featured: false\n },\n {\n id: 'faiths-garden',\n name: \"Faith's Garden\",\n location: 'Agbogazi Nike',\n description: 'Peaceful estate with natural surroundings and modern infrastructure.',\n priceRange: '₦1.9M - ₦3.8M',\n availablePlots: 53,\n totalPlots: 110,\n amenities: ['Green Spaces', 'Security', 'Road Network', 'Utilities'],\n images: [],\n featured: false\n }\n];",[],[139,182],["D",1748857966884],[166,167],[139],"74e24c2a-3f97-11f0-bcad-76b3cceeab13","f40c1e4f-74be-4df9-b2fe-9577187f3cfe",["D",1748858018202],[],[146,196,32],"database","644f50f6-3f97-11f0-9634-76b3cceeab13","migrations.ts","644f5344-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database table names with versioning for schema changes\nexport const TABLES = {\n USERS: 'eagle_majdes_users_v1',\n PROPERTIES: 'eagle_majdes_properties_v1',\n PAYMENTS: 'eagle_majdes_payments_v1',\n BOOKINGS: 'eagle_majdes_bookings_v1',\n INTERESTS: 'eagle_majdes_interests_v1',\n CHAT_MESSAGES: 'eagle_majdes_chat_messages_v1'\n};\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.USERS} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n phone TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Properties table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PROPERTIES} (\n id TEXT PRIMARY KEY,\n garden_id TEXT NOT NULL,\n plot_number TEXT NOT NULL,\n size TEXT NOT NULL,\n price INTEGER NOT NULL,\n status TEXT DEFAULT 'available' CHECK (status IN ('available', 'reserved', 'sold')),\n description TEXT,\n coordinates_lat REAL,\n coordinates_lng REAL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Payments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PAYMENTS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n property_id TEXT NOT NULL,\n amount INTEGER NOT NULL,\n currency TEXT DEFAULT 'NGN',\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'completed', 'failed')),\n payment_method TEXT,\n reference TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (property_id) REFERENCES ${TABLES.PROPERTIES}(id)\n )\n `);\n\n // Bookings table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.BOOKINGS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n property_id TEXT NOT NULL,\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'cancelled')),\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (property_id) REFERENCES ${TABLES.PROPERTIES}(id)\n )\n `);\n\n // User interests table (many-to-many relationship)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.INTERESTS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n garden_id TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n UNIQUE(user_id, garden_id)\n )\n `);\n\n // Chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.CHAT_MESSAGES} (\n id TEXT PRIMARY KEY,\n session_id TEXT NOT NULL,\n message TEXT NOT NULL,\n sender TEXT NOT NULL CHECK (sender IN ('user', 'support')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed successfully');\n}",[],[146,196,198],"644f6078-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],[163,164],[146,196],["D",1748857990392],[162],[146],["D",1748856998657],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":248,"_249":250,"_251":252,"_253":24,"_254":24,"_255":24,"_256":57,"_257":-5,"_258":-7,"_259":-7,"_260":61,"_261":24,"_262":24,"_263":-5,"_264":24,"_265":24,"_266":24,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":85,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","899124c68db8496248a17ee95f074b807335ea7b","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 · v5