-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2012 年 08 月 10 日 01:23
-- 服务器版本: 5.5.16
-- PHP 版本: 5.3.8

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

--
-- 数据库: `etwmakingserver`
--

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

--
-- 表的结构 `etw_language`
--

CREATE TABLE IF NOT EXISTS `etw_language` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `language` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domain` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kuozhan` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MainProName` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `RelatedProduct` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '相关产品',
  `OtherProduct` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '其他产品',
  `BackName` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '返回按钮名称',
  `LocationName` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '位置服务',
  `FeedBackName` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `SetItAsMyHome` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `AddToFavorites` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ETWUrl` varchar(60) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ETW平台',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

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

--
-- 表的结构 `etw_online`
--

CREATE TABLE IF NOT EXISTS `etw_online` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contacter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` varchar(5000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `senddate` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
  `usernameid` int(10) DEFAULT NULL,
  `ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `checknum` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isread` int(2) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `checknum` (`checknum`),
  KEY `usernameid` (`usernameid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `model_domain_list`
--

CREATE TABLE IF NOT EXISTS `model_domain_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL,
  `domain` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `flagid` int(11) NOT NULL,
  `linktype` int(1) NOT NULL DEFAULT '1' COMMENT '1为正常链接,0为rel="nofollow"',
  PRIMARY KEY (`id`),
  UNIQUE KEY `domain` (`domain`),
  KEY `gid` (`gid`),
  KEY `linktype` (`linktype`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

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

--
-- 表的结构 `model_flag`
--

CREATE TABLE IF NOT EXISTS `model_flag` (
  `model_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_flag_img` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `model_flag_msg` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_flag_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`model_flag_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=43 ;

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

--
-- 表的结构 `model_tmp`
--

CREATE TABLE IF NOT EXISTS `model_tmp` (
  `model_tmp_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_tmp_path` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `model_tmp_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`model_tmp_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

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

--
-- 表的结构 `model_url_conf`
--

CREATE TABLE IF NOT EXISTS `model_url_conf` (
  `model_url_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_url_domain` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
  `model_url_gid` int(11) DEFAULT NULL,
  `model_url_tmp_id` int(11) DEFAULT NULL,
  `model_url_jsqid` int(11) DEFAULT NULL,
  `model_url_chatid` int(11) DEFAULT NULL,
  `model_url_flag` int(11) DEFAULT NULL,
  `model_url_img_path` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `model_url_home_first` text CHARACTER SET latin1,
  `model_url_home_last` text CHARACTER SET latin1,
  `model_url_server_id` int(11) DEFAULT NULL,
  `model_url_header_txt` text COLLATE utf8_unicode_ci,
  `model_url_banner_txt` text COLLATE utf8_unicode_ci,
  `model_url_footer_txt` text COLLATE utf8_unicode_ci,
  `model_url_lan_id` int(11) DEFAULT NULL,
  `model_url_photo_upload` int(1) DEFAULT '0' COMMENT '图片是否上传到服务器,1为可以上传,但还没上传完成,2为完全上传',
  `model_url_starttime` date NOT NULL,
  `model_url_endtime` date NOT NULL,
  `model_url_state` int(11) NOT NULL DEFAULT '1',
  `googleverification` varchar(150) COLLATE utf8_unicode_ci NOT NULL COMMENT 'google验证',
  `googleLocation` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'google位置服务',
  PRIMARY KEY (`model_url_id`),
  UNIQUE KEY `model_url_domain` (`model_url_domain`),
  KEY `model_url_starttime` (`model_url_starttime`,`model_url_endtime`,`model_url_state`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;

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

--
-- 表的结构 `model_user_conf`
--

CREATE TABLE IF NOT EXISTS `model_user_conf` (
  `model_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_user_gid` int(11) DEFAULT NULL,
  `model_user_gtype` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `model_user_gname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `model_user_gstarttime` date NOT NULL,
  `model_user_gendtime` date NOT NULL,
  `model_user_gstate` int(11) NOT NULL DEFAULT '1',
  `model_user_logo` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `model_user_home_layout` int(11) DEFAULT '1' COMMENT '1为产品描述,2为图片',
  `model_user_home_des_len` int(11) DEFAULT '200' COMMENT '首页产品描述长度',
  `model_user_pro_layout` int(11) DEFAULT '1',
  `model_user_pro_des_len` int(11) DEFAULT '200',
  `model_user_banner` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_user_dir_type` int(3) DEFAULT NULL COMMENT '设置目录显示情况:1为显示一级,2为显示一二级',
  `model_user_mobile_code_contact` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '二维码(联系方式)',
  `googleLocation` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'google位置服务',
  `model_user_style_customer` text COLLATE utf8_unicode_ci NOT NULL COMMENT '自定义样式',
  PRIMARY KEY (`model_user_id`),
  UNIQUE KEY `model_user_gid` (`model_user_gid`),
  KEY `model_user_gtype` (`model_user_gtype`,`model_user_gstate`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

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

--
-- 表的结构 `pro`
--

CREATE TABLE IF NOT EXISTS `pro` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yid` int(11) NOT NULL COMMENT '原产品id',
  `gid` int(11) NOT NULL,
  `lanid` int(11) NOT NULL,
  `P_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `catelogue` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `docu_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `des` longtext COLLATE utf8_unicode_ci NOT NULL,
  `metaTitle` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `metaKD` text COLLATE utf8_unicode_ci NOT NULL,
  `metaDS` text COLLATE utf8_unicode_ci NOT NULL,
  `recommand_home` int(11) NOT NULL DEFAULT '0',
  `delstatus` int(1) NOT NULL DEFAULT '0' COMMENT '如果删除则为1',
  `show_hid` int(1) NOT NULL,
  `sub_child` int(1) NOT NULL,
  `md5` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `yid` (`yid`),
  UNIQUE KEY `md5` (`md5`),
  KEY `gid` (`gid`,`delstatus`),
  KEY `show_hid` (`show_hid`,`sub_child`),
  KEY `recommand_home` (`recommand_home`),
  KEY `lanid` (`lanid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=121330 ;

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

--
-- 表的结构 `proencode`
--

CREATE TABLE IF NOT EXISTS `proencode` (
  `autoid` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL COMMENT 'pro中的自动ID',
  `yid` int(11) NOT NULL,
  `des` longtext COLLATE utf8_unicode_ci NOT NULL,
  `docu_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`autoid`),
  UNIQUE KEY `proid` (`yid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=94 ;

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

--
-- 表的结构 `rss`
--

CREATE TABLE IF NOT EXISTS `rss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL,
  `lanid` int(11) NOT NULL,
  `rss` text COLLATE utf8_unicode_ci NOT NULL,
  `md5` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5` (`md5`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

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

--
-- 表的结构 `sitemap`
--

CREATE TABLE IF NOT EXISTS `sitemap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL,
  `lanid` int(11) NOT NULL,
  `sitemap` text COLLATE utf8_unicode_ci NOT NULL,
  `md5` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5` (`md5`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

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

--
-- 表的结构 `sitemapforimg`
--

CREATE TABLE IF NOT EXISTS `sitemapforimg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL,
  `lanid` int(11) NOT NULL,
  `sitemap` text COLLATE utf8_unicode_ci NOT NULL,
  `md5` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5` (`md5`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

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

--
-- 表的结构 `sitemapforxml`
--

CREATE TABLE IF NOT EXISTS `sitemapforxml` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL,
  `lanid` int(11) NOT NULL,
  `sitemap` text COLLATE utf8_unicode_ci NOT NULL,
  `md5` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5` (`md5`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

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

--
-- 表的结构 `uploadphoto`
--

CREATE TABLE IF NOT EXISTS `uploadphoto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
  `photos` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `md5` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5` (`md5`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=568 ;

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

--
-- 表的结构 `usermanager`
--

CREATE TABLE IF NOT EXISTS `usermanager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '登陆的IP地址',
  `status` int(1) NOT NULL COMMENT '如果为1则正常,否则不允许登陆',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `ip` (`ip`,`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

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

--
-- 表的结构 `visite`
--

CREATE TABLE IF NOT EXISTS `visite` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `ip` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `situation` int(2) DEFAULT '0',
  `address` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 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 */;