CREATE TABLE IF NOT EXISTS stores (
 id INT AUTO_INCREMENT PRIMARY KEY,
 sap_id VARCHAR(50) UNIQUE NOT NULL,
 centrala_id VARCHAR(50),
 skrot VARCHAR(100),
 nazwa VARCHAR(255),
 nip VARCHAR(30),
 lokalizacja VARCHAR(255),
 ulica VARCHAR(255),
 kategoria VARCHAR(100),
 kod_csa VARCHAR(100),
 format VARCHAR(100),
 wojewodztwo VARCHAR(100),
 doradca VARCHAR(255),
 telefon VARCHAR(100),
 email VARCHAR(255),
 status VARCHAR(20) DEFAULT 'AKTYWNY',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS import_logs (
 id INT AUTO_INCREMENT PRIMARY KEY,
 filename VARCHAR(255),
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 added INT DEFAULT 0,
 updated INT DEFAULT 0,
 disabled INT DEFAULT 0
);