discuz!X1.5与用户(UID)有关的字段表(字典)

完成多个论坛的合并时,需要对用户相关的表进行UID升位,增加合并后的偏移量。
于是整理了以下数据字典,方便在程序中使用。

$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'),
);

从X2数据库中整理出来的用户关联字段包含17个:
authorid
buid
buyerid
fromuid
fuid
makeruid
moderatorid
operatorid
opuid
rateeid
raterid
recommenduid
sellerid
targetuid
touid
uid
vuid

《discuz!X1.5与用户(UID)有关的字段表(字典)》有1个想法

发表评论

电子邮件地址不会被公开。