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

RESOLVED FIXED

Status

Cloud Services
Operations: Deployment Requests
RESOLVED FIXED
2 years ago
2 years ago

People

(Reporter: jrgm, Assigned: jrgm)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [qa+])

(Assignee)

Description

2 years ago
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

2 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
Last Resolved: 2 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.