Difference between revisions of "Database Table: links"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
m (Robot: Updating: Format, definition)
 
Line 8: Line 8:
 
     url varchar(255) default NULL,
 
     url varchar(255) default NULL,
 
     title varchar(255) NOT NULL default '',
 
     title varchar(255) NOT NULL default '',
 +
    hover varchar(255) default NULL,
  
 
     KEY  (journalid)
 
     KEY  (journalid)

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