From 6d04740a6482b1bdb750efc99cd603cdd33c065a Mon Sep 17 00:00:00 2001
From: Brian Wolff <bawolff+wn@gmail.com>
Date: Wed, 23 Nov 2016 17:26:22 +0000
Subject: [PATCH] Remove language, variant, skin and timecorrection prefs from
 labsdb

These preferences are kept secret by MediaWiki, and thus should not
be exposed by the labsdb public databases. In particular,
timecorrection is strongly correlated to user location, and thus
it is important that we keep it private.

Bug: T150679
---
 modules/role/templates/labsdb/maintain-views.yaml | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/modules/role/templates/labsdb/maintain-views.yaml b/modules/role/templates/labsdb/maintain-views.yaml
index 303c780..1434b37 100644
--- a/modules/role/templates/labsdb/maintain-views.yaml
+++ b/modules/role/templates/labsdb/maintain-views.yaml
@@ -346,8 +346,7 @@ customviews:
     source: user_properties
     view: select up_user, up_property, up_value
     where: >
-      up_property in ( 'disablemail', 'fancysig', 'gender', 'language',
-      'nickname', 'skin', 'timecorrection', 'variant' )
+      up_property in ( 'disablemail', 'fancysig', 'gender', 'nickname' )
   user_properties_anon:
     limit: 2
     source: ["user_properties", "user", "meta_p.properties_anon_whitelist" ]
-- 
1.9.5 (Apple Git-50.3)

