--
-- Host: localhost    Database: aquarium_eccomerce1
-- ------------------------------------------------------


--
-- Table structure for table `about_section_hero`
--

CREATE TABLE `about_section_hero` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext,
  `image` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `about_section_hero`
--

INSERT INTO `about_section_hero` VALUES (1,'MK Aquarium orbit','Welcome to MK Aquarium Orbit, your one-stop destination for all things aquatic and pet-related! Established with a passion for animals and a commitment to quality, we specialize in providing a wide range of fish, birds, cats, and dogs with food and accessories tailored to meet their specific needs.','about_hero_images/2023-01-05.jpg');

--
-- Table structure for table `about_section_principle`
--

CREATE TABLE `about_section_principle` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `description` longtext,
  `image` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `about_section_principle`
--

INSERT INTO `about_section_principle` VALUES (1,'Bringing Aquatic Life and Pet Care to Your Doorstep','MK Aquarium Orbit','Established with a passion for animals and a commitment to quality, we specialize in providing a wide range of fish, birds, cats, and dogs with food and accessories tailored to meet their specific needs. Our mission is to create a thriving and vibrant environment for your pets, whether they are swimming in an aquarium, flying in a cage, or curled up by your side. Our team is dedicated to helping you create the ideal habitat for your pets. Whether you\'re a seasoned aquarium enthusiast or a first-time pet owner, we provide the guidance, products, and support you need to ensure your pets’ well-being and happiness. At MK Aquarium Orbit, we don’t just sell products; we foster a community of pet lovers who believe in the joy and companionship that animals bring into our lives.','about_principle_images/2024-02-24.jpg');

--
-- Table structure for table `about_section_stats`
--

CREATE TABLE `about_section_stats` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `label` varchar(100) DEFAULT NULL,
  `value` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `about_section_stats`
--

INSERT INTO `about_section_stats` VALUES (1,'Types of Fish','50+ '),(2,'Happy Customers','100+ '),(3,'Customized Tanks','20+'),(4,'Accessory Brands','30+');

--
-- Table structure for table `accounts_user_groups`
--

CREATE TABLE `accounts_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accounts_user_groups_user_id_group_id_59c0b32f_uniq` (`user_id`,`group_id`),
  KEY `accounts_user_groups_user_id_52b62117` (`user_id`),
  KEY `accounts_user_groups_group_id_bd11a704` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `accounts_user_groups`
--


--
-- Table structure for table `accounts_user_user_permissions`
--

CREATE TABLE `accounts_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accounts_user_user_permi_user_id_permission_id_2ab516c2_uniq` (`user_id`,`permission_id`),
  KEY `accounts_user_user_permissions_user_id_e4f0a161` (`user_id`),
  KEY `accounts_user_user_permissions_permission_id_113bb443` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `accounts_user_user_permissions`
--


--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `profile_image` varchar(100) DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` VALUES (1,'',2),(2,'',4);

--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissions_group_id_b120cbf9` (`group_id`),
  KEY `auth_group_permissions_permission_id_84c5c92e` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  KEY `auth_permission_content_type_id_2f476e4b` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add permission',1,'add_permission'),(2,'Can change permission',1,'change_permission'),(3,'Can delete permission',1,'delete_permission'),(4,'Can view permission',1,'view_permission'),(5,'Can add group',2,'add_group'),(6,'Can change group',2,'change_group'),(7,'Can delete group',2,'delete_group'),(8,'Can view group',2,'view_group'),(9,'Can add content type',3,'add_contenttype'),(10,'Can change content type',3,'change_contenttype'),(11,'Can delete content type',3,'delete_contenttype'),(12,'Can view content type',3,'view_contenttype'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add address book',5,'add_addressbook'),(18,'Can change address book',5,'change_addressbook'),(19,'Can delete address book',5,'delete_addressbook'),(20,'Can view address book',5,'view_addressbook'),(21,'Can add customer',6,'add_customer'),(22,'Can change customer',6,'change_customer'),(23,'Can delete customer',6,'delete_customer'),(24,'Can view customer',6,'view_customer'),(25,'Can add order history',7,'add_orderhistory'),(26,'Can change order history',7,'change_orderhistory'),(27,'Can delete order history',7,'delete_orderhistory'),(28,'Can view order history',7,'view_orderhistory'),(29,'Can add wishlist',8,'add_wishlist'),(30,'Can change wishlist',8,'change_wishlist'),(31,'Can delete wishlist',8,'delete_wishlist'),(32,'Can view wishlist',8,'view_wishlist'),(33,'Can add order item',9,'add_orderitem'),(34,'Can change order item',9,'change_orderitem'),(35,'Can delete order item',9,'delete_orderitem'),(36,'Can view order item',9,'view_orderitem'),(37,'Can add cart',10,'add_cart'),(38,'Can change cart',10,'change_cart'),(39,'Can delete cart',10,'delete_cart'),(40,'Can view cart',10,'view_cart'),(41,'Can add admins',11,'add_admins'),(42,'Can change admins',11,'change_admins'),(43,'Can delete admins',11,'delete_admins'),(44,'Can view admins',11,'view_admins'),(45,'Can add Product Review',12,'add_productreview'),(46,'Can change Product Review',12,'change_productreview'),(47,'Can delete Product Review',12,'delete_productreview'),(48,'Can view Product Review',12,'view_productreview'),(49,'Can add cart item',13,'add_cartitem'),(50,'Can change cart item',13,'change_cartitem'),(51,'Can delete cart item',13,'delete_cartitem'),(52,'Can view cart item',13,'view_cartitem'),(53,'Can add banner slider',14,'add_bannerslider'),(54,'Can change banner slider',14,'change_bannerslider'),(55,'Can delete banner slider',14,'delete_bannerslider'),(56,'Can view banner slider',14,'view_bannerslider'),(57,'Can add Category',15,'add_category'),(58,'Can change Category',15,'change_category'),(59,'Can delete Category',15,'delete_category'),(60,'Can view Category',15,'view_category'),(61,'Can add contact page',16,'add_contactpage'),(62,'Can change contact page',16,'change_contactpage'),(63,'Can delete contact page',16,'delete_contactpage'),(64,'Can view contact page',16,'view_contactpage'),(65,'Can add contact submission',17,'add_contactsubmission'),(66,'Can change contact submission',17,'change_contactsubmission'),(67,'Can delete contact submission',17,'delete_contactsubmission'),(68,'Can view contact submission',17,'view_contactsubmission'),(69,'Can add Coupon',18,'add_coupon'),(70,'Can change Coupon',18,'change_coupon'),(71,'Can delete Coupon',18,'delete_coupon'),(72,'Can view Coupon',18,'view_coupon'),(73,'Can add FAQ',19,'add_faq'),(74,'Can change FAQ',19,'change_faq'),(75,'Can delete FAQ',19,'delete_faq'),(76,'Can view FAQ',19,'view_faq'),(77,'Can add hero section',20,'add_herosection'),(78,'Can change hero section',20,'change_herosection'),(79,'Can delete hero section',20,'delete_herosection'),(80,'Can view hero section',20,'view_herosection'),(81,'Can add Notification',21,'add_notification'),(82,'Can change Notification',21,'change_notification'),(83,'Can delete Notification',21,'delete_notification'),(84,'Can view Notification',21,'view_notification'),(85,'Can add Parent Category',22,'add_parentcategory'),(86,'Can change Parent Category',22,'change_parentcategory'),(87,'Can delete Parent Category',22,'delete_parentcategory'),(88,'Can view Parent Category',22,'view_parentcategory'),(89,'Can add principle',23,'add_principle'),(90,'Can change principle',23,'change_principle'),(91,'Can delete principle',23,'delete_principle'),(92,'Can view principle',23,'view_principle'),(93,'Can add Product',24,'add_product'),(94,'Can change Product',24,'change_product'),(95,'Can delete Product',24,'delete_product'),(96,'Can view Product',24,'view_product'),(97,'Can add stats section',25,'add_statssection'),(98,'Can change stats section',25,'change_statssection'),(99,'Can delete stats section',25,'delete_statssection'),(100,'Can view stats section',25,'view_statssection'),(101,'Can add product video',26,'add_productvideo'),(102,'Can change product video',26,'change_productvideo'),(103,'Can delete product video',26,'delete_productvideo'),(104,'Can view product video',26,'view_productvideo'),(105,'Can add product image',27,'add_productimage'),(106,'Can change product image',27,'change_productimage'),(107,'Can delete product image',27,'delete_productimage'),(108,'Can view product image',27,'view_productimage'),(109,'Can add log entry',28,'add_logentry'),(110,'Can change log entry',28,'change_logentry'),(111,'Can delete log entry',28,'delete_logentry'),(112,'Can view log entry',28,'view_logentry'),(113,'Can add session',29,'add_session'),(114,'Can change session',29,'change_session'),(115,'Can delete session',29,'delete_session'),(116,'Can view session',29,'view_session'),(117,'Can add cleaning videos',30,'add_cleaningvideos'),(118,'Can change cleaning videos',30,'change_cleaningvideos'),(119,'Can delete cleaning videos',30,'delete_cleaningvideos'),(120,'Can view cleaning videos',30,'view_cleaningvideos');

--
-- Table structure for table `banner_slider`
--

CREATE TABLE `banner_slider` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `button_text` varchar(50) DEFAULT NULL,
  `button_link` varchar(200) DEFAULT NULL,
  `image` varchar(100) NOT NULL,
  `order` int NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `banner_slider`
--

INSERT INTO `banner_slider` VALUES (1,'Dive into the World of MK Aquarium Orbit','Explore a Stunning Collection of Fish, Filters, and Aquariums','Shop Now','shop_catalog/','banner_images/IMG-20241111-WA0009_Xz2AWYK.jpg',1,1),(2,'Your One-Stop Destination for Aquatic Beauty','High-Quality Fish, Filtration Systems, and Aquariums Await','Shop Now','shop_catalog/','banner_images/IMG-20241111-WA0010_laWSRi3.jpg',2,1),(3,'Transform Your Space with MK Aquarium Orbit','Premium Fish, Durable Filters, and Custom Aquariums at Your Fingertips','Shop Now','shop_catalog/','banner_images/IMG-20241111-WA0008_tNz7wDh.jpg',3,1);

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `description` longtext NOT NULL,
  `status` int NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `parent_category_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `categories_parent_category_id_a0ce61fa` (`parent_category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Fish Tanks','categories/category/51pdkgo2CmL._AC_UF10001000_QL80_.png','A high-quality fish tank designed to provide a spacious and secure environment for your aquatic life. Ideal for beginners and experienced aquarists alike, this tank is built to last and offers clear visibility to showcase your fish and aquatic plants beautifully.',1,'2024-11-14 07:31:20.097416','2024-11-14 07:31:20.097416',1),(2,'Aquarium Filters','categories/category/81q27E2lzL._AC_UF10001000_QL80_.jpg','Our Aquarium Filters are designed to keep your aquarium water clear, clean, and healthy. They are equipped with advanced filtration systems that efficiently remove debris, waste, and toxins from the water, ensuring a balanced and safe environment for your fish.',1,'2024-11-14 08:54:08.073967','2024-11-14 08:56:22.815140',1),(4,'Aquarium Pumps','categories/category/portable-aquarium-air-pump.jpg','Our Aquarium Air Pumps are designed to provide essential oxygenation for your tank. They work efficiently to maintain consistent water movement, ensuring your fish remain healthy and comfortable.',1,'2024-11-14 09:56:47.577419','2024-11-14 10:59:28.159378',1),(5,'Aquarium Heaters','categories/category/61tz13t4NFL._AC_UF10001000_QL80_.jpg','Keep your aquarium at the perfect temperature with our Aquarium Heater. Whether you have tropical fish or delicate plants, this heater is designed to regulate the water temperature, creating a stable environment for your aquatic pets.',1,'2024-11-14 09:57:48.813574','2024-11-14 09:57:48.813574',1),(6,'Aquarium Lights','categories/category/63a14c41ab0723176b6dfe82-hcdmre-led-air-bubble-light-aquarium.jpg','Enhance the beauty of your aquarium and support plant growth with our Aquarium Lights. Designed for both functionality and aesthetics, these LED lights will brighten up your tank, showcasing your aquatic life and adding ambiance to any room.',1,'2024-11-14 10:00:25.385656','2024-11-14 10:00:25.385656',1),(13,'Fish Food','categories/category/81mSmDAvRTL.jpg','Fish Food is specially formulated to meet the nutritional needs of aquatic pets, providing them with the essential vitamins, minerals, and proteins for healthy growth and vibrant coloration. Available in a variety of types—such as flakes, pellets, granules, or freeze-dried—fish food is tailored to different species, from tropical fish and goldfish to bettas, cichlids, and marine fish.',1,'2024-11-14 10:31:54.068499','2024-11-14 10:31:54.068499',3),(14,'Automatic Fish Feeders','categories/category/81JoIbWrcWL._AC_UF10001000_QL80_.jpg','Automatic Fish Feeders from MK Aquarium Orbit provide a convenient and reliable way to ensure your fish are fed on time, even when you\'re away. These feeders are designed to dispense the right amount of food at preset intervals, maintaining a consistent feeding schedule for your aquatic pets. Perfect for both freshwater and marine aquariums, they help reduce overfeeding and waste, promoting a healthier tank environment.',1,'2024-11-14 10:33:21.291208','2024-11-14 10:36:49.009907',3),(15,'Colored Pebbles','categories/category/71ksZ30J4NL.jpg','Colored Pebbles from MK Aquarium Orbit are vibrant, decorative stones that add a beautiful touch to any aquarium or terrarium. Available in a variety of colors and sizes, these pebbles create a visually appealing substrate, enhancing the natural beauty of your aquatic environment.',1,'2024-11-14 10:35:18.822797','2024-11-14 10:35:18.823799',4),(16,'Aquarium Decorations','categories/category/84d037b0-77b9-4d0a-ad36-313a01af4595.__CR00970600_PT0_SX970_V1___.jpg','Aquarium Decorations from MK Aquarium Orbit offer a wide range of stylish and functional items designed to enhance the beauty and habitat of your aquarium. From natural rock formations and artificial plants to cave structures and themed ornaments, our decorations create a visually stunning environment for your fish while providing hiding spots and enrichment.',1,'2024-11-14 10:36:27.741252','2024-11-14 10:36:27.741252',4),(17,'Bird Cages','categories/category/71O3MURE1mL.jpg','Bird Cages from MK Aquarium Orbit are designed to provide a safe, comfortable, and stylish home for your feathered friends. Made from high-quality, durable materials, these cages offer ample space for birds to move, play, and perch, promoting their health and well-being. Available in various sizes and styles, our bird cages cater to different bird species, from small parrots and finches to larger breeds like cockatoos and macaws.',1,'2024-11-14 10:39:06.631901','2024-11-14 10:39:06.631901',5),(18,'Bird Food','categories/category/91misVYCiXL._AC_UF10001000_QL80_.jpg','Bird Food from MK Aquarium Orbit is specially formulated to meet the nutritional needs of a variety of bird species, ensuring they stay healthy, active, and vibrant. Our range includes seeds, pellets, grains, and nutrient-rich blends, tailored for small birds like finches and budgies, as well as larger birds like parrots and cockatoos.',1,'2024-11-14 10:40:21.544135','2024-11-14 10:40:21.544135',5),(19,'Cat Food','categories/category/images.jpeg','Cat Food from MK Aquarium Orbit is crafted to provide a complete and balanced diet for your feline friends, supporting their health, energy, and vitality. Available in a variety of dry kibble, wet food, and treats, our cat food formulas are designed to meet the specific nutritional needs of cats at every life stage—from kittens to adult and senior cats.\r\n\r\n',1,'2024-11-14 10:43:27.673925','2024-11-14 10:43:27.673925',6),(20,'Cat Cages','categories/category/81yKZjr1GEL._AC_UF10001000_QL80_.jpg','Cat Cages from MK Aquarium Orbit provide a secure and comfortable space for your feline companions, whether for transport, rest, or temporary confinement. Made from sturdy, non-toxic materials, these cages are designed to ensure your cat’s safety while offering plenty of ventilation and visibility.',1,'2024-11-14 10:44:35.608708','2024-11-14 10:44:35.608708',6),(21,'Pet Food','categories/category/adobestock_197601740.jpeg','Pet Food from MK Aquarium Orbit is designed to provide your pets with a balanced and nutritious diet, promoting overall health and well-being. Whether you have dogs, cats, birds, or small animals, our carefully crafted food formulas are rich in essential vitamins, minerals, and proteins to meet the specific dietary needs of each pet.\r\n\r\n',1,'2024-11-14 10:46:17.829655','2024-11-14 10:46:17.829655',7),(22,'Poultry Cages','categories/category/csm_Kaefighaltung-Poultry-cages-UNIVENT-Starter-680-plus-1-Big-Dutch_xL2wloX.jpg','Poultry Cages from MK Aquarium Orbit are designed to provide a safe, spacious, and comfortable environment for your chickens, ducks, or other poultry. Made from durable, rust-resistant materials, these cages are built to withstand the elements and provide long-lasting use, whether for indoor or outdoor setups.',1,'2024-11-14 10:47:17.448039','2024-11-14 10:47:17.448039',7),(23,'Lamps ','categories/category/71CyocjzAnL.jpg','Lamps from MK Aquarium Orbit are designed to enhance the lighting and ambiance of your aquarium, providing optimal conditions for both aquatic life and plants. Our range includes LED aquarium lights, UV lamps, and grow lights, offering customizable brightness and color settings to create a vibrant underwater environment.',1,'2024-11-14 10:49:06.385047','2024-11-14 10:49:06.385047',8),(24,'Aquarium Lights','categories/category/13940104563_e96c28674d_b.jpg','Aquarium Lights from MK Aquarium Orbit are designed to provide optimal lighting for your fish, plants, and coral, ensuring a vibrant and healthy aquatic environment. Available in a variety of styles, including LED lights, fluorescent tubes, and color-changing options, our aquarium lights are perfect for both freshwater and marine aquariums.',1,'2024-11-14 10:50:06.255361','2024-11-14 10:50:06.255361',8),(25,'Plastic Containers','categories/category/71cLlsIwOmL._AC_UF10001000_QL80_.jpg','Plastic Containers from MK Aquarium Orbit are versatile, durable, and ideal for organizing and storing aquarium accessories, fish food, water treatments, and other pet-related items. Made from high-quality, BPA-free plastic, these containers are built to withstand daily use while ensuring safe storage for your aquarium essentials.',1,'2024-11-14 10:51:37.979844','2024-11-14 10:51:37.979844',9),(26,'Stainless Steel Cages','categories/category/61faY3L7QpL._AC_UF10001000_QL80_.jpg','Stainless Steel Cages from MK Aquarium Orbit are designed for durability, safety, and long-lasting use, offering an ideal solution for housing small animals, birds, or pets. Made from high-quality stainless steel, these cages are resistant to rust, corrosion, and wear, making them perfect for both indoor and outdoor environments.',1,'2024-11-14 10:53:19.749157','2024-11-14 10:53:19.749157',9);

--
-- Table structure for table `cleaning_videos`
--

CREATE TABLE `cleaning_videos` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `video` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cleaning_videos`
--

INSERT INTO `cleaning_videos` VALUES (3,'Cleaning Video ','Cleaning Video Cleaning Video Cleaning Video Cleaning Video Cleaning Video Cleaning Video Cleaning Video Cleaning Video ','cleaning_videos/cleaning_videos_ElkEaQA.mp4',1,'2024-11-15 12:46:56.174065'),(4,'video1','video1','cleaning_videos/video_preview1.mp4',1,'2024-11-15 13:19:28.199029'),(5,'video2','video2','cleaning_videos/video_preview2.mp4',1,'2024-11-15 13:19:45.495723'),(6,'video3','video3','cleaning_videos/Aquarium3.mp4',1,'2024-11-15 13:20:05.047167');

--
-- Table structure for table `contact_page`
--

CREATE TABLE `contact_page` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `intro_text` longtext,
  `email` varchar(254) DEFAULT NULL,
  `phone_number` varchar(15) DEFAULT NULL,
  `whatsapp_number` varchar(15) DEFAULT NULL,
  `address` longtext,
  `map_link` varchar(200) DEFAULT NULL,
  `img` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contact_page`
--

INSERT INTO `contact_page` VALUES (1,'Lets Connect for my informations','Fill the details to connect ','info@mkaquariumgmail.com','078693 66734','78693 66734','Pipliyahana Square, Pipliyahana, Indore, Madhya Pradesh 452016','https://maps.app.goo.gl/ddu3moM81YG1RRTv5','contact_images/2024-02-24_1.jpg');

--
-- Table structure for table `contact_submission`
--

CREATE TABLE `contact_submission` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(254) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `subject` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `submitted_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contact_submission`
--


--
-- Table structure for table `coupon_codes`
--

CREATE TABLE `coupon_codes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `discount_type` varchar(15) NOT NULL,
  `discount_value` decimal(10,2) NOT NULL,
  `min_order_amount` decimal(10,2) DEFAULT NULL,
  `max_discount_amount` decimal(10,2) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `usage_limit` int unsigned NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `coupon_codes`
--

INSERT INTO `coupon_codes` VALUES (1,'CODE25','fixed',20.00,200.00,1000.00,'2024-11-15','2024-11-16',1,1,'active','2024-11-15 10:45:43.585608','2024-11-15 10:45:43.585608');

--
-- Table structure for table `customer_address_book`
--

CREATE TABLE `customer_address_book` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `address_type` varchar(10) NOT NULL,
  `address_line_1` varchar(255) NOT NULL,
  `address_line_2` varchar(255) DEFAULT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `postal_code` varchar(20) DEFAULT NULL,
  `country` varchar(100) NOT NULL,
  `is_default` tinyint(1) NOT NULL,
  `customer_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_address_book_customer_id_address_type_f7a887bb_uniq` (`customer_id`,`address_type`,`is_default`),
  KEY `customer_address_book_customer_id_062e3114` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_address_book`
--

INSERT INTO `customer_address_book` VALUES (1,'Umesh Prajapati','9933324010','delivery','707/10, Nanda Nagar','','Indore','Madhya Pradesh','450054','India',1,2),(2,NULL,NULL,'delivery','707/10, Nanda Nagar','','Indore','Madhya Pradesh','450054','India',1,1);

--
-- Table structure for table `customer_cart`
--

CREATE TABLE `customer_cart` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `customer_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_cart_customer_id_4fc97bc0` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_cart`
--

INSERT INTO `customer_cart` VALUES (1,'2024-11-14 08:01:28.940506','2024-11-14 12:03:52.314124',1),(2,'2024-11-15 10:19:36.317476','2024-11-15 10:47:43.978123',2);

--
-- Table structure for table `customer_cart_items`
--

CREATE TABLE `customer_cart_items` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `size` varchar(50) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `quantity` int unsigned NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `added_at` datetime(6) NOT NULL,
  `cart_id` bigint NOT NULL,
  `product_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_cart_items_cart_id_product_id_size_color_33e2500a_uniq` (`cart_id`,`product_id`,`size`,`color`),
  KEY `customer_cart_items_cart_id_cd3adc31` (`cart_id`),
  KEY `customer_cart_items_product_id_5563efaf` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_cart_items`
--

INSERT INTO `customer_cart_items` VALUES (1,NULL,NULL,1,100.00,'2024-11-14 08:01:28.945488',1,1),(2,NULL,NULL,1,650.00,'2024-11-14 12:07:27.521231',1,5);

--
-- Table structure for table `customer_order_history`
--

CREATE TABLE `customer_order_history` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_number` varchar(100) NOT NULL,
  `order_date` datetime(6) NOT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `status` varchar(10) NOT NULL,
  `address_id` bigint DEFAULT NULL,
  `customer_id` bigint NOT NULL,
  `applied_coupon_id` bigint DEFAULT NULL,
  `coupon_discount` decimal(10,2) DEFAULT NULL,
  `delivery_fee` decimal(10,2) DEFAULT NULL,
  `estimated_total` decimal(10,2) DEFAULT NULL,
  `total_savings` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_order_history_order_number_7fade970_uniq` (`order_number`),
  KEY `customer_order_history_address_id_be30f8d9` (`address_id`),
  KEY `customer_order_history_customer_id_65d76195` (`customer_id`),
  KEY `customer_order_history_applied_coupon_id_cb512658` (`applied_coupon_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_order_history`
--

INSERT INTO `customer_order_history` VALUES (1,'ORDER40918019','2024-11-15 10:29:45.622294',600.00,'progress',1,2,NULL,0.00,0.00,600.00,0.00),(2,'ORDER86277875','2024-11-15 10:48:08.702451',340.00,'progress',1,2,1,20.00,0.00,340.00,0.00);

--
-- Table structure for table `customer_wishlist`
--

CREATE TABLE `customer_wishlist` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `added_date` datetime(6) NOT NULL,
  `customer_id` bigint NOT NULL,
  `product_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_wishlist_customer_id_35142b92` (`customer_id`),
  KEY `customer_wishlist_product_id_fd71d12a` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_wishlist`
--


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

CREATE TABLE `customers` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `profile_image` varchar(100) DEFAULT NULL,
  `phone_number` varchar(15) DEFAULT NULL,
  `status` int NOT NULL,
  `create_at` datetime(6) NOT NULL,
  `update_at` datetime(6) NOT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `customers` VALUES (1,'','9755236026',1,'2024-11-14 06:07:14.487606','2024-11-14 06:07:14.487606',1),(2,'','9993324010',1,'2024-11-15 09:52:26.662776','2024-11-15 10:28:25.497499',3);

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_admin_log`
--


--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'auth','permission'),(2,'auth','group'),(3,'contenttypes','contenttype'),(4,'accounts','user'),(5,'accounts','addressbook'),(6,'accounts','customer'),(7,'accounts','orderhistory'),(8,'accounts','wishlist'),(9,'accounts','orderitem'),(10,'accounts','cart'),(11,'accounts','admins'),(12,'accounts','productreview'),(13,'accounts','cartitem'),(14,'myadmin','bannerslider'),(15,'myadmin','category'),(16,'myadmin','contactpage'),(17,'myadmin','contactsubmission'),(18,'myadmin','coupon'),(19,'myadmin','faq'),(20,'myadmin','herosection'),(21,'myadmin','notification'),(22,'myadmin','parentcategory'),(23,'myadmin','principle'),(24,'myadmin','product'),(25,'myadmin','statssection'),(26,'myadmin','productvideo'),(27,'myadmin','productimage'),(28,'admin','logentry'),(29,'sessions','session'),(30,'myadmin','cleaningvideos');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'myadmin','0001_initial','2024-11-13 12:03:57.916812'),(2,'contenttypes','0001_initial','2024-11-13 12:03:57.979297'),(3,'contenttypes','0002_remove_content_type_name','2024-11-13 12:03:58.057405'),(4,'auth','0001_initial','2024-11-13 12:03:58.354212'),(5,'auth','0002_alter_permission_name_max_length','2024-11-13 12:03:58.401075'),(6,'auth','0003_alter_user_email_max_length','2024-11-13 12:03:58.416696'),(7,'auth','0004_alter_user_username_opts','2024-11-13 12:03:58.416696'),(8,'auth','0005_alter_user_last_login_null','2024-11-13 12:03:58.432317'),(9,'auth','0006_require_contenttypes_0002','2024-11-13 12:03:58.432317'),(10,'auth','0007_alter_validators_add_error_messages','2024-11-13 12:03:58.447938'),(11,'auth','0008_alter_user_username_max_length','2024-11-13 12:03:58.463566'),(12,'auth','0009_alter_user_last_name_max_length','2024-11-13 12:03:58.479182'),(13,'auth','0010_alter_group_name_max_length','2024-11-13 12:03:58.510421'),(14,'auth','0011_update_proxy_permissions','2024-11-13 12:03:58.541703'),(15,'auth','0012_alter_user_first_name_max_length','2024-11-13 12:03:58.541703'),(16,'accounts','0001_initial','2024-11-13 12:04:00.291260'),(17,'admin','0001_initial','2024-11-13 12:04:28.582348'),(18,'admin','0002_logentry_remove_auto_add','2024-11-13 12:04:28.597970'),(19,'admin','0003_logentry_add_action_flag_choices','2024-11-13 12:04:28.613593'),(20,'sessions','0001_initial','2024-11-13 12:04:28.676080'),(21,'myadmin','0002_alter_coupon_discount_type','2024-11-15 10:10:14.088395'),(22,'accounts','0002_orderhistory_applied_coupon_and_more','2024-11-15 10:10:14.814055'),(23,'myadmin','0003_cleaningvideos','2024-11-15 12:07:52.666568');

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `answer` longtext NOT NULL,
  `faqs_type` varchar(20) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `faqs`
--


--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `notification_title` varchar(255) NOT NULL,
  `notification_description` longtext NOT NULL,
  `target_audience` varchar(50) NOT NULL,
  `notification_type` varchar(50) NOT NULL,
  `start_date` datetime(6) NOT NULL,
  `end_date` datetime(6) DEFAULT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `notifications`
--


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

CREATE TABLE `order_items` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `quantity` int unsigned NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `order_id` bigint NOT NULL,
  `product_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_412ad78b` (`order_id`),
  KEY `order_items_product_id_dd557d5a` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `order_items` VALUES (1,1,600.00,1,6),(2,2,180.00,2,8);

--
-- Table structure for table `parent_categories`
--

CREATE TABLE `parent_categories` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(100) NOT NULL,
  `description` longtext NOT NULL,
  `status` int NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `parent_categories`
--

INSERT INTO `parent_categories` VALUES (1,'Aquarium Essentials','categories/parent_category/aqua-scape-1024x585.png','This category includes everything you need to set up and maintain a vibrant aquarium, from durable fish tanks to efficient filters, pumps, and heaters. Keep your aquarium clean, beautiful, and functional with our quality accessories and decorations. Perfect for both beginner and seasoned aquarists.',1,'2024-11-14 07:28:38.012013','2024-11-14 07:28:38.012013'),(3,'Fish & Aquatic Care','categories/parent_category/how-to-care-for-fish-a-complete-guide-7.png','Feed and care for your fish with our range of fish food, automatic feeders, and nutrient-rich options for a healthy diet. Find beautifully crafted fish bowls and bowls with unique designs that bring an extra touch to your aquarium setup. Ideal for a thriving, well-nourished aquatic environment.',1,'2024-11-14 10:11:48.187439','2024-11-14 10:11:48.187439'),(4,'Decorative Supplies','categories/parent_category/How-to-Make-Aquarium-Novelty-Items.jpg','Elevate your aquarium or pet space with a variety of colorful pebbles, polished stones, and garden accents. These decor items are perfect for adding texture, color, and style to your aquarium, creating an eye-catching visual appeal. Ideal for a beautiful underwater landscape.',1,'2024-11-14 10:13:51.758372','2024-11-14 10:13:51.758372'),(5,'Bird Supplies','categories/parent_category/bird-feeder-1729341824883.png','Explore our wide selection of bird cages, nest boxes, food options, and decorative housing for your feathered friends. From sturdy cages to cozy birdhouses, our products provide comfort and security. Tailored for bird lovers who prioritize safety and style.',1,'2024-11-14 10:14:34.548220','2024-11-14 10:14:34.549219'),(6,'Cat Supplies','categories/parent_category/supplies-to-get-before-you-adopt-a-cat-105027327-2000-816931e_rSesgoT.jpg','Keep your cat happy and healthy with premium cat food, reliable cat litter, and cozy cat cages. Our supplies ensure your pet’s well-being while making your life easier with convenient, high-quality items. Perfect for cat owners looking for trusted essentials.',1,'2024-11-14 10:16:08.954204','2024-11-14 10:16:08.954204'),(7,'Other Pet Supplies','categories/parent_category/pet-supplies-2-1024x681.jpeg','From animal cages to poultry cages and food options, this category offers supplies for a range of pets. Our versatile products suit various needs, giving your pets safe and comfortable spaces. Ideal for multi-pet households seeking comprehensive pet care.',1,'2024-11-14 10:17:35.651668','2024-11-14 10:17:35.651668'),(8,'Lighting & Electrical','categories/parent_category/668923f3dfc7d065942b174a-walbest-submersible-led-aquarium-light.jpg','Illuminate and enhance with energy-efficient halogen and UV lamps, adding brightness and warmth to your pet spaces. These lights support plant growth in aquariums and provide extra visibility for pet areas. Great for aquariums and pet owners looking to enhance their setups.',1,'2024-11-14 10:18:25.402844','2024-11-14 10:18:25.402844'),(9,'Tools & Accessories','categories/parent_category/81YWwGp36vL.jpg','This category includes practical tools like plastic containers, body fillers, crack fillers, and stainless steel cages. Designed for both maintenance and repair, these accessories help you manage your pet spaces and keep them well-maintained. Perfect for DIY pet care and aquarium upkeep.',1,'2024-11-14 10:19:52.058986','2024-11-14 10:19:52.058986');

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

CREATE TABLE `product_images` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `image` varchar(100) NOT NULL,
  `product_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `product_images_product_id_28ebf5f0` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `product_images` VALUES (3,'products/images/download_2.jpeg',1),(4,'products/images/download_1.jpeg',1),(5,'products/images/download_Gqdj6nB.jpeg',1),(6,'products/images/51Q3erf3RYL._SX522_.jpg',2),(7,'products/images/51J0IusemL._SX522_.jpg',2),(8,'products/images/41p7Jy2QiTL.jpg',2),(10,'products/images/610jhSYRInL._SX522_.jpg',3),(11,'products/images/51gsFSmlBGL._SX522_.jpg',3),(12,'products/images/51OefofA5KL._SX522__DcOGZCh.jpg',3),(13,'products/images/61YqrCpRFAL._SL1200_.jpg',4),(14,'products/images/51npHn5I3eL._SL1200_.jpg',4),(15,'products/images/61Vg-1-WbL._SX522_.jpg',4),(16,'products/images/61bGcw5AfqL._SX522_.jpg',4),(21,'products/images/aaa_GRAe1Bc.jpg',5),(20,'products/images/bb_V1EZCOH.jpg',5),(23,'products/images/0-125-fish-toyabite125g-toya-ori.jpg',6),(24,'products/images/61xMs8b3XBL_mRCzivN.jpg',6),(29,'products/images/71wtENSGVzL._SX522_.jpg',8),(28,'products/images/71GlY101JnL._SX522__ZyG9TZt.jpg',7),(30,'products/images/616yEfZIqhL._SX522_.jpg',8),(31,'products/images/71V1fZswHL._SX522_.jpg',8),(32,'products/images/51AcfwsPi9L.jpg',9),(33,'products/images/5122WRyfKAL.jpg',9),(34,'products/images/61mF1mwnG6L._SX522_.jpg',10),(35,'products/images/61lUSWamwkL._SX522_.jpg',10),(36,'products/images/61OSZtymaL._SX522_.jpg',10),(37,'products/images/61waTMui88L._SX522_.jpg',10),(38,'products/images/61fyIsPnYiL._SX522_.jpg',11),(39,'products/images/614EI4BpnWL._SX522_.jpg',11),(40,'products/images/61vN6qyUVL._SX522_.jpg',11),(41,'products/images/61chrQBGeVL._SX522_.jpg',12),(42,'products/images/81kLGmEUNfL._SX522_.jpg',12),(43,'products/images/81N-ze2JLGL._SX522_.jpg',12),(44,'products/images/51WtjSWaPxL._SX522_.jpg',13),(45,'products/images/51EKsCQ0PbL._SX522_.jpg',13),(46,'products/images/51s9s1tfkAL._SX522_.jpg',13);

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

CREATE TABLE `product_reviews` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `rating` int NOT NULL,
  `review_description` longtext,
  `created_at` datetime(6) NOT NULL,
  `customer_id` bigint NOT NULL,
  `order_id` bigint DEFAULT NULL,
  `product_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_reviews_customer_id_product_id_order_id_e34f5b83_uniq` (`customer_id`,`product_id`,`order_id`),
  KEY `product_reviews_customer_id_3965ece8` (`customer_id`),
  KEY `product_reviews_order_id_e9252ac1` (`order_id`),
  KEY `product_reviews_product_id_9059f243` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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


--
-- Table structure for table `product_videos`
--

CREATE TABLE `product_videos` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `video` varchar(100) DEFAULT NULL,
  `product_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `product_videos_product_id_2cb4a827` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `product_videos`
--


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

CREATE TABLE `products` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` longtext,
  `about` longtext,
  `price` decimal(10,2) NOT NULL,
  `stock` int unsigned NOT NULL,
  `quantity` int unsigned NOT NULL,
  `sku` varchar(100) NOT NULL,
  `status` int NOT NULL,
  `feature` int NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `category_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sku` (`sku`),
  KEY `products_category_id_a7a3a156` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `products` VALUES (1,'8 Inch Glass Fish Bowl','This tank is ideal for both beginners and experienced aquarists. Its sleek design fits seamlessly into any home or office, while its spacious interior allows fish to swim freely. The tank is made from high-quality glass, offering durability and clarity for an unobstructed view of your aquatic life.','Our high-quality Fish Tank provides the perfect environment for your aquatic life. Designed with durability and clarity in mind, this tank offers a crystal-clear view of your aquatic world while maintaining a robust structure to ensure the safety of your fish.',100.00,10,1,'SKU72264461',1,4,'2024-11-14 07:41:40.190728','2024-11-14 09:02:11.931652',1),(2,' Sobo FK 1502 Aquarium Filter','It\'s sponge absorbs dirt and clears the water. This is Suitable for both fresh and salt water. It is Fully submersible and for any aquarium filtration. This is Super quite, efficient energy economizing and easy to clean. This is an ideal filter for tanks up to 200 to 300 L aquariums. The Filter Sponge Absorbs Dirt and Clears The Water. Super Quite, Efficient Energy Economizing, Easy To Clean. Completely Submersible and suitable for Fresh Water and Sea Water.\r\n\r\nFully submersible and ideal for any aquarium filtration\r\nIdeal Filter For Upto 200-300 Liter Tank\r\nSuper Quite, Efficient Energy Economizing, Easy To Clean. Completely Submersible And Ideal For Fresh Water And Sea Water.\r\nThe Filter Sponge Absorbs Dirt And Clears The Water.\r\nThe filter sponge absorbs dirt and clears the water. Super Quite, Efficient Energy Economizing, Easy to Clean','This is the real SOBO PRODUCT, aware local product. I know you love your Fish Turtle and Aquarium. Then why you use local product. Use only SOBO product. The SOBO Aquarium Filter is Best of Filtration. Filtration is the heart of an aquarium. Fish needs to be crystal clear water to stay in an aquarium healthy. Filtration can be biological, mechanical and chemical. Sobo Internal Filter FK-1502 is a mechanical filter. ',650.00,10,1,'SKU76027756',1,4,'2024-11-14 09:09:53.441879','2024-11-14 09:11:13.207760',2),(3,'Xilong XL F380 Aquarium Internal Filter','The VAYINATO Xilong Double Colour Aquarium Internal Filter (Xl-F380) offers a 40W power and an impressive 2500L/H flow rate, making it suitable for aquariums up to 4 feet in size. It provides mechanical and biological filtration, ensuring clean, clear water. The filter features a double colour design, adding a stylish touch to your tank, and operates quietly for a peaceful environment. Ideal for both freshwater and marine tanks, it is energy-efficient, durable, and easy to install.','This internal filter delivers optimal water circulation and filtration, keeping your aquarium healthy for fish and plants. With its efficient multi-stage filtration, it removes debris and supports beneficial bacteria growth. ',850.00,20,1,'SKU27726233',1,4,'2024-11-14 09:23:11.924203','2024-11-14 09:24:27.258913',2),(4,'Xilong XL-F180 Aquarium Internal Filter ','The Xilong XL-F180 Aquarium Internal Filter is designed for efficient filtration with a power rating of 15W and a flow rate of 1200L/H, making it suitable for smaller aquariums up to 2 feet in size. It provides mechanical and biological filtration, ensuring clean water for your tank. The filter is compact, easy to install, and operates quietly, offering a hassle-free experience. Ideal for freshwater and marine aquariums, it’s energy-efficient and built for long-lasting durability.','The Xilong XL-F180 filter is perfect for maintaining a healthy aquarium environment in smaller tanks. With its efficient filtration system, it keeps the water clear by removing debris and promoting beneficial bacteria growth.',400.00,20,1,'SKU34112031',1,4,'2024-11-14 09:33:12.016399','2024-11-14 09:33:12.016399',2),(5,'Xilong XL F280 Aquarium Internal Filter','The Xilong XL-F280 Aquarium Internal Filter offers a power rating of 25W and a flow rate of 2000L/H, making it ideal for aquariums up to 3 feet in size. It provides mechanical and biological filtration, helping maintain clean and healthy water. The filter operates quietly and is energy-efficient, ensuring low power consumption while delivering high performance. Compact and easy to install, it is suitable for both freshwater and marine tanks.','The Xilong XL-F280 is designed to provide effective filtration in medium-sized aquariums, keeping the water clean and clear. It combines mechanical filtration to remove debris and biological filtration to support healthy bacteria growth.',650.00,20,1,'SKU23153950',1,4,'2024-11-14 09:47:47.986878','2024-11-14 09:50:12.978809',2),(6,'Toya Bits Aquatic Food','Here are some common types:\r\n\r\nFlake Food: This is the most common type of fish food. It’s suitable for many species and is easy to store and use.\r\n\r\nPellets: Pellets are often used for larger fish or species with specific dietary requirements. They can come in different sizes and formulations.\r\n\r\nGranules: These are similar to pellets but generally smaller. They’re good for smaller fish or fish that prefer smaller bites.\r\n\r\nFrozen Food: Options like bloodworms, brine shrimp, and daphnia can be good for adding variety and nutrition to your fish’s diet.\r\n\r\nLive Food: This includes live worms, insects, or even small shrimp. Live food can be great for stimulating natural hunting behaviors but requires careful handling and cleanliness.','Fish food comes in a variety of types and formulations, depending on the species of fish and their dietary needs.',600.00,19,1,'SKU84797872',1,3,'2024-11-14 11:08:35.316695','2024-11-15 10:29:45.652603',13),(7,' PCG 3 In 1 Optimum Fish Food ','Probiotic supplements that help in the digestion of food and absorption of nutrients. Beta - glucans supplements that increase disease resistance and improves growth and performance in fish. Non - water fouling flavor (s) and size (s) spirulina 12 percent: Small pellet: 907. 2 G. (2 Lb), 453. 6 G. (1 Lb), medium pellet: 907. 2 G. (2 Lb) spirulina 6 percent: Mini pellet: 100 g, small pellet: 907. 2 G. (2 Lb), 453. 6 G. (1 Lb), medium pellet: 907. 2 G. (2 Lb).','Promote growth, enhance color and increase immunity formular spirulina 6 percent: Suitable for all carp fish to enhance the coloration of fish spirulina 12 percent: Suitable for all carp fish to rapid enhance the coloration of fish is a special formulation for carp, gold fish and cichlid. It is nutritionally complete and balanced. ',850.00,20,1,'SKU37698976',1,3,'2024-11-14 11:16:23.059523','2024-11-14 11:17:07.624506',13),(8,'Foodie Puppies Decorative Glossy','Pebbles are the perfect accents for candles, vases, bowls, craft projects, floral arrangements, fountains, and more Ideal for decorating your lawn also. If You Would Like To Indulge Your Artistic Side, Stone Pebbles Make The Perfect Raw Materials For Designing Your Own Ideas. It Will Be Perfect For Ponds, Paving, Candles, gardens, Vases, Bowls, Craft Projects, Floral Arrangements, Surface paths, Fountains, Flower pots, Fish tanks, Etc. So If You\'re Looking For Decorative Pebbles, Place Your Order. Please Wash In Water Before Use. These Pebbles are premium natural stone pebbles They are a distinction of their own because of their natural structure These Pebbles are very durable because they are made of stone They add a lot of taste and style to your home. They are made of natural stone and look beautiful in both dry and wet forms.','Gravels are one of the most important parts of the aquarium because they keep water fresh and healthy long and long time by absorbing all the way they work as a good biological filter because most of the healthy bacteria grow between them. They work as a great part of decoration and provide a very healthy environment for plants and fish',180.00,18,1,'SKU15507579',1,3,'2024-11-14 11:25:39.800900','2024-11-15 10:48:08.724852',15),(9,'Yellow Bird Cage','Bird Cage is a suitable cage for budgies, canaries, lovebirds and finches. It provides your bird with lots of room to move around and Vision makes it easy for you to take care of your bird.\r\nBird movements cause air currents, which flow outwards, and in the case of most standard bird cages these air currents eject waste and seed debris outside of the cage and onto the floor.','Cage detaches from base for fast, easy cleaning. Slide-out removable bottom tray.Included- One perch. Two food/ water bowls, One plastic swing/ring.Small wire bird cage for budgies, canaries, lovebirds and finches',450.00,20,1,'SKU30954102',1,3,'2024-11-14 11:28:54.823838','2024-11-14 11:28:54.823838',17),(10,'Meo Cat Food','There is vitamin C which improves the health of immune system and reduces environmental stress. The wholesome food aims to look after the overall well-being of the kitten. Therefore, level of sodium has been reduced to promote the health of heart, kidneys, and maintain a healthy blood pressure. The nutritional formula helps to prevent urinary tract infections and bladder stones, and supports the functioning of eyes. Delicious and digestible dry cat food supplies omega 3 and omega 6 fatty acids along with zinc to nourish skin and fur.\r\n\r\n','O Kitten food (Ocean Fish) is a nutritionally complete and balanced dietary formulation for optimum health and growth of a kitten. The balanced meal includes a high amount of growth inducing protein, sourced from milk and ocean fish. Bones and teeth of the young feline are strengthened with balanced amounts of calcium, phosphorus and vitamin D. ',210.00,20,1,'SKU99472723',1,3,'2024-11-14 11:36:35.082496','2024-11-14 11:36:35.082496',19),(11,'Pedigree Pet Food','Complete and balanced dry dog food in kibble form for adult dogs which can be served as sole meal for your dog. Consumption Pedigree Dry Dog food in Meat & Rice flavour by dogs aids in strong muscles, bones & teeth and healthier & shinier coat for your dog','PEDIGREE complete and balanced dry dog food for adult dogs packed with essential nutrients vital to the healthy growth of your pet. PEDIGREE, with the goodness of cereals, meat, chicken, and the nutrients blend into a tasty and healthy meal for your dog. ',350.00,20,1,'SKU15934797',1,3,'2024-11-14 11:45:39.308629','2024-11-14 11:45:39.308629',21),(12,' Bluepet Aquarium LED Light','Excellent sealed design. The tank light is fully submerged in water and work underwater. Two strong suction cup help fix cable firmly in the tank, fitting for aquarium, fish tank, pool, etc\r\n\r\nSuper Bright And Energy Efficient - Fully Waterproof And Water Submersible Led Light Lamp\r\n\r\nThis aquarium led light is specially designed for fish tank, which can light up your fish tank and bring brightness for fish. Bright light helps you look clear out of the aquarium. Help plants to thrive and light up for fishes anytime you want.','Blue Pet Glass Aquarium Fully Submersible LED Light/Lamp for Fish Tank and Aquarium with 2 Suction cupExcellent sealed design. The tank light is fully submerged in water and work underwater.',1350.00,10,1,'SKU83978168',1,3,'2024-11-14 11:51:27.750231','2024-11-14 11:51:27.750231',24),(13,' PVC Container Box','This unique reptile habitat is constructed from strong acrylic and offers ample viewing space. Made especially for reptiles, small animals and bugs: including crickets, hermit crabs, frogs, lizards and snakes. Comes with an easy-carrying handle and a basking island. dimension 29 X 15 X 20cm.','Foodie Puppies Plastic tank for turtle and small animals, Reptile Carrier with Cover and Handle. Koller Craft is highly regarded for supplying superior quality, innovative pet products and reliable service. ',550.00,20,1,'SKU80896619',1,3,'2024-11-14 11:58:27.910468','2024-11-14 11:58:27.911453',25);


