1154070 - update MySQL schema for profile server on production

Status: RESOLVED FIXED

(Cloud Services :: Operations: Deployment Requests - DEPRECATED, task)

Description

[Zachary Carter [:zaach]]

We'll need to update the profile server MySQL schema for train 35. These schema files should be run:

https://github.com/mozilla/fxa-profile-server/blob/0.35.0/lib/db/mysql/patches/patch-000-001.sql
https://github.com/mozilla/fxa-profile-server/blob/0.35.0/lib/db/mysql/patches/patch-001-002.sql
https://github.com/mozilla/fxa-profile-server/blob/0.35.0/lib/db/mysql/patches/patch-002-003.sql

Comment 1

[John Morrison [:jrgm]]

I actually had done this last Friday in stage. I don't generally like re-purposing bugs, but I'll just update this to make it the production update.

:ckolos, let me know if you need a more detailed plan for this change (I should probably do one).

Comment 2

[Chris Kolosiwsky [:ckolos] (ckolos has left the building)]

completed in prod with no incident/warnings.

MySQL [fxa_profile]> select value from dbMetadata where name = 'schema-patch-level';
+-------+
| value |
+-------+
| 3     |
+-------+
1 row in set (0.00 sec)