Difference between revisions of "Database Table: duplock"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use semantic mediawiki form.)
m (Robot: Converting database table to use semantic mediawiki form.)
Line 1: Line 1:
{{#set:name=duplock|clustered=false}}
+
{{#set:name=duplock|table type=global}}
 
= Definition =
 
= Definition =
  

Revision as of 18:44, 2 October 2009

Definition

CREATE TABLE duplock (
  realm enum('support','log','comment') NOT NULL DEFAULT 'support',
  reid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  digest CHAR(32) NOT NULL DEFAULT '',
  dupid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  instime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY (realm,reid,userid)
)

Relationships