-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- : localhost
-- : 2014  02  19  15:09
-- 汾: 5.6.12-log
-- PHP 汾: 5.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- ݿ: `uzhan`
--

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

--
-- Ľṹ `ad`
--

CREATE TABLE IF NOT EXISTS `ad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `content` text,
  `link` text,
  `pic_url` text,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=80 ;

--
-- תе `ad`
--

INSERT INTO `ad` (`id`, `title`, `alias`, `content`, `link`, `pic_url`, `name`) VALUES
(16, '&#28526;&#23439;&#22522;&#29664;&#23453;&#26071;&#33328;&#24215;', 'HomeHaiBao01', '', 'http://taoniupincom.uz.taobao.com', 'http://img03.taobaocdn.com/imgextra/i3/208465577/T2HvbtXE0XXXXXXXXX-208465577.jpg', '&#39318;&#39029;&#36718;&#25773;&#28023;&#25253;(&#19968;)'),
(17, '&#20381;&#24605;Q &#20840;&#22330;&#21253;&#37038; &#19978;&#26032;&#23395;', 'HomeHaiBao02', '', 'http://taoniupincom.uz.taobao.com', 'http://img01.taobaocdn.com/imgextra/i1/208465577/T2pr2lXpRaXXXXXXXX-208465577.jpg', '&#39318;&#39029;&#36718;&#25773;&#28023;&#25253;(&#20108;)'),
(18, '&#28010;&#28459;&#22799;&#26085;&#39118;&#24773; &#33457;&#24515;&#23567;&#38138;', 'HomeHaiBao03', '', 'http://taoniupincom.uz.taobao.com', 'http://img02.taobaocdn.com/imgextra/i2/208465577/T236TyXsRaXXXXXXXX-208465577.jpg', '&#39318;&#39029;&#36718;&#25773;&#28023;&#25253;(&#19977;)'),
(19, '&#24515;&#29233;&#23448;&#26041;&#26071;&#33328;&#24215; &#20869;&#34915;&#19987;&#39064;', 'HomeHaiBao04', '', 'http://taoniupincom.uz.taobao.com', 'http://img04.taobaocdn.com/imgextra/i4/208465577/T2UJzlXEpXXXXXXXXX-208465577.jpg', '&#39318;&#39029;&#36718;&#25773;&#28023;&#25253;(&#22235;)'),
(20, '&#31616;&#20336;&#36335;&#23448;&#26041;&#26071;&#33328;&#24215;', 'HomeHaiBao05', '', 'http://taoniupincom.uz.taobao.com', 'http://img03.taobaocdn.com/imgextra/i3/70365491/T2JcnGXEFXXXXXXXXX-70365491.jpg', '&#39318;&#39029;&#36718;&#25773;&#28023;&#25253;(&#20116;)'),
(21, '&#39318;&#39029;&#21015;&#34920;&#39029;&#24213;&#37096;&#24191;&#21578;', 'HomeBoottomAd', '', 'http://taoniupincom.uz.taobao.com', 'http://img03.taobaocdn.com/imgextra/i3/208465577/T2fB_HXtxaXXXXXXXX-208465577.jpg', '&#39318;&#39029;&#21015;&#34920;&#39029;&#24213;&#37096;&#24191;&#21578;'),
(22, '&#21015;&#34920;&#39029;&#39030;&#37096;&#24191;&#21578;', 'ListTopAd', '', 'http://taoniupincom.uz.taobao.com', 'http://img03.taobaocdn.com/imgextra/i3/208465577/T2fB_HXtxaXXXXXXXX-208465577.jpg', '&#21015;&#34920;&#39029;&#39030;&#37096;&#24191;&#21578;'),
(23, '&#21015;&#34920;&#39029;&#24213;&#37096;&#24191;&#21578;', 'ListBottomAd', '', 'http://taoniupincom.uz.taobao.com', 'http://img03.taobaocdn.com/imgextra/i3/208465577/T2fB_HXtxaXXXXXXXX-208465577.jpg', '&#21015;&#34920;&#39029;&#24213;&#37096;&#24191;&#21578;'),
(77, '&#39318;&#39029;&#20184;&#37038;&#35797;&#29992;&#19968;&#26041;&#24191;&#21578;&#27178;&#24133;', 'fuyoushiyong_ad', '', '', '', '&#39318;&#39029;&#20184;&#37038;&#35797;&#29992;&#19968;&#26041;&#24191;&#21578;&#27178;&#24133;'),
(78, '&#39318;&#39029;&#27599;&#26085;&#31186;&#26432;&#27178;&#24133;&#24191;&#21578;', 'meirimiaosha_ad', '', '', '', '&#39318;&#39029;&#27599;&#26085;&#31186;&#26432;&#27178;&#24133;&#24191;&#21578;'),
(79, '&#39318;&#39029;&#29190;&#27454;&#28909;&#21334;&#27178;&#24133;&#24191;&#21578;', 'baokuanremai_ad', '', '', '', '&#39318;&#39029;&#29190;&#27454;&#28909;&#21334;&#27178;&#24133;&#24191;&#21578;');

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

--
-- Ľṹ `article`
--

CREATE TABLE IF NOT EXISTS `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `keyword` text,
  `description` text,
  `content` text NOT NULL,
  `tag` text,
  `category_id` int(11) DEFAULT '0',
  `clicks` int(11) DEFAULT '0',
  `promote_id` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT '0',
  `num_iids` text,
  `pindao_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `promote_id` (`promote_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=11 ;

--
-- תе `article`
--

INSERT INTO `article` (`id`, `title`, `keyword`, `description`, `content`, `tag`, `category_id`, `clicks`, `promote_id`, `create_time`, `num_iids`, `pindao_id`) VALUES
(4, '&#12304;&#20080;&#21253;&#21253;&#12305;&#34903;&#35282;&#27915;&#26524;&#23376;&#24215; 15&#27454;&#30334;&#25645;&#23450;&#22411;&#23567;&#21253;', 'http://img02.taobaocdn.com/imgextra/i2/1758066283/T2sRgTXiBXXXXXXXXX_!!1758066283.jpg', '&#23450;&#22411;&#21253;&#30001;&#27431;&#27954;&#19968;&#25112;&#26102;&#26399;&#20026;&#20102;&#26041;&#20415;&#21307;&#29983;&#25658;&#24102;&#21307;&#30103;&#22120;&#26800;&#20197;&#21450;&#33647;&#21697;&#30340;&#20415;&#25658;&#31665;&#25913;&#29256;&#32780;&#26469;&#65292;&#30001;&#21402;&#23454;&#30340;&#30382;&#38761;&#21046;&#25104;&#65292;&#22312;&#24694;&#21155;&#30340;&#29615;&#22659;&#19979;&#20351;&#29992;&#38750;&#24120;&#26041;&#20415;&#12290;&#29616;&#22914;&#20170;&#65292;&#23450;&#22411;&#21253;&#20197;&#20854;&#23454;&#29992;&#21644;&#20856;&#38597;&#30340;&#39118;&#26684;&#32780;&#28145;&#21463;&#30333;&#39046;&#20204;&#30340;&#27426;&#36814;&#12290;', '&lt;p&gt;&amp;nbsp;&lt;img src=http://img02.taobaocdn.com/imgextra/i2/1758066283/T2sRgTXiBXXXXXXXXX_!!1758066283.jpg alt=alt /&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&#23450;&#22411;&#21253;&#30001;&#27431;&#27954;&#19968;&#25112;&#26102;&#26399;&#20026;&#20102;&#26041;&#20415;&#21307;&#29983;&#25658;&#24102;&#21307;&#30103;&#22120;&#26800;&#20197;&#21450;&#33647;&#21697;&#30340;&#20415;&#25658;&#31665;&#25913;&#29256;&#32780;&#26469;&#65292;&#30001;&#21402;&#23454;&#30340;&#30382;&#38761;&#21046;&#25104;&#65292;&#22312;&#24694;&#21155;&#30340;&#29615;&#22659;&#19979;&#20351;&#29992;&#38750;&#24120;&#26041;&#20415;&#12290;&#29616;&#22914;&#20170;&#65292;&#23450;&#22411;&#21253;&#20197;&#20854;&#23454;&#29992;&#21644;&#20856;&#38597;&#30340;&#39118;&#26684;&#32780;&#28145;&#21463;&#30333;&#39046;&#20204;&#30340;&#27426;&#36814;&#12290;&#39118;&#26684;&#19978;&#31361;&#26174;&#32844;&#19994;&#22899;&#24615;&#30340;&#24178;&#32451;&#27668;&#36136;&#65292;&#20248;&#38597;&#22823;&#26041;&#65292;&#23436;&#32654;&#30340;&#32447;&#26465;&#24863;&#65292;&#31616;&#21333;&#30340;&#35774;&#35745;&#65292;&#36731;&#26494;&#25198;&#20986;&#19968;&#31181;&#21326;&#20029;&#30340;&#22797;&#21476;&#24863;&#35273;&#12290;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;http://item.taobao.com/item.htm?id=18615754677&quot; target=_blank&gt;&lt;img src=http://img04.taobaocdn.com/imgextra/i4/1758066283/T2q98MXeddXXXXXXXX_!!1758066283.jpg alt=alt /&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p style=&quot;margin-bottom: 15px; line-height: 1.8em; font-size: 12px; color: rgb(68, 68, 68); font-family: &amp;#65533;&amp;#65533;&amp;#65533;&amp;#65533;, ''Helvetica Neue'', Helvetica, ''Lucida Grande'', ''Lucida Sans Unicode'', sans-serif&quot;&gt;&#25512;&#33616;&#21333;&#21697;&#65306;&lt;a href=&quot;http://item.taobao.com/item.htm?id=18615754677&quot; target=_blank style=&quot;margin: 0px; padding: 0px; text-decoration: none; color: rgb(236, 112, 48); cursor: pointer&quot;&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;&#28165;&#26032;&#36710;&#32541;&#32447;&#29233;&#24515;&#31881;&#33394;&#31995;&#33777;&#26684;&#38142;&#26465;&#21253;&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;&lt;p style=&quot;margin-bottom: 15px; line-height: 1.8em; font-size: 12px; color: rgb(68, 68, 68); font-family: &amp;#65533;&amp;#65533;&amp;#65533;&amp;#65533;, ''Helvetica Neue'', Helvetica, ''Lucida Grande'', ''Lucida Sans Unicode'', sans-serif&quot;&gt;&#24215;&#38138;&#22320;&#22336;&#65306;&lt;a href=&quot;http://phoebone.taobao.com/?nick_uz=&#34261;&#29032;&#27748;&quot; target=_blank style=&quot;margin: 0px; padding: 0px; text-decoration: none; color: rgb(236, 112, 48); cursor: pointer&quot;&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;PhoeB&#33778;&#23453;&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;', '', 50, 0, 8, 1377674634, '', 0),
(2, '&#12304;&#25252;&#32932;&#12305;&#25442;&#23395;&#25252;&#32932;&#23567;&#35838;&#22530;&#21021;&#31179;&#25252;&#32932;&#21697;&#30340;&#26356;&#25442;&#25913;&#33391;', '&#21021;&#31179;&#25252;&#32932;  &#25442;&#23395; &#25252;&#32932;', '&#20837;&#31179;&#20937;&#24847;&#26085;&#28176;&#65292;&#22799;&#26085;&#36136;&#22320;&#36807;&#20110;&#28165;&#29245;&#30340;&#25252;&#32932;&#21697;&#23545;&#20110;&#32908;&#32932;&#26469;&#35828;&#65292;&#26174;&#24471;&#36739;&#20026;&#36731;&#34180;&#20102;&#19968;&#20123;&#65292;&#31179;&#23395;&#25252;&#32932;&#20063;&#35201;&#38543;&#30528;&#23395;&#33410;&#30340;&#21464;&#21270;&#32780;&#21450;&#26102;&#35843;&#25972;&#65292;&#20197;&#20813;&#24341;&#36215;&#30382;&#32932;&#24178;&#29157;&#12289;&#32454;&#32441;&#12289;&#30382;&#23633;&#12289;&#29978;&#33267;&#36807;&#25935;&#28902;&#24700;&#30340;&#38382;&#39064;&#12290;', '&lt;p&gt;&amp;nbsp;&lt;img src=http://img04.taobaocdn.com/imgextra/i4/1758066283/T2xus6XadaXXXXXXXX_!!1758066283.jpg alt=alt /&gt;&lt;/p&gt;&lt;p&gt;&#20837;&#31179;&#20937;&#24847;&#26085;&#28176;&#65292;&#22799;&#26085;&#36136;&#22320;&#36807;&#20110;&#28165;&#29245;&#30340;&#25252;&#32932;&#21697;&#23545;&#20110;&#32908;&#32932;&#26469;&#35828;&#65292;&#26174;&#24471;&#36739;&#20026;&#36731;&#34180;&#20102;&#19968;&#20123;&#65292;&#31179;&#23395;&#25252;&#32932;&#20063;&#35201;&#38543;&#30528;&#23395;&#33410;&#30340;&#21464;&#21270;&#32780;&#21450;&#26102;&#35843;&#25972;&#65292;&#20197;&#20813;&#24341;&#36215;&#30382;&#32932;&#24178;&#29157;&#12289;&#32454;&#32441;&#12289;&#30382;&#23633;&#12289;&#29978;&#33267;&#36807;&#25935;&#28902;&#24700;&#30340;&#38382;&#39064;&#12290;&#37027;&#20040;&#65292;&#31350;&#31455;&#21738;&#20123;&#25252;&#32932;&#21697;&#35201;&#36319;&#38543;&#23395;&#33410;&#19968;&#36215;&#26356;&#25442;&#21602;&#65311;&#20170;&#22825;&#21046;&#21697;&#35831;&#21040;&#20102;&#20174;&#20107;&#26377;&#26426;&#25252;&#32932;&#30740;&#31350;&#30340;&#37197;&#26041;&#24072;&#12302;&#29790;&#12303;&#65292;&#19982;&#22823;&#23478;&#26469;&#20998;&#20139;&#19968;&#19979;&#32908;&#32932;&#22312;&#25442;&#23395;&#26102;&#23545;&#25252;&#32932;&#21697;&#30340;&#26356;&#25442;&#21644;&#25913;&#33391;&#65292;&#36214;&#24555;&#26469;&#23398;&#20064;&#19968;&#19979;&#21543;&#65281;&lt;/p&gt;&lt;p&gt; &amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;&lt;strong&gt;&#21464;&#21270;&#19968;&#65306;&#28165;&#27905;&#21697;&#20174;&#28145;&#24230;&#28165;&#27905;&#22411;&#21464;&#28201;&#26580;&#20445;&#28287;&#22411;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&#22799;&#23395;&#22825;&#27668;&#28814;&#28909;&#65292;&#30382;&#32932;&#26131;&#20998;&#27852;&#27833;&#33026;&#65292;&#26131;&#20135;&#29983;&#31896;&#33147;&#21644;&#30382;&#32932;&#27833;&#20809;&#12289;&#25152;&#26377;&#24456;&#22810;&#20154;&#20250;&#22312;&#22799;&#23395;&#20351;&#29992;&#28145;&#24230;&#28165;&#27905;&#31867;&#30340;&#28165;&#27905;&#29992;&#21697;&#65307;&#32780;&#36827;&#20837;&#31179;&#23395;&#65292;&#24178;&#29157;&#30340;&#31354;&#27668;&#29615;&#22659;&#20351;&#24471;&#30382;&#32932;&#27833;&#33026;&#20998;&#27852;&#22823;&#37327;&#20943;&#23569;&#65292;&#28145;&#24230;&#25110;&#32773;&#36807;&#24230;&#28165;&#27905;&#65292;&#23481;&#26131;&#36896;&#25104;&#32908;&#32932;&#27833;&#33026;&#21093;&#31163;&#36807;&#24230;&#65292;&#20174;&#32780;&#24341;&#21457;&#30382;&#28814;&#22411;&#30168;&#30168;&#12289;&#30382;&#32932;&#22833;&#27700;&#21457;&#30162;&#12289;&#30382;&#23633;&#32454;&#32441;&#22686;&#22810;&#30340;&#24773;&#20917;&#65292;&#26377;&#20123;&#25935;&#24863;&#22411;&#32908;&#32932;&#36824;&#21487;&#33021;&#20986;&#29616;&#36807;&#25935;&#65292;&#25152;&#20197;&#65292;&#36827;&#20837;&#31179;&#23395;&#36873;&#25321;&#19968;&#27454;&#28201;&#21644;&#30340;&#27905;&#38754;&#20135;&#21697;&#26159;&#31179;&#23395;&#27491;&#30830;&#25252;&#32932;&#30340;&#22522;&#30784;&#12290;&lt;/p&gt;&lt;p&gt; &amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;http://item.taobao.com/item.htm?id=15055282431&quot; target=_blank&gt;&lt;img src=http://img01.taobaocdn.com/imgextra/i1/1758066283/T2XqI7XXRaXXXXXXXX_!!1758066283.jpg alt=alt /&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt; &amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;color: rgb(68, 68, 68); font-family: &amp;#65533;&amp;#65533;&amp;#65533;&amp;#65533;, ''Helvetica Neue'', Helvetica, ''Lucida Grande'', ''Lucida Sans Unicode'', sans-serif; font-size: 12px; line-height: 21.59375px&quot;&gt;&#20837;&#31179;&#27905;&#38754;&#28909;&#38376;&#20043;&#36873;&#25512;&#33616;&#65306;&lt;/span&gt;&lt;a href=&quot;http://item.taobao.com/item.htm?id=15055282431&quot; target=_blank style=&quot;margin: 0px; padding: 0px; text-decoration: none; color: rgb(236, 112, 48); cursor: pointer; font-family: &amp;#65533;&amp;#65533;&amp;#65533;&amp;#65533;, ''Helvetica Neue'', Helvetica, ''Lucida Grande'', ''Lucida Sans Unicode'', sans-serif; font-size: 12px; line-height: 21.59375px&quot;&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;&#33487;&#37266;1&#21495;&middot;&#20256;&#26126;&#37240;&#27905;&#38754;&#33167;&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;', '', 52, 0, 8, 1377673453, '', 0),
(3, '&#12304;&#38795;&#21697;&#12305;&#23569;&#24180;&#32500;&#29305;&#30340;&#28902;&#24700; 16&#27454;&#22797;&#21476;&#32534;&#32455;&#20937;&#38795;', '&#20937;&#38795;', '&#22799;&#26085;&#21040;&#26469;&#65292;&#23545;&#27599;&#19968;&#20010;&#28909;&#29233;&#31359;&#25645;&#25645;&#37197;&#30340;&#20154;&#26469;&#35828;&#65292;&#19968;&#30452;&#22823;&#28909;&#30340;&#22797;&#21476;&#39118;&#33258;&#28982;&#19981;&#21487;&#32570;&#23569;&#12290;&#32780;&#22797;&#21476;&#39118;&#24517;&#22791;&#30340;&#21333;&#21697;&#23601;&#26159;&#19968;&#21452;&#32534;&#32455;&#20937;&#38795;&#20102;&#12290;&#25110;&#31616;&#32422;&#25110;&#22797;&#21476;&#30340;&#27454;&#24335;&#65292;&#25645;&#37197;&#31616;&#21333;&#30340;&#28909;&#35044;&#23601;&#21035;&#26377;&#19968;&#30058;&#28363;&#21619;&#12290;&#31359;&#19978;&#36825;&#19968;&#21452;&#32534;&#32455;&#20937;&#38795;&#65292;&#25645;&#37197;&#20986;&#23646;&#20110;&#20320;&#30340;&#22799;&#26085;&#22797;&#21476;&#39118;', '&lt;p&gt;&amp;nbsp;&lt;img src=http://img04.taobaocdn.com/imgextra/i4/1758066283/T26Jk1XjlaXXXXXXXX_!!1758066283.jpg alt=alt /&gt;&lt;/p&gt;&lt;p&gt;&#22799;&#26085;&#21040;&#26469;&#65292;&#23545;&#27599;&#19968;&#20010;&#28909;&#29233;&#31359;&#25645;&#25645;&#37197;&#30340;&#20154;&#26469;&#35828;&#65292;&#19968;&#30452;&#22823;&#28909;&#30340;&#22797;&#21476;&#39118;&#33258;&#28982;&#19981;&#21487;&#32570;&#23569;&#12290;&#32780;&#22797;&#21476;&#39118;&#24517;&#22791;&#30340;&#21333;&#21697;&#23601;&#26159;&#19968;&#21452;&#32534;&#32455;&#20937;&#38795;&#20102;&#12290;&#25110;&#31616;&#32422;&#25110;&#22797;&#21476;&#30340;&#27454;&#24335;&#65292;&#25645;&#37197;&#31616;&#21333;&#30340;&#28909;&#35044;&#23601;&#21035;&#26377;&#19968;&#30058;&#28363;&#21619;&#12290;&#31359;&#19978;&#36825;&#19968;&#21452;&#32534;&#32455;&#20937;&#38795;&#65292;&#25645;&#37197;&#20986;&#23646;&#20110;&#20320;&#30340;&#22799;&#26085;&#22797;&#21476;&#39118;&#21543;&#12290;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;http://item.taobao.com/item.htm?id=17081376353&quot; target=_blank&gt;&lt;img src=http://img02.taobaocdn.com/imgextra/i2/1758066283/T2Fog6XXlaXXXXXXXX_!!1758066283.jpg alt=alt /&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p style=&quot;margin-bottom: 15px; line-height: 1.8em; font-size: 12px; color: rgb(68, 68, 68); font-family: &amp;#65533;&amp;#65533;&amp;#65533;&amp;#65533;, ''Helvetica Neue'', Helvetica, ''Lucida Grande'', ''Lucida Sans Unicode'', sans-serif&quot;&gt;&#25512;&#33616;&#21333;&#21697;&#65306;&lt;a href=&quot;http://item.taobao.com/item.htm?id=17081376353&quot; target=_blank style=&quot;margin: 0px; padding: 0px; text-decoration: none; color: rgb(236, 112, 48); cursor: pointer&quot;&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;&#24179;&#24213;&#31895;&#36319;&#20937;&#38795; &#25163;&#24037;&#23450;&#20570;&#30495;&#30382;&#33521;&#20262;&#22797;&#21476;&#32534;&#32455;&#29980;&#32654;&#22899;&#38795;&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;&lt;p style=&quot;margin-bottom: 15px; line-height: 1.8em; font-size: 12px; color: rgb(68, 68, 68); font-family: &amp;#65533;&amp;#65533;&amp;#65533;&amp;#65533;, ''Helvetica Neue'', Helvetica, ''Lucida Grande'', ''Lucida Sans Unicode'', sans-serif&quot;&gt;&#24215;&#38138;&#22320;&#22336;&#65306;&lt;a href=&quot;http://youngage.taobao.com/?nick_uz=youngage &#38738;&#26149;&#24180;&#20195;&quot; target=_blank style=&quot;margin: 0px; padding: 0px; text-decoration: none; color: rgb(236, 112, 48); cursor: pointer&quot;&gt;&lt;span style=&quot;color: rgb(237, 66, 108)&quot;&gt;YoungAge&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;', '', 49, 0, 8, 1377674228, '', 0),
(5, 'Ŷӽ', '', ' ţƷtaoniupincom.uz.taobao.comÿ칽ǼѶѡԼϲıʱС', '<table align=center border=0 cellpadding=0 cellspacing=0 width=96%> <tbody><tr> <td class=aboutright_content width=54%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ţƷ<b class=renmingbi>nvrrenshijie</b>.uz.taobao.comÿ칽ǼѶѡԼϲıʱСǲû飬ŬԱǿUվƽ̨<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ּһҸ߿ƼʱеĻ˾ţƷľͨǵŬΪṩЧĹ߽顣ŬԱUվڵ˵Ģ֣ʵܹ֡ϲʱеվΪ֮ܶ </td> <td width=46%><div align=center><img src=/assets/daogou/img/lovemyself.jpg height=110 width=255 /></div></td> </tr> </tbody></table> <table align=center border=0 cellpadding=0 cellspacing=0 width=96%> <tbody><tr> <td><img src=/assets/daogou/img/us_1.jpg height=359 width=785 /></td> </tr> <tr> <td><img src=/assets/daogou/img/us_2.jpg height=359 width=785 /></td> </tr> <tr> <td><img src=/assets/daogou/img/us_3.jpg height=359 width=785 /></td> </tr> </tbody></table>', 'Ŷӽ', 0, 0, 11, 1380897127, '', 0),
(6, '̹', '', 'һֻȽĶ', '<p>̹</p>', '', 0, 0, 10, 1380898169, '', 0),
(7, 'ͼƬ淶', 'ͼƬ淶', 'ͼƬ淶', '<p>ͼƬ淶</p>', '', 0, 0, 15, 1381130438, '', 0),
(8, 'LOGO̳', 'LOGO̳', 'LOGO̳', '<p>LOGO̳</p>', '', 0, 0, 16, 1381130551, '', 0),
(9, 'Υ̼Ҵ', 'Υ̼Ҵ', 'Υ̼Ҵ', '<p>Υ̼Ҵ</p>', '', 0, 0, 13, 1381130624, '', 0),
(10, '̼α', '̼α', '̼α', '<p>̼α</p>', '', 0, 0, 14, 1381130701, '', 0);

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

--
-- Ľṹ `auth`
--

CREATE TABLE IF NOT EXISTS `auth` (
  `auth_id` int(8) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `auth_code` varchar(100) COLLATE gbk_bin NOT NULL COMMENT '',
  `auth_url` varchar(100) COLLATE gbk_bin NOT NULL COMMENT 'ӦURL',
  `auth_time` int(10) NOT NULL COMMENT 'ʱ',
  `auth_flag` int(2) NOT NULL COMMENT '״̬',
  PRIMARY KEY (`auth_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk COLLATE=gbk_bin AUTO_INCREMENT=3 ;

--
-- תе `auth`
--

INSERT INTO `auth` (`auth_id`, `auth_code`, `auth_url`, `auth_time`, `auth_flag`) VALUES
(1, '001aaron001', 'uz.taobao.com', 1379923233, 0),
(2, 'da83ae7a4f71026a3e3f1d27ba8ffddb', 'upload.uz.taobao.com', 1380110678, 0);

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

--
-- Ľṹ `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `tag` text,
  `keyword` text,
  `description` text,
  `alias` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT '0',
  `disabled` int(11) DEFAULT '0',
  `level` int(11) DEFAULT '1',
  `parent_id` int(11) DEFAULT '0',
  `top_parent_id` int(11) DEFAULT '0',
  `thumb` text,
  `banner` text,
  PRIMARY KEY (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=150 ;

--
-- תе `category`
--

INSERT INTO `category` (`id`, `name`, `tag`, `keyword`, `description`, `alias`, `sort`, `disabled`, `level`, `parent_id`, `top_parent_id`, `thumb`, `banner`) VALUES
(48, '', '', NULL, NULL, 'fushi', 0, 0, 1, 0, 0, '', ''),
(49, 'Ь', '', NULL, NULL, 'xiebao', 0, 0, 1, 0, 0, '', ''),
(50, '', '', NULL, NULL, 'dianqi', 0, 0, 1, 0, 0, '', ''),
(53, 'ʱ', '', NULL, NULL, 'shishang', 0, 0, 1, 0, 0, '', ''),
(148, 'ĸӤ', '', NULL, NULL, 'muying', 0, 0, 1, 0, 0, '', ''),
(149, 'ۺ', '', NULL, NULL, 'zonghe', 0, 0, 1, 0, 0, '', '');

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

--
-- Ľṹ `choujiang`
--

CREATE TABLE IF NOT EXISTS `choujiang` (
  `cj_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '齱ID',
  `cj_uid` int(11) NOT NULL COMMENT '齱ûID',
  `cj_gid` int(11) NOT NULL COMMENT '齱ƷID',
  `cj_time` int(10) NOT NULL COMMENT '齱ʱ',
  `cj_type` int(2) NOT NULL COMMENT '齱',
  `cj_jiangpin` varchar(200) COLLATE gbk_bin NOT NULL COMMENT 'Ʒ',
  PRIMARY KEY (`cj_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk COLLATE=gbk_bin AUTO_INCREMENT=36 ;

--
-- תе `choujiang`
--

INSERT INTO `choujiang` (`cj_id`, `cj_uid`, `cj_gid`, `cj_time`, `cj_type`, `cj_jiangpin`) VALUES
(19, 10, 4, 1380549434, 1, 'd21e2afc88826aa4b9ad1df691945f79'),
(31, 10, 5, 1380590983, 2, 'http://www.taobao.com'),
(32, 10, 5, 1380604070, 0, 'ûн'),
(33, 10, 5, 1380606258, 0, 'ûн'),
(34, 10, 2, 1380807592, 0, 'ûн'),
(35, 10, 6, 1380869262, 0, 'ûн');

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

--
-- Ľṹ `dazhe`
--

CREATE TABLE IF NOT EXISTS `dazhe` (
  `dz_id` int(9) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dz_titile` varchar(200) COLLATE gbk_bin NOT NULL COMMENT '۱',
  `dz_pplogo` varchar(300) COLLATE gbk_bin NOT NULL COMMENT 'ƷLOGO',
  `dz_dazhe` varchar(10) COLLATE gbk_bin NOT NULL COMMENT '۱',
  `dz_stime` int(10) NOT NULL COMMENT 'ʼʱ',
  `dz_etime` int(10) NOT NULL COMMENT 'ʱ',
  `dz_weiguan` int(10) NOT NULL COMMENT 'Χ',
  `dz_img` varchar(300) COLLATE gbk_bin NOT NULL COMMENT 'ͼ',
  `dz_link` varchar(300) COLLATE gbk_bin NOT NULL COMMENT '',
  `dz_category` int(5) NOT NULL COMMENT '',
  `dz_sort` int(5) NOT NULL DEFAULT '0' COMMENT '',
  PRIMARY KEY (`dz_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk COLLATE=gbk_bin AUTO_INCREMENT=2 ;

--
-- תе `dazhe`
--

INSERT INTO `dazhe` (`dz_id`, `dz_titile`, `dz_pplogo`, `dz_dazhe`, `dz_stime`, `dz_etime`, `dz_weiguan`, `dz_img`, `dz_link`, `dz_category`, `dz_sort`) VALUES
(1, '&#31179;&#23395;&#26032;&#21697;&#21457;&#24067; &#20840;&#22330;3&#25240;&#36215;', 'http://img01.taobaocdn.com/imgextra/i1/1758066283/T20.QxXc0bXXXXXXXX_!!1758066283.jpg', '3', 1381766400, 1384444800, 0, 'http://img02.taobaocdn.com/imgextra/i2/1758066283/T2szs5Xe4XXXXXXXXX_!!1758066283.jpg', 'http://taoniupincom.uz.taobao.com', 1, 0);

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

--
-- Ľṹ `exchange`
--

CREATE TABLE IF NOT EXISTS `exchange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `phone` char(20) NOT NULL,
  `zip` char(7) NOT NULL,
  `address` text NOT NULL,
  `wangwang` char(100) NOT NULL,
  `goods_id` int(9) NOT NULL,
  `goods_title` varchar(255) NOT NULL,
  `url` text NOT NULL,
  `image` text NOT NULL,
  `uid` varchar(50) NOT NULL,
  `nick` varchar(255) NOT NULL,
  `etime` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `ejifen` int(11) NOT NULL,
  `taobao_order_id` char(50) DEFAULT NULL,
  `lottery_log_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `free_goods`
--

CREATE TABLE IF NOT EXISTS `free_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num_iid` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `pic_url` text NOT NULL,
  `detail_url` text NOT NULL,
  `price` decimal(10,2) DEFAULT '0.00',
  `coupon_price` decimal(10,2) DEFAULT '0.00',
  `num` int(11) DEFAULT '0',
  `category_id` int(11) DEFAULT '0',
  `end_time` int(11) DEFAULT '0',
  `freight_payer` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `begin_time` int(11) DEFAULT '0',
  `sort` tinyint(4) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0',
  `lottery_times` int(11) DEFAULT '0',
  `left_num` int(11) DEFAULT '0' COMMENT 'δеע',
  `credit` tinyint(4) DEFAULT '0',
  `item_num` int(11) DEFAULT '0',
  `item_score` decimal(2,1) DEFAULT '0.0',
  `service_score` decimal(2,1) DEFAULT '0.0',
  `delivery_score` decimal(2,1) DEFAULT '0.0',
  `sid` int(11) DEFAULT '0',
  `shop_pic` text,
  `description` text,
  `recommend_goods_id` text,
  `uid` char(32) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `free_take_log`
--

CREATE TABLE IF NOT EXISTS `free_take_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` int(11) NOT NULL,
  `uid` varchar(50) NOT NULL,
  `nick` varchar(50) NOT NULL,
  `free_goods_id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `status` int(11) DEFAULT '0',
  `win` tinyint(4) DEFAULT '0',
  `order_number` varchar(50) DEFAULT NULL,
  `beizhu` text,
  PRIMARY KEY (`id`),
  KEY `free_goods_id` (`free_goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `friend_link`
--

CREATE TABLE IF NOT EXISTS `friend_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `link` text,
  `pic_url` text,
  `connect` text,
  `pic_url1` text COMMENT 'СͼƬ',
  `sort` int(9) NOT NULL DEFAULT '0' COMMENT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=4 ;

--
-- תе `friend_link`
--

INSERT INTO `friend_link` (`id`, `title`, `link`, `pic_url`, `connect`, `pic_url1`, `sort`) VALUES
(3, 'ţƷ', 'http://taoniupincom.uz.taobao.com/', '', '', 'http://img01.taobaocdn.com/imgextra/i1/1837414386/T24ZeIXxpaXXXXXXXX-1837414386.jpg', 0);

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

--
-- Ľṹ `gailv`
--

CREATE TABLE IF NOT EXISTS `gailv` (
  `gl_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `gl_value1` int(11) NOT NULL COMMENT 'һȽ',
  `gl_value2` int(11) NOT NULL COMMENT 'Ƚ',
  `gl_value3` int(11) NOT NULL COMMENT 'Ƚ',
  PRIMARY KEY (`gl_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

--
-- תе `gailv`
--

INSERT INTO `gailv` (`gl_id`, `gl_value1`, `gl_value2`, `gl_value3`) VALUES
(1, 100, 50, 10);

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

--
-- Ľṹ `gift`
--

CREATE TABLE IF NOT EXISTS `gift` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num_iid` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `pic_url` text NOT NULL,
  `detail_url` text NOT NULL,
  `price` decimal(10,2) DEFAULT '0.00',
  `coupon_price` decimal(10,2) DEFAULT '0.00',
  `num` int(11) DEFAULT '0',
  `description` text,
  `category_id` int(11) DEFAULT '0',
  `end_time` int(11) DEFAULT '0',
  `freight_payer` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `begin_time` int(11) DEFAULT '0',
  `jifen` mediumint(9) DEFAULT '0',
  `sort` tinyint(4) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0',
  `level` tinyint(4) DEFAULT '0',
  `vote` int(11) DEFAULT '0',
  `left_num` int(11) DEFAULT '0' COMMENT 'δеע',
  `lottery_times` int(11) DEFAULT '0',
  `sid` int(11) DEFAULT '0',
  `gift_type` int(5) NOT NULL DEFAULT '0' COMMENT 'ְúͨƷ',
  `youhui_link` text COMMENT 'Żȯ',
  `promote_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ƼID',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=11 ;

--
-- תе `gift`
--

INSERT INTO `gift` (`id`, `num_iid`, `title`, `pic_url`, `detail_url`, `price`, `coupon_price`, `num`, `description`, `category_id`, `end_time`, `freight_payer`, `nick`, `begin_time`, `jifen`, `sort`, `status`, `level`, `vote`, `left_num`, `lottery_times`, `sid`, `gift_type`, `youhui_link`, `promote_id`) VALUES
(7, '15165185265', 'WOOG 2013&#31179;&#35013;&#26032;&#27454;&#30007;&#22763;&#32431;&#30333;&#33394;v&#39046;&#38271;&#34966;T&#24676; &#28526;&#27969;&#38889;&#29256;&#20462;&#36523;&#32431;&#33394;&#25171;&#24213;&#34923;', 'http://img02.taobaocdn.com/bao/uploaded/i2/16057028321509800/T1nyxGXB4fXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=15165185265&spm=2014.21601761.0.0', '118.00', '10.00', 10, '', 54, 1381507200, 'seller', 'woog2005콢', 1380902400, 500, 0, 0, 0, 0, 10, 0, 67666875, 1, '', 0),
(2, '27497468839', '&#27431;&#34174;2013&#26032;&#27454;&#31179;&#20908;&#21152;&#22823;&#30721;&#22899;&#35013;&#32982;mm&#38889;&#29256;&#20462;&#36523;&#36830;&#34915;&#35033;&#35961;&#28857;&#32972;&#24515;&#35033;&#28909;&#21334;', 'http://img04.taobaocdn.com/bao/uploaded/i4/11203027785976823/T1cv5RFgdcXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=27497468839&spm=2014.21601761.0.0', '125.00', '10.00', 3, '', 48, 1380816000, 'buyer', '˺Ǯ', 1380211200, 1, 0, 0, 0, 0, 3, 1, 70480991, 1, 'http://www.taobao.com', 0),
(3, '27467856454', '&#26708;&#29066;{AA0727}&#31179;&#35013;&#26032;&#21697;V&#39046;&#34924;&#34923;&#20551;&#20108;&#20214;&#23485;&#26494;&#22871;&#22836;&#36830;&#24125;&#22823;&#30721;&#22899;&#35013;&#38024;&#32455;&#34923;', 'http://img01.taobaocdn.com/bao/uploaded/i1/17665028108865493/T1KeuUFbFcXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=27467856454&spm=2014.21601761.0.0', '79.00', '20.00', 30, '', 48, 1380729600, 'buyer', 'obuy_orangebear68', 1380211200, 1, 0, 0, 0, 0, 30, 0, 34939047, 1, 'http://www.taobao.com', 0),
(4, '26807344613', '&#32654;&#29305;&#26031;&#37030;&#23041;2013&#31179;&#23395;&#26032;&#27454;&#22806;&#22871;&#30007;&#38738;&#24180;&#26102;&#23578;&#20462;&#36523;&#31435;&#39046;&#21452;&#39046;&#20241;&#38386;&#39532;&#30002;', 'http://img03.taobaocdn.com/bao/uploaded/i3/15004026344767416/T1CGXDFh0bXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=26807344613&spm=2014.21601761.0.0', '70.00', '10.00', 10, '', 54, 1380729600, 'buyer', 'ػľ', 1380211200, 1, 0, 0, 0, 0, 994, 0, 72160571, 1, 'http://www.taobao.com', 0),
(5, '17788481876', '&#31179;&#20908;&#35013;&#26032;&#27454;&#20462;&#36523;&#30007;&#22763;&#32701;&#32466;&#26825;&#39532;&#30002;&#30007; &#21152;&#32933;&#21152;&#22823;&#26825;&#39532;&#22841;&#30007;&#25340;&#33394;&#22350;&#32937;&#28526;&#30007;', 'http://img04.taobaocdn.com/bao/uploaded/i4/19976040543924078/T1T_16Ff0XXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=17788481876&spm=2014.21601761.0.0', '298.00', '10.00', 10, '', 54, 1380816000, 'buyer', 'Ʒװ', 1380211200, 1, 0, 0, 0, 0, 10, 1, 102587643, 1, 'http://www.taobao.com', 0),
(6, '18478930165', '2013&#26032;&#27454;&#22799;&#31179;&#35013;&#38889;&#29256;&#22899;&#38634;&#32442;&#34923; &#22823;&#30721;&#20462;&#36523;&#34174;&#19997;&#19978;&#34915;T&#24676;&#22899;&#35013;&#34924;&#34923;&#25171;&#24213;&#34923;', 'http://img03.taobaocdn.com/bao/uploaded/i3/11338027210377425/T1JNezFhBXXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=18478930165&spm=2014.21601761.0.0', '118.00', '10.00', 10, '', 48, 1380988800, 'seller', 'ɯ콢', 1380384000, 1, 0, 0, 0, 0, 10, 1, 68287084, 1, 'http://www.taobao.com', 0),
(8, '19692926435', '2013&#26032;&#27454;&#38889;&#29256;&#20462;&#36523;&#26174;&#30246;&#26102;&#23578;&#28526;&#27969;&#26377;&#22411;&#30007;&#36861;&#22899;&#24517;&#22791;&#33391;&#21697;', 'http://img04.taobaocdn.com/bao/uploaded/i4/15003026765861317/T1MHX9Fh0gXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=19692926435&spm=2014.21601761.0.0', '218.00', '10.00', 10, 'http://item.taobao.com/item.htm?spm=a2106.m895.1000384.159.8pRCdv&id=19692926435&scm=1029.newlist-0.tagstd.50000436&ppath=&sku=&ug=', 134, 1383148800, 'seller', '105lin', 1381507200, 500, 0, 0, 0, 0, 10, 0, 105326248, 1, 'http://item.taobao.com/item.htm?spm=a2106.m895.1000384.159.8pRCdv&id=19692926435&scm=1029.newlist-0.tagstd.50000436&ppath=&sku=&ug=', 32),
(9, '27602000236', '&#27874;&#23572;&#35867;&#22855;2013&#31179;&#20908;&#26032;&#27454;&#30495;&#30382;&#38634;&#22320;&#22899;&#38795;&#30701;&#38772;&#31895;&#36319;&#21450;&#35064;&#38772;&#26102;&#23578;&#39640;&#36319;&#22899;&#38772;&#23376;', 'http://img01.taobaocdn.com/bao/uploaded/i1/13876028456925068/T1gqS5FepfXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=27602000236&amp;spm=2014.21601761.0.0', '698.00', '137.00', 30, '', 0, 1382112000, 'buyer', '&#27874;&#23572;&#35867;&#22855;&#26071;&#33328;&#24215;', 1381507200, 100, 0, 0, 0, 0, 0, 0, 61180465, 0, NULL, 0),
(10, '21366923101', '&#25105;&#26159;&#20013;&#22269;&#20154;&#27665;&#35299;&#25918;&#20891;&#31532;&#19968;&#20891;&#31532;&#20108;&#28846;&#20853;&#26053;&#20108;&#25490;&#19977;&#29677;&#29677;&#38271;', 'http://img04.taobaocdn.com/imgextra/i4/850374829/T29HXMXuhXXXXXXXXX-850374829.jpg', 'http://item.taobao.com/item.htm?id=21366923101&amp;spm=2014.21601761.0.0', '296.00', '0.00', 10, '', 79, 1383148800, 'seller', 'relax1370277', 1381507200, 50, 0, 0, 0, 0, 0, 0, 68261494, 1, NULL, 32);

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

--
-- Ľṹ `goods`
--

CREATE TABLE IF NOT EXISTS `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num_iid` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `pic_url` text NOT NULL,
  `detail_url` text NOT NULL,
  `price` decimal(10,2) DEFAULT '0.00',
  `coupon_price` decimal(10,2) DEFAULT '0.00',
  `num` int(11) DEFAULT '0',
  `create_user_id` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT '0',
  `description` text,
  `category_id` int(11) DEFAULT '0',
  `end_time` int(11) DEFAULT '0',
  `volume` int(6) DEFAULT '0',
  `promote_id` int(11) DEFAULT '0',
  `freight_payer` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `begin_time` int(11) DEFAULT '0',
  `pindao_id` int(11) DEFAULT '0',
  `commission_rate` decimal(10,2) DEFAULT NULL,
  `sort` int(11) DEFAULT '0',
  `flag` int(2) NOT NULL DEFAULT '0' COMMENT 'ϱ־λ',
  `sid` varchar(20) CHARACTER SET gb2312 DEFAULT NULL COMMENT 'SID',
  `delist_time` int(11) NOT NULL DEFAULT '0' COMMENT '¼ʱ',
  PRIMARY KEY (`id`),
  KEY `promote_id` (`promote_id`),
  KEY `category_id` (`category_id`),
  KEY `pindao_id` (`pindao_id`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=296 ;

--
-- תе `goods`
--

INSERT INTO `goods` (`id`, `num_iid`, `title`, `pic_url`, `detail_url`, `price`, `coupon_price`, `num`, `create_user_id`, `create_time`, `description`, `category_id`, `end_time`, `volume`, `promote_id`, `freight_payer`, `nick`, `begin_time`, `pindao_id`, `commission_rate`, `sort`, `flag`, `sid`, `delist_time`) VALUES
(295, '19939245674', '&#21490;&#29790;&#22827;2013&#26032;&#27454;&#30007;&#22763;&#20908;&#35013;&#31435;&#39046;&#38889;&#29256;&#32701;&#32466;&#26381;&#30007;&#27491;&#21697;&#28165;&#20179;&#30701;&#27454;&#20462;&#36523;&#21152;&#21402;&#28526;', 'http://img01.taobaocdn.com/bao/uploaded/i1/17362029123996551/T1fg2MFiFaXXXXXXXX_!!0-item_pic.jpg', 'http://taoniupincom.uz.taobao.com', '1299.00', '200.00', 2163, 0, 1383491981, '', 59, 1396195200, 0, 29, 'seller', '&#21490;&#29790;&#22827;&#26071;&#33328;&#24215;', 1383408000, 2, NULL, 0, 0, '71056726', 1383966032),
(294, '35214122901', '&#27491;&#23447;&#36195;&#21335;&#33040;&#27225;&#27743;&#35199;&#29305;&#20135;&#36195;&#21335;&#29305;&#20135;&#20449;&#20016;&#33040;&#27225;&#26032;&#40092;&#27700;&#26524;&#33040;&#27225;20&#26020;&#20845;&#30465;&#21253;&#37038;', 'http://img02.taobaocdn.com/bao/uploaded/i2/13152041057800299/T1arYpFadaXXXXXXXX_!!0-item_pic.jpg', 'http://taoniupincom.uz.taobao.com', '118.00', '69.00', 49654, 0, 1383491918, '', 103, 1398787200, 0, 29, 'buyer', 'lvzuofei', 1383408000, 1, NULL, 0, 0, '33396687', 0);

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

--
-- Ľṹ `goods_apply`
--

CREATE TABLE IF NOT EXISTS `goods_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num_iid` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `pic_url` text NOT NULL,
  `detail_url` text NOT NULL,
  `price` decimal(10,2) DEFAULT '0.00',
  `coupon_price` decimal(10,2) DEFAULT '0.00',
  `num` int(11) DEFAULT '0',
  `create_user_id` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT '0',
  `description` text,
  `category_id` int(11) DEFAULT '0',
  `end_time` int(11) DEFAULT '0',
  `freight_payer` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `begin_time` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `pindao_id` int(11) DEFAULT '0',
  `ga_type` int(2) NOT NULL DEFAULT '0' COMMENT '',
  `ga_re` varchar(200) CHARACTER SET gbk COLLATE gbk_bin NOT NULL COMMENT '˻ص',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `pindao_id` (`pindao_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=21 ;

--
-- תе `goods_apply`
--

INSERT INTO `goods_apply` (`id`, `num_iid`, `title`, `pic_url`, `detail_url`, `price`, `coupon_price`, `num`, `create_user_id`, `create_time`, `description`, `category_id`, `end_time`, `freight_payer`, `nick`, `begin_time`, `status`, `pindao_id`, `ga_type`, `ga_re`) VALUES
(7, '21954531434', 'M&#35760;&#22836;&#23618;&#29275;&#30382; &#27431;&#32654;&#22823;&#29260;&#33539;&#30495;&#30382;&#25163;&#25343;&#21253; &#31616;&#32422;&#22823;&#27668;&#38065;&#21253;&#21345;&#21253;&#32858;&#20250;&#26202;&#23476;&#21253;', 'http://img02.taobaocdn.com/bao/uploaded/i2/17022026749927019/T1GhqiFe8cXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=21954531434&amp;spm=2014.21601761.0.0', '249.00', '209.00', 0, 0, 1377581031, '', 96, 1378137600, 'buyer', 'hanlu19830823', 1377532800, 0, 0, 0, ''),
(8, '21958867780', '&#38889;&#22269;&#23448;&#32593;&#21516;&#27454;&#25758;&#33394;&#20449;&#23553;&#21253; &#31616;&#32422;&#23567;&#40575;&#25163;&#25552;&#21253; &#26012;&#36328;&#21253; &#37197;&#38646;&#38065;&#21253;', 'http://img01.taobaocdn.com/bao/uploaded/i1/15955026428188576/T1leyhFlpcXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=21958867780&amp;spm=2014.21601761.0.0', '108.00', '108.00', 0, 0, 1377581491, '', 92, 1378137600, 'buyer', '&#21507;&#39281;&#21862;&#25745;&#30528;&#21862;', 1377532800, 0, 0, 0, ''),
(9, '19721330524', 'CANDY &#28526;&#34955; 13&#31179;&#23395;&#29190;&#27454;&#22797;&#21476;&#40132;&#40060;&#32441;&#30952;&#30722;&#29275;&#30382;&#30495;&#30382;&#22823;&#21495;&#21333;&#32937;&#25163;&#25552;&#22823;&#21253;', 'http://img04.taobaocdn.com/bao/uploaded/i4/13337026589752533/T10_5mFdpdXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=19721330524&amp;spm=2014.21601761.0.0', '135.00', '135.00', 0, 0, 1377581671, '', 92, 1378137600, 'buyer', 'candy&#28526;&#29260;&#23567;&#38138;', 1377532800, 0, 0, 0, ''),
(10, '17788481876', '&#31179;&#20908;&#35013;&#26032;&#27454;&#20462;&#36523;&#30007;&#22763;&#32701;&#32466;&#26825;&#39532;&#30002;&#30007; &#21152;&#32933;&#21152;&#22823;&#26825;&#39532;&#22841;&#30007;&#25340;&#33394;&#22350;&#32937;&#28526;&#30007;', 'http://img04.taobaocdn.com/bao/uploaded/i4/19976040543924078/T1T_16Ff0XXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=17788481876&spm=2014.21601761.0.0', '298.00', '10.00', 10, 0, 1380283647, '', 54, 1380816000, 'buyer', 'Ʒװ', 1380211200, 1, 0, 1, ''),
(11, '26807344613', '&#32654;&#29305;&#26031;&#37030;&#23041;2013&#31179;&#23395;&#26032;&#27454;&#22806;&#22871;&#30007;&#38738;&#24180;&#26102;&#23578;&#20462;&#36523;&#31435;&#39046;&#21452;&#39046;&#20241;&#38386;&#39532;&#30002;', 'http://img03.taobaocdn.com/bao/uploaded/i3/15004026344767416/T1CGXDFh0bXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=26807344613&spm=2014.21601761.0.0', '70.00', '10.00', 10, 0, 1380283690, '', 54, 1380816000, 'buyer', 'ػľ', 1380211200, 1, 0, 1, ''),
(12, '27467856454', '&#26708;&#29066;{AA0727}&#31179;&#35013;&#26032;&#21697;V&#39046;&#34924;&#34923;&#20551;&#20108;&#20214;&#23485;&#26494;&#22871;&#22836;&#36830;&#24125;&#22823;&#30721;&#22899;&#35013;&#38024;&#32455;&#34923;', 'http://img01.taobaocdn.com/bao/uploaded/i1/17665028108865493/T1KeuUFbFcXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=27467856454&spm=2014.21601761.0.0', '79.00', '20.00', 30, 0, 1380283763, '', 48, 1380816000, 'buyer', 'obuy_orangebear68', 1380211200, 1, 0, 1, ''),
(13, '27497468839', '&#27431;&#34174;2013&#26032;&#27454;&#31179;&#20908;&#21152;&#22823;&#30721;&#22899;&#35013;&#32982;mm&#38889;&#29256;&#20462;&#36523;&#36830;&#34915;&#35033;&#35961;&#28857;&#32972;&#24515;&#35033;&#28909;&#21334;', 'http://img04.taobaocdn.com/bao/uploaded/i4/11203027785976823/T1cv5RFgdcXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=27497468839&spm=2014.21601761.0.0', '125.00', '10.00', 3, 0, 1380283829, '', 48, 1380816000, 'buyer', '˺Ǯ', 1380211200, 1, 0, 1, ''),
(14, '18478930165', '2013&#26032;&#27454;&#22799;&#31179;&#35013;&#38889;&#29256;&#22899;&#38634;&#32442;&#34923; &#22823;&#30721;&#20462;&#36523;&#34174;&#19997;&#19978;&#34915;T&#24676;&#22899;&#35013;&#34924;&#34923;&#25171;&#24213;&#34923;', 'http://img03.taobaocdn.com/bao/uploaded/i3/11338027210377425/T1JNezFhBXXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=18478930165&spm=2014.21601761.0.0', '118.00', '10.00', 10, 0, 1380461133, '', 48, 1380988800, 'seller', 'ɯ콢', 1380384000, 1, 0, 1, ''),
(15, '15165185265', 'WOOG 2013&#31179;&#35013;&#26032;&#27454;&#30007;&#22763;&#32431;&#30333;&#33394;v&#39046;&#38271;&#34966;T&#24676; &#28526;&#27969;&#38889;&#29256;&#20462;&#36523;&#32431;&#33394;&#25171;&#24213;&#34923;', 'http://img02.taobaocdn.com/bao/uploaded/i2/16057028321509800/T1nyxGXB4fXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=15165185265&spm=2014.21601761.0.0', '118.00', '10.00', 10, 0, 1380959180, '', 54, 1381507200, 'seller', 'woog2005콢', 1380902400, 1, 0, 1, ''),
(16, '16665214445', '2013&#26149;&#31179;&#26032;&#27454;&#20241;&#38386;&#21697;&#29260;&#30007;&#35013;V&#39046;&#21152;&#22823;&#30721;&#20462;&#36523;&#30007;&#22763;&#38889;&#29256;&#38271;&#34966;t&#24676; &#30007; &#28526;&#20010;', 'http://img04.taobaocdn.com/bao/uploaded/i4/19241018722771154/T1ko.qXm0XXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=16665214445&spm=2014.21601761.0.0', '128.00', '10.00', 10, 0, 1380959440, '', 54, 1381507200, 'buyer', 'txk81688', 1380902400, 0, 0, 1, ''),
(17, '17363550989', '&#31179;&#35013;2013&#26032;&#27454;&#28526;&#30007;&#35013;&#25171;&#24213;&#34923;&#38889;&#29256;&#20462;&#36523;&#32431;&#26825;&#22806;&#36152;&#20241;&#38386;&#30007;&#22303;&#38271;&#34966;t&#24676;&#30007;&#27454;', 'http://img02.taobaocdn.com/bao/uploaded/i2/19155025053777890/T1d1gtXnFXXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=17363550989&spm=2014.21601761.0.0', '80.00', '10.00', 10, 0, 1380959619, '', 54, 1381507200, 'buyer', '껪tzy', 1380902400, 0, 1, 1, ''),
(18, '15994871125', '&#29305;&#20215;&#39321;&#28207; &#19971;&#21305;&#29436; &#31179;&#35013;&#30007;&#35013;&#38271;&#34966;T&#24676; &#29190;&#27454;&#20013;&#24180;&#32431;&#26825;&#36136;T&#24676; &#32763;&#39046;&#23485;&#26494;&#22411;', 'http://img02.taobaocdn.com/bao/uploaded/i2/10115027814111588/T11NV4FXlgXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=15994871125&spm=2014.21601761.0.0', '588.00', '10.00', 10, 0, 1380959736, '', 54, 1381507200, 'seller', 'yaohaijian_2008', 1380902400, 0, 0, 1, ''),
(19, '19692926435', '&#21697;&#29260;&#30007;&#35013;2013&#31179;&#35013;&#26032;&#27454; &#21170;&#38712;&#30007;&#22763;&#38271;&#34966;T&#24676;&#34923;&#30007;&#24335;&#32763;&#39046;&#20010;&#24615;&#26102;&#23578;&#30007;t&#24676;', 'http://img04.taobaocdn.com/bao/uploaded/i4/15003026765861317/T1MHX9Fh0gXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=19692926435&spm=2014.21601761.0.0', '218.00', '10.00', 10, 0, 1380959858, 'http://item.taobao.com/item.htm?spm=a2106.m895.1000384.159.8pRCdv&id=19692926435&scm=1029.newlist-0.tagstd.50000436&ppath=&sku=&ug=', 54, 1381507200, 'seller', '105lin', 1380902400, 1, 0, 1, ''),
(20, '14847140490', '&#38134;&#36713; &#31179;&#23395;&#22899;&#35013;&#36830;&#24125;&#20462;&#36523;&#29275;&#20180;&#34915;&#19978;&#34915; &#29275;&#20180;&#22806;&#22871;&#22899;&#38271;&#34966;&#30701;&#27454;&#38889;&#29256;&#28526;&#26149;&#31179;', 'http://img04.taobaocdn.com/bao/uploaded/i4/18298028945518620/T1usYgFn4gXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=14847140490&spm=2014.21601761.0.0', '278.00', '10.00', 0, 0, 1381039782, '', 147, 1381593600, 'seller', 'inxuan콢', 1380988800, 1, 1, 0, '');

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

--
-- Ľṹ `jifen_log`
--

CREATE TABLE IF NOT EXISTS `jifen_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` char(32) NOT NULL,
  `jifen` int(11) NOT NULL,
  `nick` varchar(100) NOT NULL,
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=16 ;

--
-- תе `jifen_log`
--

INSERT INTO `jifen_log` (`id`, `uid`, `jifen`, `nick`, `create_time`) VALUES
(1, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1374913041),
(2, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1374988759),
(3, 'd4ffd8c24a201e39ec9940e9f046ed16', 2, 'a***s', 1375084397),
(4, 'd4ffd8c24a201e39ec9940e9f046ed16', 2, 'a***s', 1375174688),
(5, 'd4ffd8c24a201e39ec9940e9f046ed16', 2, 'a***s', 1375245009),
(6, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1378348373),
(7, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1378953767),
(8, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1380364888),
(9, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1380459375),
(10, 'd4ffd8c24a201e39ec9940e9f046ed16', 2, 'a***s', 1380555320),
(11, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1380942010),
(12, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1381023559),
(13, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1381563675),
(14, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1381804284),
(15, 'd4ffd8c24a201e39ec9940e9f046ed16', 1, 'a***s', 1382411933);

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

--
-- Ľṹ `lottery_log`
--

CREATE TABLE IF NOT EXISTS `lottery_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jifen` int(11) NOT NULL,
  `ltime` int(11) NOT NULL,
  `nick` varchar(50) NOT NULL,
  `uid` varchar(50) NOT NULL,
  `prize` int(11) DEFAULT '0',
  `gift_id` int(11) NOT NULL DEFAULT '0',
  `exchange_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `gift_id` (`gift_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `merchant_white_list`
--

CREATE TABLE IF NOT EXISTS `merchant_white_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taobao_nick` varchar(50) NOT NULL,
  `reported_times` int(11) DEFAULT '0',
  `verify_reported` int(11) DEFAULT '0',
  `status` tinyint(4) DEFAULT '1' COMMENT 'ǷЧ',
  `uid` varchar(100) DEFAULT NULL,
  `shop_pic` text,
  `shop_url` text,
  `sid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `taobao_nick` (`taobao_nick`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `pindao`
--

CREATE TABLE IF NOT EXISTS `pindao` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` char(50) DEFAULT 'goods',
  `name` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `sort` int(11) DEFAULT '0',
  `disabled` int(11) DEFAULT '0',
  `thumb` text,
  `banner` text,
  `description` text,
  `author` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

--
-- תе `pindao`
--

INSERT INTO `pindao` (`id`, `type`, `name`, `alias`, `sort`, `disabled`, `thumb`, `banner`, `description`, `author`) VALUES
(1, 'goods', '&#20184;&#37038;&#35797;&#29992;', 'Fuyoushiyonggoods', 0, 0, '', '', '', ''),
(2, 'goods', '&#36891;&#25240;&#25187;', 'Guangzhekou', 0, 0, '', '', '', '');

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

--
-- Ľṹ `promote_position`
--

CREATE TABLE IF NOT EXISTS `promote_position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=45 ;

--
-- תе `promote_position`
--

INSERT INTO `promote_position` (`id`, `name`, `type`, `alias`, `title`) VALUES
(15, '-ͼƬ淶', 'article', 'tupianguifan', 'ͼƬ淶'),
(33, '&#20170;&#26085;&#31186;&#26432;', 'goods', 'meirimiaosha', '&#20170;&#26085;&#31186;&#26432;'),
(16, '-LOGO̳', 'article', 'logojiaocheng', 'LOGO̳'),
(11, '-Ŷӽ', 'article', 'tuanduijieshao', 'Ŷӽ'),
(32, '&#39318;&#39029;&#20813;&#36153;&#30333;&#25343;', 'goods', 'HomeBaiNa', '&#39318;&#39029;&#20813;&#36153;&#30333;&#25343;'),
(13, '-Υ̼Ҵ', 'article', 'weiguichufa', 'Υ̼Ҵ'),
(14, '-̼α', 'article', 'shangjiabaoming', '̼α'),
(10, '-̹', 'article', 'zhaoshangguize', '̹'),
(17, '-ļֵ', 'article', 'hexinjiazhi', 'ļֵ'),
(18, '-ٷ', 'article', 'guanfangbangpai', 'ٷ'),
(19, '-Ʒƺƹ', 'article', 'pingpaihezuo', 'Ʒƺƹ'),
(20, '-Ӫ', 'article', 'yinxiaozhongxin', 'Ӫ'),
(21, '-˽', 'article', 'yinsizhengce', '˽'),
(22, '-', 'article', 'jiameng', ''),
(23, '-ϵ', 'article', 'lianxiwomen', 'ϵ'),
(24, '-ʲô', 'article', 'shisheme', 'ʲô'),
(25, '-ôѡϲı', 'article', 'tiaoxuan', 'ôѡϲı'),
(26, '-۸̼Ҳһ', 'article', 'buyizhi', '۸̼Ҳһ'),
(27, '-ǩֶһ', 'article', 'jifenduihuan', 'ǩֶһ'),
(28, '-´ô', 'article', 'xiaci', '´ô'),
(29, '&#39318;&#39029;&#36891;&#25240;&#25187;&#19987;&#21306;', 'goods', 'Homezhekou', '&#39318;&#39029;&#36891;&#25240;&#25187;&#19987;&#21306;'),
(30, '&#39318;&#39029;&#20184;&#37038;&#35797;&#29992;&#19987;&#21306;', 'goods', 'Hometry', '&#39318;&#39029;&#20184;&#37038;&#35797;&#29992;&#19987;&#21306;'),
(31, '&#39318;&#39029;&#28909;&#21334;&#23453;&#36125;&#25512;&#33616;', 'goods', 'Homeremai', '&#39318;&#39029;&#28909;&#21334;&#23453;&#36125;&#25512;&#33616;'),
(34, '&#29190;&#27454;&#28909;&#21334;', 'goods', 'baokuanremai', '&#29190;&#27454;&#28909;&#21334;'),
(35, 'Ůװ', 'goods', '1nvzhuang', 'Ůװ'),
(36, 'װ', 'goods', '2nanzhuang', 'װ'),
(37, '', 'goods', '3neiyi', ''),
(38, 'Ь', 'goods', '4xiezi', 'Ь'),
(39, '', 'goods', '5baobao', ''),
(40, '', 'goods', '6hufu', ''),
(41, 'ʳ', 'goods', '7meishi', 'ʳ'),
(42, 'ĸӤ', 'goods', '8muying', 'ĸӤ'),
(43, 'Ӽ', 'goods', '9jujia', 'Ӽ'),
(44, '', 'goods', '10qita', '');

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

--
-- Ľṹ `qiushi`
--

CREATE TABLE IF NOT EXISTS `qiushi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `create_time` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `shop`
--

CREATE TABLE IF NOT EXISTS `shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nick` varchar(255) NOT NULL,
  `shop_title` varchar(255) DEFAULT NULL,
  `category_id` int(11) DEFAULT '0',
  `pic_url` text,
  `description` text,
  `good_times` int(11) DEFAULT '0',
  `bad_times` int(11) DEFAULT '0',
  `promote_id` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT '0',
  `detail_url` text,
  `clicks` int(11) DEFAULT '0',
  `sid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `promote_id` (`promote_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `site_config`
--

CREATE TABLE IF NOT EXISTS `site_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text,
  `alias` varchar(255) NOT NULL,
  `tips` text,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=15 ;

--
-- תе `site_config`
--

INSERT INTO `site_config` (`id`, `name`, `value`, `alias`, `tips`, `type`) VALUES
(1, 'վַ', 'http://taoniupincome.uz.taobao.com', 'siteUrl', NULL, 'system'),
(2, 'ͷ', '۹Ӱ', 'wangwang', NULL, 'system'),
(3, 'ɵַ', 'http://taoniupincom.uz.taobao.com', 'bangpai', NULL, 'system'),
(4, 'appkey', '21601761', 'appkey', NULL, 'system'),
(5, 'secretKey', '266a3fc46d5a1bf489a837c7fd588740', 'secretKey', NULL, 'system'),
(6, 'pid', '45019753', 'pid', NULL, 'system'),
(8, 'LOGOַ', '/assets/tejia/img/logo.png', 'logo', NULL, 'system'),
(9, '', '', 'title_limit', NULL, 'system'),
(10, 'վ', 'ţƷ', 'siteName', NULL, 'system'),
(11, 'ͼƬ', '/assets/tejia/img/weitao.jpg', 'tupian', NULL, 'system'),
(12, 'ͼƬ1', '/assets/tejia/img/footer_logo.jpg', 'tupian1', NULL, 'system'),
(13, 'ͼƬ2', 'http://my.taobao.com/UOm8WvGc0OmIS/', 'tupian2', NULL, 'system'),
(14, 'ͼƬ3', 'http://img02.taobaocdn.com/imgextra/i2/850374829/T2pl8dXw0aXXXXXXXX_!!850374829.jpg', 'tupian3', NULL, 'system');

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

--
-- Ľṹ `topic`
--

CREATE TABLE IF NOT EXISTS `topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `link` text,
  `category_id` int(11) DEFAULT '0',
  `thumb` text,
  `description` text,
  `content` text,
  `sort` int(11) DEFAULT '0',
  `alias` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `trade_sheet`
--

CREATE TABLE IF NOT EXISTS `trade_sheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trade_id` int(11) NOT NULL,
  `num_iid` int(11) NOT NULL,
  `buy_time` int(11) NOT NULL,
  `free_take_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

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

--
-- Ľṹ `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(100) NOT NULL,
  `nick` varchar(100) NOT NULL,
  `jifen` int(11) DEFAULT '0',
  `signinlasttime` int(11) DEFAULT '0',
  `signinday` int(11) DEFAULT '0',
  `name` char(20) DEFAULT NULL,
  `wangwang` char(100) DEFAULT NULL,
  `address` text,
  `phone` char(20) DEFAULT NULL,
  `zip` char(7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=11 ;

--
-- תе `user`
--

INSERT INTO `user` (`id`, `uid`, `nick`, `jifen`, `signinlasttime`, `signinday`, `name`, `wangwang`, `address`, `phone`, `zip`) VALUES
(10, 'd4ffd8c24a201e39ec9940e9f046ed16', 'a***s', 7, 1382411933, 0, NULL, NULL, NULL, NULL, NULL);
