Database Table: userpicmap3

From Dreamwidth Notes
Revision as of 18:19, 1 October 2010 by Exor674Bot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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