| Server IP : 103.119.228.120 / Your IP : 18.119.122.140 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/softaculous/zsite/ |
Upload File : |
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: `zsite861`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]access`
--
CREATE TABLE `[[dbprefix]]access` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`objectType` char(20) NOT NULL,
`objectID` mediumint(8) NOT NULL,
`resource` char(30) NOT NULL,
`level` char(30) NOT NULL,
`cost` char(30) NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `resource` (`objectType`,`objectID`,`resource`,`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]action`
--
CREATE TABLE `[[dbprefix]]action` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`objectType` varchar(30) NOT NULL DEFAULT '',
`objectID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`actor` varchar(30) NOT NULL DEFAULT '',
`action` varchar(30) NOT NULL DEFAULT '',
`date` datetime NOT NULL,
`comment` text NOT NULL,
`extra` varchar(255) NOT NULL,
`source` char(5) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `objectType` (`objectType`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]address`
--
CREATE TABLE `[[dbprefix]]address` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`account` char(30) NOT NULL,
`contact` varchar(50) NOT NULL,
`address` varchar(255) NOT NULL,
`phone` char(20) NOT NULL,
`zipcode` char(6) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]answer`
--
CREATE TABLE `[[dbprefix]]answer` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`question` mediumint(8) unsigned NOT NULL,
`account` varchar(30) NOT NULL,
`content` text NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `question` (`question`),
KEY `account` (`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]article`
--
CREATE TABLE `[[dbprefix]]article` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(150) NOT NULL,
`titleColor` varchar(10) NOT NULL,
`alias` varchar(100) NOT NULL,
`keywords` varchar(150) NOT NULL,
`summary` text NOT NULL,
`content` text NOT NULL,
`video` text NOT NULL,
`source` enum('original','copied','translational','article') NOT NULL,
`copySite` varchar(60) NOT NULL,
`copyURL` varchar(255) NOT NULL,
`author` varchar(60) NOT NULL,
`addedBy` varchar(60) NOT NULL,
`editor` varchar(60) NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`status` varchar(20) NOT NULL DEFAULT 'normal',
`type` varchar(30) NOT NULL,
`submission` enum('0','1','2','3') NOT NULL DEFAULT '0',
`views` int(11) unsigned NOT NULL DEFAULT '0',
`sticky` enum('0','1','2','3') NOT NULL DEFAULT '0',
`stickTime` datetime NOT NULL,
`stickBold` enum('0','1') NOT NULL DEFAULT '0',
`order` smallint(5) unsigned NOT NULL,
`link` varchar(255) NOT NULL,
`css` text NOT NULL,
`js` text NOT NULL,
`onlyBody` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `lang` (`lang`),
KEY `order` (`order`),
KEY `views` (`views`),
KEY `sticky` (`sticky`),
KEY `status` (`status`),
KEY `addedDate` (`addedDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute`
--
CREATE TABLE `[[dbprefix]]attribute` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`category` mediumint(8) NOT NULL DEFAULT '0',
`code` char(30) NOT NULL,
`name` varchar(100) NOT NULL,
`inputType` char(30) NOT NULL,
`search` char(30) NOT NULL,
`values` text NOT NULL,
`default` text NOT NULL,
`sort` smallint(5) NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `category` (`category`),
KEY `search` (`category`),
KEY `lang` (`lang`),
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]balance_log`
--
CREATE TABLE `[[dbprefix]]balance_log` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`account` char(30) NOT NULL,
`tradeType` char(30) NOT NULL,
`tradeID` mediumint(8) unsigned NOT NULL,
`amount` decimal(12,2) NOT NULL DEFAULT '0.00',
`createdDate` datetime NOT NULL,
`lang` char(30) NOT NULL,
`before` decimal(12,2) NOT NULL DEFAULT '0.00',
`createdBy` char(30) NOT NULL,
`status` char(30) NOT NULL,
`after` decimal(12,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `tradeType` (`tradeType`,`tradeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]bearlog`
--
CREATE TABLE `[[dbprefix]]bearlog` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(10) NOT NULL,
`objectType` varchar(30) NOT NULL,
`objectID` mediumint(9) NOT NULL,
`url` varchar(255) NOT NULL,
`account` varchar(30) NOT NULL,
`status` char(30) NOT NULL,
`response` text NOT NULL,
`time` datetime NOT NULL,
`auto` enum('yes','no') NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `lang` (`lang`),
KEY `objectType` (`objectType`),
KEY `objectID` (`objectID`),
KEY `time` (`time`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]blacklist`
--
CREATE TABLE `[[dbprefix]]blacklist` (
`type` varchar(30) NOT NULL,
`identity` varchar(100) NOT NULL,
`reason` varchar(100) NOT NULL,
`expiredDate` datetime NOT NULL,
`addedDate` datetime NOT NULL,
`times` tinyint(3) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
UNIQUE KEY `identity` (`type`,`identity`,`lang`),
KEY `expiredDate` (`expiredDate`),
KEY `addedDate` (`addedDate`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]block`
--
CREATE TABLE `[[dbprefix]]block` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`originID` smallint(5) unsigned NOT NULL DEFAULT '0',
`effectID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`template` varchar(30) NOT NULL DEFAULT 'default',
`type` varchar(20) NOT NULL,
`title` varchar(60) NOT NULL,
`content` text NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `type` (`type`),
KEY `template` (`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=241 ;
--
-- Dumping data for table `[[dbprefix]]block`
--
INSERT INTO `[[dbprefix]]block` VALUES
(1, 0, 0, 'default', 'latestArticle', '最新文章', '{"category":"0","limit":"7"}', 'zh-cn'),
(2, 0, 0, 'default', 'hotArticle', '热门文章', '{"category":"0","limit":"7"}', 'zh-cn'),
(3, 0, 0, 'default', 'latestProduct', '最新产品', '{"category":"0","limit":"3","image":"show"}', 'zh-cn'),
(4, 0, 0, 'default', 'hotProduct', '热门产品', '{"category":"0","limit":"3","image":"show"}', 'zh-cn'),
(5, 0, 0, 'default', 'slide', '幻灯片', '', 'zh-cn'),
(6, 0, 0, 'default', 'articleTree', '文章分类', '{"showChildren":"0"}', 'zh-cn'),
(7, 0, 0, 'default', 'productTree', '产品分类', '{"showChildren":"0"}', 'zh-cn'),
(8, 0, 0, 'default', 'blogTree', '博客分类', '{"showChildren":"1"}', 'zh-cn'),
(9, 0, 0, 'default', 'pageList', '单页列表', '{"limit":"7"}', 'zh-cn'),
(10, 0, 0, 'default', 'contact', '联系我们', '', 'zh-cn'),
(11, 0, 0, 'default', 'about', '公司简介', '', 'zh-cn'),
(12, 0, 0, 'default', 'links', '友情链接', '', 'zh-cn'),
(13, 0, 0, 'default', 'header', '网站头部', '', 'zh-cn'),
(14, 0, 0, 'default', 'followUs', '关注我们', '', 'zh-cn'),
(15, 0, 0, 'default', 'subscribe', '订阅博客', '', 'zh-cn'),
(21, 0, 0, 'mobile', 'latestArticle', '最新文章', '{"category":"0","limit":"7"}', 'zh-cn'),
(22, 0, 0, 'mobile', 'hotArticle', '热门文章', '{"category":"0","limit":"7"}', 'zh-cn'),
(23, 0, 0, 'mobile', 'latestProduct', '最新产品', '{"category":"0","limit":"3","image":"show"}', 'zh-cn'),
(24, 0, 0, 'mobile', 'hotProduct', '热门产品', '{"category":"0","limit":"3","image":"show"}', 'zh-cn'),
(25, 0, 0, 'mobile', 'slide', '手机版幻灯片', '', 'zh-cn'),
(26, 0, 0, 'mobile', 'articleTree', '文章分类', '{"showChildren":"0"}', 'zh-cn'),
(27, 0, 0, 'mobile', 'productTree', '产品分类', '{"showChildren":"0"}', 'zh-cn'),
(28, 0, 0, 'mobile', 'blogTree', '博客分类', '{"showChildren":"1"}', 'zh-cn'),
(29, 0, 0, 'mobile', 'pageList', '单页列表', '{"limit":"7"}', 'zh-cn'),
(30, 0, 0, 'mobile', 'contact', '联系我们', '', 'zh-cn'),
(31, 0, 0, 'mobile', 'about', '公司简介', '', 'zh-cn'),
(32, 0, 0, 'mobile', 'links', '友情链接', '', 'zh-cn'),
(33, 0, 0, 'mobile', 'followUs', '关注我们', '', 'zh-cn'),
(34, 0, 0, 'mobile', 'header', '网站头部', '', 'zh-cn'),
(101, 0, 0, 'default', 'latestArticle', 'Latest Article', '{"category":"0","limit":"7"}', 'en'),
(102, 0, 0, 'default', 'hotArticle', 'Hot Article', '{"category":"0","limit":"7"}', 'en'),
(103, 0, 0, 'default', 'latestProduct', 'Latest Product', '{"category":"0","limit":"3","image":"show"}', 'en'),
(104, 0, 0, 'default', 'hotProduct', 'Hot Product', '{"category":"0","limit":"3","image":"show"}', 'en'),
(105, 0, 0, 'default', 'slide', 'Slide', '', 'en'),
(106, 0, 0, 'default', 'articleTree', 'Article Category', '{"showChildren":"0"}', 'en'),
(107, 0, 0, 'default', 'productTree', 'Product Category', '{"showChildren":"0"}', 'en'),
(108, 0, 0, 'default', 'blogTree', 'Blog Category', '{"showChildren":"1"}', 'en'),
(109, 0, 0, 'default', 'pageList', 'Page List', '{"limit":"7"}', 'en'),
(110, 0, 0, 'default', 'contact', 'Contact Us', '', 'en'),
(111, 0, 0, 'default', 'about', 'About Us', '', 'en'),
(112, 0, 0, 'default', 'links', 'Link', '', 'en'),
(113, 0, 0, 'default', 'header', 'Header', '', 'en'),
(114, 0, 0, 'default', 'followUs', 'Follow Us', '', 'en'),
(115, 0, 0, 'default', 'subscribe', 'Subscribe', '', 'en'),
(121, 0, 0, 'mobile', 'latestArticle', 'Latest Article', '{"category":"0","limit":"7"}', 'en'),
(122, 0, 0, 'mobile', 'hotArticle', 'Hot Article', '{"category":"0","limit":"7"}', 'en'),
(123, 0, 0, 'mobile', 'latestProduct', 'Latest Product', '{"category":"0","limit":"3","image":"show"}', 'en'),
(124, 0, 0, 'mobile', 'hotProduct', 'Hot Product', '{"category":"0","limit":"3","image":"show"}', 'en'),
(125, 0, 0, 'mobile', 'slide', 'Mobile Slide', '', 'en'),
(126, 0, 0, 'mobile', 'articleTree', 'Article Category', '{"showChildren":"0"}', 'en'),
(127, 0, 0, 'mobile', 'productTree', 'Product Category', '{"showChildren":"0"}', 'en'),
(128, 0, 0, 'mobile', 'blogTree', 'Blog Category', '{"showChildren":"1"}', 'en'),
(129, 0, 0, 'mobile', 'pageList', 'Page List', '{"limit":"7"}', 'en'),
(130, 0, 0, 'mobile', 'contact', 'Contact Us', '', 'en'),
(131, 0, 0, 'mobile', 'about', 'About Us', '', 'en'),
(132, 0, 0, 'mobile', 'links', 'Link', '', 'en'),
(133, 0, 0, 'mobile', 'followUs', 'Follow Us', '', 'en'),
(134, 0, 0, 'mobile', 'header', 'Header', '', 'en'),
(201, 0, 0, 'default', 'latestArticle', '最新文章', '{"category":"0","limit":"7"}', 'zh-tw'),
(202, 0, 0, 'default', 'hotArticle', '熱門文章', '{"category":"0","limit":"7"}', 'zh-tw'),
(203, 0, 0, 'default', 'latestProduct', '最新產品', '{"category":"0","limit":"3","image":"show"}', 'zh-tw'),
(204, 0, 0, 'default', 'hotProduct', '熱門產品', '{"category":"0","limit":"3","image":"show"}', 'zh-tw'),
(205, 0, 0, 'default', 'slide', '幻燈片', '', 'zh-tw'),
(206, 0, 0, 'default', 'articleTree', '文章分類', '{"showChildren":"0"}', 'zh-tw'),
(207, 0, 0, 'default', 'productTree', '產品分類', '{"showChildren":"0"}', 'zh-tw'),
(208, 0, 0, 'default', 'blogTree', '博客分類', '{"showChildren":"1"}', 'zh-tw'),
(209, 0, 0, 'default', 'pageList', '單頁列表', '{"limit":"7"}', 'zh-tw'),
(210, 0, 0, 'default', 'contact', '聯繫我們', '', 'zh-tw'),
(211, 0, 0, 'default', 'about', '公司簡介', '', 'zh-tw'),
(212, 0, 0, 'default', 'links', '友情鏈接', '', 'zh-tw'),
(213, 0, 0, 'default', 'header', '網站頭部', '', 'zh-tw'),
(214, 0, 0, 'default', 'followUs', '關注我們', '', 'zh-tw'),
(215, 0, 0, 'default', 'subscribe', '訂閱博客', '', 'zh-tw'),
(221, 0, 0, 'mobile', 'latestArticle', '最新文章', '{"category":"0","limit":"7"}', 'zh-tw'),
(222, 0, 0, 'mobile', 'hotArticle', '熱門文章', '{"category":"0","limit":"7"}', 'zh-tw'),
(223, 0, 0, 'mobile', 'latestProduct', '最新產品', '{"category":"0","limit":"3","image":"show"}', 'zh-tw'),
(224, 0, 0, 'mobile', 'hotProduct', '熱門產品', '{"category":"0","limit":"3","image":"show"}', 'zh-tw'),
(225, 0, 0, 'mobile', 'slide', '手機版幻燈片', '', 'zh-tw'),
(226, 0, 0, 'mobile', 'articleTree', '文章分類', '{"showChildren":"0"}', 'zh-tw'),
(227, 0, 0, 'mobile', 'productTree', '產品分類', '{"showChildren":"0"}', 'zh-tw'),
(228, 0, 0, 'mobile', 'blogTree', '博客分類', '{"showChildren":"1"}', 'zh-tw'),
(229, 0, 0, 'mobile', 'pageList', '單頁列表', '{"limit":"7"}', 'zh-tw'),
(230, 0, 0, 'mobile', 'contact', '聯繫我們', '', 'zh-tw'),
(231, 0, 0, 'mobile', 'about', '公司簡介', '', 'zh-tw'),
(232, 0, 0, 'mobile', 'links', '友情鏈接', '', 'zh-tw'),
(233, 0, 0, 'mobile', 'followUs', '關注我們', '', 'zh-tw'),
(234, 0, 0, 'mobile', 'header', '網站頭部', '', 'zh-tw'),
(235, 0, 0, 'default', 'formList', '表单列表', '{"limit":"7"}', 'zh-cn'),
(236, 0, 0, 'mobile', 'formList', '表单列表', '{"limit":"7"}', 'zh-cn'),
(237, 0, 0, 'default', 'formList', 'Form List', '{"limit":"7"}', 'en'),
(238, 0, 0, 'mobile', 'formList', 'Form List', '{"limit":"7"}', 'en'),
(239, 0, 0, 'default', 'formList', '表單列表', '{"limit":"7"}', 'zh-tw'),
(240, 0, 0, 'mobile', 'formList', '表單列表', '{"limit":"7"}', 'zh-tw');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]book`
--
CREATE TABLE `[[dbprefix]]book` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`articleID` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(150) NOT NULL,
`alias` varchar(100) NOT NULL,
`keywords` varchar(150) NOT NULL,
`summary` text NOT NULL,
`content` text NOT NULL,
`type` enum('book','chapter','article') NOT NULL,
`parent` smallint(5) unsigned NOT NULL DEFAULT '0',
`path` char(255) NOT NULL DEFAULT '',
`grade` tinyint(3) unsigned NOT NULL DEFAULT '0',
`author` varchar(60) NOT NULL,
`editor` varchar(60) NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`status` varchar(20) NOT NULL DEFAULT 'normal',
`views` int(11) unsigned NOT NULL DEFAULT '0',
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
`link` varchar(255) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `lang` (`lang`),
KEY `order` (`order`),
KEY `parent` (`parent`),
KEY `status` (`status`),
KEY `addedDate` (`addedDate`),
KEY `path` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart`
--
CREATE TABLE `[[dbprefix]]cart` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`account` char(30) NOT NULL,
`product` mediumint(8) unsigned NOT NULL DEFAULT '0',
`count` smallint(5) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
`extra` text NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `product` (`product`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category`
--
CREATE TABLE `[[dbprefix]]category` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`abbr` varchar(60) NOT NULL,
`alias` varchar(100) NOT NULL,
`desc` text NOT NULL,
`keywords` varchar(150) NOT NULL,
`parent` smallint(5) unsigned NOT NULL DEFAULT '0',
`path` char(255) NOT NULL DEFAULT '',
`grade` tinyint(3) unsigned NOT NULL DEFAULT '0',
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
`type` char(30) NOT NULL,
`readonly` enum('0','1') NOT NULL DEFAULT '0',
`moderators` varchar(255) NOT NULL,
`threads` smallint(5) NOT NULL,
`posts` smallint(5) NOT NULL,
`postedBy` varchar(30) NOT NULL,
`postedDate` datetime NOT NULL,
`postID` mediumint(9) NOT NULL,
`replyID` mediumint(8) unsigned NOT NULL,
`link` varchar(255) NOT NULL,
`unsaleable` enum('0','1') NOT NULL DEFAULT '0',
`discussion` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
`extra` text NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `tree` (`type`),
KEY `order` (`order`),
KEY `parent` (`parent`),
KEY `path` (`path`),
KEY `grade` (`grade`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]certify`
--
CREATE TABLE `[[dbprefix]]certify` (
`account` char(30) NOT NULL,
`email` varchar(90) NOT NULL,
`zentaoKey` char(32) NOT NULL,
`sendcloudUser` varchar(255) NOT NULL,
`sendcloudPwd` char(16) NOT NULL,
`sendcloudKey` char(16) NOT NULL,
`certify` varchar(20) NOT NULL,
`total` smallint(6) NOT NULL,
`send` smallint(6) NOT NULL,
`addedTime` datetime NOT NULL,
`certifyTime` datetime NOT NULL,
`send2SC` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
UNIQUE KEY `account` (`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]config`
--
CREATE TABLE `[[dbprefix]]config` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`owner` char(30) NOT NULL DEFAULT '',
`module` varchar(30) NOT NULL,
`section` char(30) NOT NULL DEFAULT '',
`key` char(50) DEFAULT NULL,
`value` text NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique` (`owner`,`module`,`section`,`key`,`lang`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `[[dbprefix]]config`
--
INSERT INTO `[[dbprefix]]config` VALUES
(1, 'system', 'common', 'request', 'categoryRule', 'global', 'zh-cn'),
(2, 'system', 'common', 'request', 'categoryRule', 'global', 'zh-tw'),
(3, 'system', 'common', 'request', 'categoryRule', 'global', 'en'),
(4, 'system', 'common', 'template', 'parser', 'raintpl', 'zh-cn'),
(5, 'system', 'common', 'template', 'parser', 'raintpl', 'zh-tw'),
(6, 'system', 'common', 'template', 'parser', 'raintpl', 'en'),
(7, 'system', 'common', 'global', 'version', '8.6.1', 'all'),
(8, 'system', 'common', 'site', 'lang', 'zh-cn', 'all');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]down`
--
CREATE TABLE `[[dbprefix]]down` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`account` char(30) DEFAULT NULL,
`file` mediumint(5) DEFAULT NULL,
`ip` char(40) NOT NULL,
`time` datetime NOT NULL,
`referer` varchar(200) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `fileID` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]faq`
--
CREATE TABLE `[[dbprefix]]faq` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`product` mediumint(8) unsigned NOT NULL,
`request` varchar(255) NOT NULL,
`answer` text NOT NULL,
`from` mediumint(8) NOT NULL,
`views` smallint(5) unsigned NOT NULL,
`addedtime` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]file`
--
CREATE TABLE `[[dbprefix]]file` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`pathname` char(100) NOT NULL,
`title` char(90) NOT NULL,
`extension` char(30) NOT NULL,
`size` int(10) unsigned NOT NULL DEFAULT '0',
`width` smallint(5) unsigned NOT NULL DEFAULT '0',
`height` smallint(5) unsigned NOT NULL DEFAULT '0',
`objectType` char(20) NOT NULL,
`objectID` char(50) NOT NULL,
`addedBy` char(30) NOT NULL DEFAULT '',
`addedDate` datetime NOT NULL,
`public` enum('1','0') NOT NULL DEFAULT '1',
`score` mediumint(8) unsigned NOT NULL DEFAULT '0',
`downloads` mediumint(8) unsigned NOT NULL DEFAULT '0',
`extra` varchar(255) NOT NULL,
`order` smallint(5) unsigned NOT NULL,
`editor` enum('1','0') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `pathname` (`pathname`),
KEY `object` (`objectType`,`objectID`),
KEY `extension` (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]form`
--
CREATE TABLE `[[dbprefix]]form` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`type` varchar(30) DEFAULT NULL,
`timeLimit` mediumint(8) unsigned NOT NULL,
`endAmount` mediumint(8) unsigned NOT NULL,
`endTime` datetime NOT NULL,
`needLogin` enum('0','1') NOT NULL DEFAULT '0',
`ipUnique` enum('0','1') NOT NULL DEFAULT '0',
`fingerprint` enum('0','1') NOT NULL DEFAULT '0',
`viewAfterPost` enum('0','1') NOT NULL DEFAULT '0',
`fullScreen` enum('0','1') NOT NULL DEFAULT '0',
`desc` text NOT NULL,
`status` enum('draft','normal','finished') NOT NULL DEFAULT 'draft',
`createdBy` varchar(30) NOT NULL,
`createdDate` datetime NOT NULL,
`editedBy` varchar(30) NOT NULL,
`editedDate` datetime NOT NULL,
`finishedBy` varchar(30) NOT NULL,
`finishedDate` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]formdata`
--
CREATE TABLE `[[dbprefix]]formdata` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`form` mediumint(8) unsigned NOT NULL,
`item` mediumint(8) unsigned NOT NULL,
`user` mediumint(8) unsigned NOT NULL,
`answer` text NOT NULL,
`score` decimal(6,2) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `form` (`form`,`item`,`user`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]formitem`
--
CREATE TABLE `[[dbprefix]]formitem` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`form` mediumint(8) unsigned NOT NULL,
`title` text NOT NULL,
`type` varchar(20) NOT NULL DEFAULT 'common',
`control` varchar(20) NOT NULL DEFAULT 'input',
`display` varchar(10) NOT NULL,
`format` varchar(10) NOT NULL,
`optionType` enum('text','image') NOT NULL DEFAULT 'text',
`rule` varchar(50) NOT NULL,
`answer` text NOT NULL,
`score` smallint(5) NOT NULL,
`scoreRule` varchar(10) NOT NULL DEFAULT 'full',
`order` smallint(5) NOT NULL,
`show` char(5) NOT NULL,
`desc` text NOT NULL,
`createdBy` varchar(30) NOT NULL,
`createdDate` datetime NOT NULL,
`editedBy` varchar(30) NOT NULL,
`editedDate` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `form` (`form`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]formoption`
--
CREATE TABLE `[[dbprefix]]formoption` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`form` mediumint(8) unsigned NOT NULL,
`item` mediumint(8) unsigned NOT NULL,
`title` text NOT NULL,
`order` smallint(5) NOT NULL,
`createdBy` varchar(30) NOT NULL,
`createdDate` datetime NOT NULL,
`editedBy` varchar(30) NOT NULL,
`editedDate` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `form` (`form`),
KEY `item` (`item`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]formuser`
--
CREATE TABLE `[[dbprefix]]formuser` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`form` mediumint(8) unsigned NOT NULL,
`account` varchar(30) NOT NULL,
`ip` varchar(30) NOT NULL,
`fingerprint` varchar(60) NOT NULL,
`score` decimal(6,2) NOT NULL,
`createdDate` datetime NOT NULL,
`desc` text NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `ip` (`ip`),
KEY `fingerprint` (`fingerprint`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]group`
--
CREATE TABLE `[[dbprefix]]group` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` char(30) NOT NULL,
`role` char(30) NOT NULL DEFAULT '',
`desc` char(255) NOT NULL DEFAULT '',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]group`
--
INSERT INTO `[[dbprefix]]group` VALUES
(1, '管理员', '', '拥有后台所有权限', 'zh-cn'),
(2, '网站编辑', '', '拥有发布以及编辑权限', 'zh-cn'),
(3, '客服', '', '管理论坛留言评论的权限', 'zh-cn');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]grouppriv`
--
CREATE TABLE `[[dbprefix]]grouppriv` (
`group` mediumint(8) unsigned NOT NULL DEFAULT '0',
`module` char(30) NOT NULL DEFAULT '',
`method` char(30) NOT NULL DEFAULT '',
`lang` char(30) NOT NULL,
UNIQUE KEY `group` (`group`,`module`,`method`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]grouppriv`
--
INSERT INTO `[[dbprefix]]grouppriv` VALUES
(1, 'admin', 'ignore', 'zh-cn'),
(1, 'admin', 'ignoreupgrade', 'zh-cn'),
(1, 'article', 'admin', 'zh-cn'),
(1, 'article', 'create', 'zh-cn'),
(1, 'article', 'edit', 'zh-cn'),
(1, 'article', 'delete', 'zh-cn'),
(1, 'article', 'forward2Forum', 'zh-cn'),
(1, 'article', 'forward2Blog', 'zh-cn'),
(1, 'article', 'check', 'zh-cn'),
(1, 'article', 'reject', 'zh-cn'),
(1, 'article', 'setcss', 'zh-cn'),
(1, 'article', 'setjs', 'zh-cn'),
(1, 'article', 'stick', 'zh-cn'),
(1, 'product', 'admin', 'zh-cn'),
(1, 'product', 'create', 'zh-cn'),
(1, 'product', 'edit', 'zh-cn'),
(1, 'product', 'changeStatus', 'zh-cn'),
(1, 'product', 'currency', 'zh-cn'),
(1, 'product', 'delete', 'zh-cn'),
(1, 'product', 'setcss', 'zh-cn'),
(1, 'product', 'setjs', 'zh-cn'),
(1, 'product', 'setting', 'zh-cn'),
(1, 'book', 'admin', 'zh-cn'),
(1, 'book', 'catalog', 'zh-cn'),
(1, 'book', 'create', 'zh-cn'),
(1, 'book', 'edit', 'zh-cn'),
(1, 'book', 'sort', 'zh-cn'),
(1, 'book', 'delete', 'zh-cn'),
(1, 'forum', 'admin', 'zh-cn'),
(1, 'forum', 'update', 'zh-cn'),
(1, 'reply', 'admin', 'zh-cn'),
(1, 'reply', 'edit', 'zh-cn'),
(1, 'reply', 'delete', 'zh-cn'),
(1, 'reply', 'deleteFile', 'zh-cn'),
(1, 'thread', 'transfer', 'zh-cn'),
(1, 'thread', 'switchStatus', 'zh-cn'),
(1, 'thread', 'delete', 'zh-cn'),
(1, 'thread', 'deleteFile', 'zh-cn'),
(1, 'site', 'setBasic', 'zh-cn'),
(1, 'site', 'setLang', 'zh-cn'),
(1, 'site', 'setRobots', 'zh-cn'),
(1, 'site', 'setUpload', 'zh-cn'),
(1, 'site', 'setOauth', 'zh-cn'),
(1, 'site', 'setRecPerPage', 'zh-cn'),
(1, 'site', 'setsecurity', 'zh-cn'),
(1, 'site', 'setsensitive', 'zh-cn'),
(1, 'nav', 'admin', 'zh-cn'),
(1, 'tag', 'admin', 'zh-cn'),
(1, 'tag', 'link', 'zh-cn'),
(1, 'links', 'admin', 'zh-cn'),
(1, 'mail', 'admin', 'zh-cn'),
(1, 'mail', 'detect', 'zh-cn'),
(1, 'mail', 'edit', 'zh-cn'),
(1, 'mail', 'save', 'zh-cn'),
(1, 'mail', 'test', 'zh-cn'),
(1, 'mail', 'reset', 'zh-cn'),
(1, 'wechat', 'admin', 'zh-cn'),
(1, 'wechat', 'create', 'zh-cn'),
(1, 'wechat', 'integrate', 'zh-cn'),
(1, 'wechat', 'edit', 'zh-cn'),
(1, 'wechat', 'delete', 'zh-cn'),
(1, 'wechat', 'adminResponse', 'zh-cn'),
(1, 'wechat', 'setResponse', 'zh-cn'),
(1, 'wechat', 'deleteResponse', 'zh-cn'),
(1, 'wechat', 'reply', 'zh-cn'),
(1, 'wechat', 'commitMenu', 'zh-cn'),
(1, 'wechat', 'deleteMenu', 'zh-cn'),
(1, 'wechat', 'message', 'zh-cn'),
(1, 'wechat', 'qrcode', 'zh-cn'),
(1, 'group', 'browse', 'zh-cn'),
(1, 'group', 'create', 'zh-cn'),
(1, 'group', 'edit', 'zh-cn'),
(1, 'group', 'copy', 'zh-cn'),
(1, 'group', 'delete', 'zh-cn'),
(1, 'group', 'managePriv', 'zh-cn'),
(1, 'group', 'manageMember', 'zh-cn'),
(1, 'ui', 'setTemplate', 'zh-cn'),
(1, 'ui', 'setDevice', 'zh-cn'),
(1, 'ui', 'customTheme', 'zh-cn'),
(1, 'ui', 'setLogo', 'zh-cn'),
(1, 'ui', 'setBaseStyle', 'zh-cn'),
(1, 'ui', 'deleteFavicon', 'zh-cn'),
(1, 'ui', 'deleteLogo', 'zh-cn'),
(1, 'ui', 'others', 'zh-cn'),
(1, 'ui', 'setCode', 'zh-cn'),
(1, 'slide', 'admin', 'zh-cn'),
(1, 'slide', 'create', 'zh-cn'),
(1, 'slide', 'edit', 'zh-cn'),
(1, 'slide', 'delete', 'zh-cn'),
(1, 'slide', 'sort', 'zh-cn'),
(1, 'slide', 'browse', 'zh-cn'),
(1, 'slide', 'createGroup', 'zh-cn'),
(1, 'slide', 'editGroup', 'zh-cn'),
(1, 'slide', 'removeGroup', 'zh-cn'),
(1, 'block', 'admin', 'zh-cn'),
(1, 'block', 'pages', 'zh-cn'),
(1, 'block', 'setregion', 'zh-cn'),
(1, 'block', 'create', 'zh-cn'),
(1, 'block', 'edit', 'zh-cn'),
(1, 'block', 'delete', 'zh-cn'),
(1, 'block', 'switchLayout', 'zh-cn'),
(1, 'block', 'cloneLayout', 'zh-cn'),
(1, 'block', 'removeLayout', 'zh-cn'),
(1, 'block', 'renameLayout', 'zh-cn'),
(1, 'company', 'setbasic', 'zh-cn'),
(1, 'company', 'setcontact', 'zh-cn'),
(1, 'user', 'admin', 'zh-cn'),
(1, 'user', 'edit', 'zh-cn'),
(1, 'user', 'forbid', 'zh-cn'),
(1, 'user', 'adminlog', 'zh-cn'),
(1, 'message', 'admin', 'zh-cn'),
(1, 'message', 'reply', 'zh-cn'),
(1, 'message', 'pass', 'zh-cn'),
(1, 'message', 'delete', 'zh-cn'),
(1, 'package', 'browse', 'zh-cn'),
(1, 'package', 'obtain', 'zh-cn'),
(1, 'package', 'install', 'zh-cn'),
(1, 'package', 'uninstall', 'zh-cn'),
(1, 'package', 'activate', 'zh-cn'),
(1, 'package', 'deactivate', 'zh-cn'),
(1, 'package', 'upload', 'zh-cn'),
(1, 'package', 'erase', 'zh-cn'),
(1, 'package', 'upgrade', 'zh-cn'),
(1, 'package', 'structure', 'zh-cn'),
(1, 'tree', 'browse', 'zh-cn'),
(1, 'tree', 'edit', 'zh-cn'),
(1, 'tree', 'children', 'zh-cn'),
(1, 'tree', 'delete', 'zh-cn'),
(1, 'tree', 'redirect', 'zh-cn'),
(1, 'file', 'browse', 'zh-cn'),
(1, 'file', 'setPrimary', 'zh-cn'),
(1, 'file', 'upload', 'zh-cn'),
(1, 'file', 'download', 'zh-cn'),
(1, 'file', 'edit', 'zh-cn'),
(1, 'file', 'sort', 'zh-cn'),
(1, 'file', 'fileManager', 'zh-cn'),
(1, 'file', 'delete', 'zh-cn'),
(1, 'file', 'sourceBrowse', 'zh-cn'),
(1, 'file', 'sourceDelete', 'zh-cn'),
(1, 'file', 'editSource', 'zh-cn'),
(1, 'file', 'selectImage', 'zh-cn'),
(1, 'file', 'browseSource', 'zh-cn'),
(1, 'search', 'buildIndex', 'zh-cn'),
(1, 'order', 'admin', 'zh-cn'),
(1, 'order', 'delivery', 'zh-cn'),
(1, 'order', 'finish', 'zh-cn'),
(1, 'order', 'pay', 'zh-cn'),
(1, 'order', 'setting', 'zh-cn'),
(1, 'order', 'deliveryInfo', 'zh-cn'),
(1, 'stat', 'traffic', 'zh-cn'),
(1, 'stat', 'from', 'zh-cn'),
(1, 'stat', 'search', 'zh-cn'),
(1, 'stat', 'client', 'zh-cn'),
(1, 'stat', 'keywords', 'zh-cn'),
(1, 'stat', 'keywordReport', 'zh-cn'),
(1, 'stat', 'domainList', 'zh-cn'),
(1, 'stat', 'domainTrend', 'zh-cn'),
(1, 'stat', 'domainPage', 'zh-cn'),
(1, 'stat', 'page', 'zh-cn'),
(1, 'stat', 'ignoreKeyword', 'zh-cn'),
(1, 'score', 'setCounts', 'zh-cn'),
(2, 'file', 'fileManager', 'zh-cn'),
(2, 'file', 'sort', 'zh-cn'),
(2, 'file', 'download', 'zh-cn'),
(2, 'file', 'edit', 'zh-cn'),
(2, 'file', 'upload', 'zh-cn'),
(2, 'file', 'setPrimary', 'zh-cn'),
(2, 'file', 'browse', 'zh-cn'),
(2, 'file', 'sourceBrowse', 'zh-cn'),
(2, 'file', 'sourceDelete', 'zh-cn'),
(2, 'file', 'editSource', 'zh-cn'),
(2, 'file', 'selectImage', 'zh-cn'),
(2, 'file', 'browseSource', 'zh-cn'),
(2, 'ui', 'setTemplate', 'zh-cn'),
(2, 'ui', 'setDevice', 'zh-cn'),
(2, 'tag', 'link', 'zh-cn'),
(2, 'site', 'setRecPerPage', 'zh-cn'),
(2, 'links', 'admin', 'zh-cn'),
(2, 'tag', 'admin', 'zh-cn'),
(2, 'nav', 'admin', 'zh-cn'),
(2, 'site', 'setLang', 'zh-cn'),
(2, 'site', 'setBasic', 'zh-cn'),
(2, 'book', 'delete', 'zh-cn'),
(2, 'company', 'setbasic', 'zh-cn'),
(2, 'block', 'delete', 'zh-cn'),
(2, 'block', 'edit', 'zh-cn'),
(2, 'block', 'setregion', 'zh-cn'),
(2, 'block', 'pages', 'zh-cn'),
(2, 'block', 'create', 'zh-cn'),
(2, 'book', 'sort', 'zh-cn'),
(2, 'book', 'edit', 'zh-cn'),
(2, 'ui', 'customTheme', 'zh-cn'),
(2, 'product', 'setcss', 'zh-cn'),
(2, 'product', 'delete', 'zh-cn'),
(2, 'ui', 'setLogo', 'zh-cn'),
(2, 'article', 'admin', 'zh-cn'),
(2, 'article', 'stick', 'zh-cn'),
(2, 'article', 'create', 'zh-cn'),
(2, 'article', 'delete', 'zh-cn'),
(2, 'article', 'edit', 'zh-cn'),
(2, 'article', 'setjs', 'zh-cn'),
(2, 'article', 'setcss', 'zh-cn'),
(2, 'article', 'forward2Forum', 'zh-cn'),
(2, 'article', 'forward2Blog', 'zh-cn'),
(2, 'article', 'check', 'zh-cn'),
(2, 'article', 'reject', 'zh-cn'),
(2, 'book', 'create', 'zh-cn'),
(2, 'book', 'catalog', 'zh-cn'),
(2, 'book', 'admin', 'zh-cn'),
(2, 'product', 'setjs', 'zh-cn'),
(2, 'tree', 'redirect', 'zh-cn'),
(2, 'tree', 'browse', 'zh-cn'),
(2, 'company', 'setcontact', 'zh-cn'),
(2, 'tree', 'delete', 'zh-cn'),
(2, 'tree', 'edit', 'zh-cn'),
(2, 'tree', 'children', 'zh-cn'),
(2, 'block', 'admin', 'zh-cn'),
(2, 'slide', 'sort', 'zh-cn'),
(2, 'product', 'currency', 'zh-cn'),
(2, 'product', 'create', 'zh-cn'),
(2, 'product', 'changeStatus', 'zh-cn'),
(2, 'product', 'edit', 'zh-cn'),
(2, 'product', 'admin', 'zh-cn'),
(2, 'slide', 'delete', 'zh-cn'),
(2, 'ui', 'deleteFavicon', 'zh-cn'),
(2, 'ui', 'setBaseStyle', 'zh-cn'),
(2, 'slide', 'create', 'zh-cn'),
(2, 'slide', 'admin', 'zh-cn'),
(2, 'ui', 'deleteLogo', 'zh-cn'),
(2, 'ui', 'others', 'zh-cn'),
(2, 'slide', 'edit', 'zh-cn'),
(2, 'file', 'delete', 'zh-cn'),
(3, 'message', 'delete', 'zh-cn'),
(3, 'reply', 'delete', 'zh-cn'),
(3, 'message', 'pass', 'zh-cn'),
(3, 'message', 'reply', 'zh-cn'),
(3, 'message', 'admin', 'zh-cn'),
(3, 'thread', 'deleteFile', 'zh-cn'),
(3, 'reply', 'edit', 'zh-cn'),
(3, 'forum', 'admin', 'zh-cn'),
(3, 'reply', 'admin', 'zh-cn'),
(3, 'forum', 'update', 'zh-cn'),
(3, 'article', 'admin', 'zh-cn'),
(3, 'product', 'admin', 'zh-cn'),
(3, 'book', 'catalog', 'zh-cn'),
(3, 'book', 'admin', 'zh-cn'),
(3, 'thread', 'delete', 'zh-cn'),
(3, 'reply', 'deleteFile', 'zh-cn'),
(3, 'thread', 'transfer', 'zh-cn'),
(3, 'thread', 'switchStatus', 'zh-cn');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]history`
--
CREATE TABLE `[[dbprefix]]history` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`action` mediumint(8) unsigned NOT NULL DEFAULT '0',
`field` varchar(30) NOT NULL DEFAULT '',
`old` text NOT NULL,
`new` text NOT NULL,
`diff` mediumtext NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `action` (`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]im_chat`
--
CREATE TABLE `[[dbprefix]]im_chat` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`gid` char(40) NOT NULL DEFAULT '',
`name` varchar(60) NOT NULL DEFAULT '',
`type` varchar(20) NOT NULL DEFAULT 'group',
`admins` varchar(255) NOT NULL DEFAULT '',
`committers` varchar(255) NOT NULL DEFAULT '',
`subject` mediumint(8) unsigned NOT NULL DEFAULT '0',
`public` enum('0','1') NOT NULL DEFAULT '0',
`createdBy` varchar(30) NOT NULL DEFAULT '',
`createdDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editedBy` varchar(30) NOT NULL DEFAULT '',
`editedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastActiveTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`dismissDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lang` char(30) NOT NULL DEFAULT 'all',
PRIMARY KEY (`id`),
KEY `gid` (`gid`),
KEY `name` (`name`),
KEY `type` (`type`),
KEY `public` (`public`),
KEY `createdBy` (`createdBy`),
KEY `editedBy` (`editedBy`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]im_chatuser`
--
CREATE TABLE `[[dbprefix]]im_chatuser` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cgid` char(40) NOT NULL DEFAULT '',
`user` mediumint(8) NOT NULL DEFAULT '0',
`order` smallint(5) NOT NULL DEFAULT '0',
`star` enum('0','1') NOT NULL DEFAULT '0',
`hide` enum('0','1') NOT NULL DEFAULT '0',
`mute` enum('0','1') NOT NULL DEFAULT '0',
`join` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`quit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`category` varchar(40) NOT NULL DEFAULT '',
`lang` char(30) NOT NULL DEFAULT 'all',
PRIMARY KEY (`id`),
UNIQUE KEY `chatuser` (`cgid`,`user`),
KEY `cgid` (`cgid`),
KEY `user` (`user`),
KEY `order` (`order`),
KEY `star` (`star`),
KEY `hide` (`hide`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]im_client`
--
CREATE TABLE `[[dbprefix]]im_client` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`version` char(10) NOT NULL DEFAULT '',
`desc` varchar(100) NOT NULL DEFAULT '',
`changeLog` text NOT NULL,
`strategy` varchar(10) NOT NULL DEFAULT '',
`downloads` text NOT NULL,
`createdDate` datetime NOT NULL,
`createdBy` varchar(30) NOT NULL DEFAULT '',
`editedDate` datetime NOT NULL,
`editedBy` varchar(30) NOT NULL DEFAULT '',
`status` enum('released','wait') NOT NULL DEFAULT 'wait',
`lang` char(30) NOT NULL DEFAULT 'all',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]im_message`
--
CREATE TABLE `[[dbprefix]]im_message` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`gid` char(40) NOT NULL DEFAULT '',
`cgid` char(40) NOT NULL DEFAULT '',
`user` varchar(30) NOT NULL DEFAULT '',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`order` bigint(8) unsigned NOT NULL,
`type` enum('normal','broadcast','notify') NOT NULL DEFAULT 'normal',
`content` text NOT NULL,
`contentType` enum('text','plain','emotion','image','file','object') NOT NULL DEFAULT 'text',
`data` text NOT NULL,
`lang` char(30) NOT NULL DEFAULT 'all',
PRIMARY KEY (`id`),
KEY `mgid` (`gid`),
KEY `mcgid` (`cgid`),
KEY `muser` (`user`),
KEY `mtype` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]im_messagestatus`
--
CREATE TABLE `[[dbprefix]]im_messagestatus` (
`user` mediumint(8) NOT NULL DEFAULT '0',
`message` int(11) unsigned NOT NULL,
`gid` char(40) NOT NULL DEFAULT '',
`status` enum('waiting','sent','readed','deleted') NOT NULL DEFAULT 'waiting',
`lang` char(30) NOT NULL DEFAULT 'all',
UNIQUE KEY `user` (`user`,`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]layout`
--
CREATE TABLE `[[dbprefix]]layout` (
`template` varchar(30) NOT NULL DEFAULT 'default',
`theme` char(30) NOT NULL DEFAULT 'default',
`page` varchar(30) NOT NULL,
`region` varchar(30) NOT NULL,
`object` varchar(30) NOT NULL,
`blocks` text NOT NULL,
`import` enum('no','doing','finished') NOT NULL DEFAULT 'no',
`lang` char(30) NOT NULL,
UNIQUE KEY `layout` (`template`,`theme`,`page`,`region`,`object`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]layout`
--
INSERT INTO `[[dbprefix]]layout` VALUES
('default', 'default', 'all', 'top', '', '[{"id":"13","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'index_index', 'top', '', '[{"id":"5","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'index_index', 'middle', '', '[{"id":"3","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"11","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"1","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'index_index', 'bottom', '', '[{"id":"12","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'company_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"14","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'article_browse', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'article_view', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'product_browse', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'product_view', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'message_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'blog_index', 'side', '', '[{"id":"15","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'blog_view', 'side', '', '[{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'page_index', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'page_view', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'default', 'all', 'top', '', '[{"id":"113","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'index_index', 'top', '', '[{"id":"105","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'index_index', 'middle', '', '[{"id":"103","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"111","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"101","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'index_index', 'bottom', '', '[{"id":"112","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'company_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"114","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'article_browse', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'article_view', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'product_browse', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'product_view', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'message_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'blog_index', 'side', '', '[{"id":"115","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'blog_view', 'side', '', '[{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'page_index', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'page_view', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'default', 'all', 'top', '', '[{"id":"213","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'index_index', 'top', '', '[{"id":"205","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'index_index', 'middle', '', '[{"id":"203","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"211","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"201","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'index_index', 'bottom', '', '[{"id":"212","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'company_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"214","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'article_browse', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'article_view', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'product_browse', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'product_view', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'message_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'blog_index', 'side', '', '[{"id":"215","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'blog_view', 'side', '', '[{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'page_index', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'default', 'page_view', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('mobile', 'default', 'all', 'top', '', '[{"id":"34","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('mobile', 'default', 'index_index', 'top', '', '[{"id":"25","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-cn'),
('mobile', 'default', 'index_index', 'middle', '', '[{"id":"31","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"23","grid":"12","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"21","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-cn'),
('mobile', 'default', 'all', 'top', '', '[{"id":"134","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('mobile', 'default', 'index_index', 'top', '', '[{"id":"125","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'en'),
('mobile', 'default', 'index_index', 'middle', '', '[{"id":"131","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"123","grid":"12","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"121","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'en'),
('mobile', 'default', 'all', 'top', '', '[{"id":"234","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('mobile', 'default', 'index_index', 'top', '', '[{"id":"225","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-tw'),
('mobile', 'default', 'index_index', 'middle', '', '[{"id":"231","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"223","grid":"12","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"221","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-tw'),
('default', 'tartan', 'all', 'top', '', '[{"id":"113","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'all', 'top', '', '[{"id":"13","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'all', 'top', '', '[{"id":"213","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'article_browse', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'article_browse', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'article_browse', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'article_view', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'article_view', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'article_view', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'blog_index', 'side', '', '[{"id":"115","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'blog_index', 'side', '', '[{"id":"15","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'blog_index', 'side', '', '[{"id":"215","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'blog_view', 'side', '', '[{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'blog_view', 'side', '', '[{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'blog_view', 'side', '', '[{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'company_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"114","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'company_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"14","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'company_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"214","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'index_index', 'bottom', '', '[{"id":"112","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'index_index', 'bottom', '', '[{"id":"12","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'index_index', 'bottom', '', '[{"id":"212","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'index_index', 'middle', '', '[{"id":"103","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"111","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"101","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'index_index', 'middle', '', '[{"id":"3","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"11","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"1","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'index_index', 'middle', '', '[{"id":"203","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"211","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"201","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'index_index', 'top', '', '[{"id":"105","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'index_index', 'top', '', '[{"id":"5","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'index_index', 'top', '', '[{"id":"205","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'message_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'message_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'message_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'page_index', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'page_index', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'page_index', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'page_view', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'page_view', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'page_view', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'product_browse', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'product_browse', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'product_browse', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'tartan', 'product_view', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'tartan', 'product_view', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'tartan', 'product_view', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'all', 'top', '', '[{"id":"113","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'all', 'top', '', '[{"id":"13","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'all', 'top', '', '[{"id":"213","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'article_browse', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'article_browse', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'article_browse', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'article_view', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'article_view', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'article_view', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'blog_index', 'side', '', '[{"id":"115","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'blog_index', 'side', '', '[{"id":"15","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'blog_index', 'side', '', '[{"id":"215","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'blog_view', 'side', '', '[{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'blog_view', 'side', '', '[{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'blog_view', 'side', '', '[{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'company_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"114","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'company_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"14","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'company_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"214","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'index_index', 'bottom', '', '[{"id":"112","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'index_index', 'bottom', '', '[{"id":"12","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'index_index', 'bottom', '', '[{"id":"212","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'index_index', 'middle', '', '[{"id":"103","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"111","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"101","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'index_index', 'middle', '', '[{"id":"3","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"11","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"1","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'index_index', 'middle', '', '[{"id":"203","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"211","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"201","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'index_index', 'top', '', '[{"id":"105","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'index_index', 'top', '', '[{"id":"5","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'index_index', 'top', '', '[{"id":"205","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'message_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'message_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'message_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'page_index', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'page_index', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'page_index', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'page_view', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'page_view', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'page_view', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'product_browse', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'product_browse', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'product_browse', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'clean', 'product_view', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'clean', 'product_view', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'clean', 'product_view', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'all', 'top', '', '[{"id":"113","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'all', 'top', '', '[{"id":"13","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'all', 'top', '', '[{"id":"213","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'article_browse', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'article_browse', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'article_browse', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'article_view', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'article_view', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'article_view', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'blog_index', 'side', '', '[{"id":"115","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'blog_index', 'side', '', '[{"id":"15","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'blog_index', 'side', '', '[{"id":"215","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'blog_view', 'side', '', '[{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'blog_view', 'side', '', '[{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'blog_view', 'side', '', '[{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'company_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"114","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'company_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"14","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'company_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"214","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'index_index', 'bottom', '', '[{"id":"112","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'index_index', 'bottom', '', '[{"id":"12","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'index_index', 'bottom', '', '[{"id":"212","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'index_index', 'middle', '', '[{"id":"103","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"111","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"101","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'index_index', 'middle', '', '[{"id":"3","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"11","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"1","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'index_index', 'middle', '', '[{"id":"203","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"211","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"201","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'index_index', 'top', '', '[{"id":"105","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'index_index', 'top', '', '[{"id":"5","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'index_index', 'top', '', '[{"id":"205","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'message_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'message_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'message_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'page_index', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'page_index', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'page_index', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'page_view', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'page_view', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'page_view', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'product_browse', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'product_browse', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'product_browse', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'wide', 'product_view', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'wide', 'product_view', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'wide', 'product_view', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'all', 'top', '', '[{"id":"113","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'all', 'top', '', '[{"id":"13","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'all', 'top', '', '[{"id":"213","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'article_browse', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'article_browse', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'article_browse', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'article_view', 'side', '', '[{"id":"106","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'article_view', 'side', '', '[{"id":"6","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'article_view', 'side', '', '[{"id":"206","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'blog_index', 'side', '', '[{"id":"115","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'blog_index', 'side', '', '[{"id":"15","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'blog_index', 'side', '', '[{"id":"215","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'blog_view', 'side', '', '[{"id":"108","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'blog_view', 'side', '', '[{"id":"8","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'blog_view', 'side', '', '[{"id":"208","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'company_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"114","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'company_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"14","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'company_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"214","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'index_index', 'bottom', '', '[{"id":"112","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'index_index', 'bottom', '', '[{"id":"12","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'index_index', 'bottom', '', '[{"id":"212","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'index_index', 'middle', '', '[{"id":"103","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"111","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"101","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'index_index', 'middle', '', '[{"id":"3","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"11","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"1","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'index_index', 'middle', '', '[{"id":"203","grid":12,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"211","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"201","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":4,"probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'index_index', 'top', '', '[{"id":"105","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'index_index', 'top', '', '[{"id":"5","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'index_index', 'top', '', '[{"id":"205","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'message_index', 'side', '', '[{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'message_index', 'side', '', '[{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'message_index', 'side', '', '[{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'page_index', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'page_index', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'page_index', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'page_view', 'side', '', '[{"id":"109","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"102","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'page_view', 'side', '', '[{"id":"9","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"2","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'page_view', 'side', '', '[{"id":"209","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"202","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw');
INSERT INTO `[[dbprefix]]layout` VALUES
('default', 'blank', 'product_browse', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'product_browse', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'product_browse', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('default', 'blank', 'product_view', 'side', '', '[{"id":"104","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"107","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"110","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('default', 'blank', 'product_view', 'side', '', '[{"id":"4","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"7","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"10","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('default', 'blank', 'product_view', 'side', '', '[{"id":"204","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"207","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0},{"id":"210","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('mobile', 'colorful', 'all', 'top', '', '[{"id":"134","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'en'),
('mobile', 'colorful', 'all', 'top', '', '[{"id":"34","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-cn'),
('mobile', 'colorful', 'all', 'top', '', '[{"id":"234","grid":"","probability":"","isRandom":"","titleless":0,"borderless":0}]', 'no', 'zh-tw'),
('mobile', 'colorful', 'index_index', 'middle', '', '[{"id":"131","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"123","grid":"12","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"121","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'en'),
('mobile', 'colorful', 'index_index', 'middle', '', '[{"id":"31","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"23","grid":"12","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"21","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-cn'),
('mobile', 'colorful', 'index_index', 'middle', '', '[{"id":"231","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"223","grid":"12","probability":"","isRandom":"","titleless":"0","borderless":"0"},{"id":"221","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-tw'),
('mobile', 'colorful', 'index_index', 'top', '', '[{"id":"125","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'en'),
('mobile', 'colorful', 'index_index', 'top', '', '[{"id":"25","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-cn'),
('mobile', 'colorful', 'index_index', 'top', '', '[{"id":"225","grid":"0","probability":"","isRandom":"","titleless":"0","borderless":"0"}]', 'no', 'zh-tw');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]log`
--
CREATE TABLE `[[dbprefix]]log` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`account` char(30) NOT NULL,
`browser` char(100) NOT NULL,
`ip` char(40) NOT NULL,
`location` char(100) NOT NULL,
`date` datetime NOT NULL,
`desc` text NOT NULL,
`ext` text NOT NULL,
`type` varchar(30) NOT NULL DEFAULT 'adminlogin',
`lang` char(30) NOT NULL DEFAULT 'all',
PRIMARY KEY (`id`),
KEY `ip` (`ip`),
KEY `lang` (`lang`),
KEY `type` (`type`),
KEY `account` (`account`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]message`
--
CREATE TABLE `[[dbprefix]]message` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`type` char(20) NOT NULL,
`objectType` varchar(30) NOT NULL DEFAULT '',
`objectID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`account` char(30) NOT NULL,
`from` char(30) NOT NULL,
`to` char(30) NOT NULL,
`phone` char(30) NOT NULL,
`mobile` char(11) NOT NULL,
`email` varchar(90) NOT NULL,
`qq` char(30) NOT NULL,
`date` datetime NOT NULL,
`content` text NOT NULL,
`link` varchar(100) NOT NULL,
`ip` varchar(40) NOT NULL,
`status` char(20) NOT NULL,
`public` enum('0','1') NOT NULL DEFAULT '1',
`readed` enum('0','1') NOT NULL,
`receiveEmail` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `status` (`status`),
KEY `type` (`type`),
KEY `to` (`to`),
KEY `account` (`account`),
KEY `readed` (`readed`),
KEY `object` (`objectType`,`objectID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]oauth`
--
CREATE TABLE `[[dbprefix]]oauth` (
`account` varchar(30) NOT NULL,
`provider` varchar(30) NOT NULL,
`openID` varchar(60) NOT NULL,
`unionID` varchar(60) NOT NULL,
`lang` char(30) NOT NULL,
`sessionKey` varchar(60) NOT NULL,
UNIQUE KEY `account` (`account`,`provider`,`openID`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]operationlog`
--
CREATE TABLE `[[dbprefix]]operationlog` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`type` varchar(30) NOT NULL,
`identity` varchar(100) NOT NULL,
`operation` varchar(200) NOT NULL,
`count` smallint(5) unsigned NOT NULL DEFAULT '0',
`createdTime` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `operation` (`type`,`identity`,`operation`,`createdTime`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]order`
--
CREATE TABLE `[[dbprefix]]order` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`humanID` char(13) NOT NULL,
`account` char(30) NOT NULL,
`amount` decimal(10,2) NOT NULL DEFAULT '0.00',
`score` mediumint(8) unsigned NOT NULL,
`balance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`payment` char(30) NOT NULL,
`sn` char(50) NOT NULL,
`refundSN` char(50) NOT NULL,
`address` text NOT NULL,
`note` text NOT NULL,
`createdDate` datetime NOT NULL,
`paidDate` datetime NOT NULL,
`payStatus` enum('not_paid','paid','refunding','refunded') NOT NULL DEFAULT 'not_paid',
`deliveriedDate` datetime NOT NULL,
`deliveriedBy` char(30) NOT NULL,
`deliveryStatus` enum('not_send','send','confirmed') NOT NULL DEFAULT 'not_send',
`waybill` char(30) NOT NULL,
`express` char(30) NOT NULL,
`track` text NOT NULL,
`confirmedDate` datetime NOT NULL,
`finishedDate` datetime NOT NULL,
`finishedBy` char(30) NOT NULL,
`status` enum('normal','canceled','finished','deleted','expired') NOT NULL DEFAULT 'normal',
`cancelReason` text NOT NULL,
`last` datetime NOT NULL,
`type` varchar(30) NOT NULL DEFAULT 'shop',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `status` (`status`),
KEY `createdDate` (`createdDate`),
KEY `deliveriedDate` (`deliveriedDate`),
KEY `deliveryStatus` (`deliveryStatus`),
KEY `payStatus` (`payStatus`),
KEY `type` (`type`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]order_api`
--
CREATE TABLE `[[dbprefix]]order_api` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`action` char(30) NOT NULL,
`url` text NOT NULL,
`debug` enum('0','1') NOT NULL DEFAULT '0',
`method` enum('get','post') NOT NULL DEFAULT 'get',
`params` text NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `action` (`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]order_product`
--
CREATE TABLE `[[dbprefix]]order_product` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`orderID` mediumint(9) unsigned NOT NULL DEFAULT '0',
`productID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`productName` varchar(150) NOT NULL,
`price` decimal(8,2) NOT NULL DEFAULT '0.00',
`score` mediumint(8) unsigned NOT NULL,
`count` smallint(5) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
`extra` text NOT NULL,
PRIMARY KEY (`id`),
KEY `orderID` (`orderID`),
KEY `productID` (`productID`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]package`
--
CREATE TABLE `[[dbprefix]]package` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`code` varchar(30) NOT NULL,
`version` varchar(50) NOT NULL,
`author` varchar(100) NOT NULL,
`desc` text NOT NULL,
`license` text NOT NULL,
`type` varchar(20) NOT NULL DEFAULT 'extension',
`site` varchar(150) NOT NULL,
`chanzhiCompatible` varchar(100) NOT NULL,
`templateCompatible` varchar(100) NOT NULL,
`installedTime` datetime NOT NULL,
`depends` varchar(100) NOT NULL,
`dirs` text NOT NULL,
`files` text NOT NULL,
`status` varchar(20) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`),
KEY `lang` (`lang`),
KEY `type` (`type`),
KEY `addedTime` (`installedTime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]product`
--
CREATE TABLE `[[dbprefix]]product` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`titleColor` varchar(10) NOT NULL,
`alias` varchar(100) NOT NULL,
`unsaleable` enum('0','1') NOT NULL DEFAULT '0',
`mall` text NOT NULL,
`brand` varchar(100) DEFAULT NULL,
`model` char(30) DEFAULT NULL,
`color` char(20) NOT NULL,
`origin` varchar(50) NOT NULL,
`unit` char(20) NOT NULL,
`price` decimal(10,2) NOT NULL,
`negotiate` enum('0','1') NOT NULL DEFAULT '0',
`promotion` decimal(10,2) NOT NULL,
`amount` mediumint(8) unsigned DEFAULT NULL,
`stockWarning` char(20) NOT NULL,
`keywords` varchar(150) NOT NULL,
`desc` text NOT NULL,
`content` text NOT NULL,
`author` varchar(60) NOT NULL,
`editor` varchar(60) NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`status` varchar(20) NOT NULL DEFAULT 'normal',
`views` int(11) unsigned NOT NULL DEFAULT '0',
`sticky` enum('0','1','2','3') NOT NULL DEFAULT '0',
`order` smallint(5) unsigned NOT NULL,
`css` text NOT NULL,
`js` text NOT NULL,
`lang` char(30) NOT NULL,
`scoreLimit` mediumint(8) NOT NULL DEFAULT '0',
`isGift` tinyint(3) NOT NULL DEFAULT '0',
`score` mediumint(8) NOT NULL DEFAULT '0',
`exchangeLimit` mediumint(8) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `order` (`order`),
KEY `views` (`views`),
KEY `sticky` (`sticky`),
KEY `status` (`status`),
KEY `model` (`model`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]product_attribute`
--
CREATE TABLE `[[dbprefix]]product_attribute` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`product` mediumint(9) NOT NULL,
`attribute` char(30) NOT NULL,
`value` varchar(255) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]product_custom`
--
CREATE TABLE `[[dbprefix]]product_custom` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`product` mediumint(8) unsigned NOT NULL DEFAULT '0',
`label` varchar(100) NOT NULL,
`value` varchar(200) NOT NULL,
`order` smallint(5) unsigned NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `label` (`product`,`label`),
KEY `lang` (`lang`),
KEY `product` (`product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]product_price`
--
CREATE TABLE `[[dbprefix]]product_price` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`type` char(30) NOT NULL,
`product` mediumint(9) NOT NULL,
`attribute` char(30) NOT NULL,
`value` varchar(255) NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `attribute` (`attribute`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]question`
--
CREATE TABLE `[[dbprefix]]question` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`category` smallint(5) unsigned NOT NULL,
`account` varchar(30) NOT NULL,
`title` varchar(255) NOT NULL,
`desc` text NOT NULL,
`score` tinyint(3) unsigned NOT NULL,
`comment` text NOT NULL,
`status` varchar(30) NOT NULL,
`addedDate` datetime NOT NULL,
`closedDate` datetime NOT NULL,
`views` smallint(5) unsigned NOT NULL,
`answers` tinyint(3) unsigned NOT NULL,
`bestAnswer` mediumint(8) unsigned NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `category` (`category`),
KEY `account` (`account`),
KEY `title` (`title`),
KEY `score` (`score`),
KEY `status` (`status`),
KEY `answers` (`answers`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]relation`
--
CREATE TABLE `[[dbprefix]]relation` (
`type` char(20) NOT NULL,
`id` mediumint(9) NOT NULL,
`category` smallint(5) NOT NULL,
`lang` char(30) NOT NULL,
UNIQUE KEY `relation` (`type`,`id`,`category`),
KEY `lang` (`lang`),
KEY `id` (`id`),
KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]reply`
--
CREATE TABLE `[[dbprefix]]reply` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`thread` mediumint(8) unsigned NOT NULL,
`reply` mediumint(8) unsigned NOT NULL,
`content` text NOT NULL,
`author` char(30) NOT NULL,
`editor` char(30) NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`hidden` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `thread` (`thread`),
KEY `reply` (`reply`),
KEY `hidden` (`hidden`),
KEY `editedDate` (`editedDate`),
KEY `author` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]request`
--
CREATE TABLE `[[dbprefix]]request` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`product` mediumint(8) unsigned NOT NULL,
`category` mediumint(8) unsigned NOT NULL,
`customer` char(30) NOT NULL,
`assignedTo` char(30) NOT NULL,
`pri` tinyint(3) unsigned DEFAULT NULL,
`title` varchar(255) NOT NULL,
`desc` text NOT NULL,
`status` varchar(30) NOT NULL,
`addedDate` datetime NOT NULL,
`viewedDate` datetime NOT NULL,
`assignedDate` datetime NOT NULL,
`repliedBy` char(30) NOT NULL,
`repliedDate` datetime NOT NULL,
`lastEditedDate` datetime NOT NULL,
`closedDate` datetime NOT NULL,
`closedBy` char(30) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]score`
--
CREATE TABLE `[[dbprefix]]score` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(30) NOT NULL,
`method` varchar(30) NOT NULL,
`type` varchar(10) NOT NULL,
`count` smallint(5) unsigned NOT NULL,
`before` mediumint(5) NOT NULL,
`after` mediumint(5) NOT NULL,
`objectType` varchar(30) NOT NULL,
`objectID` mediumint(9) NOT NULL,
`actor` varchar(30) NOT NULL,
`note` varchar(255) NOT NULL,
`time` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`),
KEY `method` (`method`),
KEY `lang` (`lang`),
KEY `objectType` (`objectType`),
KEY `objectID` (`objectID`),
KEY `time` (`time`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]search_dict`
--
CREATE TABLE `[[dbprefix]]search_dict` (
`key` smallint(5) unsigned NOT NULL,
`value` char(3) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`key`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]search_index`
--
CREATE TABLE `[[dbprefix]]search_index` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`objectType` char(20) NOT NULL,
`objectID` mediumint(9) NOT NULL,
`title` text NOT NULL,
`content` text NOT NULL,
`params` text NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`status` char(30) NOT NULL DEFAULT 'normal',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `object` (`objectType`,`objectID`),
KEY `lang` (`lang`),
KEY `addedDate` (`addedDate`),
FULLTEXT KEY `content` (`title`,`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]service`
--
CREATE TABLE `[[dbprefix]]service` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`customer` char(30) NOT NULL,
`product` mediumint(8) NOT NULL,
`endTime` date NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]slide`
--
CREATE TABLE `[[dbprefix]]slide` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`group` smallint(5) unsigned NOT NULL,
`title` varchar(60) NOT NULL,
`titleColor` char(10) NOT NULL,
`mainLink` varchar(255) NOT NULL,
`target` enum('0','1') NOT NULL DEFAULT '0',
`backgroundType` char(20) NOT NULL,
`backgroundColor` char(10) NOT NULL,
`height` smallint(5) unsigned NOT NULL DEFAULT '0',
`image` varchar(100) NOT NULL,
`label` varchar(255) NOT NULL,
`buttonClass` varchar(255) NOT NULL,
`buttonUrl` varchar(255) NOT NULL,
`buttonTarget` varchar(30) NOT NULL,
`summary` text NOT NULL,
`createdDate` datetime NOT NULL,
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `group` (`group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]statlog`
--
CREATE TABLE `[[dbprefix]]statlog` (
`id` int(9) unsigned NOT NULL AUTO_INCREMENT,
`referer` int(8) NOT NULL,
`domain` varchar(200) NOT NULL,
`url` text NOT NULL,
`link` text NOT NULL,
`searchEngine` varchar(100) NOT NULL,
`keywords` varchar(100) NOT NULL,
`visitor` int(8) NOT NULL,
`osName` varchar(100) NOT NULL,
`browserName` varchar(100) NOT NULL,
`browserVersion` varchar(100) NOT NULL,
`ip` char(40) NOT NULL,
`country` varchar(100) NOT NULL,
`province` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`account` char(30) NOT NULL,
`year` char(4) NOT NULL,
`month` char(6) NOT NULL,
`day` char(8) NOT NULL,
`hour` char(10) NOT NULL DEFAULT '0',
`new` tinyint(3) unsigned NOT NULL DEFAULT '1',
`mobile` tinyint(3) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `ip` (`ip`),
KEY `referer` (`referer`),
KEY `searchEngine` (`searchEngine`),
KEY `keywords` (`keywords`),
KEY `time` (`year`,`month`,`day`,`hour`),
KEY `location` (`country`,`province`,`city`),
KEY `mobile` (`mobile`),
KEY `lang` (`lang`),
KEY `month_lang` (`month`,`lang`),
KEY `day_lang` (`day`,`lang`),
KEY `hour_lang` (`hour`,`lang`),
KEY `osName` (`osName`),
KEY `browserName` (`browserName`),
KEY `year` (`year`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]statreferer`
--
CREATE TABLE `[[dbprefix]]statreferer` (
`id` int(9) unsigned NOT NULL AUTO_INCREMENT,
`url` text NOT NULL,
`domain` varchar(200) NOT NULL,
`searchEngine` char(30) NOT NULL,
`keywords` char(100) NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`(255)),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]statregion`
--
CREATE TABLE `[[dbprefix]]statregion` (
`id` int(9) unsigned NOT NULL AUTO_INCREMENT,
`timeType` enum('year','month','day','hour') NOT NULL DEFAULT 'hour',
`timeValue` char(10) NOT NULL DEFAULT '0',
`country` varchar(100) NOT NULL,
`province` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`pv` mediumint(9) unsigned NOT NULL DEFAULT '0',
`uv` mediumint(9) unsigned NOT NULL DEFAULT '0',
`ip` mediumint(9) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `region` (`country`,`province`,`city`),
KEY `time` (`timeType`,`timeValue`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]statreport`
--
CREATE TABLE `[[dbprefix]]statreport` (
`id` int(9) unsigned NOT NULL AUTO_INCREMENT,
`type` char(30) NOT NULL,
`item` char(100) NOT NULL DEFAULT '0',
`extra` text NOT NULL,
`timeType` enum('year','month','day','hour') NOT NULL DEFAULT 'hour',
`timeValue` char(10) NOT NULL DEFAULT '0',
`pv` mediumint(9) unsigned NOT NULL DEFAULT '0',
`uv` mediumint(9) unsigned NOT NULL DEFAULT '0',
`ip` mediumint(9) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`timeType`,`timeValue`),
KEY `type` (`type`,`item`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]statvisitor`
--
CREATE TABLE `[[dbprefix]]statvisitor` (
`id` int(9) unsigned NOT NULL AUTO_INCREMENT,
`osName` varchar(100) NOT NULL,
`osVersion` varchar(100) NOT NULL,
`browserName` varchar(100) NOT NULL,
`browserVersion` varchar(100) NOT NULL,
`browserLanguage` varchar(100) NOT NULL,
`device` varchar(100) NOT NULL,
`resolution` varchar(100) NOT NULL,
`createdTime` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `osName` (`osName`),
KEY `browsername` (`browserName`),
KEY `device` (`device`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tag`
--
CREATE TABLE `[[dbprefix]]tag` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`tag` varchar(50) NOT NULL,
`link` varchar(100) NOT NULL,
`rank` smallint(5) unsigned NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `tag` (`tag`),
KEY `rank` (`rank`),
KEY `link` (`link`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]thread`
--
CREATE TABLE `[[dbprefix]]thread` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`board` mediumint(9) NOT NULL,
`title` varchar(255) NOT NULL,
`discussion` enum('0','1') NOT NULL DEFAULT '0',
`color` char(10) NOT NULL,
`content` text NOT NULL,
`author` varchar(60) NOT NULL,
`editor` varchar(60) NOT NULL,
`addedDate` datetime NOT NULL,
`editedDate` datetime NOT NULL,
`readonly` tinyint(1) NOT NULL DEFAULT '0',
`views` int(11) unsigned NOT NULL DEFAULT '0',
`stick` enum('0','1','2','3') NOT NULL DEFAULT '0',
`stickTime` datetime NOT NULL,
`stickBold` enum('0','1') NOT NULL DEFAULT '0',
`replies` smallint(6) NOT NULL,
`repliedBy` varchar(30) NOT NULL,
`repliedDate` datetime NOT NULL,
`replyID` mediumint(8) unsigned NOT NULL,
`hidden` enum('0','1') NOT NULL DEFAULT '0',
`link` varchar(255) NOT NULL,
`lang` char(30) NOT NULL,
`status` char(10) NOT NULL,
`ip` char(40) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `category` (`board`),
KEY `hidden` (`hidden`),
KEY `status` (`status`),
KEY `addedDate` (`addedDate`),
KEY `stick` (`stick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]user`
--
CREATE TABLE `[[dbprefix]]user` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`dept` mediumint(8) unsigned NOT NULL,
`account` char(30) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`role` char(30) NOT NULL,
`token` char(32) NOT NULL,
`realname` char(30) NOT NULL DEFAULT '',
`realnames` varchar(100) NOT NULL DEFAULT '',
`nickname` char(60) NOT NULL DEFAULT '',
`idcard` char(18) NOT NULL,
`admin` enum('no','common','super') NOT NULL DEFAULT 'no',
`avatar` char(30) NOT NULL DEFAULT '',
`birthday` date NOT NULL,
`gender` enum('f','m','u') NOT NULL DEFAULT 'u',
`email` char(90) NOT NULL DEFAULT '',
`skype` char(90) NOT NULL,
`qq` char(20) NOT NULL DEFAULT '',
`yahoo` char(90) NOT NULL DEFAULT '',
`gtalk` char(90) NOT NULL DEFAULT '',
`wangwang` char(90) NOT NULL DEFAULT '',
`site` varchar(100) NOT NULL,
`mobile` char(11) NOT NULL DEFAULT '',
`phone` char(20) NOT NULL DEFAULT '',
`company` varchar(255) NOT NULL,
`companySN` char(18) NOT NULL,
`address` char(120) NOT NULL DEFAULT '',
`zipcode` char(10) NOT NULL DEFAULT '',
`sect` char(20) NOT NULL,
`visits` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ip` char(40) NOT NULL DEFAULT '',
`last` datetime NOT NULL,
`score` mediumint(9) NOT NULL,
`rank` mediumint(9) NOT NULL,
`maxLogin` tinyint(4) NOT NULL DEFAULT '10',
`fails` tinyint(3) unsigned NOT NULL DEFAULT '0',
`referer` varchar(255) NOT NULL,
`join` datetime NOT NULL,
`reset` char(64) NOT NULL,
`locked` datetime NOT NULL,
`public` varchar(30) NOT NULL DEFAULT '0',
`emailCertified` enum('0','1') NOT NULL DEFAULT '0',
`mobileCertified` enum('0','1') NOT NULL DEFAULT '0',
`realnameCertified` enum('no','wait','fail','normal') NOT NULL DEFAULT 'no',
`companyCertified` enum('no','wait','fail','normal') NOT NULL DEFAULT 'no',
`security` text,
`notification` varchar(20) NOT NULL DEFAULT '',
`os` char(30) NOT NULL,
`browser` varchar(100) NOT NULL,
`lang` char(30) NOT NULL,
`isCustomer` tinyint(1) NOT NULL DEFAULT '0',
`balance` varchar(100) NOT NULL DEFAULT '0',
`clientStatus` enum('online','away','busy','offline') NOT NULL DEFAULT 'offline',
`deleted` enum('0','1') NOT NULL DEFAULT '0',
`clientLang` varchar(10) NOT NULL DEFAULT 'zh-cn',
PRIMARY KEY (`id`),
KEY `lang` (`lang`),
KEY `admin` (`admin`),
KEY `score` (`score`),
KEY `rank` (`rank`),
KEY `account` (`account`,`password`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]user`
--
INSERT INTO `[[dbprefix]]user` VALUES
(1, 0, '[[admin_username]]', '[[admin_pass]]', '', '', '[[admin_username]]', '', '', '', 'super', '', '0000-00-00', 'u', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '0000-00-00 00:00:00', 0, 0, 10, 0, '', '[[regtime]]', '', '0000-00-00 00:00:00', '0', '0', '0', 'no', 'no', NULL, '', '', '', 'en', 0, '0', 'offline', '0', 'zh-cn');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]usercase`
--
CREATE TABLE `[[dbprefix]]usercase` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`industry` mediumint(8) unsigned NOT NULL,
`area` varchar(30) NOT NULL,
`name` varchar(200) NOT NULL,
`company` varchar(150) NOT NULL,
`site` varchar(255) NOT NULL,
`keywords` varchar(150) NOT NULL,
`desc` text NOT NULL,
`review` text NOT NULL,
`author` varchar(30) NOT NULL,
`addedDate` datetime NOT NULL,
`snap` text NOT NULL,
`status` tinyint(1) NOT NULL,
`classical` tinyint(1) NOT NULL,
`order` smallint(5) unsigned NOT NULL,
`views` mediumint(8) unsigned NOT NULL,
`reviewedDate` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `order` (`order`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]usergroup`
--
CREATE TABLE `[[dbprefix]]usergroup` (
`account` char(30) NOT NULL DEFAULT '',
`group` mediumint(8) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
UNIQUE KEY `account` (`account`,`group`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]usertpl`
--
CREATE TABLE `[[dbprefix]]usertpl` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`account` char(30) NOT NULL,
`type` char(30) NOT NULL,
`title` varchar(150) NOT NULL,
`content` text NOT NULL,
`public` enum('0','1') NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `account` (`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]widget`
--
CREATE TABLE `[[dbprefix]]widget` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`account` char(30) NOT NULL,
`type` char(20) NOT NULL,
`title` varchar(100) NOT NULL,
`params` text NOT NULL,
`order` tinyint(3) unsigned NOT NULL DEFAULT '0',
`grid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hidden` tinyint(1) unsigned NOT NULL DEFAULT '0',
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `accountAppOrder` (`account`,`order`),
KEY `lang` (`lang`),
KEY `hidden` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]wx_message`
--
CREATE TABLE `[[dbprefix]]wx_message` (
`id` mediumint(10) unsigned NOT NULL AUTO_INCREMENT,
`public` smallint(3) NOT NULL,
`wid` char(64) NOT NULL,
`to` varchar(50) NOT NULL,
`from` varchar(50) NOT NULL,
`response` mediumint(8) unsigned NOT NULL,
`content` text NOT NULL,
`type` char(30) NOT NULL,
`replied` tinyint(3) NOT NULL DEFAULT '0',
`time` datetime NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `public` (`public`),
KEY `from` (`from`),
KEY `to` (`to`),
KEY `replied` (`replied`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]wx_public`
--
CREATE TABLE `[[dbprefix]]wx_public` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(30) NOT NULL,
`name` varchar(60) NOT NULL,
`appID` char(30) NOT NULL,
`appSecret` char(32) NOT NULL,
`url` varchar(100) NOT NULL,
`token` varchar(100) NOT NULL,
`qrcode` varchar(100) NOT NULL,
`primary` tinyint(3) NOT NULL DEFAULT '0',
`type` enum('subscribe','service') NOT NULL,
`status` enum('wait','normal') NOT NULL,
`certified` enum('1','0') NOT NULL DEFAULT '0',
`addedDate` datetime NOT NULL,
`remindUsers` text NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]wx_response`
--
CREATE TABLE `[[dbprefix]]wx_response` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`public` smallint(3) NOT NULL,
`key` varchar(100) NOT NULL,
`group` varchar(100) NOT NULL,
`type` enum('text','news','link') NOT NULL DEFAULT 'text',
`source` varchar(100) NOT NULL,
`content` text NOT NULL,
`lang` char(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`public`,`key`,`lang`),
KEY `lang` (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;