Skip to content

Latest commit

 

History

History
59 lines (52 loc) · 3.96 KB

create-user-1.md

File metadata and controls

59 lines (52 loc) · 3.96 KB

Create User 1

Add email address in app and press refresh

Now view the changes on the server :

select * from user;
+----+----------------------+--------+--------+---------------------+---------------+
| id | pass_key             | subset | warden | request_offset_secs | registered_ts |
+----+----------------------+--------+--------+---------------------+---------------+
|  1 | 831a117210a2aaa84187 |      1 |      1 |               24789 |     279991557 |
|  2 | 168a2a               |      0 |      7 |                7430 |     279991830 |
+----+----------------------+--------+--------+---------------------+---------------+
2 rows in set (0.001 sec)
MySql: User Table
select * from user_TR;
+----+----------------------+--------+--------+---------------------+---------------+----+-----------+---------+---------+--------------------+------+
| id | pass_key             | subset | warden | request_offset_secs | registered_ts | ts | operation | user_id | user_ts | comment            | crc  |
+----+----------------------+--------+--------+---------------------+---------------+----+-----------+---------+---------+--------------------+------+
|  1 | 831a117210a2aaa84187 |      1 |      1 |               24789 |     279991557 |  1 |         1 |       0 |    NULL | Insert into User   |    0 |
|  2 | 168a2a               |      0 |      7 |                7430 |     279991830 |  3 |         1 |       0 |    NULL | Inserting new user | NULL |
+----+----------------------+--------+--------+---------------------+---------------+----+-----------+---------+---------+--------------------+------+
2 rows in set (0.000 sec)
MySql: User Transaction Table
select * from user_store;
+----+--------------------+--------------+------+---------+--------------------+------------------------+----------------------+
| id | email              | last_seen_ts | name | surname | records_downloaded | changes_approved_count | changes_denied_count |
+----+--------------------+--------------+------+---------+--------------------+------------------------+----------------------+
|  1 | [email protected] |            0 | NULL | NULL    |                  0 |                      0 |                    0 |
|  2 | [email protected] |    279991830 | NULL | NULL    |                  0 |                      0 |                    0 |
+----+--------------------+--------------+------+---------+--------------------+------------------------+----------------------+
2 rows in set (0.000 sec)
MySql: User Store Table
select * from user_store_TR;
+----+--------------------+--------------+------+---------+--------------------+------------------------+----------------------+----+-----------+---------+---------+------------------------+------+
| id | email              | last_seen_ts | name | surname | records_downloaded | changes_approved_count | changes_denied_count | ts | operation | user_id | user_ts | comment                | crc  |
+----+--------------------+--------------+------+---------+--------------------+------------------------+----------------------+----+-----------+---------+---------+------------------------+------+
|  1 | [email protected] |            0 | NULL | NULL    |                  0 |                      0 |                    0 |  2 |         1 |       0 |    NULL | Insert into User Store |    0 |
|  2 | [email protected] |    279991830 | NULL | NULL    |                  0 |                      0 |                    0 |  4 |         1 |       0 |    NULL | Inserting new user     | NULL |
+----+--------------------+--------------+------+---------+--------------------+------------------------+----------------------+----+-----------+---------+---------+------------------------+------+
2 rows in set (0.001 sec)
MySql: User Store Transaction Table