ǷUCPHPWIND̳,Ҫõıqb_memberdata

UCPHPWIND̳,qb_membersͻ,ͺҪ


qb_members
ûUIDʺż


qb_memberdataֶν:

  `uid` mediumint(7) unsigned NOT NULL default '0',		ûUID,Ψһ,йܶ˹
  `username` varchar(50) NOT NULL default '',			ûʺ,Ҳǲ޸ĵ,ҲΨһ
  `question` varchar(32) NOT NULL default '',			ʱûʹ
  `groupid` smallint(4) NOT NULL default '0',			ûID,3ΪԱ
  `grouptype` tinyint(1) NOT NULL default '0',			չ,1Ϊҵû
  `groups` varchar(255) NOT NULL default '',			չû鹦,ʱûõ
  `yz` tinyint(1) NOT NULL default '0',				û,1Ϊ,0Ϊ
  `newpm` tinyint(1) NOT NULL default '0',			ʱûʹ
  `medals` varchar(255) NOT NULL default '',			ʱûʹ
  `money` mediumint(7) unsigned NOT NULL default '0',		ûĲƸ,ָ̳̳Ļ,Ͳʹ
  `totalspace` bigint(13) NOT NULL default '0',			ûռ,ΪʱʹĬϵĿռС,0ʱĬϵۼ
  `usespace` bigint(13) NOT NULL default '0',			ʹõĿռ
  `oltime` int(10) NOT NULL default '0',			ʱûʹ
  `lastvist` int(10) NOT NULL default '0',			ϴηʱ
  `lastip` varchar(15) NOT NULL default '',			ϴηIP
  `regdate` int(10) NOT NULL default '0',			ע
  `regip` varchar(15) NOT NULL default '',			עʱIP
  `sex` tinyint(1) NOT NULL default '0',			Ա,1Ϊ,2ΪŮ,0Ϊδ֪
  `bday` date NOT NULL default '0000-00-00',			
  `icon` varchar(150) NOT NULL default '',			ͷ
  `introduce` text NOT NULL,					ҽ
  `hits` int(7) NOT NULL default '0',				ҳ
  `lastview` int(10) NOT NULL default '0',			ҳһαʵ
  `oicq` varchar(11) NOT NULL default '',			ϵQQ
  `msn` varchar(50) NOT NULL default '',			ϵMSN
  `homepage` varchar(150) NOT NULL default '',			ⲿ͵ַ
  `email` varchar(50) NOT NULL default '',			ϵ,Ҫ,ȡҪ
  `provinceid` mediumint(6) NOT NULL default '0',		ʡݵID
  `cityid` mediumint(7) NOT NULL default '0',			ڳеID
  `address` varchar(255) NOT NULL default '',			ϵַ
  `postalcode` varchar(6) NOT NULL default '',			
  `mobphone` varchar(12) NOT NULL default '',			ϵֻ
  `telephone` varchar(25) NOT NULL default '',			绰
  `idcard` varchar(20) NOT NULL default '',			֤ӡ
  `truename` varchar(20) NOT NULL default '',			ʵ
  `config` text NOT NULL,					չ,ûЧڻл鱣
  `moneycard` mediumint(7) unsigned NOT NULL default '0',	
  `email_yz` tinyint(1) NOT NULL default '0',			֤
  `mob_yz` tinyint(1) NOT NULL default '0',			ֻ֤
  `idcard_yz` tinyint(1) NOT NULL default '0',			֤Ϣ֤




qb_groupûݱ

  `gid` smallint(4) NOT NULL auto_increment,		ûID
  `gptype` tinyint(1) NOT NULL default '0',		ûͣ1Ϊϵͳû飬0ΪԱû
  `grouptitle` varchar(50) NOT NULL default '',		û
  `levelnum` mediumint(7) NOT NULL default '0',		Ա
  `totalspace` int(10) NOT NULL default '0',		ԱռС
  `allowsearch` tinyint(1) NOT NULL default '0',	Ƿ
  `powerdb` text NOT NULL,				ǰ̨Ȩޣл
  `allowadmin` tinyint(1) NOT NULL default '0',		Ƿ̨
  `allowadmindb` text,					̨Ȩޣл


