-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- : localhost
-- : 2011  01  23  06:56
-- 汾: 5.0.51
-- PHP 汾: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- ݿ: `companyjd`
--

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

--
-- Ľṹ `about`
--

CREATE TABLE IF NOT EXISTS `about` (
  `id` int(11) NOT NULL auto_increment,
  `content` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

--
-- е `about`
--

INSERT INTO `about` (`id`, `content`) VALUES
(1, '<P>"ʵ,ڷ,"ĽϢṩ뿪ϣΪʿṩõ꾡ϢΪʿ̻Ϣƽ̨磬ѰͬеŦǵּùҵͻܵСĸֵĻر</P>\r\n<LI>ϵʽ</LI>\r\n<LI>E-mail:postmaster@ee-today.cn</LI>\r\n<LI>algerwo@yahoo.com</LI>\r\n<LI>MSN: algerwo@hotmail.com</LI>\r\n<LI>Add.: Ϻֶ˽20203 ʱ201323  (Mr. Wu , Zhenxing Street Nr.20,Room 203,Pudong District,ShangHai P.R. China)(Post Code 201323)</LI>\r\n<LI>Tel:021-58101772</LI>\r\n<LI>Mobil:18964029557</LI>'),
(2, 'ϵʽ\r\n<br>E-mail:postmaster@ee-today.cn\r\n<br>algerwo@yahoo.com\r\n<br>MSN:&nbsp;algerwo@hotmail.com\r\n<br>Add.:&nbsp;Ϻֶ˽20203&nbsp;ʱ201323&nbsp;&nbsp;(Mr.&nbsp;Wu&nbsp;,&nbsp;Zhenxing&nbsp;Street&nbsp;Nr.20,Room&nbsp;203,Pudong&nbsp;District,ShangHai&nbsp;P.R.&nbsp;China)(Post&nbsp;Code&nbsp;201323)\r\n<br>Tel:021-58101772\r\n<br>Mobil:18964029557');

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

--
-- Ľṹ `active`
--

CREATE TABLE IF NOT EXISTS `active` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL,
  `author` varchar(50) default NULL,
  `ntime` varchar(20) NOT NULL,
  `hits` int(8) NOT NULL default '0',
  `content` longtext,
  `istop` tinyint(3) default '0',
  `photo` varchar(255) default NULL,
  `show` varchar(50) default NULL,
  `times` int(11) default '0',
  `subcat` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=9 ;

--
-- е `active`
--

INSERT INTO `active` (`id`, `title`, `author`, `ntime`, `hits`, `content`, `istop`, `photo`, `show`, `times`, `subcat`) VALUES
(2, 'ϺйľĺͶ⿪ų֮һ', '', '07/04/02', 27, 'ϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һϺйľĺͶ⿪ų֮һ', 0, '20070402050701217.jpg', '', 0, '˾'),
(3, '¹EBRO޷', '', '11/01/14', 7, '¹EBRO޷ŵ¹EBRO޷', 0, '', '', 0, '˾ף'),
(4, '¹EBRO޷', '', '11/01/14', 6, '¹EBRO޷ŵ¹EBRO޷ŵ¹EBRO޷ŵ¹EBRO޷ŵ¹EBRO޷', 1, './upfiles/20110114095401884.gif', '', 0, '˾'),
(5, 'ͼݵȼװϺ', '', '11/01/16', 4, '<P>ͼݵȼװϺͼݵȼװϺ</P>', 0, '', '', 0, '˾ף'),
(6, '¹˾', '', '11/01/16', 3, '<SPAN class=STYLE4><STRONG><FONT size=3>¹˾<SPAN class=STYLE4>¹˾<SPAN class=STYLE4><FONT size=3>¹˾<SPAN class=STYLE4>¹˾<SPAN class=STYLE4><FONT size=3>¹˾</FONT></SPAN></SPAN></FONT></SPAN></SPAN></FONT></STRONG></SPAN>', 0, '', '', 0, '˾ף'),
(7, 'սҵʱ', '', '11/01/16', 3, 'սҵʱҵҪͣչԼĲƷͷг ȻһЩչоȡýϺõķչǵഫͳó׻黹ԸٴηΪҪĿг ʹصľ˥֮ʱ˾ʱһȫԸԣͳг \r\n<DIV>&nbsp;</DIV>\r\n<DIV>гصĿ˾עԼҪʲô ҪӪȻҪȷƷгԼۺͷ огϳ˻ᣬҵҪںδҵ</DIV>', 0, '', '', 0, '˾'),
(8, 'ս', '', '11/01/16', 6, 'սսҵʱҵʱսҵʱսҵʱսҵսҵʱʱ', 1, './upfiles/20110116081945153.gif', '', 0, '˾');

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

--
-- Ľṹ `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `uid` int(11) NOT NULL auto_increment,
  `user` varchar(10) NOT NULL,
  `pass` varchar(15) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

--
-- е `admin`
--

INSERT INTO `admin` (`uid`, `user`, `pass`) VALUES
(1, 'admin', 'admin');

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

--
-- Ľṹ `article`
--

CREATE TABLE IF NOT EXISTS `article` (
  `id` int(11) NOT NULL auto_increment,
  `subcat` varchar(50) default NULL,
  `title` varchar(150) NOT NULL,
  `author` varchar(50) default NULL,
  `ntime` varchar(20) NOT NULL,
  `hits` int(8) NOT NULL default '0',
  `content` longtext,
  `istop` tinyint(3) default '0',
  `photo` varchar(255) default NULL,
  `show` varchar(50) default NULL,
  `times` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=12 ;

--
-- е `article`
--

INSERT INTO `article` (`id`, `subcat`, `title`, `author`, `ntime`, `hits`, `content`, `istop`, `photo`, `show`, `times`) VALUES
(9, 'ҵ', 'Ƶչ̨ý', '', '11/01/17', 15, 'Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨', 0, './upfiles/20110117131007280.gif', '', 0),
(11, 'ҵ', 'ҵҵ', '', '11/01/19', 2, '<A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A><A href="http://localhost/eetodayenterprise/admin/article.php?act=add" target=main>ҵ</A>', 1, './upfiles/20110119135639351.gif', '', 0),
(8, 'ҵӪ', 'Ƶչ̨ýУ԰㲥̨', '', '11/01/17', 8, 'Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨Ƶչ̨ýУ԰㲥̨', 1, './upfiles/20110118090302118.gif', '', 0),
(10, 'ҵӪ', 'ҵӪҵӪҵӪҵӪҵ', '', '11/01/19', 2, 'ҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪҵӪ', 0, '', '', 0);

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

--
-- Ľṹ `bbs`
--

CREATE TABLE IF NOT EXISTS `bbs` (
  `id` int(11) NOT NULL auto_increment,
  `content` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

--
-- е `bbs`
--

INSERT INTO `bbs` (`id`, `content`) VALUES
(1, '<p><strong>sdfsdfdsfsd</strong></p>\r\n<p><strong><em>fgfdgdfgdg</em></strong></p>\r\n<p><img src="http://localhost/new/images/02.gif" alt="" /></p>');

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

--
-- Ľṹ `board`
--

CREATE TABLE IF NOT EXISTS `board` (
  `id` int(11) NOT NULL auto_increment,
  `catname` varchar(50) NOT NULL,
  `boardmaster` varchar(150) default NULL,
  `readme` varchar(255) default NULL,
  `setting1` tinyint(3) default '0',
  `setting2` tinyint(3) default '0',
  `topicnum` tinyint(3) default '0',
  `totaltopic` tinyint(3) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ;

--
-- е `board`
--

INSERT INTO `board` (`id`, `catname`, `boardmaster`, `readme`, `setting1`, `setting2`, `topicnum`, `totaltopic`) VALUES
(1, '', 'test', '', 0, 0, 1, 1),
(2, 'Աר', 'test', 'Աר', 1, 0, 3, 7),
(3, '', 'test', '', 0, 0, 0, 0),
(4, '˾', '', '۹˾,.', 0, 0, 0, 0);

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

--
-- Ľṹ `download`
--

CREATE TABLE IF NOT EXISTS `download` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `url` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

--
-- е `download`
--

INSERT INTO `download` (`id`, `title`, `url`) VALUES
(1, '', './upfiles/20101008140910118.gif'),
(2, '', './upfiles/20110105145112397.doc');

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

--
-- Ľṹ `greeting`
--

CREATE TABLE IF NOT EXISTS `greeting` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(12) NOT NULL,
  `jieshou` varchar(12) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` mediumtext NOT NULL,
  `islook` tinyint(2) NOT NULL default '1',
  `issend` tinyint(2) NOT NULL default '0',
  `addtime` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

--
-- е `greeting`
--

INSERT INTO `greeting` (`id`, `username`, `jieshou`, `title`, `content`, `islook`, `issend`, `addtime`) VALUES
(1, 'admin', 'alanliu', 'test', 'testtesttesttest', 0, 0, 'tt'),
(2, 'alanliu', 'admin', 'test1', 'test1test1test1', 0, 0, 'dfgfd');

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

--
-- Ľṹ `jop`
--

CREATE TABLE IF NOT EXISTS `jop` (
  `id` int(11) NOT NULL auto_increment,
  `subcat` varchar(50) default NULL,
  `title` varchar(150) NOT NULL,
  `author` varchar(50) default NULL,
  `ntime` varchar(20) NOT NULL,
  `hits` int(8) NOT NULL default '0',
  `content` longtext,
  `show` varchar(50) default NULL,
  `times` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=9 ;

--
-- е `jop`
--

INSERT INTO `jop` (`id`, `subcat`, `title`, `author`, `ntime`, `hits`, `content`, `show`, `times`) VALUES
(8, 'ְƸ', 'Ƹְ繤ʦ', '', '11/01/16', 14, '<P>վչҪƸְ繤ʦŵģнҪ󶮣</P>\r\n<P>&nbsp;1ASP/ASP.NetPHPJSPԡ</P>\r\n<P>&nbsp;2DreamweaverPhotoshop,Flash, HTML (DIV+CSS)ҳ洦</P>\r\n<P>ߣ뷢<A href="mailto:algerwo@yahoo.com"><FONT color=#077ac7>algerwo@yahoo.com</FONT></A><A href="mailto:postmaster@ee-today.cn"><FONT color=#077ac7>postmaster@ee-today.com </FONT></A> </P><BR>', '', 0);

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

--
-- Ľṹ `jopapply`
--

CREATE TABLE IF NOT EXISTS `jopapply` (
  `id` int(11) NOT NULL auto_increment,
  `truename` varchar(50) default NULL,
  `birth` varchar(20) default NULL,
  `yuanxi` varchar(50) default NULL,
  `zhuanye` varchar(50) default NULL,
  `xueli` tinyint(3) default '1',
  `tel` varchar(20) default NULL,
  `email` varchar(30) default NULL,
  `yiyuan` text,
  `photo` varchar(255) default NULL,
  `jianli` varchar(255) default NULL,
  `pass` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

--
-- е `jopapply`
--

INSERT INTO `jopapply` (`id`, `truename`, `birth`, `yuanxi`, `zhuanye`, `xueli`, `tel`, `email`, `yiyuan`, `photo`, `jianli`, `pass`) VALUES
(1, 'ʵ', '19000101', '', 'ʵ', 1, '021-58101772', 'algerwo@hotmail.com', 'ʵʵʵʵʵʵʵʵʵ', '', '', '20110112074226225');

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

--
-- Ľṹ `linking`
--

CREATE TABLE IF NOT EXISTS `linking` (
  `id` int(11) NOT NULL auto_increment,
  `cat` tinyint(3) default '0',
  `title` varchar(150) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

--
-- е `linking`
--

INSERT INTO `linking` (`id`, `cat`, `title`, `url`) VALUES
(1, 1, '', 'http://www.ee-today.com/'),
(2, 1, '', 'http://www.e-together.net/');

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

--
-- Ľṹ `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL auto_increment,
  `yname` varchar(10) NOT NULL,
  `tel` varchar(15) default NULL,
  `email` varchar(30) default NULL,
  `ip` varchar(20) default NULL,
  `title` varchar(150) NOT NULL,
  `content` longtext,
  `utime` varchar(30) default NULL,
  `hidden` tinyint(3) default '0',
  `review` mediumtext,
  `rtime` varchar(30) default NULL,
  `islock` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=7 ;

--
-- е `messages`
--

INSERT INTO `messages` (`id`, `yname`, `tel`, `email`, `ip`, `title`, `content`, `utime`, `hidden`, `review`, `rtime`, `islock`) VALUES
(2, 'test', '', 'admin@admin.com', '127.0.0.1', 'test', 'test<br />\r\ntest<br />\r\ntest<br />\r\ntest<br />\r\ntest<br />\r\ntest<br />\r\ntest<br />\r\ntest<br />\r\ntest', '2007-03-26 14:04:16', 0, NULL, NULL, 1),
(6, 'alger', '021-58101772', 'algerwo@hotmail.com', '127.0.0.1', 'ݿ', 'ӣǲ鿴ԭ', '2011-01-14 9:03:49', 0, NULL, NULL, 1),
(5, 'alger', '021-58101772', 'algerwo@hotmail.com', '127.0.0.1', 'Ϣ', 'ϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢϢ', '2011-01-07 8:09:12', 0, NULL, NULL, 1);

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

--
-- Ľṹ `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL auto_increment,
  `subcat` varchar(50) default NULL,
  `title` varchar(150) NOT NULL,
  `author` varchar(50) default NULL,
  `ntime` varchar(20) NOT NULL,
  `hits` int(8) NOT NULL default '0',
  `content` longtext,
  `istop` tinyint(3) default '0',
  `photo` varchar(255) default NULL,
  `show` varchar(50) default NULL,
  `times` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=15 ;

--
-- е `news`
--

INSERT INTO `news` (`id`, `subcat`, `title`, `author`, `ntime`, `hits`, `content`, `istop`, `photo`, `show`, `times`) VALUES
(8, 'ҵ', 'ϺйľĺͶ⿪ų֮һ', 'admin', '07/03/27', 4, '<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>\r\n<P>ϺйľĺͶ⿪ų֮һ</P>', 0, '20070327142425382.jpg', '', 0),
(13, '˾', 'ͼݵȼװϺ', '', '10/10/07', 12, 'ͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺͼݵȼװϺ', 0, '', '', 0),
(14, '', 'Ϻйľ', '', '11/01/19', 0, 'ϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľϺйľ', 1, './upfiles/20110119150255665.gif', '', 0);

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

--
-- Ľṹ `precategory`
--

CREATE TABLE IF NOT EXISTS `precategory` (
  `id` int(11) NOT NULL auto_increment,
  `subcat` varchar(50) NOT NULL,
  `category` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=gbk AUTO_INCREMENT=20 ;

--
-- е `precategory`
--

INSERT INTO `precategory` (`id`, `subcat`, `category`) VALUES
(1, '˨', '˾Ʒ'),
(2, '̼', '˾Ʒ'),
(3, '', '˾Ʒ'),
(6, '', '˾Ʒ'),
(9, 'ҵ', 'ҵ'),
(10, 'ҵ', '˾'),
(11, '', '˾'),
(12, '', '˾'),
(14, '˾', '˾'),
(15, '˾ף', '˾'),
(16, '˾', '˾'),
(17, 'ְƸ', 'ҵƸ'),
(18, '̶ְλ', 'ҵƸ'),
(19, 'ҵӪ', 'ҵ');

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

--
-- Ľṹ `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `subcat` varchar(50) default NULL,
  `proID` varchar(50) default NULL,
  `hits` int(8) NOT NULL default '0',
  `tel` varchar(20) default NULL,
  `email` varchar(30) default NULL,
  `introduce` longtext NOT NULL,
  `photo` varchar(255) default NULL,
  `prodetail` varchar(255) default NULL,
  `pass` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=19 ;

--
-- е `product`
--

INSERT INTO `product` (`id`, `name`, `subcat`, `proID`, `hits`, `tel`, `email`, `introduce`, `photo`, `prodetail`, `pass`) VALUES
(7, '¹EBRO', '̼', 'dd', 2, '58101772', 'algerwo@hotmail.com', '¹EBRO޷ ¹EBROķ֮һرڵװõо', '../upfiles/20101010141400504.jpg', '../upfiles/20101010141404838.doc', '20101010141405894'),
(8, '޷', '', 'dddeee', 3, '02158101772', 'algerwo@yahoo.com', '¹EBRO޷ ¹EBROķ֮һرڵװõо', '../upfiles/20101010141549534.jpg', '../upfiles/20101010141554527.jpg', '20101010141556718'),
(9, 'ŷ', '', 'dd', 20, '021-58101772', 'algerwo@yahoo.com', '/ŷ޵ҵﵽµĸ߶ʱ ˾֯ǷͶڴĹ˾ģأ ๫˾ͬսû㹻ʽ֧չ沢 ĿǰνµδгЩ˹гĽޣ', '../upfiles/20101010150258908.jpg', '../upfiles/20101010150304870.jpg', '20101010150305717'),
(10, 'upfiles', '', 'dddeee', 7, '021-58101772', 'algerwo@sina.com', 'upfiles/20101011131335983.pdf', '', '../upfiles/20101011131335983.pdf', '20101011131414343'),
(11, 'upfiles/201010111355', '', 'dddddd', 31, '021-58101772', 'algerwo@sina.com', 'upfiles/', '../upfiles/20101011135456311.jpg', '../upfiles/20101011135528114.pdf', '20101011135551577'),
(12, 'upfiles', '˨', '20101011140103', 33, '021-58101772', 'algerwo@sina.com', '../upfiles/20101011140103737.rar', '', '../upfiles/20101011140103737.rar', '20101011140138461'),
(13, 'Ʒ', '̼', '555555', 39, '021-58101772', 'algerwo@hotmail.com', 'ƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷƲƷ', '../upfiles/20110109140633236.gif', '../upfiles/20110109140656666.doc', '20110109140658726'),
(14, 'Ʒ', '˨', '22222', 8, '58101772', 'algerwo@hotmail.com', 'ƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷƷ', '', '', '20110112100355588'),
(16, 'ϸ', '', '666666666', 15, '58101772', 'algerwo@sina.com', 'ϸ', '', '', '20110112101921878'),
(17, 'Ǳҵȡÿϲɾ', '', '666666', 3, '021-58101772', 'algerwo@hotmail.com', 'Ǳҵȡÿϲɾ͹Ǳҵȡÿϲɾ', '../upfiles/20110121090715522.gif', '../upfiles/20110121090729492.doc', '20110121090730169'),
(18, 'ִ̫', '', '555555', 3, '021-58101772', 'algerwo@hotmail.com', 'ִ̫¼ӳĥ<br /><br />\r\nִ̫¼ӳĥ<br /><br />\r\n', '../upfiles/20110121092410820.gif', '../upfiles/20110121092353955.doc', '20110121092413929');

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

--
-- Ľṹ `review`
--

CREATE TABLE IF NOT EXISTS `review` (
  `id` int(11) NOT NULL auto_increment,
  `tid` tinyint(3) default '1',
  `title` varchar(150) NOT NULL,
  `username` varchar(15) default NULL,
  `content` mediumtext,
  `addtime` varchar(50) default NULL,
  `edittime` varchar(50) default NULL,
  `ip` varchar(20) default NULL,
  `islock` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=37 ;

--
-- е `review`
--

INSERT INTO `review` (`id`, `tid`, `title`, `username`, `content`, `addtime`, `edittime`, `ip`, `islock`) VALUES
(36, 14, '', 'eetoday', 'eetodayeetodayeetoday', '2011-01-14 9:14:36', NULL, '127.0.0.1', 0),
(28, 12, 'dfd', 'admin', 'dsfd', '2007-03-30 9:37:58', NULL, '127.0.0.1', 0),
(31, 12, '', 'admin', 'sfsdfds', '2007-04-16 8:24:11', NULL, '127.0.0.1', 0);

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

--
-- Ľṹ `sccase`
--

CREATE TABLE IF NOT EXISTS `sccase` (
  `nid` int(11) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL,
  `author` varchar(50) default NULL,
  `ntime` varchar(20) NOT NULL,
  `hits` int(8) NOT NULL default '0',
  `content` longtext,
  `show` varchar(50) default NULL,
  `times` int(11) default '0',
  `subcat` varchar(50) default NULL,
  PRIMARY KEY  (`nid`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=15 ;

--
-- е `sccase`
--

INSERT INTO `sccase` (`nid`, `title`, `author`, `ntime`, `hits`, `content`, `show`, `times`, `subcat`) VALUES
(11, 'йĴƷܷŻ', 'admin', '07/03/23', 5, '<P>ѯ˾Trusted SourcesϯѧҼоLarry Brainardܶʾй¾ģʽӻʩת߿ƼҵйĴƷܻܿŻ</P>\r\n<P>BrainardʾΪȫĴƷѹй·չսԽƶʱ֧</P>\r\n<P>Brainard׶ٿCommodities WeekϱʾйͶʽʩزȻһҪƶأйĵ֮ǻĭ</P>\r\n<P>ʩĿͭ͸йľͳԼ··׻ʩBrainardʾйشѹزҵΪϣȫɱһҵζŸȻܻЩŻ</P>\r\n<P>ʾĿǰûмʾƷйڴܺĸҵж̫áBrainardʾҵйߣؽƽũҵõغũͶĸﱻƳ٣ũҵӦĳ󣬲˹Ӧƿ</P>\r\n<P>йڱͳ׵ĳڴBrainardָڽϵ󲻶Ҵȫ״ƫͣй׽ڹת䡣</P>', '', 0, ''),
(13, '̨ܻعƱչ󶼻...', '', '10/10/07', 8, '<P>̨ڼලίԱ(Financial Supervisory Commission)˹Ʊڿعɹ˾(Waterland Financial Holding Co.)չ󶼻ᱣ(MetLife Inc., MET)̨ҵ룬ƹƱȱӪñӹ˾רҵʵʽ</P>\r\n<P>ڼලίԱᷢƣƱصʽԴծ񳥻ƻԼɶͶʵķ谭󶼻ᱣ̨ӹ˾ĽӪ</P>\r\n<P>Ʊؽ4ǩЭ飬1.125Ԫչ󶼻ᱣյ̨ҵͨ㱣ҵʵҵ</P>\r\n<P>һ֮ǰ̨ܻҲв߼޹˾(China Strategic Holdings Ltd.)ǣͷһų21.5Ԫչʼ(American International Group Inc., AIG)̨ӹ˾롣</P>', '', 0, ''),
(14, '¹EBRO޷ ', '', '10/10/10', 4, '¹EBRO޷ ¹EBROķ֮һرڵװõо.¹EBRO޷ ¹EBROķ֮һرڵװõо¹EBRO޷ ¹EBROķ֮һرڵװõо¹EBRO޷ ¹EBROķ֮һرڵװõо¹EBRO޷ ¹EBROķ֮һرڵװõо¹EBRO޷ ¹EBROķ֮һرڵװõо¹EBRO޷ ¹EBROķ֮һرڵװõо', '', 0, '');

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

--
-- Ľṹ `topic`
--

CREATE TABLE IF NOT EXISTS `topic` (
  `id` int(11) NOT NULL auto_increment,
  `bid` tinyint(3) default '1',
  `title` varchar(150) NOT NULL,
  `username` varchar(15) default NULL,
  `content` mediumtext,
  `reviewcount` tinyint(3) default '0',
  `hits` int(11) default '0',
  `istop` tinyint(3) default '0',
  `iselite` tinyint(3) default '0',
  `addtime` varchar(50) default NULL,
  `edittime` varchar(50) default NULL,
  `reviewtime` varchar(50) default NULL,
  `revieuser` varchar(15) default NULL,
  `ip` varchar(20) default NULL,
  `islock` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=21 ;

--
-- е `topic`
--

INSERT INTO `topic` (`id`, `bid`, `title`, `username`, `content`, `reviewcount`, `hits`, `istop`, `iselite`, `addtime`, `edittime`, `reviewtime`, `revieuser`, `ip`, `islock`) VALUES
(4, 0, 'dfgdfg', 'test', 'dfgfdgdf', 0, 38, 0, 0, '2007-03-30 7:16:25', NULL, '2007-03-30 7:16:25', 'test', '127.0.0.1', 0),
(12, 2, 'pic', 'admin', '<p>pic</p>\r\n<p><img alt="" src="http://www.baidu.com/img/logo-yy.gif" /></p>', 2, 8, 0, 0, '2007-03-30 9:37:48', NULL, '2007-04-16 8:24:11', 'admin', '127.0.0.1', 0),
(14, 2, 'test', 'admin', 'if($bid==2)<br />{<br />$islock=0;<br />}<br />else<br />{<br />$islock=1;<br />}if($bid==2)<br />{<br />$islock=0;<br />}<br />else<br />{<br />$islock=1;<br />}if($bid==2)<br />{<br />$islock=0;<br />}<br />else<br />{<br />$islock=1;<br />}', 1, 2, 0, 0, '2007-04-16 8:32:56', NULL, '2011-01-14 9:14:36', 'eetoday', '127.0.0.1', 0),
(20, 1, 'ݿⲻӣǲ鿴ԭ', 'admin', 'ݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭݿⲻӣǲ鿴ԭ', 0, 7, 0, 0, '2011-01-09 13:22:51', NULL, '2011-01-09 13:22:51', 'admin', '127.0.0.1', 0);

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

--
-- Ľṹ `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(12) NOT NULL,
  `userpass` varchar(100) NOT NULL,
  `question` varchar(255) default NULL,
  `answer` varchar(255) default NULL,
  `truename` varchar(10) default NULL,
  `birth` varchar(20) default NULL,
  `photo` varchar(255) default NULL,
  `com` varchar(50) default NULL,
  `postion` varchar(20) default NULL,
  `intro` varchar(200) default NULL,
  `address` varchar(100) default NULL,
  `zip` varchar(10) default NULL,
  `tel` varchar(20) default NULL,
  `tax` varchar(20) default NULL,
  `mobile` varchar(12) default NULL,
  `email` varchar(30) default NULL,
  `experience` varchar(500) default NULL,
  `job` varchar(500) default NULL,
  `hoby` varchar(100) default NULL,
  `expect` varchar(100) default NULL,
  `hope` varchar(100) default NULL,
  `jianli` varchar(300) default NULL,
  `super` tinyint(3) default '1',
  `isteach` tinyint(3) default '0',
  `islock` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=19 ;

--
-- е `user`
--

INSERT INTO `user` (`id`, `username`, `userpass`, `question`, `answer`, `truename`, `birth`, `photo`, `com`, `postion`, `intro`, `address`, `zip`, `tel`, `tax`, `mobile`, `email`, `experience`, `job`, `hoby`, `expect`, `hope`, `jianli`, `super`, `isteach`, `islock`) VALUES
(9, 'admin', '21232f297a57a5a743894a0e4a801fc3', '111111', '111111', 'admin', '1900?01??', '20070323165616994.gif', '???????', '???', '??????', '???????', NULL, '021-12345678', '021-12345678', '15945678755', 'admin@admin.com', '?????????????????', '???????????', '??????????', '????????????????????', '??????????????????????', '20070323165659332.doc', 3, 1, 0),
(18, 'eetoday', 'e10adc3949ba59abbe56e057f20f883e', 'ilikeyou', 'youyou', '', '19000101', './upfiles/20110111131047285.gif', '', 'ʦ', '', 'Ϻ', '211221', '021-58101772', '021-58101772', '', 'algerwo@yahoo.com', '', ' ', '', 'ʦ', 'ʦ', './upfiles/20110111131023281.doc', 1, 0, 0);
