Difference between revisions of "Database Table: embedcontent preview"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
m (Robot: Updating: Format, definition)
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE embedcontent_preview (
 
CREATE TABLE embedcontent_preview (
     userid int(10) unsigned NOT NULL default '0',
+
     userid     int(10) unsigned NOT NULL default '0',
     moduleid int(10) NOT NULL default '0',
+
     moduleid   int(10) NOT NULL default '0',
     content text,
+
     content     text,
 +
    linktext    VARCHAR(255),
 +
    url        VARCHAR(255),
  
 
     PRIMARY KEY  (userid,moduleid)
 
     PRIMARY KEY  (userid,moduleid)
) TYPE=InnoDB
+
) ENGINE=InnoDB
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 04:35, 11 June 2013

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,
    linktext    VARCHAR(255),
    url         VARCHAR(255),
 
    PRIMARY KEY  (userid,moduleid)
) ENGINE=InnoDB

Relationships