syndicated

syndicated — Global. Stores information on syndicated accounts like feed URI, readership, polling, etc.

syndicated

Column name Type Null Default Description
userid int unsigned   0 Userid of syndicated feed account.
synurl varchar(255) YES HTML-cleaned URI of external feed.
checknext datetime   0000-00-00 00:00:00 Date and time of scheduled next check to syndication feed.
lastcheck datetime YES Date and time feed was last checked for updates, for use on syndicated account profile page. (Result of the last check is stored in the laststatus column.)
lastmod int unsigned YES Unix time converted from HTTP time received in Last-Modified HTTP response-header field when querying feed source. Converted back, and used in If-Modified-Since field within a subsequent request-header.
etag varchar(80) YES ETag (entity tag cache validator) response-header field value from server. If available, stored for use alongside an If-None-Match response-header field for subsequent requests. Used with lastmod column value.
laststatus varchar(80) YES Status of last check, for use on syndicated account profile page. The value might be: 'Parse error', 'Not Modified', etc.
lastnew datetime YES Date and time syndicated account was last updated with new entries. (Profile page will display 'Never' if feed account is newly created and not yet updated for example.)
oldest_ourdate datetime YES Stores the oldest synitem date. It is stored in the syndicated table to use later to do a mass cleaning, or as part of migration to a clustered synitem table.
numreaders mediumint YES Stores syndicated feed account readership (number of users (watchers) who list account as a friend), assuming feed isn't stale, so we can get to it quicker for other things. Lets us know which feeds are unwatched - so we poll them less.
Key name Type Column(s)
PRIMARY PRIMARY
checknext INDEX
numreaders INDEX
synurl UNIQUE