Difference between revisions of "Database Table: embedcontent preview"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
m (Robot: Updating: Format, definition)
Line 8: Line 8:
  
 
     PRIMARY KEY  (userid,moduleid)
 
     PRIMARY KEY  (userid,moduleid)
) TYPE=InnoDB
+
) ENGINE=InnoDB
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Revision as of 23:07, 28 November 2012

This is a clustered table.

Definition

CREATE TABLE embedcontent_preview (
    userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
    moduleid INT(10) NOT NULL DEFAULT '0',
    content text,
 
    PRIMARY KEY  (userid,moduleid)
) ENGINE=InnoDB

Relationships