-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `lovekbkg_ecoline`
--

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

--
-- Table structure for table `blogcategories`
--

CREATE TABLE `blogcategories` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `blogcategories`
--

INSERT INTO `blogcategories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(7, 'Furniture', '2024-11-07 14:57:06', '2024-11-07 14:58:36');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `heading` mediumtext DEFAULT NULL,
  `image` mediumtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `type` enum('active','schedule') NOT NULL DEFAULT 'active',
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `more_description` mediumtext DEFAULT NULL,
  `slug` mediumtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `category`, `heading`, `image`, `description`, `status`, `type`, `date_from`, `date_to`, `more_description`, `slug`, `created_at`, `updated_at`) VALUES
(14, 7, 'Shopping Tips for First Time Furniture Buyers', '258716-17309737411.jpg', '<p>You can avoid feeling overwhelmed when you are furnishing your home for the first time if you are prepared. Sure, there are many choices to make, but with some planning you can narrow done your options and concentrate on furniture that will make you happy and fit your needs as well as your budget.</p>\r\n<p>It is a good idea to shop at a furniture store like Home Living Furniture that offers a range of styles for every room so you can see what is available. You can expect name brand furniture manufacturers to offer well-constructed furniture, and they stand behind their products.</p>\r\n<p>Here are some important tips when you are looking for furniture for the first time.</p>\r\n<p>1.&nbsp;<strong>Know How Much you Want to Spend</strong></p>\r\n<p>First and foremost, know your budget. Before you fall in love with furniture you will want to know how much you are willing to spend. When you tell your salesperson, you can concentrate on the furniture that makes sense for you. Shopping at Home Living Furniture offers the latest styles, name brands and discount prices to help expand your choices.</p>\r\n<p>2.&nbsp;<strong>Measure your Space</strong></p>\r\n<p>It makes no sense to shop for furniture without knowing the size and configuration of furniture that will fit in your space. Measure the room dimensions and think about where you intend to place the furniture. Create a simple floorplan and be sure to include doors and windows so you can visualize how the furniture will be laid out in the room.</p>\r\n<p>3.&nbsp;<strong>Shop for Name Brands</strong></p>\r\n<p>When you furnish your home, it makes sense to shop for furniture that is made to last.&nbsp;<a href=\"https://www.homelivingfurniture.com/m/\">Well-known name brands</a> are likely to use high quality construction and materials that will last. You can ask about craftsmanship, finishes and joint construction.</p>\r\n<p>4.&nbsp;<strong>Think About the Future</strong></p>\r\n<p>Choose durable items that are made to withstand use and look good for years to come. While you may love current styles and colors, it might be a good idea to choose larger furniture pieces in lasting shades and express current styles with accent pieces.</p>\r\n<p>5.&nbsp;<strong>Choose the Basics First</strong></p>\r\n<p>Whether you are shopping for living room, dining room or bedroom furniture, it is best to choose the basic pieces first and then add accessories and accent pieces. In the living room that means you can choose the sofa, sectional, loveseat and coffee table first, and then add occasional pieces like side tables and consoles. In the dining room, choose the table and chairs, then add extras like buffets and china cabinets. In the bedroom, you can go with a bedroom set and then add chests and other storage pieces.</p>\r\n<p>If you are a first time furniture buyer, visit&nbsp;Home Living Furniture in Mays Landing, NJ to get help from experienced salespeople. For further information, visit homelivingfurniture.com.</p>\r\n<p><img style=\"float: left;\" src=\"data:image/jpeg;base64,[BLOB]\"></p>\r\n<p style=\"text-align: left;\"><img style=\"float: right;\" src=\"data:image/jpeg;base64,[BLOB]\">&nbsp; &nbsp; &nbsp;&nbsp;</p>', 'active', 'active', NULL, NULL, NULL, 'shopping-tips-for-first-time-furniture-buyers', '2024-11-07 15:02:21', '2024-11-07 15:20:56');
INSERT INTO `blogs` (`id`, `category`, `heading`, `image`, `description`, `status`, `type`, `date_from`, `date_to`, `more_description`, `slug`, `created_at`, `updated_at`) VALUES
(15, 7, 'Ashley Bedroom Sets for Every Taste', '313434-17309746742.jpg', '<p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example,</p>\r\n<p>which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?&rdquo;</p>\r\n<blockquote><strong>No one rejects, dislikes, or avoids pleasure itself, because it pleasure, but because those who do not know how to pursue pleasure ratinally encounter consequences that are.But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness.</strong></blockquote>\r\n<p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness.</p>\r\n<p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness.</p>\r\n<p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness.</p>\r\n<p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness.</p>', 'active', 'active', NULL, NULL, NULL, 'ashley-bedroom-sets-for-every-taste', '2024-11-07 15:17:54', '2024-11-07 15:20:42'),
(16, 7, 'Exciting New Decorating Trends You Should Know', '732599-17309750641.jpg', '<p>This year there are exciting decorating trends you can incorporate into your home decor for a fresh new look. It may not take a huge overhaul to keep your decor up to date. In fact, simply adding an attractive piece of furniture can go a long way in giving you the look you want.</p>\r\n<p>Here are some trends to follow to help you keep up with the times.</p>\r\n<p>&nbsp;</p>\r\n<p><strong>Include Graceful Curves</strong></p>\r\n<p>After several years of emphasizing stark straight lines in furniture design, curves are now making an appearance. Interior design is now softening to feature softly rounded arms for sofas and gently curved living room and dining room chairs. Today\'s furniture curves give your decor a welcoming look that can make your home look more inviting.</p>\r\n<p>&nbsp;</p>\r\n<p><strong>Feature Natural Elements</strong></p>\r\n<p><img class=\"img-fluid blur-up lazyloaded\" src=\"https://www.homelivingfurniture.com/data/blogs/465/465-2.jpg\" alt=\"Feature Natural Elements\" data-src=\"https://www.homelivingfurniture.com/data/blogs/465/465-2.jpg\"></p>\r\n<p>You might already know that shades of green are having a moment, along with fabrics with floral and botanical patterns. Natural textures like cotton, linen and woven fabrics are trending right now, along with water-inspired patterns like waves and ripples.</p>\r\n<p>&nbsp;</p>\r\n<p>Another good way to incorporate biophilic touches is to include elements like grasscloth wallpaper and finely crafted wood furniture. Choose darker wood&nbsp;<a href=\"https://www.homelivingfurniture.com/st/cocktail-tables\">coffee tables</a>, accent pieces and consoles to make a strong statement, or you can choose lighter wood for a more contemporary look.</p>\r\n<p>&nbsp;</p>\r\n<p><strong>Use Multifunctional Furniture</strong></p>\r\n<p><img class=\"img-fluid blur-up lazyloaded\" src=\"https://www.homelivingfurniture.com/data/blogs/465/465-3.jpg\" alt=\"Use Multifunctional Furniture\" data-src=\"https://www.homelivingfurniture.com/data/blogs/465/465-3.jpg\"></p>\r\n<p>Multifunctional furniture is a must, especially if you or your family members are working from home. Now you have more choices than ever. When you visit the Home Living Furniture showrooms, look for sofa beds that turn sofas into beds at night and lift-top coffee tables that can hold a laptop computer. Look for expandable dining room tables and cabinets with built-in shelving providing hidden storage solutions.</p>\r\n<p>&nbsp;</p>\r\n<p><strong>Organize your Treasures</strong></p>\r\n<p>Displaying your small decorative items in random places throughout the house can give you an old-fashioned look. Instead, think about adding a beautiful&nbsp;<a href=\"https://www.homelivingfurniture.com/st/china\">display cabinet</a>&nbsp;with shelving and glass doors to show off your prized possessions in an organized way. Stay up to date with todays home decor trends and get rid of unnecessary knickknacks that can make your home look cluttered and choose a few large decorative items as an alternative.</p>\r\n<p>&nbsp;</p>\r\n<p><strong>Name Brands that Keep Up With the Times</strong></p>\r\n<p>When you visit the Home Living Furniture stores you will find name brand furniture manufacturers with designs that keep up with decoration trends. Ask about customization options like sofa and sectional designs as well as performance fabrics that keep your upholstered furniture looking fresh and new.</p>\r\n<p>&nbsp;</p>\r\n<p>For more information about the latest furniture styles and decorating trends, visit homelivingfurniture.com.</p>', 'active', 'active', NULL, NULL, NULL, 'exciting-new-decorating-trends-you-should-know', '2024-11-07 15:24:24', '2024-11-07 15:24:24');

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

--
-- Table structure for table `blogs_tags`
--

CREATE TABLE `blogs_tags` (
  `id` int(11) NOT NULL,
  `blogid` int(11) NOT NULL,
  `tag` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `blogs_tags`
--

INSERT INTO `blogs_tags` (`id`, `blogid`, `tag`, `created_at`, `updated_at`) VALUES
(323, 15, 'Lamp', '2024-11-07 15:20:42', '2024-11-07 15:20:42'),
(324, 15, 'Furniture', '2024-11-07 15:20:42', '2024-11-07 15:20:42'),
(325, 14, 'Lamp', '2024-11-07 15:20:56', '2024-11-07 15:20:56'),
(326, 14, 'Furniture', '2024-11-07 15:20:56', '2024-11-07 15:20:56'),
(327, 14, 'Chair', '2024-11-07 15:20:56', '2024-11-07 15:20:56'),
(328, 16, 'Lamp', '2024-11-07 15:24:24', '2024-11-07 15:24:24'),
(329, 16, 'Furniture', '2024-11-07 15:24:24', '2024-11-07 15:24:24');

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

--
-- Table structure for table `blog_images`
--

CREATE TABLE `blog_images` (
  `id` int(11) NOT NULL,
  `blogid` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `color` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `cart` (`id`, `userid`, `productid`, `quantity`, `color`, `created_at`, `updated_at`) VALUES
(46, 98, 15, 1, NULL, '2024-11-19 14:16:31', '2024-11-19 14:16:31');

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id`, `name`, `image`, `created_at`, `updated_at`) VALUES
(8, 'Furniture', NULL, '2024-11-07 14:41:19', '2024-11-07 14:41:19'),
(9, 'Lighting', NULL, '2024-11-07 14:41:25', '2024-11-14 14:27:11'),
(11, 'Accessories', NULL, '2024-11-12 13:39:26', '2024-11-14 14:27:19');

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

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `subject` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `orderid` text DEFAULT NULL,
  `fname` text DEFAULT NULL,
  `lname` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `zipcode` text DEFAULT NULL,
  `price` text DEFAULT NULL,
  `status` text NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `order_details` (
  `id` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `product_name` text DEFAULT NULL,
  `product_price` text DEFAULT NULL,
  `quantity` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `categoryid` int(11) NOT NULL,
  `cut_price` float DEFAULT NULL,
  `price` float DEFAULT NULL,
  `discount` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `shortdetail` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `stock` enum('in stock','out of stock') NOT NULL DEFAULT 'in stock',
  `slug` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` (`id`, `name`, `categoryid`, `cut_price`, `price`, `discount`, `image`, `shortdetail`, `description`, `tags`, `stock`, `slug`, `created_at`, `updated_at`) VALUES
(13, 'Chair collection', 9, NULL, 120, NULL, '17310472551.jpg', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan', '<h4 class=\"ht__pro__title\">Description</h4>\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in iis qui facit eorum claritatem</p>\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\n<h4 class=\"ht__pro__title\">Standard Featured</h4>\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in</p>', 'Fashion, Accessories, Women, Men', 'out of stock', 'chair-collection', '2024-11-08 11:27:35', '2024-11-12 08:54:13'),
(14, 'Glass Table', 8, 400, 360, '10', '173104820011.jpg', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan', '<h4 class=\"ht__pro__title\">Description</h4>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in iis qui facit eorum claritatem</p>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n<h4 class=\"ht__pro__title\">Standard Featured</h4>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in</p>', 'Fashion, Accessories, Women, Men', 'in stock', 'glass-table', '2024-11-08 11:32:51', '2024-11-08 11:50:39'),
(15, 'Sofa Collection', 8, NULL, 255, NULL, '17310478484.jpg', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsanLorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan', '<h4 class=\"ht__pro__title\">Description</h4>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in iis qui facit eorum claritatem</p>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n<h4 class=\"ht__pro__title\">Standard Featured</h4>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in</p>', 'Fashion, Accessories, Women, Men', 'in stock', 'sofa-collection', '2024-11-08 11:37:28', '2024-11-08 11:50:06'),
(16, 'Table Collection', 8, 300, 240, '20', '17310480586.jpg', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan', '<h4 class=\"ht__pro__title\">Description</h4>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in iis qui facit eorum claritatem</p>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>\r\n<h4 class=\"ht__pro__title\">Standard Featured</h4>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in</p>', 'Fashion, Accessories, Women, Men', 'in stock', 'table-collection', '2024-11-08 11:40:58', '2024-11-08 11:48:20'),
(19, 'Vogue Holder', 11, 220, 180, '20', '1731580216photo_2024-11-14_10-14-23.jpg', 'Introducing our stunning modern magazine holder, a perfect blend of beauty, elegance, and functionality. Crafted from high-quality plexiglass, this magazine holder is designed to elevate your living space while keeping your reading materials organized and easily accessible. Its sleek, minimalist design complements a wide range of interior aesthetics, making it a versatile addition to any home or office.\r\n\r\nThe magazine holder features a clean, geometric shape, characterized by smooth lines and a transparent finish that allows it to seamlessly integrate into any environment. The transparent nature of the plexiglass gives the illusion of space, making it an ideal choice for smaller rooms or areas where you want to maintain an airy feel. Its lightweight construction ensures that it is easy to move around, allowing you to rearrange your space as needed without hassle.', '<p>Available in three stunning color variations&mdash;crystal clear, smoky gray, and vibrant blue&mdash;this magazine holder caters to diverse tastes and styles. The crystal clear option exudes a timeless elegance, allowing the contents to be the focal point while maintaining a sophisticated look. The smoky gray variation offers a contemporary twist, adding a hint of drama and sophistication without overwhelming your d&eacute;cor. For those who want to make a bold statement, the vibrant blue option brings a splash of color that can brighten up any room and serve as a striking accent piece.</p>\r\n<p>Not only is this magazine holder visually appealing, but it is also designed with practicality in mind. The ample space can accommodate a variety of magazines, catalogs, and even books, keeping your favorite reads neatly organized. The open-top design allows for easy access, so you can quickly grab your favorite publication without any fuss. Additionally, the sturdy base ensures stability, preventing tipping or sliding, which is especially useful in high-traffic areas.</p>\r\n<p>The use of high-quality plexiglass not only enhances the aesthetic appeal but also ensures durability. Unlike traditional wooden or metal holders, plexiglass is resistant to wear and tear, making it less prone to damage from spills or scratches. This means your magazine holder will maintain its pristine appearance for years to come, making it a worthwhile investment for your home.</p>\r\n<p>In terms of maintenance, the magazine holder is incredibly easy to clean. A simple wipe-down with a soft cloth and mild soap is all it takes to keep it looking brand new. This low-maintenance feature makes it a practical choice for busy households or office environments.</p>\r\n<p>Whether placed in a cozy reading nook, a stylish living room, or a modern office space, this magazine holder adds a touch of sophistication and order. It is not just a storage solution; it is a statement piece that reflects your taste and enhances your interior design.</p>\r\n<p>In summary, our elegant modern magazine holder is an exceptional accessory for those who appreciate beauty and functionality. With its stunning design, durable materials, and variety of color options, it is sure to become a cherished element in your home or office. Embrace the perfect blend of style and practicality with this exquisite magazine holder, and transform your space into an organized and aesthetically pleasing haven.</p>', 'Magazine holder, Vogue holder, Accessories, Furniture', 'in stock', 'vogue-holder', '2024-11-14 14:19:03', '2024-11-14 15:30:16');

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

--
-- Table structure for table `product_colors`
--

CREATE TABLE `product_colors` (
  `id` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `color` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product_colors`
--

INSERT INTO `product_colors` (`id`, `productid`, `color`, `created_at`, `updated_at`) VALUES
(14, 16, '#ff0000', '2024-11-12 12:30:31', '2024-11-12 12:30:31'),
(13, 17, '#23ba21', '2024-11-12 12:30:08', '2024-11-12 12:30:08'),
(12, 17, '#ff0000', '2024-11-12 12:30:08', '2024-11-12 12:30:08'),
(11, 17, '#4714ff', '2024-11-12 12:30:08', '2024-11-12 12:30:08'),
(15, 16, '#1e00ff', '2024-11-12 12:30:31', '2024-11-12 12:30:31'),
(16, 16, '#02ac43', '2024-11-12 12:30:31', '2024-11-12 12:30:31'),
(22, 18, '#00ffcc', '2024-11-12 14:10:44', '2024-11-12 14:10:44'),
(21, 18, '#0e00cc', '2024-11-12 14:10:44', '2024-11-12 14:10:44'),
(20, 18, '#fa0000', '2024-11-12 14:10:44', '2024-11-12 14:10:44'),
(23, 18, '#f500c0', '2024-11-12 14:10:44', '2024-11-12 14:10:44');

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

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

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `product_images` (`id`, `productid`, `image`, `created_at`, `updated_at`) VALUES
(39, 13, '17310472552.jpg', '2024-11-08 11:27:35', '2024-11-08 11:27:35'),
(40, 13, '17310472557.jpg', '2024-11-08 11:27:35', '2024-11-08 11:27:35'),
(41, 14, '173104757111.jpg', '2024-11-08 11:32:51', '2024-11-08 11:32:51'),
(42, 15, '17310478488.jpg', '2024-11-08 11:37:28', '2024-11-08 11:37:28'),
(43, 15, '17310478489.jpg', '2024-11-08 11:37:28', '2024-11-08 11:37:28'),
(44, 15, '173104784810.jpg', '2024-11-08 11:37:28', '2024-11-08 11:37:28'),
(45, 16, '17310480585.jpg', '2024-11-08 11:40:58', '2024-11-08 11:40:58'),
(46, 16, '173104805811.jpg', '2024-11-08 11:40:58', '2024-11-08 11:40:58'),
(54, 19, '1731580250photo_2024-11-14_10-14-28.jpg', '2024-11-14 15:30:50', '2024-11-14 15:30:50'),
(55, 19, '1731580258photo_2024-11-14_10-14-26.jpg', '2024-11-14 15:30:58', '2024-11-14 15:30:58'),
(56, 19, '1731580265photo_2024-11-14_10-14-30.jpg', '2024-11-14 15:31:05', '2024-11-14 15:31:05');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category` (`category`);

--
-- Indexes for table `blogs_tags`
--
ALTER TABLE `blogs_tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blogid` (`blogid`);

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `blog_images`
--
ALTER TABLE `blog_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_ibfk_1` FOREIGN KEY (`category`) REFERENCES `blogcategories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `blogs_tags`
--
ALTER TABLE `blogs_tags`
  ADD CONSTRAINT `blogs_tags_ibfk_1` FOREIGN KEY (`blogid`) REFERENCES `blogs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cart`
--
ALTER TABLE `cart`
  ADD CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`productid`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_details`
--
ALTER TABLE `order_details`
  ADD CONSTRAINT `order_details_ibfk_1` FOREIGN KEY (`orderid`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_details_ibfk_2` FOREIGN KEY (`productid`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`categoryid`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

