CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
login VARCHAR(100),
password VARCHAR(255),
role VARCHAR(50)
);

CREATE TABLE IF NOT EXISTS suppliers (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
active INT DEFAULT 1
);

CREATE TABLE IF NOT EXISTS products (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
supplier_id INT,
price DECIMAL(10,2)
);

CREATE TABLE IF NOT EXISTS orders (
id INT AUTO_INCREMENT PRIMARY KEY,
store_id INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);