JavaCenter_Home_UTF8.zip_JavaCenter_home networking java_ten9sm_

CREATE TABLE jchome_ad ( adid smallint(6) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '1', title varchar(50) NOT NULL default '', pagetype varchar(20) NOT NULL default '', adcode text NOT NULL, system tinyint(1) NOT NULL default '0', PRIMARY KEY (adid) ) ENGINE=MyISAM; CREATE TABLE jchome_adminsession ( uid mediumint(8) unsigned NOT NULL default '0', ip char(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', errorcount tinyint(1) NOT NULL default '0', PRIMARY KEY (uid) ) ENGINE=MEMORY; CREATE TABLE jchome_album ( albumid mediumint(8) unsigned NOT NULL auto_increment, albumname varchar(50) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', username varchar(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', updatetime int(10) unsigned NOT NULL default '0', picnum smallint(6) unsigned NOT NULL default '0', pic varchar(60) NOT NULL default '', picflag tinyint(1) NOT NULL default '0', friend tinyint(1) NOT NULL default '0', `password` varchar(10) NOT NULL default '', target_ids text NOT NULL, PRIMARY KEY (albumid), KEY uid (uid,updatetime), KEY updatetime (updatetime) ) ENGINE=MyISAM; CREATE TABLE jchome_appcreditlog ( logid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default '0', appid mediumint(8) unsigned NOT NULL default '0', appname varchar(60) NOT NULL default '', `type` tinyint(1) NOT NULL default '0', credit mediumint(8) unsigned NOT NULL default '0', note text NOT NULL, dateline int(10) unsigned NOT NULL default '0', PRIMARY KEY (logid), KEY uid (uid,dateline), KEY appid (appid) ) ENGINE=MyISAM; CREATE TABLE jchome_blacklist ( uid mediumint(8) unsigned NOT NULL default '0', buid mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', PRIMARY KEY (uid,buid), KEY uid (uid,dateline) ) ENGINE=MyISAM; CREATE TABLE jchome_block ( bid smallint(6) unsigned NOT NULL auto_increment, blockname varchar(40) NOT NULL default '', blocksql text NOT NULL, cachename varchar(30) NOT NULL default '', cachetime smallint(6) unsigned NOT NULL default '0', startnum tinyint(3) unsigned NOT NULL default '0', num tinyint(3) unsigned NOT NULL default '0', perpage tinyint(3) unsigned NOT NULL default '0', htmlcode text NOT NULL, PRIMARY KEY (bid) ) ENGINE=MyISAM; CREATE TABLE jchome_blog ( blogid mediumint(8) unsigned NOT NULL auto_increment, topicid mediumint(8) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', username char(15) NOT NULL default '', `subject` char(80) NOT NULL default '', classid smallint(6) unsigned NOT NULL default '0', viewnum mediumint(8) unsigned NOT NULL default '0', replynum mediumint(8) unsigned NOT NULL default '0', hot mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', pic char(120) NOT NULL default '', picflag tinyint(1) NOT NULL default '0', noreply tinyint(1) NOT NULL default '0', friend tinyint(1) NOT NULL default '0', `password` char(10) NOT NULL default '', click_1 smallint(6) unsigned NOT NULL default '0', click_2 smallint(6) unsigned NOT NULL default '0', click_3 smallint(6) unsigned NOT NULL default '0', click_4 smallint(6) unsigned NOT NULL default '0', click_5 smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (blogid), KEY uid (uid,dateline), KEY topicid (topicid,dateline), KEY dateline (dateline) ) ENGINE=MyISAM; CREATE TABLE jchome_blogfield ( blogid mediumint(8) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', tag varchar(255) NOT NULL default '', message mediumtext NOT NULL, postip varchar(20) NOT NULL default '', related text NOT NULL, relatedtime int(10) unsigned NOT NULL default '0', target_ids text NOT NULL, hotuser text NOT NULL, magiccolor tinyint(6) NOT NULL default '0', magicpaper tinyint(6) NOT NULL default '0', magiccall tinyint(1) NOT NULL default '0', PRIMARY KEY (blogid) ) ENGINE=MyISAM; CREATE TABLE jchome_cache ( cachekey varchar(16) NOT NULL default '', `value` mediumtext NOT NULL, mtime int(10) unsigned NOT NULL default '0', PRIMARY KEY (cachekey) ) ENGINE=MyISAM; CREATE TABLE jchome_class ( classid mediumint(8) unsigned NOT NULL auto_increment, classname char(40) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', PRIMARY KEY (classid), KEY uid (uid) ) ENGINE=MyISAM; CREATE TABLE jchome_click ( clickid smallint(6) unsigned NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', icon varchar(100) NOT NULL default '', idtype varchar(15) NOT NULL default '', displayorder tinyint(6) unsigned NOT NULL default '0', PRIMARY KEY (clickid), KEY idtype (idtype,displayorder) ) ENGINE=MyISAM; CREATE TABLE jchome_clickuser ( uid mediumint(8) unsigned NOT NULL default '0', username varchar(15) NOT NULL default '', id mediumint(8) unsigned NOT NULL default '0', idtype varchar(15) NOT NULL default '', clickid smallint(6) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', KEY id (id,idtype,dateline), KEY uid (uid,idtype,dateline) ) ENGINE=MyISAM; CREATE TABLE jchome_comment ( cid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default '0', id mediumint(8) unsigned NOT NULL default '0', idtype varchar(20) NOT NULL default '', authorid mediumint(8) unsigned NOT NULL default '0', author varchar(15) NOT NULL default '', ip varchar(20) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', message text NOT NULL, magicflicker tinyint(1) NOT NULL default '0', PRIMARY KEY (cid), KEY authorid (authorid, idtype), KEY id (id, idtype, dateline) ) ENGINE=MyISAM; CREATE TABLE jchome_config ( var varchar(30) NOT NULL default '', datavalue text NOT NULL, PRIMARY KEY (var) ) ENGINE=MyISAM; CREATE TABLE jchome_cron ( cronid smallint(6) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '0', `type` enum('user','system') NOT NULL default 'user', `name` char(50) NOT NULL default '', filename char(50) NOT NULL default '', lastrun int(10) unsigned NOT NULL default '0', nextrun int(10) unsigned NOT NULL default '0', weekday tinyint(1) NOT NULL default '0', `day` tinyint(2) NOT NULL default '0', `hour` tinyint(2) NOT NULL default '0', `minute` char(36) NOT NULL default '', PRIMARY KEY (cronid), KEY nextrun (available,nextrun) ) ENGINE=MyISAM; CREATE TABLE jchome_creditrule ( rid mediumint(8) unsigned NOT NULL auto_increment, rulename char(20) NOT NULL default '', `action` char(20) NOT NULL default '', cycletype tinyint(1) NOT NULL default '0', cycletime int(10) NOT NULL default '0', rewardnum tinyint(2) NOT NULL default '1', rewardtype tinyint(1) NOT NULL default '1', norepeat tinyint(1) NOT NULL default '0', credit mediumint(8) unsigned NOT NULL default '0', experience mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (rid), KEY `action` (`action`) ) ENGINE=MyISAM; CREATE TABLE jchome_creditlog ( clid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default '0', rid mediumint(8) unsigned NOT NULL default '0', total mediumint(8) unsigned NOT NULL default '0', cyclenum mediumint(8) unsigned NOT NULL default '0', credit mediumint(8) unsigned NOT NULL default '0', experience mediumint(8) unsigned NOT NULL default '0', starttime int(10) unsigned N