706900 - Add productID mapping table for processors

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[[:jberkus] Josh Berkus]

Create table to hold appid-product mappings for processors.

Needs spec from Lars, hence assigning to him initially.

Comment 1

[Laura Thomson :laura]

Going to be called ProductID in the JSON.

Comment 2

[[:jberkus] Josh Berkus]

The column "productid" has been added to reports table on DevDB.

Comment 3

[[:jberkus] Josh Berkus]

However, this is not the mapping table.  We need to know a few things, see wiki.

Comment 4

[Robert Helmer [:rhelmer]]

Josh - do you have all the info you need here now?

Comment 5

[Laura Thomson :laura]

Here's the new ProductID for FennecAndroid:
MOZ_APP_ID={aa3c5121-dab2-40e2-81ca-7ea25febc110}

The others can be found here (as "GUID"):
https://addons.mozilla.org/en-US/firefox/pages/appversions/

Comment 6

[[:jberkus] Josh Berkus]

yaay, productID.

Ok, the mapping table is done, just waiting to stage this in order to mark it resolved.

Comment 7

[[:jberkus] Josh Berkus]

This was deployed with 2.3.5.  Closing now.

Comment 8

[Matt Brandt [:mbrandt]]

What are the verification points for qa or is this a [qa-]?

Comment 9

[[:jberkus] Josh Berkus]

Matt,

Verify that we're seeing new crashes for FennecAndroid.

Comment 10

[[github robot]]

Commits pushed to https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/c5ba7c65027c89c90b70294be3c2730bdf1f4b04
bug 706900 - new required product_productid_map table

https://github.com/mozilla/socorro/commit/a443a06fc07dc4138a5e7e62bc81043587646b5f
Merge pull request #253 from rhelmer/refresh-schema-2.3

bug 706900 - new required product_productid_map table