Difference between revisions of "Database Table: urimap"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format, type, needs desc, rm. invalid footer key)
Line 1: Line 1:
{{Database Table|name=pollresult|table type=global|removed=1}}
+
{{Database Table|name=urimap|table type=global|removed=1}}
 
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.
 
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 =
 
= Definition =

Revision as of 04:43, 30 January 2010

Note: This table is removed and no longer used.
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)
)