Difference between revisions of "Database Table: links"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use database table header template.)
m (Robot: Updating: Format, definition)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Database Table|name=links|table type=global}}
+
{{Database Table|name=links|table type=clustered|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 +
<source lang="sql">
 +
CREATE TABLE links (
 +
    journalid int(10) unsigned NOT NULL default '0',
 +
    ordernum tinyint(4) unsigned NOT NULL default '0',
 +
    parentnum tinyint(4) unsigned NOT NULL default '0',
 +
    url varchar(255) default NULL,
 +
    title varchar(255) NOT NULL default '',
 +
    hover varchar(255) default NULL,
  
<source lang="sql">
+
    KEY  (journalid)
CREATE TABLE knob (
+
  knobname    VARCHAR(255) NOT NULL PRIMARY KEY,
+
  val        TINYINT UNSIGNED
+
 
)
 
)
 
</source>
 
</source>
 
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 23:07, 28 November 2012

This is a clustered table.

Definition

CREATE TABLE links (
    journalid INT(10) UNSIGNED NOT NULL DEFAULT '0',
    ordernum tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
    parentnum tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
    url VARCHAR(255) DEFAULT NULL,
    title VARCHAR(255) NOT NULL DEFAULT '',
    hover VARCHAR(255) DEFAULT NULL,
 
    KEY  (journalid)
)

Relationships