-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 05, 2025 at 11:50 AM
-- Server version: 8.0.41-cll-lve
-- PHP Version: 8.3.20

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

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

--
-- Table structure for table `billing_address`
--

CREATE TABLE `billing_address` (
  `id` int NOT NULL,
  `firstname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `company_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signup_id` int DEFAULT NULL,
  `zip_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `billing_address`
--

INSERT INTO `billing_address` (`id`, `firstname`, `lastname`, `company_name`, `email`, `phone`, `address`, `signup_id`, `zip_code`, `city`, `state`, `country`, `created_at`, `updated_at`) VALUES
(1, 'John Doe', 'johndoe123', 'google dev group', 'john@example.com', '1234567890', '123 Main St', 10, '10001', 'New York', 'NY', 'USA', '2024-10-22 20:45:37', '2025-01-11 17:35:59'),
(7, 'manuel', 'hack', 'hackdevs', 'emmanuelbigboss26@gmail.com', '081234565433', 'awkuzu street', 36, '11021', 'awka atani', 'anambra state', 'Nigeria', '2025-01-20 01:15:45', '2025-01-20 01:15:45'),
(8, 'Chukwudi', 'Emmanuel', 'Chukwudi Emmanuel', 'ihenachochukwudi@gmail.com', '07045227853', 'federal housing estate,  road 17, plot117b', 33, '460102', 'Owerri', 'Imo', 'Nigeria', '2025-01-20 07:55:34', '2025-01-20 07:55:34');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `message` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `email`, `subject`, `message`, `created_at`) VALUES
(5, 'emmanuelbigboss26@gmail.com', 'i love to purchase that goods', 'i have been trying to purchase that chair but am not seeing it coming because its not working or coming on, i dont know wat the fault is', '2024-10-23 16:08:15'),
(6, 'sleekennju@yopmail.com', 'Enabling of SSH/Terminal access on cPanel', 'something about testing', '2024-11-14 15:37:29'),
(7, 'sleekennju@yopmail.com', 'subject test', 'message test', '2024-11-14 15:56:42'),
(8, 'ihenachochukwudi@gmail.com', 'test subject', 'test description', '2024-11-17 19:37:17');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int NOT NULL,
  `username` varchar(255) NOT NULL,
  `secondary_email` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created` enum('true','false') NOT NULL DEFAULT 'false',
  `signup_id` int NOT NULL,
  `address_line1` varchar(255) DEFAULT NULL,
  `address_line2` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `username`, `secondary_email`, `phone`, `image`, `created`, `signup_id`, `address_line1`, `address_line2`, `city`, `state`, `zip_code`, `country`, `created_at`, `updated_at`) VALUES
(12, 'HackHariks', 'test.hackdev@gmail.com', '09128374827', '1736663102_Black and Blue Initials Creative Logo.png', 'false', 10, 'main st road', 'RD avanue 12', 'bdg', 'lagos state', '101010', 'Nigerian', '2025-01-12 06:23:43', '2025-01-12 06:25:02'),
(14, 'hackboi', 'clickstatservice@gmail.com', '081234565433', '1737335703_sommy.png', 'false', 36, 'null', 'null', 'null', 'anambra state', '191010', 'Nigeria', '2025-01-20 01:15:03', '2025-01-20 01:15:03'),
(15, 'codewithsleek', 'ihenachochukwudi@yahoo.com', '07045227853', '1737359701_twitchProfilePic.jpg', 'false', 33, 'null', 'null', 'null', 'Imo', '460102', 'Nigeria', '2025-01-20 07:55:01', '2025-01-20 07:55:01');

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

--
-- Table structure for table `flash_sales`
--

CREATE TABLE `flash_sales` (
  `id` int NOT NULL,
  `product_id` int DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flash_sales`
--

INSERT INTO `flash_sales` (`id`, `product_id`, `sale_price`, `start_date`, `end_date`) VALUES
(7, 27, 500.00, '2024-10-26 23:11:21', '2024-10-27 23:11:21');

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `newsletter`
--

INSERT INTO `newsletter` (`id`, `email`, `status`, `created_at`) VALUES
(1, 'emmanuelbigboss26@gmail.com', 'true', '2025-01-07 23:17:04'),
(2, 'gaj@yopmail.com', 'true', '2025-01-08 00:04:01'),
(3, 'olumidemorenikeji75@gmail.com', 'true', '2025-03-17 07:20:39');

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

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

CREATE TABLE `orders` (
  `id` int NOT NULL,
  `signup_id` int DEFAULT NULL,
  `total_amount` int NOT NULL,
  `status` enum('Pending','Complete','Cancelled') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Pending',
  `order_progress` enum('Unconfirmed','Order placed','Packaging','Shipped','Delivered') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Unconfirmed',
  `order_ref` varchar(255) NOT NULL,
  `order_note` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `signup_id`, `total_amount`, `status`, `order_progress`, `order_ref`, `order_note`, `created_at`) VALUES
(1, 10, 100, 'Complete', 'Delivered', '', 'Donec ac vehicula turpis. Aenean sagittis est eu arcu ornare, eget venenatis purus lobortis. Aliquam erat volutpat. Aliquam magna odio.', '2024-10-29 17:48:39'),
(6, 10, 27000, 'Complete', 'Delivered', '', 'this is the order note for this orders.', '2024-11-20 10:53:14'),
(62, 36, 524500, 'Complete', 'Order placed', 'ORDER_6797d4dbc9bd18.59504466', 'i just wan to test this', '2025-01-27 18:47:55'),
(63, 36, 127700, 'Complete', 'Order placed', 'ORDER_6797d60dd47de5.66534563', 'i love this product', '2025-01-27 18:53:01'),
(64, 33, 42700, 'Complete', 'Order placed', 'ORDER_6797d80d6b0c06.88472117', 'Just testing order id email', '2025-01-27 19:01:33'),
(66, 36, 128300, 'Complete', 'Order placed', 'ORDER_6797daf7315bb3.63252580', 'giood for product', '2025-01-27 19:13:59'),
(67, 36, 128300, 'Complete', 'Order placed', 'ORDER_6797db91222382.34058226', 'giood for product', '2025-01-27 19:16:33'),
(68, 36, 128300, 'Complete', 'Order placed', 'ORDER_6797dc349ba655.82477354', 'giood for product', '2025-01-27 19:19:16'),
(69, 33, 28200, 'Pending', 'Delivered', 'ORDER_67980065962e25.43732465', 'something', '2025-01-27 21:53:41');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int NOT NULL,
  `order_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `price` int NOT NULL,
  `status` enum('pending','verified','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `status`, `created_at`) VALUES
(98, 62, 11, 2, 35000, 'verified', '2025-01-27 18:47:55'),
(99, 62, 16, 1, 80900, 'verified', '2025-01-27 18:47:55'),
(100, 62, 20, 3, 20000, 'verified', '2025-01-27 18:47:55'),
(101, 62, 23, 2, 120000, 'verified', '2025-01-27 18:47:55'),
(102, 63, 11, 1, 35000, 'verified', '2025-01-27 18:53:01'),
(103, 63, 10, 1, 84000, 'verified', '2025-01-27 18:53:01'),
(104, 64, 56, 1, 39500, 'verified', '2025-01-27 19:01:33'),
(107, 66, 16, 1, 80900, 'verified', '2025-01-27 19:13:59'),
(108, 66, 20, 1, 20000, 'verified', '2025-01-27 19:13:59'),
(109, 67, 16, 1, 80900, 'verified', '2025-01-27 19:16:33'),
(110, 67, 20, 1, 20000, 'verified', '2025-01-27 19:16:33'),
(111, 68, 16, 1, 80900, 'verified', '2025-01-27 19:19:16'),
(112, 68, 20, 1, 20000, 'verified', '2025-01-27 19:19:16'),
(113, 69, 58, 1, 25000, 'pending', '2025-01-27 21:53:41');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `price` int NOT NULL,
  `USD_price` int NOT NULL DEFAULT '95',
  `slashed_price` int DEFAULT NULL,
  `category` varchar(200) NOT NULL,
  `filter_category` enum('Woodens','Textiles','Ceramics','Rattons','Beads & Gems') NOT NULL DEFAULT 'Woodens',
  `sku` varchar(100) DEFAULT NULL,
  `color` varchar(200) NOT NULL DEFAULT 'Brown',
  `weight` varchar(200) NOT NULL DEFAULT '28kg',
  `stock` int DEFAULT '0',
  `brand` varchar(200) NOT NULL DEFAULT 'ukraft',
  `availability` enum('in stock','out of stock') DEFAULT 'in stock',
  `is_featured` tinyint(1) DEFAULT '0',
  `is_top_rated` tinyint(1) DEFAULT '0',
  `is_new_arrival` tinyint(1) DEFAULT '0',
  `is_best_seller` tinyint(1) DEFAULT '0',
  `total_rating` int DEFAULT NULL,
  `sales_count` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `description`, `price`, `USD_price`, `slashed_price`, `category`, `filter_category`, `sku`, `color`, `weight`, `stock`, `brand`, `availability`, `is_featured`, `is_top_rated`, `is_new_arrival`, `is_best_seller`, `total_rating`, `sales_count`, `created_at`, `updated_at`) VALUES
(10, 'Achabe Magazine Rack', 'A four corner magazine rack for storing family and friends photos, bulletins, books etc.', 84000, 95, 150000, 'Woodens', 'Woodens', 'TB2891', 'Brown', '10.7kg', 2, 'Woodsworth', '', 0, 1, 0, 0, 20, 22, '2024-10-25 21:59:22', '2025-01-25 19:28:31'),
(11, 'single large fired clay pot', 'Brown large clay pot for preparing all kind of dish', 35000, 95, 47000, 'ceramic', '', 'PT9337', 'African red Clay Brown', '2kg', 9, 'Cherry Kemi', '', 0, 1, 0, 0, 100, 15, '2024-10-25 21:59:22', '2025-01-25 19:27:38'),
(16, 'Full Chair in White', 'this chair has the ability to sustain your habit for long', 80900, 95, 200, 'Woodens', 'Woodens', 'WC0283', 'Brown', '28kg', 100, 'ukraft', 'in stock', 1, 0, 0, 0, 299, 474, '2024-10-25 21:59:22', '2024-11-10 12:16:23'),
(20, 'Stump Mirror', 'Unique tree stump embedded with mirror ', 20000, 95, 25000, 'Woodens', 'Woodens', 'NK2625', 'Oak Brown', '18kg', 6, 'Curvy Art & Craft', '', 0, 1, 0, 0, 40, 10, '2024-10-26 18:26:57', '2025-01-25 19:24:39'),
(23, 'Round rattan chair ', 'Rattan chair with cushion ', 120000, 95, 150000, 'Rattons', 'Rattons', 'CH2725', 'biege Brown', '22.5kg', 18, 'African rattan market Maryland', 'in stock', 0, 0, 1, 0, 28, 17, '2024-10-26 18:35:51', '2025-01-25 19:21:21'),
(24, 'Pulane Plate', 'design for family purpose', 15000, 95, 200, 'Woodens', 'Woodens', 'PL6292', 'Brown', '28kg', 293, 'ukraft', 'in stock', 0, 0, 1, 0, 288, 200, '2024-10-26 18:35:51', '2024-11-10 12:17:44'),
(27, 'EMPEROR SOFA by Befrique', 'Frame (inches): H28\" X W25\" X XD17\"\r\nAvailable colors: Brow, Black, Oak and white \r\nMaterial: Doubled HDF Board and stainless steel legs ', 251500, 95, 300000, 'Woodens', 'Woodens', 'YD2727', 'Brown', '37kg', 8, 'befrique Art woods ', 'in stock', 0, 1, 0, 0, 200, 27, '2024-10-26 19:36:48', '2025-01-20 22:35:11'),
(34, 'TIC TAC TOE SOFA', 'Frame (inches): H28\" X XW25\" XD17\"\r\nAvailable in colors Brown, Black, Oak and White, Material: Doubled HDF Boards\r\n', 280000, 95, 300000, 'Woodens', 'Woodens', 'SK6382', 'Brown', '40kg', 2, 'befrique Art woods ', 'in stock', 0, 1, 0, 0, 200, 11, '2024-10-26 20:04:03', '2025-01-21 15:42:40'),
(35, 'Cane Rattan Cushioned Chair (coffee pair)', 'A pair of Rattan cushioned seats with coffee table, steel enforcements and metal leg stands. Hand crafted ', 150000, 95, 150000, 'ratton', '', 'CT2723', 'Ochre yellow beige', '40kg', 2, 'African Craft Market Lagos', '', 0, 0, 0, 1, 300, 150, '2024-10-26 20:04:03', '2025-01-20 22:45:52'),
(56, 'Couple beaded wooden carving', 'Single Carved wooden African couple, embellished with tiny beads, for the African home represents union and marriage, the gong held by the man representing message of joy. \r\n\r\nA piece for home decoration  ', 39500, 95, 42000, 'Woodens', 'Woodens', 'UK8361', 'black', '2.7Kg', 5, 'African Craft Market Lagos', 'in stock', 0, 0, 1, 0, 100, 50, '2025-01-20 08:13:48', '2025-01-20 22:12:33'),
(57, 'Tribal Amoeba Tye Dye Batik print', '5 yards of full hand made Adire and Batik print wrapper', 25000, 95, 35000, 'Textiles', 'Textiles', 'UK4602', 'African indigo mix', '0.025kg', 9, 'Liltex ', 'in stock', 0, 0, 0, 1, 100, 50, '2025-01-22 05:36:52', '2025-01-22 05:36:52'),
(58, 'Dotted Star Dye Batik print', 'Dotted star Adire and Batik print 100% cotton 5 yards', 25000, 95, 35000, 'Textiles', 'Textiles', 'UK9431', 'African violet and green mix', '0.025kg', 9, 'Liltex ', 'in stock', 0, 0, 0, 1, 100, 20, '2025-01-22 05:46:57', '2025-01-22 05:46:57'),
(59, 'Love bird Tye dye and Batik print  ', '5 yards of Love bird print is done on 100% plain cotton, with original react natural dye can be used for varieties of your tailoring needs ', 25000, 95, 35000, 'Textiles', 'Textiles', 'UK1103', 'Purple and Orange', '0.025kg', 7, 'Liltex ', 'in stock', 0, 0, 0, 1, 100, 13, '2025-01-22 05:52:42', '2025-01-22 05:52:42'),
(60, 'Carved African Hippo', 'miniature African carved represented stories, the Hippo represents strength and resilience\r\ndimension: 35 X 30 inches  ', 25000, 95, 32500, 'Woodens', 'Woodens', 'UK6033', 'brown', '0.085kg', 5, 'Ismaila craft', 'out of stock', 1, 0, 0, 0, 100, 4, '2025-01-23 22:57:04', '2025-01-23 22:57:04'),
(61, 'African traditional wrestlers ', '52 inches in length of hand carved detailed table top African traditional wrestlers in action form, can be a delight for home interior decor', 40000, 95, 55000, 'Woodens', 'Woodens', 'UK8621', 'Oak brown', '2.9Kg', 2, 'Ismaila craft', 'in stock', 1, 0, 0, 0, 100, 4, '2025-01-23 23:18:17', '2025-01-23 23:18:17'),
(62, 'Carved Praying Man ', 'precise wooden carved prayer man, suitable for table top home and interior decor, represents steadfastness and dedication\r\ndimension of 40inches \r\n', 20000, 95, 32000, 'Woodens', 'Woodens', 'UK6824', 'Oak brown ', '0.8kg', 4, 'Ismaila craft', 'in stock', 1, 0, 0, 0, 150, 4, '2025-01-23 23:24:58', '2025-01-23 23:24:58'),
(63, 'twin crocodile carving, \'Aguiyi\'', 'wooden carved crocodile 🐊 representing strength and patience in the African story \'Aguiyi\'', 25000, 95, 32000, 'Woodens', 'Woodens', 'UK6706', 'oak wood brown ', '0.025kg', 0, 'Ismaila craft', 'in stock', 1, 0, 0, 0, 150, 5, '2025-01-24 23:18:36', '2025-01-24 23:18:36'),
(64, 'the Hornet Man ', 'the Hornet men represents a wooden carved expression of the the Hornet musicians of the North of Most African nations like Nigeria\r\n\r\nsell for 1 a piece and can be used as significant home decor and souvenirs ', 15500, 95, 20000, 'Woodens', 'Woodens', 'UK2700', 'Oak brown ', '0.5kg', 2, 'Ismaila craft', 'in stock', 1, 0, 0, 0, 33, 4, '2025-01-25 01:10:10', '2025-01-25 01:10:10'),
(65, 'couple Love', 'represents a wooden carved expression of a couple in love holding hands perfect gift or souvenir for your new home \r\n\r\nsell for 1 a piece and can be used as significant home decor and souvenirs ', 15000, 95, 20000, 'Woodens', 'Woodens', 'UK3714', 'Oak brown ', '0.075kg', 5, 'Ismaila craft', 'in stock', 0, 0, 1, 0, 50, 35, '2025-01-25 01:13:13', '2025-01-25 01:13:13'),
(66, 'Carved Dancing Maiden ', 'Dancing Maidens wooden carved expression of the the African Cultural Dance showing the Fertility dance ritual \r\n\r\ncan be used as significant home decor and souvenirs ', 25399, 95, 32000, 'Woodens', 'Woodens', 'UK5516', 'Oak brown ', '0.035kg', 2, 'Ismaila craft', 'in stock', 0, 0, 1, 0, 52, 10, '2025-01-25 01:18:32', '2025-01-25 01:18:32'),
(67, 'Carved African royalties', 'Royalties represents a wooden carved expression of the African royal kings, chiefs and queens of the Benin kingdom of present day Nigeria \r\n\r\nsells for 1 a piece and can be used as significant home decor and souvenirs ', 45000, 95, 54000, 'Woodens', 'Woodens', 'UK1307', 'bronze wooden finish', '2.5Kg', 4, 'Ismaila craft', 'in stock', 1, 0, 0, 0, 100, 9, '2025-01-25 01:23:57', '2025-01-25 01:23:57'),
(68, 'Wood Carved sound of Africa', 'hand carved sound of Africa used as table top piece \r\ndimension - 25cm length ', 10500, 95, 15000, 'Woodens', 'Woodens', 'UK7292', 'Oak brown ', '0.025kg', 3, 'Ismaila craft', 'in stock', 1, 0, 0, 0, 50, 4, '2025-01-25 11:10:32', '2025-01-25 11:10:32'),
(69, 'Wood Carved sound of Naija', 'wooden carved sound of Naija\r\ndimension; 25 cm', 12000, 95, 15000, 'Woodens', 'Woodens', 'UK7145', 'Oak brown ', '0.025kg', 3, 'Ismaila craft', 'in stock', 0, 0, 1, 0, 50, 6, '2025-01-25 11:24:40', '2025-01-25 11:24:40'),
(70, 'African Big Animals Carved Wall Hanging', 'Wooden Carved Big Nearly extinct yet preserved African large Animals, the Elephant, Rhinoceros, and Hippo in the Savana forest of the African wild Ecosystem.\r\nDimension; diameter 42cm\r\n ', 26500, 95, 31000, 'Woodens', 'Woodens', 'UK6959', 'Oak brown ', '1.5Kg', 4, 'Ismaila craft', 'in stock', 0, 0, 1, 0, 18, 8, '2025-01-25 11:31:22', '2025-01-25 11:31:22'),
(71, 'the Northern Tribal Mask Male and Female', 'The Northern Tribal Mask Male and Female can be sold in singles male and female but to get the best of the story told, of the oneness and power as a couple tribal mask, specially carved smooth embellished with colorful tiny beads of 40+ cm length', 55000, 95, 60000, 'Woodens', 'Woodens', 'UK7197', 'multi color/ oak brown', '2.0kg', 7, 'Ismaila craft', 'in stock', 0, 0, 0, 1, 150, 25, '2025-01-25 11:37:38', '2025-01-25 11:37:38'),
(72, 'Couple burst wooden carving', 'The Couple Burst, large burst represents a couple, can be sold in single on open market however to get the best of the story and cost here you go. Elegant hand-carved wooden busts representing African heritage and craftsmanship. Measuring approximately 30–40 cm (height), 10–15 cm (width), and 10–15 cm (depth) \r\nthese sculptures showcase intricate detailing and a smooth finish, embodying the essence of African artistry. Perfect for collectors or as unique decor pieces to add cultural charm to your space', 152000, 95, 160000, 'Woodens', 'Woodens', 'UK9929', 'Black oak', '10kg', 4, 'Ismaila Artifacts craft', 'in stock', 0, 0, 0, 1, 100, 8, '2025-01-25 12:02:26', '2025-01-25 12:02:26'),
(73, 'Carved Abstract Nude African Woman', 'This hand-carved African wooden sculpture weighs 0.8kg and features a sleek, minimalist design that highlights the beauty of African artistry. Measuring approximately 30 cm (height), 10 cm (width), and 8 cm (depth), it\'s a perfect tabletop decor piece that adds elegance and cultural charm to any space.', 10000, 95, 15000, 'Woodens', 'Woodens', 'UK7941', 'Oak brown ', '0.8kg', 10, 'Ismaila Artifacts craft', 'in stock', 1, 0, 0, 0, 32, 5, '2025-01-25 12:34:35', '2025-01-25 12:34:35'),
(75, 'Hand-carved African wooden sculpture', 'Hand-carved African wooden sculpture, this weighs 0.8kg and features a sleek, minimalist design that highlights the beauty of African artistry. Measuring approximately 30 cm (height), 10 cm (width), and 8 cm (depth), it\'s a perfect tabletop decor piece that adds elegance and cultural charm to any space.', 10000, 95, 15000, 'Woodens', 'Woodens', 'UK4438', 'Oak brown ', '0.8kg', 7, 'Ismaila Artifacts craft', 'in stock', 1, 0, 0, 0, 30, 1, '2025-01-25 12:53:11', '2025-01-25 12:53:11'),
(76, 'Couple wooden carving', 'This handcrafted African wooden sculpture weighs 1.2kg and captures a pensive figure of a cultural artistry. Measuring approximately 25 cm (height), 15 cm (width), and 12 cm (depth), this tabletop carving is a unique and meaningful addition to your decor, perfect for celebrating African craftsmanship.', 18000, 95, 25000, 'Woodens', 'Woodens', 'UK4611', 'Oak brown ', '1.2kg', 7, 'Ismaila Artifacts craft', 'in stock', 1, 0, 0, 0, 30, 6, '2025-01-25 12:58:53', '2025-01-25 12:58:53'),
(77, 'speak, hear, see and do no Evil monkeys', 'A popular 4 monkeys quote, showing \"speak, hear, see and do no Evil\"  expressions sold as a set of table/ shelve tops for home decorations\r\ndimension: 45 - 6 inches sizes', 26000, 95, 32000, 'Woodens', 'Woodens', 'UK7901', 'Black and beige brown ', '1.5Kg', 4, 'Ismaila Artifacts craft', 'in stock', 1, 0, 0, 0, 48, 4, '2025-01-25 19:17:52', '2025-01-25 19:17:52'),
(79, 'The Man in Thought', 'This handcrafted African wooden sculpture weighs 1.2kg and captures a pensive figure in a seated pose, reflecting deep thought and cultural artistry. Measuring approximately 25 cm (height), 15 cm (width), and 12 cm (depth), this tabletop carving is a unique and meaningful addition to your decor, perfect for celebrating African craftsmanship', 12000, 95, 15000, 'Woodens', 'Woodens', 'UK3940', 'Oak brown ', '1.2kg', 3, 'Ismaila Artifacts craft', 'in stock', 0, 1, 0, 0, 98, 8, '2025-01-25 23:34:39', '2025-01-25 23:34:39'),
(80, 'Bucket hat brilliance', 'hand woven crotchet works made from the finest wool yarns with brilliant symbolic African colors and Grand ma\'s stories to go get yours for the winter ', 15000, 95, 18000, 'Textiles', 'Textiles', 'UK6108', 'Brilliant colors', '0.002kg', 4, 'airlishilda apparel', 'in stock', 0, 0, 1, 0, 50, 4, '2025-01-26 00:07:04', '2025-01-26 00:07:04'),
(81, 'Bucket hat cool sunshine', 'hand woven crotchet works made from the finest wool yarns with brilliant symbolic African colors and Grand ma\'s stories to go get yours for the winter and cool spring ', 15000, 95, 18000, 'Textiles', 'Textiles', 'UK3204', 'sea blue and sunshine yellow', '0.002kg', 3, 'airlishilda apparel', 'in stock', 0, 0, 1, 0, 59, 5, '2025-01-26 00:10:03', '2025-01-26 00:10:03'),
(82, 'Bucket hat night beauty', 'hand woven crotchet works made from the finest wool yarns with brilliant symbolic African colors and Grand ma\'s stories to go get yours for the winter and cool night spring casuals', 15000, 95, 18000, 'Textiles', 'Textiles', 'UK3143', 'violet, sky blue and beigeege', '0.002kg', 3, 'airlishilda apparel', 'in stock', 0, 0, 1, 0, 50, 5, '2025-01-26 00:13:31', '2025-01-26 00:13:31'),
(83, 'Beaded Drummer\'s Couple', 'Carved from the finest Oak black wood with a smooth finish, embellished with red and black colourful tiny beads made for home decor and souvenirs ', 25000, 95, 35000, 'Woodens', 'Woodens', 'UK3051', 'Oak brown black and read', '1.2kg', 3, 'Ismaila Artifacts craft', 'in stock', 1, 0, 0, 0, 100, 8, '2025-01-27 18:30:20', '2025-01-27 18:30:20'),
(84, 'Beaded Kiondo hand bags', 'Made in Kenya, is weaving style, made from beads, is often referred to as a \"Beaded Kiondo\" (or simply \"Kiondo\" if woven traditionally). The Kiondo is a handwoven bag traditionally made by the Kikuyu and Kamba communities in Kenya, though this specific beaded style may be an artistic variation influenced by modern craft techniques.\r\n\r\nThe intricate beadwork suggests a blend of cultural artistry and contemporary fashion, making it a unique craft piece!', 15450, 95, 13500, 'Beads & Gems', 'Beads & Gems', 'UK3629', 'brown, cream white and black', '1.2kg', 10, 'Lucy Kenya', 'in stock', 0, 0, 1, 0, 25, 12, '2025-02-15 15:37:08', '2025-02-15 15:38:29'),
(85, 'Kiondo hand bag ', 'Make in Kenya, a unique weaving style, made from beads, is often referred to as a \"Beaded Kiondo\" (or simply \"Kiondo\" if woven traditionally). The Kiondo is a handwoven bag traditionally made by the Kikuyu and Kamba communities in Kenya, though this specific beaded style may be an artistic variation influenced by modern craft techniques.\r\n\r\nThe intricate beadwork suggests a blend of cultural artistry and contemporary fashion, making it a unique craft piece!', 15450, 95, 14500, 'Beads & Gems', 'Beads & Gems', 'UK2652', 'Multicolor- Red, Green, white, blue, violet, cream', '1.2kg', 7, 'Lucy Kenya', 'in stock', 0, 0, 1, 0, 25, 11, '2025-02-15 15:43:24', '2025-02-15 15:43:24'),
(88, 'Beaded Kiondo hand bag (ball beads)', 'Made in kenya, a unique weaving style, made from beads, is often referred to as a \"Beaded Kiondo\" (or simply \"Kiondo\" if woven traditionally). The Kiondo is a handwoven bag traditionally made by the Kikuyu and Kamba communities in Kenya, though this specific beaded style may be an artistic variation influenced by modern craft techniques.\r\n\r\nThe intricate beadwork suggests a blend of cultural artistry and contemporary fashion, making it a unique craft piece!', 15450, 95, 15000, 'Woodens', 'Woodens', 'UK8232', 'Cream white, chocolate brown and black ', '1.2kg', 5, 'Lucy Kenya', 'in stock', 0, 0, 1, 0, 18, 12, '2025-02-15 15:48:37', '2025-02-15 15:48:37'),
(89, 'Clay water filter  dispenser', 'Handcrafted Clay Water Dispenser – Eco-Friendly & Naturally Cooling\r\n\r\nExperience the timeless purity of water with this handmade clay water dispenser by Clay by Maienne. Designed for natural cooling, this eco-friendly dispenser maintains fresh, crisp water while preserving its minerals. Crafted from high-quality clay, it features a stainless steel tap, an elegant lid, and a durable structure, making it perfect for home or office use.\r\n\r\nFeatures:\r\n✅ Naturally cools water\r\n✅ Lead-free & eco-friendly\r\n✅ Enhances water taste\r\n✅ Durable stainless steel tap\r\n✅ Handmade by expert artisans\r\n\r\nCapacity: 18L at 0.5 density\r\nfragile packaging\r\ndelivery on custom order above 10day\r\ndelivery of express or in stock according to the tracking guideline ', 85500, 95, 97750, 'Ceramics', 'Ceramics', 'UK5778', 'red clay earth ', '9kg', 4, 'Clay by Marienne', 'out of stock', 0, 1, 0, 0, 35, 11, '2025-02-15 18:23:59', '2025-02-16 17:26:19'),
(90, 'Clay cooking pot 4.6L Non Glaze', 'Clay Cooking Pot – Handmade by Clay by Maienne\r\n\r\nCrafted with precision and tradition, this handmade clay cooking pot by Clay by Maienne brings an authentic touch to your kitchen. Made from natural, unglazed clay, it enhances flavors while retaining nutrients, perfect for slow cooking stews, soups, and traditional dishes. Its heat-retaining properties ensure even cooking, while the ergonomic handles and snug-fit lid provide ease of use. A timeless, eco-friendly addition to any kitchen, designed for those who appreciate the art of cooking with nature.\r\n\r\n🔸 Material: 100% Natural Clay\r\n🔸 Capacity: Approx. 4.6L\r\n🔸 Usage: Gas, firewood, charcoal stove (not for direct electric stove use) for use on electric cooker use a heat diffuser \r\n🔸 Care: Handwash only, soak before first use', 65000, 95, 65000, 'Ceramics', 'Ceramics', 'UK5717', 'red clay earth ', '3.5kg', 12, 'Clay by Marienne', 'out of stock', 0, 1, 0, 0, 35, 20, '2025-02-15 18:35:58', '2025-02-15 18:35:58'),
(91, 'Rattan Lounge seat ', 'Inspired by Pierre Jeanneret Design called the Rattan Lounge Chair, also known as the Chandigarh chair. It is characterized by:\r\nSolid teak wood frame\r\n\"V\" shaped legs\r\nCane seat and backrest or Credenza sheet\r\nWide, flat armrests\r\nPossible sizes:\r\nTypically, the chair measures around 30 inches in height, 25 inches in width, and 30 inches in depth.\r\nSeat height is usually around 17 inches.\r\nHowever, sizes may vary slightly depending on the manufacturer or contact WhatsApp for direct order choices ', 168500, 95, 195000, 'Woodens', 'Woodens', 'UK7671', 'Oak brown ', '18kg', 15, 'Ismaila craft', 'in stock', 0, 0, 0, 1, 89, 6, '2025-03-16 02:08:12', '2025-03-19 17:43:06'),
(92, 'Thrown Curvy Seat', 'Curvy seat is a unique approach to sustainable design and culture meet innovation, the use of less felled tree materials and yet maintaining style and class.\r\n\r\nthe thrown seat design comes with a 3ft standing 2.5ft diameter solid stomp top and branch curvy stool\r\n\r\nwith a complete 4ft tall, multiple curved branch embedded thrown seat with solid oat seat space resting across solid obeche patterned carved board\r\n\r\ncompletely styled to fit your space', 185000, 95, 200000, 'Woodens', 'Woodens', 'UK9308', 'Oak brown ', '25kg', 5, 'Sam Ejiofor\'s Curvy seat', 'in stock', 0, 0, 0, 1, 102, 10, '2025-03-16 02:34:36', '2025-03-16 02:34:36'),
(93, 'Curvy Seat 1', 'Curvy seat is a unique approach to sustainable design and culture meet innovation, the use of less felled tree materials and yet maintaining style and class.\r\n\r\nWith a 3ft tall height, curved branch embedded on curvy seat with solid oat seat space resting across solid obeche patterned carved board\r\n\r\ncompletely styled to fit your space', 86500, 95, 105000, 'Woodens', 'Woodens', 'UK3312', 'Oak brown ', '18Kg', 5, 'Sam Ejiofor\'s Curvy wood', 'in stock', 0, 0, 0, 1, 82, 24, '2025-03-16 02:44:45', '2025-03-16 02:44:45'),
(94, 'Curvy Mirror', 'Curvy is a unique approach to sustainable design and culture meet innovation, the use of less felled tree materials and yet maintaining style and class. With a 4.5ft tall height, Mirror surface of 3ft length, curved branch embedded on curvy frames with solid  woods, completely styled to fit your space', 95000, 95, 120000, 'Woodens', 'Woodens', 'UK6197', 'Oak brown ', '4.5kg', 10, 'Sam Ejiofor\'s Curvy wood', 'in stock', 0, 0, 0, 1, 85, 18, '2025-03-16 15:37:07', '2025-03-16 15:37:07');

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

--
-- Table structure for table `product_discounts`
--

CREATE TABLE `product_discounts` (
  `id` int NOT NULL,
  `product_id` int DEFAULT NULL,
  `discount_percentage` decimal(5,2) DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_until` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int NOT NULL,
  `product_id` int DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `is_primary` tinyint(1) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image_url`, `is_primary`, `created_at`, `updated_at`) VALUES
(9, 10, 'table1.png', 1, '2024-10-25 22:04:57', '2024-10-25 22:04:57'),
(10, 11, 'pot.png', 1, '2024-10-25 22:04:57', '2024-10-25 22:04:57'),
(15, 16, 'full_chair.png', 1, '2024-10-25 22:04:57', '2024-10-25 22:04:57'),
(19, 20, 'necklace.png', 1, '2024-10-26 18:28:43', '2024-10-26 18:28:43'),
(22, 23, 'chair22.png', 1, '2024-10-26 18:37:42', '2024-10-26 18:37:42'),
(23, 24, 'plate2.png', 1, '2024-10-26 18:37:42', '2024-10-26 18:37:42'),
(29, 34, 'chair3.png', 1, '2024-10-26 20:06:48', '2024-10-26 20:06:48'),
(30, 35, 'center_chair.png', 1, '2024-10-26 20:06:48', '2024-10-26 20:06:48'),
(78, 56, '1737411306_IMG-20250118-WA0050-Photoroom (1) - Copy.png', 1, '2025-01-20 22:15:06', '2025-01-20 22:15:06'),
(79, 57, '1737524212_IMG_0082.JPG', 1, '2025-01-22 05:36:52', '2025-01-22 05:36:52'),
(80, 58, '1737524817_IMG_0087.JPG', 1, '2025-01-22 05:46:57', '2025-01-22 05:46:57'),
(81, 27, '1737524896_IMG-20240109-WA0098.jpg', 1, '2025-01-22 05:48:16', '2025-01-22 05:48:16'),
(82, 59, '1737525162_IMG_0129.JPG', 1, '2025-01-22 05:52:42', '2025-01-22 05:52:42'),
(83, 60, '1737673024_IMG-20250118-WA0014-Photoroom.png', 1, '2025-01-23 22:57:04', '2025-01-23 22:57:04'),
(84, 60, '1737673024_IMG-20250118-WA0015-Photoroom.png', 0, '2025-01-23 22:57:04', '2025-01-23 22:57:04'),
(86, 62, '1737674698_IMG-20250118-WA0016-Photoroom (1).png', 1, '2025-01-23 23:24:58', '2025-01-23 23:24:58'),
(87, 62, '1737674698_IMG-20250118-WA0016-Photoroom.png', 0, '2025-01-23 23:24:58', '2025-01-23 23:24:58'),
(88, 61, '1737676457_IMG-20250118-WA0017-Photoroom (1).png', 1, '2025-01-23 23:54:17', '2025-01-23 23:54:17'),
(89, 61, '1737676457_IMG-20250118-WA0017-Photoroom.png', 0, '2025-01-23 23:54:17', '2025-01-23 23:54:17'),
(90, 63, '1737760716_IMG-20250118-WA0013-Photoroom (1).png', 1, '2025-01-24 23:18:36', '2025-01-24 23:18:36'),
(91, 63, '1737760716_IMG-20250118-WA0013-Photoroom (2).png', 0, '2025-01-24 23:18:36', '2025-01-24 23:18:36'),
(92, 63, '1737760716_IMG-20250118-WA0013-Photoroom.png', 0, '2025-01-24 23:18:36', '2025-01-24 23:18:36'),
(93, 64, '1737767410_IMG-20250118-WA0018-Photoroom (1).png', 1, '2025-01-25 01:10:10', '2025-01-25 01:10:10'),
(94, 64, '1737767410_IMG-20250118-WA0018-Photoroom.png', 0, '2025-01-25 01:10:10', '2025-01-25 01:10:10'),
(95, 65, '1737767593_IMG-20250118-WA0019-Photoroom (1).png', 1, '2025-01-25 01:13:13', '2025-01-25 01:13:13'),
(96, 65, '1737767593_IMG-20250118-WA0019-Photoroom.png', 0, '2025-01-25 01:13:13', '2025-01-25 01:13:13'),
(97, 66, '1737767912_IMG-20250118-WA0020-Photoroom (1).png', 1, '2025-01-25 01:18:32', '2025-01-25 01:18:32'),
(98, 66, '1737767912_IMG-20250118-WA0020-Photoroom.png', 0, '2025-01-25 01:18:32', '2025-01-25 01:18:32'),
(99, 67, '1737768237_IMG-20250118-WA0021-Photoroom (1).png', 1, '2025-01-25 01:23:57', '2025-01-25 01:23:57'),
(100, 67, '1737768237_IMG-20250118-WA0021-Photoroom.png', 0, '2025-01-25 01:23:57', '2025-01-25 01:23:57'),
(101, 68, '1737803432_Ismailah Images 1 (18).png', 1, '2025-01-25 11:10:32', '2025-01-25 11:10:32'),
(102, 68, '1737803432_Ismailah Images 1 (19).png', 0, '2025-01-25 11:10:32', '2025-01-25 11:10:32'),
(103, 69, '1737804280_Ismailah Images 1 (20).png', 1, '2025-01-25 11:24:40', '2025-01-25 11:24:40'),
(104, 69, '1737804280_Ismailah Images 1 (21).png', 0, '2025-01-25 11:24:40', '2025-01-25 11:24:40'),
(105, 70, '1737804682_Ismailah Images 1 (22).png', 1, '2025-01-25 11:31:22', '2025-01-25 11:31:22'),
(106, 70, '1737804682_Ismailah Images 1 (23).png', 0, '2025-01-25 11:31:22', '2025-01-25 11:31:22'),
(107, 71, '1737805058_Ismailah Images 1 (24).png', 1, '2025-01-25 11:37:38', '2025-01-25 11:37:38'),
(108, 71, '1737805058_Ismailah Images 1 (25).png', 0, '2025-01-25 11:37:39', '2025-01-25 11:37:39'),
(109, 72, '1737806546_Ismailah Images 1 (26).png', 1, '2025-01-25 12:02:26', '2025-01-25 12:02:26'),
(110, 72, '1737806546_Ismailah Images 1 (27).png', 0, '2025-01-25 12:02:26', '2025-01-25 12:02:26'),
(111, 73, '1737808475_Ismailah Images 1 (28).png', 1, '2025-01-25 12:34:35', '2025-01-25 12:34:35'),
(112, 73, '1737808475_Ismailah Images 1 (29).png', 0, '2025-01-25 12:34:35', '2025-01-25 12:34:35'),
(113, 75, '1737809591_Ismailah Images 1 (32).png', 1, '2025-01-25 12:53:11', '2025-01-25 12:53:11'),
(114, 75, '1737809591_Ismailah Images 1 (33).png', 0, '2025-01-25 12:53:11', '2025-01-25 12:53:11'),
(115, 76, '1737809933_Ismailah Images 1 (34).png', 1, '2025-01-25 12:58:53', '2025-01-25 12:58:53'),
(116, 76, '1737809933_Ismailah Images 1 (35).png', 0, '2025-01-25 12:58:53', '2025-01-25 12:58:53'),
(117, 77, '1737832672_Ismailah Images 1 (36).png', 1, '2025-01-25 19:17:52', '2025-01-25 19:17:52'),
(118, 77, '1737832672_Ismailah Images 1 (37).png', 0, '2025-01-25 19:17:52', '2025-01-25 19:17:52'),
(120, 79, '1737848079_Ismailah_Images 1 (30).png', 1, '2025-01-25 23:34:39', '2025-01-25 23:34:39'),
(121, 79, '1737848079_Ismailah_Images_1 (31).png', 0, '2025-01-25 23:34:39', '2025-01-25 23:34:39'),
(122, 80, '1737850024_Hilda_crotchet_1 (4).png', 1, '2025-01-26 00:07:04', '2025-01-26 00:07:04'),
(123, 80, '1737850024_Hilda_crotchet_1 (5).png', 0, '2025-01-26 00:07:04', '2025-01-26 00:07:04'),
(124, 81, '1737850203_Hilda_crotchet_1 (6).png', 1, '2025-01-26 00:10:03', '2025-01-26 00:10:03'),
(125, 81, '1737850203_Hilda_crotchet_1 (7).png', 0, '2025-01-26 00:10:03', '2025-01-26 00:10:03'),
(126, 82, '1737850411_Hilda_crotchet_1 (2).png', 1, '2025-01-26 00:13:31', '2025-01-26 00:13:31'),
(127, 82, '1737850411_Hilda_crotchet_1 (3).png', 0, '2025-01-26 00:13:31', '2025-01-26 00:13:31'),
(128, 83, '1738002620_Ismailah Images 1 (74).png', 1, '2025-01-27 18:30:20', '2025-01-27 18:30:20'),
(129, 83, '1738002620_Ismailah Images 1 (75).png', 0, '2025-01-27 18:30:20', '2025-01-27 18:30:20'),
(130, 84, '1739633828_Lucy_Craft_Edit1 (6).png', 1, '2025-02-15 15:37:08', '2025-02-15 15:37:08'),
(131, 84, '1739633828_Lucy_Craft_Edit1 (7).png', 0, '2025-02-15 15:37:08', '2025-02-15 15:37:08'),
(132, 85, '1739634204_Lucy_Craft_Edit1 (8).png', 1, '2025-02-15 15:43:24', '2025-02-15 15:43:24'),
(133, 85, '1739634204_Lucy_Craft_Edit1 (9).png', 0, '2025-02-15 15:43:24', '2025-02-15 15:43:24'),
(134, 88, '1739634517_Lucy_Craft_Edit1 (11).png', 1, '2025-02-15 15:48:37', '2025-02-15 15:48:37'),
(135, 89, '1739643839_Maryam  (2)-Photoroom (1).png', 1, '2025-02-15 18:23:59', '2025-02-15 18:23:59'),
(136, 89, '1739643839_Maryam  (2)-Photoroom.png', 0, '2025-02-15 18:23:59', '2025-02-15 18:23:59'),
(137, 90, '1739644558_Maryam  (5)-Photoroom (1).png', 1, '2025-02-15 18:35:58', '2025-02-15 18:35:58'),
(138, 90, '1739644558_Maryam  (5)-Photoroom.png', 0, '2025-02-15 18:35:58', '2025-02-15 18:35:58'),
(139, 91, '1742090892_IMG-20240220-WA0005.jpg', 1, '2025-03-16 02:08:12', '2025-03-16 02:08:12'),
(140, 91, '1742090892_IMG-20240220-WA0037.jpg', 0, '2025-03-16 02:08:12', '2025-03-16 02:08:12'),
(141, 91, '1742090892_IMG-20240220-WA0038.jpg', 0, '2025-03-16 02:08:12', '2025-03-16 02:08:12'),
(142, 91, '1742090892_IMG-20240220-WA0040.jpg', 0, '2025-03-16 02:08:12', '2025-03-16 02:08:12'),
(143, 92, '1742092476_curvy seat throne_pR1 (1).png', 1, '2025-03-16 02:34:36', '2025-03-16 02:34:36'),
(144, 92, '1742092476_curvy seat throne_pR1 (2).png', 0, '2025-03-16 02:34:36', '2025-03-16 02:34:36'),
(145, 92, '1742092476_curvy seat throne_pR1 (3).png', 0, '2025-03-16 02:34:36', '2025-03-16 02:34:36'),
(146, 93, '1742093086_curvy seat 1.jpg', 1, '2025-03-16 02:44:46', '2025-03-16 02:44:46'),
(147, 93, '1742093086_curvy seat 1_b#.jpg', 0, '2025-03-16 02:44:46', '2025-03-16 02:44:46'),
(148, 94, '1742139427_curvy mirror 1.jpg', 1, '2025-03-16 15:37:07', '2025-03-16 15:37:07'),
(149, 94, '1742139427_curvy mirror 2.jpg', 0, '2025-03-16 15:37:07', '2025-03-16 15:37:07'),
(150, 94, '1742139427_curvy mirror 3.png', 0, '2025-03-16 15:37:07', '2025-03-16 15:37:07');

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` int NOT NULL,
  `product_id` int DEFAULT NULL,
  `signup_id` int DEFAULT NULL,
  `rating` int DEFAULT NULL,
  `review` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ;

--
-- Dumping data for table `product_reviews`
--

INSERT INTO `product_reviews` (`id`, `product_id`, `signup_id`, `rating`, `review`, `created_at`) VALUES
(15, 11, 10, 4, '', '2024-10-29 07:38:49'),
(16, 35, 10, 4, '', '2024-10-29 07:38:49'),
(17, 34, NULL, 4, '', '2024-10-29 07:43:21'),
(24, 23, 10, 2, '', '2024-10-29 07:46:35'),
(26, 20, 10, 5, '', '2024-10-29 07:48:07'),
(32, 10, NULL, 2, '', '2024-11-18 17:03:38'),
(36, 16, NULL, 3, 'good products', '2024-11-18 17:13:12'),
(40, 20, NULL, 5, '', '2024-11-18 17:13:12'),
(41, 20, 10, 5, '', '2024-11-18 17:13:12'),
(44, 23, 10, 2, '', '2024-11-18 17:13:12'),
(45, 24, 10, 1, 'good product', '2024-11-18 17:13:12'),
(48, 27, NULL, 4, '', '2024-11-18 17:21:31'),
(51, 34, 10, 4, '', '2024-11-18 17:21:31'),
(52, 35, NULL, 4, '', '2024-11-18 17:21:31'),
(72, 56, NULL, 3, '', '2025-01-20 08:13:48'),
(73, 57, NULL, 4, NULL, '2025-01-22 05:36:52'),
(74, 58, NULL, 3, NULL, '2025-01-22 05:46:57'),
(75, 59, NULL, 1, NULL, '2025-01-22 05:52:42'),
(76, 60, NULL, 3, NULL, '2025-01-23 22:57:04'),
(77, 61, NULL, 3, '', '2025-01-23 23:18:17'),
(78, 62, NULL, 3, '', '2025-01-23 23:24:58'),
(79, 63, NULL, 1, NULL, '2025-01-24 23:18:36'),
(80, 64, NULL, 3, NULL, '2025-01-25 01:10:10'),
(81, 65, NULL, 4, NULL, '2025-01-25 01:13:13'),
(82, 66, NULL, 3, NULL, '2025-01-25 01:18:32'),
(83, 67, NULL, 3, NULL, '2025-01-25 01:23:57'),
(84, 68, NULL, 2, NULL, '2025-01-25 11:10:32'),
(85, 69, NULL, 2, NULL, '2025-01-25 11:24:40'),
(86, 70, NULL, 3, NULL, '2025-01-25 11:31:22'),
(87, 71, NULL, 4, NULL, '2025-01-25 11:37:39'),
(88, 72, NULL, 1, NULL, '2025-01-25 12:02:26'),
(89, 73, NULL, 3, NULL, '2025-01-25 12:34:35'),
(91, 75, NULL, 1, NULL, '2025-01-25 12:53:11'),
(92, 76, NULL, 1, NULL, '2025-01-25 12:58:53'),
(93, 77, NULL, 1, NULL, '2025-01-25 19:17:52'),
(95, 79, NULL, 3, NULL, '2025-01-25 23:34:39'),
(96, 80, NULL, 3, NULL, '2025-01-26 00:07:04'),
(97, 81, NULL, 1, NULL, '2025-01-26 00:10:03'),
(98, 82, NULL, 2, NULL, '2025-01-26 00:13:31'),
(99, 83, NULL, 1, NULL, '2025-01-27 18:30:20'),
(100, 84, NULL, 4, '', '2025-02-15 15:37:08'),
(101, 85, NULL, 4, NULL, '2025-02-15 15:43:24'),
(102, 88, NULL, 4, NULL, '2025-02-15 15:48:37'),
(103, 89, NULL, 5, '', '2025-02-15 18:23:59'),
(104, 90, NULL, 4, NULL, '2025-02-15 18:35:58'),
(105, 91, NULL, 4, '', '2025-03-16 02:08:12'),
(106, 92, NULL, 4, '', '2025-03-16 02:34:36'),
(107, 93, NULL, 4, NULL, '2025-03-16 02:44:46'),
(108, 94, NULL, 1, NULL, '2025-03-16 15:37:07');

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

--
-- Table structure for table `product_variations`
--

CREATE TABLE `product_variations` (
  `id` int NOT NULL,
  `product_id` int DEFAULT NULL,
  `attribute_name` varchar(255) DEFAULT NULL,
  `attribute_value` varchar(255) DEFAULT NULL,
  `price` int DEFAULT NULL COMMENT 'If the variation has a different price',
  `stock` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_variations`
--

INSERT INTO `product_variations` (`id`, `product_id`, `attribute_name`, `attribute_value`, `price`, `stock`, `created_at`, `updated_at`) VALUES
(7, 10, 'color', 'red', NULL, NULL, '2024-10-26 20:13:52', '2024-10-28 08:21:17'),
(8, 27, 'weight', '28kg', NULL, NULL, '2024-10-26 20:14:56', '2024-10-28 08:21:21');

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

--
-- Table structure for table `related_products`
--

CREATE TABLE `related_products` (
  `product_id` int NOT NULL,
  `related_product_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `shipping_address`
--

CREATE TABLE `shipping_address` (
  `id` int NOT NULL,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signup_id` int DEFAULT NULL,
  `zip_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shipping_address`
--

INSERT INTO `shipping_address` (`id`, `firstname`, `lastname`, `company_name`, `email`, `phone`, `address`, `signup_id`, `zip_code`, `city`, `state`, `country`) VALUES
(3, 'John Doe', 'johndoe123', 'google dev group', 'john@example.com', '1234567890', '123 Main St', 10, '10001', 'New York', 'NY', 'USA'),
(6, 'manuel', 'hack', 'hackdevs', 'emmanuelbigboss26@gmail.com', '081234565433', 'awkuzu street', 36, '11021', 'awka atani', 'anambra state', 'Nigeria'),
(7, 'Chukwudi', 'Emmanuel', 'Chukwudi Emmanuel', 'ihenachochukwudi@gmail.com', '07045227853', 'federal housing estate, road 17, plot117b', 33, '460102', 'Owerri', 'Imo', 'Nigeria');

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

--
-- Table structure for table `signup`
--

CREATE TABLE `signup` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` enum('pending','verified') NOT NULL DEFAULT 'pending',
  `password` varchar(255) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `verification_code` varchar(200) DEFAULT NULL,
  `temp_token` varchar(255) DEFAULT NULL,
  `temp_token_validation` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `signup`
--

INSERT INTO `signup` (`id`, `name`, `email`, `status`, `password`, `token`, `verification_code`, `temp_token`, `temp_token_validation`, `created_at`) VALUES
(10, 'Manuel Hacks', 'emmanuelbigboss26@gmail.coms', 'verified', '$2y$10$vyyw3PfvTaKcZ0QZk1oyuumQshO9ACPC4zKffgmLEGeu02rvI4LzS', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJ1a3JhZnQiLCJhdWQiOiJ1a3JhZnQiLCJpYXQiOjE3MzAzODUyNzEsIm5iZiI6MTczMDM4NTI3MSwiZXhwIjoxNzMwMzg4ODcxLCJ1c2VySWQiOjE1LCJlbWFpbCI6ImVtbWFudWVsYmlnYm9zczI2QGdtYWlsLmNvbSJ9.C0kn2jXC9pIFBsWCHE61Mh_FSjZaaEO-nLgdkylNo', NULL, NULL, NULL, '2024-10-20 11:51:26'),
(33, 'Chukwudi Emmanuel', 'ihenachochukwudi@gmail.com', 'verified', '$2y$10$/DFp.XzeDb3W3ypkMXZEOuz2yuncHLPuuWj6at5V/OBMo84f17F9C', NULL, NULL, NULL, NULL, '2025-01-19 23:20:01'),
(36, 'manuel hack', 'emmanuelbigboss26@gmail.com', 'verified', '$2y$10$PwWNHZJIg5VwocBA0mGkkejJz/FwHd/CGf4uD.eM1crY/eoWWtzHG', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJ1a3JhZnQiLCJhdWQiOiJ1a3JhZnQiLCJpYXQiOjE3MzczMzU1MTksIm5iZiI6MTczNzMzNTUxOSwiZXhwIjoxNzM3MzM5MTE5LCJ1c2VySWQiOiIzNiIsImVtYWlsIjoiZW1tYW51ZWxiaWdib3NzMjZAZ21haWwuY29tIn0.e0AeBXSMAEpl7Ip6Sw7KRhgMPqxICLLCpJuLjx', NULL, 'e1916bcb23bd3c7cf7fab1cd8fd4a8ce16603121563158d31285979cc979fac1', '2025-01-20 01:37:34', '2025-01-20 00:51:38'),
(37, 'Francis Njoku Admin test 1', 'francisnjokuseo@gmail.com', 'verified', '$2y$10$ChHCXqkReCAkoWISKLbjH.bbCj3XRRV3BuSwC0q7wNHIvPGnfT8qK', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJ1a3JhZnQiLCJhdWQiOiJ1a3JhZnQiLCJpYXQiOjE3Mzk2MzQ5OTEsIm5iZiI6MTczOTYzNDk5MSwiZXhwIjoxNzM5NjM4NTkxLCJ1c2VySWQiOiIzNyIsImVtYWlsIjoiZnJhbmNpc25qb2t1c2VvQGdtYWlsLmNvbSJ9.xD2k_gA1SIez99QkfAyZ3CDJsfWZ6FYn272vXsLVq', NULL, NULL, NULL, '2025-01-20 08:24:19'),
(38, 'Udochukwu Emeka', 'udochukwuleonard57@gmail.com', 'verified', '$2y$10$dMsYwp5GNEuJPu7t59Kd1OMbl0MpSgphdcUenhDDnbuw5348Q.UkW', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJ1a3JhZnQiLCJhdWQiOiJ1a3JhZnQiLCJpYXQiOjE3Mzc1NDAzNTEsIm5iZiI6MTczNzU0MDM1MSwiZXhwIjoxNzM3NTQzOTUxLCJ1c2VySWQiOiIzOCIsImVtYWlsIjoidWRvY2h1a3d1bGVvbmFyZDU3QGdtYWlsLmNvbSJ9.xY3YVZxLNJM_YYoDbqhCbFSbypf_ozczRqnNE', NULL, NULL, NULL, '2025-01-22 10:05:51'),
(39, 'Adeniran ', 'adeniranquwam001@gmail.com', 'verified', '$2y$10$UBzkV3W73/DxvPwOaOMnHeVxtzxFb3mNdGrZPULulaTAEod0y0fte', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJ1a3JhZnQiLCJhdWQiOiJ1a3JhZnQiLCJpYXQiOjE3Mzc3NDY5MjMsIm5iZiI6MTczNzc0NjkyMywiZXhwIjoxNzM3NzUwNTIzLCJ1c2VySWQiOiIzOSIsImVtYWlsIjoiYWRlbmlyYW5xdXdhbTAwMUBnbWFpbC5jb20ifQ.2kJoof-hK1DiaVa07m_f50TSKOcUnBkbigFgoN6', NULL, NULL, NULL, '2025-01-24 19:28:01'),
(40, 'Chidinma Okafor Modupe', 'giftokwara33@gmail.com', 'verified', '$2y$10$kX1Yot.FRPpcs9MSkB5Z2O0/T0CYGiy/HPHQgFDbs7TVGi/ohif4W', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJ1a3JhZnQiLCJhdWQiOiJ1a3JhZnQiLCJpYXQiOjE3MzkzMDQ0ODgsIm5iZiI6MTczOTMwNDQ4OCwiZXhwIjoxNzM5MzA4MDg4LCJ1c2VySWQiOiI0MCIsImVtYWlsIjoiZ2lmdG9rd2FyYTMzQGdtYWlsLmNvbSJ9.j0KvAgtOc5anGmzlzJTl0m7CfxzPaE9T1YfR-FIn2Mg', NULL, NULL, NULL, '2025-02-11 20:05:22');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int NOT NULL,
  `transaction_reference` varchar(255) NOT NULL,
  `transaction_type` varchar(200) NOT NULL,
  `order_id` int NOT NULL,
  `status` varchar(50) DEFAULT NULL,
  `amount` int DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `squadco_message` varchar(200) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `transaction_reference`, `transaction_type`, `order_id`, `status`, `amount`, `currency`, `squadco_message`, `created_at`, `updated_at`) VALUES
(8, 'SQHACK6386769679805700001', 'Card', 6, 'Success', 27000, 'NGN', 'charge_successful', '2024-11-20 10:54:42', '2024-11-20 10:54:42'),
(24, 'SQHACK6387360047876800003', 'Card', 62, 'Success', 524500, 'NGN', 'charge_successful', '2025-01-27 18:48:51', '2025-01-27 18:48:51'),
(25, 'SQHACK6387360078304700004', 'Card', 63, 'Success', 127700, 'NGN', 'charge_successful', '2025-01-27 18:53:46', '2025-01-27 18:53:46'),
(26, 'SQHACK6387360129858700005', 'Card', 64, 'Success', 42700, 'NGN', 'charge_successful', '2025-01-27 19:03:20', '2025-01-27 19:03:20'),
(28, 'SQHACK6387360203980500007', 'Card', 66, 'Success', 128300, 'NGN', 'charge_successful', '2025-01-27 19:14:21', '2025-01-27 19:14:21'),
(29, 'SQHACK6387360219426600008', 'Card', 67, 'Success', 128300, 'NGN', 'charge_successful', '2025-01-27 19:16:53', '2025-01-27 19:16:53'),
(30, 'SQHACK6387360235760800009', 'Card', 68, 'Success', 128300, 'NGN', 'charge_successful', '2025-01-27 19:19:41', '2025-01-27 19:19:41');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `billing_address`
--
ALTER TABLE `billing_address`
  ADD PRIMARY KEY (`id`),
  ADD KEY `billing_address_ibfk_1` (`signup_id`);

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

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `secondary_email` (`secondary_email`),
  ADD KEY `customers_ibfk_1` (`signup_id`);

--
-- Indexes for table `flash_sales`
--
ALTER TABLE `flash_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `flash_sales_ibfk_1` (`product_id`);

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_signup_ibfk_1` (`signup_id`),
  ADD KEY `Order_ref` (`order_ref`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_ibfk_1` (`order_id`),
  ADD KEY `order_items_ibfk_2` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sku` (`sku`);

--
-- Indexes for table `product_discounts`
--
ALTER TABLE `product_discounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_discounts_ibfk_1` (`product_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_images_ibfk_1` (`product_id`);

--
-- Indexes for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_reviews_ibfk_1` (`product_id`),
  ADD KEY `INDEX_SIGNUP` (`signup_id`);

--
-- Indexes for table `product_variations`
--
ALTER TABLE `product_variations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_variations_ibfk_1` (`product_id`);

--
-- Indexes for table `related_products`
--
ALTER TABLE `related_products`
  ADD PRIMARY KEY (`product_id`,`related_product_id`),
  ADD KEY `related_products_ibfk_2` (`related_product_id`);

--
-- Indexes for table `shipping_address`
--
ALTER TABLE `shipping_address`
  ADD PRIMARY KEY (`id`),
  ADD KEY `index` (`signup_id`);

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transaction_reference` (`transaction_reference`),
  ADD KEY `orders_ibfk_1` (`order_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `billing_address`
--
ALTER TABLE `billing_address`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `flash_sales`
--
ALTER TABLE `flash_sales`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `newsletter`
--
ALTER TABLE `newsletter`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;

--
-- AUTO_INCREMENT for table `product_discounts`
--
ALTER TABLE `product_discounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT for table `product_reviews`
--
ALTER TABLE `product_reviews`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_variations`
--
ALTER TABLE `product_variations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `shipping_address`
--
ALTER TABLE `shipping_address`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `signup`
--
ALTER TABLE `signup`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `billing_address`
--
ALTER TABLE `billing_address`
  ADD CONSTRAINT `billing_address_ibfk_1` FOREIGN KEY (`signup_id`) REFERENCES `signup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `customers`
--
ALTER TABLE `customers`
  ADD CONSTRAINT `customers_ibfk_1` FOREIGN KEY (`signup_id`) REFERENCES `signup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `flash_sales`
--
ALTER TABLE `flash_sales`
  ADD CONSTRAINT `flash_sales_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_signup_ibfk_1` FOREIGN KEY (`signup_id`) REFERENCES `signup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_discounts`
--
ALTER TABLE `product_discounts`
  ADD CONSTRAINT `product_discounts_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD CONSTRAINT `product_reviews_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `signup_id_ibfk_1` FOREIGN KEY (`signup_id`) REFERENCES `signup` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `product_variations`
--
ALTER TABLE `product_variations`
  ADD CONSTRAINT `product_variations_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `related_products`
--
ALTER TABLE `related_products`
  ADD CONSTRAINT `related_products_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `related_products_ibfk_2` FOREIGN KEY (`related_product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `shipping_address`
--
ALTER TABLE `shipping_address`
  ADD CONSTRAINT `shipping_address_ibfk_1` FOREIGN KEY (`signup_id`) REFERENCES `signup` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;
