-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Июн 14 2015 г., 10:50
-- Версия сервера: 5.5.43
-- Версия PHP: 5.3.10-1ubuntu3.18

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

--
-- База данных: `m001`
--

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

--
-- Структура таблицы `aw_blog`
--

CREATE TABLE IF NOT EXISTS `aw_blog` (
  `post_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `post_content` text NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '0',
  `created_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `identifier` varchar(255) NOT NULL DEFAULT '',
  `user` varchar(255) NOT NULL DEFAULT '',
  `update_user` varchar(255) NOT NULL DEFAULT '',
  `meta_keywords` text NOT NULL,
  `meta_description` text NOT NULL,
  `comments` tinyint(11) NOT NULL,
  `tags` text NOT NULL,
  `short_content` text NOT NULL,
  PRIMARY KEY (`post_id`),
  UNIQUE KEY `identifier` (`identifier`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Дамп данных таблицы `aw_blog`
--

INSERT INTO `aw_blog` (`post_id`, `title`, `post_content`, `status`, `created_time`, `update_time`, `identifier`, `user`, `update_user`, `meta_keywords`, `meta_description`, `comments`, `tags`, `short_content`) VALUES
(1, 'Hello World', '<p>Welcome to Magento Blog by aheadWorks Co. This is your first post. Edit or delete it, then start blogging!</p>', 1, '2010-09-06 07:28:34', '2015-06-07 01:41:50', 'Hello', 'Joe Blogs', 'admin admin', 'Keywords', 'Description', 0, '', ''),
(2, 'japan-disable-tag1', '<p>Content</p>', 2, '2015-06-06 19:32:06', '2015-06-07 06:46:01', 'test', 'Dante', 'admin admin', '', '', 0, 'tag1', '<p>Short Content</p>'),
(4, 'No category', '', 1, '2015-06-07 06:40:09', NULL, 'no-cat', 'admin admin', 'admin admin', '', '', 0, '', ''),
(5, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:43:14', 'test1', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(6, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:43:26', 'test2', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(7, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:43:36', 'test3', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(8, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:43:45', 'test4', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(9, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:44:02', 'test5', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(10, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:44:23', 'test6', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(11, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:45:08', 'test7', 'Dante', 'admin admin', '', '', 0, 'tag1,tag2', '<p>Short Content</p>'),
(12, 'belarus-enable-tag2', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:46:59', 'test8', 'Dante', 'admin admin', '', '', 0, 'tag2', '<p>Short Content</p>'),
(13, 'belarus-hidden-tag3-faq', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:47:45', 'test9', 'Dante', 'admin admin', '', '', 0, 'tag3', '<p>Short Content</p>'),
(14, 'belarus-hidden-tag3-faq', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:50:34', 'test91', 'Dante', 'admin admin', '', '', 0, 'tag3', '<p>Short Content</p>'),
(15, 'Hello World', '<p>Welcome to Magento Blog by aheadWorks Co. This is your first post. Edit or delete it, then start blogging!</p>', 1, '2010-09-06 07:28:34', '2015-06-07 06:50:46', 'Hello1', 'Joe Blogs', 'admin admin', 'Keywords', 'Description', 0, '', ''),
(16, 'Hello World', '<p>Welcome to Magento Blog by aheadWorks Co. This is your first post. Edit or delete it, then start blogging!</p>', 1, '2010-09-06 07:28:34', '2015-06-07 06:51:01', 'Hello11', 'Joe Blogs', 'admin admin', 'Keywords', 'Description', 0, '', ''),
(17, 'japan-disable-tag1', '<p>Content</p>', 2, '2015-06-06 19:32:06', '2015-06-07 06:51:15', 'test10', 'Dante', 'admin admin', '', '', 0, 'tag1', '<p>Short Content</p>'),
(18, 'No category', '', 1, '2015-06-07 06:40:09', '2015-06-07 06:51:28', 'no-cat1', 'admin admin', 'admin admin', '', '', 0, '', ''),
(19, 'No category', '', 1, '2015-06-07 06:40:09', '2015-06-07 06:51:34', 'no-cat11', 'admin admin', 'admin admin', '', '', 0, '', ''),
(20, 'japan-disable-tag1', '<p>Content</p>', 2, '2015-06-06 19:32:06', '2015-06-07 06:51:44', 'test11', 'Dante', 'admin admin', '', '', 0, 'tag1', '<p>Short Content</p>'),
(21, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:51:54', 'test31', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(22, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:52:38', 'test51', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>'),
(23, 'Test', '<p>Content</p>', 1, '2015-06-06 19:32:06', '2015-06-07 06:52:47', 'test32', 'admin admin', 'admin admin', '', '', 0, '', '<p>Short Content</p>');

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

--
-- Структура таблицы `aw_blog_cat`
--

CREATE TABLE IF NOT EXISTS `aw_blog_cat` (
  `cat_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `identifier` varchar(255) NOT NULL DEFAULT '',
  `sort_order` tinyint(6) NOT NULL,
  `meta_keywords` text NOT NULL,
  `meta_description` text NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Дамп данных таблицы `aw_blog_cat`
--

INSERT INTO `aw_blog_cat` (`cat_id`, `title`, `identifier`, `sort_order`, `meta_keywords`, `meta_description`) VALUES
(1, 'News', 'news', 0, '', ''),
(2, 'FAQ', 'faq', 0, '', '');

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

--
-- Структура таблицы `aw_blog_post_cat`
--

CREATE TABLE IF NOT EXISTS `aw_blog_post_cat` (
  `cat_id` smallint(6) unsigned DEFAULT NULL,
  `post_id` smallint(6) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `aw_blog_post_cat`
--

INSERT INTO `aw_blog_post_cat` (`cat_id`, `post_id`) VALUES
(1, 1),
(1, 3),
(1, 5),
(2, 5),
(1, 6),
(2, 6),
(1, 7),
(2, 7),
(1, 8),
(2, 8),
(2, 9),
(1, 10),
(1, 11),
(1, 2),
(1, 12),
(2, 13),
(2, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(2, 18),
(1, 19),
(2, 19),
(1, 20),
(1, 21),
(2, 21),
(2, 22),
(1, 23),
(2, 23);

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

--
-- Структура таблицы `aw_blog_store`
--

CREATE TABLE IF NOT EXISTS `aw_blog_store` (
  `post_id` smallint(6) unsigned DEFAULT NULL,
  `store_id` smallint(6) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `aw_blog_store`
--

INSERT INTO `aw_blog_store` (`post_id`, `store_id`) VALUES
(1, 8),
(1, 1),
(1, 3),
(1, 2),
(1, 4),
(3, 4),
(3, 8),
(3, 1),
(3, 3),
(3, 2),
(4, 8),
(4, 1),
(4, 3),
(4, 2),
(4, 4),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 8),
(9, 1),
(9, 3),
(9, 2),
(9, 4),
(10, 4),
(10, 8),
(10, 1),
(10, 3),
(10, 2),
(11, 4),
(11, 8),
(11, 1),
(11, 3),
(11, 2),
(2, 4),
(12, 8),
(13, 8),
(14, 8),
(15, 4),
(15, 8),
(15, 1),
(15, 3),
(15, 2),
(16, 4),
(16, 8),
(16, 1),
(16, 3),
(16, 2),
(17, 4),
(18, 4),
(18, 8),
(18, 1),
(18, 3),
(18, 2),
(19, 4),
(19, 8),
(19, 1),
(19, 3),
(19, 2),
(20, 4),
(21, 1),
(22, 4),
(22, 8),
(22, 1),
(22, 3),
(22, 2),
(23, 1);

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