-- SQL schema with GDPR-ready users and transactions
CREATE TABLE users (
 id INT AUTO_INCREMENT PRIMARY KEY,
 email VARCHAR(255),
 password VARCHAR(255),
 role ENUM('admin','client'),
 last_login TIMESTAMP,
 ip_address VARCHAR(100)
);
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
);
-- Demo data
INSERT INTO users (email,password,role) VALUES 
('admin@davcoind.com','Admin@123','admin'),
('client1@demo.com','Client@123','client'),
('client2@demo.com','Client@123','client');

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');
