Database Table: urimap

From Dreamwidth Notes
Revision as of 16:32, 22 July 2010 by Exor674 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)
)