-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_admin`
-- 

CREATE TABLE `jtb_admin` (
  `aid` int(9) NOT NULL auto_increment,
  `jtb_aname` varchar(50) default NULL,
  `jtb_apword` varchar(50) default NULL,
  `jtb_apopedom` varchar(255) default NULL,
  `jtb_alock` int(1) default '0',
  `jtb_alasttime` datetime default NULL,
  `jtb_alastip` varchar(50) default NULL,
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_admin_log`
-- 

CREATE TABLE `jtb_admin_log` (
  `lid` int(9) NOT NULL auto_increment,
  `jtb_lname` varchar(50) default NULL,
  `jtb_ltime` datetime default NULL,
  `jtb_lip` varchar(50) default NULL,
  `jtb_lislogin` int(1) default '0',
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_article`
-- 

CREATE TABLE `jtb_article` (
  `aid` int(9) NOT NULL auto_increment,
  `jtb_atopic` varchar(50) default NULL,
  `jtb_acontent` text,
  `jtb_acontent_images_list` text,
  `jtb_acttype` int(1) default '0',
  `jtb_acp_note` int(1) default '0',
  `jtb_acp_mode` int(1) default '0',
  `jtb_acp_type` int(1) default '0',
  `jtb_acp_num` int(9) default '0',
  `jtb_atime` datetime default NULL,
  `jtb_acls` text,
  `jtb_aclass` int(9) default '0',
  `jtb_ahidden` int(1) default '0',
  `jtb_aupdate` int(1) default '0',
  `jtb_agood` int(1) default '0',
  `jtb_acount` int(9) default '0',
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_download`
-- 

CREATE TABLE `jtb_download` (
  `did` int(9) NOT NULL auto_increment,
  `jtb_dtopic` varchar(50) default NULL,
  `jtb_dcls` text,
  `jtb_dclass` int(9) default '0',
  `jtb_dscont` text,
  `jtb_dimage` varchar(255) default NULL,
  `jtb_dcttype` int(1) default '0',
  `jtb_dcontent` text,
  `jtb_dcontent_images_list` text,
  `jtb_dsize` int(9) default '0',
  `jtb_drunco` varchar(255) default NULL,
  `jtb_dstar` int(9) default '0',
  `jtb_daccredit` int(9) default '0',
  `jtb_dlng` int(9) default '0',
  `jtb_dlink` varchar(255) default NULL,
  `jtb_dauthor` varchar(255) default NULL,
  `jtb_durls` text,
  `jtb_dhidden` int(1) default '0',
  `jtb_dgood` int(1) default '0',
  `jtb_dtime` datetime default NULL,
  `jtb_dcount` int(9) default '0',
  `jtb_dupdate` int(1) default '0',
  PRIMARY KEY  (`did`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_expansion_js`
-- 

CREATE TABLE `jtb_expansion_js` (
  `jid` int(9) NOT NULL auto_increment,
  `jtb_jtopic` varchar(50) default NULL,
  `jtb_jcontent` text,
  `jtb_jretimetype` int(1) default '0',
  `jtb_jretimevalue` int(9) default '0',
  `jtb_jretime` datetime default NULL,
  `jtb_jtime` datetime default NULL,
  PRIMARY KEY  (`jid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_forum_blacklist`
-- 

CREATE TABLE `jtb_forum_blacklist` (
  `bid` int(9) NOT NULL auto_increment,
  `jtb_busername` varchar(50) default NULL,
  `jtb_bsid` int(9) default '0',
  `jtb_badmin` varchar(50) default NULL,
  `jtb_btime` datetime default NULL,
  `jtb_bremark` varchar(255) default NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_forum_sort`
-- 

CREATE TABLE `jtb_forum_sort` (
  `sid` int(9) NOT NULL auto_increment,
  `jtb_ssort` varchar(50) default NULL,
  `jtb_sfid` varchar(50) default NULL,
  `jtb_sfsid` int(9) default '0',
  `jtb_slng` varchar(50) default NULL,
  `jtb_sorder` int(9) default '0',
  `jtb_stype` int(9) default '0',
  `jtb_smode` int(9) default '0',
  `jtb_sispop` int(9) default '0',
  `jtb_spopedom` varchar(50) default NULL,
  `jtb_simages` varchar(255) default NULL,
  `jtb_sadmin` varchar(255) default NULL,
  `jtb_srule` varchar(255) default NULL,
  `jtb_sexplain` varchar(255) default NULL,
  `jtb_sattestation` varchar(255) default NULL,
  `jtb_shidden` int(1) default '0',
  `jtb_sntopic` int(9) default '0',
  `jtb_snnote` int(9) default '0',
  `jtb_stoday_ntopic` int(9) default '0',
  `jtb_stoday_date` datetime default NULL,
  `jtb_slast_topic` varchar(50) default NULL,
  `jtb_slast_tid` int(9) default '0',
  `jtb_slast_time` datetime default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_forum_topic`
-- 

CREATE TABLE `jtb_forum_topic` (
  `tid` int(9) NOT NULL auto_increment,
  `jtb_tsid` int(9) default '0',
  `jtb_tfid` int(9) default '0',
  `jtb_ticon` int(9) default '0',
  `jtb_ttopic` varchar(50) default NULL,
  `jtb_tcolor` varchar(50) default NULL,
  `jtb_tb` int(1) default '0',
  `jtb_tauthor` varchar(50) default NULL,
  `jtb_tauthorip` varchar(50) default NULL,
  `jtb_tcontent` text,
  `jtb_tcontent_files_list` text,
  `jtb_tvoteid` int(9) default '0',
  `jtb_tubb` int(1) default '0',
  `jtb_treply` int(9) default '0',
  `jtb_tcount` int(9) default '0',
  `jtb_ttime` datetime default NULL,
  `jtb_thtop` int(1) default '0',
  `jtb_ttop` int(1) default '0',
  `jtb_tlock` int(1) default '0',
  `jtb_telite` int(1) default '0',
  `jtb_thidden` int(1) default '0',
  `jtb_tlasttime` datetime default NULL,
  `jtb_tlastuser` varchar(50) default NULL,
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_forum_vote`
-- 

CREATE TABLE `jtb_forum_vote` (
  `vid` int(9) NOT NULL auto_increment,
  `jtb_vtopic` varchar(50) default NULL,
  `jtb_vtype` int(9) default '0',
  `jtb_vtime` datetime default NULL,
  `jtb_vday` int(9) default '0',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_forum_vote_data`
-- 

CREATE TABLE `jtb_forum_vote_data` (
  `vdid` int(9) NOT NULL auto_increment,
  `jtb_vdtopic` varchar(50) default NULL,
  `jtb_vdfid` int(9) default '0',
  `jtb_vdvid` int(9) default '0',
  `jtb_vdcount` int(9) default '0',
  PRIMARY KEY  (`vdid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_forum_vote_voter`
-- 

CREATE TABLE `jtb_forum_vote_voter` (
  `vuid` int(9) NOT NULL auto_increment,
  `jtb_vufid` int(9) default '0',
  `jtb_vuip` varchar(50) default NULL,
  `jtb_vuusername` varchar(50) default NULL,
  `jtb_vudata` varchar(255) default NULL,
  `jtb_vutime` datetime default NULL,
  PRIMARY KEY  (`vuid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_product`
-- 

CREATE TABLE `jtb_product` (
  `pid` int(9) NOT NULL auto_increment,
  `jtb_psnum` varchar(50) default NULL,
  `jtb_ptopic` varchar(50) default NULL,
  `jtb_pimage` varchar(255) default NULL,
  `jtb_pcontent` text,
  `jtb_pcontent_images_list` text,
  `jtb_pcttype` int(1) default '0',
  `jtb_ptime` datetime default NULL,
  `jtb_pcls` text,
  `jtb_pclass` int(9) default '0',
  `jtb_phidden` int(1) default '0',
  `jtb_pupdate` int(1) default '0',
  `jtb_pgood` int(1) default '0',
  `jtb_pcount` int(9) default '0',
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_gbook`
-- 

CREATE TABLE `jtb_support_gbook` (
  `gid` int(9) NOT NULL auto_increment,
  `jtb_gauthor` varchar(50) default NULL,
  `jtb_gauthorip` varchar(50) default NULL,
  `jtb_gsex` int(1) default '0',
  `jtb_gqq` int(12) default '0',
  `jtb_gface` int(9) default '0',
  `jtb_gemail` varchar(50) default NULL,
  `jtb_ghomepage` varchar(255) default NULL,
  `jtb_gtopic` varchar(50) default NULL,
  `jtb_gcontent` text,
  `jtb_gtime` datetime default NULL,
  `jtb_greply` text,
  `jtb_greplytime` datetime default NULL,
  `jtb_ghidden` int(1) default '0',
  `jtb_glng` varchar(50) default NULL,
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_linkimages`
-- 

CREATE TABLE `jtb_support_linkimages` (
  `lid` int(9) NOT NULL auto_increment,
  `jtb_ltopic` varchar(50) default NULL,
  `jtb_lurl` varchar(255) default NULL,
  `jtb_lkeyword` varchar(50) default NULL,
  `jtb_limage` varchar(255) default NULL,
  `jtb_lintro` varchar(255) default NULL,
  `jtb_ltime` datetime default NULL,
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_linktext`
-- 

CREATE TABLE `jtb_support_linktext` (
  `lid` int(9) NOT NULL auto_increment,
  `jtb_ltopic` varchar(50) default NULL,
  `jtb_lurl` varchar(255) default NULL,
  `jtb_lkeyword` varchar(50) default NULL,
  `jtb_lintro` varchar(255) default NULL,
  `jtb_ltime` datetime default NULL,
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_review`
-- 

CREATE TABLE `jtb_support_review` (
  `rid` int(9) NOT NULL auto_increment,
  `jtb_rauthor` varchar(50) default NULL,
  `jtb_rauthorip` varchar(50) default NULL,
  `jtb_rcontent` text,
  `jtb_rtime` datetime default NULL,
  `jtb_rkeyword` varchar(50) default NULL,
  `jtb_rfid` int(9) default '0',
  `jtb_rhidden` int(1) default '0',
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_vote`
-- 

CREATE TABLE `jtb_support_vote` (
  `vid` int(9) NOT NULL auto_increment,
  `jtb_vtopic` varchar(50) default NULL,
  `jtb_vtype` int(1) default '0',
  `jtb_vcount` varchar(9) default '0',
  `jtb_vstarttime` datetime default NULL,
  `jtb_vendtime` datetime default NULL,
  `jtb_vlock` int(1) default '0',
  `jtb_vtime` datetime default NULL,
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_vote_data`
-- 

CREATE TABLE `jtb_support_vote_data` (
  `vdid` int(9) NOT NULL auto_increment,
  `jtb_vdtopic` varchar(50) default NULL,
  `jtb_vdfid` int(9) default '0',
  `jtb_vdvid` int(9) default '0',
  `jtb_vdcount` int(9) default '0',
  PRIMARY KEY  (`vdid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_support_vote_voter`
-- 

CREATE TABLE `jtb_support_vote_voter` (
  `vuid` int(9) NOT NULL auto_increment,
  `jtb_vufid` int(9) default '0',
  `jtb_vuip` varchar(50) default NULL,
  `jtb_vuusername` varchar(50) default NULL,
  `jtb_vudata` varchar(255) default NULL,
  `jtb_vutime` datetime default NULL,
  PRIMARY KEY  (`vuid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_sys_sort`
-- 

CREATE TABLE `jtb_sys_sort` (
  `sortid` int(9) NOT NULL auto_increment,
  `sort_sort` varchar(50) default NULL,
  `sort_fid` varchar(255) default NULL,
  `sort_fsid` int(9) default '0',
  `sort_genre` varchar(50) default NULL,
  `sort_lng` varchar(50) default NULL,
  `sort_hidden` int(1) default '0',
  `sort_order` int(9) default '0',
  PRIMARY KEY  (`sortid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_sys_upload`
-- 

CREATE TABLE `jtb_sys_upload` (
  `upid` int(9) NOT NULL auto_increment,
  `jtb_upgenre` varchar(50) default NULL,
  `jtb_upupident` varchar(50) default NULL,
  `jtb_upfilename` varchar(255) default NULL,
  `jtb_upfield` varchar(50) default NULL,
  `jtb_upfid` int(9) default '0',
  `jtb_uptime` datetime default NULL,
  `jtb_upuser` varchar(50) default NULL,
  `jtb_upvalid` int(1) default '0',
  `jtb_upvoidreason` int(1) default '0',
  PRIMARY KEY  (`upid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_ubase`
-- 

CREATE TABLE `jtb_ubase` (
  `uid` int(9) NOT NULL auto_increment,
  `jtb_uusername` varchar(50) default NULL,
  `jtb_upassword` varchar(50) default NULL,
  `jtb_uemail` varchar(50) default NULL,
  `jtb_ucity` varchar(50) default NULL,
  `jtb_usex` varchar(50) default NULL,
  `jtb_uold` varchar(50) default NULL,
  `jtb_uname` varchar(50) default NULL,
  `jtb_uqq` varchar(50) default NULL,
  `jtb_umsn` varchar(50) default NULL,
  `jtb_uphone` varchar(50) default NULL,
  `jtb_uhomepage` varchar(255) default NULL,
  `jtb_ucode` varchar(50) default NULL,
  `jtb_uaddress` varchar(255) default NULL,
  `jtb_uemoney` int(9) default '0',
  `jtb_uintegral` int(9) default '0',
  `jtb_utopic` int(9) default '0',
  `jtb_uface` int(9) default '0',
  `jtb_uface_u` int(1) default '0',
  `jtb_uface_url` varchar(255) default NULL,
  `jtb_uface_width` int(9) default '0',
  `jtb_uface_height` int(9) default '0',
  `jtb_usign` varchar(255) default NULL,
  `jtb_uforum_admin` int(1) default '0',
  `jtb_uutype` int(9) default '0',
  `jtb_ulock` int(1) default '0',
  `jtb_utime` datetime default NULL,
  `jtb_ulasttime` datetime default NULL,
  `jtb_upretime` datetime default NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_ubase_friend`
-- 

CREATE TABLE `jtb_ubase_friend` (
  `feid` int(9) NOT NULL auto_increment,
  `jtb_feusername` varchar(50) default NULL,
  `jtb_fename` varchar(50) default NULL,
  `jtb_fetime` datetime default NULL,
  PRIMARY KEY  (`feid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Ľṹ `jtb_ubase_message`
-- 

CREATE TABLE `jtb_ubase_message` (
  `mid` int(9) NOT NULL auto_increment,
  `jtb_mtopic` varchar(50) default NULL,
  `jtb_mcontent` text,
  `jtb_mread` int(1) default '0',
  `jtb_mtime` datetime default NULL,
  `jtb_mlen` int(9) default '0',
  `jtb_maddresser` varchar(50) default NULL,
  `jtb_mrecipients` varchar(50) default NULL,
  PRIMARY KEY  (`mid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- ڱвʼԱʻ `jtb_admin`
-- 

INSERT INTO `jtb_admin` (`jtb_aname`, `jtb_apword`, `jtb_apopedom`) VALUES ('admin', '21232f297a57a5a743894a0e4a801fc3', '-1') ;