Difference between revisions of "Database Table: userpicmap3"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table userpicmap3)
(No difference)

Revision as of 18:19, 1 October 2010

This is a clustered table.

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)
)

Relationships