CREATE TABLE clients(
client_id INT AUTO_INCREMENT PRIMARY KEY,
full_name VARCHAR(100) NOT NULL,
phone VARCHAR(20) NOT NULL,
email VARCHAR(100),
city VARCHAR(50) NOT NULL
);
CREATE TABLE categories(
category_id INT AUTO_INCREMENT PRIMARY KEY,
category_name VARCHAR(100) NOT NULL
);
CREATE TABLE products(
product_id INT auto_increment primary key,
product_name VARCHAR(150) NOT NULL,
category_id INT NOT NULL,
price DECIMAL(10,2) NOT NULL,
quantity INT NOT NULL
);
create table orders(
order_id INT auto_increment PRIMARY KEY,
client_id INT NOT NULL,
order_date DATE NOT NULL,
status VARCHAR(30) NOT NULL
);
CREATE table order_items(
item_id INT auto_increment primary key,
order_id INT NOT NULL,
product_id INT NOT NULL,
quantity INT NOT NULL
);
INSERT INTO Clients VALUES (1,'Иванов Иван Иванович', '+79001112233', 'ivanov@mail.ru', 'Ярославль');
INSERT INTO Clients VALUES (2,'Петров Пётр Сергеевич', '+79002223344', 'petrov@mail.ru', 'Москва');
INSERT INTO Clients VALUES (3,'Сидорова Анна Викторовна', '+79003334455', 'sidorova@mail.ru', 'Кострома');
INSERT INTO Clients VALUES (4,'Кузнецов Алексей Павлович', '+79004445566', 'kuznetsov@mail.ru', 'Ярославль');
INSERT INTO Clients VALUES (5,'Смирнова Мария Андреевна', '+79005556677', 'smirnova@mail.ru', 'Вологда');
INSERT INTO categories VALUES (1,'Ноутбуки');
INSERT INTO categories VALUES (2,'Мониторы');
INSERT INTO categories VALUES (3,'Клавиатуры');
INSERT INTO categories VALUES (4,'Мышки');
INSERT INTO categories VALUES (5,'Принтеры');
INSERT INTO products VALUES (1,'Ноутбук Lenovo IdeaPad 3', 1, 52000.00, 8);
INSERT INTO products VALUES (2,'Ноутбук ASUS VivoBook', 1, 61000.00, 5);
INSERT INTO products VALUES (3,'Монитор Samsung 24"', 2, 14500.00, 12);
INSERT INTO products VALUES (4,'Монитор LG UltraGear 27"', 2, 28500.00, 6);
INSERT INTO products VALUES (5,'Клавиатура Logitech K120', 3, 1200.00, 25);
INSERT INTO products VALUES (6,'Клавиатура Redragon Kumara', 3, 3900.00, 10);
INSERT INTO products VALUES (7,'Мышь Logitech M185', 4, 950.00, 30);
INSERT INTO products VALUES (8,'Мышь A4Tech Bloody V8', 4, 2100.00, 15);
INSERT INTO products VALUES (9,'Принтер HP LaserJet', 5, 18500.00, 4);
INSERT INTO products VALUES (10,'Принтер Canon Pixma', 5, 12500.00, 7);
INSERT INTO orders VALUES (1,1, '2026-06-01', 'Новый');
INSERT INTO orders VALUES (2,2, '2026-06-03', 'Оплачен');
INSERT INTO orders VALUES (3,3, '2026-06-05', 'Доставлен');
INSERT INTO orders VALUES (4,1, '2026-06-07', 'Оплачен');
INSERT INTO orders VALUES (5,4, '2026-06-10', 'Новый');
INSERT INTO orders VALUES (6,5, '2026-06-12', 'Отменён');
INSERT INTO order_items VALUES (1,1, 1, 1);
INSERT INTO order_items VALUES (2,1, 5, 2);
INSERT INTO order_items VALUES (3,2, 3, 1);
INSERT INTO order_items VALUES (4,2, 7, 1);
INSERT INTO order_items VALUES (5,3, 2, 1);
INSERT INTO order_items VALUES (6,3, 8, 2);
INSERT INTO order_items VALUES (7,4, 4, 1);
INSERT INTO order_items VALUES (8,4, 6, 1);
INSERT INTO order_items VALUES (9,5, 9, 1);
INSERT INTO order_items VALUES (10,6, 10, 1);
UPDATE clients SET city = 'Рыбинск' WHERE full_name = 'Иванов Иван Иванович';
UPDATE categories SET product_name = 'Ноутбук' WHERE price *1.10;
UPDATE products SET product_name = 'Мышь Logitech M185' WHERE category_id - 2;
UPDATE clients SET email = 'petr.petrov@mail.ru' WHERE full_name = 'Петров Пётр Сергеевич';
