-- Our clients logos (home page). Run in phpMyAdmin (fizasie).
USE fizasie;

CREATE TABLE IF NOT EXISTS our_clients (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(200) NOT NULL,
    logo VARCHAR(255) NOT NULL,
    website_url VARCHAR(500) DEFAULT NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO site_settings (setting_key, setting_value) VALUES
('our_clients_title', 'Our clients'),
('our_clients_subtext', 'Trusted by brands across industries')
ON DUPLICATE KEY UPDATE setting_key = setting_key;

-- Optional dummy clients (SVG logos in uploads/clients/) — run seed_our_clients_dummy.sql after deploy
