There are currently four different tables on stat1003 corresponding to this schema. Here's a table to record their differences, namely how they correspond to different versions of the app:
| Table name on stat1003 (linking to schema version) |
LEFT(MIN(timestamp),8) |
Android app versions that feed this table
SELECT DISTINCT MID(LEFT(userAgent,INSTR(userAgent," ")-1),INSTR(userAgent,"/")+1) AS app_version FROM ... WHERE userAgent LIKE '%Android%' ORDER BY app_version;
|
| MobileWikiAppToCInteraction_14585319 |
20151113 |
2.1.134-2.1.143 (r, releasesprod, beta, amazon, fdroid), 2.1.241 beta [sic]
|
|
2.1.134-amazon-2015-11-12
2.1.134-beta-2015-11-12
2.1.134-fdroid
2.1.134-r-2015-11-12
2.1.135-beta-2015-12-03
2.1.135-fdroid
2.1.136-amazon-2015-12-09
2.1.136-beta-2015-12-09
2.1.136-fdroid
2.1.136-r-2015-12-09
2.1.136-releasesprod-2015-12-09
2.1.137-beta-2016-01-11
2.1.137-fdroid
2.1.137-r-2016-01-11
2.1.137-releasesprod-2016-01-11
2.1.138-amazon-2016-01-21
2.1.138-beta-2016-01-21
2.1.138-r-2016-01-21
2.1.139-beta-2016-01-22
2.1.139-fdroid
2.1.139-r-2016-01-22
2.1.139-releasesprod-2016-01-22
2.1.140-beta-2016-02-04
2.1.140-fdroid
2.1.141-amazon-2016-02-10
2.1.141-beta-2016-02-10
2.1.141-fdroid
2.1.141-r-2016-02-10
2.1.141-releasesprod-2016-02-10
2.1.142-beta-2016-03-07
2.1.143-beta-2016-03-16
2.1.143-r-2016-03-16
2.1.241-beta-2016-03-03
| (updated 2016-03-24)
|
| MobileWikiAppToCInteraction_11014396 |
20150120 |
2.0 from 2015-03-23 on, and 2.0.101-2.1.133 (r, releasesprod, amazon, fdroid, beta, dev, tmy)
|
|
2.0-alpha-2015-01-20
2.0-beta-2015-01-28
2.0-alpha-2015-02-13
2.0-beta-2015-02-19
2.0-beta-2015-02-27
2.0-alpha-2015-03-05
2.0-beta-2015-03-05
2.0-alpha-2015-03-07
2.0-beta-2015-03-09
2.0-alpha-2015-03-11
2.0-beta-2015-03-23
2.0-r-2015-03-23
2.0-beta-2015-04-03
2.0-beta-2015-04-10
2.0-releasesprod-2015-03-23
2.0-beta-2015-04-23
2.0-r-2015-04-23
2.0-alpha-2015-04-29
2.0-dev-2015-05-06
2.0-amazon-2015-04-23
2.0.101-dev-2015-05-09
2.0.101-dev-2015-05-11
2.0.102-beta-2015-05-14
2.0-releasesprod-2015-04-23
2.0.102-r-2015-05-14
2.0.101-alpha-2015-05-27
2.0.103-beta-2015-06-11
2.0-tmy-2015-04-23
2.0.103-dev-2015-06-23
2.0.102-beta-2015-06-08
2.0.103-dev-2015-06-24
2.0.103-dev-2015-06-25
2.0.104-beta-2015-06-25
2.0.104-dev-2015-06-26
2.0.105-beta-2015-06-30
2.0.105-r-2015-06-30
2.0.105-amazon-2015-06-30
2.0.102-releasesprod-2015-05-14
2.0.106-beta-2015-07-20
2.0.106-beta-2015-07-30
2.0.107-beta-2015-08-03
2.0.108-beta-2015-08-04
2.0.108-r-2015-08-04
2.0.108-amazon-2015-08-04
2.0.108-r-2015-08-18
2.0.109-beta-2015-08-21
2.0.109-fdroid
2.0.104-beta-2015-06-27
2.0.110-beta-2015-08-31
2.0.110-r-2015-08-31
2.0.107-releasesprod-2015-08-03
2.0.110-amazon-2015-08-31
2.0.110-fdroid
2.0.111-beta-2015-09-16
2.0.111-r-2015-09-16
2.0.111-releasesprod-2015-09-16
2.1.131-beta-2015-09-28
2.0.111-amazon-2015-09-16
2.1.131-fdroid
2.1.132-beta-2015-10-23
2.1.133-beta-2015-10-26
2.1.132-fdroid
2.1.133-r-2015-10-26
2.1.133-fdroid
2.1.133-amazon-2015-10-26
2.0.104-beta-2015-06-26
2.0-releasesprod-2015-03-17
|
(updated 2016-01-01)
|
| MobileWikiAppToCInteraction_10375484 |
20141031 |
...
|
|
2.0-dev-2014-10-30
2.0-alpha-2014-11-03
2.0-dev-2014-11-03
2.0-beta-2014-11-03
2.0-r-2014-11-03
2.0-alpha-2014-11-04
2.0-dev-2014-11-04
2.0-releasesprod-2014-11-03
2.0-alpha-2014-11-05
2.0-dev-2014-11-05
2.0-alpha-2014-11-06
2.0-dev-2014-11-06
2.0-alpha-2014-11-07
2.0-beta-2014-11-07
2.0-dev-2014-11-07
2.0-dev-2014-11-08
2.0-alpha-2014-11-09
2.0-dev-2014-11-10
2.0-alpha-2014-11-10
2.0-dev-2014-11-11
2.0-alpha-2014-11-12
2.0-dev-2014-11-12
2.0-alpha-2014-11-13
2.0-beta-2014-11-12
2.0-dev-2014-11-13
2.0-alpha-2014-11-14
2.0-dev-2014-11-15
2.0-alpha-2014-11-15
2.0-beta-2014-11-15
2.0-beta-2014-11-17
2.0-alpha-2014-11-17
2.0-beta-2014-11-18
2.0-alpha-2014-11-18
2.0-alpha-2014-11-19
2.0-dev-2014-11-19
2.0-beta-2014-11-20
2.0-alpha-2014-11-20
2.0-dev-2014-11-20
2.0-beta-2014-11-21
2.0-alpha-2014-11-21
2.0-dcg-2014-11-21
2.0-beta-2014-11-22
2.0-beta-2014-11-24
2.0-alpha-2014-11-24
2.0-alpha-2014-11-25
2.0-beta-2014-11-25
2.0-r-2014-11-26
2.0-beta-2014-11-26
2.0-alpha-2014-11-26
2.0-beta-2014-11-27
2.0-dev-2014-11-22
2.0-beta-2014-12-01
2.0-alpha-2014-12-01
2.0-r-2014-12-01
2.0-beta-2014-12-02
2.0-releasesprod-2014-12-01
2.0-alpha-2014-12-02
2.0-beta-2014-12-03
2.0-alpha-2014-12-03
2.0-beta-2014-12-04
2.0-alpha-2014-12-04
2.0-dev-2014-12-04
2.0-r-2014-12-05
2.0-alpha-2014-12-05
2.0-beta-2014-12-05
2.0-alpha-2014-12-06
2.0-r-2014-12-07
2.0-beta-2014-12-08
2.0-alpha-2014-12-08
2.0-alpha-2014-12-07
2.0-dev-2014-12-08
2.0-alpha-2014-12-09
2.0-beta-2014-12-09
2.0-dev-2014-12-09
2.0-alpha-2014-12-10
2.0-beta-2014-12-10
2.0-beta-2014-12-11
2.0-alpha-2014-12-11
2.0-r-2014-12-11
2.0-alpha-2014-12-12
2.0-alpha-2014-12-14
2.0-dev-2014-12-14
2.0-alpha-2014-12-15
2.0-alpha-2014-12-16
2.0-beta-2014-12-16
2.0-alpha-2014-12-17
2.0-beta-2014-12-17
2.0-alpha-2014-12-18
2.0-alpha-2014-12-19
2.0-beta-2014-12-19
2.0-alpha-2014-12-20
2.0-alpha-2014-12-21
2.0-alpha-2014-12-22
2.0-alpha-2014-12-23
2.0-alpha-2014-12-24
2.0-alpha-2014-12-27
2.0-alpha-2014-12-29
2.0-alpha-2014-12-30
2.0-alpha-2014-12-31
2.0-alpha-2015-01-02
2.0-alpha-2015-01-04
2.0-alpha-2015-01-05
2.0-alpha-2015-01-07
2.0-alpha-2015-01-08
2.0-alpha-2015-01-09
2.0-alpha-2015-01-10
2.0-alpha-2015-01-11
2.0-alpha-2015-01-12
2.0-alpha-2015-01-13
2.0-r-2015-01-13
2.0-beta-2015-01-13
2.0-alpha-2015-01-14
2.0-alpha-2015-01-15
1.0
2.0-r-2015-01-15
2.0-releasesprod-2015-01-15
2.0-r-2015-01-16
2.0-alpha-2015-01-16
2.0-amazon-2015-01-15
2.0-alpha-2015-01-17
2.0-dev-2015-01-16
2.0-alpha-2015-01-19
2.0-r-2015-01-20
2.0-alpha-2015-01-20
2.0-alpha-2015-01-21
2.0-alpha-2015-01-22
2.0-alpha-2015-01-23
2.0-alpha-2015-01-24
2.0-alpha-2015-01-25
2.0-alpha-2015-01-26
2.0-alpha-2015-01-27
2.0-alpha-2015-01-29
2.0-dev-2015-01-20
2.0-alpha-2015-02-05
2.0-tmy-2015-02-10
2.0-alpha-2015-02-10
2.0-releasesprod-2015-01-27
2.0-alpha-2015-02-28
2.0-alpha-2015-04-06
2.0-alpha-2015-04-10
2.0-alpha-2015-04-17
2.0-dev-2015-05-20
|
(updated November 2015)
|
| MobileWikiAppToCInteraction_8461467 |
20140510 |
...
|
|
2.0-alpha-2014-05-09
2.0-alpha-2014-05-10
2.0-alpha-2014-05-14
2.0-alpha-2014-05-19
2.0-alpha-2014-05-20
2.0-alpha-2014-05-22
2.0-alpha-2014-05-25
2.0-alpha-2014-05-30
2.0-alpha-2014-06-03
2.0-beta1
2.0-beta2
2.0-alpha-2014-06-04
2.0-beta3
2.0-alpha-2014-06-05
2.0-beta4
2.0-alpha-2014-06-06
2.0-beta5
2.0-beta6
2.0-alpha-2014-06-09
2.0-beta-2014-06-12
2.0-alpha-2014-06-12
2.0-alpha-2014-06-16
2.0-beta-2014-06-17
2.0-alpha-2014-06-17
2.0-beta-2014-06-18
2.0-alpha-2014-06-18
2.0-beta-2014-06-19
2.0-beta-2014-06-23
2.0-alpha-2014-06-23
2.0-beta-2014-06-24
2.0-beta-2014-06-25
2.0-alpha-2014-06-25
2.0
2.0-alpha-2014-07-02
2.0-alpha-2014-07-10
2.0-alpha-2014-07-11
2.0-beta-2014-07-16
2.0-beta-2014-07-18
1.0
2.0-r-2014-07-23
2.0-cc-2014-07-28
2.0-beta-2014-08-04
dev
2.0-r-2014-08-07
2.0-beta-2014-08-07
2.0-qbp-2014-08-12
2.0-beta-2014-08-13
2.0-r-2014-08-13
2.0-amazon-2014-08-13
2.0-releasesprod-2014-08-13
2.0-qbp-2014-08-13
2.0-beta-2014-08-20
2.0-qcn-2014-09-04
2.0-beta-2014-09-07
2.0-beta-2014-08-26
null
2.0-beta-2014-09-09
2.0-dev-2014-09-10
2.0-dev-2014-09-11
2.0-dev-2014-09-12
2.0-beta-2014-09-12
2.0-dev-2014-09-15
2.0-dev-2014-09-16
2.0-beta-2014-09-16
2.0-dev-2014-09-17
2.0-alpha-2014-09-17
2.0-beta-2014-09-11
2.0-beta-2014-09-17
2.0-beta-2014-09-18
2.0-alpha-2014-09-18
2.0-dev-2014-09-18
2.0-beta-2014-09-19
2.0-beta-2014-09-22
2.0-beta-2014-09-23
2.0-dev-2014-09-23
2.0-dev-2014-09-24
2.0-dev-2014-09-25
2.0-dev-2014-09-26
2.0-dev-2014-09-27
2.0-alpha-2014-09-27
2.0-alpha-2014-09-28
2.0-alpha-2014-09-29
2.0-dev-2014-09-29
2.0-alpha-2014-09-30
2.0-alpha-2014-10-02
2.0-alpha-2014-10-03
2.0-dev-2014-10-06
2.0-alpha-2014-10-06
2.0-alpha-2014-09-12
2.0-alpha-2014-10-07
2.0-beta-2014-10-07
2.0-dev-2014-10-07
2.0-beta-2014-10-08
2.0-r-2014-10-08
2.0-alpha-2014-10-08
2.0-dev-2014-10-08
2.0-alpha-2014-10-09
2.0-dev-2014-10-09
2.0-alpha-2014-10-10
2.0-dev-2014-10-10
2.0-dev-2014-10-11
2.0-alpha-2014-10-11
2.0-dev-2014-10-12
2.0-alpha-2014-10-13
2.0-dev-2014-10-13
2.0-dev-2014-10-14
2.0-alpha-2014-10-14
2.0-r-2014-10-14
2.0-beta-2014-10-14
2.0-dev-2014-10-15
2.0-releasesprod-2014-10-14
2.0-alpha-2014-10-15
2.0-alpha-2014-10-16
2.0-dev-2014-10-16
2.0-amazon-2014-10-14
2.0-alpha-2014-10-17
2.0-dev-2014-10-17
2.0-beta-2014-10-18
2.0-dev-2014-10-18
2.0-alpha-2014-10-18
2.0-alpha-2014-10-20
2.0-dev-2014-10-19
2.0-r-2014-10-20
2.0-beta-2014-10-20
2.0-dev-2014-10-20
2.0-alpha-2014-10-21
2.0-dev-2014-10-21
2.0-alpha-2014-10-22
2.0-r-2014-10-22
2.0-dev-2014-10-22
2.0-alpha-2014-10-23
2.0-dev-2014-10-23
2.0-alpha-2014-10-24
2.0-alpha-2014-10-25
2.0-alpha-2014-10-26
2.0-alpha-2014-10-27
2.0-dev-2014-10-27
2.0-alpha-2014-10-28
2.0-dev-2014-10-28
2.0-qpb-2014-10-28
2.0-alpha-2014-10-29
2.0-dev-2014-10-29
2.0-beta-2014-10-29
2.0-r-2014-10-29
2.0-r-2014-10-30
2.0-dev-2014-10-30
2.0-beta-2014-10-30
2.0-releasesprod-2014-10-30
2.0-alpha-2014-10-31
2.0-alc-2014-10-31
2.0-blu-2014-10-31
2.0-mul-2014-10-31
2.0-dev-2014-10-31
2.0-alpha-2014-10-30
2.0-alpha-2014-11-01
2.0-dev-2014-11-01
2.0-dev-2014-11-02
2.0-dev-2014-11-03
2.0-beta-2014-10-31
2.0-alpha-2014-11-03
2.0-beta-2014-10-15
2.0-r-2014-12-01
H_1018.2
2.0-alpha-2014-06-24
2.0-beta-2015-03-25
2.0-beta-2015-04-12
|
(updated November 2015)
|
(All four tables are still recording data, i.e. contain rows with timestamp as of today.)
Android team, can you check the app version information in the rightmost column above, and help consolidate it by relating it to code changes in the app? E.g. in the last row, we might be able to say "All alpha versions from 2.0-alpha-2014-05-09 until 2.0-alpha-2014-11-03" instead of the query output that is listing all them separately. (Just as an example; for the analysis we are planning it's more important to get the production releases in the two most recent versions of the schema right.)
Regards, Tbayer (WMF) (talk) 21:36, 25 November 2015 (UTC)Reply
- Update: Looked at this with Dmitry on IRC and he confirmed that the latest version of the schema only corresponds to 2.1.134 (and later), and that the next-to-latest version corresponds to production releases as early as 2015-03-23. I have consolidated the table above accordingly. He was also going to send the exact git revisions marking the introduction of each new schema version, but for now this might already be enough - I will leave phab:T119664 open for a bit longer until we know that no more information is needed for the current analysis. Regards, Tbayer (WMF) (talk) 17:50, 2 January 2016 (UTC)Reply
.svg)