-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 19, 2025 at 03:00 PM
-- Server version: 5.7.17-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `db_pike`
--
CREATE DATABASE IF NOT EXISTS `db_pike` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `db_pike`;

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

--
-- Table structure for table `cms_categ`
--

CREATE TABLE IF NOT EXISTS `cms_categ` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `title` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `active` tinyint(1) NOT NULL,
  `meta_title` text NOT NULL,
  `meta_description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_categ`
--

INSERT INTO `cms_categ` (`id`, `parent_id`, `title`, `slug`, `description`, `active`, `meta_title`, `meta_description`) VALUES
(1, NULL, 'Internet', 'internet', 'Internet category description\r\nf dfdsfdsa', 1, 'Internet categ', 'Meta desc'),
(2, NULL, 'Food', 'food', 'Food and Drink', 1, 'Food and Drink', 'Food and Drink custom meta description'),
(4, NULL, 'Travel', 'travel', '', 1, '', ''),
(5, NULL, 'Business', 'business', '', 1, '', '');

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

--
-- Table structure for table `cms_comments`
--

CREATE TABLE IF NOT EXISTS `cms_comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `post_id` int(10) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `comment` text NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_comments`
--

INSERT INTO `cms_comments` (`id`, `post_id`, `name`, `email`, `comment`, `date`, `ip`) VALUES
(4, 9, 'Gabriel c', '[email protected]', 'Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.', '2019-04-19 23:58:45', '86.124.189.220'),
(3, 9, 'MX Scripts', '[email protected]', 'Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.\r\n\r\nDuo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.', '2019-04-19 23:58:19', '86.124.189.220'),
(5, 8, 'Gabriel', '[email protected]', 'Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.', '2019-04-19 23:59:59', '86.124.189.220'),
(6, 8, 'Test Visitor', '[email protected]', 'Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei.', '2019-04-20 00:15:28', '86.124.189.220'),
(7, 12, 'Gabriel', '[email protected]', 'Great cities. I like Spain cities', '2019-06-12 16:33:12', '::1');

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

--
-- Table structure for table `cms_media`
--

CREATE TABLE IF NOT EXISTS `cms_media` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `post_id` int(10) NOT NULL,
  `type` varchar(25) NOT NULL,
  `title` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `content` text NOT NULL,
  `redirect_url` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_posts`
--

CREATE TABLE IF NOT EXISTS `cms_posts` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `image` varchar(250) DEFAULT NULL,
  `user_id` int(10) DEFAULT NULL,
  `categ_id` int(5) NOT NULL,
  `status` varchar(20) NOT NULL,
  `content_short` text,
  `content` longtext,
  `sticky` varchar(3) DEFAULT NULL,
  `disable_comments` varchar(3) DEFAULT NULL,
  `disable_ratings` varchar(3) DEFAULT NULL,
  `meta_title` varchar(250) DEFAULT NULL,
  `meta_description` varchar(250) DEFAULT NULL,
  `tags` text,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `hits` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_posts`
--

INSERT INTO `cms_posts` (`id`, `title`, `slug`, `image`, `user_id`, `categ_id`, `status`, `content_short`, `content`, `sticky`, `disable_comments`, `disable_ratings`, `meta_title`, `meta_description`, `tags`, `created`, `updated`, `hits`) VALUES
(1, 'The best side dishes to serve with a curry', 'the-best-side-dishes-to-serve-with-a-curry', '201904/b3a9e15d-food123.jpg', 35, 2, 'active', 'Made a delicious Indian spice pot but stuck for something to serve it with? Read our definitive list of accompaniments and never be short on sides again…', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, 'on', NULL, 'custom meta title', 'custom meta description', '', '2019-02-02 00:00:00', '2019-06-13 16:29:38', 6),
(3, 'Singapore's fastest growing companies 2019', 'singapore-39-s-fastest-growing-companies-2019', '201904/030d8a20-singapore-city.jpg', 35, 5, 'active', 'A look at why IT-enabled firms, in particular, are dominating Singapore’s Fastest Growing Companies list.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'Singapore's fastest growing companies 2019', 'A look at why IT-enabled firms, in particular, are dominating Singapore’s Fastest Growing Companies list.', 'Singapore,travel', '2019-03-02 01:11:21', '2019-04-19 12:21:59', 2),
(4, 'Lavazza Group’s 2018 revenues up 9.3 percent to EUR 1.87 billion', 'lavazza-group-s-2018-revenues-up-9-3-percent-to-eur-1-87-billion', '201904/2f3e262e-lavazza.jpg', 35, 5, 'active', 'Lavazza Group recorded total revenues of EUR 1.87 billion in 2018, up 9.3 percent compared to 2017, and EBITDA of EUR 197.3 million, up 6.2 percent. Net profit was EUR 87.9 million, up 12.9 percent compared to EUR 77.9 million in 2017.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'Lavazza Group’s 2018 revenues up 9.3 percent to EUR 1.87 billion', 'Lavazza Group recorded total revenues of EUR 1.87 billion in 2018, up 9.3 percent compared to 2017, and EBITDA of EUR 197.3 million, up 6.2 percent. Net profit was EUR 87.9 million, up 12.9 percent co', 'Lavazza,European Union,Cofee', '2019-04-02 01:11:37', '2019-04-19 11:37:59', 1),
(6, 'PayPal to buy its first Blockchain startup', 'paypal-to-buy-its-first-blockchain-startup', '201904/6de643b9-paypal-blockchain-tech.jpg', 35, 5, 'active', 'Online payments giant PayPal has made its first-ever investment in a blockchain technology company. PayPal has joined the extension of a Series A funding round in Cambridge Blockchain.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p><strong>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</strong></p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, '', '', 'PayPal,Blockchain', '2019-04-04 22:12:08', NULL, 1),
(7, 'A guide to wine – how to choose, store and serve', 'a-guide-to-wine-how-to-choose-store-and-serve', '201904/516e323d-wine.jpg', 35, 2, 'active', 'Experts give advice on how to choose, buy and store wine.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'A guide to wine – how to choose, store and serve', 'Experts give advice on how to choose, buy and store wine.', 'wine', '2019-04-04 22:30:33', '2019-06-12 16:40:12', 12),
(8, 'A guide to cheese: How to make the perfect cheeseboard', 'a-guide-to-cheese-how-to-make-the-perfect-cheeseboard', '201904/f4794da8-cheese-guide.jpg', 35, 2, 'active', 'Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. ', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'A guide to cheese: How to make the perfect cheeseboard', 'Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum', 'cheese,travel,spain', '2019-04-04 22:33:27', '2019-04-19 11:38:32', 17),
(9, 'Your guide to buying the best fruit in the summer season', 'your-guide-to-buying-the-best-fruit-in-the-summer-season', '201904/a9824f53-fruits.jpg', 35, 2, 'active', 'With summer on the horizon, the season is ripe for picking up some fantastic fruits. Here’s a guide on what’s hot this season and how to spot signs of the most juicy produce in your local supermarket.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'Your guide to buying the best fruit in the summer season', 'With summer on the horizon, the season is ripe for picking up some fantastic fruits. Here’s a guide on what’s hot this season and how to spot signs of the most juicy produce in your local supermar', 'summer,fruits', '2019-04-04 22:44:07', '2019-04-19 11:38:21', 10),
(10, 'Our best travel tips after 20 years of traveling', 'our-best-travel-tips-after-20-years-of-traveling', '201904/1b59a826-acropolis-philopappos-hill-athens.jpg', 35, 4, 'active', 'Over the past 20 years, Caz and I have been fortunate to have visited over 50 countries and lived in 5, and today we’d like to share with you our 20 best travel tips!', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'Our best travel tips after 20 years of traveling', 'Over the past 20 years, Caz and I have been fortunate to have visited over 50 countries and lived in 5, and today we’d like to share with you our 20 best travel tips!', 'travel tips,travel,Romania', '2019-04-04 22:53:34', '2019-04-19 11:27:41', 12),
(11, 'Barcelona travel guide and tips', 'barcelona-travel-guide-and-tips', '201904/96ed1546-barcelona.jpg', 35, 4, 'active', 'What city in the world could be more perfect than Barcelona? With its cosmopolitan feel, relaxed pace of life, breathtaking architecture, fantastic gastronomy, and unbeatable climate, it really is the city that has everything. T+L’s Barcelona travel guide will tell you everything you need to know about what to see, eat, and visit in the Catalan capital, from the tried and tested favorites, to top secret spots, and the best new arrivals on the scene.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'Barcelona travel guide and tips', 'What city in the world could be more perfect than Barcelona? With its cosmopolitan feel, relaxed pace of life, breathtaking architecture, fantastic gastronomy, and unbeatable climate, it really is the', 'Spain,travel tips,Romania', '2019-04-04 23:02:59', '2019-04-19 11:27:33', 12),
(12, 'The Top 15 Cities in the United States', 'the-top-15-cities-in-the-united-states', '201904/d5b884a6-travel-usa.jpg', 35, 4, 'active', 'On the surface, the skyscrapers of New York City couldn’t feel more different from the sun-washed pueblo buildings of Santa Fe. Likewise, the crystalline beaches of Honolulu seem worlds apart from the oak-shaded squares of Savannah. But despite their striking contrasts, the American cities beloved by T+L readers share a similar spirit.', '<p>Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei. Nobis dignissim sed an, malis possim alienum pri id, ex denique eleifend qui. Quo no diceret partiendo molestiae. Eu nam solet patrioque voluptaria, quo viris pertinax id.</p><p>Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.</p><p>Duo propriae accusamus tincidunt eu, et suas qualisque euripidis pro. Ad mea malis nominati repudiare, sit in primis facete nusquam, nam perpetua repudiare in. Id est exerci melius. Postea instructior an vix, duo libris facete in, eos solum dignissim voluptaria ea.</p><p>Duo efficiantur necessitatibus te, in munere nostro qui, pri fierent noluisse epicurei cu. Qui et assentior intellegat percipitur, ad eum atqui argumentum eloquentiam. Mutat iriure sententiae te mea. Mea viderer volumus tacimates no. Ne moderatius ullamcorper usu, id eos diceret noluisse suscipiantur, eu vix putent quidam sanctus. Clita intellegat abhorreant ea sit, est ad ubique senserit comprehensam. Vim putant quaeque et.</p><p>Enim nibh populo cu cum. Et oblique detraxit vis, no scripta dolorem eam. Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.</p>', NULL, NULL, NULL, 'The Top 15 Cities in the United States', 'On the surface, the skyscrapers of New York City couldn’t feel more different from the sun-washed pueblo buildings of Santa Fe. Likewise, the crystalline beaches of Honolulu seem worlds apart from t', 'travel', '2019-06-04 23:09:13', '2019-06-13 22:03:35', 39);

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

--
-- Table structure for table `cms_tags`
--

CREATE TABLE IF NOT EXISTS `cms_tags` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_id` int(10) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `counter` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=148 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_tags`
--

INSERT INTO `cms_tags` (`id`, `post_id`, `tag`, `slug`, `counter`) VALUES
(109, 4, 'Lavazza', 'lavazza', 1),
(110, 4, 'European Union', 'european-union', 1),
(105, 11, 'Romania', 'romania', 2),
(104, 11, 'travel tips', 'travel-tips', 2),
(103, 11, 'Spain', 'spain', 2),
(115, 8, 'travel', 'travel', 4),
(114, 8, 'cheese', 'cheese', 1),
(108, 10, 'Romania', 'romania', 2),
(107, 10, 'travel', 'travel', 4),
(106, 10, 'travel tips', 'travel-tips', 2),
(147, 12, 'travel', 'travel', 4),
(111, 4, 'Cofee', 'cofee', 1),
(112, 9, 'summer', 'summer', 1),
(113, 9, 'fruits', 'fruits', 1),
(116, 8, 'spain', 'spain', 2),
(120, 3, 'Singapore', 'singapore', 1),
(121, 3, 'travel', 'travel', 4),
(135, 7, 'wine', 'wine', 1);

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

--
-- Table structure for table `contact_msg`
--

CREATE TABLE IF NOT EXISTS `contact_msg` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `message` text NOT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(50) NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `is_responded` tinyint(1) NOT NULL DEFAULT '0',
  `is_spam` tinyint(1) NOT NULL DEFAULT '0',
  `is_important` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact_msg`
--

INSERT INTO `contact_msg` (`id`, `name`, `email`, `subject`, `message`, `time`, `ip`, `is_read`, `is_responded`, `is_spam`, `is_important`) VALUES
(291, 'flavio motta', '[email protected]', 'new DEMO PAGE', 'hi, it´s possible add a PAGE DEMO in PRO VERSION using a MASTER/DETAIL page ?\r\n\r\nthanks', '2019-02-14 20:46:11', '191.190.113.30', 0, 0, 0, 0),
(292, 'Crystal', '[email protected]', 'Create Instant App for your Website', 'Instantly create an app for your website with the click of buttons! Appy Pie,  is an unrivalled leader in the mobile app bandwagon that allows everyone to transform their app ideas into reality, without any technical knowledge. \r\n\r\nSimply drag and drop the features and create an advanced Android or iOS application for mobiles and smartphones, as easy as a pie. \r\n\r\nStart creating your app on the fly & even convert your website into an app with Appy Pie.\r\n\r\nhttp://www.tkqlhce.com/click-8095449-11578080', '2019-02-14 21:51:25', '39.115.133.72', 0, 0, 0, 0),
(297, 'Reynaldo Cusi', '[email protected]', 'This action is disabled in DEMO MODE', 'Estimados, \r\n\r\nCompre hace un momento la version ADMIN PRO\r\n\r\ny me aparece el mensaje "This action is disabled in DEMO MODE!" cuando quiero cambiar los textos de configuración en mi localhost.\r\n\r\nPor favor su ayuda', '2019-02-17 06:29:34', '179.7.224.105', 0, 0, 0, 0),
(299, 'Carl S.', '[email protected]', 'link exchange with domain', 'Hi,\r\n\r\nI would like to propose the link exchange deal with your website pikeadmin.com, for mutual benefit in getting more traffic and improve search engine's ranking, absolutely no money involve.\r\n\r\nWe will link to you from our Music and Entertainment authority site - https://www.loudthings.org/, from its homepage's sidebar. In return you will agree to do the same to link back to one of our Music & Entertainment Site, from your pikeadmin.com's homepage too (sidebar, footer, or anywhere on your homepage), with our brand name Guitar Junky.\r\n\r\nIf you are interested, kindly reply to this email.\r\n\r\nThank you,\r\nCarl', '2019-02-19 02:58:50', '172.246.8.138', 0, 0, 0, 0),
(303, 'Aly Chiman', '[email protected]', 'Resource Link Enquiry', 'Hello there,\r\n\r\nMy name is Aly and I would like to know if you would have any interest to have your website here at pikeadmin.com promoted as a resource on our blog alychidesign.com ? \r\n\r\nWe are in the midst of updating our broken link resources to include current and up to date resources for our readers. Our resource links are manually approved allowing us to mark a link as a do-follow link as well\r\n.\r\nIf you may be interested please in being included as a resource on our blog, please let me know.\r\n\r\nThanks,\r\nAly\r\n', '2019-02-21 15:58:40', '201.175.51.152', 0, 0, 0, 0),
(316, 'Gabriel Chimilevschi', '[email protected]', 'Piracy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna 'aliqua'. Venenatis tellus in metus vulputate eu scelerisque felis imperdiet "proin". \r\n\r\nTincidunt dui ut ornare lectus sit amet. Vitae sapien pellentesque habitant morbi tristique. Sit amet aliquam id diam maecenas ultricies mi eget. Porttitor massa id neque aliquam vestibulum morbi blandit cursus. At varius vel pharetra vel turpis nunc eget lorem. Dignissim suspendisse in est ante in. Aliquam malesuada bibendum arcu vitae elementum. Vel orci porta non pulvinar.\r\n\r\nPHP Arena - Free professional scripts\r\n<a href="xxx">dsd</a>', '2019-04-16 16:24:56', '86.124.189.220', 1, 0, 0, 0),
(317, 'MX Scripts', '[email protected]', 'Piracy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Venenatis tellus in metus vulputate eu scelerisque felis imperdiet proin. \r\n\r\n', '2019-04-20 00:11:00', '86.124.189.220', 1, 0, 0, 0);

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

--
-- Table structure for table `contact_msg_rep`
--

CREATE TABLE IF NOT EXISTS `contact_msg_rep` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `msg_id` int(10) NOT NULL,
  `sender_user_id` int(5) NOT NULL,
  `message` text NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `content` text,
  `image` varchar(250) DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `target` varchar(50) DEFAULT NULL,
  `position` tinyint(2) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `title`, `content`, `image`, `url`, `target`, `position`, `active`) VALUES
(7, 'Lorem ipsum dolor sit amet', 'Lorem ipsum dolor sit amet, cu cum graeco constituam. Delenit pericula scribentur usu cu, per et quis scripta iudicabit, quo melius detracto sadipscing ei.', '7301e926-acropolis-philopappos-hill-athens.jpg', '', 'blank', 1, 1),
(8, 'Delicata principes quo in. Accumsan mnesarchum disputando sed ut', 'Delicata principes quo in. Accumsan mnesarchum disputando sed ut, mei ei deleniti oportere explicari. Et diam brute diceret pro, equidem ponderum qualisque vim ut, est justo omnesque no. Solum quando iuvaret an duo, mel laudem constituto consetetur ex. Vel ea duis errem, mollis praesent vix at.', '7b4f84be-fruits.jpg', 'https://www.pikeadmin.com', 'self', 2, 1),
(9, 'Enim nibh populo cu cum. Et oblique detraxit vis', 'Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.', '7c448eb3-travel-usa.jpg', 'https://www.youtube.com/watch?v=U5HAEzEk8QM', 'self', 3, 1),
(11, 'GSMLoop', 'Ullum putant deterruisset nam eu, has no tollit legere appetere, mei at dolore option oporteat. Quodsi scriptorem eam ne, ad novum elitr doming qui. Ut nibh mundi nam. Tation oporteat eu pro, sit lorem deterruisset et.', '2395fa97-singapore-city.jpg', '', 'self', 4, 1);

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

--
-- Table structure for table `sys_config`
--

CREATE TABLE IF NOT EXISTS `sys_config` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `value` longtext NOT NULL,
  `app` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_config`
--

INSERT INTO `sys_config` (`id`, `name`, `value`, `app`) VALUES
(2, 'site_title', 'Pike Admin', 'core'),
(28, 'recaptcha_registration_enabled', '1', 'core'),
(30, 'recaptcha_site_key', '', 'core'),
(25, 'site_meta_author', 'Pike Admin - https://www.pikeadmin.com', 'core'),
(24, 'site_meta_keywords', 'Meta keywords ', 'core'),
(26, 'site_meta_description', 'Pike Admin Framework', 'core'),
(22, 'site_meta_title', 'Pike Admin Framework', 'core'),
(27, 'registration_enabled', '1', 'core'),
(31, 'recaptcha_secret_key', 'xxx', 'core'),
(144, 'template', 'default', 'core'),
(66, 'media_big_height', '400', 'core'),
(63, 'analytics-code', 'fsd', 'custom'),
(65, 'media_big_width', '900', 'core'),
(56, 'analytics_code', '', 'core'),
(39, 'site_language_code', 'en', 'core'),
(40, 'site_text_direction', 'ltr', 'core'),
(41, 'site_charset_encoding', 'UTF-8', 'core'),
(42, 'timezone', 'Europe/London', 'core'),
(45, 'mail_sending_option', 'php', 'core'),
(43, 'date_format', 'F j, Y', 'core'),
(44, 'time_format', 'H:i', 'core'),
(46, 'smtp_user', '[email protected]', 'core'),
(47, 'smtp_password', '', 'core'),
(48, 'smtp_encryption', 'tls', 'core'),
(49, 'site_email', '[email protected]', 'core'),
(50, 'site_email_name', 'Pike Admin', 'core'),
(51, 'smtp_server', 'smtp.mailgun.org', 'core'),
(52, 'sendmail_path', '/usr/sbin/sendmail', 'core'),
(53, 'smtp_port', '587', 'core'),
(54, 'mail_global_signature', '<p></p><hr><strong>Powered by <a href="https://www.pikeadmin.com/" target="_blank">Pike Admin</a></strong><p></p>\r\n\r\n<p>Bootstrap 4 Kit (Admin + Template + CMS Framework)</p>', 'core'),
(55, 'mail_global_css', 'html {\r\n  position: relative;\r\n  min-height: 100%; \r\n  }\r\n\r\nbody {\r\n  font-size: 1rem;\r\n  background-color: #fff;\r\n  font-family: Arial;\r\n  color: #999;\r\n  padding-bottom: 50px; }\r\n\r\na {\r\n    color: #0ca4ca;\r\n    text-decoration: none; }\r\n\r\nhr {\r\n    margin-top: 0.9rem;\r\n    margin-bottom: 1rem;\r\n    border: 0;\r\n    border-top: 1px solid rgba(0,0,0,.1);\r\n}', 'core'),
(67, 'media_big_resize', 'auto', 'core'),
(68, 'media_small_resize', 'crop', 'core'),
(69, 'media_thumb_resize', 'crop', 'core'),
(70, 'media_small_width', '480', 'core'),
(71, 'media_small_height', '350', 'core'),
(72, 'media_thumb_width', '160', 'core'),
(73, 'media_thumb_height', '160', 'core'),
(74, 'active_app_group', 'cms', 'core'),
(149, 'google_maps_location', 'Palas Mall, Iasi, Romania', 'core'),
(84, 'default_role_id', '3', 'core'),
(148, 'google_maps_zoom', '17', 'core'),
(95, 'social_facebook_page', 'https://www.facebook.com/mxscripts', 'core'),
(94, 'facebook_app_id', '43423434', 'core'),
(103, 'currency_display_style', 'value_symbol', 'core'),
(104, 'number_thousands_separator', 'none', 'core'),
(105, 'number_decimal_separator', 'dot', 'core'),
(100, 'logo_small', 'selfie-mobile.jpg', 'core'),
(97, 'google_analytics_ua', '', 'core'),
(98, 'footer_code', '<b>Pike Web Development</b> - https://www.pikeadmin.com\r\n', 'core'),
(99, 'logo', 'new-project-2-.png', 'core'),
(101, 'favicon', 'favicon.ico', 'core'),
(147, 'contact_google_map_enabled', '1', 'core'),
(106, 'currency_name', '', 'core'),
(110, 'active_app_id', '3', 'core'),
(107, 'currency_code', '', 'core'),
(108, 'currency_symbol', '', 'core'),
(109, 'copyright_text', 'Copyright <a href="https://www.pikeadmin.com">Pike Admin</a>. All Rights Reserved.', 'core'),
(125, 'mail_template_forgot_password', 'bggbg', 'core'),
(145, 'contact_page_enabled', '1', 'core'),
(146, 'contact_form_enabled', '1', 'core'),
(130, 'img_large_resize_type', 'portrait', 'cms'),
(129, 'img_thumb_resize_type', 'square', 'cms'),
(131, 'img_large_max_width', '1000', 'core'),
(132, 'img_large_max_height', '500', 'core'),
(133, 'img_thumb_max_width', '450', 'core'),
(134, 'img_thumb_max_height', '300', 'core'),
(135, 'cms_img_large_max_width', '900', 'cms'),
(136, 'cms_img_large_max_height', '450', 'cms'),
(137, 'cms_img_thumb_max_width', '450', 'cms'),
(138, 'cms_img_thumb_max_height', '300', 'cms'),
(151, 'contact_content', '<p><strong>Lorem ipsum dolor sit amet</strong>, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Venenatis tellus in metus vulputate eu scelerisque felis imperdiet proin. </p><p>Tincidunt dui ut ornare lectus sit amet. Vitae sapien pellentesque habitant morbi tristique. Sit amet aliquam id diam maecenas ultricies mi eget. Porttitor massa id neque aliquam vestibulum morbi blandit cursus. At varius vel pharetra vel turpis nunc eget lorem. Dignissim suspendisse in est ante in. Aliquam malesuada bibendum arcu vitae elementum. Vel orci porta non pulvinar.</p><p><a href="https://www.pikeadmin.com" target="_blank"><strong>Pike Admin - Bootstrap 4 kit (admin + template + CMS Framework)</strong></a></p>', 'core');

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

--
-- Table structure for table `sys_currencies`
--

CREATE TABLE IF NOT EXISTS `sys_currencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(100) NOT NULL,
  `c_code` varchar(50) NOT NULL,
  `c_symbol` varchar(50) DEFAULT NULL,
  `is_main` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_currencies`
--

INSERT INTO `sys_currencies` (`id`, `c_name`, `c_code`, `c_symbol`, `is_main`, `active`) VALUES
(2, 'US Dollar', 'USD', '$', 1, 1),
(4, 'Great Britain Pounds', 'GBP', '£', 0, 1),
(13, 'Euro', 'EUR', '€', 0, 1);

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

--
-- Table structure for table `sys_email_templates`
--

CREATE TABLE IF NOT EXISTS `sys_email_templates` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `html` text NOT NULL,
  `plain` text NOT NULL,
  `app` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_email_templates`
--

INSERT INTO `sys_email_templates` (`id`, `name`, `subject`, `html`, `plain`, `app`) VALUES
(1, 'registration', 'Your registration and activation on {{SITE_TITLE}}', '<p>Hello, {{USER_NAME}}</p><p>You just registered on {{SITE_URL}}. You MUST activate verify your email address to login into your account.</p><p><strong>Click here to ACTIVATE YOUR ACCOUNT: {{ACTIVATION_URL}}</strong></p><p>After activation, you can login using your email address - {{USER_EMAIL}} and your password.</p><p>Thank you.</p>', 'Hello, {{USER_NAME}}You just registered on {{SITE_URL}}. You MUST activate verify your email address to login into your account.Click here to ACTIVATE YOUR ACCOUNT: {{ACTIVATION_URL}}After activation, you can login using your email address - {{USER_EMAIL}} and your password.Thank you.', 'core'),
(3, 'welcome', 'Welcome to {{SITE_TITLE}}', '<p style="font-size: 15.2px;">Hello, {{USER_NAME}}</p><p style="font-size: 15.2px;">You just registered on {{SITE_URL}}</p><p style=""><strong><span style="font-size: 15.2px;">You can login here: </span>{{SITE_LOGIN_URL}}<br></strong></p><p style="font-size: 15.2px;">Thank you.</p>', 'Hello, {{USER_NAME}}You just registered on {{SITE_URL}}You can login here: {{SITE_LOGIN_URL}}Thank you.', 'core'),
(4, 'resend_activation', 'New activation code on {{SITE_TITLE}}', '<p>Hello, {{USER_NAME}}</p><p style="">You just require for a new activation code on {{SITE_URL}}</p><p style=""><strong>Click here to ACTIVATE your account: {{RESEND_ACTIVATION_CODE_URL}}</strong></p><p>Thank you.</p>', 'Hello, {{USER_NAME}}You just require for a new activation code on {{SITE_URL}}Click here to ACTIVATE your account: {{RESEND_ACTIVATION_CODE_URL}}Thank you.', 'core'),
(2, 'reset_password', 'Pasword reset on {{SITE_TITLE}}', '<p style="font-size: 15.2px;">Hello, {{USER_NAME}}</p><p style="font-size: 15.2px;">You just require to reset your password on {{SITE_URL}}</p><p style=""><span style="font-size: 15.2px; font-weight: bolder;">Click here to RESET YOUR PASSWORD: {{</span><strong>RESET_PASSWORD_URL</strong><span style="font-size: 15.2px; font-weight: bolder;">}}</span></p><p style=""><span style="font-size: 15.2px;">Thank you.</span></p>', 'Hello, {{USER_NAME}}You just require to reset your password on {{SITE_URL}}Click here to RESET YOUR PASSWORD: {{RESET_PASSWORD_URL}}Thank you.', 'core');

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

--
-- Table structure for table `sys_pages`
--

CREATE TABLE IF NOT EXISTS `sys_pages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `content` mediumtext,
  `active` tinyint(1) NOT NULL,
  `meta_title` text,
  `meta_description` text,
  `enable_site_comments` varchar(3) DEFAULT NULL,
  `enable_fb_comments` varchar(3) DEFAULT NULL,
  `enable_disqus_comments` varchar(3) DEFAULT NULL,
  `redirect_url` varchar(250) DEFAULT NULL,
  `custom_tpl_file` varchar(250) DEFAULT NULL,
  `show_in_header` varchar(3) DEFAULT NULL,
  `show_in_footer` varchar(13) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_pages`
--

INSERT INTO `sys_pages` (`id`, `title`, `slug`, `content`, `active`, `meta_title`, `meta_description`, `enable_site_comments`, `enable_fb_comments`, `enable_disqus_comments`, `redirect_url`, `custom_tpl_file`, `show_in_header`, `show_in_footer`) VALUES
(16, 'Gallery', 'gallery', '', 1, 'Gallery', '', NULL, NULL, NULL, '', 'custom_page_gallery.php', 'on', NULL),
(6, 'Privcacy Policy', 'privacy', '<p><strong>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ullamcorper eget nulla facilisi etiam dignissim diam quis enim. Quis enim lobortis scelerisque fermentum dui. Sollicitudin aliquam ultrices sagittis orci a scelerisque purus. Enim nulla aliquet porttitor lacus luctus accumsan. Lectus proin nibh nisl condimentum id venenatis a condimentum vitae. Diam maecenas sed enim ut sem viverra aliquet eget sit. Eros in cursus turpis massa tincidunt dui ut ornare lectus. Venenatis tellus in metus vulputate eu. Urna id volutpat lacus laoreet non curabitur gravida arcu. Feugiat pretium nibh ipsum consequat.</strong></p><p>Aliquam purus sit amet luctus venenatis lectus. Malesuada fames ac turpis egestas sed tempus urna et. Aliquam id diam maecenas ultricies. Nunc consequat interdum varius sit amet mattis. Bibendum ut tristique et egestas quis ipsum. Quam elementum pulvinar etiam non quam lacus suspendisse faucibus interdum. Mattis rhoncus urna neque viverra justo nec ultrices. Viverra justo nec ultrices dui sapien eget mi. Bibendum enim facilisis gravida neque convallis a cras semper auctor. At consectetur lorem donec massa sapien faucibus et molestie.</p><p>Enim praesent elementum facilisis leo vel fringilla est ullamcorper. Elit at imperdiet dui accumsan. Id diam vel quam elementum. Sed faucibus turpis in eu mi. Nibh tortor id aliquet lectus proin nibh nisl condimentum id. Volutpat odio facilisis mauris sit amet massa vitae tortor. Amet risus nullam eget felis eget nunc. Natoque penatibus et magnis dis. Scelerisque purus semper eget duis at tellus. Purus non enim praesent elementum facilisis leo vel fringilla est. Arcu ac tortor dignissim convallis aenean et tortor at risus. Elit ut aliquam purus sit amet luctus venenatis. Integer enim neque volutpat ac tincidunt vitae semper. Feugiat sed lectus vestibulum mattis ullamcorper velit sed ullamcorper. Mattis rhoncus urna neque viverra.</p>', 1, 'custom meta title', 'custom meta description', NULL, NULL, NULL, '', '', NULL, 'on'),
(8, 'Terms and Conditions', 'terms', '<p><strong>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ullamcorper eget nulla facilisi etiam dignissim diam quis enim. Quis enim lobortis scelerisque fermentum dui. Sollicitudin aliquam ultrices sagittis orci a scelerisque purus. Enim nulla aliquet porttitor lacus luctus accumsan. Lectus proin nibh nisl condimentum id venenatis a condimentum vitae. Diam maecenas sed enim ut sem viverra aliquet eget sit. Eros in cursus turpis massa tincidunt dui ut ornare lectus. Venenatis tellus in metus vulputate eu. Urna id volutpat lacus laoreet non curabitur gravida arcu. Feugiat pretium nibh ipsum consequat.</strong></p><p>Aliquam purus sit amet luctus venenatis lectus. Malesuada fames ac turpis egestas sed tempus urna et. Aliquam id diam maecenas ultricies. Nunc consequat interdum varius sit amet mattis. Bibendum ut tristique et egestas quis ipsum. Quam elementum pulvinar etiam non quam lacus suspendisse faucibus interdum. Mattis rhoncus urna neque viverra justo nec ultrices. Viverra justo nec ultrices dui sapien eget mi. Bibendum enim facilisis gravida neque convallis a cras semper auctor. At consectetur lorem donec massa sapien faucibus et molestie.</p><p>Enim praesent elementum facilisis leo vel fringilla est ullamcorper. Elit at imperdiet dui accumsan. Id diam vel quam elementum. Sed faucibus turpis in eu mi. Nibh tortor id aliquet lectus proin nibh nisl condimentum id. Volutpat odio facilisis mauris sit amet massa vitae tortor. Amet risus nullam eget felis eget nunc. Natoque penatibus et magnis dis. Scelerisque purus semper eget duis at tellus. Purus non enim praesent elementum facilisis leo vel fringilla est. Arcu ac tortor dignissim convallis aenean et tortor at risus. Elit ut aliquam purus sit amet luctus venenatis. Integer enim neque volutpat ac tincidunt vitae semper. Feugiat sed lectus vestibulum mattis ullamcorper velit sed ullamcorper. Mattis rhoncus urna neque viverra.</p>', 1, 'Terms and Conditions', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ullamcorper eget nulla facilisi etiam dignissim diam quis enim. Quis enim lobortis scelerisque fermentum dui. Sollicitudin ali', NULL, NULL, NULL, '', '', NULL, 'on'),
(9, 'About', 'about-us', '<p><strong>Lorem ipsum dolor sit amet</strong>, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ullamcorper eget nulla facilisi etiam dignissim diam quis enim. Quis enim lobortis scelerisque fermentum dui. Sollicitudin aliquam ultrices sagittis orci a scelerisque purus. Enim nulla aliquet porttitor lacus luctus accumsan. Lectus proin nibh nisl condimentum id venenatis a condimentum vitae. Diam maecenas sed enim ut sem viverra aliquet eget sit. Eros in cursus turpis massa tincidunt dui ut ornare lectus. Venenatis tellus in metus vulputate eu. Urna id volutpat lacus laoreet non curabitur gravida arcu. Feugiat pretium nibh ipsum consequat.</p><p>Aliquam purus sit amet luctus venenatis lectus. Malesuada fames ac turpis egestas sed tempus urna et. Aliquam id diam maecenas ultricies. Nunc consequat interdum varius sit amet mattis. Bibendum ut tristique et egestas quis ipsum. Quam elementum pulvinar etiam non quam lacus suspendisse faucibus interdum. Mattis rhoncus urna neque viverra justo nec ultrices. Viverra justo nec ultrices dui sapien eget mi. Bibendum enim facilisis gravida neque convallis a cras semper auctor. At consectetur lorem donec massa sapien faucibus et molestie.</p><p>Enim praesent elementum facilisis leo vel fringilla est ullamcorper. Elit at imperdiet dui accumsan. Id diam vel quam elementum. Sed faucibus turpis in eu mi. Nibh tortor id aliquet lectus proin nibh nisl condimentum id. Volutpat odio facilisis mauris sit amet massa vitae tortor. Amet risus nullam eget felis eget nunc. Natoque penatibus et magnis dis. Scelerisque purus semper eget duis at tellus. Purus non enim praesent elementum facilisis leo vel fringilla est. Arcu ac tortor dignissim convallis aenean et tortor at risus. Elit ut aliquam purus sit amet luctus venenatis. Integer enim neque volutpat ac tincidunt vitae semper. Feugiat sed lectus vestibulum mattis ullamcorper velit sed ullamcorper. Mattis rhoncus urna neque viverra.</p>', 1, 'About us custom meta title', 'About us custom meta description', NULL, NULL, 'on', '', '', 'on', 'on');

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

--
-- Table structure for table `sys_pages_comments`
--

CREATE TABLE IF NOT EXISTS `sys_pages_comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `page_id` int(10) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `website` varchar(250) DEFAULT NULL,
  `content` text NOT NULL,
  `date` datetime NOT NULL,
  `ip` varchar(50) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sys_users`
--

CREATE TABLE IF NOT EXISTS `sys_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(150) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `avatar` varchar(100) DEFAULT NULL,
  `password` varchar(60) NOT NULL,
  `token` varchar(100) DEFAULT NULL,
  `role_id` int(3) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `email_verified` tinyint(1) NOT NULL,
  `protected` tinyint(1) DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_users`
--

INSERT INTO `sys_users` (`id`, `email`, `name`, `slug`, `avatar`, `password`, `token`, `role_id`, `active`, `email_verified`, `protected`, `last_activity`) VALUES
(35, '[email protected]', 'Admin Default', 'admin-default', 'd62c6783-admin.jpg', '$2a$08$tqJuAqMYAXg8.DtcAa.tqOkAwzdRG5LSv0krrMDiB29UGVththnDe', '2135679d331d6e9fc3ce4c5760f3b7cd0ef1e1584aca1fdd43392a5f779a4da7', 1, 1, 1, 1, '2019-06-15 00:02:21'),
(59, '[email protected]', 'Test user', 'test-user', '22d0749a-avatar6.png', '$2a$08$XuKn9LQwfY6/CK5gzQdkuul0II8FYbbIHmLoe/5Y/eSkB90RGtLQi', NULL, 3, 1, 1, NULL, NULL);

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

--
-- Table structure for table `sys_users_extra_keys`
--

CREATE TABLE IF NOT EXISTS `sys_users_extra_keys` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `extra_key` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_users_extra_keys`
--

INSERT INTO `sys_users_extra_keys` (`id`, `extra_key`) VALUES
(1, 'register_time'),
(2, 'social_facebook_page'),
(3, 'register_ip'),
(4, 'register_host'),
(5, 'activation_code');

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

--
-- Table structure for table `sys_users_extra_values`
--

CREATE TABLE IF NOT EXISTS `sys_users_extra_values` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `key_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `value` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_users_extra_values`
--

INSERT INTO `sys_users_extra_values` (`id`, `key_id`, `user_id`, `value`) VALUES
(1, 1, 35, '2019-01-15 20:51:27'),
(94, 5, 59, 'a0252c91893178e0'),
(93, 4, 59, '86.124.41.21'),
(92, 3, 59, '86.124.41.21'),
(91, 1, 59, '2019-06-15 00:34:12');

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

--
-- Table structure for table `sys_users_roles`
--

CREATE TABLE IF NOT EXISTS `sys_users_roles` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `role` varchar(100) NOT NULL,
  `title` varchar(250) NOT NULL,
  `app_id` int(5) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `description` text NOT NULL,
  `is_internal` tinyint(1) NOT NULL,
  `protected` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_users_roles`
--

INSERT INTO `sys_users_roles` (`id`, `role`, `title`, `app_id`, `active`, `description`, `is_internal`, `protected`) VALUES
(1, 'admin', 'Administrator', NULL, 1, 'Have full access to all sections', 1, 1),
(2, 'editor', 'Editor', NULL, 1, 'Can add content. Manage any content from any user.', 1, 1),
(3, 'user', 'User', NULL, 1, 'Registered user', 0, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cms_posts`
--
ALTER TABLE `cms_posts` ADD FULLTEXT KEY `title` (`title`);

/*!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 */;