MariaDB [dalden]> DESC users;
+------------+--------------+------+-----+-------------------+----------------+
| Field      | Type         | Null | Key | Default           | Extra          |
+------------+--------------+------+-----+-------------------+----------------+
| id         | int(11)      | NO   | PRI | NULL              | auto_increment |
| username   | varchar(50)  | NO   | UNI | NULL              |                |
| password   | varchar(255) | NO   |     | NULL              |                |
| created_at | datetime     | YES  |     | CURRENT_TIMESTAMP |                |
| u_email    | varchar(255) | NO   |     | NULL              |                |
| fname      | varchar(255) | NO   |     | NULL              |                |
+------------+--------------+------+-----+-------------------+----------------+
6 rows in set (0.00 sec)

MariaDB [dalden]> SELECT * FROM users;
+----+----------+--------------+---------------------+---------------+-----------+
| id | username | password     | created_at          | u_email       | fname     |
+----+----------+--------------+---------------------+---------------+-----------+
|  1 | test     | testpassword | 2018-04-11 12:18:10 | test@test.com | testfname |
+----+----------+--------------+---------------------+---------------+-----------+
1 row in set (0.00 sec)

MariaDB [dalden]> DESC Products;
+------------------+---------------------+------+-----+---------+---------------                       -+
| Field            | Type                | Null | Key | Default | Extra                                 |
+------------------+---------------------+------+-----+---------+---------------                       -+
| prod_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment                        |
| prod_name        | varchar(127)        | YES  |     | NULL    |                                       |
| prod_img         | varchar(127)        | YES  |     | NULL    |                                       |
| prod_description | varchar(511)        | YES  |     | NULL    |                                       |
| prod_price       | decimal(10,2)       | YES  |     | NULL    |                                       |
| prod_rating      | tinyint(3) unsigned | YES  |     | NULL    |                                       |
| prod_sku         | char(32)            | YES  |     | NULL    |                                       |
| prod_stock       | int(10) unsigned    | YES  |     | NULL    |                                       |
+------------------+---------------------+------+-----+---------+---------------                       -+
8 rows in set (0.00 sec)

MariaDB [dalden]> SELECT * FROM Products;
+---------+-----------+------------+------------------------------+------------+-------------+-------------------+------------+
| prod_id | prod_name | prod_img   | prod_description             | prod_price | prod_rating | prod_sku          | prod_stock |
+---------+-----------+------------+------------------------------+------------+-------------+-------------------+------------+
|       1 | Sword     | sword.jpg  | Sword for home defense       |      99.99 |           5 | 12345abc01        |          8 |
|       3 | Hammer    | hammer.jpg | Hammer for home construction |      24.99 |           4 | 12345abc02        |         25 |
|       5 | Spear     | spear.jpg  | good for poking              |       1.50 |           2 | 123456789ffd      |         88 |
|       6 | Dagger    | dagger.jpg | small sharp blade            |       9.50 |           3 | 123456789fffgd1   |        100 |
|       7 | Stick     | stick.jpg  | small branch                 |       0.50 |           1 | 12345678d9fffgd1  |         13 |
|       8 | Mace      | mace.jpg   | heavy mace for smashing      |      44.50 |           6 | 12345678d9ffaagd1 |          0 |
+---------+-----------+------------+------------------------------+------------+-------------+-------------------+------------+
6 rows in set (0.00 sec)