Difference between revisions of "Database Table: urimap"
From Dreamwidth Notes
| 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. | 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. | ||
| − | [[Category: | + | [[Category: Obsolete Database Tables|urimap]] |
=Definition= | =Definition= | ||
<source lang="sql"> | <source lang="sql"> | ||
Revision as of 18:13, 23 August 2009
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.
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) )
