Database Table: userpicmap3
From Dreamwidth Notes
Revision as of 18:19, 1 October 2010 by Exor674Bot (Talk | contribs)
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) )