-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 18, 2025 at 12:23 AM
-- Server version: 10.6.21-MariaDB-cll-lve-log
-- PHP Version: 8.3.19

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: `webrbaew_candycleanse_crystal`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `admin_id` int(255) NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `admin_email` varchar(255) NOT NULL,
  `admin_password` varchar(255) NOT NULL,
  `admin_image` varchar(255) DEFAULT NULL,
  `admin_phone` text DEFAULT NULL,
  `admin_address` text DEFAULT NULL,
  `role` enum('Super Admin','Admin','User') NOT NULL,
  `date_added` datetime NOT NULL,
  `added_by` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`admin_id`, `admin_name`, `admin_email`, `admin_password`, `admin_image`, `admin_phone`, `admin_address`, `role`, `date_added`, `added_by`) VALUES
(1001, 'Crystal Woods', 'admin@gmail.com', 'admin', '1744949197_7882.jpg', NULL, NULL, 'Super Admin', '0000-00-00 00:00:00', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `banner_id` int(255) NOT NULL,
  `banner_first_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`banner_id`, `banner_first_image`) VALUES
(4, '-image_1--image_1-candy_cleanse_header-compressed.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `cust_ip` text NOT NULL,
  `prod_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `date_added` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`id`, `cust_ip`, `prod_id`, `quantity`, `date_added`) VALUES
(10, '73.222.88.139', 13047, 1, '2025-01-27'),
(47, '174.58.18.4', 13042, 1, '2025-02-18'),
(51, '174.238.103.21', 13043, 1, '2025-03-25'),
(58, '173.252.95.114', 13051, 1, '2025-03-28'),
(59, '173.252.95.114', 13041, 1, '2025-03-28'),
(60, '174.218.53.4', 13051, 1, '2025-03-30'),
(61, '174.218.53.4', 13050, 1, '2025-03-30'),
(62, '107.13.221.236', 12888, 1, '2025-03-30'),
(63, '193.186.4.82', 13058, 1, '2025-04-01'),
(64, '107.13.208.222', 13050, 1, '2025-04-03'),
(65, '107.13.221.236', 13051, 1, '2025-04-05'),
(68, '172.74.80.17', 13055, 1, '2025-04-15'),
(69, '107.13.221.236', 13058, 1, '2025-04-16'),
(70, '39.50.128.149', 8691, 1, '2025-04-16');

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `c_id` int(255) NOT NULL,
  `c_name` text DEFAULT NULL,
  `picture` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`c_id`, `c_name`, `picture`) VALUES
(5, '2025-01-28', '5-image_1-te1.jpg'),
(6, '2025-01-28', '6-image_1-te2.jpg'),
(7, '2025-01-28', '7-image_1-te3.jpg'),
(11, '2025-01-28', '11-image_1-te4.jpg'),
(12, '2025-01-28', '12-image_1-te5.jpg'),
(13, '2025-01-28', '13-image_1-te6.jpg'),
(14, '2025-01-28', '14-image_1-te7.jpg'),
(15, '2025-01-28', '15-image_1-te8.jpg'),
(16, '2025-01-28', '16-image_1-te9.jpg'),
(17, '2025-01-28', '17-image_1-te10.jpg'),
(18, '2025-01-28', '18-image_1-te11.jpg'),
(19, '2025-01-28', '19-image_1-te12.jpg'),
(20, '2025-01-28', '20-image_1-testimonial-2.jpg'),
(21, '2025-01-28', '21-image_1-testimonial-4.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `order_id` text NOT NULL,
  `customer_email` text NOT NULL,
  `customer_name` text NOT NULL,
  `customer_phone` text NOT NULL,
  `total_price` float NOT NULL,
  `order_date` date NOT NULL,
  `download_passcode` longtext NOT NULL,
  `user_state` varchar(255) DEFAULT NULL,
  `user_city` varchar(255) DEFAULT NULL,
  `user_postalcode` varchar(255) DEFAULT NULL,
  `order_address` text DEFAULT NULL,
  `shipping_cost` double DEFAULT NULL,
  `order_complete` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_quantity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(255) NOT NULL,
  `product_title` varchar(255) NOT NULL,
  `product_price` int(255) NOT NULL,
  `product_description` text NOT NULL,
  `product_image` varchar(255) NOT NULL,
  `type` enum('weight','banner','stand') NOT NULL DEFAULT 'weight',
  `unit` enum('lbs','oz') NOT NULL,
  `weight` float NOT NULL,
  `product_shipping_cost` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`product_id`, `product_title`, `product_price`, `product_description`, `product_image`, `type`, `unit`, `weight`, `product_shipping_cost`, `status`) VALUES
(6403, '16oz Tropical Punch To Make Yourself', 120, 'Take a trip to paradise with Tropical Punch Candy Cleanse, a delicious escape formulated to support your gut, aid your digestion, and advance your weight-management goals. With a burst of fruity flavor, this instant tea offers a refreshing and relaxing cleanse that will have you living on island time.*\r\n16 Oz Tropical Punch Candy Cleanse Make at-Home Kit- Pack Of 7 Bottles.', '1.jpg', 'weight', 'oz', 3, 12, 1),
(8691, '8oz Tropical Punch Ready Made', 75, '8oz Tropical Punch Candy Cleanse\r\nPre-Made & Ready to Drink - Pack Of 7 Bottles', '1.jpg', 'weight', 'oz', 3, 12, 1),
(11071, '16oz Watermelon To Make Yourself', 120, 'Enjoy a taste of summer with this juicy flavor of our world-renowned Watermelon Candy Cleanse!\r\n16 Oz Watermelon Candy Cleanse\r\nMake at Home Kit - Pack Of 7 Bottles', '2.jpg', 'weight', 'lbs', 1, 12, 1),
(12888, '8oz Watermelon Ready Made', 85, '8oz Watermelon Candy Cleanse\r\nPre-Made & Ready to Drink - Pack Of 7 Bottles', '2.jpg', 'weight', 'lbs', 1.5, 12, 1),
(12890, 'Chaga Superfood', 70, 'Harness the power of the legendary Chaga mushroom, prized for its uses in traditional medicine in the Far East. Feed your body with Chaga for the support you need to feel unstoppable.', '3.jpg', 'weight', 'lbs', 1, 12, 1),
(12894, 'Delgada Instant Coffee', 80, 'Enjoy the rich flavor of Delgada, a bold roast, spray-dried instant coffee containing Garcinia cambogia extract to support your weight-management goals. Start your day off right with a cup of our premium coffee, the perfect addition to your wellness program.', 'IMG-20250103-WA0025.jpg', 'weight', 'lbs', 1.2, 12, 1),
(12897, 'DyNamic Duo - Delgado + NRG', 140, '..', 'IMG-20250103-WA0030.jpg', 'weight', 'oz', 7, 12, 1),
(12899, 'NRG', 70, 'Plug into your potential and take charge of your day with NRG! Take one capsule with 8 or more fl. oz. of water once per day to electrify your mind and aid your weight-management program!*', '6.jpg', 'banner', 'lbs', 8, 40, 1),
(13031, 'Iaso Tea - Tamarindo', 45, 'Produced in the tropics of Mexico and Central America, the tamarind fruit fuses notes of sweet and sour to create a vibrant, tangy taste. This Latin-inspired cleansing tea not only supports your gut, digestion, and weight-management goals but also treats you to a bold flavor youâ€™ll want to savor.', 'IMG-20250103-WA0020.jpg', 'weight', 'oz', 4, 12, 1),
(13037, 'Iaso Tea - Tropical Punch', 60, 'Tropical Punch IasoÂ® Instant Tea, a delicious escape formulated to support your gut, aid your digestion, and advance your weight-management goals. With a burst of fruity flavor, this instant tea offers a refreshing and relaxing cleanse that will have you living on island time.', 'WhatsApp Image 2025-01-02 at 11.33.59 PM.jpeg', 'weight', 'oz', 4, 12, 1),
(13040, 'Iaso Tea - Watermelon', 45, '..', '9.jpg', 'weight', 'oz', 6, 12, 1),
(13041, 'NutraBurst', 70, 'NutraBurst is much more than a regular daily supplement. This easily-digestible liquid multivitamin is designed to deliver essential elements that help nourish and strengthen your body. Our multi-blend formula contains 72 Minerals, 12 Vitamins, 22 Phytonutrients, 18 Amino Acids, and 18 vegetables. Thatâ€™s 142 reasons to start your day!*', '10.jpg', 'weight', 'oz', 4, 12, 1),
(13042, 'Resolution Drops', 70, 'Resolutions arenâ€™t just for the new year. Struggling to support healthy weight-management goals or kick your cravings for junk food? Consider Resolution Drops to supplement a balanced diet and help you carve a path to your goals.*', 'IMG-20250103-WA0019.jpg', 'weight', 'oz', 4, 12, 1),
(13043, 'Techui', 65, '..', '11.jpg', 'weight', 'oz', 9, 12, 0),
(13047, 'NRG 1 pack 3 pills', 15, '..', 'IMG-20250103-WA0022.jpg', 'stand', 'lbs', 20, 75, 1),
(13050, 'Watermelon 2 sachets', 10, '..', '12.jpg', 'weight', 'lbs', 1, 7, 1),
(13051, 'Tropical fruit punch 5 sachets', 25, '..', '13.jpg', 'weight', 'lbs', 0, 12, 1),
(13055, 'Lemonade IasoÂ® Instant Tea', 120, 'Refresh your routine with the invigorating taste of Lemonade laso Instant Tea! Kick bloating to the curb and embrace a lighter, more energized you. This zesty citrus blend not only delights your taste buds but also supports digestion, promotes weight management, and keeps you feeling refreshed from the inside out. Every sip is a step toward a healthier, more vibrant lifestyle - because wellness should taste as good as it feels!', 'lem.jpg', 'weight', 'lbs', 0, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `review_id` int(255) NOT NULL,
  `product_id` int(11) NOT NULL,
  `review_name` varchar(255) NOT NULL,
  `review_title` varchar(255) NOT NULL,
  `review_text` text NOT NULL,
  `review_stars` int(10) NOT NULL DEFAULT 5,
  `review_time` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `shipping_rates`
--

CREATE TABLE `shipping_rates` (
  `id` int(11) NOT NULL,
  `type` enum('weight','stand','banner') NOT NULL,
  `unit` enum('lbs','oz','piece') NOT NULL,
  `range_from` float NOT NULL,
  `range_to` float NOT NULL,
  `shipping_cost` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shipping_rates`
--

INSERT INTO `shipping_rates` (`id`, `type`, `unit`, `range_from`, `range_to`, `shipping_cost`) VALUES
(1, 'weight', 'oz', 0, 12, 10),
(2, 'weight', 'lbs', 1, 2, 12),
(3, 'weight', 'lbs', 2, 3, 14),
(4, 'banner', 'lbs', 1, 8, 50),
(5, 'stand', 'lbs', 1, 20, 75);

-- --------------------------------------------------------

--
-- Table structure for table `system_configuration`
--

CREATE TABLE `system_configuration` (
  `id` int(11) NOT NULL,
  `system_name` text DEFAULT NULL,
  `system_title` text DEFAULT NULL,
  `system_email` text DEFAULT NULL,
  `system_phone` text DEFAULT NULL,
  `system_address` text DEFAULT NULL,
  `system_image` varchar(255) DEFAULT NULL,
  `system_facebook` longtext DEFAULT NULL,
  `system_instagram` longtext DEFAULT NULL,
  `system_youtube` longtext DEFAULT NULL,
  `system_twitter` longtext DEFAULT NULL,
  `theme_color` varchar(255) DEFAULT '#FF4E4E',
  `public_key` longtext DEFAULT NULL,
  `secret_key` longtext DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `system_configuration`
--

INSERT INTO `system_configuration` (`id`, `system_name`, `system_title`, `system_email`, `system_phone`, `system_address`, `system_image`, `system_facebook`, `system_instagram`, `system_youtube`, `system_twitter`, `theme_color`, `public_key`, `secret_key`) VALUES
(1, 'Candy Cleanse Weightloss Cleanse', NULL, 'lsa@millsonwheels.info', '(919) 407-0845', '#', '1744949231_8943.jpg', '#', '#', '#', '', '#ff4e4e', 'pk_test_51JK74sEVex5ZGUHnGiwAr8AjWuIauxYnBau86ifwLJtjGFBMhTjZTwtSH674KKC6JnppRilEthk08Al1VfPvmgm600V3V71pxP', 'sk_test_51JK74sEVex5ZGUHnwFJ0ux5PekiyXdtzacmwYnV8DoysNyf0UOdUsNqVvSU25SjQI86JTWrlfIFgB72IrMbe5N8N00GSpD2qwF');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`admin_id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`banner_id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`c_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `review`
--
ALTER TABLE `review`
  ADD PRIMARY KEY (`review_id`),
  ADD KEY `project_id` (`review_time`) USING BTREE;

--
-- Indexes for table `shipping_rates`
--
ALTER TABLE `shipping_rates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `system_configuration`
--
ALTER TABLE `system_configuration`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `admin_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1008;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `banner_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `c_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `product_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13061;

--
-- AUTO_INCREMENT for table `review`
--
ALTER TABLE `review`
  MODIFY `review_id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shipping_rates`
--
ALTER TABLE `shipping_rates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;
