Difference between revisions of "Database Table: links"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format, needs desc, definition) |
Exor674Bot (Talk | contribs) m (Robot: Updating: Format, definition) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=links|table type=clustered|need desc=1}} | + | {{Database Table|name=links|table type=clustered|need desc=1|repo=dw-free}} |
= Definition = | = Definition = | ||
<source lang="sql"> | <source lang="sql"> | ||
| 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) )
