

qb_hy_company ˾Ϣ
   rid  mediumint(7)       auto_increment     ԶֵID,̫Ҫ          
   title  varchar(200)                     	˾
   host  varchar(32)                     	̶
   fname  varchar(100)                     	,ͬʱڶ
   uid  mediumint(7)     0                	̼UID
   username  varchar(32)                     	̼ʺ
   renzheng  tinyint(1)     0                	֤,0Ϊû֤,1֤ͨ,2Ϊ֤,3Ϊ֤
   is_agent  tinyint(1)     0                	ǷΪ,ûʹ
   is_vip  tinyint(1)     0                	ǷΪVIPԱ,ûʹ
   posttime  int(10)     0                	Ǽ
   list  int(10)     0                	ֵ
   listorder  int(10)     0                	ʱûʹ
   picurl  varchar(255)                     	ʱûʹ
   gz  varchar(248)                     	,1Ϊ,0Ϊû
   yz  tinyint(1)     0                	ʱûʹ
   yzer  varchar(32)                     	ʱûʹ
   yztime  int(10)     0                	ʱûʹ
   hits  int(10)     0                	ע
   levels  tinyint(2)     0                	Ƽ,1ΪƼ,0ΪûƼ
   levelstime  int(10)     0                	Ƽ
   lastview  int(10)     0                	ʱûʹ
   content  text                     		ҵ
   province_id  mediumint(7)     0            ʡ
   city_id  mediumint(7)     0                ڳ
   zone_id  mediumint(7)     0                
   street_id  mediumint(7)     0              ڽֵ
   qy_cate  varchar(32)                     	ҵʽ:˶ҵ,徭Ӫ
   qy_saletype  varchar(48)                   Ӫģʽ:,
   qy_regmoney  int(10)     0                	עʱ
   qy_createtime  varchar(64)                 ע
   qy_regplace  varchar(128)                  עַ
   qy_address  varchar(248)                   ϵַ
   qy_postnum  varchar(8)                     
   qy_pro_ser  varchar(248)                   ӪƷ
   my_buy  varchar(248)                     	ҪɹƷ
   my_trade  varchar(32)                     	ҵ
   qy_contact  varchar(16)                    ϵ
   qy_contact_zhiwei  varchar(16)             ϵְλ  
   qy_contact_sex  int(1)     1               ϵԱ,1Ϊ,2ΪŮ,0Ϊδ֪
   qy_contact_tel  varchar(248)               ϵ˵绰
   qy_contact_mobile  varchar(248)            ϵֻ
   qy_contact_fax  varchar(248)               ϵ˴
   qy_contact_email  varchar(248)             ϵ
   qy_website  varchar(248)                   ˾ַ
   qq  varchar(248)                     	ϵQQ
   msn  varchar(248)                     	ϵMSN
   skype  varchar(248)                     	ϵskype
   ww  varchar(248)                     	ϵ
   bd_pics  varchar(248)                     	ͼƬ
   toptime  int(10)     0                	,ʱûʹ
   if_homepage  tinyint(4)     0              Ƿ,1Ϊ,0Ϊ
   permit_pic  varchar(100)                   Ӫҵִɨ
   guo_tax_pic  varchar(100)                  ˰ɨ
   di_tax_pic  varchar(100)                   ˰ɨ
   organization_pic  varchar(100)             ɨ
   idcard_pic  varchar(100)                	֤ɨ     
   gg_maps  varchar(50)                    	ȸͼλ


qb_hy_company_fid	˾,ͬʱĿ

   uid  mediumint(7)  UNSIGNED   0         ˾UID       
   fid  mediumint(7)  UNSIGNED   0         ĿID


qb_hy_config    ̼һҳģò

   c_key  varchar(50)                 
   c_value  text                     	ֵ
   c_descrip  text                    


qb_hy_friendlink	
   ck_id  int(10)  UNSIGNED     auto_increment        ԶֵID,岻    
   uid  mediumint(7)  UNSIGNED   0                	̼UID
   username  varchar(16)                     		̼ʺ
   companyName  varchar(64)                     	ûõ
   title  varchar(128)                     		վ
   url  varchar(248)                     		ַַ
   description  text                     		
   yz  tinyint(1)     0               		


qb_hy_guestbook  ̻Ա
   id  int(7)       auto_increment      		ԶֵID,岻
   cuid  mediumint(7)     0                		̼UID
   uid  int(7)     0                			UID
   username  varchar(30)                     		ʺ
   ip  varchar(15)                     		IPԴ
   content  text                     			
   yz  tinyint(1)     0                		
   posttime  int(16)     0                		
   list  int(10)     0               			ֵ

qb_hy_home	ҵ,Ҫе.
   uid  mediumint(7)  UNSIGNED   0           		ҵUID     
   username  varchar(32)                     		ҵ¼ʺ,ҵ
   style  varchar(32)                     		ʹ÷
   index_left  varchar(248)                     	߷õģ
   index_right  varchar(248)                     	ұ߷õģ
   listnum  text                     			ģʾ¼
   banner  varchar(248)                     		ԶģͼƬ,еķ֧ܲ
   bodytpl  varchar(8)     left                	ʱûʹ
   renzheng_show  tinyint(1)     0                	ʱûʹ
   visitor  text                     			ÿ
   hits  mediumint(7)     0                		ע
   head_menu  text                     		ͷ˵,л
   gg_maps  varchar(255)                    		ȸͼλ


qb_hy_news ̼
   id  int(10)  UNSIGNED     auto_increment      	ԶֵID
   uid  mediumint(7)  UNSIGNED   0                	ҵUID
   title  varchar(150)                     		ű
   content  text                     			
   hits  mediumint(7)     0                		
   posttime  int(10)  UNSIGNED   0                	
   list  int(10)  UNSIGNED   0                	ֵ
   username  varchar(30)                     		ʺ
   titlecolor  varchar(15)                     	ʱûʹ
   fonttype  tinyint(1)     0                		ʱûʹ
   picurl  varchar(150)                     		ʱûʹ
   ispic  tinyint(1)     0                		ʱûʹ
   yz  tinyint(1)     0                		,1Ϊ,0Ϊû
   levels  tinyint(1)     0                		ǷΪƼ
   keywords  varchar(100)                     	ʱûʹ
   bd_pics  varchar(248)                    		ͼƬ

qb_hy_pic	̼ͼƬ
   pid  int(10)  UNSIGNED     auto_increment     	ԶֵID         
   psid  int(10)  UNSIGNED   0                	ͼƬID
   uid  mediumint(7)  UNSIGNED   0                	ҵUID
   username  varchar(32)                     		ҵ¼ʺ
   title  varchar(128)                     		ͼƬ
   url  varchar(248)                     		ͼƬַ
   level  tinyint(1)     0                		ǷƼ,1ΪƼ,0ΪƼ
   yz  tinyint(1)     0                		
   posttime  int(10)  UNSIGNED   0                	
   isfm  tinyint(1)     0                		ǷΪͼ
   orderlist  mediumint(5)     0                	ֵ
   type  varchar(8)                    		ûʹ


qb_hy_picsort	ͼƬ

   psid  int(10)  UNSIGNED     auto_increment         ԶֵID       
   psup  int(10)  UNSIGNED   0                	ʱûʹ
   name  varchar(16)                     		
   remarks  varchar(248)                     		ʱûʹ
   uid  mediumint(7)  UNSIGNED   0                	ҵUID
   username  varchar(16)                     		ҵ¼ʺ
   level  tinyint(1)     0                		ʱûʹ
   posttime  int(10)  UNSIGNED   0                	ʱûʹ
   orderlist  mediumint(4)  UNSIGNED   0              ֵ
   faceurl  varchar(248)                    		ͼ



qb_hy_sort      ҵ
   fid  mediumint(7)  UNSIGNED     auto_increment     ID,Զֵ          
   fup  mediumint(7)  UNSIGNED   0                	ID
   name  varchar(50)                     		
   mid  smallint(4)     0                		ʱûʹ
   class  smallint(4)     0                		ʱûʹ
   sons  smallint(4)     0                		ʱûʹ
   type  tinyint(1)     0                		ʱûʹ
   admin  varchar(100)                     		ʱûʹ
   list  int(10)     0                		ֵ
   listorder  tinyint(2)     0                	ʱûʹ
   passwd  varchar(32)                     		ʱûʹ
   logo  varchar(150)                     		ʱûʹ
   descrip  text                     			ʱûʹ
   style  varchar(50)                     		ʱûʹ
   template  text                     		ʱûʹ
   jumpurl  varchar(150)                     		ʱûʹ
   maxperpage  tinyint(3)     0                	ʱûʹ
   metatitle  varchar(250)                     	ʱûʹ
   metakeywords  varchar(255)                     	ʱûʹ
   metadescription  varchar(255)                     	ʱûʹ
   allowcomment  tinyint(1)     0                	ʱûʹ
   allowpost  varchar(150)                     	ʱûʹ
   allowviewtitle  varchar(150)                     	ʱûʹ
   allowviewcontent  varchar(150)                     ʱûʹ
   allowdownload  varchar(150)                     	ʱûʹ
   forbidshow  tinyint(1)     0                	ʱûʹ
   config  mediumtext                     		ʱûʹ
   index_show  tinyint(1)     0                	ʱûʹ
   contents  mediumint(4)     0                	ʱûʹ
   tableid  varchar(30)                     		ʱûʹ
   dir_name  varchar(50)                     		ʱûʹ
   ifcolor  tinyint(1)     0               		ʱûʹ










