834802 - Add column to raw_adu so we can track when it is received

Status: VERIFIED FIXED

(Socorro :: Database, task)

Description

[Selena Deckelmann :selenamarie :selena]

Add column with 'default NOW() NOT NULL' so we can keep track of when we receive ADU (aka ADI).

Comment 1

[[github robot]]

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

https://github.com/mozilla/socorro/commit/cfa6801e55045b9509ee670e3fc42d7f7b274281
bug 834802 Add column to raw_adu to track time received

https://github.com/mozilla/socorro/commit/2b3f32e8a3f22ae7085f695025846363efacb573
Merge pull request #1091 from selenamarie/bug834802-track-adi-receipt

bug 834802 Add column to raw_adu to track time received

Comment 3

[Matt Brandt [:mbrandt]]

Selena could you do me a favor and post in a comment output from postgres showing a column with the correct attributes was created on Stage?

Comment 4

[Selena Deckelmann :selenamarie :selena]

Confirmed that this is working!

-[ RECORD 5 ]-------+------------------------------
adu_count           | 1
date                | 2013-02-26
product_name        | WebappRuntime
product_os_platform | Windows
product_os_version  | 
product_version     | 22.0a1
build               | 20130226031002
build_channel       | nightly
product_guid        | [e-mail]
inserted_at         | 2013-02-27 05:06:40.706344+00


Thanks for checking in, Matt.

Comment 5

[Matt Brandt [:mbrandt]]

(In reply to Selena Deckelmann :selenamarie :selena from comment #4)
> Confirmed that this is working!

<3 many thanks! QA verified per comment 4