Difference between revisions of "Database Table: urimap"
From Dreamwidth Notes
(New page: 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: Unu...) |
|||
| Line 2: | Line 2: | ||
[[Category: Unused Database Tables|urimap]] | [[Category: Unused Database Tables|urimap]] | ||
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | 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) | ||
| + | ) | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | |||
| + | =Location= | ||
| + | [[Clustered database]] | ||
Revision as of 23:48, 22 March 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) )
