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

displayorder tinyint(3) NOT NULL default '0' COMMENT 'ÏÔʾ˳Ðò', title varchar(30) NOT NULL default COMMENT '×éÃû³Æ', url varchar(30) NOT NULL default COMMENT 'ͼÀýURL' ) ENGINE=MyISAM COMMENT='ÔÚÏßÁÐ±í¶¨ÖÆ';

DROP TABLE IF EXISTS pre_forum_order; CREATE TABLE pre_forum_order (

orderid char(32) NOT NULL default COMMENT '¶©µ¥ºÅid', `status` char(3) NOT NULL default COMMENT '״̬',

buyer char(50) NOT NULL default COMMENT '¹ºÂòÕßÐÕÃû',

admin char(15) NOT NULL default COMMENT '²¹µ¥¹ÜÀíÔ±ÐÕÃû',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '¹ºÂòÕßid', amount int(10) unsigned NOT NULL default '0' COMMENT 'ÊýÁ¿', price float(7,2) unsigned NOT NULL default '0.00' COMMENT '¼Û¸ñ',

submitdate int(10) unsigned NOT NULL default '0' COMMENT 'Ìá½»ÈÕÆÚ', confirmdate int(10) unsigned NOT NULL default '0' COMMENT 'È·ÈÏÈÕÆÚ', email char(40) NOT NULL default COMMENT '¹ºÂòʱµÄEmail', ip char(15) NOT NULL default COMMENT '¹ºÂòʱµÄIP', UNIQUE KEY orderid (orderid), KEY submitdate (submitdate), KEY uid (uid,submitdate)

) ENGINE=MyISAM COMMENT='¶©µ¥ÐÅÏ¢±í';

DROP TABLE IF EXISTS pre_forum_groupfield; CREATE TABLE pre_forum_groupfield (

fid mediumint(8) unsigned NOT NULL default '0' COMMENT 'Ⱥ×鹨Áªfid', privacy tinyint(1) unsigned NOT NULL default '0' COMMENT 'Ⱥ×éÒþ˽ÉèÖÃ', dateline int(10) unsigned NOT NULL default '0' COMMENT '»º´æÉú³Éʱ¼ä', type varchar(255) NOT NULL COMMENT '»º´æÀàÐÍ', data text NOT NULL COMMENT '»º´æÊý¾Ý',

UNIQUE KEY types (fid,type), KEY fid (fid), KEY type (type)

) ENGINE = MyISAM COMMENT='Ⱥ×éÀ©Õ¹ÐÅÏ¢»º´æ';

DROP TABLE IF EXISTS pre_forum_groupinvite; CREATE TABLE pre_forum_groupinvite (

fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT 'Ⱥ×éid', uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT 'ÑûÇëÈËid',

inviteuid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '±»ÑûÇëÈËid', dateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT 'ÑûÇëʱ¼ä',

UNIQUE KEY ids (fid,inviteuid), KEY dateline (dateline)

) ENGINE = MYISAM COMMENT='Ⱥ×éÑûÇë';

DROP TABLE IF EXISTS pre_forum_groupuser; CREATE TABLE pre_forum_groupuser (

fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT 'Ⱥ×鹨Áªfid', uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±id', username CHAR( 15 ) NOT NULL COMMENT '³ÉÔ±Ãû',

level TINYINT( 3 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±µÈ¼¶\\n(0:´ýÉóºË 1:ȺÖ÷ 2:¸±ÈºÖ÷ 3:Ã÷ÐdzÉÔ± 4:ÆÕͨ³ÉÔ±)',

threads MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±Ö÷ÌâÊý', replies MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±»Ø¸´Êý', joindateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±¼ÓÈëȺ×éʱ¼ä', lastupdate INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±×îºó»î¶¯Ê±¼ä', privacy TINYINT( 1 ) UNSIGNED NOT NULL default '0' COMMENT '³ÉÔ±Òþ˽ÉèÖÃ', PRIMARY KEY (fid,uid),

KEY uid_lastupdate (uid,lastupdate), KEY userlist (fid,level,lastupdate)

) ENGINE = MYISAM COMMENT='Ⱥ×é³ÉÔ±';

DROP TABLE IF EXISTS pre_common_plugin; CREATE TABLE pre_common_plugin (

pluginid smallint(6) unsigned NOT NULL auto_increment COMMENT '²å¼þid', available tinyint(1) NOT NULL default '0' COMMENT 'ÊÇ·ñÆôÓÃ',

adminid tinyint(1) unsigned NOT NULL default '0' COMMENT '¹ÜÀíÔ±id', `name` varchar(40) NOT NULL default COMMENT 'Ãû³Æ',

identifier varchar(40) NOT NULL default COMMENT 'Ψһ±êʶ·û', description varchar(255) NOT NULL default COMMENT '½âÊÍ˵Ã÷', datatables varchar(255) NOT NULL default COMMENT '²å¼þÊý¾Ý±í', `directory` varchar(100) NOT NULL default COMMENT '²å¼þĿ¼', copyright varchar(100) NOT NULL default COMMENT '°æÈ¨ÐÅÏ¢', modules text NOT NULL COMMENT '²å¼þÐÅÏ¢',

version varchar(20) NOT NULL default COMMENT '²å¼þ°æ±¾', PRIMARY KEY (pluginid),

UNIQUE KEY identifier (identifier)

) ENGINE=MyISAM COMMENT='²å¼þ±í';

DROP TABLE IF EXISTS pre_common_pluginvar; CREATE TABLE pre_common_pluginvar (

pluginvarid mediumint(8) unsigned NOT NULL auto_increment COMMENT '²å¼þ±äÁ¿id',

pluginid smallint(6) unsigned NOT NULL default '0' COMMENT '²å¼þid', displayorder tinyint(3) NOT NULL default '0' COMMENT 'ÏÔʾ˳Ðò', title varchar(100) NOT NULL default COMMENT 'Ãû³Æ',

description varchar(255) NOT NULL default COMMENT '½âÊÍ˵Ã÷', variable varchar(40) NOT NULL default COMMENT '±äÁ¿Ãû', `type` varchar(20) NOT NULL default 'text' COMMENT 'ÀàÐÍ', `value` text NOT NULL COMMENT 'Öµ', extra text NOT NULL COMMENT '¸½¼Ó', PRIMARY KEY (pluginvarid), KEY pluginid (pluginid)

) ENGINE=MyISAM COMMENT='²å¼þ±äÁ¿±í';

DROP TABLE IF EXISTS pre_forum_thread_moderate; CREATE TABLE pre_forum_thread_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='Ö÷ÌâÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_forum_post_moderate; CREATE TABLE pre_forum_post_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='Ìû×ÓÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_home_blog_moderate; CREATE TABLE pre_home_blog_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='ÈÕÖ¾ÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_home_pic_moderate;

CREATE TABLE pre_home_pic_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='ͼƬÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_home_doing_moderate; CREATE TABLE pre_home_doing_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='¼Ç¼ÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_home_share_moderate; CREATE TABLE pre_home_share_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='·ÖÏíÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_portal_article_moderate; CREATE TABLE pre_portal_article_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),

KEY status (status, dateline)

) ENGINE=MyISAM COMMENT='ÎÄÕÂÉóºËÊý¾Ý±í';

DROP TABLE IF EXISTS pre_home_comment_moderate; CREATE TABLE pre_home_comment_moderate (

id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID', idtype varchar(15) NOT NULL default COMMENT 'IDÀàÐÍ',

status tinyint(3) NOT NULL default '0' COMMENT '״̬ 0 ÉóºËÖУ¬1 ÒѺöÂÔ',

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)