SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Ľṹ `gb_admin`
--

CREATE TABLE `gb_admin` (
  `id` int(2) NOT NULL auto_increment,
  `adminname` varchar(100) NOT NULL,
  `adminpass` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

--
-- е `gb_admin`
--

INSERT INTO `gb_admin` (`id`, `adminname`, `adminpass`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

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

--
-- Ľṹ `gb_config`
--

CREATE TABLE `gb_config` (
  `sitename` varchar(100) NOT NULL,
  `siteurl` varchar(200) NOT NULL,
  `keywords` varchar(500) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `listpage` int(4) NOT NULL,
  `viewpage` int(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

--
-- е `gb_config`
--

INSERT INTO `gb_config` (`sitename`, `siteurl`, `keywords`, `description`, `listpage`, `viewpage`) VALUES
('FexBookԱ', 'http://localhost', 'php,fexphp,fexbook,,,framework', 'FexBook,һ׵Ա˵Ա˵һõ½ɷĵ̳', 15, 10);

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

--
-- Ľṹ `gb_posts`
--

CREATE TABLE `gb_posts` (
  `id` int(8) NOT NULL auto_increment,
  `title` varchar(200) NOT NULL,
  `author` varchar(50) NOT NULL,
  `addtime` int(13) NOT NULL default '0',
  `content` text NOT NULL,
  `hits` int(10) NOT NULL default '0',
  `reply` int(10) NOT NULL default '0',
  `istop` tinyint(1) NOT NULL default '0',
  `sex` enum('male','female') NOT NULL default 'male',
  `userpic` varchar(255) NOT NULL,
  `yoursite` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `qq` int(13) NOT NULL,
  `IP` varchar(15) NOT NULL,
  `adminreply` varchar(500) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;

--
-- е `gb_posts`
--

INSERT INTO `gb_posts` (`id`, `title`, `author`, `addtime`, `content`, `hits`, `reply`, `istop`, `sex`, `userpic`, `yoursite`, `email`, `qq`, `IP`, `adminreply`) VALUES
(1, 'лʹFexBookԱ', 'Terry', 1193850375, '<p>лʹFexBookԱ&nbsp; </p>\r\n<p><font color=#228b22>Ϣ</font></p>', 2, 0, 1, 'male', '07.gif', 'http://www.meiu.cn', 'baoling@yeah.net', 110042869, '127.0.0.1', ''),
(2, 'FexBookĹ', 'Terry', 1193850455, '<ul><li>ûⷢظע \r\n<li>Աں̨˻ظ \r\n<li>Աö \r\n<li>бͨAjaxʽչ \r\n<li>ͨRSSۺʱ鿴 \r\n<li>ʹKindEditorΪ༭ \r\n<li>ٷԻظѡʹUBB \r\n<li>̨ṩ򵥵 </li></ul>', 2, 0, 0, 'male', '01.gif', 'http://www.meiu.cn', 'baoling@yeah.net', 11042869, '127.0.0.1', '');

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

--
-- Ľṹ `gb_replys`
--

CREATE TABLE `gb_replys` (
  `id` int(10) NOT NULL auto_increment,
  `pid` int(8) NOT NULL,
  `title` varchar(200) NOT NULL,
  `author` varchar(50) NOT NULL,
  `addtime` int(13) NOT NULL,
  `content` text NOT NULL,
  `sex` enum('male','female') NOT NULL default 'male',
  `userpic` varchar(255) NOT NULL,
  `yoursite` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `qq` int(13) NOT NULL,
  `IP` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

--
-- е `gb_replys`
--