Difference between revisions of "Database Table: cmdbuffer"

From Dreamwidth Notes
Jump to: navigation, search
Line 20: Line 20:
 
[[Clustered database]]
 
[[Clustered database]]
  
[[Category: Database Table|scmdbuffer]]
+
[[Category: Database Tables|cmdbuffer]]

Revision as of 21:57, 30 March 2009

Definition

CREATE TABLE cmdbuffer (
  cbid INT UNSIGNED NOT NULL AUTO_INCREMENT,
  journalid INT UNSIGNED NOT NULL,
  cmd VARCHAR(30) NOT NULL DEFAULT '',
  instime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  args TEXT NOT NULL,
  PRIMARY KEY  (cbid),
  KEY (cmd),
  KEY (journalid)
)

Relationships

Location

Clustered database