USERS:

mysql> desc Users;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| user_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user_name     | varchar(255)     | YES  |     | NULL    |                |
| user_email    | varchar(255)     | YES  |     | NULL    |                |
| user_password | varchar(255)     | YES  |     | NULL    |                |
| user_fname    | varchar(255)     | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> select * from Users;
+---------+-----------+-----------------+---------------+------------+
| user_id | user_name | user_email      | user_password | user_fname |
+---------+-----------+-----------------+---------------+------------+
|       1 | test      | test@test.com   | testpassword  | testfname  |
|       2 | JohnBC    | johnbc@test.com | jbc_password  | John       |
|       3 | GeorgeFC  | george@test.com | gfc_password  | George     |
+---------+-----------+-----------------+---------------+------------+
3 rows in set (0.00 sec)

/******************************************************************************/
/******************************************************************************/

PRODUCTS:
mysql> 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)


mysql> select * from Products;
+---------+----------------+--------------------------+---------------------------------------+------------+-------------+----------+------------+
| prod_id | prod_name      | prod_img                 | prod_description                      | prod_price | prod_rating | prod_sku | prod_stock |
+---------+----------------+--------------------------+---------------------------------------+------------+-------------+----------+------------+
|       1 | Toy            | ./img/toy.png            | The Murbles Outdoor Game 4 Player Set |       4.45 |           4 | 123450   |          3 |
|       2 | Stereo         | ./img/stereo.png         | music player                          |     122.95 |           5 | 123451   |          4 |
|       3 | Wheel          | ./img/wheel.png          | Toyota Wheel and Tire combo           |     285.50 |           3 | 123452   |          0 |
|       4 | Ram            | ./img/ram.png            | laptop Ram                            |      68.95 |           2 | 123453   |          2 |
|       5 | AndroidCharger | ./img/AndroidCharger.png | Android Charger                       |      49.98 |           1 | 123454   |          7 |
|       6 | Shoes          | ./img/vans.png           | Vans Shoes                            |      49.17 |           4 | 123455   |          0 |
|       7 | Laptop         | ./img/laptop.png         | ASUS Laptop                           |    1279.37 |           4 | 123456   |         12 |
|       8 | Clock          | ./img/clock.png          | Atomic Clock                          |      16.87 |           5 | 123457   |          3 |
+---------+----------------+--------------------------+---------------------------------------+------------+-------------+----------+------------+
8 rows in set (0.00 sec)