FxA schema

gistfile1.txt

mysql> show tables;
+----------------------+
| Tables_in_fxa        |
+----------------------+
| accountResetTokens   |
| accounts             |
| dbMetadata           |
| keyFetchTokens       |
| passwordChangeTokens |
| passwordForgotTokens |
| sessionTokens        |
+----------------------+
7 rows in set (0.00 sec)

mysql> desc accountResetTokens;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| tokenId   | binary(32)          | NO   | PRI | NULL    |       |
| tokenData | binary(32)          | NO   |     | NULL    |       |
| uid       | binary(16)          | NO   | UNI | NULL    |       |
| createdAt | bigint(20) unsigned | NO   | MUL | NULL    |       |
+-----------+---------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> desc accounts;
+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| uid             | binary(16)          | NO   | PRI | NULL    |       |
| normalizedEmail | varchar(255)        | NO   | UNI | NULL    |       |
| email           | varchar(255)        | NO   |     | NULL    |       |
| emailCode       | binary(16)          | NO   |     | NULL    |       |
| emailVerified   | tinyint(1)          | NO   |     | 0       |       |
| kA              | binary(32)          | NO   |     | NULL    |       |
| wrapWrapKb      | binary(32)          | NO   |     | NULL    |       |
| authSalt        | binary(32)          | NO   |     | NULL    |       |
| verifyHash      | binary(32)          | NO   |     | NULL    |       |
| verifierVersion | tinyint(3) unsigned | NO   |     | NULL    |       |
| verifierSetAt   | bigint(20) unsigned | NO   |     | NULL    |       |
| createdAt       | bigint(20) unsigned | NO   |     | NULL    |       |
| locale          | varchar(255)        | YES  |     | NULL    |       |
+-----------------+---------------------+------+-----+---------+-------+
13 rows in set (0.00 sec)

mysql> desc dbMetadata;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name  | varchar(255) | NO   | PRI | NULL    |       |
| value | varchar(255) | NO   |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> desc keyFetchTokens;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| tokenId   | binary(32)          | NO   | PRI | NULL    |       |
| authKey   | binary(32)          | NO   |     | NULL    |       |
| uid       | binary(16)          | NO   | MUL | NULL    |       |
| keyBundle | binary(96)          | NO   |     | NULL    |       |
| createdAt | bigint(20) unsigned | NO   |     | NULL    |       |
+-----------+---------------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> desc passwordChangeTokens;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| tokenId   | binary(32)          | NO   | PRI | NULL    |       |
| tokenData | binary(32)          | NO   |     | NULL    |       |
| uid       | binary(16)          | NO   | UNI | NULL    |       |
| createdAt | bigint(20) unsigned | NO   | MUL | NULL    |       |
+-----------+---------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> desc passwordForgotTokens;
+-----------+----------------------+------+-----+---------+-------+
| Field     | Type                 | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+-------+
| tokenId   | binary(32)           | NO   | PRI | NULL    |       |
| tokenData | binary(32)           | NO   |     | NULL    |       |
| uid       | binary(16)           | NO   | UNI | NULL    |       |
| passCode  | binary(16)           | NO   |     | NULL    |       |
| createdAt | bigint(20) unsigned  | NO   | MUL | NULL    |       |
| tries     | smallint(5) unsigned | NO   |     | NULL    |       |
+-----------+----------------------+------+-----+---------+-------+
6 rows in set (0.02 sec)

mysql> desc sessionTokens;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| tokenId   | binary(32)          | NO   | PRI | NULL    |       |
| tokenData | binary(32)          | NO   |     | NULL    |       |
| uid       | binary(16)          | NO   | MUL | NULL    |       |
| createdAt | bigint(20) unsigned | NO   |     | NULL    |       |
+-----------+---------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)