Difference between revisions of "Database Table: urimap"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format, type, needs desc, rm. invalid footer key) |
|||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=pollresult|table type= | + | {{Database Table|name=pollresult|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 = |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE urimap ( | CREATE TABLE urimap ( | ||
| Line 12: | Line 12: | ||
) | ) | ||
</source> | </source> | ||
| − | {{Database Table Footer| | + | {{Database Table Footer|removed=1}} |
Revision as of 04:35, 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) )
