View file File name : sample_data.sql Content :-- -- Sample data for all tables to match the Next.js mock data. -- -- -- Dumping data for table `business_settings` -- INSERT INTO `business_settings` (`id`, `name`, `logo`, `email`, `phone`, `address`, `city_state_zip`, `country`, `primary_color`) VALUES (1, 'OmniBooks', NULL, 'sales@omnistudio.bz', '501-629-7170', '123 Main St', 'Belmopan, Cayo', 'Belize', '217 91% 60%'); -- -- Dumping data for table `customers` -- INSERT INTO `customers` (`id`, `name`, `email`, `address`, `phone`, `logo`) VALUES ('1', 'Innovate LLC', 'contact@innovatellc.com', '123 Tech Park, Silicon Valley, CA', '123-456-7890', 'https://placehold.co/128x128.png'), ('10', 'Pioneer Labs', 'info@pioneerlabs.tech', '789 Discovery Way, Innovation, MA', '555-666-5678', NULL), ('11', 'Zenith Logistics', 'support@zenithlog.com', '321 Peak Ave, Apex, CO', '555-777-8901', 'https://placehold.co/128x128.png'), ('12', 'Equinox Designs', 'hello@equinox.design', '101 Balance St, Harmony, IN', '555-888-1234', NULL), ('13', 'Vertex Software', 'sales@vertex.soft', '444 Code Block, Devtown, CA', '555-999-5678', NULL), ('14', 'Maritime Exports', 'shipping@maritime.com', '88 Dockside Dr, Port City, FL', '555-101-1122', 'https://placehold.co/128x128.png'), ('15', 'Heritage Farms', 'farmer@heritage.com', '112 Greenfield Rd, Heartland, IA', '555-212-2233', NULL), ('16', 'Redwood Financial', 'invest@redwood.fi', '1 Giant Tree Rd, Sequoia, CA', '555-313-4159', 'https://placehold.co/128x128.png'), ('17', 'Blue Ocean Robotics', 'deep@blueocean.io', '20000 Leagues Ave, Atlantis, OC', '555-271-8281', 'https://placehold.co/128x128.png'), ('18', 'Golden Gate Goods', 'goods@goldengate.com', '1 Bridge View, San Francisco, CA', '555-415-1849', NULL), ('19', 'Desert Bloom Landscaping', 'contact@desertbloom.com', '1 Oasis Way, Phoenix, AZ', '555-602-7777', 'https://placehold.co/128x128.png'), ('2', 'Quantum Solutions', 'info@quantumsol.com', '456 Future Drive, Metropolis, NY', '234-567-8901', 'https://placehold.co/128x128.png'), ('20', 'Midnight Sun Tech', 'dev@midnightsun.tech', '1 Aurora Circle, Fairbanks, AK', '555-907-2024', NULL), ('3', 'Synergy Corp', 'support@synergy.com', '789 Business Blvd, Commerce City, TX', '345-678-9012', NULL), ('4', 'Apex Industries', 'sales@apexind.com', '101 Summit Peak, Denver, CO', '456-789-0123', 'https://placehold.co/128x128.png'), ('5', 'Nexus Solutions', 'contact@nexussolutions.com', '222 Connection Ave, Cyberspace, ZZ', '555-111-2222', NULL), ('6', 'Stellar Dynamics', 'hello@stellardynamics.co', '999 Galaxy Way, Star City, CA', '555-222-3333', 'https://placehold.co/128x128.png'), ('7', 'Momentum Inc', 'support@momentum.inc', '42 Thrust St, Velocity, TX', '555-333-4444', NULL), ('8', 'Orion Services', 'billing@orionservices.net', '11 Constellation Rd, Astro, FL', '555-444-5555', NULL), ('9', 'Cascade Builders', 'contact@cascade.com', '55 Mountain View, Summit, WA', '555-555-1234', 'https://placehold.co/128x128.png'); -- -- Dumping data for table `items` -- INSERT INTO `items` (`id`, `name`, `description`, `price`, `sell`, `incomeAccountId`, `buy`, `salesTax`) VALUES ('item-1', 'Web Design Services', '20-page custom website design and development.', '2500.00', 1, 'sales', 0, NULL), ('item-10', '1 Side Business Card Print', 'Printing of 1-sided business cards, 14pt cardstock.', '0.35', 1, 'sales', 0, NULL), ('item-2', 'Hosting (1 Year)', 'Basic web hosting for one year.', '300.00', 1, 'sales', 0, NULL), ('item-3', 'Quantum Computing Consultation', 'Per hour consultation on quantum computing applications.', '500.00', 1, 'sales', 0, NULL), ('item-4', 'Brand Strategy Package', 'Full brand identity and strategy development.', '3500.00', 1, 'sales', 0, NULL), ('item-5', 'Product Prototyping', 'Physical prototype creation from design specs.', '7500.00', 1, 'sales', 0, NULL), ('item-6', 'Material Costs', 'Reimbursement for raw materials.', '1800.00', 0, NULL, 1, '5%'), ('item-7', 'Cloud Migration Service', 'Migrate on-premise servers to the cloud.', '6200.00', 1, 'sales', 0, NULL), ('item-8', 'Stellar Cartography Data', 'Subscription to stellar mapping data.', '300.00', 1, 'sales', 0, NULL), ('item-9', 'Physics Engine Licensing', 'Annual license for advanced physics engine.', '12000.00', 1, 'sales', 0, NULL); -- -- Dumping data for table `invoices` (dates will need to be calculated dynamically in a real app) -- INSERT INTO `invoices` (`id`, `customer_id`, `invoice_date`, `due_date`, `status`, `paid_at`, `viewed_at`, `paymentMethod`, `paymentAccount`, `notes`, `subtotal`, `tax`, `discount`, `total`) VALUES ('INV-001', '1', '2024-05-20', '2024-06-19', 'Paid', '2024-06-01 00:00:00', '2024-05-21 00:00:00', 'Bank Transfer', 'Atlantic Bank (BZD)', 'Thank you for your business!', '2800.00', '8.00', '0.00', '3024.00'), ('INV-002', '2', '2024-07-15', '2024-08-14', 'Due', NULL, '2024-07-16 00:00:00', NULL, NULL, NULL, '5000.00', '0.00', '0.00', '5000.00'), ('INV-003', '3', '2024-05-01', '2024-06-01', 'Overdue', NULL, '2024-05-02 00:00:00', NULL, NULL, 'Payment is overdue. Please remit payment as soon as possible.', '3500.00', '5.50', '0.00', '3692.50'), ('INV-004', '4', '2024-07-20', '2024-08-19', 'Draft', NULL, NULL, NULL, NULL, NULL, '9300.00', '7.25', '0.00', '9974.25'), ('INV-005', '5', '2024-04-05', '2024-04-20', 'Paid', '2024-04-18 00:00:00', '2024-04-06 00:00:00', 'Credit Card', NULL, NULL, '6200.00', '10.00', '0.00', '6820.00'); -- Add more invoices as needed -- -- Dumping data for table `invoice_items` -- INSERT INTO `invoice_items` (`id`, `invoice_id`, `description`, `quantity`, `price`) VALUES ('item-1-1', 'INV-001', 'Web Design Services', 1, '2500.00'), ('item-1-2', 'INV-001', 'Hosting (1 Year)', 1, '300.00'), ('item-2-1', 'INV-002', 'Quantum Computing Consultation', 10, '500.00'), ('item-3-1', 'INV-003', 'Brand Strategy Package', 1, '3500.00'), ('item-4-1', 'INV-004', 'Product Prototyping', 1, '7500.00'), ('item-4-2', 'INV-004', 'Material Costs', 1, '1800.00'), ('item-5-1', 'INV-005', 'Cloud Migration Service', 1, '6200.00'); -- Add more invoice items as needed -- -- Dumping data for table `expenses` -- INSERT INTO `expenses` (`id`, `name`, `amount`, `date`, `category`, `type`) VALUES ('exp-1', 'Quickbooks', '45.00', '2024-07-01', 'Subscriptions', 'monthly'), ('exp-2', 'Google Workspace', '25.00', '2024-07-05', 'Subscriptions', 'monthly'), ('exp-3', 'Office Gas Bill', '150.75', '2024-07-10', 'Gas', 'one-time'), ('exp-4', 'Comcast Business Internet', '120.00', '2024-07-15', 'Internet', 'monthly'), ('exp-5', 'Bank of America Fee', '12.50', '2024-06-28', 'Bank fees', 'monthly'), ('exp-6', 'Figma', '50.00', '2024-06-01', 'Subscriptions', 'monthly'); -- -- Dumping data for table `payroll` -- INSERT INTO `payroll` (`id`, `employeeName`, `baseSalary`, `payFrequency`, `bonus`, `advanceDeduction`, `status`, `bankName`, `accountNumber`) VALUES ('pay-1', 'John Doe', '4166.67', 'monthly', '500.00', '0.00', 'Pending', 'Atlantic Bank', '123456789'), ('pay-2', 'Jane Smith', '5000.00', 'monthly', '0.00', '200.00', 'Pending', 'Belize Bank', '987654321'), ('pay-3', 'Peter Jones', '1000.00', 'monthly', '0.00', '0.00', 'Pending', 'Atlantic Bank', '112233445'); -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `name`, `username`, `password`) VALUES ('admin-1', 'Admin User', 'admin', 'password123');