-- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 21, 2018 at 12:18 PM
-- Server version: 10.1.34-MariaDB
-- PHP Version: 7.1.19

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `chewi-merge`
--

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

--
-- Table structure for table `chewi_m_items`
--

CREATE TABLE `chewi_m_items` (
  `id` int(11) NOT NULL,
  `name` varchar(99) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `description` varchar(200) DEFAULT NULL,
  `content` text NOT NULL,
  `features` text NOT NULL,
  `icon_img` varchar(99) DEFAULT NULL,
  `preview_img` varchar(255) DEFAULT NULL,
  `item_file` varchar(99) DEFAULT NULL,
  `item_scr` varchar(250) DEFAULT NULL,
  `cat_id` int(3) NOT NULL DEFAULT '0',
  `user_pin` varchar(50) NOT NULL,
  `support` int(11) NOT NULL DEFAULT '0',
  `featured` int(11) NOT NULL DEFAULT '0',
  `on_sale` int(11) DEFAULT '0',
  `sale_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `on_stock` int(11) NOT NULL DEFAULT '0',
  `stock_amount` int(11) NOT NULL DEFAULT '1',
  `tags` text NOT NULL,
  `demo` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `right_to_sell` int(11) NOT NULL DEFAULT '0',
  `update_request` int(11) NOT NULL DEFAULT '0',
  `update_request_on` datetime NOT NULL,
  `review_message` text NOT NULL,
  `free` int(11) NOT NULL DEFAULT '0',
  `apply_free` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chewi_m_items`
--

INSERT INTO `chewi_m_items` (`id`, `name`, `price`, `description`, `content`, `features`, `icon_img`, `preview_img`, `item_file`, `item_scr`, `cat_id`, `user_pin`, `support`, `featured`, `on_sale`, `sale_price`, `on_stock`, `stock_amount`, `tags`, `demo`, `video`, `created`, `last_updated`, `status`, `right_to_sell`, `update_request`, `update_request_on`, `review_message`, `free`, `apply_free`) VALUES
(1, 'Test Product 1', '5.99', 'A short description...', '<h1>HTML Bit</h1>\r\n<div class=\"alert alert-warning\" role=\"alert\">This is a bootstrap message box that can be used in whatever way you want!</div>', '<h1>Features Bit</h1>\r\n<ul>\r\n<li>Easy to use</li>\r\n<li>Generate chosen number of passwords</li>\r\n<li>Customize the number&nbsp;characters in the password</li>\r\n<li>Customize what characters the passwords will contain</li>\r\n<li>AJAX</li>\r\n<li>No install</li>\r\n<li>No db</li>\r\n</ul>\r\n<pre>cxxx<br />svshjvdsjvfhvf<br />dsaafsa<br />im an area where you can write code or do a change log????</pre>', 'icon.jpg', 'preview.jpg', 'test.zip', NULL, 3, '3230711532825926', 1, 1, 0, '0.00', 0, 1, 'tag1,tag2, tag3, tag4, tag5, tag6, tag7,tag8, tag9, tag10, tag11, tag12, tag13, tag14, tag15', 'http://www.nick.com/avatar-the-last-airbender/', 'https://www.youtube.com/embed/DTV5GK4DeHM', '2018-05-25 00:00:00', '2018-05-27 00:00:00', 1, 1, 1, '2018-10-14 00:00:00', 'Your item is almost there! Please add a documentation and resubmit!', 1, 1),
(2, 'Test Product 2', '2.99', 'A short description', '<p>HTML Bit</p>', '<h1>Features Bit</h1>', 'icon.jpg', 'preview.jpg', 'test1.zip', NULL, 4, '2367511535496873', 1, 1, 1, '1.00', 0, 1, 'tag1, tag2, tag3', NULL, NULL, '2018-05-26 00:00:00', '2018-05-26 00:00:00', 1, 1, 0, '0000-00-00 00:00:00', 'Your item is almost there! Please add a documentation and resubmit!', 0, 0),
(3, 'Test Product 3', '1.99', 'A short description...', '<p>HTML Bit</p>', '<h1>Features Bit</h1>', 'icon.jpg', 'preview.jpg', 'test1.zip', NULL, 4, '2367511535496873', 1, 1, 1, '1.00', 0, 1, 'tag1, tag2, tag3', NULL, NULL, '2018-10-16 00:00:00', '2018-05-26 00:00:00', 0, 1, 0, '0000-00-00 00:00:00', 'Your item is almost there! Please add a documentation and resubmit!', 0, 0);

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

--
-- Table structure for table `chewi_m_items_categories`
--

CREATE TABLE `chewi_m_items_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chewi_m_items_categories`
--

INSERT INTO `chewi_m_items_categories` (`id`, `name`, `icon`, `parent_id`, `status`) VALUES
(1, 'Scripts & Code', 'fas fa-code', NULL, 1),
(2, 'App & Source Code', 'fas fa-mobile-alt', NULL, 1),
(3, 'PHP Scripts', 'fab fa-php', 1, 1),
(4, 'Javascript', 'fab fa-js', 1, 1),
(5, 'CSS', 'fab fa-css3', 1, 1),
(6, 'Python', 'fab fa-python', 1, 1),
(7, 'Graphics', 'fas fa-image', NULL, 1),
(8, 'Icons', 'fas fa-vector-square', 7, 1),
(9, 'User Interfaces', 'fas fa-desktop', 7, 1),
(10, 'Android', 'fab fa-android', 2, 1),
(11, 'IOS', 'fab fa-apple', 2, 1),
(12, 'React', 'fab fa-react', 2, 1);

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

--
-- Table structure for table `chewi_m_transactions`
--

CREATE TABLE `chewi_m_transactions` (
  `id` int(11) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `payment_type` int(11) NOT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `fee` decimal(10,2) DEFAULT NULL,
  `currency` varchar(50) NOT NULL,
  `payment_date` datetime NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `notes` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chewi_m_transactions`
--

INSERT INTO `chewi_m_transactions` (`id`, `user_id`, `item_id`, `payment_type`, `payment_id`, `price`, `fee`, `currency`, `payment_date`, `status`, `notes`) VALUES
(1, '1', 0, 1, 'PAY-4PB4905128778532MLPBFKIY', '30.00', NULL, 'GBP', '2018-10-13 21:27:15', 0, NULL),
(2, '1', 1, 1, 'PAY-7E7932160V277915XLPBFLRY', '30.00', NULL, 'GBP', '2018-10-13 21:29:59', 1, NULL),
(3, '1', 0, 3, 'CHEWI-MANUAL-53749016', '15.00', NULL, 'GBP', '2018-10-15 18:33:47', 1, '&pound;15 Free Credit'),
(4, '1', 2, 2, 'CHEWI-62747363', '12.00', NULL, 'GBP', '2018-10-15 10:41:28', 1, ''),
(5, '1', NULL, 1, 'PAY-8AK40675AR6559636LPFWE3I', '7.99', NULL, 'GBP', '0000-00-00 00:00:00', 0, NULL),
(6, '1', NULL, 1, 'PAY-1D5427772F489140VLPF4DVY', '2.99', NULL, 'GBP', '0000-00-00 00:00:00', 1, NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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