[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_263":264,"_265":266},"routes/_app.x.$handle.$name",{"_98":97,"_37":49,"_106":88,"_32":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_26":-5,"_118":-5,"_119":-5,"_120":30,"_121":122,"_123":30,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":-5,"_57":-5,"_19":58,"_59":-5,"_60":30,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":30},"version",11,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","bc4553f1-03d6-4e19-953f-2a5a64e116ae","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":26,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","src-tauri/src/commands/settings.rs","latestPath","fileId","a1333fd0-3156-11f1-91e0-42dde27851f2","name","settings.rs","fileType","content","use tauri::State;\nuse crate::AppState;\n\n#[tauri::command]\npub async fn set_gologin_token(\n token: String,\n state: State<'_, AppState>,\n) -> Result<(), String> {\n // Save to DB\n let db = state.db.lock().await;\n db.conn.execute(\n \"INSERT OR REPLACE INTO settings (key, value) VALUES ('gologin_token', ?1)\",\n rusqlite::params![token],\n ).map_err(|e| e.to_string())?;\n // Also update in-memory\n drop(db);\n let mut t = state.gologin_token.lock().await;\n *t = Some(token);\n Ok(())\n}\n\n#[tauri::command]\npub async fn get_gologin_token(state: State<'_, AppState>) -> Result, String> {\n let db = state.db.lock().await;\n let result: Result = db.conn.query_row(\n \"SELECT value FROM settings WHERE key = 'gologin_token'\",\n [],\n |row| row.get(0),\n );\n match result {\n Ok(token) => {\n drop(db);\n let mut t = state.gologin_token.lock().await;\n *t = Some(token.clone());\n Ok(Some(token))\n }\n Err(rusqlite::Error::QueryReturnedNoRows) => Ok(None),\n Err(e) => Err(e.to_string()),\n }\n}\n","createdAt",["D",1775438356660],"branchVersion","branchId","ec034a42-3155-11f1-86bb-42dde27851f2","id","ec02899a-3155-11f1-86bb-42dde27851f2","mmo",["D",1775438052675],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019d5bac-65a2-765b-bf0e-efaa6646838f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d5bac-65a2-765b-bf0e-f380c1f143d2","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_19":58,"_102":103,"_104":30},"branch",{"_13":87,"_37":88,"_47":46,"_89":48,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":49,"_96":97},"isOwned",39,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","v7er","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQnZCOXM2WDI0VTloakRTNmlXQzVDbFRxT0YifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":259,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":-5,"_57":-5,"_19":58,"_59":-5,"_60":30,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":260,"_82":261,"_84":262,"_86":30},"tree",[160,172],"files",[160,161,162,163,164,165,166,167,168,169,170,171,172],"counts",{"_150":64,"_151":138,"_152":64,"_153":154,"_155":156},"contents",[128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":143,"_37":144,"_35":145,"_133":-5,"_45":46,"_44":146,"_135":136,"_42":147,"_13":64,"_39":148,"_40":-5,"_29":30,"_141":-5,"_32":149},{"_47":130,"_37":131,"_35":132,"_133":-5,"_45":46,"_44":134,"_135":136,"_42":137,"_13":138,"_39":139,"_40":140,"_29":30,"_141":-5,"_32":142},"75ed3100-3156-11f1-8047-42dde27851f2","main.ts","ec05a30a-3155-11f1-86bb-42dde27851f2","parentId",2,"latest",true,["D",1775438284050],1,"script","// MMO — Multi-Account Manager (GoLogin + Tauri desktop app)\n// This val is the project scaffold. All source files live in sub-folders.\n// See README.md for setup instructions.\nexport const info = \"MMO Desktop App — see README.md\";\n","label",[131],"79b2a036-3156-11f1-ac11-42dde27851f2","src-tauri","ad641644-d40d-4703-a5fa-ca7de66815db",3,["D",1775438290378],"directory",[144],"pulls","branches","forks","envVars",{"_157":64,"_159":64},"connections",{"_157":64,"_158":64},"count","unfilledCount","emptyCount",{"_47":143,"_37":144,"_35":145,"_133":-5,"_45":46,"_44":146,"_135":136,"_42":256,"_13":64,"_39":148,"_40":-5,"_29":30,"_141":-5,"_174":257,"_32":258},{"_47":252,"_37":201,"_35":195,"_133":145,"_45":46,"_44":205,"_135":136,"_42":253,"_13":64,"_39":148,"_40":-5,"_29":30,"_141":-5,"_174":254,"_32":255},{"_47":248,"_37":239,"_35":235,"_133":195,"_45":46,"_44":243,"_135":136,"_42":249,"_13":64,"_39":148,"_40":-5,"_29":30,"_141":-5,"_174":250,"_32":251},{"_47":240,"_37":241,"_35":242,"_133":235,"_45":46,"_44":243,"_135":136,"_42":244,"_13":64,"_39":26,"_40":245,"_29":30,"_141":-5,"_174":246,"_32":247},{"_47":234,"_37":38,"_35":36,"_133":235,"_45":46,"_44":14,"_135":136,"_42":236,"_13":64,"_39":26,"_40":41,"_29":30,"_141":-5,"_174":237,"_32":238},{"_47":226,"_37":227,"_35":228,"_133":195,"_45":46,"_44":229,"_135":136,"_42":230,"_13":64,"_39":26,"_40":231,"_29":30,"_141":-5,"_174":232,"_32":233},{"_47":218,"_37":219,"_35":220,"_133":195,"_45":46,"_44":221,"_135":136,"_42":222,"_13":64,"_39":26,"_40":223,"_29":30,"_141":-5,"_174":224,"_32":225},{"_47":210,"_37":211,"_35":212,"_133":195,"_45":46,"_44":213,"_135":136,"_42":214,"_13":64,"_39":26,"_40":215,"_29":30,"_141":-5,"_174":216,"_32":217},{"_47":202,"_37":203,"_35":204,"_133":195,"_45":46,"_44":205,"_135":136,"_42":206,"_13":64,"_39":26,"_40":207,"_29":30,"_141":-5,"_174":208,"_32":209},{"_47":192,"_37":193,"_35":194,"_133":195,"_45":46,"_44":196,"_135":136,"_42":197,"_13":64,"_39":26,"_40":198,"_29":30,"_141":-5,"_174":199,"_32":200},{"_47":185,"_37":186,"_35":187,"_133":145,"_45":46,"_44":146,"_135":136,"_42":188,"_13":64,"_39":26,"_40":189,"_29":30,"_141":-5,"_174":190,"_32":191},{"_47":177,"_37":178,"_35":179,"_133":145,"_45":46,"_44":180,"_135":136,"_42":181,"_13":64,"_39":26,"_40":182,"_29":30,"_141":-5,"_174":183,"_32":184},{"_47":130,"_37":131,"_35":132,"_133":-5,"_45":46,"_44":134,"_135":136,"_42":173,"_13":138,"_39":139,"_40":140,"_29":30,"_141":-5,"_174":175,"_32":176},["D",1775438284050],"children",[],[131],"7d74bb1e-3156-11f1-8812-42dde27851f2","tauri.conf.json","7d74bbe6-3156-11f1-8812-42dde27851f2",4,["D",1775438296683],"{\n \"$schema\": \"https://schema.tauri.app/config/2\",\n \"productName\": \"MMO\",\n \"version\": \"0.1.0\",\n \"identifier\": \"com.v7er.mmo\",\n \"build\": {\n \"frontendDist\": \"../dist\",\n \"devUrl\": \"http://localhost:5173\",\n \"beforeDevCommand\": \"pnpm dev\",\n \"beforeBuildCommand\": \"pnpm build\"\n },\n \"app\": {\n \"windows\": [\n {\n \"title\": \"MMO — Multi-Account Manager\",\n \"width\": 1400,\n \"height\": 900,\n \"minWidth\": 1100,\n \"minHeight\": 700,\n \"decorations\": true,\n \"resizable\": true,\n \"center\": true\n }\n ],\n \"security\": {\n \"csp\": null\n }\n },\n \"bundle\": {\n \"active\": true,\n \"targets\": \"all\",\n \"icon\": [\n \"icons/32x32.png\",\n \"icons/128x128.png\",\n \"icons/128x128@2x.png\",\n \"icons/icon.icns\",\n \"icons/icon.ico\"\n ]\n },\n \"plugins\": {\n \"sql\": {\n \"preloadConnections\": [\"sqlite:mmo.db\"]\n },\n \"store\": {\n \"path\": \"mmo-store.json\"\n }\n }\n}\n",[],[144,178],"79b286fa-3156-11f1-ac11-42dde27851f2","Cargo.toml","79b287cc-3156-11f1-ac11-42dde27851f2",["D",1775438290378],"[package]\nname = \"mmo\"\nversion = \"0.1.0\"\ndescription = \"MMO — Multi-Account Manager with GoLogin\"\nauthors = [\"v7er\"]\nedition = \"2021\"\n\n[lib]\nname = \"mmo_lib\"\ncrate-type = [\"staticlib\", \"cdylib\", \"rlib\"]\n\n[build-dependencies]\ntauri-build = { version = \"2\", features = [] }\n\n[dependencies]\ntauri = { version = \"2\", features = [\"protocol-asset\"] }\ntauri-plugin-sql = { version = \"2\", features = [\"sqlite\"] }\ntauri-plugin-shell = { version = \"2\" }\ntauri-plugin-http = { version = \"2\" }\ntauri-plugin-store = { version = \"2\" }\nserde = { version = \"1\", features = [\"derive\"] }\nserde_json = \"1\"\nrusqlite = { version = \"0.31\", features = [\"bundled\"] }\ntokio = { version = \"1\", features = [\"full\"] }\nreqwest = { version = \"0.12\", features = [\"json\", \"rustls-tls\"], default-features = false }\nchrono = { version = \"0.4\", features = [\"serde\"] }\nuuid = { version = \"1\", features = [\"v4\", \"serde\"] }\nanyhow = \"1\"\nthiserror = \"1\"\nonce_cell = \"1\"\n\n[features]\ndefault = [\"custom-protocol\"]\ncustom-protocol = [\"tauri/custom-protocol\"]\n",[],[144,186],"93353d20-3156-11f1-93b7-42dde27851f2","models.rs","93353dca-3156-11f1-93b7-42dde27851f2","06a34471-d168-4c6e-8bc4-9065ecb4a2f5",8,["D",1775438333179],"use serde::{Deserialize, Serialize};\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct Team {\n pub id: String,\n pub name: String,\n pub description: String,\n pub color: String,\n pub created_at: String,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct Account {\n pub id: String,\n pub team_id: String,\n pub platform: String,\n pub username: String,\n pub display_name: String,\n pub avatar_url: String,\n pub gologin_profile_id: String,\n pub proxy: String,\n pub notes: String,\n pub status: String,\n pub last_active_at: Option,\n pub created_at: String,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct GologinProfile {\n pub id: String,\n pub name: String,\n pub os: String,\n pub notes: String,\n pub account_id: Option,\n pub synced_at: String,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct Post {\n pub id: String,\n pub account_id: String,\n pub platform: String,\n pub content: String,\n pub media_urls: String, // JSON array string\n pub status: String,\n pub scheduled_at: Option,\n pub published_at: Option,\n pub post_url: String,\n pub created_at: String,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct Activity {\n pub id: String,\n pub account_id: String,\n #[serde(rename = \"type\")]\n pub activity_type: String,\n pub target_url: String,\n pub target_name: String,\n pub content: String,\n pub status: String,\n pub done_at: String,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct Metric {\n pub id: String,\n pub account_id: String,\n pub date: String,\n pub platform: String,\n pub new_posts: i64,\n pub new_likes: i64,\n pub new_reacts: i64,\n pub new_comments: i64,\n pub new_friends: i64,\n pub new_followers: i64,\n pub profile_views: i64,\n pub reach: i64,\n pub comments_made: i64,\n pub friend_requests_sent: i64,\n pub messages_sent: i64,\n pub notes: String,\n pub created_at: String,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct DashboardStats {\n pub total_accounts: i64,\n pub active_accounts: i64,\n pub total_posts_today: i64,\n pub total_activities_today: i64,\n pub total_new_friends_today: i64,\n pub total_new_followers_today: i64,\n pub total_comments_today: i64,\n pub total_likes_today: i64,\n pub platform_breakdown: Vec,\n pub team_breakdown: Vec,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct PlatformStat {\n pub platform: String,\n pub count: i64,\n pub posts_today: i64,\n pub likes_today: i64,\n}\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct TeamStat {\n pub team_id: String,\n pub team_name: String,\n pub account_count: i64,\n pub posts_today: i64,\n}\n",[],[144,201,193],"src","7f030314-3156-11f1-8812-42dde27851f2","main.rs","7f0303c8-3156-11f1-8812-42dde27851f2",5,["D",1775438299295],"// Prevents additional console window on Windows in release\n#![cfg_attr(not(debug_assertions), windows_subsystem = \"windows\")]\n\nfn main() {\n mmo_lib::run();\n}\n",[],[144,201,203],"84c81abe-3156-11f1-93b7-42dde27851f2","lib.rs","84c81b9a-3156-11f1-93b7-42dde27851f2",6,["D",1775438308973],"mod db;\nmod commands;\nmod gologin;\nmod models;\n\nuse db::Database;\nuse std::sync::Arc;\nuse tokio::sync::Mutex;\n\npub struct AppState {\n pub db: Arc>,\n pub gologin_token: Arc>>,\n}\n\n#[cfg_attr(mobile, tauri::mobile_entry_point)]\npub fn run() {\n tauri::Builder::default()\n .plugin(tauri_plugin_shell::init())\n .plugin(tauri_plugin_http::init())\n .plugin(tauri_plugin_store::Builder::default().build())\n .setup(|app| {\n let app_dir = app.path().app_data_dir().expect(\"failed to get app data dir\");\n std::fs::create_dir_all(&app_dir).expect(\"failed to create app data dir\");\n let db_path = app_dir.join(\"mmo.db\");\n\n let db = tauri::async_runtime::block_on(async {\n Database::new(db_path.to_str().unwrap())\n .await\n .expect(\"failed to initialize database\")\n });\n\n app.manage(AppState {\n db: Arc::new(Mutex::new(db)),\n gologin_token: Arc::new(Mutex::new(None)),\n });\n\n Ok(())\n })\n .invoke_handler(tauri::generate_handler![\n // Settings\n commands::settings::set_gologin_token,\n commands::settings::get_gologin_token,\n // Teams & Apartments\n commands::teams::create_team,\n commands::teams::list_teams,\n commands::teams::update_team,\n commands::teams::delete_team,\n // Accounts\n commands::accounts::add_account,\n commands::accounts::list_accounts,\n commands::accounts::update_account,\n commands::accounts::delete_account,\n commands::accounts::get_account,\n // GoLogin Profiles\n commands::profiles::list_gologin_profiles,\n commands::profiles::launch_profile,\n commands::profiles::stop_profile,\n commands::profiles::sync_profiles,\n // Posts\n commands::posts::create_post,\n commands::posts::list_posts,\n commands::posts::delete_post,\n // Activities\n commands::activities::log_activity,\n commands::activities::list_activities,\n // Metrics (daily tracking)\n commands::metrics::record_metric,\n commands::metrics::get_metrics,\n commands::metrics::get_dashboard_stats,\n commands::metrics::get_metric_history,\n ])\n .run(tauri::generate_context!())\n .expect(\"error while running MMO application\");\n}\n",[],[144,201,211],"9bb1f2c2-3156-11f1-9811-42dde27851f2","gologin.rs","9bb1f3d0-3156-11f1-9811-42dde27851f2",9,["D",1775438347421],"use serde::{Deserialize, Serialize};\nuse anyhow::Result;\n\nconst GOLOGIN_API: &str = \"https://api.gologin.com\";\n\n#[derive(Debug, Serialize, Deserialize, Clone)]\npub struct GologinProfile {\n pub id: String,\n pub name: String,\n pub os: Option,\n pub notes: Option,\n}\n\n#[derive(Debug, Serialize, Deserialize)]\nstruct ProfilesResponse {\n profiles: Vec,\n}\n\npub struct GologinClient {\n token: String,\n client: reqwest::Client,\n}\n\nimpl GologinClient {\n pub fn new(token: &str) -> Self {\n Self {\n token: token.to_string(),\n client: reqwest::Client::new(),\n }\n }\n\n pub async fn list_profiles(&self) -> Result> {\n let url = format!(\"{}/browser?skip=0&limit=200\", GOLOGIN_API);\n let resp = self.client\n .get(&url)\n .bearer_auth(&self.token)\n .send()\n .await?;\n let body: serde_json::Value = resp.json().await?;\n let profiles = body[\"profiles\"]\n .as_array()\n .unwrap_or(&vec![])\n .iter()\n .filter_map(|p| {\n Some(GologinProfile {\n id: p[\"id\"].as_str()?.to_string(),\n name: p[\"name\"].as_str().unwrap_or(\"Unnamed\").to_string(),\n os: p[\"os\"].as_str().map(|s| s.to_string()),\n notes: p[\"notes\"].as_str().map(|s| s.to_string()),\n })\n })\n .collect();\n Ok(profiles)\n }\n\n pub async fn create_profile(&self, name: &str, os: &str) -> Result {\n let body = serde_json::json!({\n \"name\": name,\n \"os\": os,\n \"navigator\": {\n \"resolution\": \"1920x1080\",\n \"language\": \"en-US\",\n \"hardwareConcurrency\": 4,\n \"deviceMemory\": 8\n }\n });\n let resp = self.client\n .post(format!(\"{}/browser\", GOLOGIN_API))\n .bearer_auth(&self.token)\n .json(&body)\n .send()\n .await?;\n let p: serde_json::Value = resp.json().await?;\n Ok(GologinProfile {\n id: p[\"id\"].as_str().unwrap_or_default().to_string(),\n name: p[\"name\"].as_str().unwrap_or(name).to_string(),\n os: Some(os.to_string()),\n notes: None,\n })\n }\n\n pub async fn delete_profile(&self, profile_id: &str) -> Result<()> {\n self.client\n .delete(format!(\"{}/browser/{}\", GOLOGIN_API, profile_id))\n .bearer_auth(&self.token)\n .send()\n .await?;\n Ok(())\n }\n\n /// Returns the WebSocket debug URL for Puppeteer/CDP connection.\n /// Requires the GoLogin desktop app running locally (port 36912).\n pub async fn start_local_profile(&self, profile_id: &str) -> Result {\n let resp = self.client\n .get(format!(\"http://localhost:36912/browser/{}\", profile_id))\n .send()\n .await?;\n let body: serde_json::Value = resp.json().await?;\n let ws_url = body[\"wsUrl\"]\n .as_str()\n .ok_or_else(|| anyhow::anyhow!(\"No wsUrl returned — is GoLogin desktop running?\"))?\n .to_string();\n Ok(ws_url)\n }\n\n pub async fn stop_local_profile(&self, profile_id: &str) -> Result<()> {\n self.client\n .delete(format!(\"http://localhost:36912/browser/{}\", profile_id))\n .send()\n .await?;\n Ok(())\n }\n}\n",[],[144,201,219],"8cdf500a-3156-11f1-91e0-42dde27851f2","db.rs","8cdf50b4-3156-11f1-91e0-42dde27851f2",7,["D",1775438322554],"use rusqlite::{Connection, Result, params};\nuse std::path::Path;\n\npub struct Database {\n pub conn: Connection,\n}\n\nimpl Database {\n pub async fn new(path: &str) -> Result {\n let conn = Connection::open(Path::new(path))?;\n let db = Database { conn };\n db.run_migrations()?;\n Ok(db)\n }\n\n fn run_migrations(&self) -> Result<()> {\n self.conn.execute_batch(\"PRAGMA journal_mode=WAL; PRAGMA foreign_keys=ON;\")?;\n self.conn.execute_batch(SCHEMA)?;\n Ok(())\n }\n}\n\nconst SCHEMA: &str = r#\"\n-- Teams / Apartments\nCREATE TABLE IF NOT EXISTS teams (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n description TEXT DEFAULT '',\n color TEXT DEFAULT '#6366f1',\n created_at TEXT DEFAULT (datetime('now'))\n);\n\n-- Social Accounts\nCREATE TABLE IF NOT EXISTS accounts (\n id TEXT PRIMARY KEY,\n team_id TEXT NOT NULL REFERENCES teams(id) ON DELETE CASCADE,\n platform TEXT NOT NULL CHECK(platform IN ('facebook','google','tiktok')),\n username TEXT NOT NULL,\n display_name TEXT DEFAULT '',\n avatar_url TEXT DEFAULT '',\n gologin_profile_id TEXT DEFAULT '',\n proxy TEXT DEFAULT '',\n notes TEXT DEFAULT '',\n status TEXT DEFAULT 'active' CHECK(status IN ('active','inactive','banned','warming')),\n last_active_at TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n);\n\n-- GoLogin profile cache\nCREATE TABLE IF NOT EXISTS gologin_profiles (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n os TEXT DEFAULT 'win',\n notes TEXT DEFAULT '',\n account_id TEXT REFERENCES accounts(id) ON DELETE SET NULL,\n synced_at TEXT DEFAULT (datetime('now'))\n);\n\n-- Posts scheduled / published\nCREATE TABLE IF NOT EXISTS posts (\n id TEXT PRIMARY KEY,\n account_id TEXT NOT NULL REFERENCES accounts(id) ON DELETE CASCADE,\n platform TEXT NOT NULL,\n content TEXT NOT NULL,\n media_urls TEXT DEFAULT '[]',\n status TEXT DEFAULT 'draft' CHECK(status IN ('draft','scheduled','published','failed')),\n scheduled_at TEXT,\n published_at TEXT,\n post_url TEXT DEFAULT '',\n created_at TEXT DEFAULT (datetime('now'))\n);\n\n-- Activities log (comment, friend request, like, etc.)\nCREATE TABLE IF NOT EXISTS activities (\n id TEXT PRIMARY KEY,\n account_id TEXT NOT NULL REFERENCES accounts(id) ON DELETE CASCADE,\n type TEXT NOT NULL CHECK(type IN ('comment','friend_request','like','share','follow','message','custom')),\n target_url TEXT DEFAULT '',\n target_name TEXT DEFAULT '',\n content TEXT DEFAULT '',\n status TEXT DEFAULT 'done' CHECK(status IN ('done','pending','failed')),\n done_at TEXT DEFAULT (datetime('now'))\n);\n\n-- Daily metrics per account\nCREATE TABLE IF NOT EXISTS metrics (\n id TEXT PRIMARY KEY,\n account_id TEXT NOT NULL REFERENCES accounts(id) ON DELETE CASCADE,\n date TEXT NOT NULL, -- YYYY-MM-DD\n platform TEXT NOT NULL,\n new_posts INTEGER DEFAULT 0,\n new_likes INTEGER DEFAULT 0,\n new_reacts INTEGER DEFAULT 0,\n new_comments INTEGER DEFAULT 0,\n new_friends INTEGER DEFAULT 0,\n new_followers INTEGER DEFAULT 0,\n profile_views INTEGER DEFAULT 0,\n reach INTEGER DEFAULT 0,\n comments_made INTEGER DEFAULT 0,\n friend_requests_sent INTEGER DEFAULT 0,\n messages_sent INTEGER DEFAULT 0,\n notes TEXT DEFAULT '',\n created_at TEXT DEFAULT (datetime('now')),\n UNIQUE(account_id, date)\n);\n\n-- App settings KV store\nCREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n);\n\"#;\n",[],[144,201,227],"a1333efe-3156-11f1-91e0-42dde27851f2","73e2db9d-be5b-4e72-8cdf-6e7755e14430",["D",1775438356660],[],[144,201,239,38],"commands","9d5c5d60-3156-11f1-9811-42dde27851f2","mod.rs","9d5c5e50-3156-11f1-9811-42dde27851f2",10,["D",1775438350216],"pub mod settings;\npub mod teams;\npub mod accounts;\npub mod profiles;\npub mod posts;\npub mod activities;\npub mod metrics;\n",[],[144,201,239,241],"9d5c667a-3156-11f1-9811-42dde27851f2",["D",1775438350216],[163,164],[144,201,239],"7f030ddc-3156-11f1-8812-42dde27851f2",["D",1775438299295],[162,165,166,167,168,169],[144,201],["D",1775438290378],[161,170,171],[144],["D",1775438052675],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_19":58,"_102":103,"_104":30},{"_13":87,"_37":88,"_47":46,"_89":48,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":49,"_96":97},"ctx",{"_80":-5,"_125":296,"_297":298,"_299":300,"_301":30,"_302":30,"_303":30,"_304":136,"_305":-5,"_306":-7,"_307":-7,"_308":64,"_309":30,"_310":30,"_311":-5,"_312":30,"_313":30,"_314":30,"_315":-5},"ENV",{"_267":268,"_269":270,"_271":88,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v11