Flea Flicker
0fe10434e1
- Add database migration 0024 with indexes on invoices, invoice_line_items, and invoice_tip_splits
- Update Drizzle schema with index definitions for sync
- Add pagination (limit/offset) to GET /api/invoices with max 200 limit
- Add LEFT JOIN to include clientName in invoice list response
- Return { data: [...], total: N } response shape for pagination
Co-Authored-By: Paperclip <noreply@paperclip.ing>
5 lines
339 B
SQL
5 lines
339 B
SQL
CREATE INDEX idx_invoices_client_id ON invoices(client_id);
|
|
CREATE INDEX idx_invoices_status ON invoices(status);
|
|
CREATE INDEX idx_invoices_created_at ON invoices(created_at);
|
|
CREATE INDEX idx_invoice_line_items_invoice_id ON invoice_line_items(invoice_id);
|
|
CREATE INDEX idx_invoice_tip_splits_invoice_id ON invoice_tip_splits(invoice_id); |