Closed
Bug 1184713
Opened 9 years ago
Closed 9 years ago
fxa - database changes needed for fxa-auth train-41
Categories
(Cloud Services :: Operations: Deployment Requests - DEPRECATED, task)
Cloud Services
Operations: Deployment Requests - DEPRECATED
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: jrgm, Assigned: jrgm)
Details
(Whiteboard: [qa+])
This is need for train-41 fxa-auth-db-mysql -------------------- DELIMITER $$ CREATE PROCEDURE `passwordChangeToken_2` ( IN `inTokenId` BINARY(32) ) BEGIN SELECT t.uid, t.tokenData, t.createdAt, a.email, a.verifierSetAt FROM passwordChangeTokens t, accounts a WHERE t.tokenId = inTokenId AND t.uid = a.uid ; END; $$ DELIMITER ; UPDATE dbMetadata SET value = '13' WHERE name = 'schema-patch-level'; ------------------------
Assignee | ||
Comment 1•9 years ago
|
||
Done. MySQL [fxa]> source /home/jrgm/train-41-auth.sql Query OK, 0 rows affected (0.03 sec) Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 MySQL [fxa]> select db,name from mysql.proc where name = 'passwordChangeToken_2'; +-----+-----------------------+ | db | name | +-----+-----------------------+ | fxa | passwordChangeToken_2 | +-----+-----------------------+ 1 row in set (0.00 sec) MySQL [fxa]> select * from fxa.dbMetadata where name like 'schema%'; +--------------------+-------+ | name | value | +--------------------+-------+ | schema-patch-level | 13 | +--------------------+-------+ 1 row in set (0.00 sec) MySQL [fxa]>
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•