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

START TRANSACTION;



--
-- Database: `downgrade`
--

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

--
-- Table structure for table `attributes`
--

CREATE TABLE `attributes` (
  `attr_id` int(11) NOT NULL,
  `attr_label` varchar(500) DEFAULT NULL,
  `attr_field_type` varchar(100) DEFAULT NULL,
  `attr_field_value` text DEFAULT NULL,
  `attr_field_order` int(100) NOT NULL,
  `attr_field_status` int(100) NOT NULL,
  `attr_drop_status` varchar(50) DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `attributes`
--

INSERT INTO `attributes` (`attr_id`, `attr_label`, `attr_field_type`, `attr_field_value`, `attr_field_order`, `attr_field_status`, `attr_drop_status`) VALUES
(32, 'Package Includes', 'multi-select', 'CSS,HTML', 1, 1, 'no'),
(33, 'Compatible Browsers', 'multi-select', 'Opera,Safari,Chrome,Firefox,Internet Explorer', 2, 1, 'no');

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `blog_cat_id` int(11) NOT NULL,
  `blog_category_name` varchar(500) NOT NULL,
  `blog_category_slug` varchar(500) NOT NULL,
  `blog_category_status` int(20) NOT NULL,
  `drop_status` varchar(20) NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`blog_cat_id`, `blog_category_name`, `blog_category_slug`, `blog_category_status`, `drop_status`) VALUES
(11, 'Creative', 'Creative', 1, 'no'),
(12, 'Featured', 'Featured', 1, 'no'),
(13, 'Hobbies', 'Hobbies', 1, 'no'),
(14, 'International', 'International', 1, 'no'),
(15, 'Lifestyle', 'Lifestyle', 1, 'no'),
(16, 'Travel', 'Travel', 1, 'no');

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

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

CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL,
  `category_name` varchar(200) NOT NULL,
  `category_slug` varchar(200) NOT NULL,
  `category_meta_keywords` text DEFAULT NULL,
  `category_meta_desc` text DEFAULT NULL,
  `category_status` int(50) NOT NULL,
  `display_order` int(50) NOT NULL,
  `drop_status` varchar(50) NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `category` (`cat_id`, `category_name`, `category_slug`, `category_meta_keywords`, `category_meta_desc`, `category_status`, `display_order`, `drop_status`) VALUES
(27, 'Scripts', 'scripts', '', '', 1, 1, 'no'),
(28, 'Themes', 'themes', '', '', 1, 2, 'no'),
(29, 'Plugins', 'plugins', '', '', 1, 3, 'no'),
(30, 'Print', 'print', '', '', 1, 4, 'no'),
(31, 'Graphics', 'graphics', '', '', 1, 5, 'no'),
(32, 'Mobile Apps', 'mobile-apps', '', '', 1, 6, 'no');

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

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

CREATE TABLE `contact` (
  `cid` int(11) NOT NULL,
  `from_name` varchar(200) NOT NULL,
  `from_email` varchar(200) NOT NULL,
  `message_text` text NOT NULL,
  `contact_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `contact` (`cid`, `from_name`, `from_email`, `message_text`, `contact_date`) VALUES
(2, 'parker', 'parker@gmail.com', 'hello sample message', '2019-10-04'),
(3, 'test', 'test@test.com', 'test', '2019-10-07'),
(4, 'tester', 'tester@gnauk.com', 'tester', '2023-03-01');

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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `country_id` int(11) NOT NULL,
  `country_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `country`
--

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

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

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `coupon_id` int(11) NOT NULL,
  `user_id` int(100) NOT NULL,
  `coupon_type` varchar(191) NOT NULL DEFAULT 'product',
  `coupon_code` varchar(200) DEFAULT NULL,
  `discount_type` varchar(100) DEFAULT NULL,
  `coupon_value` float NOT NULL,
  `coupon_start_date` varchar(200) DEFAULT NULL,
  `coupon_end_date` varchar(200) DEFAULT NULL,
  `coupon_status` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `coupon`
--

INSERT INTO `coupon` (`coupon_id`, `user_id`, `coupon_type`, `coupon_code`, `discount_type`, `coupon_value`, `coupon_start_date`, `coupon_end_date`, `coupon_status`) VALUES
(40, 1, 'product', 'DEAL', 'fixed', 10, '2023-05-26', '2023-06-30', 1),
(41, 1, 'subscription', 'BEST', 'percentage', 10, '2023-05-26', '2023-06-30', 1);

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

--
-- Table structure for table `development_logo`
--

CREATE TABLE `development_logo` (
  `logo_id` int(11) NOT NULL,
  `logo_image` varchar(200) NOT NULL,
  `logo_order` int(50) NOT NULL DEFAULT 0,
  `logo_status` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `development_logo`
--

INSERT INTO `development_logo` (`logo_id`, `logo_image`, `logo_order`, `logo_status`) VALUES
(4, '1570022081.jpg', 1, 1),
(5, '1570022094.jpg', 2, 1),
(6, '1570022281.jpg', 3, 1),
(7, '1570022437.jpg', 4, 1),
(8, '1570022552.jpg', 5, 1);

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

--
-- Table structure for table `email_template`
--

CREATE TABLE `email_template` (
  `et_id` int(10) UNSIGNED NOT NULL,
  `et_heading` text DEFAULT NULL,
  `et_subject` text DEFAULT NULL,
  `et_content` longtext DEFAULT NULL,
  `et_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1);

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

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

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `page_title` varchar(500) NOT NULL,
  `page_desc` mediumtext NOT NULL,
  `page_slug` varchar(200) NOT NULL,
  `main_menu` int(50) NOT NULL DEFAULT 0,
  `footer_menu` int(50) NOT NULL DEFAULT 0,
  `menu_order` int(50) NOT NULL,
  `page_status` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `pages` (`page_id`, `page_title`, `page_desc`, `page_slug`, `main_menu`, `footer_menu`, `menu_order`, `page_status`) VALUES
(7, 'About Us', '&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;', 'about-us', 1, 1, 1, 1),
(11, 'Faq', '&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;', 'faq', 0, 1, 2, 1),
(12, 'Terms and conditions', '&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;', 'terms-and-conditions', 1, 1, 3, 1),
(13, 'Privacy Policy', '&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;', 'privacy-policy', 1, 1, 4, 1),
(14, 'What does support include?', '&lt;p&gt;&lt;strong&gt;Regular License&lt;/strong&gt;&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;\r\n&lt;p&gt;&lt;strong&gt;Extended License&lt;/strong&gt;&lt;/p&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum&lt;/p&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;', 'what-does-support-include', 0, 0, 0, 1);

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

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

CREATE TABLE `post` (
  `post_id` int(11) NOT NULL,
  `post_title` varchar(1000) NOT NULL,
  `post_slug` varchar(200) NOT NULL,
  `blog_cat_id` int(100) NOT NULL,
  `post_short_desc` text NOT NULL,
  `post_image` varchar(200) NOT NULL,
  `post_desc` longtext NOT NULL,
  `post_date` date NOT NULL,
  `post_view` int(100) NOT NULL DEFAULT 0,
  `post_tags` text DEFAULT NULL,
  `post_status` int(100) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `post` (`post_id`, `post_title`, `post_slug`, `blog_cat_id`, `post_short_desc`, `post_image`, `post_desc`, `post_date`, `post_view`, `post_tags`, `post_status`) VALUES
(11, 'Ridiculus non et dis fermentum non', 'ridiculus-non-et-dis-fermentum-non', 15, 'Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor', '1568442066.jpg', '&lt;p&gt;Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor&lt;/p&gt;\r\n&lt;p&gt;Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor&lt;/p&gt;\r\n&lt;p&gt;Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor&lt;/p&gt;', '2021-06-05', 29, 'blog,lifestyle,style', 1),
(12, 'Mus viverra sem a a magna consequat', 'mus-viverra-sem-a-a-magna-consequat', 16, 'Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.', '1568442193.jpg', '&lt;p&gt;Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.&lt;/p&gt;\r\n&lt;p&gt;Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.&lt;/p&gt;\r\n&lt;p&gt;Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.&lt;/p&gt;', '2021-06-05', 5, 'travel,lifestyle,blog', 1),
(13, 'Parturient eleifend varius auctor', 'parturient-eleifend-varius-auctor', 13, 'Accumsan proin aliquet ridiculus sapien parturient eleifend varius auctor dignissim vivamus vivamus a metus nostra curae at et sociosqu leo parturient euismod suspendisse nunc penatibus magna. Adipiscing a condimentum vel proin nisl dignissim class congue malesuada suspendisse primis neque odio at parturient.', '1568442458.jpg', '&lt;p&gt;Accumsan proin aliquet ridiculus sapien parturient eleifend varius auctor dignissim vivamus vivamus a metus nostra curae at et sociosqu leo parturient euismod suspendisse nunc penatibus magna. Adipiscing a condimentum vel proin nisl dignissim class congue malesuada suspendisse primis neque odio at parturient.&lt;/p&gt;\r\n&lt;p&gt;Accumsan proin aliquet ridiculus sapien parturient eleifend varius auctor dignissim vivamus vivamus a metus nostra curae at et sociosqu leo parturient euismod suspendisse nunc penatibus magna. Adipiscing a condimentum vel proin nisl dignissim class congue malesuada suspendisse primis neque odio at parturient.&lt;/p&gt;\r\n&lt;p&gt;Accumsan proin aliquet ridiculus sapien parturient eleifend varius auctor dignissim vivamus vivamus a metus nostra curae at et sociosqu leo parturient euismod suspendisse nunc penatibus magna. Adipiscing a condimentum vel proin nisl dignissim class congue malesuada suspendisse primis neque odio at parturient.&lt;/p&gt;', '2021-06-05', 13, 'Hobbies,lifestyle,post,blog', 1),
(14, 'Non vestibulum lacus sociosqu hac', 'non-vestibulum-lacus-sociosqu-hac', 11, 'Aptent ultrices vestibulum scelerisque dui suspendisse adipiscing vestibulum consectetur a class faucibus senectus iaculis hendrerit interdum justo commodo.A eget nunc natoque at dignissim a libero hendrerit a ut bibendum arcu ultrices a magna vitae leo vel id donec duis nulla nulla a adipiscing odio sodales.', '1568442655.jpg', '&lt;p&gt;Aptent ultrices vestibulum scelerisque dui suspendisse adipiscing vestibulum consectetur a class faucibus senectus iaculis hendrerit interdum justo commodo.A eget nunc natoque at dignissim a libero hendrerit a ut bibendum arcu ultrices a magna vitae leo vel id donec duis nulla nulla a adipiscing odio sodales.&lt;/p&gt;\r\n&lt;p&gt;Aptent ultrices vestibulum scelerisque dui suspendisse adipiscing vestibulum consectetur a class faucibus senectus iaculis hendrerit interdum justo commodo.A eget nunc natoque at dignissim a libero hendrerit a ut bibendum arcu ultrices a magna vitae leo vel id donec duis nulla nulla a adipiscing odio sodales.&lt;/p&gt;\r\n&lt;p&gt;Aptent ultrices vestibulum scelerisque dui suspendisse adipiscing vestibulum consectetur a class faucibus senectus iaculis hendrerit interdum justo commodo.A eget nunc natoque at dignissim a libero hendrerit a ut bibendum arcu ultrices a magna vitae leo vel id donec duis nulla nulla a adipiscing odio sodales.&lt;/p&gt;', '2021-06-05', 5, 'blog,post,creative', 1),
(15, 'Suspendisse a penatibus a varius', 'suspendisse-a-penatibus-a-varius', 14, 'Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.', '1568442786.jpg', '&lt;p&gt;Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.&lt;/p&gt;\r\n&lt;p&gt;Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.&lt;/p&gt;\r\n&lt;p&gt;Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.&lt;/p&gt;', '2021-06-05', 9, 'blog,international,post', 1),
(16, 'Nam venenatis parturient convallis', 'nam-venenatis-parturient-convallis', 12, 'Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.', '1568442941.jpg', '&lt;p&gt;Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.&lt;/p&gt;\r\n&lt;p&gt;Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.&lt;/p&gt;\r\n&lt;p&gt;Nam venenatis parturient convallis arcu lorem at eros cubilia nulla adipiscing urna sed vestibulum a suscipit. Mus viverra sem a a magna consequat ullamcorper a tristique etiam integer a dui parturient dapibus velit massa a nam feugiat donec.Nibh vestibulum facilisi morbi praesent facilisi vestibulum non facilisis potenti consectetur.&lt;/p&gt;', '2021-06-05', 20, 'Travel,cretive,post', 1),
(17, 'Vestibulum fringilla taciti gravida', 'vestibulum-fringilla-taciti-gravida', 16, 'Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor', '1568443072.jpg', '&lt;p&gt;Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor&lt;/p&gt;\r\n&lt;p&gt;Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor&lt;/p&gt;\r\n&lt;p&gt;Tortor ac litora phasellus a porta hac vestibulum fringilla taciti gravida adipiscing est litora sed massa per a ut vivamus libero vel. Ridiculus non et dis fermentum non libero per hac vestibulum senectus tortor leo nisl lobortis consectetur senectus habitant facilisi sodales vestibulum potenti nisl a. Ultricies et tortor&lt;/p&gt;', '2021-06-05', 62, 'creative,international,travel,post', 1),
(18, 'Pretium nascetur at cras porta', 'pretium-nascetur-at-cras-porta', 15, 'Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.', '1568443277.jpg', '&lt;p&gt;Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.&lt;/p&gt;\r\n&lt;p&gt;Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.&lt;/p&gt;\r\n&lt;p&gt;Susp endisse ullam corper a adipiscing class ullam corper inceptos nisl consequat eros congue ullamcorper suspendisse a penatibus a varius. Montes a platea viva mus ridiculus consequat parturient parturient pretium nascetur at cras porta parturient scelerisque ad mollis at in vivamus risus. Euismod maecenas.&lt;/p&gt;', '2021-06-05', 85, 'lifestyle,blog,post', 1);

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

--
-- Table structure for table `post_comment`
--

CREATE TABLE `post_comment` (
  `comment_id` int(11) NOT NULL,
  `post_id` int(50) NOT NULL,
  `user_id` int(50) NOT NULL,
  `comment_content` text NOT NULL,
  `comment_date` date NOT NULL,
  `comment_status` int(50) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `post_comment`
--

INSERT INTO `post_comment` (`comment_id`, `post_id`, `user_id`, `comment_content`, `comment_date`, `comment_status`) VALUES
(4, 15, 7, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum', '2020-08-28', 1);

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

--
-- Table structure for table `product_checkout`
--

CREATE TABLE `product_checkout` (
  `chout_id` int(11) NOT NULL,
  `purchase_token` varchar(500) NOT NULL,
  `order_ids` varchar(200) DEFAULT NULL,
  `product_prices` varchar(200) DEFAULT NULL,
  `product_user_id` varchar(200) DEFAULT NULL,
  `user_id` int(200) NOT NULL,
  `total` float NOT NULL,
  `subtotal` float NOT NULL,
  `processing_fee` float NOT NULL,
  `payment_type` varchar(100) DEFAULT NULL,
  `payment_token` varchar(300) DEFAULT NULL,
  `payment_date` date NOT NULL,
  `order_firstname` varchar(200) DEFAULT NULL,
  `order_lastname` varchar(200) DEFAULT NULL,
  `order_company` varchar(200) DEFAULT NULL,
  `order_email` varchar(200) DEFAULT NULL,
  `order_country` varchar(200) DEFAULT NULL,
  `order_address` text DEFAULT NULL,
  `order_city` varchar(200) DEFAULT NULL,
  `order_zipcode` varchar(200) DEFAULT NULL,
  `order_notes` text DEFAULT NULL,
  `payment_status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `product_comments`
--

CREATE TABLE `product_comments` (
  `comm_id` int(11) NOT NULL,
  `comm_user_id` int(200) NOT NULL,
  `comm_product_user_id` int(200) NOT NULL,
  `comm_product_id` int(200) NOT NULL,
  `comm_text` text NOT NULL,
  `comm_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_comments`
--

INSERT INTO `product_comments` (`comm_id`, `comm_user_id`, `comm_product_user_id`, `comm_product_id`, `comm_text`, `comm_date`) VALUES
(8, 7, 1, 7, 'Good product item', '2019-09-27 13:35:37'),
(10, 7, 1, 7, 'can you recommended any hosting provider?', '2019-09-28 07:14:58'),
(11, 7, 1, 4, 'latest laravel version?', '2019-09-30 11:35:58'),
(12, 7, 1, 6, 'Can i install script on my server?', '2019-10-06 09:57:45'),
(13, 7, 1, 6, 'thank you :)', '2020-09-25 12:14:29'),
(14, 7, 1, 161, 'can you help me?', '2022-12-09 10:33:33');

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

--
-- Table structure for table `product_comment_reply`
--

CREATE TABLE `product_comment_reply` (
  `comm_reply_id` int(11) NOT NULL,
  `comm_user_id` int(200) NOT NULL,
  `comm_product_user_id` int(200) NOT NULL,
  `comm_product_id` int(200) NOT NULL,
  `comm_id` int(200) NOT NULL,
  `comm_text` text NOT NULL,
  `comm_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_comment_reply`
--

INSERT INTO `product_comment_reply` (`comm_reply_id`, `comm_user_id`, `comm_product_user_id`, `comm_product_id`, `comm_id`, `comm_text`, `comm_date`) VALUES
(3, 1, 1, 7, 8, 'thanks :)', '2019-09-28 07:07:57'),
(5, 1, 1, 7, 8, 'i really appreciate you', '2019-09-28 07:13:40'),
(6, 1, 1, 7, 10, 'sure', '2019-09-28 07:17:57'),
(7, 1, 1, 6, 12, 'sure. send me details', '2019-10-06 09:58:37'),
(8, 1, 1, 6, 12, 'mail me your details', '2020-09-25 12:16:45'),
(9, 1, 1, 6, 13, 'Hi', '2020-09-25 12:20:53'),
(10, 1, 1, 161, 14, 'sure, send me details', '2022-12-09 10:35:53');

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

--
-- Table structure for table `product_compatible_browsers`
--

CREATE TABLE `product_compatible_browsers` (
  `browser_id` int(11) NOT NULL,
  `browser_name` varchar(200) NOT NULL,
  `browser_drop_status` varchar(50) NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product_compatible_browsers`
--

INSERT INTO `product_compatible_browsers` (`browser_id`, `browser_name`, `browser_drop_status`) VALUES
(6, 'Internet Explorer', 'no'),
(7, 'Firefox', 'no'),
(8, 'Chrome', 'no'),
(9, 'Safari', 'no'),
(10, 'Opera', 'no');

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

--
-- Table structure for table `product_favorite`
--

CREATE TABLE `product_favorite` (
  `fav_id` int(11) NOT NULL,
  `product_id` int(100) NOT NULL,
  `user_id` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product_favorite`
--

INSERT INTO `product_favorite` (`fav_id`, `product_id`, `user_id`) VALUES
(28, 11, 7),
(30, 3, 7),
(31, 153, 7),
(32, 157, 7),
(33, 158, 7);

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

--
-- Table structure for table `product_order`
--

CREATE TABLE `product_order` (
  `ord_id` int(11) NOT NULL,
  `user_id` int(100) NOT NULL,
  `session_id` varchar(500) DEFAULT NULL,
  `product_id` int(100) NOT NULL,
  `product_name` varchar(200) NOT NULL,
  `product_user_id` int(100) NOT NULL,
  `product_token` varchar(200) NOT NULL,
  `purchase_token` varchar(200) DEFAULT NULL,
  `payment_token` varchar(200) DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `license` varchar(50) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `coupon_key` varchar(191) DEFAULT NULL,
  `coupon_id` varchar(191) DEFAULT NULL,
  `coupon_code` varchar(191) DEFAULT NULL,
  `coupon_type` varchar(191) DEFAULT NULL,
  `coupon_value` varchar(191) DEFAULT NULL,
  `discount_price` double(8,2) NOT NULL,
  `product_price` float NOT NULL,
  `admin_amount` float NOT NULL DEFAULT 0,
  `total_price` float NOT NULL,
  `order_status` varchar(100) NOT NULL,
  `drop_status` varchar(100) DEFAULT NULL,
  `approval_status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `product_package_includes`
--

CREATE TABLE `product_package_includes` (
  `package_id` int(11) NOT NULL,
  `package_name` varchar(200) DEFAULT NULL,
  `package_drop_status` varchar(50) NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product_package_includes`
--

INSERT INTO `product_package_includes` (`package_id`, `package_name`, `package_drop_status`) VALUES
(1, 'HTML', 'no'),
(2, 'CSS', 'no');

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

--
-- Table structure for table `product_refund`
--

CREATE TABLE `product_refund` (
  `refund_id` int(11) NOT NULL,
  `ref_product_id` int(200) NOT NULL,
  `ref_order_id` int(200) NOT NULL,
  `ref_purchased_token` varchar(200) NOT NULL,
  `ref_product_token` varchar(200) NOT NULL,
  `ref_user_id` int(200) NOT NULL,
  `ref_product_user_id` int(200) NOT NULL,
  `ref_refund_reason` varchar(500) NOT NULL,
  `ref_refund_comment` text NOT NULL,
  `ref_refund_approval` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `product_withdrawal`
--

CREATE TABLE `product_withdrawal` (
  `wd_id` int(11) NOT NULL,
  `wd_user_id` int(200) NOT NULL,
  `wd_date` date NOT NULL,
  `withdraw_type` varchar(100) NOT NULL,
  `paypal_email` varchar(200) NOT NULL,
  `stripe_email` varchar(200) NOT NULL,
  `paystack_email` varchar(200) DEFAULT NULL,
  `bank_details` text DEFAULT NULL,
  `wd_amount` float NOT NULL,
  `wd_status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `pwa_settings`
--

CREATE TABLE `pwa_settings` (
  `sno` int(11) NOT NULL,
  `app_name` varchar(100) DEFAULT NULL,
  `short_name` varchar(100) DEFAULT NULL,
  `background_color` varchar(50) DEFAULT NULL,
  `theme_color` varchar(50) DEFAULT NULL,
  `pwa_icon1` varchar(50) DEFAULT NULL,
  `pwa_icon2` varchar(50) DEFAULT NULL,
  `pwa_icon3` varchar(50) DEFAULT NULL,
  `pwa_icon4` varchar(50) DEFAULT NULL,
  `pwa_icon5` varchar(50) DEFAULT NULL,
  `pwa_icon6` varchar(50) DEFAULT NULL,
  `pwa_icon7` varchar(50) DEFAULT NULL,
  `pwa_icon8` varchar(50) DEFAULT NULL,
  `pwa_splash1` varchar(50) DEFAULT NULL,
  `pwa_splash2` varchar(50) DEFAULT NULL,
  `pwa_splash3` varchar(50) DEFAULT NULL,
  `pwa_splash4` varchar(50) DEFAULT NULL,
  `pwa_splash5` varchar(50) DEFAULT NULL,
  `pwa_splash6` varchar(50) DEFAULT NULL,
  `pwa_splash7` varchar(50) DEFAULT NULL,
  `pwa_splash8` varchar(50) DEFAULT NULL,
  `pwa_splash9` varchar(50) DEFAULT NULL,
  `pwa_splash10` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pwa_settings`
--

INSERT INTO `pwa_settings` (`sno`, `app_name`, `short_name`, `background_color`, `theme_color`, `pwa_icon1`, `pwa_icon2`, `pwa_icon3`, `pwa_icon4`, `pwa_icon5`, `pwa_icon6`, `pwa_icon7`, `pwa_icon8`, `pwa_splash1`, `pwa_splash2`, `pwa_splash3`, `pwa_splash4`, `pwa_splash5`, `pwa_splash6`, `pwa_splash7`, `pwa_splash8`, `pwa_splash9`, `pwa_splash10`) VALUES
(1, 'Downgrade Marketplace', 'Selling Items', '#213E66', '#4AD295', '16940953121.png', '16940953122.png', '16940953123.png', '16940953124.png', '16940953125.png', '16940953126.png', '16940953127.png', '16940953128.png', '16940953129.png', '169409531210.png', '169409531211.png', '169409531212.png', '169409531213.png', '169409531214.png', '169409531215.png', '169409531216.png', '169409531217.png', '169409531218.png');

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

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (
  `subcat_id` int(11) NOT NULL,
  `cat_id` int(50) NOT NULL,
  `subcategory_name` varchar(200) NOT NULL,
  `subcategory_slug` varchar(200) NOT NULL,
  `subcategory_order` int(50) NOT NULL,
  `subcategory_status` int(50) NOT NULL,
  `drop_status` varchar(50) NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`subcat_id`, `cat_id`, `subcategory_name`, `subcategory_slug`, `subcategory_order`, `subcategory_status`, `drop_status`) VALUES
(52, 27, 'JavaScript', 'javascript', 1, 1, 'no'),
(53, 27, 'PHP Scripts', 'php-scripts', 2, 1, 'no'),
(54, 27, 'CSS', 'css', 3, 1, 'no'),
(55, 27, 'HTML5', 'html5', 4, 1, 'no'),
(56, 27, '.NET', '-net', 5, 1, 'no'),
(57, 27, 'Skins', 'skins', 6, 1, 'no'),
(58, 28, 'WordPress', 'wordpress', 7, 1, 'no'),
(59, 28, 'HTML/CSS', 'html-css', 8, 1, 'no'),
(60, 28, 'Bootstrap', 'bootstrap', 8, 1, 'no'),
(61, 28, 'Muse', 'muse', 9, 1, 'no'),
(62, 28, 'Joomla', 'joomla', 10, 1, 'no'),
(63, 28, 'Magento', 'magento', 11, 1, 'no'),
(64, 28, 'Drupal', 'drupal', 12, 1, 'no'),
(65, 28, 'OpenCart', 'opencart', 13, 1, 'no'),
(66, 28, 'PrestaShop', 'prestashop', 14, 1, 'no'),
(67, 28, 'Tumblr', 'tumblr', 15, 1, 'no'),
(68, 29, 'WordPress Plugins', 'wordpress-plugins', 16, 1, 'no'),
(69, 29, 'Magento Extensions', 'magento-extensions', 17, 1, 'no'),
(70, 29, 'Joomla', 'joomla', 18, 1, 'no'),
(71, 29, 'Drupal', 'drupal', 19, 1, 'no'),
(72, 29, 'OpenCart', 'opencart', 20, 1, 'no'),
(73, 29, 'ExpressionEngine', 'expressionengine', 21, 1, 'no'),
(74, 30, 'Business Cards', 'business-cards', 22, 1, 'no'),
(75, 30, 'Brochures', 'brochures', 23, 1, 'no'),
(76, 30, 'Flyers', 'flyers', 24, 1, 'no'),
(77, 30, 'Resumes', 'resumes', 25, 1, 'no'),
(78, 30, 'Logos', 'logos', 26, 1, 'no'),
(79, 30, 'Magazines', 'magazines', 27, 1, 'no'),
(80, 31, 'Icons', 'icons', 28, 1, 'no'),
(81, 31, 'Illustrations', 'illustrations', 29, 1, 'no'),
(82, 31, 'Objects', 'objects', 30, 1, 'no'),
(83, 31, 'Patterns', 'patterns', 31, 1, 'no'),
(84, 31, 'Product Mock-Ups', 'product-mock-ups', 32, 1, 'no'),
(85, 31, 'Textures', 'textures', 33, 1, 'no'),
(86, 32, 'Android', 'android', 34, 1, 'no'),
(87, 32, 'iOS', 'ios', 35, 1, 'no'),
(88, 32, 'Native Web', 'native-web', 36, 1, 'no'),
(89, 32, 'Unity', 'unity', 37, 1, 'no'),
(90, 32, 'Corona', 'corona', 38, 1, 'no');

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

--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `subscr_id` int(11) NOT NULL,
  `subscr_name` varchar(200) NOT NULL,
  `subscr_slug` varchar(200) NOT NULL,
  `subscr_price` float NOT NULL,
  `subscr_duration` varchar(50) NOT NULL,
  `subscr_item_level` varchar(100) DEFAULT NULL,
  `subscr_item` int(100) NOT NULL,
  `subscr_download_item` mediumint(9) NOT NULL,
  `subscr_space_level` varchar(100) DEFAULT NULL,
  `subscr_space` int(100) NOT NULL,
  `subscr_space_type` varchar(100) DEFAULT NULL,
  `subscr_order` int(50) NOT NULL,
  `subscr_email_support` int(50) NOT NULL,
  `subscr_payment_mode` int(50) NOT NULL,
  `subscr_status` int(50) NOT NULL,
  `subscr_drop_status` varchar(50) NOT NULL DEFAULT 'no',
  `highlight_pack` int(11) NOT NULL DEFAULT 0,
  `highlight_bg_color` varchar(191) DEFAULT NULL,
  `highlight_text_color` varchar(191) DEFAULT NULL,
  `icon_color` varchar(191) DEFAULT NULL,
  `button_bg_color` varchar(191) DEFAULT NULL,
  `button_text_color` varchar(191) DEFAULT NULL,
  `extra_info` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscription`
--

INSERT INTO `subscription` (`subscr_id`, `subscr_name`, `subscr_slug`, `subscr_price`, `subscr_duration`, `subscr_item_level`, `subscr_item`, `subscr_download_item`, `subscr_space_level`, `subscr_space`, `subscr_space_type`, `subscr_order`, `subscr_email_support`, `subscr_payment_mode`, `subscr_status`, `subscr_drop_status`, `highlight_pack`, `highlight_bg_color`, `highlight_text_color`, `icon_color`, `button_bg_color`, `button_text_color`, `extra_info`) VALUES
(7, 'Monthly', 'monthly', 29, '1 Month', 'limited', 50, 0, NULL, 0, NULL, 1, 0, 0, 1, 'no', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'Yearly', 'yearly', 129, '1 Year', 'limited', 300, 0, NULL, 0, NULL, 2, 0, 0, 1, 'no', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 'Life Time', 'life-time', 1499, '1000 Year', 'unlimited', 0, 0, NULL, 0, NULL, 3, 0, 0, 1, 'no', 0, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `withdrawal`
--

CREATE TABLE `withdrawal` (
  `wd_id` int(11) NOT NULL,
  `wd_user_id` int(200) NOT NULL,
  `wd_date` date NOT NULL,
  `withdraw_type` varchar(100) NOT NULL,
  `paypal_email` varchar(200) NOT NULL,
  `stripe_email` varchar(200) NOT NULL,
  `wd_amount` float NOT NULL,
  `wd_status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attributes`
--
ALTER TABLE `attributes`
  ADD PRIMARY KEY (`attr_id`);

--
-- Indexes for table `blog_category`
--
ALTER TABLE `blog_category`
  ADD PRIMARY KEY (`blog_cat_id`);

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

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

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `coupon`
--
ALTER TABLE `coupon`
  ADD PRIMARY KEY (`coupon_id`);

--
-- Indexes for table `development_logo`
--
ALTER TABLE `development_logo`
  ADD PRIMARY KEY (`logo_id`);

--
-- Indexes for table `email_template`
--
ALTER TABLE `email_template`
  ADD PRIMARY KEY (`et_id`);

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

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

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

--
-- Indexes for table `post_comment`
--
ALTER TABLE `post_comment`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indexes for table `product_checkout`
--
ALTER TABLE `product_checkout`
  ADD PRIMARY KEY (`chout_id`);

--
-- Indexes for table `product_comments`
--
ALTER TABLE `product_comments`
  ADD PRIMARY KEY (`comm_id`);

--
-- Indexes for table `product_comment_reply`
--
ALTER TABLE `product_comment_reply`
  ADD PRIMARY KEY (`comm_reply_id`);

--
-- Indexes for table `product_compatible_browsers`
--
ALTER TABLE `product_compatible_browsers`
  ADD PRIMARY KEY (`browser_id`);

--
-- Indexes for table `product_favorite`
--
ALTER TABLE `product_favorite`
  ADD PRIMARY KEY (`fav_id`);

--
-- Indexes for table `product_order`
--
ALTER TABLE `product_order`
  ADD PRIMARY KEY (`ord_id`);

--
-- Indexes for table `product_package_includes`
--
ALTER TABLE `product_package_includes`
  ADD PRIMARY KEY (`package_id`);

--
-- Indexes for table `product_refund`
--
ALTER TABLE `product_refund`
  ADD PRIMARY KEY (`refund_id`);

--
-- Indexes for table `product_withdrawal`
--
ALTER TABLE `product_withdrawal`
  ADD PRIMARY KEY (`wd_id`);

--
-- Indexes for table `pwa_settings`
--
ALTER TABLE `pwa_settings`
  ADD PRIMARY KEY (`sno`);

--
-- Indexes for table `subcategory`
--
ALTER TABLE `subcategory`
  ADD PRIMARY KEY (`subcat_id`);

--
-- Indexes for table `subscription`
--
ALTER TABLE `subscription`
  ADD PRIMARY KEY (`subscr_id`);

--
-- Indexes for table `withdrawal`
--
ALTER TABLE `withdrawal`
  ADD PRIMARY KEY (`wd_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `blog_category`
--
ALTER TABLE `blog_category`
  MODIFY `blog_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=244;

--
-- AUTO_INCREMENT for table `coupon`
--
ALTER TABLE `coupon`
  MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

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

--
-- AUTO_INCREMENT for table `email_template`
--
ALTER TABLE `email_template`
  MODIFY `et_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

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

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

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

--
-- AUTO_INCREMENT for table `product_checkout`
--
ALTER TABLE `product_checkout`
  MODIFY `chout_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=206;

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

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

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

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

--
-- AUTO_INCREMENT for table `product_order`
--
ALTER TABLE `product_order`
  MODIFY `ord_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144;

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

--
-- AUTO_INCREMENT for table `product_refund`
--
ALTER TABLE `product_refund`
  MODIFY `refund_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

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

--
-- AUTO_INCREMENT for table `subcategory`
--
ALTER TABLE `subcategory`
  MODIFY `subcat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

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

--
-- AUTO_INCREMENT for table `withdrawal`
--
ALTER TABLE `withdrawal`
  MODIFY `wd_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

