-- Create table for image slider management
CREATE TABLE `tblslider` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SliderTitle` varchar(255) NOT NULL,
  `SliderImage` varchar(255) NOT NULL,
  `SliderDescription` text DEFAULT NULL,
  `SliderLink` varchar(255) DEFAULT NULL,
  `SliderOrder` int(11) DEFAULT 1,
  `Status` int(11) DEFAULT 1,
  `CreationDate` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert sample Apple slider images
INSERT INTO `tblslider` (`SliderTitle`, `SliderImage`, `SliderDescription`, `SliderLink`, `SliderOrder`, `Status`) VALUES
('Apple iPhone Collection', 'apple-slider-1.jpg', 'Discover the latest iPhone models with cutting-edge technology', 'shop-mobile.php', 1, 1),
('Apple Accessories', 'apple-slider-2.jpg', 'Complete your Apple experience with premium accessories', 'shop-mobile.php', 2, 1);