\n \n \n \n \n\n",[],[106,124],"6de971ce-3136-11f0-8e91-569c3dd06744","components","ed520248-4749-4262-b3f3-8de72fedb75a",9,["D",1747277029039],[137,138,139,140,141],[106,131],{"_36":174,"_13":175,"_39":176,"_41":132,"_43":44,"_45":133,"_47":48,"_49":177,"_17":65,"_52":101,"_54":178,"_56":57,"_58":-5,"_86":179,"_18":180},{"_36":166,"_13":167,"_39":168,"_41":132,"_43":44,"_45":169,"_47":48,"_49":170,"_17":65,"_52":101,"_54":171,"_56":57,"_58":-5,"_86":172,"_18":173},{"_36":158,"_13":159,"_39":160,"_41":132,"_43":44,"_45":161,"_47":48,"_49":162,"_17":65,"_52":101,"_54":163,"_56":57,"_58":-5,"_86":164,"_18":165},{"_36":150,"_13":151,"_39":152,"_41":132,"_43":44,"_45":153,"_47":48,"_49":154,"_17":65,"_52":101,"_54":155,"_56":57,"_58":-5,"_86":156,"_18":157},{"_36":142,"_13":143,"_39":144,"_41":132,"_43":44,"_45":145,"_47":48,"_49":146,"_17":65,"_52":101,"_54":147,"_56":57,"_58":-5,"_86":148,"_18":149},"9a54f44a-3136-11f0-ac4a-569c3dd06744","InteractionForm.tsx","9a54f51c-3136-11f0-ac4a-569c3dd06744",13,["D",1747277103568],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Interaction, InteractionType } from \"../../shared/types.ts\";\n\ninterface InteractionFormProps {\n onSubmit: (interaction: Interaction) => void;\n}\n\nexport default function InteractionForm({ onSubmit }: InteractionFormProps) {\n const [formData, setFormData] = useState>({\n type: 'call' as InteractionType,\n notes: '',\n date: new Date().toISOString().split('T')[0] // Today's date in YYYY-MM-DD format\n });\n\n const [errors, setErrors] = useState>({});\n\n const handleChange = (\n e: React.ChangeEvent\n ) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n \n // Clear error when field is edited\n if (errors[name]) {\n setErrors(prev => {\n const newErrors = { ...prev };\n delete newErrors[name];\n return newErrors;\n });\n }\n };\n\n const validateForm = () => {\n const newErrors: Record = {};\n \n if (!formData.type) {\n newErrors.type = \"Type is required\";\n }\n \n if (!formData.date) {\n newErrors.date = \"Date is required\";\n }\n \n setErrors(newErrors);\n return Object.keys(newErrors).length === 0;\n };\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n \n if (validateForm()) {\n onSubmit(formData as Interaction);\n }\n };\n\n return (\n \n );\n}",[],[106,131,143],"72523188-3136-11f0-8e91-569c3dd06744","ContactList.tsx","72523264-3136-11f0-8e91-569c3dd06744",10,["D",1747277036441],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Contact } from \"../../shared/types.ts\";\n\ninterface ContactListProps {\n contacts: Contact[];\n selectedContactId?: number;\n onSelectContact: (contact: Contact) => void;\n}\n\nexport default function ContactList({ \n contacts, \n selectedContactId, \n onSelectContact \n}: ContactListProps) {\n if (contacts.length === 0) {\n return (\n

\n No contacts found\n

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

onSelectContact(contact)}\n >\n
{contact.name}
\n {contact.company && (\n
{contact.company}
\n )}\n {contact.email && (\n
{contact.email}
\n )}\n

\n );\n}",[],[106,131,151],"7d554c32-3136-11f0-a36f-569c3dd06744","ContactForm.tsx","7d554df4-3136-11f0-a36f-569c3dd06744",11,["D",1747277054915],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Contact } from \"../../shared/types.ts\";\n\ninterface ContactFormProps {\n contact?: Contact;\n onSubmit: (contact: Contact) => void;\n}\n\nexport default function ContactForm({ contact, onSubmit }: ContactFormProps) {\n const [formData, setFormData] = useState({\n id: contact?.id,\n name: contact?.name || \"\",\n email: contact?.email || \"\",\n phone: contact?.phone || \"\",\n company: contact?.company || \"\",\n notes: contact?.notes || \"\"\n });\n\n const [errors, setErrors] = useState>({});\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n \n // Clear error when field is edited\n if (errors[name]) {\n setErrors(prev => {\n const newErrors = { ...prev };\n delete newErrors[name];\n return newErrors;\n });\n }\n };\n\n const validateForm = () => {\n const newErrors: Record = {};\n \n if (!formData.name.trim()) {\n newErrors.name = \"Name is required\";\n }\n \n if (formData.email && !/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(formData.email)) {\n newErrors.email = \"Invalid email format\";\n }\n \n setErrors(newErrors);\n return Object.keys(newErrors).length === 0;\n };\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n \n if (validateForm()) {\n onSubmit(formData);\n }\n };\n\n return (\n \n );\n}",[],[106,131,159],"90f0030e-3136-11f0-9109-569c3dd06744","ContactDetail.tsx","90f003cc-3136-11f0-9109-569c3dd06744",12,["D",1747277087808],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Contact, Interaction, InteractionType } from \"../../shared/types.ts\";\nimport InteractionForm from \"./InteractionForm.tsx\";\n\ninterface ContactDetailProps {\n contact: Contact;\n onEdit: () => void;\n onDelete: () => void;\n onContactUpdated: () => void;\n}\n\nexport default function ContactDetail({ \n contact, \n onEdit, \n onDelete,\n onContactUpdated\n}: ContactDetailProps) {\n const [interactions, setInteractions] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(null);\n const [isAddingInteraction, setIsAddingInteraction] = useState(false);\n\n // Fetch interactions for this contact\n const fetchInteractions = async () => {\n if (!contact.id) return;\n \n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(`/api/contacts/${contact.id}/interactions`);\n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to fetch interactions\");\n }\n \n setInteractions(result.data);\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error fetching interactions:\", err);\n } finally {\n setIsLoading(false);\n }\n };\n\n // Load interactions when contact changes\n useEffect(() => {\n fetchInteractions();\n }, [contact.id]);\n\n // Add a new interaction\n const handleAddInteraction = async (interaction: Interaction) => {\n try {\n const response = await fetch(\"/api/interactions\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n ...interaction,\n contact_id: contact.id\n })\n });\n \n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to add interaction\");\n }\n \n fetchInteractions();\n setIsAddingInteraction(false);\n onContactUpdated();\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error adding interaction:\", err);\n }\n };\n\n // Delete an interaction\n const handleDeleteInteraction = async (id: number) => {\n if (!confirm(\"Are you sure you want to delete this interaction?\")) return;\n \n try {\n const response = await fetch(`/api/interactions/${id}`, {\n method: \"DELETE\"\n });\n \n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to delete interaction\");\n }\n \n fetchInteractions();\n onContactUpdated();\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error deleting interaction:\", err);\n }\n };\n\n // Format date for display\n const formatDate = (dateString: string) => {\n const date = new Date(dateString);\n return date.toLocaleDateString();\n };\n\n // Get icon for interaction type\n const getInteractionIcon = (type: InteractionType) => {\n switch (type) {\n case 'call': return '📞';\n case 'email': return '📧';\n case 'meeting': return '👥';\n default: return '📝';\n }\n };\n\n return (\n

{contact.name}

\n {contact.company && (\n

{contact.company}

\n )}\n

\n \n Edit\n \n \n Delete\n \n

\n\n {error && (\n

\n Error: {error}\n \n

\n )}\n\n

\n {contact.email && (\n

Email

{contact.email}

\n )}\n \n {contact.phone && (\n

Phone

{contact.phone}

\n )}\n

\n\n {contact.notes && (\n

Notes

{contact.notes}

\n )}\n\n

Interactions

\n setIsAddingInteraction(true)}\n >\n Add Interaction\n \n

\n\n {isAddingInteraction ? (\n

New Interaction

\n setIsAddingInteraction(false)}\n >\n Cancel\n \n

\n \n

\n ) : null}\n\n {isLoading ? (\n

\n ) : interactions.length === 0 ? (\n

\n No interactions recorded yet\n

\n ) : (\n

\n
\n
\n \n {getInteractionIcon(interaction.type)}\n \n
\n
\n \n {interaction.type}\n \n •\n \n {formatDate(interaction.date)}\n \n
\n {interaction.notes && (\n
\n {interaction.notes}\n
\n )}\n
\n
\n interaction.id && handleDeleteInteraction(interaction.id)}\n title=\"Delete interaction\"\n >\n ×\n \n
\n

\n )}\n

\n );\n}",[],[106,131,167],"6de94212-3136-11f0-8e91-569c3dd06744","App.tsx","6de94302-3136-11f0-8e91-569c3dd06744",["D",1747277029039],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Contact } from \"../../shared/types.ts\";\nimport ContactList from \"./ContactList.tsx\";\nimport ContactDetail from \"./ContactDetail.tsx\";\nimport ContactForm from \"./ContactForm.tsx\";\n\nexport default function App() {\n const [contacts, setContacts] = useState([]);\n const [selectedContact, setSelectedContact] = useState(null);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(null);\n const [isAddingContact, setIsAddingContact] = useState(false);\n const [isEditingContact, setIsEditingContact] = useState(false);\n const [searchQuery, setSearchQuery] = useState(\"\");\n\n // Fetch contacts\n const fetchContacts = async (query = \"\") => {\n setIsLoading(true);\n setError(null);\n try {\n const url = query \n ? `/api/contacts?q=${encodeURIComponent(query)}` \n : \"/api/contacts\";\n \n const response = await fetch(url);\n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to fetch contacts\");\n }\n \n setContacts(result.data);\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error fetching contacts:\", err);\n } finally {\n setIsLoading(false);\n }\n };\n\n // Initial load\n useEffect(() => {\n fetchContacts();\n }, []);\n\n // Handle search\n useEffect(() => {\n const delayDebounceFn = setTimeout(() => {\n fetchContacts(searchQuery);\n }, 300);\n\n return () => clearTimeout(delayDebounceFn);\n }, [searchQuery]);\n\n // Select a contact\n const handleSelectContact = (contact: Contact) => {\n setSelectedContact(contact);\n setIsAddingContact(false);\n setIsEditingContact(false);\n };\n\n // Add a new contact\n const handleAddContact = async (contact: Contact) => {\n try {\n const response = await fetch(\"/api/contacts\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(contact)\n });\n \n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to add contact\");\n }\n \n fetchContacts();\n setIsAddingContact(false);\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error adding contact:\", err);\n }\n };\n\n // Update a contact\n const handleUpdateContact = async (contact: Contact) => {\n if (!contact.id) return;\n \n try {\n const response = await fetch(`/api/contacts/${contact.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(contact)\n });\n \n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to update contact\");\n }\n \n fetchContacts();\n setSelectedContact({ ...contact });\n setIsEditingContact(false);\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error updating contact:\", err);\n }\n };\n\n // Delete a contact\n const handleDeleteContact = async (id: number) => {\n if (!confirm(\"Are you sure you want to delete this contact?\")) return;\n \n try {\n const response = await fetch(`/api/contacts/${id}`, {\n method: \"DELETE\"\n });\n \n const result = await response.json();\n \n if (!result.success) {\n throw new Error(result.error || \"Failed to delete contact\");\n }\n \n fetchContacts();\n setSelectedContact(null);\n } catch (err) {\n setError(err instanceof Error ? err.message : \"An unknown error occurred\");\n console.error(\"Error deleting contact:\", err);\n }\n };\n\n return (\n

Personal CRM

Manage your contacts and interactions

\n\n {error && (\n

\n Error: {error}\n \n

\n )}\n\n

\n {/* Left sidebar */}\n

Contacts

\n {\n setIsAddingContact(true);\n setSelectedContact(null);\n setIsEditingContact(false);\n }}\n >\n Add Contact\n \n

\n \n

\n setSearchQuery(e.target.value)}\n />\n

\n\n {isLoading ? (\n

\n ) : (\n \n )}\n

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

\n {isAddingContact ? (\n

Add New Contact

\n setIsAddingContact(false)}\n >\n Cancel\n \n

\n \n

\n ) : isEditingContact && selectedContact ? (\n

Edit Contact

\n setIsEditingContact(false)}\n >\n Cancel\n \n

\n \n

\n ) : selectedContact ? (\n setIsEditingContact(true)}\n onDelete={() => handleDeleteContact(selectedContact.id!)}\n onContactUpdated={() => {\n fetchContacts();\n // Refresh the selected contact\n if (selectedContact.id) {\n fetch(`/api/contacts/${selectedContact.id}`)\n .then(res => res.json())\n .then(result => {\n if (result.success) {\n setSelectedContact(result.data);\n }\n });\n }\n }}\n />\n ) : (\n

Select a contact to view details or add a new contact

\n )}\n

\n );\n}",[],[106,131,175],["D",1747276943006],[184,185,186],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":51,"_47":48,"_49":201,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":202,"_18":203},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":190,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":191,"_18":192},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":187,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":188,"_18":189},["D",1747277177656],[],[19,38],["D",1747276973145],[193],[19,61],{"_36":194,"_13":195,"_39":196,"_41":62,"_43":44,"_45":63,"_47":48,"_49":197,"_17":65,"_52":101,"_54":198,"_56":57,"_58":-5,"_86":199,"_18":200},"4c9841c6-3136-11f0-9aa1-569c3dd06744","api.ts","4c9842a2-3136-11f0-9aa1-569c3dd06744",["D",1747276973145],"import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { \n getAllContacts, \n getContactById, \n createContact, \n updateContact, \n deleteContact,\n searchContacts,\n getInteractionsByContactId,\n createInteraction,\n deleteInteraction\n} from \"../database/queries.ts\";\nimport { Contact, Interaction } from \"../../shared/types.ts\";\n\nconst api = new Hono();\n\n// Contacts endpoints\napi.get(\"/contacts\", async (c) => {\n try {\n const searchQuery = c.req.query(\"q\");\n const contacts = searchQuery \n ? await searchContacts(searchQuery)\n : await getAllContacts();\n \n return c.json({ success: true, data: contacts });\n } catch (error) {\n console.error(\"Error fetching contacts:\", error);\n return c.json({ success: false, error: \"Failed to fetch contacts\" }, 500);\n }\n});\n\napi.get(\"/contacts/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const contact = await getContactById(id);\n \n if (!contact) {\n return c.json({ success: false, error: \"Contact not found\" }, 404);\n }\n \n return c.json({ success: true, data: contact });\n } catch (error) {\n console.error(\"Error fetching contact:\", error);\n return c.json({ success: false, error: \"Failed to fetch contact\" }, 500);\n }\n});\n\napi.post(\"/contacts\", async (c) => {\n try {\n const contact = await c.req.json() as Contact;\n \n if (!contact.name) {\n return c.json({ success: false, error: \"Name is required\" }, 400);\n }\n \n const id = await createContact(contact);\n return c.json({ success: true, data: { id } }, 201);\n } catch (error) {\n console.error(\"Error creating contact:\", error);\n return c.json({ success: false, error: \"Failed to create contact\" }, 500);\n }\n});\n\napi.put(\"/contacts/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const contact = await c.req.json() as Contact;\n \n if (!contact.name) {\n return c.json({ success: false, error: \"Name is required\" }, 400);\n }\n \n const success = await updateContact(id, contact);\n \n if (!success) {\n return c.json({ success: false, error: \"Contact not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating contact:\", error);\n return c.json({ success: false, error: \"Failed to update contact\" }, 500);\n }\n});\n\napi.delete(\"/contacts/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const success = await deleteContact(id);\n \n if (!success) {\n return c.json({ success: false, error: \"Contact not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting contact:\", error);\n return c.json({ success: false, error: \"Failed to delete contact\" }, 500);\n }\n});\n\n// Interactions endpoints\napi.get(\"/contacts/:id/interactions\", async (c) => {\n try {\n const contactId = parseInt(c.req.param(\"id\"));\n const interactions = await getInteractionsByContactId(contactId);\n \n return c.json({ success: true, data: interactions });\n } catch (error) {\n console.error(\"Error fetching interactions:\", error);\n return c.json({ success: false, error: \"Failed to fetch interactions\" }, 500);\n }\n});\n\napi.post(\"/interactions\", async (c) => {\n try {\n const interaction = await c.req.json() as Interaction;\n \n if (!interaction.contact_id || !interaction.type || !interaction.date) {\n return c.json({ \n success: false, \n error: \"Contact ID, type, and date are required\" \n }, 400);\n }\n \n const id = await createInteraction(interaction);\n return c.json({ success: true, data: { id } }, 201);\n } catch (error) {\n console.error(\"Error creating interaction:\", error);\n return c.json({ success: false, error: \"Failed to create interaction\" }, 500);\n }\n});\n\napi.delete(\"/interactions/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const success = await deleteInteraction(id);\n \n if (!success) {\n return c.json({ success: false, error: \"Interaction not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting interaction:\", error);\n return c.json({ success: false, error: \"Failed to delete interaction\" }, 500);\n }\n});\n\nexport default api;",[],[19,61,195],["D",1747276943006],[204,205],[19,69],{"_36":214,"_13":215,"_39":216,"_41":70,"_43":44,"_45":51,"_47":48,"_49":217,"_17":65,"_52":101,"_54":218,"_56":57,"_58":-5,"_86":219,"_18":220},{"_36":206,"_13":207,"_39":208,"_41":70,"_43":44,"_45":209,"_47":48,"_49":210,"_17":65,"_52":101,"_54":211,"_56":57,"_58":-5,"_86":212,"_18":213},"42e97848-3136-11f0-8f7a-569c3dd06744","queries.ts","42e9792e-3136-11f0-8f7a-569c3dd06744",4,["D",1747276956902],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Contact, Interaction } from \"../../shared/types.ts\";\nimport { CONTACTS_TABLE, INTERACTIONS_TABLE } from \"./migrations.ts\";\n\n// Contact queries\nexport async function getAllContacts(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${CONTACTS_TABLE} ORDER BY name ASC`);\n return result.rows as Contact[];\n}\n\nexport async function getContactById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CONTACTS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows.length > 0 ? (result.rows[0] as Contact) : null;\n}\n\nexport async function createContact(contact: Contact): Promise {\n const { name, email, phone, company, notes } = contact;\n const result = await sqlite.execute(\n `INSERT INTO ${CONTACTS_TABLE} (name, email, phone, company, notes) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [name, email || null, phone || null, company || null, notes || null]\n );\n return result.rows[0].id as number;\n}\n\nexport async function updateContact(id: number, contact: Contact): Promise {\n const { name, email, phone, company, notes } = contact;\n const result = await sqlite.execute(\n `UPDATE ${CONTACTS_TABLE} \n SET name = ?, email = ?, phone = ?, company = ?, notes = ?, updated_at = datetime('now')\n WHERE id = ?`,\n [name, email || null, phone || null, company || null, notes || null, id]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function deleteContact(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${CONTACTS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function searchContacts(query: string): Promise {\n const searchTerm = `%${query}%`;\n const result = await sqlite.execute(\n `SELECT * FROM ${CONTACTS_TABLE} \n WHERE name LIKE ? OR email LIKE ? OR company LIKE ? OR notes LIKE ?\n ORDER BY name ASC`,\n [searchTerm, searchTerm, searchTerm, searchTerm]\n );\n return result.rows as Contact[];\n}\n\n// Interaction queries\nexport async function getInteractionsByContactId(contactId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${INTERACTIONS_TABLE} \n WHERE contact_id = ? \n ORDER BY date DESC`,\n [contactId]\n );\n return result.rows as Interaction[];\n}\n\nexport async function createInteraction(interaction: Interaction): Promise {\n const { contact_id, type, notes, date } = interaction;\n const result = await sqlite.execute(\n `INSERT INTO ${INTERACTIONS_TABLE} (contact_id, type, notes, date) \n VALUES (?, ?, ?, ?) RETURNING id`,\n [contact_id, type, notes || null, date]\n );\n return result.rows[0].id as number;\n}\n\nexport async function deleteInteraction(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${INTERACTIONS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rowsAffected > 0;\n}",[],[19,69,207],"3aa15a98-3136-11f0-a98c-569c3dd06744","migrations.ts","3aa15b74-3136-11f0-a98c-569c3dd06744",["D",1747276943006],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - change these when modifying schema\nexport const CONTACTS_TABLE = 'personal_crm_contacts';\nexport const INTERACTIONS_TABLE = 'personal_crm_interactions';\n\nexport async function runMigrations() {\n // Create contacts table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CONTACTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT,\n phone TEXT,\n company TEXT,\n notes TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )\n `);\n\n // Create interactions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${INTERACTIONS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n contact_id INTEGER NOT NULL,\n type TEXT NOT NULL,\n notes TEXT,\n date TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (contact_id) REFERENCES ${CONTACTS_TABLE} (id) ON DELETE CASCADE\n )\n `);\n\n console.log(\"Migrations completed successfully\");\n}",[],[19,69,215],"089964be-3136-11f0-a36f-569c3dd06744",["D",1747276859072],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_273":269},"org",{"_11":12,"_267":-5,"_268":269,"_230":231,"_270":271,"_272":57},"branch",{"_17":46,"_13":16,"_36":44,"_259":221,"_260":-5,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":14,"_266":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":221,"_13":14,"_49":366,"_223":-5,"_224":57,"_225":226,"_227":226,"_228":-5,"_229":-5,"_230":231,"_232":40,"_233":48,"_234":48,"_235":-5,"_236":65,"_237":238,"_239":-5,"_240":-5,"_241":-5,"_242":-5,"_243":244,"_245":244,"_246":247,"_248":247,"_249":247,"_250":244,"_251":244,"_252":367,"_254":368,"_256":369,"_258":57},[309,316,325,327],"files",[309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327],"counts",{"_300":65,"_301":83,"_302":65,"_32":303,"_304":305},[294,295,296],{"_36":73,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":74,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":293},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":51,"_47":48,"_49":71,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":299},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":298},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":297},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_306":65,"_308":65},"connections",{"_306":65,"_307":65},"count","unfilledCount","emptyCount",{"_36":73,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":51,"_47":48,"_49":181,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":364,"_18":365},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":51,"_47":48,"_49":201,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":362,"_18":363},{"_36":214,"_13":215,"_39":216,"_41":70,"_43":44,"_45":51,"_47":48,"_49":217,"_17":65,"_52":101,"_54":218,"_56":57,"_58":-5,"_86":360,"_18":361},{"_36":206,"_13":207,"_39":208,"_41":70,"_43":44,"_45":209,"_47":48,"_49":210,"_17":65,"_52":101,"_54":211,"_56":57,"_58":-5,"_86":358,"_18":359},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":190,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":356,"_18":357},{"_36":194,"_13":195,"_39":196,"_41":62,"_43":44,"_45":63,"_47":48,"_49":197,"_17":65,"_52":101,"_54":198,"_56":57,"_58":-5,"_86":354,"_18":355},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":187,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":352,"_18":353},{"_36":105,"_13":106,"_39":107,"_41":-5,"_43":44,"_45":108,"_47":48,"_49":109,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":350,"_18":351},{"_36":130,"_13":131,"_39":132,"_41":107,"_43":44,"_45":133,"_47":48,"_49":134,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":348,"_18":349},{"_36":174,"_13":175,"_39":176,"_41":132,"_43":44,"_45":133,"_47":48,"_49":177,"_17":65,"_52":101,"_54":178,"_56":57,"_58":-5,"_86":346,"_18":347},{"_36":166,"_13":167,"_39":168,"_41":132,"_43":44,"_45":169,"_47":48,"_49":170,"_17":65,"_52":101,"_54":171,"_56":57,"_58":-5,"_86":344,"_18":345},{"_36":158,"_13":159,"_39":160,"_41":132,"_43":44,"_45":161,"_47":48,"_49":162,"_17":65,"_52":101,"_54":163,"_56":57,"_58":-5,"_86":342,"_18":343},{"_36":150,"_13":151,"_39":152,"_41":132,"_43":44,"_45":153,"_47":48,"_49":154,"_17":65,"_52":101,"_54":155,"_56":57,"_58":-5,"_86":340,"_18":341},{"_36":142,"_13":143,"_39":144,"_41":132,"_43":44,"_45":145,"_47":48,"_49":146,"_17":65,"_52":101,"_54":147,"_56":57,"_58":-5,"_86":338,"_18":339},{"_36":123,"_13":124,"_39":125,"_41":107,"_43":44,"_45":108,"_47":48,"_49":126,"_17":65,"_52":24,"_54":127,"_56":57,"_58":-5,"_86":336,"_18":337},{"_36":115,"_13":116,"_39":117,"_41":107,"_43":44,"_45":118,"_47":48,"_49":119,"_17":65,"_52":101,"_54":120,"_56":57,"_58":-5,"_86":334,"_18":335},{"_36":89,"_13":90,"_39":91,"_41":-5,"_43":44,"_45":92,"_47":48,"_49":93,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_86":332,"_18":333},{"_36":97,"_13":98,"_39":99,"_41":91,"_43":44,"_45":92,"_47":48,"_49":100,"_17":65,"_52":101,"_54":102,"_56":57,"_58":-5,"_86":330,"_18":331},{"_36":80,"_13":81,"_39":82,"_41":-5,"_43":44,"_45":83,"_47":48,"_49":84,"_17":65,"_52":24,"_54":85,"_56":57,"_58":-5,"_86":328,"_18":329},[],[81],[],[90,98],[326],[90],[],[106,116],[],[106,124],[],[106,131,143],[],[106,131,151],[],[106,131,159],[],[106,131,167],[],[106,131,175],[318,319,320,321,322],[106,131],[317,323,324],[106],[],[19,38],[],[19,61,195],[314],[19,61],[],[19,69,207],[],[19,69,215],[311,312],[19,69],[310,313,315],[19],["D",1747276859072],{"_11":12,"_273":269},{"_11":12,"_267":-5,"_268":269,"_230":231,"_270":271,"_272":57},{"_17":46,"_13":16,"_36":44,"_259":221,"_260":-5,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":14,"_266":12},"ctx",{"_252":-5,"_290":403,"_404":405,"_406":407,"_408":57,"_409":57,"_410":57,"_411":48,"_412":-5,"_413":-7,"_414":-7,"_415":65,"_416":57,"_417":57,"_418":-5,"_419":57,"_420":57,"_421":57,"_422":-5},"ENV",{"_374":375,"_376":377,"_378":16,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]