Gerenciador & Editor PHP

📝 Editando: diasdiamonds.sql

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 17, 2023 at 04:19 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 7.4.27

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

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

--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `detailaddress` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `address`
--

INSERT INTO `address` (`id`, `name`, `mobile`, `email`, `detailaddress`, `city`, `state`, `country`, `pincode`) VALUES
(1, 'prameshwer', '9875266256', 'butigod91@gmail.com', 'B1 Krishna Vihar Sodala', 'Jaipur', 'Rajasthan', 'India', '302006'),
(2, 'Singh Singh', '0806721800', 'johnsmithstore.91@gmail.com', 'RMZ Infinity - Tower E No.3, Old Madras Road', 'bangalore', 'ka', 'India', '560016'),
(3, 'Prameshwer', '9875266256', 'butigod91@gmail.com', 'Krishna Vihar Sodala', 'Jaipur', 'Rajasthan', 'India', '302019'),
(4, 'Prameshwer', '9875266256', 'butigod91@gmail.com', '6222 Richmond Avenue, Suite 447,', 'Houston', 'Texas ', 'United States', '77057');

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` int(11) NOT NULL,
  `systemaddress` varchar(255) NOT NULL,
  `userid` varchar(255) NOT NULL,
  `mykey` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `total` varchar(255) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` (`id`, `systemaddress`, `userid`, `mykey`, `sku`, `url`, `name`, `size`, `picture`, `quantity`, `price`, `total`, `date`) VALUES
(2, '::1', 'butigod91@gmail.com', '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', 'DD008', 'the-obharnait-diamond-ringdd008', 'The Obharnait Diamond Ring', '11', 'newf92c72d10deef671c732e0c6ba1016a83e7c74800765ff3c46abdecbacf9796f.jpg', '1', '435', '435', '2023-07-17');

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `metatitle` varchar(255) NOT NULL,
  `metakeyword` varchar(255) NOT NULL,
  `metadescription` longtext NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `discount` int(2) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `categories` (`id`, `picture`, `name`, `metatitle`, `metakeyword`, `metadescription`, `description`, `discount`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'diamonds-banner.jpg', 'Diamonds', 'Diamonds Jewellery', 'Diamonds Jewellery', 'Diamonds Jewellery', 'Diamonds Jewellery', 0, '2023-02-24', '2023-02-24', 'YES'),
(2, 'lab-grown-diamonds-banner.jpg', 'Lab Grown Diamonds', 'Lab Grown Diamonds', 'Lab Grown Diamonds', 'Lab Grown Diamonds', 'Lab Grown Diamonds', 0, '2023-02-24', '2023-02-24', 'YES');

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

--
-- Table structure for table `colors`
--

CREATE TABLE `colors` (
  `id` int(11) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `colors`
--

INSERT INTO `colors` (`id`, `picture`, `name`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'black.jpg', 'BLACK', '2021-08-17', '2021-08-17', 'YES'),
(2, 'blue.jpg', 'BLUE', '2021-08-17', '2021-08-17', 'YES'),
(3, 'brown.jpg', 'BROWN', '2021-08-17', '2021-08-17', 'YES'),
(6, 'green.jpg', 'GREEN', '2021-08-17', '2021-08-17', 'YES'),
(7, 'grey.jpg', 'GREY', '2021-08-17', '2021-08-17', 'YES'),
(8, 'khaki.jpg', 'KHAKI', '2021-08-17', '2021-08-17', 'YES'),
(9, 'maroon.jpg', 'MAROON', '2021-08-17', '2021-08-17', 'YES'),
(10, 'mustarad.jpg', 'MUSTARD', '2021-08-17', '2021-08-17', 'YES'),
(11, 'orange.jpg', 'ORANGE', '2021-08-17', '2021-08-17', 'YES'),
(12, 'pink.jpg', 'PINK', '2021-08-17', '2021-08-17', 'YES'),
(13, 'purple.jpg', 'PURPLE', '2021-08-17', '2021-08-17', 'YES'),
(14, 'red.jpg', 'RED', '2021-08-17', '2021-08-17', 'YES'),
(15, 'white.jpg', 'WHITE', '2021-08-17', '2021-08-17', 'YES'),
(16, 'yellow.jpg', 'YELLOW', '2021-08-17', '2021-08-17', 'YES'),
(17, 'light-grey.jpg', 'LIGHT GREY', '2021-08-17', '2021-08-17', 'YES'),
(18, 'turquoise.jpg', 'TURQUOISE', '2021-08-17', '2021-08-17', 'YES'),
(19, '674477aedfff08e64da0edc5b88295131fb10016b7def65b694f0706686739a1.jpg', 'CREAM', '2022-10-26', '2022-10-26', 'YES'),
(20, '2dc113f71d49dfc4a3fb6521a7855342a7e089489324fdba6e07cf81016863ed.jpg', 'BARBADOS', '2023-04-25', '2023-04-26', 'YES'),
(21, '3e1bf5ff1df1cd42d1804b5e378266cafe0b0a9137e7079013ecbad9470183a5.jpg', 'BEIGE', '2023-04-26', '2023-04-26', 'YES'),
(22, 'b1a8344369732aedfa2b075666e96e29669766b3677c6c4a150d0e21c4599775.jpg', 'ALL COLOR', '2023-05-02', '2023-05-02', 'YES');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(5) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `action`) VALUES
(1, 'Andorra', 'YES'),
(2, 'United Arab Emirates', 'YES'),
(3, 'Afghanistan', 'YES'),
(4, 'Antigua and Barbuda', 'YES'),
(5, 'Anguilla', 'YES'),
(6, 'Albania', 'YES'),
(7, 'Armenia', 'YES'),
(8, 'Angola', 'YES'),
(9, 'Antarctica', 'YES'),
(10, 'Argentina', 'YES'),
(11, 'American Samoa', 'YES'),
(12, 'Austria', 'YES'),
(13, 'Australia', 'YES'),
(14, 'Aruba', 'YES'),
(15, 'Åland Islands', 'YES'),
(16, 'Azerbaijan', 'YES'),
(17, 'Bosnia and Herzegovina', 'YES'),
(18, 'Barbados', 'YES'),
(19, 'Bangladesh', 'YES'),
(20, 'Belgium', 'YES'),
(21, 'Burkina Faso', 'YES'),
(22, 'Bulgaria', 'YES'),
(23, 'Bahrain', 'YES'),
(24, 'Burundi', 'YES'),
(25, 'Benin', 'YES'),
(26, 'Saint Barthélemy', 'YES'),
(27, 'Bermuda', 'YES'),
(28, 'Brunei Darussalam', 'YES'),
(29, 'Bolivia', 'YES'),
(30, 'Bonaire, Sint Eustatius and Saba', 'YES'),
(31, 'Brazil', 'YES'),
(32, 'Bahamas', 'YES'),
(33, 'Bhutan', 'YES'),
(34, 'Bouvet Island', 'YES'),
(35, 'Botswana', 'YES'),
(36, 'Belarus', 'YES'),
(37, 'Belize', 'YES'),
(38, 'Canada', 'YES'),
(39, 'Cocos [Keeling] Islands', 'YES'),
(40, 'Democratic Republic of the Congo', 'YES'),
(41, 'Central African Republic', 'YES'),
(42, 'Republic of the Congo', 'YES'),
(43, 'Switzerland', 'YES'),
(44, 'Ivory Coast', 'YES'),
(45, 'Cook Islands', 'YES'),
(46, 'Chile', 'YES'),
(47, 'Cameroon', 'YES'),
(48, 'China', 'YES'),
(49, 'Colombia', 'YES'),
(50, 'Costa Rica', 'YES'),
(51, 'Cuba', 'YES'),
(52, 'Cape Verde', 'YES'),
(53, 'Curaçao', 'YES'),
(54, 'Christmas Island', 'YES'),
(55, 'Cyprus', 'YES'),
(56, 'Czech Republic', 'YES'),
(57, 'Germany', 'YES'),
(58, 'Djibouti', 'YES'),
(59, 'Denmark', 'YES'),
(60, 'Dominica', 'YES'),
(61, 'Dominican Republic', 'YES'),
(62, 'Algeria', 'YES'),
(63, 'Ecuador', 'YES'),
(64, 'Estonia', 'YES'),
(65, 'Egypt', 'YES'),
(66, 'Western Sahara', 'YES'),
(67, 'Eritrea', 'YES'),
(68, 'Spain', 'YES'),
(69, 'Ethiopia', 'YES'),
(70, 'Finland', 'YES'),
(71, 'Fiji', 'YES'),
(72, 'Falkland Islands', 'YES'),
(73, 'Micronesia', 'YES'),
(74, 'Faroe Islands', 'YES'),
(75, 'France', 'YES'),
(76, 'Gabon', 'YES'),
(77, 'United Kingdom of Great Britain and Northern Ireland', 'YES'),
(78, 'Grenada', 'YES'),
(79, 'Georgia', 'YES'),
(80, 'French Guiana', 'YES'),
(81, 'Guernsey', 'YES'),
(82, 'Ghana', 'YES'),
(83, 'Gibraltar', 'YES'),
(84, 'Greenland', 'YES'),
(85, 'Gambia', 'YES'),
(86, 'Guinea', 'YES'),
(87, 'Guadeloupe', 'YES'),
(88, 'Equatorial Guinea', 'YES'),
(89, 'Greece', 'YES'),
(90, 'South Georgia and the South Sandwich Islands', 'YES'),
(91, 'Guatemala', 'YES'),
(92, 'Guam', 'YES'),
(93, 'Guinea-Bissau', 'YES'),
(94, 'Guyana', 'YES'),
(95, 'Hong Kong', 'YES'),
(96, 'Heard Island and McDonald Islands', 'YES'),
(97, 'Honduras', 'YES'),
(98, 'Croatia', 'YES'),
(99, 'Haiti', 'YES'),
(100, 'Hungary', 'YES'),
(101, 'Indonesia', 'YES'),
(102, 'Ireland', 'YES'),
(103, 'Israel', 'YES'),
(104, 'Isle of Man', 'YES'),
(105, 'India', 'YES'),
(106, 'British Indian Ocean Territory', 'YES'),
(107, 'Iraq', 'YES'),
(108, 'Iran', 'YES'),
(109, 'Iceland', 'YES'),
(110, 'Italy', 'YES'),
(111, 'Jersey', 'YES'),
(112, 'Jamaica', 'YES'),
(113, 'Jordan', 'YES'),
(114, 'Japan', 'YES'),
(115, 'Kenya', 'YES'),
(116, 'Kyrgyzstan', 'YES'),
(117, 'Cambodia', 'YES'),
(118, 'Kiribati', 'YES'),
(119, 'Comoros', 'YES'),
(120, 'Saint Kitts and Nevis', 'YES'),
(121, 'North Korea', 'YES'),
(122, 'South Korea', 'YES'),
(123, 'Kuwait', 'YES'),
(124, 'Cayman Islands', 'YES'),
(125, 'Kazakhstan', 'YES'),
(126, 'Laos', 'YES'),
(127, 'Lebanon', 'YES'),
(128, 'Saint Lucia', 'YES'),
(129, 'Liechtenstein', 'YES'),
(130, 'Sri Lanka', 'YES'),
(131, 'Liberia', 'YES'),
(132, 'Lesotho', 'YES'),
(133, 'Lithuania', 'YES'),
(134, 'Luxembourg', 'YES'),
(135, 'Latvia', 'YES'),
(136, 'Libya', 'YES'),
(137, 'Morocco', 'YES'),
(138, 'Monaco', 'YES'),
(139, 'Moldova', 'YES'),
(140, 'Montenegro', 'YES'),
(141, 'Saint Martin', 'YES'),
(142, 'Madagascar', 'YES'),
(143, 'Marshall Islands', 'YES'),
(144, 'North Macedonia', 'YES'),
(145, 'Mali', 'YES'),
(146, 'Myanmar [Burma]', 'YES'),
(147, 'Mongolia', 'YES'),
(148, 'Macao', 'YES'),
(149, 'Northern Mariana Islands', 'YES'),
(150, 'Martinique', 'YES'),
(151, 'Mauritania', 'YES'),
(152, 'Montserrat', 'YES'),
(153, 'Malta', 'YES'),
(154, 'Mauritius', 'YES'),
(155, 'Maldives', 'YES'),
(156, 'Malawi', 'YES'),
(157, 'Mexico', 'YES'),
(158, 'Malaysia', 'YES'),
(159, 'Mozambique', 'YES'),
(160, 'Namibia', 'YES'),
(161, 'New Caledonia', 'YES'),
(162, 'Niger', 'YES'),
(163, 'Norfolk Island', 'YES'),
(164, 'Nigeria', 'YES'),
(165, 'Nicaragua', 'YES'),
(166, 'Netherlands', 'YES'),
(167, 'Norway', 'YES'),
(168, 'Nepal', 'YES'),
(169, 'Nauru', 'YES'),
(170, 'Niue', 'YES'),
(171, 'New Zealand', 'YES'),
(172, 'Oman', 'YES'),
(173, 'Panama', 'YES'),
(174, 'Peru', 'YES'),
(175, 'French Polynesia', 'YES'),
(176, 'Papua New Guinea', 'YES'),
(177, 'Philippines', 'YES'),
(178, 'Pakistan', 'YES'),
(179, 'Poland', 'YES'),
(180, 'Saint Pierre and Miquelon', 'YES'),
(181, 'Pitcairn Islands', 'YES'),
(182, 'Puerto Rico', 'YES'),
(183, 'Palestine', 'YES'),
(184, 'Portugal', 'YES'),
(185, 'Palau', 'YES'),
(186, 'Paraguay', 'YES'),
(187, 'Qatar', 'YES'),
(188, 'Réunion', 'YES'),
(189, 'Romania', 'YES'),
(190, 'Serbia', 'YES'),
(191, 'Russia', 'YES'),
(192, 'Rwanda', 'YES'),
(193, 'Saudi Arabia', 'YES'),
(194, 'Solomon Islands', 'YES'),
(195, 'Seychelles', 'YES'),
(196, 'Sudan', 'YES'),
(197, 'Sweden', 'YES'),
(198, 'Singapore', 'YES'),
(199, 'Saint Helena', 'YES'),
(200, 'Slovenia', 'YES'),
(201, 'Svalbard and Jan Mayen', 'YES'),
(202, 'Slovakia', 'YES'),
(203, 'Sierra Leone', 'YES'),
(204, 'San Marino', 'YES'),
(205, 'Senegal', 'YES'),
(206, 'Somalia', 'YES'),
(207, 'Suriname', 'YES'),
(208, 'South Sudan', 'YES'),
(209, 'São Tomé and Príncipe', 'YES'),
(210, 'El Salvador', 'YES'),
(211, 'Sint Maarten', 'YES'),
(212, 'Syria', 'YES'),
(213, 'Swaziland', 'YES'),
(214, 'Turks and Caicos Islands', 'YES'),
(215, 'Chad', 'YES'),
(216, 'French Southern Territories', 'YES'),
(217, 'Togo', 'YES'),
(218, 'Thailand', 'YES'),
(219, 'Tajikistan', 'YES'),
(220, 'Tokelau', 'YES'),
(221, 'East Timor', 'YES'),
(222, 'Turkmenistan', 'YES'),
(223, 'Tunisia', 'YES'),
(224, 'Tonga', 'YES'),
(225, 'Turkey', 'YES'),
(226, 'Trinidad and Tobago', 'YES'),
(227, 'Tuvalu', 'YES'),
(228, 'Taiwan', 'YES'),
(229, 'Tanzania', 'YES'),
(230, 'Ukraine', 'YES'),
(231, 'Uganda', 'YES'),
(232, 'U.S. Minor Outlying Islands', 'YES'),
(233, 'United States', 'YES'),
(234, 'Uruguay', 'YES'),
(235, 'Uzbekistan', 'YES'),
(236, 'Vatican City', 'YES'),
(237, 'Saint Vincent and the Grenadines', 'YES'),
(238, 'Venezuela', 'YES'),
(239, 'British Virgin Islands', 'YES'),
(240, 'U.S. Virgin Islands', 'YES'),
(241, 'Vietnam', 'YES'),
(242, 'Vanuatu', 'YES'),
(243, 'Wallis and Futuna', 'YES'),
(244, 'Samoa', 'YES'),
(245, 'Kosovo', 'YES'),
(246, 'Yemen', 'YES'),
(247, 'Mayotte', 'YES'),
(248, 'South Africa', 'YES'),
(249, 'Zambia', 'YES'),
(250, 'Zimbabwe', 'YES');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `minimumamount` varchar(255) NOT NULL DEFAULT '0',
  `mode` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `name`, `amount`, `minimumamount`, `mode`, `type`, `startdate`, `enddate`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'SAVE100', '100', '299', 'RUPEE', 'MULTIPLE', '2021-01-24', '2021-01-26', '2021-08-29', '2021-08-29', 'YES');

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL,
  `inr` varchar(255) NOT NULL,
  `usd` varchar(255) NOT NULL,
  `pound` varchar(255) NOT NULL,
  `euro` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `inr`, `usd`, `pound`, `euro`) VALUES
(1, '82.07', '1', '0.77', '0.89');

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `role` longtext NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `role`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'ADMINISTRATOR', 'Categories__Color__Integration__Marketing__Metals__Notifications__Page__Products__Report__Sales__Shapes__Size Charts__Size Measurement__Sliders__Stores__Tax Rules__User Permissions__Users__', '2021-08-30', '2023-07-17', 'YES');

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `name`, `email`, `mobile`, `username`, `department`, `password`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'prameshwer', 'butigod91@gmail.com', '9875266256', 'admin', 'ADMINISTRATOR', '9f4cb4b0f20b8983fdd603acfd66f7a0209a811e79c9f9deb413ebb342eca1c9', '2021-08-15', '2021-08-30', 'YES');

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

--
-- Table structure for table `exhibitions`
--

CREATE TABLE `exhibitions` (
  `id` int(11) NOT NULL,
  `city` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `datefrom` date NOT NULL,
  `dateto` date NOT NULL,
  `time` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exhibitions`
--

INSERT INTO `exhibitions` (`id`, `city`, `address`, `datefrom`, `dateto`, `time`, `action`) VALUES
(1, 'New Delhi', 'Aga Khan Hall Bhagwan Das Road, New Delhi, Delhi 110001', '2022-07-09', '2022-07-10', '10 AM - 8 PM', 'YES');

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

--
-- Table structure for table `fabrics`
--

CREATE TABLE `fabrics` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fabrics`
--

INSERT INTO `fabrics` (`id`, `name`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'RAYON', '2021-08-17', '2021-08-17', 'YES'),
(2, 'COTTON', '2021-08-17', '2021-08-17', 'YES'),
(3, 'CHIFFON', '2021-11-07', '2021-11-07', 'YES'),
(4, 'CHANDERI', '2021-11-08', '2021-11-08', 'YES'),
(5, 'KOTA DORIA', '2021-11-08', '2021-11-08', 'YES'),
(6, '100 % POLYSTER', '2023-02-28', '2023-04-26', 'YES'),
(7, 'NON WOOVEN ', '2023-04-29', '2023-04-29', 'YES'),
(8, 'PVC', '2023-05-01', '2023-05-01', 'YES'),
(9, 'FABRIC ', '2023-05-01', '2023-05-01', 'YES'),
(10, 'SUEDE ', '2023-05-01', '2023-05-01', 'YES'),
(11, 'BLACKOUT FABRIC ', '2023-05-01', '2023-05-01', 'YES'),
(12, 'WOODEN ', '2023-05-07', '2023-05-07', 'YES');

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

--
-- Table structure for table `histories`
--

CREATE TABLE `histories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` varchar(255) NOT NULL,
  `logout` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `histories`
--

INSERT INTO `histories` (`id`, `name`, `date`, `time`, `logout`, `ip`) VALUES
(1, 'butigod91@gmail.com', '2023-06-30', '11:32', '11:37', '152.58.98.114'),
(2, 'butigod91@gmail.com', '2023-06-30', '11:37', '', '152.58.98.114'),
(3, 'butigod91@gmail.com', '2023-06-30', '11:47', '', '152.58.98.114');

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

--
-- Table structure for table `integrations`
--

CREATE TABLE `integrations` (
  `id` int(11) NOT NULL,
  `googlewebmaster` longtext NOT NULL,
  `googleanalytics` longtext NOT NULL,
  `googleconversion` longtext NOT NULL,
  `googlethanks` longtext NOT NULL,
  `facebookpixel` longtext NOT NULL,
  `facebooksnippet` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `integrations`
--

INSERT INTO `integrations` (`id`, `googlewebmaster`, `googleanalytics`, `googleconversion`, `googlethanks`, `facebookpixel`, `facebooksnippet`) VALUES
(1, '', '', '', '', '', '');

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `receiveremail` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `date` date NOT NULL,
  `time` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `metals`
--

CREATE TABLE `metals` (
  `id` int(11) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `createdate` date DEFAULT NULL,
  `modifieddate` date DEFAULT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `metals`
--

INSERT INTO `metals` (`id`, `picture`, `name`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'rosegold.png', 'ROSE GOLD', '2023-07-17', '2023-07-17', 'YES'),
(2, 'yellowgold.png', 'YELLOW GOLD', '2023-07-17', '2023-07-17', 'YES'),
(3, 'platinum.png', 'PLATINUM', '2023-07-17', '2023-07-17', 'YES'),
(4, 'silver.png', 'SILVER', '2023-07-17', '2023-07-17', 'YES'),
(6, '14k-white-gold.png', 'WHITE GOLD', '2023-07-17', '2023-07-17', 'YES');

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

--
-- Table structure for table `narrations`
--

CREATE TABLE `narrations` (
  `id` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `userid` varchar(255) NOT NULL,
  `heading` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `createdate` date DEFAULT NULL,
  `modifieddate` date DEFAULT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `notifications` (`id`, `name`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'Call Us tel:+1(832)643-9131', '2023-02-20', '2023-02-20', 'YES'),
(2, 'All over world Delivery', '2023-02-20', '2023-02-20', 'YES'),
(3, 'Lifetime Warranty', '2023-07-14', '2023-07-14', 'YES');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `txnid` varchar(255) NOT NULL,
  `bank_ref_no` varchar(255) NOT NULL,
  `responseurl` varchar(255) NOT NULL,
  `paymentstatus` varchar(255) NOT NULL,
  `orderid` int(11) NOT NULL DEFAULT 0,
  `invoiceno` int(11) NOT NULL,
  `userid` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `address` longtext NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `gstn` varchar(255) NOT NULL,
  `remark` longtext NOT NULL,
  `date` date NOT NULL,
  `time` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `discount` varchar(255) NOT NULL,
  `shipping` int(11) NOT NULL DEFAULT 0,
  `total` varchar(255) NOT NULL,
  `advance` varchar(255) DEFAULT NULL,
  `paymentmode` varchar(255) NOT NULL,
  `sellerremark` longtext NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'PENDING',
  `trackingurl` varchar(255) NOT NULL,
  `trackingid` varchar(255) NOT NULL,
  `cron` varchar(255) NOT NULL DEFAULT 'NO'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `orders` (`id`, `token`, `txnid`, `bank_ref_no`, `responseurl`, `paymentstatus`, `orderid`, `invoiceno`, `userid`, `name`, `mobile`, `address`, `city`, `state`, `country`, `pincode`, `gstn`, `remark`, `date`, `time`, `amount`, `discount`, `shipping`, `total`, `advance`, `paymentmode`, `sellerremark`, `status`, `trackingurl`, `trackingid`, `cron`) VALUES
(6, 'fcad6d86f828c23a8ad21989bcde799c', '', '', '', 'Pending', 1001, 0, 'butigod91@gmail.com', 'Prameshwer', '9875266256', '6222 Richmond Avenue, Suite 447,', 'Houston', 'Texas ', 'United States', '77057', '', '', '2023-07-17', '14:13', '435', '0', 0, '435', NULL, 'PAYPAL', '', 'PENDING', '', '', 'NO');

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

--
-- Table structure for table `ordersdetails`
--

CREATE TABLE `ordersdetails` (
  `id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `txnid` varchar(255) NOT NULL,
  `orderid` varchar(255) NOT NULL DEFAULT '0',
  `userid` varchar(255) NOT NULL,
  `mykey` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `variation` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `total` varchar(255) NOT NULL,
  `paymentmode` varchar(255) NOT NULL,
  `paymentstatus` varchar(255) NOT NULL DEFAULT 'Pending',
  `date` date NOT NULL,
  `status` varchar(255) NOT NULL,
  `review` varchar(255) NOT NULL DEFAULT 'NO'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ordersdetails`
--

INSERT INTO `ordersdetails` (`id`, `token`, `txnid`, `orderid`, `userid`, `mykey`, `sku`, `name`, `variation`, `picture`, `quantity`, `price`, `total`, `paymentmode`, `paymentstatus`, `date`, `status`, `review`) VALUES
(5, 'fcad6d86f828c23a8ad21989bcde799c', '', '1001', 'butigod91@gmail.com', '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', 'DD008', 'The Obharnait Diamond Ring', '11', 'newf92c72d10deef671c732e0c6ba1016a83e7c74800765ff3c46abdecbacf9796f.jpg', '1', '435', '435', 'PAYPAL', 'Pending', '2023-07-17', 'PENDING', 'NO');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `name`, `description`, `createdate`, `modifieddate`) VALUES
(1, 'terms', 'Welcome to diasdiamonds.com (“Website”). Dias Diamonds and/or its affiliates provide website features and other products and services to you when you visit or shop at diasdiamonds.com, use Dias Diamonds products or services, or use software provided by Dias Diamonds in connection with any of the foregoing. Dias Diamonds provides the Services subject to the following conditions. This user agreement (“Terms and Conditions” or “T&amp;C” or “Terms” or “Agreement”) is between you (“you” or “End User” or “your” or “Buyer” or “Customer” or “Registered User”) and Dias Diamonds (“Company” or “us” or “we” or “diasdiamonds.com”). This document is an electronic record in terms of Information Technology Act, 2000 and rules there under as applicable and the amended provisions pertaining to electronic records in various statutes as amended by the Information Technology Act, 2000. This electronic record is generated by a computer system and does not require any physical or digital signatures .Not withstanding anything contained or said in any other document, if there is a conflict between the terms mentioned herein below and any other document, the terms contained in the present T&amp;C shall alone prevail for the purposes of usage of the Site.\n\nRIGHT TO CHANGE\n\nDias Diamonds reserves the sole right to update or modify these Terms and Conditions at any time without prior notice. For this reason, we encourage you to review these Terms and Conditions every time you purchase products from us or use our Web Site.\n\nPRIVACY\n\nWe view protection of your privacy as a very important principle. We understand clearly that You and Your Personal Information is one of our most important assets. We store and process Your Information including any sensitive financial information collected (as defined under the Information Technology Act, 2000), if any, on computers that may be protected by physical as well as reasonable technological security measures and procedures in accordance with Information Technology Act 2000 and Rules there under. If you object to our current Privacy Policy and your information being transferred or used in this way please do not use Website.\n\nELECTRONIC COMMUNICATIONS\n\nWhen you use any of our Services, or send e-mails to us, you are communicating with us electronically. You by using our services consent to receive communications from us electronically. We will communicate with you by e-mail or by posting notices on this site or through other Services. You agree that all agreements, notices, disclosures and other communications that we provide to you electronically satisfy any legal requirement that such communications be in writing. The legal requirements would be inconformity with the Indian Information Technology Act, 2000 and rules there under as applicable and the amended provisions pertaining to electronic records in various statutes as amended by the Information Technology Act, 2000.\n\nINTELLECTUAL PROPERTY RIGHTS\n\nUnless otherwise indicated or anything contained to the contrary or any proprietary material owned by a third party and so expressly mentioned, Dias Diamonds owns all Intellectual Property Rights to and into the Website, including, without limitation, any and all rights, title and interest in and to copyright, related rights, patents, utility models, trademarks, trade names, service marks, designs, know-how, trade secrets and inventions (whether patentable or not), goodwill, source code, meta tags, databases, text, content, graphics, icons, and hyperlinks. You acknowledge and agree that you shall not use, reproduce or distribute any content from the Website belonging to Dias Diamonds without obtaining authorization from it.\n\nUser shall not upload post or otherwise make available on the Site any material protected by copyright, trademark or other proprietary right without the express permission of the owner of the copyright, trademark or other proprietary right. Dias Diamonds does not have any express burden or responsibility to provide the Users with indications, markings or anything else that may aid the User in determining whether the material in question is copyrighted or trademarked. User shall be solely liable for any damage resulting from any infringement of copyrights, trademarks, proprietary rights or any other harm resulting from such a submission. By submitting material to any public area of the Site, User warrants that the owner of such material has expressly granted Dias Diamonds the royalty-free, perpetual, irrevocable, non-exclusive right and license to use, reproduce, modify, adapt, publish, translate and distribute such material (in whole or in part) worldwide and/or to incorporate it in other works in any form, media or technology now known or hereafter developed for the full term of any copyright that may exist in such material. User also permits any other end user to access, view, store or reproduce the material for that end user’s personal use. User hereby grants Dias Diamonds, the right to edit, copy, publish and distribute any material made available on the Site by the User. The foregoing provisions of Section 25 apply equally to and are for the benefit of Dias Diamonds, its subsidiaries, affiliates and its third party content providers and licensors and each shall have the right to assert and enforce such provisions directly or on its own behalf.\n\nTRADEMARKS\n\nThe Site contain copyrighted material, trademarks and other proprietary information, including, but not limited to, text, software, photos, video, graphics, music, sound, and the entire contents of Dias Diamonds protected by copyright as a collective work under the applicable copyright laws. Dias Diamonds owns a copyright in the selection, coordination, arrangement and enhancement of such content, as well as in the content original to it. Users may not modify, publish, transmit, participate in the transfer or sale, create derivative works, or in any way exploit, any of the content, in whole or in part. Users may download / print / save copyrighted material for the User’s personal use only. Except as otherwise a expressly stated under copyright law, no copying, redistribution, retransmission, publication or commercial exploitation of downloaded material without the express permission of Dias Diamonds and the copyright owner is permitted.\n\nIf copying, redistribution or publication of copyrighted material is permitted, no changes in or deletion of author attribution, trademark legend or copyright notice shall be made. The User acknowledges that he/she/it does not acquire any ownership rights by downloading copyrighted material. Trademarks that are located within or on the Site or a website otherwise owned or operated in conjunction with Dias Diamonds shall not be deemed to be in the public domain but rather the exclusive property of Dias Diamonds, unless such site is under license from the trademark owner thereof in which case such license is for the exclusive benefit and use of Dias Diamonds, unless otherwise stated.\n\n\n\nINTELLECTUAL PROPERTY RIGHTS COMPLAINTS\n\nDias Diamonds respects the intellectual property of others. If you believe that your work has been copied in a way that constitutes any Intellectual Property Right infringement, please address a complaint to the ‘Customer Care’ by way of an email as provided herein below.\n\nUSER RESPONSIBILITY AND REGISTRATION OBLIGATIONS\n\nIf you use the Website as Registered User, you agree that you are competent to contract within the meaning of the Indian Contract Act, 1872. Dias Diamonds reserves the right to terminate your membership and refuse to provide you with access to the Website if it is brought to its notice or if it is discovered that you are under the age of 18 years. You are solely responsible for maintaining the confidentiality of your User ID and Password. You are responsible for all activities that occur under your User ID and Password. You agree, inter-alia, to provide true, accurate, current and complete information about yourself as prompted by Website registration form or provided by You as a Visitor or user of a third party site through which You access the Website. If you provide any information that is untrue, inaccurate, not current or incomplete or we have reasonable grounds to suspect that such information is untrue, inaccurate, not current or incomplete, or not in accordance with the User Agreement, Dias Diamonds has the right to indefinitely suspend or terminate or block access of your membership with the Website and refuse to provide you with access to the Website.\n\nAs a condition of purchase, the Site requires your permission to send you administrative and promotional emails. We will send you information regarding your account activity and purchases, as well as updates about our products and promotional offers. You can opt-out of our promotional emails anytime by clicking the unsubscribe link at the bottom of any of our email correspondences. Please see our Privacy Policy for details. The offers made in any promotional messages sent via emails/SMS/MMS shall be subject to change at the sole discretion of Dias Diamonds and Dias Diamonds owes no responsibility to provide you any information regarding such change.\n\nYou undertake not to host, display, upload, modify, publish, transmit, update or share any information that is contained on the website that:\n\nbelongs to another person and to which you does not have any right to; is grossly harmful, harassing, blasphemous; defamatory, obscene, pornographic, pedophilic, libelous, invasive of another’s privacy, hateful, or racially, ethnically objectionable, disparaging, relating or encouraging money laundering or gambling, or otherwise unlawful in any manner whatever; harm minors in any way; infringes any patent, trademark, copyright or other proprietary rights; violates any law for the time being in force; deceives or misleads the addressee about the origin of such messages or communicates any information which is grossly offensive or menacing in nature; impersonate another person; contains software viruses or any other computer code, files or programs designed to interrupt, destroy or limit the functionality of any computer resource; threatens the unity, integrity, defence, security or sovereignty of India, friendly relations with foreign states, or or public order or causes incitement to the commission of any cognisable offence or prevents investigation of any offence or is insulting any other nation. That in case it is found that you are in violation of these express conditions, you shall be solely responsible and shall face all legal consequences of the same by yourself and that Dias Diamonds shall in no manner be held responsible for the same\n\nThat in case it is found that you are in violation of these express conditions, you shall be solely responsible and shall face all legal consequences of the same by yourself and that Dias Diamonds shall in no manner be held responsible for the same.\n\nBILLING\n\nThe price of our merchandise as mentioned on diasdiamonds.com is the Maximum Retail Price (MRP) for the said product. Such MRP shall be inclusive of all local taxes as are applicable in India. Additional applicable taxes may be charged depending upon the destination where the order has to be shipped to. The tax rate applied and charged upon the order shall include combined tax rate for both state and local tax rates in accordance with the address where the order is being shipped. Dias Diamonds reserves the right to collect taxes and/or such other levy/ duty/ surcharge that it may have to incur in addition to the normal taxes it may have to pay. We may also charge Delivery Charges which may include postal charges/ shipment charges etc. that may be applicable for your country.\n\nGIFT CARD &amp; CREDIT NOTE POLICY\n\n<ul>\n\n<li>Gift Cards bought on our website will be sent via email. Physical copy of Gift Cards bought online will not be sent separately.</li>\n\n<li>Gift Cards bought in INR currency in shop or on our web boutique can be redeemed on the website and across all shops, pan India.</li>\n\n<li>Gift Cards can also be bought in USD and GBP currency on web boutique. These Gift Cards can only be redeemed on the web boutique and not in shops.</li>\n\n<li>Gift Cards cannot be used towards buying additional Gift Cards and cannot be redeemed for cash or credit voucher/credit note.</li>\n\n<li>Gift Cards cannot be purchased using credit voucher/credit note issued either by shops or on our web boutique</li>\n\n<li>Gift Cards can only be redeemed in the same currency in which they are bought (i.e. You can only redeem USD or GBP Gift Card when shipping outside India and INR Gift Card when shipping within India).</li>\n\n<li>Gift Card value can be partially redeemed in multiple transactions, on both our web boutique and across all shops, pan India, using the same code.</li>\n\n<li>In case of order value exceeding the Gift Card amount, the outstanding balance must be paid by Debit Card/Credit Card/Net Banking (for international transactions).</li>\n\n<li>Credit Notes are only issued in Dias Diamonds stores. These however can be redeemed across all our stores pan India as well as on our web boutique.</li>\n\n<li>Multiple Gift Cards and Credit Notes CAN be applied or used in combination with each other in our shops and web boutique (online).</li>\n\n<li>To redeem a Credit Note against an online order(s), please sign into the account associated with the customer in whose name and email address the credit note has been issued.</li>\n\n<li>In shops, Credit Note can be redeemed by the customer whose name and email address it was issued in.</li>\n\n<li>With effect from April 1st, 2018, Credit Notes will be valid for 6 months from the date of issue.</li>\n\n<li>Any Credit Note issued prior to April 1st, 2018, will be valid till 30th Sep, 2018 (i.e. 6-months from April 1st).</li>\n\n<li>Dias Diamonds shall not be held responsible for any Gift Card being lost or stolen or redeemed without owner’s permission.</li>\n\n<li>With effect from January 1st, 2018, Gift Cards will be valid for 2 years from the date of purchase.</li>\n\n<li>Gift Card &amp; Credit Note Policies are subject to change at any time without prior notice.</li>\n\n</ul>\n\nHOW TO ACTIVATE GIFT CARD GUIDE\n\n<ul>\n\n<li>To activate your gift card, visit our web boutique and follow the following steps.</li>\n\n<li>Under the Profile tab on the header select ‘Activate Gift Card’ from the drop-down menu. In case you are already signed in, information such as your name, mobile number or email ID will auto populate the form in the activate your gift card window. In case, you are not logged in fill in your first and last name in the input fields provided.</li>\n\n<li>Fill in your gift card number in the input box provided and select either the email address or mobile number radio buttons to choose the method you would like to receive your OTP via. Next, select the agree to terms box at the bottom of the page, and then press the ‘Send OTP’ button.</li>\n\n<li>*Please note that receiving an OTP via SMS is only applicable for domestic (pan Indian) phone numbers. For international numbers, please select the send OTP via email option.</li>\n\n<li>Once you receive your OTP, enter the number in the input space provided on the next page. Then, click on the ‘Activate Gift Card’ tab at the bottom of the screen. In case you did not receive your OTP, click on the ‘Resend OTP’ link to resend the OTP.</li>\n\n<li>Once you have successfully submitted your OTP, a window informing you that your gift card is now activated will appear with details such as date of issue and of expiry. The window will also show you the available balance on the gift card.</li>\n\n<li>*Please note: validity will be calculated from date of purchase not from date of activation.</li>\n\nDias Diamonds REGISTRY T&amp;Cs\n\n<li>Your Dias Diamonds Registry is online-based and is valid solely on our web boutique.</li>\n\n<li>In order to create your registry, you must be signed in to your Dias Diamonds account.</li>\n\n<li>You can only create one active registry at a time, either a wedding registry or a special occasion registry.</li>\n\n<li>You can make changes to the name of the registry, registrant and co-registrant at any time.</li>\n\n<li>Once submitted, the email address provided by you cannot be changed.</li>\n\n<li>Please note that a change of address to another country may result in a change of pricing of the products in your registry catalogue.</li>\n\n<li>Once your Dias Diamonds Registry is created, it cannot be deleted. However, you can make changes to the date and product quantities.</li>\n\n<li>Please note that once a single quantity of the desired product from your Dias Diamonds Registry is purchased, you will not be able to delete the purchased item. However, items can be deleted before they are purchased.</li>\n\n<li>To track how many items have been purchased, discarded or requested, please visit your dashboard.</li>\n\n<li>Gift cards cannot be added to the Dias Diamonds Registry, but can be redeemed against registry orders.</li>\n\n<li>Your Dias Diamonds Registry is valid during annual sales and promotional events.</li>\n\n<li>You can share your Dias Diamonds Registry with friends and family via whatsapp (on mobile) and email by copy-pasting the link.</li>\n\n<li>For any questions or order enquiries that you may have, please reach out to us on hello@Dias Diamonds,com.</li>\n\n</ul>\n\nCATALOGUE PRICING\n\n<ul>\n\n<li>By changing the country, you will be charged according to the price list associated with that country and NOT by any conversion rate.</li>\n\n<li>Our international catalogues are priced in Indian Rupees for Indian residents, British pounds for UK residents and US dollars for all other international customers.</li>\n\n<li>Due to import/trade restrictions, certain products might not be available for delivery in your chosen country.</li>\n\n</ul>\n\nORDER CANCELLATION BY Dias Diamonds\n\nDue to unavoidable circumstances there may be times when certain orders having been validly placed may not be processed or capable of being dispatched. Dias Diamonds reserves the exclusive right to refuse or cancel any order for any reason. Some situations that may result in your order being cancelled shall include limitations on quantities available for purchase, inaccuracies or errors in product or pricing information, problems identified by our credit and fraud avoidance department or any defect regarding the quality of the product. We may also require additional verifications or information before accepting any order. We will contact you if all or any portion of your order is cancelled or if additional information is required to accept your order. If your order is cancelled after your credit card/ debit card/ any other mode of payment has been charged, the said amount will be reversed into your Account/ as the case may be to the source of the payment within a period of 30 working days. Any type of voucher used in these orders shall be returned and made available to the user in case of cancellation by Dias Diamonds.\n\nSHIPPING &amp; PROCESSING FEE\n\nOur shipping and processing charges are intended to compensate Dias Diamonds for the cost of processing your order, handling and packing the products you purchase and delivering them to you. For further information please refer to our Shipping &amp; Payment Policy.\n\nPAYMENT\n\nWhile availing any of the payment method/s offered by us, we are not responsible or take no liability of whatsoever nature in respect of any loss or damage arising directly or indirectly to you including but not limited to the following: (a) lack of authorization for any transaction/s; (b) or exceeding the preset limit mutually agreed by you and between your “Bank/s”; (c) or any payment issues arising out of the transaction; (d) or decline of transaction for any other reason/s.\n\nAll payments made against the purchases/services on diasdiamonds.com by you shall be as against the MRP displayed on the website and shall be in terms and conditions of the third party Online Payment Gateway Services as adopted and applicable to your transaction as approved by Dias Diamonds. Before shipping your order to you, we may request you to provide supporting documents (including but not limited to Govt. issued ID and address proof) to establish the ownership of the payment instrument used by you for your purchase. This is done so as to ensure a safe and a fool proof online shopping environment to our users.\n\nSuch payments can be made through the electronic or through Cash on delivery transactions, as may be permitted by Dias Diamonds which shall be at its sole discretion. Use of such third party services will be governed by their User Agreement, Seller Terms, Conditions and other rules and policies as may be required and applicable for your nature of activities.\n\nDELIVERY\n\nDias Diamonds endeavors but does not guarantee delivery of products in the stipulated time period as mentioned on the purchase of the product. In no manner can the contract be repudiated if Dias Diamonds fails to deliver any one or more products in the stipulated time frame. However, if you fail to take the delivery of the goods, Dias Diamonds may at its discretion charge you for additional shipping cost.\n\nLOSS IN TRANSIT\n\nDias Diamonds endeavors but does not guarantee delivery of products in the stipulated time period as mentioned on the purchase of the product. In no manner can the contract be repudiated if Dias Diamonds fails to deliver any one or more products in the stipulated time frame. However, if you fail to take the delivery of the goods, Dias Diamonds may at its discretion charge you for additional shipping cost.\n\nREFUNDS &amp; RETURNS\n\nDias Diamonds shall make all endeavors to deliver defect free products to the purchasers. Dias Diamonds does not take title to any returned items purchased by the user unless the item is received by Dias Diamonds. Any item purchased on our website does not qualify for any return unless the product delivered is damaged or has manufacturing defects. The defective and/or damaged goods so received shall be communicated to Dias Diamonds within 48 hours of its receipt. Any communication received after 48 hours of delivery shall not qualify for return unless expressly covered by the product warranty even in case the said product has been wrongly delivered.\n\nDias Diamonds holds the sole discretion to determine whether a refund can be issued. For further information please read our Returns &amp; Exchanges Policy.\n\nPRODUCT DESCRIPTIONS\n\nProducts displayed on Dias Diamonds attempts to be as accurate as possible. However, Dias Diamonds does not warrant that product descriptions or other content is accurate, complete, reliable, current, or error-free. If a product offered by Dias Diamonds is not as described, your sole remedy is to contact Dias Diamonds within 48 hours of receipt and Dias Diamonds reserves the right to provide a solution as per its discretion. Dias Diamonds is not liable to issue any refunds or allow exchanges and/or returns as a matter of policy.\n\nPRODUCT COMPLIANCE\n\nProducts displayed/ sold on the Dias Diamonds website are manufactured/ procured as per the applicable Local Laws of India and are in conformity with the required Indian industry standards.\n\nPRODUCT PRICING DISCLAIMER\n\nThe prices displayed on our website may differ from prices that are available in stores. Further the prices displayed in our catalogs are quotes which may vary from country to country for the same product. Prices shown on the website both for India and in other International Countries are subject to change without prior notice. These prices only reflect the MRP and do not include shipping and taxes which may be extra as applicable.\n\nINACCURACY DISCLAIMER\n\nFrom time to time there may be information on our Website or in our catalog that may contain typographical errors, inaccuracies, or omissions that may relate to product descriptions, pricing, and availability. Dias Diamonds reserves the right to correct any errors, inaccuracies or omissions and to change or update information at any time without prior notice.\n\nWARRANTIES &amp; LIABILITY\n\nAll information, content, materials, products (including software) and other services included on or otherwise made available to you by Dias Diamonds are provided on an AS IS and AS AVAILABLE basis, unless otherwise specified in writing. Dias Diamonds makes no representations or warranties of any kind, express or implied, as to the operation of the services, or the information, content, materials, products (including software) or other services included on or otherwise made available to you through Dias Diamonds, unless otherwise specified in writing. You expressly agree that your use of the website is at your sole risk.\n\nDias Diamonds does not warrant that this Website will be constantly available or available at all or that any information on this Website is complete, true, accurate or non-misleading.\n\nWe will not be liable to You in any way or in relation to the Contents of, or use of, or otherwise in connection with, the Website. You acknowledge, by your use of this Website, that your use of this Website is at your sole risk, that you assume full responsibility for all risks associated with all necessary servicing or repairs of any equipment you use in connection with your use of this Website, and that Dias Diamonds shall not be liable for any damages of any kind related to your use of this Website.\n\nThough Dias Diamonds shall make all endeavor to protect its websites from any viruses or other illegal use of its website. However we do not warrant that this site; information, Content, materials, product (including software) or services included on or otherwise made available to You through the Website; its servers; or electronic communication sent from us are free of viruses or other harmful components. Nothing on Website constitutes, or is meant to constitute, advice of any kind.\n\nAll the Products sold on Website shall be solely governed by the Indian Laws. In the event we are unable to deliver such Products due to implications of different territorial laws, we will return or will give credit for the amount (if any) received in advance by us from the sale of such Product that could not be delivered to You. It is YOUR responsibility to ensure that the products purchased on this website is not restricted in your territory. Dias Diamonds shall not be responsible for any non-compliance with regard to the local laws of that territory for any product available on this website.\n\nDias Diamonds will not be liable for any damages of any kind arising from the use of any service, or from any information, content, materials, products (including software) or other services included on or otherwise made available to you through the website, including, but not limited to direct, indirect, incidental, punitive, and consequential damages, unless otherwise specified in writing.\n\nINDEMNITY\n\nYou agree to indemnify and shall not hold Dias Diamonds (and its officers, directors, agents, subsidiaries, affiliates, joint ventures, and employees) for any claim or demand, including but not limited to reasonable attorneys’ fees, or arising out of or related to your breach of this T&amp;C, or your violation of any law or the rights of a third party or any damage to life and/or property caused by the products delivered.\n\nBREACH\n\nIn the event you are found to be in breach of the Terms of Use or Privacy Policy or other rules and policies or if we are unable to verify or authenticate any information you provide or if it is believed that your actions may cause legal liability for you, other users or us, without limiting to the present, without prior notice immediately limit your activity, remove your information, temporarily/indefinitely suspend or terminate or block your membership, and/or refuse to provide you with access to this Website. Any user that has been suspended or blocked may not register or attempt to register with us or use the Website in any manner whatsoever until such time that such user is reinstated by us.\n\nNotwithstanding the foregoing, if you breach the Terms of Use or Privacy Policy or other rules and policies, we reserve the right to recover any amounts due and owing by you to us and to take strict legal action including but not limited to a referral to the appropriate police or other authorities for initiating criminal or other proceedings against you.\n\nAny breach of any applicable local laws of that territory shall also result in, without prior notice immediately limit your activity, remove your information, temporarily/indefinitely suspend or terminate or block your membership, and/or refuse to provide you with access to this Website.\n\nSEVERABILITY\n\nWe reserve the right to make changes to our site, policies, Service Terms, and these Conditions of Use at any time. If any of these conditions shall be deemed invalid, void, or for any reason unenforceable, that condition shall be deemed severable and shall not affect the validity and enforceability of any remaining condition.\n\nWAIVER\n\nThe failure by Dias Diamonds to enforce at any time or for any period any one or more of the terms or conditions of the Agreement shall not be a waiver by Dias Diamonds of them or of the right any time subsequent to enforce all Terms and Conditions of this agreement.\n\nFORCE MAJEURE\n\nFailure on the part of Dias Diamonds to perform any of its obligations and the non furnishing of the Service), shall not entitle you to raise any claim against Dias Diamonds or be a breach hereunder to the extent that such failure arises from an event of Force Majeure. If through force Majeure the fulfillment by either party of any obligation set forth in this Agreement will be delayed, the period of such delay will not be counted on in computing periods prescribed by this Agreement. Force Majeure will include any war, civil commotion, strike, governmental action, lockout, accident, epidemic or any other event of any nature or kind whatsoever beyond the control of Dias Diamonds that directly or indirectly hinders or prevents Dias Diamonds from commencing or proceeding with consummation of the transactions contemplated hereby. You expressly agree that lack of funds shall not in any event constitute or be considered an event of Force Majeure.\n\nDISPUTE RESOLUTION\n\nThis agreement shall be construed and the legal relations between YOU and Dias Diamonds hereto shall be determined and governed according to the laws of India. If any dispute arises between You and Dias Diamonds regarding Your use of the Website or Your dealing with Dias Diamonds in relation to any activity on the Website, in connection with the validity, interpretation, implementation or breach of any provision of the Terms &amp; Conditions and/or Privacy Policy including but not limited to the rules and policies contained herein, the dispute shall be subject to the exclusive jurisdiction to the Courts of New Delhi.\n\nYour obligations to pay the Payment Fees shall not be suspended during the pendency of such proceedings.\n\nGRIEVANCE\n\nAny grievances you have by way of use of the website can be addressed to the ‘Customer Care’ by way of email to info@diasdiamonds.com\n\nThe ‘Customer Care’ shall thereafter consider the same and provide a response within one month of the date of such complaint/ grievance.\n\nGOVERNING LAW\n\nThese Terms and Conditions or the documents of third party payment channels shall be governed and construed in accordance with the laws of India.\n\nThis document is an electronic record in terms of Information Technology Act, 2000 and the amended provisions pertaining to electronic records in various statutes as amended by the Information Technology Act, 2000. This electronic record is generated by a computer system and does not require any physical or digital signatures.\n\n', '2021-08-14', '2023-02-28'),
(2, 'privacy', 'USER INFORMATION AND PRIVACY\nDias Diamonds Apparel and Furnishing Pvt. Ltd (hereafter referred to as Dias Diamonds) and/or its affiliates are committed to protecting all the information you share with us. We follow stringent procedures to protect the confidentiality, security, and integrity of data stored on our systems. Only those employees who need access to your information in order to perform their duties are allowed such access. Any employee who violates our privacy and/or security policies is subject to disciplinary action, including possible termination and civil and/or criminal prosecution, Dias Diamonds’s topmost priority is in protecting your confidential information and privacy.\nThis privacy policy tells you how we use your personal information collected through the www.diasdiamonds.com. Please read this privacy policy before using the www.diasdiamonds.com or submitting any personal information. This policy will be updated subject to any changes in information collection, activities performed or any applicable regulations. You are encouraged to review the privacy policy whenever you visit the www.diasdiamonds.com to make sure that you understand how any personal information you provide will be used.\n\nPlease Note:\nThe privacy practices set forth in this privacy policy are for www.diasdiamonds.com only. If you link to other web sites, please review those privacy policies, which may be very different.\n\nCOLLECTION AND USE OF INFORMATION\n\nCOLLECTION OF YOUR INFORMATION\nDias Diamonds collects, processes, and retains information about you when you visit our www.diasdiamonds.com. You may choose to provide us with information, such as your name, email address, company information, street address, telephone number, or other information, to access protected information on www.diasdiamonds.com or so we can follow up with you after your visit. Personal Information may include, but is not limited to:\n<ul>\n<li>Your name,</li>\n<li>Email addresses,</li>\n<li>Telephone numbers</li>\n<li>Country, City, and State</li>\n</ul>\nREGISTRATION\nDias Diamonds keeps track of your information to offer you the best possible experience. A data subject has to provide an email address is the mandatory Personal Information during registration (sign-up). Post this registration, Dias Diamonds will be able to access your account every time you visit the Website. The customers also have to provide other Personal Information (instance - name, phone number, email, billing and shipping addresses) before completing the first purchase.\n\nHOW WE USE YOUR INFORMATION\n\nAny of the information we collect from you may be used in one of the following ways:\n<ul>\n<li>To gather details about prospect customers: Your information helps us to more effectively respond to your requests and queries to make the application interface user-friendly.</li>\n<li>To send periodic emails: Subject to your prior approval, we may use the information you share with us, to communicate with you through e-mails, text messages, and calls, in order to provide our product or service related information and/or for promotional and marketing purposes.</li>\n<li>Select Content, Improve Quality and Facilitate Use of the other interface channels: Dias Diamonds may use your Personal Information to help create and personalize content on our Channels, facilitate your use of the Channels (for example, to facilitate navigation and the login process, avoid duplicate data entry, enhance security, improve quality, track campaign and survey responsiveness and evaluate page response rates.</li>\n<li>Obtain Third Party Services: We also share Personal Information and Other Information with affiliates/subsidiaries and third parties who provide services to Dias Diamonds website management, information technology, and related infrastructure provision, customer service, e-mail delivery, auditing and other similar services. When Dias Diamonds shares Personal Information with affiliates/subsidiaries, third parties, service providers, we assure you that they use your Personal Information and Other Information only for the purpose of providing services to us and subject to terms consistent with this policy.</li>\n</ul>\n\nFAIRNESS AND PURPOSE\n\nDias Diamonds will collect adequate, relevant and necessary Personal Information and will process such information fairly and lawfully for the purpose it is collected. The purpose of collection will be specified not later than at the time of data collection or on each occasion of change of purpose.\n\nDISTRIBUTION OF INFORMATION\n\nINFORMATION DISCLOSURE\n\nDias Diamonds does not share, sell, rent, or trade personal information collected through its www.diasdiamonds.com with third parties for their sole promotional purposes or as otherwise outlined in this Privacy Policy. Dias Diamonds may share information with third-party service providers contracted to provide services on our behalf for processing to provide your employment-related services and benefits and other business purposes. These third-party service providers may only use the information we provide to them as requested and instructed by Dias Diamonds.\n<ul>\n<li>Dias Diamonds may disclose your Personal Information as we believe to be necessary or appropriate:\n</li><li>under applicable law, including laws outside your country of residence; \n</li><li>to comply with legal process; \n</li><li>to respond to requests from public and government authorities, including public and government authorities outside your country of residence, for national security and/or law enforcement purposes; \n</li><li>to enforce our terms and conditions; and \n</li><li>to allow us to pursue available remedies or limit the damages that we may sustain. \n	Additionally, in the event of a reorganization, merger, sale, joint venture, assignment, transfer or other disposition of all or any portion of our business, assets or stock (including in connection with any bankruptcy or similar proceedings), we may transfer the Personal Information which we have collected to the affiliates/subsidiaries/ relevant third party.\n	We may share information with governmental agencies or other companies assisting us in fraud prevention or investigation. We may do so when:\n</li><li>permitted or required by law; or,\n</li><li>trying to protect against or prevent actual or potential fraud or unauthorized transactions; or,\n</li><li>Investigating fraud which has already taken place. The information is not provided to these companies for marketing purposes.\n</li></ul>\nIf Dias Diamonds goes through a business transition, such as a merger, acquisition by another company, or sale of all or a portion of its assets, the personal information collected from the customers (i.e. collected through our website(s) / retail stores) may be treated as an assets-transferred. Not having a retrospective effect, a notice will appear on our website(s) for 30 days after any such change in ownership or control of your personal information.\nTo improve your Web experience, and to offer you products in which you might be interested, we provide links to business alliance companies, Dias Diamonds dealers, and other third-party sites. When you click on these links, you will be transferred out of our Web site and connected to the Web site of the organization or company that you selected. Because Dias Diamonds does not control these sites (even if an affiliation exists between our Web sites and a third party site), you are encouraged to review their individual privacy notices. If you visit a Web site that is linked to our sites, you should consult that site\'s privacy policy before providing any Customer Identifiable Information. Dias Diamonds does not assume any responsibility or liability in relation to the conduct of such third parties.\n\nCROSS-BORDER DATA TRANSFERS\nWhen conducting business, working on Company projects, or implementing new processes or systems, an operation may require the transfer of personal information to other entities or third parties that are located outside of the Dias Diamonds operation’s country of business. While permissible data transfer mechanisms are defined by applicable law or regulation, examples include:\n<ul>\n<li>a data transfer agreement with the party who will access or obtain the personal information;</li>\n<li>notice to and/or approval from a country’s local data protection authority; or</li>\n<li>notice to and/or consent from the individual whose data is to be transferred.</li>\n</ul>\nCONSENT AND CONTROL\n\nCONSENT\nConsent is often referred to as an individual’s choice to “opt-in” or “opt-out” of the Company’s use of personal information and is usually obtained by a “checkbox” or signature confirming the individual understands and agrees to the processing of their personal information. At times, express written consent from the individual may be required based on the information processing activity. Dias Diamonds receives consent from individuals prior to: collecting, using, or processing their personal information, including sensitive personal information, in certain ways or sharing the individual’s personal information with any third party; transferring the individual’s personal information outside of the individual’s country of residence using or placing web cookies on an individual’s computer or other electronic devices.\n\nCONTROL OF YOUR INFORMATION\nYou may request to review, correct, update, suppress, or otherwise modify any of your Personal Information that you have previously provided to us through www.diasdiamonds.com, or object to the use or processing of such Personal Information by us. If you have concerns regarding access to or the correction of your Personal Information, please contact us at the privacy contact information mentioned within Section 11 “Privacy Contact Information” of this policy. In your request, please make clear what Personal Information you would like to have changed, whether you would like to have your Personal Information that you have provided to us suppressed from our database or otherwise let us know what limitations you would like to put on our use of your Personal Information that you have provided to us.\nWhile the majority of questions and issues related to access can be handled quickly, complex requests may take more research and time. In such cases, issues will be addressed, or you will be contacted regarding the nature of the problem and appropriate next steps, within thirty days.\n\nDATA STORAGE\nDias Diamonds may transfer your information from www.diasdiamonds.com to other databases and store it on Dias Diamonds or other supplier systems. Dias Diamonds ensures appropriate security controls while storing data on its or its supplier’s systems.\n\nCOMMITMENT TO DATA SECURITY\nYour personally identifiable information is kept secure. Only authorized employees, business partners, clients, vendors, affiliates/subsidiaries and other third-party providers (who have agreed to keep information secure and confidential) have access to this information. Dias Diamonds ensures that our supplier employs industry-standard security measures to ensure the security of information through legally binding terms and conditions. However, users of our www.diasdiamonds.com are responsible for maintaining the security of any password, user ID, or other forms of authentication involved in obtaining access to password protected or secure areas of any Workday websites. Access to and use of password protected and/or secure area of www.diasdiamonds.com is restricted to authorized users only. Unauthorized access to such areas is prohibited and may lead to criminal prosecution.\n\nUSE OF COOKIES\nLike many other transactional websites, we use “cookies” to improve your shopping experience and to save you time. Cookies are little tags that we place onto your computer. We assign a cookie to your computer when you first visit us in order to enable us to recognize you each time you return. Through cookies, we can customize our Website to your individual preferences in order to create a more personalized, convenient shopping experience. Please note that the cookies we use for our Website or email campaigns do not store personally identifiable information about you or your finances. Dias Diamonds may offer certain features that are only available through the use of a “cookie”. Dias Diamonds does not control the use of cookies by third parties and is not responsible for the same. Dias Diamonds may in addition also offer certain features that are only available through the use of a “cookie”.\n\nRETENTION AND DISPOSAL\nDias Diamonds Personal information shall be retained only as long as necessary for the fulfillment of the stated purposes and should be disposed of thereafter. We will retain your information for as long as your account is active or as needed to provide you services. If you wish that we no longer use your information to provide you services, contact us via the information provided in section 11 of this privacy policy. We will respond to your request within 30 days of receipt of the request. However, we may also retain and use your information as necessary to comply with our legal obligations, resolve disputes, and enforce our agreements.\n\nYOUR CONSENT\nYour consent to personal data collection and processing may be revoked by notifying us via our contact page. For users below the age of 16, the consent should be provided by the holder of parental responsibility of the child.\nPlease note, in case you (the customer) is not willing to provide consent or withdraw the consent at any given point of time, Dias Diamonds shall not be able to provide the services as detailed above in section 2.2 of this policy.\n\nPRIVACY CONTACT INFORMATION\nIf you have any questions regarding our Privacy Statement or if you need to update, change or remove information, you can do so by contacting +1(832)643-9131 or by regular mail addressed to info@diasdiamonds.com\n\nCHANGES TO THE PRIVACY POLICY\nFrom time to time we may update this Privacy Policy without any prior notice. Your continued subscription to our Services constitutes an acceptance of the current Privacy Policy and Terms &amp; Conditions. Therefore, we encourage you to visit this page (https://www.diasdiamonds.com/privacy-policy) periodically to review any changes.\n\n', '2021-08-14', '2023-02-28');
INSERT INTO `pages` (`id`, `name`, `description`, `createdate`, `modifieddate`) VALUES
(3, 'return', 'EXCHANGE / REFUND/ RETURN POLICY\n(Online orders cannot be exchanged and returned in stores.)\n \n1. EXCHANGE: (ONLY VALID FOR DOMESTIC ORDERS)\nEligibility-\nYour purchase is eligible for exchange if it meets the following requirements-\n<ul>\n<li>If the product you received is damaged. (Please share a photograph of the damaged product at diasdiamonds.com within 7 days of receiving the product.)</li>\n<li>If the product you ordered needs to be exchanged in size. (If the new size requested is out of stock, we will issue a coupon code which will be valid for 6 months. This coupon code can be used to make a purchase for the same value or higher from our online store)</li>\n<li>If you don’t like the style of the product that you received.(In this case, we will issue a coupon code which will be valid for 6 months and can be used to make a purchase of the same value or higher. We will not limit your options, you will be able to choose from our complete online collection)</li>\n</ul>\n\nPolicy-\n<ul>\n<li>If your order is eligible for Exchange kindly inform us of the problem by sending us an email at info@diasdiamonds.com within 7 days of receiving the order. Our customer care team will get back to you within 48 hours.</li>\n<li>Products bought online cannot be exchanged in stores.</li>\n<li>The Exchange Process takes 9-18 days</li>\n<li>If your order is eligible for Exchange, we will schedule a pickup for the garments within 48 hours of receiving the email. All additional information will be provided via email.</li>\n<li>Please ensure the returned merchandise is unused and has the original packaging, price tag, and invoice.</li>\n<li>We allow multiple size exchanges if we have available stock in your required size.</li>\n<li>If the size you want in exchange is ‘Out of Stock’, you will be issued a coupon code which will be valid for 6 months. The coupon code issued can be used to make a purchase from our complete online collection for the same value or higher. </li>\n<li>All courier charges for exchanges will be borne by us.</li>\n</ul>\n2. RETURN/REFUND: (VALID FOR BOTH DOMESTIC AND INTERNATIONAL ORDERS)\n\nEligibility-\nYour purchase is eligible for a refund if it meets the following requirements-\n<ul>\n<li>In the event that you receive a product that is Damaged or Defective.</li>\n<li>In the case that we send the wrong style or size of a product from the one ordered.</li>\n</ul> \nPolicy-\n<ul>\n<li>If your order is eligible for Return/ Refund kindly inform us of the problem by sending us an email at info@diasdiamonds.com within 7 days of receiving the order. Our customer care team will get back to you within 48 hours.</li>\n<li>Products bought online cannot be returned in stores.</li>\n<li>The Refund Process takes 10-15 days.</li>\n<li>If your order is eligible for Return we will schedule a pickup for the garments within 48 hours of receiving the email. All additional information will be provided via email.</li>\n<li>Please ensure the returned merchandise is unused and has the original packaging, price tag, and invoice.</li>\n<li>All courier charges for return will be borne by us.</li>\n<li>Dias Diamonds reserves the right to inspect a returned product before processing the refund.</li>\n<li>In case of a Refund, the amount will be refunded using the same online mode of payment through which it was originally made within 15 days of the request being verified and subject to the issuing bank\'s policy. If the payment method was Cash on Delivery we will ask for your bank account details via your registered email address.</li>\n</ul> \n3. SALE PERIOD\n<ul>\n<li>We do not accept exchange and return on discounted products.</li>\n<li>We experience high volumes during the sale and will be unable to cancel any order due to shipment delays. However, we reserve the right to cancel an order on account of the non-availability of goods.</li>\n<li>All Duties &amp; Taxes for international orders will apply as per the rules of the shipping destination and will be borne by the customer.</li>\n<li>In case the product you received is damaged or in the wrong style from the one ordered. Please contact us via email at info@diasdiamonds.com</li>\n</ul>\n4. COUPON CODE:\n<ul>\n<li>To redeem a Coupon Code, please sign in to the account associated with the customer in whose name and email address the coupon code has been issued.</li>\n<li>The coupon code is sent to the email address the customer had registered with.</li>\n<li>The coupon code is only valid for the online store.</li>\n<li>The coupon code is valid for one-time use only, so please shop for more than the discounted amount as a remainder amount will not be carried forward.</li>\n<li>The coupon code is valid for six months. If the coupon code expires the amount will not be refunded and the coupon code will not be issued again, so please use it till it’s valid.</li>\n<li>Coupon code policies are subject to change at any time without prior notice.</li>\n</ul>\n', '2021-08-14', '2023-02-28'),
(4, 'about', 'Dias Diamonds is a renowned diamond retailer, offering a wide selection of both natural diamonds and lab-grown diamonds to customers worldwide. Based in Houston, Texas, we pride ourselves on providing exquisite diamonds that cater to a diverse range of preferences and budgets. With a commitment to quality, integrity, and exceptional customer service, we strive to create memorable experiences for each and every client.\nOur Expertise\nAt Dias Diamonds, we understand that diamonds are not just beautiful gemstones; they are cherished symbols of love, commitment, and celebration. With our extensive knowledge and expertise in the diamond industry, we ensure that every diamond we offer meets the highest standards of quality and craftsmanship. Whether you are seeking a classic engagement ring, a stunning pair of earrings, or a unique piece of diamond jewelry, we have a diverse collection to suit your individual taste and style.\nNatural Diamonds\nOur natural diamonds are sourced ethically and responsibly, adhering to strict industry standards. We understand the significance of each diamond purchase and offer a comprehensive selection of GIA (Gemological Institute of America) certified diamonds, ensuring transparency and authenticity. From exquisite solitaires to dazzling fancy cuts, our natural diamond collection showcases the timeless beauty and brilliance of these precious gemstones.\nLab-Grown Diamonds\nIn addition to our natural diamond offerings, we are proud to offer a stunning range of lab-grown diamonds. These diamonds are created using advanced scientific techniques that simulate the natural diamond-growing process. Our lab-grown diamonds possess the same physical and chemical properties as natural diamonds, providing a sustainable and affordable alternative without compromising on quality or beauty.\nWorldwide Reach\nDias Diamonds extends its services worldwide, bringing the brilliance of diamonds to customers across the globe. Our online platform offers a seamless shopping experience, enabling you to explore our extensive inventory, compare options, and make informed decisions from the comfort of your own home. We provide secure shipping and reliable delivery services, ensuring that your diamond reaches you safely and efficiently, no matter where you are in the world.\nExperience the Brilliance\nAt Dias Diamonds, we believe that every diamond has a unique story to tell. We invite you to explore our exceptional collection and discover the perfect diamond that resonates with your personal style and special moments. From engagement rings to anniversary gifts, we are honored to be a part of your significant milestones and help you celebrate life\'s most precious moments with brilliance and elegance.\nChoose Dias Diamonds, and let us accompany you on your journey to find the diamond of your dreams.', '2021-08-14', '2023-03-01');

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

--
-- Table structure for table `productpictures`
--

CREATE TABLE `productpictures` (
  `id` int(11) NOT NULL,
  `mykey` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `original` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productpictures`
--

INSERT INTO `productpictures` (`id`, `mykey`, `picture`, `original`, `position`, `createdate`, `modifieddate`, `action`) VALUES
(3, '3871f8e4562d9675d045be6fd0df8e44ed92bc401f516dc51dc616c23ed1b8b9', '193683_2_PicarioBig.jpg', 'new-one-1.jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(4, 'b997d23320bc3f59c1eb5836067cffa38c9f2dd1dbbad089f991704bcae78ee0', '193693_2_PicarioBig.jpg', '3.jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(5, 'b997d23320bc3f59c1eb5836067cffa38c9f2dd1dbbad089f991704bcae78ee0', '193693_3_PicarioBig.jpg', '2.jpg', 3, '2023-02-28', '2023-02-28', 'YES'),
(6, '4445e041f282f58ca6eeedecb5e37a7577b3030bb8c96da9569603ea044d8dd4', '193679_2_PicarioBig.jpg', 'L-1.jpg', 1, '2023-02-28', '2023-02-28', 'YES'),
(7, '4445e041f282f58ca6eeedecb5e37a7577b3030bb8c96da9569603ea044d8dd4', '193679_3_PicarioBig.jpg', 'L-2.jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(8, '0bcc64b1f64bc1c1584a93ba454a1fdf2935c05b30e42d8a83fcd472c7e0a680', '193708_2_PicarioBig.jpg', '1.jpg', 1, '2023-02-28', '2023-02-28', 'YES'),
(9, '0bcc64b1f64bc1c1584a93ba454a1fdf2935c05b30e42d8a83fcd472c7e0a680', '193708_3_PicarioBig.jpg', '3.jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(10, '9f612007292ceaee1bf62ae02eeb0b2419993355c839b236b994be7a80afe0e3', '193706_2_PicarioBig.jpg', 'L-1.jpg', 1, '2023-02-28', '2023-02-28', 'YES'),
(11, '9f612007292ceaee1bf62ae02eeb0b2419993355c839b236b994be7a80afe0e3', '193706_3_PicarioBig.jpg', 'L-2.jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(12, 'a5b4759427b16c5e5ec4aec877ac8f81252fee7d4de5bf6e97498255ac59b69d', '193702_2_PicarioBig.jpg', '1 (1).jpg', 1, '2023-02-28', '2023-02-28', 'YES'),
(13, 'a5b4759427b16c5e5ec4aec877ac8f81252fee7d4de5bf6e97498255ac59b69d', '193702_3_PicarioBig.jpg', '2 (1).jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(14, '56b91c637f57a16a27306965ab7ee1dd3dd3a4eaf7006446a70afad921e7995c', '182304_2_PicarioBig.jpg', 'TCL-1.jpg', 1, '2023-02-28', '2023-02-28', 'YES'),
(15, '56b91c637f57a16a27306965ab7ee1dd3dd3a4eaf7006446a70afad921e7995c', '182304_3_PicarioBig.jpg', 'TCL-2.jpg', 2, '2023-02-28', '2023-02-28', 'YES'),
(16, '98vdsb65vsddovjd6cbdb552', '1220-_4__4.jpg', '1220-_4__4.jpg', 2, '2023-06-29', '2023-06-29', 'YES'),
(17, '98vdsb65vsddovjd6cbdb552', 'd81b6aa1554b573252675316aa4316b644fec0216dac9f1fd19a8ca0c935550e.jpg', '2.jpg', 3, '2023-06-30', '2023-06-30', 'YES'),
(18, '98vdsb65vsddovjd6cbdb552', '1b0b4ba1d160ada1777196947f6569440dd66b0454f9c2a97f3187bde6dd33d0.jpg', '55.jpg', 4, '2023-06-30', '2023-06-30', 'YES'),
(19, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '392f245a5ed609b5ddea8a2ba640c3e14ba9198b6b16991b9e063ec145f2e587.jpg', 'SLLR00053-1__1143866455.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(20, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', 'fd932f9a8a41a9c6261abc1df95646d9dc9c72c796f0b5e8f26f5685fce03adc.jpg', 'SLLR00053-2__8588035.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(21, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '24370eaf3e904dde814df645ac0caa080ca0aec2e29a9daa5917192378750f9a.jpg', 'SLLR00053-6_374.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(22, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '3fcfcc6dcd503967b290dcbe039230d76af4668a485183edb1ac7790785dd66e.jpg', 'SLLR00053-3__283892778.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(23, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '1267dd85a40097d1ab4021c1dbb12cef7131ac700631e9db97d0ad17130167dd.jpg', 'GR00796-1__70407395.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(24, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '3cc2cd13b4d9ccefa84df0e7a6d9286024e8c7612086c2d8491a71bad7fd2418.jpg', 'GR00796-6_380.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(25, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', 'aba40a00faf0cbd214dbe525bbf1d46b77fdb3098349a22e34cbbbca6b2fb9be.jpg', 'SLLR00053-4__3157500.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(26, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '5b78c0b1ef9473ad893594b4c14ec7a1264fe843b60930a7b0a068a296b49581.jpg', 'GR00796-3__572894824.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(27, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '0e5ebdd5f1fa682ae1ce79110856dcae63e32f6f9d87d02c9bfa071386f69af7.jpg', 'GR00796-2__1255081561.jpg', 5, '2023-07-17', '2023-07-17', 'YES'),
(28, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', 'a79fe939fa41bc24c093b93541a95108bc21e2de2fbf9f384d7d76943dc1a6c1.png', 'download.png', 6, '2023-07-17', '2023-07-17', 'YES'),
(29, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', '86cf86569c91a036160cd5f94d0d592f7eb0fdaa52d7285acd3708591f3217be.jpg', 'BR00511-1__360046732.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(30, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', '59a5d65fc60417ea082f2eb4fd5066034ceb4997a91e60530a216adebc220041.jpg', 'BR00511-6_48.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(31, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', '02c360623ee5744c8b4fd2dda0a97cb69c5da68b8c9de24a52d09892c5300211.jpg', 'BR00511-3__932492837.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(32, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', 'ff3b82aa40cc718fda3a10666edf3f024c2777be9a0b7c18696a4612d7a6c75a.jpg', 'BR00511-2__1264145498.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(33, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', 'c81838b492595729e5247e58e877f5686e523c31e47a19efbefe6b3c148772ec.jpg', 'BR00511-4__647697853.jpg', 5, '2023-07-17', '2023-07-17', 'YES'),
(34, '9f4141d09febbcd7424ee8d719cbc5fc5189303198907bdd6d2211d3354d2f29', '37a13b73fe5cca72dfe7408235bb57b1fb2682a87905d8ae60ac9663ec7db582.jpg', 'ER01291-1_47.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(35, '9f4141d09febbcd7424ee8d719cbc5fc5189303198907bdd6d2211d3354d2f29', 'a1308f7f9deb97046a0cf1cd49047a801e371090515d53af2be0330d6c6748ba.jpg', 'ER01291-2__398465721.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(36, '9f4141d09febbcd7424ee8d719cbc5fc5189303198907bdd6d2211d3354d2f29', '73ef64fa85e5ef3c939ce4b6a8d1f59f5de38e65c83e78c66dc1738e2b47c611.jpg', 'ER01291-3__957637461.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(37, '9f4141d09febbcd7424ee8d719cbc5fc5189303198907bdd6d2211d3354d2f29', '54d4696063a44e65dbe2aa3826bbdfbdfbeeea98544c0e54ef922e76f93dafca.jpg', 'ER01291-4__1500445719.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(38, '0a745e306a48773a8ffb4c8457a84917419991550f689e9a53a2400dace8eb5f', '2955bf451fdd34d53522e4f00545d6116d8cfcfa16b2f4e1c76fc3454bfa2792.jpg', 'DS00042P-3__1589792352.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(39, '0a745e306a48773a8ffb4c8457a84917419991550f689e9a53a2400dace8eb5f', 'd67a9643801fb1aa277c8969e0d58f20cc224bee3bc9ad58efe4b6afbbd6f883.jpg', 'DS00042P-1_795.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(40, '0a745e306a48773a8ffb4c8457a84917419991550f689e9a53a2400dace8eb5f', 'da9fa1d14097a4a532a1274a0a335d97df8a3efd8b26cce1b64e43102cc6f0b4.jpg', 'DS00042P-2__187667834.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(41, '0a745e306a48773a8ffb4c8457a84917419991550f689e9a53a2400dace8eb5f', '6e0b5cfece0c990b1dc179b1e434806442c5abec6228a158b1ce26444917d10d.jpg', 'DS00042P-4__1238906360.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(42, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '2e12620b28fbff8f33d21c104544e5716cbe4ba047f47e4c45da97418ba511f9.jpg', 'GR00331-1__1225975550.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(43, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', 'bd1bddb24f5040e9b64be632f79a93ed56b62729d5cb77ab92c390f97f5fb9ae.jpg', 'GR00331-6_998.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(44, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '5e030a77117bba74ffb21bdfe981c08b6a865ab2b2e7235a352c2b82d09a3351.jpg', 'GR00331-5__838419521.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(45, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', 'd861ee3db85f680dbb1f94e8506742ee928436b04ba29566c55311e36afb41e1.jpg', 'GR00331-2__1932973674.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(46, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', 'c1cee64313c8e58fb59d28c775a1723f97a0496b5c9919216ffe966a12983c2e.jpg', 'GR00143-1__1390560965.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(47, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '7db385b935a31af9ec250652affdcac20e925f302a4a2907e9b013f89a73405b.jpg', 'GR00143-3__122502276.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(48, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '1f8ba05bfa7aa79df16fd9047528b676623584b4a3efa75c960c1eef762b1a19.jpg', 'GR00143-6_882.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(49, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '1ffab3dcbd68800d9f406eabec79e34e8d70b8cd4fce7543e1340d8e64d18d6c.jpg', 'GR00143-2__539056029.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(50, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', 'f92c72d10deef671c732e0c6ba1016a83e7c74800765ff3c46abdecbacf9796f.jpg', 'GR00808-1__969387310.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(51, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', 'c45b2de7dbfcb4cdad1c167fc3b2597773d49aec02f62aae67824a3eb3d69f0d.jpg', 'GR00808-6_940.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(52, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '3986b39a2569839bab2eb0ca201dd153f7d3213f2f35dd122c4f0dd89701e238.jpg', 'GR00808-2__1091981198.jpg', 3, '2023-07-17', '2023-07-17', 'YES'),
(53, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '739e5d82054d49f486a09bd5cc629c25add10f5d3084552501d259bf414d0aba.jpg', 'GR00808-3__1633368113.jpg', 4, '2023-07-17', '2023-07-17', 'YES'),
(54, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', 'd35bc948ac16688a9e3ec55356609337d70f3acef2a841e1d1d8a8697d0e4353.jpg', 'LR01786-1__396700571.jpg', 1, '2023-07-17', '2023-07-17', 'YES'),
(55, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', '23cc54d9df7f28d9106ba01cf28331f3912cd108ed2471a925acf68bb4f1a94a.jpg', 'LR01786-3__292303729.jpg', 2, '2023-07-17', '2023-07-17', 'YES'),
(56, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', '5d02cd5f3cd4d1e6d4676ce3a37a048f8e4c21fe4f93e0928f3a8155e4c129db.jpg', 'LR01786-4__735160013.jpg', 3, '2023-07-17', '2023-07-17', 'YES');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `mykey` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `subcategory` varchar(255) NOT NULL,
  `metatitle` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `metakeyword` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `metadescription` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `picture1` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `subname` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `diamondshape` varchar(255) NOT NULL,
  `diamondweight` varchar(255) NOT NULL,
  `metal` varchar(255) NOT NULL,
  `metalweight` varchar(255) NOT NULL,
  `clarity` varchar(255) NOT NULL,
  `polish` varchar(255) NOT NULL,
  `similar` varchar(255) NOT NULL,
  `shopthelook` varchar(255) NOT NULL,
  `bundle` varchar(255) NOT NULL,
  `mrp` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `discount` int(11) NOT NULL,
  `tax` varchar(255) NOT NULL,
  `shortdescription` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `description` longtext NOT NULL,
  `sizechart` varchar(255) NOT NULL,
  `visits` int(6) NOT NULL DEFAULT 1,
  `luxury` varchar(255) NOT NULL DEFAULT 'NO',
  `newarrival` varchar(255) NOT NULL DEFAULT 'NO',
  `action` varchar(255) NOT NULL DEFAULT 'YES',
  `removed` varchar(255) NOT NULL DEFAULT 'NO',
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`id`, `mykey`, `url`, `category`, `subcategory`, `metatitle`, `metakeyword`, `metadescription`, `picture1`, `name`, `subname`, `sku`, `color`, `diamondshape`, `diamondweight`, `metal`, `metalweight`, `clarity`, `polish`, `similar`, `shopthelook`, `bundle`, `mrp`, `price`, `discount`, `tax`, `shortdescription`, `description`, `sizechart`, `visits`, `luxury`, `newarrival`, `action`, `removed`, `createdate`, `modifieddate`) VALUES
(1, '3871f8e4562d9675d045be6fd0df8e44ed92bc401f516dc51dc616c23ed1b8b9', 'tremolo-curtains', 'Curtains', 'Leaves Curtains', 'Tremolo Curtains', 'Tremolo Curtains', 'Tremolo Curtains', '193683_1_PicarioBig.jpg', 'Tremolo Curtains', 'Curtains Store Gurgaon', 'DS1002', 'PINK', '', '', '', '', '', '', '', '', '', 1499, 1499, 0, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 59, '', 'YES', 'NO', 'YES', '2023-02-28', '2023-02-28'),
(2, 'b997d23320bc3f59c1eb5836067cffa38c9f2dd1dbbad089f991704bcae78ee0', 'cecelia-curtains', 'Curtains', 'Leaves Curtains', 'Cecelia Curtains', 'Cecelia Curtains', 'Cecelia Curtains', '193693_1_PicarioBig.jpg', 'Cecelia Curtains', 'Curtains Store Gurgaon', 'DS1003', 'BROWN', '', '', '', '', '', '', '', '', '', 1349, 1349, 0, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 64, '', 'YES', 'NO', 'YES', '2023-02-28', '2023-02-28'),
(3, '4445e041f282f58ca6eeedecb5e37a7577b3030bb8c96da9569603ea044d8dd4', 'cupola-curtains', 'Curtains', 'Leaves Curtains', 'Cupola Curtains', 'Cupola Curtains', 'Cupola Curtains', '193679_1_PicarioBig.jpg', 'Cupola Curtains', 'Curtains Store Gurgaon', 'DS1004', 'CREAM', '', '', '', '', '', '', '', '', '', 1749, 1749, 0, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 61, '', 'YES', 'NO', 'YES', '2023-02-28', '2023-02-28'),
(4, '0bcc64b1f64bc1c1584a93ba454a1fdf2935c05b30e42d8a83fcd472c7e0a680', 'masami-curtains', 'Curtains', 'Floral Curtains', 'Masami Curtains', 'Masami Curtains', 'Masami Curtains', '193708_1_PicarioBig.jpg', 'Masami Curtains', 'Curtains Store Gurgaon', 'DS1005', 'TURQUOISE', '', '', '', '', '', '', '', '', '', 1349, 1349, 0, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 60, '', 'YES', 'NO', 'YES', '2023-02-28', '2023-02-28'),
(5, '9f612007292ceaee1bf62ae02eeb0b2419993355c839b236b994be7a80afe0e3', 'olene-curtains', 'Curtains', 'Geometric Curtains', 'Olene Curtains', 'Olene Curtains', 'Olene Curtains', '193706_2_PicarioBig.jpg', 'Olene Curtains', 'Curtains Store Gurgaon', 'DS1006', 'TURQUOISE', '', '', '', '', '', '', '', '', '', 20, 10, 50, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 66, 'NO', 'YES', 'NO', 'YES', '2023-02-28', '2023-06-30'),
(6, 'a5b4759427b16c5e5ec4aec877ac8f81252fee7d4de5bf6e97498255ac59b69d', 'hibano-curtains', 'Curtains', 'Floral Curtains', 'Hibano Curtains', 'Hibano Curtains', 'Hibano Curtains', '193702_1_PicarioBig.jpg', 'Hibano Curtains', 'Curtains Store Gurgaon', 'DS1007', 'BEIGE', '', '', '', '', '', '', '', '', '', 1299, 1299, 0, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 60, 'NO', 'YES', 'NO', 'YES', '2023-02-28', '2023-02-28'),
(7, '56b91c637f57a16a27306965ab7ee1dd3dd3a4eaf7006446a70afad921e7995c', 'kalopsia-curtains', 'Curtains', 'Small Motifs Curtains', 'Kalopsia Curtains', 'Kalopsia Curtains', 'Kalopsia Curtains', '182304_1_PicarioBig_1_1.jpg', 'Kalopsia Curtains', 'Curtains Store Gurgaon', 'DS1008', 'WHITE', '', '', '', '', '', '', '', '', '', 1549, 1549, 0, '5', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain (1 N): 1.35 m x 2.25 m', 'Curtain', 63, 'NO', 'YES', 'NO', 'YES', '2023-02-28', '2023-02-28'),
(8, '98vdsb65vsddovjd6cbdb552', 'misiana-linen', 'Blinds', 'Roller Blind', 'Misiana Linen Roller Blind', 'Misiana Linen Roller Blind', 'Misiana Linen Roller Blind', '1220-_4__2.jpg', 'Misiana Linen', 'Roller Blind Store Gurgaon', 'DS1009', 'GREY', '', '', '', '', '', '', '', '', '', 4495, 4495, 0, '5', 'UOM for thickness(MM): 0.5\r\nWeight (GSM): 395', 'UOM for thickness(MM): 0.5\r\nWeight (GSM): 395', 'Roller Blinds', 2, 'NO', 'YES', 'NO', 'YES', '2023-06-29', '2023-06-29'),
(9, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', 'the-coira-solitaire-diamond-ringdd001', 'Diamonds', 'Rings', 'The Coira Solitaire Diamond Ring', 'The Coira Solitaire Diamond Ring', 'The Coira Solitaire Diamond Ring', '392f245a5ed609b5ddea8a2ba640c3e14ba9198b6b16991b9e063ec145f2e587.jpg', 'The Coira Solitaire Diamond Ring', 'The Coira Solitaire Diamond Ring', 'DD001', 'WHITE', 'Round Diamond', '0.9CT', 'WHITE GOLD', '3.04 g', 'IJ-SI', '', '', '', '', 5164, 5164, 0, '0', '', '<div> </div>', '', 2, 'NO', 'YES', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(10, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', 'the-neason-diamond-ringdd002', 'Diamonds', 'Wedding Band', 'The Neason Diamond Ring', 'The Neason Diamond Ring', 'The Neason Diamond Ring', 'new1267dd85a40097d1ab4021c1dbb12cef7131ac700631e9db97d0ad17130167dd.jpg', 'The Neason Diamond Ring', 'The Neason Diamond Ring', 'DD002', 'WHITE', 'Round Diamond', '0.06CT', 'WHITE GOLD', '4.54 g', 'IJ-SI', '', '', '', '', 370, 295, 20, '0', '', '<div> </div>', '', 2, 'NO', 'YES', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(11, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', 'the-diamond-bracelet-br00511-ships-fasterdd003', 'Diamonds', 'Braceletes', 'The Diamond Bracelet BR00511 Ships Faster', 'The Diamond Bracelet BR00511 Ships Faster', 'The Diamond Bracelet BR00511 Ships Faster', 'new86cf86569c91a036160cd5f94d0d592f7eb0fdaa52d7285acd3708591f3217be.jpg', 'The Diamond Bracelet BR00511 Ships Faster', 'The Diamond Bracelet BR00511 Ships Faster', 'DD003', 'ALL COLOR', 'Round Diamond', '0.15CT', 'YELLOW GOLD', '2.186 g', 'KL-I', '', '', '', '', 200, 200, 0, '0', '', '<div> </div>', '', 2, 'NO', 'NO', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(12, '9f4141d09febbcd7424ee8d719cbc5fc5189303198907bdd6d2211d3354d2f29', 'the-lida-diamond-earringsdd004', 'Diamonds', 'Earrings', 'The Lida Diamond Earrings', 'The Lida Diamond Earrings', 'The Lida Diamond Earrings', 'new37a13b73fe5cca72dfe7408235bb57b1fb2682a87905d8ae60ac9663ec7db582.jpg', 'The Lida Diamond Earrings', 'The Lida Diamond Earrings', 'DD004', 'YELLOW', 'Round Diamond', '0.024CT', 'YELLOW GOLD', '3.66 g', 'IJ-SI', '', '', '', '', 1010, 808, 20, '0', '', '<div> </div>', '', 1, 'NO', 'YES', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(13, '0a745e306a48773a8ffb4c8457a84917419991550f689e9a53a2400dace8eb5f', 'the-erneszt-diamond-necklacedd005', 'Diamonds', 'Necklaces', 'The Erneszt Diamond Necklace', 'The Erneszt Diamond Necklace', 'The Erneszt Diamond Necklace', 'new2955bf451fdd34d53522e4f00545d6116d8cfcfa16b2f4e1c76fc3454bfa2792.jpg', 'The Erneszt Diamond Necklace', 'The Erneszt Diamond Necklace', 'DD005', 'WHITE', 'Round Diamond', '0.324', 'YELLOW GOLD', '9.51 g', 'IJ-SI', '', '', '', '', 1132, 870, 23, '0', '', '<div> </div>', '', 1, 'NO', 'YES', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(14, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', 'the-cole-diamond-ringdd006', 'Diamonds', 'Wedding Band', 'The Cole Diamond Ring', 'The Cole Diamond Ring', 'The Cole Diamond Ring', 'new2e12620b28fbff8f33d21c104544e5716cbe4ba047f47e4c45da97418ba511f9.jpg', 'The Cole Diamond Ring', 'The Cole Diamond Ring', 'DD006', 'YELLOW', 'Round Diamond', '0.528CT', 'YELLOW GOLD', '3.49 g', 'IJ-SI', '', '', '', '', 1280, 1280, 0, '0', '', '<div> </div>', '', 1, 'NO', 'YES', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(15, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', 'the-roy-diamond-ringdd007', 'Diamonds', 'Wedding Band', 'The Roy Diamond Ring', 'The Roy Diamond Ring', 'The Roy Diamond Ring', 'newc1cee64313c8e58fb59d28c775a1723f97a0496b5c9919216ffe966a12983c2e.jpg', 'The Roy Diamond Ring', 'The Roy Diamond Ring', 'DD007', 'ALL COLOR', 'Round Diamond', '0.336CT', 'YELLOW GOLD', '4.59 g', 'IJ-SI', '', '', '', '', 690, 690, 0, '0', '', '<div> </div>', '', 1, 'NO', 'YES', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(16, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', 'the-obharnait-diamond-ringdd008', 'Diamonds', 'Wedding Band', 'The Obharnait Diamond Ring', 'The Obharnait Diamond Ring', 'The Obharnait Diamond Ring', 'newf92c72d10deef671c732e0c6ba1016a83e7c74800765ff3c46abdecbacf9796f.jpg', 'The Obharnait Diamond Ring', 'The Obharnait Diamond Ring', 'DD008', 'GREY', 'Round Diamond', '0.044', 'ROSE GOLD', '5.76 g', 'IJ-SI', '', '', '', '', 435, 435, 0, '0', '', '<div> </div>', '', 2, 'NO', 'NO', 'YES', 'NO', '2023-07-17', '2023-07-17'),
(17, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', 'the-niallan-diamond-ringdd009', 'Diamonds', 'Rings', 'The Niallan Diamond Ring', 'The Niallan Diamond Ring', 'The Niallan Diamond Ring', 'newd35bc948ac16688a9e3ec55356609337d70f3acef2a841e1d1d8a8697d0e4353.jpg', 'The Niallan Diamond Ring', 'The Niallan Diamond Ring', 'DD009', 'ALL COLOR', 'Round Diamond', '0.23', 'WHITE GOLD', '1.73 g', 'IJ-SI', '', '', '', '', 490, 490, 0, '0', '', '<div> </div>', '', 1, 'NO', 'NO', 'YES', 'NO', '2023-07-17', '2023-07-17');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `product` varchar(255) NOT NULL,
  `rating` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `date` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'NO'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `roles`
--

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

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`) VALUES
(1, 'Page'),
(2, 'Size Charts'),
(3, 'Size Measurement'),
(4, 'Tax Rules'),
(5, 'Sliders'),
(6, 'Color'),
(8, 'Categories'),
(9, 'Users'),
(10, 'Products'),
(11, 'Report'),
(12, 'Sales'),
(13, 'Marketing'),
(14, 'User Permissions'),
(15, 'Integration'),
(16, 'Notifications'),
(17, 'Stores'),
(18, 'Metals'),
(19, 'Shapes');

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

--
-- Table structure for table `shapes`
--

CREATE TABLE `shapes` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `createdate` date DEFAULT NULL,
  `modifieddate` date DEFAULT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `shapes`
--

INSERT INTO `shapes` (`id`, `name`, `picture`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'Round Diamond', 'round-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(2, 'Princess Diamond', 'princess-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(3, 'Emerald Diamond', 'emerald-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(4, 'Asscher Diamond', 'asscher-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(5, 'Oval Diamond', 'oval-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(6, 'Radiant Diamond', 'radiant-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(7, 'Pear Diamond', 'pear-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(8, 'Heart Diamond', 'heart-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(9, 'Marquise Diamond', 'marquise-diamond.png', '2023-07-13', '2023-07-13', 'YES'),
(10, 'Cushion Diamond', 'cushion-diamond.png', '2023-07-13', '2023-07-13', 'YES');

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

--
-- Table structure for table `sizecharts`
--

CREATE TABLE `sizecharts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sizecharts`
--

INSERT INTO `sizecharts` (`id`, `name`, `picture`, `createdate`, `modifieddate`) VALUES
(2, 'Diamond', 'roller-blind.jpg', '2023-06-29', '2023-07-17');

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

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES',
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sizes`
--

INSERT INTO `sizes` (`id`, `name`, `action`, `createdate`, `modifieddate`) VALUES
(1, '8', 'YES', '2023-07-17', '2023-07-17'),
(2, '7', 'YES', '2023-07-17', '2023-07-17'),
(3, '9', 'YES', '2023-07-17', '2023-07-17'),
(4, '10', 'YES', '2023-07-17', '2023-07-17'),
(5, '11', 'YES', '2023-07-17', '2023-07-17'),
(6, '12', 'YES', '2023-07-17', '2023-07-17'),
(7, '13', 'YES', '2023-07-17', '2023-07-17'),
(8, '13', 'YES', '2023-07-17', '2023-07-17'),
(9, '14', 'YES', '2023-07-17', '2023-07-17'),
(10, '15', 'YES', '2023-07-17', '2023-07-17'),
(11, '16', 'YES', '2023-07-18', '2023-07-18'),
(12, 'STANDARD', 'YES', '2023-07-17', '2023-07-17');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `bannermobile` varchar(255) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `url`, `picture`, `bannermobile`, `createdate`, `modifieddate`, `action`) VALUES
(5, '', 'slider1.jpg', 'slider1.jpg', '2023-02-24', '2023-02-24', 'YES'),
(6, '', 'slider2.jpg', 'slider2.jpg', '2023-02-24', '2023-02-24', 'YES'),
(27, '', 'slider3.jpg', 'slider3.jpg', '2023-07-15', '2023-07-15', 'YES');

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

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

CREATE TABLE `states` (
  `id` int(10) UNSIGNED NOT NULL,
  `state` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `states` (`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'),
(36, 'Telangana');

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

--
-- Table structure for table `stocks`
--

CREATE TABLE `stocks` (
  `id` int(11) NOT NULL,
  `mykey` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `quantity` int(10) NOT NULL,
  `minimumstock` int(11) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stocks`
--

INSERT INTO `stocks` (`id`, `mykey`, `size`, `price`, `quantity`, `minimumstock`, `createdate`, `modifieddate`) VALUES
(3, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '7', 5164, 10, 5, '2023-07-17', '2023-07-17'),
(4, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '8', 0, 10, 5, '2023-07-17', '2023-07-17'),
(5, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '9', 0, 10, 5, '2023-07-17', '2023-07-17'),
(6, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '10', 0, 10, 5, '2023-07-17', '2023-07-17'),
(7, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '7', 295, 10, 5, '2023-07-17', '2023-07-17'),
(8, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '8', 0, 10, 5, '2023-07-17', '2023-07-17'),
(9, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '9', 0, 10, 5, '2023-07-17', '2023-07-17'),
(10, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '10', 0, 10, 5, '2023-07-17', '2023-07-17'),
(11, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', 'STANDARD', 200, 10, 5, '2023-07-17', '2023-07-17'),
(12, '9f4141d09febbcd7424ee8d719cbc5fc5189303198907bdd6d2211d3354d2f29', 'STANDARD', 808, 10, 5, '2023-07-17', '2023-07-17'),
(13, '0a745e306a48773a8ffb4c8457a84917419991550f689e9a53a2400dace8eb5f', 'STANDARD', 870, 10, 5, '2023-07-17', '2023-07-17'),
(14, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '7', 1280, 10, 5, '2023-07-17', '2023-07-17'),
(15, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '8', 0, 10, 5, '2023-07-17', '2023-07-17'),
(16, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '9', 0, 10, 5, '2023-07-17', '2023-07-17'),
(17, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '10', 0, 10, 5, '2023-07-17', '2023-07-17'),
(18, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '11', 0, 10, 5, '2023-07-17', '2023-07-17'),
(19, '656b40da2ba11b0f6a5e813f6132365652a31c59ffbb096476b84e7ae29cbb96', '12', 0, 10, 5, '2023-07-17', '2023-07-17'),
(20, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '10', 690, 10, 5, '2023-07-17', '2023-07-17'),
(21, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '11', 0, 10, 5, '2023-07-17', '2023-07-17'),
(22, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '12', 0, 10, 5, '2023-07-17', '2023-07-17'),
(23, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '13', 0, 10, 5, '2023-07-17', '2023-07-17'),
(24, 'b336a12acc15499a2b8443d6d6cc54069a63a1d42bc7d9aab0ddc3c18162719e', '14', 0, 10, 5, '2023-07-17', '2023-07-17'),
(25, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '11', 435, 10, 5, '2023-07-17', '2023-07-17'),
(26, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '12', 0, 10, 5, '2023-07-17', '2023-07-17'),
(27, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '13', 0, 10, 5, '2023-07-17', '2023-07-17'),
(28, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '14', 0, 10, 5, '2023-07-17', '2023-07-17'),
(29, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '15', 0, 10, 5, '2023-07-17', '2023-07-17'),
(30, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', '12', 490, 10, 5, '2023-07-17', '2023-07-17'),
(31, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', '13', 0, 10, 5, '2023-07-17', '2023-07-17'),
(32, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', '14', 0, 10, 5, '2023-07-17', '2023-07-17'),
(33, '64e84693c243848c63fcd1171356a294810093c57d80ecf620b54768167eeb4f', '15', 0, 10, 5, '2023-07-17', '2023-07-17');

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

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` int(11) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `address` longtext NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `direction` varchar(255) NOT NULL,
  `createdate` date DEFAULT NULL,
  `modifieddate` date DEFAULT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `stores`
--

INSERT INTO `stores` (`id`, `picture`, `city`, `address`, `email`, `phone`, `direction`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'store-1.jpg', 'Houston', '6222 Richmond Avenue, Suite 447, Houston, Texas 77057, United States', 'info@diasdiamonds.com', '18326439131', 'https://goo.gl/maps/EhN8KYcR3Bsbua6z8', '2023-02-20', '2023-06-30', 'YES');

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

--
-- Table structure for table `subadmin`
--

CREATE TABLE `subadmin` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` longtext NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategories`
--

CREATE TABLE `subcategories` (
  `id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `metatitle` varchar(255) NOT NULL,
  `metakeyword` varchar(255) NOT NULL,
  `metadescription` longtext NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `homevisible` varchar(255) NOT NULL DEFAULT 'YES',
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subcategories`
--

INSERT INTO `subcategories` (`id`, `category`, `name`, `picture`, `metatitle`, `metakeyword`, `metadescription`, `description`, `homevisible`, `createdate`, `modifieddate`, `action`) VALUES
(1, 'Diamonds', 'Rings', 'rings-banner.jpg', 'Diamonds Rings', 'Diamonds Rings', 'Diamonds Rings', 'Diamonds Rings', 'YES', '2023-02-28', '2023-02-28', 'YES'),
(2, 'Diamonds', 'Necklaces', 'necklaces-banner.jpg', 'Diamonds Necklaces', 'Diamonds Necklaces', 'Diamonds Necklaces', 'Diamonds Necklaces', 'YES', '2023-02-28', '2023-02-28', 'YES'),
(3, 'Diamonds', 'Braceletes', 'braceletes-banner.jpg', 'Diamonds Braceletes', 'Diamonds Braceletes', 'Diamonds Braceletes', 'Diamonds Braceletes', 'YES', '2023-05-06', '2023-05-06', 'YES'),
(4, 'Diamonds', 'Wedding Band', 'wedding-band.jpg', 'Diamond Wedding Band', 'Diamond Wedding Band', 'Diamond Wedding Band', 'Diamond Wedding Band', 'YES', '2023-05-06', '2023-05-06', 'YES'),
(5, 'Diamonds', 'Earrings', 'earrings-banner.jpg', 'Diamonds Earrings', 'Diamonds Earrings', 'Diamonds Earrings', 'Diamonds Earrings', 'YES', '2023-05-06', '2023-05-06', 'YES');

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `value`, `createdate`, `modifieddate`, `action`) VALUES
(10, 'TAX FREE', '0', '2023-07-17', '2023-07-17', 'YES');

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `product` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'YES',
  `createdate` date NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `platformid` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `token` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'NO'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `mobile`, `password`, `platform`, `platformid`, `date`, `token`, `action`) VALUES
(2, 'PRAMESHWER', 'butigod91@gmail.com', '', 'f0dc85bd1cd804d0d22b5ad5a16f19543800d991392a9786b77dbb702b9d6e68', 'Website', '', '2023-06-30', '84766', 'YES');

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

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `id` int(11) NOT NULL,
  `mykey` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `visits`
--

INSERT INTO `visits` (`id`, `mykey`, `ip`) VALUES
(8, '', '::1'),
(9, '56b91c637f57a16a27306965ab7ee1dd3dd3a4eaf7006446a70afad921e7995c', '::1'),
(10, '', '::1'),
(11, '', '::1'),
(12, 'dc684b3c0e37d1afed66e26073dd5185faee004c2c09fbff379829d69d2043f9', '::1'),
(13, 'c9d2c094371ffd1fab07d655b9cbd8313cd5fba25a796eb04d53dd66afba6345', '::1'),
(14, '3e64901fd0421ff42937d7e634546a6f84bf012a25c9e176247c4f9a8e7619e2', '::1'),
(15, '31f52aef98569fad4a449847e64a45c8291a8b7504fc91c02de437f62d050613', '::1');

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

--
-- Table structure for table `wishlists`
--

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

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

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

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

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

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

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

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

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

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

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

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

[ Cancelar ]

Nome	Permissões	Ações
[ .. Voltar ]
📄 .editorconfig	0644	[ EDITAR/VER ]
📄 .gitattributes	0644	[ EDITAR/VER ]
📄 .gitignore	0644	[ EDITAR/VER ]
📄 .htaccess	0644	[ EDITAR/VER ]
📄 .travis.yml	0644	[ EDITAR/VER ]
📁 .well-known/	0755
📁 adminarea/	0755
📁 bin/	0755
📁 config/	0755
📁 data/	0755
📄 diasdiamonds.sql	0644	[ EDITAR/VER ]
📁 fb/	0755
📁 google/	0755
📄 imp.txt	0644	[ EDITAR/VER ]
📄 index.php	0644	[ EDITAR/VER ]
📁 logs/	0755
📁 plugins/	0755
📄 pro.php	0644	[ EDITAR/VER ]
📁 src/	0755
📁 tests/	0755
📁 tmp/	0755
📁 vendor/	0755
📁 webroot/	0755

📍 /home/diasdiamonds/public_html

📝 Editando: diasdiamonds.sql