Ƿ±Ҫõı


һƪ,漰ݱ3:

qb_article_db	ID,ҪΪ˷ֱʹ,ûֱĻ,¼,Ҳ̫.ȸһID,
qb_article	±⼰
qb_reply	

ر
qb_sort		ĿϢ
qb_comment	۱

ǵĹֶaid


qb_articleֶ:

  `aid` mediumint(7) unsigned NOT NULL auto_increment,	IDԶӵ
  `title` varchar(150) NOT NULL default '',		±
  `smalltitle` varchar(100) NOT NULL default '',	¶̱,һΪ,ʹ
  `fid` mediumint(7) unsigned NOT NULL default '0',	µĿFID
  `mid` mediumint(5) NOT NULL default '0',		ģ,µĻ,ֵΪ0
  `fname` varchar(50) NOT NULL default '',		Ŀ
  `hits` mediumint(7) NOT NULL default '0',		
  `pages` smallint(4) NOT NULL default '0',		жҳ
  `comments` mediumint(7) NOT NULL default '0',		ж
  `posttime` int(10) NOT NULL default '0',		
  `list` int(10) NOT NULL default '0',			ֵ,ĬǷڵֵ,ɵɿ
  `uid` mediumint(7) NOT NULL default '0',		ߵUID
  `username` varchar(30) NOT NULL default '',		ߵʺ
  `author` varchar(30) NOT NULL default '',		µ,һǷ
  `copyfrom` varchar(100) NOT NULL default '',		Դĸվ
  `copyfromurl` varchar(150) NOT NULL default '',	Դĸַ
  `titlecolor` varchar(15) NOT NULL default '',		ɫ
  `fonttype` tinyint(1) NOT NULL default '0',		ǷӴ,ʹ
  `picurl` varchar(150) NOT NULL default '0',		ͼ,Ҳбҳʾͼ,ǰ̨ҳõͼ
  `ispic` tinyint(1) NOT NULL default '0',		Ƿͼ,ҪǷѯݿ
  `yz` tinyint(1) NOT NULL default '0',			,1Ϊ,2Ϊվ,0Ϊδ
  `yzer` varchar(30) NOT NULL default '',		ʺ,
  `yztime` int(10) NOT NULL default '0',		,
  `levels` tinyint(2) NOT NULL default '0',		ǷΪ,1Ϊ,0Ϊͨ
  `levelstime` int(10) NOT NULL default '0',		±Ƽ
  `keywords` varchar(100) NOT NULL default '',		µĹؼ,ÿո.漰.
  `jumpurl` varchar(150) NOT NULL default '',		µתⲿַ,õĻ,ַָ
  `iframeurl` varchar(150) NOT NULL default '',		µĿַ,õĻ,һַ,Ĳͬʱ
  `style` varchar(15) NOT NULL default '',		ָ
  `template` varchar(255) NOT NULL default '',		ָģ
  `target` tinyint(1) NOT NULL default '0',		бǷ´д
  `ip` varchar(15) NOT NULL default '',			ߵIP
  `lastfid` mediumint(7) NOT NULL default '0',		·վ,֮ǰĿFID,㻹ԭ
  `money` mediumint(7) NOT NULL default '0',		²鿴ҪշѶ
  `buyuser` text NOT NULL,				շѺ,û
  `passwd` varchar(32) NOT NULL default '',		²鿴
  `allowdown` varchar(150) NOT NULL default '',		¸û
  `allowview` varchar(150) NOT NULL default '',		鿴ĵû
  `editer` varchar(30) NOT NULL default '',		޸Ĺµûʺ,
  `edittime` int(10) NOT NULL default '0',		޸ıĵ,
  `begintime` int(10) NOT NULL default '0',		ʼ,þͲ
  `endtime` int(10) NOT NULL default '0',		Ľ,þͲ
  `description` text NOT NULL,				µһЩҪ,
  `lastview` int(10) NOT NULL default '0',		
  `digg_num` mediumint(7) NOT NULL default '0',		±Ĵ
  `digg_time` int(10) NOT NULL default '0',		һα
  `forbidcomment` tinyint(1) NOT NULL default '0',	Ƿֹ,ĬϵĿΪ׼
  `ifvote` tinyint(1) NOT NULL default '0',		ǷͶƱ
  `heart` varchar(255) NOT NULL default '',		
  `htmlname` varchar(100) NOT NULL default '',		ɾ̬URLļ


qb_replyֶ

  `rid` mediumint(7) NOT NULL auto_increment,		ID,,ҪԲ
  `subhead` varchar(150) NOT NULL default '',		ݱ,һҳʱ,岻,ҳʱ,ÿҳı
  `postdate` int(10) NOT NULL default '0',		,ҳʱ,һҳʱ,岻
  `aid` mediumint(7) NOT NULL default '0',		ؼID
  `fid` mediumint(7) NOT NULL default '0',		ĿFID
  `uid` mediumint(7) NOT NULL default '0',		ߵUID
  `topic` tinyint(1) NOT NULL default '0',		һҳĻΪ1,ڶҳԺΪ0
  `content` mediumtext NOT NULL,			
  `orderid` mediumint(7) NOT NULL default '0',		ҳĻ,,ֵ



·һƪ,

ȸqb_article_dbһ¼,õID,Ȼٸqb_article,벻ȱٵֶ
aid,title,fid,fname,posttime,list,uid,username,picurl,ispic,yz,keywords,ip

ͼڵĻ,picurl,ispicͬʱΪ,ͼƬĻ,ispic=1

ٸqb_replyֶε
postdate,aid,fid,uid,topic,content

һҳĻ,topic=1









qb_sort	 ĿϢֶϢ


  `fid` mediumint(7) unsigned NOT NULL auto_increment,		ĿID,ԶֵĻFID
  `fup` mediumint(7) unsigned NOT NULL default '0',		ĿID
  `fmid` mediumint(5) NOT NULL default '0',			ĸģ,µĻ,Ϊ0
  `name` varchar(50) NOT NULL default '',			Ŀ
  `class` smallint(4) NOT NULL default '0',			Ҫֶ,ɾ
  `sons` smallint(4) NOT NULL default '0',			Ҫֶ,ɾ
  `type` tinyint(1) NOT NULL default '0',			Ŀ,1Ϊ,0ΪռĿ,2Ϊƪ
  `admin` varchar(100) NOT NULL default '',			Ŀİ
  `list` int(10) NOT NULL default '0',				Ŀֵ
  `listorder` tinyint(2) NOT NULL default '0',			Ŀµʽ,еķ
  `passwd` varchar(32) NOT NULL default '',			Ŀ
  `logo` varchar(150) NOT NULL default '',			ĿLOGOͼ,
  `descrip` text NOT NULL,					Ŀ,
  `style` varchar(50) NOT NULL default '',			Ŀָķ,»
  `template` text NOT NULL,					Ŀָģ,»
  `jumpurl` varchar(150) NOT NULL default '',			תⲿַ
  `maxperpage` tinyint(3) NOT NULL default '0',			Ŀµÿҳƪ,еķ
  `metakeywords` varchar(255) NOT NULL default '',		SEOؼ
  `metadescription` varchar(255) NOT NULL default '',		SEO
  `allowcomment` tinyint(1) NOT NULL default '0',		ڱĿµ½۵û,
  `allowpost` varchar(150) NOT NULL default '',			Ͷû,
  `allowviewtitle` varchar(150) NOT NULL default '',		±û,
  `allowviewcontent` varchar(150) NOT NULL default '',		ݵû,
  `allowdownload` varchar(150) NOT NULL default '',		¸û,
  `forbidshow` tinyint(1) NOT NULL default '0',			ǷֹڸĿʾĿ,Ŀ̫Ŀʱ,бҪһ
  `config` text NOT NULL,					չֶ
  `list_html` varchar(255) NOT NULL default '',			̬ҳʱ,бҳURLʽ
  `bencandy_html` varchar(255) NOT NULL default '',		̬ҳʱ,ҳURLʽ
  `domain` varchar(150) NOT NULL default '',			̬ҳʱ,Ŀ󶨵
  `domain_dir` varchar(100) NOT NULL default '',		̬ҳʱ,̬ҳĸĿ¼





qb_comment	 ۱ֶϢ


  `cid` mediumint(7) unsigned NOT NULL auto_increment,		ԶֵID,岻
  `aid` int(10) unsigned NOT NULL default '0',			µID
  `fid` mediumint(7) unsigned NOT NULL default '0',		ĿID
  `authorid` mediumint(7) NOT NULL default '0',			ߵID
  `uid` mediumint(7) unsigned NOT NULL default '0',		ߵUID
  `username` varchar(30) NOT NULL default '',			ʺ
  `posttime` int(10) NOT NULL default '0',			
  `content` text NOT NULL,					
  `ip` varchar(15) NOT NULL default '',				ߵIP
  `icon` tinyint(3) NOT NULL default '0',			ѡı
  `yz` tinyint(1) NOT NULL default '0',				Ƿ,1Ϊ,0Ϊδ
  `ifcom` tinyint(1) NOT NULL default '0',			ǷΪ,1Ϊ,0Ϊͨ
  `agree` mediumint(5) NOT NULL default '0',			֧Ʊ
  `disagree` mediumint(5) NOT NULL default '0',			ԵƱ




