-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 15, 2025 at 06:55 AM -- Server version: 11.4.8-MariaDB-cll-lve -- PHP Version: 8.3.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `pamdrafist_dynamic-coupons` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `username`, `password`) VALUES (1, 'admin', '$2b$12$W/tfeXgUc9OtFpQC.AxM5u0wr2.5wxcobO1E8Q4k97lq2fL2Uofp6'); -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` int(11) NOT NULL, `category` varchar(100) DEFAULT NULL, `discount` varchar(50) DEFAULT NULL, `brand` varchar(200) DEFAULT NULL, `product` varchar(200) DEFAULT NULL, `description` text DEFAULT NULL, `code` varchar(100) DEFAULT NULL, `expiry` varchar(50) DEFAULT NULL, `icon` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `coupons` -- INSERT INTO `coupons` (`id`, `category`, `discount`, `brand`, `product`, `description`, `code`, `expiry`, `icon`) VALUES (1, 'electronics', '75% OFF', 'Apple', 'iPhone 15 Pro', 'Latest flagship smartphone with advanced camera', 'APPLE75SAVE', '12/15/2023', 'fas fa-mobile-alt'), (2, 'fashion', '80% OFF', 'Nike', 'Air Max Sneakers', 'Premium athletic shoes with maximum comfort', 'NIKE80DEAL', '11/30/2023', 'fas fa-shoe-prints'), (3, 'home', '70% OFF', 'KitchenAid', 'Stand Mixer', 'Professional-grade mixer for all your baking needs', 'KITCHEN70MIX', '12/20/2023', 'fas fa-blender'), (4, 'health', '85% OFF', 'Colgate', 'Oral Care Kit', 'Complete dental hygiene set with electric toothbrush', 'COLGATE85SMILE', '12/10/2023', 'fas fa-tooth'), (5, 'electronics', '72% OFF', 'Samsung', 'Galaxy Tab S9', 'High-performance tablet for work and entertainment', 'SAMSUNG72TAB', '12/05/2023', 'fas fa-tablet-alt'), (6, 'fashion', '78% OFF', 'Levi\'s', 'Classic Jeans', 'Authentic denim jeans in various fits and washes', 'LEVIS78DENIM', '11/25/2023', 'fas fa-tshirt'), (7, 'home', '82% OFF', 'Dyson', 'Vacuum Cleaner', 'Powerful cordless vacuum with advanced filtration', 'DYSON82CLEAN', '12/18/2023', 'fas fa-wind'), (8, 'health', '77% OFF', 'Fitbit', 'Charge 6 Fitness Tracker', 'Advanced health and activity monitoring', 'FITBIT77TRACK', '12/12/2023', 'fas fa-heartbeat'), (9, 'electronics', '88% OFF', 'Sony', 'PlayStation 5', 'Next-gen gaming console with 4K gaming', 'SONY88PLAY', '12/25/2023', 'fas fa-gamepad'), (10, 'fashion', '73% OFF', 'The North Face', 'Winter Jacket', 'Insulated waterproof jacket for extreme cold', 'NORTHFACE73WARM', '11/28/2023', 'fas fa-mountain'), (11, 'home', '79% OFF', 'Nest', 'Smart Thermostat', 'Wi-Fi enabled programmable home thermostat', 'NEST79SMART', '12/22/2023', 'fas fa-thermometer-half'), (12, 'health', '84% OFF', 'Nature Made', 'Vitamin Bundle', 'Complete daily vitamin and supplement pack', 'NATURE84HEALTH', '12/08/2023', 'fas fa-capsules'), (13, 'electronics', '76% OFF', 'Dell', 'XPS Laptop', 'High-performance laptop for professionals', 'DELL76WORK', '12/14/2023', 'fas fa-laptop'), (14, 'fashion', '81% OFF', 'Ray-Ban', 'Aviator Sunglasses', 'Classic UV protection polarized sunglasses', 'RAYBAN81SHADE', '12/02/2023', 'fas fa-sun'), (15, 'home', '86% OFF', 'Keurig', 'K-Elite Coffee Maker', 'Single-serve coffee brewer with strong brew option', 'KEURIG86BREW', '12/16/2023', 'fas fa-coffee'), (16, 'health', '74% OFF', 'Theragun', 'Massage Device', 'Professional percussion massage therapy gun', 'THERAGUN74RELAX', '11/29/2023', 'fas fa-hand-holding-heart'), (17, 'electronics', '89% OFF', 'Bose', 'Noise Cancelling Headphones', 'Premium over-ear headphones with superior sound', 'BOSE89SOUND', '12/24/2023', 'fas fa-headphones'), (18, 'fashion', '71% OFF', 'Fossil', 'Smartwatch', 'Hybrid smartwatch with fitness tracking', 'FOSSIL71TIME', '12/07/2023', 'fas fa-clock'), (19, 'home', '83% OFF', 'Weber', 'Grill Master Set', 'Premium charcoal grill with accessories', 'WEBER83GRILL', '12/19/2023', 'fas fa-fire'), (20, 'health', '87% OFF', 'Oral-B', 'Electric Toothbrush', 'Advanced electric toothbrush with multiple modes', 'ORALB87SMILE', '12/11/2023', 'fas fa-teeth'), (21, 'electronics', '75% OFF', 'GoPro', 'HERO12 Camera', 'Action camera for adventure photography', 'GOPRO75SHOOT', '12/13/2023', 'fas fa-camera'), (22, 'fashion', '80% OFF', 'Coach', 'Signature Handbag', 'Luxury leather handbag with signature print', 'COACH80STYLE', '12/01/2023', 'fas fa-shopping-bag'), (23, 'home', '78% OFF', 'Ninja', 'Foodi Pressure Cooker', 'Multi-functional pressure cooker and air fryer', 'NINJA78COOK', '12/17/2023', 'fas fa-utensils'), (24, 'health', '82% OFF', 'Lululemon', 'Yoga Collection', 'Premium yoga pants and accessories set', 'LULU82FIT', '12/09/2023', 'fas fa-spa'), (25, 'electronics', '85% OFF', 'Microsoft', 'Surface Pro', '2-in-1 laptop and tablet with pen', 'MICROSOFT85PRO', '12/21/2023', 'fas fa-laptop-code'), (26, 'fashion', '77% OFF', 'Calvin Klein', 'Modern Fit Suit', 'Tailored business suit with contemporary fit', 'CALVIN77STYLE', '11/26/2023', 'fas fa-user-tie'), (27, 'home', '84% OFF', 'Ring', 'Video Doorbell', 'Smart video doorbell with motion detection', 'RING84SECURE', '12/23/2023', 'fas fa-door-closed'), (28, 'health', '79% OFF', 'Garnier', 'Skincare Bundle', 'Complete skincare regimen for all skin types', 'GARNIER79GLOW', '12/06/2023', 'fas fa-spa'), (29, 'electronics', '90% OFF', 'JBL', 'Flip 6 Speaker', 'Portable waterproof Bluetooth speaker', 'JBL90TUNE', '12/26/2023', 'fas fa-volume-up'), (30, 'fashion', '73% OFF', 'Under Armour', 'Sportswear Set', 'Performance athletic wear for training', 'UA73SPORT', '12/03/2023', 'fas fa-running'); -- -------------------------------------------------------- -- -- Table structure for table `redirects` -- CREATE TABLE `redirects` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `bot_check_url` varchar(255) NOT NULL, `post_bot_url` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `redirects` -- INSERT INTO `redirects` (`id`, `name`, `bot_check_url`, `post_bot_url`) VALUES (1, 'Black Friday Offer', 'bot-check.php', 'https://example.com/black-friday-deals/123'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `key` varchar(100) NOT NULL, `value` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`key`, `value`) VALUES ('footer_contact', '123 Com Street, New York, NY 10001'), ('header_text', 'USA Exclusive Deals -'), ('header_tfn', '+1 (555) 123-7777'), ('social_links', '{\"facebook\":\"https:\\/\\/facebook.com\",\"twitter\":\"https:\\/\\/twitter.com\",\"instagram\":\"https:\\/\\/instagram.com\",\"pinterest\":\"https:\\/\\/pinterest.com\"}'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `coupons` -- ALTER TABLE `coupons` ADD PRIMARY KEY (`id`); -- -- Indexes for table `redirects` -- ALTER TABLE `redirects` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`key`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `coupons` -- ALTER TABLE `coupons` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `redirects` -- ALTER TABLE `redirects` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;