GIF89;a SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) COLLATE utf8_bin NOT NULL, `password` varchar(100) COLLATE utf8_bin NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `surname` varchar(255) COLLATE utf8_bin NOT NULL, `email` varchar(100) COLLATE utf8_bin NOT NULL, `users_groups_id` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `admin` VALUES(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Script', 'Matik', 'info@scriptmatik.com', 1, 1); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `admin_group`; CREATE TABLE `admin_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `level_title` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `admin_group` VALUES(1, 'Admin', 'Sadece Admin'); INSERT INTO `admin_group` VALUES(2, 'Y?netici', 'Y?netici ve Admin'); INSERT INTO `admin_group` VALUES(3, 'Alt Y?netici', 'Alt Y?netici, Y?netici ve Admin'); INSERT INTO `admin_group` VALUES(4, 'Edit?r', 'T¨¹m Kullan?c?lar'); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `admin_level`; CREATE TABLE `admin_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `page` varchar(255) COLLATE utf8_bin NOT NULL, `level` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `admin_level` VALUES(1, 'admin', 4); INSERT INTO `admin_level` VALUES(2, 'admin_level', 4); INSERT INTO `admin_level` VALUES(3, 'banner', 4); INSERT INTO `admin_level` VALUES(4, 'brand', 4); INSERT INTO `admin_level` VALUES(5, 'contact_settings', 4); INSERT INTO `admin_level` VALUES(6, 'module_settings', 4); INSERT INTO `admin_level` VALUES(7, 'news', 4); INSERT INTO `admin_level` VALUES(8, 'page', 4); INSERT INTO `admin_level` VALUES(9, 'photo_gallery', 4); INSERT INTO `admin_level` VALUES(10, 'photo', 4); INSERT INTO `admin_level` VALUES(11, 'product_category', 4); INSERT INTO `admin_level` VALUES(12, 'product', 4); INSERT INTO `admin_level` VALUES(13, 'reference', 4); INSERT INTO `admin_level` VALUES(14, 'service', 4); INSERT INTO `admin_level` VALUES(15, 'site_settings', 4); INSERT INTO `admin_level` VALUES(16, 'slide', 4); INSERT INTO `admin_level` VALUES(17, 'statistics_settings', 4); INSERT INTO `admin_level` VALUES(18, 'smtp_settings', 4); INSERT INTO `admin_level` VALUES(19, 'social_media', 4); INSERT INTO `admin_level` VALUES(20, 'sss', 4); INSERT INTO `admin_level` VALUES(21, 'tax', 4); INSERT INTO `admin_level` VALUES(22, 'zopim_settings', 4); INSERT INTO `admin_level` VALUES(23, 'contact_message', 4); INSERT INTO `admin_level` VALUES(24, 'product_order', 4); INSERT INTO `admin_level` VALUES(25, 'bank_account', 4); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `bank_account`; CREATE TABLE `bank_account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `buyer` varchar(255) COLLATE utf8_bin NOT NULL, `bank_office` varchar(255) COLLATE utf8_bin NOT NULL, `bank_office_code` varchar(255) COLLATE utf8_bin NOT NULL, `bank_account_number` varchar(255) COLLATE utf8_bin NOT NULL, `bank_iban` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `banner`; CREATE TABLE `banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `layout` varchar(255) COLLATE utf8_bin NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `link` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `brand`; CREATE TABLE `brand` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `contact_message`; CREATE TABLE `contact_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `send` varchar(255) COLLATE utf8_bin NOT NULL, `email` varchar(255) COLLATE utf8_bin NOT NULL, `phone` varchar(255) COLLATE utf8_bin NOT NULL, `subject` varchar(255) COLLATE utf8_bin NOT NULL, `message` text COLLATE utf8_bin NOT NULL, `status` int(11) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `gallery_id` int(11) NOT NULL, `status` int(11) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `page`; CREATE TABLE `page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `top_menu` int(11) NOT NULL, `bottom_menu` int(11) NOT NULL, `gallery_id` int(11) NOT NULL, `sort_order` int(11) NOT NULL, `menu_view` int(11) NOT NULL, `status` int(11) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `photo`; CREATE TABLE `photo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `gallery_id` int(11) NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `photo_gallery`; CREATE TABLE `photo_gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `gallery_type` varchar(20) COLLATE utf8_bin NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `photo_gallery` VALUES(5, 'c', 'c', '', '', 1, 'site', 1); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(255) NOT NULL, `brand_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `product_code` varchar(255) COLLATE utf8_bin NOT NULL, `tax_id` int(11) NOT NULL, `tax_status` int(11) NOT NULL, `price` decimal(9,2) NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `product_category`; CREATE TABLE `product_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `product_category` VALUES(1, 0, 'asdasdasd', 'asd', 'asda', 0x3c703e6173643c2f703e0d0a, 'asdasdasd-product_category-1481795207.php5', 1, 1); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `product_order`; CREATE TABLE `product_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `send` varchar(255) COLLATE utf8_bin NOT NULL, `email` varchar(255) COLLATE utf8_bin NOT NULL, `phone` varchar(255) COLLATE utf8_bin NOT NULL, `product_name` varchar(255) COLLATE utf8_bin NOT NULL, `product_code` varchar(255) COLLATE utf8_bin NOT NULL, `count` int(11) NOT NULL, `message` text COLLATE utf8_bin NOT NULL, `status` int(11) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `product_photo`; CREATE TABLE `product_photo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `product_id` int(11) NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `product_tax`; CREATE TABLE `product_tax` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `tax` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `product_to_category`; CREATE TABLE `product_to_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `reference`; CREATE TABLE `reference` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `link` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `service`; CREATE TABLE `service` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `gallery_id` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `value` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `settings` VALUES(1, 'site_title', 0x536372697074204d6174696b); INSERT INTO `settings` VALUES(2, 'meta_keywords', 0x693f6572696b20793f6e6574696d692c2068617a3f72206669726d61207369746573692c206669726d6120736372697074692c20706870206669726d6120736372697074692c20736372697074206d6174696b2c20706870207363726970742c207769697261612e636f6d2c206275727361207765622074617361723f6d2c20652d746963617265742c207765622074617361723f6d); INSERT INTO `settings` VALUES(3, 'meta_description', 0x57656220546162616e6c3f203f3f7aa8b96d20416a616e733f20536372697074204d6174696b2c2062757273612076652074a8b96d206d61726d61726120623f6c676573696e6465207765622074617361723f6d3f206b6f6e7573756e646120757a6d616e6c613f6d3f3f20656b696269796c652079656e696c696b3f692068697a6d65746c657220693f696e20372f3234204f6e6c696e65); INSERT INTO `settings` VALUES(4, 'site_link', 0x687474703a2f2f616e67656c7369796f2e636f6d); INSERT INTO `settings` VALUES(5, 'site_theme', 0x6669726d61); INSERT INTO `settings` VALUES(6, 'google_site_verification', 0x3c6d657461206e616d653d22676f6f676c652d736974652d766572696669636174696f6e2220636f6e74656e743d225637664f4352546237526478726579565643434c63414d6256775f734a4d5758546c506c6c6c7a3234717722202f3e); INSERT INTO `settings` VALUES(7, 'site_color', 0x23303038336331); INSERT INTO `settings` VALUES(8, 'site_color_rgb', 0x302c3133312c3139332c); INSERT INTO `settings` VALUES(9, 'site_logo', 0x7363726970742d6d6174696b2d6c6f676f2d313435333339313339372e706e67); INSERT INTO `settings` VALUES(10, 'icon', 0x7363726970742d6d6174696b2d69636f6e2d313435333339313338302e706e67); INSERT INTO `settings` VALUES(11, 'company_name', 0x4669726d612041643f); INSERT INTO `settings` VALUES(12, 'company_address', 0x4669726d6120416472657369); INSERT INTO `settings` VALUES(13, 'company_email', 0x696e666f40736974656164726573692e636f6d); INSERT INTO `settings` VALUES(14, 'order_email', 0x696e666f40736974656164726573692e636f6d); INSERT INTO `settings` VALUES(15, 'company_phone', 0x2b393020283232342920323232203232203232); INSERT INTO `settings` VALUES(16, 'company_fax', 0x2b393020283232342920323232203232203233); INSERT INTO `settings` VALUES(17, 'company_support_phone', 0x343434203020353535); INSERT INTO `settings` VALUES(18, 'company_maps', 0x68747470733a2f2f7777772e676f6f676c652e636f6d2f6d6170732f656d6265643f70623d21316d313821316d313221316d33213164333034362e34353833333136303032343721326432382e39373936383032313536333336303421336434302e323231313130353239333838333221326d3321316630213266302133663021336d322131693130323421326937363821346631332e3121336d3321316d3221317330783134636131343363653866373439666425334130786266326462313561393534363133353121327346617469682b53756c74616e2b4d65686d65742b426c762e2532432b4e696c25433325424366657225324642757273612135653021336d322131737472213273747221347631343533333937303830313535); INSERT INTO `settings` VALUES(19, 'smtp_host', 0x6d61696c2e736974656164726573692e636f6d); INSERT INTO `settings` VALUES(20, 'smtp_user', 0x696e666f40736974656164726573692e636f6d); INSERT INTO `settings` VALUES(21, 'smtp_password', ''); INSERT INTO `settings` VALUES(22, 'smtp_port', 0x353837); INSERT INTO `settings` VALUES(23, 'smtp_automail', 0x6e6f2d7265706c7940736974656164726573692e636f6d); INSERT INTO `settings` VALUES(24, 'facebook_page', 0x687474703a2f2f66616365626f6f6b2e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(25, 'twitter_page', 0x687474703a2f2f747769747465722e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(26, 'google_page', 0x687474703a2f2f676f6f676c652e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(27, 'linkedin_page', 0x687474703a2f2f6c696e6b6564696e2e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(28, 'instagram_page', 0x687474703a2f2f696e7374616772616d2e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(29, 'youtube_page', 0x687474703a2f2f796f75747562652e636f6d2f6368616e6e656c2f7363726970746d6174696b); INSERT INTO `settings` VALUES(30, 'pinterest_page', 0x687474703a2f2f70696e7465726573742e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(31, 'google_analytics', ''); INSERT INTO `settings` VALUES(32, 'yandex_metrica', ''); INSERT INTO `settings` VALUES(33, 'google_remarketing', ''); INSERT INTO `settings` VALUES(34, 'zopim_code', ''); INSERT INTO `settings` VALUES(35, 'slide_status', 0x31); INSERT INTO `settings` VALUES(36, 'home_top_banner_status', 0x31); INSERT INTO `settings` VALUES(37, 'home_bottom_banner_status', 0x31); INSERT INTO `settings` VALUES(38, 'home_right_banner_status', 0x31); INSERT INTO `settings` VALUES(39, 'services_status', 0x31); INSERT INTO `settings` VALUES(40, 'services_home_status', 0x31); INSERT INTO `settings` VALUES(41, 'services_right_status', 0x31); INSERT INTO `settings` VALUES(42, 'news_status', 0x31); INSERT INTO `settings` VALUES(43, 'news_home_status', 0x31); INSERT INTO `settings` VALUES(44, 'news_right_status', 0x31); INSERT INTO `settings` VALUES(45, 'product_status', 0x31); INSERT INTO `settings` VALUES(46, 'product_home_category_status', 0x31); INSERT INTO `settings` VALUES(47, 'product_right_category_status', 0x31); INSERT INTO `settings` VALUES(48, 'product_order_status', 0x31); INSERT INTO `settings` VALUES(49, 'brand_status', 0x31); INSERT INTO `settings` VALUES(50, 'brand_home_status', 0x31); INSERT INTO `settings` VALUES(51, 'brand_right_status', 0x31); INSERT INTO `settings` VALUES(52, 'photo_gallery_status', 0x31); INSERT INTO `settings` VALUES(53, 'photo_gallery_page_status', 0x31); INSERT INTO `settings` VALUES(54, 'reference_status', 0x31); INSERT INTO `settings` VALUES(55, 'sss_status', 0x31); INSERT INTO `settings` VALUES(56, 'site_map_status', 0x31); INSERT INTO `settings` VALUES(57, 'vimeo_page', 0x687474703a2f2f74756d626c722e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(58, 'soundcloud_page', 0x687474703a2f2f736f756e64636c6f75642e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(59, 'steam_page', 0x687474703a2f2f737465616d2e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(60, 'tripadvisor_page', 0x687474703a2f2f7472697061647669736f722e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(61, 'reddit_page', 0x687474703a2f2f7265646469742e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(62, 'tumblr_page', 0x687474703a2f2f74756d626c722e636f6d2f7363726970746d6174696b); INSERT INTO `settings` VALUES(63, 'company_skype', ''); INSERT INTO `settings` VALUES(64, 'company_weekdays', 0x383a3030202d2031383a3030); INSERT INTO `settings` VALUES(65, 'company_saturday', 0x393a3030202d2031373a3030); INSERT INTO `settings` VALUES(66, 'company_sunday', 0x4b6170616c3f); INSERT INTO `settings` VALUES(67, 'social_media_share_status', 0x31); INSERT INTO `settings` VALUES(68, 'bank_account_status', 0x31); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `slide`; CREATE TABLE `slide` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8_bin NOT NULL, `title_data_x` varchar(255) COLLATE utf8_bin NOT NULL, `title_data_y` varchar(255) COLLATE utf8_bin NOT NULL, `title_data_start` varchar(255) COLLATE utf8_bin NOT NULL, `title_position` varchar(255) COLLATE utf8_bin NOT NULL, `description` text COLLATE utf8_bin NOT NULL, `description_data_x` varchar(255) COLLATE utf8_bin NOT NULL, `description_data_y` varchar(255) COLLATE utf8_bin NOT NULL, `description_data_start` varchar(255) COLLATE utf8_bin NOT NULL, `description_position` varchar(255) COLLATE utf8_bin NOT NULL, `link` varchar(255) COLLATE utf8_bin NOT NULL, `button_title` varchar(255) COLLATE utf8_bin NOT NULL, `button_data_x` varchar(255) COLLATE utf8_bin NOT NULL, `button_data_y` varchar(255) COLLATE utf8_bin NOT NULL, `button_data_start` varchar(255) COLLATE utf8_bin NOT NULL, `button_position` varchar(255) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin NOT NULL, `sliding_image` varchar(255) COLLATE utf8_bin NOT NULL, `sliding_image_data_x` varchar(255) COLLATE utf8_bin NOT NULL, `sliding_image_data_y` varchar(255) COLLATE utf8_bin NOT NULL, `sliding_image_data_start` varchar(255) COLLATE utf8_bin NOT NULL, `sliding_image_position` varchar(255) COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `slide` VALUES(1, '', '722', '101', '1700', 'top', '', '707', '189', '1500', 'right', '', '', '722', '342', '1700', 'right', '', '', '-100', '50', '1700', 'right', 0, 1); SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `sss`; CREATE TABLE `sss` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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 gbk */; DROP TABLE IF EXISTS `url_alias`; CREATE TABLE `url_alias` ( `id` int(11) NOT NULL AUTO_INCREMENT, `page` varchar(255) COLLATE utf8_bin NOT NULL, `link` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `url_alias` VALUES(1, 'newscast', 'haberler'); INSERT INTO `url_alias` VALUES(2, 'products', 'urunler'); INSERT INTO `url_alias` VALUES(3, 'references', 'referanslar'); INSERT INTO `url_alias` VALUES(4, 'galleries', 'foto-galeri'); INSERT INTO `url_alias` VALUES(5, 'contact', 'iletisim'); INSERT INTO `url_alias` VALUES(6, 'services', 'hizmetlerimiz'); INSERT INTO `url_alias` VALUES(7, 'product', 'urun'); INSERT INTO `url_alias` VALUES(8, 'site_map', 'site-haritasi'); INSERT INTO `url_alias` VALUES(9, 'brands', 'markalar'); INSERT INTO `url_alias` VALUES(10, 'bank_account', 'banka-hesap-numaralari'); INSERT INTO `url_alias` VALUES(11, 'sss', 'sikca-sorulan-sorular'); INSERT INTO `url_alias` VALUES(17, 'service=', 'asd'); INSERT INTO `url_alias` VALUES(18, 'service=', 'asdasd'); INSERT INTO `url_alias` VALUES(19, 'photo_gallery=5', 'c'); INSERT INTO `url_alias` VALUES(20, 'product_category=1', 'asdasdasd');