allowanonymous tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÄäÃû·¢Ìû',

allowsigbbcode tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÇ©ÃûʹÓÃbbcode', allowsigimgcode tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓÃimg', allowmagics tinyint(1) unsigned NOT NULL COMMENT 'ÔÊÐíʹÓõÀ¾ß',

disableperiodctrl tinyint(1) NOT NULL default '0' COMMENT '²»ÊÜʱ¼ä¶ÎÏÞÖÆ', reasonpm tinyint(1) NOT NULL default '0' COMMENT '²Ù×÷ÀíÓɶÌÐÅ֪ͨ×÷Õß', maxprice smallint(6) unsigned NOT NULL default '0' COMMENT 'Ö÷Ìâ×î´óÊÛ¼Û', maxsigsize smallint(6) unsigned NOT NULL default '0' COMMENT '×î´óÇ©Ãû³ß´ç', maxattachsize int(10) unsigned NOT NULL default '0' COMMENT '×î´ó¸½¼þ³ß´ç',

maxsizeperday int(10) unsigned NOT NULL default '0' COMMENT 'ÿÌì×î´ó¸½¼þ×ܳߴç', maxthreadsperhour tinyint(3) unsigned NOT NULL default '0' COMMENT 'ÿСʱ·¢Ö÷ÌâÊýÏÞÖÆ',

maxpostsperhour tinyint(3) unsigned NOT NULL default '0' COMMENT 'ÿСʱ·¢»ØÌûÊýÏÞÖÆ',

attachextensions char(100) NOT NULL default COMMENT 'ÔÊÐí·¢±íµÄ¸½¼þÀàÐÍ', raterange char(150) NOT NULL default COMMENT 'ÆÀ·Ö·¶Î§',

mintradeprice smallint(6) unsigned NOT NULL default '1' COMMENT '½»Ò××îС»ý·Ö', maxtradeprice smallint(6) unsigned NOT NULL default '0' COMMENT '½»Ò××î´ó»ý·Ö', minrewardprice smallint(6) unsigned NOT NULL default '1' COMMENT 'ÐüÉÍ×îС»ý·Ö', maxrewardprice smallint(6) unsigned NOT NULL default '0' COMMENT 'ÐüÉÍ×î´ó»ý·Ö', magicsdiscount tinyint(1) NOT NULL COMMENT 'µÀ¾ßÕÛ¿Û',

maxmagicsweight smallint(6) unsigned NOT NULL COMMENT 'µÀ¾ß¸ºÔØ×î´óÖµ', allowpostdebate tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±í±çÂÛ', tradestick tinyint(1) unsigned NOT NULL COMMENT '¿ÉÉÌÆ·ÍƼöÊý', exempt tinyint(1) unsigned NOT NULL COMMENT 'Óû§×é±í´ïʽ',

maxattachnum smallint(6) NOT NULL default '0' COMMENT '×î´óÿÌ츽¼þÊýÁ¿', allowposturl tinyint(1) NOT NULL default '3' COMMENT 'ÊÇ·ñÔÊÐí·¢Ëͺ¬ url ÄÚÈÝ',

allowrecommend tinyint(1) unsigned NOT NULL default '1' COMMENT 'ÊÇ·ñÔÊÐíÆÀ¼ÛÖ÷Ìâ', allowpostrushreply TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'ÔÊÐí·¢±íÇÀÂ¥Ìû', maxfriendnum smallint(6) unsigned NOT NULL default '0' COMMENT '×î¶àºÃÓÑÊý', maxspacesize int(10) unsigned NOT NULL default '0' COMMENT '¿Õ¼ä´óС', allowcomment tinyint(1) NOT NULL default '0' COMMENT '·¢±íÁôÑÔ/ÆÀÂÛ',

allowcommentarticle smallint(6) NOT NULL default '0' COMMENT '·¢±íÎÄÕµÄÆÀÂÛ',

searchinterval smallint(6) unsigned NOT NULL default '0' COMMENT 'Á½´ÎËÑË÷²Ù×÷¼ä¸ô', searchignore tinyint(1) NOT NULL default '0' COMMENT 'ÊÇ·ñÃâ·ÑËÑË÷', allowblog tinyint(1) NOT NULL default '0' COMMENT '·¢±íÈÕÖ¾', allowdoing tinyint(1) NOT NULL default '0' COMMENT '·¢±í¼Ç¼', allowupload tinyint(1) NOT NULL default '0' COMMENT 'ÉÏ´«Í¼Æ¬', allowshare tinyint(1) NOT NULL default '0' COMMENT '·¢²¼·ÖÏí',

allowblogmod tinyint(1) unsigned NOT NULL default '0' COMMENT '·¢±íÈÕÖ¾ÐèÒªÉóºË', allowdoingmod tinyint(1) unsigned NOT NULL default '0' COMMENT '·¢±í¼Ç¼ÐèÒªÉóºË', allowuploadmod tinyint(1) unsigned NOT NULL default '0' COMMENT 'ÉÏ´«Í¼Æ¬ÐèÒªÉóºË', allowsharemod tinyint(1) unsigned NOT NULL default '0' COMMENT '·¢²¼·ÖÏíÐèÒªÉóºË', allowcss tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí×Ô¶¨ÒåCSS',

allowpoke tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí´òÕкô', allowfriend tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí¼ÓºÃÓÑ', allowclick tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí±í̬',

allowmagic tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓõÀ¾ß', allowstat tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí²é¿´Ç÷ÊÆͳ¼Æ',

allowstatdata tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí²é¿´Í³¼ÆÊý¾Ý±¨±í', videophotoignore tinyint(1) NOT NULL default '0' COMMENT 'ÊÓƵÈÏÖ¤ÏÞÖÆ',

allowviewvideophoto tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí²é¿´ÊÓƵÈÏÖ¤', allowmyop tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓÃÓ¦ÓÃ', magicdiscount tinyint(1) NOT NULL default '0' COMMENT '¹ºÂòµÀ¾ßÕÛ¿Û',

domainlength smallint(6) unsigned NOT NULL default '0' COMMENT '¶þ¼¶ÓòÃû×î¶Ì³¤¶È', seccode tinyint(1) NOT NULL default '1' COMMENT '·¢²¼²Ù×÷ÐèÌîÑéÖ¤Âë',

disablepostctrl tinyint(1) NOT NULL DEFAULT '0' COMMENT '·¢±íÊÇ·ñÊÜ·À¹àË®ÏÞÖÆ',

allowbuildgroup tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÔÊÐí½¨Á¢Èº×飬0Ϊ²»ÔÊÐí',

allowgroupdirectpost tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÔÊÐíÖ±½ÓÔÚȺ×éÖз¢Ìû',

allowgroupposturl tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÔÊÐíÔÚȺ×éÖз¢Õ¾ÍâURL',

edittimelimit smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '±à¼­Ìû×Óʱ¼äÏÞÖÆ', allowpostarticle tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢²¼ÎÄÕÂ',

allowdownlocalimg tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÏÂÔر¾µØͼƬ', allowdownremoteimg tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÏÂÔØÔ¶³ÌͼƬ',

allowpostarticlemod tinyint(1) unsigned NOT NULL default '0' COMMENT '·¢²¼ÎÄÕÂÊÇ·ñÐèÒªÉóºË',

allowspacediyhtml tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí×Ô¶¨ÒåÄ£¿éʹÓÃHTML', allowspacediybbcode tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí×Ô¶¨ÒåÄ£¿éʹÓÃBBCODE',

allowspacediyimgcode tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí×Ô¶¨ÒåÄ£¿éʹÓÃ[img]',

allowcommentpost tinyint(1) NOT NULL default '2' COMMENT 'ÔÊÐíÌû×ÓµãÆÀ 0:½ûÖ¹ 1:Â¥Ö÷ 2:»Ø¸´ 3:All',

allowcommentitem tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±íµãÆÀ¹Ûµã', allowcommentreply tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±í»Ø¸´µãÆÀ', allowreplycredit tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíÉèÖûØÌû½±Àø',

ignorecensor tinyint(1) unsigned NOT NULL default '0' COMMENT 'ÊÇ·ñºöÂÔÒªÉóºËµÄ¹Ø¼ü×Ö',

allowsendallpm tinyint(1) unsigned NOT NULL default '0' COMMENT 'ÊÇ·ñ²»ÊÜ¡°Ö»½ÓÊÕºÃÓѶÌÏûÏ¢¡±ÉèÖõÄÏÞÖÆ',

allowsendpmmaxnum smallint(6) unsigned NOT NULL default '0' COMMENT '24СʱÄÚÔÊÐí·¢¶ÌÏûÏ¢µÄÊýÁ¿',

maximagesize mediumint(8) unsigned NOT NULL default '0' COMMENT 'Ïà²áÖÐÔÊÐí×î´óͼƬ´óС',

allowmediacode tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíʹÓöàýÌå´úÂë',

allowat smallint(6) unsigned NOT NULL default '0' COMMENT 'ÔÊÐí@Óû§ 0£º½ûÖ¹ n:·¢Ìûʱ@µÄÊýÁ¿',

allowsetpublishdate tinyint(1) unsigned NOT NULL default '0' COMMENT 'ÔÊÐí¶¨Ê±·¢²¼Ö÷Ìâ',

allowfollowcollection tinyint(1) unsigned NOT NULL default '0' COMMENT 'ÔÊÐí¹Ø×¢ÌÔר¼­Êý',

allowcommentcollection tinyint(1) unsigned NOT NULL default '0' COMMENT 'ÔÊÐíÆÀÂÛÌÔר¼­',

allowcreatecollection smallint(6) unsigned NOT NULL default '0' COMMENT 'ÔÊÐí´´½¨ÌÔר¼­Êý',

PRIMARY KEY (groupid)

) ENGINE=MyISAM COMMENT='»áÔ±Óû§×éȨÏÞ±í';

DROP TABLE IF EXISTS pre_common_word; CREATE TABLE pre_common_word (

id smallint(6) unsigned NOT NULL auto_increment COMMENT '´Ê»ãid', admin varchar(15) NOT NULL default COMMENT '¹ÜÀíÔ±Ãû', type smallint(6) NOT NULL default '1' COMMENT '¹Ø¼ü´Ê·ÖÀà', find varchar(255) NOT NULL default COMMENT '²»Á¼´ÊÓï',

replacement varchar(255) NOT NULL default COMMENT 'Ìæ»»ÄÚÈÝ', extra varchar(255) NOT NULL default , PRIMARY KEY (id)

) ENGINE=MyISAM COMMENT='´ÊÓï¹ýÂ˱í';

DROP TABLE IF EXISTS pre_common_word_type; CREATE TABLE pre_common_word_type (

id smallint(6) unsigned NOT NULL auto_increment COMMENT '´ÊÓï¹ýÂË·ÖÀàid', typename varchar(15) NOT NULL default COMMENT '·ÖÀàÃû³Æ', PRIMARY KEY (id)

) ENGINE=MyISAM COMMENT='´ÊÓï¹ýÂË·ÖÀà';

DROP TABLE IF EXISTS pre_common_tag; CREATE TABLE pre_common_tag (

tagid smallint(6) unsigned NOT NULL auto_increment COMMENT '±êÇ©id', tagname char(20) NOT NULL default COMMENT '±êÇ©Ãû',

status tinyint(1) NOT NULL default '0' COMMENT 'ÏÔʾ״̬\\n(0:Õý³£ 1:¹Ø±Õ 2:ÍƼö 3:Óû§±êÇ©)',

PRIMARY KEY (tagid), KEY tagname (tagname), KEY status (status, tagid)

) ENGINE=MyISAM COMMENT='±êÇ©±í';

DROP TABLE IF EXISTS pre_common_tagitem; CREATE TABLE pre_common_tagitem (

tagid smallint(6) unsigned NOT NULL default '0' COMMENT '±êÇ©id', itemid mediumint(8) unsigned NOT NULL default '0' COMMENT 'itemid', idtype char(10) NOT NULL default COMMENT 'ÄÚÈÝÀàÐÍ', UNIQUE KEY item (tagid, itemid, idtype), KEY idtype (idtype, itemid)

) ENGINE=MyISAM COMMENT='±êÇ©ÄÚÈݱí';

DROP TABLE IF EXISTS pre_forum_access; CREATE TABLE pre_forum_access (

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '»áÔ±id', fid mediumint(8) unsigned NOT NULL default '0' COMMENT 'ÂÛ̳id', allowview tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐíä¯ÀÀ', allowpost tinyint(1) NOT NULL default '0' COMMENT 'ÔÊÐí·¢±í', allowreply 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 'ÔÊÐíÉÏ´«Í¼Æ¬',

adminuser mediumint(8) unsigned NOT NULL default '0' COMMENT '¹ÜÀíÔ±id', dateline int(10) unsigned NOT NULL default '0' COMMENT 'ʱ¼ä', PRIMARY KEY (uid,fid), KEY listorder (fid,dateline)

) ENGINE=MyISAM COMMENT='·ÃÎÊȨÏÞ±í';

DROP TABLE IF EXISTS pre_forum_activity; CREATE TABLE pre_forum_activity (

tid mediumint(8) unsigned NOT NULL default '0' COMMENT 'Ö÷Ìâid', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '»áÔ±id', aid mediumint(8) unsigned NOT NULL default '0' COMMENT 'Ö÷ÌâͼƬid', cost mediumint(8) unsigned NOT NULL default '0' COMMENT 'ÿÈË»¨Ïú', starttimefrom int(10) unsigned NOT NULL default '0' COMMENT '¿ªÊ¼Ê±¼ä', starttimeto int(10) unsigned NOT NULL default '0' COMMENT '½áÊøʱ¼ä', place varchar(255) NOT NULL default COMMENT 'µØµã', class varchar(255) NOT NULL default COMMENT 'Àà±ð', gender tinyint(1) NOT NULL default '0' COMMENT 'ÐÔ±ð',

number smallint(5) unsigned NOT NULL default '0' COMMENT 'ÈËÊý',

applynumber smallint(5) unsigned NOT NULL default '0' COMMENT 'ÒѲμÓÈËÊý', expiration int(10) unsigned NOT NULL default '0' COMMENT '±¨Ãû½ØÖ¹ÈÕÆÚ',