-- Hero Slides Table for Australian Agro
CREATE TABLE IF NOT EXISTS hero_slides (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(200) NOT NULL,
    subtitle TEXT,
    description TEXT,
    image_path VARCHAR(255) NOT NULL,
    button_text VARCHAR(100),
    button_link VARCHAR(255),
    sort_order INT DEFAULT 0,
    is_active BOOLEAN DEFAULT TRUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Insert default slides
INSERT INTO hero_slides (title, subtitle, description, image_path, button_text, button_link, sort_order) VALUES
('Grow with Agro, Earn with Agro', 'Join Australia\'s premier agro farming MLM platform', 'Invest in sustainable agriculture products and build a profitable network while supporting eco-friendly farming practices.', 'assets/images/hero-slide-1.jpg', 'Start Earning', 'register.php', 1),
('Sustainable Farming Solutions', 'Premium organic products for modern agriculture', 'Discover our range of organic seeds, natural fertilizers, and professional farming equipment designed for sustainable growth.', 'assets/images/hero-slide-2.jpg', 'View Products', 'products.php', 2),
('Build Your Team, Grow Your Income', 'Multi-level commission structure with daily returns', 'Earn through direct referrals, level commissions, and team rewards. Start with as little as $50 and watch your income grow.', 'assets/images/hero-slide-3.jpg', 'Learn More', '#opportunity', 3);