Correct description of talkleft_xfp table.
Patch by kareila.
diffs (12 lines):
diff -r 8a1f5a11df97 -r e07e5004e51e bin/upgrading/base-data.sql
--- a/bin/upgrading/base-data.sql Wed Oct 21 17:58:27 2009 +0000
+++ b/bin/upgrading/base-data.sql Wed Oct 21 18:00:15 2009 +0000
@@ -923,7 +923,7 @@ REPLACE INTO schematables (des, public_b
REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Global. Used by the move user cluster script. Both before
and after updating a user\'s read-only flag we add the user to this table,
which is just an index onto users who - might - be in read-only.\n\r\nA
maintenance task will periodically clean those and make sure nobody is stranded
in read-only, without resorting to a full tablescan of the [dbtable[user]]
table, by checking if users are still locked, removing those that are not from
this table, querying the job server (if up) for users that are still locked and
unlocking those that can be unlocked.', '0', 'off', NULL, 'readonly_user');
REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Global. ZIP Code table used to validate and auto-complete
user-entered location data. More data can be found in the (redundant) table
[dbtable[zips]], which was imported later.', '0', 'off', NULL, 'zip');
REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Global.', '0', 'off', NULL, 'eventtypelist');
-REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Historic. Global. Stores a user\'s posts on other clusters,
when either 1) that user isn\'t clustered themselves yet, or 2) we\'re doing a
mass conversion (moveucluster.pl) and don\'t want to look it up.\n\r\nA
maintenance task (clean_caches) moves data from here to [dbtable[talkleft]] on
clusters.', '0', 'off', NULL, 'talkleft_xfp');
+REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Global. Stores comments when the database cluster of the
user making the comment is unavailable.\n\r\nA maintenance task (clean_caches)
moves data from here to [dbtable[talkleft]] on clusters.', '0', 'off', NULL,
'talkleft_xfp');
REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Lookup table for states, countries, languages, etc...',
'1', 'replace', NULL, 'codes');
REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Stores data on valid invite codes and who has used them.
The acctinvite table stores the data on why they were made.', '0', 'off', NULL,
'acctcode');
REPLACE INTO schematables (des, public_browsable, redist_mode, redist_where,
tablename) VALUES ('Stores metadata for entries users mark as \"Memories\".
Please see also the clustered [dbtable[memorable2]] table.', '0', 'off', NULL,
'memorable');
_______________________________________________
dw-changelog mailing list
[email protected]
http://lists.dwscoalition.org/mailman/listinfo/dw-changelog
