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 ÒѺöÂÔ',