qb_shoptg_comments,qb_shoptg_pic,qb_shoptg_reportʱûʹõ

qb_shoptg_collection	ղؼ

   cid  mediumint(7)       auto_increment     ԶֵID,岻         
   id  mediumint(7)     0                	ŹϢID
   uid  mediumint(7)     0                	ղߵUID
   posttime  int(10)     0     		ղ


qb_shoptg_config	ģļ

   c_key  varchar(50)                     	
   c_value  text                     		ֵ
   c_descrip  text                    	ʱûʹ
          
qb_shoptg_content	ŹϢ

   id  int(10)       auto_increment           ԶֵID   
   title  varchar(100)                     	ŹϢ
   mid  smallint(4)     0                	ģID,ǿΪ1
   fid  mediumint(7)     0                	ĿID
   fname  varchar(50)                     	Ŀ
   hits  mediumint(7)     0                	ע
   comments  mediumint(7)     0               ,ʱûʹ
   posttime  int(10)     0                	
   list  varchar(10)                     	ֵ
   uid  mediumint(7)     0                	ߵUID
   username  varchar(30)                     	ߵʺ
   titlecolor  varchar(15)                    ʱûʹ
   picurl  varchar(150)                     	ͼ
   ispic  tinyint(1)     0                	Ƿнͼ,еĻΪ1
   yz  tinyint(1)     0                	,1Ϊ
   levels  tinyint(2)     0                	Ƽ,1ΪƼ
   levelstime  int(10)     0                	Ƽ
   keywords  varchar(100)                     ʱûʹ
   ip  varchar(15)                     	ߵIP
   lastfid  mediumint(7)     0                ʱûʹ
   money  mediumint(7)     0                	ʱûʹ
   passwd  varchar(32)                     	ʱûʹ
   begintime  int(10)     0                	ʱûʹ
   endtime  int(10)     0                	ʱûʹ
   lastview  int(10)     0                	ʱûʹ
   city_id  mediumint(7)     0                ڳID
   picnum  smallint(4)     0                	ʱûʹ
   price  varchar(20)                     	ڵļ۸
   join_num  mediumint(5)     0               
   pay_num  mediumint(5)     0                ȷϲμ
   gg_maps  varchar(50)          		ȸͼλ


qb_shoptg_content_1	ŹϢ

   rid  mediumint(7)       auto_increment     ԶֵID,岻Ҫ          
   id  mediumint(7)     0                	ID
   fid  mediumint(7)     0                	
   uid  mediumint(7)     0                	ߵUID
   content  mediumtext                     	
   market_price  varchar(10)                  г۸
   shoptype  varchar(10)                     	ۿ,
   min_num  int(4)     0                	Ź
   about  mediumtext                     	
   end_time  varchar(20)                     	
   address  varchar(150)                    	̼ҵַ


qb_shoptg_join	μŹ
   id  mediumint(7)       auto_increment      ԶֵID,岻Ҫ       
   mid  smallint(4)     0                	ģID,ǿΪ2
   cid  mediumint(7)     0                	ŹϢID
   cuid  mediumint(7)     0                	ŹϢķUID
   fid  mediumint(7)     0                	ŹϢĿID
   posttime  int(10)     0                	µ
   uid  mediumint(7)     0                	µûUID
   username  varchar(30)                     	µûʺ
   yz  tinyint(1)     0                	
   ip  varchar(15)                     	ԴIP
   shopnum  mediumint(7)     0                Ԥ
   ifpay  tinyint(1)     0                	
   ifsend  tinyint(1)     0                	
   totalmoney  varchar(10)                    ܶ
   banktype  varchar(15)                     	
   emscode  varchar(32)                     	ʽ,֧ʽ֧
   password  varchar(32)                    	,ƾ


qb_shoptg_content_2 μŹ
   rid  mediumint(7)       auto_increment     ԶֵID,岻Ҫ      
   id  int(10)     0                		ID
   fid  mediumint(7)     0                	ŹϢĿID
   uid  mediumint(7)     0                	µûUID
   content  mediumtext                     	ע
   order_username  varchar(20)                ˿     
   order_phone  varchar(20)                   ϵ绰
   order_mobphone  varchar(15)                ϵֻ
   order_email  varchar(50)                   ϵ
   order_qq  varchar(11)                     	ϵQQ
   order_postcode  varchar(6)                 
   order_sendtype  tinyint(1)     0           ͷʽ
   order_paytype  tinyint(1)     0            ֧ʽ
   order_address  varchar(100)      		ϵַ

qb_shoptg_sort
   fid  mediumint(7)  UNSIGNED     auto_increment    	ID
   fup  mediumint(7)  UNSIGNED   0                   	ID
   name  varchar(50)                     		
   mid  smallint(4)     0                		ĸģID
   class  smallint(4)     0                		ʱûʹ
   sons  smallint(4)     0                		ʱûʹ
   type  tinyint(1)     0                		Ƿ಻ռĿ,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)                     	SEOؼ
   metakeywords  varchar(255)                     	SEOؼ
   metadescription  varchar(255)                     	SEO
   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               		ʱûʹ           


qb_shoptg_module	ģͱ       
   id  smallint(4)       auto_increment         	ԶֵģID,ܶطҪõ     
   sort_id  mediumint(5)     0                	ʱûʹ
   name  varchar(50)                     		ģ
   list  smallint(4)     0                		ֵ
   style  varchar(50)                     		ʱûõ
   config  text                     			չֶ1
   config2  text                     			չֶ2,ʱûõ
   comment_type  tinyint(1)     0                	ʱûõ
   ifdp  tinyint(1)     0                		ʱûõ
   template  text                    			ָĸģ       

qb_shoptg_field		ģֶϸ
   id  mediumint(7)       auto_increment      	ԶֵID,岻      
   mid  mediumint(5)     0                		ӦID
   title  varchar(50)                     		ֶ
   field_name  varchar(30)                     	ֶ,MSYQLʹõֶ
   field_type  varchar(15)                     	ֶ,ͻַ
   field_leng  smallint(3)     0                	ֶγ
   orderlist  int(10)     0                		ֵ
   form_type  varchar(15)                     	
   field_inputwidth  smallint(3)     NULL             
   field_inputheight  smallint(3)     0               ĸ߶
   form_set  text                     		,ѡ,ѡĲ
   form_value  text                     		Ĭֵ
   form_units  varchar(30)                     	ʾĵλ
   form_title  text                     		ʾı
   mustfill  tinyint(1)     0                		ǷΪ
   listshow  tinyint(1)     0                		Ƿбʾ
   listfilter  tinyint(1)     NULL                	Ƿбɸѡ
   search  tinyint(1)     0                		ǷΪֶ
   allowview  varchar(255)                     	鿴ֶεû
   allowpost  varchar(255)                     	ֶݵû
   js_check  text                     		JSЧǷϷ
   js_checkmsg  varchar(255)                     	JSЧʾϢ
   classid  mediumint(7)     0                	ֶչʹ
   form_js  text                    			JSչʹ
