Discuz! X2.5Êý¾Ý¿â×Öµä

ip3 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP¶Î', ip4 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP¶Î',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '»áÔ±id', username char(15) NOT NULL default COMMENT '»áÔ±Ãû',

groupid smallint(6) unsigned NOT NULL default '0' COMMENT '»áÔ±×é', invisible tinyint(1) NOT NULL default '0' COMMENT 'ÊÇ·ñÒþÉíµÇ¼',

`action` tinyint(1) unsigned NOT NULL default '0' COMMENT 'µ±Ç°¶¯×÷', lastactivity int(10) unsigned NOT NULL default '0' COMMENT '×îºó»î¶¯Ê±¼ä',

lastolupdate int(10) unsigned NOT NULL default '0' COMMENT 'ÔÚÏßʱ¼ä×îºó¸üÐÂ', fid mediumint(8) unsigned NOT NULL default '0' COMMENT 'ÂÛ̳id', tid mediumint(8) unsigned NOT NULL default '0' COMMENT 'Ö÷Ìâid', UNIQUE KEY sid (sid), KEY uid (uid)

) ENGINE=MEMORY COMMENT='»áÔ±ÈÏÖ¤±í';

DROP TABLE IF EXISTS pre_common_setting; CREATE TABLE pre_common_setting (

skey varchar(255) NOT NULL default COMMENT '±äÁ¿Ãû', svalue text NOT NULL COMMENT 'Öµ', PRIMARY KEY (skey)

) ENGINE=MyISAM COMMENT='ÉèÖñí';

DROP TABLE IF EXISTS pre_common_smiley; CREATE TABLE pre_common_smiley (

id smallint(6) unsigned NOT NULL auto_increment COMMENT '±íÇéid', typeid smallint(6) unsigned NOT NULL COMMENT '±íÇé·ÖÀà id', displayorder tinyint(1) NOT NULL default '0' COMMENT 'ÏÔʾ˳Ðò',

`type` enum('smiley','stamp','stamplist') NOT NULL default 'smiley' COMMENT 'ÀàÐÍ', `code` varchar(30) NOT NULL default COMMENT '±ê¼Ç', url varchar(30) NOT NULL default COMMENT '·¾¶', PRIMARY KEY (id),

KEY `type` (`type`, displayorder)

) ENGINE=MyISAM COMMENT='±íÇé±í';

DROP TABLE IF EXISTS pre_common_stat; CREATE TABLE pre_common_stat (

daytime int(10) unsigned NOT NULL default '0' COMMENT 'ʱ¼ä', login int(10) unsigned NOT NULL default '0' COMMENT 'µÇ½',

mobilelogin int(10) unsigned NOT NULL default '0' COMMENT 'ÊÖ»úµÇ½',

connectlogin int(10) unsigned NOT NULL default '0' COMMENT 'QQConnectµÇ½', register int(10) unsigned NOT NULL default '0' COMMENT '×¢²á',

invite int(10) unsigned NOT NULL default '0' COMMENT 'ÑûÇë',

appinvite int(10) unsigned NOT NULL default '0' COMMENT 'Ó¦ÓÃÑûÇë', doing int(10) unsigned NOT NULL default '0' COMMENT '¼Ç¼', blog int(10) unsigned NOT NULL default '0' COMMENT 'ÈÕÖ¾', pic int(10) unsigned NOT NULL default '0' COMMENT 'ͼƬ', poll int(10) unsigned NOT NULL default '0' COMMENT 'ͶƱ', activity int(10) unsigned NOT NULL default '0' COMMENT '»î¶¯', `share` int(10) unsigned NOT NULL default '0' COMMENT '·ÖÏí', thread int(10) unsigned NOT NULL default '0' COMMENT 'Ö÷Ìâ',

docomment int(10) unsigned NOT NULL default '0' COMMENT '¼Ç¼ÆÀÂÛ', blogcomment int(10) unsigned NOT NULL default '0' COMMENT 'ÈÕÖ¾ÆÀÂÛ', piccomment int(10) unsigned NOT NULL default '0' COMMENT 'ͼƬÆÀÂÛ', sharecomment int(10) unsigned NOT NULL default '0' COMMENT '·ÖÏíÆÀÂÛ', reward int(10) unsigned NOT NULL default '0' COMMENT 'ÐüÉÍ', debate int(10) unsigned NOT NULL default '0' COMMENT '±çÂÛ', trade int(10) unsigned NOT NULL default '0' COMMENT 'ÉÌÆ·', `group` int(10) unsigned NOT NULL default '0' COMMENT 'Ⱥ×é',

groupjoin int(10) unsigned NOT NULL default '0' COMMENT '²ÎÓëȺ×é', groupthread int(10) unsigned NOT NULL default '0' COMMENT 'Ⱥ×éÖ÷Ìâ', grouppost int(10) unsigned NOT NULL default '0' COMMENT 'Ⱥ×é»Ø¸´', post int(10) unsigned NOT NULL default '0' COMMENT 'Ö÷Ìâ»Ø¸´', wall int(10) unsigned NOT NULL default '0' COMMENT 'ÁôÑÔ', poke int(10) unsigned NOT NULL default '0' COMMENT '´òÕкô', click int(10) unsigned NOT NULL default '0' COMMENT '±í̬',

sendpm int(10) unsigned NOT NULL default '0' COMMENT '·¢ËÍPM', friend int(10) unsigned NOT NULL default '0' COMMENT '³ÉΪºÃÓÑ', addfriend int(10) unsigned NOT NULL default '0' COMMENT 'ºÃÓÑÇëÇó', PRIMARY KEY (daytime)

) ENGINE=MyISAM COMMENT='Ç÷ÊÆͳ¼Æ';

DROP TABLE IF EXISTS pre_common_statuser; CREATE TABLE pre_common_statuser (

uid mediumint(8) unsigned NOT NULL default '0', daytime int(10) unsigned NOT NULL default '0',

`type` char(20) NOT NULL default COMMENT '¸÷ÖÖÓû§ÐÐΪÈ磺invite¡¢register¡¢login...', KEY uid (uid)

) ENGINE=MyISAM COMMENT='ͳ¼ÆÓû§±í';

DROP TABLE IF EXISTS pre_common_style; CREATE TABLE pre_common_style (

styleid smallint(6) unsigned NOT NULL auto_increment COMMENT '·ç¸ñid', `name` varchar(20) NOT NULL default COMMENT '·ç¸ñÃû³Æ',

available tinyint(1) NOT NULL default '1' COMMENT '·ç¸ñÊÇ·ñ¿ÉÓÃ',

templateid smallint(6) unsigned NOT NULL default '0' COMMENT '¶ÔӦģ°åid', extstyle varchar(255) NOT NULL default COMMENT 'ÅäÉ«', PRIMARY KEY (styleid)

) ENGINE=MyISAM COMMENT='·ç¸ñ±í';

DROP TABLE IF EXISTS pre_common_stylevar; CREATE TABLE pre_common_stylevar (

stylevarid smallint(6) unsigned NOT NULL auto_increment COMMENT '·ç¸ñ±äÁ¿id', styleid smallint(6) unsigned NOT NULL default '0' COMMENT '·ç¸ñid', variable text NOT NULL COMMENT '±äÁ¿Ãû', substitute text NOT NULL COMMENT '±äÁ¿¸³Öµ', PRIMARY KEY (stylevarid), KEY styleid (styleid)

) ENGINE=MyISAM COMMENT='·ç¸ñ±äÁ¿±í';

DROP TABLE IF EXISTS pre_common_syscache; CREATE TABLE pre_common_syscache (

cname varchar(32) NOT NULL COMMENT '»º´æÃû³Æ',

`ctype` tinyint(3) unsigned NOT NULL COMMENT '»º´æÀàÐÍ 0=value, serialize=1', dateline int(10) unsigned NOT NULL COMMENT '»º´æÉú³Éʱ¼ä', `data` mediumblob NOT NULL COMMENT '»º´æÊý¾Ý', PRIMARY KEY (cname)

) ENGINE=MyISAM COMMENT='»º´æÊý¾Ý±í';

DROP TABLE IF EXISTS pre_common_template; CREATE TABLE pre_common_template (

templateid smallint(6) unsigned NOT NULL auto_increment COMMENT 'Ä£°åid', `name` varchar(30) NOT NULL default COMMENT 'Ãû³Æ', `directory` varchar(100) NOT NULL default COMMENT 'Ŀ¼', copyright varchar(100) NOT NULL default COMMENT '°æȨ', PRIMARY KEY (templateid)

) ENGINE=MyISAM COMMENT='Ä£°å±í';

DROP TABLE IF EXISTS pre_common_usergroup; CREATE TABLE pre_common_usergroup (

groupid smallint(6) unsigned NOT NULL auto_increment COMMENT '»áÔ±×éid', radminid tinyint(3) NOT NULL default '0' COMMENT '¹ØÁª¹Ø¹ÜÀí×é',

`type` enum('system','special','member') NOT NULL default 'member' COMMENT 'ÀàÐÍ', system varchar(255) NOT NULL default 'private' COMMENT '»áÔ±ÊÇ·ñ¿ÉÒÔ×ÔÓɽø³ö',

grouptitle varchar(255) NOT NULL default COMMENT '×éÍ·ÏÎ',

creditshigher int(10) NOT NULL default '0' COMMENT '¸Ã×éµÄ»ý·ÖÉÏÏÞ', creditslower int(10) NOT NULL default '0' COMMENT '¸Ã×éµÄ»ý·ÖÏÂÏÞ', stars tinyint(3) NOT NULL default '0' COMMENT 'ÐÇÐÇÊýÁ¿', color varchar(255) NOT NULL default COMMENT '×éÍ·ÏÎÑÕÉ«',

icon varchar(255) NOT NULL default ,

allowvisit tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·ÃÎÊ',

allowsendpm tinyint(1) NOT NULL default '1' COMMENT 'ÊÇ·ñÔÊÐí·¢ËͶÌÐÅÏ¢', allowinvite tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓÃÑûÇë×¢²á',

allowmailinvite tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíͨ¹ýÂÛ̳Óʼþϵͳ·¢ËÍÑûÇëÂë',

maxinvitenum tinyint(3) unsigned NOT NULL default '0' COMMENT '×î´óÑûÇëÂëÓµÓÐÊýÁ¿', inviteprice smallint(6) unsigned NOT NULL default '0' COMMENT 'ÑûÇëÂ빺Âò¼Û¸ñ', maxinviteday smallint(6) unsigned NOT NULL default '0' COMMENT 'ÑûÇëÂëÓÐЧÆÚ', PRIMARY KEY (groupid),

KEY creditsrange (creditshigher,creditslower) ) ENGINE=MyISAM COMMENT='Óû§×é±í';

DROP TABLE IF EXISTS pre_common_usergroup_field; CREATE TABLE pre_common_usergroup_field (

groupid smallint(6) unsigned NOT NULL COMMENT '»áÔ±×éid',

readaccess tinyint(3) unsigned NOT NULL default '0' COMMENT 'ÔĶÁȨÏÞ', allowpost tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢Ìû', allowreply tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí»Ø¸´',

allowpostpoll tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±íͶƱ', allowpostreward tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±íÐüÉÍ', allowposttrade tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±í½»Ò×', allowpostactivity tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±í»î¶¯', allowdirectpost tinyint(1) NOT NULL default '0' COMMENT 'ÊÇ·ñÐèÒªÉóºË', allowgetattach tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÏÂÔظ½¼þ', allowgetimage tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí²é¿´Í¼Æ¬', allowpostattach tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÉÏ´«¸½¼þ', allowpostimage tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÉÏ´«Í¼Æ¬', allowvote tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí²ÎÓëͶƱ', allowsearch tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíËÑË÷',

allowcstatus tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí×Ô¶¨ÒåÍ·ÏÎ', allowinvisible tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÒþÉíµÇ¼', allowtransfer tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí»ý·ÖתÕÊ',

allowsetreadperm tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÉèÖÃÔĶÁȨÏÞ', allowsetattachperm tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÉèÖø½¼þȨÏÞ', allowposttag tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓñêÇ©',

allowhidecode tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓÃhide´úÂë', allowhtml tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓÃhtml',