SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- Database: `arastta162`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]addon`
CREATE TABLE `[[dbprefix]]addon` (
`addon_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`product_name` varchar(255) NOT NULL,
`product_type` varchar(32) NOT NULL,
`product_version` varchar(32) NOT NULL DEFAULT '1.0.0',
PRIMARY KEY (`addon_id`),
KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
-- Dumping data for table `[[dbprefix]]addon`
INSERT INTO `[[dbprefix]]addon` VALUES
(1, 0, 'Cart', 'module', '1.0.0', '["admin\\/controller\\\\module\\\\cart.php","catalog\\/controller\\\\module\\\\cart.php","admin\\/language\\\\en-GB\\\\module\\\\cart.php","catalog\\/language\\\\en-GB\\\\module\\\\cart.php","admin\\/view\\\\template\\\\module\\\\cart.tpl","catalog\\/view\\\\theme\\\\default\\\\template\\\\module\\\\cart.tpl"]', '{"theme_ids":[],"extension_ids":[444]}'),
(2, 0, 'Summernote', 'editor', '1.0.0', '["admin\\/controller\\\\editor\\\\summernote.php","admin\\/language\\\\en-GB\\\\editor\\\\summernote.php","admin\\/view\\\\template\\\\editor\\\\summernote.tpl"]', '{"theme_ids":[],"extension_ids":[445]}'),
(3, 0, 'Tinymce', 'editor', '1.0.0', '["admin\\/controller\\\\editor\\\\tinymce.php","admin\\/language\\\\en-GB\\\\editor\\\\tinymce.php","admin\\/view\\\\template\\\\editor\\\\tinymce.tpl"]', '{"theme_ids":[],"extension_ids":[446]}'),
(4, 0, 'Products', 'module', '1.0.0', '["admin\\controller\\module\\products.php","admin\\language\\en-GB\\module\\products.php","admin\\view\\template\\module\\products.tpl","catalog\\controller\\module\\products.php","catalog\\language\\en-GB\\module\\products.php","catalog\\view\\theme\\default\\template\\module\\products.tpl","catalog\\view\\theme\\second\\template\\module\\products.tpl"]', '{"theme_ids":[],"extension_ids":[447]}'),
(5, 0, 'Google Analytics', 'analytics', '1.0.0', '["admin/controller\\analytics\\google.php","admin/language\\en-GB\\analytics\\google.php","admin/view\\template\\analytics\\google.tpl"]', '{"theme_ids":[],"extension_ids":[448]}'),
(6, 0, 'Woopra', 'analytics', '1.0.0', '["admin/controller\\analytics\\woopra.php","admin/language\\en-GB\\analytics\\woopra.php","admin/view\\template\\analytics\\woopra.tpl"]', '{"theme_ids":[],"extension_ids":[449]}'),
(7, 0, 'Maxmind', 'antifraud', '1.0.0', '["admin/controller\\antifraud\\maxmind.php","admin/language\\en-GB\\antifraud\\maxmind.php","catalog/model\\antifraud\\maxmind.php","admin/view\\template\\antifraud\\maxmind.tpl"]', '{"theme_ids":[],"extension_ids":[450]}'),
(8, 0, 'Basic', 'captcha', '1.0.0', '["admin/controller\\captcha\\basic.php","catalog/controller\\captcha\\basic.php","admin/language\\en-GB\\captcha\\basic.php","admin/view\\template\\captcha\\basic.tpl","catalog/view\\theme\\default\\template\\captcha\\basic.tpl"]', '{"theme_ids":[],"extension_ids":[451]}'),
(9, 0, 'Google Captcha', 'captcha', '1.0.0', '["admin/controller\\captcha\\google.php","catalog/controller\\captcha\\google.php","admin/language\\en-GB\\captcha\\google.php","admin/view\\template\\captcha\\google.tpl","catalog/view\\theme\\default\\template\\captcha\\google.tpl"]', '{"theme_ids":[],"extension_ids":[452]}'),
(10, 225, 'English', 'translation', '', '', '{"language_id":1,"theme_ids":[],"extension_ids":[]}');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]address`
CREATE TABLE `[[dbprefix]]address` (
`address_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`company` varchar(40) NOT NULL,
`address_1` varchar(128) NOT NULL,
`address_2` varchar(128) NOT NULL,
`city` varchar(128) NOT NULL,
`postcode` varchar(10) NOT NULL,
`country_id` int(11) NOT NULL DEFAULT '0',
`zone_id` int(11) NOT NULL DEFAULT '0',
`custom_field` text NOT NULL,
PRIMARY KEY (`address_id`),
KEY `customer_id` (`customer_id`),
KEY `country_id` (`country_id`),
KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]affiliate`
CREATE TABLE `[[dbprefix]]affiliate` (
`affiliate_id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(96) NOT NULL,
`telephone` varchar(32) NOT NULL,
`fax` varchar(32) NOT NULL,
`password` varchar(40) NOT NULL,
`salt` varchar(9) NOT NULL,
`company` varchar(40) NOT NULL,
`website` varchar(255) NOT NULL,
`address_1` varchar(128) NOT NULL,
`address_2` varchar(128) NOT NULL,
`city` varchar(128) NOT NULL,
`postcode` varchar(10) NOT NULL,
`country_id` int(11) NOT NULL,
`zone_id` int(11) NOT NULL,
`code` varchar(64) NOT NULL,
`commission` decimal(4,2) NOT NULL DEFAULT '0.00',
`tax` varchar(64) NOT NULL,
`payment` varchar(6) NOT NULL,
`cheque` varchar(100) NOT NULL,
`paypal` varchar(64) NOT NULL,
`bank_name` varchar(64) NOT NULL,
`bank_branch_number` varchar(64) NOT NULL,
`bank_swift_code` varchar(64) NOT NULL,
`bank_account_name` varchar(64) NOT NULL,
`bank_account_number` varchar(64) NOT NULL,
`ip` varchar(40) NOT NULL,
`status` tinyint(1) NOT NULL,
`approved` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`affiliate_id`),
KEY `country_id` (`country_id`),
KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]affiliate_activity`
CREATE TABLE `[[dbprefix]]affiliate_activity` (
`activity_id` int(11) NOT NULL AUTO_INCREMENT,
`affiliate_id` int(11) NOT NULL,
`key` varchar(64) NOT NULL,
`ip` varchar(40) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`activity_id`),
KEY `affiliate_id` (`affiliate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]affiliate_commission`
CREATE TABLE `[[dbprefix]]affiliate_commission` (
`affiliate_commission_id` int(11) NOT NULL AUTO_INCREMENT,
`affiliate_id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`description` text NOT NULL,
`amount` decimal(15,4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`affiliate_commission_id`),
KEY `affiliate_id` (`affiliate_id`),
KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]affiliate_login`
CREATE TABLE `[[dbprefix]]affiliate_login` (
`affiliate_login_id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(96) NOT NULL,
`ip` varchar(40) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
PRIMARY KEY (`affiliate_login_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]api`
CREATE TABLE `[[dbprefix]]api` (
`api_id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL,
`firstname` varchar(64) NOT NULL,
`lastname` varchar(64) NOT NULL,
`password` text NOT NULL,
`status` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `[[dbprefix]]api`
INSERT INTO `[[dbprefix]]api` VALUES
(1, '[[hashusername]]', '', '', '[[hashpassword]]', 1, '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]attribute`
CREATE TABLE `[[dbprefix]]attribute` (
`attribute_id` int(11) NOT NULL AUTO_INCREMENT,
`attribute_group_id` int(11) NOT NULL,
`sort_order` int(3) NOT NULL,
PRIMARY KEY (`attribute_id`),
KEY `attribute_group_id` (`attribute_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
-- Dumping data for table `[[dbprefix]]attribute`
INSERT INTO `[[dbprefix]]attribute` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]attribute_description`
CREATE TABLE `[[dbprefix]]attribute_description` (
`attribute_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`attribute_id`,`language_id`),
KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]attribute_description`
INSERT INTO `[[dbprefix]]attribute_description` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]attribute_group`
CREATE TABLE `[[dbprefix]]attribute_group` (
`attribute_group_id` int(11) NOT NULL AUTO_INCREMENT,
`sort_order` int(3) NOT NULL,
PRIMARY KEY (`attribute_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
-- Dumping data for table `[[dbprefix]]attribute_group`
INSERT INTO `[[dbprefix]]attribute_group` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]attribute_group_description`
CREATE TABLE `[[dbprefix]]attribute_group_description` (
`attribute_group_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`attribute_group_id`,`language_id`),
KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]attribute_group_description`
INSERT INTO `[[dbprefix]]attribute_group_description` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]banner`
CREATE TABLE `[[dbprefix]]banner` (
`banner_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`status` tinyint(1) NOT NULL,
PRIMARY KEY (`banner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- Dumping data for table `[[dbprefix]]banner`
INSERT INTO `[[dbprefix]]banner` VALUES
(7, 'Home Page Slideshow', 1),
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]banner_image`
CREATE TABLE `[[dbprefix]]banner_image` (
`banner_image_id` int(11) NOT NULL AUTO_INCREMENT,
`banner_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`title` varchar(64) NOT NULL,
`link` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`sort_order` int(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`banner_image_id`),
KEY `banner_id` (`banner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=120 ;
-- Dumping data for table `[[dbprefix]]banner_image`
INSERT INTO `[[dbprefix]]banner_image` VALUES
(108, 8, 1, 'BellField', '', 'catalog/demo/manufacturer/bellfield.jpg', 0),
(109, 8, 1, 'BONDS', '', 'catalog/demo/manufacturer/bonds.jpg', 0),
(110, 8, 1, 'EDWIN', '', 'catalog/demo/manufacturer/edwin.jpg', 0),
(111, 8, 1, 'Minimum', '', 'catalog/demo/manufacturer/minimum.jpg', 0),
(112, 8, 1, 'OBEY', '', 'catalog/demo/manufacturer/obey.jpg', 0),
(113, 8, 1, 'SKAGEN', '', 'catalog/demo/manufacturer/skagen.jpg', 0),
(114, 8, 1, 'Spiral', '', 'catalog/demo/manufacturer/spiral.jpg', 0),
(115, 8, 1, 'SUPRA', '', 'catalog/demo/manufacturer/supra.jpg', 0),
(116, 8, 1, 'Timberland', '', 'catalog/demo/manufacturer/timberland.jpg', 0),
(117, 8, 1, 'Wrangler', '', 'catalog/demo/manufacturer/wrangler.jpg', 0),
(118, 7, 1, 'Slide 1', 'index.php?route=product/product&path=18_46&product_id=47', 'catalog/demo/banners/slide-1.jpg', 0),
(119, 7, 1, 'Slide 2', 'index.php?route=product/product&path=34&product_id=48', 'catalog/demo/banners/slide-2.jpg', 0);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_category`
CREATE TABLE `[[dbprefix]]blog_category` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`image` varchar(255) DEFAULT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`top` tinyint(1) NOT NULL,
`sort_order` int(3) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '1',
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`category_id`),
KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `[[dbprefix]]blog_category`
INSERT INTO `[[dbprefix]]blog_category` VALUES
(1, '', 0, 0, 0, 1, '2017-04-06 14:06:13', '0000-00-00 00:00:00');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_category_description`
CREATE TABLE `[[dbprefix]]blog_category_description` (
`category_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`meta_title` varchar(255) NOT NULL,
`meta_description` varchar(255) NOT NULL,
`meta_keyword` varchar(255) NOT NULL,
PRIMARY KEY (`category_id`,`language_id`),
KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]blog_category_description`
INSERT INTO `[[dbprefix]]blog_category_description` VALUES
(1, 1, 'General', '', 'General', '', '');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_category_path`
CREATE TABLE `[[dbprefix]]blog_category_path` (
`category_id` int(11) NOT NULL,
`path_id` int(11) NOT NULL,
`level` int(11) NOT NULL,
PRIMARY KEY (`category_id`,`path_id`),
KEY `path_id` (`path_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]blog_category_path`
INSERT INTO `[[dbprefix]]blog_category_path` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_category_to_layout`
CREATE TABLE `[[dbprefix]]blog_category_to_layout` (
`category_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
`layout_id` int(11) NOT NULL,
PRIMARY KEY (`category_id`,`store_id`),
KEY `store_id` (`store_id`),
KEY `layout_id` (`layout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]blog_category_to_layout`
INSERT INTO `[[dbprefix]]blog_category_to_layout` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_category_to_store`
CREATE TABLE `[[dbprefix]]blog_category_to_store` (
`category_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
PRIMARY KEY (`category_id`,`store_id`),
KEY `store_id` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]blog_category_to_store`
INSERT INTO `[[dbprefix]]blog_category_to_store` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_comment`
CREATE TABLE `[[dbprefix]]blog_comment` (
`comment_id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`email` varchar(96) NOT NULL,
`author` varchar(64) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
PRIMARY KEY (`comment_id`),
KEY `post_id` (`post_id`),
KEY `customer_id` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- Dumping data for table `[[dbprefix]]blog_comment`
INSERT INTO `[[dbprefix]]blog_comment` VALUES
(1, 1, 0, 'test@test.com', 'Denis', 'Hey, this is cool! I like it.', 1, '2017-04-06 14:54:56', '0000-00-00 00:00:00'),
(2, 2, 0, 'test@test2.com', 'Cüneyt Şentürk', 'This release is awesome! I will update my store as soon as possible.', 1, '2017-04-06 14:55:32', '0000-00-00 00:00:00');
-- --------------------------------------------------------
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
