--
-- JavaCenter Home 数据库SQL
-- 生成日期: 2008 年 1 月 1 日 00:00
--
--
-- 数据库: 'jchome'
--
-- --------------------------------------------------------
--
-- 表的结构 'jchome_ad'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_adminsession'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_album'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_appcreditlog'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_blacklist'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_block'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_blog'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_blogfield'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_cache'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_class'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_click'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_clickuser'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_comment'
--
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;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_config'
--
CREATE TABLE jchome_config (
var varchar(30) NOT NULL default '',
datavalue text NOT NULL,
PRIMARY KEY (var)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- 表的结构 'jchome_cron'
--
CREATE TABLE jchome_cron (
cronid smallint(6) unsigned NOT NULL auto_increment
JavaCenter_Home
5星 · 超过95%的资源 需积分: 10 194 浏览量
2011-10-25
23:40:42
上传
评论 2
收藏 17.91MB ZIP 举报 
JavaCenter_Home （1101个子文件） 
style.css 42KB network.css 13KB style.css 13KB style.css 9KB style.css 9KB album.css 6KB event.css 6KB poll.css 5KB space.css 4KB blog.css 4KB gift.css 4KB contact.css 3KB style.css 3KB addrbook.css 3KB style.css 3KB doing.css 2KB style.css 2KB style.css 1KB style.css 1KB style.css 1KB rss.css 1KB thread.css 1KB style.css 1KB style.css 1KB ext_stopword.dic 153B
header.gif 52KB body_bg.gif 42KB 3.logo.gif 30KB 4.bg.gif 28KB doing.gif 24KB mtag1.gif 23KB space.gif 23KB 3.bg.gif 16KB album.gif 15KB cp2.gif 14KB 404.gif 13KB cp.gif 13KB noavatar_big.gif 12KB 1275549292171_pzXItW.gif 11KB 6.topbg.gif 11KB 3.topbg.gif 10KB mtag2.gif 10KB 500.gif 10KB header.gif 10KB body_bg.gif 9KB 1275549917343_TdOM0Y.gif 8KB 1275548899437_H1fx1b.gif 8KB 1275549566359_pidssZ.gif 8KB 1275550116515_KLl7iy.gif 8KB home.gif 7KB 1275549206843_AhQFuV.gif 7KB body_bg.gif 7KB 1275549026281_PXA293.gif 7KB 1275550025937_gMRcbq.gif 7KB 1275549642609_8FYmnF.gif 7KB 1275549622593_yO4kf7.gif 7KB 1275549588921_GVGMbK.gif 7KB 1275549606843_WDE6IT.gif 7KB loading.gif 7KB 1275548925437_RyNFXz.gif 7KB 1275549493593_bMSbkz.gif 6KB 1275549898515_XBL4XQ.gif 6KB blog.gif 6KB 1275549265218_tg0pGk.gif 6KB 1275549995562_52QIW6.gif 6KB noavatar_middle.gif 6KB 1275549948562_8EBlaq.gif 6KB 1275549962421_GGD6ny.gif 6KB 7.toplogo.gif 6KB 1275549471609_2LsSOz.gif 6KB 1275549544312_7saP3Z.gif 6KB 3.bg.gif 6KB mtag3.gif 6KB 1.bg.gif 5KB 1275548965687_4hXFYg.gif 5KB 2.gif 5KB 1275548996484_geO3Bd.gif 5KB 1275549677296_Y8CQeg.gif 5KB 1275549444312_z7tPfQ.gif 5KB 1275549081187_yzonc0.gif 5KB 1275548853640_7KBa9p.gif 5KB yel_bg.gif 5KB editor_boolbar.gif 5KB header_bg.gif 5KB yel_bg.gif 5KB yel_bg.gif 5KB buttons.gif 5KB yel_bg.gif 5KB header.gif 4KB 1275549930687_1ggT7u.gif 4KB 1275549975390_K4WqIz.gif 4KB showuser_label.gif 4KB 1275549524671_7kAhdI.gif 4KB icon.gif 4KB ilayer.gif 4KB share2.gif 4KB login_logo.gif 4KB avatar_bg.gif 4KB print.gif 4KB 1275549058015_mg7DN6.gif 3KB共 1101 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
- 1
- 2
前往页