CREATE TABLE customers(id INTEGER PRIMARY KEY,name TEXT NOT NULL);
CREATE TABLE orders(id INTEGER PRIMARY KEY,customer_id INTEGER NOT NULL,status TEXT NOT NULL,order_date TEXT NOT NULL,total_cents INTEGER NOT NULL,refund_cents INTEGER NOT NULL DEFAULT 0);
CREATE TABLE order_items(id INTEGER PRIMARY KEY,order_id INTEGER NOT NULL,sku TEXT NOT NULL,qty INTEGER NOT NULL,unit_price_cents INTEGER NOT NULL);
INSERT INTO customers VALUES(1,'Аня'),(2,'Борис'),(3,'Вера'),(4,'Глеб'),(5,'Даша');
INSERT INTO orders VALUES(101,1,'paid','2026-09-01',3000,0),(102,1,'paid','2026-09-03',2000,500),(103,2,'cancelled','2026-09-04',5000,0),(104,3,'paid','2026-09-06',0,0),(105,4,'paid','2026-09-07',4000,4000),(106,2,'paid','2026-10-01',7000,0);
INSERT INTO order_items VALUES(1,101,'A',2,1000),(2,101,'B',1,1000),(3,102,'C',1,2000),(4,103,'D',1,5000),(5,104,'FREE',1,0),(6,105,'E',2,2000),(7,106,'F',1,7000);