[livejournal] r14091: DB schemadocs. Adding column description...
DB schemadocs. Adding column descriptions
this time (approx 90 cols across 30 or so tables)

U   trunk/bin/upgrading/base-data.sql

Modified: trunk/bin/upgrading/base-data.sql
===================================================================
--- trunk/bin/upgrading/base-data.sql	2008-07-30 12:30:34 UTC (rev 14090)
+++ trunk/bin/upgrading/base-data.sql	2008-07-30 15:11:56 UTC (rev 14091)
@@ -613,9 +613,14 @@
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('State', 'State.', 'zips');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('aaid', 'Primary key for each authaction.', 'authactions');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('acid', 'Account code ID.  Primary key.', 'acctcode');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('acktime', 'The time the user saw the box, either by clicking next/no/more info.', 'cprod');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('action', 'A textual description of what happened (up to 30 characters).', 'userlog');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('action', 'The action command name to be run when the authaction is confirmed (clicked/etc)', 'authactions');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('actiontarget', 'Optional, but is likely some numeric value.', 'userlog');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('alloc', 'Allocation Factor (decimal portion of state within zipcode).', 'zips');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('allowmask', 'A bitmask to specify who can read the (non-public/non-private) entry. Bit 0 is for all friends (i.e., any defined friend can read it). Bits 1-30 are used for [dbtable[friendgroup2]]/[dbtable[friendgroup]]s. Bit 31 is reserved.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('answer', 'The answer text, in plaintext.', 'faq');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('anum', 'The access number. A random number between 0 and 255 associated with the entry to form the jitemid.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('area', 'The type of usage: \"L\" for log, \"T\" for talk, \"B\" for bio, \"P\" for pic.', 'dudata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('areaid', 'Unique ID within area, or \'0\' if area has no ids (like bio)', 'dudata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('arg1', 'Optional argument to accompany the action.', 'authactions');
@@ -625,35 +630,56 @@
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('bgcolor', 'The background color used in the friends view events.', 'friends');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('bytes', 'Number of bytes item takes up.', 'dudata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('cbid', 'unique id', 'cmdbuffer');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('checknext', 'Date and time of scheduled next check to syndication feed.', 'syndicated');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('city', 'City name', 'zip');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('clickthrutime', 'The time when the user clicked for more information.', 'cprod');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('client', 'Client string, of form Platform-Name/Version.  See login mode of protocol docs.', 'clients');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('clientid', 'Clientid of client from [dbtable[clients]] table.', 'clientusage');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('clientid', 'Primary key.  Auto-generated for each new client name.', 'clients');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('cmd', 'Text of the command name.', 'cmdbuffer');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('colname', 'The name of the specific column of the table being described.', 'schemacols');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('color', 'The #rrggbb color (or one of the constants)', 'themedata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('coltype', 'The color code, used in /cgi-bin/ljviews.pl.', 'themedata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('comment', 'Stores userpic comments. Users can define a 120 character, or 255 byte, comment for each userpic.', 'userpic2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('compdata', 'Gzipped compiled layer data.', 's2compiled2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('compressed', 'Either \"N\" or \"Y\", depending on whether the metadata about the journal entry is compressed. Unimplemented. Always \"N\".', 'log2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('createtime', 'Unixtime.', 'subs');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('curr', 'The current weighting value for this dbid+role.', 'dbweights');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('datatype', 'Either \"char\" for text data, \"num\" for an integer, or \"bool\" for a 1/0 value.', 'userproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('datatype', 'Type of property, e.g. bool(ean).', 'talkproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('dateadd', 'Date and time syndicated account was updated with the entry item.', 'synitem');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('datecreate', 'Date the auth code was created.', 'authactions');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('dateins', 'The date the search was made.', 'dirsearchres2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('dateview', 'The time of the viewing.', 'faquses');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('day', 'The day of the eventtime. Duplicated for an index.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('dbid', 'The dbid from [dbtable[dbinfo]].', 'dbweights');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('dbid', 'Unique database ID.  Recommended to use the mysql server-id value.', 'dbinfo');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('des', 'A description of the individual column within the table, for use in the schema browser, and in the LJ manual.', 'schemacols');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('des', 'A description of the table, for use in the schema browser, and in the LJ manual.', 'schematables');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('des', 'Description of a comment property.', 'talkproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('des', 'Description of rate-limited thing. Example: Logged when wrong username/password is used.', 'ratelist');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('des', 'Description of the meta-data, for use by developers (humans?)', 'userproplist');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('digest', 'The md5 digest of the event.  Concatenate everything important and run it through perl\'s md5_hex (or MySQL\'s md5)', 'duplock');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('domain', 'domain name, without any leading http:// or www.  Example:  foo.com', 'domains');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('dupid', 'The unique ID this action generated the first time.', 'duplock');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('etag', '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.', 'syndicated');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('event', 'Journal entry text.', 'logtext2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('eventtime', 'The time of the entry, supplied by the user / according to the user\'s system clock.', 'log2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('expiretime', 'Unixtime. Can be 0, to mean \"never\".', 'subs');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('exptype', 'Session expiration type, the length a specific session should be defined for. \'short\' is 36 hours, \'long\' is 60 days,  \'once\' defaults to same length as \'short\'; just doesn\'t renew. ', 'sessions');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('faqcat', 'The name of the main category the FAQ item belongs to. Is the index to [dbtable[faqcat]]', 'faq');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('faqid', 'The faqid of the [dbtable[faq]] item which was viewed.', 'faquses');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('faqid', 'The unique id number of the FAQ.', 'faq');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('fdsn', 'The DBI connection DSN, username, then password, delimited by pipe characters.', 'dbinfo');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('fgcolor', 'The foreground color used in the friends view events.', 'friends');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('firstshowtime', 'The time when it was first highlighted to them (not at the show everything page).', 'cprod');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('fmt', 'Format of the uploaded image file. One of \'G\', \'J\', or \'P\', for GIF, JPEG, or PNG formats respectively.', 'userpic2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('friendid', 'The [dbtable[user]].userid of the friend to watch/trust.', 'friends');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('groupmask', 'A bitmask of 1 (1 << 0) OR\'ed with (1 << [dbtable[friendgroup]].groupnum) for each friendgroup this friend belongs to.', 'friends');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('groupname', 'Name given to the friend group.', 'friendgroup');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('groupnum', 'The group number. Can be 1-30.', 'friendgroup');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('height', 'Height of image in pixels.', 'userpic2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('idtype', 'The external identity type. One of \"O\" - OpenID, \"L\" - LID (NetMesh), \"T\" - TypeKey, ?  - etc.', 'identitymap');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('incname', 'The filename of the include file.', 'includetext');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('inctext', 'The text contents of the include file.', 'includetext');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('instime', 'The time the action first completed.', 'duplock');
@@ -661,64 +687,129 @@
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('intcount', 'The number of users listing the interest.', 'interests');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('interest', 'The text of the interest.', 'interests');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('intid', 'Unique id assigned to the interest.', 'interests');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('is_dirty', 'One of either 1 (indexed), or NULL (not in index) - means we need to update the target\'s etypeid.', 'subs');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('is_public', 'Determines if the group can be seen by anyone, or just the owner.', 'friendgroup');
-REPLACE INTO schemacols (colname, des, tablename) VALUES ('journalid', 'Journal id the command affects. This is so that all of a user\'s queued actions can be run before that user is potentially movedbetween clusters.', 'cmdbuffer');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('item', 'base64digest of rss $item', 'synitem');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('jitemid', 'The unique id number given to the entry.', 'log2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('jitemid', 'Unique id number given to the entry.', 'logsec2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('jitemid', 'Unique id of entry.', 'logprop2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('journalid', 'Journal id the command affects. This is so that all of a user\'s queued actions can be run before that user is potentially moved between clusters.', 'cmdbuffer');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('journalid', 'The journal in which the event took place.', 'subs');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('journalid', 'The userid of the [dbtable[user]] (such as a journal or community) in which the comment was posted.', 'talk2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('journalid', 'The userid of the [dbtable[user]] (such as a journal or community) in which the entry is being posted.', 'log2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('journalid', 'The userid of the [dbtable[user]] in which the comment is being posted.', 'talkprop2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('jtalkid', 'Each comment\'s unique id.', 'talk2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('jtalkid', 'Unique id of a comment.', 'talkprop2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastcheck', '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.)', 'syndicated');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastitemid', 'Itemid of their last post (see [dbtable[log2]])', 'userusage');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastlogin', 'The most recent time this user used this client.', 'clientusage');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastmod', '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.', 'syndicated');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastmodtime', 'The date the FAQ item was last modified.', 'faq');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastmoduserid', 'The userid of the [dbtable[user]] who last modified the FAQ item.', 'faq');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('lastnew', '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.)', 'syndicated');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('laststatus', 'Status of last check, for use on syndicated account profile page. The value might be: \'Parse error\', \'Not Modified\', etc.', 'syndicated');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('lat', 'Latitude (North is assumed, no plus sign).', 'zips');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('level', 'Either \"all\" for user to get notifications and then a copy of each comment/solution posted, or \"new\" for user to get notifications when a new Support request in that category is posted.', 'supportnotify');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('logtime', 'The time of the entry, when the entry was posted (and when LJ logged it to the database - here), according to the server\'s clock.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('lon', 'Longitude (West is assumed, no minus sign).', 'zips');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('masterid', 'The dbid which this server replicates from, or 0 for the master server.  Note: only one server should have a master of 0!', 'dbinfo');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('membership', 'Can people join without being invited?', 'community');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('modtime', 'API gets and sets this when loading/saving style layers and takes it into account when appending modtime (Last-Modified header field, so browsers will cache properly) to stylesheet_url.', 's2styles');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('modtime', 'Unix time when row was created (for the new cookie).', 'uniqmap');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('month', 'The month of the eventtime. Duplicated for an index.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('name', 'A unique name of the server.', 'dbinfo');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('name', 'Name of property, matching [a-z0-9_]+.  Intended for use by code and clients.', 'userproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('name', 'Name of the rate-limited thing, for referring to in code. Example: failed_login', 'ratelist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('name', 'System name of a comment property.', 'talkproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('nodeid', 'The thread nodeid for the given nodetype to which this comment applies (probably the jitemid from the [dbtable[log2]] row).', 'talk2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('nodetype', 'This field defines what type of thing in comment is in reply to. The value can be \"L\" = log item (journal entry), \"T\" = todo item.', 'talk2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('norm', 'The normal weighting value for this dbid+role.', 'dbweights');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('nothankstime', 'Also a boolean: time/if user does not want to see it again.', 'cprod');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('ntypeid', 'The notification type from the [dbtable[notifytypelist]] table.', 'subs');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('numreaders', '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.', 'syndicated');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('oldest_ourdate', 'Stores the oldest [dbtable[synitem]] date. It is stored in the [dbtable[syndicated]] table to use later to do a mass cleaning, or as part of migration to a clustered [dbtable[synitem]] table.', 'syndicated');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('oldvalue', 'The old value of the item.', 'infohistory');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('other', 'Optional note space.', 'infohistory');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('parentkwid', '(Can be null.)', 'usertags');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('parenttalkid', 'talkid of parent comment that this comment is in reply to within a comment thread. 0 if it is a top-level comment.', 'talk2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('pop1990', 'Population in 1990. (Table uses 1990 Census Bureau \'Gazetteer\' data).', 'zips');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('posterid', 'The [dbtable[user]] userid of the person that posted the comment.', 'talk2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('posterid', 'The [dbtable[user]] userid of the person that posted the entry.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('postlevel', 'Who can post?  Members only, or a select group.  \"screened\" is not yet used.', 'community');
-REPLACE INTO schemacols (colname, des, tablename) VALUES ('prettyname', 'Mixed case pretty name with spaces and punctuation.  Indeded for use by humans.', 'userproplist');
-REPLACE INTO schemacols (colname, des, tablename) VALUES ('public_browsable', 'If set to 1, users can view the data in this table from the web.  (lookup tables only)', 'schematables');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('prettyname', 'Mixed case pretty name with spaces and punctuation.  Intended for use by humans.', 'userproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('prettyname', 'Property name formatted to be human-readable.', 'talkproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('prop', 'A property name, such as \'useragent\'.', 'supportprop');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('public_browsable', 'If set to 1, users with the schemadoc priv can view the data in this table from the web. (lookup tables only)', 'schematables');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('public_help', 'Controls if you can use internal comments/actions as Reply Types.', 'supportcat');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('qdigest', 'An MD5sum of the SQL search query.', 'dirsearchres2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('question', 'The question text, in plaintext.', 'faq');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('rcptid', 'Userid of recipient, or 0 if code is unused.', 'acctcode');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('realm', 'The area of the site the lock is being provided for.', 'duplock');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('recentshowtime', 'A recent showing time. Perhaps not _the_ most recent, though.', 'cprod');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('redist_mode', 'Determines if data from this table is made available in the LJ source distribution.  And if so, is it to be updated with upgrades (REPLACE INTO) or just inserted once.', 'schematables');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('reid', 'Realm ID.  If you don\'t need it (most don\'t), use 0.  Example: for comment realm, reid is the itemid being replied to.', 'duplock');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('replycount', 'The number of people that have replied to this entry.', 'log2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('rlid', 'Corresponds to a rate-limitable action\'s rlid number in [dbtable[ratelist]].', 'ratelog');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('role', 'The database role type:  master, slave, clusterN, clusterNslave, etc...  See other documentation.', 'dbweights');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('rootfdsn', 'The fdsn to connect as root, to do administrative stuff.', 'dbinfo');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('scope', 'Either \"general\" for talkprops in the generic LiveJournal code, or \"local\" if the talkprop is site-specific.', 'talkproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('scope', 'Either \"general\" for userprops in the generic LiveJournal code, or \"local\" if the userprop is site-specific.', 'userproplist');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('security', 'The security level of the entry. \"public\" is viewable to all, \"private\" is for only the poster, and \"usemask\" does a bitwise calculation of the allowmask and the groupmask of the friend viewing it.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('showbydefault', 'Unused.', 'friends');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('sortorder', 'The sorting number the questions are ordered by. Used while SELECT\'ing them.', 'faq');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('sortorder', 'The sorting order.', 'friendgroup');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('spid', 'Unique ID of Support request. Used in URL.', 'supportprop');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('state', 'Comment state identifier: (A)ctive, (D)eleted, (S)creened, (F)rozen, etc.', 'talk2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('state', 'State code (see [dbtable[codes]] for how to turn this into a full state name)', 'zip');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('subid', 'The ESN subscription ID (domain type \'E\') allocated by the LJ::alloc_user_counter function.', 'subs');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('subject', 'Journal entry subject.', 'logtext2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('summary', 'The summary text, in plaintext, for the user to browse at-a-glance.', 'faq');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('synurl', 'HTML-cleaned URI of external feed.', 'syndicated');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('tablename', 'The name of the table being described.', 'schemacols');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('tablename', 'The name of the table being described.', 'schematables');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('themeid', 'Unique ID, references [dbtable[themelist]] table.', 'themedata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('timechange', 'The time of the change.', 'infohistory');
-REPLACE INTO schemacols (colname, des, tablename) VALUES ('timecheck', 'unused.', 'userusage');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('timecheck', 'Usage information sufficient to tell us whether the accounts been used in the last year or month, even just for viewing. (Important so that if site ever does start to close old accounts, will know they\'re not closing active only-used-for-viewing accounts)', 'userusage');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('timecreate', 'When the user created their journal.', 'userusage');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('timeupdate', 'When the user last updated their journal.', 'userusage');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('tpropid', 'Corresponds to unique tpropid in [dbtable[talkproplist]] of an individual comment property. Example: 10 (which might map to subjecticon in [dbtable[talkproplist]].', 'talkprop2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('tpropid', 'Unique id of a comment property.', 'talkproplist');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('track', 'If the police or a court has contact us to track a user, we turn this on and activities are logged to the [dbtable[tracking]] table.', 'user');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('ubefore', 'Units before (unit = 10 seconds).', 'weekuserusage');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('uniq', 'Value of the unique cookie.', 'uniqmap');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('updatetime', 'The date it was last updated.', 'includetext');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('upropid', 'Unique id for this meta-data property.', 'userproplist');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Community\'s userid from the [dbtable[user]] table.', 'community');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The owner of the subscription.', 'subs');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid doing the action, or 0 if user is unknown (as in support realm)', 'duplock');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid of the [dbtable[user]] making the change.', 'infohistory');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid of the [dbtable[user]] who added the friend.', 'friends');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid of the [dbtable[user]] who this friends group belongs to.', 'friendgroup');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid of the remote [dbtable[user]] viewing the FAQ item.', 'faquses');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid of the subscribing [dbtable[user]].', 'supportnotify');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'The userid the disk usage item belongs to.', 'dudata');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of [dbtable[user]] using client.', 'clientusage');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of [dbtable[user]] we\'re verifying.', 'authactions');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of [dbtable[user]] whose journal should be loaded.', 'domains');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of [dbtable[user]].  One row in this table per user.', 'userusage');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of syndicated feed account.', 'syndicated');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of syndicated feed account.', 'synitem');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid of user the unique cookie belongs to.', 'uniqmap');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('userid', 'Userid that can give this code.', 'acctcode');
-REPLACE INTO schemacols (colname, des, tablename) VALUES ('userids', 'List of matched userids for the query, comma separated.', 'dirsearchres2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('userids', 'Either \"[Searching]\" if a query is still running, or a comma-separated list of userids matched for the query if it is finished.', 'dirsearchres2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('value', 'The property value such as the requestor\'s useragent string, a unique cookie value to display on Support requests for authorized users, etc.', 'supportprop');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('value', 'Value for tpropid (generally set by comment poster). Property can be a boolean (e.g., enabling don\'t auto-format), partial filename of specific selected subject icon, etc.', 'talkprop2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('verifytime', 'The unixtime we last checked this [dbtable[has_subs]] caching row is still accurate and people do in fact still subscribe to this. This allows for maintenance tasks to background prune this table and fix up verifytimes.', 'has_subs');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('what', 'Criterion being used to ban on: ip, emailnopay (site-specific example and means don\'t allow payments from that e-mail), email, etc.', 'sysban');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('what', 'Short name of the item being changed.', 'infohistory');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('width', 'Horizontal width of image in pixels.', 'userpic2');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('wknum', 'Number of weeks past Unix epoch time', 'weekuserusage');
+REPLACE INTO schemacols (colname, des, tablename) VALUES ('year', 'The year of the eventtime. Duplicated for an index.', 'log2');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('zip', 'ZIP Code', 'zip');
 REPLACE INTO schemacols (colname, des, tablename) VALUES ('zip', 'ZIP Code.', 'zips');
 REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where, tablename) VALUES ('', '0', 'off', NULL, 'moods');
+REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where, tablename) VALUES ('', '0', 'off', NULL, 's2styles');
+REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where, tablename) VALUES ('', '0', 'off', NULL, 'synitem');
 REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where, tablename) VALUES ('', '0', 'off', NULL, 'user');
 REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where, tablename) VALUES ('Clustered, not indexed.', '0', 'off', NULL, 'userproplite2');
 REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where, tablename) VALUES ('Clustered. ESN event queue notification method.', '0', 'off', NULL, 'notifyqueue');