Difference between revisions of "Database Table: talkleft"

From Dreamwidth Notes
Jump to: navigation, search
Line 1: Line 1:
 +
{{#set:name=talkleft|clustered=true}}
 
= Definition =
 
= Definition =
  
Line 15: Line 16:
 
</source>
 
</source>
  
= Relationships =
+
{{Database Table Footer}}
 
+
= Location =
+
 
+
[[Clustered database]]
+
 
+
[[Category: Database Tables|talkleft]]
+

Revision as of 01:46, 2 October 2009

Definition

CREATE TABLE talkleft (
  userid    INT UNSIGNED NOT NULL,
  posttime  INT UNSIGNED NOT NULL,
  INDEX (userid, posttime),
  journalid  INT UNSIGNED NOT NULL,
  nodetype   CHAR(1) NOT NULL,
  nodeid     INT UNSIGNED NOT NULL,
  INDEX (journalid, nodetype, nodeid),
  jtalkid    MEDIUMINT UNSIGNED NOT NULL,
  publicitem   ENUM('1','0') NOT NULL DEFAULT '1'
)

Relationships