discuz!X1.5与用户(UID)有关的字段表(字典)
完成多个论坛的合并时,需要对用户相关的表进行UID升位,增加合并后的偏移量。
于是整理了以下数据字典,方便在程序中使用。
[php]
$tables = array(
‘ucenter_members’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘common_block’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘common_invite’ => array(‘id’ => ‘fuid’, ‘name’ => ‘fusername’),
‘common_member’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘common_member_security’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘common_mytask’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘common_report’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘forum_thread’ => array(‘id’ => ‘authorid’, ‘name’ => ‘author’),
‘forum_post’ => array(‘id’ => ‘authorid’, ‘name’ => ‘author’),
‘forum_activityapply’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘forum_groupuser’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘forum_pollvoter’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘forum_postcomment’ => array(‘id’ => ‘authorid’, ‘name’ => ‘author’),
‘forum_ratelog’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_album’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_blog’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_clickuser’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_docomment’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_doing’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_feed’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_feed_app’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_friend’ => array(‘id’ => ‘fuid’, ‘name’ => ‘fusername’),
‘home_friend_request’ => array(‘id’ => ‘fuid’, ‘name’ => ‘fusername’),
‘home_notification’ => array(‘id’ => ‘authorid’, ‘name’ => ‘author’),
‘home_pic’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_poke’ => array(‘id’ => ‘fromuid’, ‘name’ => ‘fromusername’),
‘home_share’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_show’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_specialuser’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘home_visitor’ => array(‘id’ => ‘vuid’, ‘name’ => ‘vusername’),
‘portal_article_title’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘portal_comment’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘portal_topic’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
‘portal_topic_pic’ => array(‘id’ => ‘uid’, ‘name’ => ‘username’),
);
[/php]
从X2数据库中整理出来的用户关联字段包含17个:
authorid
buid
buyerid
fromuid
fuid
makeruid
moderatorid
operatorid
opuid
rateeid
raterid
recommenduid
sellerid
targetuid
touid
uid
vuid
路过