ģͱqb_showroom_module
id=1 չģ
id=2 μչ
id=3 չģ

һչϢõı
qb_showroom_content,qb_showroom_content_1
ǵĹֶid

һչϢõı
qb_showroom_room,qb_showroom_content_2
ǵĹֶid

ǼǱչõı
qb_showroom_join,qb_showroom_content_3



qb_showroom_city  չڳб

   fid  mediumint(7)  UNSIGNED     auto_increment     FID,Զֵ        
   fup  mediumint(7)  UNSIGNED   0                	ʱûʹ
   name  varchar(200)                     		
   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                	ʱûʹ
   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  text                    			ʱûʹ


qb_showroom_config	չչģò
   c_key  varchar(50)                     		
   c_value  text                     			ֵ
   c_descrip  text                    		ʱûʹ


qb_showroom_content	չϢ
   id  int(10)       auto_increment     		չԶֵID         
   title  varchar(100)                     		չ
   mid  smallint(4)     0                		ǿΪ1,չģ
   fid  mediumint(7)     0                		FID
   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                		ʱûʹ
   yz  tinyint(1)     0                		֤,Ϊ1ʱ֤,0û֤
   levels  tinyint(2)     0                		ǷƼ,1ΪƼ,0ΪδƼ
   levelstime  int(10)     0                		Ƽ
   keywords  varchar(100)                     	ؼ
   ip  varchar(15)                     		ߵIP
   lastfid  mediumint(7)     0                	ʱûʹ
   money  mediumint(7)     0                		ʱûʹ
   begintime  int(10)     0                		ʱûʹ
   endtime  int(10)     0                		ʱûʹ
   lastview  int(10)     0                		ʱûʹ
   city_id  mediumint(7)     0                	ڳ
   picnum  smallint(4)     0                		жŽͼ
   totaluser  mediumint(7)     0                	λж
   roomid  mediumint(7)     0               		ĸչݵչ

qb_showroom_content_1  	չϢ
   rid  mediumint(7)       auto_increment     	ԶֵID,岻         
   id  mediumint(7)     0                		ID
   fid  mediumint(7)     0                		ĿFID
   uid  mediumint(7)     0                		UID
   content  mediumtext                     		չϸ
   day_begin  varchar(20)                     	չῪʼ
   day_end  varchar(20)                     		չ
   main_preside  varchar(255)                     	췽
   assist_preside  mediumtext                     	Э췽
   shop_area  mediumtext                     		չƷΧ
   joinmoney  varchar(20)                     	չ
   contact  varchar(200)                     		ϵʽ
   about  mediumtext                     		ע
   my_title1  varchar(100)                     	ԶĿһ
   my_content1  mediumtext                    	ԶĿһ 
   my_title2  varchar(100)                     	ԶĿ
   my_content2  mediumtext                    	ԶĿ


qb_showroom_room    չ
   id  int(10)       auto_increment      		ԶֵID        
   title  varchar(100)                     		չ
   mid  smallint(4)     0                		ǿΪ3,ģ
   fid  mediumint(7)     0                		FID
   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Ϊ,0Ϊ
   yz  tinyint(1)     0                		
   levels  tinyint(2)     0                		Ƽ,1ΪƼ
   levelstime  int(10)     0                		Ƽ
   keywords  varchar(100)                     	ؼ
   ip  varchar(15)                     		ǼIP
   lastfid  mediumint(7)     0                	ʱûʹ
   money  mediumint(7)     0                		ʱûʹ
   begintime  int(10)     0                		ʱûʹ
   endtime  int(10)     0                		ʱûʹ
   lastview  int(10)     0                		ʱûʹ
   city_id  mediumint(7)     0                	ڳID
   picnum  smallint(4)     0               		ͼ


qb_showroom_content_3   չݸ
   rid  mediumint(7)       auto_increment       	ֵID,岻      
   id  int(10)     0                			ؼID
   fid  mediumint(7)     0                		FID
   uid  mediumint(7)     0                		ǼUID
   content  mediumtext                     		ϸ
   room_address  varchar(100)                     	ַ
   room_web  varchar(100)                     	ַ
   contact  varchar(150)                    		ϵʽ




qb_showroom_join	չᱨ
   id  mediumint(7)       auto_increment      	ԶֵID        
   mid  smallint(4)     0                		ǿΪ2,ģ
   cid  mediumint(7)     0                		չID
   cuid  mediumint(7)     0                		չᷢߵUID
   fid  mediumint(7)     0                		չĿ
   posttime  int(10)     0                		
   uid  mediumint(7)     0                		ߵUID
   username  varchar(30)                     		ʺ
   yz  tinyint(1)     0                		
   ip  varchar(15)                    		ߵIP


qb_showroom_content_2	ǼǱ
   rid  mediumint(7)       auto_increment     	ԶֵID,岻          
   id  mediumint(7)     0                		ID
   fid  mediumint(7)     0                		ʱûʹ
   uid  mediumint(7)     0                		ǼUID
   content  mediumtext                     		עϢ
   realname  varchar(30)                     		ʵ
   telphone  varchar(20)                     		绰
   companyname  varchar(255)                    	˾



qb_showroom_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_showroom_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չʹ


qb_showroom_pic    ϢͼƬ

   pid  mediumint(7)       auto_increment      	ԶֵID,岻̫        
   id  mediumint(10)     0                		ϢID
   fid  mediumint(7)     0                		ϢĿFID
   mid  smallint(4)     0                		Ϣģ
   uid  mediumint(7)     0                		UID
   type  tinyint(1)     0                		0Ϊչ,1Ϊչݵ
   imgurl  varchar(150)                     		ͼƬĵַ
   name  varchar(100)                    		ͼƬ



qb_showroom_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               		ʱûʹ





