Database Table: userpicmap3

This is a clustered table. Stores userpic keyword mappings

• NULL kwid with non-NULL picid is a pic#xxxx keyword
• NULL picid with non-NULL kwid is a unassigned keyword
• NULL picid and kwid is a redirect.

Definition

CREATE TABLE userpicmap3 (
    userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
    mapid INT(10) UNSIGNED NOT NULL,
    kwid INT(10) UNSIGNED,
    picid INT(10) UNSIGNED,
    redirect_mapid INT(10) UNSIGNED,
 
    PRIMARY KEY (userid, mapid),
    UNIQUE KEY  (userid, kwid),
    INDEX redirect (userid, redirect_mapid)
)