---

-- 1. Создаем таблицу Поставщики (suppliers)
CREATE TABLE suppliers (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    address TEXT,
    phone TEXT
);

-- 2. Создаем таблицу Товары (products)
CREATE TABLE products (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    article TEXT UNIQUE,
    quantity INTEGER,
    price REAL,
    supplier_id INTEGER,
    FOREIGN KEY (supplier_id) REFERENCES suppliers(id)
);

-- 3. Добавляем данные о поставщиках
INSERT INTO suppliers (name, address, phone) VALUES 
('Nike Official', 'Moscow, Lenina st. 10', '+79991112233'),
('Adidas Store', 'Saint Petersburg, Mira st. 5', '+79994445566');

-- 4. Добавляем данные о товарах
INSERT INTO products (name, article, quantity, price, supplier_id) VALUES 
('Кроссовки Nike Air', 'NK-001', 15, 12000.00, 1),
('Кеды Adidas Superstar', 'AD-002', 20, 9500.00, 2),
('Ботинки Nike Boots', 'NK-003', 8, 15000.00, 1);