+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| user_id       | bigint(20) 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    |                |
+---------------+---------------------+------+-----+---------+----------------+

+---------+------------+---------------+---------------+------------+
| user_id | user_uname | user_email    | user_password | user_fname |
+---------+------------+---------------+---------------+------------+
|       1 | test       | test@test.com | testpassword  | testfname  |
+---------+------------+---------------+---------------+------------+

+------------------+---------------------+------+-----+---------+----------------+
| 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    |                |
+------------------+---------------------+------+-----+---------+----------------+

+---------+-----------------+------------+---------------------------------------------------------------------------------------------------------------------------------+------------+-------------+----------+------------+
| prod_id | prod_name       | prod_img   | prod_description                                                                                                                | prod_price | prod_rating | prod_sku | prod_stock |
+---------+-----------------+------------+---------------------------------------------------------------------------------------------------------------------------------+------------+-------------+----------+------------+
|       1 | Lamp            | lamp.jpg   | It shines a light when dark comes.                                                                                              |       5.12 |           2 | 2366     |          3 |
|       2 | Train Ticket    | ticket.jpg | Someone left their ticket. It goes to Busan, so if you want to go there, then there you go.                                     |       8.50 |           3 | 6523     |          1 |
|       3 | Glass Eye       | eye.jpg    | Missing an eye? Well, we'll replace it for you with this product. Many colors to choose from. Missing both eyes? Then, buy two. |      25.01 |           5 | 110110   |         53 |
|       4 | Carrot          | carrot.jpg | I think it's a carrot...                                                                                                        |       0.66 |           3 | 35       |         20 |
|       5 | Punching Bag    | bag.jpg    | You can do a 360 roundhouse kick to it.                                                                                         |      50.12 |           4 | 11001010 |         23 |
|       6 | Dinosaur Fossil | fossil.jpg | It's just a whale bone...look into it...                                                                                        |      64.99 |           1 | 613      |          7 |
|       7 | Trash Can       | trash.jpg  | It is pretty much empty except for Goose's Drangon Ball skills.                                                                 |       4.08 |           1 | 10       |          0 |
+---------+-----------------+------------+---------------------------------------------------------------------------------------------------------------------------------+------------+-------------+----------+------------+