
CREATE TABLE transactions (
 id INT AUTO_INCREMENT PRIMARY KEY,
 txid VARCHAR(100),
 user_email VARCHAR(255),
 amount DECIMAL(12,2),
 status VARCHAR(50),
 description TEXT
);

INSERT INTO transactions (txid,user_email,amount,status,description) VALUES
('TXN-9A1B2C3D','client1@demo.com',2500.00,'Pending','Awaiting blockchain confirmation'),
('TXN-8X4Z7M6Q','client1@demo.com',5000.00,'Confirmed','Transaction verified on chain'),
('TXN-7H2K9D4T','client2@demo.com',1200.00,'Completed','Funds credited successfully');
