MAINHACK

Viewing / Editing File: sreealan_db.sql

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 28, 2026 at 09:10 AM
-- Server version: 10.1.45-MariaDB
-- PHP Version: 7.2.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `sreealan_db`
--

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

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

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `email` varchar(128) DEFAULT NULL,
  `password` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `admin` (`id`, `email`, `password`, `name`) VALUES
(1, 'info@sreealankar.in', 'eee25baa2fd5b403fa7b111ab02b8e23', 'Admin');

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

--
-- Table structure for table `bill`
--

CREATE TABLE `bill` (
  `id` int(11) NOT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `product_id` varchar(100) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `size` varchar(200) DEFAULT NULL,
  `price` double NOT NULL,
  `total` double NOT NULL,
  `order_time` datetime NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `delivery_charge` varchar(128) DEFAULT NULL,
  `gst` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bill`
--

INSERT INTO `bill` (`id`, `order_id`, `product_id`, `product_name`, `quantity`, `size`, `price`, `total`, `order_time`, `user_id`, `delivery_charge`, `gst`) VALUES
(133, 'ORD167', 'PROD156', 'Brown Side Bag', 2, NULL, 2500, 5000, '2024-08-31 09:56:59', 'USR152', NULL, NULL),
(134, 'ORD167', 'PROD151', 'Brown Leather Bag', 1, NULL, 1200, 1200, '2024-08-31 09:56:59', 'USR152', NULL, NULL),
(135, 'ORD168', 'PROD156', 'Brown Side Bag', 2, NULL, 2500, 5000, '2024-08-31 09:57:42', 'USR152', NULL, NULL),
(136, 'ORD168', 'PROD151', 'Brown Leather Bag', 1, NULL, 1200, 1200, '2024-08-31 09:57:42', 'USR152', NULL, NULL),
(137, 'ORD169', 'PROD156', 'Brown Side Bag', 1, NULL, 2500, 2500, '2024-09-02 05:51:57', 'USR152', NULL, NULL),
(138, 'ORD170', 'PROD151', 'Brown Leather Bag', 1, NULL, 1200, 1200, '2024-09-02 05:54:15', 'USR152', NULL, NULL),
(139, 'ORD170', 'PROD155', 'Brown Satchel Bag', 1, NULL, 2200, 2200, '2024-09-02 05:54:15', 'USR152', NULL, NULL),
(140, 'ORD171', 'PROD156', 'Brown Side Bag', 1, NULL, 2500, 2500, '2024-09-02 06:27:41', 'USR152', NULL, NULL),
(141, 'ORD172', 'PROD151', 'Brown Leather Bag', 1, NULL, 1200, 1200, '2024-09-02 07:46:37', 'USR152', NULL, NULL),
(142, 'ORD173', 'PROD151', 'Brown Leather Bag', 1, NULL, 1200, 1200, '2024-09-02 08:19:00', 'USR152', NULL, NULL),
(143, 'ORD174', 'PROD156', 'Brown Side Bag', 1, NULL, 2500, 2500, '2024-09-02 09:22:22', 'USR152', NULL, NULL),
(144, 'ORD182', 'PROD178', 'Heavy Necklace', 2, NULL, 110000, 220000, '2024-09-13 08:16:58', 'USR152', NULL, NULL),
(145, 'ORD183', 'PROD180', 'Helena Platinum Ring for Her', 2, NULL, 80000, 160000, '2024-09-13 09:11:08', 'USR152', NULL, NULL),
(146, 'ORD184', 'PROD179', 'Custom Diamond Necklace', 1, NULL, 2500, 2500, '2024-09-13 10:01:24', 'USR152', NULL, NULL),
(147, 'ORD187', 'PROD185', 'P-Pearl', 10, NULL, 1000, 10000, '2024-10-05 09:06:47', 'USR186', NULL, NULL),
(148, 'ORD195', 'PROD192', 'Alloy Party Beautiful korean hanging Earrings', 1, NULL, 60, 60, '2024-10-08 11:20:04', 'USR152', NULL, NULL),
(149, 'ORD196', 'PROD192', 'Alloy Party Beautiful korean hanging Earrings', 1, NULL, 60, 60, '2024-10-08 11:21:16', 'USR152', NULL, NULL),
(150, 'ORD198', 'PROD190', 'Pink and blue hair clip', 1, NULL, 280, 280, '2024-10-16 07:20:40', 'USR152', NULL, NULL),
(151, 'ORD199', 'PROD190', 'Pink and blue hair clip', 1, NULL, 280, 280, '2024-10-16 08:01:52', 'USR152', NULL, NULL),
(152, 'ORD200', 'PROD190', 'Pink and blue hair clip', 1, NULL, 280, 280, '2024-10-16 08:04:38', 'USR152', NULL, NULL),
(153, 'ORD201', 'PROD190', 'Pink and blue hair clip', 1, NULL, 280, 280, '2024-10-16 10:31:33', 'USR152', NULL, NULL),
(154, 'ORD202', 'PROD190', 'Pink and blue hair clip', 1, NULL, 280, 280, '2024-10-16 10:53:39', 'USR152', NULL, NULL),
(155, 'ORD204', 'PROD203', 'demo necklace set', 1, NULL, 1000, 1000, '2024-10-17 07:09:37', 'USR197', NULL, NULL),
(156, 'ORD205', 'PROD193', ' Butterfly Long Stud Drop Earrings For Women', 1, NULL, 150, 150, '2024-10-18 06:50:22', 'ADMIN', NULL, NULL),
(157, 'ORD206', 'PROD203', 'demo necklace set', 8, NULL, 1000, 8000, '2024-10-23 06:39:36', 'USR186', NULL, NULL),
(158, 'ORD207', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-25 08:53:32', 'USR197', NULL, NULL),
(159, 'ORD208', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-25 09:11:32', 'USR197', NULL, NULL),
(160, 'ORD209', 'PROD180', 'Helena Platinum Ring for Her', 1, NULL, 80000, 80000, '2024-10-25 11:00:29', 'USR197', NULL, NULL),
(161, 'ORD210', 'PROD180', 'Helena Platinum Ring for Her', 1, NULL, 80000, 80000, '2024-10-25 11:50:30', 'USR197', NULL, NULL),
(162, 'ORD211', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-25 06:56:13', 'USR197', NULL, NULL),
(163, 'ORD212', 'PROD185', 'P-Pearl', 3, NULL, 1000, 3000, '2024-10-28 07:05:12', 'USR197', NULL, NULL),
(164, 'ORD213', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-28 07:26:55', 'USR197', NULL, NULL),
(165, 'ORD214', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-28 07:28:28', 'USR197', NULL, NULL),
(166, 'ORD215', 'PROD203', 'demo necklace set', 1, NULL, 1000, 1000, '2024-10-28 07:37:45', 'USR197', NULL, NULL),
(167, 'ORD216', 'PROD193', ' Butterfly Long Stud Drop Earrings For Women', 1, NULL, 150, 150, '2024-10-28 09:39:09', 'USR197', NULL, NULL),
(168, 'ORD217', 'PROD193', ' Butterfly Long Stud Drop Earrings For Women', 1, NULL, 150, 150, '2024-10-28 09:47:48', 'USR197', NULL, NULL),
(169, 'ORD218', 'PROD193', ' Butterfly Long Stud Drop Earrings For Women', 1, NULL, 150, 150, '2024-10-28 09:49:45', 'USR197', NULL, NULL),
(170, 'ORD219', 'PROD193', ' Butterfly Long Stud Drop Earrings For Women', 1, NULL, 150, 150, '2024-10-28 09:50:12', 'USR197', NULL, NULL),
(171, 'ORD220', 'PROD193', ' Butterfly Long Stud Drop Earrings For Women', 1, NULL, 150, 150, '2024-10-28 09:58:37', 'USR197', NULL, NULL),
(172, 'ORD221', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-28 12:21:35', 'USR197', NULL, NULL),
(173, 'ORD222', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-28 12:22:37', 'USR197', NULL, NULL),
(174, 'ORD223', 'PROD185', 'P-Pearl', 1, NULL, 1000, 1000, '2024-10-28 12:22:51', 'USR197', NULL, NULL),
(175, 'ORD257', 'PROD236', 'Beautiful bandni Mask', 1, NULL, 99, 99, '2025-03-10 08:17:28', NULL, NULL, NULL),
(176, 'ORD257', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 08:17:28', NULL, NULL, NULL),
(177, 'ORD258', 'PROD236', 'Beautiful bandni Mask', 1, NULL, 99, 99, '2025-03-10 08:17:46', NULL, NULL, NULL),
(178, 'ORD258', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 08:17:46', NULL, NULL, NULL),
(179, 'ORD259', 'PROD236', 'Beautiful bandni Mask', 1, NULL, 99, 99, '2025-03-10 08:23:00', NULL, NULL, NULL),
(180, 'ORD259', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 08:23:00', NULL, NULL, NULL),
(181, 'ORD260', 'PROD236', 'Beautiful bandni Mask', 1, NULL, 99, 99, '2025-03-10 10:53:14', NULL, NULL, NULL),
(182, 'ORD260', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 10:53:14', NULL, NULL, NULL),
(183, 'ORD261', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 11:06:40', NULL, NULL, NULL),
(184, 'ORD261', 'PROD224', 'Tropical Hawaiian Masks', 1, NULL, 99, 99, '2025-03-10 11:06:40', NULL, NULL, NULL),
(185, 'ORD262', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 11:13:05', NULL, NULL, NULL),
(186, 'ORD262', 'PROD224', 'Tropical Hawaiian Masks', 1, NULL, 99, 99, '2025-03-10 11:13:05', NULL, NULL, NULL),
(187, 'ORD263', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-10 11:14:34', NULL, NULL, NULL),
(188, 'ORD263', 'PROD224', 'Tropical Hawaiian Masks', 1, NULL, 99, 99, '2025-03-10 11:14:34', NULL, NULL, NULL),
(189, 'ORD264', 'PROD236', 'Beautiful bandni Mask', 2, NULL, 99, 198, '2025-03-11 06:27:26', NULL, NULL, NULL),
(190, 'ORD265', 'PROD236', 'Beautiful bandni Mask', 1, NULL, 99, 99, '2025-03-11 06:33:11', NULL, NULL, NULL),
(191, 'ORD266', 'PROD236', 'Beautiful bandni Mask', 1, NULL, 99, 99, '2025-03-11 06:36:03', 'USR225', NULL, NULL),
(192, 'ORD267', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-17 10:07:42', 'USR225', NULL, NULL),
(193, 'ORD268', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-17 10:50:24', 'USR225', NULL, NULL),
(194, 'ORD269', 'PROD235', 'Handcrafted Vase', 1, NULL, 399, 399, '2025-03-18 11:52:36', 'USR225', NULL, NULL),
(195, 'ORD270', 'PROD236', 'Beautiful bandni Mask', 2, NULL, 99, 198, '2025-03-19 06:24:46', 'USR225', NULL, NULL);

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `title1` text,
  `description1` text,
  `image1` varchar(128) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `title1`, `description1`, `image1`, `date`) VALUES
(5, 'Blog 1', '&lt;p&gt;Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged.&lt;/p&gt;', '67cffab95c424250311.png', '2025-03-11 08:48:20'),
(6, 'Test Blog 2', '&lt;p&gt;Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged.&lt;/p&gt;', '67d7e61e56e65250317.png', '2025-03-17 09:06:41'),
(7, 'blog 3', '&lt;p&gt;Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged. Lorem Ipsum is simply dummy text of the printing when an unknown printer took a galley of type and scrambled it to make a type specimen book. remaining essentially unchanged.&lt;/p&gt;', '67d7ed4c675db250317.jpg', '2025-03-17 09:37:16');

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

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

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `category` varchar(128) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `category` (`id`, `category`, `title`) VALUES
(75, 'Neck Set', NULL),
(76, 'Earrings', NULL),
(77, 'Rings', NULL),
(78, 'Nosepins', NULL),
(79, 'Bangles', NULL);

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

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

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `phone` varchar(128) DEFAULT NULL,
  `msg` text,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `contact` (`id`, `name`, `email`, `phone`, `msg`, `date`) VALUES
(12, 'Priyanka Das', 'priya.pie27@gmail.com', '9874615676', 'test test', '2024-05-24 06:59:45'),
(13, 'Priyanka Das', 'priya.pie27@gmail.com', '9874615676', 'test', '2024-07-25 10:08:54'),
(16, 'Sanjib', 'ezesols@gmail.com', '8800688526', 'contact', '2025-04-10 10:07:00'),
(15, 'Priyanka Das', 'priya.pie27@gmail.com', '9874615676', 'test', '2025-04-09 06:53:53'),
(17, 'dsd', 'dfdg@gmail.com', '999999999', '76276', '2025-04-14 06:34:07');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `images` varchar(128) DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `name`, `images`, `date`, `type`) VALUES
(154, NULL, '66a1ee8f6c965240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(153, NULL, '66a1ee80493f9240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(152, NULL, '66a1ee747bdda240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(151, NULL, '66a1ee6771cb2240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(150, NULL, '66a1ee5dd1afb240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(149, NULL, '66a1ea19ed471240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(148, NULL, '66a1ea12573cc240725.png', '2024-07-24 18:30:00', 'GALLERY'),
(147, NULL, '66a1e9e53e7a3240725.png', '2024-07-24 18:30:00', 'GALLERY');

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

--
-- Table structure for table `ids`
--

CREATE TABLE `ids` (
  `id` int(11) NOT NULL,
  `referid` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ids`
--

INSERT INTO `ids` (`id`, `referid`) VALUES
(1, '333');

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

--
-- Table structure for table `marquee`
--

CREATE TABLE `marquee` (
  `id` int(11) NOT NULL,
  `marquee` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `marquee`
--

INSERT INTO `marquee` (`id`, `marquee`) VALUES
(1, 'Trusted Brand. Happy Faces'),
(2, 'Beautiful collection. Never-ending variety');

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

--
-- Table structure for table `other_address`
--

CREATE TABLE `other_address` (
  `id` int(11) NOT NULL,
  `order_id` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `phone` varchar(128) DEFAULT NULL,
  `address` text,
  `pincode` varchar(128) DEFAULT NULL,
  `city` varchar(128) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `user_id` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `other_address`
--

INSERT INTO `other_address` (`id`, `order_id`, `name`, `phone`, `address`, `pincode`, `city`, `state`, `user_id`) VALUES
(4, 'ORD184', 'Priyanka Das', '9874615676', 'kaikhali', '700023', 'Kolkata', 'WEST BENGAL', 'USR152'),
(5, 'ORD204', 'Priyanka Das', '987676767', 'test test', '700059', 'Kolkata', 'WEST BENGAL', 'USR197');

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

--
-- Table structure for table `place_order`
--

CREATE TABLE `place_order` (
  `id` int(11) NOT NULL,
  `pay_status` varchar(100) DEFAULT NULL,
  `txid` varchar(100) DEFAULT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `client_name` varchar(128) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `address` varchar(1000) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(100) DEFAULT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `phon` varchar(100) DEFAULT NULL,
  `payment_option` varchar(200) DEFAULT NULL,
  `cod` int(11) DEFAULT NULL,
  `txnid` varchar(100) DEFAULT NULL,
  `txn_status` varchar(50) DEFAULT NULL,
  `bank_txn` varchar(50) DEFAULT NULL,
  `bank_name` varchar(50) DEFAULT NULL,
  `checksum` varchar(50) DEFAULT NULL,
  `gatewayname` varchar(50) DEFAULT NULL,
  `txn_msg` varchar(50) DEFAULT NULL,
  `mid` varchar(50) DEFAULT NULL,
  `other_address` int(11) NOT NULL DEFAULT '0',
  `delivery` varchar(128) DEFAULT 'NOT DELIVERED',
  `refund` varchar(128) DEFAULT 'NO',
  `delivery_link` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `place_order`
--

INSERT INTO `place_order` (`id`, `pay_status`, `txid`, `user_id`, `client_name`, `email`, `address`, `amount`, `date`, `status`, `order_id`, `phon`, `payment_option`, `cod`, `txnid`, `txn_status`, `bank_txn`, `bank_name`, `checksum`, `gatewayname`, `txn_msg`, `mid`, `other_address`, `delivery`, `refund`, `delivery_link`) VALUES
(243, 'Online', NULL, 'USR225', 'Priyanka Das', 'priya.pie27@gmail.com', '1/2 raghunathpur, teghoria', 99, '2025-03-11 12:06:03', 'PENDING', 'ORD266', '9874615676', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'NOT DELIVERED', 'NO', NULL),
(244, 'Pending', NULL, 'USR225', 'Priyanka Das', 'priya.pie27@gmail.com', NULL, 399, '2025-03-17 15:37:42', 'Pending', 'ORD267', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'NOT DELIVERED', 'NO', NULL),
(245, 'Online', NULL, 'USR225', 'Priyanka Das', 'priya.pie27@gmail.com', 'Rc-1/2, Raghunathpur, Kolkata, WEST BENGAL, 700156', 399, '2025-03-17 16:20:24', 'PENDING', 'ORD268', '9874615676', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'NOT DELIVERED', 'NO', NULL),
(246, 'Pending', NULL, 'USR225', 'Priyanka Das', 'priya.pie27@gmail.com', NULL, 399, '2025-03-18 17:22:36', 'Pending', 'ORD269', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'NOT DELIVERED', 'NO', NULL),
(247, 'PAYMENT_SUCCESS', NULL, 'USR225', 'Priyanka Das', 'priya.pie27@gmail.com', 'Rc-1/2, Raghunathpur, Kolkata, WEST BENGAL, 700156', 198, '2025-03-19 11:54:46', 'Cancelled', 'ORD270', '9874615676', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'NOT DELIVERED', 'YES', NULL);

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `id` int(11) NOT NULL,
  `title` text,
  `content` text,
  `image` varchar(128) DEFAULT NULL,
  `date` date NOT NULL,
  `category` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`id`, `title`, `content`, `image`, `date`, `category`) VALUES
(31, 'Shall I make the payment by online transferring or any other digital transfer?', '&lt;p&gt;It&amp;rsquo;s all based on the girl you hire. If she is ready for that you can do that but the service will start only after the amount credited in her account.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(32, 'What are the limitations with your escorts service ?', '&lt;p&gt;Number of sessions are always limited as per the gift amount fixed.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(29, 'Your in-call place is safe?', '&lt;p&gt;My in-call service is not offered to all the clients because I need to keep it safest place for meeting my clients.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(30, 'If I need the escorts girl at my place chennai, what I have to do?', '&lt;p&gt;You can plan it based on your feel of comfort. If you are planning out-call at your residence I prefer the client should come down to my place.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(27, 'Shall I get the real worth of my money?', '&lt;p&gt;Shall I get the real worth of my money?&lt;/p&gt;', NULL, '2024-07-12', NULL),
(28, 'Do you have travel escorts for business trips?', '&lt;p&gt;Yes, you will get the outstanding profiles for your business trips.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(25, 'Will you keep my details in your phone?', '&lt;p&gt;Never, as I told you I am giving most importance to the personal life and privacy of my dear clients.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(26, 'Are you running an escorts agency?', '&lt;p&gt;No, I am not running an &lt;strong&gt;escorts agency&lt;/strong&gt;.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(24, 'How the charges differs?', '&lt;p&gt;I have different levels of profiles offering different types of services.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(22, 'The pictures in your website are real?', '&lt;p&gt;I am offering real &lt;strong&gt;independent&lt;/strong&gt; escorts services.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(23, 'Which is the safe communication system for hiring an escort?', '&lt;p&gt;I prefer email communication. Just create a new email and send me mail asking the details and revealing your personal details.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(21, 'Shall I get the very same profile which I have chosen?', '&lt;p&gt;Please don&amp;rsquo;t compare my services with any low class &lt;strong&gt;escorts agency services.&lt;/strong&gt; I am dealing with the elite class people only and I have lots of satisfied regular clients across the city.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(19, 'What are the benefits of being independent?', '&lt;div class=&quot;panel&quot; style=&quot;display: block;&quot;&gt;\r\n&lt;p&gt;You can choose your hours more flexibly You can choose your own terms and talk to your clients before they come and see you&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;', NULL, '2024-07-12', NULL),
(20, ' How can I make sure that I am going to have fun with a genuine independent escorts?', '&lt;p&gt;The profiles which I have shown in my personal website are real &lt;strong&gt;independent escorts only&lt;/strong&gt;. You will feel the quality of the profile with their communication and the way they are treating the clients. Most of them are working professionals.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(33, 'I am staying in a hotel, I need the girl at my room, who will spend for her travelling?', '&lt;p&gt;The client has to spend money for her travelling. He has to pay extra for the up and down cab by cash.&lt;/p&gt;', NULL, '2024-07-12', NULL),
(34, 'Where can i find best escort service in Chennai?', '&lt;div class=&quot;panel&quot; style=&quot;display: block;&quot;&gt;\r\n&lt;p&gt;You can find Best Escort service in Chennai At &lt;a href=&quot;../index.php&quot;&gt;SafewalkChennai&lt;/a&gt;&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;', NULL, '2024-07-12', NULL);

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

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

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `title` text,
  `description` text,
  `image` varchar(128) DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `product_id` varchar(128) DEFAULT NULL,
  `category` varchar(128) DEFAULT NULL,
  `price` double(9,2) NOT NULL,
  `discounted_price` double(9,2) NOT NULL,
  `discount` int(11) NOT NULL,
  `sub_category` varchar(128) DEFAULT NULL,
  `trending` varchar(128) DEFAULT NULL,
  `size` varchar(128) DEFAULT NULL,
  `metal` varchar(128) DEFAULT NULL,
  `stone` varchar(128) DEFAULT NULL,
  `bestsellers` varchar(20) DEFAULT 'NO',
  `review_num` int(11) NOT NULL,
  `review_total_num` int(11) NOT NULL,
  `rating_num` int(11) NOT NULL,
  `sub_title` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `product` (`id`, `title`, `description`, `image`, `date`, `product_id`, `category`, `price`, `discounted_price`, `discount`, `sub_category`, `trending`, `size`, `metal`, `stone`, `bestsellers`, `review_num`, `review_total_num`, `rating_num`, `sub_title`) VALUES
(48, 'Silver Nosepin', NULL, '67dd05a106638250321.jpg', '2025-03-21 06:22:25', 'PROD280', 'Nosepins', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(49, 'Silver Nosepin', NULL, '67dd05ca6213a250321.webp', '2025-03-21 06:23:06', 'PROD281', 'Nosepins', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(50, 'Golden Ring', NULL, '67dd05f6605cc250321.png', '2025-03-21 06:23:50', 'PROD282', 'Rings', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(51, 'Stone studded Earrings', NULL, '67dd0683b53be250321.jpeg', '2025-03-21 06:26:11', 'PROD283', 'Earrings', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(52, 'Studded Nosepin', NULL, '67dd06de0353f250321.jpeg', '2025-03-21 06:27:42', 'PROD284', 'Nosepins', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(60, '3 layer neck set in pearl', NULL, '67f9324d2d3aa250411.jpeg', '2025-04-11 15:16:29', 'PROD307', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(45, 'Costume Jewelry Necklace', NULL, '67dcff6bd8213250321.png', '2025-03-21 05:55:55', 'PROD277', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'YES', 0, 0, 0, ''),
(46, 'Pendant with Chain', NULL, '67dcffba312a5250321.png', '2025-03-21 05:57:14', 'PROD278', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'YES', 0, 0, 0, ''),
(47, 'Dokra Ring spiral', NULL, '67dd0033b91b6250321.png', '2025-03-21 05:59:15', 'PROD279', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'YES', 0, 0, 0, 'made by Pital'),
(40, 'Pearl and MOP Set', NULL, '67dbf6803f11c250320.png', '2025-03-20 11:05:36', 'PROD272', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, 'mother of pearl'),
(41, 'Sreealankar best Neck Sets Product', NULL, '67dbf79265791250320.png', '2025-03-20 11:05:53', 'PROD273', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(42, 'Sreealankar best Neck Sets Product', NULL, '67dbf6af0faa9250320.png', '2025-03-20 11:06:23', 'PROD274', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(43, 'Sreealankar best Neck Sets Product', NULL, '67dbf7c3000f8250320.jpeg', '2025-03-20 11:10:59', 'PROD275', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'YES', 0, 0, 0, 'mother of pearl'),
(39, 'Dokra Set ', NULL, '67dbf57a18d68250320.png', '2025-03-20 11:01:14', 'PROD271', 'Neck Set', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, 'made by Pital '),
(53, 'Bangles', NULL, '67dd0987bd857250321.png', '2025-03-21 06:39:03', 'PROD285', 'Bangles', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(54, 'Diamond  Bangles ', NULL, '67dd0a15c5d79250321.jpg', '2025-03-21 06:41:25', 'PROD286', 'Bangles', 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(55, 'Bangles Set', NULL, '67dd0a3031c25250321.jpg', '2025-03-21 06:41:52', 'PROD287', 'Bangles', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'YES', 0, 0, 0, ''),
(59, 'Febric Jewellery', NULL, '67f929529bc90250411.png', '2025-04-11 14:38:10', 'PROD306', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(61, 'Agate and quartz stone fusion neck set', NULL, '67f932d07f2a7250411.jpeg', '2025-04-11 15:18:40', 'PROD308', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(62, 'Agate stone and texture beads fusion neck set', NULL, '67f93389e6a15250411.jpeg', '2025-04-11 15:21:45', 'PROD309', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(63, 'Derjiling stone neck set', NULL, '67f933eeab2c6250411.jpeg', '2025-04-11 15:23:26', 'PROD310', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(64, 'Monalisa stone and lace agate fusion neckpiece', NULL, '67f9342a1c80c250411.jpeg', '2025-04-11 15:24:26', 'PROD311', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(65, 'Mother of pearl and Monalisa stone fusion _001', NULL, '67f934b478771250411.jpeg', '2025-04-11 15:26:44', 'PROD312', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(66, 'Mother of pearl and Monalisa stone fusion in brass base_002', NULL, '67f93517b287c250411.jpeg', '2025-04-11 15:28:23', 'PROD313', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(67, 'Precious Stone Neckpiece', NULL, '67f9354fc87c3250411.jpeg', '2025-04-11 15:29:19', 'PROD314', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(68, 'Resin and pearl neck set_001', NULL, '67f935c086905250411.jpeg', '2025-04-11 15:30:25', 'PROD315', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(69, 'Brass Neck Set in Mother of pearl  ', NULL, '67f93623db383250411.jpeg', '2025-04-11 15:32:51', 'PROD316', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(70, 'Agate stone with monalisa  pendant neck piece', NULL, '6808fcd2d5c4f250423.jpg', '2025-04-23 14:44:34', 'PROD317', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(71, 'Agate stone with quartz pendant necl piece', NULL, '6808fd9c4e7f9250423.jpg', '2025-04-23 14:47:56', 'PROD318', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(72, 'Box agate with monalisa fusion', NULL, '6808fe0bdc743250423.jpg', '2025-04-23 14:49:47', 'PROD319', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(73, 'Fresh water pearl with AD stone pendant (chocolate colour )', NULL, '6808fe66dda63250423.jpg', '2025-04-23 14:51:18', 'PROD320', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(75, 'Fresh water pearl with AD stone pendant', NULL, '6808ff43aef30250423.jpg', '2025-04-23 14:54:59', 'PROD322', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(76, 'Fresh water pearl with stone pendant', NULL, '680c905dc36d6250426.jpg', '2025-04-26 07:50:53', 'PROD323', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(77, 'Monalisa with brass choker', NULL, '680c90a2a1e16250426.jpg', '2025-04-26 07:52:02', 'PROD324', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(78, 'Silver Look alike neck piece with ruby stone', NULL, '680c95ddf2313250426.jpg', '2025-04-26 08:14:21', 'PROD325', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(79, 'Slice agate with texture stone neck piece', NULL, '680c961a37145250426.jpg', '2025-04-26 08:15:22', 'PROD326', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(80, 'Yellow Tamble Agate Stone Neck Piece with ear rings', NULL, '680c964152ec0250426.jpg', '2025-04-26 08:16:01', 'PROD327', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(81, 'Precious stone neckpiece colour ice blue', NULL, '683c0cc61f3b8250601.jpg', '2025-06-01 08:18:14', 'PROD328', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(82, 'Precious stone neckpiece colour pink', NULL, '683c0cf372409250601.jpg', '2025-06-01 08:18:59', 'PROD329', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(83, 'Precious stone neckpiece colour sea green and white', NULL, '683c0d2ca0e43250601.jpg', '2025-06-01 08:19:56', 'PROD330', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(84, 'Stone chips neckpiece colour Red and White', NULL, '683c0d5799619250601.jpg', '2025-06-01 08:20:39', 'PROD331', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, ''),
(85, 'Stone chps neckpiece colour green', NULL, '683c0d7f76a1d250601.jpg', '2025-06-01 08:21:19', 'PROD332', 'Neck Set', 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 'NO', 0, 0, 0, '');

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

--
-- Table structure for table `product_enquiry`
--

CREATE TABLE `product_enquiry` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `phone` varchar(128) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `product` varchar(255) DEFAULT NULL,
  `requirements` varchar(255) DEFAULT NULL,
  `image` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_enquiry`
--

INSERT INTO `product_enquiry` (`id`, `name`, `email`, `phone`, `city`, `date`, `product`, `requirements`, `image`) VALUES
(64, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 14:37:05', 'Bangles Set', 'ok', '67dd0a3031c25250321.jpg'),
(63, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 14:35:49', 'Silver Nosepin', 'no', '67dd05a106638250321.jpg'),
(62, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 14:34:26', 'Dokra Ring spiral', 'Test', '67dd0033b91b6250321.png'),
(61, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 10:08:27', 'Dokra Ring spiral', 'test', '67dd0033b91b6250321.png'),
(60, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 10:03:51', 'Studded Nosepin', 'ok', '67dd06de0353f250321.jpeg'),
(59, 'Sanjib Datta', 'info@ezesols.com', '8800688526', NULL, '2025-04-10 10:02:32', 'Sreealankar best Neck Sets Product', 'testb', '67dbf7c3000f8250320.jpeg'),
(58, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 09:55:34', 'Dokra Ring spiral', 'test', '67dd0033b91b6250321.png'),
(57, 'Sanjib Datta', 'ezesols@gmail.com', '8800688526', NULL, '2025-04-10 07:46:53', 'Pendant with Chain', 'test', '67dcffba312a5250321.png'),
(65, 'Vishesh  Minocha ', 'visheshminocha99@gmail.com', '7503703915', NULL, '2026-02-10 12:49:55', 'Stone studded Earrings', 'Looking for coordinated jewellery sets.', '67dd0683b53be250321.jpeg'),
(66, 'Vishesh  Minocha ', 'visheshminocha99@gmail.com', '7503703915', NULL, '2026-02-10 12:49:58', 'Stone studded Earrings', 'Looking for coordinated jewellery sets.', '67dd0683b53be250321.jpeg'),
(67, 'Vishesh  Minocha ', 'visheshminocha99@gmail.com', '7503703915', NULL, '2026-02-10 12:49:58', 'Stone studded Earrings', 'Looking for coordinated jewellery sets.', '67dd0683b53be250321.jpeg'),
(68, 'Vishesh  Minocha ', 'visheshminocha99@gmail.com', '7503703915', NULL, '2026-02-10 14:34:24', 'Stone studded Earrings', 'Looking for coordinated jewellery sets.', '67dd0683b53be250321.jpeg');

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

--
-- Table structure for table `product_img`
--

CREATE TABLE `product_img` (
  `id` int(11) NOT NULL,
  `product_id` varchar(128) DEFAULT NULL,
  `img` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_img`
--

INSERT INTO `product_img` (`id`, `product_id`, `img`) VALUES
(67, 'PROD150', '66d02f00bcdecproduct-4.png'),
(66, 'PROD150', '66d02f00bc8c0product-4.png'),
(65, 'PROD150', '66d02f00bc48cproduct-4.png'),
(64, 'PROD150', '66d02f00bbe82product-4.png'),
(63, 'PROD155', '66d02e2666c84product-2.png'),
(62, 'PROD155', '66d02e2666923product-2.png'),
(61, 'PROD155', '66d02e2666567product-2.png'),
(60, 'PROD155', '66d02e2666046product-2.png'),
(59, 'PROD154', '66d02dea51baaproduct-3.png'),
(58, 'PROD154', '66d02dea517abproduct-3.png'),
(57, 'PROD154', '66d02dea512f0product-3.png'),
(56, 'PROD154', '66d02dea50c26product-3.png'),
(55, 'PROD151', '66b490606f6e8product-1.png'),
(54, 'PROD151', '66b490606f1daproduct-1.png'),
(53, 'PROD151', '66b4905fd0ae2product-1.png'),
(52, 'PROD151', '66b4905fd03bbproduct-1.png'),
(68, 'PROD156', '66d02f00bcdecproduct-4.png'),
(69, 'PROD156', '66d02f00bcdecproduct-4.png'),
(70, 'PROD177', '66d6df473ec8eearrings-1.png'),
(71, 'PROD177', '66d6df473f9d6earrings-1.png'),
(72, 'PROD177', '66d6df473ff4dearrings-1.png'),
(73, 'PROD177', '66d6df474046fearrings-1.png'),
(74, 'PROD178', '66d957919692ctrending-product-4.png'),
(75, 'PROD178', '66d957919707etrending-product-4.png'),
(76, 'PROD178', '66d95791974fatrending-product-4.png'),
(77, 'PROD178', '66d9579384631trending-product-4.png'),
(78, 'PROD179', '66d958374f201shopping.webp'),
(79, 'PROD179', '66d958374f7b9shopping.webp'),
(80, 'PROD179', '66d958374faa6shopping.webp'),
(81, 'PROD179', '66d958374fd18shopping.webp'),
(82, 'PROD180', '66d95cd4b25cering-1.png'),
(83, 'PROD180', '66d95cd4b2d78ring-1.png'),
(84, 'PROD180', '66d95cd4b31f3ring-1.png'),
(85, 'PROD180', '66d95cd4b3625ring-1.png'),
(86, 'PROD181', '66d96bfa1087dring-3.png'),
(87, 'PROD181', '66d96bfa8d359ring-3.png'),
(88, 'PROD181', '66d96bfa8da0ering-3.png'),
(89, 'PROD181', '66d96bfa8e036ring-3.png'),
(90, 'PROD185', '66e87864a33a9IMG_0040.jpeg'),
(91, 'PROD185', '66e87864a39b4IMG_0041.jpeg'),
(92, 'PROD185', '66e87864a3c6fIMG_0042.jpeg'),
(93, 'PROD185', '66e87864a477dIMG_0043.jpeg'),
(94, 'PROD179', '66e87bf9201bd240916.jpg'),
(95, 'PROD179', '66e87bfb34b81240916.jpg'),
(96, 'PROD179', '66e87bfbd8912240916.jpg'),
(97, 'PROD179', '66e87bfbd9fba240916.jpg'),
(98, 'PROD188', '6703915cd06a1images.jpg'),
(99, 'PROD188', '6703915cd0af0images.jpg'),
(100, 'PROD188', '6703915cd0ce9images.jpg'),
(101, 'PROD188', '6703915cd0f03images.jpg'),
(102, 'PROD189', '670391edcb029Untitled.jpg'),
(103, 'PROD189', '670391edcb3f3Untitled.jpg'),
(104, 'PROD189', '670391edcb5faUntitled.jpg'),
(105, 'PROD189', '670391edcb7f4Untitled.jpg'),
(106, 'PROD190', '670392b9082eb3_24bc81e9-a2b5-4ffc-9f6f-10723e0deb6b.webp'),
(107, 'PROD190', '670392b9087fe3_24bc81e9-a2b5-4ffc-9f6f-10723e0deb6b.webp'),
(108, 'PROD190', '670392b908b243_24bc81e9-a2b5-4ffc-9f6f-10723e0deb6b.webp'),
(109, 'PROD190', '670392b908fac3_24bc81e9-a2b5-4ffc-9f6f-10723e0deb6b.webp'),
(110, 'PROD191', '670393396761eBRI-new-wedding-hair-accessories-4d4d9db13fcd4e7a9a9a71d6480573a1.jpg'),
(111, 'PROD191', '6703933967b6bBRI-new-wedding-hair-accessories-4d4d9db13fcd4e7a9a9a71d6480573a1.jpg'),
(112, 'PROD191', '6703933967e89BRI-new-wedding-hair-accessories-4d4d9db13fcd4e7a9a9a71d6480573a1.jpg'),
(113, 'PROD191', '670393396814aBRI-new-wedding-hair-accessories-4d4d9db13fcd4e7a9a9a71d6480573a1.jpg'),
(114, 'PROD178', '6703946f7b452241007.webp'),
(115, 'PROD178', '6703946f7b877241007.webp'),
(116, 'PROD178', '6703946f7bafd241007.webp'),
(117, 'PROD178', '6703946f7bd5d241007.webp'),
(118, 'PROD192', '6703951ca0a36product-jpeg.jpg'),
(119, 'PROD192', '6703951ca0fcdproduct-jpeg.jpg'),
(120, 'PROD192', '6703951ca131fproduct-jpeg.jpg'),
(121, 'PROD192', '6703951ca1690product-jpeg.jpg'),
(122, 'PROD193', '670395852df37images.jpg'),
(123, 'PROD193', '670395852e404images.jpg'),
(124, 'PROD193', '670395852e673images.jpg'),
(125, 'PROD193', '670395852e81dimages.jpg'),
(126, 'PROD194', '670395ed897bbimages.jpg'),
(127, 'PROD194', '670395ed89c29images.jpg'),
(128, 'PROD194', '670395ed89eafimages.jpg'),
(129, 'PROD194', '670395ed8a1cfimages.jpg'),
(130, 'PROD203', '670faa721d2f7shopping.webp'),
(131, 'PROD203', '670faa721d007shopping.webp'),
(132, 'PROD203', '670faa721d2f7shopping.webp'),
(133, 'PROD203', '670faa721d588shopping.webp'),
(134, 'PROD224', '67c171ae4b9capro2.png'),
(135, 'PROD224', '67c171ae4c73dpro2.png'),
(136, 'PROD224', '67c171ae4cbccpro2.png'),
(137, 'PROD224', '67c171ae4d5ecpro2.png'),
(138, 'PROD235', '67c82671a38c6product03.png'),
(139, 'PROD235', '67c82671a4800product03.png'),
(140, 'PROD235', '67c8267398eaaproduct03.png'),
(141, 'PROD235', '67c82673997d7product03.png'),
(142, 'PROD236', '67c826b523075product02.png'),
(143, 'PROD236', '67c826b52366dproduct02.png'),
(144, 'PROD236', '67c826b523a64product02.png'),
(145, 'PROD236', '67c826b523e26product02.png');

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

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `id` int(11) NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `address` text,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `website` varchar(128) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `city` varchar(128) DEFAULT NULL,
  `pincode` varchar(128) DEFAULT NULL,
  `logo` varchar(128) DEFAULT NULL,
  `title` text,
  `favicon` varchar(128) DEFAULT NULL,
  `gst` varchar(134) DEFAULT NULL,
  `contact_person` varchar(128) DEFAULT NULL,
  `phonepay_img` varchar(128) DEFAULT NULL,
  `gpay_img` varchar(128) DEFAULT NULL,
  `paytm_img` varchar(128) DEFAULT NULL,
  `phonepe` varchar(128) DEFAULT NULL,
  `gpay` varchar(128) DEFAULT NULL,
  `paytm` varchar(128) DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `insta` varchar(255) DEFAULT NULL,
  `privacy` text,
  `terms` text,
  `meta_description` text,
  `meta_keyword` text,
  `merchant_key` varchar(128) DEFAULT NULL,
  `merchant_salt` varchar(128) DEFAULT NULL,
  `background_img` varchar(128) DEFAULT NULL,
  `signin_title` text,
  `watsapp` varchar(128) DEFAULT NULL,
  `title1` text,
  `content1` text,
  `banner` varchar(128) DEFAULT NULL,
  `content2` text,
  `leftside_title` varchar(255) DEFAULT NULL,
  `rightside_title` varchar(255) DEFAULT NULL,
  `about_title` varchar(255) DEFAULT NULL,
  `about_content` text,
  `about_img` varchar(128) DEFAULT NULL,
  `mission` text,
  `mission_img` varchar(128) DEFAULT NULL,
  `content12` text,
  `content21` text,
  `content3` text,
  `content4` text,
  `vision_img` varchar(128) DEFAULT NULL,
  `about_img2` varchar(128) DEFAULT NULL,
  `content3_title` varchar(555) DEFAULT NULL,
  `content4_img` varchar(128) DEFAULT NULL,
  `content5` text,
  `content5_img` varchar(128) DEFAULT NULL,
  `content6` text,
  `content6_img` varchar(128) DEFAULT NULL,
  `content7` text,
  `content7_img` varchar(128) DEFAULT NULL,
  `content8_img` varchar(128) DEFAULT NULL,
  `content9_img` varchar(128) DEFAULT NULL,
  `content10_img` varchar(128) DEFAULT NULL,
  `content_title2` text,
  `under_video` varchar(128) DEFAULT NULL,
  `under_img` varchar(128) DEFAULT NULL,
  `second_banner_video` varchar(128) DEFAULT NULL,
  `second_banner_img` varchar(128) DEFAULT NULL,
  `return_policy` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` (`id`, `company_name`, `address`, `phone`, `email`, `website`, `state`, `city`, `pincode`, `logo`, `title`, `favicon`, `gst`, `contact_person`, `phonepay_img`, `gpay_img`, `paytm_img`, `phonepe`, `gpay`, `paytm`, `fb`, `insta`, `privacy`, `terms`, `meta_description`, `meta_keyword`, `merchant_key`, `merchant_salt`, `background_img`, `signin_title`, `watsapp`, `title1`, `content1`, `banner`, `content2`, `leftside_title`, `rightside_title`, `about_title`, `about_content`, `about_img`, `mission`, `mission_img`, `content12`, `content21`, `content3`, `content4`, `vision_img`, `about_img2`, `content3_title`, `content4_img`, `content5`, `content5_img`, `content6`, `content6_img`, `content7`, `content7_img`, `content8_img`, `content9_img`, `content10_img`, `content_title2`, `under_video`, `under_img`, `second_banner_video`, `second_banner_img`, `return_policy`) VALUES
(1, 'Sree Alankar', 'I-2/155,156(1st floor) , sector 16, Rohini , Delhi 110089', '8587949009 /8527801005', 'info@sreealankar.in', 'sreealankar.in', 'DELHI', 'Delhi', '110089', '67dbd9ee20e9a250320.png', 'Sree Alankar', '67dbd9ee21206250320.png', '', 'NOT ADDED', '', '', '', '', '', '', 'https://www.facebook.com/share/18TR43q3D4/', 'https://www.instagram.com/invites/contact/?utm_source=ig_contact_invite&amp;utm_medium=copy_link&amp;utm_content=hs0s9c2', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\nUntil recently, the prevailing view assumed lorem ipsum was born as a nonsense text. &ldquo;It\'s not Latin, though it looks like it, and it actually says nothing,&rdquo; Before &amp; After magazine answered a curious reader, &ldquo;Its &lsquo;words&rsquo; loosely approximate the frequency with which letters occur in English, which is why at a glance it looks pretty real.&rdquo;\r\nThe discovery of the text\'s origin is attributed to Richard McClintock, a Latin scholar at Hampden&ndash;Sydney College. McClintock connected Lorem ipsum to Cicero\'s writing sometime before 1982 while searching for instances of the Latin word consectetur, which was rarely used in classical literature.[2] McClintock first published his discovery in a 1994 letter to the editor of Before &amp; After magazine,[9] contesting the editor\'s earlier claim that Lorem ipsum held no meaning.\r\nOn the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain.\r\nThese cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammeled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains.\r\n&nbsp;', 'AAAAm ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Until recently, the prevailing view assumed lorem ipsum was born as a nonsense text. &ldquo;It\'s not Latin, though it looks like it, and it actually says nothing,&rdquo; Before &amp; After magazine answered a curious reader, &ldquo;Its &lsquo;words&rsquo; loosely approximate the frequency with which letters occur in English, which is why at a glance it looks pretty real.&rdquo; The discovery of the text\'s origin is attributed to Richard McClintock, a Latin scholar at Hampden&ndash;Sydney College. McClintock connected Lorem ipsum to Cicero\'s writing sometime before 1982 while searching for instances of the Latin word consectetur, which was rarely used in classical literature.[2] McClintock first published his discovery in a 1994 letter to the editor of Before &amp; After magazine,[9] contesting the editor\'s earlier claim that Lorem ipsum held no meaning. On the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain. These cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammeled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains. But I must explain to you how all this mistaken idea of reprobating pleasure and extolling pain arose. To do so, 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 occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, 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? At vero eos et accusamus et iusto odio dignissimos ducimus, qui blanditiis praesentium voluptatum deleniti atque corrupti, quos dolores et quas molestias excepturi sint, obcaecati cupiditate non provident, similique sunt in culpa, qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem reru[d]um facilis est e[r]t expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio, cumque nihil impedit, quo minus id, quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellend[a]us. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet, ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat. We provide marketing services to startups and small businesses to looking for a partner of their digital media, design &amp; dev, lead generation, and communications requirements. We work with you, not for you. Although we have great resources. We reserve the right to change this User Agreement from time to time without notice. You acknowledge and agree that it is your responsibility to review this User Agreement periodically to be familiar yourself with any modifications. Your continued use of this site after such modifications will constitute acknowledgment and agreement of the modified terms and conditions. &nbsp;', '', '', '', '', '', 'Sree Alankar', 'NOT ADDED', 'Bangalore Night Plans', '&lt;p&gt;NOT ADDED&lt;/p&gt;', '6515215832cdb230928.mp4', NULL, 'OUR SERVICES', 'SRA PROJECT', 'About Us', '&lt;div class=&quot;col-md-6 col-sm-6 col-xs-12&quot;&gt;\r\n&lt;div class=&quot;about-left-block aos-init aos-animate&quot; style=&quot;transition: all 1600ms ease-in-out;&quot; data-aos=&quot;fade-down&quot;&gt;\r\n&lt;p&gt;Welcome to Sree Alankar, your go-to destination for trendy and affordable junk jewelry! We believe that great style doesn&amp;rsquo;t have to come with a hefty price tag. Our collection is all about fun, fashion, and self-expression&amp;mdash;helping you accessorize effortlessly for any occasion.&lt;/p&gt;\r\n&lt;p&gt;At Sree Alankar, we handpick unique and stylish pieces that add a touch of glam to your everyday look. Whether you love bold statement jewelry or delicate, minimalistic designs, we have something for everyone.&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;p&gt;&amp;nbsp;Our mission is simple: to bring you high-quality, budget-friendly jewelry that lets you shine without breaking the bank. We are passionate about creativity, affordability, and customer satisfaction.&lt;/p&gt;', '66a20538e58c3240725.png', '&lt;p&gt;The mission of Multistar Developers is to provide an outstanding level of service and expertise in the real estate market that is innovative and ambitious. Edge Realty is dedicated to the highest standards, systems and performance necessary to fulfill all of your real estate dreams.&lt;/p&gt;', '67e11686905f1250324.png', '&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;', '&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.&lt;/p&gt;', '&lt;p&gt;NOT ADDED&lt;/p&gt;', '&lt;p&gt;NOT ADDED&lt;/p&gt;', '67e1168690b1e250324.png', '66a20538e5dab240725.png', 'NOT ADDED', '66a20538e6195240725.png', '&lt;p&gt;Through our efforts, we\'re not just selling products; we\'re fostering a sense of community and solidarity. We\'re inviting individuals to be a part of something greater than themselves, to join hands in building a brighter tomorrow for those who need it most. When someone purchases a piece of stationery from us, they\'re not just acquiring a tangible item; they\'re investing in the future of a child, in the dreams of a young girl eager to break free from the chains of poverty.&lt;/p&gt;\r\n&lt;p&gt;Every sale is a step towards breaking the cycle of disadvantage and inequality. It\'s a testament to the belief that every child, regardless of their background, deserves access to quality education. By supporting our cause, individuals are not only enriching their own lives through beautiful stationery but also enriching the lives of those less fortunate. They\'re becoming agents of change, catalysts for progress, and champions of equality.&lt;/p&gt;', '66a20538e659b240725.png', '&lt;p&gt;As we continue our journey, we invite everyone to join us in this noble cause. Together, let\'s turn the page on illiteracy and write a new chapter of hope, opportunity, and empowerment for generations to come. With each purchase, each donation, we\'re not just selling stationery; we\'re selling dreams, we\'re selling possibilities, and most importantly, we\'re selling the promise of a brighter future for all.&lt;/p&gt;', '664dbc04987ad240522.png', 'NOT ADDED', '664dbf22c6992240522.png', '664dbf22c6db2240522.png', '664dbf22c7026240522.png', '664efc6328e54240523.png', 'NOT ADDED', 'ring-bracelet.mp4', '670116cd874b3241005.png', 'jewellery-necklaces-2.mp4', '6701196f878fa241005.png', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\nUntil recently, the prevailing view assumed lorem ipsum was born as a nonsense text. &ldquo;It\'s not Latin, though it looks like it, and it actually says nothing,&rdquo; Before &amp; After magazine answered a curious reader, &ldquo;Its &lsquo;words&rsquo; loosely approximate the frequency with which letters occur in English, which is why at a glance it looks pretty real.&rdquo;\r\nThe discovery of the text\'s origin is attributed to Richard McClintock, a Latin scholar at Hampden&ndash;Sydney College. McClintock connected Lorem ipsum to Cicero\'s writing sometime before 1982 while searching for instances of the Latin word consectetur, which was rarely used in classical literature.[2] McClintock first published his discovery in a 1994 letter to the editor of Before &amp; After magazine,[9] contesting the editor\'s earlier claim that Lorem ipsum held no meaning.\r\nOn the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain.\r\nThese cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammeled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains.');

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

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

CREATE TABLE `review` (
  `id` int(11) NOT NULL,
  `user_id` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `review` text,
  `rating` varchar(128) DEFAULT NULL,
  `maker_id` varchar(50) DEFAULT NULL,
  `order_id` varchar(128) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `product_id` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `review`
--

INSERT INTO `review` (`id`, `user_id`, `name`, `email`, `review`, `rating`, `maker_id`, `order_id`, `status`, `date`, `product_id`) VALUES
(79, 'USR197', 'P Das', 'priya.pie27@gmail.com', 'test', '5', NULL, NULL, 'Not-Published', '2024-10-30', 'PROD194'),
(77, 'USR197', 'P Das', 'priya.pie27@gmail.com', 'fvbbfvcx', '4', NULL, NULL, 'Not-Published', '2024-10-28', ''),
(78, 'USR197', 'P Das', 'priya.pie27@gmail.com', 'fvbbfvcx', '4', NULL, NULL, 'Not-Published', '2024-10-28', ''),
(76, 'USR197', 'P Das', 'priya.pie27@gmail.com', 'fvbbfvcx', '4', NULL, NULL, 'Not-Published', '2024-10-28', ''),
(75, 'USR152', 'Priyanka Das', 'priya.pie27@gmail.com', 'test', '5', NULL, NULL, 'Published', '2024-10-15', 'PROD193');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(11) NOT NULL,
  `title` text,
  `content` text,
  `image` varchar(128) DEFAULT NULL,
  `date` date NOT NULL,
  `category` varchar(128) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `product_id` varchar(128) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `A` varchar(7) NOT NULL DEFAULT '',
  `state_name` varchar(26) DEFAULT NULL,
  `C` varchar(9) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`A`, `state_name`, `C`) VALUES
('StateId', 'StateName', 'CountryId'),
('1', 'Andaman and Nicobar Island', '1'),
('2', 'Andhra Pradesh', '1'),
('3', 'Arunachal Pradesh', '1'),
('4', 'Assam', '1'),
('5', 'Bihar', '1'),
('6', 'Chandigarh', '1'),
('7', 'Chhattisgarh', '1'),
('8', 'Dadra and Nagar Haveli', '1'),
('9', 'Daman and Diu', '1'),
('10', 'Delhi', '1'),
('11', 'Goa', '1'),
('12', 'Gujarat', '1'),
('13', 'Haryana', '1'),
('14', 'Himachal Pradesh', '1'),
('15', 'Jammu and Kashmir', '1'),
('16', 'Jharkhand', '1'),
('17', 'Karnataka', '1'),
('18', 'Kerala', '1'),
('19', 'Lakshadweep', '1'),
('20', 'Madhya Pradesh', '1'),
('21', 'Maharashtra', '1'),
('22', 'Manipur', '1'),
('23', 'Meghalaya', '1'),
('24', 'Mizoram', '1'),
('25', 'Nagaland', '1'),
('26', 'Odisha', '1'),
('27', 'Puducherry', '1'),
('28', 'Punjab', '1'),
('29', 'Rajasthan', '1'),
('30', 'Sikkim', '1'),
('31', 'Tamil Nadu', '1'),
('32', 'Telangana', '1'),
('33', 'Tripura', '1'),
('34', 'Uttar Pradesh', '1'),
('35', 'Uttarakhand', '1'),
('36', 'West Bengal', '1');

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

--
-- Table structure for table `state_list`
--

CREATE TABLE `state_list` (
  `id` int(11) NOT NULL,
  `state` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `state_list`
--

INSERT INTO `state_list` (`id`, `state`) VALUES
(1, 'ANDAMAN AND NICOBAR ISLANDS'),
(2, 'ANDHRA PRADESH'),
(3, 'ARUNACHAL PRADESH'),
(4, 'ASSAM'),
(5, 'BIHAR'),
(6, 'CHATTISGARH'),
(7, 'CHANDIGARH'),
(8, 'DAMAN AND DIU'),
(9, 'DELHI'),
(10, 'DADRA AND NAGAR HAVELI'),
(11, 'GOA'),
(12, 'GUJARAT'),
(13, 'HIMACHAL PRADESH'),
(14, 'HARYANA'),
(15, 'JAMMU AND KASHMIR'),
(16, 'JHARKHAND'),
(17, 'KERALA'),
(18, 'KARNATAKA'),
(19, 'LAKSHADWEEP'),
(20, 'MEGHALAYA'),
(21, 'MAHARASHTRA'),
(22, 'MANIPUR'),
(23, 'MADHYA PRADESH'),
(24, 'MIZORAM'),
(25, 'NAGALAND'),
(26, 'ORISSA'),
(27, 'PUNJAB'),
(28, 'PONDICHERRY'),
(29, 'RAJASTHAN'),
(30, 'SIKKIM'),
(31, 'TAMIL NADU'),
(32, 'TRIPURA'),
(33, 'UTTARAKHAND'),
(34, 'UTTAR PRADESH'),
(35, 'WEST BENGAL');

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

--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `id` int(11) NOT NULL,
  `sub_category` varchar(128) DEFAULT NULL,
  `category` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `image` varchar(128) DEFAULT NULL,
  `design` varchar(555) DEFAULT NULL,
  `content` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`id`, `name`, `image`, `design`, `content`) VALUES
(3, 'Sarah Pahwa', '664efb0037a9b240523.png', NULL, '&lt;p&gt;Sarah Pahwa is currently a Senior pursuing Entrepreneurship in Babson College, USA and is attending one year in LSE, London for the academic year 2023-24. She is passionate about inducing collective change at the community level through targeted interventions, careful study of human behaviour, and efforts to increase social awareness. She hopes to incorporate the elements of Positive Psychology in her solutions to socioeconomic and cultural conflicts of contemporary society.&lt;/p&gt;'),
(4, 'Kyra Pahwa', '664efb1864823240523.png', NULL, '&lt;p class=&quot;aos-init aos-animate&quot; data-aos=&quot;zoom-in&quot;&gt;Kyra Pahwa is a 17 year old student at the Sat Paul Mittal School in Ludhiana, where she currently studies in Grade 12 in the Non Medical Stream. Kyra founded the Pay It Forward Society with her sister Sarah in 2017, and has been involved in the planning and execution of the Society\'s events since its conception. Being a person high on EQ, she has always aimed to work with empathy and compassion, putting her heart and soul into her initiatives. She aspires to bring about tangible social change through inclusive and impact-oriented community action.&lt;/p&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `description` text,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `name`, `description`, `date`) VALUES
(14, 'Renu Narayan (United Kingdom)', 'Fast delivery, stunning designs, and amazing customer service! Highly recommend.', '2025-04-04 05:59:45'),
(13, ' Shampa Mondal( Germany)', 'Sree Alankar never disappoints! Unique pieces that always get me compliments.', '2025-04-04 05:59:29'),
(12, 'Ronjita Choudhury (Germany)', 'Beautiful collection with great quality! Looks expensive but super budget-friendly!', '2025-04-04 05:59:11'),
(11, ' Pallabi Chatterjee (United Kingdom)', 'Absolutely love the designs! Affordable, stylish, and perfect for every occasion.', '2025-04-04 05:58:09'),
(15, 'Rakhi Dasgupta (kolkata)', ' Affordable luxury! The jewelry looks premium without the hefty price tag.', '2025-04-04 06:00:03'),
(16, 'Debashree Mukharjee (kolkata)', 'Perfect for gifting! My friends loved the trendy and elegant pieces.', '2025-04-04 06:00:18'),
(17, 'Sushmita Bose(Delhi)', 'Lightweight, stylish, and perfect for daily wear. My new favorite brand!', '2025-04-04 06:00:32'),
(18, 'Sunita Bose ( Odisha)', 'From traditional to modern, they have it all! My go-to for junk jewelry.', '2025-04-04 06:00:57'),
(19, 'Roshni shah( Japan)', 'Great value for money! I keep coming back for more trendy pieces.', '2025-04-04 06:01:13');

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

--
-- Table structure for table `top_slider`
--

CREATE TABLE `top_slider` (
  `id` int(11) NOT NULL,
  `image` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `top_slider`
--

INSERT INTO `top_slider` (`id`, `image`) VALUES
(23, '67dbe730a0366250320.png'),
(24, '67dbe77bdba6e250320.png'),
(25, '67dbe783bfda4250320.png'),
(26, '67dbe7a994e33250320.png'),
(27, '67dbe7ba88a27250320.png'),
(28, '67dbe7c6848df250320.png');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `user_id` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `password` varchar(128) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `pincode` varchar(225) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `city` varchar(128) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `user_id`, `name`, `phone`, `email`, `password`, `status`, `address`, `pincode`, `state`, `city`, `date`) VALUES
(6, 'USR225', 'Priyanka Das', '9874615676', 'priya.pie27@gmail.com', '25d55ad283aa400af464c76d713c07ad', 'ACTIVE', 'Rc-1/2, Raghunathpur', '700156', 'WEST BENGAL', 'Kolkata', '2025-03-03 10:39:42'),
(8, 'USR227', 'Priyanka Das', '1234567890', 'p@gmail.com', '25d55ad283aa400af464c76d713c07ad', 'INACTIVE', NULL, NULL, NULL, NULL, '2025-03-03 11:08:44'),
(11, 'USR230', 'R Gupta', '1234567890', 'rgupta@gmail.com', '1bbd886460827015e5d605ed44252251', 'INACTIVE', NULL, NULL, NULL, NULL, '2025-03-03 11:10:22'),
(12, 'USR231', 'R MIshra', '878787878', 'rmishra.erp@gmail.com', '25d55ad283aa400af464c76d713c07ad', 'INACTIVE', NULL, NULL, NULL, NULL, '2025-03-03 11:11:48'),
(14, 'USR233', 'Sujoy Biswas', '8327623414', 'sujoybiswas145@gmail.com', 'b519d98fd6947cce66b54cd888399b03', 'ACTIVE', NULL, NULL, NULL, NULL, '2025-03-04 10:19:17');

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`id`, `url`, `date`) VALUES
(13, 'il3dx59xw7k', '2024-04-17'),
(12, 'nBnh5pKenE0', '2024-04-17'),
(14, 'il3dx59xw7k', '2024-04-17'),
(15, 'il3dx59xw7k', '2024-04-17');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`A`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: sreealan_db.sql

Server Info

System Features

User Info