1184713 - fxa - database changes needed for fxa-auth train-41

Status: RESOLVED FIXED

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

Description

[John Morrison [:jrgm]]

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';
------------------------

Comment 1

[John Morrison [:jrgm]]

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]>