#
# ıṹ: gb_admin
#
CREATE TABLE gb_admin ( id INTEGER NOT NULL PRIMARY KEY, adminname varchar(100) NOT NULL , adminpass varchar(50) NOT NULL );

#
# ӱе: gb_admin
#
INSERT INTO gb_admin 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 );

#
# ӱе: gb_config
#
INSERT INTO gb_config VALUES ('FexBookԱ', 'http://localhost', 'php,fexphp,fexbook,,,framework', 'FexBook,һ׵Ա˵Ա˵һõ½ɷĵ̳', '15', '10');
# --------------------------------------------------------


#
# ıṹ: gb_posts
#
CREATE TABLE gb_posts ( id INTEGER NOT NULL PRIMARY KEY, title VARCHAR (200), 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 VARCHAR(6) NOT NULL DEFAULT 'male', userpic VARCHAR(255), yoursite VARCHAR(255), email VARCHAR(255), qq INT(13), IP VARCHAR(15), adminreply VARCHAR(500) );

#
# ӱе: gb_posts
#
INSERT INTO gb_posts VALUES ('1', 'лʹFexBookԱ', 'Terry', '1193850375', '<p>лʹFexBookԱ&nbsp; </p> <p><font color=#228b22>Ϣ </font></p>', '2', '0', '1', 'male', '07.gif', 'http://www.meiu.cn', 'baoling@yeah.net', '110042869', '127.0.0.1', NULL);
INSERT INTO gb_posts VALUES ('2', 'FexBookĹ', 'Terry', '1193850455', '<ul><li>ûⷢظע <li>Աں̨˻ظ <li>Աö <li>бͨAjaxʽչ <li>ͨRSSۺʱ鿴 <li>ʹKindEditor Ϊ༭ <li>ٷԻظѡʹUBB <li>̨ṩ򵥵 </li></ul>', '2', '0', '0', 'male', '01.gif', 'http://www.meiu.cn', 'baoling@yeah.net', '11042869', '127.0.0.1', NULL);
# --------------------------------------------------------


#
# ıṹ: gb_replys
#
CREATE TABLE gb_replys ( id INTEGER NOT NULL PRIMARY KEY, pid INT(8) NOT NULL DEFAULT '0', title VARCHAR(200) NOT NULL, author VARCHAR(50) NOT NULL, addtime INT(13) NOT NULL DEFAULT '0', content TEXT NOT NULL, sex VARCHAR(6) NOT NULL DEFAULT 'male', userpic VARCHAR(255) NOT NULL, yoursite VARCHAR (255), email VARCHAR(255), qq INT(13), IP VARCHAR(15) );