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

CREATE TABLE IF NOT EXISTS stores (
 id INT AUTO_INCREMENT PRIMARY KEY,
 sap_id VARCHAR(50) UNIQUE,
 name VARCHAR(255),
 status VARCHAR(20) DEFAULT 'AKTYWNY'
);

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

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

CREATE TABLE IF NOT EXISTS order_items (
 id INT AUTO_INCREMENT PRIMARY KEY,
 order_id INT,
 product_id INT,
 quantity INT
);