-- BK:Jan-Sewa SQL Database Backup
-- Exported on: 2026-08-19 15:57:04

DELETE FROM shop_settings WHERE id = 1;
INSERT INTO shop_settings (id, shop_name, proprietor, mobile, address, preset_purposes, currency, currency_symbol) VALUES (1, 'BK:Jan-Sewa', 'Imran Ahmad', '+91 9876543210', 'Shop No. 4, Main Market, Digital Seva Kendra', 'Aadhaar service,PAN service,Online form,Printing,Photocopy,Passport service,Money transfer,Bill payment,Recharge,Government service,Document service,Other', 'INR', '₹');

-- Customers (8 records)
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (1, 'Rahul Kumar', '+91 9876543210', 'Near Water Tank, Rampur', 'Regular customer for online job forms', '2026-08-14 13:46:48') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (2, 'Amit Kumar', '+91 9812345678', 'Village Kalyanpur', 'Advance deposited for passport appointment', '2026-08-15 13:46:48') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (3, 'Priya Sharma', '+91 9898989898', 'Civil Lines, Block B', 'College admission form & PAN card', '2026-08-13 13:46:48') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (4, 'Mohd Danish', '+91 9765432109', 'Purana Bazar, Ward 12', 'CSC center regular', '2026-08-12 13:46:48') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (5, 'Sunita Devi', '+91 9654321098', 'Gautam Nagar', 'Ayushman card holder', '2026-08-17 13:46:48') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (6, 'Vikas Yadav', '+91 9543210987', 'Shivaji Chowk', 'Electricity bill regular', '2026-08-16 13:46:48') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (7, 'Rizwan Ahmad', '+919198895688', 'House No 628, Shivnagar, Maswanpur', NULL, '2026-08-19 14:04:25') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO customers (id, name, mobile, address, notes, created_at) VALUES (8, 'Abu Talha', '9721120378', 'House No 628, Shivnagar, Maswanpur', NULL, '2026-08-19 14:07:41') ON DUPLICATE KEY UPDATE name=VALUES(name);

-- Transactions (13 records)
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (1, 1, 'CREDIT', 100000, 'Online form', 'UP Police Constable Exam Form + Printout', '2026-08-15 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (2, 1, 'DEBIT', 50000, 'Online form', 'Partial cash payment received', '2026-08-17 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (3, 1, 'CREDIT', 15000, 'Printing', 'Color project printouts (15 pages)', '2026-08-19 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (4, 2, 'DEBIT', 50000, 'Passport service', 'Advance token received for passport appointment', '2026-08-16 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (5, 2, 'CREDIT', 20000, 'Passport service', 'Document scanning & verification charge', '2026-08-18 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (6, 3, 'CREDIT', 35000, 'PAN service', 'New PAN Card application fee', '2026-08-14 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (7, 3, 'DEBIT', 35000, 'PAN service', 'UPI payment received (Full settlement)', '2026-08-14 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (8, 4, 'CREDIT', 150000, 'Money transfer', 'DMT transfer to SBI account + transfer fee', '2026-08-13 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (9, 4, 'CREDIT', 25000, 'Aadhaar service', 'Aadhaar address update fee', '2026-08-16 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (10, 4, 'DEBIT', 50000, 'Money transfer', 'Cash payment received', '2026-08-18 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (11, 5, 'CREDIT', 20000, 'Government service', 'Ayushman Bharat Golden Card print & lamination', '2026-08-18 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (12, 5, 'DEBIT', 10000, 'Government service', 'Cash received', '2026-08-19 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
INSERT INTO transactions (id, customer_id, type, amount, purpose, notes, transaction_date) VALUES (13, 6, 'DEBIT', 15000, 'Bill payment', 'Electricity bill cashback credit return to customer', '2026-08-17 13:46:48') ON DUPLICATE KEY UPDATE amount=VALUES(amount);
