Difference between revisions of "Database Table: links"
From Dreamwidth Notes
(Created page with 'knob =Definition= <source lang="sql"> CREATE TABLE knob ( knobname VARCHAR(255) NOT NULL PRIMARY KEY, val TINYINT UNSIGNED ) </source>...') |
Exor674Bot (Talk | contribs) m (Robot: Updating: Format, definition) |
||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Database Table|name=links|table type=clustered|need desc=1|repo=dw-free}} | |
| − | =Definition= | + | = Definition = |
<source lang="sql"> | <source lang="sql"> | ||
| − | CREATE TABLE | + | 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) | ||
) | ) | ||
</source> | </source> | ||
| − | + | {{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) )
