describe Users; 
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| user_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user_uname    | 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)


SELECT * FROM Users; 
+---------+------------+---------------+---------------+------------+
| user_id | user_uname | user_email    | user_password | user_fname |
+---------+------------+---------------+---------------+------------+
|       1 | test       | test@test.com | testpassword  | testfname  |
+---------+------------+---------------+---------------+------------+
1 row in set (0.01 sec)


describe 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)


SELECT * FROM Products; 
+---------+---------------------+---------------+-----------------------------------------------------------------------------+------------+-------------+-----------+------------+
| prod_id | prod_name           | prod_img      | prod_description                                                            | prod_price | prod_rating | prod_sku  | prod_stock |
+---------+---------------------+---------------+-----------------------------------------------------------------------------+------------+-------------+-----------+------------+
|       1 | Screen              | screen.jpg    | 40 inch 4k UHTV enjoy movies with the ones you love with our great TV deals |     600.23 |           4 | JSKDUI0A1 |          1 |
|       2 | Microwave           | microwave.jpg | OUT of time? this microwave will make your busy life easier and enjoyable!  |      90.12 |           3 | JSKDUI0B2 |          0 |
|       3 | Mechanical Keyboard | keyboard.jpg  | Enjoy typing and reduce misspelled words! type confidently!                 |     320.14 |           5 | JSKDUI0C3 |          1 |
|       4 | Fancy Wine          | wine.jpg      | Stress out or enjoying life! now try our fancy wine makes you great!        |      49.14 |           5 | JSKDUI0D4 |          1 |
|       5 | Soft Towels         | towels.jpg    | Get our towel deal now!                                                     |      20.14 |           2 | JSKDUI0F5 |          1 |
|       6 | Charcoal            | charcoal.jpg  | BBQ with the one you love!                                                  |      10.99 |           5 | JSKDUI0E6 |          1 |
|       7 | Fatty Nuts          | nuts.jpg      | Healthy! test Great!                                                        |      13.99 |           1 | JSKDUI0G7 |          1 |
|       8 | Fruity KitKat       | kitkat.jpg    | Try our desert! free shipping!                                              |       5.14 |           3 | JSKDUI0K8 |          0 |
+---------+---------------------+---------------+-----------------------------------------------------------------------------+------------+-------------+-----------+------------+
8 rows in set (0.00 sec)