Difference between revisions of "Database Table: urimap"

From Dreamwidth Notes
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Clustered. Stores data for mapping a named URI permalink - that is: http://somejournal.example.com/this_is_a_named_uri.html (not-yet-implemented), to the respective entry.
+
{{Database Table|name=urimap|table type=global|repo=dw-free|removed=1|removed in=2422fd729e2a}}
 
+
Stores data for mapping a named URI permalink - that is: http://somejournal.example.com/this_is_a_named_uri.html (not-yet-implemented), to the respective entry.
[[Category: Removed Database Tables|urimap]]
+
= Definition =
=Definition=
+
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE urimap (
 
CREATE TABLE urimap (
Line 13: Line 12:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer|removed=1}}
=Relationships=
+
 
+
=Location=
+
[[Clustered database]]
+

Latest revision as of 16:32, 22 July 2010

Note: This table is removed and no longer used. This table was removed in dw-free changeset 2422fd729e2a [1]
This is a global table. Stores data for mapping a named URI permalink - that is: http://somejournal.example.com/this_is_a_named_uri.html (not-yet-implemented), to the respective entry.

Definition

CREATE TABLE urimap (
  journalid   INTEGER UNSIGNED NOT NULL,
  uri         VARCHAR(255) BINARY NOT NULL,
  PRIMARY KEY (journalid, uri),
  nodetype    CHAR(1) NOT NULL,
  nodeid      INTEGER UNSIGNED NOT NULL,
  INDEX       (journalid, nodetype, nodeid)
)