mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| MobileApp          |
+--------------------+

mysql> show tables;
+---------------------+
| Tables_in_MobileApp |
+---------------------+
| Accounts            |
| Devices             |
+---------------------+

mysql> describe Accounts;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int          | NO   | PRI | NULL    | auto_increment |
| email    | varchar(255) | YES  |     | NULL    |                |
| account  | varchar(255) | YES  |     | NULL    |                |
| password | varchar(255) | YES  |     | NULL    |                |
| verified | tinyint(1)   | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

mysql> describe Devices;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int          | NO   | PRI | NULL    | auto_increment |
| accountsid  | int          | YES  |     | NULL    |                |
| mac         | varchar(255) | YES  |     | NULL    |                |
| description | varchar(255) | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+