Database Table: synitem

From Dreamwidth Notes
Revision as of 18:08, 22 March 2009 by SlowSculpture (Talk | contribs)

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

Definition

CREATE TABLE synitem
(
   userid  INT UNSIGNED NOT NULL,
   item   CHAR(22),    # base64digest OF rss $item
   dateadd DATETIME NOT NULL,
   INDEX (userid, item(3)),
   INDEX (userid, dateadd)
)

Relationships

Location

Global database