[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_208":209,"_210":211},"routes/_app.x.$handle.$name",{"_99":98,"_32":50,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_21":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":25,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":-5,"_58":-5,"_18":59,"_60":-5,"_61":25,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",4,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","shared","latestPath","fileId","9f4e0aa7-01da-45f1-a4e4-e1f7c1456e8e","name","fileType","directory","content","createdAt",["D",1747679433031],"branchVersion","branchId","623b2c68-34de-11f0-a72c-9e149126039e",{"_30":43,"_32":44,"_33":45,"_35":46,"_36":47,"_38":14,"_39":40,"_24":25},"shared/types.ts","596100d0-34df-11f0-b1a5-9e149126039e","types.ts","script","// User types\nexport interface User {\n id: string;\n email: string;\n password_hash: string;\n full_name: string;\n created_at: number;\n updated_at: number;\n kyc_verified: boolean;\n is_admin: boolean;\n}\n\nexport interface UserRegistration {\n email: string;\n password: string;\n full_name: string;\n}\n\nexport interface UserLogin {\n email: string;\n password: string;\n}\n\nexport interface AuthResponse {\n token: string;\n user: Omit;\n}\n\n// KYC types\nexport type IdType = 'passport' | 'national_id' | 'drivers_license' | 'nin';\n\nexport interface KycSubmission {\n id: string;\n user_id: string;\n full_name: string;\n id_type: IdType;\n id_number: string;\n document_url: string;\n selfie_url: string;\n status: 'pending' | 'approved' | 'rejected';\n submitted_at: number;\n verified_at: number | null;\n}\n\nexport interface KycSubmissionRequest {\n full_name: string;\n id_type: IdType;\n id_number: string;\n document_url: string;\n selfie_url: string;\n}\n\n// Currency types\nexport type Currency = 'USD' | 'GBP' | 'NGN' | 'EUR';\n\n// Wallet types\nexport interface Wallet {\n id: string;\n user_id: string;\n currency: Currency;\n balance: number;\n account_number: string;\n bank_name?: string;\n routing_number?: string;\n sort_code?: string;\n iban?: string;\n bic?: string;\n nuban?: string;\n created_at: number;\n updated_at: number;\n}\n\nexport interface WalletCreationRequest {\n currency: Currency;\n}\n\n// Transaction types\nexport type TransactionType = 'deposit' | 'withdrawal' | 'transfer' | 'exchange';\nexport type TransactionStatus = 'pending' | 'completed' | 'failed';\n\nexport interface Transaction {\n id: string;\n user_id: string;\n transaction_type: TransactionType;\n from_wallet_id?: string;\n to_wallet_id?: string;\n from_currency?: Currency;\n to_currency?: Currency;\n amount: number;\n fee: number;\n exchange_rate?: number;\n status: TransactionStatus;\n reference?: string;\n description?: string;\n created_at: number;\n updated_at: number;\n}\n\nexport interface TransferRequest {\n from_currency: Currency;\n to_currency: Currency;\n amount: number;\n description?: string;\n}\n\nexport interface SendMoneyRequest {\n to_email: string;\n currency: Currency;\n amount: number;\n description?: string;\n}\n\n// Transaction limits\nexport type LimitType = 'daily_transfer' | 'single_transfer' | 'daily_withdrawal' | 'single_withdrawal';\n\nexport interface TransactionLimit {\n id: string;\n user_id: string;\n limit_type: LimitType;\n currency: Currency;\n amount: number;\n created_at: number;\n updated_at: number;\n}\n\nexport interface SetLimitRequest {\n limit_type: LimitType;\n currency: Currency;\n amount: number;\n}\n\n// Support chat types\nexport interface SupportChat {\n id: string;\n user_id: string;\n status: 'open' | 'closed';\n created_at: number;\n updated_at: number;\n}\n\nexport interface SupportMessage {\n id: string;\n chat_id: string;\n sender_type: 'user' | 'support';\n sender_id: string;\n message: string;\n created_at: number;\n}\n\nexport interface SendMessageRequest {\n chat_id: string;\n message: string;\n}\n\n// Webhook types\nexport interface WebhookEvent {\n event: string;\n currency: Currency;\n amount: string;\n wallet_id: string;\n user_id: string;\n}\n\n// Exchange rates\nexport interface ExchangeRate {\n from: Currency;\n to: Currency;\n rate: number;\n}",["D",1747679433031],"id","623af928-34de-11f0-a72c-9e149126039e","untitled-682",["D",1747679018388],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","180d29bb-29b4-41f4-a984-6297ecbf663d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":59,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_48":40,"_90":49,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":50,"_97":98},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","godinoarts","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":204,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":-5,"_58":-5,"_18":59,"_60":-5,"_61":25,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":205,"_83":206,"_85":207,"_87":25},"tree",[162,166,168],"files",[162,163,164,165,166,167,168],"counts",{"_152":65,"_153":136,"_154":65,"_155":156,"_157":158},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":146,"_32":147,"_30":148,"_135":-5,"_39":40,"_38":149,"_137":138,"_36":150,"_13":65,"_33":34,"_35":-5,"_24":25,"_141":-5,"_27":151},{"_48":143,"_32":28,"_30":31,"_135":-5,"_39":40,"_38":14,"_137":138,"_36":144,"_13":65,"_33":34,"_35":-5,"_24":25,"_141":-5,"_27":145},{"_48":132,"_32":133,"_30":134,"_135":-5,"_39":40,"_38":136,"_137":138,"_36":139,"_13":65,"_33":21,"_35":140,"_24":25,"_141":-5,"_27":142},"2c00934e-34df-11f0-9f57-9e149126039e","README.md","2c009420-34df-11f0-9f57-9e149126039e","parentId",1,"latest",true,["D",1747679356902],"# GodinoMawa Bank (GM)\n\nA fully functional digital banking application with multi-currency support, KYC verification, and real-time transactions.\n\n## Features\n\n- User authentication (register/login)\n- KYC submission with live camera and document upload\n- Multi-currency wallets (USD, GBP, NGN, EUR)\n- View bank details for each currency\n- Send and receive funds between wallets\n- Currency exchange\n- Transaction limits\n- Transaction history\n- Live support chat and email system\n- Admin webhook simulation for incoming transactions\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ ├── routes/ # Route modules\n│ │ ├── auth.ts # Authentication routes\n│ │ ├── kyc.ts # KYC verification routes\n│ │ ├── wallet.ts # Wallet management routes\n│ │ ├── transaction.ts # Transaction routes\n│ │ ├── support.ts # Support chat routes\n│ │ └── webhook.ts # Webhook simulation\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ ├── auth/ # Authentication components\n│ │ ├── kyc/ # KYC components\n│ │ ├── wallet/ # Wallet components\n│ │ ├── transaction/ # Transaction components\n│ │ └── support/ # Support chat components\n│ ├── pages/ # Page components\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ └── style.css\n└── shared/\n ├── types.ts # Shared type definitions\n └── utils.ts # Shared utility functions\n```\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript)\n- **Database**: SQLite\n- **Frontend**: React, TailwindCSS\n- **Authentication**: JWT\n- **Storage**: Val Town blob storage\n\n## Getting Started\n\nAccess the application at the provided HTTP endpoint.","label",[133],"5961346a-34df-11f0-b1a5-9e149126039e",["D",1747679433031],[28],"3683befe-34df-11f0-9fa9-9e149126039e","backend","3c713c03-5820-4fc0-80b9-8ae54bd02595",2,["D",1747679374537],[147],"pulls","branches","forks","envVars",{"_159":65,"_161":65},"connections",{"_159":65,"_160":65},"count","unfilledCount","emptyCount",{"_48":146,"_32":147,"_30":148,"_135":-5,"_39":40,"_38":149,"_137":138,"_36":201,"_13":65,"_33":34,"_35":-5,"_24":25,"_141":-5,"_170":202,"_27":203},{"_48":197,"_32":189,"_30":183,"_135":148,"_39":40,"_38":149,"_137":138,"_36":198,"_13":65,"_33":34,"_35":-5,"_24":25,"_141":-5,"_170":199,"_27":200},{"_48":190,"_32":191,"_30":192,"_135":183,"_39":40,"_38":149,"_137":138,"_36":193,"_13":65,"_33":45,"_35":194,"_24":25,"_141":-5,"_170":195,"_27":196},{"_48":180,"_32":181,"_30":182,"_135":183,"_39":40,"_38":184,"_137":138,"_36":185,"_13":65,"_33":45,"_35":186,"_24":25,"_141":-5,"_170":187,"_27":188},{"_48":143,"_32":28,"_30":31,"_135":-5,"_39":40,"_38":14,"_137":138,"_36":177,"_13":65,"_33":34,"_35":-5,"_24":25,"_141":-5,"_170":178,"_27":179},{"_48":173,"_32":44,"_30":43,"_135":31,"_39":40,"_38":14,"_137":138,"_36":174,"_13":65,"_33":45,"_35":46,"_24":25,"_141":-5,"_170":175,"_27":176},{"_48":132,"_32":133,"_30":134,"_135":-5,"_39":40,"_38":136,"_137":138,"_36":169,"_13":65,"_33":21,"_35":140,"_24":25,"_141":-5,"_170":171,"_27":172},["D",1747679356902],"children",[],[133],"5960ffe0-34df-11f0-b1a5-9e149126039e",["D",1747679433031],[],[28,44],["D",1747679433031],[167],[28],"4ef72124-34df-11f0-acaa-9e149126039e","queries.ts","4ef721d8-34df-11f0-acaa-9e149126039e","02f24975-7d7f-4c55-9bd4-d7d1215bdee1",3,["D",1747679415560],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { \n USERS_TABLE, \n KYC_TABLE, \n WALLETS_TABLE, \n TRANSACTIONS_TABLE,\n TRANSACTION_LIMITS_TABLE,\n SUPPORT_CHATS_TABLE,\n SUPPORT_MESSAGES_TABLE\n} from \"./migrations.ts\";\nimport { \n User, \n KycSubmission, \n Wallet, \n Transaction,\n TransactionLimit,\n SupportChat,\n SupportMessage,\n Currency\n} from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, email, password_hash, full_name, created_at, updated_at, kyc_verified, is_admin)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, user.email, user.password_hash, user.full_name, now, now, user.kyc_verified || false, user.is_admin || false]\n );\n \n return { id, ...user, created_at: now, updated_at: now };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as User;\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as User;\n}\n\nexport async function updateUserKycStatus(userId: string, verified: boolean): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET kyc_verified = ?, updated_at = ? WHERE id = ?`,\n [verified, now, userId]\n );\n}\n\n// KYC queries\nexport async function createKycSubmission(kyc: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n const status = \"pending\";\n \n await sqlite.execute(\n `INSERT INTO ${KYC_TABLE} (id, user_id, full_name, id_type, id_number, document_url, selfie_url, status, submitted_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, kyc.user_id, kyc.full_name, kyc.id_type, kyc.id_number, kyc.document_url, kyc.selfie_url, status, now]\n );\n \n return { id, ...kyc, status, submitted_at: now, verified_at: null };\n}\n\nexport async function getKycSubmissionByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${KYC_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as KycSubmission;\n}\n\nexport async function updateKycStatus(kycId: string, status: string): Promise {\n const now = Date.now();\n const verified_at = status === \"approved\" ? now : null;\n \n await sqlite.execute(\n `UPDATE ${KYC_TABLE} SET status = ?, verified_at = ? WHERE id = ?`,\n [status, verified_at, kycId]\n );\n \n if (status === \"approved\") {\n const kyc = await getKycById(kycId);\n if (kyc) {\n await updateUserKycStatus(kyc.user_id, true);\n }\n }\n}\n\nexport async function getKycById(kycId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${KYC_TABLE} WHERE id = ?`,\n [kycId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as KycSubmission;\n}\n\n// Wallet queries\nexport async function createWallet(wallet: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${WALLETS_TABLE} (\n id, user_id, currency, balance, account_number, bank_name, routing_number, \n sort_code, iban, bic, nuban, created_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, wallet.user_id, wallet.currency, wallet.balance || 0, wallet.account_number,\n wallet.bank_name, wallet.routing_number, wallet.sort_code, wallet.iban,\n wallet.bic, wallet.nuban, now, now\n ]\n );\n \n return { id, ...wallet, created_at: now, updated_at: now };\n}\n\nexport async function getWalletsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${WALLETS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows as Wallet[];\n}\n\nexport async function getWalletByUserIdAndCurrency(userId: string, currency: Currency): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${WALLETS_TABLE} WHERE user_id = ? AND currency = ?`,\n [userId, currency]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as Wallet;\n}\n\nexport async function getWalletById(walletId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${WALLETS_TABLE} WHERE id = ?`,\n [walletId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as Wallet;\n}\n\nexport async function updateWalletBalance(walletId: string, newBalance: number): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${WALLETS_TABLE} SET balance = ?, updated_at = ? WHERE id = ?`,\n [newBalance, now, walletId]\n );\n}\n\n// Transaction queries\nexport async function createTransaction(transaction: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS_TABLE} (\n id, user_id, transaction_type, from_wallet_id, to_wallet_id, from_currency, to_currency,\n amount, fee, exchange_rate, status, reference, description, created_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, transaction.user_id, transaction.transaction_type, transaction.from_wallet_id,\n transaction.to_wallet_id, transaction.from_currency, transaction.to_currency,\n transaction.amount, transaction.fee || 0, transaction.exchange_rate,\n transaction.status, transaction.reference, transaction.description, now, now\n ]\n );\n \n return { id, ...transaction, created_at: now, updated_at: now };\n}\n\nexport async function getTransactionsByUserId(userId: string, limit = 50, offset = 0): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE user_id = ? ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [userId, limit, offset]\n );\n \n return result.rows as Transaction[];\n}\n\nexport async function updateTransactionStatus(transactionId: string, status: string): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${TRANSACTIONS_TABLE} SET status = ?, updated_at = ? WHERE id = ?`,\n [status, now, transactionId]\n );\n}\n\n// Transaction limits queries\nexport async function setTransactionLimit(limit: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n // Check if limit already exists\n const existingLimit = await getTransactionLimitByTypeAndCurrency(limit.user_id, limit.limit_type, limit.currency);\n \n if (existingLimit) {\n // Update existing limit\n await sqlite.execute(\n `UPDATE ${TRANSACTION_LIMITS_TABLE} SET amount = ?, updated_at = ? WHERE id = ?`,\n [limit.amount, now, existingLimit.id]\n );\n \n return { ...existingLimit, amount: limit.amount, updated_at: now };\n } else {\n // Create new limit\n await sqlite.execute(\n `INSERT INTO ${TRANSACTION_LIMITS_TABLE} (id, user_id, limit_type, currency, amount, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [id, limit.user_id, limit.limit_type, limit.currency, limit.amount, now, now]\n );\n \n return { id, ...limit, created_at: now, updated_at: now };\n }\n}\n\nexport async function getTransactionLimitByTypeAndCurrency(\n userId: string, \n limitType: string, \n currency: Currency\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTION_LIMITS_TABLE} WHERE user_id = ? AND limit_type = ? AND currency = ?`,\n [userId, limitType, currency]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as TransactionLimit;\n}\n\nexport async function getTransactionLimitsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTION_LIMITS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows as TransactionLimit[];\n}\n\n// Support chat queries\nexport async function createSupportChat(userId: string): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n const status = \"open\";\n \n await sqlite.execute(\n `INSERT INTO ${SUPPORT_CHATS_TABLE} (id, user_id, status, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?)`,\n [id, userId, status, now, now]\n );\n \n return { id, user_id: userId, status, created_at: now, updated_at: now };\n}\n\nexport async function getSupportChatsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SUPPORT_CHATS_TABLE} WHERE user_id = ? ORDER BY updated_at DESC`,\n [userId]\n );\n \n return result.rows as SupportChat[];\n}\n\nexport async function updateSupportChatStatus(chatId: string, status: string): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${SUPPORT_CHATS_TABLE} SET status = ?, updated_at = ? WHERE id = ?`,\n [status, now, chatId]\n );\n}\n\n// Support message queries\nexport async function createSupportMessage(message: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${SUPPORT_MESSAGES_TABLE} (id, chat_id, sender_type, sender_id, message, created_at)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [id, message.chat_id, message.sender_type, message.sender_id, message.message, now]\n );\n \n // Update chat updated_at timestamp\n await sqlite.execute(\n `UPDATE ${SUPPORT_CHATS_TABLE} SET updated_at = ? WHERE id = ?`,\n [now, message.chat_id]\n );\n \n return { id, ...message, created_at: now };\n}\n\nexport async function getSupportMessagesByChatId(chatId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SUPPORT_MESSAGES_TABLE} WHERE chat_id = ? ORDER BY created_at ASC`,\n [chatId]\n );\n \n return result.rows as SupportMessage[];\n}",[],[147,189,181],"database","368386d2-34df-11f0-9fa9-9e149126039e","migrations.ts","36838786-34df-11f0-9fa9-9e149126039e",["D",1747679374537],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning to allow schema changes\nexport const USERS_TABLE = \"gm_users_v1\";\nexport const KYC_TABLE = \"gm_kyc_v1\";\nexport const WALLETS_TABLE = \"gm_wallets_v1\";\nexport const TRANSACTIONS_TABLE = \"gm_transactions_v1\";\nexport const TRANSACTION_LIMITS_TABLE = \"gm_transaction_limits_v1\";\nexport const SUPPORT_CHATS_TABLE = \"gm_support_chats_v1\";\nexport const SUPPORT_MESSAGES_TABLE = \"gm_support_messages_v1\";\n\n// Run all migrations\nexport async function runMigrations() {\n await createUsersTable();\n await createKycTable();\n await createWalletsTable();\n await createTransactionsTable();\n await createTransactionLimitsTable();\n await createSupportChatsTable();\n await createSupportMessagesTable();\n}\n\n// Create users table\nasync function createUsersTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n full_name TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n kyc_verified BOOLEAN DEFAULT FALSE,\n is_admin BOOLEAN DEFAULT FALSE\n )\n `);\n}\n\n// Create KYC table\nasync function createKycTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KYC_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n full_name TEXT NOT NULL,\n id_type TEXT NOT NULL,\n id_number TEXT NOT NULL,\n document_url TEXT NOT NULL,\n selfie_url TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n submitted_at INTEGER NOT NULL,\n verified_at INTEGER,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n}\n\n// Create wallets table\nasync function createWalletsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${WALLETS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n currency TEXT NOT NULL,\n balance REAL NOT NULL DEFAULT 0,\n account_number TEXT NOT NULL,\n bank_name TEXT,\n routing_number TEXT,\n sort_code TEXT,\n iban TEXT,\n bic TEXT,\n nuban TEXT,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE(user_id, currency)\n )\n `);\n}\n\n// Create transactions table\nasync function createTransactionsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n transaction_type TEXT NOT NULL,\n from_wallet_id TEXT,\n to_wallet_id TEXT,\n from_currency TEXT,\n to_currency TEXT,\n amount REAL NOT NULL,\n fee REAL NOT NULL DEFAULT 0,\n exchange_rate REAL,\n status TEXT NOT NULL,\n reference TEXT,\n description TEXT,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n FOREIGN KEY (from_wallet_id) REFERENCES ${WALLETS_TABLE} (id),\n FOREIGN KEY (to_wallet_id) REFERENCES ${WALLETS_TABLE} (id)\n )\n `);\n}\n\n// Create transaction limits table\nasync function createTransactionLimitsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTION_LIMITS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n limit_type TEXT NOT NULL,\n currency TEXT NOT NULL,\n amount REAL NOT NULL,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE(user_id, limit_type, currency)\n )\n `);\n}\n\n// Create support chats table\nasync function createSupportChatsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SUPPORT_CHATS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'open',\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n}\n\n// Create support messages table\nasync function createSupportMessagesTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SUPPORT_MESSAGES_TABLE} (\n id TEXT PRIMARY KEY,\n chat_id TEXT NOT NULL,\n sender_type TEXT NOT NULL,\n sender_id TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n FOREIGN KEY (chat_id) REFERENCES ${SUPPORT_CHATS_TABLE} (id)\n )\n `);\n}",[],[147,189,191],"3683c098-34df-11f0-9fa9-9e149126039e",["D",1747679374537],[164,165],[147,189],["D",1747679374537],[163],[147],["D",1747679018388],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":59,"_103":104,"_105":25},{"_13":88,"_32":89,"_48":40,"_90":49,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":50,"_97":98},"ctx",{"_81":-5,"_126":241,"_242":243,"_244":245,"_246":25,"_247":25,"_248":25,"_249":138,"_250":-5,"_251":-7,"_252":-7,"_253":65,"_254":25,"_255":25,"_256":-5,"_257":25,"_258":25,"_259":25,"_260":-5},"ENV",{"_212":213,"_214":215,"_216":89,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240},"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"]

Diff · v4