🎉 Exclusive Offers For You

-- ============================================================
-- TABLE: offers
-- ============================================================
CREATE TABLE IF NOT EXISTS offers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    discount_percent DECIMAL(5,2) NOT NULL,
    coupon_code VARCHAR(50),
    valid_until DATE NOT NULL,
    is_active TINYINT(1) DEFAULT 1,
    image_url VARCHAR(500),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- ============================================================
-- SAMPLE DATA (Insert these rows)
-- ============================================================
INSERT INTO offers (title, description, discount_percent, coupon_code, valid_until, is_active, image_url) VALUES
('🎓 Freshers Special', 'Get 20% off on all career counseling sessions. Limited time offer!', 20.00, 'FRESH20', '2026-09-30', 1, 'https://images.unsplash.com/photo-1573496359142-b8d87734a5a2?w=400&h=300&fit=crop'),
('🚀 Internship Booster', 'Exclusive 15% discount on internship placement packages.', 15.00, 'BOOST15', '2026-10-15', 1, 'https://images.unsplash.com/photo-1522071820081-009f0129c71c?w=400&h=300&fit=crop'),
('💼 HR Mentorship', 'Flat ₹500 off on Dedicated HR Manager services.', 500.00, 'HR500', '2026-08-31', 1, 'https://images.unsplash.com/photo-1573164713988-8665fc963095?w=400&h=300&fit=crop'),
('📚 Upskilling Bundle', 'Buy 2 training programs, get 1 free (40% savings).', 40.00, 'BUNDLE40', '2026-11-01', 1, 'https://images.unsplash.com/photo-1542744173-8e7e53415bb0?w=400&h=300&fit=crop'),
('🎯 First Job Guarantee', '10% discount on our flagship placement assistance program.', 10.00, 'JOB10', '2026-12-25', 1, 'https://images.unsplash.com/photo-1516321318423-f06f85e504b3?w=400&h=300&fit=crop');