-- Adminer 4.1.0 MySQL dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

CREATE TABLE `modx_active_users` (
  `internalKey` int(9) NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '',
  `lasthit` int(20) NOT NULL DEFAULT '0',
  `id` int(10) DEFAULT NULL,
  `action` varchar(10) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`internalKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data about active users.';


CREATE TABLE `modx_a_delivery` (
  `delivery_id` int(11) NOT NULL AUTO_INCREMENT,
  `delivery_title` varchar(64) NOT NULL DEFAULT '0',
  `delivery_cost` int(11) NOT NULL DEFAULT '0',
  `delivery_default` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`delivery_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_delivery` (`delivery_id`, `delivery_title`, `delivery_cost`, `delivery_default`) VALUES
(1,	'Courier',	50,	0),
(2,	'USPS',	10,	0),
(3,	'Pickup',	0,	1);

CREATE TABLE `modx_a_fc` (
  `filter_id` int(11) NOT NULL,
  `modx_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  UNIQUE KEY `filter_id_modx_id` (`filter_id`,`modx_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_fc` (`filter_id`, `modx_id`, `position`) VALUES
(6,	20,	0),
(6,	14,	0),
(6,	18,	0),
(6,	19,	0),
(6,	17,	0),
(6,	13,	0),
(6,	15,	0),
(6,	23,	0),
(6,	8,	0),
(6,	6,	0),
(6,	7,	0),
(4,	20,	0),
(4,	14,	0),
(4,	18,	0),
(4,	19,	0),
(4,	17,	0),
(4,	13,	0),
(4,	15,	0),
(4,	23,	0),
(4,	8,	0),
(4,	6,	0),
(4,	7,	0),
(7,	13,	0),
(7,	7,	0);

CREATE TABLE `modx_a_filters` (
  `filter_id` int(11) NOT NULL AUTO_INCREMENT,
  `filter_name` varchar(64) NOT NULL,
  `filter_desc` text NOT NULL,
  `filter_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - числовой 2 - или 3 - и',
  PRIMARY KEY (`filter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_filters` (`filter_id`, `filter_name`, `filter_desc`, `filter_type`) VALUES
(4,	'Weight',	'weight in gramm',	1),
(7,	'Pieces',	'Number of pieces in portion',	3),
(6,	'Vegan',	'Did is vegan good?',	2);

CREATE TABLE `modx_a_lang` (
  `lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `ua` text NOT NULL COMMENT 'ua',
  `en` text NOT NULL COMMENT 'en',
  `ru` text NOT NULL COMMENT 'ru',
  PRIMARY KEY (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_lang` (`lang_id`, `ua`, `en`, `ru`) VALUES
(1,	'Кошик',	'Cart',	'Корзина'),
(2,	'порожнiй',	'is empty',	'пуста'),
(3,	'Увiйти',	'Sign in',	'Войти'),
(4,	'Вийти',	'Log out',	'Выйти'),
(5,	'Шукати',	'Search',	'Найти'),
(6,	'Введiть назву товару для пошуку',	'Enter product title to search',	'Введите название товара для поиска'),
(7,	'Підписатися',	'Subscribe',	'Подписаться'),
(8,	'',	'Price',	''),
(9,	'',	'Filter',	''),
(10,	'',	'Reset filters',	''),
(11,	'',	'Sort by price',	''),
(12,	'',	'from cheap to expensive',	''),
(13,	'',	'from expensive to cheap',	''),
(14,	'',	'Sort by status',	''),
(15,	'',	'Available',	''),
(16,	'',	'New',	''),
(17,	'',	'Popular',	''),
(18,	'',	'Sale',	''),
(19,	'',	'Buy',	'');

CREATE TABLE `modx_a_mailer` (
  `tpl_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `mailed` tinyint(4) NOT NULL DEFAULT '0',
  UNIQUE KEY `tpl_id_user_id` (`tpl_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_mailer` (`tpl_id`, `user_id`, `mailed`) VALUES
(2,	2,	1);

CREATE TABLE `modx_a_mailer_templates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `template_subject` varchar(512) NOT NULL,
  `template_post` text NOT NULL,
  PRIMARY KEY (`template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `modx_a_mailer_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(32) NOT NULL,
  `user_email` varchar(64) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `modx_a_mail_templates` (
  `mail_name` varchar(16) NOT NULL,
  `mail_lang` char(2) NOT NULL,
  `mail_title` varchar(32) NOT NULL,
  `mail_subject` varchar(1024) NOT NULL,
  `mail_template` mediumtext NOT NULL,
  UNIQUE KEY `mail_name_mail_lang` (`mail_name`,`mail_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_mail_templates` (`mail_name`, `mail_lang`, `mail_title`, `mail_subject`, `mail_template`) VALUES
('register',	'en',	'Registration',	'Registration on site',	'<p>Your username and password</p>\r\n<table>\r\n	<tr>\r\n		<td>Login</td>\r\n		<td>{email}</td>\r\n	</tr>\r\n	<tr>\r\n		<td>Password</td>\r\n		<td>{password}</td>\r\n	</tr>\r\n</table>'),
('recovery',	'en',	'Password recovery',	'Password recovery',	'<ol>\r\n	<li>\r\n		For password confirm go to <a href=\"{confirm_url}\" target=\"_blank\">this link</a>\r\n	</li>\r\n	<li>Your new pasword <b>{password}</b></li>\r\n</ol>'),
('meta',	'en',	'General template (META)',	'',	'<!doctype html>\r\n<html lang=\"en\">\r\n<head>\r\n	<meta charset=\"UTF-8\">\r\n	<title>Document</title>\r\n</head>\r\n<body>\r\n	<h1 style=\"padding:10px 20px;background:#0080ff;color:white;text-shadow:1px 1px 0px black;\">[(site_name)]</h1>\r\n	{body}\r\n</body>\r\n</html>'),
('order',	'en',	'Create order',	'New order',	'<table border=\"1\" style=\"border-collapse:collapse;\" cellpadding=\"3\">\r\n	<tr>\r\n		<td colspan=\"2\">Product</td>\r\n		<td>Price</td>\r\n		<td>Quantity</td>\r\n		<td>Total</td>\r\n	</tr>\r\n	{items}\r\n	<tr>\r\n		<td colspan=\"4\">Delivery</td>\r\n		<td>{delivery_cost}</td>\r\n	</tr>\r\n	<tr>\r\n		<td colspan=\"4\">Total</td>\r\n		<td>{total} [(currency)]</td>\r\n	</tr>\r\n</table>');

CREATE TABLE `modx_a_newpost_wh` (
  `wh_id` int(11) NOT NULL,
  `wh_cityid` int(11) NOT NULL,
  `wh_city` varchar(128) NOT NULL,
  `wh_name` varchar(1024) NOT NULL,
  `pos_lat` float NOT NULL,
  `pos_lng` float NOT NULL,
  PRIMARY KEY (`wh_id`),
  KEY `wh_cityid` (`wh_cityid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `modx_a_order` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_created` datetime DEFAULT NULL,
  `order_status` tinyint(4) DEFAULT '1' COMMENT '0 del 1 new 2 work 3 done',
  `order_status_pay` tinyint(4) DEFAULT '0' COMMENT '0 wait pay 1 payed',
  `order_client` int(11) DEFAULT NULL,
  `order_manager` int(11) DEFAULT '0',
  `order_delivery` tinytext,
  `order_delivery_cost` int(11) DEFAULT NULL,
  `order_cost` float(7,2) DEFAULT NULL,
  `order_comment` text,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `modx_a_order_products` (
  `order_id` int(11) NOT NULL DEFAULT '0',
  `product_id` int(11) DEFAULT '0',
  `product_count` int(11) DEFAULT '0',
  `product_price` float(7,2) DEFAULT '0.00',
  UNIQUE KEY `order_id_product_id` (`order_id`,`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `modx_a_pro2cat` (
  `link_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `modx_id` int(11) NOT NULL,
  PRIMARY KEY (`link_id`),
  UNIQUE KEY `product_id_modx_id` (`product_id`,`modx_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Связь товара с категорией';

INSERT INTO `modx_a_pro2cat` (`link_id`, `product_id`, `modx_id`) VALUES
(111,	2,	6),
(108,	3,	6),
(117,	4,	14),
(118,	5,	14),
(119,	6,	13),
(121,	7,	13),
(122,	8,	13),
(135,	9,	7),
(124,	10,	7),
(125,	11,	7),
(126,	12,	8),
(127,	13,	8),
(128,	14,	8),
(97,	15,	15),
(96,	16,	15),
(129,	17,	13),
(94,	18,	6),
(130,	19,	17),
(92,	20,	15),
(131,	21,	13),
(91,	22,	6),
(132,	23,	18),
(88,	24,	19),
(87,	25,	20),
(86,	26,	6),
(115,	27,	20),
(85,	28,	20),
(114,	29,	20),
(84,	30,	19),
(133,	31,	23),
(134,	32,	17),
(112,	33,	20);

CREATE TABLE `modx_a_pro2val` (
  `pv_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `filter_id` int(11) NOT NULL,
  `value_id` int(11) NOT NULL,
  PRIMARY KEY (`pv_id`),
  UNIQUE KEY `product_id_filter_id` (`product_id`,`filter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_pro2val` (`pv_id`, `product_id`, `filter_id`, `value_id`) VALUES
(155,	32,	6,	390),
(154,	32,	7,	275),
(93,	33,	4,	346),
(94,	33,	6,	347),
(153,	32,	4,	389),
(100,	29,	6,	351),
(98,	29,	4,	350),
(99,	29,	7,	278),
(103,	27,	6,	353),
(101,	27,	4,	352),
(102,	27,	7,	281),
(152,	31,	6,	388),
(151,	31,	4,	387),
(20,	30,	4,	285),
(21,	30,	7,	286),
(22,	30,	6,	287),
(23,	28,	4,	288),
(24,	28,	7,	289),
(25,	28,	6,	290),
(26,	26,	4,	291),
(27,	26,	6,	292),
(28,	25,	4,	293),
(29,	25,	7,	286),
(30,	25,	6,	294),
(31,	24,	4,	295),
(32,	24,	7,	281),
(33,	24,	6,	296),
(150,	23,	6,	386),
(149,	23,	4,	385),
(148,	21,	6,	384),
(146,	21,	4,	383),
(147,	21,	7,	300),
(39,	22,	4,	302),
(40,	22,	6,	303),
(41,	20,	4,	304),
(42,	20,	6,	305),
(145,	19,	6,	382),
(143,	19,	4,	381),
(144,	19,	7,	281),
(46,	18,	4,	308),
(47,	18,	6,	309),
(142,	17,	6,	380),
(140,	17,	4,	379),
(141,	17,	7,	311),
(51,	16,	4,	313),
(52,	16,	6,	314),
(53,	15,	4,	315),
(54,	15,	6,	316),
(139,	14,	6,	378),
(137,	14,	4,	377),
(138,	14,	7,	289),
(136,	13,	6,	376),
(134,	13,	4,	375),
(135,	13,	7,	289),
(133,	12,	6,	374),
(132,	12,	4,	373),
(131,	11,	6,	372),
(129,	11,	4,	371),
(130,	11,	7,	275),
(128,	10,	6,	370),
(126,	10,	4,	369),
(127,	10,	7,	326),
(157,	9,	7,	281),
(158,	9,	6,	392),
(156,	9,	4,	391),
(122,	8,	6,	366),
(120,	8,	4,	365),
(121,	8,	7,	281),
(118,	7,	7,	311),
(119,	7,	6,	364),
(117,	7,	4,	363),
(112,	5,	6,	359),
(110,	5,	4,	358),
(111,	5,	7,	289),
(109,	4,	6,	357),
(107,	4,	4,	356),
(108,	4,	7,	289),
(84,	3,	4,	338),
(85,	3,	6,	339),
(92,	2,	6,	345),
(91,	2,	4,	344),
(113,	6,	6,	360);

CREATE TABLE `modx_a_products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_code` varchar(32) NOT NULL,
  `product_created` datetime NOT NULL,
  `product_edited` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `product_available` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 нет в наличие 1 есть 2 новинка 3 хит 4 акция',
  `product_visible` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 no 1 yes',
  `product_url` varchar(255) NOT NULL,
  `product_cover` varchar(32) NOT NULL,
  `product_price` float(7,2) NOT NULL,
  `product_friends` varchar(64) NOT NULL COMMENT 'сопутствующие товары',
  `product_articles` varchar(64) NOT NULL,
  `product_brand` int(11) NOT NULL,
  `tv_seo_title` varchar(1024) NOT NULL,
  `tv_seo_keywords` varchar(1024) NOT NULL,
  `tv_seo_description` text NOT NULL,
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `product_code` (`product_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Товары';

INSERT INTO `modx_a_products` (`product_id`, `product_code`, `product_created`, `product_edited`, `product_available`, `product_visible`, `product_url`, `product_cover`, `product_price`, `product_friends`, `product_articles`, `product_brand`, `tv_seo_title`, `tv_seo_keywords`, `tv_seo_description`) VALUES
(2,	'2',	'2014-06-27 14:06:57',	'2014-06-27 11:07:32',	1,	1,	'wide-eel/',	'0781980001403867212.jpg',	33.95,	'',	'',	0,	'',	'',	''),
(3,	'1403867608',	'2014-06-27 14:13:28',	'2014-06-27 11:13:54',	1,	1,	'suimono/',	'0875390001403867603.jpg',	31.95,	'',	'',	0,	'',	'',	''),
(4,	'4',	'2014-06-27 14:16:52',	'2014-07-02 11:19:36',	1,	1,	'salmon/',	'0027907001403867809.jpg',	5.00,	'',	'',	0,	'',	'',	''),
(5,	'5',	'2014-06-27 14:19:20',	'2014-07-02 11:19:30',	1,	1,	'tuna/',	'0340513001403867953.jpg',	6.00,	'',	'',	0,	'',	'',	''),
(6,	'6',	'2014-06-27 14:22:55',	'2014-07-02 11:19:27',	1,	1,	'wasabi-roll/',	'0852756001403868170.jpg',	7.00,	'',	'',	0,	'',	'',	''),
(7,	'7',	'2014-06-27 14:26:50',	'2014-07-02 11:19:22',	1,	1,	'futomaki/',	'0334528001403868405.jpg',	8.00,	'',	'',	0,	'',	'',	''),
(8,	'8',	'2014-06-27 14:29:11',	'2014-07-02 11:19:19',	1,	1,	'philadelphia/',	'0032543001403868547.jpg',	8.00,	'',	'',	0,	'Philadelphia',	'',	''),
(9,	'9',	'2014-06-27 14:32:33',	'2014-07-29 17:05:11',	4,	1,	'flying-fish/',	'0881537001403868750.jpg',	99.00,	'',	'',	0,	'',	'',	''),
(10,	'10',	'2014-06-27 14:35:25',	'2014-07-02 11:19:10',	1,	1,	'hiashi-wakame/',	'0076678001403868918.jpg',	6.00,	'',	'',	0,	'',	'',	''),
(11,	'11',	'2014-06-27 14:39:13',	'2014-07-02 11:19:06',	1,	1,	'salmon1/',	'0533448001403869148.jpg',	5.00,	'',	'',	0,	'',	'',	''),
(12,	'12',	'2014-06-27 15:19:08',	'2014-07-02 11:18:59',	1,	1,	'smoked salmon/',	'0983170001403871542.jpg',	4.00,	'',	'',	0,	'',	'',	''),
(13,	'13',	'2014-06-27 15:21:56',	'2014-07-02 11:18:55',	1,	1,	'red-grouper/',	'0627265001403871713.jpg',	4.00,	'',	'',	0,	'',	'',	''),
(14,	'14',	'2014-06-27 15:27:19',	'2014-07-02 11:18:34',	1,	1,	'caviar/',	'0067308001403872026.jpg',	5.00,	'',	'',	0,	'',	'',	''),
(15,	'15',	'2014-06-27 15:30:10',	'2014-06-27 12:31:49',	1,	1,	'salad-with-salmon/',	'0652711001403872305.jpg',	22.95,	'',	'',	0,	'',	'',	''),
(16,	'16',	'2014-06-27 15:34:36',	'2014-06-27 12:34:36',	1,	1,	'salad-with-shrimp/',	'0130810001403872473.jpg',	24.95,	'',	'',	0,	'',	'',	''),
(17,	'17',	'2014-06-27 15:39:41',	'2014-07-02 11:18:22',	1,	1,	'egoist/',	'0412830001403872776.jpg',	8.00,	'',	'',	0,	'',	'',	''),
(18,	'18',	'2014-06-27 15:44:21',	'2014-06-27 12:44:21',	1,	1,	'wakame/',	'0255707001403873056.jpg',	20.95,	'',	'',	0,	'',	'',	''),
(19,	'19',	'2014-07-01 09:00:53',	'2014-07-02 11:18:12',	1,	1,	'Pizza/',	'0604958001404194446.jpg',	6.00,	'',	'',	0,	'Pizza',	'',	''),
(20,	'20',	'2014-07-01 09:12:23',	'2014-07-01 06:18:27',	1,	1,	'Salad-with-fork-and-tomato/',	'0969552001404195139.jpg',	780.00,	'',	'',	0,	'',	'',	''),
(21,	'21',	'2014-07-01 09:17:06',	'2014-07-29 17:02:48',	1,	1,	'sushi-roll/',	'0255228001404195414.jpg',	50.00,	'',	'',	0,	'three sushi rolls',	'',	''),
(22,	'22',	'2014-07-01 09:28:45',	'2014-07-01 06:28:45',	1,	1,	'chicken-soup/',	'0454588001404196120.jpg',	788.00,	'',	'',	0,	'',	'',	''),
(23,	'23',	'2014-07-01 09:32:49',	'2014-07-02 11:17:57',	1,	1,	'pasta-collection/',	'0372698001404196296.jpg',	5.00,	'',	'',	0,	'',	'',	''),
(24,	'24',	'2014-07-01 09:39:26',	'2014-07-01 06:39:26',	1,	1,	'cabbage-rolls/',	'0063716001404196763.jpg',	430.00,	'',	'',	0,	'',	'',	''),
(25,	'25',	'2014-07-01 09:43:26',	'2014-07-01 06:43:26',	1,	1,	'pancakes/',	'0280234001404197001.jpg',	789.00,	'',	'',	0,	'',	'',	''),
(26,	'26',	'2014-07-01 09:58:19',	'2014-07-01 06:59:07',	1,	1,	'red-soup-borsch/',	'0495028001404197893.jpg',	206.00,	'',	'',	0,	'',	'',	''),
(27,	'27',	'2014-07-01 10:22:12',	'2014-07-01 08:00:15',	1,	1,	'white-cake/',	'0950637001404199327.jpg',	435.00,	'',	'',	0,	'',	'',	''),
(28,	'28',	'2014-07-01 10:27:55',	'2014-07-01 07:27:55',	1,	1,	'donuts/',	'0800266001404199670.jpg',	206.00,	'',	'',	0,	'',	'',	''),
(29,	'29',	'2014-07-01 10:33:37',	'2014-07-01 08:00:49',	1,	1,	'cheesecake-with-cherry-topping/',	'0743617001404200004.jpg',	432.00,	'',	'',	0,	'',	'',	''),
(30,	'30',	'2014-07-01 10:36:17',	'2014-07-01 07:36:33',	1,	1,	'vareniks-with-cheese/',	'0360859001404200162.jpg',	206.00,	'',	'',	0,	'',	'',	''),
(31,	'31',	'2014-07-01 10:40:13',	'2014-07-02 11:17:43',	1,	1,	'sandwich/',	'0335538001404200370.jpg',	3.00,	'',	'',	0,	'',	'',	''),
(32,	'32',	'2014-07-01 11:18:35',	'2014-07-02 11:17:22',	1,	1,	'tomato-mozzarella/',	'0837410001404202710.jpg',	7.00,	'',	'',	0,	'',	'',	''),
(33,	'33',	'2014-07-01 11:20:08',	'2014-07-01 08:20:08',	1,	1,	'fruit-salad/',	'0449756001404202803.jpg',	206.00,	'',	'',	0,	'',	'',	'');

CREATE TABLE `modx_a_product_strings` (
  `product_id` int(11) NOT NULL DEFAULT '0',
  `translate_lang` char(2) DEFAULT 'ru',
  `product_name` varchar(512) DEFAULT NULL,
  `product_introtext` tinytext,
  `product_description` mediumtext,
  UNIQUE KEY `product_id_translate_lang` (`product_id`,`translate_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Языковые переводы названий, описаний товаров';

INSERT INTO `modx_a_product_strings` (`product_id`, `translate_lang`, `product_name`, `product_introtext`, `product_description`) VALUES
(2,	'ua',	'Місо-широ з вугром',	'<p>Склад: водорості вакаме, гриб шиітаке, зелена цибуля, місо паста, перепелине яйце, рибний бульйон, насіння кунжуту, тофу, вугор</p>',	'<p>Склад: водорості вакаме, гриб шиітаке, зелена цибуля, місо паста, перепелине яйце, рибний бульйон, насіння кунжуту, тофу, вугор</p>'),
(2,	'ru',	'Мисо-широ с угрём',	'<p>Состав: водоросли вакаме, гриб шиитаке, зеленый лук, мисо паста, перепелиное яйцо, рыбный бульон, семена кунжута, тофу, угорь</p>',	'<p>Состав: водоросли вакаме, гриб шиитаке, зеленый лук, мисо паста, перепелиное яйцо, рыбный бульон, семена кунжута, тофу, угорь</p>'),
(2,	'en',	'Miso-wide eel',	'<p>Ingredients: Wakame seaweed, shiitake mushrooms, green onions, miso paste, quail egg, fish broth, sesame seeds, tofu, eel</p>',	'<p>Ingredients: Wakame seaweed, shiitake mushrooms, green onions, miso paste, quail egg, fish broth, sesame seeds, tofu, eel</p>'),
(3,	'ua',	'Суімоно з морепродуктами',	'<p>Склад: водорості вакаме, гриб шиітаке, зелена цибуля, лосось, майонез, морський коктейль, рибний бульйон, соєвий соус, спеції, тофу</p>',	'<p>Склад: водорості вакаме, гриб шиітаке, зелена цибуля, лосось, майонез, морський коктейль, рибний бульйон, соєвий соус, спеції, тофу</p>'),
(3,	'ru',	'Суимоно с морепродуктами',	'<p>Состав: водоросли вакаме, гриб шиитаке, зеленый лук, лосось, майонез, морской коктейль, рыбный бульон, соевый соус, специи, тофу</p>',	'<p>Состав: водоросли вакаме, гриб шиитаке, зеленый лук, лосось, майонез, морской коктейль, рыбный бульон, соевый соус, специи, тофу</p>'),
(3,	'en',	'Suimono with seafood',	'<p>Ingredients: Wakame seaweed, shiitake mushrooms, green onions, salmon, mayonnaise, seafood mix, fish broth, soy sauce, spices, tofu</p>',	'<p>Ingredients: Wakame seaweed, shiitake mushrooms, green onions, salmon, mayonnaise, seafood mix, fish broth, soy sauce, spices, tofu</p>'),
(4,	'ua',	'З лососем',	'<p>Склад: водорості норі, лосось, огірок, рис</p>',	'<p>Склад: водорості норі, лосось, огірок, рис</p>'),
(4,	'ru',	'С лососем',	'<p>Состав: водоросли нори, лосось, огурец, рис</p>',	'<p>Состав: водоросли нори, лосось, огурец, рис</p>'),
(4,	'en',	'With salmon',	'<p>Ingredients: seaweed, salmon, cucumber, rice</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(5,	'ua',	'З тунцем',	'<p>Склад: водорості норі, огірок, рис, тунець</p>',	'<p>Склад: водорості норі, огірок, рис, тунець</p>'),
(5,	'ru',	'С тунцом',	'<p>Состав: водоросли нори, огурец, рис, тунец</p>',	'<p>Состав: водоросли нори, огурец, рис, тунец</p>'),
(5,	'en',	'With tuna',	'<p>Ingredients: seaweed, cucumber, rice, tuna</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(6,	'ua',	'Васабі рол',	'<p>Склад: васабі, водорості норі, животик лосося, рис, чорний кунжут</p>',	'<p>Склад: васабі, водорості норі, животик лосося, рис, чорний кунжут</p>'),
(6,	'ru',	'Васаби ролл',	'<p>Состав: васаби, водоросли нори, животик лосося, рис, черный кунжут</p>',	'<p>Состав: васаби, водоросли нори, животик лосося, рис, черный кунжут</p>'),
(6,	'en',	'Wasabi roll',	'<p>Ingredients: wasabi, seaweed, salmon belly, rice, black sesame</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(7,	'ua',	'',	'<p>Склад: водорості норі, гриб шиітаке, ікра корюшки, крабова паличка, огірок, омлет, рис, гарбуз</p>',	'<p>Склад: водорості норі, гриб шиітаке, ікра корюшки, крабова паличка, огірок, омлет, рис, гарбуз</p>'),
(7,	'ru',	'Футомаки',	'<p>Состав: водоросли нори, гриб шиитаке, икра корюшки, крабовая палочка, огурец, омлет, рис, тыква</p>',	'<p>Состав: водоросли нори, гриб шиитаке, икра корюшки, крабовая палочка, огурец, омлет, рис, тыква</p>'),
(7,	'en',	'Futomaki',	'<p>Ingredients: seaweed, shiitake mushrooms, caviar smelt, crab stick, cucumber, eggs, rice, pumpkin</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(8,	'ua',	'Філадельфія з червоною ікрою',	'<p>Склад: авокадо, водорості норі, червона ікра, лосось, огірок, рис, сир Філадельфія</p>',	'<p>Склад: авокадо, водорості норі, червона ікра, лосось, огірок, рис, сир Філадельфія</p>'),
(8,	'ru',	'Филадельфия с красной икрой',	'<p>Состав: авокадо, водоросли нори, красная икра, лосось, огурец, рис, сыр Филадельфия</p>',	'<p>Состав: авокадо, водоросли нори, красная икра, лосось, огурец, рис, сыр Филадельфия</p>'),
(8,	'en',	'Philadelphia with red caviar',	'<p>Ingredients: avocado, seaweed, red caviar, salmon, cucumber, rice, cheese Philadelphia</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(9,	'ua',	'Ікра летючої риби',	'<p>Склад: водорості норі, ікра летючої риби, рис</p>',	'<p>Склад: водорості норі, ікра летючої риби, рис</p>'),
(9,	'ru',	'Икра летучей рыбы',	'<p>Состав: водоросли нори, икра летучей рыбы, рис</p>',	'<p>Состав: водоросли нори, икра летучей рыбы, рис</p>'),
(9,	'en',	'Flying fish roe',	'<p>Ingredients: seaweed, flying fish roe, rice</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(10,	'ua',	'Хіяші вакаме',	'<p>Склад: водорості норі, водорості сівід і ламінарії, насіння кунжуту</p>',	'<p>Склад: водорості норі, водорості сівід і ламінарії, насіння кунжуту</p>'),
(10,	'ru',	'Хияши вакаме',	'<p>Состав: водоросли нори, водоросли сивид и ламинарии, семена кунжута</p>',	'<p>Состав: водоросли нори, водоросли сивид и ламинарии, семена кунжута</p>'),
(10,	'en',	'Hiashi wakame',	'<p>Ingredients: seaweed, kelp and algae sivid, sesame seeds</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(11,	'ua',	'Лосось',	'<p>Склад: лосось, рис</p>',	'<p>Склад: лосось, рис</p>'),
(11,	'ru',	'Лосось',	'<p>Состав: лосось, рис</p>',	'<p>Состав: лосось, рис</p>'),
(11,	'en',	'Salmon',	'<p>Ingredients: salmon, rice</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(12,	'ua',	'Лосось копчений',	'<p>Склад: копчений лосось, огірок</p>',	'<p>Склад: копчений лосось, огірок</p>'),
(12,	'ru',	'Лосось копченый',	'<p>Состав: копченый лосось, огурец</p>',	'<p>Состав: копченый лосось, огурец</p>'),
(12,	'en',	'Smoked salmon',	'<p>Ingredients: smoked salmon, cucumber</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(13,	'ua',	'Oкунь червоний',	'<p>Склад: червоний окунь, огірок</p>',	'<p>Склад: червоний окунь, огірок</p>'),
(13,	'ru',	'Окунь красный',	'<p>Состав: красный окунь, огурец</p>',	'<p>Состав: красный окунь, огурец</p>'),
(13,	'en',	'Red grouper',	'<p>Ingredients: red snapper, cucumber</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(14,	'ua',	'Ікра червона',	'<p>Склад: червона ікра, огірок</p>',	'<p>Склад: червона ікра, огірок</p>'),
(14,	'ru',	'Икра красная',	'<p>Состав: красная икра, огурец</p>',	'<p>Состав: красная икра, огурец</p>'),
(14,	'en',	'Caviar',	'<p>Ingredients: red caviar, cucumber</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(15,	'ua',	'Салат з лососем',	'<p>Склад: болгарський перець, лист салату, лосось, огірок, пікантний соус, насіння кунжуту</p>',	'<p>Склад: болгарський перець, лист салату, лосось, огірок, пікантний соус, насіння кунжуту</p>'),
(15,	'ru',	'Салат с лососем',	'<p>Состав: болгарский перец, лист салата, лосось, огурец, пикантный соус, семена кунжута</p>',	'<p>Состав: болгарский перец, лист салата, лосось, огурец, пикантный соус, семена кунжута</p>'),
(15,	'en',	'Salad with salmon',	'<p>Ingredients: pepper, lettuce, salmon, cucumber, spicy sauce, sesame seeds</p>',	'<p>Ingredients: pepper, lettuce, salmon, cucumber, spicy sauce, sesame seeds</p>'),
(16,	'ua',	'Салат з креветкою',	'<p>Склад: болгарський перець, креветка, лист салату, огірок, пікантний соус, насіння кунжуту</p>',	'<p>Склад: болгарський перець, креветка, лист салату, огірок, пікантний соус, насіння кунжуту</p>'),
(16,	'ru',	'Салат с креветкой',	'<p>Состав: болгарский перец, креветка, лист салата, огурец, пикантный соус, семена кунжута</p>',	'<p>Состав: болгарский перец, креветка, лист салата, огурец, пикантный соус, семена кунжута</p>'),
(16,	'en',	'Salad with shrimp',	'<p>Ingredients: pepper, shrimp, lettuce, cucumber, spicy sauce, sesame seeds</p>',	'<p>Ingredients: pepper, shrimp, lettuce, cucumber, spicy sauce, sesame seeds</p>'),
(17,	'ua',	'Егоїст',	'',	''),
(17,	'ru',	'Эгоист',	'<p>Состав: полролла Авокадо (с угрем), полролла Филадельфия, полролла Филадельфия с копченым лососем, полролла Ханами</p>',	'<p>Состав: полролла Авокадо (с угрем), полролла Филадельфия, полролла Филадельфия с копченым лососем, полролла Ханами</p>'),
(17,	'en',	'Egoist',	'<p>Ingredients: Avocado polrolla (eel), polrolla Philadelphia, Philadelphia polrolla with smoked salmon, polrolla Hanami</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(18,	'ua',	'Вакаме',	'<p>Склад: водорості сівід, гриб шиітаке, соєвий соус, тофу, чорний кунжут</p>',	'<p>Склад: водорості сівід, гриб шиітаке, соєвий соус, тофу, чорний кунжут</p>'),
(18,	'ru',	'Вакаме',	'<p>Состав: водоросли сивид, гриб шиитаке, соевый соус, тофу, черный кунжут</p>',	'<p>Состав: водоросли сивид, гриб шиитаке, соевый соус, тофу, черный кунжут</p>'),
(18,	'en',	'Wakame',	'<p>Ingredients: sivid seaweed, shiitake mushrooms, soy sauce, tofu, black sesame seeds</p>',	'<p>Ingredients: sivid seaweed, shiitake mushrooms, soy sauce, tofu, black sesame seeds</p>'),
(19,	'en',	'Pizza',	'<p>Pizza with Mozzarella Cheese and Fresh Tomato and Pesto Sauce. Garnished with Dried Tomato, Green and Black Olives and Basil Leaves</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(20,	'en',	'Plate of Salad with fork and tomato',	'<p>Plate of Salad with fork and tomato isolated on white</p>',	''),
(21,	'en',	'Three sushi rolls',	'<p>Three sushi rolls on white</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(22,	'en',	'Chicken Soup (clipping path)',	'<p>Chicken soup isolated on a white background with clipping path.</p>',	''),
(23,	'en',	'Pasta Collection',	'<p>Fettucini prepared with fried cherry tomatoes, basil and mozarella</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(24,	'en',	'Ukrainian Pan Fried Perogies',	'<p>Ukrainian Pan Fried Perogies with Ukrainian Sausage and Beef</p>',	''),
(25,	'en',	'Pancakes',	'<p>Pancakes with syrup and butter</p>',	''),
(26,	'en',	'Ukrainian and russian national red soup-borsch',	'<p>Ukrainian and russian national red soup-borsch.</p>',	''),
(27,	'en',	'White Cake Slice Missing',	'<p>A high angle close up of a white cake with a white vanilla and creme cheese frosting with a large slice missing. Isolated on white.</p>',	''),
(28,	'en',	'Donuts',	'<p>Donuts isolated on a white background.</p>',	''),
(29,	'en',	'Cheesecake with cherry topping',	'<p>Cheesecake with cherries and cherry topping</p>',	''),
(30,	'en',	'Vareniks with cheese',	'<p>Vareniks with cheese.</p>',	''),
(31,	'en',	'Sandwich',	'<p>Wholegrain roll sandwich with ham, cheese and vegetables.</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(32,	'en',	'Pizza tomato mozzarella',	'<p>Italian pizza. Margherita, tomato and mozzarella on white.</p>',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque vitae pretium.</p>\r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum sed at enim urna.</p>\r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus at justo sollicitudin.</p>\r\n<p>Mi nulla ut adipiscing.</p>'),
(33,	'en',	'Fruit salad',	'<p>Fruit salad in the bowl.</p>',	'');

CREATE TABLE `modx_a_recall` (
  `recall_id` int(11) NOT NULL AUTO_INCREMENT,
  `recall_pub_date` datetime NOT NULL,
  `recall_name` varchar(128) NOT NULL,
  `recall_email` varchar(128) NOT NULL,
  `recall_text` text NOT NULL,
  `recall_product` int(11) NOT NULL,
  `recall_moderated` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0n1y',
  PRIMARY KEY (`recall_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `modx_a_redirect` (
  `redirect_id` int(11) NOT NULL AUTO_INCREMENT,
  `redirect_code` int(11) NOT NULL DEFAULT '301',
  `redirect_source` varchar(1024) NOT NULL,
  `redirect_target` varchar(1024) NOT NULL,
  PRIMARY KEY (`redirect_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_redirect` (`redirect_id`, `redirect_code`, `redirect_source`, `redirect_target`) VALUES
(2,	301,	'/ru/blablabla/',	'/ru/novosti/');

CREATE TABLE `modx_a_values` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT,
  `val` varchar(128) NOT NULL,
  `num` int(11) NOT NULL,
  PRIMARY KEY (`value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `modx_a_values` (`value_id`, `val`, `num`) VALUES
(214,	'',	12),
(215,	'',	1),
(216,	'',	12),
(217,	'',	1),
(218,	'',	12),
(219,	'',	1),
(220,	'',	999),
(234,	'',	999),
(222,	'',	234),
(233,	'',	0),
(224,	'',	345),
(232,	'',	34),
(226,	'',	456),
(231,	'',	0),
(113,	'Просто мешает',	0),
(112,	'мешает всё',	0),
(109,	'Универсальный',	0),
(107,	'С золотыми кнопками',	0),
(230,	'',	1111),
(228,	'',	1231),
(237,	'',	0),
(238,	'',	1111),
(239,	'',	0),
(235,	'',	0),
(240,	'',	345),
(243,	'',	0),
(242,	'',	999),
(236,	'',	34),
(241,	'',	0),
(244,	'',	1111),
(245,	'',	0),
(246,	'',	1231),
(247,	'',	0),
(248,	'',	345),
(249,	'',	0),
(250,	'',	345),
(251,	'',	0),
(252,	'',	345),
(253,	'',	0),
(254,	'',	1231),
(255,	'',	0),
(256,	'',	1231),
(257,	'',	0),
(258,	'',	1231),
(259,	'',	0),
(260,	'',	34),
(261,	'',	0),
(262,	'',	1111),
(263,	'',	0),
(264,	'',	1111),
(265,	'',	0),
(266,	'',	0),
(267,	'',	0),
(268,	'',	0),
(269,	'',	0),
(270,	'',	0),
(271,	'',	0),
(272,	'',	250),
(273,	'',	1),
(274,	'',	400),
(275,	'6',	0),
(276,	'',	1),
(277,	'',	100),
(278,	'1',	0),
(279,	'',	0),
(280,	'',	500),
(281,	'8',	0),
(282,	'',	0),
(283,	'',	150),
(284,	'',	0),
(285,	'',	200),
(286,	'10',	0),
(287,	'',	0),
(288,	'',	100),
(289,	'2',	0),
(290,	'',	0),
(291,	'',	250),
(292,	'',	0),
(293,	'',	400),
(294,	'',	1),
(295,	'',	550),
(296,	'',	0),
(297,	'',	300),
(298,	'',	1),
(299,	'',	200),
(300,	'3',	0),
(301,	'',	0),
(302,	'',	200),
(303,	'',	0),
(304,	'',	300),
(305,	'',	1),
(306,	'',	450),
(307,	'',	0),
(308,	'',	300),
(309,	'',	0),
(310,	'',	400),
(311,	'12',	0),
(312,	'',	0),
(313,	'',	250),
(314,	'',	0),
(315,	'',	250),
(316,	'',	0),
(317,	'',	100),
(318,	'',	0),
(319,	'',	150),
(320,	'',	0),
(321,	'',	400),
(322,	'',	0),
(323,	'',	250),
(324,	'',	0),
(325,	'',	200),
(326,	'4',	0),
(327,	'',	1),
(328,	'',	350),
(329,	'',	0),
(330,	'',	420),
(331,	'',	0),
(332,	'',	550),
(333,	'',	0),
(334,	'',	100),
(335,	'',	0),
(336,	'',	200),
(337,	'',	0),
(338,	'',	450),
(339,	'',	0),
(340,	'',	440),
(341,	'',	0),
(342,	'',	220),
(343,	'',	0),
(344,	'',	440),
(345,	'',	1),
(346,	'',	250),
(347,	'',	1),
(348,	'',	400),
(349,	'',	1),
(350,	'',	100),
(351,	'',	0),
(352,	'',	500),
(353,	'',	0),
(354,	'',	220),
(355,	'',	0),
(356,	'',	200),
(357,	'',	0),
(358,	'',	100),
(359,	'',	0),
(360,	'',	0),
(361,	'',	550),
(362,	'',	0),
(363,	'',	550),
(364,	'',	0),
(365,	'',	420),
(366,	'',	0),
(367,	'',	350),
(368,	'',	0),
(369,	'',	200),
(370,	'',	1),
(371,	'',	250),
(372,	'',	0),
(373,	'',	400),
(374,	'',	0),
(375,	'',	150),
(376,	'',	0),
(377,	'',	100),
(378,	'',	0),
(379,	'',	400),
(380,	'',	0),
(381,	'',	450),
(382,	'',	0),
(383,	'',	200),
(384,	'',	0),
(385,	'',	300),
(386,	'',	1),
(387,	'',	150),
(388,	'',	0),
(389,	'',	400),
(390,	'',	1),
(391,	'',	350),
(392,	'',	0);

CREATE TABLE `modx_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(45) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Categories to be used snippets,tv,chunks, etc';

INSERT INTO `modx_categories` (`id`, `category`) VALUES
(1,	'Js'),
(2,	'Manager and Admin'),
(3,	'Navigation'),
(4,	'Content'),
(5,	'SEO'),
(6,	'_Structure'),
(7,	'Shop'),
(8,	'Shop - Товар'),
(9,	'popup'),
(10,	'Shop - Корзина'),
(11,	'_Mail'),
(12,	'Profile'),
(13,	'Shop - Фильтры'),
(14,	'Shop - Поиск');

CREATE TABLE `modx_documentgroup_names` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `private_memgroup` tinyint(4) DEFAULT '0' COMMENT 'determine whether the document group is private to manager users',
  `private_webgroup` tinyint(4) DEFAULT '0' COMMENT 'determines whether the document is private to web users',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for access permissions.';


CREATE TABLE `modx_document_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `document_group` int(10) NOT NULL DEFAULT '0',
  `document` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `document` (`document`),
  KEY `document_group` (`document_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for access permissions.';


CREATE TABLE `modx_event_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventid` int(11) DEFAULT '0',
  `createdon` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1- information, 2 - warning, 3- error',
  `user` int(11) NOT NULL DEFAULT '0' COMMENT 'link to user table',
  `usertype` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - manager, 1 - web',
  `source` varchar(50) NOT NULL DEFAULT '',
  `description` text,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores event and error logs';


CREATE TABLE `modx_keyword_xref` (
  `content_id` int(11) NOT NULL DEFAULT '0',
  `keyword_id` int(11) NOT NULL DEFAULT '0',
  KEY `content_id` (`content_id`),
  KEY `keyword_id` (`keyword_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Cross reference bewteen keywords and content';


CREATE TABLE `modx_manager_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `timestamp` int(20) NOT NULL DEFAULT '0',
  `internalKey` int(10) NOT NULL DEFAULT '0',
  `username` varchar(255) DEFAULT NULL,
  `action` int(10) NOT NULL DEFAULT '0',
  `itemid` varchar(10) DEFAULT '0',
  `itemname` varchar(255) DEFAULT NULL,
  `message` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains a record of user interaction.';


CREATE TABLE `modx_manager_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains login information for backend users.';

INSERT INTO `modx_manager_users` (`id`, `username`, `password`) VALUES
(1,	'admin',	'uncrypt>b3b8bc7bf0d35b71189a33e62c52256e5b402a8a'),
(2,	'demo',	'uncrypt>5aa3a111067225d9d87cabe794ba8844083d888a');

CREATE TABLE `modx_membergroup_access` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `membergroup` int(10) NOT NULL DEFAULT '0',
  `documentgroup` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for access permissions.';


CREATE TABLE `modx_membergroup_names` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for access permissions.';


CREATE TABLE `modx_member_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_group` int(10) NOT NULL DEFAULT '0',
  `member` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_group_member` (`user_group`,`member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for access permissions.';


CREATE TABLE `modx_site_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL DEFAULT 'document',
  `contentType` varchar(50) NOT NULL DEFAULT 'text/html',
  `pagetitle` varchar(255) NOT NULL DEFAULT '',
  `longtitle` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) DEFAULT '',
  `link_attributes` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link attriubtes',
  `published` int(1) NOT NULL DEFAULT '0',
  `pub_date` int(20) NOT NULL DEFAULT '0',
  `unpub_date` int(20) NOT NULL DEFAULT '0',
  `parent` int(10) NOT NULL DEFAULT '0',
  `isfolder` int(1) NOT NULL DEFAULT '0',
  `introtext` text COMMENT 'Used to provide quick summary of the document',
  `content` mediumtext,
  `richtext` tinyint(1) NOT NULL DEFAULT '1',
  `template` int(10) NOT NULL DEFAULT '0',
  `menuindex` int(10) NOT NULL DEFAULT '0',
  `searchable` int(1) NOT NULL DEFAULT '1',
  `cacheable` int(1) NOT NULL DEFAULT '1',
  `createdby` int(10) NOT NULL DEFAULT '0',
  `createdon` int(20) NOT NULL DEFAULT '0',
  `editedby` int(10) NOT NULL DEFAULT '0',
  `editedon` int(20) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `deletedon` int(20) NOT NULL DEFAULT '0',
  `deletedby` int(10) NOT NULL DEFAULT '0',
  `publishedon` int(20) NOT NULL DEFAULT '0' COMMENT 'Date the document was published',
  `publishedby` int(10) NOT NULL DEFAULT '0' COMMENT 'ID of user who published the document',
  `menutitle` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu title',
  `donthit` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Disable page hit count',
  `haskeywords` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'has links to keywords',
  `hasmetatags` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'has links to meta tags',
  `privateweb` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Private web document',
  `privatemgr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Private manager document',
  `content_dispo` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-inline, 1-attachment',
  `hidemenu` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide document from menu',
  `alias_visible` int(2) NOT NULL DEFAULT '1',
  `pagetitle_ua` varchar(255) NOT NULL COMMENT 'pagetitle ua version',
  `longtitle_ua` varchar(255) NOT NULL COMMENT 'longtitle ua version',
  `description_ua` varchar(255) NOT NULL COMMENT 'description ua version',
  `link_attributes_ua` varchar(255) NOT NULL COMMENT 'link_attributes ua version',
  `introtext_ua` text NOT NULL COMMENT 'introtext ua version',
  `menutitle_ua` varchar(255) NOT NULL COMMENT 'menutitle ua version',
  `content_ua` mediumtext NOT NULL COMMENT 'content ua version',
  `pagetitle_en` varchar(255) NOT NULL COMMENT 'pagetitle en version',
  `longtitle_en` varchar(255) NOT NULL COMMENT 'longtitle en version',
  `description_en` varchar(255) NOT NULL COMMENT 'description en version',
  `link_attributes_en` varchar(255) NOT NULL COMMENT 'link_attributes en version',
  `introtext_en` text NOT NULL COMMENT 'introtext en version',
  `menutitle_en` varchar(255) NOT NULL COMMENT 'menutitle en version',
  `content_en` mediumtext NOT NULL COMMENT 'content en version',
  `pagetitle_ru` varchar(255) NOT NULL COMMENT 'pagetitle ru version',
  `longtitle_ru` varchar(255) NOT NULL COMMENT 'longtitle ru version',
  `description_ru` varchar(255) NOT NULL COMMENT 'description ru version',
  `link_attributes_ru` varchar(255) NOT NULL COMMENT 'link_attributes ru version',
  `introtext_ru` text NOT NULL COMMENT 'introtext ru version',
  `menutitle_ru` varchar(255) NOT NULL COMMENT 'menutitle ru version',
  `content_ru` mediumtext NOT NULL COMMENT 'content ru version',
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `parent` (`parent`),
  KEY `aliasidx` (`alias`),
  KEY `typeidx` (`type`),
  FULLTEXT KEY `content_ft_idx` (`pagetitle`,`description`,`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains the site document tree.';

INSERT INTO `modx_site_content` (`id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `haskeywords`, `hasmetatags`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `alias_visible`, `pagetitle_ua`, `longtitle_ua`, `description_ua`, `link_attributes_ua`, `introtext_ua`, `menutitle_ua`, `content_ua`, `pagetitle_en`, `longtitle_en`, `description_en`, `link_attributes_en`, `introtext_en`, `menutitle_en`, `content_en`, `pagetitle_ru`, `longtitle_ru`, `description_ru`, `link_attributes_ru`, `introtext_ru`, `menutitle_ru`, `content_ru`) VALUES
(1,	'document',	'text/html',	'Главная',	'',	'',	'glavnaya',	'',	1,	1406649660,	1406822460,	0,	0,	'',	'',	1,	3,	0,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Головна',	'',	'',	'',	'',	'',	'',	'Index',	'',	'',	'',	'',	'',	'',	'Главная',	'',	'',	'',	'',	'',	''),
(2,	'document',	'text/html',	'Страница не найдена',	'',	'',	'not-found',	'',	1,	1406649660,	1406822460,	0,	0,	'',	'',	1,	7,	1,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Сторiнку не знайдено',	'',	'',	'',	'',	'',	'404',	'Page not found',	'',	'',	'',	'',	'',	'404',	'Страница не найдена',	'',	'',	'',	'',	'',	'404'),
(3,	'document',	'text/html',	'Авторизация',	'',	'',	'signup',	'',	1,	1406649660,	1406822460,	0,	0,	'',	'[!if?&is=`[*error*]:!=:` &then=`\r\n<div class=\"alert alert-danger alert-dismissable col-md-12\">\r\n	<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>\r\n	<strong>[*error*]</strong>\r\n</div>\r\n`!]\r\n<div class=\"small-forms\">\r\n	<form class=\"form-signin\" role=\"form\" id=\"auth\" method=\"post\">\r\n		<h3 class=\"form-signin-heading\">Авторизация</h3>\r\n		<input type=\"email\" name=\"auth[email]\" class=\"form-control\" placeholder=\"Email\" data-remember=\"\" required=\"\" autofocus=\"\">\r\n		<input type=\"password\" name=\"auth[pass]\" class=\"form-control\" placeholder=\"Пароль\" required=\"\">\r\n		<label class=\"checkbox\">\r\n			<input type=\"checkbox\" value=\"remember-me\"> Запомнить меня\r\n		</label>\r\n		<button class=\"btn btn-lg btn-success btn-block\" type=\"submit\">Войти</button>\r\n		<a href=\"#recovery\" class=\"btn btn-lg btn-warning btn-block js_form\" type=\"submit\">Забыл пароль</a>\r\n		<a href=\"#register\" class=\"btn btn-lg btn-info btn-block js_form\" type=\"submit\">Я тут впервые</a>\r\n	</form>\r\n	<form class=\"form-signin hide\" role=\"form\" id=\"register\" method=\"post\">\r\n		<h3 class=\"form-signin-heading\">Регистрация</h3>\r\n		<input type=\"text\" name=\"reg[name]\" class=\"form-control\" placeholder=\"Как Вас зовут?\" required=\"\" data-remember=\"\" autofocus=\"\" />\r\n		<input type=\"email\" name=\"reg[email]\" class=\"form-control\" placeholder=\"Email\" data-remember=\"\" required=\"\" />\r\n		<input type=\"text\" name=\"reg[phone]\" class=\"form-control\" placeholder=\"Телефон\" data-remember=\"\" required=\"\" />\r\n		<input type=\"password\" name=\"reg[pass]\" class=\"form-control\" placeholder=\"Пароль\" required=\"\" />\r\n		<input type=\"password\" name=\"reg[cfm]\" class=\"form-control\" placeholder=\"Пароль еще раз\" required=\"\" />\r\n		<br>\r\n		<button class=\"btn btn-lg btn-success btn-block\" type=\"submit\">Зарегистрироваться</button>\r\n	</form>\r\n	<form class=\"hide\" role=\"form\" id=\"recovery\" method=\"post\">\r\n		<h3 class=\"form-signin-heading\">Восстановление пароля</h3>\r\n		<input type=\"email\" name=\"recover[email]\" class=\"form-control\" placeholder=\"Email\" required=\"\" autofocus=\"\">\r\n		<br>\r\n		<button class=\"btn btn-lg btn-success btn-block\" type=\"submit\">Восстановить пароль</button>\r\n	</form>\r\n</div>\r\n<script>\r\n	$(document).ready(function(){\r\n		$(\".js_form\").on(\"click\", function(){\r\n			$(this).parents(\"form\").addClass(\"hide\");\r\n			$($(this).attr(\"href\")).removeClass(\"hide\").slideDown();\r\n		})\r\n		if (window.location.hash != \"\")\r\n			$(\".js_form[href=\'\"+window.location.hash+\"\']\").trigger(\"click\");\r\n	});\r\n</script>',	1,	10,	2,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Авторизація',	'',	'',	'',	'',	'',	'',	'Authorization',	'',	'',	'',	'',	'',	'',	'Авторизация',	'',	'',	'',	'',	'',	''),
(4,	'document',	'text/html',	'Страница товара',	'',	'',	'item',	'',	1,	1406649660,	1406822460,	0,	0,	'',	'',	1,	5,	3,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Сторінка товару',	'',	'',	'',	'',	'',	'',	'Product page',	'',	'',	'',	'',	'',	'',	'Страница товара',	'',	'',	'',	'',	'',	''),
(5,	'document',	'text/html',	'Каталог',	'',	'',	'catalog',	'',	1,	1406649660,	1406822460,	0,	1,	'',	'',	1,	4,	4,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Каталог',	'',	'',	'',	'',	'',	'',	'Catalogue',	'',	'',	'',	'',	'',	'',	'Каталог',	'',	'',	'',	'',	'',	''),
(6,	'document',	'text/html',	'Новый ресурс',	'',	'',	'10',	'',	1,	1406649660,	1406822460,	5,	0,	'',	'',	1,	4,	0,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Суп',	'',	'',	'',	'',	'',	'',	'Soup',	'',	'',	'',	'',	'',	'',	'Суп',	'',	'',	'',	'',	'',	''),
(7,	'document',	'text/html',	'Смартфоны',	'',	'',	'11',	'',	1,	1406649660,	1406822460,	5,	0,	'',	'',	1,	4,	1,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Суши',	'',	'',	'',	'',	'',	'',	'Sushi',	'',	'',	'',	'',	'',	'',	'Суши',	'',	'',	'',	'',	'',	''),
(8,	'document',	'text/html',	'Ноутбуки',	'',	'',	'12',	'',	1,	1406649660,	1406822460,	5,	0,	'',	'',	1,	4,	2,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Сашимі',	'',	'',	'',	'',	'',	'',	'Sashimi',	'',	'',	'',	'',	'',	'',	'Сашими',	'',	'',	'',	'',	'',	''),
(9,	'document',	'text/html',	'Профиль',	'',	'',	'profile',	'',	1,	1406649660,	1406822460,	0,	0,	'',	'',	1,	8,	5,	0,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Профiль',	'',	'',	'',	'',	'',	'',	'Profile',	'',	'',	'',	'',	'',	'',	'Профиль',	'',	'',	'',	'',	'',	''),
(10,	'document',	'text/html',	'Оформить заказ',	'',	'',	'oformit-zakaz',	'',	1,	1406649660,	1406822460,	0,	0,	'',	'',	1,	6,	6,	1,	0,	2,	1406649660,	2,	1406649660,	0,	0,	0,	1406649422,	2,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Оформити замовлення',	'',	'',	'',	'',	'',	'',	'Order',	'',	'',	'',	'',	'',	'',	'Оформить заказ',	'',	'',	'',	'',	'',	''),
(11,	'document',	'text/html',	'Заказ оформлен!',	'',	'',	'zakaz-oformlen',	'',	1,	1396715504,	0,	0,	0,	'',	'',	1,	7,	7,	1,	0,	1,	1396715895,	1,	1400427329,	0,	0,	0,	1396715895,	1,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Замовлення оформлено',	'',	'',	'',	'',	'',	'<div class=\"jumbotron\">\r\n	<h1>Спасибо за заказ!</h1>\r\n	<p>Ваш заказ был успешно оформлен.</p>\r\n	<a class=\"btn btn-lg btn-success\" href=\"[~~9~~]\" role=\"button\"><span class=\"glyphicon glyphicon-user\"></span> Перейти в личный кабинет</a> \r\n	<a class=\"btn btn-lg btn-primary\" href=\"/[(lang)]/\" role=\"button\"><span class=\"glyphicon glyphicon-home\"></span> Вернуться на главную страницу</a> \r\n	[*pay_form*]\r\n	\r\n</div>',	'Order confirm',	'',	'',	'',	'',	'',	'<div class=\"jumbotron\">\r\n	<h1>Спасибо за заказ!</h1>\r\n	<p>Ваш заказ был успешно оформлен.</p>\r\n	<a class=\"btn btn-lg btn-success\" href=\"[~~9~~]\" role=\"button\"><span class=\"glyphicon glyphicon-user\"></span> Перейти в личный кабинет</a> \r\n	<a class=\"btn btn-lg btn-primary\" href=\"/[(lang)]/\" role=\"button\"><span class=\"glyphicon glyphicon-home\"></span> Вернуться на главную страницу</a> \r\n	[*pay_form*]\r\n	\r\n</div>',	'Заказ оформлен!',	'',	'',	'',	'',	'',	'<div class=\"jumbotron\">\r\n	<h1>Спасибо за заказ!</h1>\r\n	<p>Ваш заказ был успешно оформлен.</p>\r\n	<a class=\"btn btn-lg btn-success\" href=\"[~~9~~]\" role=\"button\"><span class=\"glyphicon glyphicon-user\"></span> Перейти в личный кабинет</a> \r\n	<a class=\"btn btn-lg btn-primary\" href=\"/[(lang)]/\" role=\"button\"><span class=\"glyphicon glyphicon-home\"></span> Вернуться на главную страницу</a> \r\n	[*pay_form*]\r\n	\r\n</div>'),
(12,	'document',	'text/html',	'Результат поиска',	'',	'',	'rezultat-poiska',	'',	1,	1398858642,	0,	0,	0,	'',	'',	1,	9,	8,	1,	0,	1,	1398858646,	1,	1399191221,	0,	0,	0,	1398858646,	1,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'Результати пошуку',	'',	'',	'',	'',	'',	'',	'Search results',	'',	'',	'',	'',	'',	'',	'Результат поиска',	'',	'',	'',	'',	'',	''),
(13,	'document',	'text/html',	'',	'',	'',	'rolls',	'',	1,	1403857278,	0,	5,	0,	NULL,	NULL,	1,	4,	3,	1,	0,	1,	1403857346,	1,	1404199657,	0,	0,	0,	1403857346,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Роли',	'',	'',	'',	'',	'',	'',	'Rolls',	'',	'',	'',	'',	'',	'',	'Роллы',	'',	'',	'',	'',	'',	''),
(14,	'document',	'text/html',	'',	'',	'',	'hendrolly',	'',	0,	0,	0,	5,	0,	NULL,	NULL,	1,	4,	4,	1,	0,	1,	1403866791,	1,	1404299783,	0,	0,	0,	0,	0,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Hendrolly',	'',	'',	'',	'',	'',	'',	'Hendrolly',	'',	'',	'',	'',	'',	'',	'Хендроллы',	'',	'',	'',	'',	'',	''),
(15,	'document',	'text/html',	'',	'',	'',	'salads',	'',	0,	0,	0,	5,	0,	NULL,	NULL,	1,	4,	5,	1,	0,	1,	1403872277,	1,	1404299792,	0,	0,	0,	0,	0,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Салати',	'',	'',	'',	'',	'',	'',	'Salads',	'',	'',	'',	'',	'',	'',	'Салаты',	'',	'',	'',	'',	'',	''),
(16,	'document',	'text/html',	'',	'',	'',	'delivery',	'',	1,	0,	0,	0,	0,	NULL,	NULL,	1,	7,	9,	1,	0,	1,	1403877451,	1,	1404300802,	0,	0,	0,	1404198711,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Доставка',	'',	'',	'',	'',	'',	'',	'Delivery',	'',	'',	'',	'',	'',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque \r\n      vitae pretium.</p> \r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut \r\n      eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum \r\n      sed at enim urna.</p> \r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus \r\n      elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus \r\n      at justo sollicitudin.</p> \r\n<p>Mi nulla ut adipiscing.</p>',	'Доставка',	'',	'',	'',	'',	'',	''),
(17,	'document',	'text/html',	'Duplicate of ',	'',	'',	'pizza',	'',	1,	0,	0,	5,	0,	'',	'',	1,	4,	6,	1,	0,	1,	1404194359,	1,	1404200140,	0,	0,	0,	1404194406,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Салати',	'',	'',	'',	'',	'',	'',	'Pizza',	'',	'',	'',	'',	'',	'',	'Салаты',	'',	'',	'',	'',	'',	''),
(18,	'document',	'text/html',	'Duplicate of Duplicate of ',	'',	'',	'pasta',	'',	1,	0,	0,	5,	0,	'',	'',	1,	4,	7,	1,	0,	1,	1404196376,	1,	1404200145,	0,	0,	0,	1404196392,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Салати',	'',	'',	'',	'',	'',	'',	'Pasta',	'',	'',	'',	'',	'',	'',	'Салаты',	'',	'',	'',	'',	'',	''),
(19,	'document',	'text/html',	'Duplicate of Duplicate of Duplicate of ',	'',	'',	'cabbage-rolls',	'',	0,	0,	0,	5,	0,	'',	'',	1,	4,	8,	1,	0,	1,	1404196772,	1,	1404299800,	0,	0,	0,	0,	0,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'Салати',	'',	'',	'',	'',	'',	'',	'Pelmeni',	'',	'',	'',	'',	'',	'',	'Салаты',	'',	'',	'',	'',	'',	''),
(20,	'document',	'text/html',	'',	'',	'',	'dessert',	'',	0,	0,	0,	5,	0,	NULL,	NULL,	1,	4,	9,	1,	0,	1,	1404197078,	1,	1404299809,	0,	0,	0,	0,	0,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'Dessert',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	''),
(21,	'document',	'text/html',	'',	'',	'',	'contacts',	'',	1,	1404198834,	0,	0,	1,	NULL,	NULL,	1,	7,	10,	1,	0,	1,	1404198931,	1,	1404201064,	0,	0,	0,	1404198931,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'Contacts',	'',	'',	'',	'',	'',	'we are at the address</br> c. Food, st. Big Appetite, 7</br> email us</br> good@food.com</br> or call us </br> 777-333-1</br>',	'',	'',	'',	'',	'',	'',	''),
(22,	'document',	'text/html',	'',	'',	'',	'about-us',	'',	1,	1404198934,	0,	0,	0,	NULL,	NULL,	1,	7,	11,	1,	0,	1,	1404198943,	1,	1404374206,	0,	0,	0,	1404198943,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'About Us',	'',	'',	'',	'',	'',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque \r\n      vitae pretium.</p> \r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut \r\n      eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum \r\n      sed at enim urna.</p> \r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus \r\n      elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus \r\n      at justo sollicitudin.</p> \r\n<p>Mi nulla ut adipiscing.</p>',	'',	'',	'',	'',	'',	'',	''),
(23,	'document',	'text/html',	'',	'',	'',	'sandwich',	'',	1,	1404200328,	0,	5,	0,	NULL,	NULL,	1,	4,	10,	1,	0,	1,	1404200332,	1,	1404200332,	0,	0,	0,	1404200332,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'Sandwich',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	''),
(24,	'document',	'text/html',	'',	'',	'',	'store-apple',	'',	1,	1404288398,	0,	21,	0,	NULL,	NULL,	1,	7,	0,	1,	0,	1,	1404288588,	1,	1404368150,	0,	0,	0,	1404288588,	1,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'',	'',	'',	'',	'',	'',	'',	'Store Apple',	'111-222-3',	'',	'',	'',	'',	'c. Yablokovo, st. Yummy, 13',	'',	'',	'',	'',	'',	'',	''),
(25,	'document',	'text/html',	'',	'',	'',	'store-meat',	'',	1,	1404288597,	0,	21,	0,	NULL,	NULL,	1,	7,	1,	1,	0,	1,	1404288734,	1,	1404368155,	0,	0,	0,	1404288734,	1,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'',	'',	'',	'',	'',	'',	'',	'Store Meat',	'333-444-5',	'',	'',	'',	'',	'c. Beef, st. Big Cow, 33',	'',	'',	'',	'',	'',	'',	''),
(26,	'document',	'text/html',	'',	'',	'',	'store-strawberries',	'',	1,	1404288738,	0,	21,	0,	NULL,	NULL,	1,	7,	2,	1,	0,	1,	1404288870,	1,	1404368161,	0,	0,	0,	1404288870,	1,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'',	'',	'',	'',	'',	'',	'',	'Store Strawberries',	' 555-666-7',	'',	'',	'',	'',	'c. Berry, st. Red, 77',	'',	'',	'',	'',	'',	'',	''),
(27,	'document',	'text/html',	'',	'',	'',	'store-nut',	'',	1,	1404288873,	0,	21,	0,	NULL,	NULL,	1,	7,	3,	1,	0,	1,	1404289020,	1,	1404368169,	0,	0,	0,	1404289020,	1,	'',	0,	0,	0,	0,	0,	0,	1,	1,	'',	'',	'',	'',	'',	'',	'',	'Store Nut',	'777-888-9',	'',	'',	'',	'',	'c. Almonds, st. Walnut, 37',	'',	'',	'',	'',	'',	'',	''),
(28,	'document',	'text/html',	'',	'',	'',	'payment',	'',	1,	1404300932,	0,	0,	0,	NULL,	NULL,	1,	7,	12,	1,	0,	1,	1404300994,	1,	1404300994,	0,	0,	0,	1404300994,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'Payment',	'',	'',	'',	'',	'',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque \r\n      vitae pretium.</p> \r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut \r\n      eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum \r\n      sed at enim urna.</p> \r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus \r\n      elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus \r\n      at justo sollicitudin.</p> \r\n<p>Mi nulla ut adipiscing.</p>',	'',	'',	'',	'',	'',	'',	''),
(29,	'document',	'text/html',	'',	'',	'',	'warranty',	'',	1,	1404301001,	0,	0,	0,	NULL,	NULL,	1,	7,	13,	1,	0,	1,	1404301042,	1,	1404301042,	0,	0,	0,	1404301042,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'Warranty',	'',	'',	'',	'',	'',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque \r\n      vitae pretium.</p> \r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut \r\n      eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum \r\n      sed at enim urna.</p> \r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus \r\n      elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus \r\n      at justo sollicitudin.</p> \r\n<p>Mi nulla ut adipiscing.</p>',	'',	'',	'',	'',	'',	'',	''),
(30,	'document',	'text/html',	'',	'',	'',	'faq',	'',	1,	1404301046,	0,	0,	0,	NULL,	NULL,	1,	7,	14,	1,	0,	1,	1404301057,	1,	1404301057,	0,	0,	0,	1404301057,	1,	'',	0,	0,	0,	0,	0,	0,	0,	1,	'',	'',	'',	'',	'',	'',	'',	'FAQ',	'',	'',	'',	'',	'',	'<p>Lorem ipsum dolor sit amet consectetuer cursus pede pellentesque \r\n      vitae pretium.</p> \r\n<p>Tristique mus at elit lobortis libero Sed vestibulum ut \r\n      eleifend habitasse. Quis Nam Mauris adipiscing Integer ligula dictum \r\n      sed at enim urna.</p> \r\n<p>Et scelerisque id et nibh dui tincidunt Curabitur faucibus \r\n      elit massa. Tincidunt et gravida Phasellus eget parturient faucibus tellus \r\n      at justo sollicitudin.</p> \r\n<p>Mi nulla ut adipiscing.</p>',	'',	'',	'',	'',	'',	'',	'');

CREATE TABLE `modx_site_content_metatags` (
  `content_id` int(11) NOT NULL DEFAULT '0',
  `metatag_id` int(11) NOT NULL DEFAULT '0',
  KEY `content_id` (`content_id`),
  KEY `metatag_id` (`metatag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Reference table between meta tags and content';


CREATE TABLE `modx_site_htmlsnippets` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT 'Chunk',
  `editor_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT 'category id',
  `cache_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Cache option',
  `snippet` mediumtext,
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains the site chunks.';

INSERT INTO `modx_site_htmlsnippets` (`id`, `name`, `description`, `editor_type`, `category`, `cache_type`, `snippet`, `locked`) VALUES
(1,	'mm_rules',	'Default ManagerManager rules.',	0,	1,	0,	'mm_default(\"pub_date\");\r\n\r\nmm_createTab(\"SEO\", \"seo\");\r\nmm_moveFieldsToTab(\"tv_seo_title,tv_seo_keywords,tv_seo_description,tv_seo_robots,tv_seo_canonical\", \"seo\");\r\n\r\nmm_widget_showimagetvs(); // Always give a preview of Image TVs\r\n',	0),
(2,	'HEAD',	'',	0,	6,	0,	'<!DOCTYPE html>\r\n<html lang=\"en\">\r\n	<head>\r\n		<meta charset=\"utf-8\">\r\n		<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n		<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n		<meta name=\"description\" content=\"[*tv_seo_description*]\">\r\n		<meta name=\"robots\" content=\"[*tv_seo_robots*]\">\r\n		<meta name=\"keywords\" content=\"[*tv_seo_keywords*]\">\r\n		<title>[*tv_seo_title*]</title>\r\n		<link href=\"/assets/site/bootstrap/css/bootstrap.min.css\" rel=\"stylesheet\">\r\n		<link href=\"/assets/site/bootstrap/css/bootstrap-theme.min.css\" rel=\"stylesheet\">\r\n		<link href=\"/assets/site/slider/css/slider.css\" rel=\"stylesheet\">\r\n		<link href=\"/assets/site/styles.css\" rel=\"stylesheet\">\r\n		<script src=\"/assets/site/jquery.min.js\"></script>\r\n		<script src=\"/assets/site/bootstrap/js/bootstrap.min.js\"></script>\r\n		<script src=\"/assets/site/slider/js/bootstrap-slider.js\"></script>\r\n		<script src=\"/assets/site/shop.js\"></script>\r\n		<!--[if lt IE 9]>\r\n<script src=\"https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js\"></script>\r\n<script src=\"https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js\"></script>\r\n<![endif]-->\r\n	</head>\r\n	<body>\r\n		<div class=\"container\">\r\n			<br>\r\n			<div class=\"text-right\">\r\n				<select data-active=\"[(lang)]\" id=\"js_switch_lang\">\r\n					[[Shop?&get=`langs`&tpl=`tpl_option`]]\r\n				</select>\r\n				<select data-active=\"[*ses_currency*]\" id=\"js_switch_curr\">\r\n					[[Shop?&get=`currency`&tpl=`tpl_option`]]\r\n				</select>\r\n			</div>\r\n			<br>\r\n		</div>',	0),
(3,	'HEADER',	'',	0,	6,	0,	'<div class=\"navbar navbar-default\" role=\"navigation\">\r\n	<div class=\"navbar-header\">\r\n		<a class=\"navbar-brand\" href=\"/\">[(site_name)]</a>\r\n	</div>\r\n	<div class=\"navbar-collapse collapse\">\r\n		[[Wayfinder?&startId=`0`&outerClass=`nav navbar-nav`&parentRowTpl=`wf_menu_parent`&innerTpl=`wf_menu_inner`]]\r\n		<ul class=\"nav navbar-nav navbar-right\">\r\n			[!if?&is=`[*u_email*]:!=:`&then=`\r\n			<li><a href=\"[~~9~~]\"><span class=\"glyphicon glyphicon-user\"></span> Профиль</a></li>\r\n			<li><a href=\"/[(lang)]/?logout\"><span class=\"glyphicon glyphicon-off\"></span> [#4#]</a></li>\r\n			`&else=`\r\n			<li><a href=\"[~~3~~]\"><span class=\"glyphicon glyphicon-user\"></span> [#3#]</a></li>\r\n			`!]\r\n			<li>\r\n				<a href=\"#Cart\" data-toggle=\"modal\" data-ajax=\"cart\" data-target=\"#Cart\">\r\n					<span class=\"glyphicon glyphicon-shopping-cart\"></span> \r\n					<span class=\"cart_title\">[#1#] <span class=\"cart_title\">[!if?&is=`[!Shop?&get=`cart_count`!]:is:0`&then=`[#2#]`&else=`([!Shop?&get=`cart_count`!])`!]</span></span>\r\n				</a>\r\n			</li>\r\n		</ul>\r\n	</div><!--/.nav-collapse -->\r\n</div>\r\n<form action=\"[~~12~~]\" method=\"get\" class=\"row\">\r\n	<div class=\"col-md-10\">\r\n		<input type=\"text\" name=\"search\" placeholder=\"[#6#]...\" value=\"[*get_search*]\" class=\"form-control\" />\r\n	</div>\r\n	<div class=\"col-md-2\">\r\n		<button class=\"btn btn-default form-control\" type=\"submit\"><span class=\"glyphicon glyphicon-search\"></span> [#5#]</button>\r\n	</div>\r\n	<br><br><br>\r\n</form>',	0),
(9,	'pop_cart',	'',	0,	9,	0,	'<div class=\"modal fade\" id=\"Cart\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"myModalLabel\" aria-hidden=\"true\">\r\n	<div class=\"modal-dialog\">\r\n		<div class=\"modal-content\">\r\n			<div class=\"modal-header\">\r\n				<button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-hidden=\"true\">&times;</button>\r\n				<h4 class=\"modal-title\" id=\"myModalLabel\">Корзина</h4>\r\n			</div>\r\n			<div class=\"modal-body row\">\r\n				<table class=\"table table-condensed table-bordered table-striped\">\r\n					[[Shop?&get=`cart`&tpl=`tpl_cart`]]\r\n					<tr>\r\n						<th colspan=\"4\">ИТОГО</th>\r\n						<th><span></span> [(currency)]</th>\r\n					</tr>\r\n				</table>\r\n			</div>\r\n			<div class=\"modal-footer\">\r\n				<button type=\"button\" class=\"btn btn-default pull-left\" data-dismiss=\"modal\">Продолжить покупки</button>\r\n				<a href=\"[~~10~~]\" class=\"btn btn-success\"><span class=\"glyphicon glyphicon-shopping-cart\"></span> Оформить заказ</a>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>',	0),
(4,	'FOOTER',	'',	0,	6,	0,	'<div class=\"container\">\r\n	<form method=\"post\" action=\"\" class=\"col-md-20\"><div class=\"pull-right\">\r\n		<div class=\"col-md-7\">\r\n			<input type=\"text\" name=\"subscribe[email]\" value=\"\" class=\"form-control\" />\r\n		</div>\r\n		<div class=\"col-md-5\">\r\n			<button type=\"submit\" class=\"btn btn-default form-control\">[#7#]</button>\r\n		</div></div>\r\n	</form>\r\n</div>\r\n<div id=\"alert\"><span class=\"close\">&times;</span><p>Сообщение</p></div>\r\n<script>\r\n	_lang = $.cookie(\"lang\") == undefined ? \"[(lang_default)]\" : $.cookie(\'lang\');\r\n	_curr = $.cookie(\"currency\") == undefined ? \"[(shop_curr_default_code)]\" : $.cookie(\'currency\');\r\n	$(\".js_switch_lang button[value=\'\"+_lang+\"\']\").parent().addClass(\"active\");\r\n	$(\".js_switch_curr button[value=\'\"+_curr+\"\']\").parent().addClass(\"active\");\r\n</script>\r\n</body>\r\n</html>',	0),
(5,	'tpl_catalog',	'',	0,	7,	0,	'<div class=\"item\">\r\n    <!-- {product_id} -->\r\n	<a href=\"{url}\"><img src=\"[[R?&img=`/assets/images/items/{product_id}/{product_cover}`&opt=`w=240&h=240&far=1`]]\" alt=\"{product_name}\" class=\"thumbnail item_image\"></a>\r\n	<a href=\"{url}\" class=\"item_title\">{product_name}</a>\r\n	<div class=\"item_bottom\">\r\n		<span class=\"item_price\">{product_price} [(currency)]</span>\r\n		<a href=\"[~[*id*]~]?buy={product_id}\" data-buy=\"{product_id}\" class=\"btn btn-success pull-right\"><span class=\"glyphicon glyphicon-shopping-cart\"></span> [#19#]</a>\r\n	</div>\r\n</div>',	0),
(6,	'tpl_item_spec',	'',	0,	8,	0,	'<tr>\r\n	<td>{filter_name}</td>\r\n	<td>{filter_value}</td>\r\n</tr>',	0),
(7,	'tpl_item_image',	'',	0,	8,	0,	'<li><a href=\"[[R?&img=`{image}`&folder=`item/[*product_id*]`&opt=`h=700&far=1&fltr=wmt|[(site_name)]|25|BR|ffffff|fonts/5102337.ttf|100||0|000000|50|`]]\"><img src=\"[[R?&img=`{image}`&folder=`item/[*product_id*]`&opt=`w=64&h=64&zc=1`]]\" alt=\"[*product_name*]\" class=\"thumbnail\" /></a></li>',	0),
(8,	'tpl_item_image_fb',	'',	0,	8,	0,	'\'[[R?&img=`{image}`&folder=`item/[*product_id*]`&opt=`h=700&far=1&fltr=wmt|[(site_name)]|25|BR|ffffff|fonts/5102337.ttf|100||0|000000|50|`]]\' ,',	0),
(10,	'tpl_cart',	'',	0,	10,	0,	'<tr>\r\n	<td><span class=\"cart_remove\" data-cart-remove=\"{product_id}\">&times;</span></td>\r\n	<td>\r\n		<a href=\"{product_url}\" target=\"_blank\" class=\"pull-left\"><img src=\"[[R?&img=`/assets/images/items/{product_id}/{product_cover}`&folder=`item/{product_id}`&opt=`w=32&h=32&far=1`]]\" alt=\"{product_name}\" class=\"thumbnail\"></a>\r\n		<a href=\"{product_url}\" target=\"_blank\">{product_name}</a>\r\n	</td>\r\n	<td><span>{product_price}</span> [(currency)] &times;</td>\r\n	<td class=\"col-md-2\"> <input type=\"text\" name=\"{product_id}\" value=\"{cart_quantity}\" data-filter=\"0-9\" class=\"form-control\" /></td>\r\n	<td><span>{cart_sum}</span> [(currency)]</td>\r\n</tr>',	0),
(11,	'tpl_item_order',	'',	0,	7,	0,	'<div class=\"panel panel-default\">\r\n	<div class=\"panel-body\">\r\n		<a href=\"{product_url}\" target=\"_blank\" class=\"pull-left\"><img src=\"[[R?&img=`/assets/images/items/{product_id}/{product_cover}`&folder=`item/{product_id}`&opt=`w=64&h=64&far=1`]]\" alt=\"{product_name}\" class=\"thumbnail\"> <b>{product_name}</b></a>\r\n		<br>\r\n		<small class=\"pull-right text-muted\"><i>{product_code}</i></small>\r\n		<div class=\"clearfix\"></div>\r\n		{product_price}  &times; {cart_quantity} = <b><span class=\"js_item\">{cart_sum}</span> [(currency)]</b>\r\n	</div>\r\n</div>',	0),
(12,	'mail_order_item',	'',	0,	11,	0,	'<tr>\r\n	<td><a href=\"{product_url}\" target=\"_blank\"><img src=\"[(site_url)][[R?&img=`/assets/images/items/{product_id}/{product_cover}`&folder=`item/{product_id}`&opt=`w=64&h=64&far=1`]]\" alt=\"{product_name}\"></a></td>\r\n	<td><a href=\"{product_url}\" target=\"_blank\">{product_name}</a></td>\r\n	<td>{product_price}</td>\r\n	<td>{cart_quantity}</td>\r\n	<td>{cart_sum}</td>\r\n</tr>',	0),
(13,	'tpl_option',	'',	0,	0,	0,	'<option value=\"[+id+]\">[+pagetitle+]</option>',	0),
(14,	'tpl_order',	'',	0,	12,	0,	'<tr>\r\n	<th>{order_num}</th>\r\n	<td>{order_created}</td>\r\n	<td>{order_total} [(currency)]</td>\r\n	<td>\r\n		[!if?&is=`{order_status}:=:5`&then=`<span class=\"label label-default\">Отменен</span>`!]\r\n		[!if?&is=`{order_status}:=:1`&then=`<span class=\"label label-info\">Новый</span>`!]\r\n		[!if?&is=`{order_status}:=:2`&then=`<span class=\"label label-danger\">Ожидает оплаты</span>`!]\r\n		[!if?&is=`{order_status}:=:3`&then=`<span class=\"label label-warning\">Доставляется</span>`!]\r\n		[!if?&is=`{order_status}:=:4`&then=`<span class=\"label label-success\">Доставлен</span>`!]\r\n	</td>\r\n	<td>\r\n		[!if?&is=`{order_status_pay}:=:0`&then=`\r\n		<span class=\"label label-danger\">Не оплачен</span>\r\n		`&else=`\r\n		<span class=\"label label-success\">Оплачен</span>\r\n		`!]\r\n	</td>\r\n	<td width=\"70px\"><a href=\"#\" data-order-details=\"{order_id}\" class=\"btn btn-xs btn-info\"><span class=\"glyphicon glyphicon-info-sign\"></span> Детали заказа</a></td>\r\n</tr>',	0),
(15,	'tpl_order_empty',	'',	0,	12,	0,	'<tr>\r\n	<td colspan=\"6\" align=\"center\"><i>Вы не сделали ни одного заказа на сайте</i></td>\r\n</tr>',	0),
(16,	'tpl_user_addr',	'',	0,	12,	0,	'<tr>\r\n	<td width=\"100px\"><input type=\"text\" name=\"profile[addr][index][]\" value=\"{index}\" placeholder=\"Индекс\" class=\"form-control\"></td>\r\n	<td><input type=\"text\" name=\"profile[addr][city][]\" value=\"{city}\" placeholder=\"Город\" class=\"form-control\"></td>\r\n	<td><input type=\"text\" name=\"profile[addr][ave][]\" value=\"{ave}\" placeholder=\"Улица\" class=\"form-control\"></td>\r\n	<td width=\"100px\"><input type=\"text\" name=\"profile[addr][house][]\" value=\"{house}\" placeholder=\"Дом\" class=\"form-control\"></td>\r\n	<td width=\"110px\"><input type=\"text\" name=\"profile[addr][room][]\" value=\"{room}\" placeholder=\"Квартира\" class=\"form-control\"></td>\r\n	<td><a href=\"#\" class=\"btn btn-danger js_addr_remove\"><span class=\"glyphicon glyphicon-remove-sign\"></span></a></td>\r\n</tr>',	0),
(17,	'tpl_user_addr_order',	'',	0,	7,	0,	'<option value=\"{key}\">{index} г.{city} ул.{ave}, {house} кв. {room}</option>',	0),
(18,	'tpl_delivery',	'',	0,	7,	0,	'<option value=\"{delivery_id}\" data-delivery=\"{delivery_cost}\">{delivery_title} ({delivery_cost} [(currency)])</option>',	0),
(19,	'tpl_order_details',	'',	0,	12,	0,	'<tr class=\"hide js_order_detail\">\r\n	<td colspan=\"6\">\r\n		<table class=\"table\">\r\n			<tr>\r\n				<th>Наименование</th>\r\n				<th>Цена</th>\r\n				<th>Количество</th>\r\n				<th>Стоимость</th>\r\n			</tr>\r\n			{items}\r\n			<tr>\r\n				<th colspan=\"3\">Доставка</th>\r\n				<th>{order_delivery_cost} [(currency)]</th>\r\n			</tr>\r\n			<tr>\r\n				<th colspan=\"3\">ИТОГО К ОПЛАТЕ</th>\r\n				<th>{order_total} [(currency)]</th>\r\n			</tr>\r\n		</table>\r\n		{pay_form}\r\n	</td>\r\n</tr>',	0),
(20,	'tpl_order_details_item',	'',	0,	12,	0,	'<tr>\r\n	<td><a href=\"[~~[(shop_page_item)]~~]{product_url}\" target=\"_blank\">{product_name}</a></td>\r\n	<td>{product_price} [(currency)]</td>\r\n	<td>{product_count}</td>\r\n	<td>{product_cost} [(currency)]</td>\r\n</tr>',	0),
(21,	'tpl_filter_wrap',	'',	0,	13,	0,	'<div class=\"panel panel-default\">\r\n	<div class=\"panel-heading\">\r\n		<h4 class=\"panel-title\">\r\n			<a data-toggle=\"collapse\" data-parent=\"#accordion\" href=\"#filter{filter_id}\">\r\n				{filter_name}\r\n			</a>\r\n			<span class=\"pull-right text-default glyphicon glyphicon-info-sign\" title=\"{filter_desc}\"></span>\r\n		</h4>\r\n	</div>\r\n	<div id=\"filter{filter_id}\" class=\"panel-collapse collapse in\">\r\n		<div class=\"panel-body\">\r\n			{filters}\r\n		</div>\r\n	</div>\r\n</div>',	0),
(22,	'tpl_type2',	'OR',	0,	13,	0,	'<label><input type=\"radio\" name=\"f[{filter_id}]\" value=\"1\"> <span class=\"label label-success\">Yes</span></label>\r\n<label><input type=\"radio\" name=\"f[{filter_id}]\" value=\"-1\" checked> <span class=\"label label-warning\">Does not matter</span></label>\r\n<label><input type=\"radio\" name=\"f[{filter_id}]\" value=\"0\"> <span class=\"label label-danger\">No</span></label>',	0),
(23,	'tpl_type3',	'AND',	0,	13,	0,	'<label><input type=\"checkbox\" name=\"f[{filter_id}][]\" value=\"{value_id}\"> {value}</label>',	0),
(24,	'tpl_type1',	'',	0,	13,	0,	'<div class=\"row\">\r\n	<div class=\"col-md-12\">\r\n		<input type=\"text\" id=\"slider{filter_id}\" class=\"span2\" value=\"\" data-slider-min=\"{min}\" data-slider-max=\"{max}\" data-slider-step=\"1\" data-slider-value=\"[{min},{max}]\" data-slider-orientation=\"horizontal\" data-slider-selection=\"after\" data-slider-tooltip=\"hide\">\r\n	</div>\r\n	<br>\r\n	<div class=\"col-md-6\">\r\n		<input type=\"text\" name=\"f[{filter_id}][min]\" value=\"{min}\" class=\"form-control\">	\r\n	</div>\r\n	<div class=\"col-md-6\">\r\n		<input type=\"text\" name=\"f[{filter_id}][max]\" value=\"{max}\" class=\"form-control\">\r\n	</div>\r\n</div>\r\n<script>\r\n	$(document).ready(function(){\r\n		$(\"#slider{filter_id}\").slider().on(\"slide\", function(ev){\r\n            $(this).closest(\".row\").find(\"[name*=\'min\']\").val(ev.value[0]);\r\n            $(this).closest(\".row\").find(\"[name*=\'max\']\").val(ev.value[1]);\r\n        })\r\n	})\r\n</script>',	0),
(25,	'tpl_button',	'',	0,	0,	0,	'<label class=\"btn btn-xs btn-{class}\">\r\n	<input type=\"radio\" name=\"{name}\" value=\"{val}\" /> {value}\r\n</label>',	0),
(26,	'tpl_page_enable',	'pagination',	0,	7,	0,	'<li><a href=\"{url}\" class=\"{class}\">{title}</a></li>',	0),
(27,	'tpl_page_disable',	'desabled pagination',	0,	7,	0,	'<li class=\"{class}\"><span>{title}<span></li>',	0),
(28,	'tpl_search',	'',	0,	14,	0,	'<div class=\"item\">\r\n	<a href=\"{url}\"><img src=\"[[R?&img=`/assets/images/items/{product_id}/{product_cover}`&opt=`w=240&h=240&far=1`]]\" alt=\"{product_name}\" class=\"thumbnail item_image\"></a>\r\n	<a href=\"{url}\" class=\"item_title\">{product_name}</a>\r\n	<div class=\"item_bottom\">\r\n		<span class=\"item_price\">{product_price} [(currency)]</span>\r\n		<a href=\"[~[*id*]~]?buy={product_id}\" data-buy=\"{product_id}\" class=\"btn btn-success pull-right\"><span class=\"glyphicon glyphicon-shopping-cart\"></span> Купить</a>\r\n	</div>\r\n</div>',	0),
(29,	'tpl_search_empty',	'',	0,	14,	0,	'Я ничего не нашел!',	0),
(30,	'tpl_recall',	'',	0,	8,	0,	'<blockquote>\r\n	<p>{recall_text}</p>\r\n	<footer>{recall_name}</footer>\r\n</blockquote>',	0),
(31,	'wf_menu_parent',	'',	0,	3,	0,	'<li class=\"dropdown\">\r\n	<a href=\"[+wf.link+]\" role=\"button\" class=\"dropdown-toggle\" data-toggle=\"dropdown\">[+wf.linktext+] <span class=\"caret\"></span></a>\r\n	[+wf.wrapper+]\r\n</li>',	0),
(32,	'wf_menu_inner',	'',	0,	3,	0,	'<ul class=\"dropdown-menu\" role=\"menu\">[+wf.wrapper+]</ul>',	0);

CREATE TABLE `modx_site_keywords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `keyword` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Site keyword list';


CREATE TABLE `modx_site_metatags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `tag` varchar(50) NOT NULL DEFAULT '' COMMENT 'tag name',
  `tagvalue` varchar(255) NOT NULL DEFAULT '',
  `http_equiv` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - use http_equiv tag style, 0 - use name',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Site meta tags';


CREATE TABLE `modx_site_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '0',
  `editor_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
  `disabled` tinyint(4) NOT NULL DEFAULT '0',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT 'category id',
  `wrap` tinyint(4) NOT NULL DEFAULT '0',
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'url to module icon',
  `enable_resource` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'enables the resource file feature',
  `resourcefile` varchar(255) NOT NULL DEFAULT '' COMMENT 'a physical link to a resource file',
  `createdon` int(11) NOT NULL DEFAULT '0',
  `editedon` int(11) NOT NULL DEFAULT '0',
  `guid` varchar(32) NOT NULL DEFAULT '' COMMENT 'globally unique identifier',
  `enable_sharedparams` tinyint(4) NOT NULL DEFAULT '0',
  `properties` text,
  `modulecode` mediumtext COMMENT 'module boot up code',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Site Modules';

INSERT INTO `modx_site_modules` (`id`, `name`, `description`, `editor_type`, `disabled`, `category`, `wrap`, `locked`, `icon`, `enable_resource`, `resourcefile`, `createdon`, `editedon`, `guid`, `enable_sharedparams`, `properties`, `modulecode`) VALUES
(1,	'Doc Manager',	'<strong>1.1</strong> Quickly perform bulk updates to the Documents in your site including templates, publishing details, and permissions',	0,	0,	2,	0,	0,	'',	0,	'',	0,	0,	'docman435243542tf542t5t',	1,	'',	'include_once(MODX_BASE_PATH.\'assets/modules/docmanager/classes/docmanager.class.php\');\ninclude_once(MODX_BASE_PATH.\'assets/modules/docmanager/classes/dm_frontend.class.php\');\ninclude_once(MODX_BASE_PATH.\'assets/modules/docmanager/classes/dm_backend.class.php\');\n\n$dm = new DocManager($modx);\n$dmf = new DocManagerFrontend($dm, $modx);\n$dmb = new DocManagerBackend($dm, $modx);\n\n$dm->ph = $dm->getLang();\n$dm->ph[\'theme\'] = $dm->getTheme();\n$dm->ph[\'ajax.endpoint\'] = MODX_SITE_URL.\'assets/modules/docmanager/tv.ajax.php\';\n$dm->ph[\'datepicker.offset\'] = $modx->config[\'datepicker_offset\'];\n$dm->ph[\'datetime.format\'] = $modx->config[\'datetime_format\'];\n\nif (isset($_POST[\'tabAction\'])) {\n    $dmb->handlePostback();\n} else {\n    $dmf->getViews();\n    echo $dm->parseTemplate(\'main.tpl\', $dm->ph);\n}'),
(2,	'Languages',	'',	0,	0,	0,	0,	0,	'',	0,	'',	0,	0,	'5c3fc0de3800db491e6fe6c03d6239a3',	0,	'',	'require MODX_BASE_PATH . \"assets/modules/lang/module.php\";'),
(3,	'Mailer',	'',	0,	0,	0,	0,	0,	'',	0,	'',	0,	0,	'b1174e2fa5e64516c27d922bafb60adf',	0,	'',	'/*\r\n    cron файл лежит рядом в папке модуля\r\n*/\r\nrequire MODX_BASE_PATH . \"assets/modules/mailer/index.php\"; '),
(4,	'SEO',	'',	0,	0,	0,	0,	0,	'',	0,	'',	0,	0,	'1e02aa06fad20590c97b51fc0c26c2ce',	0,	'',	'require MODX_BASE_PATH . \"assets/modules/seo/index.php\";');

CREATE TABLE `modx_site_module_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` int(11) NOT NULL DEFAULT '0',
  `usergroup` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Module users group access permission';


CREATE TABLE `modx_site_module_depobj` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` int(11) NOT NULL DEFAULT '0',
  `resource` int(11) NOT NULL DEFAULT '0',
  `type` int(2) NOT NULL DEFAULT '0' COMMENT '10-chunks, 20-docs, 30-plugins, 40-snips, 50-tpls, 60-tvs',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Module Dependencies';


CREATE TABLE `modx_site_plugins` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT 'Plugin',
  `editor_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT 'category id',
  `cache_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Cache option',
  `plugincode` mediumtext,
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `properties` text COMMENT 'Default Properties',
  `disabled` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Disables the plugin',
  `moduleguid` varchar(32) NOT NULL DEFAULT '' COMMENT 'GUID of module from which to import shared parameters',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains the site plugins.';

INSERT INTO `modx_site_plugins` (`id`, `name`, `description`, `editor_type`, `category`, `cache_type`, `plugincode`, `locked`, `properties`, `disabled`, `moduleguid`) VALUES
(1,	'FileSource',	'<strong>0.1</strong> Save snippet and plugins to file',	0,	2,	0,	'require MODX_BASE_PATH.\'assets/plugins/filesource/plugin.filesource.php\';',	0,	'',	0,	''),
(2,	'CodeMirror',	'<strong>1.2b</strong> JavaScript library that can be used to create a relatively pleasant editor interface based on CodeMirrir 3.13',	0,	2,	0,	'$_CM_BASE = \'assets/plugins/codemirror/\';\n\n$_CM_URL = $modx->config[\'site_url\'] . $_CM_BASE;\n\nrequire(MODX_BASE_PATH. $_CM_BASE .\'codemirror.plugin.php\');\n\n',	0,	'&theme=Theme;list;default,ambiance,blackboard,cobalt,eclipse,elegant,erlang-dark,lesser-dark,midnight,monokai,neat,night,rubyblue,solarized,twilight,vibrant-ink,xq-dark,xq-light; &indentUnit=Indent unit;int;4 &tabSize=The width of a tab character;int;4 &lineWrapping=lineWrapping;list;true,false;true &matchBrackets=matchBrackets;list;true,false;false &activeLine=activeLine;list;true,false;false &emmet=emmet;list;true,false;true &search=search;list;true,false;true',	0,	' '),
(3,	'TinyMCE Rich Text Editor',	'<strong>3.5.8</strong> Javascript WYSIWYG Editor',	0,	2,	0,	'require MODX_BASE_PATH.\'assets/plugins/tinymce/plugin.tinymce.php\';',	0,	'&customparams=Custom Parameters;textarea;valid_elements : \"*[*]\", &mce_formats=Block Formats;text;p,h1,h2,h3,h4,h5,h6,div,blockquote,code,pre &entity_encoding=Entity Encoding;list;named,numeric,raw;named &entities=Entities;text; &mce_path_options=Path Options;list;Site config,Absolute path,Root relative,URL,No convert;Site config &mce_resizing=Advanced Resizing;list;true,false;true &disabledButtons=Disabled Buttons;text; &link_list=Link List;list;enabled,disabled;enabled &webtheme=Web Theme;list;simple,editor,creative,custom;simple &webPlugins=Web Plugins;text;style,advimage,advlink,searchreplace,contextmenu,paste,fullscreen,xhtmlxtras,media &webButtons1=Web Buttons 1;text;undo,redo,selectall,|,pastetext,pasteword,|,search,replace,|,hr,charmap,|,image,link,unlink,anchor,media,|,cleanup,removeformat,|,fullscreen,code,help &webButtons2=Web Buttons 2;text;bold,italic,underline,strikethrough,sub,sup,|,|,blockquote,bullist,numlist,outdent,indent,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,|,styleprops &webButtons3=Web Buttons 3;text; &webButtons4=Web Buttons 4;text; &webAlign=Web Toolbar Alignment;list;ltr,rtl;ltr &width=Width;text;97% &height=Height;text;300',	0,	' '),
(4,	'TransAlias',	'<strong>1.0.2</strong> Human readible URL translation supporting multiple languages and overrides',	0,	2,	0,	'require MODX_BASE_PATH.\'assets/plugins/transalias/plugin.transalias.php\';',	0,	'&table_name=Trans table;list;common,russian,dutch,german,czech,utf8,utf8lowercase;russian &char_restrict=Restrict alias to;list;lowercase alphanumeric,alphanumeric,legal characters;lowercase alphanumeric &remove_periods=Remove Periods;list;Yes,No;Yes &word_separator=Word Separator;list;dash,underscore,none;dash &override_tv=Override TV name;string;',	0,	' '),
(5,	'ManagerManager',	'<strong>0.3.11</strong> Customize the MODx Manager to offer bespoke admin functions for end users.',	0,	2,	0,	'$js_default_url_local = $modx->config[\'site_url\']. \'/assets/js/jquery.min.js\';\n$js_default_url_remote = \'http://ajax.googleapis.com/ajax/libs/jquery/1.8/jquery.min.js\';\n$asset_path = $modx->config[\'base_path\'] . \'assets/plugins/managermanager/mm.inc.php\';\ninclude($asset_path);\n',	0,	'&config_chunk=Configuration Chunk;text;mm_rules; &remove_deprecated_tv_types_pref=Remove deprecated TV types;list;yes,no;yes &which_jquery=jQuery source;list;local (assets/js),remote (google code),manual url (specify below);local (assets/js) &js_src_type=jQuery URL override;text;',	0,	''),
(6,	'Shop',	'',	0,	7,	0,	'require MODX_BASE_PATH . \"assets/shop/plugin.index.php\";',	0,	'',	0,	' '),
(7,	'Language controller',	'',	0,	0,	0,	'require MODX_BASE_PATH . \"assets/modules/lang/plugin.php\";',	0,	'',	0,	' '),
(9,	'Mailer',	'',	0,	0,	0,	'/*\r\n    Плагин подписки/отписки на рассылку\r\n*/	\r\nswitch ($modx->event->name) {\r\n    case \'OnWebPageInit\':\r\n	case \'OnLoadWebDocument\':\r\n        if (isset($_GET[\'unsubscribe\']) && $_SESSION[\'hash\'][\'unsubscribe\'] != md5(serialize($_GET[\'unsubscribe\']))) {\r\n            $modx->db->query(\'delete from `modx_a_mailer_users` where user_email = \"\'.$modx->db->escape($_GET[\'unsubscribe\']).\'\"\');\r\n            $_SESSION[\'hash\'][\'unsubscribe\'] = md5(serialize($_GET[\'unsubscribe\']));\r\n            $js = \'alert(\"Вы успешно отписались от рассылки!\");\';\r\n        }\r\n        if (count($_POST[\'subscribe\']) > 0 && $_SESSION[\'hash\'][\'subscribe\'] != md5(serialize($_POST[\'subscribe\']))) {\r\n            $modx->db->query(\'insert into `modx_a_mailer_users` set user_email = \"\'.$modx->db->escape($_POST[\'subscribe\'][\'email\']).\'\" on duplicate key update user_email = user_email\');\r\n            $_SESSION[\'hash\'][\'subscribe\'] = md5(serialize($_POST[\'subscribe\']));\r\n            $js = \'alert(\"Вы были успешно подписаны на рассылку!\");\';\r\n        } elseif (count($_POST[\'subscribe\']) > 0 && !filter_var($_POST[\'subscribe\'][\'email\'], FILTER_VALIDATE_EMAIL))\r\n            $js = \'alert(\"Вы уже подаисаны на рассылку.\")\';\r\n        if (isset($js)) $modx->regClientScript($js);\r\n    break;\r\n}\r\n',	0,	'',	0,	' '),
(10,	'API',	'',	0,	0,	0,	'switch($modx->event->name) {\r\n	case \"OnWebPageInit\":\r\n	if ($_GET[\'lang\'] == \"api\")\r\n			require MODX_BASE_PATH.\"/assets/shop/plugin.api.php\";\r\n	else if (getenv(\"REMOTE_ADDR\") != \"217.112.221.86\") die($modx->config[\'site_unavailable_message\']);\r\n	break;\r\n}',	0,	'',	0,	' ');

CREATE TABLE `modx_site_plugin_events` (
  `pluginid` int(10) NOT NULL,
  `evtid` int(10) NOT NULL DEFAULT '0',
  `priority` int(10) NOT NULL DEFAULT '0' COMMENT 'determines plugin run order',
  PRIMARY KEY (`pluginid`,`evtid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Links to system events';

INSERT INTO `modx_site_plugin_events` (`pluginid`, `evtid`, `priority`) VALUES
(1,	34,	0),
(1,	35,	0),
(1,	36,	0),
(1,	40,	0),
(1,	41,	0),
(1,	42,	0),
(2,	23,	1),
(2,	41,	0),
(2,	35,	0),
(2,	29,	0),
(2,	73,	0),
(2,	47,	0),
(3,	85,	0),
(3,	87,	0),
(3,	88,	0),
(4,	100,	0),
(5,	28,	0),
(5,	29,	0),
(5,	53,	0),
(6,	81,	1),
(6,	90,	3),
(6,	1000,	1),
(6,	91,	1),
(2,	88,	1),
(6,	19,	1),
(7,	92,	1),
(7,	91,	1),
(7,	90,	2),
(9,	91,	1),
(9,	90,	1),
(10,	90,	0);

CREATE TABLE `modx_site_snippets` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT 'Snippet',
  `editor_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT 'category id',
  `cache_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Cache option',
  `snippet` mediumtext,
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `properties` text COMMENT 'Default Properties',
  `moduleguid` varchar(32) NOT NULL DEFAULT '' COMMENT 'GUID of module from which to import shared parameters',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains the site snippets.';



CREATE TABLE `modx_site_templates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `templatename` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT 'Template',
  `editor_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT 'category id',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'url to icon file',
  `template_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-page,1-content',
  `content` mediumtext,
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains the site templates.';

INSERT INTO `modx_site_templates` (`id`, `templatename`, `description`, `editor_type`, `category`, `icon`, `template_type`, `content`, `locked`) VALUES
(3,	'Index page',	'',	0,	0,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	<div class=\"jumbotron\">\r\n		<h1>Sales</h1>\r\n		<p>Only in our shop.</p>\r\n		<p>\r\n			<a class=\"btn btn-lg btn-primary\" href=\"/en/catalog/\" role=\"button\">Go to shop &raquo;</a>\r\n		</p>\r\n	</div>\r\n	\r\n</div> <!-- /container -->\r\n{{FOOTER}}',	0),
(4,	'Catalogue',	'',	0,	7,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	[[Shop?&get=`breadcrumbs`]]\r\n	<div class=\"row\">\r\n		<div id=\"filters\">\r\n		<form action=\"\" method=\"post\">\r\n			<div class=\"col-md-3\">			\r\n				<div class=\"panel-group\">\r\n					<div class=\"panel panel-default\">\r\n						<div class=\"panel-heading\">\r\n							<h4 class=\"panel-title\">\r\n								<a data-toggle=\"collapse\" data-parent=\"#accordion\" href=\"#filterPrice\">\r\n									<b>[#8#]</b>\r\n								</a>\r\n								<span class=\"pull-right text-default glyphicon glyphicon-info-sign\" title=\"Price range\"></span>\r\n							</h4>\r\n						</div>\r\n						<div id=\"filterPrice\" class=\"panel-collapse collapse in\">\r\n							<div class=\"panel-body\">\r\n								<div class=\"row\">\r\n									<div class=\"col-md-12\">\r\n										<input type=\"text\" id=\"sliderPrice\" class=\"span2\" value=\"\" data-slider-min=\"[*min*]\" data-slider-max=\"[*max*]\" data-slider-step=\"1\" data-slider-value=\"[[*min*],[*max*]]\" data-slider-orientation=\"horizontal\" data-slider-selection=\"after\" data-slider-tooltip=\"hide\">\r\n									</div>\r\n									<br>\r\n									<div class=\"col-md-6\">\r\n										<input type=\"text\" name=\"price[min]\" value=\"[*min*]\" class=\"form-control\">	\r\n									</div>\r\n									<div class=\"col-md-6\">\r\n										<input type=\"text\" name=\"price[max]\" value=\"[*max*]\" class=\"form-control\">\r\n									</div>\r\n								</div>\r\n							</div>\r\n						</div>\r\n					</div>\r\n					<input type=\"hidden\" name=\"p\" value=\"0\">\r\n					[[Shop?&get=`filters`&tplWrap=`tpl_filter_wrap`]]\r\n				</div>\r\n				<br>\r\n				<button class=\"btn btn-primary form-control\"> <b>[#9#]</b></button>\r\n				<br><br>\r\n				<a class=\"btn btn-danger form-control js_reset_filters\" disabled=\"disabled\"><span class=\"glyphicon glyphicon-remove\"></span> <b>[#10#]</b></a>		\r\n		</div>\r\n		<div class=\"col-md-5 col-md-offset-3 pull-right\">\r\n			<table >\r\n				<tr>\r\n					<td>\r\n						<select name=\"sort[price]\" class=\"nc form-control\">\r\n							<option value=\"-1\">--[#11#]--</option>\r\n							<option value=\"expensive\">[#12#]</option>\r\n							<option value=\"cheap\">[#13#]</option>\r\n						</select>\r\n					</td>\r\n					<td>\r\n					</td>					\r\n					<td>\r\n						<select name=\"sort[status]\" class=\"nc form-control\">\r\n							<option value=\"-1\">--[#14#]--</option>\r\n							<option value=\"1\">[#15#]</option>\r\n							<option value=\"2\">[#16#]</option>\r\n							<option value=\"3\">[#17#]</option>\r\n							<option value=\"4\">[#18#]</option>\r\n						</select>\r\n					</td>\r\n					<td>\r\n					</td>\r\n					<td>\r\n						<button class=\"btn btn-primary form-control\"><span class=\"glyphicon glyphicon-sort\"></span></button>\r\n					</td>\r\n				</tr>	\r\n			</table>\r\n		</div>\r\n		</form>\r\n		</div>\r\n		<br>\r\n		<div class=\"col-md-9 catalog js_catalog\">			\r\n			[[Shop?&get=`catalog`&tpl=`tpl_catalog`&limit=`12`]]\r\n		</div>\r\n		<center>\r\n			<div>\r\n				<ul class=\"pagination js_paginate\">\r\n				[[Shop?&get=`paginate`]]\r\n				</ul>\r\n			</div>		\r\n		</center>\r\n	</div>\r\n</div> <!-- /container -->\r\n<script>\r\n	$(document).ready(function(){\r\n		restoreHash();\r\n	})\r\n</script>\r\n{{FOOTER}}',	0),
(5,	'Product',	'',	0,	7,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	[[Shop?&get=`breadcrumbs`&id=`[(shop_catalog_root)]`]]\r\n	<div class=\"page_item\">\r\n		<div class=\"row\">\r\n			<div class=\"page_item_image col-md-4\">\r\n				<a href=\"[[R?&img=`/assets/images/items/[*product_id*]/[*product_cover*]`&folder=`item/[*product_id*]`&opt=`h=700&far=1&fltr=wmt|[(site_name)]|25|BR|ffffff|fonts/5102337.ttf|100||0|000000|50|`]]\">\r\n					<img src=\"[[R?&img=`/assets/images/items/[*product_id*]/[*product_cover*]`&folder=`item/[*product_id*]`&opt=`w=360&h=320&far=1`]]\" alt=\"[*product_name*]\">\r\n				</a>\r\n				<ul class=\"product_images\">\r\n					[[Shop?&get=`item_images`&tpl=`tpl_item_image`]]	\r\n				</ul>			\r\n			</div>\r\n			<div class=\"page_item_desc col-md-6\">\r\n				<h1>[*product_name*]</h1>\r\n				\r\n				<div class=\"page_item_intro\">[*product_introtext*]</div>\r\n				<span class=\"text-success page_item_desc_price\">[*product_price*] [(currency)]</span>\r\n				<a href=\"?buy=[*product_id*]\" class=\"btn btn-lg btn-success\" data-buy=\"[*product_id*]\"><span class=\"glyphicon glyphicon-shopping-cart\"></span> Buy</a>\r\n				<br><br>\r\n				<pre>Social buttons here</pre>\r\n			</div>\r\n		</div>\r\n		<div class=\"col-md-12\">\r\n			<ul class=\"nav nav-tabs\" id=\"productTab\">\r\n				<li><a href=\"#desc\" data-toggle=\"tab\">Description</a></li>\r\n				<li><a href=\"#spec\" data-toggle=\"tab\">Technical details</a></li>\r\n				<li><a href=\"#messages\" data-toggle=\"tab\">Recalls</a></li>\r\n				<li><a href=\"#friends\" data-toggle=\"tab\">Recommend products</a></li>\r\n				<li><a href=\"#history\" data-toggle=\"tab\">Viewed products</a></li>\r\n			</ul>\r\n			<div class=\"tab-content\">\r\n				<div class=\"tab-pane fade\" id=\"desc\">\r\n					[*product_description*]\r\n				</div>\r\n				<div class=\"tab-pane fade\" id=\"spec\">\r\n					<table class=\"table table-bordered\">\r\n						[[Shop?&get=`item_spec`&tpl=`tpl_item_spec`]]\r\n					</table>\r\n				</div>\r\n				<div class=\"tab-pane fade\" id=\"messages\">\r\n					[[Shop?&get=`item_recalls`&tpl=`tpl_recall`]]\r\n					<form action=\"\" method=\"post\">\r\n						<div class=\"row\">\r\n							<div class=\"col-md-6\">\r\n								<input type=\"text\" name=\"recall[name]\" class=\"form-control col-md-6\" value=\"[*u_fullname*]\" placeholder=\"Name\" required>\r\n							</div>\r\n							<div class=\"col-md-6\">\r\n								<input type=\"text\" name=\"recall[email]\" class=\"form-control col-md-6\" value=\"[*u_email*]\" placeholder=\"Email\" required>\r\n							</div>\r\n							<br><br>\r\n							<div class=\"col-md-12\">\r\n								<textarea name=\"recall[text]\" placeholder=\"Your recall about [*product_name*]\" class=\"form-control\" required></textarea>\r\n								<input type=\"hidden\" name=\"recall[product]\" value=\"[*product_id*]\">\r\n								<br>\r\n								<button class=\"submit btn btn-primary\"><span class=\"glyphicon glyphicon-comment\"></span> Send recall</button>\r\n							</div>\r\n						</div>\r\n					</form>\r\n				</div>\r\n				<div class=\"tab-pane fade\" id=\"friends\">\r\n					<div class=\"col-md-9 catalog js_catalog\">\r\n						[[Shop?&get=`friends_product`&tpl=`tpl_catalog`&friends=`[*product_friends*]`]]\r\n					</div>\r\n				</div>\r\n				<div class=\"tab-pane fade\" id=\"history\">\r\n					<div class=\"col-md-9 catalog js_catalog\">\r\n						[[Shop?&get=`friends_product`&tpl=`tpl_catalog`&friends=`[*history*]`]]\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>\r\n<script type=\"text/javascript\" src=\"/assets/site/fancybox/jquery.fancybox.pack.js?v=2.1.5\"></script>\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/assets/site/fancybox/jquery.fancybox.css?v=2.1.5\" media=\"screen\" />\r\n<script>\r\n	$(document).ready(function(){\r\n		$(\'#productTab a\').click(function (e) {\r\n			e.preventDefault()\r\n			$(this).tab(\'show\');\r\n		})\r\n		if (window.location.hash != \"\")\r\n			$(\"[href=\'\"+window.location.hash+\"\']\").trigger(\"click\");\r\n		else \r\n			$(\"#productTab a:first\").trigger(\"click\");\r\n		\r\n		$(\".page_item_image a:has(img)\").on(\"click\", function (){\r\n			var idx = $(\".product_images [href=\'\"+$(this).attr(\"href\")+\"\']\").parents(\"li\").index();\r\n			$.fancybox([\r\n				[[Shop?&get=`item_images`&tpl=`tpl_item_image_fb`]]	\r\n			], {type    : \'image\',\r\n				cyclic  : \'true\', \r\n				index   : idx == -1 ? 0 : idx});\r\n			return false;\r\n		});\r\n	});\r\n</script>\r\n{{FOOTER}}',	0),
(6,	'Checkout',	'',	0,	7,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	[[Shop?&get=`breadcrumbs`]]\r\n	[!if?&is=`[*error*]:!=:` &then=`\r\n		<div class=\"alert alert-danger alert-dismissable col-md-12\">\r\n			<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>\r\n			<strong>[*error*]</strong>\r\n		</div>\r\n	`!]\r\n	<div class=\"row\">\r\n		<div class=\"col-md-6\">\r\n			<ul class=\"nav nav-tabs\" id=\"myTab\">\r\n				[!if?&is=`[*u_internalKey*]:=:`&then=`\r\n					<li class=\"active\"><a href=\"#new-client\" data-toggle=\"tab\">New customer</a></li>\r\n					<li><a href=\"#old-client\" data-toggle=\"tab\">Regular customer</a></li>\r\n				`&else=`\r\n					<li class=\"active\"><a href=\"#new-client\" data-toggle=\"tab\">Regular customer</a></li>\r\n				`!]\r\n			</ul>\r\n			\r\n			<div class=\"tab-content\">\r\n				<div class=\"tab-pane active\" id=\"new-client\">\r\n					<form action=\"\" method=\"post\">\r\n						<table class=\"table\">\r\n							<tr>\r\n								<th colspan=\"2\">Contact info</th>\r\n							</tr>\r\n							<tr>\r\n								<td>Your name</td>\r\n								<td><input type=\"text\" name=\"order[fullname]\" value=\"[*u_fullname*]\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td>Email <sup>*</sup></td>\r\n								<td><input type=\"text\" name=\"order[email]\" value=\"[*u_email*]\" class=\"form-control\" required></td>\r\n							</tr>\r\n							<tr>\r\n								<td>Phone <sup>*</sup></td>\r\n								<td><input type=\"text\" name=\"order[phone]\" value=\"[*u_phone*]\" class=\"form-control\" required></td>\r\n							</tr>\r\n							<tr>\r\n								<th colspan=\"2\">Delivery</th>\r\n							</tr>\r\n							<tr>\r\n								<td>Dlivery type</td>\r\n								<td>\r\n									<select name=\"order[delivery]\" class=\"form-control\" data-active=\"[*u_delivery*]\">\r\n										[[Shop?&get=`delivery_list`&tpl=`tpl_delivery`]]\r\n									</select>\r\n								</td>\r\n							</tr>\r\n							<tr class=\"hide newpost\">\r\n								<td>City</td>\r\n								<td>\r\n									<select name=\"order[addr][city]\" id=\"newpost_city\" class=\"form-control\">\r\n										[[Shop?&get=`newpost`&type=`city`&tpl=`tpl_option`]]\r\n									</select>\r\n								</td>\r\n							</tr>\r\n							<tr class=\"hide newpost\">\r\n								<td>Warehouse</td>\r\n								<td>\r\n									<select name=\"order[addr][warehouse]\" id=\"newpost_warehouse\" class=\"form-control\">\r\n									</select>\r\n								</td>\r\n							</tr>\r\n							[!if?&is=`[*u_internalKey*]:!=:`&then=`\r\n							<tr>\r\n								<td>Delivery address</td>\r\n								<td>\r\n									<select name=\"order[addr]\" class=\"form-control\">\r\n										[[Shop?&get=`newpost`&tpl=`tpl_user_addr_order`]]\r\n									</select>\r\n								</td>\r\n							</tr>\r\n							`&else=`\r\n							<tr>\r\n								<td>ZIP</td>\r\n								<td><input type=\"text\" name=\"order[addr][index]\" value=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td>City</td>\r\n								<td><input type=\"text\" name=\"order[addr][city]\" value=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td>Street</td>\r\n								<td><input type=\"text\" name=\"order[addr][ave]\" value=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td>House</td>\r\n								<td><input type=\"text\" name=\"order[addr][house]\" value=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td>Apartment</td>\r\n								<td><input type=\"text\" name=\"order[addr][room]\" value=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							`!]\r\n							<tr>\r\n								<td>Order comment</td>\r\n								<td>\r\n									<textarea name=\"order[comment]\" class=\"form-control\"></textarea>\r\n								</td>\r\n							</tr>\r\n							<tr>\r\n								<td></td>\r\n								<td><button class=\"btn btn-success btn-lg\"><span class=\"glyphicon glyphicon-ok-sign\"></span> Checkout</button></td>\r\n							</tr>\r\n						</table>\r\n						\r\n					</form>\r\n				</div>\r\n				[!if?&is=`[*u_internalKey*]:=:`&then=`\r\n				<div class=\"tab-pane\" id=\"old-client\">\r\n					<form action=\"\" method=\"post\">\r\n						<table class=\"table table-condensed\">\r\n							<tr>\r\n								<td>Email</td>\r\n								<td><input type=\"text\" name=\"auth[email]\" id=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td>Password</td>\r\n								<td><input type=\"password\" name=\"auth[pass]\" id=\"\" class=\"form-control\"></td>\r\n							</tr>\r\n							<tr>\r\n								<td></td>\r\n								<td>\r\n									<button class=\"btn btn-primary btn-lg\"><span class=\"glyphicon glyphicon-share\"></span> Sign in</button>\r\n								</td>\r\n							</tr>\r\n						</table>\r\n						<input type=\"hidden\" name=\"auth[redirect]\" value=\"[*id*]\">\r\n					</form>\r\n				</div>\r\n				`!]\r\n			</div>\r\n		</div>\r\n		<div class=\"col-md-6 js_order_cart\">\r\n			<h4 class=\"text-muted pull-right\">Ordered products</h4>\r\n			<div class=\"clearfix\"></div>\r\n			[[Shop?&get=`cart`&tpl=`tpl_item_order`]]\r\n			<hr>\r\n			<h3 class=\"order_total text-muted\">Delivery cost: <b><span class=\"js_delivery\"></span> [(currency)]</b></h3>\r\n			<h3 class=\"order_total text-primary\">TOTAL: <b><span class=\"js_total\"></span> [(currency)]</b></h3>\r\n		</div>\r\n	</div>\r\n	\r\n</div>\r\n<script>\r\n	$(document).ready(function(){\r\n		calcOrder();\r\n	})\r\n</script>\r\n{{FOOTER}}',	0),
(7,	'Site page',	'',	0,	0,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	[*content*]\r\n	\r\n</div> <!-- /container -->\r\n{{FOOTER}}',	0),
(8,	'User profile',	'',	0,	12,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	[!if?&is=`[*error*]:!=:` &then=`\r\n	<div class=\"alert alert-danger alert-dismissable col-md-12\">\r\n		<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>\r\n		<strong>[*error*]</strong>\r\n	</div>\r\n	`!]\r\n	[!if?&is=`[*success*]:!=:` &then=`\r\n	<div class=\"alert alert-success alert-dismissable col-md-12\">\r\n		<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>\r\n		<strong>[*success*]</strong>\r\n	</div>\r\n	`!]\r\n	<ul class=\"nav nav-tabs\">\r\n		<li class=\"active\"><a href=\"#data\" data-toggle=\"tab\"><span class=\"glyphicon glyphicon-list-alt\"></span> My userdata</a></li>\r\n		<li><a href=\"#orders\" data-toggle=\"tab\"><span class=\"glyphicon glyphicon-credit-card\"></span> My orders</a></li>\r\n	</ul>\r\n	<div class=\"tab-content\">\r\n		<div class=\"tab-pane active\" id=\"data\">\r\n			<h3>Customer data</h3>\r\n			<form action=\"\" method=\"post\">\r\n				<table class=\"table table-bordered table-condensed\">\r\n					<tr>\r\n						<th width=\"150px\">Name</th>\r\n						<td><input type=\"text\" name=\"profile[name]\" value=\"[*u_fullname*]\" class=\"form-control\"></td>\r\n					</tr>\r\n					<tr>\r\n						<th>Email</th>\r\n						<td><input type=\"text\" name=\"profile[email]\" value=\"[*u_email*]\" class=\"form-control\"></td>\r\n					</tr>\r\n					<tr>\r\n						<th>Phone</th>\r\n						<td><input type=\"text\" name=\"profile[phone]\" value=\"[*u_phone*]\" class=\"form-control\"></td>\r\n					</tr>\r\n					<tr>\r\n						<th>Delivery type</th>\r\n						<td>\r\n							<select name=\"profile[delivery]\" class=\"form-control\" data-active=\"[*u_delivery*]\">\r\n								[[Shop?&get=`delivery_list`&tpl=`tpl_delivery`]]\r\n							</select>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<th>Delivery address</th>\r\n						<td>\r\n							\r\n							<table class=\"table\" id=\"js_addr\">\r\n								[[Shop?&get=`user_addr`&tpl=`tpl_user_addr`]]\r\n							</table>\r\n							<a href=\"#\" class=\"btn btn-success js_addr_add\"><span class=\"glyphicon glyphicon-plus-sign\"></span> Add delivery address</a>\r\n						</td>\r\n					</tr>\r\n				</table>\r\n				<h3>Change password</h3>\r\n				<table class=\"table table-bordered table-condensed\">\r\n					<tr>\r\n						<th width=\"150px\">Current password</th>\r\n						<td><input type=\"password\" name=\"profile[old]\" id=\"\" class=\"form-control\"></td>\r\n					</tr>\r\n					<tr>\r\n						<th>New password</th>\r\n						<td><input type=\"password\" name=\"profile[new]\" id=\"\" class=\"form-control\"></td>\r\n					</tr>\r\n					<tr>\r\n						<th>New password confirm</th>\r\n						<td><input type=\"password\" name=\"profile[cfm]\" id=\"\" class=\"form-control\"></td>\r\n					</tr>\r\n				</table>\r\n				<button class=\"btn btn-primary\">Update my data</button>\r\n			</form>\r\n		</div>\r\n		<div class=\"tab-pane\" id=\"orders\">\r\n			<table class=\"table table-bordered table-condensed\">\r\n				<tbody>\r\n					<tr>\r\n						<th>#</th>\r\n						<th>Date</th>\r\n						<th>Price</th>\r\n						<th>Order status</th>\r\n						<th>Pay status</th>\r\n						<th></th>\r\n					</tr>\r\n				</tbody>\r\n				<tbody>\r\n					[[Shop?&get=`orders`&tpl=`tpl_order`]]\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n	</div>\r\n	<script>\r\n		var _row = $(\"#js_addr tr:last\").clone();\r\n		$(\".js_addr_add\").on(\"click\", function(){\r\n			_row.find(\"input\").val(\'\');\r\n			$(\"#js_addr\").append(_row.clone());\r\n			return false;\r\n		});\r\n		$(\"#js_addr\").on(\"click\", \".js_addr_remove\", function(){\r\n			if (!confirm(\'Delete address?\')) return false;\r\n			$(this).closest(\"tr\").remove();\r\n			return false;\r\n		});\r\n	</script>\r\n</div> <!-- /container -->\r\n{{FOOTER}}',	0),
(9,	'Search results',	'',	0,	0,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	<div class=\"col-md-14 catalog js_catalog\">\r\n		<h3>Результаты поиска</h3>\r\n		[[Shop?&get=`search`&tpl=`tpl_search`&limit=`15`&tplEmpty=`tpl_search_empty`]]\r\n	</div>\r\n	<center>\r\n		<div>\r\n			<ul class=\"pagination js_paginate\">\r\n				[[Shop?&get=`paginate`&tpl=`tpl_paginate`&page=`1`&classJS=` js_search_page`]]\r\n			</ul>\r\n		</div>		\r\n	</center>\r\n</div> <!-- /container -->\r\n{{FOOTER}}',	0),
(10,	'Auth/Register',	'',	0,	12,	'',	0,	'{{HEAD}}\r\n<div class=\"container\">\r\n	{{HEADER}}\r\n	[!if?&is=`[*error*]:!=:` &then=`\r\n	<div class=\"alert alert-danger alert-dismissable col-md-12\">\r\n		<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>\r\n		<strong>[*error*]</strong>\r\n	</div>\r\n	`!]\r\n	<div class=\"small-forms\">\r\n		<form class=\"form-signin\" role=\"form\" id=\"auth\" method=\"post\">\r\n			<h3 class=\"form-signin-heading\">[#3#]</h3>\r\n			<input type=\"email\" name=\"auth[email]\" class=\"form-control\" placeholder=\"Email\" data-remember=\"\" required=\"\" autofocus=\"\">\r\n			<input type=\"password\" name=\"auth[pass]\" class=\"form-control\" placeholder=\"Password\" required=\"\">\r\n			<label class=\"checkbox\">\r\n				<input type=\"checkbox\" value=\"remember-me\"> Remember me\r\n			</label>\r\n			<button class=\"btn btn-lg btn-success btn-block\" type=\"submit\">[#3#]</button>\r\n			<a href=\"#recovery\" class=\"btn btn-lg btn-warning btn-block js_form\" type=\"submit\">Forgot password</a>\r\n			<a href=\"#register\" class=\"btn btn-lg btn-info btn-block js_form\" type=\"submit\">Register</a>\r\n		</form>\r\n		<form class=\"form-signin hide\" role=\"form\" id=\"register\" method=\"post\">\r\n			<h3 class=\"form-signin-heading\">Register</h3>\r\n			<p>All fields are required</p>\r\n			<input type=\"text\" name=\"reg[name]\" class=\"form-control\" placeholder=\"Your name?\" required=\"\" data-remember=\"\" autofocus=\"\" />\r\n			<input type=\"email\" name=\"reg[email]\" class=\"form-control\" placeholder=\"Email\" data-remember=\"\" required=\"\" />\r\n			<input type=\"text\" name=\"reg[phone]\" class=\"form-control\" placeholder=\"Phone\" data-remember=\"\" required=\"\" />\r\n			<input type=\"password\" name=\"reg[pass]\" class=\"form-control\" placeholder=\"Password\" required=\"\" />\r\n			<input type=\"password\" name=\"reg[cfm]\" class=\"form-control\" placeholder=\"Password one more time\" required=\"\" />\r\n			<br>\r\n			<button class=\"btn btn-lg btn-success btn-block\" type=\"submit\">Register</button>\r\n		</form>\r\n		<form class=\"hide\" role=\"form\" id=\"recovery\" method=\"post\">\r\n			<h3 class=\"form-signin-heading\">Password recovery</h3>\r\n			<input type=\"email\" name=\"recovery\" autocomplete=\"off\" class=\"form-control\" placeholder=\"Email\" required=\"\" autofocus=\"\">\r\n			<br>\r\n			<button class=\"btn btn-lg btn-success btn-block\" type=\"submit\">Recover password</button>\r\n		</form>\r\n	</div>\r\n	<script>\r\n		$(document).ready(function(){\r\n			$(\".js_form\").on(\"click\", function(){\r\n				$(this).parents(\"form\").addClass(\"hide\");\r\n				$($(this).attr(\"href\")).removeClass(\"hide\").slideDown();\r\n			})\r\n			if (window.location.hash != \"\")\r\n				$(\".js_form[href=\'\"+window.location.hash+\"\']\").trigger(\"click\");\r\n		});\r\n	</script>\r\n</div> <!-- /container -->\r\n{{FOOTER}}',	0);

CREATE TABLE `modx_site_tmplvars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `caption` varchar(80) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `editor_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
  `category` int(11) NOT NULL DEFAULT '0' COMMENT 'category id',
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `elements` text,
  `rank` int(11) NOT NULL DEFAULT '0',
  `display` varchar(20) NOT NULL DEFAULT '' COMMENT 'Display Control',
  `display_params` text COMMENT 'Display Control Properties',
  `default_text` text,
  PRIMARY KEY (`id`),
  KEY `indx_rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Site Template Variables';

INSERT INTO `modx_site_tmplvars` (`id`, `type`, `name`, `caption`, `description`, `editor_type`, `category`, `locked`, `elements`, `rank`, `display`, `display_params`, `default_text`) VALUES
(2,	'text',	'tv_seo_keywords',	'Keywords',	'',	0,	5,	0,	'',	0,	'',	'',	''),
(3,	'textarea',	'tv_seo_description',	'Description',	'',	0,	5,	0,	'',	0,	'',	'',	''),
(4,	'text',	'tv_seo_robots',	'Robots',	'',	0,	5,	0,	'',	0,	'',	'',	'noindex,nofollow'),
(5,	'text',	'tv_seo_canonical',	'Canonical',	'',	0,	5,	0,	'',	0,	'',	'',	''),
(8,	'text',	'tv_seo_title_en',	'SEO title',	'en',	0,	0,	0,	'',	0,	'',	'',	''),
(9,	'text',	'tv_weight_cat',	'category weight',	'',	0,	0,	0,	'',	0,	'',	'',	''),
(10,	'text',	'tv_coords',	'Coordinates',	'',	0,	0,	0,	'',	0,	'',	'',	'');

CREATE TABLE `modx_site_tmplvar_access` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tmplvarid` int(10) NOT NULL DEFAULT '0',
  `documentgroup` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for template variable access permissions.';


CREATE TABLE `modx_site_tmplvar_contentvalues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tmplvarid` int(10) NOT NULL DEFAULT '0' COMMENT 'Template Variable id',
  `contentid` int(10) NOT NULL DEFAULT '0' COMMENT 'Site Content Id',
  `value` text,
  PRIMARY KEY (`id`),
  KEY `idx_tmplvarid` (`tmplvarid`),
  KEY `idx_id` (`contentid`),
  FULLTEXT KEY `value_ft_idx` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Site Template Variables Content Values Link Table';

INSERT INTO `modx_site_tmplvar_contentvalues` (`id`, `tmplvarid`, `contentid`, `value`) VALUES
(1,	10,	24,	'37.794796,-122.394798'),
(2,	10,	25,	'37.787946,-122.441983'),
(3,	10,	26,	'37.78859,-122.420225'),
(4,	10,	27,	'37.78859,-122.420225');

CREATE TABLE `modx_site_tmplvar_templates` (
  `tmplvarid` int(10) NOT NULL DEFAULT '0' COMMENT 'Template Variable id',
  `templateid` int(11) NOT NULL DEFAULT '0',
  `rank` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tmplvarid`,`templateid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Site Template Variables Templates Link Table';

INSERT INTO `modx_site_tmplvar_templates` (`tmplvarid`, `templateid`, `rank`) VALUES
(2,	3,	0),
(3,	3,	0),
(4,	3,	0),
(5,	3,	0),
(8,	3,	0),
(9,	4,	0),
(10,	7,	0);

CREATE TABLE `modx_system_eventnames` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `service` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'System Service number',
  `groupname` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='System Event Names.';

INSERT INTO `modx_system_eventnames` (`id`, `name`, `service`, `groupname`) VALUES
(1,	'OnDocPublished',	5,	''),
(2,	'OnDocUnPublished',	5,	''),
(3,	'OnWebPagePrerender',	5,	''),
(4,	'OnWebLogin',	3,	''),
(5,	'OnBeforeWebLogout',	3,	''),
(6,	'OnWebLogout',	3,	''),
(7,	'OnWebSaveUser',	3,	''),
(8,	'OnWebDeleteUser',	3,	''),
(9,	'OnWebChangePassword',	3,	''),
(10,	'OnWebCreateGroup',	3,	''),
(11,	'OnManagerLogin',	2,	''),
(12,	'OnBeforeManagerLogout',	2,	''),
(13,	'OnManagerLogout',	2,	''),
(14,	'OnManagerSaveUser',	2,	''),
(15,	'OnManagerDeleteUser',	2,	''),
(16,	'OnManagerChangePassword',	2,	''),
(17,	'OnManagerCreateGroup',	2,	''),
(18,	'OnBeforeCacheUpdate',	4,	''),
(19,	'OnCacheUpdate',	4,	''),
(20,	'OnLoadWebPageCache',	4,	''),
(21,	'OnBeforeSaveWebPageCache',	4,	''),
(22,	'OnChunkFormPrerender',	1,	'Chunks'),
(23,	'OnChunkFormRender',	1,	'Chunks'),
(24,	'OnBeforeChunkFormSave',	1,	'Chunks'),
(25,	'OnChunkFormSave',	1,	'Chunks'),
(26,	'OnBeforeChunkFormDelete',	1,	'Chunks'),
(27,	'OnChunkFormDelete',	1,	'Chunks'),
(28,	'OnDocFormPrerender',	1,	'Documents'),
(29,	'OnDocFormRender',	1,	'Documents'),
(30,	'OnBeforeDocFormSave',	1,	'Documents'),
(31,	'OnDocFormSave',	1,	'Documents'),
(32,	'OnBeforeDocFormDelete',	1,	'Documents'),
(33,	'OnDocFormDelete',	1,	'Documents'),
(34,	'OnPluginFormPrerender',	1,	'Plugins'),
(35,	'OnPluginFormRender',	1,	'Plugins'),
(36,	'OnBeforePluginFormSave',	1,	'Plugins'),
(37,	'OnPluginFormSave',	1,	'Plugins'),
(38,	'OnBeforePluginFormDelete',	1,	'Plugins'),
(39,	'OnPluginFormDelete',	1,	'Plugins'),
(40,	'OnSnipFormPrerender',	1,	'Snippets'),
(41,	'OnSnipFormRender',	1,	'Snippets'),
(42,	'OnBeforeSnipFormSave',	1,	'Snippets'),
(43,	'OnSnipFormSave',	1,	'Snippets'),
(44,	'OnBeforeSnipFormDelete',	1,	'Snippets'),
(45,	'OnSnipFormDelete',	1,	'Snippets'),
(46,	'OnTempFormPrerender',	1,	'Templates'),
(47,	'OnTempFormRender',	1,	'Templates'),
(48,	'OnBeforeTempFormSave',	1,	'Templates'),
(49,	'OnTempFormSave',	1,	'Templates'),
(50,	'OnBeforeTempFormDelete',	1,	'Templates'),
(51,	'OnTempFormDelete',	1,	'Templates'),
(52,	'OnTVFormPrerender',	1,	'Template Variables'),
(53,	'OnTVFormRender',	1,	'Template Variables'),
(54,	'OnBeforeTVFormSave',	1,	'Template Variables'),
(55,	'OnTVFormSave',	1,	'Template Variables'),
(56,	'OnBeforeTVFormDelete',	1,	'Template Variables'),
(57,	'OnTVFormDelete',	1,	'Template Variables'),
(58,	'OnUserFormPrerender',	1,	'Users'),
(59,	'OnUserFormRender',	1,	'Users'),
(60,	'OnBeforeUserFormSave',	1,	'Users'),
(61,	'OnUserFormSave',	1,	'Users'),
(62,	'OnBeforeUserFormDelete',	1,	'Users'),
(63,	'OnUserFormDelete',	1,	'Users'),
(64,	'OnWUsrFormPrerender',	1,	'Web Users'),
(65,	'OnWUsrFormRender',	1,	'Web Users'),
(66,	'OnBeforeWUsrFormSave',	1,	'Web Users'),
(67,	'OnWUsrFormSave',	1,	'Web Users'),
(68,	'OnBeforeWUsrFormDelete',	1,	'Web Users'),
(69,	'OnWUsrFormDelete',	1,	'Web Users'),
(70,	'OnSiteRefresh',	1,	''),
(71,	'OnFileManagerUpload',	1,	''),
(72,	'OnModFormPrerender',	1,	'Modules'),
(73,	'OnModFormRender',	1,	'Modules'),
(74,	'OnBeforeModFormDelete',	1,	'Modules'),
(75,	'OnModFormDelete',	1,	'Modules'),
(76,	'OnBeforeModFormSave',	1,	'Modules'),
(77,	'OnModFormSave',	1,	'Modules'),
(78,	'OnBeforeWebLogin',	3,	''),
(79,	'OnWebAuthentication',	3,	''),
(80,	'OnBeforeManagerLogin',	2,	''),
(81,	'OnManagerAuthentication',	2,	''),
(82,	'OnSiteSettingsRender',	1,	'System Settings'),
(83,	'OnFriendlyURLSettingsRender',	1,	'System Settings'),
(84,	'OnUserSettingsRender',	1,	'System Settings'),
(85,	'OnInterfaceSettingsRender',	1,	'System Settings'),
(86,	'OnMiscSettingsRender',	1,	'System Settings'),
(87,	'OnRichTextEditorRegister',	1,	'RichText Editor'),
(88,	'OnRichTextEditorInit',	1,	'RichText Editor'),
(89,	'OnManagerPageInit',	2,	''),
(90,	'OnWebPageInit',	5,	''),
(101,	'OnLoadDocumentObject',	5,	''),
(91,	'OnLoadWebDocument',	5,	''),
(92,	'OnParseDocument',	5,	''),
(93,	'OnManagerLoginFormRender',	2,	''),
(94,	'OnWebPageComplete',	5,	''),
(95,	'OnLogPageHit',	5,	''),
(96,	'OnBeforeManagerPageInit',	2,	''),
(97,	'OnBeforeEmptyTrash',	1,	'Documents'),
(98,	'OnEmptyTrash',	1,	'Documents'),
(99,	'OnManagerLoginFormPrerender',	2,	''),
(100,	'OnStripAlias',	1,	'Documents'),
(200,	'OnCreateDocGroup',	1,	'Documents'),
(201,	'OnManagerWelcomePrerender',	2,	''),
(202,	'OnManagerWelcomeHome',	2,	''),
(203,	'OnManagerWelcomeRender',	2,	''),
(204,	'OnBeforeDocDuplicate',	1,	'Documents'),
(205,	'OnDocDuplicate',	1,	'Documents'),
(206,	'OnManagerMainFrameHeaderHTMLBlock',	2,	''),
(207,	'OnManagerPreFrameLoader',	2,	''),
(208,	'OnManagerFrameLoader',	2,	''),
(209,	'OnManagerTreeInit',	2,	''),
(210,	'OnManagerTreePrerender',	2,	''),
(211,	'OnManagerTreeRender',	2,	''),
(212,	'OnManagerNodePrerender',	2,	''),
(213,	'OnManagerNodeRender',	2,	''),
(999,	'OnPageUnauthorized',	1,	''),
(1000,	'OnPageNotFound',	1,	'');

CREATE TABLE `modx_system_settings` (
  `setting_name` varchar(50) NOT NULL DEFAULT '',
  `setting_value` text,
  PRIMARY KEY (`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains Content Manager settings.';

INSERT INTO `modx_system_settings` (`setting_name`, `setting_value`) VALUES
('manager_theme',	'MODxRE'),
('settings_version',	'1.0.12'),
('show_meta',	'0'),
('server_offset_time',	'0'),
('server_protocol',	'http'),
('manager_language',	'english'),
('modx_charset',	'UTF-8'),
('site_name',	'foodelivery'),
('site_start',	'1'),
('error_page',	'2'),
('unauthorized_page',	'3'),
('site_status',	'1'),
('site_unavailable_message',	'<h1>This is server side admin panel only!</h1>\r\n<p>Log in <a href=\"/manager/\">admin panel</a></p>\r\n'),
('track_visitors',	'0'),
('top_howmany',	'10'),
('auto_template_logic',	'sibling'),
('default_template',	'3'),
('old_template',	'3'),
('publish_default',	'1'),
('cache_default',	'0'),
('search_default',	'1'),
('friendly_urls',	'1'),
('friendly_url_prefix',	''),
('friendly_url_suffix',	'/'),
('friendly_alias_urls',	'1'),
('use_alias_path',	'1'),
('use_udperms',	'1'),
('udperms_allowroot',	'0'),
('failed_login_attempts',	'300'),
('blocked_minutes',	'60'),
('use_captcha',	'0'),
('captcha_words',	'MODX,Access,Better,BitCode,Cache,Desc,Design,Excell,Enjoy,URLs,TechView,Gerald,Griff,Humphrey,Holiday,Intel,Integration,Joystick,Join(),Tattoo,Genetic,Light,Likeness,Marit,Maaike,Niche,Netherlands,Ordinance,Oscillo,Parser,Phusion,Query,Question,Regalia,Righteous,Snippet,Sentinel,Template,Thespian,Unity,Enterprise,Verily,Veri,Website,WideWeb,Yap,Yellow,Zebra,Zygote'),
('emailsender',	''),
('email_method',	'smtp'),
('smtp_auth',	'1'),
('smtp_host',	''),
('smtp_port',	''),
('smtp_username',	''),
('emailsubject',	'Your login details'),
('number_of_logs',	'100'),
('number_of_messages',	'30'),
('number_of_results',	'20'),
('use_editor',	'1'),
('use_browser',	'1'),
('rb_base_dir',	'/var/www/food/assets/'),
('rb_base_url',	'assets/'),
('which_editor',	'TinyMCE'),
('fe_editor_lang',	'russian-UTF8'),
('fck_editor_toolbar',	'standard'),
('fck_editor_autolang',	'0'),
('editor_css_path',	''),
('editor_css_selectors',	''),
('strip_image_paths',	'1'),
('upload_images',	'bmp,ico,gif,jpeg,jpg,png,psd,tif,tiff'),
('upload_media',	'au,avi,mp3,mp4,mpeg,mpg,wav,wmv'),
('upload_flash',	'fla,flv,swf'),
('upload_files',	'aac,au,avi,css,cache,doc,docx,gz,gzip,htaccess,htm,html,js,mp3,mp4,mpeg,mpg,ods,odp,odt,pdf,ppt,pptx,rar,tar,tgz,txt,wav,wmv,xls,xlsx,xml,z,zip'),
('upload_maxsize',	'1048576'),
('new_file_permissions',	'0644'),
('new_folder_permissions',	'0755'),
('filemanager_path',	'/var/www/food/'),
('theme_refresher',	''),
('manager_layout',	'4'),
('custom_contenttype',	'application/rss+xml,application/pdf,application/vnd.ms-word,application/vnd.ms-excel,text/html,text/css,text/xml,text/javascript,text/plain,application/json'),
('auto_menuindex',	'1'),
('session.cookie.lifetime',	'604800'),
('mail_check_timeperiod',	'60'),
('manager_direction',	'ltr'),
('tinymce_editor_theme',	'editor'),
('tinymce_custom_plugins',	'style,advimage,advlink,searchreplace,print,contextmenu,paste,fullscreen,nonbreaking,xhtmlxtras,visualchars,media'),
('tinymce_custom_buttons1',	'undo,redo,selectall,separator,pastetext,pasteword,separator,search,replace,separator,nonbreaking,hr,charmap,separator,image,link,unlink,anchor,media,separator,cleanup,removeformat,separator,fullscreen,print,code,help'),
('tinymce_custom_buttons2',	'bold,italic,underline,strikethrough,sub,sup,separator,bullist,numlist,outdent,indent,separator,justifyleft,justifycenter,justifyright,justifyfull,separator,styleselect,formatselect,separator,styleprops'),
('tree_show_protected',	'0'),
('rss_url_news',	'http://feeds.feedburner.com/modx-announce'),
('rss_url_security',	'http://feeds.feedburner.com/modxsecurity'),
('validate_referer',	'0'),
('datepicker_offset',	'-10'),
('xhtml_urls',	'1'),
('allow_duplicate_alias',	'0'),
('automatic_alias',	'1'),
('datetime_format',	'dd-mm-YYYY'),
('warning_visibility',	'1'),
('remember_last_tab',	'1'),
('enable_bindings',	'0'),
('seostrict',	'0'),
('cache_type',	'2'),
('maxImageWidth',	'1600'),
('maxImageHeight',	'1200'),
('thumbWidth',	'150'),
('thumbHeight',	'150'),
('thumbsDir',	'.thumbs'),
('jpegQuality',	'90'),
('denyZipDownload',	'0'),
('denyExtensionRename',	'0'),
('showHiddenFiles',	'0'),
('docid_incrmnt_method',	'0'),
('make_folders',	'0'),
('site_id',	'52a422b7dbe7e'),
('site_unavailable_page',	''),
('reload_site_unavailable',	''),
('siteunavailable_message_default',	'The site is currently unavailable.'),
('check_files_onlogin',	'index.php\r\n.htaccess\r\nmanager/index.php\r\nmanager/includes/config.inc.php'),
('error_reporting',	'1'),
('send_errormail',	'0'),
('pwd_hash_algo',	'UNCRYPT'),
('reload_captcha_words',	''),
('captcha_words_default',	'MODX,Access,Better,BitCode,Chunk,Cache,Desc,Design,Excell,Enjoy,URLs,TechView,Gerald,Griff,Humphrey,Holiday,Intel,Integration,Joystick,Join(),Oscope,Genetic,Light,Likeness,Marit,Maaike,Niche,Netherlands,Ordinance,Oscillo,Parser,Phusion,Query,Question,Regalia,Righteous,Snippet,Sentinel,Template,Thespian,Unity,Enterprise,Verily,Tattoo,Veri,Website,WideWeb,Yap,Yellow,Zebra,Zygote'),
('reload_emailsubject',	''),
('emailsubject_default',	'Your login details'),
('reload_signupemail_message',	''),
('signupemail_message',	'Здравствуйте, [+uid+]!\r\n\r\nВаши данные для авторизации в системе управления сайтом [+sname+]:\r\n\r\nИмя пользователя: [+uid+]\r\nПароль: [+pwd+]\r\n\r\nПосле успешной авторизации в системе управления сайтом ([+surl+]), вы сможете изменить свой пароль.\r\n\r\nС уважением, Администрация'),
('system_email_signup_default',	'Hello [+uid+] \r\n\r\nHere are your login details for [+sname+] Content Manager:\r\n\r\nUsername: [+uid+]\r\nPassword: [+pwd+]\r\n\r\nOnce you log into the Content Manager ([+surl+]), you can change your password.\r\n\r\nRegards,\r\nSite Administrator'),
('shop_hotline_filename',	'hotline.xml'),
('shop_hotline_lang',	'ru'),
('shop_pn_filename',	'pn.xml'),
('shop_pn_lang',	'ru'),
('reload_websignupemail_message',	''),
('websignupemail_message',	'Здравствуйте, [+uid+]!\r\n\r\nВаши данные для авторизации на [+sname+]:\r\n\r\nИмя пользователя: [+uid+]\r\nПароль: [+pwd+]\r\n\r\nПосле успешной авторизации на [+sname+] ([+surl+]), вы сможете изменить свой пароль.\r\n\r\nС уважением, Администрация'),
('system_email_websignup_default',	'Hello [+uid+]\r\n\r\nHere are your login details for [+sname+]:\r\n\r\nUsername: [+uid+]\r\nPassword: [+pwd+]\r\n\r\nOnce you log into [+sname+] ([+surl+]), you can change your password.\r\n\r\nRegards,\r\nSite Administrator'),
('mailer_smtp_limit',	'1'),
('reload_system_email_webreminder_message',	''),
('webpwdreminder_message',	'Здравствуйте, [+uid+]!\r\n\r\nЧтобы активировать ваш новый пароль, перейдите по следующей ссылке:\r\n\r\n[+surl+]\r\n\r\nПозже вы сможете использовать следующий пароль для авторизации: [+pwd+]\r\n\r\nЕсли это письмо пришло к вам по ошибке, пожалуйста, проигнорируйте его.\r\n\r\nС уважением, Администрация'),
('system_email_webreminder_default',	'Hello [+uid+]\r\n\r\nTo activate your new password click the following link:\r\n\r\n[+surl+]\r\n\r\nIf successful you can use the following password to login:\r\n\r\nPassword:[+pwd+]\r\n\r\nIf you did not request this email then please ignore it.\r\n\r\nRegards,\r\nSite Administrator'),
('',	'0'),
('mailer_smtp_server',	''),
('mailer_smtp_port',	''),
('mailer_smtp_login',	''),
('mailer_smtp_pass',	''),
('mailer_smtp_name',	''),
('tree_page_click',	'27'),
('resource_tree_node_name',	'pagetitle'),
('rb_webuser',	'0'),
('clean_uploaded_filename',	'1'),
('mce_editor_skin',	'default'),
('mce_template_docs',	''),
('mce_template_chunks',	''),
('mce_entermode',	'p'),
('mce_element_format',	'xhtml'),
('mce_schema',	'html4'),
('tinymce_custom_buttons3',	''),
('tinymce_custom_buttons4',	''),
('tinymce_css_selectors',	'left=justifyleft;right=justifyright'),
('sys_files_checksum',	'a:4:{s:23:\"/var/www/food/index.php\";s:32:\"0c2fe8e7f3c57346371cd577d0933492\";s:23:\"/var/www/food/.htaccess\";s:32:\"6d3434a034164ca5a7e5a56086cc48b1\";s:31:\"/var/www/food/manager/index.php\";s:32:\"6bf6af1f3481d75a3a30ae16044ee056\";s:45:\"/var/www/food/manager/includes/config.inc.php\";s:32:\"9513887d594a898b329e08989004d6ed\";}'),
('shop_curr_rate',	'12|0.3|1|16'),
('shop_curr_sign',	'₴|rub.|$|€'),
('shop_curr_name',	'Ukrainian hryvna|Russian ruble|US Dollar|Euro'),
('shop_curr_active',	'0|0|1|0'),
('shop_curr_default_sign',	'$'),
('shop_mail_tpl_meta',	'<meta>'),
('shop_mail_tpl_reg',	'	reg'),
('shop_mail_tpl_recovery',	'recovery	'),
('shop_mail_tpl_order_meta',	'create'),
('shop_mail_tpl_order_item',	''),
('shop_mail_tpl_order_status',	'status'),
('shop_liqpay_mid',	''),
('shop_liqpay_sig',	''),
('shop_curr_default_code',	'usd'),
('shop_curr_code',	'uah|rur|usd|eur|'),
('shop_page_item',	'4'),
('shop_tpl_category',	'4'),
('shop_liqpay_percent',	'shop'),
('shop_catalog_root',	'5'),
('lang_list',	'en'),
('lang_default',	'en'),
('shop_rc_pukey',	''),
('shop_rc_prkey',	''),
('smtppw',	'bYvaRAB'),
('shop_import_dir',	'assets/import/'),
('shop_import_step',	'0'),
('shop_export_filename',	'export.xml'),
('shop_export_period',	'4'),
('shop_import_filename',	'import.xml'),
('shop_export_dir',	'assets/export/'),
('shop_import_img_dir_from',	'assets/import/images/'),
('shop_import_img_dir_to',	'assets/images/items/'),
('lang_enable',	'1'),
('shop_privat24_mid',	''),
('shop_privat24_sig',	'');

CREATE TABLE `modx_user_attributes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `internalKey` int(10) NOT NULL DEFAULT '0',
  `fullname` varchar(100) NOT NULL DEFAULT '',
  `role` int(10) NOT NULL DEFAULT '0',
  `email` varchar(100) NOT NULL DEFAULT '',
  `phone` varchar(100) NOT NULL DEFAULT '',
  `mobilephone` varchar(100) NOT NULL DEFAULT '',
  `blocked` int(1) NOT NULL DEFAULT '0',
  `blockeduntil` int(11) NOT NULL DEFAULT '0',
  `blockedafter` int(11) NOT NULL DEFAULT '0',
  `logincount` int(11) NOT NULL DEFAULT '0',
  `lastlogin` int(11) NOT NULL DEFAULT '0',
  `thislogin` int(11) NOT NULL DEFAULT '0',
  `failedlogincount` int(10) NOT NULL DEFAULT '0',
  `sessionid` varchar(100) NOT NULL DEFAULT '',
  `dob` int(10) NOT NULL DEFAULT '0',
  `gender` int(1) NOT NULL DEFAULT '0' COMMENT '0 - unknown, 1 - Male 2 - female',
  `country` varchar(5) NOT NULL DEFAULT '',
  `street` varchar(255) NOT NULL DEFAULT '',
  `city` varchar(255) NOT NULL DEFAULT '',
  `state` varchar(25) NOT NULL DEFAULT '',
  `zip` varchar(25) NOT NULL DEFAULT '',
  `fax` varchar(100) NOT NULL DEFAULT '',
  `photo` varchar(255) NOT NULL DEFAULT '' COMMENT 'link to photo',
  `comment` text,
  PRIMARY KEY (`id`),
  KEY `userid` (`internalKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains information about the backend users.';

INSERT INTO `modx_user_attributes` (`id`, `internalKey`, `fullname`, `role`, `email`, `phone`, `mobilephone`, `blocked`, `blockeduntil`, `blockedafter`, `logincount`, `lastlogin`, `thislogin`, `failedlogincount`, `sessionid`, `dob`, `gender`, `country`, `street`, `city`, `state`, `zip`, `fax`, `photo`, `comment`) VALUES
(1,	1,	'Default admin account',	1,	'admin@gma1il.com',	'',	'',	0,	0,	0,	30,	1417004487,	1419340324,	0,	'lt9mqaokanlp2ed2ejf1nqiig4',	0,	0,	'',	'',	'',	'',	'',	'',	'',	''),
(2,	2,	'',	3,	'demo@demo.com',	'',	'',	0,	0,	0,	57,	1406752900,	1406790205,	0,	'9220c815c860bc2c372eb7c08a565215',	0,	0,	'',	'',	'',	'',	'',	'',	'',	'');

CREATE TABLE `modx_user_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(15) NOT NULL DEFAULT '',
  `subject` varchar(60) NOT NULL DEFAULT '',
  `message` text,
  `sender` int(10) NOT NULL DEFAULT '0',
  `recipient` int(10) NOT NULL DEFAULT '0',
  `private` tinyint(4) NOT NULL DEFAULT '0',
  `postdate` int(20) NOT NULL DEFAULT '0',
  `messageread` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains messages for the Content Manager messaging system.';


CREATE TABLE `modx_user_roles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `frames` int(1) NOT NULL DEFAULT '0',
  `home` int(1) NOT NULL DEFAULT '0',
  `view_document` int(1) NOT NULL DEFAULT '0',
  `new_document` int(1) NOT NULL DEFAULT '0',
  `save_document` int(1) NOT NULL DEFAULT '0',
  `publish_document` int(1) NOT NULL DEFAULT '0',
  `delete_document` int(1) NOT NULL DEFAULT '0',
  `empty_trash` int(1) NOT NULL DEFAULT '0',
  `action_ok` int(1) NOT NULL DEFAULT '0',
  `logout` int(1) NOT NULL DEFAULT '0',
  `help` int(1) NOT NULL DEFAULT '0',
  `messages` int(1) NOT NULL DEFAULT '0',
  `new_user` int(1) NOT NULL DEFAULT '0',
  `edit_user` int(1) NOT NULL DEFAULT '0',
  `logs` int(1) NOT NULL DEFAULT '0',
  `edit_parser` int(1) NOT NULL DEFAULT '0',
  `save_parser` int(1) NOT NULL DEFAULT '0',
  `edit_template` int(1) NOT NULL DEFAULT '0',
  `settings` int(1) NOT NULL DEFAULT '0',
  `credits` int(1) NOT NULL DEFAULT '0',
  `new_template` int(1) NOT NULL DEFAULT '0',
  `save_template` int(1) NOT NULL DEFAULT '0',
  `delete_template` int(1) NOT NULL DEFAULT '0',
  `edit_snippet` int(1) NOT NULL DEFAULT '0',
  `new_snippet` int(1) NOT NULL DEFAULT '0',
  `save_snippet` int(1) NOT NULL DEFAULT '0',
  `delete_snippet` int(1) NOT NULL DEFAULT '0',
  `edit_chunk` int(1) NOT NULL DEFAULT '0',
  `new_chunk` int(1) NOT NULL DEFAULT '0',
  `save_chunk` int(1) NOT NULL DEFAULT '0',
  `delete_chunk` int(1) NOT NULL DEFAULT '0',
  `empty_cache` int(1) NOT NULL DEFAULT '0',
  `edit_document` int(1) NOT NULL DEFAULT '0',
  `change_password` int(1) NOT NULL DEFAULT '0',
  `error_dialog` int(1) NOT NULL DEFAULT '0',
  `about` int(1) NOT NULL DEFAULT '0',
  `file_manager` int(1) NOT NULL DEFAULT '0',
  `save_user` int(1) NOT NULL DEFAULT '0',
  `delete_user` int(1) NOT NULL DEFAULT '0',
  `save_password` int(11) NOT NULL DEFAULT '0',
  `edit_role` int(1) NOT NULL DEFAULT '0',
  `save_role` int(1) NOT NULL DEFAULT '0',
  `delete_role` int(1) NOT NULL DEFAULT '0',
  `new_role` int(1) NOT NULL DEFAULT '0',
  `access_permissions` int(1) NOT NULL DEFAULT '0',
  `bk_manager` int(1) NOT NULL DEFAULT '0',
  `new_plugin` int(1) NOT NULL DEFAULT '0',
  `edit_plugin` int(1) NOT NULL DEFAULT '0',
  `save_plugin` int(1) NOT NULL DEFAULT '0',
  `delete_plugin` int(1) NOT NULL DEFAULT '0',
  `new_module` int(1) NOT NULL DEFAULT '0',
  `edit_module` int(1) NOT NULL DEFAULT '0',
  `save_module` int(1) NOT NULL DEFAULT '0',
  `delete_module` int(1) NOT NULL DEFAULT '0',
  `exec_module` int(1) NOT NULL DEFAULT '0',
  `view_eventlog` int(1) NOT NULL DEFAULT '0',
  `delete_eventlog` int(1) NOT NULL DEFAULT '0',
  `manage_metatags` int(1) NOT NULL DEFAULT '0' COMMENT 'manage site meta tags and keywords',
  `edit_doc_metatags` int(1) NOT NULL DEFAULT '0' COMMENT 'edit document meta tags and keywords',
  `new_web_user` int(1) NOT NULL DEFAULT '0',
  `edit_web_user` int(1) NOT NULL DEFAULT '0',
  `save_web_user` int(1) NOT NULL DEFAULT '0',
  `delete_web_user` int(1) NOT NULL DEFAULT '0',
  `web_access_permissions` int(1) NOT NULL DEFAULT '0',
  `view_unpublished` int(1) NOT NULL DEFAULT '0',
  `import_static` int(1) NOT NULL DEFAULT '0',
  `export_static` int(1) NOT NULL DEFAULT '0',
  `remove_locks` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains information describing the user roles.';

INSERT INTO `modx_user_roles` (`id`, `name`, `description`, `frames`, `home`, `view_document`, `new_document`, `save_document`, `publish_document`, `delete_document`, `empty_trash`, `action_ok`, `logout`, `help`, `messages`, `new_user`, `edit_user`, `logs`, `edit_parser`, `save_parser`, `edit_template`, `settings`, `credits`, `new_template`, `save_template`, `delete_template`, `edit_snippet`, `new_snippet`, `save_snippet`, `delete_snippet`, `edit_chunk`, `new_chunk`, `save_chunk`, `delete_chunk`, `empty_cache`, `edit_document`, `change_password`, `error_dialog`, `about`, `file_manager`, `save_user`, `delete_user`, `save_password`, `edit_role`, `save_role`, `delete_role`, `new_role`, `access_permissions`, `bk_manager`, `new_plugin`, `edit_plugin`, `save_plugin`, `delete_plugin`, `new_module`, `edit_module`, `save_module`, `delete_module`, `exec_module`, `view_eventlog`, `delete_eventlog`, `manage_metatags`, `edit_doc_metatags`, `new_web_user`, `edit_web_user`, `save_web_user`, `delete_web_user`, `web_access_permissions`, `view_unpublished`, `import_static`, `export_static`, `remove_locks`) VALUES
(3,	'Demo',	'',	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0,	0,	0,	0,	0,	0,	0,	1,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	1,	1,	1,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	1,	1,	1,	1,	0,	1,	0,	0,	1),
(1,	'Administrator',	'Site administrators have full access to all functions',	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1);

CREATE TABLE `modx_user_settings` (
  `user` int(11) NOT NULL,
  `setting_name` varchar(50) NOT NULL DEFAULT '',
  `setting_value` text,
  PRIMARY KEY (`user`,`setting_name`),
  KEY `setting_name` (`setting_name`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains backend user settings.';

INSERT INTO `modx_user_settings` (`user`, `setting_name`, `setting_value`) VALUES
(1,	'allow_manager_access',	'1'),
(1,	'which_editor',	'none'),
(2,	'allow_manager_access',	'1');

CREATE TABLE `modx_webgroup_access` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `webgroup` int(10) NOT NULL DEFAULT '0',
  `documentgroup` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for web access permissions.';


CREATE TABLE `modx_webgroup_names` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for web access permissions.';


CREATE TABLE `modx_web_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `webgroup` int(10) NOT NULL DEFAULT '0',
  `webuser` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_group_user` (`webgroup`,`webuser`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data used for web access permissions.';

INSERT INTO `modx_web_groups` (`id`, `webgroup`, `webuser`) VALUES
(5,	1,	5),
(53,	1,	55),
(19,	1,	21),
(4,	1,	4),
(17,	1,	19),
(24,	1,	26),
(52,	1,	54),
(66,	1,	68),
(37,	1,	39),
(54,	1,	56),
(55,	1,	57),
(56,	1,	58),
(57,	1,	59),
(58,	1,	60),
(59,	1,	61),
(60,	1,	62),
(61,	1,	63),
(62,	1,	64),
(63,	1,	65),
(64,	1,	66),
(65,	1,	67),
(67,	1,	69);




CREATE TABLE `modx_web_user_attributes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `internalKey` int(10) NOT NULL DEFAULT '0',
  `fullname` varchar(100) NOT NULL DEFAULT '',
  `role` int(10) NOT NULL DEFAULT '0',
  `email` varchar(100) NOT NULL DEFAULT '',
  `phone` varchar(100) NOT NULL DEFAULT '',
  `blocked` int(1) NOT NULL DEFAULT '0',
  `blockeduntil` int(11) NOT NULL DEFAULT '0',
  `blockedafter` int(11) NOT NULL DEFAULT '0',
  `logincount` int(11) NOT NULL DEFAULT '0',
  `lastlogin` int(11) NOT NULL DEFAULT '0',
  `thislogin` int(11) NOT NULL DEFAULT '0',
  `failedlogincount` int(10) NOT NULL DEFAULT '0',
  `sessionid` varchar(100) NOT NULL DEFAULT '',
  `delivery` tinyint(4) NOT NULL DEFAULT '0',
  `addr` text NOT NULL,
  `dob` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`internalKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains information for web users.';

CREATE TABLE `modx_web_user_settings` (
  `webuser` int(11) NOT NULL,
  `setting_name` varchar(50) NOT NULL DEFAULT '',
  `setting_value` text,
  PRIMARY KEY (`webuser`,`setting_name`),
  KEY `setting_name` (`setting_name`),
  KEY `webuserid` (`webuser`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains web user settings.';

INSERT INTO `modx_web_user_settings` (`webuser`, `setting_name`, `setting_value`) VALUES
(9,	'login_home',	'9'),
(9,	'allowed_days',	'1,2,3,4,5,6,7'),
(11,	'login_home',	'3'),
(11,	'allowed_ip',	'3'),
(11,	'allowed_days',	'1,3,4');

-- 2014-12-23 14:28:24
